Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `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(35) 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=2605 DEFAULT CHARSET=utf8 COMMENT='Primary inventory table'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement