ADCFBAL – Cost of Funds by Date

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

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

About ADCFBAL

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

Fields (13)

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

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

Indexes (2)

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

IndexKeysFlagsConditionUsed in
ADLSET1COMPANY, EFFECT-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryAD191, AD290, AD300, AD96.1, AD98.1, GL110, GL120, GL500
ADLSET2COMPANY, EFFECT-DATE, ACCOUNT, SUB-ACCOUNT, ACCT-UNITAD97.1, GL120

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AdavgbalADAVGBALRequiredADL-COMPANY → ADV-COMPANY, ADL-EFFECT-DATE → ADV-EFFECT-DATE, ADL-ACCT-UNIT → ADV-ACCT-UNIT, ADL-ACCOUNT → ADV-ACCOUNT, ADL-SUB-ACCOUNT → ADV-SUB-ACCOUNT
GlamountsGLAMOUNTSRequiredADL-COMPANY → GAM-COMPANY, ADL-FISCAL-YEAR → GAM-FISCAL-YEAR, ADL-ACCT-UNIT → GAM-ACCT-UNIT, ADL-ACCOUNT → GAM-ACCOUNT, ADL-SUB-ACCOUNT → GAM-SUB-ACCOUNT
GlmasterGLMASTERRequiredADL-COMPANY → GLM-COMPANY, ADL-ACCOUNT → GLM-ACCOUNT, ADL-SUB-ACCOUNT → GLM-SUB-ACCOUNT, ADL-VAR-LEVELS → GLM-VAR-LEVELS, ADL-ACCT-UNIT → GLM-ACCT-UNIT
GlnamesGLNAMESRequiredADL-COMPANY → GLN-COMPANY, ADL-ACCT-UNIT → GLN-ACCT-UNIT
GlsystemGLSYSTEMRequiredADL-COMPANY → GLS-COMPANY

Programs

Updated by (5)

Referenced by (4)