GLAcct
ODI Extracts
>
CIF2020
>
GLAcct
Extract to provide information from the General Ledger Master File
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| CIF2020 | Dlt | Delete Record Flag | String | 1 | 0 | 0 | ||
| CIF2020 | SrcKey | Unique Record Key | String | 21 | 0 | 0 | ||
| CIF2020 | AcctId | Account number | Integer | 5 | 9 | 0 | ||
| CIF2020 | AcctType | Account Type | String | 1 | 0 | 0 | ||
| CIF2020 | AcctTitle | Account title | String | 35 | 0 | 0 | ||
| CIF2020 | CurBal | Current balance | Integer | 7 | 13 | 2 | ||
| CIF2020 | YestBal | Yesterdays balance | Integer | 7 | 13 | 2 | ||
| CIF2020 | CurBalNetChng | Net Change Today | Integer | 7 | 13 | 2 | ||
| CIF2020 | BegYrCurBal | Begin Bal Curr Year | Integer | 7 | 13 | 2 | ||
| CIF2020 | BrCode | Branch number | Integer | 2 | 3 | 0 | ||
| CIF2020 | BrDesc | Bank/branch name | String | 30 | 0 | 0 | ||
| CIF2020 | GLProdCode | Product code | Integer | 2 | 3 | 0 | ||
| CIF2020 | GLProdDesc | Product Description | String | 40 | 0 | 0 | ||
| CIF2020 | GLCostCtr | Cost center | Integer | 3 | 4 | 0 | ||
| CIF2020 | GLTrnActFreq | Posting Frequency | String | 1 | 0 | 0 | ||
| CIF2020 | GLBalType | Normal Balance | String | 1 | 0 | 0 | ||
| CIF2020 | GLRptType | Report type | String | 1 | 0 | 0 | ||
| CIF2020 | LastActDt | Date last active | Integer | 4 | 7 | 0 | ||
| CIF2020 | LastMainDt | Date of last maintenance | Integer | 4 | 7 | 0 | ||
| CIF2020 | OrigAcctId | Original Account Id | Integer | 9 | 16 | 0 | ||
| CIF2020 | GLTotalLvl | Totaling Level | Integer | 1 | 1 | 0 |
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.
Did this page help you?
Last updated Fri Feb 21 2025