Sales Payment Document Checkbook Setup (RVLPD006)

azurecurveProductsPayment Document Management (2150)SalesSales Payment Document Checkbook Setup (RVLPD006)

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: rvlrmPmntDocCheckbookSETP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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
2PMTDOCID SearchPmntDocIDStringPmntDocID15
3NextPmntDocNum SearchNextPmntDocNumStringNextPmntDocNum20
4RCVDPMNTDOCGLACCT SearchRcvdPmntDocGLAcctIdxLong IntegerLI_1414
5ASSESSPMNTDOCGLACCTIDX SearchAssessPmntDocGLAcctIdxLong IntegerLI_1414
6DISCPMNTDOCGLACCTIDX SearchDiscPmntDocGLAcctIdxLong IntegerLI_1414
7COLLECTPMNTDOCGLACCT SearchCollectPmntDocGLAcctIdxLong IntegerLI_1414
8NSFPMNTDOCGLACCT SearchNSFPmntDocGLAcctIdxLong IntegerLI_1414
9SETTLEPMNTDOCGLACCT SearchSettlePmntDocGLAcctIdxLong IntegerLI_1414
10RcvdPmntDocCheckbook SearchRcvdPmntDocCheckbookStringSTR15_Checkbook_ID15
11AssessPmntDocCheckbook SearchAssessPmntDocCheckbookStringSTR15_Checkbook_ID15
12DISCPMNTDOCCHECKBOOK SearchDiscPmntDocCheckbookStringSTR15_Checkbook_ID15
13CollectPmntDocCheckbook SearchCollectPmntDocCheckbookStringSTR15_Checkbook_ID15
14NSFPmntDocCheckbook SearchNSFPmntDocCheckbookStringSTR15_Checkbook_ID15
15SettlePmntDocCheckbook SearchSettlePmntDocCheckbookStringSTR15_Checkbook_ID15
16MaxPmntDocAmt SearchMaxPmntDocAmtCurrencyDLR19_RBSO_UTR$19
17ExceedPmntDocPassword SearchExceedPmntDocPasswordStringPassword10
18DuplicatePmntDocNum SearchDuplicatePmntDocNumBooleanDuplicatePmntDocNum0
19OverridePmntDocNum SearchOverridePmntDocNumBooleanOverridePmntDocNum0
20NOTEINDX SearchNote IndexCurrencyDLR1414
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
azurecurveProductsPayment Document Management (2150)SalesSales Payment Document Checkbook Setup (RVLPD006)

Leave a Reply

Your email address will not be published. Required fields are marked *