Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD019
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document Master
Physical Name: RVLPD019
Technical Name: rvlpmPmntDocMSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PMTDOCID 
PmntDocID String PmntDocID 15 2 PmntDocDescription PmntDocDescription String STR64 64 3 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 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'].CHEKBKID4 PayableBeforeDueDate PayableBeforeDueDate Boolean PayableBeforeDueDate 0 5 NOTEINDX Note Index Currency DLR14 14 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'].NOTEINDX6 USRSTRG1 UserDefnStr1 String UserDefn 25 7 USRSTRG2 UserDefnStr2 String UserDefn 25 8 USRSTRG3 UserDefnStr3 String UserDefn 25 9 USRSTRG4 UserDefnStr4 String UserDefn 25 10 USRSTRG5 UserDefnStr5 String UserDefn 25 11 USRSTRG6 UserDefnStr6 String UserDefn 25 12 USRDATE1 UserDefnDate1 String UserDefn 25 13 USRDATE2 UserDefnDate2 String UserDefn 25 14 USRCURR1 UserDefnCurr1 String UserDefn 25 15 USRCURR2 UserDefnCurr2 String UserDefn 25 16 USRBACT1 UserDefnBankAcct1 String UserDefn 25 17 USRBACT2 UserDefnBankAcct2 String UserDefn 25 18 ReqUserDefnStr1 ReqUserDefnStr1 Boolean ReqUserDefn 0 19 ReqUserDefnStr2 ReqUserDefnStr2 Boolean ReqUserDefn 0 20 ReqUserDefnStr3 ReqUserDefnStr3 Boolean ReqUserDefn 0 21 ReqUserDefnStr4 ReqUserDefnStr4 Boolean ReqUserDefn 0 22 ReqUserDefnStr5 ReqUserDefnStr5 Boolean ReqUserDefn 0 23 ReqUserDefnStr6 ReqUserDefnStr6 Boolean ReqUserDefn 0 24 ReqUserDefnDate1 ReqUserDefnDate1 Boolean ReqUserDefn 0 25 ReqUserDefnDate2 ReqUserDefnDate2 Boolean ReqUserDefn 0 26 ReqUserDefnCurr1 ReqUserDefnCurr1 Boolean ReqUserDefn 0 27 ReqUserDefnCurr2 ReqUserDefnCurr2 Boolean ReqUserDefn 0 28 ReqUserDefnBankAcct1 ReqUserDefnBankAcct1 Boolean ReqUserDefn 0 29 ReqUserDefnBankAcct2 ReqUserDefnBankAcct2 Boolean ReqUserDefn 0