Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD026
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document HISTORY
Physical Name: RVLPD026
Technical Name: rvlpmPmntDocHISTSeq 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 HISTORY'].VENDORID AS 'Purchasing Payment Document HISTORY-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
RVLPD026 AS ['Purchasing Payment Document HISTORY']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Purchasing Payment Document HISTORY'].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 HISTORY'].CHEKBKID AS 'Purchasing Payment Document HISTORY-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RVLPD026 AS ['Purchasing Payment Document HISTORY']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Purchasing Payment Document HISTORY'].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 HISTORY'].CURNCYID AS 'Purchasing Payment Document HISTORY-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RVLPD026 AS ['Purchasing Payment Document HISTORY']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Payment Document HISTORY'].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 HISTORY'].CURRNIDX AS 'Purchasing Payment Document HISTORY-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RVLPD026 AS ['Purchasing Payment Document HISTORY']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Payment Document HISTORY'].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 HISTORY'].NOTEINDX AS 'Purchasing Payment Document HISTORY-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD026 AS ['Purchasing Payment Document HISTORY']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing Payment Document HISTORY'].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