WHSCOMPOUT – No description in the Lawson data dictionary

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

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

About WHSCOMPOUT

No description in the Lawson data dictionary.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
WCO-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
WCO-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
WCO-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
WCO-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
WCO-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the record sequence number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WCO-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
WCO-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
WCO-INTERFACE-STS
INTERFACE_STS		Numeric 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WCO-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
WCO-DOC-NBR
DOC_NBR		Alpha 10 (Right Justified)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WCO-ITEM
ITEM		Alpha 32This field contains the item identifier.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WCO-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WCO-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
WCO-DETAIL-REQ
DETAIL_REQ		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WCO-UNIT-COST
UNIT_COST		Signed 18.5—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
WCOSET1COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, CREATION-DATE, CREATION-TIMEPrimaryWH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +22 more (list truncated in source)
WCOSET2COMPANY, LOCATION, INTERFACE-STS, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, CREATION-DATE, CREATION-TIME—

Programs

Updated by (33)