Purchasing Payment Document Master (RVLPD019)

azurecurveProductsPayment Document Management (2150)PurchasingPurchasing Payment Document Master (RVLPD019)

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

Product: Payment Document Management (2150)
Series: Purchasing

Display Name: Purchasing Payment Document Master
Physical Name: RVLPD019
Technical Name: rvlpmPmntDocMSTR

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
       ['Purchasing Payment Document Master'].CHEKBKID AS 'Purchasing Payment Document Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RVLPD019 AS ['Purchasing Payment Document Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Purchasing Payment Document Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
4PayableBeforeDueDate SearchPayableBeforeDueDatePayableBeforeDueDateBoolean20
5NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Leave a Reply

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