COMMCODES – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
ISC
Primary key
ITEM-GROUP, COMMODITY-CODE
Fields
4
Updated by
0 programs
Referenced by
0 programs

COMMCODES is a Lawson Inventory Control table (prefix ISC); no description in the lawson data dictionary. It is indexed by ITEM-GROUP, COMMODITY-CODE (ISCSET1). The table has 4 fields, 1 index and 0 documented relations.

About COMMCODES

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
ISC-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.DR100, IC11.1, IC141, IC142, IC83.1, MA42.1, MA43.1, MA44.1 +28 more
ISC-COMMODITY-CODE PK
COMMODITY_CODE
Alpha 35DR100, IC11.1, IC141, IC142, IC83.1, MA42.1, MA43.1, MA44.1 +28 more
ISC-CC-DESCRIPTION
CC_DESCRIPTION
Alpha 60 (Lower Case)DR100, IC11.1, IC141, IC142, IC83.1, MA42.1, MA43.1, MA44.1 +28 more
ISC-CC-ACTIVE
CC_ACTIVE
Numeric 1
  • 0 Inactive
  • 1 Active
DR100, IC11.1, IC141, IC142, IC83.1, MA42.1, MA43.1, MA44.1 +28 more

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ISCSET1ITEM-GROUP, COMMODITY-CODEPrimaryDR100, IC11.1, IC141, IC142, IC83.1, MA42.1, MA43.1, MA44.1 +22 more (list truncated in source)

Programs

No Lawson programs are documented as updating or referencing this table.