ICITEMCODE – Item Code

System
Inventory Control (IC)
Prefix
IIC
Primary key
ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITY
Fields
9
Updated by
229 programs
Referenced by
6 programs

ICITEMCODE is the Item Code table in Lawson Inventory Control (prefix IIC). It is indexed by ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITY (IICSET1); alternate indexes: IICSET2, IICSET3, IICSET4 and IICSET5. It is related 1:M to ICITEMGTIN and ITEMMAST. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 221 more and referenced by IC218, IC46.1, IC511, ICI9.1, PD21.1 and RQ260. The table has 9 fields, 5 indexes and 2 documented relations.

About ICITEMCODE

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
IIC-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICSEGMENT PK
ICSEGMENT		Alpha 2The ICSEGMENT is the first part of a four part item hierarchy structure. The ICSEGMENT is the top level of the hierarchy. All levels of the hierarchy are two characters. This hierarchy also can be used to store UNSPSC codes and descriptions.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICFAMILY PK
ICFAMILY		Alpha 2ICFAMILY is the second level of the product hierarchy. If the ICFAMILY field has a 00 in it, this indicates that this code is for describing the segment. If there is a 00 the code parts below this should also be 00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICCLASS PK
ICCLASS		Alpha 2ICCLASS is the third level of the hierarchy. If this is 00 and the code parts below this are 00, then this code is for describing the ICFAMILY field level.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICCOMMODITY PK
ICCOMMODITY		Alpha 2ICCOMMODITY is the fourth and last level of the hierarchy. All levels of the hierarchy must be entered for a item, it cannot split and only certain levels used. The hierarchy will remain an optional field when entering items. When this field contains 00, the code is for describing the ICCLASS level of the hierarchy.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-DESC-LEVEL
DESC_LEVEL		Numeric 1The description level is an indicator for what level of the hierarchy is being described by the description.
  • 1 ICSEGMENT Description
  • 2 ICFAMILY Description
  • 3 ICCLASS Description
  • 4 ICCOMMODITY Description
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICCODE-SDESC
ICCODE_SDESC		Alpha 20The sdesc is a shortened description. It based on the long description. It is needed for screens that cannot display the long description.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICCODE-LDESC
ICCODE_LDESC		Alpha 250This is the correct description for the level of the hierarchy that is indicated by the description level field. This should be the full description.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
IIC-ICCODE-ACTIVE
ICCODE_ACTIVE		Alpha 1This code defines whether any item is currently using this code. As long as this code is on one item it is considered active. The exception to is for codes that contain 00 which is used for describing levels of the codes.
  • Y Code is used for an item
  • N Code is not currently used
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (5)

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

IndexKeysFlagsConditionUsed in
IICSET1ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITYPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
IICSET2ITEM-GROUP, ICSEGMENTSubsetWhere DESC-LEVEL = 1 And ICCODE-ACTIVE = "Y"—
IICSET3ITEM-GROUP, ICSEGMENT, ICFAMILYSubsetWhere DESC-LEVEL = 2 And ICCODE-ACTIVE = "Y"—
IICSET4ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASSSubsetWhere DESC-LEVEL = 3 And ICCODE-ACTIVE = "Y"—
IICSET5ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITYSubsetWhere DESC-LEVEL = 4 And ICCODE-ACTIVE = "Y"—

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
IcitemgtinICITEMGTINIIC-ITEM-GROUP → GTI-ITEM-GROUP (GTISET5), IIC-ICSEGMENT → GTI-ICSEGMENT, IIC-ICFAMILY → GTI-ICFAMILY, IIC-ICCLASS → GTI-ICCLASS, IIC-ICCOMMODITY → GTI-ICCOMMODITY, → GTI-GTIN, → GTI-ITEM
ItemcodetoitemITEMMASTIIC-ITEM-GROUP → ITE-ITEM-GROUP, IIC-ICSEGMENT → ITE-ICSEGMENT, IIC-ICFAMILY → ITE-ICFAMILY, IIC-ICCLASS → ITE-ICCLASS, IIC-ICCOMMODITY → ITE-ICCOMMODITY, → ITE-ITEM

Programs

Updated by (229)

Referenced by (6)