GTM_aaUnpostedGLDistView_Batch (GTM20018V)

azurecurve Products Grant Management (4421)FinancialGTM_aaUnpostedGLDistView_Batch (GTM20018V)

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

Product: Grant Management (4421)
Series:

Display Name: GTM_aaUnpostedGLDistView_Batch
Physical Name: GTM20018V
Technical Name: GTM_aaUnpostedGLDistView_Batch

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BACHNUMB	Batch Number	String	STR15_LBAU	15
2	BCHSOURC	Batch Source	String	STR15	15
3	aaGLWorkHdrID	aaGLWorkHdrID	Long Integer	aaLONG_INT	8
4	aaGLWorkDistID	aaGLWorkDistID	Long Integer	aaLONG_INT	8
5	aaGLWorkAssignID	aaGLWorkAssignID	Long Integer	aaLONG_INT	8
6	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
7	RCTRXSEQ	Recurring TRX Sequence	Currency	DLR19_$S2	19
8	aaTRXType	aaTRXType	Integer	DDL	0
9	GLPOSTDT	GL Posting Date	Date	DT	8
10	aaTrxDimID	aaTrxDimID	Long Integer	aaLONG_INT	8
11	aaTrxCodeID	aaTrxCodeID	Long Integer	aaLONG_INT	8
12	aaTrxDimCode	aaTrxDimCode	String	aaSTR30_LBAU	30
13	INTERID	Intercompany ID	String	STR5_IC_ID	5
	Key to the Company Master (SY01500). Click to show/hide SELECT ['GTM_aaUnpostedGLDistView_Batch'].INTERID AS 'GTM_aaUnpostedGLDistView_Batch-Intercompany ID' ,['Company Master'].INTERID AS 'Company Master-Intercompany ID' FROM GTM20018V AS ['GTM_aaUnpostedGLDistView_Batch'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['GTM_aaUnpostedGLDistView_Batch'].INTERID = ['Company Master'].INTERID
14	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['GTM_aaUnpostedGLDistView_Batch'].ACTINDX AS 'GTM_aaUnpostedGLDistView_Batch-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GTM20018V AS ['GTM_aaUnpostedGLDistView_Batch'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['GTM_aaUnpostedGLDistView_Batch'].ACTINDX = ['Account Index Master'].ACTINDX
15	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
16	DEBITAMT	Debit Amount	Currency	DLR19_$S2	19
17	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19
18	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['GTM_aaUnpostedGLDistView_Batch'].CURNCYID AS 'GTM_aaUnpostedGLDistView_Batch-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM GTM20018V AS ['GTM_aaUnpostedGLDistView_Batch'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['GTM_aaUnpostedGLDistView_Batch'].CURNCYID = ['Currency Setup'].CURNCYID
19	SQNCLINE	Sequence Line	Currency	DLR19_$S2	19

azurecurve Products Grant Management (4421)FinancialGTM_aaUnpostedGLDistView_Batch (GTM20018V)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply