Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD009
Product: Payment Document Management (2150)
Series:
Display Name: Sales Payment Document OPEN
Physical Name: RVLPD009
Technical Name: rvlrmPmntDocOPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RMDTYPAL RM Document Type-All Integer INT2 2 Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments
2 DOCNUMBR Document Number String STR20_Document_Number 20 3 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Sales Payment Document OPEN'].CUSTNMBR AS 'Sales Payment Document OPEN-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RVLPD009 AS ['Sales Payment Document OPEN']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Sales Payment Document OPEN'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4 CUSTNAME Customer Name String STR64_Customer_Name 64 5 STMTNAME Statement Name String STR64 64 6 PMTDOCID PmntDocID String PmntDocID 15 7 CHEKNMBR Check Number String STR20_Document_Number 20 8 PDOCSTRM PmntDocStateRM Integer PmntDocStateRM 2 9 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Sales Payment Document OPEN'].CHEKBKID AS 'Sales Payment Document OPEN-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD009 AS ['Sales Payment Document OPEN']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Sales Payment Document OPEN'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
10 DOCDATE Document Date Date DT 8 11 DUEDATE Due Date Date DT 8 12 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 13 ORDOCAMT Originating Document Amount Currency DLR17_RBS0_STR$ 17 14 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Sales Payment Document OPEN'].CURNCYID AS 'Sales Payment Document OPEN-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RVLPD009 AS ['Sales Payment Document OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Sales Payment Document OPEN'].CURNCYID = ['Currency Setup'].CURNCYID
15 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Sales Payment Document OPEN'].CURRNIDX AS 'Sales Payment Document OPEN-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RVLPD009 AS ['Sales Payment Document OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Sales Payment Document OPEN'].CURRNIDX = ['Currency Setup'].CURRNIDX
16 TRXDSCRN Transaction Description String STR30 30 17 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Sales Payment Document OPEN'].NOTEINDX AS 'Sales Payment Document OPEN-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD009 AS ['Sales Payment Document OPEN']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Sales Payment Document OPEN'].NOTEINDX = ['Record Notes Master'].NOTEINDX
18 VALSTRG1 ValueUserDefnStr1 String STR64 64 19 VALSTRG2 ValueUserDefnStr2 String STR64 64 20 VALSTRG3 ValueUserDefnStr3 String STR64 64 21 VALSTRG4 ValueUserDefnStr4 String STR64 64 22 VALSTRG5 ValueUserDefnStr5 String STR64 64 23 VALSTRG6 ValueUserDefnStr6 String STR64 64 24 VALDATE1 ValueUserDefnDate1 Date DT 8 25 VALDATE2 ValueUserDefnDate2 Date DT 8 26 VALCURR1 ValueUserDefnCurr1 Currency DLR19_RBSO_UTR$ 19 27 VALCURR2 ValueUserDefnCurr2 Currency DLR19_RBSO_UTR$ 19 28 VALBACT1 ValueUserDefnBankAcct1 String BankAcct 35 29 VALBACT2 ValueUserDefnBankAcct2 String BankAcct 35 30 TRXSORCE TRX Source String STR13 13 31 MKDBYUSR Marked By User String STR15 15 32 MKTOPROC Marked To Process Boolean CB 0 33 REMTYPE RemitType Integer RemitType 0 34 REMITID RemitID String RemitID 15 35 CMRecordNumber CMRecordNumber Currency DLR_Document_Number 19