|
|
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 change 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 General Ledger company.
GLA-ACCT-UNIT Alpha 15 GL20.1 GL24.1
Element: Accounting UniThe accounting unit name associated with
the move record.
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 GL20 (Accounting Units).
GLA-OLD-LEVELS Alpha 30 GL20.1
Element: Old Levels The previous variable level address of
the accounting unit.
GLA-NEW-LEVELS Alpha 30 GL20.1 GL24.1
Element: New Levels The new variable level address of the
accounting unit.
GLA-OBJ-ID Numeric 12 GL20.1 GL24.1
Element: Object ID This is the object identifier. It is a
unique number assigned to each
accounting unit.
GLA-PARENT-OBJ-ID Numeric 12 GL20.1 GL24.1
Element: Parent Object This is the object identifier. It is
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-NEW-PAR-OBJ-ID Numeric 12 GL20.1 GL24.1
Element: New Parent ObjThe new parent object identifier is used
on the reorganization process to
identify where the subordinate members
will be moved.
GLA-LEVEL-DEPTH Numeric 1 GL20.1 GL24.1
Element: Level Depth The new variable level depth related to
this record.
GLA-LEVEL-DETAIL Numeric 15 Occurs 5 Times GL20.1 GL24.1
Element: Level Detail The breakdown of the variable levels
realted to this record.
GLA-MOVED-BY-AU Alpha 15 GL20.1
Moved by Accounting The accounting unit that initiated the
Unit move.
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
|
