ADBALANCE – ADB and COF by Period

System
Avg Daily Balance (AD)
Prefix
ADE
Primary key
COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, RECORD-TYPE
Fields
13
Updated by
5 programs
Referenced by
7 programs

ADBALANCE is the ADB and COF by Period table in Lawson Avg Daily Balance (prefix ADE). It is indexed by COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, RECORD-TYPE (ADESET1); alternate indexes: ADESET2, ADESET3, ADESET4, ADESET5, ADESET6 and ADESET7. It is related 1:1 to GLAMOUNTS, GLCHART, GLMASTER, GLNAMES and GLSYSTEM. It is updated by AD190, AD191, AD300, AD320 and GL110 and referenced by AD290, AD97.1, AD97.3, AD98.1, AD98.3, GLRV.1 and RW80.1. The table has 13 fields, 7 indexes and 5 documented relations.

About ADBALANCE

The Average Daily Balance file contains the average daily balances for the period, quarter and year by Record Type B (Avg Daily Balance) or C (Cost of Funds) for the company, fiscal year, accounting unit and account. This file is updated by AD190 and AD191. This file will contain only one record for each calendar period and is used for Report Writer reporting. The ADAVGBAL file and ADCFBAL will contain records by date.

Fields (13)

Column = COBOL field name without the ADE- 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
#ADE-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
#ADE-COMPANY PK
COMPANY		Numeric 4The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.AD190, AD191
#ADE-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4This is the current fiscal year.AD190, AD191
#ADE-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, AD191
#ADE-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
#ADE-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
#ADE-VAR-LEVELS SET4 SET5 SET6
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.AD190, AD191, AD320
#ADE-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
#ADE-AVG-PER-AMOUNT
AVG_PER_AMOUNT		Signed 18.2 Occurs 13 Times ×13The average period balance.AD190, AD191
#ADE-AVG-QTR-AMOUNT
AVG_QTR_AMOUNT		Signed 18.2 Occurs 13 Times ×13The average quarter balance.AD190, AD191
#ADE-AVG-YER-AMOUNT
AVG_YER_AMOUNT		Signed 18.2 Occurs 13 Times ×13The average year balance.AD190, AD191
#ADE-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.AD190, AD191
#ADE-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AD190, AD191

Indexes (7)

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
ADESET1
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. RECORD-TYPE
PrimaryAD190, AD191, AD290, AD98.3, GL110
ADESET2
  1. RECORD-TYPE
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
AD300, AD98.1
ADESET3
  1. RECORD-TYPE
  2. FISCAL-YEAR
  3. COMPANY
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. ACCT-UNIT
AD97.1, AD97.3
ADESET4
  1. RECORD-TYPE
  2. FISCAL-YEAR
  3. COMPANY
  4. VAR-LEVELS
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. ACCT-UNIT
KeyChangeRW80.1, GLRV.1
ADESET5
  1. RECORD-TYPE
  2. FISCAL-YEAR
  3. COMPANY
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. VAR-LEVELS
  7. ACCT-UNIT
KeyChangeGLRV.1
ADESET6
  1. RECORD-TYPE
  2. FISCAL-YEAR
  3. VAR-LEVELS
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. COMPANY
  7. ACCT-UNIT
KeyChangeGLRV.1
ADESET7
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. FISCAL-YEAR
  6. RECORD-TYPE
AD320

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
GlamountsGLAMOUNTSRequired
ADE-COMPANY→GAM-COMPANY
ADE-FISCAL-YEAR→GAM-FISCAL-YEAR
ADE-ACCT-UNIT→GAM-ACCT-UNIT
ADE-ACCOUNT→GAM-ACCOUNT
ADE-SUB-ACCOUNT→GAM-SUB-ACCOUNT
GlchartGLCHARTRequired
ADE-CHART-NAME→GCH-CHART-NAME
GlmasterGLMASTERRequired
ADE-COMPANY→GLM-COMPANY
ADE-ACCOUNT→GLM-ACCOUNT
ADE-SUB-ACCOUNT→GLM-SUB-ACCOUNT
ADE-VAR-LEVELS→GLM-VAR-LEVELS
ADE-ACCT-UNIT→GLM-ACCT-UNIT
GlnamesGLNAMESRequired
ADE-COMPANY→GLN-COMPANY
ADE-ACCT-UNIT→GLN-ACCT-UNIT
GlsystemGLSYSTEMRequired
ADE-COMPANY→GLS-COMPANY

Programs

Updated by (5)

Referenced by (7)