|
WHSHIPLINE FILE
Shipment Line
The Shipment Line file contains shipment line records.
REFERENCED BY
BL120 BL122 BL123 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
WH126 WH131 WH140 WH20.7 WH20.2 WH224
WH38.1 WH80.1 WH81.1 POIF.1 POIG.1 RQ10.1
RQ140 RQ35.1 RQ44.1 RQ44.2 RQD0.1 RQD1.1
WH25.1 WH25.2 WH82.1
UPDATED BY
BL92.1 RQ300 WH130 WH132 WH190 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHL-COMPANY Numeric 4 BL92.1 WH130
Element: Company This field contains the company number. 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
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
WHL-SYSTEM-CD Alpha 2 BL92.1 WH130
Element: System Cd This field indicates from which Lawson WH132 WH190
system the document originated. WH30.1 WH30.2
OE = Customer Order WH30.3 WH30.4
RQ = Requisitions WH31.1 WH31.2
CX = Case Cart WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-DOC-NBR Alpha 10 (Right Justified) BL92.1 WH130
Element: Doc Nbr This field contains the document number WH132 WH190
assigned to this shipment line. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-SHIPMENT-NBR Numeric 10 BL92.1 WH130
Element: Shipment Nbr This field contains the shipment WH132 WH190
number. One document can have several WH30.1 WH30.2
shipment numbers if the items were not WH30.3 WH30.4
shipped at the same time. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-LINE-NBR Numeric 6 BL92.1 WH130
Element: Line Nbr This field contains the shipment line WH132 WH190
number. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-LINE-TYPE Alpha 1 BL92.1 WH130
Element: Line Type This field contains the type of item WH132 WH190
found on this shipment line. WH30.1 WH30.2
I = Inventoried Item WH30.3 WH30.4
N = Nonstock Item WH31.1 WH31.2
X = Special Item WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-ITEM Alpha 32 BL92.1 WH130
Element: Item This field contains the item WH132 WH190
identifier. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-DESCRIPTION Alpha 30 (Lower Case) BL92.1 WH130
Element: Description This field contains the description of WH132 WH190
the line item. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-LOCATION Alpha 5 BL92.1 WH130
Element: Location This field contains a valid stock WH132 WH190
location within the company inventory. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-PRINTED-QTY Signed 13.4 BL92.1 WH130
Element: Quantity This field contains the quantity that WH132 WH190
was printed on the pick list to be WH30.1 WH30.2
picked. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-TRAN-UOM Alpha 4 BL92.1 WH130
Element: Uom This field indicates the unit of WH132 WH190
measure from the document. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-TRAN-UOM-MULT Signed 13.7 BL92.1 WH130
Element: Uom Mult This field is the conversion factor to WH132 WH190
convert to stock unit of measure. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-IN-PROCESS-QTY Signed 13.4 BL92.1 WH130
Element: In-Process QuaThis field contains the in-process WH132 WH190
quantity, which is the shipment line WH30.1 WH30.2
quantity currently in process. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-SHIPPED-QTY Signed 13.4 BL92.1 WH130
Element: Quantity This field contains the quantity that WH132 WH190
was shipped in stock unit of measure. WH30.1 WH30.2
For catch weight items, the shipped WH30.3 WH30.4
quantity is in secondary unit of WH31.1 WH31.2
measure. WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-DELIVERED-QTY Signed 13.4
Element: Delivered Qty 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 Signed 13.4 BL92.1 WH130
Element: Quantity This field contains the catch weight WH132 WH190
quantity in stock unit of measure. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-PRE-ASMBLD-KIT Signed 13.4 BL92.1 WH130
Element: Pre-Assembled This field contains the make-to-order WH132 WH190
kit quantity. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-KIT-COMP-QTY Signed 13.4 BL92.1 WH130
Element: Quantity This field contains the desired WH132 WH190
quantity. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-DETAIL-QTY Signed 13.4 BL92.1 WH130
Element: Detail QuantitThis field shows the total quantity of WH132 WH190
details assigned to the shipment line. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-DTL-CTW-QTY Signed 13.4 BL92.1 WH130
Detail Catch Weight This field contains the catch weight WH132 WH190
Quantity quantity for shipment lines with WH30.1 WH30.2
details. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-DETAIL-REQ Alpha 1 BL92.1 WH130
Element: Detail RequireThis field indicates whether or not WH132 WH190
details are required for shipment lines. WH30.1 WH30.2
Y = Yes WH30.3 WH30.4
N = No WH31.1 WH31.2
I = Interfaced WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-WALK-THRU-REQ Alpha 1 BL92.1 WH130
Element: Walk Thru RequThis field indicates that a shipment WH132 WH190
line is out of balance. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-UNIT-COST Signed 18.5 BL92.1 WH130
Element: Intl Cost This field contains the unit cost of WH132 WH190
the shipment line. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-WEIGHT Signed 9.3 BL92.1 WH130
Element: Weight This field contains the shipment line's WH132 WH190
calculated weight based on the item WH30.1 WH30.2
master stock weight and the line's WH30.3 WH30.4
quantity in stock unit of measure. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-CUBIC-FEET Signed 9.3 BL92.1 WH130
Element: Cubic Feet This field contains the shipment line's WH132 WH190
calculated cubic measurement based on WH30.1 WH30.2
the item master stock cubic and the WH30.3 WH30.4
shipment line's quantity in stock unit WH31.1 WH31.2
of measure. WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-MSDS-REQ-FL Alpha 1 BL92.1 WH130
Element: All Flag This field indicates if a Material WH132 WH190
Safety Data Sheet is required for the WH30.1 WH30.2
item of this shipment line. This flag is WH30.3 WH30.4
originally set at item master. WH31.1 WH31.2
Y = Yes WH31.3 WH31.4
N = No WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-MSDS-DT Numeric 8 (yyyymmdd) BL92.1 WH130
Element: MSDS Date This field contains the date that a WH132 WH190
Material Safety Data Sheet is being sent WH30.1 WH30.2
to a customer ship to for this shipment WH30.3 WH30.4
line. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-MSDS-DOCUMENT Alpha 30 BL92.1 WH130
Element: Msds Document The document number that references the WH132 WH190
Material Safety Data Sheet that is being WH30.1 WH30.2
sent for this shipment line. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-MSDS-VERSION Alpha 4 BL92.1 WH130
Element: Msds Version The version number of the MSDS document WH132 WH190
that is being sent with this shipment WH30.1 WH30.2
line. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-OPR-CODE Alpha 10 (Lower Case) BL92.1 WH130
Element: Opr Code This field contains the operator code WH132 WH190
or user ID of the person who last WH30.1 WH30.2
updated this record. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 WH130
Element: Update Date This field contains the date the record WH132 WH190
was updated. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-UPDATE-TIME Numeric 6 BL92.1 WH130
Element: Update Time This field contains the system time WH132 WH190
when the record was updated. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-FULL-VOID-FL Alpha 1 BL92.1 WH130
Element: Full Void Fl Indicates that shipment line has been WH132 WH190
voided. No quantities will be shipped WH30.1 WH30.2
from this line. WH30.3 WH30.4
Y = Voided WH31.1 WH31.2
N = Not Voided WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-REQ-COMPANY Numeric 4
Element: Company This field contains the requesting
company.
WHL-OPEN-QUANTITY Derived
Element: Open Quantity This field contains the total of the
in-process quantity and the backorder
quantity.
WHL-PARTIAL Derived
Element: Partial This field is used to help determine if
a shipment is partial or not.
WHL-PARTIAL-VALUE Derived
Element: Partial Value This field indicates whether or not a
shipment is partial.
WHL-SUPLMNTARY-UOM Alpha 4 BL92.1 WH130
Element: Uom This field contains the valid stock WH132 WH190
unit of measure for this item. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-SUPLMNTARY-QTY Signed 13.4 BL92.1 WH130
Element: Quantity This field contains the desired WH132 WH190
quantity. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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
WHL-ICN-CODE Alpha 8 BL92.1 WH130
Element: Icn Code 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
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
WHL-RQSRC-MACHINE Alpha 6 BL92.1 WH130
Element: Rqsrc Machine 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
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
WHL-PAR-ORDER-ID Alpha 20 BL92.1 WH130
Element: Par Order Id 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
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
WHSHIPLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHLSET1 COMPANY BL120 BL122
LOCATION BL123 BL130
SHIPMENT-NBR BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 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
...
WHLSET2 COMPANY BL120 BL122
SYSTEM-CD BL130 BL20.1
DOC-NBR BL20.3 BL21.2
LINE-NBR BL21.5 BL29.1
SHIPMENT-NBR BL29.2 BL520
BL820 BL92.1
POIF.1 POIG.1
RQ10.1 RQ140
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
...
WHLSET3 COMPANY Subset BL92.1 WH130
LOCATION Where (WALK-THRU-REQ = "Y" ) WH132 WH190
SHIPMENT-NBR WH30.1 WH30.2
LINE-NBR WH30.3 WH30.4
ITEM WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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 Subset
LOCATION Where DETAIL-REQ = "N"
SHIPMENT-NBR
LINE-NBR
WHLSET6 COMPANY WH30.1 WH30.2
LOCATION WH31.1 WH31.2
LINE-NBR WH32.1 WH32.2
SHIPMENT-NBR WH33.1 WH33.2
WH33.3 WH33.4
WH33.7 WH34.1
WH34.2 WH34.3
WH34.4
WHLSET7 COMPANY WH82.1
LOCATION
ITEM
SHIPMENT-NBR
LINE-NBR
WHSHIPLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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"
Or WHL-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 RELATED
NAME 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"
And ITL-BIN-TRACK-FL = "Y"
And ITE-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-
And ITE-LOT-TRACK-FL = "N"
And ITE-SER-TRACK-FL = "N"
And ITL-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"
And ITL-BIN-TRACK-FL = "Y"
And ITE-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-
And ITE-LOT-TRACK-FL = "N"
And ITE-SER-TRACK-FL = "N"
And ITL-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
|