Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ICCPHYINV FILE

UPDATED BY

IC57.1    IC574

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


IPI-SELECT-ID        Alpha 5                                     IC57.1
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
Location Code        This field contains a valid stocking
                     location within the company inventory.

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

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

IPI-COUNT-QTY        Signed 13.4                                 IC57.1  IC574
Count Quantity

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

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

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

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

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

IPI-SERIAL           Alpha 16                                    IC57.1
Serial Number

IPI-UNIT-COST        Signed 13.5                                 IC57.1
Unit Cost            This field contains the unit cost.

IPI-SEC-COUNT-QTY    Signed 13.4                                 IC57.1
Secondary Count      This is the quantity counted for the
Quantity             secondary quantity.

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

IPI-RECORD-ERROR     Alpha 1                                     IC57.1  IC574
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