|
|
WHSHLINEIN FILE
UPDATED BY
WH52.1 WH520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WLI-COMPANY Numeric 4 WH52.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.
WLI-LOCATION Alpha 5 WH52.1
Element: Location Code This field contains a valid stocking
location within the company inventory.
WLI-SHIPMENT-NBR Numeric 10 WH52.1
Element: Shipment NumbeThis 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 WH52.1
Element: Line Number This field contains the line number.
WLI-PROCESS-DATE Numeric 8 (yyyymmdd) WH52.1
Element: Process Date
WLI-UPDATE-TIME Numeric 6 WH52.1
Element: Update Time This field contains the system time
when the record was updated.
WLI-ITEM Alpha 32 WH52.1
Element: Item Number This field contains the item
identifier.
WLI-LINE-TYPE Alpha 1 WH52.1
Element: Line Type This field contains the type of
inventory on this line.
WLI-STOCK-UOM Alpha 4 WH52.1
Element: Unit of MeasurThis is the stock unit of measure for
the item.
WLI-TRAN-UOM Alpha 4 WH52.1
Element: Unit of Measure
WLI-TRAN-UOM-MULT Signed 13.7 WH52.1
Unit of Measure
Multiplier
WLI-IN-PROCESS-QTY Signed 13.4 WH52.1
Element: Quantity
WLI-SHIPPED-QTY Signed 13.4 WH52.1
Element: Quantity
WLI-CATCH-WT-QTY Signed 13.4 WH52.1
Element: Quantity This field contains the quantity
received for catch weight shipments.
WLI-PRE-ASMBLD-KIT Signed 13.4 WH52.1
Element: Pre Asmbld Kit
WLI-DETAIL-QTY Signed 13.4 WH52.1
Element: Quantity 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 WH52.1
Element: Quantity
WLI-UNIT-COST Signed 18.5 WH52.1
Element: Intl Cost This field contains the unit cost.
WLI-WEIGHT Signed 9.3 WH52.1
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
WLI-CUBIC-FEET Signed 9.3 WH52.1
Element: Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
WLI-MSDS-DT Numeric 8 (yyyymmdd) WH52.1
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 WH52.1 WH52.2
LOCATION WH52.3 WH520
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
|
