GLAcct

ODI Extracts > Core Director > GLAcct

Extract to provide information from the General Ledger Master File

Provider	Element	Element Description	Reference File	Reference Field	Field Type	Length	Decimal Places
Core Director	Dlt	Delete record flag			String	1
Core Director	SrcKey	Account number	GLSUMM.ISM	GL_SUM_ACCOUNT	String	10
Core Director	AcctId	Account number	GLSUMM.ISM	GL_SUM_ACCOUNT	String	10
Core Director	AcctTitle	Description	GLSUMM.ISM	GL_SUM_DESC	String	29
Core Director	CurBal	Current balance	GLSUMM.ISM	Calculated (GL_SUM_CYR_BEG_BAL+GL_SUM_CMM_CHG)	Decimal	16	2
Core Director	YestBal	Yesterday's balance		Calculated	Decimal	16	2
Core Director	CurBalNetChng			Calculated	Decimal	16	2
Core Director	BegYrCurBal		GLSUMM.ISM	GL_SUM_CYR_BEG_BAL	Decimal	16	2
Core Director	BegLastYrBal		GLSUMM.ISM	GL_SUM_PYR_BEG_BAL	Decimal	16	2
Core Director	AvgYTDBal		GLSUMM.ISM	Calculated	Decimal	16	2
Core Director	BrCode	Branch code	GLSUMM.ISM	Calculated based on bank parameters	String	2
Core Director	BrDesc	Branch description	USRCOD.ISM	USER_DESCRIPTION	String	40
Core Director	GLProdCode	Prod code	GLSUMM.ISM	GL_SUM_ACCT_TYPE	String	1
Core Director	GLProdDesc	Prod description		Calculated based on GL_SUM_ACCT_TYPE	String	15
Core Director	GLBalType		GLSUMM.ISM	Calculated based on GL_SUM_BAL_CR_DB	String	4

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Fri Feb 21 2025