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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ILG-COMPANY PKCOMPANY | 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 PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC02.2 |
ILG-SEQ PKSEQ | Numeric 3 | This field contains the record sequence number. | IC02.2 |
ILG-SUB-LOCATIONSUB_LOCATION | Alpha 5 | This is a substitute location for the location. | IC02.2 |
ILG-SYSTEM-CD PKSYSTEM_CD | Alpha 2 | The system code designates the system that uses this location group record. WO | IC02.2 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ILGSET1 | COMPANY, LOCATION, SYSTEM-CD, SEQ | Primary | AP510, IC02.1, IC02.2, IC202, IC64.1, IC64.2, IC64.3, IC64.4 +11 more | |
ILGSET2 | COMPANY, LOCATION, SYSTEM-CD, SUB-LOCATION, SEQ | KeyChange | IC02.2 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Icloc | ICLOCATION | Required | ILG-COMPANY → ICL-COMPANY, ILG-LOCATION → ICL-LOCATION | |
| Sub Loc | ICLOCATION | Required | ILG-COMPANY → ICL-COMPANY, ILG-SUB-LOCATION → ICL-LOCATION |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (15)
- AP510 Vendor Conversion
- IC02.1 Location
- IC02.2 Substitute Locations
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC802 Locations to LRO via BCI
- IC81.1 Cart, Par Location
- IC840 Cart Par Location Conversion