ADAMOUNTSX – Daily GL Amounts for ADB

System
Avg Daily Balance (AD)
Prefix
BAD
Primary key
COMPANY, EFFECT-DATE, POST-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
11
Updated by
16 programs
Referenced by
3 programs

ADAMOUNTSX is the Daily GL Amounts for ADB table in Lawson Avg Daily Balance (prefix BAD). It is indexed by COMPANY, EFFECT-DATE, POST-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (BADSET1); alternate indexes: BADSET2 and BADSET3. It is updated by AD190, AD300, AD325, GL110, GL120, GL146, GL190, GL197 and 8 more and referenced by AD90.1, GL122 and GL20.2. The table has 11 fields, 3 indexes and 0 documented relations.

About ADAMOUNTSX

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.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
BAD-COMPANY PK
COMPANY		Numeric 4The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.AD325, GL110, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3 +4 more
BAD-EFFECT-DATE PK
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.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more
BAD-POST-DATE PK
POST_DATE		Numeric 8 (yyyymmdd)The date general ledger entries for the transaction will be posted to the general ledger.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more
BAD-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.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more
BAD-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.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more
BAD-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.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more
BAD-VAR-LEVELS
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.AD325, GL120, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3 +4 more
BAD-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.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more
BAD-FISCAL-YEAR
FISCAL_YEAR		Numeric 4This is the current fiscal year.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +4 more
BAD-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the current accounting period.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +4 more
BAD-BASE-AMOUNT
BASE_AMOUNT		Signed 18.2The company base amount.AD325, GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +3 more

Indexes (3)

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

IndexKeysFlagsConditionUsed in
BADSET1COMPANY, EFFECT-DATE, POST-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryAD300, AD325, GL110, GL120, GL146, GL190, GL197, GL40.1 +7 more
BADSET2COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, EFFECT-DATE, POST-DATEAD325, AD90.1, GL110, GL120, GL122, GL20.2
BADSET3COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, FISCAL-YEAR, ACCT-PERIOD, EFFECT-DATE, POST-DATEAD190

Programs

Updated by (16)

Referenced by (3)