|
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 The company number represents an
established company and is entered on
all function codes.
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
|