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:

NameTypeDescription
CLASIFCODE_IDBIGINT NOT NULLGenerated primary key.
DOMAINCHAR (32) NOT NULLThe classification standard or domain.
CODECHAR (16) NOT NULLThe classification code.
PARENTCODECHAR (16)The parent classification code.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CLASIFCODE_IDPrimary Key
I0000072CODE+DOMAINUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_241CLASIFCODE_IDCLSFCODEDSCLASIFCODE_IDCascade