CLASIFCODE

This table contains all possible product classification codes under different classification domains (such as UNSPSC, SPSC, and so on) that can be assigned to CatalogEntries.

Column Descriptions:

Name	Type	Description
CLASIFCODE_ID	BIGINT NOT NULL	Generated primary key.
DOMAIN	CHAR (32) NOT NULL	The classification standard or domain.
CODE	CHAR (16) NOT NULL	The classification code.
PARENTCODE	CHAR (16)	The parent classification code.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CLASIFCODE_ID	Primary Key
I0000072	CODE+DOMAIN	Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_241	CLASIFCODE_ID	CLSFCODEDS	CLASIFCODE_ID	Cascade