Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD021
Product: Payment Document Management (2150)
Series:
Display Name: Creditor Payment Document Setup
Physical Name: RVLPD021
Technical Name: rvlpmPmntDocVendSETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Creditor Payment Document Setup'].VENDORID AS 'Creditor Payment Document Setup-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
RVLPD021 AS ['Creditor Payment Document Setup']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Creditor Payment Document Setup'].VENDORID = ['PM Vendor Master File'].VENDORID
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
['Creditor Payment Document Setup'].CHEKBKID AS 'Creditor Payment Document Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD021 AS ['Creditor Payment Document Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Creditor Payment Document Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
4 CheckbookFrom CheckbookFrom Integer GB 0 5 GivePmntDocGLAcctIdx GivePmntDocGLAcctIdx Long Integer LI_14 14 6 PayPmntDocGLAcctIdx PayPmntDocGLAcctIdx Long Integer LI_14 14 7 PmntDocGLAcctFrom PmntDocGLAcctFrom Integer GB 0 8 MaxPmntDocAmt MaxPmntDocAmt Currency DLR19_RBSO_UTR$ 19 9 MaxPmntDocAmtFrom MaxPmntDocAmtFrom Integer GB 0 10 ExceedPmntDocPassword ExceedPmntDocPassword String Password 10 11 STMTNAME Statement Name String STR64 64 12 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Creditor Payment Document Setup'].NOTEINDX AS 'Creditor Payment Document Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD021 AS ['Creditor Payment Document Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Creditor Payment Document Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX