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