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

IC211     IC330     PO20.1    WH422     WH440     WHD2.1
IC203     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 Grp    This field contains the set of
                       locations within a company defined for
                       reporting purposes.

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

IRG-TOTAL-GRP          Numeric 3                                 IC03.1
Element: Total Grp     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                                                IC03.1  IC211
          REPORT-GRP                                             IC330   PO20.1
          LOCATION                                               WH422   WH440
                                                                 WHD2.1

IRGSET2   COMPANY       KeyChange                                IC203   RQ230
          REPORT-GRP
          TOTAL-GRP
          LOCATION

                         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