Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL50502
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: GLIV_UMatch_TRX_WORK
Physical Name: GL50502
Technical Name: GLIV_UMatch_TRX_WORKSeq 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
['GLIV_UMatch_TRX_WORK'].ORCTRNUM AS 'GLIV_UMatch_TRX_WORK-Originating Control Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
GL50502 AS ['GLIV_UMatch_TRX_WORK']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['GLIV_UMatch_TRX_WORK'].ORCTRNUM = ['PM Key Master File'].CNTRLNUM5 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['GLIV_UMatch_TRX_WORK'].ACTINDX AS 'GLIV_UMatch_TRX_WORK-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
GL50502 AS ['GLIV_UMatch_TRX_WORK']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['GLIV_UMatch_TRX_WORK'].ACTINDX = ['Account Index Master'].ACTINDX6 DEBITAMT Debit Amount Currency DLR19_$S2 19 7 CRDTAMNT Credit Amount Currency DLR19_$S2 19