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

Display Name: Debtor Payment Document Setup
Physical Name: RVLPD005
Technical Name: rvlrmPmntDocCustSETP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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 SearchPmntDocIDPmntDocIDString1615
3CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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 SearchCheckbookFromGBInteger20
5RCVDPMNTDOCGLACCT SearchRcvdPmntDocGLAcctIdxLI_14Long Integer414
6ASSESSPMNTDOCGLACCTIDX SearchAssessPmntDocGLAcctIdxLI_14Long Integer414
7DISCPMNTDOCGLACCTIDX SearchDiscPmntDocGLAcctIdxLI_14Long Integer414
8COLLECTPMNTDOCGLACCT SearchCollectPmntDocGLAcctIdxLI_14Long Integer414
9NSFPMNTDOCGLACCT SearchNSFPmntDocGLAcctIdxLI_14Long Integer414
10SETTLEPMNTDOCGLACCT SearchSettlePmntDocGLAcctIdxLI_14Long Integer414
11PmntDocGLAcctFrom SearchPmntDocGLAcctFromGBInteger20
12MaxPmntDocAmt SearchMaxPmntDocAmtDLR19_RBSO_UTR$Currency1019
13MaxPmntDocAmtFrom SearchMaxPmntDocAmtFromGBInteger20
14ExceedPmntDocPassword SearchExceedPmntDocPasswordPasswordString1210
15STMTNAME SearchStatement NameSTR64String6664
16NOTEINDX SearchNote IndexDLR14Currency1014
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
17DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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