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