GLPM_PMatch_TRX_WORK (GL50503)

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

Display Name: GLPM_PMatch_TRX_WORK
Physical Name: GL50503
Technical Name: GLPM_PMatch_TRX_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	TRXDATE	TRX Date	Date	DT_Date	6
2	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
3	ORTRXSRC	Originating TRX Source	String	STR13	13
4	ORCTRNUM	Originating Control Number	String	STR20	20
	For transactions originating in the Purchasing series, this is the key to the PM Key Master File (PM00400). Click to show/hide SELECT ['GLPM_PMatch_TRX_WORK'].ORCTRNUM AS 'GLPM_PMatch_TRX_WORK-Originating Control Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM GL50503 AS ['GLPM_PMatch_TRX_WORK'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['GLPM_PMatch_TRX_WORK'].ORCTRNUM = ['PM Key Master File'].CNTRLNUM
5	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['GLPM_PMatch_TRX_WORK'].ACTINDX AS 'GLPM_PMatch_TRX_WORK-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GL50503 AS ['GLPM_PMatch_TRX_WORK'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['GLPM_PMatch_TRX_WORK'].ACTINDX = ['Account Index Master'].ACTINDX
6	DEBITAMT	Debit Amount	Currency	DLR19_$S2	19
7	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19
8	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19