ADCONSOL – ADB and COF Consolidation

System
Avg Daily Balance (AD)
Prefix
ADO
Primary key
FISCAL-YEAR, LEVEL-DEPTH, RECORD-TYPE, COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT
Fields
13
Updated by
5 programs
Referenced by
1 program

ADCONSOL is the ADB and COF Consolidation table in Lawson Avg Daily Balance (prefix ADO). It is indexed by FISCAL-YEAR, LEVEL-DEPTH, RECORD-TYPE, COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT (ADOSET1); alternate indexes: ADOSET2, ADOSET3, ADOSET4 and ADOSET5. It is related 1:1 to GLCHART and GLSYSTEM and 1:M to GLCONSOL, GLMASTER and GLNAMES. It is updated by AD190, AD191, AD300, AD320 and GL110 and referenced by GLRV.1. The table has 13 fields, 5 indexes and 5 documented relations.

About ADCONSOL

This file contains consolidated account balances for the ADBALANCE file. Consolidated balances are kept for summary level accounting units. The purpose of this file is for reporting summary balances.

Fields (13)

Column = COBOL field name without the ADO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ADO-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • B Average Daily Balance
  • C Cost of Funds
AD190, AD191
#ADO-LEVEL-DEPTH PK
LEVEL_DEPTH		Numeric 1The variable levels depth number pertaining to this record.AD190, AD191
#ADO-COMPANY PK
COMPANY		Numeric 4The Average Daily Balance Company established in AD10. The company must exist in General Ledger.AD190, AD191
#ADO-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4This is the current fiscal year.AD190, AD191
#ADO-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, AD191
#ADO-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, AD191
#ADO-VAR-LEVELS PK
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.AD190, AD191, AD320
#ADO-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.AD190, AD191
#ADO-AVG-PER-AMOUNT
AVG_PER_AMOUNT		Signed 18.2 Occurs 13 Times ×13The average period amount.AD190, AD191
#ADO-AVG-QTR-AMOUNT
AVG_QTR_AMOUNT		Signed 18.2 Occurs 13 Times ×13The average quarter amount.AD190, AD191
#ADO-AVG-YER-AMOUNT
AVG_YER_AMOUNT		Signed 18.2 Occurs 13 Times ×13The average year amount.AD190, AD191
#ADO-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.AD190, AD191
#ADO-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AD190, AD191

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ADOSET1
  1. FISCAL-YEAR
  2. LEVEL-DEPTH
  3. RECORD-TYPE
  4. COMPANY
  5. VAR-LEVELS
  6. ACCOUNT
  7. SUB-ACCOUNT
PrimaryAD190, AD191, GLRV.1
ADOSET2
  1. RECORD-TYPE
  2. COMPANY
  3. FISCAL-YEAR
  4. LEVEL-DEPTH
  5. VAR-LEVELS
  6. ACCOUNT
  7. SUB-ACCOUNT
AD300
ADOSET3
  1. FISCAL-YEAR
  2. LEVEL-DEPTH
  3. RECORD-TYPE
  4. COMPANY
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. VAR-LEVELS
GLRV.1
ADOSET4
  1. FISCAL-YEAR
  2. LEVEL-DEPTH
  3. RECORD-TYPE
  4. VAR-LEVELS
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. COMPANY
GLRV.1
ADOSET5
  1. COMPANY
  2. VAR-LEVELS
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. FISCAL-YEAR
  6. RECORD-TYPE
  7. LEVEL-DEPTH
AD320, GL110

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCHARTGLSYSTEMGLCONSOLGLMASTERGLNAMESADCONSOL

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlchartGLCHARTRequired
ADO-CHART-NAME→GCH-CHART-NAME
GlsystemGLSYSTEMRequired
ADO-COMPANY→GLS-COMPANY

One to many (3) — child tables

RelationTableRulesConditionField map
GlconsolGLCONSOL
ADO-FISCAL-YEAR→GCN-FISCAL-YEAR
ADO-LEVEL-DEPTH→GCN-LEVEL-DEPTH
Zeroes→GCN-BUDGET-NBR
"A"→GCN-TRANS-TYPE
ADO-COMPANY→GCN-COMPANY
ADO-VAR-LEVELS→GCN-VAR-LEVELS
ADO-ACCOUNT→GCN-ACCOUNT
ADO-SUB-ACCOUNT→GCN-SUB-ACCOUNT
—→GCN-CURRENCY-CODE
GlmasterGLMASTER
ADO-COMPANY→GLM-COMPANY
ADO-ACCOUNT→GLM-ACCOUNT
ADO-SUB-ACCOUNT→GLM-SUB-ACCOUNT
ADO-VAR-LEVELS→GLM-VAR-LEVELS
—→GLM-ACCT-UNIT
GlnamesGLNAMES
ADO-COMPANY→GLN-COMPANY
ADO-VAR-LEVELS→GLN-VAR-LEVELS
—→GLN-ACCT-UNIT

Programs

Updated by (5)

Referenced by (1)