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.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

ILG-LOCATION         Alpha 5                                     IC02.1
Location Code        This field contains a valid stock
                     location within the company inventory.


ILG-SEQ              Numeric 3                                   IC02.1
Sequence Number      This field contains the record sequence
                     number.

ILG-SUB-LOCATION     Alpha 5                                     IC02.1
Sub Location         This is a substitute location for the
                     location.

ILG-SYSTEM-CD        Alpha 2                                     IC02.1
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  IC202
          LOCATION                                               IC68.1  IC68.2
          SYSTEM-CD                                              IC68.3
          SEQ

ILGSET2   COMPANY       KeyChange                                IC02.1
          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