WHSHLINEIN

UPDATED BY
WH52.1 WH520

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WLI-COMPANY
Element: Company
Numeric 4
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.
WH52.1
WLI-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
WH52.1
WLI-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
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.
WH52.1
WLI-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
WH52.1
WLI-PROCESS-DATE
Element: Process Date
Numeric 8 (yyyymmdd)
WH52.1
WLI-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
WH52.1
WLI-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
WH52.1
WLI-LINE-TYPE
Element: Line Type
Alpha 1
This field contains the type of inventory on this line.
WH52.1
WLI-STOCK-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
WH52.1
WLI-TRAN-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
WH52.1
WLI-TRAN-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
WH52.1
WLI-IN-PROCESS-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
WH52.1
WLI-SHIPPED-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
WH52.1
WLI-CATCH-WT-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
WH52.1
WLI-PRE-ASMBLD-KIT
Element: Pre Asmbld Kit
Signed 13.4
WH52.1
WLI-DETAIL-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
WH52.1
WLI-DTL-CTW-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
WH52.1
WLI-UNIT-COST
Element: Intl Cost
Signed 18.5
WH52.1
WLI-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
WH52.1
WLI-CUBIC-FEET
Element: Cubic Feet
Signed 9.3
This field contains the unit cubic feet of the item based on the stocking UOM.
WH52.1
WLI-MSDS-DT
Element: Msds Dt
Numeric 8 (yyyymmdd)
This date is the date that a new Material Safety Data Sheet should be sent from the vendor.
WH52.1


WHSHLINEIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WLISET1 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
WH52.1 WH52.2
WH52.3 WH520
WLISET2 COMPANY
LOCATION
PROCESS-DATE
SHIPMENT-NBR
LINE-NBR


WHSHLINEIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:30:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.