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
WLI-GLBL-LINE-TYPE
Element: Glbl Line Type		Alpha 15
WH52.1
WLI-WHL-USR-FLD-01
Element: Whl Usr Fld 01		Alpha 20
WH52.1
WLI-WHL-USR-FLD-02
Element: Whl Usr Fld 02		Alpha 20
WH52.1
WLI-WHL-USR-FLD-03
Element: Whl Usr Fld 03		Alpha 20
WH52.1
WLI-WHL-USR-FLD-04
Element: Whl Usr Fld 04		Alpha 20
WH52.1
WLI-WHL-USR-FLD-05
Element: Whl Usr Fld 05		Alpha 20
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 02:33:57 2016

Home
Contact Us



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