ICFREEZE – Physical Inven Freeze Record

System: Inventory Control (IC)
Prefix: ICF
Primary key: COMPANY, SELECT-ID, PAGE, LINE
Fields: 22
Updated by: 8 programs
Referenced by: 4 programs

ICFREEZE is the Physical Inven Freeze Record table in Lawson Inventory Control (prefix ICF). It is indexed by COMPANY, SELECT-ID, PAGE, LINE (ICFSET1); alternate indexes: ICFSET2. It is related 1:1 to BINGROUP, ICCOMPANY, ITEMLOC, ITEMMAST, ITSERIAL and ICSELECT and 1:M to BINGRPDTL and SOHDETAIL. It is updated by IC170, IC175, IC179, IC574, IC72.1, IC73.1, IC74.1 and IC76.1 and referenced by IC15.2, IC270, IC70.1 and IC95.3. The table has 22 fields, 2 indexes and 8 documented relations.

About ICFREEZE

ICFREEZE records contain detailed information of the item stock-on-hand quantity. ICFREEZE is the control record for the physical inventory counting process.

Fields (22)

Column = COBOL field name without the ICF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ICF-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.	IC170, IC574, IC73.1, IC74.1
`ICF-SELECT-ID` PK SELECT_ID	Alpha 5	This field is user-defined and identifies groups of items and item selection criteria for physical inventory counts. This field can be used cyclically.	IC170, IC574, IC73.1, IC74.1
`ICF-PAGE` PK PAGE	Numeric 4	This field contains the page number for a count sheet.	IC170, IC574, IC73.1, IC74.1
`ICF-LINE` PK LINE	Numeric 2	This field contains a line number for an item on a count sheet.	IC170, IC574, IC73.1, IC74.1
`ICF-LOCATION` LOCATION	Alpha 5	This field contains the valid location defined in IC02.1 (Location).	IC170, IC574, IC73.1, IC74.1
`ICF-BIN-GROUP` BIN_GROUP	Alpha 7	This field contains the group of bins defined in IC15.3 (Bin Groups). Bins are set up in IC15.2 (Bins) and assigned to items set up for bin tracking in IC12.1 (Item Location) or IC10.2 (Item Master and Location).	IC170
`ICF-BIN` BIN	Alpha 7	This field contains a storage area for an item or any number of items.	IC170, IC574, IC73.1, IC74.1
`ICF-ITEM` ITEM	Alpha 32	This field contains an item number identified for physical inventory count by a select ID.	IC170, IC574, IC73.1, IC74.1
`ICF-UOM` UOM	Alpha 4	This field contains the stock unit of measure defined for the item in Item Master (IC11.1).	IC170, IC574, IC72.1, IC73.1, IC74.1
`ICF-LOT-SERIAL` LOT_SERIAL	Alpha 16	This field contains the item's lot, sublot, or serial number, depending on whether the item is set up for lot or serial number tracking in IC11.1 (Item Master).	IC170, IC574, IC73.1, IC74.1
`ICF-ENTERED-UOM` ENTERED_UOM	Alpha 4	This field contains a valid unit of measure for the item quantity.	IC170, IC574, IC72.1
`ICF-FREEZE-QTY` FREEZE_QTY	Signed 13.4	This field contains the stock-on-hand quantity when the item was selected in IC170 (Freeze Selected Items). This number is automatically assigned.	IC170, IC574, IC74.1
`ICF-COUNT-QTY` COUNT_QTY	Signed 13.4	This field contains the count of the actual physical inventory based on the item's stock unit of measure.	IC170, IC574, IC72.1, IC73.1, IC74.1
`ICF-UNIT-COST` UNIT_COST	Signed 18.5	This field contains the unit cost defined for the item.	IC170, IC175, IC574, IC73.1, IC74.1
`ICF-SECONDARY-QTY` SECONDARY_QTY	Signed 13.4	For catch weight items, this field contains the item's secondary unit of measure quantity when selected in IC170 (Freeze Selected Items). This quantity is for reference purposes only.	IC170, IC574
`ICF-SEC-COUNT-QTY` SEC_COUNT_QTY	Signed 13.4	This field contains the actual physical inventory count based on the item's secondary unit of measure.	IC574, IC72.1, IC73.1, IC74.1
`ICF-SEC-UOM` SEC_UOM	Alpha 4	For catch weight items, this is the secondary unit of measure defined in Item Master (IC11.1).	IC170, IC574, IC72.1, IC73.1, IC74.1
`ICF-SEC-UOM-MULT` SEC_UOM_MULT	Signed 13.7	For catch weight items, this field contains the secondary unit of measure multiplier. It is used to convert the stock-on-hand quantity to the secondary quantity or visa versa.	IC574, IC72.1, IC74.1
`ICF-REASON-CODE` REASON_CODE	Alpha 4	This field contains a reason code used to explain variances found between the system count and actual physical inventory count. This reason code is defined in IC17.1 (Reason Codes).	IC170, IC574, IC72.1, IC73.1, IC74.1, IC76.1
`ICF-MOVEX-CLASS` MOVEX_CLASS	Alpha 1	This field contains the movement class code (1, 2 or 3) defined for the item in IC12.1 (Item Location) or IC10.2 (Item Master and Location). `1` Class 1 `2` Class 2 `3` Class 3 `X` Special Cycle Count	IC170, IC574, IC74.1
`ICF-STATUS` STATUS	Numeric 1	This field contains the current processing status. `0` Freeze Record Not Responded To `1` Count Entered	IC170, IC574, IC72.1, IC73.1, IC74.1
`ICF-OPERATOR-ID` OPERATOR_ID	Alpha 10	This field contains the terminal sign on identifier when the count quantity was entered.	IC72.1, IC73.1, IC74.1

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
`ICFSET1`	`COMPANY`, `SELECT-ID`, `PAGE`, `LINE`	Primary		IC170, IC175, IC270, IC574, IC70.1, IC72.1, IC73.1, IC74.1 +2 more
`ICFSET2`	`COMPANY`, `SELECT-ID`, `LOCATION`, `ITEM`, `BIN`, `LOT-SERIAL`, `UOM`			IC15.2, IC170, IC175, IC179, IC574, IC74.1

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Bingroup	BINGROUP	Required	`ICF-COMPANY` → `BGR-COMPANY`, `ICF-LOCATION` → `BGR-LOCATION`, `ICF-BIN-GROUP` → `BGR-BIN-GROUP`
Company	ICCOMPANY	Required	`ICF-COMPANY` → `ICC-COMPANY`
Itemloc	ITEMLOC	Required	`ICF-COMPANY` → `ITL-COMPANY`, `ICF-LOCATION` → `ITL-LOCATION`, `ICF-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Required	`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `ICF-ITEM` → `ITE-ITEM`
Itserial	ITSERIAL	Not Required, Delete Cascades	`ICF-COMPANY` → `SER-COMPANY`, `ICF-ITEM` → `SER-ITEM`, `ICF-LOT-SERIAL` → `SER-SERIAL`
Selectid	ICSELECT	Required	`ICF-COMPANY` → `ICS-COMPANY`, `ICF-SELECT-ID` → `ICS-SELECT-ID`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Bingrpdtl	BINGRPDTL			`ICF-COMPANY` → `BGD-COMPANY`, `ICF-LOCATION` → `BGD-LOCATION`, `ICF-BIN-GROUP` → `BGD-BIN-GROUP`, → `BGD-BIN-SEQ`
Sohdetail	SOHDETAIL			`ICF-COMPANY` → `SDT-COMPANY`, `ICF-LOCATION` → `SDT-LOCATION`, `ICF-ITEM` → `SDT-ITEM`, → `SDT-UOM`, → `SDT-LOT`, → `SDT-SUBLOT`, → `SDT-BIN`

Programs

Updated by (8)

IC170 Freeze Selected Items
IC175 Update Variances
IC179 Delete Freeze Records
IC574 Physical Inventory Interface
IC72.1 Counts by Page
IC73.1 Count Detail
IC74.1 Random Counts
IC76.1 Variance Reasons

Referenced by (4)

IC15.2 Bins
IC270 Count Sheets
IC70.1 Select IDs
IC95.3 Catch Weight