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
RQD0.1 RQD1.1 WH20.2 WH20.7 WH225 WH25.1
WH25.2 WH38.1 WH80.1 WH80.3 WH80.4 WH80.2
WH81.1 WHD2.1 WHD3.1 WH82.1 WH140 WH131
POIF.1 POIG.1
UPDATED BY
BL92.1 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 BL92.1 WH130
Element: Company This field contains the company number. 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 WH130
Element: System Cd This field indicates on which Lawson WH132 WH190
system the document originated. WH30.1 WH30.2
OE = Customer Order WH30.3 WH30.4
RQ = Requisitions WH31.1 WH31.2
CX = Case Cart 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 WH130
Element: Doc Nbr This field contains the document number WH132 WH190
within the shipment. 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 WH130
Element: Shipment Nbr This field contains the shipment WH132 WH190
number. One document can have several WH30.1 WH30.2
shipment numbers if the items were not WH30.3 WH30.4
shipped at the same time. 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: Doc 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 WH130
Customer Ship-To This field contains the ship-to WH132 WH190
Number customer number. 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 WH130
Element: Requesting LocThis field contains the requesting WH132 WH190
location. This location can be an WH30.1 WH30.2
inventory or nonstock location. 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 WH130
Element: Destination This field represents the destination WH132 WH190
to which shipments are being sent. 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 WH130
Element: Process Level This field contains the process level WH132 WH190
assigned to the document. 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 WH130
Element: Location This field contains a valid stock WH132 WH190
location within the company inventory. 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 WH130
Element: Batch Nbr This identifies the batch number WH132 WH190
assigned to the shipment when you ran WH30.1 WH30.2
Pick List Print (WH130). 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 WH130
Element: Status This field contains the status of the WH132 WH190
shipment. WH30.1 WH30.2
0 = Printed WH30.3 WH30.4
1 = Picked WH31.1 WH31.2
2 = Packed WH31.3 WH31.4
3 = Shipped WH32.1 WH32.2
4 = Released WH32.3 WH32.4
5 = Closed WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WHD0.1
WHS-OPR-CODE Alpha 10 (Lower Case) BL92.1 WH130
Element: Opr Code This field contains the operator code WH132 WH190
or the user ID of the person who last WH30.1 WH30.2
updated this record. 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 WH130
Element: Picking RequirThis field indicates whether or not WH132 WH190
picking feedback is required based on WH30.1 WH30.2
the process type. 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-PACKING-REQ Alpha 1 BL92.1 WH130
Element: Packing RequirThis field indicates whether or not WH132 WH190
packing feedback is required based on WH30.1 WH30.2
the process type. 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-PRINT-DATE Numeric 8 (yyyymmdd) BL92.1 WH130
Element: Date This field displays the system date WH132 WH190
when this was created. 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 WH130
Element: Date This field contains the date that WH132 WH190
picking feedback was performed. The WH30.1 WH30.2
system date defaults. 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 WH130
Element: Date This field contains the pack date. The WH132 WH190
system date defaults but can be WH30.1 WH30.2
overridden if you are using the WH20 WH30.3 WH30.4
form series. 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 WH130
Element: Date This field displays the system date WH132 WH190
when this was created. 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 WH130
Element: Gl Date This field contains the general ledger WH132 WH190
posting date. 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 WH130
Element: Expected Ship This field contains the expected ship WH132 WH190
date. If you leave the field blank and WH30.1 WH30.2
no ship days are defined on the WH30.3 WH30.4
document's process level, the document WH31.1 WH31.2
date defaults. If ship days exist on WH31.3 WH31.4
the process level, ship days are added WH32.1 WH32.2
to the document date to calculate the WH32.3 WH32.4
expected ship date. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHS-VENDOR Alpha 9 (Right Justified) BL92.1 WH130
Element: Vendor The vendor's identification code. 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 WH130
Element: Route This field contains the route number. WH132 WH190
The route assigned to the ship-to WH30.1 WH30.2
customer defaults from the Route file. 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 WH130
Element: Stop This field contains the stop within the WH132 WH190
route. If left blank, the stop WH30.1 WH30.2
associated with the ship-to customer WH30.3 WH30.4
defaults from the Route file. 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 WH130
Element: Bol Nbr This field contains the Bill of Lading WH132 WH190
number for the shipment. 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 WH130
number. The carrier must be valid in WH132 WH190
Accounts Payable. 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 This field contains the shipping method BL92.1 WH130
that you defined using Shipping Method WH132 WH190
(WH11.1). 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 WH130
identification, which prints on the WH132 WH190
invoice and Bill of Lading. 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 WH130
Element: Freight Code This field contains the freight code. WH132 WH190
This must be valid in the Order Entry WH30.1 WH30.2
Freight Code file. This determines WH30.3 WH30.4
whether carrier and charge are allowed WH31.1 WH31.2
for the shipment. 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 WH130
Element: Freight RequirThis field indicates whether or not WH132 WH190
freight charges are required on this WH30.1 WH30.2
shipment. Freight codes are defined in WH30.3 WH30.4
the Lawson Billing system. 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 WH130
Freight Charge This field contains the freight charge WH132 WH190
Currency amount in billing currency. 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 WH130
Element: Cartons This field contains the total number of WH132 WH190
cartons in the shipment. 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 WH130
Element: Cubic Feet This field contains the total of all WH132 WH190
the shipment line's calculated cubic WH30.1 WH30.2
measurements based on the item master WH30.3 WH30.4
stock cubic values. 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 WH130
Element: Weight This field contains the total of all WH132 WH190
the shipment line's calculated weight WH30.1 WH30.2
based on the item master stock weight WH30.3 WH30.4
values. 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 WH130
Element: Pack List FlagY = Yes WH132 WH190
N = No 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
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHS-POD-PRT-FL Alpha 1 BL92.1 WH126
Element: POD Print FlagThis field represents the Proof of WH130 WH132
Delivery (POD) Print flag. WH126 (POD WH190 WH30.1
Print) sets this flag to Yes after WH30.2 WH30.3
printing a POD. 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-POD-RETRN-DT Numeric 8 (yyyymmdd) BL92.1 WH130
Element: POD Return DatThis field contains the date the Proof WH132 WH190
of Delivery (POD) form is returned with WH30.1 WH30.2
an acknowledgment. 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 WH130
Element: Invc Prefix This field contains the invoice prefix WH132 WH190
that is assigned from either the billing WH30.1 WH30.2
company or process level, depending on WH30.3 WH30.4
the invoice-level option chosen. 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 WH130
Element: Invoice NumberThis field contains the invoice number WH132 WH190
assigned by the system. 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 WH130
Element: Company This field contains the requesting WH132 WH190
company. 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 WH130
Element: Intrastat Nbr The number assigned by the Intrastat WH132 WH190
system to a transaction that involves WH30.1 WH30.2
Intrastat reporting after it has been WH30.3 WH30.4
added. 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 WH130
Element: Fob Code The user defined Free On Board Code. 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 WH130
Element: Port Cd The Intrastat port code. Must be WH132 WH190
define WH30.1 WH30.2
in IN04.1 (Port Maintenance) 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 WH130
Element: Notc The Nature of Transaction code. Must WH132 WH190
be a valid code defined in IN07.1 (NOTC WH30.1 WH30.2
Maintenance). 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 WH130
Element: Stat Proc The statistical procedure code applied WH132 WH190
to the data. The code must be defined WH30.1 WH30.2
in IN06.1. (Statistical Procedure WH30.3 WH30.4
Maintenance). 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 WH130
Element: Vat Reg Nbr The number component of the VAT WH132 WH190
Registration Number. This field together WH30.1 WH30.2
with the Registration Country field make WH30.3 WH30.4
up the VAT Registration Number. 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 BL120 BL122
LOCATION BL130 BL20.1
SHIPMENT-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL80.1 BL820
BL92.1 RQD0.1
RQD1.1 WH126
WH130 WH132
WH190 WH20.2
WH20.7 WH222
WH224 WH225
WH25.1 WH25.2
WH30.1 WH30.2
WH30.3 WH30.4
...
WHSSET10 COMPANY Subset WH82.1
LOCATION Where STATUS < 4
SHIPMENT-NBR*
WHSSET11 COMPANY
LOCATION
SHIPMENT-NBR*
WHSSET2 COMPANY KeyChange, Subset WH140 WH40.2
LOCATION Where (BOL-NBR != Spaces )
BOL-NBR
SHIPMENT-NBR
WHSSET3 COMPANY KeyChange WH40.1
LOCATION
CARRIER
BOL-NBR
SHIPMENT-NBR
WHSSET4 COMPANY Subset WH190
LOCATION Where (STATUS = 3 )
BATCH-NBR
SHIPMENT-NBR
WHSSET5 COMPANY WH130 WH131
LOCATION WH132 WH30.3
BATCH-NBR WH31.3 WH32.3
SHIPMENT-NBR WH80.4
WHSSET6 COMPANY Subset
LOCATION Where (SYSTEM-CD = "OE" )
DOC-NBR And (STATUS = 4 )
SHIPMENT-NBR
WHSSET7 COMPANY 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
POIF.1 POIG.1
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
...
WHSSET8 COMPANY WH130 WH30.1
LOCATION WH31.1 WH32.1
SYSTEM-CD
DOC-NBR
SHIPMENT-NBR
WHSSET9 COMPANY BL92.1 WH130
SHIPMENT-NBR WH132 WH190
LOCATION 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
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
|