ITCOMMENT – Comments

System
Inventory Control (IC)
Prefix
ICO
Primary key
ITEM-GROUP, ITEM, LANGUAGE-CODE, SEQ
Fields
8
Updated by
3 programs
Referenced by
12 programs

ITCOMMENT is the Comments table in Lawson Inventory Control (prefix ICO). It is indexed by ITEM-GROUP, ITEM, LANGUAGE-CODE, SEQ (ICOSET1). It is related 1:1 to ITEMGROUP and ITEMMAST. It is updated by IC11.1, IC18.1 and IC811 and referenced by IC110, IC210, IC211, IC212, PO130, PO220, PO230, POCP.1 and 4 more. The table has 8 fields, 1 index and 2 documented relations.

About ITCOMMENT

No description in the Lawson data dictionary.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
ICO-ITEM-GROUP PK
ITEM_GROUP
Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC18.1, IC811
ICO-ITEM PK
ITEM
Alpha 32This field contains the item identifier.IC18.1, IC811
ICO-SEQ PK
SEQ
Numeric 3This field contains the record sequence number.IC18.1, IC811
ICO-COMMENT
COMMENT
Alpha 40 (Lower Case)This field contains the comment narrative.
ICO-BEGIN-DATE
BEGIN_DATE
Numeric 8 (yyyymmdd)The begin date for this effort period.IC18.1, IC811
ICO-END-DATE
END_DATE
Numeric 8 (yyyymmdd)The end date for this effort period.IC18.1, IC811, WH130
ICO-COM-TYPE
COM_TYPE
Alpha 1IC18.1, IC811
ICO-LANGUAGE-CODE PK
LANGUAGE_CODE
Alpha 10Language Code (LOCALE).IC18.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ICOSET1ITEM-GROUP, ITEM, LANGUAGE-CODE, SEQPrimaryIC11.1, IC110, IC18.1, IC210, IC211, IC212, IC811, PO130 +7 more

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredICO-ITEM-GROUPITG-ITEM-GROUP
ItemmasterITEMMASTRequiredICO-ITEM-GROUPITE-ITEM-GROUP, ICO-ITEMITE-ITEM

Programs

Updated by (3)

Referenced by (12)