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.

Field / column	Type	Description & values	Updated by
`ADO-RECORD-TYPE` PK RECORD_TYPE	Alpha 1	This 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 1	The variable levels depth number pertaining to this record.	AD190, AD191
`ADO-COMPANY` PK COMPANY	Numeric 4	The Average Daily Balance Company established in AD10. The company must exist in General Ledger.	AD190, AD191
`ADO-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	This is the current fiscal year.	AD190, AD191
`ADO-ACCOUNT` PK 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.	AD190, AD191
`ADO-SUB-ACCOUNT` PK SUB_ACCOUNT	Numeric 4	This 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 30	A level that represents the location of an accounting unit in an organization's level structure.	AD190, AD191, AD320
`ADO-CHART-NAME` 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.	AD190, AD191
`ADO-AVG-PER-AMOUNT` AVG_PER_AMOUNT	Signed 18.2 Occurs 13 Times ×13	The average period amount.	AD190, AD191
`ADO-AVG-QTR-AMOUNT` AVG_QTR_AMOUNT	Signed 18.2 Occurs 13 Times ×13	The average quarter amount.	AD190, AD191
`ADO-AVG-YER-AMOUNT` AVG_YER_AMOUNT	Signed 18.2 Occurs 13 Times ×13	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`ADOSET1`	`FISCAL-YEAR`, `LEVEL-DEPTH`, `RECORD-TYPE`, `COMPANY`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`	Primary	AD190, AD191, GLRV.1
`ADOSET2`	`RECORD-TYPE`, `COMPANY`, `FISCAL-YEAR`, `LEVEL-DEPTH`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`		AD300
`ADOSET3`	`FISCAL-YEAR`, `LEVEL-DEPTH`, `RECORD-TYPE`, `COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `VAR-LEVELS`		GLRV.1
`ADOSET4`	`FISCAL-YEAR`, `LEVEL-DEPTH`, `RECORD-TYPE`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`, `COMPANY`		GLRV.1
`ADOSET5`	`COMPANY`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`, `FISCAL-YEAR`, `RECORD-TYPE`, `LEVEL-DEPTH`		AD320, GL110

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Glchart	GLCHART	Required		`ADO-CHART-NAME` → `GCH-CHART-NAME`
Glsystem	GLSYSTEM	Required		`ADO-COMPANY` → `GLS-COMPANY`

One to many (3) — child tables

Relation	Table	Field map
Glconsol	GLCONSOL	`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`
Glmaster	GLMASTER	`ADO-COMPANY` → `GLM-COMPANY`, `ADO-ACCOUNT` → `GLM-ACCOUNT`, `ADO-SUB-ACCOUNT` → `GLM-SUB-ACCOUNT`, `ADO-VAR-LEVELS` → `GLM-VAR-LEVELS`, → `GLM-ACCT-UNIT`
Glnames	GLNAMES	`ADO-COMPANY` → `GLN-COMPANY`, `ADO-VAR-LEVELS` → `GLN-VAR-LEVELS`, → `GLN-ACCT-UNIT`

Programs

Updated by (5)

AD190 Transaction Posting
AD191 Cost of Funds
AD300 Average Daily Balance History Delete
AD320 Variable Level Rebuild
GL110 Company Copy Delete

Referenced by (1)

GLRV.1 General Ledger Report