|
|
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
|
