Daily GL Amounts for ADB
The Average Daily Amount file contains the the base amount balance for the ADB Company by Effective date for the accounting unit and account. This file is updated during the General Ledger Posting process.
REFERENCED BY
AD90.1 | GL122 | GL20.2 |
AD300 | AD325 | GL110 | GL120 | GL146 | GL190 |
GL197 | GL40.1 | GL40.2 | GL40.3 | GL40.7 | GL40.8 |
GL44.1 | GL45.1 | GL500 | AD190 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BAD-COMPANY Element: Company | Numeric 4 The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company. |
|
||||||||||||
BAD-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) The Effective Date is the effective date of the GL transaction. This file stores GL transations summarized by their effective date for the ADB Company, accounting unit and account. |
|
||||||||||||
BAD-POST-DATE Element: Post Date | Numeric 8 (yyyymmdd) The date general ledger entries for the transaction will be posted to the general ledger. |
|
||||||||||||
BAD-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||||||||||||
BAD-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||||||||
BAD-SUB-ACCOUNT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||
BAD-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||
BAD-CHART-NAME Element: Chart Name | Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system. |
|
||||||||||||
BAD-FISCAL-YEAR Element: Year | Numeric 4 This is the current fiscal year. |
|
||||||||||||
BAD-ACCT-PERIOD Element: Acct Period | Numeric 2 This is the current accounting period. |
|
||||||||||||
BAD-BASE-AMOUNT Element: Intl Amt | Signed 18.2 The company base amount. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BADSET1 |
COMPANY EFFECT-DATE POST-DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||
BADSET2 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT EFFECT-DATE POST-DATE |
|
| ||||||||||||||||||||||
BADSET3 |
COMPANY ACCOUNT SUB-ACCOUNT ACCT-UNIT FISCAL-YEAR ACCT-PERIOD EFFECT-DATE POST-DATE |
|
|
All trademarks and registered trademarks are the property of their
respective owners.