2.35 NC_ProductCategory Table

The NC_ProductCategory table contains information about product subcategories.

Column

Key

Type

Null

Description

ProductCategoryOID

PK

binary(16)

No

An internal ID number used as a primary key.

ProductCategoryName

nvarchar(32)

No

The name of the product subcategory.

CategoryOID

FK

binary(16)

No

Product category information.

IsTally

smallint

No

1 if this is a product category defined by Novell; 0 if it is user-defined.

IsDeleted

DateTime

The date and time the record was deleted; else null.

NOTE:The CategoryOID foreign key references the CategoryOID primary key column of the NC_Category table.