Lawson Insight Technical Documentation |
|
WHSHIPLINE
WHSHIPLINE FILE
Shipment Line
The Shipment Line file contains shipment line records.
REFERENCED BY
WH126 WH131 WH140 WH224 WH38.1 WH80.1
WH81.1 POIF.1 POIG.1 RQ10.1 RQ140 RQ35.1
RQ44.1 RQ44.2 RQD0.1 RQD1.1
UPDATED BY
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 WHD0.1 WHD2.1 WHD3.1
RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHL-COMPANY Numeric 4 WH130 WH132
Element: Company This field contains the company 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-SYSTEM-CD Alpha 2 WH130 WH132
Element: System Code This field indicates from which Lawson WH190 WH30.1
system the document originated. WH30.2 WH30.3
OE = Customer Order WH30.4 WH31.1
RQ = Requisitions WH31.2 WH31.3
CX = Case Cart 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) WH130 WH132
Element: Doc Nbr This field contains the document number WH190 WH30.1
assigned to 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-SHIPMENT-NBR Numeric 10 WH130 WH132
Element: Shipment NumbeThis field contains the shipment WH190 WH30.1
number. One document can have several WH30.2 WH30.3
shipment numbers if the items were not WH30.4 WH31.1
shipped at the same time. 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 WH130 WH132
Element: Line Number This field contains the shipment line WH190 WH30.1
number. 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 WH130 WH132
Element: Line Type This field contains the type of item WH190 WH30.1
found on this shipment line. WH30.2 WH30.3
I = Inventoried Item WH30.4 WH31.1
N = Nonstock Item WH31.2 WH31.3
X = Special Item 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 WH130 WH132
Element: Item Number This field contains the item WH190 WH30.1
identifier. 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) WH130 WH132
Element: Description This field contains the description of WH190 WH30.1
the line item. 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 WH130 WH132
Element: Location Code This field contains a valid stock WH190 WH30.1
location within the company inventory. 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 WH130 WH132
Element: Quantity This field contains the quantity that WH190 WH30.1
was printed on the pick list to be WH30.2 WH30.3
picked. 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 WH130 WH132
Element: Unit of MeasurThis field indicates the unit of WH190 WH30.1
measure from the document. 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 WH130 WH132
Unit of Measure This field is the conversion factor to WH190 WH30.1
Multiplier convert to stock unit of measure. 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 WH130 WH132
Element: In-Process QuaThis field contains the in-process WH190 WH30.1
quantity, which is the shipment line WH30.2 WH30.3
quantity currently in process. 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 WH130 WH132
Element: Quantity This field contains the quantity that WH190 WH30.1
was shipped in stock unit of measure. WH30.2 WH30.3
For catch weight items, the shipped WH30.4 WH31.1
quantity is in secondary unit of WH31.2 WH31.3
measure. 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 WH130 WH132
Element: Quantity This field contains the catch weight WH190 WH30.1
quantity in stock unit of measure. 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 WH130 WH132
Element: Pre-Assembled This field contains the make-to-order WH190 WH30.1
kit quantity. 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 WH130 WH132
Element: 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-DETAIL-QTY Signed 13.4 WH130 WH132
Element: Detail QuantitThis field shows the total quantity of WH190 WH30.1
details assigned to the 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
WHD2.1
WHL-DTL-CTW-QTY Signed 13.4 WH130 WH132
Detail Catch Weight This field contains the catch weight WH190 WH30.1
Quantity quantity for shipment lines with WH30.2 WH30.3
details. 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 WH130 WH132
Element: Detail RequireThis field indicates whether or not WH190 WH30.1
details are required for shipment lines. WH30.2 WH30.3
Y = Yes WH30.4 WH31.1
N = No WH31.2 WH31.3
I = Interfaced 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 WH130 WH132
Element: Walk Thru RequThis field indicates that a shipment WH190 WH30.1
line is out of balance. 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 13.5 WH130 WH132
Element: Base Cost This field contains the unit cost of WH190 WH30.1
the 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-WEIGHT Signed 9.3 WH130 WH132
Element: Unit Weight This field contains the shipment line's WH190 WH30.1
calculated weight based on the item WH30.2 WH30.3
master stock weight and the line's WH30.4 WH31.1
quantity in stock unit 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-CUBIC-FEET Signed 9.3 WH130 WH132
Element: Cubic Feet This field contains the shipment line's WH190 WH30.1
calculated cubic measurement based on WH30.2 WH30.3
the item master stock cubic and the WH30.4 WH31.1
shipment line's quantity in stock unit WH31.2 WH31.3
of measure. 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 WH130 WH132
Element: All Flag This field indicates if a Material WH190 WH30.1
Safety Data Sheet is required for the WH30.2 WH30.3
item of this shipment line. This flag is WH30.4 WH31.1
originally set at item master. WH31.2 WH31.3
Y = Yes WH31.4 WH32.1
N = No 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) WH130 WH132
Element: MSDS Date This field contains the date that a WH190 WH30.1
Material Safety Data Sheet is being sent WH30.2 WH30.3
to a customer ship to for this shipment WH30.4 WH31.1
line. 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 WH130 WH132
Element: Msds Document The document number that references the WH190 WH30.1
Material Safety Data Sheet that is being WH30.2 WH30.3
sent for this shipment 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-VERSION Alpha 4 WH130 WH132
Element: Msds Version The version number of the MSDS document WH190 WH30.1
that is being sent with 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-OPR-CODE Alpha 10 (Lower Case) WH130 WH132
Element: Requester This field contains the operator code WH190 WH30.1
or user ID of the person who last WH30.2 WH30.3
updated this record. 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) WH130 WH132
Element: Date 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 WH130 WH132
Element: Update Time This field contains the system time WH190 WH30.1
when the record was updated. 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 WH130 WH132
Element: Full Void Fl Indicates that shipment line has been WH190 WH30.1
voided. No quantities will be shipped WH30.2 WH30.3
from this line. WH30.4 WH31.1
Y = Voided WH31.2 WH31.3
N = Not Voided 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 WH130 WH132
Element: 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 WH40.1
WH40.2 WH520
WH830
WHL-SUPLMNTARY-QTY Signed 13.4 WH130 WH132
Element: 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-ICN-CODE Alpha 8 WH130 WH132
Element: Icn Code 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 WH130 WH132
Element: Rqsrc Machine The name of the dispenser machine that WH190 WH30.1
is keeping track of the medical supply WH30.2 WH30.3
and that produces the requisition WH30.4 WH31.1
request when the quantity of that supply WH31.2 WH31.3
goes below the par level. WH31.4 WH32.1
DROYAL WH32.2 WH32.3
ESIOB WH32.4 WH33.1
HBOC WH33.2 WH33.3
OMNICL WH33.4 WH33.5
PAREXC WH33.6 WH33.8
PERSE WH33.9 WH34.1
PYXIS WH34.2 WH34.3
SSI WH34.4 WH40.1
WH40.2 WH520
WH830
WHL-PAR-ORDER-ID Alpha 20 WH130 WH132
Element: Par Order Id This is the identifier of the order or WH190 WH30.1
request when the quantity of a medical WH30.2 WH30.3
supply falls below the par level at one WH30.4 WH31.1
of the special dispensers that can WH31.2 WH31.3
produce such a request. 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 RQ300 WH126
LOCATION updating the table. WH130 WH131
SHIPMENT-NBR WH132 WH140
LINE-NBR WH190 WH222
WH224 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
...
WHLSET2 COMPANY Used to find shipment lines by the POIF.1 POIG.1
SYSTEM-CD originating system. RQ10.1 RQ140
DOC-NBR RQ35.1 RQ44.1
LINE-NBR RQ44.2 RQD0.1
SHIPMENT-NBR RQD1.1 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
...
WHLSET3 COMPANY Used to find shipment lines that need WH130 WH132
LOCATION to have details assigned. WH190 WH30.1
SHIPMENT-NBR Subset WH30.2 WH30.3
LINE-NBR Where (WALK-THRU-REQ = "Y" ) WH30.4 WH31.1
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
WH34.1 WH34.2
WH34.3 WH34.4
WH38.1 WH40.1
WH40.2 WH520
WH830
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
|