Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICCPHYINV


                             ICCPHYINV FILE

UPDATED BY

IC57.1    IC574

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IPI-COMPANY            Numeric 4                                 IC57.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

IPI-SELECT-ID          Alpha 5                                   IC57.1
Element: Select ID     Corresponds to the set of parameters
                       entered for the selection of items for
                       a physical inventory count.

IPI-LOCATION           Alpha 5                                   IC57.1
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

IPI-ITEM               Alpha 32                                  IC57.1
Element: Item Number   This field contains the item
                       identifier.

IPI-SEQ-TRNS-NBR       Numeric 10                                IC57.1
Element: Seq Trns Nbr

IPI-COUNT-QTY          Signed 13.4                               IC57.1  IC574
Element: Quantity

IPI-COUNT-UOM          Alpha 4                                   IC57.1  IC574
Element: Count Uom

IPI-REASON-CODE        Alpha 4                                   IC57.1
Accounts Receivable    This field contains the reason code,
Code                   which indicates the cause for credit
                       memos.

IPI-BIN                Alpha 7                                   IC57.1  IC574
Element: Bin           This field contains a storage area for
                       an item or any number of items.

IPI-LOT-NBR            Alpha 10                                  IC57.1
Element: Lot Nbr

IPI-SUBLOT-NBR         Alpha 6                                   IC57.1
Element: Sublot Nbr

IPI-SERIAL             Alpha 16                                  IC57.1
Element: Serial Number

IPI-UNIT-COST          Signed 13.5                               IC57.1
Element: Base Cost

IPI-SEC-COUNT-QTY      Signed 13.4                               IC57.1
Element: Quantity

IPI-NEW-RECORD         Alpha 1                                   IC57.1  IC574
Element: New Record

IPI-RECORD-ERROR       Alpha 1                                   IC57.1  IC574
Element: Record Error

                         ICCPHYINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IPISET1   COMPANY                                                IC57.1  IC574
          SELECT-ID
          LOCATION
          ITEM
          SEQ-TRNS-NBR

IPISET2   COMPANY       Subset                                   IC57.1
          SELECT-ID     Where RECORD-ERROR = "Y"
          LOCATION
          ITEM
          SEQ-TRNS-NBR
          RECORD-ERROR