WHSCMNTOUT – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WIO
Primary key
COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, SEQ, CREATION-DATE, CREATION-TIME
Fields
13
Updated by
33 programs
Referenced by
0 programs

WHSCMNTOUT is a Lawson Warehouse table (prefix WIO); no description in the lawson data dictionary. It is indexed by COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, SEQ, CREATION-DATE, CREATION-TIME (WIOSET1); alternate indexes: WIOSET2. It is updated by WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 and 25 more. The table has 13 fields, 2 indexes and 0 documented relations.

About WHSCMNTOUT

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
WIO-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
WIO-SYSTEM-CD PK
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
WIO-DOC-NBR PK
DOC_NBR		Alpha 10 (Right Justified)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WIO-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
WIO-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WIO-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
WIO-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
WIO-INTERFACE-STS
INTERFACE_STS		Numeric 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WIO-COMMENT
COMMENT		Alpha 40 (Lower Case)This field contains the comment narrative.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WIO-PRINT-CODE
PRINT_CODE		Alpha 1This field contains the print code, which defines where comments are displayed or printed.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WIO-PICK-FL
PICK_FL		Alpha 1This field indicates whether comments are printed on the pick list.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WIO-SHIPMENT-NBR
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
WIO-SHIP-LINE-NBR
SHIP_LINE_NBR		Numeric 6——

Indexes (2)

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

IndexKeysFlagsConditionUsed in
WIOSET1COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, SEQ, CREATION-DATE, CREATION-TIMEPrimaryWH330
WIOSET2COMPANY, INTERFACE-STS, SYSTEM-CD, DOC-NBR, LINE-NBR, SEQ, CREATION-DATE, CREATION-TIME—

Programs

Updated by (33)