Lawson Insight Technical Documentation


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

ACDL.1    CA00.1    CA00.2    CA110     CA190     GL190
GL162     GL20.1    GL20.7    GL20.5    GL62.1    AC121
AC123     AC127     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC22.1    AC30.2    AC30.3    AC32.1    AC87.1
ACBO.1    ACVW.1    AM205     AM255     AM520     CXA1.1
CA10.5    CA10.2    CA10.7    CA199     FB100     FB101
FB141     FB20.1    FB20.6    FB20.7    FB21.1    FB700
FB95.1    FB95.2    FB95.3    FB95.4    FB95.5    FB95.6
GL170     GL179     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     GL87.1
GL88.1    GLCV.1    GLOB.1    GLVW.1    POA1.1    SAA1.1
WOA1.1    AC176     AC195     AM115     AM118     AM120
AM125     AM15.1    AM15.2    AM15.3    AM15.4    AM170
AM180     AM185     AM190     AM192     AM195     AM20.1
AM20.2    AM20.3    AM20.4    AM20.5    AM20.6    AM212
AM220     AM221     AM222     AM223     AM224     AM225
AM230     AM235     AM240     AM245     AM250     AM260
AM265     AM270     AM275     AM277     AM280     AM285
AM290     AM292     AM295     AM300     AM310     AM500
AM580     AM96.1    AM98.1    CXA2.1    CXA3.1    GL191
GLOP.1    POA2.1    POA3.1    SAA2.1    SAA3.1    WOA2.1
WOA3.1

UPDATED BY

GL11.1

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                                   AM195   AM255
Company              The company number as defined in GL10.1     AM285   AM295
                     (Company).                                  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                                                ACDL.1  CA00.1
          COMPANY-GROUP                                          CA00.2  CA110
                                                                 CA190   GL190
                                                                 GL11.1  GL162
                                                                 GL20.1  GL20.7
                                                                 GL62.1

GCCSET2   COMPANY-GROUP KeyChange                                AC121   AC123
          SEQ-NBR                                                AC127   AC130
          COMPANY                                                AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC22.1  AC30.2
                                                                 AC30.3  AC32.1
                                                                 AC87.1  ACBO.1
                                                                 ACVW.1  AM205
                                                                 AM255   AM520
                                                                 CXA1.1  CA10.5
                                                                 CA110   CA190
                                                                 CA199   FB100
                                                                 FB101   FB141
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 ...

GCCSET3   COMPANY-GROUP                                          AC176   AC195
          COMPANY                                                AM115   AM118
                                                                 AM120   AM125
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM180
                                                                 AM185   AM190
                                                                 AM192   AM195
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM212   AM220
                                                                 AM221   AM222
                                                                 AM223   AM224
                                                                 AM225   AM230
                                                                 ...

                         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