Lawson Insight Technical Documentation |
|
WHSHIPMENT
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
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE530 OE810 OE830 WH225
WH38.1 WH80.1 WH80.3 WH80.4 WH80.2 WH81.1
WH140 WH131 OE271 OE272 POIF.1 POIG.1
OE229 OE88.1 RQ35.1
UPDATED BY
BL92.1 OE114 OE129 OE310 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 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHS-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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-SYSTEM-CD Alpha 2 BL92.1 OE114
Element: 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 WH30.4 WH31.1
CX = Case Cart WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-DOC-NBR Alpha 10 (Right Justified) BL92.1 OE114
Element: Doc Nbr This field contains the document number WH130 WH132
within the shipment. 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-DOC-TYPE Alpha 2 WH830
Element: 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-REQ-LOCATION Alpha 5 BL92.1 OE114
Element: Requesting LocThis field contains the requesting WH130 WH132
location. This location can be an WH190 WH30.1
inventory or nonstock location. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-DESTINATION Alpha 15 BL92.1 OE114
Element: Destination This field represents the destination WH130 WH132
to which shipments are being sent. 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PROCESS-LEVEL Alpha 5 BL92.1 OE114
Element: Process Level This field contains the process level WH130 WH132
assigned to 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-BATCH-NBR Numeric 6 BL92.1 OE114
Element: 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-STATUS Numeric 1 BL92.1 OE114
Element: Status This field contains the status of the OE129 WH130
shipment. WH132 WH190
0 = Printed WH30.1 WH30.2
1 = Picked WH30.3 WH30.4
2 = Packed WH31.1 WH31.2
3 = Shipped WH31.3 WH31.4
4 = Released WH32.1 WH32.2
5 = Closed WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-OPR-CODE Alpha 10 (Lower Case) BL92.1 OE114
Element: 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PICKING-REQ Alpha 1 BL92.1 OE114
Element: Picking RequirThis 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 WH30.4 WH31.1
N = No WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PACKING-REQ Alpha 1 BL92.1 OE114
Element: Packing RequirThis 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 WH30.4 WH31.1
N = No WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PRINT-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Date This field contains the date when the WH130 WH132
pick list was printed. 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PICK-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Date This field contains the date that WH130 WH132
picking feedback was performed. The WH190 WH30.1
system date defaults. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PACK-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: 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. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-SHIP-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-GL-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: General LedgerThis field contains the general ledger OE129 WH130
posting date. 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.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-EST-DEL-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Expected Ship 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 WH30.4 WH31.1
date defaults. If ship days exist on WH31.2 WH31.3
the process level, ship days are added WH31.4 WH32.1
to the document date to calculate the WH32.2 WH32.3
expected ship date. WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-VENDOR Alpha 9 (Right Justified) BL92.1 OE114
Element: Vendor ID 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PO-FLAG Alpha 1 WH830
Element: 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
Element: 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-STOP Numeric 4 BL92.1 OE114
Element: 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. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-BOL-NBR Alpha 22 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-CARRIER Alpha 9 (Right Justified) BL122 BL80.1
Element: Carrier NumberThis 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-METHOD Alpha 10 BL122 BL80.1
Element: Method Code 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-TRANS-ID Alpha 20 BL122 BL80.1
Element: TransportationThis 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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-FREIGHT-CODE Alpha 2 BL92.1 OE114
Element: 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 WH30.4 WH31.1
for the shipment. WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-FREIGHT-REQ Alpha 1 BL92.1 OE114
Element: Freight RequirThis 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. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-FRT-CHG-CURR Signed 18.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
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH33.7 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-CARTONS Numeric 6 BL92.1 OE114
Element: Number of CartThis field contains the total number of WH130 WH132
cartons in the shipment. 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-CUBIC-FEET Signed 9.3 BL92.1 OE114
Element: Cubic Feet This field contains the total of all WH130 WH132
the shipment line's calculated cubic WH190 WH30.1
measurements based on the item master WH30.2 WH30.3
stock cubic values. 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
WHS-CUBIC-ADJ Signed 9.3
Element: Cubic Adj This field contains a shipment level
adjustment to the total of all the
shipment line's calculated cubic
measurements.
WHS-CUBIC-TOTAL Signed 9.3
Element: Cubic Total 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 Signed 9.3 BL92.1 OE114
Element: Unit Weight This field contains the total of all WH130 WH132
the shipment line's calculated weight WH190 WH30.1
based on the item master stock weight WH30.2 WH30.3
values. 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
WHS-WEIGHT-ADJ Signed 9.3
Element: Weight Adj This field contains a shipment level
adjustment to the total of all the
shipment line's calculated weight.
WHS-WEIGHT-TOTAL Signed 9.3
Element: Weight Total 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 Alpha 1 BL92.1 OE114
Element: Pack List FlagThis field indicates if the packing WH130 WH132
list has been printed. WH190 WH224
Y = Yes WH30.1 WH30.2
N = No WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-POD-PRT-FL Alpha 1 BL92.1 OE114
Element: POD Print FlagThis 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 WH30.4
Y = Yes WH31.1 WH31.2
N = No WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-POD-RETRN-DT Numeric 8 (yyyymmdd) BL92.1 OE114
Element: POD Return DatThis field contains the date the Proof WH130 WH132
of Delivery (POD) form is returned with WH190 WH30.1
an acknowledgment. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-INVC-PREFIX Alpha 2 BL92.1 OE114
Element: Invoice PrefixThis 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 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-INVC-NUMBER Numeric 8 BL92.1 OE114
Element: Invoice NumberThis field contains the invoice number OE129 WH130
assigned by the system. 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.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-REQ-COMPANY Numeric 4 BL92.1 OE114
Element: Company This field contains the requesting WH130 WH132
company. 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-DOC-NBR-NUM Numeric 10
Element: Doc Nbr Num This field contains the numeric version
of the document number.
WHS-ORIGIN Derived
Element: Origin This literal helps to indicate in which
Lawson system the document originated.
WHS-DAYS-LATE Derived
Element: Days Late This field contains the number of days
after the requested date that you sent a
shipment.
WHS-DAYS-LATE-COND Derived
Element: Days Late CondThis flag helps to indicate whether or
not a shipment was late.
WHS-DAYS-LATE-CTR Derived
Element: Days Late CounThis flag will be either zero or one,
indicating if the shipment was late or
not.
WHS-LAST-DATE Derived
Element: Last Activity 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
Element: Ready To StatuThis field indicates the shipment
status the shipment is about to go to,
based on the process type.
WHS-RDY-TO-LITERAL Derived
Element: Ready To LiterThis literal is used to help display
the status a shipment is about to go to.
WHS-INTRASTAT-NBR Numeric 12 BL92.1 OE114
Element: Intrastat Nbr The number assigned by the Intrastat WH130 WH132
system to a transaction that involves WH190 WH30.1
Intrastat reporting after it has been WH30.2 WH30.3
added. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-FOB-CODE Alpha 3 BL92.1 OE114
Element: Shipping Term 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PORT-CD Alpha 5 BL92.1 OE114
Element: Port Cd The Intrastat port code. Must be WH130 WH132
define WH190 WH30.1
in IN04.1 (Port Maintenance) WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-NOTC Alpha 2 BL92.1 OE114
Element: Notc The Nature of Transaction code. Must WH130 WH132
be a valid code defined in IN07.1 (NOTC WH190 WH30.1
Maintenance). WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-STAT-PROC Alpha 6 BL92.1 OE114
Element: Stat Proc The statistical procedure code applied WH130 WH132
to the data. The code must be defined WH190 WH30.1
in IN06.1. (Statistical Procedure WH30.2 WH30.3
Maintenance). WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-VAT-REG-NBR Alpha 12 BL92.1 OE114
Element: Vat Reg Nbr The number component of the VAT WH130 WH132
Registration Number. This field together WH190 WH30.1
with the Registration Country field make WH30.2 WH30.3
up the VAT Registration Number. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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 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 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE810 OE830
WH126 WH130
WH132 WH190
...
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.3 WH31.3
SHIPMENT-NBR WH32.3 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 BL122
SYSTEM-CD BL130 BL20.1
DOC-NBR BL20.3 BL21.2
SHIPMENT-NBR BL21.5 BL29.1
LOCATION BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE271 OE272
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE530
OE830 POIF.1
POIG.1 RQ300
...
WHSSET8 COMPANY OE229 OE88.1
LOCATION RQ35.1 WH30.1
SYSTEM-CD WH31.1 WH32.1
DOC-NBR
SHIPMENT-NBR
WHSSET9 COMPANY This index was created as a solution to BL92.1 OE114
SHIPMENT-NBR the Find Next/Prev Flag error. It is WH130 WH132
LOCATION only used where a modify must be done WH190 WH224
within a 850-FIND-NLT or 850-FIND-BEGRNG WH30.1 WH30.2
loop. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
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-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
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 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
|