Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICRPTGRP


                             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     IC220     IC221     IC222     IC223     IC224
IC225     IC226     IC227     IC228     IC230     IC235
IC237     IC238     IC239     IC241     IC242     IC281
IC286     IC287     IC31.1    IC330     IC331     IC37.1
IC40.1    IC40.2    IC44.1    IC46.1    IC520     IC522
IC525     IC530     IC55.1    IC55.2    IC70.1    PO20.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
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

IRG-TOTAL-GRP          Numeric 3                                 IC03.1
Element: 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
                                                                 IC220   IC221
                                                                 IC222   IC223
                                                                 IC224   IC225
                                                                 IC226   IC227
                                                                 IC228   IC230
                                                                 IC235   IC237
                                                                 IC238   IC239
                                                                 IC241   IC242
                                                                 ...

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