Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLZONE


                              GLZONE FILE

                          General Ledger Zone

This file contains the zone relationships set up in the interzone processing
programs. The zone relationships contain companies with payable and receivable
accounts. If you request automatic zone balancing when you define your
company, error suspense, and retained earnings accounts are also stored in
this file.


REFERENCED BY

AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP23.1    AP30.2    CA10.1    CA10.2    CA10.4
CA10.6    CA10.7    CA190     FB45.1    GL122     GL135
GL146     GL148     GL167     GL170     GL190     GL191
GL195     GL196     GL197     GL199     GL230     GL240
GL325     GL327     GL330     GL40.1    GL40.2    GL40.3
GL40.6    GL40.7    GL40.8    GL44.1    GL45.1    GL50.4
GL500     GL70.1    GL70.2    GL70.3    GL70.5    GL70.6
GL75.1    GL20.1    GL20.2    GL20.4    MA41.1    MA41.2
MA41.4    MA41.7    MA43.2

UPDATED BY

GL110     GL30.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLZ-COMPANY            Numeric 4                                 GL110   GL30.2
Element: Company       The company number as defined in GL10.1
                       (Company).


GLZ-ZONE               Alpha 15                                  GL30.2
Element: Zone          A zone identifies a group of accounting
                       units that stay in balance when
                       transactions pass between defined zone
                       areas.




GLZ-BS-ACCT-UNIT       Alpha 15                                  GL30.2
Balance Sheet          The zone balance sheet accounting unit.
Accounting Unit

GLZ-IS-ACCT-UNIT       Alpha 15                                  GL30.2
Income Statement       The zone Income Statement accounting
Account Unit           unit.

                         GLZONE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLZSET1   COMPANY                                                AP20.1  AP20.2
          ZONE                                                   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP30.2  CA10.1
                                                                 CA10.2  CA10.4
                                                                 CA10.6  CA10.7
                                                                 CA190   FB45.1
                                                                 GL110   GL122
                                                                 GL135   GL146
                                                                 GL148   GL167
                                                                 GL170   GL190
                                                                 GL191   GL195
                                                                 GL196   GL197
                                                                 GL199   GL230
                                                                 ...

                         GLZONE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bs Acct Unit   GLNAMES      Required

                            GLZ-COMPANY         -> GLN-COMPANY
                            GLZ-BS-ACCT-UNIT    -> GLN-ACCT-UNIT

Company        GLSYSTEM     Required

                            GLZ-COMPANY         -> GLS-COMPANY

Is Acct Unit   GLNAMES      Required

                            GLZ-COMPANY         -> GLN-COMPANY
                            GLZ-IS-ACCT-UNIT    -> GLN-ACCT-UNIT

                         GLZONE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glintco        GLINTCO

                            "L"                 -> GIC-RECORD-TYPE
                            GLZ-COMPANY         -> GIC-COMPANY-A
                            Zeroes              -> GIC-COMPANY-B
                            GLZ-ZONE            -> GIC-ZONE-A
                                                   GIC-ZONE-B
                                                   GIC-SYSTEM