Lawson Insight Technical Documentation |
|
WHSHIPMENT
WHSHIPMENT FILE
Shipment
The Shipment file carries a record for every shipment created for every
document.
REFERENCED BY
RQD0.1 RQD1.1 WH225 WH38.1 WH80.1 WH80.3
WH80.4 WH80.2 WH81.1 WHD2.1 WHD3.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.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 Numeric 4 WH130 WH132
Element: 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
Element: 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
Element: 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
Element: Shipment NumbeThis 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 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 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
Element: Requesting LocThis 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
WHD0.1
WHS-OPR-CODE Alpha 10 (Lower Case) WH130 WH132
Element: Requester 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
Element: Picking RequirThis 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
Element: Packing RequirThis 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
Element: Date 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) WH130 WH132
Element: 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
Element: 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
Element: 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
Element: Date 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) WH130 WH132
Element: Expected Ship 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
Element: 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 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 WH130 WH132
Element: 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
Element: 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
Element: Carrier NumberThis 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
Element: Opt Method 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
Element: TransportationThis 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
Element: Add On Cost CoThis 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
Element: Freight RequirThis 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
Element: Number of CartThis 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
Element: 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.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 WH130 WH132
Element: 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.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 WH130 WH132
Element: Pack List FlagY = Yes WH190 WH224
N = No 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-POD-PRT-FL Alpha 1 WH126 WH130
Element: POD Print FlagThis 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
Element: POD Return DatThis 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
Element: Invoice PrefixThis 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
Element: Invoice NumberThis 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 WH130 WH132
Element: Company This field contains the requesting WH190 WH30.1
company. 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 WH130 WH132
Element: 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
Element: Shipping Term 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
Element: 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
Element: 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
Element: 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
Element: 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
WHSHIPMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHSSET1 COMPANY Primary index used for accessing and RQD0.1 RQD1.1
LOCATION updating the table. WH126 WH130
SHIPMENT-NBR WH132 WH190
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
...
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
|