Table inventory_categories

Table inventory_categories defines extra categories whic help organize inventory attributes. Categories appear as tabs in the maintain inventory screen.

Table Type: MyISAM

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.