Customer Payment Document Setup (RVLPD005)

azurecurveProductsPayment Document Management (2150)SalesCustomer Payment Document Setup (RVLPD005)

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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
2PMTDOCID SearchPmntDocIDStringPmntDocID15
3CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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
4CheckbookFrom SearchCheckbookFromIntegerGB0
5RCVDPMNTDOCGLACCT SearchRcvdPmntDocGLAcctIdxLong IntegerLI_1414
6ASSESSPMNTDOCGLACCTIDX SearchAssessPmntDocGLAcctIdxLong IntegerLI_1414
7DISCPMNTDOCGLACCTIDX SearchDiscPmntDocGLAcctIdxLong IntegerLI_1414
8COLLECTPMNTDOCGLACCT SearchCollectPmntDocGLAcctIdxLong IntegerLI_1414
9NSFPMNTDOCGLACCT SearchNSFPmntDocGLAcctIdxLong IntegerLI_1414
10SETTLEPMNTDOCGLACCT SearchSettlePmntDocGLAcctIdxLong IntegerLI_1414
11PmntDocGLAcctFrom SearchPmntDocGLAcctFromIntegerGB0
12MaxPmntDocAmt SearchMaxPmntDocAmtCurrencyDLR19_RBSO_UTR$19
13MaxPmntDocAmtFrom SearchMaxPmntDocAmtFromIntegerGB0
14ExceedPmntDocPassword SearchExceedPmntDocPasswordStringPassword10
15STMTNAME SearchStatement NameStringSTR6464
16NOTEINDX SearchNote IndexCurrencyDLR1414
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
azurecurveProductsPayment Document Management (2150)SalesCustomer Payment Document Setup (RVLPD005)

Leave a Reply

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