ADAVGBAL FILE
UPDATED BY
GL120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADV-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
ADV-EFFECT-DATE Numeric 8 (yyyymmdd)
Effective Date
ADV-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.
ADV-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.
ADV-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.
ADV-VAR-LEVELS Alpha 30 GL120
Variable Levels A level that represents the location of
an accounting unit in an organization's
level structure.
ADV-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
ADV-ACCT-PERIOD Numeric 2
Account Period This is the current accounting period.
This field is updated by GL199 (Period
Closing).
ADV-AVG-PER-AMOUNT Currency 15.2
Avg Per Amount
ADV-AVG-QTR-AMOUNT Currency 15.2
Avg Qtr Amount
ADV-AVG-YER-AMOUNT Currency 15.2
Avg Yer Amount
ADV-MAINT-DATE Numeric 8 (yyyymmdd)
Maintenance Date The date last changed.
ADV-MAINT-TIME Numeric 6 (hhmmss)
Maintenance Time The time last changed.
ADAVGBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADVSET1 COMPANY GL120
EFFECT-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADVSET2 COMPANY
EFFECT-DATE
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
ADVSET3 COMPANY
EFFECT-DATE*
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADVSET4 COMPANY
EFFECT-DATE*
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
|
