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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ICO-ITEM-GROUP PKITEM_GROUP | Alpha 5 | This field contains the identifier for a group of items that can be shared by one or more companies. | IC18.1, IC811 |
#ICO-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | IC18.1, IC811 |
#ICO-SEQ PKSEQ | Numeric 3 | This field contains the record sequence number. | IC18.1, IC811 |
#ICO-COMMENTCOMMENT | Alpha 40 (Lower Case) | This field contains the comment narrative. | — |
#ICO-BEGIN-DATEBEGIN_DATE | Numeric 8 (yyyymmdd) | The begin date for this effort period. | IC18.1, IC811 |
#ICO-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | IC18.1, IC811, WH130 |
#ICO-COM-TYPECOM_TYPE | Alpha 1 | — | IC18.1, IC811 |
#ICO-LANGUAGE-CODE PKLANGUAGE_CODE | Alpha 10 | Language Code (LOCALE). | IC18.1 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ICOSET1 |
| Primary | IC11.1, IC110, IC18.1, IC210, IC211, IC212, IC811, PO130 +7 more |
Relations
One to one (2) — lookups and parents
Programs
Updated by (3)
Referenced by (12)
- IC110 Intransit Shipping
- IC210 Item Master Listing
- IC211 Item Location Listing
- IC212 Item Comments Listing
- PO130 Receiving Document
- PO220 PO Status Report
- PO230 Unreleased Receivings Listing
- POCP.1 POC Comments Copy
- POI7.1 POI7 Print Object
- WH130 Pick List Print
- WH222 Shipments In Process
- WH224 Packing List Print