ADAVGBAL – Average Daily Balance by Date

System
Avg Daily Balance (AD)
Prefix
ADV
Primary key
COMPANY, EFFECT-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
13
Updated by
5 programs
Referenced by
5 programs

ADAVGBAL is the Average Daily Balance by Date table in Lawson Avg Daily Balance (prefix ADV). It is indexed by COMPANY, EFFECT-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (ADVSET1); alternate indexes: ADVSET2. It is related 1:1 to ADCFBAL, GLAMOUNTS, GLMASTER, GLNAMES and GLSYSTEM. It is updated by AD190, AD300, GL110, GL120 and GL500 and referenced by AD191, AD290, AD96.1, AD97.1 and AD98.1. The table has 13 fields, 2 indexes and 5 documented relations.

About ADAVGBAL

the Average Daily Balance file contains the period, quarter and year balances by company and effective date for each accounting unit and account. This file is updated by AD190 if the ADCOMPANY.UPDATE-DAILY=Yes

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
ADV-COMPANY PK
COMPANY		Numeric 4The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.AD190
ADV-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)This is the effective date that the AD190 was run for. The amounts for a particular effective date represent the average daily balance for that date.AD190
ADV-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.AD190
ADV-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.AD190
ADV-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.AD190
ADV-VAR-LEVELS
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.AD190, GL120
ADV-FISCAL-YEAR
FISCAL_YEAR		Numeric 4This is the current fiscal year.AD190, GL500
ADV-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the current accounting period.AD190, GL500
ADV-AVG-PER-AMOUNT
AVG_PER_AMOUNT		Signed 18.2This is the average period amount.AD190
ADV-AVG-QTR-AMOUNT
AVG_QTR_AMOUNT		Signed 18.2The average quarter amount.AD190
ADV-AVG-YER-AMOUNT
AVG_YER_AMOUNT		Signed 18.2The average year amount.AD190
ADV-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.GL500
ADV-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—GL500

Indexes (2)

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

IndexKeysFlagsConditionUsed in
ADVSET1COMPANY, EFFECT-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryAD190, AD191, AD290, AD300, AD96.1, AD98.1, GL110, GL120 +1 more
ADVSET2COMPANY, EFFECT-DATE, ACCOUNT, SUB-ACCOUNT, ACCT-UNITAD97.1, GL120

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AdcfbalADCFBALRequiredADV-COMPANY → ADL-COMPANY, ADV-EFFECT-DATE → ADL-EFFECT-DATE, ADV-ACCT-UNIT → ADL-ACCT-UNIT, ADV-ACCOUNT → ADL-ACCOUNT, ADV-SUB-ACCOUNT → ADL-SUB-ACCOUNT
GlamountsGLAMOUNTSRequiredADV-COMPANY → GAM-COMPANY, ADV-FISCAL-YEAR → GAM-FISCAL-YEAR, ADV-ACCT-UNIT → GAM-ACCT-UNIT, ADV-ACCOUNT → GAM-ACCOUNT, ADV-SUB-ACCOUNT → GAM-SUB-ACCOUNT
GlmasterGLMASTERRequiredADV-COMPANY → GLM-COMPANY, ADV-ACCOUNT → GLM-ACCOUNT, ADV-SUB-ACCOUNT → GLM-SUB-ACCOUNT, ADV-VAR-LEVELS → GLM-VAR-LEVELS, ADV-ACCT-UNIT → GLM-ACCT-UNIT
GlnamesGLNAMESRequiredADV-COMPANY → GLN-COMPANY, ADV-ACCT-UNIT → GLN-ACCT-UNIT
GlsystemGLSYSTEMRequiredADV-COMPANY → GLS-COMPANY

Programs

Updated by (5)

Referenced by (5)