Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IEGLTRXI
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: ieTrxGLImport
Physical Name: IEGLTRXI
Technical Name: ieTrxGLImportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMRECNUM 
Record Number Currency DLR_Document_Number 19 2 SEQUENCE1 Sequence Currency DLR19_$S2 19 3 JRNENTRY Journal Entry Long Integer LI8_U0 8 4 TRXDATE TRX Date Date DT_Date 6 5 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['ieTrxGLImport'].SOURCDOC AS 'ieTrxGLImport-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
IEGLTRXI AS ['ieTrxGLImport']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['ieTrxGLImport'].SOURCDOC = ['Source Document Master'].SOURCDOC6 REFRENCE Reference String STR30 30 7 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 8 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 9 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 10 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 11 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 12 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 13 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 14 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 15 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 16 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 17 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ieTrxGLImport'].ACTINDX AS 'ieTrxGLImport-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IEGLTRXI AS ['ieTrxGLImport']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ieTrxGLImport'].ACTINDX = ['Account Index Master'].ACTINDX18 ACTDESCR Account Description String STR50 50 19 ACCATNUM Account Category Number Integer INT2_U0 2 Key to the Account Category Master (GL00102).
Click to show/hide
SELECT
['ieTrxGLImport'].ACCATNUM AS 'ieTrxGLImport-Account Category Number'
,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
IEGLTRXI AS ['ieTrxGLImport']
INNER JOIN
GL00102 AS ['Account Category Master']
ON
['ieTrxGLImport'].ACCATNUM = ['Account Category Master'].ACCATNUM20 ACCTTYPE Account Type Integer DDL_Account_Type 0 21 DEBITAMT Debit Amount Currency DLR19_$S2 19 22 CRDTAMNT Credit Amount Currency DLR19_$S2 19 23 DSCRIPTN Description String STR30 30