Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            GLCLSAUDIT FILE

                            GL Closing Audit

The General Ledger Closing Audit file contains the company general ledger
closing information for a specific period and fiscal year.


UPDATED BY

GL110     GL199

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GCA-COMPANY          Numeric 4                                   GL199
Company              The company number represents an
                     established company and is entered on
                     all function codes.

GCA-FISCAL-YEAR      Numeric 4                                   GL199
Fiscal Year          This is the current fiscal year.  This
                     field is updated by Period Closing
                     (GL199).

GCA-ACCT-PERIOD      Numeric 2                                   GL199
Accounting Period    This is the current accounting period.
                     This field is updated by GL199 (Period
                     Closing).

GCA-CLOSE-SEQ        Numeric 2                                   GL199
Closing Sequence     The General Ledger close sequence.

GCA-CLOSE-DATE       Numeric 8  (yyyymmdd)                       GL199
Close Date           The General Ledger period close date.

GCA-CLOSE-TIME       Numeric 6  (hhmmss)                         GL199
Closing Time         The General Ledger period close time.

GCA-PER-END-CODE     Alpha 1                                     GL199
Period End Code      The General Ledger period closing
                     option.

                     L = Limited
                     F = Final

                         GLCLSAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCASET1   COMPANY                                                GL110   GL199
          FISCAL-YEAR
          ACCT-PERIOD
          CLOSE-SEQ

                         GLCLSAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required

                            GCA-COMPANY        -> GLS-COMPANY

                         GLCLSAUDIT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcontrol      GLCONTROL

                            GCA-COMPANY        -> GLC-COMPANY
                            GCA-FISCAL-YEAR    -> GLC-FISCAL-YEAR
                            GCA-ACCT-PERIOD    -> GLC-ACCT-PERIOD
                            GCA-CLOSE-SEQ      -> GLC-CLOSE-SEQ
                                                  GLC-SYSTEM
                                                  GLC-JE-TYPE
                                                  GLC-CONTROL-GROUP
                                                  GLC-JE-SEQUENCE