|
|
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 The time the record was processed. 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 The Parent Object Identifier field
contains the object identifier of the
member parent.
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
|
