CREATE TABLE `supplier_enquiry` (
  `recnum` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `link2cust` int(11) DEFAULT NULL,
  `partdesc` varchar(100) DEFAULT NULL,
  `partnum` varchar(50) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `enq_date` date DEFAULT NULL,
  `rtquot_date` date DEFAULT NULL,
  `rtquot_no` varchar(100) DEFAULT NULL,
  `risk_involv` varchar(255) DEFAULT NULL,
  `risk_details` text,
  `status` varchar(100) DEFAULT NULL,
  `remarks` text,
  `siteid` varchar(45) DEFAULT NULL,
  `formrev` varchar(100) DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `approved_by` varchar(100) DEFAULT NULL,
  `approved_date` date DEFAULT NULL,
  `id` varchar(100) DEFAULT NULL,
  `approved` varchar(100) DEFAULT NULL,
  `modified_by` varchar(100) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB

 CREATE TABLE `supplier_quote` (
  `recnum` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id` varchar(100) DEFAULT NULL,
  `quote_date` date DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `descr` varchar(100) DEFAULT NULL,
  `excelfile` varchar(255) DEFAULT NULL,
  `rfqid` varchar(30) DEFAULT NULL,
  `owner_userid` varchar(25) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `last_modified` date DEFAULT NULL,
  `delivarydate` date DEFAULT NULL,
  `terms` varchar(150) DEFAULT NULL,
  `quote2type` int(11) DEFAULT NULL,
  `quotetype` varchar(100) DEFAULT NULL,
  `comments` varchar(100) DEFAULT NULL,
  `quote2company` int(11) DEFAULT NULL,
  `convert2sales` varchar(50) DEFAULT NULL,
  `quote2employee` varchar(50) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `mail2customer` varchar(255) DEFAULT NULL,
  `quote_grosstotal` float DEFAULT NULL,
  `link2bom` int(11) DEFAULT NULL,
  `tax` float DEFAULT NULL,
  `labor` float DEFAULT NULL,
  `shipping` float DEFAULT NULL,
  `misc` float DEFAULT NULL,
  `revise_num` int(11) DEFAULT NULL,
  `parent_quote_id` varchar(20) DEFAULT NULL,
  `lockstatus` varchar(20) DEFAULT NULL,
  `total_due` float DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB


 CREATE TABLE `supplier_quote_li` (
  `recnum` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `item` varchar(20) DEFAULT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `rate` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `link2quote` int(11) DEFAULT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB