GTM_aaUnpostedGLDistView (GTM20016V)

azurecurve Products Grant Management (4421)FinancialGTM_aaUnpostedGLDistView (GTM20016V)

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

Product: Grant Management (4421)
Series:

Display Name: GTM_aaUnpostedGLDistView
Physical Name: GTM20016V
Technical Name: GTM_aaUnpostedGLDistView

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

azurecurve Products Grant Management (4421)FinancialGTM_aaUnpostedGLDistView (GTM20016V)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply