GLAcct
Operational Data Integration (ODI)
>
ODI Extracts
>
Core Director
>
GLAcct
Extract to provide information from the General Ledger Master File
Core Director
Dlt
Delete record flag
String
1
SrcKey
Account number
GLSUMM.ISM
GL_SUM_ACCOUNT
10
AcctId
AcctTitle
Description
GL_SUM_DESC
29
CurBal
Current balance
Calculated (GL_SUM_CYR_BEG_BAL+GL_SUM_CMM_CHG)
Decimal
16
2
YestBal
Yesterday's balance
Calculated
CurBalNetChng
BegYrCurBal
GL_SUM_CYR_BEG_BAL
BegLastYrBal
GL_SUM_PYR_BEG_BAL
AvgYTDBal
BrCode
Branch code
Calculated based on bank parameters
BrDesc
Branch description
USRCOD.ISM
USER_DESCRIPTION
40
GLProdCode
Prod code
GL_SUM_ACCT_TYPE
GLProdDesc
Prod description
Calculated based on GL_SUM_ACCT_TYPE
15
GLBalType
Calculated based on GL_SUM_BAL_CR_DB
4
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024