Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10113
Product: Encumbrance Management (3258)
Series:
Display Name: ENC Unposted GL Transaction
Physical Name: ENC10113
Technical Name: ENC_GL_TRX_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 JRNENTRY Journal Entry Long Integer LI8_U0 8 2 SQNCLINE Sequence Line Currency DLR19_$S2 19 3 DTAControlNum DTA Control Number String STR20 20 4 DTATRXType DTA TRX Type Integer INT 0 5 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ENC Unposted GL Transaction'].ACTINDX AS 'ENC Unposted GL Transaction-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENC10113 AS ['ENC Unposted GL Transaction']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ENC Unposted GL Transaction'].ACTINDX = ['Account Index Master'].ACTINDX
6 DEBITAMT Debit Amount Currency DLR19_$S2 19 7 CRDTAMNT Credit Amount Currency DLR19_$S2 19 8 TRXDATE TRX Date Date DT_Date 6 9 YEAR1 Year Integer Year 4 10 PERIODID Period ID Integer INT3 3 11 BACHNUMB Batch Number String STR15_LBAU 15 12 BCHSOURC Batch Source String STR15 15 13 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['ENC Unposted GL Transaction'].SOURCDOC AS 'ENC Unposted GL Transaction-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
ENC10113 AS ['ENC Unposted GL Transaction']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['ENC Unposted GL Transaction'].SOURCDOC = ['Source Document Master'].SOURCDOC
14 REFRENCE Reference String STR30 30