Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD003
Product: Payment Document Management (2150)
Series:
Display Name: Sales Payment Document Master
Physical Name: RVLPD003
Technical Name: rvlrmPmntDocMSTRSeq 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
['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'].CHEKBKID4 SettleBeforeDueDate SettleBeforeDueDate Boolean SettleBeforeDueDate 0 5 Discountable Discountable Boolean Discountable 0 6 Collectable Collectable Boolean Collectable 0 7 DeferredDisc DeferredDisc Boolean DeferredDisc 0 8 NOTEINDX Note Index Currency DLR14 14 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'].NOTEINDX9 USRSTRG1 UserDefnStr1 String UserDefn 25 10 USRSTRG2 UserDefnStr2 String UserDefn 25 11 USRSTRG3 UserDefnStr3 String UserDefn 25 12 USRSTRG4 UserDefnStr4 String UserDefn 25 13 USRSTRG5 UserDefnStr5 String UserDefn 25 14 USRSTRG6 UserDefnStr6 String UserDefn 25 15 USRDATE1 UserDefnDate1 String UserDefn 25 16 USRDATE2 UserDefnDate2 String UserDefn 25 17 USRCURR1 UserDefnCurr1 String UserDefn 25 18 USRCURR2 UserDefnCurr2 String UserDefn 25 19 USRBACT1 UserDefnBankAcct1 String UserDefn 25 20 USRBACT2 UserDefnBankAcct2 String UserDefn 25 21 ReqUserDefnStr1 ReqUserDefnStr1 Boolean ReqUserDefn 0 22 ReqUserDefnStr2 ReqUserDefnStr2 Boolean ReqUserDefn 0 23 ReqUserDefnStr3 ReqUserDefnStr3 Boolean ReqUserDefn 0 24 ReqUserDefnStr4 ReqUserDefnStr4 Boolean ReqUserDefn 0 25 ReqUserDefnStr5 ReqUserDefnStr5 Boolean ReqUserDefn 0 26 ReqUserDefnStr6 ReqUserDefnStr6 Boolean ReqUserDefn 0 27 ReqUserDefnDate1 ReqUserDefnDate1 Boolean ReqUserDefn 0 28 ReqUserDefnDate2 ReqUserDefnDate2 Boolean ReqUserDefn 0 29 ReqUserDefnCurr1 ReqUserDefnCurr1 Boolean ReqUserDefn 0 30 ReqUserDefnCurr2 ReqUserDefnCurr2 Boolean ReqUserDefn 0 31 ReqUserDefnBankAcct1 ReqUserDefnBankAcct1 Boolean ReqUserDefn 0 32 ReqUserDefnBankAcct2 ReqUserDefnBankAcct2 Boolean ReqUserDefn 0