WHSLINEOUT 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 WLO-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 WLO-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 WLO-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 WLO-LINE-NBR Numeric 6 BL92.1 OE114 Line Number This field contains the line number. 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 WLO-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 WLO-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 WLO-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 WLO-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 WLO-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 WLO-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 WLO-LINE-TYPE Alpha 1 BL92.1 OE114 Line Type This field contains the type of WH130 WH132 inventory on this line. 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 WLO-ITEM Alpha 32 BL92.1 OE114 Item Number This field contains the item WH130 WH132 identifier. 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 WLO-DESCRIPTION Alpha 30 (Lower Case) BL92.1 OE114 Description This field contains the description. 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 WLO-TRAN-UOM Alpha 4 Transaction Unit of Measure WLO-TRAN-UOM-MULT Signed 13.7 Transaction UOM Multiplier WLO-PRINTED-QTY Signed 13.4 BL92.1 OE114 Printed on Pick This field contains the quantity that WH130 WH132 List Quantity was printed on the picklist to be WH190 WH30.1 picked. 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 WLO-IN-PROCESS-QTY Signed 13.4 BL92.1 OE114 In Process Qty 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 WLO-SHIPPED-QTY Signed 13.4 BL92.1 OE114 Shipped Quantity 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 WLO-CATCH-WT-QTY Signed 13.4 BL92.1 OE114 Catch Weight This field contains the quantity WH130 WH132 Quantity received for catch weight shipments. 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 WLO-PRE-ASMBLD-KIT Signed 13.4 BL92.1 OE114 Pre Asmbld Kit 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 WLO-DETAIL-QTY Signed 13.4 BL92.1 OE114 Detail Qty This field shows the total quantity of WH130 WH132 details defined for a detail tracked WH190 WH30.1 item. It is matched against the line WH30.2 WH30.3 quantity field to determine if details WH31.1 WH31.2 are in balance. WH31.3 WH32.1 In the item detail screen, it is the WH32.2 WH32.3 quantity for a particular lot or bin. 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 WLO-DTL-CTW-QTY Signed 13.4 BL92.1 OE114 Dtl Ctw Qty 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 WLO-DETAIL-REQ Alpha 1 BL92.1 OE114 Detail 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 WLO-WALK-THRU-REQ Alpha 1 BL92.1 OE114 Walk Thru Req This field indicates that a transaction WH130 WH132 line is out of balance. For example, WH190 WH30.1 if lot, bin or serial quantities do not WH30.2 WH30.3 equal the transaction quantity, use the WH31.1 WH31.2 (W)alkThru screen function code to WH31.3 WH32.1 balance the transaction quantities. 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 WLO-UNIT-COST Signed 13.5 BL92.1 OE114 Unit Cost This field contains the unit cost. 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 WLO-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 WLO-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 WLO-MSDS-DT Numeric 8 (yyyymmdd) BL92.1 OE114 Material Safety This date is the date that a new WH130 WH132 DataSheet Date Material Safety Data Sheet should be WH190 WH30.1 sent from the vendor. 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 WLO-UPC-CODE Alpha 13 BL92.1 OE114 Upc 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 WLO-KIT-FLAG Alpha 1 BL92.1 OE114 Kit Flag 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 WHSLINEOUT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN WLOSET1 COMPANY BL92.1 OE114 LOCATION WH130 WH132 SHIPMENT-NBR WH190 WH30.1 LINE-NBR WH30.2 WH30.3 CREATION-DATE WH31.1 WH31.2 CREATION-TIME 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 ... WLOSET2 COMPANY LOCATION INTERFACE-STS SHIPMENT-NBR LINE-NBR CREATION-DATE CREATION-TIME |