Lawson Insight Technical Documentation

                             GLCPYGRP FILE

                      General Ledger Company Group

This file contains the valid company group definitions. Company groups are
defined in GL11.1 (Company Group).


REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC30.2    AC30.3    AC32.1    AC34.1
AC35.1    AC36.1    AC490     ACVW.1    AM152     AM206
AM211     AM252     AM520     CA00.1    CA00.2    CA110
CA190     CA195     CA199     CA200     CA210     CA215
CA240     CA290     FB100     FB101     FB122     FB210
FB220     FB225     FB230     FB231     FB95.1    FB95.2
FB95.3    FB95.4    FB95.5    FB95.6    GL120     GL122
GL141     GL145     GL146     GL167     GL170     GL179
GL190     GL191     GL196     GL199     GL230     GL238
GL240     GL241     GL243     GL245     GL247     GL250
GL256     GL267     GL270     GL275     GL290     GL291
GL292     GL293     GL294     GL295     GL296     GL297
GL300     GL310     GL320     GL325     GL326     GL327
GL328     GL330     GL55.1    GL95.1    GL95.2    GL95.3
GL95.4    GL95.5    GL95.6    GL95.7    GL95.8    GL95.9
GL96.1    GL96.2    GL96.3    GL96.4    GL96.5    GL97.1
GL97.2    GL97.3    GL97.4    GL97.5    GL97.6    GL97.7
GL97.8    GL97.9    GL98.1    GL98.2    GL98.3    GL98.4
GL98.5    GL99.1    GL99.2    GL99.3    GL99.4    GL99.5
GL99.6    RW00.1    RW10.2    RW10.3    RW10.4    RW10.6
RW10.7    RW100     RW20.5    RW20.6    RW298     RW60.1
RW60.4    RW70.1    CU161     CU203     CU220     CU261
CU300     GL121     GL161     GL198     GL210     GL211
GL220     GL221     GL222     GL225     GL261     GLAV.1
GLCV.1    GLVW.1    MX00.3    MX135     SLVW.1

UPDATED BY

GL110     GL11.1    GL11.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GCG-COMPANY-GROUP    Alpha 12                                    GL11.2
Company Group        The company group name.

GCG-DESCRIPTION      Alpha 30  (Lower Case)                      GL11.2  RW100
Description          This is the description.

GCG-LST-SEQ-NBR      Numeric 4                                   GL11.1
List Sequence Number The list member sequence number within
                     the company group.


GCG-SHORT-DESC       Derived
Short Description    The short description.

                         GLCPYGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCGSET1   COMPANY-GROUP                                          AC121   AC123
                                                                 AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC34.1
                                                                 AC35.1  AC36.1
                                                                 AC490   ACVW.1
                                                                 AM152   AM206
                                                                 AM211   AM252
                                                                 AM520   CA00.1
                                                                 CA00.2  CA110
                                                                 CA190   CA195
                                                                 CA199   CA200
                                                                 CA210   CA215
                                                                 ...

                         GLCPYGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcgcpy        GLCGCPY      Delete Cascades

                            GCG-COMPANY-GROUP    -> GCC-COMPANY-GROUP
                                                    GCC-SEQ-NBR
                                                    GCC-COMPANY

Matrix Cat     MXOBJCAT

                            "ACCTU"              -> MOC-OBJ-TYPE
                            GCG-COMPANY-GROUP    -> MOC-APPLY-TO-GROUP
                                                    MOC-MATRIX-CAT