 |
Lawson Insight Technical Documentation |
|
WHSHIPMENT FILE
Shipment
The Shipment file carries a record for every shipment created for every
document.
REFERENCED BY
WH225 WH38.1 WH80.1 WH80.3 WH80.4 WH80.2
WH81.1 WH140 WH131 POIF.1 POIG.1 RQ35.1
UPDATED BY
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.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHS-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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-SYSTEM-CD Alpha 2 WH130 WH132
System Code This field indicates on 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-DOC-NBR Alpha 10 (Right Justified) WH130 WH132
Doc Nbr This field contains the document number WH190 WH30.1
within the shipment. 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 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-DOC-TYPE Alpha 2
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 WH130 WH132
Customer Ship-To This field contains the ship-to WH190 WH30.1
Number customer number. 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 WH130 WH132
Requesting Location This field contains the requesting WH190 WH30.1
location. This location can be an WH30.2 WH30.3
inventory or nonstock location. 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 WH130 WH132
Destination This field represents the destination WH190 WH30.1
to which shipments are being sent. 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 WH130 WH132
Process Level This field contains the process level WH190 WH30.1
assigned to 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-BATCH-NBR Numeric 6 WH130 WH132
Batch Number This identifies the batch number WH190 WH30.1
assigned to the shipment when you ran WH30.2 WH30.3
WH130 (Pick List Print). 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 WH130 WH132
Status This field contains the status of the WH190 WH30.1
shipment. WH30.2 WH30.3
0 = Printed WH30.4 WH31.1
1 = Picked WH31.2 WH31.3
2 = Packed WH31.4 WH32.1
3 = Shipped WH32.2 WH32.3
4 = Released WH32.4 WH33.5
5 = Closed WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-OPR-CODE Alpha 10 (Lower Case) WH130 WH132
Operator Code This field contains the operator code WH190 WH30.1
or the 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PICKING-REQ Alpha 1 WH130 WH132
Picking Required This field indicates whether or not WH190 WH30.1
picking feedback is required based on WH30.2 WH30.3
the process type. WH30.4 WH31.1
Y = Yes WH31.2 WH31.3
N = No 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 WH130 WH132
Packing Required This field indicates whether or not WH190 WH30.1
packing feedback is required based on WH30.2 WH30.3
the process type. WH30.4 WH31.1
Y = Yes WH31.2 WH31.3
N = No 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) WH130 WH132
Print Date This field contains the date when the WH190 WH30.1
pick list was printed. 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) WH130 WH132
Pick Date This field contains the date that WH190 WH30.1
picking feedback was performed. The WH30.2 WH30.3
system date defaults. 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) WH130 WH132
Pack Date This field contains the pack date. The WH190 WH30.1
system date defaults but can be WH30.2 WH30.3
overridden if you are using the WH20 WH30.4 WH31.1
form series. 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) WH130 WH132
Ship Date This field contains the ship date. If WH190 WH30.1
left blank, the 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-GL-DATE Numeric 8 (yyyymmdd) WH130 WH132
General Ledger Date This field contains the general ledger WH190 WH30.1
posting date. 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) WH130 WH132
Expected Ship Date This field contains the expected ship WH190 WH30.1
date. If you leave the field blank and WH30.2 WH30.3
no ship days are defined on the WH30.4 WH31.1
document's process level, the document WH31.2 WH31.3
date defaults. If ship days exist on WH31.4 WH32.1
the process level, ship days are added WH32.2 WH32.3
to the document date to calculate the WH32.4 WH33.5
expected ship date. WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-VENDOR Alpha 9 (Right Justified) WH130 WH132
Vendor ID The vendor's identification 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PO-FLAG Alpha 1
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 WH130 WH132
Route This field contains the route number. WH190 WH30.1
The route assigned to the ship-to WH30.2 WH30.3
customer 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-STOP Numeric 4 WH130 WH132
Stop This field contains the stop within the WH190 WH30.1
route. If left blank, the stop WH30.2 WH30.3
associated with the ship-to customer WH30.4 WH31.1
defaults from the Route file. 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 WH130 WH132
Bill of Lading This field contains the Bill of Lading WH190 WH30.1
Number number for the shipment. 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) WH130 WH132
Carrier Number This field contains the carrier WH190 WH30.1
number. The carrier must be valid in WH30.2 WH30.3
the Lawson Accounts Payable 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-METHOD Alpha 10 WH130 WH132
Method Code This field contains the shipping method WH190 WH30.1
that you defined using WH11.1 (Shipping WH30.2 WH30.3
Method). 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 WH130 WH132
Transportation ID This field contains the transportation WH190 WH30.1
identification, which prints on the WH30.2 WH30.3
invoice and Bill of Lading. 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 WH130 WH132
Freight Code This field contains the freight code. WH190 WH30.1
This must be valid in the Order Entry WH30.2 WH30.3
Freight Code file. This determines WH30.4 WH31.1
whether carrier and charge are allowed WH31.2 WH31.3
for the shipment. 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 WH130 WH132
Freight Required This field indicates whether or not WH190 WH30.1
freight charges are required on this WH30.2 WH30.3
shipment. Freight codes are defined in WH30.4 WH31.1
the Lawson Billing system. 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 15.2 WH130 WH132
Freight Charge This field contains the freight charge WH190 WH30.1
Currency amount in billing currency. 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 WH130 WH132
Number of Cartons This field contains the total number of WH190 WH30.1
cartons in the shipment. 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 WH130 WH132
Cubic Feet This field contains the total of all WH190 WH30.1
the shipment line's calculated cubic WH30.2 WH30.3
measurements based on the item master WH30.4 WH31.1
stock cubic values. 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-ADJ Signed 9.3
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
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 WH130 WH132
Unit Weight This field contains the total of all WH190 WH30.1
the shipment line's calculated weight WH30.2 WH30.3
based on the item master stock weight WH30.4 WH31.1
values. 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-WEIGHT-ADJ Signed 9.3
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
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 WH130 WH132
Pack List Flag This field indicates if the packing WH190 WH224
list has been printed. WH30.1 WH30.2
Y = Yes WH30.3 WH30.4
N = No 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 WH126 WH130
POD Print Flag This field represents the Proof of WH132 WH190
Delivery (POD) Print flag. WH126 (POD WH30.1 WH30.2
Print) sets this flag to Yes after WH30.3 WH30.4
printing a POD. WH31.1 WH31.2
Y = Yes WH31.3 WH31.4
N = No 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) WH130 WH132
POD Return Date This field contains the date the Proof WH190 WH30.1
of Delivery (POD) form is returned with WH30.2 WH30.3
an acknowledgment. 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 WH130 WH132
Invoice Prefix This field contains the invoice prefix WH190 WH30.1
that is assigned from either the billing WH30.2 WH30.3
company or process level, depending on WH30.4 WH31.1
the invoice-level option chosen. 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 WH130 WH132
Invoice Number This field contains the invoice number WH190 WH30.1
assigned by the system. 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
Req Company This field contains the requesting
company.
WHS-DOC-NBR-NUM Numeric 10
Doc Nbr Num This field contains the numeric version
of the document number.
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.
WHS-INTRASTAT-NBR Numeric 12 WH130 WH132
Intrastat Nbr The number assigned by the Intrastat WH190 WH30.1
system to a transaction that involves WH30.2 WH30.3
Intrastat reporting after it has been WH30.4 WH31.1
added. 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 WH130 WH132
Shipping Term Code The user defined Free On Board 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.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-PORT-CD Alpha 5 WH130 WH132
Port Cd The Intrastat port code. Must be WH190 WH30.1
define WH30.2 WH30.3
in IN04.1 (Port 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-NOTC Alpha 2 WH130 WH132
Notc The Nature of Transaction code. Must WH190 WH30.1
be a valid code defined in IN07.1 (NOTC 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-STAT-PROC Alpha 6 WH130 WH132
Stat Proc The statistical procedure code applied WH190 WH30.1
to the data. The code must be defined WH30.2 WH30.3
in IN06.1. (Statistical Procedure WH30.4 WH31.1
Maintenance). 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 WH130 WH132
Vat Reg Nbr The number component of the VAT WH190 WH30.1
Registration Number. This field together WH30.2 WH30.3
with the Registration Country field make WH30.4 WH31.1
up the VAT Registration Number. 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-RQSRC-MACHINE Alpha 6
Rqsrc Machine
WHS-PAR-ORDER-ID Alpha 20
Par Order Id
WHSHIPMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHSSET1 COMPANY Primary index used for accessing and WH126 WH130
LOCATION updating the table. WH132 WH190
SHIPMENT-NBR WH222 WH224
WH225 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
...
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. WH130 WH131
LOCATION WH132 WH30.3
BATCH-NBR WH31.3 WH32.3
SHIPMENT-NBR WH80.4
WHSSET6 COMPANY Used to find shipments that are shipped
LOCATION but not invoiced.
DOC-NBR Subset
SHIPMENT-NBR Where (SYSTEM-CD = "OE" )
And (STATUS = 4 )
WHSSET7 COMPANY Used to find the originating system. POIF.1 POIG.1
SYSTEM-CD RQ300 WH130
DOC-NBR WH132 WH190
SHIPMENT-NBR WH222 WH30.1
LOCATION 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
...
WHSSET8 COMPANY RQ35.1 WH30.1
LOCATION WH31.1 WH32.1
SYSTEM-CD
DOC-NBR
SHIPMENT-NBR
WHSSET9 COMPANY This index was created as a solution to WH130 WH132
SHIPMENT-NBR the Find Next/Prev Flag error. It is WH190 WH224
LOCATION only used where a modify must be done WH30.1 WH30.2
within a 850-FIND-NLT or 850-FIND-BEGRNG WH30.3 WH30.4
loop. 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
|