|
|
ADCOMPANY FILE
Average Daily Balance Company
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.
REFERENCED BY
GL122 GL190 GL121 GL20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADC-COMPANY Numeric 4
Element: Company The Average Daily Balance Company
established in AD10. The company must
exist as a General Ledger Company.
ADC-BAL-ACCT-UNIT Alpha 15
Element: Bal Acct Unit The Balancing Accounting Unit
established in the Average Daily
Balance Company AD10.
ADC-BAL-ACCOUNT Numeric 6
Element: Account The Balancing Account established in the
Average Daily Balance company AD10.
ADC-BAL-SUB-ACCT Numeric 4
Element: Sub Acct The Balancing Sub-Account establshed in
the Average Daily Balance Company.
ADC-LAST-UPDT-PROG Alpha 5
Element: Program The Transaction Posting (AD190) or The
Cost of Funds (AD191) program that last
processed for the company.
ADC-LAST-RUN-DATE Numeric 8 (yyyymmdd)
Element: Last Run Date The last run date of the Transaction
Posting (AD190) or the Cost of Funds
(AD191).
ADC-AS-OF-EFFT-DTE Numeric 8 (yyyymmdd)
Element: As Of Efft DteThe As Of Effective Date defined in
AD10. Used for date default for AD190.
ADC-UPDATE-DAILY Alpha 1
Element: Update Daily The Update Daily Flag determines if the
daily balance files are created.
The Valid values are Yes and No.
" " = Default
Y = Yes
N = No
ADCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADCSET1 COMPANY GL122 GL190
GL121 GL20.2
ADCSET2 COMPANY Subset
Where COMPANY != Zeroes
ADCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
ADC-COMPANY -> GLS-COMPANY (GLSSET1)
|
