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
AP23.1    AP30.2    AP32.2    CA10.1    CA10.2    CA10.6
CA10.7    CA190     FB45.1    GL122     GL135     GL146
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.6    GL75.1    GL20.1    GL20.2
GL20.4    MA41.2    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 base accounting unit.
Accounting Unit

GLZ-IS-ACCT-UNIT       Alpha 15                                  GL30.2
Income Statement
Account 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
                                                                 AP23.1  AP30.2
                                                                 AP32.2  CA10.1
                                                                 CA10.2  CA10.6
                                                                 CA10.7  CA190
                                                                 FB45.1  GL110
                                                                 GL122   GL135
                                                                 GL146   GL167
                                                                 GL170   GL190
                                                                 GL191   GL195
                                                                 GL196   GL197
                                                                 GL199   GL230
                                                                 GL240   GL30.1
                                                                 ...

                         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