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

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                                            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