Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCOMPREL


                             GLCOMPREL FILE

                     GL Organization Relationships

This file contains information needed to create the Lawson Company structure
when converting from a non-Lawson system as defined in GL08.1 (Organization
Relationship).


REFERENCED BY

AC527     CA160     CA60.1    FB165     FB195     FB265
FB65.1    GL165     GL167     GL195     GL65.1    GL67.1
GL162     GL208     GL62.1

UPDATED BY

GL08.1    GL08.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GCR-OLD-COMPANY        Alpha 35                                  GL08.1  GL08.2
Element: Old Company   The organization code defined for the
                       old company number.


GCR-COMPANY            Numeric 4                                 GL08.1  GL08.2
Element: Company       The company number as defined in GL10.1
                       (Company).


GCR-ACCT-UNIT          Alpha 15                                  GL08.1  GL08.2
Element: Accounting UniThe alphanumeric name that represents
                       the 30-digit variable level number. The
                       name is a unique location within the
                       company. Once defined, the accounting
                       unit's name cannot be changed.


GCR-OLD-CPY-SHORT      Derived
Element: Old Cpy Short The short description.

                         GLCOMPREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCRSET1   OLD-COMPANY                                            AC527   CA160
                                                                 CA60.1  FB165
                                                                 FB195   FB265
                                                                 FB65.1  GL165
                                                                 GL167   GL195
                                                                 GL65.1  GL67.1
                                                                 GL08.1  GL08.2
                                                                 GL162   GL208
                                                                 GL62.1

                         GLCOMPREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Unit      GLNAMES      Required

                            GCR-COMPANY      -> GLN-COMPANY
                            GCR-ACCT-UNIT    -> GLN-ACCT-UNIT

Company        GLSYSTEM     Required

                            GCR-COMPANY      -> GLS-COMPANY