Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD006
Product: Payment Document Management (2150)
Series:
Display Name: Sales Payment Document Chequebook Setup
Physical Name: RVLPD006
Technical Name: rvlrmPmntDocCheckbookSETPSeq 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
['Sales Payment Document Chequebook Setup'].CHEKBKID AS 'Sales Payment Document Chequebook Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD006 AS ['Sales Payment Document Chequebook Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Sales Payment Document Chequebook Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2 PMTDOCID PmntDocID String PmntDocID 15 3 NextPmntDocNum NextPmntDocNum String NextPmntDocNum 20 4 RCVDPMNTDOCGLACCT RcvdPmntDocGLAcctIdx Long Integer LI_14 14 5 ASSESSPMNTDOCGLACCTIDX AssessPmntDocGLAcctIdx Long Integer LI_14 14 6 DISCPMNTDOCGLACCTIDX DiscPmntDocGLAcctIdx Long Integer LI_14 14 7 COLLECTPMNTDOCGLACCT CollectPmntDocGLAcctIdx Long Integer LI_14 14 8 NSFPMNTDOCGLACCT NSFPmntDocGLAcctIdx Long Integer LI_14 14 9 SETTLEPMNTDOCGLACCT SettlePmntDocGLAcctIdx Long Integer LI_14 14 10 RcvdPmntDocCheckbook RcvdPmntDocCheckbook String STR15_Checkbook_ID 15 11 AssessPmntDocCheckbook AssessPmntDocCheckbook String STR15_Checkbook_ID 15 12 DISCPMNTDOCCHECKBOOK DiscPmntDocCheckbook String STR15_Checkbook_ID 15 13 CollectPmntDocCheckbook CollectPmntDocCheckbook String STR15_Checkbook_ID 15 14 NSFPmntDocCheckbook NSFPmntDocCheckbook String STR15_Checkbook_ID 15 15 SettlePmntDocCheckbook SettlePmntDocCheckbook String STR15_Checkbook_ID 15 16 MaxPmntDocAmt MaxPmntDocAmt Currency DLR19_RBSO_UTR$ 19 17 ExceedPmntDocPassword ExceedPmntDocPassword String Password 10 18 DuplicatePmntDocNum DuplicatePmntDocNum Boolean DuplicatePmntDocNum 0 19 OverridePmntDocNum OverridePmntDocNum Boolean OverridePmntDocNum 0 20 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Sales Payment Document Chequebook Setup'].NOTEINDX AS 'Sales Payment Document Chequebook Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD006 AS ['Sales Payment Document Chequebook Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Sales Payment Document Chequebook Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX