Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              GLCGCPY FILE

                         Company Group Company

The General Ledger Company Group file contains the valid groups for an
existing company as defined in GL11.1 (Company Group).


REFERENCED BY

AC121     AC123     AC130     AC195     AC20.1    AC20.2
AC20.3    AC20.4    AC20.5    AC30.2    AC30.3    AC32.1
AC490     ACDL.1    AM152     AM180     AM252     CA00.1
CA00.2    CA190     CA210     GL190     GL10.1    GL124
GL162     GL20.1    GL20.7    GL20.8    GL20.5    GL62.1
IFEO.1    IFOS.1    IFOS.3    AC34.1    ACVW.1    AM205
AM206     AM211     AM255     AM520     CA10.5    CA10.2
CA10.6    CA110     CA199     FB100     FB101     FB141
FB20.1    FB20.6    FB20.7    FB21.1    FB95.1    FB95.2
FB95.3    FB95.4    FB95.5    FB95.6    GL199     GL256
GL292     GL293     GL294     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    RW230     RW270
RW299     RW30.1    RW60.1    RW60.4    RW70.1    RW80.1
GL211     GLAV.1    GLCV.1    GLVW.1    IFBO.1    SLVW.1
AC176     AM115     AM118     AM120     AM125     AM15.1
AM15.2    AM15.3    AM15.4    AM170     AM185     AM190
AM192     AM195     AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM21.1    AM21.2    AM21.3    AM21.4
AM21.5    AM21.6    AM212     AM220     AM221     AM222
AM223     AM224     AM225     AM230     AM235     AM240
AM241     AM245     AM250     AM251     AM260     AM265
AM266     AM270     AM275     AM277     AM278     AM280
AM281     AM282     AM285     AM290     AM292     AM295
AM300     AM310     AM320     AM500     AM551     AM580
AM88.7    AM96.1    AM98.1    AMAS.1    AMDL.1    BR211
CA195     CA215     CA240     CA290     FB122     FB210
FB220     FB225     FB230     FB231     GL120     GL122
GL141     GL145     GL146     GL167     GL170     GL179
GL191     GL196     GL230     GL238     GL240     GL241
GL243     GL245     GL247     GL250     GL267     GL270
GL275     GL290     GL291     GL295     GL296     GL297
GL300     GL310     GL320     GL325     GL326     GL327
GL328     GL330     CU161     CU203     CU220     CU261
CU300     GL121     GL161     GL198     GL210     GL220
GL221     GL222     GL225     GL261     GLOP.1    MX135

UPDATED BY

GL110     GL11.1    GL11.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GCC-COMPANY-GROUP    Alpha 12                                    GL11.1
Company Group        The name that identifies the company
                     group.


GCC-COMPANY          Numeric 4                                   AM190   AM195
Company              The company number as defined in GL10.1     AM255   AM266
                     (Company).                                  AM282   AM285
                                                                 AM295   GL11.1

GCC-SEQ-NBR          Numeric 4                                   GL11.1
Sequence Number      Contains the assigned sequence number.

                         GLCGCPY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCCSET1   COMPANY                                                AC121   AC123
          COMPANY-GROUP                                          AC130   AC195
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC30.2
                                                                 AC30.3  AC32.1
                                                                 AC490   ACDL.1
                                                                 AM152   AM180
                                                                 AM252   CA00.1
                                                                 CA00.2  CA190
                                                                 CA210   GL110
                                                                 GL190   GL10.1
                                                                 GL11.1  GL124
                                                                 GL162   GL20.1
                                                                 GL20.7  GL20.8
                                                                 ...

GCCSET2   COMPANY-GROUP KeyChange                                AC121   AC123
          SEQ-NBR                                                AC130   AC20.1
          COMPANY                                                AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC34.1
                                                                 AC490   ACVW.1
                                                                 AM152   AM180
                                                                 AM205   AM206
                                                                 AM211   AM252
                                                                 AM255   AM520
                                                                 CA10.5  CA110
                                                                 CA190   CA199
                                                                 FB100   FB101
                                                                 FB141   FB20.1
                                                                 ...

GCCSET3   COMPANY-GROUP                                          AC176   AC195
          COMPANY                                                AC34.1  AM115
                                                                 AM118   AM120
                                                                 AM125   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM152
                                                                 AM170   AM180
                                                                 AM185   AM190
                                                                 AM192   AM195
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM205   AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 ...

                         GLCGCPY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required

                            GCC-COMPANY          -> GLS-COMPANY

Glcpygrp       GLCPYGRP     Required

                            GCC-COMPANY-GROUP    -> GCG-COMPANY-GROUP