ICFREEZE

Physical Inven Freeze Record

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

REFERENCED BY
IC270 IC70.1 IC95.3 IC15.2


UPDATED BY
IC170 IC175 IC179 IC574 IC72.1 IC73.1
IC74.1 IC76.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICF-COMPANY
Element: 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
Element: 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
Element: Page		Numeric 4
This field contains the page number for a count sheet.
IC170 IC574
IC73.1 IC74.1
ICF-LINE
Element: Line		Numeric 2
This field contains a line number for an item on a count sheet.
IC170 IC574
IC73.1 IC74.1
ICF-LOCATION
Element: Location		Alpha 5
This field contains the valid location defined in IC02.1 (Location).
IC170 IC574
IC73.1 IC74.1
ICF-BIN-GROUP
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Uom		Alpha 4
This field contains a valid unit of measure for the item quantity.
IC170 IC574
IC72.1
ICF-FREEZE-QTY
Element: 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
Element: Quantity		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
Element: Intl Cost		Signed 18.5
This field contains the unit cost defined for the item.
IC170 IC175
IC574 IC73.1
IC74.1
ICF-SECONDARY-QTY
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Operator		Alpha 10
This field contains the terminal sign on identifier when the count quantity was entered.
IC72.1 IC73.1
IC74.1


ICFREEZE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICFSET1 COMPANY
SELECT-ID
PAGE
LINE
IC170 IC175
IC270 IC574
IC70.1 IC72.1
IC73.1 IC74.1
IC76.1 IC95.3
ICFSET2 COMPANY
SELECT-ID
LOCATION
ITEM
BIN
LOT-SERIAL
UOM
IC15.2 IC170
IC175 IC179
IC574 IC74.1


ICFREEZE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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


ICFREEZE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Thu Jun 09 02:18:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.