Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL50507
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: GLCM_PMatch_TRX_WORK
Physical Name: GL50507
Technical Name: GLCM_PMatch_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
['GLCM_PMatch_TRX_WORK'].ORCTRNUM AS 'GLCM_PMatch_TRX_WORK-Originating Control Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
GL50507 AS ['GLCM_PMatch_TRX_WORK']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['GLCM_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
['GLCM_PMatch_TRX_WORK'].ACTINDX AS 'GLCM_PMatch_TRX_WORK-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
GL50507 AS ['GLCM_PMatch_TRX_WORK']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['GLCM_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