Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              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.5    AP20.7    AP23.1    AP30.2
AP32.2    CA10.1    CA10.2    CA10.7    CA10.8    CA190
GL122     GL135     GL146     GL167     GL170     GL190
GL195     GL196     GL199     GL230     GL240     GL327
GL330     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL40.9    GL44.1    GL45.1    GL50.4    GL500     GL70.1
GL70.2    GL70.3    GL70.7    GL75.1    GL20.1    GL20.2
GL20.4    MA40.1    MA40.2    MA41.1    MA41.2    MA41.4
MA41.5    MA41.6    MA43.1    MA43.2    MA43.3    MA43.4
MA52.1

UPDATED BY

GL110     GL30.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


GLZ-ZONE             Alpha 15                                    GL30.2
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
Base Accounting Unit The base accounting unit.

GLZ-GAIN-ACCT-UNT    Alpha 15                                    GL30.2
Gain Accounting Unit This field identifies the accounting

                     unit for posting translation gains in
                     this zone.


GLZ-LOSS-ACCT-UNT    Alpha 15                                    GL30.2
Loss Accounting Unit The loss account unit used for posting
                     translation loss amounts within this
                     zone.


                         GLZONE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLZSET1   COMPANY                                                AP20.1  AP20.2
          ZONE                                                   AP20.5  AP20.7
                                                                 AP23.1  AP30.2
                                                                 AP32.2  CA10.1
                                                                 CA10.2  CA10.7
                                                                 CA10.8  CA190
                                                                 GL110   GL122
                                                                 GL135   GL146
                                                                 GL167   GL170
                                                                 GL190   GL195
                                                                 GL196   GL199
                                                                 GL230   GL240
                                                                 GL30.1  GL30.2
                                                                 GL327   GL330
                                                                 GL40.1  GL40.2
                                                                 ...

                         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

Gain Acct Unt  GLNAMES      Required

                            GLZ-COMPANY          -> GLN-COMPANY
                            GLZ-GAIN-ACCT-UNT    -> GLN-ACCT-UNIT

Loss Acct Unt  GLNAMES      Required

                            GLZ-COMPANY          -> GLN-COMPANY
                            GLZ-LOSS-ACCT-UNT    -> 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