CATCLSFCOD

This table contains the assignment of classification codes to CatalogEntries.

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe reference number of the CatalogEntry.
DOMAINCHAR (32) NOT NULLClassification domain used to assign a code. One such example is UNSPSC classification system.
CODECHAR (16) NOT NULLClassification code assigned under a particular classification domain.
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>CATENTRY_ID+DOMAINPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_186CATENTRY_IDCATENTRYCATENTRY_IDCascade