Sales Payment Document Master (RVLPD003)

azurecurveProductsPayment Document Management (2150)SalesSales Payment Document Master (RVLPD003)

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

Product: Payment Document Management (2150)
Series: Sales

Display Name: Sales Payment Document Master
Physical Name: RVLPD003
Technical Name: rvlrmPmntDocMSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PMTDOCID SearchPmntDocIDPmntDocIDString1615
2PmntDocDescription SearchPmntDocDescriptionSTR64String6664
3CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Sales Payment Document Master'].CHEKBKID AS 'Sales Payment Document Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RVLPD003 AS ['Sales Payment Document Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Sales Payment Document Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
4SettleBeforeDueDate SearchSettleBeforeDueDateSettleBeforeDueDateBoolean20
5Discountable SearchDiscountableDiscountableBoolean20
6Collectable SearchCollectableCollectableBoolean20
7DeferredDisc SearchDeferredDiscDeferredDiscBoolean20
8NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Sales Payment Document Master'].NOTEINDX AS 'Sales Payment Document Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RVLPD003 AS ['Sales Payment Document Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Sales Payment Document Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9USRSTRG1 SearchUserDefnStr1UserDefnString2625
10USRSTRG2 SearchUserDefnStr2UserDefnString2625
11USRSTRG3 SearchUserDefnStr3UserDefnString2625
12USRSTRG4 SearchUserDefnStr4UserDefnString2625
13USRSTRG5 SearchUserDefnStr5UserDefnString2625
14USRSTRG6 SearchUserDefnStr6UserDefnString2625
15USRDATE1 SearchUserDefnDate1UserDefnString2625
16USRDATE2 SearchUserDefnDate2UserDefnString2625
17USRCURR1 SearchUserDefnCurr1UserDefnString2625
18USRCURR2 SearchUserDefnCurr2UserDefnString2625
19USRBACT1 SearchUserDefnBankAcct1UserDefnString2625
20USRBACT2 SearchUserDefnBankAcct2UserDefnString2625
21ReqUserDefnStr1 SearchReqUserDefnStr1ReqUserDefnBoolean20
22ReqUserDefnStr2 SearchReqUserDefnStr2ReqUserDefnBoolean20
23ReqUserDefnStr3 SearchReqUserDefnStr3ReqUserDefnBoolean20
24ReqUserDefnStr4 SearchReqUserDefnStr4ReqUserDefnBoolean20
25ReqUserDefnStr5 SearchReqUserDefnStr5ReqUserDefnBoolean20
26ReqUserDefnStr6 SearchReqUserDefnStr6ReqUserDefnBoolean20
27ReqUserDefnDate1 SearchReqUserDefnDate1ReqUserDefnBoolean20
28ReqUserDefnDate2 SearchReqUserDefnDate2ReqUserDefnBoolean20
29ReqUserDefnCurr1 SearchReqUserDefnCurr1ReqUserDefnBoolean20
30ReqUserDefnCurr2 SearchReqUserDefnCurr2ReqUserDefnBoolean20
31ReqUserDefnBankAcct1 SearchReqUserDefnBankAcct1ReqUserDefnBoolean20
32ReqUserDefnBankAcct2 SearchReqUserDefnBankAcct2ReqUserDefnBoolean20
33DEX_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 Master (RVLPD003)

Leave a Reply

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