WHSHIPLINE

Shipment Line

The Shipment Line file contains shipment line records.

REFERENCED BY
IC216 POIG.1 RQ10.1 RQ10.4 RQ140 RQ44.1
RQ44.2 WH131 WH38.1 WH80.1 WH81.1 WH82.1


UPDATED BY
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 POIF.1 RQ270 RQ300
RQ35.1 RQD0.1 RQD1.1 WH126 WH130 WH132
WH140 WH190 WH20.2 WH20.7 WH222 WH224
WH25.1 WH25.2 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.7 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH34.5 WH40.1
WH40.2 WH520 WH830 WHD0.1 WHD2.1 WHD3.1
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHL-COMPANY
Element: Company		Numeric 4
This field contains the company number.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-SYSTEM-CD
Element: System Cd		Alpha 2
This field indicates from which Lawson system the document originated.
OE = Customer Order
RQ = Requisitions
CX = Case Cart
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-DOC-NBR
Element: Doc Nbr		Alpha 10 (Right Justified)
This field contains the document number assigned to this shipment line.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-SHIPMENT-NBR
Element: Shipment Nbr		Numeric 10
This field contains the shipment number. One document can have several shipment numbers if the items were not shipped at the same time.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the shipment line number.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-LINE-TYPE
Element: Line Type		Alpha 1
This field contains the type of item found on this shipment line.
I = Inventoried Item
N = Nonstock Item
X = Special Item
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field contains the description of the line item.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-LOCATION
Element: Location		Alpha 5
This field contains a valid stock location within the company inventory.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-PRINTED-QTY
Element: Quantity		Signed 13.4
This field contains the quantity that was printed on the pick list to be picked.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-TRAN-UOM
Element: Uom		Alpha 4
This field indicates the unit of measure from the document.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-TRAN-UOM-MULT
Element: Uom Mult		Signed 13.7
This field is the conversion factor to convert to stock unit of measure.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-IN-PROCESS-QTY
Element: In-Process Quantity		Signed 13.4
This field contains the in-process quantity, which is the shipment line quantity currently in process.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-SHIPPED-QTY
Element: Quantity		Signed 13.4
This field contains the quantity that was shipped in stock unit of measure. For catch weight items, the shipped quantity is in secondary unit of measure.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-DELIVERED-QTY
Element: Delivered Qty		Signed 13.4
This is the quantity that has been issued or transferred to the requesting location. This quantity is updated by PO221 (Delivery Ticket).
WHL-CATCH-WT-QTY
Element: Quantity		Signed 13.4
This field contains the catch weight quantity in stock unit of measure.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH34.5 WH40.1
WH40.2 WH520
WH830 WHD2.1
ZW130
WHL-PRE-ASMBLD-KIT
Element: Pre-Assembled Kit		Signed 13.4
This field contains the make-to-order kit quantity.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-KIT-COMP-QTY
Element: Quantity		Signed 13.4
This field contains the desired quantity.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-DETAIL-QTY
Element: Detail Quantity		Signed 13.4
This field shows the total quantity of details assigned to the shipment line.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WHD2.1
ZW130
WHL-DTL-CTW-QTY
Detail Catch Weight
Quantity		Signed 13.4
This field contains the catch weight quantity for shipment lines with details.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH34.5
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-DETAIL-REQ
Element: Detail Required		Alpha 1
This field indicates whether or not details are required for shipment lines.
Y = Yes
N = No
I = Interfaced
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-WALK-THRU-REQ
Element: Walk Thru Required		Alpha 1
This field indicates that a shipment line is out of balance.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH34.5
WH40.1 WH40.2
WH520 WH830
WHD3.1 ZW130
WHL-UNIT-COST
Element: Intl Cost		Signed 18.5
This field contains the unit cost of the shipment line.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-WEIGHT
Element: Weight		Signed 9.3
This field contains the shipment line's calculated weight based on the item master stock weight and the line's quantity in stock unit of measure.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-CUBIC-FEET
Element: Cubic Feet		Signed 9.3
This field contains the shipment line's calculated cubic measurement based on the item master stock cubic and the shipment line's quantity in stock unit of measure.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-MSDS-REQ-FL
Element: All Flag		Alpha 1
This field indicates if a Material Safety Data Sheet is required for the item of this shipment line. This flag is originally set at item master.
Y = Yes
N = No
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-MSDS-DT
Element: MSDS Date		Numeric 8 (yyyymmdd)
This field contains the date that a Material Safety Data Sheet is being sent to a customer ship to for this shipment line.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-MSDS-DOCUMENT
Element: Msds Document		Alpha 30
The document number that references the Material Safety Data Sheet that is being sent for this shipment line.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-MSDS-VERSION
Element: Msds Version		Alpha 4
The version number of the MSDS document that is being sent with this shipment line.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-OPR-CODE
Element: Opr Code		Alpha 10 (Lower Case)
This field contains the operator code or user ID of the person who last updated this record.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-UPDATE-DATE
Element: Update Date		Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-UPDATE-TIME
Element: Update Time		Numeric 6
This field contains the system time when the record was updated.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-FULL-VOID-FL
Element: Full Void Fl		Alpha 1
Indicates that shipment line has been voided. No quantities will be shipped from this line.
Y = Voided
N = Not Voided
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 ZW130
WHL-REQ-COMPANY
Element: Company		Numeric 4
This field contains the requesting company.
WHL-OPEN-QUANTITY
Element: Open Quantity		Derived
This field contains the total of the in-process quantity and the backorder quantity.
WHL-PARTIAL
Element: Partial		Derived
This field is used to help determine if a shipment is partial or not.
WHL-PARTIAL-VALUE
Element: Partial Value		Derived
This field indicates whether or not a shipment is partial.
WHL-SUPLMNTARY-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-SUPLMNTARY-QTY
Element: Quantity		Signed 13.4
This field contains the desired quantity.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-ICN-CODE
Element: Icn Code		Alpha 8
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-RQSRC-MACHINE
Element: Rqsrc Machine		Alpha 6
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130
WHL-PAR-ORDER-ID
Element: Par Order Id		Alpha 20
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ZW130


WHSHIPLINE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHLSET1 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
...
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 RQ300
WH126 WH130
WH131 WH132
WH140 WH190
WH20.7 WH222
WH224 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WHLSET2 COMPANY
SYSTEM-CD
DOC-NBR
LINE-NBR
SHIPMENT-NBR
...
POIF.1 POIG.1
RQ10.1 RQ10.4
RQ140 RQ270
RQ35.1 RQ44.1
RQ44.2 RQD0.1
RQD1.1 WH130
WH132 WH190
WH20.2 WH20.7
WH25.1 WH25.2
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WHLSET3 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
ITEM
Subset
Where(WALK-THRU-REQ ="Y")
...
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH38.1
WH40.1 WH40.2
WH520 WH830
WHLSET4 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
Subset
WhereDETAIL-REQ ="N"
WHLSET6 COMPANY
LOCATION
LINE-NBR
SHIPMENT-NBR
WH30.1 WH30.2
WH31.1 WH31.2
WH32.1 WH32.2
WH33.1 WH33.2
WH33.3 WH33.4
WH33.7 WH34.1
WH34.2 WH34.3
WH34.4
WHLSET7 COMPANY
LOCATION
ITEM
SHIPMENT-NBR
LINE-NBR
IC216 WH82.1


WHSHIPLINE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Caseline CXPREFITEM Required
When WHL-SYSTEM-CD ="CX"
WHL-COMPANY->CPI-COMPANY
WHS-REQ-LOCATION->CPI-REQ-LOCATION
WHL-DOC-NBR->CPI-CASE
WHL-LINE-NBR->CPI-IF-REF-NBR
Coline COLINE Required
When WHS-SYSTEM-CD ="OE"
WHL-COMPANY->COL-COMPANY
WDH-DOC-NBR-NUM->COL-ORDER-NBR
WHL-LINE-NBR->COL-LINE-NBR
Iccompany ICCOMPANY Required
WHL-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Required
WHL-COMPANY->ICL-COMPANY
WHL-LOCATION->ICL-LOCATION
Itemloc ITEMLOC Required
When WHL-LINE-TYPE ="I"
WHL-COMPANY->ITL-COMPANY
WHL-LOCATION->ITL-LOCATION
WHL-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
When WHL-LINE-TYPE ="I"
OrWHL-LINE-TYPE ="N"
ICC-ITEM-GROUP->ITE-ITEM-GROUP
WHL-ITEM->ITE-ITEM
Reqline REQLINE Required
When -SYSTEM-CD ="R"
WDM-REQ-COMPANY->RLN-COMPANY
WDM-DOC-NBR-NUM->RLN-REQ-NUMBER
WHL-LINE-NBR->RLN-LINE-NBR
Shipment WHSHIPMENT Required
WHL-COMPANY->WHS-COMPANY
WHL-LOCATION->WHS-LOCATION
WHL-SHIPMENT-NBR->WHS-SHIPMENT-NBR
Whdemand WHDEMAND Required
WHL-COMPANY->WDM-COMPANY
WHL-SYSTEM-CD->WDM-SYSTEM-CD
WHL-DOC-NBR->WDM-DOC-NBR
WHL-LINE-NBR->WDM-LINE-NBR
Zeroes->WDM-COMPONENT-SEQ
WHL-LOCATION->WDM-LOCATION
Whdemndhdr WHDEMNDHDR Required
WHL-COMPANY->WDH-COMPANY
WHL-SYSTEM-CD->WDH-SYSTEM-CD
WHL-DOC-NBR->WDH-DOC-NBR
Whwebtrack WHWEBTRACK Not Required
WHL-COMPANY->WST-COMPANY
WHL-LOCATION->WST-LOCATION
WHL-SHIPMENT-NBR->WST-SHIPMENT-NBR
WHL-LINE-NBR->WST-LINE-NBR
Whwhluf WHWHLUF Not Required
WHL-COMPANY->WLU-COMPANY
WHL-LOCATION->WLU-LOCATION
WHL-SHIPMENT-NBR->WLU-SHIPMENT-NBR
WHL-LINE-NBR->WLU-LINE-NBR


WHSHIPLINE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Atch Ser Recpt WHSHLDTL
Valid When ITE-SER-TRACK-FL ="R"
WHL-COMPANY->WHD-COMPANY
WHL-LOCATION->WHD-LOCATION
WHL-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHL-LINE-NBR->WHD-LINE-NBR
Zeroes->WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL
Attached Bins WHSHLDTL
Valid When ITE-LOT-TRACK-FL ="N"
AndITL-BIN-TRACK-FL ="Y"
AndITE-SER-TRACK-FL ="N"
WHL-COMPANY->WHD-COMPANY
WHL-LOCATION->WHD-LOCATION
WHL-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHL-LINE-NBR->WHD-LINE-NBR
Zeroes->WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL
Attached Lots WHSHLDTL
Valid When ITE-LOT-TRACK-FL ="Y"
WHL-COMPANY->WHD-COMPANY
WHL-LOCATION->WHD-LOCATION
WHL-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHL-LINE-NBR->WHD-LINE-NBR
Zeroes->WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL
Attached Sers WHSHLDTL
Valid When ITE-SER-TRACK-FL ="I"
WHL-COMPANY->WHD-COMPANY
WHL-LOCATION->WHD-LOCATION
WHL-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHL-LINE-NBR->WHD-LINE-NBR
Zeroes->WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL
Attached Uoms WHSHLDTL
Valid When SDT- =WHL-
AndITE-LOT-TRACK-FL ="N"
AndITE-SER-TRACK-FL ="N"
AndITL-BIN-TRACK-FL ="N"
WHL-COMPANY->WHD-COMPANY
WHL-LOCATION->WHD-LOCATION
WHL-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHL-LINE-NBR->WHD-LINE-NBR
Zeroes->WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL
Bins SOHDETAIL
Valid When ITE-LOT-TRACK-FL ="N"
AndITL-BIN-TRACK-FL ="Y"
AndITE-SER-TRACK-FL ="N"
WHL-COMPANY->SDT-COMPANY
WHL-LOCATION->SDT-LOCATION
WHL-ITEM->SDT-ITEM
  SDT-UOM
  SDT-LOT
  SDT-SUBLOT
  SDT-BIN
Itcomment ITCOMMENT
ICC-ITEM-GROUP->ICO-ITEM-GROUP
WHL-ITEM->ICO-ITEM
  ICO-LANGUAGE-CODE
  ICO-SEQ
Itserial ITSERIAL
Valid When ITE-SER-TRACK-FL ="R"
WHL-COMPANY->SER-COMPANY
WHL-ITEM->SER-ITEM
  SER-SERIAL
Itserials ITSERIAL
Valid When ITE-SER-TRACK-FL ="I"
WHL-COMPANY->SER-COMPANY
WHL-ITEM->SER-ITEM
  SER-SERIAL
Lots SOHDETAIL
Valid When ITE-LOT-TRACK-FL ="Y"
WHL-COMPANY->SDT-COMPANY
WHL-LOCATION->SDT-LOCATION
WHL-ITEM->SDT-ITEM
  SDT-UOM
  SDT-LOT
  SDT-SUBLOT
  SDT-BIN
Shiplnedtl WHSHLDTL
WHL-COMPANY->WHD-COMPANY
WHL-LOCATION->WHD-LOCATION
WHL-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHL-LINE-NBR->WHD-LINE-NBR
  WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL
Sohdetail SOHDETAIL
WHL-COMPANY->SDT-COMPANY
WHL-LOCATION->SDT-LOCATION
WHL-ITEM->SDT-ITEM
  SDT-UOM
  SDT-LOT
  SDT-SUBLOT
  SDT-BIN
Uoms SOHDETAIL
Valid When SDT- =WHL-
AndITE-LOT-TRACK-FL ="N"
AndITE-SER-TRACK-FL ="N"
AndITL-BIN-TRACK-FL ="N"
WHL-COMPANY->SDT-COMPANY
WHL-LOCATION->SDT-LOCATION
WHL-ITEM->SDT-ITEM
  SDT-UOM
  SDT-LOT
  SDT-SUBLOT
  SDT-BIN
Whshipcomp WHSHIPCOMP
WHL-COMPANY->WHC-COMPANY
WHL-LOCATION->WHC-LOCATION
WHL-SHIPMENT-NBR->WHC-SHIPMENT-NBR
WHL-LINE-NBR->WHC-LINE-NBR
  WHC-COMPONENT-SEQ
Whshlaud WHSHLAUD
WHL-COMPANY->WHA-COMPANY
WHL-LOCATION->WHA-LOCATION
WHL-SHIPMENT-NBR->WHA-SHIPMENT-NBR
WHL-LINE-NBR->WHA-LINE-NBR
  WHA-STATUS

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

Home
Contact Us



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