Average Daily Bal Acct Master
The AD Master file contains the company, accounting unit, account, and subaccount that ADB records would be run for. When an account is flagged as ADB it is added to this file. AD190 and AD191 will reference this file for the accounts to run their calculations on.
REFERENCED BY
AD10.1 | AD190 | AD220 | AD290 | AD325 | AD90.1 |
AD98.2 | AD98.3 | AD191 | AD97.2 | AD97.3 |
AD120 | AD20.1 | GL110 | GL122 | GL121 | GL20.2 |
GL20.4 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
---|---|---|---|---|---|---|---|---|
ADM-COMPANY Element: Company | Numeric 4 The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company. |
|
||||||
ADM-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. |
|
||||||
ADM-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. |
|
||||||
ADM-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. |
|
||||||
ADM-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. |
|
||||||
ADM-PER-DAYS Element: Per Days | Numeric 2 The number of days in the period established in AD20 for each account. This is used in the calculation of the cost of funds. |
|
||||||
ADM-YEAR-DAYS Element: Year Days | Numeric 3 The number of days in the year established in AD20 for each account. This is used in the calculation of cost of funds. |
|
||||||
ADM-INT-ACCT-UNIT Element: Acct Unit | Alpha 15 The Interest Accounting Unit established in AD20 for an average daily balance account. |
|
||||||
ADM-INT-ACCOUNT Element: Account | Numeric 6 The Interest Account established in AD20 for an avereage daily balance account. |
|
||||||
ADM-INT-SUB-ACCT Element: Sub Acct | Numeric 4 The Interest Sub-account established in AD20 for an average daily balance account. |
|
||||||
ADM-INT-RATIO Element: Int Ratio | Alpha 10 The Interest Total Name established in AD20 for an average daily balance account. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ADMSET1 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||||||
ADMSET2 |
COMPANY INT-RATIO ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||||||
ADMSET3 |
COMPANY ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Glmaster | GLMASTER |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.