Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD008
Product: Payment Document Management (2150)
Series:
Display Name: Sales Payment Document WORK
Physical Name: RVLPD008
Technical Name: rvlrmPmntDocWORKSeq 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 WORK'].CUSTNMBR AS 'Sales Payment Document WORK-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RVLPD008 AS ['Sales Payment Document WORK']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Sales Payment Document WORK'].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 WORK'].CHEKBKID AS 'Sales Payment Document WORK-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD008 AS ['Sales Payment Document WORK']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Sales Payment Document WORK'].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 WORK'].CURNCYID AS 'Sales Payment Document WORK-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RVLPD008 AS ['Sales Payment Document WORK']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Sales Payment Document WORK'].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 WORK'].CURRNIDX AS 'Sales Payment Document WORK-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RVLPD008 AS ['Sales Payment Document WORK']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Sales Payment Document WORK'].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 WORK'].NOTEINDX AS 'Sales Payment Document WORK-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD008 AS ['Sales Payment Document WORK']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Sales Payment Document WORK'].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 UPDATED Updated Boolean Boolean 0