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 TypeLength
1PMTDOCID SearchPmntDocIDPmntDocIDString15
2PmntDocDescription SearchPmntDocDescriptionSTR64String64
3CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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 SearchPayableBeforeDueDatePayableBeforeDueDateBoolean0
5NOTEINDX SearchNote IndexDLR14Currency14
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 SearchUserDefnStr1UserDefnString25
7USRSTRG2 SearchUserDefnStr2UserDefnString25
8USRSTRG3 SearchUserDefnStr3UserDefnString25
9USRSTRG4 SearchUserDefnStr4UserDefnString25
10USRSTRG5 SearchUserDefnStr5UserDefnString25
11USRSTRG6 SearchUserDefnStr6UserDefnString25
12USRDATE1 SearchUserDefnDate1UserDefnString25
13USRDATE2 SearchUserDefnDate2UserDefnString25
14USRCURR1 SearchUserDefnCurr1UserDefnString25
15USRCURR2 SearchUserDefnCurr2UserDefnString25
16USRBACT1 SearchUserDefnBankAcct1UserDefnString25
17USRBACT2 SearchUserDefnBankAcct2UserDefnString25
18ReqUserDefnStr1 SearchReqUserDefnStr1ReqUserDefnBoolean0
19ReqUserDefnStr2 SearchReqUserDefnStr2ReqUserDefnBoolean0
20ReqUserDefnStr3 SearchReqUserDefnStr3ReqUserDefnBoolean0
21ReqUserDefnStr4 SearchReqUserDefnStr4ReqUserDefnBoolean0
22ReqUserDefnStr5 SearchReqUserDefnStr5ReqUserDefnBoolean0
23ReqUserDefnStr6 SearchReqUserDefnStr6ReqUserDefnBoolean0
24ReqUserDefnDate1 SearchReqUserDefnDate1ReqUserDefnBoolean0
25ReqUserDefnDate2 SearchReqUserDefnDate2ReqUserDefnBoolean0
26ReqUserDefnCurr1 SearchReqUserDefnCurr1ReqUserDefnBoolean0
27ReqUserDefnCurr2 SearchReqUserDefnCurr2ReqUserDefnBoolean0
28ReqUserDefnBankAcct1 SearchReqUserDefnBankAcct1ReqUserDefnBoolean0
29ReqUserDefnBankAcct2 SearchReqUserDefnBankAcct2ReqUserDefnBoolean0
30DEX_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)PurchasingPurchasing Payment Document Master (RVLPD019)

Leave a Reply

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