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     FB160     FB190     FB210     FB211     FB220
FB225     FB230     FB231     FB235     FB240     FB296
FB60.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL120     GL122     GL141     GL145     GL146
GL147     GL148     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    GL90.6    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     SADM.2    SADM.5    SADM.6    SADM.7    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