ADMASTER

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


UPDATED BY
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.
GL110 GL121
GL122 GL20.2
GL20.4
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.
GL121 GL122
GL20.2 GL20.4
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.
GL121 GL122
GL20.2 GL20.4
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.
GL121 GL122
GL20.2 GL20.4
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.
GL121 GL122
GL20.2 GL20.4
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.
AD120 AD20.1
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.
AD120 AD20.1
ADM-INT-ACCT-UNIT
Element: Acct Unit
Alpha 15
The Interest Accounting Unit established in AD20 for an average daily balance account.
AD120 AD20.1
ADM-INT-ACCOUNT
Element: Account
Numeric 6
The Interest Account established in AD20 for an avereage daily balance account.
AD120 AD20.1
ADM-INT-SUB-ACCT
Element: Sub Acct
Numeric 4
The Interest Sub-account established in AD20 for an average daily balance account.
AD120 AD20.1
ADM-INT-RATIO
Element: Int Ratio
Alpha 10
The Interest Total Name established in AD20 for an average daily balance account.
AD120 AD20.1


ADMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADMSET1 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
AD10.1 AD120
AD190 AD20.1
AD220 AD290
AD325 AD90.1
AD98.2 AD98.3
GL110 GL122
GL121 GL20.2
GL20.4
ADMSET2 COMPANY
INT-RATIO
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
KeyChange, Subset
WhereINT-RATIO !=Spaces
Or(INT-ACCT-UNIT !=Spaces
AndINT-ACCOUNT !=Zeroes)
AD191
ADMSET3 COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
AD97.2 AD97.3


ADMASTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glmaster GLMASTER Required
ADM-COMPANY->GLM-COMPANY
ADM-ACCT-UNIT->GLM-ACCT-UNIT
ADM-ACCOUNT->GLM-ACCOUNT
ADM-SUB-ACCOUNT->GLM-SUB-ACCOUNT


File created: Thu Jun 09 02:04:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.