Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCLSAUDIT


                            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     GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GCA-COMPANY            Numeric 4                                 GL199   GL500
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

GCA-FISCAL-YEAR        Numeric 4                                 GL199   GL500
Element: Fiscal Year   Contains the fiscal year for the data
                       stored on this record.


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

GCA-CLOSE-SEQ          Numeric 2                                 GL199   GL500
Element: Close SequenceThe General Ledger close sequence.

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

GCA-CLOSE-TIME         Numeric 6  (hhmmss)                       GL199   GL500
Element: Close Time    The General Ledger period close time.

GCA-PER-END-CODE       Alpha 1                                   GL199   GL500
Element: Period End CodThe 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                                            GL500
          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