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
|
