Lawson Insight Technical Documentation |
|
WHSHIPLINE
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
OE129 OE229 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE81.1
OE830 OE88.1 SA100 WH126 WH131 WH140
WH224 WH38.1 WH80.1 WH81.1 OE270 OE271
POIF.1 POIG.1 RQ10.1 RQ35.1 RQ44.1 RQ44.2
UPDATED BY
BL92.1 OE114 OE310 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
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
RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHL-COMPANY Numeric 4 BL92.1 OE114
Element: Company 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 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 OE114
Element: System Code This field indicates from which Lawson WH130 WH132
system the document originated. WH190 WH30.1
OE = Customer Order WH30.2 WH30.3
RQ = Requisitions WH30.4 WH31.1
CX = Case Cart 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-DOC-NBR Alpha 10 (Right Justified) BL92.1 OE114
Element: Doc Nbr This field contains the document number WH130 WH132
assigned to this shipment line. 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-SHIPMENT-NBR Numeric 10 BL92.1 OE114
Element: Shipment NumbeThis field contains the shipment WH130 WH132
number. One document can have several WH190 WH30.1
shipment numbers if the items were not WH30.2 WH30.3
shipped at the same time. 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-NBR Numeric 6 BL92.1 OE114
Element: Line Number This field contains the shipment line WH130 WH132
number. 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-LINE-TYPE Alpha 1 BL92.1 OE114
Element: Line Type This field contains the type of item WH130 WH132
found on this shipment line. WH190 WH30.1
I = Inventoried Item WH30.2 WH30.3
N = Nonstock Item WH30.4 WH31.1
X = Special Item 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-ITEM Alpha 32 BL92.1 OE114
Element: Item Number This field contains the item WH130 WH132
identifier. 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-DESCRIPTION Alpha 30 (Lower Case) BL92.1 OE114
Element: Description This field contains the description of WH130 WH132
the line item. 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-LOCATION Alpha 5 BL92.1 OE114
Element: Location Code This field contains a valid stock WH130 WH132
location within the company inventory. 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-PRINTED-QTY Signed 13.4 BL92.1 OE114
Element: Quantity This field contains the quantity that WH130 WH132
was printed on the pick list to be WH190 WH30.1
picked. 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 Alpha 4 BL92.1 OE114
Element: Unit of MeasurThis field indicates the unit of WH130 WH132
measure from the document. 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-TRAN-UOM-MULT Signed 13.7 BL92.1 OE114
Unit of Measure This field is the conversion factor to WH130 WH132
Multiplier convert to stock unit of measure. 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-IN-PROCESS-QTY Signed 13.4 BL92.1 OE114
Element: In-Process QuaThis field contains the in-process WH130 WH132
quantity, which is the shipment line WH190 WH30.1
quantity currently in process. 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-SHIPPED-QTY Signed 13.4 BL92.1 OE114
Element: Quantity This field contains the quantity that OE270 WH130
was shipped in stock unit of measure. WH132 WH190
For catch weight items, the shipped WH30.1 WH30.2
quantity is in secondary unit of WH30.3 WH30.4
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-DELIVERED-QTY Signed 13.4
Element: Delivered QuanThis 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 OE114
Element: Quantity This field contains the catch weight WH130 WH132
quantity in stock unit of measure. 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 WH34.5
WH40.1 WH40.2
WH520 WH830
WHL-PRE-ASMBLD-KIT Signed 13.4 BL92.1 OE114
Element: Pre-Assembled This field contains the make-to-order WH130 WH132
kit quantity. 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-KIT-COMP-QTY Signed 13.4 BL92.1 OE114
Element: Quantity The total component quantity of the WH130 WH132
shipping line kit item. 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-DETAIL-QTY Signed 13.4 BL92.1 OE114
Element: Detail QuantitThis field shows the total quantity of WH130 WH132
details assigned to the shipment line. 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-DTL-CTW-QTY Signed 13.4 BL92.1 OE114
Detail Catch Weight This field contains the catch weight WH130 WH132
Quantity quantity for shipment lines with WH190 WH30.1
details. 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
WHL-DETAIL-REQ Alpha 1 BL92.1 OE114
Element: Detail RequireThis field indicates whether or not WH130 WH132
details are required for shipment lines. WH190 WH30.1
Y = Yes WH30.2 WH30.3
N = No WH30.4 WH31.1
I = Interfaced 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-WALK-THRU-REQ Alpha 1 BL92.1 OE114
Element: Walk Thru RequThis field indicates that a shipment WH130 WH132
line is out of balance. 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
WH34.5 WH40.1
WH40.2 WH520
WH830
WHL-UNIT-COST Signed 18.5 BL92.1 OE114
Element: Intl Cost This field contains the unit cost of WH130 WH132
the shipment line. 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-WEIGHT Signed 9.3 BL92.1 OE114
Element: Unit Weight This field contains the shipment line's WH130 WH132
calculated weight based on the item WH190 WH30.1
master stock weight and the line's WH30.2 WH30.3
quantity in stock unit of measure. 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-CUBIC-FEET Signed 9.3 BL92.1 OE114
Element: Cubic Feet This field contains the shipment line's WH130 WH132
calculated cubic measurement based on WH190 WH30.1
the item master stock cubic and the WH30.2 WH30.3
shipment line's quantity in stock unit WH30.4 WH31.1
of measure. 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-REQ-FL Alpha 1 BL92.1 OE114
Element: All Flag This field indicates if a Material WH130 WH132
Safety Data Sheet is required for the WH190 WH30.1
item of this shipment line. This flag is WH30.2 WH30.3
originally set at item master. WH30.4 WH31.1
Y = Yes WH31.2 WH31.3
N = No 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-DT Numeric 8 (yyyymmdd) BL92.1 OE114
Element: MSDS Date This field contains the date that a WH130 WH132
Material Safety Data Sheet is being sent WH190 WH30.1
to a customer ship to for this shipment WH30.2 WH30.3
line. 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-DOCUMENT Alpha 30 BL92.1 OE114
Element: Msds Document The document number that references the WH130 WH132
Material Safety Data Sheet that is being WH190 WH30.1
sent for this shipment line. 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-MSDS-VERSION Alpha 4 BL92.1 OE114
Element: Msds Version The version number of the MSDS document WH130 WH132
that is being sent with this shipment WH190 WH30.1
line. 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-OPR-CODE Alpha 10 (Lower Case) BL92.1 OE114
Element: Operator Code This field contains the operator code WH130 WH132
or user ID of the person who last WH190 WH30.1
updated this record. 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-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Update Date This field contains the date the record WH130 WH132
was updated. 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-UPDATE-TIME Numeric 6 BL92.1 OE114
Element: Update Time This field contains the system time WH130 WH132
when the record was updated. 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-FULL-VOID-FL Alpha 1 BL92.1 OE114
Element: Full Void Fl Indicates that shipment line has been WH130 WH132
voided. No quantities will be shipped WH190 WH30.1
from this line. WH30.2 WH30.3
Y = Voided WH30.4 WH31.1
N = Not Voided 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-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 OE114
Element: 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 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 OE114
Element: 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 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 OE114
Element: Icn Code 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 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 OE114
Element: Rqsrc Machine 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 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 OE114
Element: Par Order Id 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 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 Primary index used for accessing and BL120 BL122
LOCATION updating the table. BL123 BL130
SHIPMENT-NBR BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE114
OE129 OE229
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE530
OE81.1 OE830
OE88.1 RQ300
...
WHLSET2 COMPANY Used to find shipment lines by the BL92.1 OE114
SYSTEM-CD originating system. OE270 OE271
DOC-NBR OE81.1 POIF.1
LINE-NBR POIG.1 RQ10.1
SHIPMENT-NBR RQ35.1 RQ44.1
RQ44.2 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
WH33.1 WH33.2
WH33.3 WH33.4
...
WHLSET3 COMPANY Used to find shipment lines that need BL92.1 OE114
LOCATION to have details assigned. WH130 WH132
SHIPMENT-NBR Subset WH190 WH30.1
LINE-NBR Where (WALK-THRU-REQ = "Y" ) WH30.2 WH30.3
ITEM 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
WH34.1 WH34.2
WH34.3 WH34.4
WH38.1 WH40.1
WH40.2 WH520
...
WHLSET4 COMPANY Used to find shipment lines that do not
LOCATION require details (but other lines on the
SHIPMENT-NBR same shipment do require details).
LINE-NBR Subset
Where DETAIL-REQ = "N"
WHLSET5 COMPANY KeyChange
LOCATION
SHIPMENT-NBR
FULL-VOID-FL
LINE-NBR
WHLSET6 COMPANY This index was created as a solution to WH30.1 WH30.2
LOCATION the Find Next/Prev Flag error. It is WH31.1 WH31.2
LINE-NBR only used where a modify must be done WH32.1 WH32.2
SHIPMENT-NBR within a 850-FIND-NLT or 850-FIND-BEGRNG WH33.1 WH33.2
loop. WH33.3 WH33.4
WH33.7 WH34.1
WH34.2 WH34.3
WH34.4
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
|