WHSHIPMENT

Shipment

The Shipment file carries a record for every shipment created for every document.

REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 CX05.1 CX05.2 CX805 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC216
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQD0.1 RQD1.1 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1 WH110
WH120 WH20.1 WH20.2 WH20.3 WH20.4 WH20.5
WH20.6 WH20.7 WH21.1 WH21.2 WH21.3 WH21.4
WH210 WH22.1 WH225 WH25.1 WH25.2 WH38.1
WH39.1 WH39.2 WH80.1 WH80.3 WH80.4 WH80.2
WH81.1 WHBD.1 WHBD.2 WHD2.1 WHD3.1 WH82.1
WH140 WH131 POIF.1 POIG.1 RQ270


UPDATED BY
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 RQ300 WH126 WH130
WH132 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 WH32.5 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 WHD0.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHS-COMPANY
Element: Company		Numeric 4
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-SYSTEM-CD
Element: System Cd		Alpha 2
This field indicates on which Lawson system the document originated.
OE = Customer Order
RQ = Requisitions
CX = Case Cart
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-DOC-NBR
Element: Doc Nbr		Alpha 10 (Right Justified)
This field contains the document number within the shipment.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-SHIPMENT-NBR
Element: Shipment Nbr		Numeric 10
This field contains the shipment number. One document can have several shipment numbers if the items were not shipped at the same time.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-DOC-TYPE
Element: Doc Type		Alpha 2
This field contains the type of document. For warehouse purposes, this is the shipping document.
SH = Shipment
WHS-CUST-SHIP-TO
Customer Ship-To
Number		Numeric 4
This field contains the ship-to customer 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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-REQ-LOCATION
Element: Requesting Location		Alpha 5
This field contains the requesting location. This location can be an inventory or nonstock location.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-DESTINATION
Element: Destination		Alpha 15
This field represents the destination to which shipments are being sent.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PROCESS-LEVEL
Element: Process Level		Alpha 5
This field contains the process level assigned to the document.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-LOCATION
Element: Location		Alpha 5
This field contains a valid stock location within the company inventory.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-BATCH-NBR
Element: Batch Nbr		Numeric 6
This identifies the batch number assigned to the shipment when you ran Pick List Print (WH130).
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-STATUS
Element: Status		Numeric 1
This field contains the status of the shipment.
0 = Printed
1 = Picked
2 = Packed
3 = Shipped
4 = Released
5 = Closed
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WHD0.1
WHS-OPR-CODE
Element: Opr Code		Alpha 10 (Lower Case)
This field contains the operator code or the user ID of the person who last updated this record.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PICKING-REQ
Element: Picking Required		Alpha 1
This field indicates whether or not picking feedback is required based on the process type.
Y = Yes
N = No
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PACKING-REQ
Element: Packing Required		Alpha 1
This field indicates whether or not packing feedback is required based on the process type.
Y = Yes
N = No
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PRINT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PICK-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field contains the date that picking feedback was performed. The system date defaults.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PACK-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field contains the pack date. The system date defaults but can be overridden if you are using the WH20 form series.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-SHIP-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-GL-DATE
Element: Gl Date		Numeric 8 (yyyymmdd)
This field contains the general ledger posting date.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-EST-DEL-DATE
Element: Expected Ship Date		Numeric 8 (yyyymmdd)
This field contains the expected ship date. If you leave the field blank and no ship days are defined on the document's process level, the document date defaults. If ship days exist on the process level, ship days are added to the document date to calculate the expected ship date.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification 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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PO-FLAG
Element: PO Flag		Alpha 1
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
Element: Route		Numeric 4
This field contains the route number. The route assigned to the ship-to customer defaults from the Route file.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-STOP
Element: Stop		Numeric 4
This field contains the stop within the route. If left blank, the stop associated with the ship-to customer defaults from the Route file.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-BOL-NBR
Element: Bol Nbr		Alpha 22
This field contains the Bill of Lading number for the shipment.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-CARRIER
Element: Carrier Number		Alpha 9 (Right Justified)
This field contains the carrier number. The carrier must be valid in Accounts Payable.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-METHOD
Element: Method		Alpha 10
This field contains the shipping method that you defined using Shipping Method (WH11.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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-TRANS-ID
Element: Transportation ID		Alpha 20
This field contains the transportation identification, which prints on the invoice and Bill of Lading.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-FREIGHT-CODE
Element: Freight Code		Alpha 2
This field contains the freight code. This must be valid in the Order Entry Freight Code file. This determines whether carrier and charge are allowed for the shipment.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-FREIGHT-REQ
Element: Freight Required		Alpha 1
This field indicates whether or not freight charges are required on this shipment. Freight codes are defined in the Lawson Billing system.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-FRT-CHG-CURR
Freight Charge
Currency		Signed 18.2
This field contains the freight charge amount in billing currency.
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 WH32.5
WH33.5 WH33.7
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-CARTONS
Element: Cartons		Numeric 6
This field contains the total number of cartons in the shipment.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-CUBIC-FEET
Element: Cubic Feet		Signed 9.3
This field contains the total of all the shipment line's calculated cubic measurements based on the item master stock cubic values.
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 WH32.5
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
WHS-CUBIC-ADJ
Element: Cubic Adj		Signed 9.3
This field contains a shipment level adjustment to the total of all the shipment line's calculated cubic measurements.
WHS-CUBIC-TOTAL
Element: Cubic Total		Signed 9.3
This field contains the shipment's total cubic measurement which is the sum of the shipment line's calculated totals and the shipment level adjustment.
WHS-WEIGHT
Element: Weight		Signed 9.3
This field contains the total of all the shipment line's calculated weight based on the item master stock weight values.
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 WH32.5
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
WHS-WEIGHT-ADJ
Element: Weight Adj		Signed 9.3
This field contains a shipment level adjustment to the total of all the shipment line's calculated weight.
WHS-WEIGHT-TOTAL
Element: Weight Total		Signed 9.3
This field contains the shipment's total weight which is the sum of the shipment line's calculated totals and the shipment level adjustment.
WHS-PACK-LIST-FL
Element: Pack List Flag		Alpha 1

Y = Yes
N = No
WH130 WH132
WH190 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
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-POD-PRT-FL
Element: POD Print Flag		Alpha 1
This field represents the Proof of Delivery (POD) Print flag. WH126 (POD Print) sets this flag to Yes after printing a POD.
Y = Yes
N = No
WH126 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
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-POD-RETRN-DT
Element: POD Return Date		Numeric 8 (yyyymmdd)
This field contains the date the Proof of Delivery (POD) form is returned with an acknowledgment.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-INVC-PREFIX
Element: Invc Prefix		Alpha 2
This field contains the invoice prefix that is assigned from either the billing company or process level, depending on the invoice-level option chosen.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-INVC-NUMBER
Element: Invoice Number		Numeric 8
This field contains the invoice number assigned by the system.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-REQ-COMPANY
Element: Company		Numeric 4
This field contains the requesting company.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-DOC-NBR-NUM
Element: Doc Nbr Num		Numeric 10
This field contains the numeric version of the document number.
WHS-ORIGIN
Element: Origin		Derived
This literal helps to indicate in which Lawson system the document originated.
WHS-DAYS-LATE
Element: Days Late		Derived
This field contains the number of days after the requested date that you sent a shipment.
WHS-DAYS-LATE-COND
Element: Days Late Condition		Derived
This flag helps to indicate whether or not a shipment was late.
WHS-DAYS-LATE-CTR
Element: Days Late Counter		Derived
This flag will be either zero or one, indicating if the shipment was late or not.
WHS-LAST-DATE
Element: Last Activity Date		Derived
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
Element: Ready To Status		Derived
This field indicates the shipment status the shipment is about to go to, based on the process type.
WHS-RDY-TO-LITERAL
Element: Ready To Literal		Derived
This literal is used to help display the status a shipment is about to go to.
WHS-INTRASTAT-NBR
Element: Intrastat Nbr		Numeric 12
The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-FOB-CODE
Element: Fob Code		Alpha 3
The user defined Free On Board 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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-PORT-CD
Element: Port Cd		Alpha 5
The Intrastat port code. Must be define in IN04.1 (Port Maintenance)
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-NOTC
Element: Notc		Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-STAT-PROC
Element: Stat Proc		Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-VAT-REG-NBR
Element: Vat Reg Nbr		Alpha 12
The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration 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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-EXT-ACCT-ENT
Element: Ext Acct Ent		Alpha 22 (Lower Case)
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-EXT-LOCATION
Element: Ext Location		Alpha 22 (Lower Case)
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-EXT-SHIP-NBR
Element: Ext Ship Nbr		Alpha 100 (Lower Case)
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-GLBL-DOC-TYPE
Element: Glbl Doc Type		Alpha 10
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-TEMP-HOLD
Element: Temp Hold		Alpha 1

S = Sent for Approval
A = Approved by Engine
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 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830


WHSHIPMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHSSET1 COMPANY
LOCATION
SHIPMENT-NBR
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX05.1
CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
WHSSET10 COMPANY
LOCATION
SHIPMENT-NBR*
Subset
WhereSTATUS <4
WH82.1
WHSSET11 COMPANY
LOCATION
SHIPMENT-NBR*
WHSSET2 COMPANY
LOCATION
BOL-NBR
SHIPMENT-NBR
KeyChange, Subset
Where(BOL-NBR !=Spaces)
WH140 WH40.2
WHSSET3 COMPANY
LOCATION
CARRIER
BOL-NBR
SHIPMENT-NBR
KeyChange
WH40.1
WHSSET4 COMPANY
LOCATION
BATCH-NBR
SHIPMENT-NBR
Subset
Where(STATUS =3)
WH190
WHSSET5 COMPANY
LOCATION
BATCH-NBR
SHIPMENT-NBR
WH130 WH131
WH132 WH30.3
WH31.3 WH32.3
WH80.4
WHSSET6 COMPANY
LOCATION
DOC-NBR
SHIPMENT-NBR
Subset
Where(SYSTEM-CD ="OE")
And(STATUS =4)
WHSSET7 COMPANY
SYSTEM-CD
DOC-NBR
SHIPMENT-NBR
LOCATION
...
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 POIF.1
POIG.1 RQ270
RQ300 WH130
WH132 WH190
WH20.7 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
WHSSET8 COMPANY
LOCATION
SYSTEM-CD
DOC-NBR
SHIPMENT-NBR
WH130 WH30.1
WH31.1 WH32.1
WHSSET9 COMPANY
SHIPMENT-NBR
LOCATION
WH130 WH132
WH190 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
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830


WHSHIPMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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-REQ-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
Whsbod WHSBOD Not Required, Delete Cascades
WHS-COMPANY->WBA-COMPANY
WHS-LOCATION->WBA-LOCATION
WHS-SHIPMENT-NBR->WBA-SHIPMENT-NBR
Whwhsuf WHWHSUF Not Required
WHS-COMPANY->WSU-COMPANY
WHS-LOCATION->WSU-LOCATION
WHS-SHIPMENT-NBR->WSU-SHIPMENT-NBR


WHSHIPMENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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
Whshtrk WHSHTRK
WHS-COMPANY->WHT-COMPANY
WHS-LOCATION->WHT-LOCATION
WHS-SHIPMENT-NBR->WHT-SHIPMENT-NBR
  WHT-TRACKING-NBR

File created: Thu Jun 09 02:33:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.