CFM PM Transaction WORK (CFM10000)

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

Display Name: CFM PM Transaction WORK
Physical Name: CFM10000
Technical Name: CFM_PM_Transaction_WORK

Seq 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 ['CFM PM Transaction WORK'].VENDORID AS 'CFM PM Transaction WORK-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM CFM10000 AS ['CFM PM Transaction WORK'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['CFM PM Transaction WORK'].VENDORID = ['PM Vendor Master File'].VENDORID
2	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
3	DOCDATE	Document Date	Date	DT	8
4	DOCNUMBR	Document Number	String	STR20_Document_Number	20
5	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
6	DUEDATE	Due Date	Date	DT	8
7	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
8	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['CFM PM Transaction WORK'].VCHRNMBR AS 'CFM PM Transaction WORK-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM CFM10000 AS ['CFM PM Transaction WORK'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['CFM PM Transaction WORK'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['CFM PM Transaction WORK'].DOCTYPE = ['PM Key Master File'].DOCTYPE
9	TRXSORCE	TRX Source	String	STR13	13