WHSHLINEIN FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WLI-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
WLI-LOCATION Alpha 5
Location Code This field contains a valid stocking
location within the company inventory.
WLI-SHIPMENT-NBR Numeric 10
Shipment Number This field contains the shipment
number. One order can have several
shipment numbers if the items of the
order were not shipped at the same time.
WLI-LINE-NBR Numeric 6
Line Number This field contains the line number.
WLI-PROCESS-DATE Numeric 8 (yyyymmdd)
Process Date
WLI-UPDATE-TIME Numeric 6
Update Time This field contains the system time
when the record was updated.
WLI-ITEM Alpha 32
Item Number This field contains the item
identifier.
WLI-LINE-TYPE Alpha 1
Line Type This field contains the type of
inventory on this line.
WLI-STOCK-UOM Alpha 4
Stocking Unit of This is the stock unit of measure for
Measure the item.
WLI-TRAN-UOM Alpha 4
Transaction Unit of
Measure
WLI-TRAN-UOM-MULT Signed 13.7
Transaction UOM
Multiplier
WLI-IN-PROCESS-QTY Signed 13.4
In Process Qty
WLI-SHIPPED-QTY Signed 13.4
Shipped Quantity
WLI-CATCH-WT-QTY Signed 13.4
Catch Weight This field contains the quantity
Quantity received for catch weight shipments.
WLI-PRE-ASMBLD-KIT Signed 13.4
Pre Asmbld Kit
WLI-DETAIL-QTY Signed 13.4
Detail Qty This field shows the total quantity of
details defined for a detail tracked
item. It is matched against the line
quantity field to determine if details
are in balance.
In the item detail screen, it is the
quantity for a particular lot or bin.
WLI-DTL-CTW-QTY Signed 13.4
Dtl Ctw Qty
WLI-UNIT-COST Signed 13.5
Unit Cost This field contains the unit cost.
WLI-WEIGHT Signed 9.3
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
WLI-CUBIC-FEET Signed 9.3
Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
WLI-MSDS-DT Numeric 8 (yyyymmdd)
Material Safety This date is the date that a new
DataSheet Date Material Safety Data Sheet should be
sent from the vendor.
WHSHLINEIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WLISET1 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
WLISET2 COMPANY
LOCATION
PROCESS-DATE
SHIPMENT-NBR
LINE-NBR
WHSHLINEIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whshpmntin WHSHPMNTIN Required
WLI-COMPANY -> WSI-COMPANY (WSISET1)
WLI-LOCATION -> WSI-LOCATION
WLI-SHIPMENT-NBR -> WSI-SHIPMENT-NBR
WHSHLINEIN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whslcrtnin WHSLCRTNIN
WLI-COMPANY -> WCL-COMPANY
WLI-LOCATION -> WCL-LOCATION
WLI-SHIPMENT-NBR -> WCL-SHIPMENT-NBR
WLI-LINE-NBR -> WCL-SHIP-LINE-NBR
WCL-CARTON-NBR
|
