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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GLA-COMPANY          Numeric 4                                   GL110   GL20.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

GLA-ACCT-UNIT        Alpha 15                                    GL20.1
Accounting Unit      The 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
Process Date         The date the record was processed.

GLA-PROCESS-TIME     Numeric 6  (hhmmss)                         GL120   GL20.1
Process Time         The time the record was processed.

GLA-DATE-CHANGED     Numeric 8  (yyyymmdd)                       GL20.1
Date Changed         The system date the record was last
                     changed in GL10 (Accounting Units).


GLA-OLD-LEVELS       Alpha 30                                    GL20.1
Old Levels           The level the Accounting Unit was
                     changed from.


GLA-NEW-LEVELS       Alpha 30                                    GL20.1
New Levels           The level the Accounting Unit was
                     changed to.


GLA-DESCRIPTION      Alpha 30  (Lower Case)
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
From                 This 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.


                         GLAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLASET1   COMPANY                                                GL110   GL20.1
          ACCT-UNIT
          PROCESS-DATE
          PROCESS-TIME

GLASET2   COMPANY       KeyChange                                GL120
          PROCESS-DATE
          PROCESS-TIME
          ACCT-UNIT

GLASET3   COMPANY       KeyChange, Subset                        GL20.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