ICLOCGRP – Location Group

System
Inventory Control (IC)
Prefix
ILG
Primary key
COMPANY, LOCATION, SYSTEM-CD, SEQ
Fields
5
Updated by
15 programs
Referenced by
4 programs

ICLOCGRP is the Location Group table in Lawson Inventory Control (prefix ILG). It is indexed by COMPANY, LOCATION, SYSTEM-CD, SEQ (ILGSET1); alternate indexes: ILGSET2. It is related 1:1 to ICLOCATION and 1:M to ICICLAUDIT. It is updated by AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 and 7 more and referenced by IC202, IC68.1, IC68.2 and IC68.3. The table has 5 fields, 2 indexes and 3 documented relations.

About ICLOCGRP

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.

Fields (5)

Column = COBOL field name without the ILG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ILG-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC02.2
#ILG-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.IC02.2
#ILG-SUB-LOCATION SET2
SUB_LOCATION		Alpha 5This is a substitute location for the location.IC02.2
#ILG-SYSTEM-CD PK
SYSTEM_CD		Alpha 2The system code designates the system that uses this location group record. WOIC02.2

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ILGSET1
  1. COMPANY
  2. LOCATION
  3. SYSTEM-CD
  4. SEQ
PrimaryAP510, IC02.1, IC02.2, IC202, IC64.1, IC64.2, IC64.3, IC64.4 +11 more
ILGSET2
  1. COMPANY
  2. LOCATION
  3. SYSTEM-CD
  4. SUB-LOCATION
  5. SEQ
KeyChangeIC02.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICLOCATIONICICLAUDITICLOCGRP

One to one (2) — lookups and parents

RelationTableRulesConditionField map
IclocICLOCATIONRequired
ILG-COMPANY→ICL-COMPANY
ILG-LOCATION→ICL-LOCATION
Sub LocICLOCATIONRequired
ILG-COMPANY→ICL-COMPANY
ILG-SUB-LOCATION→ICL-LOCATION

One to many (1) — child tables

RelationTableRulesConditionField map
IciclauditICICLAUDIT
ILG-COMPANY→ILA-COMPANY
ILG-LOCATION→ILA-LOCATION
ILG-SYSTEM-CD→ILA-SYSTEM-CD
—→ILA-SEQ
—→ILA-DATE
—→ILA-TIME
—→ILA-FLD-NBR

Programs

Updated by (15)

Referenced by (4)