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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ADL-COMPANY PKCOMPANY | Numeric 4 | The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company. | AD191 |
#ADL-EFFECT-DATE PKEFFECT_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 PKACCT_UNIT | Alpha 15 | The 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 PKACCOUNT | Numeric 6 | This 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 PKSUB_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. | AD191 |
#ADL-VAR-LEVELSVAR_LEVELS | Alpha 30 | A level that represents the location of an accounting unit in an organization's level structure. | AD191, GL120 |
#ADL-FISCAL-YEARFISCAL_YEAR | Numeric 4 | This is the current fiscal year. | AD191, GL500 |
#ADL-ACCT-PERIODACCT_PERIOD | Numeric 2 | This is the current accounting period. | AD191, GL500 |
#ADL-CF-PER-AMOUNTCF_PER_AMOUNT | Signed 18.2 | The cost of funds period amount. | AD191 |
#ADL-CF-QTR-AMOUNTCF_QTR_AMOUNT | Signed 18.2 | The cost of funds quarter amount. | AD191 |
#ADL-CF-YER-AMOUNTCF_YER_AMOUNT | Signed 18.2 | The cost of funds year amount. | AD191 |
#ADL-MAINT-TIMEMAINT_TIME | Numeric 6 (hhmmss) | — | GL500 |
#ADL-MAINT-DATEMAINT_DATE | Numeric 8 (yyyymmdd) | The date last changed. | GL500 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADLSET1 |
| Primary | AD191, AD290, AD300, AD96.1, AD98.1, GL110, GL120, GL500 | |
ADLSET2 |
| AD97.1, GL120 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adavgbal | ADAVGBAL | Required |
| ||||||||||||||||
| Glamounts | GLAMOUNTS | Required |
| ||||||||||||||||
| Glmaster | GLMASTER | Required |
| ||||||||||||||||
| Glnames | GLNAMES | Required |
| ||||||||||||||||
| Glsystem | GLSYSTEM | Required |
|
Programs
Updated by (5)
- AD191 Cost of Funds
- AD300 Average Daily Balance History Delete
- GL110 Company Copy Delete
- GL120 Level Reorganization
- GL500 Fiscal Year Change