Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICFREEZE


                             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
Element: 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
Element: 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
Element: Page Number   This field contains the page number for   IC73.1  IC74.1
                       a count sheet.

ICF-LINE               Numeric 2                                 IC170   IC574
Element: 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
Element: Location Code This field contains the valid location    IC73.1  IC74.1
                       defined in IC02.1 (Location).

ICF-BIN-GROUP          Alpha 7                                   IC170
Element: 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
Element: 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
Element: 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
Element: Unit of MeasurThis 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
Element: 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
Element: Unit of MeasurThis field contains a valid unit of       IC72.1
                       measure for the item quantity.

ICF-FREEZE-QTY         Signed 13.4                               IC170   IC574
Element: 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
Element: 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
Element: Base Cost     This field contains the unit cost         IC574   IC73.1
                       defined for the item.                     IC74.1

ICF-SECONDARY-QTY      Signed 13.4                               IC170   IC574
Element: 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
Element: Quantity      This field contains the actual physical   IC73.1  IC74.1
                       inventory count based on the item's
                       secondary unit of measure.

ICF-SEC-UOM            Alpha 4                                   IC170   IC574
Element: Unit of MeasurFor catch weight items, this is the       IC72.1  IC73.1
                       secondary unit of measure defined in      IC74.1
                       IC11.1 (Item Master).

ICF-SEC-UOM-MULT       Signed 13.7                               IC574   IC72.1
Unit of Measure        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
Accounts Receivable    This field contains a reason code used    IC72.1  IC73.1
Code                   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
Element: 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
Element: Operator Code This field contains the terminal sign     IC74.1
                       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-BIN-SEQ

Sohdetail      SOHDETAIL

                            ICF-COMPANY       -> SDT-COMPANY
                            ICF-LOCATION      -> SDT-LOCATION
                            ICF-ITEM          -> SDT-ITEM
                                                 SDT-UOM
                                                 SDT-LOT
                                                 SDT-SUBLOT
                                                 SDT-BIN