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.

Field / column	Type	Description & values	Updated by
`ICP-COMPANY` PK 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.	IC62.1, IC62.2, IC62.4
`ICP-LOCATION` PK LOCATION	Alpha 5	This 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 32	This field contains the finished good item number.	IC62.1, IC62.2, IC62.4
`ICP-SEQ` PK SEQ	Numeric 3	This field contains the record sequence number.	IC62.2
`ICP-ITEM` ITEM	Alpha 32	This field contains the item identifier.	IC62.2
`ICP-QUANTITY` QUANTITY	Signed 13.4	This field contains the desired quantity.	IC62.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
`ICPSET1`	`COMPANY`, `LOCATION`, `FG-ITEM`, `SEQ`	Primary		IC262, IC62.1, IC62.2, IC62.4
`ICPSET2`	`COMPANY`, `LOCATION`, `ITEM`, `FG-ITEM`, `SEQ`	KeyChange		IC12.1, IC330

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Iccompany	ICCOMPANY	Required		`ICP-COMPANY` → `ICC-COMPANY`
Itemmast	ITEMMAST	Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `ICP-ITEM` → `ITE-ITEM`

ICFGBYPROD – Finished Goods Byproduct

About ICFGBYPROD

Fields (6)

Indexes (2)

Relations

One to one (2) — lookups and parents

Programs

Updated by (3)

Referenced by (3)