Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD026
Product: Payment Document Management (2150)
Series: Purchasing
Display Name: Purchasing Payment Document HISTORY 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.
Physical Name: RVLPD026
Technical Name: rvlpmPmntDocHISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 16 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'].VENDORID2 VENDNAME Vendor Name STR64_Vendor_Name String 66 64 3 DOCNUMBR Document Number STR20_Document_Number String 22 20 4 VNDCHKNM Vendor Check Name STR64_Vendor_Name String 66 64 5 DOCTYPE Document Type DDL_Document_Type Integer 2 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo6 PMTDOCID PmntDocID PmntDocID String 16 15 7 CHEKNMBR Check Number STR20_Document_Number String 22 20 8 PDOCSTPM PmntDocStatePM PmntDocStateRM Integer 2 2 9 CHEKBKID Checkbook ID STR15_Checkbook_ID String 16 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'].CHEKBKID10 DOCDATE Document Date DT Date 4 8 11 DUEDATE Due Date DT Date 4 8 12 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 10 19 13 ORDOCAMT Originating Document Amount DLR17_RBS0_STR$ Currency 10 17 14 CURNCYID Currency ID STR15_Currency_ID String 16 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'].CURNCYID15 CURRNIDX Currency Index INT3 Integer 2 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'].CURRNIDX16 TRXDSCRN Transaction Description STR30 String 32 30 17 NOTEINDX Note Index DLR14 Currency 10 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'].NOTEINDX18 VALSTRG1 ValueUserDefnStr1 STR64 String 66 64 19 VALSTRG2 ValueUserDefnStr2 STR64 String 66 64 20 VALSTRG3 ValueUserDefnStr3 STR64 String 66 64 21 VALSTRG4 ValueUserDefnStr4 STR64 String 66 64 22 VALSTRG5 ValueUserDefnStr5 STR64 String 66 64 23 VALSTRG6 ValueUserDefnStr6 STR64 String 66 64 24 VALDATE1 ValueUserDefnDate1 DT Date 4 8 25 VALDATE2 ValueUserDefnDate2 DT Date 4 8 26 VALCURR1 ValueUserDefnCurr1 DLR19_RBSO_UTR$ Currency 10 19 27 VALCURR2 ValueUserDefnCurr2 DLR19_RBSO_UTR$ Currency 10 19 28 VALBACT1 ValueUserDefnBankAcct1 BankAcct String 36 35 29 VALBACT2 ValueUserDefnBankAcct2 BankAcct String 36 35 30 TRXSORCE TRX Source STR13 String 14 13 31 MKDBYUSR Marked By User STR15 String 16 15 32 MKTOPROC Marked To Process CB Boolean 2 0 33 REMTYPE RemitType RemitType Integer 2 0 34 REMITID RemitID RemitID String 16 15 35 DEX_ROW_ID int int 10 10