Lawson Insight Technical Documentation

                             ICRPTGRP FILE

                              Report Group

The Report Group file stores the valid report groups used to define groups of
locations for reporting purposes.

REFERENCED BY

DR100     IC120     IC138     IC140     IC141     IC142
IC145     IC150     IC151     IC152     IC170     IC183
IC211     IC221     IC222     IC223     IC224     IC225
IC226     IC227     IC228     IC230     IC237     IC238
IC239     IC241     IC242     IC281     IC286     IC31.1
IC330     IC40.1    IC40.2    IC520     IC522     IC525
IC530     IC70.1    IC125     IC134     IC135     IC182
IC203     IC229     IC233     IC234     IC283     IC295
IC523     IC526     IC527     PC210     RQ230

UPDATED BY

IC03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IRG-COMPANY          Numeric 4                                   IC03.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

IRG-REPORT-GRP       Alpha 5                                     IC03.1
Report Group         This field contains the set of
                     locations within a company defined for
                     reporting purposes.

IRG-LOCATION         Alpha 5                                     IC03.1
Location Code        This field contains a valid stocking
                     location within the company inventory.

IRG-TOTAL-GRP        Numeric 3                                   IC03.1
Total Group          This field contains a value assigned to
                     a location within a report group. This
                     value is used to group locations for
                     printing total breaks on reports when
                     this value changes.

                         ICRPTGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IRGSET1   COMPANY                                                DR100   IC03.1
          REPORT-GRP                                             IC120   IC138
          LOCATION                                               IC140   IC141
                                                                 IC142   IC145
                                                                 IC150   IC151
                                                                 IC152   IC170
                                                                 IC183   IC211
                                                                 IC221   IC222
                                                                 IC223   IC224
                                                                 IC225   IC226
                                                                 IC227   IC228
                                                                 IC230   IC237
                                                                 IC238   IC239
                                                                 IC241   IC242
                                                                 IC281   IC286
                                                                 ...

IRGSET2   COMPANY       KeyChange                                DR100   IC125
          REPORT-GRP                                             IC134   IC135
          TOTAL-GRP                                              IC182   IC203
          LOCATION                                               IC229   IC233
                                                                 IC234   IC283
                                                                 IC295   IC522
                                                                 IC523   IC525
                                                                 IC526   IC527
                                                                 PC210   RQ230

                         ICRPTGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            IRG-COMPANY     -> ICC-COMPANY

Location       ICLOCATION   Required

                            IRG-COMPANY     -> ICL-COMPANY
                            IRG-LOCATION    -> ICL-LOCATION