ICFGBYPROD – Finished Goods Byproduct

System
Inventory Control (IC)
Prefix
ICP
Primary key
COMPANY, LOCATION, FG-ITEM, SEQ
Fields
6
Updated by
3 programs
Referenced by
3 programs

ICFGBYPROD is the Finished Goods Byproduct table in Lawson Inventory Control (prefix ICP). It is indexed by COMPANY, LOCATION, FG-ITEM, SEQ (ICPSET1); alternate indexes: ICPSET2. It is related 1:1 to ICCOMPANY and ITEMMAST. It is updated by IC62.1, IC62.2 and IC62.4 and referenced by IC12.1, IC262 and IC330. The table has 6 fields, 2 indexes and 2 documented relations.

About ICFGBYPROD

The Finished Goods Byproduct file contains information for byproducts that are a result of the process that creates the finished goods.

Fields (6)

Column = COBOL field name without the ICP- 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
#ICP-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.IC62.1, IC62.2, IC62.4
#ICP-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory. It is also the production facility where finished goods are produced.IC62.1, IC62.2, IC62.4
#ICP-FG-ITEM PK
FG_ITEM		Alpha 32This field contains the finished good item number.IC62.1, IC62.2, IC62.4
#ICP-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.IC62.2
#ICP-ITEM SET2
ITEM		Alpha 32This field contains the item identifier.IC62.2
#ICP-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.IC62.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
ICPSET1
  1. COMPANY
  2. LOCATION
  3. FG-ITEM
  4. SEQ
PrimaryIC262, IC62.1, IC62.2, IC62.4
ICPSET2
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. FG-ITEM
  5. SEQ
KeyChangeIC12.1, IC330

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
ICP-COMPANY→ICC-COMPANY
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
ICP-ITEM→ITE-ITEM

Programs

Updated by (3)

Referenced by (3)