 |
Lawson Insight Technical Documentation |
|
WHSHPMTOUT FILE
UPDATED BY
WH130 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH330 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSO-COMPANY Numeric 4 WH130 WH33.1
Company The company number represents an WH33.2 WH33.3
established company and is entered on WH33.4 WH33.5
all function codes. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-LOCATION Alpha 5 WH130 WH33.1
Location Code This field contains a valid stocking WH33.2 WH33.3
location within the company inventory. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIPMENT-NBR Numeric 10 WH130 WH33.1
Shipment Number This field contains the shipment WH33.2 WH33.3
number. One order can have several WH33.4 WH33.5
shipment numbers if the items of the WH33.6 WH33.8
order were not shipped at the same time. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CREATION-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Creation Date This is the date that this line was WH33.2 WH33.3
added to the requisition. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CREATION-TIME Numeric 6 (hhmmss) WH130 WH33.1
Creation Time The creation time. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-INTERFACE-STS Numeric 1 WH130 WH33.1
Interface Sts WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SYSTEM-CD Alpha 2 WH130 WH33.1
System Code This field indicates on what system the WH33.2 WH33.3
transaction originated. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-DOC-NBR Alpha 10 (Right Justified) WH130 WH33.1
Doc Nbr WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-DOC-TYPE Alpha 2 WH130 WH33.1
Document Type This field contains the type of WH33.2 WH33.3
transaction. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PROCESS-LEVEL Alpha 5 WH130 WH33.1
Process Level This field contains the process level, WH33.2 WH33.3
which is the reporting hierarchy below WH33.4 WH33.5
company. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BATCH-NBR Numeric 6 WH130 WH33.1
Batch Number This identifies the batch the entered WH33.2 WH33.3
invoices, debit memos, and credit memos WH33.4 WH33.5
are a part of. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-STATUS Numeric 1 WH130 WH33.1
Status This field displays the status of the WH33.2 WH33.3
transaction. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CUST-PO-NBR Alpha 22
Customer P.O. Number
WSO-OPR-CODE Alpha 10 (Lower Case) WH130 WH33.1
Operator Code This field contains the operator code. WH33.2 WH33.3
This is the user ID of the person who WH33.4 WH33.5
last maintained this record. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-DESTINATION Alpha 15 WH130 WH33.1
Destination WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CUSTOMER Alpha 9 (Right Justified) WH130 WH33.1
Customer Number This field contains the number that WH33.2 WH33.3
represents a customer. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CUST-SHIP-TO Numeric 4 WH130 WH33.1
Customer Ship to This field contains the ship to WH33.2 WH33.3
Number customer number. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-REQ-LOCATION Alpha 5 WH130 WH33.1
To Location The location requisitioning items. WH33.2 WH33.3
This location can be an inventory or WH33.4 WH33.5
noninventory location. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-NAME Alpha 30 (Lower Case) WH130 WH33.1
Ship-to Name WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-ADDR1 Alpha 30 (Lower Case) WH130 WH33.1
Ship-to Address WH33.2 WH33.3
Line 1 WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-ADDR2 Alpha 30 (Lower Case) WH130 WH33.1
Ship-to Address WH33.2 WH33.3
Line 2 WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-ADDR3 Alpha 30 (Lower Case) WH130 WH33.1
Ship To Addr3 WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-ADDR4 Alpha 30 (Lower Case) WH130 WH33.1
Ship To Addr4 WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-CITY Alpha 18 WH130 WH33.1
Ship-to City WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-STATE Alpha 2 WH130 WH33.1
Ship-to State or WH33.2 WH33.3
Province WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-ZIP Alpha 10 WH130 WH33.1
Ship-to Postal Code WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-CNTRY Alpha 30 (Lower Case) WH130 WH33.1
Ship-to Country WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-NAME Alpha 30 (Lower Case) WH130 WH33.1
Bill To Name WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-ADDR1 Alpha 30 (Lower Case) WH130 WH33.1
Bill To Addr1 WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-ADDR2 Alpha 30 (Lower Case) WH130 WH33.1
Bill To Addr2 WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-ADDR3 Alpha 30 (Lower Case) WH130 WH33.1
Bill To Addr3 WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-ADDR4 Alpha 30 (Lower Case) WH130 WH33.1
Bill To Addr4 WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-CITY Alpha 18 WH130 WH33.1
Bill To City WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-STATE Alpha 2 WH130 WH33.1
Bill To State WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-ZIP Alpha 10 WH130 WH33.1
Bill To Zip WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-TO-CNTRY Alpha 30 (Lower Case) WH130 WH33.1
Bill To Cntry WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PHONE-NMBR Alpha 15 WH130 WH33.1
Telephone Number WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PICKING-REQ Alpha 1 WH130 WH33.1
Picking Req WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PACKING-REQ Alpha 1 WH130 WH33.1
Packing Req WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-ORDER-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Order Date WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PRINT-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Print Date This field contains the date when the WH33.2 WH33.3
pick list was printed. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PICK-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Pick Date This field contains the pick date. WH33.2 WH33.3
The system date defaults. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PACK-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Pack Date This field contains the pack date. The WH33.2 WH33.3
system date defaults but can be WH33.4 WH33.5
overridden if you are using OE20.1 (On WH33.6 WH33.8
Line Allocation). WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Ship Date This field contains the ship date. If WH33.2 WH33.3
left blank, the system date defaults. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-GL-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
General Ledger Date This field contains the general ledger WH33.2 WH33.3
posting date. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-EST-DEL-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Estimated Delivery WH33.2 WH33.3
Date WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-VENDOR Alpha 9 (Right Justified) WH130 WH33.1
Vendor ID The vendor's identification code. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PO-FLAG Alpha 1
Po Flag
WSO-ROUTE Numeric 4
Route This field contains the route number.
The route assigned to the ship-to
customer defaults from the Order Entry
Route file.
WSO-STOP Numeric 4
Stop This field contains the stop within the
route. If left blank, the stop
associated with the ship to customer
defaults from OEROUTE.
WSO-BOL-NBR Alpha 22 WH130 WH33.1
Bill of Lading This field contains the Bill of Lading WH33.2 WH33.3
Number number. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CARRIER Alpha 9 (Right Justified) WH130 WH33.1
Carrier Vendor This is the carrier vendor number. It WH33.2 WH33.3
Number must be a valid vendor. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-METHOD Alpha 10 WH130 WH33.1
Method Code The method. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-TRANS-ID Alpha 20 WH130 WH33.1
Trans Id WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-FREIGHT-REQ Alpha 1 WH130 WH33.1
Freight Req WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-FREIGHT-CODE Alpha 2 WH130 WH33.1
Freight Code This field contains the freight code. WH33.2 WH33.3
This is must be valid in OEFRTCODE. This WH33.4 WH33.5
determines whether carrier and charge WH33.6 WH33.8
are allowed for the shipment. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-FRT-CHG-CURR Signed 15.2 WH130 WH33.1
Frt Chg Curr WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-WHS-CARTONS Numeric 6 WH130 WH33.1
Whs Cartons WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-CUBIC-FEET Signed 9.3 WH130 WH33.1
Cubic Feet This field contains the unit cubit feet WH33.2 WH33.3
of the item based on the stocking UOM. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-WEIGHT Signed 9.3 WH130 WH33.1
Unit Weight This field contains the unit weight of WH33.2 WH33.3
the item based on the stocking UOM. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-PACK-LIST-FL Alpha 1 WH130 WH33.1
Pack List Fl This field indicates if the packing WH33.2 WH33.3
list has been printed. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-POD-PRT-FL Alpha 1 WH130 WH33.1
Pod Prt Fl This is the POD (Proof of Delivery) WH33.2 WH33.3
Print Flag. The POD print program sets WH33.4 WH33.5
this flag to (Y)es after printing a POD. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-POD-RETRN-DT Numeric 8 (yyyymmdd) WH130 WH33.1
Pod Retrn Dt This field contains the date the POD is WH33.2 WH33.3
returned with an acknowledgment. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-INVC-PREFIX Alpha 2 WH130 WH33.1
Invoice Prefix This field contains the invoice prefix WH33.2 WH33.3
that is assigned from either the company WH33.4 WH33.5
or process level, depending on the WH33.6 WH33.8
invoice-level option chosen. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-INVC-NUMBER Numeric 8 WH130 WH33.1
Invc Number This field contains the invoice number WH33.2 WH33.3
assigned by the system. Invoice numbers WH33.4 WH33.5
are assigned at the company or process WH33.6 WH33.8
level, depending on an invoice-level WH33.9 WH34.1
option on the company file. WH34.2 WH34.3
WH34.4
WSO-TO-CNTRY-CD Alpha 2 WH130 WH33.1
To Cntry Cd The Ship-To country code. Must be WH33.2 WH33.3
defined in IN01.1 (Country WH33.4 WH33.5
Maintenaance). WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-SHIP-TO-REGION Alpha 2 WH130 WH33.1
Ship To Region The ship-to region code. WH33.2 WH33.3
Must be a valid region for the country, WH33.4 WH33.5
defined in IN02.1 (Region WH33.6 WH33.8
Maintenance). WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-TO-EC-CTRY Numeric 3 WH130 WH33.1
To Ec Ctry WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-TO-ISO-CTRY Numeric 3 WH130 WH33.1
To Iso Ctry WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-CTRY-CD Alpha 2 WH130 WH33.1
Bill Ctry Cd WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-REGION Alpha 2 WH130 WH33.1
Bill Region The Bill-To region code. Must be a WH33.2 WH33.3
valid region for the country, defined in WH33.4 WH33.5
IN02.1 (Region Maintenance). WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-EC-CTRY Numeric 3 WH130 WH33.1
Bill Ec Ctry WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WSO-BILL-ISO-CTRY Numeric 3 WH130 WH33.1
Bill Iso Ctry WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHSHPMTOUT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSOSET1 COMPANY WH330
LOCATION
SHIPMENT-NBR
CREATION-DATE
CREATION-TIME
WSOSET2 COMPANY
LOCATION
INTERFACE-STS
SHIPMENT-NBR
CREATION-DATE
CREATION-TIME
WSOSET3 COMPANY
LOCATION
BATCH-NBR
SHIPMENT-NBR
|