Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPO10113
Product: Purchase Order Enhancements (2277)
Series:
Display Name: POE Unposted GL Transaction
Physical Name: CPO10113
Technical Name: CPOP_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
['POE Unposted GL Transaction'].ACTINDX AS 'POE Unposted GL Transaction-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CPO10113 AS ['POE Unposted GL Transaction']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['POE Unposted GL Transaction'].ACTINDX = ['Account Index Master'].ACTINDX6 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
['POE Unposted GL Transaction'].SOURCDOC AS 'POE Unposted GL Transaction-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
CPO10113 AS ['POE Unposted GL Transaction']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['POE Unposted GL Transaction'].SOURCDOC = ['Source Document Master'].SOURCDOC14 REFRENCE Reference String STR30 30