Sales Payment Document Remittances Ranges (RVLPD012)

azurecurveProductsPayment Document Management (2150)SalesSales Payment Document Remittances Ranges (RVLPD012)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD012

Product: Payment Document Management (2150)
Series: Sales

Display Name: Sales Payment Document Remittances Ranges
Physical Name: RVLPD012
Technical Name: rvlrmPmntDocTRXRANGE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REMTYPE SearchRemitTypeRemitTypeInteger20
2REMITID SearchRemitIDRemitIDString1615
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
4RGEAVAIL SearchRangeAvailableSTR64String6664
5RNGE SearchRangeSTR132String134132
6CARRY SearchCarryCarryInteger22
7SETTED SearchSettedSettedBoolean20
8SETTEDBY SearchSettedBySettedByInteger22
9FIELDTYPE SearchField TypeLong IntLong Integer48
10LOWCUR SearchLowCurrencyDollar19Currency1019
11HIGHCUR SearchHighCurrencyDollar19Currency1019
12LOWDATE SearchLowDateDATEDate46
13HIGHDATE SearchHighDateDATEDate46
14LOWSTR SearchLowStringSTR132String134132
15HIGHSTR SearchHighStringSTR132String134132
16VALBACT1 SearchValueUserDefnBankAcct1BankAcctString3635
17VALBACT2 SearchValueUserDefnBankAcct2BankAcctString3635
18STADTTOK SearchStartingDateTokenStartingDateTokenInteger22
19ENDDTTOK SearchEndingDateTokenEndingDateTokenInteger22
20DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsPayment Document Management (2150)SalesSales Payment Document Remittances Ranges (RVLPD012)

Leave a Reply

Your email address will not be published. Required fields are marked *