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 TypeLength
1REMTYPE SearchRemitTypeRemitTypeInteger0
2REMITID SearchRemitIDRemitIDString15
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
4RGEAVAIL SearchRangeAvailableSTR64String64
5RNGE SearchRangeSTR132String132
6CARRY SearchCarryCarryInteger2
7SETTED SearchSettedSettedBoolean0
8SETTEDBY SearchSettedBySettedByInteger2
9FIELDTYPE SearchField TypeLong IntLong Integer8
10LOWCUR SearchLowCurrencyDollar19Currency19
11HIGHCUR SearchHighCurrencyDollar19Currency19
12LOWDATE SearchLowDateDATEDate6
13HIGHDATE SearchHighDateDATEDate6
14LOWSTR SearchLowStringSTR132String132
15HIGHSTR SearchHighStringSTR132String132
16VALBACT1 SearchValueUserDefnBankAcct1BankAcctString35
17VALBACT2 SearchValueUserDefnBankAcct2BankAcctString35
18STADTTOK SearchStartingDateTokenStartingDateTokenInteger2
19ENDDTTOK SearchEndingDateTokenEndingDateTokenInteger2
20DEX_ROW_ID Searchintint10

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 *