Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD005
Product: Payment Document Management (2150)
Series:
Display Name: Debtor Payment Document Setup
Physical Name: RVLPD005
Technical Name: rvlrmPmntDocCustSETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Debtor Payment Document Setup'].CUSTNMBR AS 'Debtor Payment Document Setup-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RVLPD005 AS ['Debtor Payment Document Setup']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Debtor Payment Document Setup'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2 PMTDOCID PmntDocID String PmntDocID 15 3 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Debtor Payment Document Setup'].CHEKBKID AS 'Debtor Payment Document Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD005 AS ['Debtor Payment Document Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Debtor Payment Document Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
4 CheckbookFrom CheckbookFrom Integer GB 0 5 RCVDPMNTDOCGLACCT RcvdPmntDocGLAcctIdx Long Integer LI_14 14 6 ASSESSPMNTDOCGLACCTIDX AssessPmntDocGLAcctIdx Long Integer LI_14 14 7 DISCPMNTDOCGLACCTIDX DiscPmntDocGLAcctIdx Long Integer LI_14 14 8 COLLECTPMNTDOCGLACCT CollectPmntDocGLAcctIdx Long Integer LI_14 14 9 NSFPMNTDOCGLACCT NSFPmntDocGLAcctIdx Long Integer LI_14 14 10 SETTLEPMNTDOCGLACCT SettlePmntDocGLAcctIdx Long Integer LI_14 14 11 PmntDocGLAcctFrom PmntDocGLAcctFrom Integer GB 0 12 MaxPmntDocAmt MaxPmntDocAmt Currency DLR19_RBSO_UTR$ 19 13 MaxPmntDocAmtFrom MaxPmntDocAmtFrom Integer GB 0 14 ExceedPmntDocPassword ExceedPmntDocPassword String Password 10 15 STMTNAME Statement Name String STR64 64 16 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Debtor Payment Document Setup'].NOTEINDX AS 'Debtor Payment Document Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD005 AS ['Debtor Payment Document Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Debtor Payment Document Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX