WHSLINEOUT – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WLO
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, CREATION-DATE, CREATION-TIME
Fields
30
Updated by
33 programs
Referenced by
0 programs

WHSLINEOUT is a Lawson Warehouse table (prefix WLO); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, CREATION-DATE, CREATION-TIME (WLOSET1); alternate indexes: WLOSET2. It is updated by WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 and 25 more. The table has 30 fields, 2 indexes and 0 documented relations.

About WHSLINEOUT

No description in the Lawson data dictionary.

Fields (30)

Column = COBOL field name without the WLO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
WLO-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-CREATION-DATE PK
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-CREATION-TIME PK
CREATION_TIME		Numeric 6 (hhmmss)The creation time.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-INTERFACE-STS
INTERFACE_STS		Numeric 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-SYSTEM-CD
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-DOC-NBR
DOC_NBR		Alpha 10 (Right Justified)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-OPR-CODE
OPR_CODE		Alpha 10 (Lower Case)This field contains the operator code. This is the user ID of the person who last maintained this record.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-LINE-TYPE
LINE_TYPE		Alpha 1This field contains the type of inventory on this line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-ITEM
ITEM		Alpha 32This field contains the item identifier.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-TRAN-UOM
TRAN_UOM		Alpha 4This field contains the valid stock unit of measure for this item.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-TRAN-UOM-MULT
TRAN_UOM_MULT		Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-PRINTED-QTY
PRINTED_QTY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-IN-PROCESS-QTY
IN_PROCESS_QTY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-SHIPPED-QTY
SHIPPED_QTY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-CATCH-WT-QTY
CATCH_WT_QTY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-PRE-ASMBLD-KIT
PRE_ASMBLD_KIT		Signed 13.4—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-DETAIL-QTY
DETAIL_QTY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-DTL-CTW-QTY
DTL_CTW_QTY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-DETAIL-REQ
DETAIL_REQ		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-WALK-THRU-REQ
WALK_THRU_REQ		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-UNIT-COST
UNIT_COST		Signed 18.5—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-CUBIC-FEET
CUBIC_FEET		Signed 9.3This field contains the unit cubic feet of the item based on the stocking UOM.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-MSDS-DT
MSDS_DT		Numeric 8 (yyyymmdd)This date is the date that a new Material Safety Data Sheet should be sent from the vendor.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-UPC-CODE
UPC_CODE		Alpha 13—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WLO-KIT-FLAG
KIT_FLAG		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WLOSET1COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, CREATION-DATE, CREATION-TIMEPrimaryWH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +22 more (list truncated in source)
WLOSET2COMPANY, LOCATION, INTERFACE-STS, SHIPMENT-NBR, LINE-NBR, CREATION-DATE, CREATION-TIME—

Programs

Updated by (33)