Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD022
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document Chequebook Setup
Physical Name: RVLPD022
Technical Name: rvlpmPmntDocCheckbookSETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CHEKBKID 
Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Purchasing Payment Document Chequebook Setup'].CHEKBKID AS 'Purchasing Payment Document Chequebook Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD022 AS ['Purchasing Payment Document Chequebook Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Purchasing Payment Document Chequebook Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 PMTDOCID PmntDocID String PmntDocID 15 3 NextPmntDocNum NextPmntDocNum String NextPmntDocNum 20 4 GivePmntDocGLAcctIdx GivePmntDocGLAcctIdx Long Integer LI_14 14 5 PayPmntDocGLAcctIdx PayPmntDocGLAcctIdx Long Integer LI_14 14 6 GivePmntDocCheckbook GivePmntDocCheckbook String STR15_Checkbook_ID 15 7 PayPmntDocCheckbook PayPmntDocCheckbook String STR15_Checkbook_ID 15 8 MaxPmntDocAmt MaxPmntDocAmt Currency DLR19_RBSO_UTR$ 19 9 ExceedPmntDocPassword ExceedPmntDocPassword String Password 10 10 DuplicatePmntDocNum DuplicatePmntDocNum Boolean DuplicatePmntDocNum 0 11 OverridePmntDocNum OverridePmntDocNum Boolean OverridePmntDocNum 0 12 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Purchasing Payment Document Chequebook Setup'].NOTEINDX AS 'Purchasing Payment Document Chequebook Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD022 AS ['Purchasing Payment Document Chequebook Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing Payment Document Chequebook Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX