2.34 NC_Product Table

The NC_Product table contains product information.

Column	Key	Type	Null	Description
ProductOID	PK	binary(16)	No	An internal ID number used as a primary key.
Code		int		The product’s unique ID where 0 as the leading digit represents hardware and 1 represents software.
ProductType		smallint	No	The product type. See "Notes"below.
ProductCategoryOID	FK	binary(16)		Product classification information.
Manufacturer		nvarchar(35)		The manufacturer’s name.
Product		nvarchar(100)		The product name.
Model		nvarchar(25)		The model of the product.
Source		smallint	No	How the product was created: 0=Novell Defined 1= Collection 2=Field Editor 3 = ZENworks Control Center 4=Translator/Migrator 5=Palm Translator 6=UNIX Translator 7=OS X Translator.
SWPlatform		smallint		The platform under which a software product runs. See "Notes" below.
NotInUse		smallint	No	True(1) indicates if the product is a local product that has been reconciled into another product; else 0.
Classification		smallint	No	The classification of a product: 0=hardware, 1=software.
Platform		smallint	No	The platform. See "Notes" below.
Language		smallint	No	The language. See "Notes" below.
IsCodeValid		smallint	No	True(1) indicates if the code is valid; else 0.
IsMerged		smallint	No	True(1) indicates if the local product has been merged into the product KB files; else 0.
DistributionModel		smallint		How the product is sold: 0 = Unknown 1 = Commercial 2 = Freeware 3 = Shareware 4 = Open Source 5 = Multiple 6 = Public Domain
LicenseProductType		smallint		The type of license that is associated with the software: 0 = Unknown 1 = Full 2 = Eval 3 = OEM 4 = Multiple 5 = Network
CurrentManufacturer		nvarchar(35)
CreateDate		DateTime		The time and date the product was created.
DateLastModified		DateTime		The time and date the product was last modified by a ZENworks Asset Management User.
IsDeleted		DateTime		The date and time the record was deleted;else null.
ADF0		nvarchar(256)		Description of "Administrator Defined Field 0"
ADF1		nvarchar(256)		Description of "Administrator Defined Field 1"
ADF2		nvarchar(64)		Description of "Administrator Defined Field 2"
ADF3		nvarchar(64)		Description of "Administrator Defined Field 3"
ADF4		nvarchar(64)		Description of "Administrator Defined Field 4"
ADF5		nvarchar(64)		Description of "Administrator Defined Field 5"
ADF6		nvarchar(64)		Description of "Administrator Defined Field 6"
ADF7		nvarchar(64)		Description of "Administrator Defined Field 7"
ADF8		nvarchar(64)		Description of "Administrator Defined Field 8"
ADF9		nvarchar(64)		Description of "Administrator Defined Field 9"
ADF10		nvarchar(64)		Description of "Administrator Defined Field 10"
ADF11		nvarchar(64)		Description of "Administrator Defined Field 11"
ADF12		nvarchar(64)		Description of "Administrator Defined Field 12"
ADF13		nvarchar(64)		Description of "Administrator Defined Field 13"
ADF14		nvarchar(64)		Description of "Administrator Defined Field 14"
ADF15		nvarchar(64)		Description of "Administrator Defined Field 15"
ADF16		nvarchar(64)		Description of "Administrator Defined Field 16"
ADF17		nvarchar(64)		Description of "Administrator Defined Field 17"
ADF18		nvarchar(64)		Description of "Administrator Defined Field 18"
ADF19		nvarchar(64)		Description of "Administrator Defined Field 19"

NOTE:

The ProductType can be one of the following:

1	BIOS	16	Partition
2	CPU	17	Printer
3	CD-ROM	18	Bus Adapter
4	DMI	19	Serial Port
5	Floppy	20	Sound Card
6	Hard Disk	21	Software
7	Keyboard	22	System
8	LAN Adapter	23	System Board
9	Memory Module	24	Video Adapter
10	Modem	25	Removable Media
11	Monitor	26	Other
12	Mouse	29	Hot Fix
13	Network Driver	30	USB Port
14	Current Operating System	31	Docking Station
15	Parallel port

SWPlatform and Platform can have one of the following values:

0	DOS
1	Windows 3.x
2	Windows 95
3	Windows 98
4	Windows 32-bit
5	Windows NT
6	Windows 9x
7	OS/2
8	Unassigned
9	Palm OS
10	Windows 2000
11	Windows XP
12	UNIX
13	OS X
14	Windows Vista

Language can have one of the following values:

1	Afrikaans	15	Hungarian
2	Arabic	16	International
3	Chinese	17	Italian
4	Simple Chinese	18	Japanese
5	Traditional Chinese	19	Korean
6	Danish	20	Norwegian
7	Dutch	21	Polish
8	English (U.K.)	22	Portuguese
9	English (U.S.)	23	Brazilian Portuguese
10	Finnish	24	Russian
11	French	25	Spanish
12	German	26	Swedish
13	Greek	27	Turkish
14	Hebrew

The ProductCategoryOID foreign key references the ProductCategoryOID primary key column of the NC_ProductCategory table.
ProductType + Manufacturer + Product + Model + Source + Language + IsDeleted has a unique constraint named UQ_Product_Names.