Purchasing Payment Document Keys Master (RVLPD023)

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

Display Name: Purchasing Payment Document Keys Master
Physical Name: RVLPD023
Technical Name: rvlpmPmntDocKeysMSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CNTRLNUM	Control Number	String	STR20_LBAU	20
2	CNTRLTYP	Control Type	Integer	INT1	1
3	PMTDOCID	PmntDocID	String	PmntDocID	15
4	DCSTATUS	Document Status	Integer	DDL_Doc_Status	0
5	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 Keys Master'].VENDORID AS 'Purchasing Payment Document Keys Master-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM RVLPD023 AS ['Purchasing Payment Document Keys Master'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchasing Payment Document Keys Master'].VENDORID = ['PM Vendor Master File'].VENDORID
6	DOCNUMBR	Document Number	String	STR20_Document_Number	20
7	TRXSORCE	TRX Source	String	STR13	13
8	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['Purchasing Payment Document Keys Master'].CHEKBKID AS 'Purchasing Payment Document Keys Master-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM RVLPD023 AS ['Purchasing Payment Document Keys Master'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['Purchasing Payment Document Keys Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
9	BCHSOURC	Batch Source	String	STR15	15