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 GL20.2 AD120 AD20.1 AD210
AD220 AD290 AD300 AD320 AD325 AD50.1
AD90.1 AD95.1 AD96.1 AD97.1 AD97.2 AD97.3
AD98.1 AD98.2 AD98.3 GL121


UPDATED BY
AD10.1 AD190 AD191 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.
AD10.1 GL110
ADC-BAL-ACCT-UNIT
Element: Bal Acct Unit
Alpha 15
The Balancing Accounting Unit established in the Average Daily Balance Company AD10.
AD10.1
ADC-BAL-ACCOUNT
Element: Account
Numeric 6
The Balancing Account established in the Average Daily Balance company AD10.
AD10.1
ADC-BAL-SUB-ACCT
Element: Sub Acct
Numeric 4
The Balancing Sub-Account establshed in the Average Daily Balance Company.
AD10.1
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.
AD190 AD191
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.
AD10.1
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
AD10.1


ADCOMPANY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADCSET1 COMPANY
AD10.1 AD120
AD190 AD191
AD20.1 AD210
AD220 AD290
AD300 AD320
AD325 AD50.1
AD90.1 AD95.1
AD96.1 AD97.1
AD97.2 AD97.3
AD98.1 AD98.2
AD98.3 GL110
GL122 GL190
GL121 GL20.2
ADCSET2 COMPANY
Subset
WhereCOMPANY !=Zeroes
AD10.1 AD210
AD320 AD325


ADCOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Thu Jun 09 11:05:10 2016

Home
Contact Us



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