The NC_Category table tracks product categories.
Column
Key
Type
Null
Description
CategoryOID
PK
binary(16)
No
An internal ID number used as a primary key.
CategoryName
nvarchar(32)
The name of the product category.
CategoryType
smallint
The product type to which the category belongs. See "Note" below.
IsTally
1 (TRUE) if the category was defined by Novell; else 0.
IsDeleted
DateTime
The date and time the record was deleted; else null.
NOTE:The CategoryType can be one of the following:
1
BIOS
17
Printer
2
CPU
18
BUS Adapter
3
CD/DVD Drive
19
Serial Port
4
DMI
20
Sound Card
5
Diskette Drive
21
Software
6
Hard Disk
22
System
7
Keyboard
23
System Board
8
LAN Adapter
24
Video Adapter
9
Memory Module Socket
25
Removable Media Drive
10
Modem
26
Other
11
Monitor
29
Hot Fix
12
Mouse
30
USB Port
13
Network Driver
31
Docking Station
14
Operating System
15
Parallel Port
16
Partition