GLAUDIT

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
Element: Company		Numeric 4
The company number represents an established General Ledger company.
GL110 GL20.1
GL24.1
GLA-ACCT-UNIT
Element: Accounting Unit		Alpha 15
The accounting unit name associated with the move record.
GL20.1 GL24.1
GLA-PROCESS-DATE
Element: Process Date		Numeric 8 (yyyymmdd)
The date the record was processed.
GL120 GL20.1
GL24.1
GLA-PROCESS-TIME
Element: Process Time		Numeric 6 (hhmmss)
GL120 GL20.1
GL24.1
GLA-DATE-CHANGED
Element: Date Changed		Numeric 8 (yyyymmdd)
The system date the record was last changed in GL20 (Accounting Units).
GL20.1 GL24.1
GLA-OLD-LEVELS
Element: Old Levels		Alpha 30
The previous variable level address of the accounting unit.
GL20.1
GLA-NEW-LEVELS
Element: New Levels		Alpha 30
The new variable level address of the accounting unit.
GL20.1 GL24.1
GLA-OBJ-ID
Element: Object ID		Numeric 12
This is the object identifier. It is a unique number assigned to each accounting unit.
GL20.1 GL24.1
GLA-PARENT-OBJ-ID
Element: Parent Object ID		Numeric 12
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.
GL20.1 GL24.1
GLA-NEW-PAR-OBJ-ID
Element: New Parent Object ID		Numeric 12
The new parent object identifier is used on the reorganization process to identify where the subordinate members will be moved.
GL20.1 GL24.1
GLA-LEVEL-DEPTH
Element: Level Depth		Numeric 1
The new variable level depth related to this record.
GL20.1 GL24.1
GLA-LEVEL-DETAIL
Element: Level Detail		Numeric 15 Occurs 5 Times
The breakdown of the variable levels realted to this record.
GL20.1 GL24.1
GLA-MOVED-BY-AU
Moved by Accounting
Unit		Alpha 15
The accounting unit that initiated the move.
GL20.1


GLAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLASET1 COMPANY
ACCT-UNIT
PROCESS-DATE
PROCESS-TIME
GL110 GL20.1
GL24.1
GLASET2 COMPANY
PROCESS-DATE
PROCESS-TIME
ACCT-UNIT
KeyChange
GL120
GLASET3 COMPANY
NEW-LEVELS
ACCT-UNIT
KeyChange, Subset
WherePROCESS-DATE =Zeroes
GL20.1 GL24.1


GLAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Delete Restricted
GLA-COMPANY->GLM-COMPANY
GLA-ACCT-UNIT->GLM-ACCT-UNIT
  GLM-ACCOUNT
  GLM-SUB-ACCOUNT

File created: Thu Jun 09 02:13:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.