|
|
ADAVGBAL FILE
UPDATED BY
GL120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADV-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
ADV-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Date
ADV-ACCT-UNIT Alpha 15
Element: Accounting UniThe 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
Element: 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
Element: Subaccount
ADV-VAR-LEVELS Alpha 30 GL120
Element: New Levels
ADV-FISCAL-YEAR Numeric 4
Element: Last Closed YeThis is the current fiscal year. This
field is updated by Period Closing
(GL199).
ADV-ACCT-PERIOD Numeric 2
Element: Current Period
ADV-AVG-PER-AMOUNT Currency 15.2
Element: Avg Per Amount
ADV-AVG-QTR-AMOUNT Currency 15.2
Element: Avg Qtr Amount
ADV-AVG-YER-AMOUNT Currency 15.2
Element: Avg Yer Amount
ADV-MAINT-DATE Numeric 8 (yyyymmdd)
Element: Date
ADV-MAINT-TIME Numeric 6 (hhmmss)
Element: Sys Time
ADAVGBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADVSET1 COMPANY GL120
EFFECT-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADVSET2 COMPANY GL120
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
|
