ADCFBAL FILE
UPDATED BY
GL120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADL-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
ADL-EFFECT-DATE Numeric 8 (yyyymmdd)
Effective Date
ADL-ACCT-UNIT Alpha 15
Accounting Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
ADL-ACCOUNT Numeric 6
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ADL-SUB-ACCOUNT Numeric 4
Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ADL-VAR-LEVELS Alpha 30 GL120
Variable Levels A level that represents the location of
an accounting unit in an organization's
level structure.
ADL-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
ADL-ACCT-PERIOD Numeric 2
Account Period This is the current accounting period.
This field is updated by GL199 (Period
Closing).
ADL-CF-PER-AMOUNT Currency 15.2
Cf Per Amount
ADL-CF-QTR-AMOUNT Currency 15.2
Cf Qtr Amount
ADL-CF-YER-AMOUNT Currency 15.2
Cf Yer Amount
ADL-MAINT-TIME Numeric 6 (hhmmss)
Maintenance Time The time last changed.
ADL-MAINT-DATE Numeric 8 (yyyymmdd)
Maintenance Date The date last changed.
ADCFBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADLSET1 COMPANY GL120
EFFECT-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADLSET2 COMPANY
EFFECT-DATE
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
|