Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

FB165     FB195     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
Old Company          The organization code defined for the
                     old company number.


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


GCR-ACCT-UNIT        Alpha 15                                    GL08.1  GL08.2
Accounting Unit      The 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
Old Cpy Short        The short description.

                         GLCOMPREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCRSET1   OLD-COMPANY                                            FB165   FB195
                                                                 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