ADCOMPANY – Average Daily Balance Company
- System
- Avg Daily Balance (AD)
- Prefix
ADC- Primary key
COMPANY- Fields
- 8
- Updated by
- 4 programs
- Referenced by
- 22 programs
ADCOMPANY is the Average Daily Balance Company table in Lawson Avg Daily Balance (prefix ADC). It is indexed by COMPANY (ADCSET1); alternate indexes: ADCSET2. It is related 1:1 to GLSYSTEM. It is updated by AD10.1, AD190, AD191 and GL110 and referenced by AD120, AD20.1, AD210, AD220, AD290, AD300, AD320, AD325 and 14 more. The table has 8 fields, 2 indexes and 1 documented relation.
About ADCOMPANY
The AD Company file stores the balancing accounting unit, account, subaccount, that are set up in Company (AD10). Transaction Posting (AD190) uses the balancing account for AD calculations and is used to indicate what companies are ADB companies.
Fields (8)
Column = COBOL field name without the ADC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ADC-COMPANY PKCOMPANY | Numeric 4 | The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company. | AD10.1, GL110 |
ADC-BAL-ACCT-UNITBAL_ACCT_UNIT | Alpha 15 | The Balancing Accounting Unit established in the Average Daily Balance Company AD10. | AD10.1 |
ADC-BAL-ACCOUNTBAL_ACCOUNT | Numeric 6 | The Balancing Account established in the Average Daily Balance company AD10. | AD10.1 |
ADC-BAL-SUB-ACCTBAL_SUB_ACCT | Numeric 4 | The Balancing Sub-Account establshed in the Average Daily Balance Company. | AD10.1 |
ADC-LAST-UPDT-PROGLAST_UPDT_PROG | Alpha 5 | The Transaction Posting (AD190) or The Cost of Funds (AD191) program that last processed for the company. | AD190, AD191 |
ADC-LAST-RUN-DATELAST_RUN_DATE | Numeric 8 (yyyymmdd) | The last run date of the Transaction Posting (AD190) or the Cost of Funds (AD191). | — |
ADC-AS-OF-EFFT-DTEAS_OF_EFFT_DTE | Numeric 8 (yyyymmdd) | The As Of Effective Date defined in AD10. Used for date default for AD190. | AD10.1 |
ADC-UPDATE-DAILYUPDATE_DAILY | Alpha 1 | The Update Daily Flag determines if the daily balance files are created. The Valid values are Yes and No. " " = Default
| AD10.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADCSET1 | COMPANY | Primary | AD10.1, AD120, AD190, AD191, AD20.1, AD210, AD220, AD290 +18 more | |
ADCSET2 | COMPANY | Subset | Where COMPANY != Zeroes | AD10.1, AD210, AD320, AD325 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Glsystem | GLSYSTEM | Required | ADC-COMPANY → GLS-COMPANY |
Programs
Updated by (4)
- AD10.1 Average Daily Balance Company
- AD190 Transaction Posting
- AD191 Cost of Funds
- GL110 Company Copy Delete
Referenced by (22)
- AD120 AD Mass Account Maintenance
- AD20.1 Average Daily Balance Account Maintenance
- AD210 Average Daily Company Listing
- AD220 Account Listing
- AD290 Average Daily Balance-Cost of Funds Report
- AD300 Average Daily Balance History Delete
- AD320 Variable Level Rebuild
- AD325 ADAMOUNTSX File Rebuild
- AD50.1 Average Daily Balance-Cost of Funds Report Setup
- AD90.1 Average Daily Balance Company Analysis
- AD95.1 Account Analysis
- AD96.1 Date
- AD97.1 Accounts
- AD97.2 Accounts
- AD97.3 Compare
- AD98.1 Accounting Units
- AD98.2 Accounting Units Actuals
- AD98.3 Accounting Units Compare
- GL121 Mass Account Addition
- GL122 Mass Account Change Delete
- GL190 Journal Posting
- GL20.2 Posting Accounts