ICLOCGRP

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 AP510 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC802 IC81.1 IC840

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILG-COMPANY
Element: Company
Numeric 4
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.
IC02.2
ILG-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC02.2
ILG-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
IC02.2
ILG-SUB-LOCATION
Element: Location
Alpha 5
This is a substitute location for the location.
IC02.2
ILG-SYSTEM-CD
Element: System Cd
Alpha 2
The system code designates the system that uses this location group record.
WO
IC02.2


ICLOCGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILGSET1 COMPANY
LOCATION
SYSTEM-CD
SEQ
AP510 IC02.1
IC02.2 IC202
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC68.1
IC68.2 IC68.3
IC802 IC81.1
IC840
ILGSET2 COMPANY
LOCATION
SYSTEM-CD
SUB-LOCATION
SEQ
KeyChange
IC02.2


ICLOCGRP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


ICLOCGRP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iciclaudit ICICLAUDIT
ILG-COMPANY->ILA-COMPANY
ILG-LOCATION->ILA-LOCATION
ILG-SYSTEM-CD->ILA-SYSTEM-CD
  ILA-SEQ
  ILA-DATE
  ILA-TIME
  ILA-FLD-NBR


File created: Thu Jun 09 02:18:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.