WHSHIPMENT FILE
Shipment
The Shipment file carries a record for every shipment created for every
document.
REFERENCED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL820
BL940 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE810 OE830 OE950
WH38.1 WH80.1 WH80.3 WH80.4 WH80.2 WH81.1
WH140 WH131 OE271 OE272 RQ35.1
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 OE114 OE129
OE310 RQ300 WH126 WH130 WH132 WH190
WH222 WH224 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5
WH33.7 WH33.1 WH33.2 WH33.3 WH33.4 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WH966
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHS-COMPANY Numeric 4 BL92.1 OE114
Company This field contains the company number. WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-SYSTEM-CD Alpha 2 BL92.1 OE114
System Code This field indicates on which Lawson WH130 WH132
system the document originated. WH190 WH30.1
OE = Customer Order WH30.2 WH30.3
RQ = Requisitions WH31.1 WH31.2
CX = Case Cart WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-DOC-NBR Alpha 10 (Right Justified) BL92.1 OE114
Document Number This field contains the document number WH130 WH132
within the shipment. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-SHIPMENT-NBR Numeric 10 BL92.1 OE114
Shipment Number This 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. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-DOC-TYPE Alpha 2 WH966
Document Type This field contains the type of
document. For warehouse purposes, this
is the shipping document.
SH = Shipment
WHS-CUST-SHIP-TO Numeric 4 BL92.1 OE114
Customer Ship-To This field contains the ship-to WH130 WH132
Number customer number. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-REQ-LOCATION Alpha 5 BL92.1 OE114
Requesting Location This field contains the requesting WH130 WH132
location. This location can be an WH190 WH30.1
inventory or nonstock location. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-DESTINATION Alpha 15 BL92.1 OE114
Destination This field represents the destination WH130 WH132
to which shipments are being sent. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PROCESS-LEVEL Alpha 5 BL92.1 OE114
Process Level This field contains the process level WH130 WH132
assigned to the document. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-LOCATION Alpha 5 BL92.1 OE114
Location This field contains a valid stock WH130 WH132
location within the company inventory. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-BATCH-NBR Numeric 6 BL92.1 OE114
Batch Number This identifies the batch number WH130 WH132
assigned to the shipment when you ran WH190 WH30.1
WH130 (Pick List Print). WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-STATUS Numeric 1 BL92.1 OE114
Status This field contains the status of the OE129 WH130
shipment. WH132 WH190
0 = Printed WH30.1 WH30.2
1 = Picked WH30.3 WH31.1
2 = Packed WH31.2 WH31.3
3 = Shipped WH32.1 WH32.2
4 = Released WH32.3 WH33.5
5 = Closed WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-OPR-CODE Alpha 10 (Lower Case) BL92.1 OE114
Operator Code This field contains the operator code WH130 WH132
or the user ID of the person who last WH190 WH30.1
updated this record. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PICKING-REQ Alpha 1 BL92.1 OE114
Picking Required This field indicates whether or not WH130 WH132
picking feedback is required based on WH190 WH30.1
the process type. WH30.2 WH30.3
Y = Yes WH31.1 WH31.2
N = No WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PACKING-REQ Alpha 1 BL92.1 OE114
Packing Required This field indicates whether or not WH130 WH132
packing feedback is required based on WH190 WH30.1
the process type. WH30.2 WH30.3
Y = Yes WH31.1 WH31.2
N = No WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PRINT-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Print Date This field contains the date when the WH130 WH132
pick list was printed. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PICK-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Pick Date This field contains the date that WH130 WH132
picking feedback was performed. The WH190 WH30.1
system date defaults. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PACK-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Pack Date This field contains the pack date. The WH130 WH132
system date defaults but can be WH190 WH30.1
overridden if you are using the WH20 WH30.2 WH30.3
form series. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-SHIP-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Ship Date This field contains the ship date. If OE271 OE272
left blank, the system date defaults. WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-GL-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
General Ledger Date This field contains the general ledger OE129 WH130
posting date. WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-EST-DEL-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Expected Ship Date This field contains the expected ship WH130 WH132
date. If you leave the field blank and WH190 WH30.1
no ship days are defined on the WH30.2 WH30.3
document's process level, the document WH31.1 WH31.2
date defaults. If ship days exist on WH31.3 WH32.1
the process level, ship days are added WH32.2 WH32.3
to the document date to calculate the WH33.5 WH34.1
expected ship date. WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-VENDOR Alpha 9 BL92.1 OE114
Vendor The vendor's identification code. WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PO-FLAG Alpha 1 WH966
PO Flag This field indicates whether or not
shipment lines that create purchase
orders are based on purchase order
receipt.
Y = Based on PO Receipt
N = Not Related to PO
WHS-ROUTE Numeric 4 BL92.1 OE114
Route This field contains the route number. WH130 WH132
The route assigned to the ship-to WH190 WH30.1
customer defaults from the Route file. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-STOP Numeric 4 BL92.1 OE114
Stop This field contains the stop within the WH130 WH132
route. If left blank, the stop WH190 WH30.1
associated with the ship-to customer WH30.2 WH30.3
defaults from the Route file. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-BOL-NBR Alpha 10 BL92.1 OE114
Bill of Lading This field contains the Bill of Lading WH130 WH132
Number number for the shipment. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-CARRIER Alpha 9 BL122 BL80.1
Carrier Number This field contains the carrier BL92.1 OE114
number. The carrier must be valid in WH130 WH132
the Lawson Accounts Payable system. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-METHOD Alpha 10 BL122 BL80.1
Method This field contains the shipping method BL92.1 OE114
that you defined using WH11.1 (Shipping WH130 WH132
Method). WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-TRANS-ID Alpha 10 BL122 BL80.1
Transportation ID This field contains the transportation BL92.1 OE114
identification, which prints on the WH130 WH132
invoice and Bill of Lading. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-FREIGHT-CODE Alpha 2 BL92.1 OE114
Freight Code This field contains the freight code. WH130 WH132
This must be valid in the Order Entry WH190 WH30.1
Freight Code file. This determines WH30.2 WH30.3
whether carrier and charge are allowed WH31.1 WH31.2
for the shipment. WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-FREIGHT-REQ Alpha 1 BL92.1 OE114
Freight Required This field indicates whether or not WH130 WH132
freight charges are required on this WH190 WH30.1
shipment. Freight codes are defined in WH30.2 WH30.3
the Lawson Billing system. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-FRT-CHG-CURR Signed 15.2 BL92.1 OE114
Freight Charge This field contains the freight charge WH130 WH132
Currency amount in billing currency. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH33.7
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-CARTONS Numeric 6 BL92.1 OE114
Cartons This field contains the total number of WH130 WH132
cartons in the shipment. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-CUBIC-FEET Signed 9.3 BL92.1 OE114
Cubic Feet This field contains the cubic feet of WH130 WH132
the item based on the stock unit of WH190 WH30.1
measure. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-WEIGHT Signed 9.3 BL92.1 OE114
Weight This field contains the weight of the WH130 WH132
item based on the stock unit of measure. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-PACK-LIST-FL Alpha 1 BL92.1 OE114
Pack List Flag This field indicates if the packing WH130 WH132
list has been printed. WH190 WH224
Y = Yes WH30.1 WH30.2
N = No WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-POD-PRT-FL Alpha 1 BL92.1 OE114
POD Print Flag This field represents the Proof of WH126 WH130
Delivery (POD) Print flag. WH126 (POD WH132 WH190
Print) sets this flag to Yes after WH30.1 WH30.2
printing a POD. WH30.3 WH31.1
Y = Yes WH31.2 WH31.3
N = No WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-POD-RETRN-DT Numeric 8 (yyyymmdd) BL92.1 OE114
POD Return Date This field contains the date the Proof WH130 WH132
of Delivery (POD) form is returned with WH190 WH30.1
an acknowledgment. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WH966
WHS-INVC-PREFIX Alpha 2 BL92.1 OE114
Invoice Prefix This field contains the invoice prefix OE129 WH130
that is assigned from either the billing WH132 WH190
company or process level, depending on WH30.1 WH30.2
the invoice-level option chosen. WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-INVC-NUMBER Numeric 8 BL92.1 OE114
Invoice Number This field contains the invoice number OE129 WH130
assigned by the system. WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WH966
WHS-ORIGIN Derived
Origin This literal helps to indicate in which
Lawson system the document originated.
WHS-DAYS-LATE Derived
Days Late This field contains the number of days
after the requested date that you sent a
shipment.
WHS-DAYS-LATE-COND Derived
Days Late Condition This flag helps to indicate whether or
not a shipment was late.
WHS-DAYS-LATE-CTR Derived
Days Late Counter This flag will be either zero or one,
indicating if the shipment was late or
not.
WHS-LAST-DATE Derived
Last Activity Date This field contains the last activity
date for the shipment. In other words,
when the last activity such as picking
or packing feedback was performed.
WHS-RDY-TO-STATUS Derived
Ready To Status This field indicates the shipment
status the shipment is about to go to,
based on the process type.
WHS-RDY-TO-LITERAL Derived
Ready To Literal This literal is used to help display
the status a shipment is about to go to.
WHSHIPMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHSSET1 COMPANY Primary index used for accessing and BL120 BL122
LOCATION updating the table. BL130 BL20.1
SHIPMENT-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL80.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE810 OE830
OE950 WH126
WH130 WH132
...
WHSSET2 COMPANY Used to find shipments for Bills of WH140 WH40.2
LOCATION Lading.
BOL-NBR KeyChange, Subset
SHIPMENT-NBR Where (BOL-NBR != Spaces )
WHSSET3 COMPANY Used to find all the shipments for a WH40.1
LOCATION specific carrier.
CARRIER KeyChange
BOL-NBR
SHIPMENT-NBR
WHSSET4 COMPANY Used to find shipments that are shipped WH190
LOCATION but not released.
BATCH-NBR Subset
SHIPMENT-NBR Where (STATUS = 3 )
WHSSET5 COMPANY Used to find batch sequence numbers. OE114 WH130
LOCATION WH131 WH132
BATCH-NBR WH30.2 WH31.2
SHIPMENT-NBR WH32.2 WH80.4
WHSSET6 COMPANY Used to find shipments that are shipped OE129
LOCATION but not invoiced.
DOC-NBR Subset
SHIPMENT-NBR Where (SYSTEM-CD = "OE" )
And (STATUS = 4 )
WHSSET7 COMPANY Used to find the originating system. BL120 BL130
SYSTEM-CD BL20.1 BL20.3
DOC-NBR BL21.2 BL21.5
SHIPMENT-NBR BL29.1 BL29.2
LOCATION BL520 BL820
BL92.1 BL940
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 OE114
OE129 OE271
OE272 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
WHSHIPMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When WHS-CARRIER != Spaces
WHS-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
When WHS-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
WHS-CARRIER -> VEN-VENDOR
Caseheader CXCASEHEAD Required
When WHS-SYSTEM-CD = "CX"
WHS-COMPANY -> CXH-COMPANY
WHS-REQ-LOCATION -> CXH-REQ-LOCATION
WHS-DOC-NBR -> CXH-CASE
Custorder CUSTORDER Required
When WHS-SYSTEM-CD = "OE"
WHS-COMPANY -> COR-COMPANY
WDH-DOC-NBR-NUM -> COR-ORDER-NBR
Iccompany ICCOMPANY Required
WHS-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
WHS-COMPANY -> ICL-COMPANY
WHS-LOCATION -> ICL-LOCATION
Oemethod OEMETHOD Not Required
Valid When WHS-METHOD != Spaces
WHS-COMPANY -> OMT-COMPANY
WHS-METHOD -> OMT-METHOD
Reqheader REQHEADER Required
When WHS-SYSTEM-CD = "RQ"
WHS-COMPANY -> RQH-COMPANY
WDH-DOC-NBR-NUM -> RQH-REQ-NUMBER
Shipto SHIPTO Not Required
WHS-COMPANY -> SHP-COMPANY
COR-CUSTOMER -> SHP-CUSTOMER
WHS-CUST-SHIP-TO -> SHP-SHIP-TO
Whdemndhdr WHDEMNDHDR Required
WHS-COMPANY -> WDH-COMPANY
WHS-SYSTEM-CD -> WDH-SYSTEM-CD
WHS-DOC-NBR -> WDH-DOC-NBR
WHSHIPMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
No Details WHSHIPLINE
WHS-COMPANY -> WHL-COMPANY
WHS-LOCATION -> WHL-LOCATION
WHS-SHIPMENT-NBR -> WHL-SHIPMENT-NBR
WHL-LINE-NBR
Shipline WHSHIPLINE
WHS-COMPANY -> WHL-COMPANY
WHS-LOCATION -> WHL-LOCATION
WHS-SHIPMENT-NBR -> WHL-SHIPMENT-NBR
WHL-LINE-NBR
Shiplnedtl WHSHLDTL
WHS-COMPANY -> WHD-COMPANY
WHS-LOCATION -> WHD-LOCATION
WHS-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-SERIAL
WHD-UOM
WHD-LINE-NBR
WHD-COMPONENT-SEQ
|