ADCOMPANY

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


UPDATED BY
GL110

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADC-COMPANY
Element: Company
Numeric 4
The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.
GL110
ADC-BAL-ACCT-UNIT
Element: Bal Acct Unit
Alpha 15
The Balancing Accounting Unit established in the Average Daily Balance Company AD10.
ADC-BAL-ACCOUNT
Element: Account
Numeric 6
The Balancing Account established in the Average Daily Balance company AD10.
ADC-BAL-SUB-ACCT
Element: Sub Acct
Numeric 4
The Balancing Sub-Account establshed in the Average Daily Balance Company.
ADC-LAST-UPDT-PROG
Element: Program
Alpha 5
The Transaction Posting (AD190) or The Cost of Funds (AD191) program that last processed for the company.
ADC-LAST-RUN-DATE
Element: Last Run Date
Numeric 8 (yyyymmdd)
The last run date of the Transaction Posting (AD190) or the Cost of Funds (AD191).
ADC-AS-OF-EFFT-DTE
Element: As Of Efft Dte
Numeric 8 (yyyymmdd)
The As Of Effective Date defined in AD10. Used for date default for AD190.
ADC-UPDATE-DAILY
Element: Update Daily
Alpha 1
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
GL110 GL122
GL190 GL121
GL20.2
ADCSET2 COMPANY
Subset
WhereCOMPANY !=Zeroes


ADCOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
ADC-COMPANY->GLS-COMPANY (GLSSET1)


File created: Wed Jun 08 20:46:59 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.