Purchasing Payment Document Settlement Line (RVLPD029)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD029

Display Name: Purchasing Payment Document Settlement Line
Physical Name: RVLPD029
Technical Name: rvlpmPmntDocTRXLINE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	REMTYPE	RemitType	Integer	RemitType	0
2	REMITID	RemitID	String	RemitID	15
3	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 Settlement Line'].VENDORID AS 'Purchasing Payment Document Settlement Line-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM RVLPD029 AS ['Purchasing Payment Document Settlement Line'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchasing Payment Document Settlement Line'].VENDORID = ['PM Vendor Master File'].VENDORID
4	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
5	DOCNUMBR	Document Number	String	STR20_Document_Number	20