|
|
ICFREEZE FILE
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 Numeric 4 IC170 IC574
Company The company number represents an IC73.1 IC74.1
established company and is entered on
all function codes.
ICF-SELECT-ID Alpha 5 IC170 IC574
Select ID This field is user-defined and IC73.1 IC74.1
identifies groups of items and item
selection criteria for physical
inventory counts. This field can be used
cyclically.
ICF-PAGE Numeric 4 IC170 IC574
Page Number This field contains the page number for IC73.1 IC74.1
a count sheet.
ICF-LINE Numeric 2 IC170 IC574
Line Number This field contains a line number for IC73.1 IC74.1
an item on a count sheet.
ICF-LOCATION Alpha 5 IC170 IC574
Location Code This field contains the valid location IC73.1 IC74.1
defined in IC02.1 (Location).
ICF-BIN-GROUP Alpha 7 IC170
Bin Group 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).
ICF-BIN Alpha 7 IC170 IC574
Bin This field contains a storage area for IC73.1 IC74.1
an item or any number of items.
ICF-ITEM Alpha 32 IC170 IC574
Item Number This field contains an item number IC73.1 IC74.1
identified for physical inventory count
by a select ID.
ICF-UOM Alpha 4 IC170 IC574
Unit of Measure This field contains the stock unit of IC72.1 IC73.1
measure defined for the item in IC11.1 IC74.1
(Item Master).
ICF-LOT-SERIAL Alpha 16 IC170 IC574
Lot/Serial Number This field contains the item's lot, IC73.1 IC74.1
sublot, or serial number, depending on
whether the item is set up for lot or
serial number tracking in IC11.1 (Item
Master).
ICF-ENTERED-UOM Alpha 4 IC170 IC574
Entered Unit of This field contains a valid unit of IC72.1
Measure measure for the item quantity.
ICF-FREEZE-QTY Signed 13.4 IC170 IC574
Freeze Quantity This field contains the stock-on-hand IC74.1
quantity when the item was selected in
IC170 (Freeze Selected Items). This
number is automatically assigned.
ICF-COUNT-QTY Signed 13.4 IC170 IC574
Count Quantity This field contains the count of the IC72.1 IC73.1
actual physical inventory based on the IC74.1
item's stock unit of measure.
ICF-UNIT-COST Signed 13.5 IC170 IC175
Unit Cost This field contains the unit cost IC574 IC73.1
defined for the item. IC74.1
ICF-SECONDARY-QTY Signed 13.4 IC170 IC574
Secondary Quantity 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.
ICF-SEC-COUNT-QTY Signed 13.4 IC574 IC72.1
Secondary Count This field contains the actual physical IC73.1 IC74.1
Quantity inventory count based on the item's
secondary unit of measure.
ICF-SEC-UOM Alpha 4 IC170 IC574
Secondary Unit of For catch weight items, this is the IC72.1 IC73.1
Measure secondary unit of measure defined in IC74.1
IC11.1 (Item Master).
ICF-SEC-UOM-MULT Signed 13.7 IC574 IC72.1
Secondary UOM For catch weight items, this field IC74.1
Multiplier contains the secondary unit of measure
multiplier. It is used to convert the
stock-on-hand quantity to the secondary
quantity or visa versa.
ICF-REASON-CODE Alpha 4 IC170 IC574
Reason Code This field contains a reason code used IC72.1 IC73.1
to explain variances found between the IC74.1 IC76.1
system count and actual physical
inventory count. This reason code is
defined in IC17.1 (Reason Codes).
ICF-MOVEX-CLASS Alpha 1 IC170 IC574
Movement Class/Spec This field contains the movement class IC74.1
Cycle Cnt 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
ICF-STATUS Numeric 1 IC170 IC574
Status This field contains the current IC72.1 IC73.1
processing status. IC74.1
0 = Freeze Record Not Responded To
1 = Count Entered
ICF-OPERATOR-ID Alpha 10 IC72.1 IC73.1
Operator This field contains the terminal sign IC74.1
Identification Code on identifier when the count quantity
was entered.
ICFREEZE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICFSET1 COMPANY IC170 IC175
SELECT-ID IC270 IC574
PAGE IC70.1 IC72.1
LINE IC73.1 IC74.1
IC76.1 IC95.3
ICFSET2 COMPANY IC15.2 IC170
SELECT-ID IC175 IC179
LOCATION IC574 IC74.1
ITEM
BIN
LOT-SERIAL
UOM
ICFREEZE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bingrpdtl BINGRPDTL
ICF-COMPANY -> BGD-COMPANY
ICF-LOCATION -> BGD-LOCATION
ICF-BIN-GROUP -> BGD-BIN-GROUP
BGD-SEQ
Sohdetail SOHDETAIL
ICF-COMPANY -> SDT-COMPANY
ICF-LOCATION -> SDT-LOCATION
ICF-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
|