 |
Lawson Insight Technical Documentation |
|
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 RQ35.1 RQ44.1
RQ44.2
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 RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHL-COMPANY Numeric 4 WH130 WH132
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
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
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
Shipment Number This 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
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
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
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
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
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
Printed on Pick This field contains the quantity that WH190 WH30.1
List Quantity 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
Transaction Unit of This field indicates the unit of WH190 WH30.1
Measure 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
Transaction UOM 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
In-Process Quantity This 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
Shipped 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
Delivered Quantity 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 WH130 WH132
Catch Weight This field contains the catch weight WH190 WH30.1
Quantity 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 WH40.1
WH40.2 WH520
WH830
WHL-PRE-ASMBLD-KIT Signed 13.4 WH130 WH132
Pre-Assembled Kit 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
Kit Comp Qty The total component quantity of the WH190 WH30.1
shipping line kit 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.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
Detail Quantity This 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
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
Detail Required This 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
Walk Thru Required This 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
WHL-UNIT-COST Signed 13.5 WH130 WH132
Unit 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
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
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
MSDS Required 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
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
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
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
Operator Code 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
Update Date This field contains the date the record WH190 WH30.1
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-UPDATE-TIME Numeric 6 WH130 WH132
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
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
Req Company This field contains the requesting
company.
WHL-OPEN-QUANTITY Derived
Open Quantity This field contains the total of the
in-process quantity and the backorder
quantity.
WHL-PARTIAL Derived
Partial This field is used to help determine if
a shipment is partial or not.
WHL-PARTIAL-VALUE Derived
Partial Value This field indicates whether or not a
shipment is partial.
WHL-SUPLMNTARY-UOM Alpha 4 WH130 WH132
Suplmntary Uom 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
Suplmntary Qty 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
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
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 RQ35.1
DOC-NBR RQ44.1 RQ44.2
LINE-NBR WH130 WH132
SHIPMENT-NBR 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
...
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 WH33.7
LOCATION the Find Next/Prev Flag error. It is
LINE-NBR only used where a modify must be done
SHIPMENT-NBR within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
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 WHL-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 WHL-SYSTEM-CD = "RQ"
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
Attached Bins WHSHLDTL
Valid When WHL-LOT-TRACK-FL = "N"
And WHL-BIN-TRACK-FL = "Y"
And WHL-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 WHL-LOT-TRACK-FL = "Y"
WHL-COMPANY -> WHD-COMPANY
WHL-LINE-TYPE -> 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 WHL-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 WHL- = WHL-
And WHL-LOT-TRACK-FL = "N"
And WHL-SER-TRACK-FL = "N"
And WHL-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 WHL-LOT-TRACK-FL = "N"
And WHL-BIN-TRACK-FL = "Y"
And WHL-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 WHL-SER-TRACK-FL = "R"
WHL-COMPANY -> SER-COMPANY
WHL-ITEM -> SER-ITEM
SER-SERIAL
Itserials ITSERIAL
Valid When WHL-SER-TRACK-FL = "I"
WHL-COMPANY -> SER-COMPANY
WHL-ITEM -> SER-ITEM
SER-SERIAL
Lots SOHDETAIL
Valid When WHL-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 WHL- = WHL-
And WHL-LOT-TRACK-FL = "N"
And WHL-SER-TRACK-FL = "N"
And WHL-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
|