Field | Type | Default | Description |
---|---|---|---|
category_id | int (11) | NOT NULL | PRIMARY KEY - Auto increment field to hold unique ID |
category_name | varchar (32) | NOT NULL | Holds the name of the inventory category. The category appears as a tab in the maintain inventory script. |
sort_order | int (2) | 0 | Sort order to organize the tabs. Will appear after the defaults tabs (system, bom, master stock) |
category_description | varchar (80) | NOT NULL | Textual description of the category. Mostly used in reports. |