--
-- Structure for table `f_inventory`
--

DROP TABLE IF EXISTS `f_inventory`;
CREATE TABLE IF NOT EXISTS `f_inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sku` varchar(24) NOT NULL DEFAULT '',
  `inactive` enum('0','1') NOT NULL DEFAULT '0',
  `inventory_type` char(2) NOT NULL DEFAULT 'si',
  `description_short` varchar(60) NOT NULL DEFAULT '',
  `description_purchase` varchar(255) DEFAULT NULL,
  `description_sales` varchar(255) DEFAULT NULL,
  `image_with_path` varchar(255) DEFAULT NULL,
  `account_sales_income` varchar(15) DEFAULT NULL,
  `account_inventory_wage` varchar(15) DEFAULT '',
  `account_cost_of_sales` varchar(15) DEFAULT NULL,
  `item_taxable` int(11) NOT NULL DEFAULT '0',
  `purch_taxable` int(11) NOT NULL DEFAULT '0',
  `item_cost` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cost_method` enum('a','f','l') NOT NULL DEFAULT 'f',
  `price_sheet` varchar(32) DEFAULT NULL,
  `price_sheet_v` varchar(32) DEFAULT NULL,
  `full_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `item_weight` float NOT NULL DEFAULT '0',
  `quantity_on_hand` float NOT NULL DEFAULT '0',
  `quantity_on_order` float NOT NULL DEFAULT '0',
  `quantity_on_sales_order` float NOT NULL DEFAULT '0',
  `quantity_on_allocation` float NOT NULL DEFAULT '0',
  `minimum_stock_level` float NOT NULL DEFAULT '0',
  `reorder_quantity` float NOT NULL DEFAULT '0',
  `vendor_id` int(11) NOT NULL DEFAULT '0',
  `lead_time` int(3) NOT NULL DEFAULT '1',
  `upc_code` varchar(13) NOT NULL DEFAULT '',
  `serialize` enum('0','1') NOT NULL DEFAULT '0',
  `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_journal_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `category` char(49) DEFAULT NULL,
  `realfoto` enum('0','1') DEFAULT '0',
  `cater` enum('0','1') DEFAULT '0',
  `specprices` enum('0','1') DEFAULT '0',
  `rev` enum('0','1') DEFAULT '0',
  `iverrev` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3913 DEFAULT CHARSET=utf8 COMMENT='Primary inventory table';