Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICLOCGRP


                             ICLOCGRP FILE

                             Location Group

The Location Group file allows logical location groups to be set up.  For an
inventory location, other inventory locations can be associated with it in a
specific sequence.

For the Work Order system, location groups are set up in this file to define
substitute locations that can be the inventory source of components when the
component is not available at the normal inventory (production) location.

REFERENCED BY

IC202     IC68.1    IC68.2    IC68.3

UPDATED BY

IC02.2    IC02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ILG-COMPANY            Numeric 4                                 IC02.2
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.

ILG-LOCATION           Alpha 5                                   IC02.2
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

ILG-SEQ                Numeric 3                                 IC02.2
Element: Sequence NumbeThis field contains the record sequence
                       number.

ILG-SUB-LOCATION       Alpha 5                                   IC02.2
Element: Location Code This is a substitute location for the
                       location.

ILG-SYSTEM-CD          Alpha 2                                   IC02.2
Element: System Code   The system code designates the system
                       that uses this location group record.
                       WO

                         ICLOCGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ILGSET1   COMPANY                                                IC02.1  IC02.2
          LOCATION                                               IC202   IC68.1
          SYSTEM-CD                                              IC68.2  IC68.3
          SEQ

ILGSET2   COMPANY       KeyChange                                IC02.2
          LOCATION
          SYSTEM-CD
          SUB-LOCATION
          SEQ

                         ICLOCGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icloc          ICLOCATION   Required

                            ILG-COMPANY         -> ICL-COMPANY
                            ILG-LOCATION        -> ICL-LOCATION

Sub Loc        ICLOCATION   Required

                            ILG-COMPANY         -> ICL-COMPANY
                            ILG-SUB-LOCATION    -> ICL-LOCATION