POE Unposted GL Transaction (CPO10113)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPO10113

Display Name: POE Unposted GL Transaction
Physical Name: CPO10113
Technical Name: CPOP_GL_TRX_WORK

Seq 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'].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 ['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'].SOURCDOC
14	REFRENCE	Reference	String	STR30	30