Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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

                         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