|
|
ICCPHYINV FILE
UPDATED BY
IC57.1 IC574
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPI-COMPANY Numeric 4 IC57.1
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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
Element: Reason Code This field contains the reason 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 18.5 IC57.1
Element: Intl 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
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
|
