Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD025
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document OPEN
Physical Name: RVLPD025
Technical Name: rvlpmPmntDocOPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Purchasing Payment Document OPEN'].VENDORID AS 'Purchasing Payment Document OPEN-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
RVLPD025 AS ['Purchasing Payment Document OPEN']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Purchasing Payment Document OPEN'].VENDORID = ['PM Vendor Master File'].VENDORID
2 VENDNAME Vendor Name String STR64_Vendor_Name 64 3 DOCNUMBR Document Number String STR20_Document_Number 20 4 VNDCHKNM Vendor Check Name String STR64_Vendor_Name 64 5 DOCTYPE Document Type Integer DDL_Document_Type 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo
6 PMTDOCID PmntDocID String PmntDocID 15 7 CHEKNMBR Check Number String STR20_Document_Number 20 8 PDOCSTPM PmntDocStatePM Integer PmntDocStateRM 2 9 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Purchasing Payment Document OPEN'].CHEKBKID AS 'Purchasing Payment Document OPEN-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD025 AS ['Purchasing Payment Document OPEN']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Purchasing 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
['Purchasing Payment Document OPEN'].CURNCYID AS 'Purchasing Payment Document OPEN-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RVLPD025 AS ['Purchasing Payment Document OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing 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
['Purchasing Payment Document OPEN'].CURRNIDX AS 'Purchasing Payment Document OPEN-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RVLPD025 AS ['Purchasing Payment Document OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing 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
['Purchasing Payment Document OPEN'].NOTEINDX AS 'Purchasing Payment Document OPEN-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD025 AS ['Purchasing Payment Document OPEN']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing 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