|
|
GLAUDIT FILE
General Ledger Audit
This file contains an audit of when and how the levels within a company were
changed. Information is stored here when you changed a level and process the
change by running GL120 (Level Reorganization).
UPDATED BY
GL110 GL120 GL20.1 GL24.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLA-COMPANY Numeric 4 GL110 GL20.1
Element: Company The company number represents an GL24.1
established company and is entered on
all function codes.
GLA-ACCT-UNIT Alpha 15 GL20.1 GL24.1
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.
GLA-PROCESS-DATE Numeric 8 (yyyymmdd) GL120 GL20.1
Element: Process Date The date the record was processed. GL24.1
GLA-PROCESS-TIME Numeric 6 (hhmmss) GL120 GL20.1
Element: Process Time GL24.1
GLA-DATE-CHANGED Numeric 8 (yyyymmdd) GL20.1 GL24.1
Element: Date Changed The system date the record was last
changed in GL10 (Accounting Units).
GLA-OLD-LEVELS Alpha 30 GL20.1
Element: Old Levels
GLA-NEW-LEVELS Alpha 30 GL20.1 GL24.1
Element: New Levels The level the Accounting Unit was
changed to.
GLA-DESCRIPTION Alpha 30 (Lower Case)
Element: Description Currently unused. This field contains
the description. When implemented, this
feature will allow posting accounting
units to be automatically created by
loading them into this file with a zero
old levels and a description. See also
the ACCTS-FROM-AU field.
GLA-ACCTS-FROM-AU Alpha 15
Element: Accounting UniThis field allows an Accounting Unit to
be loaded into this field when creating
Accounting Units in a batch mode. The
accounts in this Accounting Unit will be
copied to the new accounting unit. This
field will be optional.
GLA-OBJ-ID Numeric 12 GL20.1 GL24.1
Object This is the object identifier. It is
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
GLA-PARENT-OBJ-ID Numeric 12 GL20.1 GL24.1
Object
Identification
GLA-NEW-PAR-OBJ-ID Numeric 12 GL20.1 GL24.1
Element: New Par Obj Id
GLA-LEVEL-DEPTH Numeric 1 GL20.1 GL24.1
Element: Level Depth The number of variable levels
pertaining
to this record.
GLA-LEVEL-DETAIL Numeric 15 Occurs 5 Times GL20.1 GL24.1
Element: Level Detail
GLA-MOVED-BY-AU Alpha 15 GL20.1
Element: Moved By Au
GLAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLASET1 COMPANY GL110 GL20.1
ACCT-UNIT GL24.1
PROCESS-DATE
PROCESS-TIME
GLASET2 COMPANY KeyChange GL120
PROCESS-DATE
PROCESS-TIME
ACCT-UNIT
GLASET3 COMPANY KeyChange, Subset GL20.1 GL24.1
NEW-LEVELS Where PROCESS-DATE = Zeroes
ACCT-UNIT
GLAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Unit GLNAMES Required
GLA-COMPANY -> GLN-COMPANY
GLA-ACCT-UNIT -> GLN-ACCT-UNIT
Company GLSYSTEM Required
GLA-COMPANY -> GLS-COMPANY
GLAUDIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Delete Restricted
GLA-COMPANY -> GLM-COMPANY
GLA-ACCT-UNIT -> GLM-ACCT-UNIT
GLM-ACCOUNT
GLM-SUB-ACCOUNT
|
