ADMASTER – Average Daily Bal Acct Master

System
Avg Daily Balance (AD)
Prefix
ADM
Primary key
COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
11
Updated by
7 programs
Referenced by
11 programs

ADMASTER is the Average Daily Bal Acct Master table in Lawson Avg Daily Balance (prefix ADM). It is indexed by COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (ADMSET1); alternate indexes: ADMSET2 and ADMSET3. It is related 1:1 to GLMASTER. It is updated by AD120, AD20.1, GL110, GL121, GL122, GL20.2 and GL20.4 and referenced by AD10.1, AD190, AD191, AD220, AD290, AD325, AD90.1, AD97.2 and 3 more. The table has 11 fields, 3 indexes and 1 documented relation.

About ADMASTER

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.

Fields (11)

Column = COBOL field name without the ADM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ADM-COMPANY PK
COMPANY		Numeric 4The 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 PK
ACCT_UNIT		Alpha 15The 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 PK
ACCOUNT		Numeric 6This 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 PK
SUB_ACCOUNT		Numeric 4This 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
CHART_NAME		Alpha 12This 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
PER_DAYS		Numeric 2The 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
YEAR_DAYS		Numeric 3The 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
INT_ACCT_UNIT		Alpha 15The Interest Accounting Unit established in AD20 for an average daily balance account.AD120, AD20.1
ADM-INT-ACCOUNT
INT_ACCOUNT		Numeric 6The Interest Account established in AD20 for an avereage daily balance account.AD120, AD20.1
ADM-INT-SUB-ACCT
INT_SUB_ACCT		Numeric 4The Interest Sub-account established in AD20 for an average daily balance account.AD120, AD20.1
ADM-INT-RATIO
INT_RATIO		Alpha 10The Interest Total Name established in AD20 for an average daily balance account.AD120, AD20.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ADMSET1COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryAD10.1, AD120, AD190, AD20.1, AD220, AD290, AD325, AD90.1 +7 more
ADMSET2COMPANY, INT-RATIO, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTKeyChange, SubsetWhere INT-RATIO != Spaces Or (INT-ACCT-UNIT != Spaces And INT-ACCOUNT != Zeroes)AD191
ADMSET3COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNITAD97.2, AD97.3

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlmasterGLMASTERRequiredADM-COMPANY → GLM-COMPANY, ADM-ACCT-UNIT → GLM-ACCT-UNIT, ADM-ACCOUNT → GLM-ACCOUNT, ADM-SUB-ACCOUNT → GLM-SUB-ACCOUNT

Programs

Updated by (7)

Referenced by (11)