Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCPYGRP


                             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    AC32.1    AC34.1    AC35.1    AC36.1
AC37.1    AC490     ACVW.1    AM152     AM206     AM211
AM252     AM520     CA00.1    CA00.2    CA110     CA190
CA195     CA199     CA200     CA210     CA215     CA240
CA290     FB100     FB101     FB11.1    FB111     FB122
FB145     FB190     FB210     FB211     FB220     FB225
FB230     FB231     FB240     FB296     FB95.1    FB95.2
FB95.3    FB95.4    FB95.5    FB95.6    GL120     GL122
GL141     GL145     GL146     GL147     GL167     GL170
GL179     GL190     GL191     GL196     GL197     GL199
GL230     GL238     GL240     GL241     GL243     GL245
GL247     GL250     GL256     GL267     GL270     GL275
GL290     GL291     GL292     GL293     GL294     GL295
GL296     GL297     GL298     GL300     GL310     GL320
GL325     GL326     GL327     GL328     GL330     GL55.1
GL94.1    GL94.2    GL94.3    GL94.4    GL94.5    GL94.6
GL94.7    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
Element: Company Group The company group name.

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

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


GCG-SHORT-DESC         Derived
Element: Short DescriptThe 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
                                                                 AC32.1  AC34.1
                                                                 AC35.1  AC36.1
                                                                 AC37.1  AC490
                                                                 ACVW.1  AM152
                                                                 AM206   AM211
                                                                 AM252   AM520
                                                                 CA00.1  CA00.2
                                                                 CA110   CA190
                                                                 CA195   CA199
                                                                 CA200   CA210
                                                                 CA215   CA240
                                                                 ...

                         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