-- Table structure for table `mc_capacity_master`
--

CREATE TABLE `mc_capacity_master` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mc_id` varchar(45) DEFAULT NULL,
  `mc_name` varchar(45) DEFAULT NULL,
  `avail_capacity` float DEFAULT '0',
  `mc_series` varchar(45) DEFAULT NULL,
  `create_date` date DEFAULT '0000-00-00',
  `modified_date` date DEFAULT '0000-00-00',
  `created_by` varchar(65) DEFAULT NULL,
  `modified_by` varchar(65) DEFAULT NULL,
  `month` varchar(65) DEFAULT NULL,
  `year` varchar(65) DEFAULT NULL,
  `shift` int(11) NOT NULL,
  `units` varchar(50) NOT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `oe` int(11) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mc_capacity_master`
--

INSERT INTO `mc_capacity_master` VALUES (1,'Slim3n-4AHS-1','Slim3n-4AHS-1',680,'Slim3n-4AHS-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(2,'Slim3n-4AHS-2','Slim3n-4AHS-2',680,'Slim3n-4AHS-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(3,'slim3n-5AHS-1','slim3n-5AHS-1',680,'slim3n-5AHS-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(4,'i700-1','i700-1',680,'i700-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(5,'DX 200-2','DX 200-2',680,'DX 200-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(6,'MakinoF5-3','MakinoF5-3',680,'MakinoF5-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(7,'QT100S-1','QT100S-1',680,'QT100S-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(8,'MakinoF5-1','MakinoF5-1',680,'MakinoF5-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(9,'HAASVF2SS-1','HAASVF2SS-1',680,'HAASVF2SS-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(10,'A51nx-1','A51nx-1',680,'A51nx-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(12,'VMC 70L','VMC 70L',680,'VMC 70L','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(13,'PS105-02','PS105-02',680,'PS105-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(14,'PS105-01','PS105-01',680,'PS105-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(15,'DX 200-1','DX 200-1',680,'DX 200-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(16,'HMC 440','HMC 440',680,'HMC 440','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(17,'HASSVF2SS','HASSVF2SS',680,'HASSVF2SS','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(18,'ST20','ST20',680,'ST20','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(19,'i700-3','i700-3',680,'i700-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(20,'HAAS VM6','HAAS VM6',680,'HAAS VM6','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(21,'UNIPRO 5000-1','UNIPRO 5000-1',680,'UNIPRO 5000-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(22,'LMW LX20T-1','LMW LX20T-1',680,'LMW LX20T-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(23,'ST20Y1','ST20Y1',680,'ST20Y1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(24,'ST20Y','ST20Y',680,'ST20Y','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(25,'VM2-3','VM2-3',680,'VM2-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(26,'HASS VR11','HASS VR11',680,'HASS VR11','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(27,'BMV 60-1','BMV 60-1',680,'BMV 60-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(28,'QT100S-3','QT100S-3',680,'QT100S-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(29,'QT100S-5','QT100S-5',680,'QT100S-5','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(30,'Slim3n-4AHS-3','Slim3n-4AHS-3',680,'Slim3n-4AHS-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(31,'SLIM 3N-4AHS-3','SLIM 3N-4AHS-3',680,'SLIM 3N-4AHS-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(32,'MakinoF5-2','MakinoF5-2',680,'MakinoF5-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(33,'BMV 45-1','BMV 45-1',680,'BMV 45-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(34,'Slim3n-5AHS-2','Slim3n-5AHS-2',680,'Slim3n-5AHS-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(35,'HAASVF2SS-2','HAASVF2SS-2',680,'HAASVF2SS-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(36,'MakinoF3-1','MakinoF3-1',680,'MakinoF3-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(37,'DX 200-3','DX 200-3',680,'DX 200-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(38,'DX 200','DX 200',680,'DX 200','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(39,'MAKINO SLIM-1','MAKINO SLIM-1',680,'MAKINO SLIM-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(40,'BMV 45-2','BMV 45-2',680,'BMV 45-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(41,'QT100S-2','QT100S-2',680,'QT100S-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(42,'MV-02','MV-02',680,'MV-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(43,'QT100S-4','QT100S-4',680,'QT100S-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(44,'MakinoF5-4','MakinoF5-4',680,'MakinoF5-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(45,'200MY-01','200MY-01',680,'200MY-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(46,'100MY-01','100MY-01',680,'100MY-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(47,'MV-03','MV-03',680,'MV-03','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(48,'i700-5','i700-5',680,'i700-5','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(49,'a51nx-05','a51nx-05',680,'a51nx-05','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(50,'AC-1','AC-1',680,'AC-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(51,'a51nx-01','a51nx-01',680,'a51nx-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(52,'a51nx-02','a51nx-02',680,'a51nx-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(54,'i700-2','i700-2',680,'i700-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(55,'i700-4','i700-4',680,'i700-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(56,'DX200-4','DX200-4',680,'DX200-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(57,'MAKINO SLIM-2','MAKINO SLIM-2',680,'MAKINO SLIM-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(58,'VM2-2','VM2-2',680,'VM2-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(60,'DMG 360L','DMG 360L',680,'DMG 360L','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(61,'Slim3n-4AHS-4','Slim3n-4AHS-4',680,'Slim3n-4AHS-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(62,'VM-2','VM-2',680,'VM-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(63,'BMV 60-2','BMV 60-2',680,'BMV 60-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(64,'DX200-3','DX200-3',680,'DX200-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(65,'MV-04','MV-04',680,'MV-04','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(66,'a51nx-03','a51nx-03',680,'a51nx-03','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(67,'200MY-02','200MY-02',680,'200MY-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(68,'100MY-02','100MY-02',680,'100MY-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(69,'MV-01','MV-01',680,'MV-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(70,'a51nx-04','a51nx-04',680,'a51nx-04','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(71,'AC-2','AC-2',680,'AC-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(72,'VM2-1','VM2-1',680,'VM2-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(74,'MakinoF5-5','MakinoF5-5',680,'MakinoF5-5','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85);

--
-- Table structure for table `mc_capacity_plan`
--

CREATE TABLE `mc_capacity_plan` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mc_id` varchar(45) NOT NULL DEFAULT '',
  `mc_name` varchar(45) NOT NULL DEFAULT '',
  `crn` varchar(65) NOT NULL DEFAULT '',
  `plan_month` varchar(65) NOT NULL DEFAULT '',
  `req_crn_hrs` varchar(65) NOT NULL DEFAULT '',
  `wonum` varchar(65) NOT NULL DEFAULT '',
  `wo_hrs` varchar(45) NOT NULL DEFAULT '',
  `mc_series` varchar(45) DEFAULT NULL,
  `plan_year` varchar(45) DEFAULT NULL,
  `mc_cap_hrs` varchar(65) DEFAULT NULL,
  `mc_avail_hrs` varchar(65) DEFAULT NULL,
  `crn_qty` varchar(65) DEFAULT NULL,
  `runtime_units` varchar(65) DEFAULT NULL,
  `balance_crn_hrs` varchar(65) DEFAULT NULL,
  `balance_crn_qty` varchar(65) DEFAULT NULL,
  `balance_mc_hrs` varchar(65) DEFAULT NULL,
  `create_date` date DEFAULT '0000-00-00',
  `modified_date` date DEFAULT '0000-00-00',
  `created_by` varchar(65) DEFAULT NULL,
  `modified_by` varchar(65) DEFAULT NULL,
  `operation` char(5) DEFAULT NULL,
  `priority` char(10) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `start_time` int(11) DEFAULT NULL,
  `start_meridiem` varchar(65) DEFAULT NULL,
  `end_meridiem` varchar(65) DEFAULT NULL,
  `end_time` int(10) unsigned DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `blank` int(11) DEFAULT NULL,
  `units` varchar(45) DEFAULT NULL,
  `shift` varchar(45) DEFAULT NULL,
  `schedule_date` datetime DEFAULT NULL,
  `sch_qty` int(11) DEFAULT NULL,
  `fgqty` int(11) DEFAULT NULL,
  `totalfgqty` int(11) DEFAULT NULL,
  `grn_qty` int(11) DEFAULT NULL,
  `ff_qty` varchar(65) DEFAULT NULL,
  `ff_qty_hrs` varchar(65) DEFAULT NULL,
  `wip_qty` int(11) DEFAULT NULL,
  `rej_qty` int(11) DEFAULT NULL,
  `disp_qty` int(11) DEFAULT NULL,
  `time24` int(11) DEFAULT NULL,
  `dependency` char(5) DEFAULT NULL,
  `dependencymc` char(45) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mc_capacity_plan`
--

INSERT INTO `mc_capacity_plan` VALUES (1,'','Slim3n-4AHS-1','51-005','08','7.0','','',NULL,'2018','700',NULL,NULL,'35','0','0','693.0','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-02 06:00:00','2018-08-02 13:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-02 00:00:00',12,NULL,NULL,NULL,'12','7.0',NULL,NULL,NULL,NULL,'',''),(2,'','Slim3n-4AHS-1','51-001','08','29.10','','',NULL,'2018','700',NULL,NULL,'35','0','0','663.50','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-02 13:00:00','2018-08-04 02:01:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-05 00:00:00',50,NULL,NULL,NULL,'50','29.10',NULL,NULL,NULL,NULL,'',''),(3,'','Slim3n-4AHS-1','51-003','08','32.5','','',NULL,'2018','700',NULL,NULL,'35','0','0','631.45','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-04 02:01:00','2018-08-07 02:06:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-08 00:00:00',55,NULL,NULL,NULL,'55','32.5',NULL,NULL,NULL,NULL,'',''),(4,'','Slim3n-4AHS-1','51-005','08','35.0','','',NULL,'2018','700',NULL,NULL,'35','0','0','596.45','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-07 02:06:00','2018-08-09 05:06:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-09 00:00:00',60,NULL,NULL,NULL,'60','35.0',NULL,NULL,NULL,NULL,'2','Slim3n-4AHS-1'),(5,'','Slim3n-4AHS-1','51-006','08','37.55','','',NULL,'2018','700',NULL,NULL,'35','0','0','558.50','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-09 05:06:00','2018-08-11 11:01:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-11 00:00:00',65,NULL,NULL,NULL,'65','37.55',NULL,NULL,NULL,NULL,'',''),(6,'','Slim3n-4AHS-1','51-013','08','22.40','','',NULL,'2018','700',NULL,NULL,'20','0','0','536.10','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-11 11:01:00','2018-08-13 17:05:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-12 00:00:00',68,NULL,NULL,NULL,'68','22.40',NULL,NULL,NULL,NULL,'',''),(7,'','Slim3n-4AHS-1','51-014','08','23.20','','',NULL,'2018','700',NULL,NULL,'20','0','0','512.50','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-13 17:05:00','2018-08-16 00:07:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-15 00:00:00',70,NULL,NULL,NULL,'70','23.20',NULL,NULL,NULL,NULL,'',''),(8,'','Slim3n-4AHS-1','51-015','08','24.0','','',NULL,'2018','700',NULL,NULL,'20','0','0','488.50','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-16 00:07:00','2018-08-17 08:07:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-16 00:00:00',72,NULL,NULL,NULL,'72','24.0',NULL,NULL,NULL,NULL,'',''),(9,'','Slim3n-4AHS-1','51-005','08','14.0','','',NULL,'2018','700',NULL,NULL,'35','0','0','474.50','0000-00-00','0000-00-00',NULL,NULL,'2',NULL,'2018-08-17 08:07:00','2018-08-17 22:07:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2018-10-19 00:00:00',24,NULL,NULL,NULL,'24','14.0',NULL,NULL,NULL,NULL,'2','Slim3n-4AHS-1');

--
-- Table structure for table `mc_master`
--

CREATE TABLE `mc_master` (
  `mc_id` varchar(20) DEFAULT NULL,
  `mc_name` varchar(50) DEFAULT NULL,
  `mc_cost_per_hour` float DEFAULT NULL,
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `qty` int(11) DEFAULT NULL,
  `setup_time` int(11) DEFAULT NULL,
  `crn_num` varchar(30) DEFAULT NULL,
  `setup_time_mins` int(11) DEFAULT NULL,
  `fitting_time_hrs` int(11) DEFAULT NULL,
  `fitting_time_mins` int(11) DEFAULT NULL,
  `insp_time_hrs` int(11) DEFAULT NULL,
  `insp_time_mins` int(11) DEFAULT NULL,
  `val_per_part` decimal(8,2) DEFAULT NULL,
  `mps_revision` varchar(45) DEFAULT NULL,
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mc_master`
--

INSERT INTO `mc_master` VALUES (NULL,NULL,NULL,1,1,0,'PRN1',0,0,23,23,0,1.00,'123','2016-05-29','2016-05-29','FSI'),(NULL,NULL,NULL,2,1,0,'prn1',0,10,0,10,0,2.00,'0','2016-06-01','2016-07-05','FSI'),(NULL,NULL,NULL,3,1,0,'prn2',0,8,0,8,0,3.00,'0','2016-06-06','2016-07-07','FSI');

--
-- Table structure for table `mc_stage_master`
--

CREATE TABLE `mc_stage_master` (
  `stage_num` int(11) DEFAULT NULL,
  `running_time` int(11) DEFAULT NULL,
  `link2mc_master` int(11) DEFAULT NULL,
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `mc_name` varchar(40) DEFAULT NULL,
  `setting_time_mins` float DEFAULT NULL,
  `running_time_mins` float DEFAULT NULL,
  `setting_time` float DEFAULT NULL,
  `cost` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mc_stage_master`
--


--
-- Table structure for table `mdm`
--

CREATE TABLE `mdm` (
  `recnum` int(11) DEFAULT NULL,
  `refnum` varchar(20) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `partname` varchar(20) DEFAULT NULL,
  `drg_issue` varchar(20) DEFAULT NULL,
  `attachments` varchar(50) DEFAULT NULL,
  `dim1` varchar(20) DEFAULT NULL,
  `dim2` varchar(20) DEFAULT NULL,
  `dim3` varchar(20) DEFAULT NULL,
  `raw_mat_type` varchar(20) DEFAULT NULL,
  `raw_mat_spec` varchar(20) DEFAULT NULL,
  `maching_cycle_time` varchar(10) DEFAULT NULL,
  `filtering_cycle_time` varchar(10) DEFAULT NULL,
  `inopectun_cycle_time` varchar(10) DEFAULT NULL,
  `part_type` varchar(20) DEFAULT NULL,
  `customer` varchar(30) DEFAULT NULL,
  `project` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mdm`
--


--
-- Table structure for table `mechanical_properties_li`
--

CREATE TABLE `mechanical_properties_li` (
  `recno` int(11) DEFAULT NULL,
  `constituents` varchar(30) DEFAULT NULL,
  `standard_min` float DEFAULT NULL,
  `standard_max` float DEFAULT NULL,
  `supplier_min` float DEFAULT NULL,
  `supplier_max` float DEFAULT NULL,
  `report_lab` varchar(100) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `link2testreport` varchar(20) DEFAULT NULL,
  `lineno` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mechanical_properties_li`
--


--
-- Table structure for table `mfg_order`
--

CREATE TABLE `mfg_order` (
  `recnum` int(11) DEFAULT NULL,
  `mfg_id` varchar(50) DEFAULT NULL,
  `mfg_desc` varchar(255) DEFAULT NULL,
  `orderdate` date DEFAULT NULL,
  `link2company` int(11) DEFAULT NULL,
  `link2contact` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mfg_order`
--

INSERT INTO `mfg_order` VALUES (1,'M1','','2016-03-15',126,26,'2016-03-10');

--
-- Table structure for table `milestone_notes`
--

CREATE TABLE `milestone_notes` (
  `recnum` int(11) DEFAULT NULL,
  `notes` longtext,
  `create_date` date DEFAULT NULL,
  `notes2user` int(11) DEFAULT NULL,
  `link2dates` int(11) DEFAULT NULL,
  `dept` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `milestone_notes`
--


--
-- Table structure for table `mm`
--

CREATE TABLE `mm` (
  `recnum` int(11) DEFAULT NULL,
  `qty_drawn` int(11) DEFAULT NULL,
  `drawn_by` varchar(255) DEFAULT NULL,
  `issued_by` varchar(255) DEFAULT NULL,
  `accepted` varchar(255) DEFAULT NULL,
  `rejected` varchar(255) DEFAULT NULL,
  `returned` varchar(255) DEFAULT NULL,
  `recd_by` varchar(100) DEFAULT NULL,
  `sl_from` varchar(100) DEFAULT NULL,
  `sl_to` varchar(100) DEFAULT NULL,
  `notes` varchar(100) DEFAULT NULL,
  `link2wo` int(11) DEFAULT NULL,
  `link2notes` int(11) DEFAULT NULL,
  `line_num` varchar(100) DEFAULT NULL,
  `drawn_date` date DEFAULT NULL,
  `issued_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mm`
--


--
-- Table structure for table `mps`
--

CREATE TABLE `mps` (
  `mps_revision` varchar(20) DEFAULT NULL,
  `control` varchar(50) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `link2master_data` int(11) DEFAULT NULL,
  `recnum` int(11) DEFAULT NULL,
  `linenum` varchar(20) DEFAULT NULL,
  `revstat` char(30) DEFAULT NULL,
  `rev_date` date DEFAULT NULL,
  `approval` varchar(50) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `model_ref` varchar(50) DEFAULT NULL,
  `approval_date` date DEFAULT NULL,
  `engineer` varchar(255) DEFAULT NULL,
  `mpsliflag` int(11) DEFAULT NULL,
  `siteid` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mps`
--


--
-- Table structure for table `mtl_act_log`
--

CREATE TABLE `mtl_act_log` (
  `recnum` int(11) DEFAULT NULL,
  `ldate` date DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `usertype` varchar(20) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `link2mtltrk` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtl_act_log`
--

INSERT INTO `mtl_act_log` VALUES (1315,'2016-05-25','bmandyam','EMPL','Modified',1015),(1316,'2016-05-25','bmandyam','EMPL','Modified',1015),(1317,'2016-05-25','bmandyam','EMPL','Modified',1015),(1318,'2016-05-25','bmandyam','EMPL','Modified',1015),(1319,'2016-05-25','bmandyam','EMPL','Modified',1015),(1320,'2016-05-25','bmandyam','EMPL','Modified',1015),(1321,'2016-05-25','bmandyam','EMPL','Modified',1007),(1322,'2016-05-25','bmandyam','EMPL','Modified',1007),(1323,'2016-05-25','bmandyam','EMPL','Modified',1007),(1324,'2016-05-25','bmandyam','EMPL','Modified',1007),(1325,'2016-05-25','bmandyam','EMPL','Modified',1007),(1326,'2016-05-25','bmandyam','EMPL','Modified',1007),(1327,'2016-05-25','bmandyam','EMPL','Modified',1007),(1328,'2016-05-25','bmandyam','EMPL','Modified',1007),(1329,'2016-05-26','bmandyam','EMPL','Modified',1015),(1330,'2016-05-26','bmandyam','EMPL','Modified',1015),(1331,'2016-05-26','bmandyam','EMPL','Modified',1015),(1332,'2016-05-26','bmandyam','EMPL','Modified',1015),(1333,'2016-05-26','bmandyam','EMPL','Modified',1015),(1334,'2016-05-26','bmandyam','EMPL','Modified',1015),(1335,'2016-05-26','bmandyam','EMPL','Modified',1015),(1336,'2016-05-26','bmandyam','EMPL','Modified',1015),(1337,'2016-05-26','bmandyam','EMPL','Modified',1015),(1338,'2016-05-26','bmandyam','EMPL','Modified',1015),(1339,'2016-05-26','bmandyam','EMPL','Modified',1015),(1340,'2016-05-26','bmandyam','EMPL','Modified',1012),(1341,'2016-05-26','bmandyam','EMPL','Modified',1012),(1342,'2016-05-26','bmandyam','EMPL','Modified',1012),(1343,'2016-05-26','bmandyam','EMPL','Modified',1012),(1344,'2016-06-01','bmandyam','EMPL','Modified',1012),(1345,'2016-06-01','bmandyam','EMPL','Modified',1012),(1346,'2016-06-01','bmandyam','EMPL','Modified',1012),(1347,'2016-06-01','bmandyam','EMPL','Modified',1012),(1348,'2016-06-01','bmandyam','EMPL','Modified',1007),(1349,'2016-07-04','bmandyam','EMPL','Modified',1022),(1350,'2017-02-16','bmandyam','EMPL','Modified',1020),(1351,'2018-04-05','bmandyam','EMPL','Modified',1028),(1352,'2018-04-05','aero','VEND','Modified',1028);

--
-- Table structure for table `mtl_supplier_notes`
--

CREATE TABLE `mtl_supplier_notes` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `suppliernotes` longtext,
  `link2supplier` int(11) DEFAULT NULL,
  `link2user` varchar(255) DEFAULT NULL,
  `link2po` int(10) unsigned DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtl_supplier_notes`
--

INSERT INTO `mtl_supplier_notes` VALUES (1,'test',129,'aero',1028,'2018-04-05','2018-04-05');

--
-- Table structure for table `mtl_tracker`
--

CREATE TABLE `mtl_tracker` (
  `recnum` int(11) DEFAULT NULL,
  `ponum` varchar(20) DEFAULT NULL,
  `vendor_name` varchar(30) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `adv_license_qty` float DEFAULT NULL,
  `qty` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtl_tracker`
--

INSERT INTO `mtl_tracker` VALUES (10073,'PO1','2','RMT',NULL,0),(10074,'214','2','sc',NULL,0),(10075,'35','2','sc',NULL,0),(10076,'','2','sc',NULL,0),(10077,'12','2','sfff',NULL,0),(10078,'4','2','dg',NULL,0),(10079,'2','2','sc',NULL,0),(10080,'po4','2','sc',NULL,0),(10083,'11','2','sfff',NULL,0),(10084,'112','128','',NULL,0),(10085,'45','129','RMT3',NULL,0),(10087,'1','2','',NULL,0),(10088,'1','2','RMT',NULL,0),(10089,'2','129','sc',NULL,0),(10090,'3','129','RMT3',NULL,0),(10091,'4','130','RMT4',NULL,0),(10092,'5','130','sfff',NULL,0),(10093,'6','129','dg',NULL,0),(10094,'234','129','RMT 6',NULL,0),(10095,'555','129','RMS 7',NULL,0),(10096,'5551','129','RMT 8',NULL,0),(10097,'PO-001','129','rmt',NULL,0),(10099,'KARPO-001','132','rm type',NULL,0),(10100,'KAR-002','132','PART',NULL,0),(10101,'KARCO-001','132','PART',NULL,0),(10102,'PO-002','129','test',NULL,0),(10103,'PO-099','129','RM type',NULL,0),(10105,'PO-100','129','RM type',NULL,0),(10106,'CUSTPO-011','129','rm type',NULL,5),(10107,'po-01','129','rm type',NULL,10),(10108,'po-012','129','rm type',NULL,10),(10109,'po-0112','129','rm type',NULL,11),(10110,'po-121','129','rm type',NULL,1),(10111,'po-1221','129','rm type',NULL,1),(10112,'po-0011','129','rm type',NULL,10),(10113,'po-019','129','RM type',NULL,2),(10114,'po-0119','129','RM type',NULL,2),(10115,'p0-0101','129','rm type',NULL,12),(10116,'po-0197','129','RM type',NULL,2),(10117,'po-0179','129','RM type',NULL,3),(10118,'po-01dsadasd','129','RM type',NULL,5),(10119,'po-EE','129','rm type',NULL,12),(10120,'po-EE','129','RM type',NULL,5),(10121,'po-64','174','rm type',NULL,100),(10122,'po-07','129','rm type',NULL,30),(10123,'po-117','129','rm type',NULL,30),(10124,'','129','rm type',NULL,30),(10125,'','129','rm type',NULL,10),(10126,'','129','rm type',NULL,3),(10127,'','129','rm type',NULL,2),(10128,'','174','rm type',NULL,20),(10130,'','178','rm type',NULL,0),(10131,'','178','rm type',NULL,100),(10133,'','178','rm type',NULL,10),(10134,'','129','rm type',NULL,100),(10135,'','129','rm type',NULL,100),(10137,'PO1068','129','rm type',NULL,1),(1,'PO001','178','rm type',NULL,10),(1,'PO001','178','rm type',NULL,90),(10139,'PO1067','178','rm type',NULL,11),(10140,'PO1068','173','RM type1',NULL,10),(10142,'PO1069','173','RM type1',NULL,90),(10143,'PO1070','173','RM type1',NULL,10),(10144,'PO1071','178','RM type1',NULL,10),(10146,'PO1072','173','AL',NULL,10),(2,'PO002','3','AL 101',NULL,2),(4,'PO003','3','Ni',NULL,10),(1,'','3','',NULL,11),(6,'PO004','5','rm type',NULL,10);

--
-- Table structure for table `mtl_tracker_li`
--

CREATE TABLE `mtl_tracker_li` (
  `recnum` int(11) DEFAULT NULL,
  `invnum` varchar(20) DEFAULT NULL,
  `invdate` date DEFAULT NULL,
  `invqty` float DEFAULT NULL,
  `supdel_date` date DEFAULT NULL,
  `paydue_date` date DEFAULT NULL,
  `payexp_date` date DEFAULT NULL,
  `pick_date` date DEFAULT NULL,
  `sail_date` date DEFAULT NULL,
  `eda` date DEFAULT NULL,
  `aad` date DEFAULT NULL,
  `expclr_date` date DEFAULT NULL,
  `cfdel_date` date DEFAULT NULL,
  `link2mtltracker` int(11) DEFAULT NULL,
  `ffpaydue_date` date DEFAULT NULL,
  `ffpayexp_date` date DEFAULT NULL,
  `cfpaydue_date` date DEFAULT NULL,
  `cfpayexp_date` date DEFAULT NULL,
  `packnum` varchar(50) DEFAULT NULL,
  `bill_lading_num` varchar(50) DEFAULT NULL,
  `bill_lading_date` date DEFAULT NULL,
  `docket_num` varchar(50) DEFAULT NULL,
  `boe_num` varchar(50) DEFAULT NULL,
  `credit_note_no` int(11) DEFAULT NULL,
  `recd_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtl_tracker_li`
--

INSERT INTO `mtl_tracker_li` VALUES (580,'1233','2017-02-01',1,'2017-02-28','0000-00-00','0000-00-00','0000-00-00','0000-00-00','0000-00-00','0000-00-00','0000-00-00','0000-00-00',10096,'0000-00-00','0000-00-00','0000-00-00','0000-00-00','ps-001','b/l-01','2017-09-08','','',NULL,NULL);

--
-- Table structure for table `mtm_leads_opportunity`
--

CREATE TABLE `mtm_leads_opportunity` (
  `leads_recnum` int(11) DEFAULT NULL,
  `opportunity_recnum` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtm_leads_opportunity`
--

INSERT INTO `mtm_leads_opportunity` VALUES (3,4),(3,3),(4,4),(4,3),(5,3),(5,4),(4,5),(5,5);

--
-- Table structure for table `mtm_po_wo`
--

CREATE TABLE `mtm_po_wo` (
  `po_recnum` int(11) DEFAULT NULL,
  `wo_recnum` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtm_po_wo`
--


--
-- Table structure for table `mtm_wo_grn`
--

CREATE TABLE `mtm_wo_grn` (
  `wo` char(20) DEFAULT NULL,
  `grn` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mtm_wo_grn`
--


--
-- Table structure for table `nc4qa`
--

CREATE TABLE `nc4qa` (
  `recnum` int(11) DEFAULT NULL,
  `refnum` varchar(20) DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `partname` varchar(25) DEFAULT NULL,
  `bachnum` varchar(20) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `matl_spec` varchar(20) DEFAULT NULL,
  `issues_ps` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `ponum` varchar(20) DEFAULT NULL,
  `part_sl_num` varchar(20) DEFAULT NULL,
  `wonum` varchar(20) DEFAULT NULL,
  `dcnum` varchar(20) DEFAULT NULL,
  `dcdate` date DEFAULT NULL,
  `traceability_recnum` varchar(30) DEFAULT NULL,
  `dim_deviation` varchar(5) DEFAULT NULL,
  `man` varchar(5) DEFAULT NULL,
  `inprocess` varchar(5) DEFAULT NULL,
  `mat_deviation` varchar(5) DEFAULT NULL,
  `machine` varchar(5) DEFAULT NULL,
  `final_insp` varchar(5) DEFAULT NULL,
  `other_deviation` varchar(5) DEFAULT NULL,
  `method` varchar(5) DEFAULT NULL,
  `cust_end` varchar(5) DEFAULT NULL,
  `description` text,
  `root_cause` text,
  `corrective_action` text,
  `preventive_action` text,
  `effectiveness` text,
  `cofcnum` varchar(20) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `super_name` varchar(100) DEFAULT NULL,
  `oper_name` varchar(255) DEFAULT NULL,
  `cust_ncno` varchar(100) DEFAULT NULL,
  `cust_ncdate` date DEFAULT NULL,
  `remarks` text,
  `formatnum` varchar(255) DEFAULT NULL,
  `formatrev` varchar(255) DEFAULT NULL,
  `rm_cost` decimal(10,2) DEFAULT NULL,
  `currency` char(10) DEFAULT NULL,
  `status` char(30) DEFAULT NULL,
  `accepted` varchar(5) DEFAULT NULL,
  `rejected` varchar(5) DEFAULT NULL,
  `quarantined` varchar(5) DEFAULT NULL,
  `wotype` varchar(45) DEFAULT NULL,
  `dn_num` varchar(45) DEFAULT NULL,
  `stagenum` varchar(30) DEFAULT NULL,
  `rework` char(5) DEFAULT NULL,
  `mc_name` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `onsite` char(5) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  KEY `ind_nc4qa_wonum` (`wonum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nc4qa`
--


--
-- Table structure for table `nc4stores`
--

CREATE TABLE `nc4stores` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `refnum` varchar(45) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `supplier` varchar(45) DEFAULT NULL,
  `rm_po_num` varchar(45) DEFAULT NULL,
  `receipt_date` date DEFAULT NULL,
  `invoice_num` varchar(45) DEFAULT NULL,
  `bol_num` varchar(45) DEFAULT NULL,
  `cofcnum` varchar(20) DEFAULT NULL,
  `dim_deviation` varchar(5) DEFAULT NULL,
  `mat_deviation` varchar(5) DEFAULT NULL,
  `descrepancy_quantity` varchar(5) DEFAULT NULL,
  `raw_material_docs` varchar(5) DEFAULT NULL,
  `specific_marking` varchar(5) DEFAULT NULL,
  `root_cause` text,
  `corrective_action` text,
  `preventive_action` text,
  `nc_created_by` varchar(45) DEFAULT NULL,
  `nc_supplied_by` varchar(45) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `effectiveness` text,
  `other_deviation` varchar(5) DEFAULT NULL,
  `description` text,
  `formatnum` varchar(255) DEFAULT NULL,
  `formatrev` varchar(255) DEFAULT NULL,
  `qty` int(10) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `supplier_answer` text,
  `grnnum` varchar(55) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nc4stores`
--

INSERT INTO `nc4stores` VALUES (1,'3434','2017-02-16','sss','24443','2017-02-16','','','','Yes','No','Yes','Yes','No','','','','','','0000-00-00','','Yes','','F7533','Rev. No.0',NULL,NULL,NULL,NULL,'FSI');

--
-- Table structure for table `ncforstores`
--

CREATE TABLE `ncforstores` (
  `recnum` int(11) DEFAULT NULL,
  `refnum` varchar(30) DEFAULT NULL,
  `partnum` varchar(30) DEFAULT NULL,
  `partname` varchar(30) DEFAULT NULL,
  `rm_invoice_num` varchar(30) DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `received_date` date DEFAULT NULL,
  `dcnum` varchar(30) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `ponum` varchar(30) DEFAULT NULL,
  `rmdim1` varchar(20) DEFAULT NULL,
  `rmdim2` varchar(20) DEFAULT NULL,
  `rmdim3` varchar(20) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ncforstores`
--


--
-- Table structure for table `ncqa`
--

CREATE TABLE `ncqa` (
  `recnum` int(11) DEFAULT NULL,
  `refnum` varchar(20) DEFAULT NULL,
  `customer` varchar(20) DEFAULT NULL,
  `partname` varchar(25) DEFAULT NULL,
  `bachnum` varchar(20) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `matl_spec` varchar(20) DEFAULT NULL,
  `issues_ps` varchar(10) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `ponum` varchar(20) DEFAULT NULL,
  `part_sl_num` varchar(20) DEFAULT NULL,
  `wonum` varchar(20) DEFAULT NULL,
  `dcnum` varchar(20) DEFAULT NULL,
  `dcdate` date DEFAULT NULL,
  `traceability_recnum` varchar(30) DEFAULT NULL,
  `dim_deviation` varchar(5) DEFAULT NULL,
  `man` varchar(5) DEFAULT NULL,
  `inprocess` varchar(5) DEFAULT NULL,
  `mat_deviation` varchar(5) DEFAULT NULL,
  `machine` varchar(5) DEFAULT NULL,
  `final_insp` varchar(5) DEFAULT NULL,
  `other_deviation` varchar(5) DEFAULT NULL,
  `method` varchar(5) DEFAULT NULL,
  `cust_end` varchar(5) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `root_cause` varchar(255) DEFAULT NULL,
  `corrective_action` varchar(255) DEFAULT NULL,
  `preventive_action` varchar(255) DEFAULT NULL,
  `effectiveness` varchar(255) DEFAULT NULL,
  `cofcnum` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ncqa`
--


--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `recnum` int(11) DEFAULT NULL,
  `created_by` varchar(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `descr` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES (20,'bmandyam','2016-09-28','test tuss uuiyi hiiox jhiihk kkhihi kkhoo hkhoo hoo hoos mshklhdl kksoi ksdkls lsdlsos kxnksdko sdklklsdhlshdlksljdosd khsdkshdskhdks khkhkhkhkh hkhkhkhl.'),(21,'bmandyam','2016-09-29','  dsgdsg gfsdg sdgfdsgds gsdg sdgsdgdsg dfgsdfgfsg fdgsd'),(22,'bmandyam','2016-09-30','  hjhgkj'),(23,'bmandyam','2016-09-28','  cgfdg');

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `recnum` int(11) DEFAULT NULL,
  `notes` longtext,
  `create_date` date DEFAULT NULL,
  `notes2user` int(11) DEFAULT NULL,
  `notes2wo` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notes`
--


--
-- Table structure for table `oper_mc_usage`
--

CREATE TABLE `oper_mc_usage` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `mc_id` varchar(20) DEFAULT NULL,
  `mc_name` varchar(50) DEFAULT NULL,
  `running_time` float DEFAULT NULL,
  `stage_num` int(11) DEFAULT NULL,
  `link2operator` int(11) DEFAULT NULL,
  `oper_name` varchar(30) DEFAULT NULL,
  `setting_time` float DEFAULT NULL,
  `idle_time` float DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `sl_from` varchar(30) DEFAULT NULL,
  `sl_to` varchar(30) DEFAULT NULL,
  `setting_time_mins` float DEFAULT NULL,
  `running_time_mins` float DEFAULT NULL,
  `idle_time_mins` float DEFAULT NULL,
  `qty_rej` float DEFAULT NULL,
  `markup_time` decimal(4,2) DEFAULT '0.00',
  `markup_time_mins` decimal(4,2) DEFAULT '0.00',
  `markdown_time` decimal(4,2) DEFAULT '0.00',
  `markdown_time_mins` decimal(4,2) DEFAULT '0.00',
  `qty_acc` float DEFAULT NULL,
  `qty_rew` float DEFAULT NULL,
  `breakdown_time` decimal(6,2) DEFAULT NULL,
  `breakdown_time_mins` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`recnum`),
  KEY `ind_link2operator` (`link2operator`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oper_mc_usage`
--

INSERT INTO `oper_mc_usage` VALUES (1,'','BMV 60-1',1,1,1,'',1,0,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,0.00,0.00),(2,'','BMV 1',1,1,2,'',1,0,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,0.00,0.00),(3,'','VMC 2',1,1,3,'',1,1,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,1.00,0.00),(4,'','DMG 3',1,1,4,'',1,1,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,1.00,0.00),(5,'','DX 4',1,1,5,'',1,1,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,1.00,0.00),(6,'','HMC 5',2,1,6,'',2,2,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,2.00,0.00),(7,'','VMC 2',1,1,7,'',1,1,1,'0','0',0,0,0,0,0.00,0.00,0.00,0.00,1,0,1.00,0.00),(8,'','VMC 2',2,1,8,'',2,1,1,'0','0',2,0,0,0,0.00,0.00,0.00,0.00,1,0,2.00,0.00);

--
-- Table structure for table `operation`
--

CREATE TABLE `operation` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `opnnum` varchar(25) DEFAULT NULL,
  `stn` varchar(50) DEFAULT NULL,
  `oper_descr` varchar(255) DEFAULT NULL,
  `signoff` varchar(50) DEFAULT NULL,
  `link2assywo` int(11) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `operation`
--


--
-- Table structure for table `operator`
--

CREATE TABLE `operator` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `oper_id` varchar(10) DEFAULT NULL,
  `oper_name` varchar(50) DEFAULT NULL,
  `shift` varchar(10) DEFAULT NULL,
  `crn` varchar(30) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `st_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `qty_rej` int(11) DEFAULT NULL,
  `qty_with_dev` int(11) DEFAULT NULL,
  `qty_accepted` int(11) DEFAULT NULL,
  `mc_name` varchar(50) DEFAULT NULL,
  `wo_num` varchar(20) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`recnum`),
  KEY `opcrn` (`crn`),
  KEY `opwonumm` (`wo_num`),
  KEY `ind_opername` (`oper_name`),
  KEY `ind_mc_name` (`mc_name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `operator`
--

INSERT INTO `operator` VALUES (2,'','','1','prn1',NULL,'2016-10-28',NULL,0,0,0,'BMV 1','31404','','Approved','FSI'),(3,'','','1','prn2',NULL,'2016-11-02',NULL,0,0,0,'VMC 2','31400','test','Approved','FSI'),(4,'','','1','prn1',NULL,'2016-11-02',NULL,0,0,0,'DMG 3','31405','test','Approved','FSI'),(5,'','','1','prn3',NULL,'2016-11-02',NULL,0,0,0,'DX 4','31398','test','Approved','FSI'),(6,'','','1','prn5',NULL,'2016-11-02',NULL,0,0,0,'HMC 5','31401','test','Approved','FSI'),(7,'','','1','prn2',NULL,'2016-11-04',NULL,0,0,0,'VMC 2','31400','TEST','Approved','FSI'),(8,'','','1','prn3',NULL,'2016-11-10',NULL,0,0,0,'VMC 2','31414','test','Approved','FSI');

--
-- Table structure for table `opportunity_notes`
--

CREATE TABLE `opportunity_notes` (
  `recnum` int(11) DEFAULT NULL,
  `notes` longtext,
  `create_date` date DEFAULT NULL,
  `notes2user` int(11) DEFAULT NULL,
  `notes2opportunity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `opportunity_notes`
--


--
-- Table structure for table `packing`
--

CREATE TABLE `packing` (
  `recnum` int(10) unsigned NOT NULL,
  `ponum` varchar(45) DEFAULT NULL,
  `podate` date DEFAULT NULL,
  `wonum` varchar(45) DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `order_qty` varchar(45) DEFAULT NULL,
  `qty_dispatch` varchar(45) DEFAULT NULL,
  `qty_balance` varchar(45) DEFAULT NULL,
  `cim_invoice` varchar(45) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `pack_date` date DEFAULT NULL,
  `no_packings` int(10) unsigned DEFAULT NULL,
  `type_packing` varchar(255) DEFAULT NULL,
  `transportation` varchar(100) DEFAULT NULL,
  `link2company` int(10) unsigned DEFAULT NULL,
  `packingnum` varchar(45) DEFAULT NULL,
  `link2invoice` int(10) unsigned DEFAULT NULL,
  `formrev` varchar(255) DEFAULT NULL,
  `tot_net_wt` float DEFAULT NULL,
  `gross_wt` float DEFAULT NULL,
  `siteid` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `packing`
--


--
-- Table structure for table `part_bom`
--

CREATE TABLE `part_bom` (
  `recnum` int(11) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `part_unit` varchar(20) DEFAULT NULL,
  `rm_spec` varchar(20) DEFAULT NULL,
  `req_rm_qty` int(11) DEFAULT NULL,
  `rm_units` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `part_bom`
--


--
-- Table structure for table `part_master`
--

CREATE TABLE `part_master` (
  `recnum` int(11) DEFAULT NULL,
  `part_num` varchar(100) DEFAULT NULL,
  `part_desc` varchar(255) DEFAULT NULL,
  `mfr` varchar(255) DEFAULT NULL,
  `domain` varchar(50) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `units` varchar(50) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `store_qty` int(11) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `part_master`
--


--
-- Table structure for table `part_used`
--

CREATE TABLE `part_used` (
  `recnum` int(11) DEFAULT NULL,
  `part_used_num` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `serial_no` varchar(255) DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `subtype` varchar(30) DEFAULT NULL,
  `part_used2part_master` int(11) DEFAULT NULL,
  `part_used2type` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `last_modified_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `part_used`
--


--
-- Table structure for table `partwise_req`
--

CREATE TABLE `partwise_req` (
  `recnum` int(11) DEFAULT NULL,
  `slnum` int(11) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `customer` varchar(30) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `target` varchar(20) DEFAULT NULL,
  `achieved` varchar(10) DEFAULT NULL,
  `balance` varchar(20) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `partwise_req`
--


--
-- Table structure for table `payroll`
--

CREATE TABLE `payroll` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lname` varchar(45) NOT NULL,
  `fname` varchar(45) NOT NULL,
  `init` varchar(1) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `bdate` date NOT NULL,
  `dept` varchar(15) NOT NULL,
  `position` varchar(45) NOT NULL,
  `pay` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `dayswork` int(10) unsigned NOT NULL DEFAULT '0',
  `otrate` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `othrs` int(10) unsigned NOT NULL DEFAULT '0',
  `allow` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `advances` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `insurance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `siteid` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payroll`
--

INSERT INTO `payroll` VALUES (1,'aa','ass','a','male','2017-05-02','Accounting','',0.00,0,0.00,0,0.00,0.00,0.00,'flu_1779'),(2,'s','a','s','male','2017-05-31','Accounting','',0.00,0,0.00,0,0.00,0.00,0.00,'flu_1779'),(3,'','','','male','0000-00-00','Accounting','',0.00,0,0.00,0,0.00,0.00,0.00,'E3456'),(4,'','','','male','0000-00-00','Marketing','',0.00,0,0.00,0,0.00,0.00,0.00,'FSI');

--
-- Table structure for table `payroll_master`
--

CREATE TABLE `payroll_master` (
  `recnum` int(11) DEFAULT NULL,
  `id` varchar(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `basic_salary` int(11) DEFAULT NULL,
  `hra` varchar(30) DEFAULT NULL,
  `ta` varchar(100) DEFAULT NULL,
  `sa` varchar(100) DEFAULT NULL,
  `join_date` date DEFAULT NULL,
  `increment` int(11) DEFAULT NULL,
  `siteid` varchar(55) DEFAULT NULL,
  `role` varchar(45) DEFAULT NULL,
  `grade` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payroll_master`
--

INSERT INTO `payroll_master` VALUES (3,'E242','Karthick',8000,'5000','2000','5000','2015-04-06',5000,'FSI','Developer','S');

--
-- Table structure for table `payroll_monthly`
--

CREATE TABLE `payroll_monthly` (
  `recnum` int(11) DEFAULT NULL,
  `id` varchar(20) DEFAULT NULL,
  `hrs_worked` int(11) DEFAULT NULL,
  `ot` int(11) DEFAULT NULL,
  `gross_salary` int(11) DEFAULT NULL,
  `tds` int(11) DEFAULT NULL,
  `net_salary` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `siteid` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payroll_monthly`
--

INSERT INTO `payroll_monthly` VALUES (7,'E242',35,0,4583,0,4583,'2017-08-07','FSI');

--
-- Table structure for table `payroll_trans`
--

CREATE TABLE `payroll_trans` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `empid` varchar(50) DEFAULT NULL,
  `date` datetime NOT NULL,
  `siteid` varchar(50) NOT NULL,
  `checkInOut` tinyint(1) DEFAULT NULL,
  `TaskId` varchar(50) NOT NULL,
  `Lat` varchar(50) NOT NULL,
  `Lon` varchar(50) NOT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payroll_trans`
--

INSERT INTO `payroll_trans` VALUES (1,'E2','2017-08-21 16:37:03','FSI',1,'TK-8','0','0'),(2,'E2','2017-08-21 16:37:11','FSI',0,'TK-8','0','0'),(3,'E2','2017-08-21 17:03:41','FSI',1,'TK-11','0','0'),(4,'E2','2017-08-21 17:20:33','FSI',0,'TK-11','0','0'),(5,'E2','2017-08-21 17:30:41','FSI',1,'TK-11','0','0'),(6,'E2','2017-08-21 17:35:37','FSI',2,'TK-11','0','0'),(7,'E2','2017-08-21 17:36:38','FSI',0,'TK-11','0','0'),(8,'E2','2017-08-22 10:26:52','FSI',1,'TK-9','0','0'),(9,'E2','2017-08-22 10:27:13','FSI',0,'TK-9','0','0'),(10,'E2','2017-08-22 11:48:41','FSI',1,'TK-9','0','0'),(11,'E2','2017-08-22 15:00:00','FSI',2,'TK-9','0','0');

--
-- Table structure for table `po`
--

CREATE TABLE `po` (
  `recnum` int(11) DEFAULT NULL,
  `ponum` varchar(100) DEFAULT NULL,
  `podate` varchar(255) DEFAULT NULL,
  `podescr` varchar(100) DEFAULT NULL,
  `terms` varchar(255) DEFAULT NULL,
  `ship_via` varchar(255) DEFAULT NULL,
  `acct_num` varchar(255) DEFAULT NULL,
  `fob` varchar(255) DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `poamount` decimal(15,2) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `wonum` varchar(50) DEFAULT NULL,
  `link2vendor` int(11) DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `last_modified` date DEFAULT NULL,
  `tax` decimal(15,2) DEFAULT NULL,
  `shipping` decimal(15,2) DEFAULT NULL,
  `labor` decimal(15,2) DEFAULT NULL,
  `total_due` decimal(15,2) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `formatnum` varchar(255) DEFAULT NULL,
  `formatrev` varchar(255) DEFAULT NULL,
  `remarks` text,
  `approval` varchar(5) DEFAULT NULL,
  `approvaldate` date DEFAULT NULL,
  `amendment_num` varchar(100) DEFAULT NULL,
  `amendmentdate` date DEFAULT NULL,
  `amendment_notes` longtext,
  `communication` int(11) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `advance_info` varchar(255) DEFAULT NULL,
  `advance_amount` decimal(12,2) DEFAULT NULL,
  `sgst` decimal(12,2) NOT NULL,
  `cgst` decimal(12,2) NOT NULL,
  `igst` decimal(12,2) NOT NULL,
  `link2customer` int(8) NOT NULL,
  `link2quoteid` varchar(100) NOT NULL,
  `stage` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `po`
--


--
-- Table structure for table `po_line_items`
--

CREATE TABLE `po_line_items` (
  `recnum` int(11) DEFAULT NULL,
  `line_num` varchar(20) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `rate` decimal(15,2) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `shipping_handling` decimal(10,2) DEFAULT NULL,
  `taxes` decimal(15,2) DEFAULT NULL,
  `link2po` int(11) DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `last_modified` date DEFAULT NULL,
  `material_ref` varchar(255) DEFAULT NULL,
  `material_spec` varchar(255) DEFAULT NULL,
  `thick` varchar(255) DEFAULT NULL,
  `width` varchar(255) DEFAULT NULL,
  `length` varchar(255) DEFAULT NULL,
  `qty_per_meter` float DEFAULT NULL,
  `no_of_meterages` float DEFAULT NULL,
  `delv_by` varchar(20) DEFAULT NULL,
  `uom` varchar(30) DEFAULT NULL,
  `grainflow` varchar(100) DEFAULT NULL,
  `no_of_lengths` float DEFAULT NULL,
  `accepted_date` date DEFAULT NULL,
  `condition` text,
  `crn` varchar(100) DEFAULT NULL,
  `maxruling` varchar(100) DEFAULT NULL,
  `qty_rej` int(11) DEFAULT NULL,
  `delivery_time` int(11) DEFAULT NULL,
  `order_qty` int(8) DEFAULT NULL,
  `alt_spec_rm` varchar(45) DEFAULT NULL,
  `spec_type` varchar(45) DEFAULT NULL,
  `layoutrefnum` varchar(45) DEFAULT NULL,
  `qty_recd` int(8) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `grn_num` varchar(45) DEFAULT NULL,
  `due_date1` date DEFAULT NULL,
  `due_date2` date DEFAULT NULL,
  `cim1_approval` varchar(5) DEFAULT NULL,
  `cim2_approval` varchar(5) DEFAULT NULL,
  `link2cust_po` varchar(32) NOT NULL,
  `po_num` varchar(32) NOT NULL,
  `link2quoteid` varchar(100) NOT NULL,
  KEY `ind_link2po` (`link2po`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `po_line_items`
--

INSERT INTO `po_line_items` VALUES (2,'1','','',NULL,'2019-08-06',100.00,200.00,NULL,NULL,2,'2019-08-06',NULL,'AL 101','AL','10','10','10',NULL,2,'SEA','MM','GF-1',0,'2019-08-06','10','prn-1','mrs-1',0,0,2,'100','Primary Spec','',2,'Close','li remarks','','0000-00-00','0000-00-00',NULL,NULL,'cust-po-1','PO002','supp_qt_id-1'),(3,'1-1','','',NULL,'2019-08-06',100.00,200.00,NULL,NULL,2,'2019-08-06',NULL,'AL 101','AL','10','10','10',NULL,2,'SEA','MM','GF-1',0,'2019-08-06','10','prn-1','mrs-1',0,0,2,'100','Primary Spec','',2,'Close','li remarks','G00002',NULL,NULL,NULL,NULL,'','',''),(4,'1','','',NULL,'2019-08-07',200.00,2000.00,NULL,NULL,3,'2019-08-07',NULL,'Ni','Ni 7080','12','14','12',NULL,10,'','MM','GF-12',0,'2019-08-07','14','prn-2','mrs-2',0,0,10,'200','Primary Spec','',10,'Close','','','0000-00-00','0000-00-00',NULL,NULL,'cust-po-2','PO003','supp_qt_id-2'),(5,'1-1','','',NULL,'2019-08-07',200.00,2000.00,NULL,NULL,3,'2019-08-07',NULL,'Ni','Ni 7080','12','14','12',NULL,10,'','MM','GF-12',0,'2019-08-07','14','prn-2','mrs-2',0,0,10,'200','Primary Spec','',10,'Close','','G00003',NULL,NULL,NULL,NULL,'','',''),(6,'1','','',NULL,'2019-08-10',10.00,100.00,NULL,NULL,4,'2019-08-10',NULL,'rm type','rm sepc','12','10','20',NULL,10,'SEA','MM','21',0,'2019-08-14','10','prn-3','11',0,0,10,'','Primary Spec','',10,'Close','','','0000-00-00','0000-00-00',NULL,NULL,'CUST-005','PO004','003');

--
-- Table structure for table `po_notes`
--

CREATE TABLE `po_notes` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ponotes` longtext,
  `link2user` varchar(50) DEFAULT NULL,
  `link2po` int(10) unsigned DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `po_notes`
--

INSERT INTO `po_notes` VALUES (1,'sadfdsgsdg','bmandyam',1015,'2016-05-26','2016-05-26'),(2,'sadfdsgsdg','bmandyam',1015,'2016-05-26','2016-05-26'),(3,'sadfdsgsdg','bmandyam',1015,'2016-05-26','2016-05-26'),(4,'sadfdsgsdg','bmandyam',1015,'2016-05-26','2016-05-26'),(5,'sadfdsgsdg','bmandyam',1015,'2016-05-26','2016-05-26'),(6,'sadfdsgsdg','bmandyam',1015,'2016-05-26','2016-05-26'),(7,'dsfsdgfdf','bmandyam',1015,'2016-05-26','2016-05-26'),(8,'1321424fdgdg','bmandyam',1015,'2016-05-26','2016-05-26'),(9,'swad','bmandyam',1015,'2016-05-26','2016-05-26'),(10,'saf','bmandyam',1015,'2016-05-26','2016-05-26'),(11,'safdsgds','bmandyam',1012,'2016-05-26','2016-05-26'),(12,'cxgvfd','bmandyam',1012,'2016-05-26','2016-05-26'),(13,'test','bmandyam',1012,'2016-06-01','2016-06-01'),(14,'test1','bmandyam',1012,'2016-06-01','2016-06-01'),(15,'test','bmandyam',1007,'2016-06-01','2016-06-01'),(16,'testing','bmandyam',1022,'2016-07-04','2016-07-04'),(17,'tes','bmandyam',1020,'2017-02-16','2017-02-16'),(18,'test','bmandyam',1028,'2018-04-05','2018-04-05');

--
-- Table structure for table `po_plan`
--

CREATE TABLE `po_plan` (
  `recnum` int(8) NOT NULL AUTO_INCREMENT,
  `link2vend` varchar(128) DEFAULT NULL,
  `link2cust` varchar(128) DEFAULT NULL,
  `partnum` varchar(128) DEFAULT NULL,
  `rfqid` varchar(128) DEFAULT NULL,
  `rfq_date` date DEFAULT NULL,
  `quoteid` varchar(128) DEFAULT NULL,
  `quote_rate` decimal(15,2) DEFAULT NULL,
  `ponum` varchar(128) DEFAULT NULL,
  `po_rate` decimal(15,2) DEFAULT NULL,
  `po_qty` decimal(15,2) DEFAULT NULL,
  `po_amount` decimal(15,2) DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `quote_date` date NOT NULL,
  `siteid` varchar(32) NOT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `po_plan`
--


--
-- Table structure for table `post_contract`
--

CREATE TABLE `post_contract` (
  `recnum` int(11) DEFAULT NULL,
  `cust_ponum` varchar(100) DEFAULT NULL,
  `wonum` varchar(100) DEFAULT NULL,
  `drg_no` varchar(100) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post_contract`
--


--
-- Table structure for table `post_contract_li`
--

CREATE TABLE `post_contract_li` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `section` varchar(100) DEFAULT NULL,
  `matl_Spec` varchar(100) DEFAULT NULL,
  `material` varchar(100) DEFAULT NULL,
  `exact_match` varchar(100) DEFAULT NULL,
  `equivalent_accepted` varchar(100) DEFAULT NULL,
  `altcust_approval` varchar(100) DEFAULT NULL,
  `rm_size` varchar(100) DEFAULT NULL,
  `grain_direction` varchar(100) DEFAULT NULL,
  `purchase_approval` varchar(100) DEFAULT NULL,
  `supplier` varchar(100) DEFAULT NULL,
  `supplier_approved` varchar(100) DEFAULT NULL,
  `cust_approval` varchar(100) DEFAULT NULL,
  `import_restriction` varchar(100) DEFAULT NULL,
  `mill_cert_required` varchar(100) DEFAULT NULL,
  `as approved` varchar(100) DEFAULT NULL,
  `approval_reference` varchar(100) DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `process_approved` varchar(100) DEFAULT NULL,
  `cert_required` varchar(100) DEFAULT NULL,
  `NADCAP_approved` varchar(100) DEFAULT NULL,
  `production_machine` varchar(100) DEFAULT NULL,
  `process` varchar(100) DEFAULT NULL,
  `size` varchar(100) DEFAULT NULL,
  `accuracy` varchar(100) DEFAULT NULL,
  `surface_finish` varchar(100) DEFAULT NULL,
  `tools` varchar(100) DEFAULT NULL,
  `program` varchar(100) DEFAULT NULL,
  `capacity` varchar(100) DEFAULT NULL,
  `quality` varchar(100) DEFAULT NULL,
  `measureability_of_parameters` varchar(100) DEFAULT NULL,
  `cmm_requirement` varchar(100) DEFAULT NULL,
  `customer_plan` varchar(100) DEFAULT NULL,
  `sample_size` varchar(100) DEFAULT NULL,
  `fai_req` varchar(100) DEFAULT NULL,
  `pdi` varchar(100) DEFAULT NULL,
  `standard_availability` varchar(100) DEFAULT NULL,
  `others` varchar(100) DEFAULT NULL,
  `miscellaneous` varchar(100) DEFAULT NULL,
  `rm_store_space` varchar(100) DEFAULT NULL,
  `shelf_life` varchar(100) DEFAULT NULL,
  `cutting_feasibility` varchar(100) DEFAULT NULL,
  `special_coolant_req` varchar(100) DEFAULT NULL,
  `packing_feasibility` varchar(100) DEFAULT NULL,
  `logistics_feasibility` varchar(100) DEFAULT NULL,
  `risks_identified` varchar(100) DEFAULT NULL,
  `rpn` varchar(100) DEFAULT NULL,
  `riskreg_entry_no` varchar(100) DEFAULT NULL,
  `identified_by` varchar(100) DEFAULT NULL,
  `reviewed` varchar(100) DEFAULT NULL,
  `link2contract` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post_contract_li`
--


--
-- Table structure for table `price`
--

CREATE TABLE `price` (
  `recnum` int(11) DEFAULT NULL,
  `crn` char(50) DEFAULT NULL,
  `partnum` varchar(255) DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `currency` char(5) DEFAULT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  `status` char(10) DEFAULT NULL,
  `price_valid_from` date DEFAULT NULL,
  `price_valid_to` date DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `link2customer` int(10) unsigned DEFAULT NULL,
  `partname` varchar(255) DEFAULT NULL,
  `formrev` varchar(255) DEFAULT NULL,
  `siteid` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `price`
--


--
-- Table structure for table `proc_deviation`
--

CREATE TABLE `proc_deviation` (
  `recnum` int(11) DEFAULT NULL,
  `partnumber` varchar(50) DEFAULT NULL,
  `drgissue` varchar(50) DEFAULT NULL,
  `procdev2customer` int(11) DEFAULT NULL,
  `partname` varchar(100) DEFAULT NULL,
  `matltype` varchar(50) DEFAULT NULL,
  `matlspec` varchar(50) DEFAULT NULL,
  `project` varchar(100) DEFAULT NULL,
  `refno` varchar(50) DEFAULT NULL,
  `attachments` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proc_deviation`
--


--
-- Table structure for table `proc_deviation_li`
--

CREATE TABLE `proc_deviation_li` (
  `recnum` int(11) DEFAULT NULL,
  `sl_num` varchar(20) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `signature` varchar(50) DEFAULT NULL,
  `link2procdev` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proc_deviation_li`
--


--
-- Table structure for table `process_details`
--

CREATE TABLE `process_details` (
  `recnum` int(11) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `part_tasks` varchar(20) DEFAULT NULL,
  `mfg_cycle_time` varchar(20) DEFAULT NULL,
  `inspection_time` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `process_details`
--


--
-- Table structure for table `production_plan`
--

CREATE TABLE `production_plan` (
  `recnum` int(11) DEFAULT NULL,
  `slnum` int(11) DEFAULT NULL,
  `partnum` varchar(20) DEFAULT NULL,
  `customer` varchar(30) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `target` varchar(20) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `production_plan`
--


--
-- Table structure for table `production_sch`
--

CREATE TABLE `production_sch` (
  `recnum` int(11) DEFAULT NULL,
  `partnum` varchar(50) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `est_start_date` date DEFAULT NULL,
  `crnnum` varchar(30) DEFAULT NULL,
  `book_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `production_sch`
--


--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `project` varchar(255) DEFAULT NULL,
  `desc` text,
  `start_date` date DEFAULT NULL,
  `closed_date` date DEFAULT NULL,
  `manager` char(100) DEFAULT NULL,
  `req` varchar(255) DEFAULT NULL,
  `category` char(50) DEFAULT NULL,
  `technology` char(50) DEFAULT NULL,
  `platform` char(50) DEFAULT NULL,
  `link2site` int(11) DEFAULT NULL,
  `released_to` varchar(255) DEFAULT NULL,
  `link2company` int(11) DEFAULT NULL,
  `siteid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project`
--

INSERT INTO `project` VALUES (1,'React','React','2017-08-10','2017-09-30','Karthick','2 laps','Wep App','Web App','JS',NULL,NULL,134,NULL),(2,'laravel','simple crud application','2017-09-01','2017-09-30','karthick','nothing','crud','react','php',NULL,NULL,134,NULL);

--
-- Table structure for table `purchasing_alloc`
--

CREATE TABLE `purchasing_alloc` (
  `recnum` int(11) NOT NULL DEFAULT '0',
  `linenum` varchar(20) DEFAULT NULL,
  `mat_spec` varchar(30) DEFAULT NULL,
  `crn` varchar(30) DEFAULT NULL,
  `qty_allocated` int(11) DEFAULT NULL,
  `ponum` varchar(100) DEFAULT NULL,
  `link2poli` int(11) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasing_alloc`
--


--
-- Table structure for table `quality_plan`
--

CREATE TABLE `quality_plan` (
  `recnum` int(11) DEFAULT NULL,
  `opnrefno` varchar(50) DEFAULT NULL,
  `operationnumber` varchar(50) DEFAULT NULL,
  `partnumber` varchar(50) DEFAULT NULL,
  `revnumber` varchar(50) DEFAULT NULL,
  `partname` varchar(100) DEFAULT NULL,
  `revdate` date DEFAULT NULL,
  `parttype` varchar(100) DEFAULT NULL,
  `drgissue` varchar(50) DEFAULT NULL,
  `approvedby` varchar(100) DEFAULT NULL,
  `preparedby` varchar(100) DEFAULT NULL,
  `issuesnumber` varchar(50) DEFAULT NULL,
  `sheet` varchar(50) DEFAULT NULL,
  `attachments` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `descr` longtext,
  `wonum` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quality_plan`
--

INSERT INTO `quality_plan` VALUES (11,'qp-001',NULL,'121','1213','sss','2016-08-31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-16','trst','31472'),(12,'qp-002',NULL,'3434','00','dsds','0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-17','tesdgrd','31470');

--
-- Table structure for table `quality_plan_line_items`
--

CREATE TABLE `quality_plan_line_items` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `sl_num` varchar(20) DEFAULT NULL,
  `drawing_dim` varchar(50) DEFAULT NULL,
  `measuring_istrument` varchar(50) DEFAULT NULL,
  `samplesize` varchar(50) DEFAULT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `link2qualityplan` int(11) DEFAULT NULL,
  `nominal` varchar(100) DEFAULT NULL,
  `upper_tool` varchar(100) DEFAULT NULL,
  `lower_tool` varchar(100) DEFAULT NULL,
  `upper_limit` varchar(100) DEFAULT NULL,
  `lower_limit` varchar(100) DEFAULT NULL,
  `control` varchar(100) DEFAULT NULL,
  `reaction_control` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quality_plan_line_items`
--

INSERT INTO `quality_plan_line_items` VALUES (1,'1','22','dgg4','12','test',11,'3243','ut1','lt1','ul1','ll1','tesefhtbg','3fdvdf'),(2,'1','22','dgg4','12','test',0,'3243','ut1','lt1','ul1','ll1','tesefhtbg','3fdvdf'),(3,'1','22','dgg4','12','test',0,'3243','ut1','lt1','ul1','ll1','tesefhtbg','3fdvdf'),(4,'1','22','dgg4','12','test',11,'3243','ut1','lt1','ul1','ll1','tesefhtbg','3fdvdf'),(5,'1','tesete','v v','33','fcbfb',12,'edtdsg','dc','fdbf','fbf','bvb','cvc','cc'),(7,'2','dvd','ngngb','556','gn',12,'bfdbdf','gbg','ngfgb','gbgfb','gfnbgng','vnb','bgng'),(8,'3','dfd','fnfn','ffnfn','fh',12,'dvb','dbfb','fbfn','fnfn','fnfn','fhfh','fhfh');

--
-- Table structure for table `quote`
--

CREATE TABLE `quote` (
  `recnum` int(11) DEFAULT NULL,
  `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,
  `link2risk` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quote`
--


--
-- Table structure for table `quote_li`
--

CREATE TABLE `quote_li` (
  `recnum` int(11) 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,
  `quote_num` varchar(32) NOT NULL,
  `partnum` varchar(100) NOT NULL,
  `rmtype` varchar(200) NOT NULL,
  `rmspec` varchar(200) NOT NULL,
  `partiss` varchar(200) NOT NULL,
  `drgiss` varchar(200) NOT NULL,
  `uom` varchar(10) NOT NULL,
  `dia` varchar(50) NOT NULL,
  `length` varchar(50) NOT NULL,
  `thickness` varchar(50) NOT NULL,
  `grainflow` varchar(50) NOT NULL,
  `maxruling` varchar(50) NOT NULL,
  `cos_iss` varchar(50) NOT NULL,
  `part_desc` varchar(200) NOT NULL,
  `remarks_li` varchar(200) NOT NULL,
  `rfqid` varchar(32) NOT NULL,
  `quote_date` date NOT NULL,
  `linenum` varchar(32) NOT NULL,
  `width` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quote_li`
--


--
-- Table structure for table `rccp_plan`
--

CREATE TABLE `rccp_plan` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mc_name` varchar(45) DEFAULT NULL,
  `crn` varchar(65) DEFAULT NULL,
  `capacity_hrs` float DEFAULT '0',
  `req_hrs` float DEFAULT '0',
  `remaining_hrs` float DEFAULT '0',
  `option_used_hrs` float DEFAULT '0',
  `calendar_option` text,
  `calendar_option_hrs` float DEFAULT '0',
  `altwoc_option` text,
  `altwoc_option_hrs` float DEFAULT '0',
  `qty_option` text,
  `qty_option_hrs` float DEFAULT '0',
  `plan_month` varchar(45) DEFAULT NULL,
  `plan_year` varchar(45) DEFAULT NULL,
  `create_date` date DEFAULT '0000-00-00',
  `modified_date` date DEFAULT '0000-00-00',
  `created_by` varchar(65) DEFAULT NULL,
  `modified_by` varchar(65) DEFAULT NULL,
  `siteid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rccp_plan`
--

INSERT INTO `rccp_plan` VALUES (7,'F5-3','51-097',700,45,655,0,'{\"A51-nx\":[{\"date\":\"2018-10-14\",\"shift\":2},{\"date\":\"2018-10-21\",\"shift\":2},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-14\",\"shift\":3},{\"date\":\"2018-10-21\",\"shift\":3}]}',0,'{\"A51-nx\":[{\"mcname\":\"Slim3n-4AHS-1\",\"balhrs\":450},{\"mcname\":\"Slim3n-4AHS-2\",\"balhrs\":421},{\"mcname\":\"F5-3\",\"balhrs\":45}]}',0,'{\"A51-nx\":[{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"1\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"500:30\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"2\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"195:0\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"1\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"2\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79}]}',0,'10','2018','2018-09-14','0000-00-00','Karthick',NULL,'FSI'),(8,'i700-1','51-095, 51-111, 51-110',1300,1964,-664,0,'{\"A51-nx\":[{\"date\":\"2018-10-14\",\"shift\":2},{\"date\":\"2018-10-21\",\"shift\":2},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-14\",\"shift\":3},{\"date\":\"2018-10-21\",\"shift\":3}]}',0,'{\"A51-nx\":[{\"mcname\":\"Slim3n-4AHS-1\",\"balhrs\":450},{\"mcname\":\"Slim3n-4AHS-2\",\"balhrs\":421},{\"mcname\":\"F5-3\",\"balhrs\":45}]}',0,'{\"A51-nx\":[{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"1\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"500:30\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"2\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"195:0\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"1\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"2\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79}]}',0,'10','2018','2018-09-14','0000-00-00','Karthick',NULL,'FSI'),(9,'i700-3','51-113, 51-112',700,4299,-3599,0,'{\"A51-nx\":[{\"date\":\"2018-10-14\",\"shift\":2},{\"date\":\"2018-10-21\",\"shift\":2},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-14\",\"shift\":3},{\"date\":\"2018-10-21\",\"shift\":3}]}',0,'{\"A51-nx\":[{\"mcname\":\"Slim3n-4AHS-1\",\"balhrs\":450},{\"mcname\":\"Slim3n-4AHS-2\",\"balhrs\":421},{\"mcname\":\"F5-3\",\"balhrs\":45}]}',0,'{\"A51-nx\":[{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"1\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"500:30\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"2\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"195:0\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"1\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"2\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79}]}',0,'10','2018','2018-09-14','0000-00-00','Karthick',NULL,'FSI'),(10,'Slim3n-4AHS-1','51-005, 51-001, 51-003, 51-006, 51-013, 51-014, 51-015',700,450,250,0,'{\"A51-nx\":[{\"date\":\"2018-10-14\",\"shift\":2},{\"date\":\"2018-10-21\",\"shift\":2},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-14\",\"shift\":3},{\"date\":\"2018-10-21\",\"shift\":3}]}',0,'{\"A51-nx\":[{\"mcname\":\"Slim3n-4AHS-1\",\"balhrs\":450},{\"mcname\":\"Slim3n-4AHS-2\",\"balhrs\":421},{\"mcname\":\"F5-3\",\"balhrs\":45}]}',0,'{\"A51-nx\":[{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"1\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"500:30\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"2\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"195:0\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"1\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"2\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79}]}',0,'10','2018','2018-09-14','0000-00-00','Karthick',NULL,'FSI'),(11,'Slim3n-4AHS-2','51-124, 51-125, 51-126',700,421,279,0,'{\"A51-nx\":[{\"date\":\"2018-10-14\",\"shift\":2},{\"date\":\"2018-10-21\",\"shift\":2},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-07\",\"shift\":3},{\"date\":\"2018-10-14\",\"shift\":3},{\"date\":\"2018-10-21\",\"shift\":3}]}',0,'{\"A51-nx\":[{\"mcname\":\"Slim3n-4AHS-1\",\"balhrs\":450},{\"mcname\":\"Slim3n-4AHS-2\",\"balhrs\":421},{\"mcname\":\"F5-3\",\"balhrs\":45}]}',0,'{\"A51-nx\":[{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"1\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"500:30\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-099\",\"operation\":\"2\",\"total_hrs\":\"500:30\",\"ffqty_hrs\":\"195:0\",\"runtime\":390,\"sch_qty\":77},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"1\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79},{\"mcname\":\"A51-nx\",\"prn\":\"51-100\",\"operation\":\"2\",\"total_hrs\":\"513:30\",\"ffqty_hrs\":\"0\",\"runtime\":390,\"sch_qty\":79}]}',0,'10','2018','2018-09-14','0000-00-00','Karthick',NULL,'FSI'),(13,'200MY-01','35-618, 35-415, 35-531A, 35-604',680,62,516,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(14,'A51nx-01','35-588',680,140,-140,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(15,'A51nx-02','35-409A, 35-453A, 35-454A, 35-584, 35-407',680,240,338,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(16,'a51nx-05','35-531A',680,97,-97,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(17,'A51nx-1','35-443C',680,10,670,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(18,'AC-01','35-597, 35-598',680,66,-66,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(19,'BFU','18-065D, 18-069C, 18-066D, 18-084A',680,85,-85,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(20,'BMV 45-2','18-293C, 18-685A',680,51,527,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(21,'BMV 60-1','18-029A, 18-230B, 18-034C, 18-056B, 18-061B, 18-062B, 18-064B, 18',680,249,329,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(22,'BMV 60-2','18-221B, 18-318A, 18-323A, 18-325A, 18-382B, 18-383B, 18-084A, 18',680,271,307,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(23,'DX 200-1','18-029A, 18-090A, 18-091A, 18-221B, 18-293C, 18-386B, 18-395A, 35',680,562,16,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(24,'DX 200-2','35-473B, 18-704A',680,44,534,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(25,'DX 200-3','18-685A',680,51,527,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(26,'DX200-1','51-089',680,15,563,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(27,'DX200-4','18-076A, 18-317B, 18-077A, 18-101A, 18-109A, 18-114A, 18-384B, 18',680,174,404,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(28,'EMAG-1','18-376B, 18-377B',680,545,-545,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(29,'HAAS VM6','18-158A, 18-163B, 18-164B, 18-405C, 51-115',680,94,484,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(30,'HAASVF2SS-1','35-446A, 35-441B, 35-442B, 35-443C, 35-480B, 35-481B',680,742,-164,212,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',48,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',164,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(31,'HAASVF2SS-3','35-484, 35-485, 35-590, 35-591, 35-428A, 35-509A, 35-510A, 35-560',680,393,-393,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(32,'HASS VR11','18-408A',680,8,570,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(33,'Heat TREATMENT','51-119',680,6480,-5902,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','2018-09-28','Karthick','Karthick','FSI'),(34,'HMC 440','18-298B, 18-297B',680,8,570,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(35,'I 700 -5','35-430',680,119,-119,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(36,'i700-04','35-584',680,53,627,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(37,'i700-1','51-095, 51-110',680,59,519,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(38,'i700-2','35-409A, 35-407',680,100,-100,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(39,'i700-3','51-118, 51-112, 51-119',680,82,496,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(40,'i700-4','35-453A, 35-454A',680,20,-20,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(41,'i700-5','35-597, 35-598',680,66,512,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(42,'JIG BORING','18-056B, 18-058A, 18-060B, 18-061B, 18-062B, 18-063B, 18-067B, 18',680,0,578,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(43,'LB-20','18-125B, 18-382B, 18-383B, 18-386B, 18-092A, 18-124B, 18-384B, 18',680,324,254,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(44,'LMW LX20T-1','18-376B, 18-377B',680,545,33,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(45,'Makino F5-1','35-618, 35-415',680,18,-18,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(46,'MAKINO SLIM-1','18-413B, 18-414B, 18-415B, 18-069C, 35-655, 35-656, 46-012A, 46-0',680,1094,-516,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(47,'MAKINO SLIM-2','18-318A, 18-319A, 18-396C, 18-657A, 35-604',680,56,522,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(48,'MakinoF5-1','18-642A, 18-646A, 46-008A, 46-009A, 46-020A, 46-021A',680,1014,-436,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(49,'MakinoF5-4','35-473B, 35-479A, 35-603A, 35-669, 35-670, 18-419A, 18-430A, 35-5',680,100,478,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(50,'MV -003','35-434, 35-412, 35-513, 35-514, 35-576, 35-587, 35-411, 35-435A',680,254,-254,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(51,'MV-002','35-649, 35-659, 35-625',680,54,-54,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(52,'QT100S-1','18-090A, 18-091A, 35-473B, 18-221B, 18-317B, 18-382B, 18-383B, 18',680,501,77,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(53,'QT100S-2','35-479A',680,5,675,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(54,'QT100S-3','18-030A, 35-479A, 35-602A, 35-603A, 18-371B, 18-380B, 18-444B, 35',680,581,-3,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(55,'QT100S-4','35-668, 18-378B, 18-380B, 18-379B, 18-446B',680,120,458,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(56,'QT100S-5','18-378B, 18-444B, 18-379B, 18-381B, 18-446B',680,140,438,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(57,'Slim3n-4AHS-1','51-129, 51-016',680,17,561,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(58,'Slim3n-4AHS-2','51-124, 51-125, 51-126, 51-005, 51-015',680,172,406,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(59,'Slim3n-4AHS-3','46-014A, 46-015A, 46-016A, 46-017A',680,352,226,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(60,'ST20','18-031A, 18-413B, 18-414B, 18-415B, 35-618, 35-446A, 18-076A, 35-',680,478,100,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(61,'ST20Y1','18-295A',680,125,555,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(62,'UNISIGN5000-1','51-115',680,13,667,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(63,'VF2SS-1','51-087',680,66,512,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(64,'VM2-3','18-413B, 35-473B, 18-058A, 18-060B, 18-098B, 18-194A, 18-196A, 18',680,478,100,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(65,'VMC 70L','18-408A',680,1,679,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI'),(66,'VMC70L','51-087, 51-115',680,7,571,0,'{\"HAASVF2SS-1\":[{\"date\":\"2018-09-23\",\"shift\":1},{\"date\":\"2018-09-23\",\"shift\":2},{\"date\":\"2018-09-23\",\"shift\":3},{\"date\":\"2018-09-30\",\"shift\":1},{\"date\":\"2018-09-30\",\"shift\":2},{\"date\":\"2018-09-30\",\"shift\":3}]}',0,'{\"HAASVF2SS-1\":[{\"mcname\":\"200MY-01\",\"balhrs\":164}]}',0,'{}',0,'9','2018','2018-09-28','0000-00-00','Karthick',NULL,'FSI');

--
-- Table structure for table `resource_requirement`
--

CREATE TABLE `resource_requirement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customercompanyid` varchar(10) NOT NULL,
  `date` date NOT NULL,
  `shift` varchar(50) NOT NULL,
  `requirement` int(11) NOT NULL,
  `upload_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_requirement`
--

INSERT INTO `resource_requirement` VALUES (1,'A127','2017-11-21','day',1,'2017-11-21'),(2,'A127','2017-11-21','day night',1,'2017-11-21'),(3,'A127','2017-11-21','night',1,'2017-11-21'),(4,'A127','2017-11-22','day',1,'2017-11-21'),(5,'A127','2017-11-22','day night',1,'2017-11-21'),(6,'A127','2017-11-22','night',1,'2017-11-21'),(7,'A127','2017-11-23','day',1,'2017-11-21'),(8,'A127','2017-11-23','day night',1,'2017-11-21'),(9,'A127','2017-11-23','night',1,'2017-11-21');

--
-- Table structure for table `resource_schdule`
--

CREATE TABLE `resource_schdule` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `parent_company` varchar(20) DEFAULT NULL,
  `subsidary` varchar(20) DEFAULT NULL,
  `empid` varchar(50) DEFAULT NULL,
  `link2user` int(11) DEFAULT NULL,
  `shift` varchar(20) DEFAULT NULL,
  `shiftdate` date DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(20) DEFAULT NULL,
  `link2resourceupload` int(11) DEFAULT NULL,
  `insert_type` varchar(50) DEFAULT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_schdule`
--

INSERT INTO `resource_schdule` VALUES (1,'FSI','A127','E249',NULL,'day','2017-11-21','2017-11-21','sa',1,'Import'),(2,'FSI','A127','E249',NULL,'day','2017-11-22','2017-11-21','bmandyam',0,'manual'),(3,'FSI','A127','E250',NULL,'day night','2017-11-21','2017-11-21','bmandyam',0,'manual'),(4,'FSI','A127','E251',NULL,'night','2017-11-21','2017-11-21','bmandyam',0,'manual');

--
-- Table structure for table `resource_upload`
--

CREATE TABLE `resource_upload` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `upload_name` varchar(50) DEFAULT NULL,
  `upload_size` varchar(50) DEFAULT NULL,
  `upload_by` varchar(50) DEFAULT NULL,
  `upload_date` date DEFAULT NULL,
  `link2user` int(11) DEFAULT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_upload`
--

INSERT INTO `resource_upload` VALUES (1,'Import_2017-11-21 08:24:37','','sa','2017-11-21',1);

--
-- Table structure for table `review_line_items`
--

CREATE TABLE `review_line_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `line_num` varchar(20) DEFAULT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `partnum` varchar(100) DEFAULT NULL,
  `rmtype` varchar(50) DEFAULT NULL,
  `rmspec` varchar(50) DEFAULT NULL,
  `partiss` varchar(50) DEFAULT NULL,
  `drgiss` varchar(50) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `link2review` int(11) DEFAULT NULL,
  `hcdrgiss` varchar(50) DEFAULT NULL,
  `hcpartiss` varchar(50) DEFAULT NULL,
  `po_cos` varchar(50) DEFAULT NULL,
  `hc_cos` varchar(50) DEFAULT NULL,
  `cos_iss` varchar(50) DEFAULT NULL,
  `uom` varchar(10) DEFAULT NULL,
  `dia` decimal(8,2) DEFAULT NULL,
  `length` decimal(8,2) DEFAULT NULL,
  `width` decimal(8,2) DEFAULT NULL,
  `thickness` decimal(8,2) DEFAULT NULL,
  `grainflow` varchar(50) DEFAULT NULL,
  `maxruling` varchar(50) DEFAULT NULL,
  `altspec` varchar(50) DEFAULT NULL,
  `model_iss` varchar(50) DEFAULT NULL,
  `crn_num` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `review_line_items`
--


--
-- Table structure for table `review_notes`
--

CREATE TABLE `review_notes` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `stamp_created` datetime DEFAULT NULL,
  `stamp_updated` datetime DEFAULT NULL,
  `notes` longtext,
  `notes2review` int(11) DEFAULT NULL,
  `notes2user` varchar(50) DEFAULT NULL,
  `dept` char(20) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `review_notes`
--


--
-- Table structure for table `rfq`
--

CREATE TABLE `rfq` (
  `recnum` int(11) DEFAULT NULL,
  `rfqid` varchar(50) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `last_modified_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rfq`
--


--
-- Table structure for table `riskassesment`
--

CREATE TABLE `riskassesment` (
  `riskassnum` varchar(100) NOT NULL,
  `riskdate` date NOT NULL,
  `dept` varchar(100) NOT NULL,
  `customer` varchar(100) NOT NULL,
  `enquiry` varchar(100) NOT NULL,
  `rfqnum` varchar(100) NOT NULL,
  `status` varchar(100) DEFAULT NULL,
  `pur_approval` varchar(30) DEFAULT NULL,
  `pur_approved_by` varchar(100) DEFAULT NULL,
  `pur_app_date` date DEFAULT NULL,
  `bd_approval` varchar(30) DEFAULT NULL,
  `bd_approved_by` varchar(100) DEFAULT NULL,
  `bd_app_date` date DEFAULT NULL,
  `engg_approval` varchar(30) DEFAULT NULL,
  `engg_approved_by` varchar(100) DEFAULT NULL,
  `engg_app_date` date DEFAULT NULL,
  `prodn_approval` varchar(30) DEFAULT NULL,
  `prodn_approved_by` varchar(100) DEFAULT NULL,
  `prodn_app_date` date DEFAULT NULL,
  `qad_approval` varchar(30) DEFAULT NULL,
  `qad_approved_by` varchar(100) DEFAULT NULL,
  `qad_app_date` date DEFAULT NULL,
  `link2customer` int(11) DEFAULT NULL,
  `rflag` int(11) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `format` varchar(100) DEFAULT NULL,
  `revnum` varchar(100) DEFAULT NULL,
  `revdate` varchar(100) DEFAULT NULL,
  `recnum` int(8) NOT NULL,
  `siteid` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `riskassesment`
--


--
-- Table structure for table `riskassesmentli`
--

CREATE TABLE `riskassesmentli` (
  `area` varchar(255) NOT NULL,
  `rat_seviority` int(11) NOT NULL,
  `rat_occurance` int(11) NOT NULL,
  `rat_rpn` int(11) NOT NULL,
  `rat_mitigating` varchar(255) DEFAULT NULL,
  `res_seviority` int(11) NOT NULL,
  `res_occurance` int(11) NOT NULL,
  `res_rpn` int(11) NOT NULL,
  `link2ra` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `recnum` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `riskassesmentli`
--


--
-- Table structure for table `rma_items`
--

CREATE TABLE `rma_items` (
  `recnum` int(11) DEFAULT NULL,
  `partnum` varchar(50) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `link2rma` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rma_items`
--


--
-- Table structure for table `rmm_notes`
--

CREATE TABLE `rmm_notes` (
  `recnum` int(11) DEFAULT NULL,
  `notes` text,
  `create_date` date DEFAULT NULL,
  `notes2rmm` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rmm_notes`
--

INSERT INTO `rmm_notes` VALUES (1,'rshgdhxdh','2016-05-06',3011),(1,'wa','2016-05-10',3011),(1,'dsf','2016-05-17',3015),(1,'testimg','2016-07-04',3014),(1,'testing','2016-07-04',3014),(1,'testing','2016-07-05',3018),(1,'test','2016-07-28',3014),(1,'test','2016-08-23',3019),(1,'test','2016-08-23',3019),(1,'test','2016-08-23',3019),(1,'test','2016-08-23',3019),(1,'test','2016-08-23',3019),(1,'test','2016-08-23',3020),(1,'test','2016-09-30',3021),(1,'test','2016-09-30',3021),(1,'test','2016-09-30',3021),(1,'test','2016-09-30',3023),(1,'test','2016-09-30',3023),(1,'test','2016-10-06',3024),(1,'test','2016-10-12',3025),(1,'test','2016-10-12',3025),(1,'test','2016-10-18',3026),(1,'test','2016-10-18',3026),(1,'test','2016-10-18',3026),(1,'dfadf','2017-08-08',3027),(1,'test','2017-11-24',3029),(1,'test','2017-11-24',3030),(1,'test','2017-11-24',3031),(1,'test','2017-11-24',3028),(1,'notes added','2017-12-05',3032),(1,'TEST','2019-06-12',3033),(1,'test','2019-06-13',3034),(1,'test','2019-06-13',3035),(1,'test','2019-06-13',3036),(1,'testing','2019-06-13',3037),(1,'test','2019-06-13',3037),(1,'tets','2019-06-14',3038),(1,'test','2019-06-14',3038),(1,'test','2019-06-19',3039),(1,'test','2019-06-20',3040),(1,'test','2019-06-25',3041),(1,'terst','2019-06-25',3041),(1,'test','2019-06-26',3041),(1,'test','2019-06-27',3042),(1,'test','2019-07-02',3043),(1,'test','2019-07-11',3044),(1,'test','2019-07-12',3045),(1,'test','2019-07-15',3046),(1,'notes1','2019-07-25',3047),(1,'RM notes','2019-07-25',3048),(1,'tedt','2019-08-02',3049),(1,'notes','2019-08-05',3050),(1,'status active','2019-08-06',2),(1,'Notes for Approval and make status active','2019-08-07',3),(1,'test','2019-08-10',4);

--
-- Table structure for table `rmmaster`
--

CREATE TABLE `rmmaster` (
  `recnum` int(11) DEFAULT NULL,
  `crnnum` varchar(45) DEFAULT NULL,
  `rmcode` varchar(50) DEFAULT NULL,
  `rm_type` varchar(255) DEFAULT NULL,
  `rm_spec` varchar(255) DEFAULT NULL,
  `rm_ruling_dim` varchar(255) DEFAULT NULL,
  `rm_dia` varchar(255) DEFAULT NULL,
  `length` varchar(255) DEFAULT NULL,
  `width` varchar(255) DEFAULT NULL,
  `thickness` varchar(255) DEFAULT NULL,
  `partnum` varchar(60) DEFAULT NULL,
  `rm_condition` text,
  `rm_uom` varchar(50) DEFAULT NULL,
  `rm_grainflow` varchar(50) DEFAULT NULL,
  `rm_lt` varchar(50) DEFAULT NULL,
  `rm_st` varchar(50) DEFAULT NULL,
  `rm_qty_perbill` varchar(50) DEFAULT NULL,
  `rm_mrs` varchar(50) DEFAULT NULL,
  `rm_unitprize` varchar(50) DEFAULT NULL,
  `rm_supplier` varchar(50) DEFAULT NULL,
  `rm_altrm` varchar(50) DEFAULT NULL,
  `link2vendor` int(11) DEFAULT NULL,
  `rm_status` varchar(50) DEFAULT NULL,
  `createdate` date DEFAULT NULL,
  `modifieddate` date DEFAULT NULL,
  `rm_remarks` text,
  `enggapproved` varchar(45) DEFAULT NULL,
  `directorsapproved` varchar(45) DEFAULT NULL,
  `directorsapprovedby` varchar(45) DEFAULT NULL,
  `engapprovedby` varchar(45) DEFAULT NULL,
  `eng_app_date` date DEFAULT NULL,
  `director_app_date` date DEFAULT NULL,
  `currency` char(4) DEFAULT NULL,
  `rm_bars_plates` varchar(20) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `rm_wt_kg` float DEFAULT NULL,
  `rm_unit_scrap_wt` float DEFAULT NULL,
  `unit_wt_finished` float DEFAULT NULL,
  KEY `rmm_crnnum` (`crnnum`),
  KEY `rmm_status` (`rm_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rmmaster`
--


--
-- Table structure for table `rmmfrmaster`
--

CREATE TABLE `rmmfrmaster` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `mtl_type` varchar(100) NOT NULL,
  `airbus_spec` varchar(100) NOT NULL,
  `mfr_code` int(100) DEFAULT NULL,
  `mfr_name` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `country_code` varchar(100) NOT NULL,
  `created_date` varchar(100) DEFAULT NULL,
  `modified_date` varchar(100) DEFAULT NULL,
  `from_date` varchar(100) DEFAULT NULL,
  `to_date` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rmmfrmaster`
--


--
-- Table structure for table `sales_leads`
--

CREATE TABLE `sales_leads` (
  `recnum` int(11) DEFAULT NULL,
  `source` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `title` varchar(5) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `product_interest` varchar(255) DEFAULT NULL,
  `primary_lead` varchar(4) DEFAULT NULL,
  `rating` varchar(255) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `industry_segment` varchar(255) DEFAULT NULL,
  `addr1` varchar(50) DEFAULT NULL,
  `addr2` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `convert2contact` int(11) DEFAULT NULL,
  `leadsnum` varchar(100) DEFAULT NULL,
  `oppnum` varchar(100) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `stage` varchar(55) DEFAULT NULL,
  `percent` int(11) DEFAULT NULL,
  `stage_num` int(11) DEFAULT NULL,
  `contacted_date` date DEFAULT NULL,
  `meeting_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales_leads`
--

INSERT INTO `sales_leads` VALUES (50,'www','ashwini','ashum','436546','ashu.pinky24@fluensoft.com','23','',NULL,'',NULL,'FSI','ds','','','bang','karnataka','','USA',0,'','',NULL,'Convert to Opportunity',10,90,'0000-00-00','0000-00-00'),(51,'www','ashwini','ashum','3434','asha@fluentsoft.com','0','',NULL,'',NULL,'FSI','ds','','','bang','karnataka','','59999',0,'','',NULL,'Convert to Opportunity',0,90,'0000-00-00','0000-00-00'),(52,'','ashwini','dfdsf','436546757','ashu.pinky24@fluentsoft.com','','',NULL,'',NULL,'FSI','fgf','','','','','','',0,'','','FSI','Convert to Opportunity',0,90,'0000-00-00','0000-00-00'),(53,'','dfdg','fg','565767','','','',NULL,'',NULL,'fgfh','54656','','','','','','',0,'','','FSI','Convert to Opportunity',0,90,'2017-07-18','0000-00-00'),(61,'Self Generated','ERP','asds','dfrd','ashu.pinky24@fluentsoft.com','ERP','Yes',NULL,'','2017-07-27','FSI','dfd','dfd','df','dfd','dfd','df','fdf',0,'','',NULL,'Convert to Opportunity',10,90,'0000-00-00','0000-00-00');

--
-- Table structure for table `sales_opportunity`
--

CREATE TABLE `sales_opportunity` (
  `recnum` int(11) DEFAULT NULL,
  `opp_name` varchar(100) DEFAULT NULL,
  `acc_name` varchar(50) DEFAULT NULL,
  `expected_close_date` date DEFAULT NULL,
  `sales_stage` varchar(20) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `link2lead` int(11) DEFAULT NULL,
  `amount_currency` float DEFAULT NULL,
  `assigned_to` varchar(30) DEFAULT NULL,
  `probability` varchar(20) DEFAULT NULL,
  `next_step` varchar(20) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `lead_source` varchar(30) DEFAULT NULL,
  `link2salesnotes` varchar(50) DEFAULT NULL,
  `currency` varchar(250) DEFAULT NULL,
  `leadsnum` varchar(100) DEFAULT NULL,
  `oppnum` varchar(100) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `opp_stagenum` int(11) DEFAULT NULL,
  `proposal_date` date DEFAULT NULL,
  `negotiate_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales_opportunity`
--

INSERT INTO `sales_opportunity` VALUES (3,'aero','hdbj','2016-05-24','','',0,300,'','21','','2016-05-24','','dsg','$','34','23','FSI',NULL,NULL,NULL),(4,'ddd','sss','2016-08-08','Prospecting','Existing Business',0,100,'','10','','2016-08-02','','','$','123','124',NULL,NULL,NULL,NULL),(5,'ssss','hjdgjh','2016-08-25','Prospecting','Existing Business',0,1000,'','1232','','2016-08-23','','','$','1321','121',NULL,NULL,NULL,NULL),(6,'test123','fgfh','2017-07-20','Proposal/Quote','Existing Business',53,100,'test','200','test','2017-07-21','','test testui iucjcbd','$','dfdg','',NULL,140,'2017-07-21','0000-00-00'),(7,'Opp1','FSI','2017-07-27','','Existing Business',52,100,'','100','','2017-07-27','Cold Call','','$','ashwini','',NULL,0,'0000-00-00','0000-00-00'),(8,'Opp2','FSI','2017-07-27','','Existing Business',51,100,'','100','','2017-07-27','Cold Call','','$','ashwini','',NULL,0,'0000-00-00','0000-00-00'),(9,'Opp3','FSI','2017-07-27','Needs Analysis','Existing Business',61,100,'','100','','2017-07-27','Self Generated','','$','ERP','',NULL,110,'0000-00-00','0000-00-00');

--
-- Table structure for table `sales_order`
--

CREATE TABLE `sales_order` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `so2customer` int(11) DEFAULT NULL,
  `so2contact` int(11) DEFAULT NULL,
  `so2employee` int(11) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `sales_order` varchar(20) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `special_instruction` longtext,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zipcode` varchar(30) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `quote_num` varchar(30) DEFAULT NULL,
  `po_num` varchar(255) DEFAULT NULL,
  `grosstotal` float DEFAULT NULL,
  `tax` float DEFAULT NULL,
  `shipping` float DEFAULT NULL,
  `labor` float DEFAULT NULL,
  `total_due` float DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `currency` varchar(20) DEFAULT NULL,
  `resellnum` varchar(50) DEFAULT NULL,
  `quote_date` date DEFAULT NULL,
  `attach1` varchar(100) DEFAULT NULL,
  `attach2` varchar(100) DEFAULT NULL,
  `contact` varchar(100) DEFAULT NULL,
  `link2review` int(11) DEFAULT NULL,
  `rmtotal` float DEFAULT NULL,
  `mctotal` float DEFAULT NULL,
  `amendment_num` varchar(50) DEFAULT NULL,
  `formatnum` varchar(255) DEFAULT NULL,
  `formatrev` varchar(255) DEFAULT NULL,
  `amendment_date` date DEFAULT NULL,
  `amendments` text,
  `refno` varchar(30) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `ordernum` varchar(30) DEFAULT NULL,
  `ordertype` varchar(255) DEFAULT NULL,
  `numofparts` varchar(255) DEFAULT NULL,
  `attachment1` varchar(255) DEFAULT NULL,
  `quoterefnum` varchar(50) DEFAULT NULL,
  `rawmaterial` varchar(255) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `class` varchar(255) DEFAULT NULL,
  `resources` varchar(255) DEFAULT NULL,
  `qualityreq` varchar(255) DEFAULT NULL,
  `saliant` varchar(255) DEFAULT NULL,
  `aditional_resources` varchar(255) DEFAULT NULL,
  `investment` varchar(255) DEFAULT NULL,
  `subcontract` varchar(255) DEFAULT NULL,
  `special_process` varchar(255) DEFAULT NULL,
  `delivery_req` varchar(255) DEFAULT NULL,
  `person` varchar(50) DEFAULT NULL,
  `enq_answeredby` varchar(50) DEFAULT NULL,
  `quotation` varchar(100) DEFAULT NULL,
  `data_for_quote` varchar(255) DEFAULT NULL,
  `data_store` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `quotation_det_store` varchar(255) DEFAULT NULL,
  `risk_factors` varchar(255) DEFAULT NULL,
  `requirements` varchar(255) DEFAULT NULL,
  `quote_sentby` varchar(255) DEFAULT NULL,
  `explain_risk_factors` varchar(255) DEFAULT NULL,
  `quote_path` varchar(255) DEFAULT NULL,
  `enquiry_path` varchar(255) DEFAULT NULL,
  `data_for_enquiry` varchar(255) DEFAULT NULL,
  `orderfor` varchar(255) DEFAULT NULL,
  `formrev` varchar(50) DEFAULT NULL,
  `special_instrns` longtext,
  `val_status` varchar(50) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `qa_approved` varchar(45) DEFAULT NULL,
  `engineering_approved` varchar(45) DEFAULT NULL,
  `qa_app_by` varchar(100) DEFAULT NULL,
  `engg_app_by` varchar(100) DEFAULT NULL,
  `prodn_approved` varchar(45) DEFAULT NULL,
  `prodn_app_by` varchar(100) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `link2risk` int(8) NOT NULL,
  PRIMARY KEY (`recnum`),
  KEY `wpo` (`po_num`),
  KEY `ind_so2cust` (`so2customer`),
  KEY `ind_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales_order`
--


--
-- Table structure for table `seqnum`
--

CREATE TABLE `seqnum` (
  `nxtnum` int(11) DEFAULT NULL,
  `tablename` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `seqnum`
--

INSERT INTO `seqnum` VALUES (1,'shipment'),(1,'activeusers_log'),(1,'address'),(1,'app_license'),(1,'bookmark'),(5,'company'),(5,'contact'),(43,'dates'),(1,'eco'),(1,'employee'),(1,'inventory'),(1,'log'),(1,'mfg_order'),(1,'mtm_po_wo'),(1,'notes'),(1,'part_master'),(1,'part_used'),(4,'po'),(6,'po_line_items'),(6,'quote'),(7,'quote_li'),(1,'rfq'),(1,'rma'),(1,'rma_items'),(1,'seqnum'),(1,'serv_req'),(1,'solution'),(1,'srtype'),(1,'support'),(1,'support_notes'),(1,'tran_license'),(1,'user'),(1,'vend_part_master'),(1,'work_flow_config'),(7,'work_order'),(1,'m_pagename'),(1,'m_pagefields'),(1,'generic_wo'),(1,'generic_quote'),(1,'sales_leads'),(1,'sales_opportunity'),(5,'sales_order'),(5,'so_line_items'),(1,'account'),(1,'leads_notes'),(1,'opportunity_notes'),(1,'mtm_leads_opportunity'),(1,'mfg_order'),(1,'shipment'),(4,'invoice'),(1,'invoice_payment'),(1,'email'),(1,'tasklist'),(1,'tasklist_time'),(1,'wo_attachment'),(1,'task_notes'),(1,'milestone_notes'),(1,'dwf_stage_field'),(1,'master'),(1,'master_line_items'),(1,'datasheet'),(1,'datasheet_line_items'),(1,'quality_plan'),(1,'quality_plan_line_items'),(1,'cust_data_validation'),(1,'cust_data_lineitems'),(1,'mm'),(1,'contract_enquiry'),(1,'contract_review'),(1,'proc_deviation'),(1,'proc_deviation_li'),(1,'feedback'),(1,'test_report'),(1,'chemical_composition_li'),(1,'mechanical_properties_li'),(1,'fid'),(1,'irm'),(1,'stage_insp'),(1,'stage_insp_report'),(1,'stage_insp_lineitems'),(8,'final_insp_report'),(8,'final_insp_lineitems'),(4,'master_data'),(1,'dd'),(1,'nc4qa'),(1,'standard'),(1,'allot_crn'),(10,'grn'),(1,'mdm'),(1,'ncforstores'),(1,'production_sch'),(1,'maintain_machine'),(1,'process_details'),(1,'partwise_req'),(1,'production_plan'),(1,'mtl_tracker_li'),(1,'mtl_act_log'),(1,'part_bom'),(1,'capacity_plan'),(10,'grn_li'),(4,'rmmaster'),(7,'wonum'),(4,'dispatch'),(4,'dispatch_line_items'),(1,'accp_rating'),(1,'purchasing_alloc'),(1,'advlic'),(1,'advlic_li'),(6,'mps'),(1,'assypo'),(1,'assypo_line_items'),(2,'delivery_note'),(2,'delivery_note_li'),(1,'bom'),(1,'bom_mfg_items'),(1,'bom_bought_items'),(1,'bom_consume'),(1,'assy_review'),(1,'assy_review_li'),(1,'assywo'),(1,'bom_op_desc'),(1,'spmaster'),(1,'bom_subassy_items'),(11,'consumption'),(1,'task'),(1,'news'),(1,'bom_treated_items'),(1,'arform'),(3,'Price'),(4,'invoice'),(1,'shipping'),(1,'shipping_line_items'),(1,'arform'),(1,'arform_line_items'),(7,'grn_issue'),(1,'site'),(1,'payroll_master'),(1,'payroll_monthly'),(1,'tasks'),(1,'assywo_flow'),(5,'enquiry'),(1,'cust_feedback'),(1,'post_contract'),(1,'dc4supp'),(1,'dc4cust'),(1,'dc4supp'),(1,'dc4cust'),(1,'quality_plan'),(1,'control_plan'),(1,'dc4cust'),(4,'invoice_line_items'),(7,'master_process_sheet_li'),(4,'dc'),(4,'dc'),(4,'dc'),(8,'supplier_enquiry_li'),(5,'enquiry_li'),(1,'credite_note'),(1,'debit_note'),(61,'riskassesmentli'),(3,'riskassesment'),(2,'eqpo'),(7,'supplier_enquiry'),(6,'supplier_quote'),(10,'stockxfer');

--
-- Table structure for table `serv_req`
--

CREATE TABLE `serv_req` (
  `recnum` int(11) DEFAULT NULL,
  `srnum` varchar(100) DEFAULT NULL,
  `drawing_rev` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `reportedby` varchar(100) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `priority` varchar(100) DEFAULT NULL,
  `error_desc` longtext,
  `docdate` date DEFAULT NULL,
  `received_date` date DEFAULT NULL,
  `duedate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `serv_req`
--


--
-- Table structure for table `shipment`
--

CREATE TABLE `shipment` (
  `recnum` int(11) DEFAULT NULL,
  `seqnum` varchar(50) DEFAULT NULL,
  `ship_desc` varchar(255) DEFAULT NULL,
  `carrier` varchar(255) DEFAULT NULL,
  `tracking_num` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `final` char(1) DEFAULT NULL,
  `link2wo` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shipment`
--


--
-- Table structure for table `shipping`
--

CREATE TABLE `shipping` (
  `recnum` int(10) unsigned DEFAULT NULL,
  `link2invoice` int(10) unsigned DEFAULT NULL,
  `sbnum` varchar(45) DEFAULT NULL,
  `sbdate` date DEFAULT NULL,
  `impexpcode` varchar(45) DEFAULT NULL,
  `rbicode` varchar(45) DEFAULT NULL,
  `qcertnum` varchar(45) DEFAULT NULL,
  `qcertdate` date DEFAULT NULL,
  `rotatingnum` varchar(45) DEFAULT NULL,
  `dischargeport` varchar(100) DEFAULT NULL,
  `countrydestination` varchar(100) DEFAULT NULL,
  `cf` varchar(5) DEFAULT NULL,
  `cfr` varchar(5) DEFAULT NULL,
  `fob` varchar(5) DEFAULT NULL,
  `contractother` varchar(45) DEFAULT NULL,
  `exchangerate` float DEFAULT NULL,
  `netweight` varchar(45) DEFAULT NULL,
  `grossweight` varchar(45) DEFAULT NULL,
  `fobwords` varchar(255) DEFAULT NULL,
  `fob_value` varchar(45) DEFAULT NULL,
  `fob_currency` varchar(45) DEFAULT NULL,
  `fob_inr` varchar(45) DEFAULT NULL,
  `freight_value` varchar(45) DEFAULT NULL,
  `freight_currency` varchar(45) DEFAULT NULL,
  `freight_inr` varchar(45) DEFAULT NULL,
  `insurance_value` varchar(45) DEFAULT NULL,
  `insurance_currency` varchar(45) DEFAULT NULL,
  `insurance_inr` varchar(45) DEFAULT NULL,
  `commission_value` varchar(45) DEFAULT NULL,
  `commission_currency` varchar(45) DEFAULT NULL,
  `commission_inr` varchar(45) DEFAULT NULL,
  `discount_value` varchar(45) DEFAULT NULL,
  `discount_currency` varchar(45) DEFAULT NULL,
  `discount_inr` varchar(45) DEFAULT NULL,
  `other_value` varchar(45) DEFAULT NULL,
  `other_currency` varchar(45) DEFAULT NULL,
  `other_inr` varchar(45) DEFAULT NULL,
  `deduction_value` varchar(45) DEFAULT NULL,
  `deduction_currency` varchar(45) DEFAULT NULL,
  `deduction_inr` varchar(45) DEFAULT NULL,
  `custom_agent` varchar(45) DEFAULT NULL,
  `shipping_id` varchar(45) DEFAULT NULL,
  `createdate` date DEFAULT NULL,
  `licnum` varchar(45) DEFAULT NULL,
  `formrev` varchar(255) DEFAULT NULL,
  `deffcredit` varchar(45) DEFAULT NULL,
  `jointventure` varchar(5) DEFAULT NULL,
  `rupcredit` varchar(5) DEFAULT NULL,
  `otherex` varchar(5) DEFAULT NULL,
  `rbiappcode` varchar(45) DEFAULT NULL,
  `rbiappdate` date DEFAULT NULL,
  `outrightsale` varchar(5) DEFAULT NULL,
  `consignmentexp` varchar(5) DEFAULT NULL,
  `othersh` varchar(5) DEFAULT NULL,
  `ar4anum` varchar(45) DEFAULT NULL,
  `ar4adate` date DEFAULT NULL,
  `total_qty` float DEFAULT NULL,
  `vfobtotal` float DEFAULT NULL,
  `siteid` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shipping`
--

INSERT INTO `shipping` VALUES (1,1,'S-5659/16-17','2016-11-16','0797004271','','','0000-00-00','',NULL,NULL,'no','no','no','',100,'','','','100','$','10000','','','','','','','','','','','','','','','','','','','JEENA&Co AAAFJ1721HCH054','S-5659/16-17','2016-11-02','','F7000 Rev 00 dt August 04, 2011','','no','no','no','','0000-00-00','no','no','no','','2016-11-16',1,100,NULL),(6,2,'S-5654/16-17','2016-11-17','0797004271','','','0000-00-00','',NULL,NULL,'no','no','no','',200,'','','','0','$','0','','','','','','','','','','','','','','','','','','','JEENA&Co AAAFJ1721HCH054','S-5654/16-17','2016-11-02','','F7000 Rev 00 dt August 04, 2011','','no','no','no','','0000-00-00','no','no','no','','2016-11-24',1,0,NULL);

--
-- Table structure for table `shipping_line_items`
--

CREATE TABLE `shipping_line_items` (
  `recnum` int(10) unsigned DEFAULT NULL,
  `line_num` int(10) unsigned DEFAULT NULL,
  `marknum` varchar(255) DEFAULT NULL,
  `statcode` varchar(255) DEFAULT NULL,
  `qty` int(10) unsigned DEFAULT NULL,
  `value_fob` float DEFAULT NULL,
  `link2shipping` int(10) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shipping_line_items`
--

INSERT INTO `shipping_line_items` VALUES (2,1,'  ',' 3543 dfdf ',1,0,5),(3,1,'  ',' 3543 dfdf ',1,0,6);

--
-- Table structure for table `site`
--

CREATE TABLE `site` (
  `recnum` int(11) DEFAULT NULL,
  `siteid` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `fax` varchar(100) DEFAULT NULL,
  `tsymbol` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `employees` varchar(100) DEFAULT NULL,
  `rating` varchar(10) DEFAULT NULL,
  `ownership` varchar(100) DEFAULT NULL,
  `annual_revenue` int(11) DEFAULT NULL,
  `industry` varchar(100) DEFAULT NULL,
  `stccode` varchar(100) DEFAULT NULL,
  `addr1` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zipcode` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `site2parent_site` int(11) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `last_modified_date` date DEFAULT NULL,
  `guid` varchar(20) DEFAULT NULL,
  `alt_recnum` int(11) DEFAULT NULL,
  `remarks` text,
  `terms` varchar(255) DEFAULT NULL,
  `category` varchar(45) DEFAULT NULL,
  `how_created` varchar(50) DEFAULT NULL,
  `id` varchar(45) DEFAULT NULL,
  KEY `ind_recnum` (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `site`
--

INSERT INTO `site` VALUES (14,'flu_1779','FSI','EMPL','8050200958','','','','ashwinic@fluentsoft.com','','','',0,'','','','','','','',NULL,'Active','2017-05-02',NULL,NULL,NULL,NULL,NULL,NULL,'Online Registration','A14'),(15,'gma_1721','Aero','EMPL','20333333','','','','raj@gmail.com','','','',0,'','','','','','','',NULL,'Active','2017-05-02',NULL,NULL,NULL,NULL,NULL,NULL,'Online Registration','A15'),(1,'FSI','FSI','EMPL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'_5743','FSI','EMPL','8050200804','','','','ammu','','','',0,'','','','','','','',NULL,'Active','2017-05-05',NULL,NULL,NULL,NULL,NULL,NULL,'Online Registration','A2');

--
-- Table structure for table `so_line_items`
--

CREATE TABLE `so_line_items` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `line_num` varchar(20) DEFAULT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `partnum` varchar(100) DEFAULT NULL,
  `rmtype` varchar(255) DEFAULT NULL,
  `rmspec` varchar(255) DEFAULT NULL,
  `partiss` varchar(255) DEFAULT NULL,
  `drgiss` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `link2so` int(11) DEFAULT NULL,
  `rmprice` float DEFAULT NULL,
  `rmamount` float DEFAULT NULL,
  `mcprice` float DEFAULT NULL,
  `mcamount` float DEFAULT NULL,
  `hcdrgiss` varchar(255) DEFAULT NULL,
  `hcpartiss` varchar(255) DEFAULT NULL,
  `po_cos` varchar(255) DEFAULT NULL,
  `hc_cos` varchar(255) DEFAULT NULL,
  `model_iss` varchar(255) DEFAULT NULL,
  `amendment_num` varchar(255) DEFAULT NULL,
  `amendment_date` date DEFAULT NULL,
  `uom` varchar(10) DEFAULT NULL,
  `dia` varchar(50) DEFAULT NULL,
  `length` varchar(50) DEFAULT NULL,
  `width` varchar(50) DEFAULT NULL,
  `thickness` varchar(50) DEFAULT NULL,
  `grainflow` varchar(50) DEFAULT NULL,
  `maxruling` varchar(50) DEFAULT NULL,
  `altspec` varchar(50) DEFAULT NULL,
  `cos_iss` varchar(50) DEFAULT NULL,
  `crn_num` varchar(45) DEFAULT NULL,
  `condition` text,
  `po_num` varchar(50) DEFAULT NULL,
  `dim1` varchar(255) DEFAULT NULL,
  `dim2` varchar(255) DEFAULT NULL,
  `dim3` varchar(255) DEFAULT NULL,
  `siteid` varchar(255) DEFAULT NULL,
  `blnc_poqty` int(8) NOT NULL,
  `quote_num` varchar(64) NOT NULL,
  PRIMARY KEY (`recnum`),
  KEY `ind_soli_partnum` (`partnum`),
  KEY `ind_link2so` (`link2so`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `so_line_items`
--


--
-- Table structure for table `so_notes`
--

CREATE TABLE `so_notes` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `stamp_created` datetime DEFAULT NULL,
  `stamp_updated` datetime DEFAULT NULL,
  `notes` longtext,
  `notes2so` int(11) DEFAULT NULL,
  `notes2user` varchar(50) DEFAULT NULL,
  `dept` char(20) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `so_notes`
--


--
-- Table structure for table `so_plan`
--

CREATE TABLE `so_plan` (
  `recnum` int(8) NOT NULL AUTO_INCREMENT,
  `link2vend` varchar(128) DEFAULT NULL,
  `link2cust` varchar(128) DEFAULT NULL,
  `partnum` varchar(128) DEFAULT NULL,
  `rfqid` varchar(128) DEFAULT NULL,
  `rfq_date` date DEFAULT NULL,
  `quoteid` varchar(128) DEFAULT NULL,
  `quote_rate` decimal(15,2) DEFAULT NULL,
  `ponum` varchar(128) DEFAULT NULL,
  `po_rate` decimal(15,2) DEFAULT NULL,
  `po_qty` decimal(15,2) DEFAULT NULL,
  `po_amount` decimal(15,2) DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `quote_date` date NOT NULL,
  `siteid` varchar(32) NOT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `so_plan`
--


--
-- Table structure for table `solution`
--

CREATE TABLE `solution` (
  `recnum` int(11) DEFAULT NULL,
  `solnum` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `prob_desc` longtext,
  `sol_desc` longtext,
  `type` varchar(50) DEFAULT NULL,
  `sol_upload_file` varchar(200) DEFAULT NULL,
  `create_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `solution`
--


--
-- Table structure for table `spmaster`
--

CREATE TABLE `spmaster` (
  `recnum` int(11) DEFAULT NULL,
  `crnnum` char(30) DEFAULT NULL,
  `partnum` varchar(255) DEFAULT NULL,
  `aukpartnum` varchar(255) DEFAULT NULL,
  `saabpartnum` varchar(255) DEFAULT NULL,
  `currency` char(10) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `price_valid_from` date DEFAULT NULL,
  `price_valid_upto` date DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `qty_valid_from` date DEFAULT NULL,
  `qty_valid_upto` date DEFAULT NULL,
  `totalcost` float DEFAULT NULL,
  `totalcost_valid_from` date DEFAULT NULL,
  `totalcost_valid_upto` date DEFAULT NULL,
  `qty_ss` int(11) DEFAULT NULL,
  `link2vendor` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `status` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `spmaster`
--


--
-- Table structure for table `spmfrmaster`
--

CREATE TABLE `spmfrmaster` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `arp_id` varchar(255) DEFAULT NULL,
  `company_name` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `ref_no` varchar(100) NOT NULL,
  `ref_no_pi` varchar(60) DEFAULT NULL,
  `title` varchar(100) NOT NULL,
  `title_pi` varchar(60) DEFAULT NULL,
  `special_process` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `limitation` varchar(200) NOT NULL,
  `created_date` varchar(100) NOT NULL,
  `modified_date` varchar(100) NOT NULL,
  `from_date` varchar(60) DEFAULT NULL,
  `to_date` varchar(60) DEFAULT NULL,
  `created_by` varchar(225) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `spmfrmaster`
--


--
-- Table structure for table `sptreat`
--

CREATE TABLE `sptreat` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `crnnum` varchar(65) DEFAULT NULL,
  `partnum` varchar(85) DEFAULT NULL,
  `drg_iss` varchar(65) DEFAULT NULL,
  `part_iss` varchar(75) DEFAULT NULL,
  `cos_iss` varchar(75) DEFAULT NULL,
  `mtl_type` varchar(75) DEFAULT NULL,
  `mtl_spec` varchar(75) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `modified_by` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `partname` varchar(85) DEFAULT NULL,
  `per_drg` varchar(45) DEFAULT NULL,
  `partlist` varchar(45) DEFAULT NULL,
  `edoc` varchar(45) DEFAULT NULL,
  `adcn` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sptreat`
--


--
-- Table structure for table `sptreat_li`
--

CREATE TABLE `sptreat_li` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `line_num` varchar(45) DEFAULT NULL,
  `process_desc` varchar(255) DEFAULT NULL,
  `standard` varchar(150) DEFAULT NULL,
  `iss_of_std` varchar(45) DEFAULT NULL,
  `link2sptreat` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sptreat_li`
--


--
-- Table structure for table `srtype`
--

CREATE TABLE `srtype` (
  `recnum` int(11) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `status` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `srtype`
--


--
-- Table structure for table `stage_insp`
--

CREATE TABLE `stage_insp` (
  `recnum` int(11) DEFAULT NULL,
  `seqnum` int(11) DEFAULT NULL,
  `qc_sign` varchar(5) DEFAULT NULL,
  `link2wo` int(11) DEFAULT NULL,
  `remarks` varchar(50) DEFAULT NULL,
  `fqc_sign` varchar(15) DEFAULT NULL,
  `fremarks` varchar(50) DEFAULT NULL,
  `prodn_sign` varchar(15) DEFAULT NULL,
  `premarks` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stage_insp`
--


--
-- Table structure for table `stage_insp_lineitems`
--

CREATE TABLE `stage_insp_lineitems` (
  `recnum` int(11) DEFAULT NULL,
  `linenum` int(11) DEFAULT NULL,
  `normal_dim` varchar(30) DEFAULT NULL,
  `slno1` int(11) DEFAULT NULL,
  `slno2` int(11) DEFAULT NULL,
  `slno3` int(11) DEFAULT NULL,
  `slno4` int(11) DEFAULT NULL,
  `measured_dim1` varchar(30) DEFAULT NULL,
  `measured_dim2` varchar(30) DEFAULT NULL,
  `measured_dim3` varchar(30) DEFAULT NULL,
  `measured_dim4` varchar(30) DEFAULT NULL,
  `verified_by` varchar(30) DEFAULT NULL,
  `insp_by1` varchar(30) DEFAULT NULL,
  `insp_by2` varchar(30) DEFAULT NULL,
  `insp_by3` varchar(30) DEFAULT NULL,
  `insp_by4` varchar(30) DEFAULT NULL,
  `shift1` varchar(20) DEFAULT NULL,
  `shift2` varchar(20) DEFAULT NULL,
  `shift3` varchar(20) DEFAULT NULL,
  `shift4` varchar(20) DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `date3` date DEFAULT NULL,
  `date4` date DEFAULT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `tr_no` varchar(30) DEFAULT NULL,
  `rev_no` int(11) DEFAULT NULL,
  `revdate` date DEFAULT NULL,
  `link2stage_insp` int(11) DEFAULT NULL,
  `measured_dim5` varchar(30) DEFAULT NULL,
  `insp_by5` varchar(30) DEFAULT NULL,
  `shift5` varchar(20) DEFAULT NULL,
  `date5` date DEFAULT NULL,
  `slno5` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stage_insp_lineitems`
--


--
-- Table structure for table `stage_insp_report`
--

CREATE TABLE `stage_insp_report` (
  `recnum` int(11) DEFAULT NULL,
  `refnum` varchar(30) DEFAULT NULL,
  `opnnum` varchar(20) DEFAULT NULL,
  `partnum` varchar(30) DEFAULT NULL,
  `batch_qty` varchar(20) DEFAULT NULL,
  `partname` varchar(30) DEFAULT NULL,
  `sheet` varchar(10) DEFAULT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `tr_no` varchar(30) DEFAULT NULL,
  `rev_no` int(11) DEFAULT NULL,
  `revdate` date DEFAULT NULL,
  `siteid` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stage_insp_report`
--


--
-- Table structure for table `standard`
--

CREATE TABLE `standard` (
  `recnum` int(11) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `file` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `standard`
--


--
-- Table structure for table `stdmaster`
--

CREATE TABLE `stdmaster` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `std_no` varchar(85) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stdmaster`
--


--
-- Table structure for table `stdmaster_li`
--

CREATE TABLE `stdmaster_li` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `line_num` varchar(45) DEFAULT NULL,
  `iss_of_ref` varchar(45) DEFAULT NULL,
  `iss_date` date DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `link2std` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stdmaster_li`
--


--
-- Table structure for table `stockxfer`
--

CREATE TABLE `stockxfer` (
  `recnum` int(11) DEFAULT NULL,
  `sxfer` varchar(55) DEFAULT NULL,
  `stock_date` date DEFAULT NULL,
  `link2company` int(11) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `siteid` varchar(55) DEFAULT NULL,
  `annexure_num` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stockxfer`
--


--
-- Table structure for table `stockxfer_li`
--

CREATE TABLE `stockxfer_li` (
  `recno` int(11) NOT NULL AUTO_INCREMENT,
  `iss_date` date DEFAULT NULL,
  `iss_qty` int(11) DEFAULT NULL,
  `iss4wo` varchar(20) DEFAULT NULL,
  `accqty` int(11) DEFAULT NULL,
  `rejqty` int(11) DEFAULT NULL,
  `retqty` int(11) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `link2grn` int(11) DEFAULT NULL,
  `line_no` int(11) DEFAULT NULL,
  `opbal` int(11) DEFAULT NULL,
  `clbal` int(11) DEFAULT NULL,
  `wonum` varchar(255) DEFAULT NULL,
  `grnnum` varchar(255) DEFAULT NULL,
  `wo_status` varchar(10) DEFAULT NULL,
  `link2stock` int(11) DEFAULT NULL,
  `crn` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`recno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stockxfer_li`
--


--
-- Table structure for table `suppevaluation`
--

CREATE TABLE `suppevaluation` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `quality` varchar(100) DEFAULT NULL,
  `delivery` varchar(255) DEFAULT NULL,
  `inventory` varchar(255) DEFAULT NULL,
  `communication` varchar(255) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `total` int(50) DEFAULT NULL,
  `percentage` double DEFAULT NULL,
  `link2company` varchar(100) DEFAULT NULL,
  `supp_date` date DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suppevaluation`
--

INSERT INTO `suppevaluation` VALUES (1,'8','9','5','10','2019-07-04','bmandyam','2019-07-08 11:50:38','bmandyam',32,80,'178','2019-07-04',NULL),(2,'7','7','8','7','2019-07-08','bmandyam','2019-07-08 11:39:17','bmandyam',29,72.5,'173','2019-07-24',NULL),(3,'2','8','8','8','2019-08-01','bmandyam',NULL,NULL,26,65,'173','2019-08-14','FSI'),(4,'9','8','9','9','2019-08-07','bmandyam',NULL,NULL,35,87.5,'3','2019-08-07','FSI');

--
-- Table structure for table `supplier_enquiry`
--

CREATE TABLE `supplier_enquiry` (
  `recnum` int(11) DEFAULT NULL,
  `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,
  `customer` varchar(100) DEFAULT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_enquiry`
--


--
-- Table structure for table `supplier_enquiry_li`
--

CREATE TABLE `supplier_enquiry_li` (
  `linenum` varchar(32) NOT NULL,
  `part_desc` varchar(30) NOT NULL,
  `part_num` varchar(255) NOT NULL,
  `remarks_li` varchar(255) DEFAULT NULL,
  `link2rfq` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `width` varchar(255) DEFAULT NULL,
  `thickness` varchar(255) DEFAULT NULL,
  `rm_dia` varchar(255) DEFAULT NULL,
  `rm_spec` varchar(255) DEFAULT NULL,
  `rm_type` varchar(255) DEFAULT NULL,
  `rm_uom` varchar(50) DEFAULT NULL,
  `rm_grainflow` varchar(50) DEFAULT NULL,
  `rm_mrs` varchar(50) DEFAULT NULL,
  `length` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `recnum` int(11) DEFAULT NULL,
  `rfqid` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_enquiry_li`
--


--
-- Table structure for table `supplier_quote`
--

CREATE TABLE `supplier_quote` (
  `recnum` int(11) DEFAULT NULL,
  `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,
  `link2cust` int(8) NOT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_quote`
--


--
-- Table structure for table `supplier_quote_li`
--

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` decimal(15,2) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `link2quote` int(11) DEFAULT NULL,
  `linenum` varchar(32) NOT NULL,
  `quote_num` varchar(32) NOT NULL,
  `rfqid` varchar(32) NOT NULL,
  `length` varchar(255) NOT NULL,
  `width` varchar(255) DEFAULT NULL,
  `thickness` varchar(255) DEFAULT NULL,
  `rm_dia` varchar(255) DEFAULT NULL,
  `rm_spec` varchar(255) DEFAULT NULL,
  `rm_type` varchar(255) DEFAULT NULL,
  `rm_uom` varchar(50) DEFAULT NULL,
  `rm_grainflow` varchar(50) DEFAULT NULL,
  `rm_mrs` varchar(50) DEFAULT NULL,
  `link2cust` int(8) NOT NULL,
  `quote_date` date NOT NULL,
  KEY `recnum` (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_quote_li`
--


--
-- Table structure for table `suppmaster`
--

CREATE TABLE `suppmaster` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supplier` varchar(255) DEFAULT NULL,
  `link2supplier` int(11) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `scope_approval` varchar(255) DEFAULT NULL,
  `method_type` varchar(255) DEFAULT NULL,
  `extent_control` varchar(255) DEFAULT NULL,
  `inspection_year` varchar(255) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `approved` varchar(20) DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `approved_date` date DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `modified_by` varchar(50) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `risk_involve` varchar(55) DEFAULT NULL,
  `siteid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suppmaster`
--


--
-- Table structure for table `support`
--

CREATE TABLE `support` (
  `recnum` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `condition` varchar(30) DEFAULT NULL,
  `supp2wo` int(11) DEFAULT NULL,
  `supp2customer` int(11) DEFAULT NULL,
  `supp2contact` int(11) DEFAULT NULL,
  `supp2employee` int(11) DEFAULT NULL,
  `supp2type` int(11) DEFAULT NULL,
  `supp2solution` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `support`
--


--
-- Table structure for table `support_notes`
--

CREATE TABLE `support_notes` (
  `recnum` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `notes` longtext,
  `create_date` date DEFAULT NULL,
  `notes2user` int(11) DEFAULT NULL,
  `notes2support` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `support_notes`
--


--
-- Table structure for table `task`
--

CREATE TABLE `task` (
  `recnum` int(11) DEFAULT NULL,
  `task_name` varchar(20) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `taskcreate_date` date DEFAULT NULL,
  `taskcomp_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `task`
--

INSERT INTO `task` VALUES (40,'Create Bom',40,'2016-09-27','2016-09-28'),(41,'Create Sales',41,'2016-09-29','2016-09-30'),(42,'asssd',42,'2016-09-28','2016-10-27'),(43,'zhjgjg',43,'0000-00-00','2016-09-29'),(48,'ssss',48,'2016-11-10','0000-00-00');

--
-- Table structure for table `task_notes`
--

CREATE TABLE `task_notes` (
  `recnum` int(11) DEFAULT NULL,
  `notes` longtext,
  `create_date` date DEFAULT NULL,
  `notes2user` int(11) DEFAULT NULL,
  `notes2task` int(11) DEFAULT NULL,
  `task` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `task_notes`
--


--
-- Table structure for table `tasklist`
--

CREATE TABLE `tasklist` (
  `recnum` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `task1` varchar(255) DEFAULT NULL,
  `task2` varchar(255) DEFAULT NULL,
  `task3` varchar(255) DEFAULT NULL,
  `userid` varchar(255) DEFAULT NULL,
  `taskdate` date DEFAULT NULL,
  `task4` varchar(255) DEFAULT NULL,
  `task5` varchar(255) DEFAULT NULL,
  `task6` varchar(255) DEFAULT NULL,
  `task7` varchar(255) DEFAULT NULL,
  `task8` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tasklist`
--


--
-- Table structure for table `tasklist_time`
--

CREATE TABLE `tasklist_time` (
  `recnum` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tasklist_time`
--


--
-- Table structure for table `tasknotes`
--

CREATE TABLE `tasknotes` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `notes` longtext,
  `create_date` date DEFAULT NULL,
  `notes2user` int(11) DEFAULT NULL,
  `notes2task` int(11) DEFAULT NULL,
  `notes2project` int(11) DEFAULT NULL,
  KEY `ind_recnum` (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tasknotes`
--

INSERT INTO `tasknotes` VALUES (1,'','2017-08-22',2,1,1),(2,'create users','2017-08-22',2,1,1),(3,'List the users','2017-08-22',2,2,1);

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` char(50) DEFAULT NULL,
  `task_name` char(50) DEFAULT NULL,
  `category` char(50) DEFAULT NULL,
  `desc` text,
  `status` char(50) DEFAULT NULL,
  `link2project` int(11) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `priority` varchar(50) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `finish_date` datetime DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `userrecnum` int(11) DEFAULT NULL,
  `act_complete_date` datetime DEFAULT NULL,
  `estimate_hours` int(11) DEFAULT NULL,
  `started_date` datetime DEFAULT NULL,
  `estimate_mins` int(11) DEFAULT NULL,
  `filepath` varchar(255) DEFAULT NULL,
  `siteid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` VALUES (1,'TK-8','Db Structure','DB','create db structure','Completed',1,'bmandyam','2017-08-21','low','2017-08-21 00:00:00','2017-08-22 00:00:00',NULL,NULL,2,'2017-08-21 16:40:41',4,'2017-08-21 16:37:03',6,NULL,NULL),(2,'TK-9','one','crud','one','Break',1,'bmandyam','2017-08-21','low','2017-08-22 00:00:00','2017-08-23 00:00:00',NULL,NULL,2,NULL,4,'2017-08-22 10:26:52',5,NULL,NULL),(3,'TK-10','two','dghdsg','dafASDF','Created',1,'bmandyam','2017-08-21','low','2017-08-23 00:00:00','2017-08-24 00:00:00',NULL,NULL,2,NULL,4,NULL,8,NULL,NULL),(4,'TK-11','three','sdfasdf','sfgasdfsdf','Completed',1,'bmandyam','2017-08-21','low','2017-08-24 00:00:00','2017-08-25 00:00:00',NULL,NULL,2,'2017-08-21 17:37:00',3,'2017-08-21 17:03:41',17,NULL,NULL);

--
-- Table structure for table `test_report`
--

CREATE TABLE `test_report` (
  `recno` int(11) DEFAULT NULL,
  `refno` varchar(50) DEFAULT NULL,
  `partno` varchar(50) DEFAULT NULL,
  `customer` varchar(50) DEFAULT NULL,
  `partname` varchar(100) DEFAULT NULL,
  `cust_standard` varchar(100) DEFAULT NULL,
  `rm_inv_no` varchar(50) DEFAULT NULL,
  `material_type` varchar(50) DEFAULT NULL,
  `inv_date` date DEFAULT NULL,
  `material_spec` varchar(50) DEFAULT NULL,
  `rm_receipt_date` date DEFAULT NULL,
  `rm_supplier` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test_report`
--


--
-- Table structure for table `token`
--

CREATE TABLE `token` (
  `recnum` int(11) NOT NULL,
  `link2user` int(11) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `expires_in` int(11) DEFAULT NULL,
  `creation_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `token`
--

INSERT INTO `token` VALUES (0,94,'yaortaw3xc60qin70f68x5u6p0gd3w8p',3600,'2017-08-07 11:36:29'),(0,96,'rkoyx13rqr7z7fpzp4vlbdd6fbhj2kv3',3600,'2017-08-07 12:07:33'),(0,97,'fyxx6b37atnjsnkmynexmzbkn2o2qk4w',86400,'2017-09-07 08:02:23'),(0,2,'ejeci9rjcw9w1smd3l0fnj23bc0p78sd',86400,'2017-11-20 06:43:39');

--
-- Table structure for table `tools_transction`
--

CREATE TABLE `tools_transction` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `issued_to` varchar(85) DEFAULT NULL,
  `date_issued` date DEFAULT NULL,
  `date_received` date DEFAULT NULL,
  `link2machine_tools` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tools_transction`
--

INSERT INTO `tools_transction` VALUES (1,'fdfdfd','2019-08-08','2019-08-14',1),(2,'dsfsfsd','2019-08-06','2019-08-07',6),(3,'SunSys','2019-08-08','2019-08-08',4),(4,'SunSys','2019-08-08','2019-08-08',4),(5,'qas','2019-08-12','2019-08-16',5),(6,'HR','2019-08-12','0000-00-00',10);

--
-- Table structure for table `tran_license`
--

CREATE TABLE `tran_license` (
  `recnum` int(11) DEFAULT NULL,
  `app_name` varchar(100) DEFAULT NULL,
  `license_count` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tran_license`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `recnum` int(11) DEFAULT NULL,
  `initials` varchar(10) DEFAULT NULL,
  `userid` varchar(255) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `user2contact` varchar(50) DEFAULT NULL,
  `user2employee` varchar(50) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `last_modified` date DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,NULL,'sa','c12e01f2a13ff5587e1e9e4aedb8242d','EMPL',NULL,'1','Active',NULL,NULL,'FSI'),(2,'bm','bmandyam','63b4553627cdf3bd8706fe56795ef0c9','EMPL',NULL,'2','Active','2007-04-15',NULL,'FSI'),(56,'acc','accounts','7a90e38a211ece1c346928e7d1f3e968','EMPL',NULL,'225','Active','2016-11-02',NULL,'FSI1'),(57,'r','ravi','63dd3e154ca6d948fc380fa576343ba6','CUST','27',NULL,'Active','2017-02-17',NULL,'FSI'),(58,'a','asha','a2d5dc83dddc9580d68221d6604a759f','CUST','28',NULL,'Active','2017-02-20',NULL,'FSI'),(60,'A','aero','9575f05d5454113cd5f349e0e1da503c','VEND','30',NULL,'Active','2017-02-20',NULL,'FSI'),(84,'st','stores','61af09f34bc001f3b6d9139687a723fd','EMPL','NULL','232','Active','2017-05-03',NULL,'FSI'),(85,'p','ppc1','c21cedfcbe74cad21fa79031ca5aa95b','EMPL','NULL','233','Active','2017-05-03',NULL,'FSI'),(86,'q','qas','5668eca6cce28dbd64d888303dd7fb60','EMPL','NULL','234','Active','2017-05-03',NULL,'FSI'),(87,'pu','purchasing','74ba4e8291e8b2e40a31a50505f8b72e','EMPL','NULL','235','Active','2017-05-03',NULL,'FSI'),(88,'p','prodn','f8b493c7ffe23206dfdece136d51c382','EMPL','NULL','236','Active','2017-05-03',NULL,'FSI'),(89,'w','WO','e0a0862398ccf49afa6c809d3832915c','EMPL','NULL','237','Active','2017-05-03',NULL,'FSI'),(90,'r','PRN','3c8362a4683179fef39b9cd1e91787df','EMPL','NULL','238','Active','2017-05-03',NULL,'FSI'),(91,'h','HR','adab7b701f23bb82014c8506d3dc784e','EMPL','NULL','239','Active','2017-05-03',NULL,'FSI'),(92,'','sa_FSI','4393fa5764f826773d80747f312741d9','EMPL','','240','Active','2017-05-05',NULL,''),(93,NULL,'asd','79f839a4d23939eeebf8939818068516','EMPL',NULL,'241','Active','2017-07-05',NULL,'FSI'),(95,'aab','aab','e62595ee98b585153dac87ce1ab69c3c','MOBILE',NULL,'244',NULL,'2017-08-07',NULL,NULL),(96,'mmt','mmt','82915a4d88af6b86b4d6cb42705ffcb6','MOBILE',NULL,'245',NULL,'2017-08-07',NULL,NULL),(97,'M','manu','f13bb1bed03db9d68a7d9a48aafeec78','EMPL','NULL','246','Active','2017-09-07',NULL,'FSI');

--
-- Table structure for table `vend_part_master`
--

CREATE TABLE `vend_part_master` (
  `recnum` int(11) DEFAULT NULL,
  `partnum` varchar(50) DEFAULT NULL,
  `mfr_partnum` varchar(50) DEFAULT NULL,
  `digikey_partnum` varchar(50) DEFAULT NULL,
  `serial` varchar(50) DEFAULT NULL,
  `mfr` varchar(255) DEFAULT NULL,
  `rate` float DEFAULT NULL,
  `min_qty` int(11) DEFAULT NULL,
  `lead_time` int(11) DEFAULT NULL,
  `lead_unit` char(1) DEFAULT NULL,
  `part_desc` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `inventory_cnt` int(11) DEFAULT NULL,
  `link2vendor` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `ptype` varchar(30) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `part_iss` varchar(255) DEFAULT NULL,
  `drg_no` varchar(200) DEFAULT NULL,
  `drg_iss` varchar(200) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vend_part_master`
--

INSERT INTO `vend_part_master` VALUES (85,'BBOM/prn6','','','','',NULL,NULL,NULL,'y','testdf','',13,132,'2016-07-05','PART',NULL,'','','','FSI'),(86,'BBOM/prn2','','','','',NULL,NULL,NULL,'y','test','',10,132,'2016-07-06','BOM',NULL,'','','','FSI'),(2,'1234','3434','','','',100,NULL,NULL,'y','test','100',0,129,'2016-10-13','PART',NULL,'','','','FSI'),(3,'rmk 00 12','rmk 00 12','','','fluent',10,50,NULL,'y','ghdsgh','',0,132,'2017-12-05','PART',NULL,'A','A','A','FSI'),(4,'rmk 00 13','rmk 00 13','','','fluent',10,NULL,NULL,'y','dghsdd','',0,132,'2017-12-05','PART',NULL,'A','A','A','FSI');

--
-- Table structure for table `wo_attachment`
--

CREATE TABLE `wo_attachment` (
  `recnum` int(11) DEFAULT NULL,
  `filename1` varchar(255) DEFAULT NULL,
  `filename2` varchar(255) DEFAULT NULL,
  `filename3` varchar(255) DEFAULT NULL,
  `filename4` varchar(255) DEFAULT NULL,
  `link2wo` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wo_attachment`
--


--
-- Table structure for table `wo_mps`
--

CREATE TABLE `wo_mps` (
  `recnum` int(11) NOT NULL AUTO_INCREMENT,
  `ref_docs` varchar(255) NOT NULL,
  `alt_wk_cen` varchar(100) NOT NULL,
  `jig_validate` varchar(100) NOT NULL,
  `work_center` varchar(64) NOT NULL,
  `department` varchar(32) NOT NULL,
  `dcflag` varchar(16) NOT NULL,
  `mp_approval` varchar(32) NOT NULL,
  `app_date` date NOT NULL,
  `app_by` varchar(16) NOT NULL,
  `mps_desc` varchar(255) NOT NULL,
  `link2wo` int(11) NOT NULL,
  `line_num` int(11) NOT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wo_mps`
--


--
-- Table structure for table `wo_part_status`
--

CREATE TABLE `wo_part_status` (
  `fromsl` varchar(15) DEFAULT NULL,
  `tosl` varchar(15) DEFAULT NULL,
  `samplingsl` varchar(255) DEFAULT NULL,
  `rework` varchar(255) DEFAULT NULL,
  `acc` varchar(255) DEFAULT NULL,
  `rej` varchar(255) DEFAULT NULL,
  `ret` varchar(255) DEFAULT NULL,
  `stage` varchar(255) DEFAULT NULL,
  `inspnum` varchar(255) DEFAULT NULL,
  `signoff` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `link2wo` int(11) DEFAULT NULL,
  `line_num` int(11) DEFAULT NULL,
  `recno` int(11) NOT NULL AUTO_INCREMENT,
  `st_date` date DEFAULT NULL,
  `dn` varchar(45) DEFAULT NULL,
  `dn_sent` int(10) unsigned DEFAULT NULL,
  `dn_recv` int(10) unsigned DEFAULT NULL,
  `ncnum` char(50) DEFAULT NULL,
  `cofc_num` varchar(255) DEFAULT NULL,
  `cofc_date` date DEFAULT NULL,
  `supplier_wo` varchar(255) DEFAULT NULL,
  `hold` int(10) unsigned DEFAULT NULL,
  `cust_nc` char(50) DEFAULT NULL,
  `cust_rej` int(11) DEFAULT NULL,
  `qtyused_in_assy` int(11) DEFAULT NULL,
  `qtyused_in_dispatch` int(11) DEFAULT NULL,
  `balance_qty` int(11) DEFAULT NULL,
  `cust_rew` int(11) DEFAULT NULL,
  `ref_docs` varchar(255) DEFAULT NULL,
  `alt_wk_cen` varchar(100) DEFAULT NULL,
  `jig_validate` varchar(100) DEFAULT NULL,
  `work_center` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `dcflag` varchar(255) DEFAULT NULL,
  `mp_qpproval` varchar(30) DEFAULT NULL,
  `app_by` varchar(50) DEFAULT NULL,
  `app_date` date DEFAULT NULL,
  `mps_desc` varchar(255) DEFAULT NULL,
  `mp_approval` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`recno`),
  KEY `ind_wps2wo` (`link2wo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wo_part_status`
--


--
-- Table structure for table `wonotes`
--

CREATE TABLE `wonotes` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `create_date` date DEFAULT NULL,
  `link2wo` int(10) unsigned DEFAULT NULL,
  `link2user` varchar(45) DEFAULT NULL,
  `wonotes` text,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=267 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wonotes`
--

INSERT INTO `wonotes` VALUES (1,'2016-05-10',31420,'2',''),(7,'2016-05-11',31420,'2',''),(25,'2016-05-11',31433,'2',''),(26,'2016-05-11',31432,'2',''),(27,'2016-05-11',31433,'2',''),(28,'2016-05-11',31433,'2',''),(29,'2016-05-11',31433,'2',''),(30,'2016-05-11',31433,'2',''),(34,'2016-05-11',31420,'2',''),(35,'2016-05-11',31432,'2',''),(36,'2016-05-11',31433,'2',''),(37,'2016-05-11',31432,'2',''),(38,'2016-05-11',31435,'2',''),(39,'2016-05-12',31418,'2',''),(40,'2016-05-12',31423,'2','af'),(41,'2016-05-19',31436,'2',''),(42,'2016-05-23',31434,'2',''),(43,'2016-05-23',31434,'2',''),(44,'2016-05-24',31428,'2',''),(45,'2016-05-24',31437,'2',''),(49,'2016-05-24',31419,'2',''),(50,'2016-05-27',31430,'2',''),(51,'2016-05-30',31438,'2','test'),(52,'2016-06-02',31431,'2',''),(53,'2016-06-02',31440,'2',''),(54,'2016-06-02',31440,'2',''),(55,'2016-06-02',31440,'2',''),(56,'2016-06-02',31435,'2',''),(57,'2016-06-02',31440,'2',''),(58,'2016-06-24',31439,'2',''),(59,'2016-06-24',31439,'2','testing'),(60,'2016-06-27',31439,'2','test'),(62,'2016-06-27',31435,'2',''),(63,'2016-06-27',31435,'2',''),(64,'2016-06-27',31435,'2',''),(65,'2016-06-27',31435,'2',''),(66,'2016-06-27',31438,'2',''),(67,'2016-06-27',31438,'2',''),(68,'2016-06-27',31438,'2',''),(69,'2016-06-28',31435,'2','test'),(71,'2016-06-28',31435,'2','test'),(72,'2016-06-28',31435,'2',''),(73,'2016-06-28',31435,'2',''),(74,'2016-06-28',31446,'2',''),(75,'2016-06-29',31447,'2',''),(76,'2016-06-29',31447,'2',''),(77,'2016-06-30',31452,'2',''),(78,'2016-06-30',31452,'2',''),(79,'2016-06-30',31450,'2',''),(80,'2016-07-01',31451,'2',''),(82,'2016-07-01',31451,'2',''),(83,'2016-07-01',31453,'2',''),(84,'2016-07-04',31457,'2',''),(85,'2016-07-04',31457,'2',''),(86,'2016-07-04',31457,'2',''),(87,'2016-07-04',31457,'2',''),(88,'2016-07-04',31457,'2',''),(89,'2016-07-04',31457,'2',''),(90,'2016-07-04',31457,'2',''),(91,'2016-07-04',31457,'2',''),(92,'2016-07-04',31457,'2',''),(93,'2016-07-05',31457,'2',''),(94,'2016-07-05',31457,'2',''),(95,'2016-07-05',31457,'2',''),(96,'2016-07-05',31457,'2',''),(97,'2016-07-05',31457,'2',''),(98,'2016-07-05',31457,'2',''),(99,'2016-07-05',31457,'2','testing'),(100,'2016-07-05',31457,'2',''),(101,'2016-07-05',31457,'2',''),(102,'2016-07-05',31457,'2','testing'),(103,'2016-07-05',31457,'2','tetsting'),(104,'2016-07-28',31453,'2',''),(105,'2016-07-28',31458,'2',''),(106,'2016-08-23',31460,'17','testing'),(107,'2016-09-30',31462,'85',''),(108,'2016-09-30',31462,'85',''),(109,'2016-10-03',31463,'2','test'),(110,'2016-10-04',31464,'2','test'),(111,'2016-10-05',31463,'2',''),(112,'2016-10-05',31463,'2',''),(113,'2016-10-05',31463,'2',''),(114,'2016-10-05',31463,'2',''),(115,'2016-10-05',31461,'2',''),(116,'2016-10-05',31463,'2',''),(117,'2016-10-05',31463,'2',''),(118,'2016-10-05',31461,'2',''),(119,'2016-10-05',31461,'2',''),(120,'2016-10-05',31461,'2',''),(121,'2016-10-05',31461,'2',''),(122,'2016-10-05',31461,'2',''),(123,'2016-10-05',31461,'2',''),(124,'2016-10-05',31461,'2',''),(125,'2016-10-05',31461,'2',''),(126,'2016-10-05',31461,'2',''),(130,'2016-10-07',31460,'2','test'),(131,'2016-10-12',31468,'2','test'),(132,'2016-10-14',31467,'2','dsdsd'),(133,'2016-10-14',31467,'2','ddd'),(134,'2016-10-18',31465,'2','test'),(135,'2016-10-18',31465,'2','test'),(136,'2016-10-18',31469,'2','test'),(137,'2016-10-18',31469,'2','test'),(138,'2016-10-18',31469,'2','test'),(139,'2016-11-04',31472,'2','test'),(140,'2016-11-05',31476,'2','WO CLosed'),(141,'2016-11-07',31477,'2','Closed'),(142,'2016-11-09',31478,'2','test'),(143,'2016-11-09',31479,'2','test'),(144,'2016-11-10',31477,'2','test'),(145,'2016-11-14',31483,'2','testing  grn issue'),(146,'2016-11-14',31483,'2','test'),(147,'2016-12-19',31487,'2','cancel work order'),(148,'2016-12-19',31488,'2','work order cancelled'),(149,'2016-12-22',31488,'2','testing\r\n'),(150,'2016-12-22',31488,'2','testing'),(151,'2017-02-14',31489,'2','wo caneclled'),(153,'2017-02-20',31480,'2','test'),(154,'2017-03-09',31490,'2','test'),(155,'2017-03-16',31480,'2','test'),(156,'2017-03-16',31480,'2','test'),(157,'2017-08-10',31500,'2','test'),(158,'2017-08-10',31501,'2','test'),(159,'2017-08-10',31501,'2',''),(160,'2017-08-10',31502,'2',''),(161,'2017-08-10',31504,'2',''),(162,'2017-08-16',31510,'2','test'),(163,'2017-08-16',31510,'2','test'),(164,'2017-08-16',31495,'2',''),(165,'2017-08-16',31511,'2','test'),(166,'2017-08-16',31512,'2','test'),(173,'2017-08-28',31520,'2','test'),(175,'2017-08-28',31521,'2','test'),(176,'2017-09-12',31526,'2','test'),(177,'2017-09-12',31524,'2','test'),(178,'2017-09-12',31523,'2','test'),(179,'2017-09-12',31523,'2','test'),(180,'2017-09-12',31527,'2','test'),(181,'2017-11-23',31520,'2','test'),(186,'2017-11-23',31521,'2','test'),(187,'2017-11-23',31533,'2','test'),(188,'2017-11-23',31534,'2','test'),(189,'2017-11-23',31531,'2','Closed by ashwini'),(190,'2017-11-23',31528,'2','test'),(191,'2017-11-24',31535,'2','added fi and closed'),(192,'2017-11-24',31537,'2','Added FI And closed'),(193,'2017-11-24',31537,'2','test'),(194,'2017-11-24',31538,'2','test'),(195,'2017-11-24',31539,'2','test'),(196,'2017-11-24',31540,'2','Added FI and closed'),(197,'2017-11-24',31542,'2','test'),(198,'2017-12-05',31543,'2','close the work order'),(199,'2018-04-10',31545,'2','WO Closed'),(201,'2018-04-13',31536,'2','test'),(203,'2018-04-13',31536,'2','test'),(205,'2018-05-04',31544,'2','test'),(207,'2018-05-04',31536,'2','test'),(208,'2018-05-04',31544,'2','changed wo type to out source'),(209,'2018-05-04',31544,'2','teest'),(210,'2018-05-04',31544,'2','Closed wo'),(211,'2018-05-07',31536,'2','closed wo by ashwini'),(212,'2018-05-08',31546,'2','added dc num '),(215,'2019-06-13',31550,'2','test'),(216,'2019-06-14',31550,'2','tets'),(217,'2019-06-14',31550,'2','tets'),(218,'2019-06-20',31551,'2','test'),(219,'2019-06-26',31552,'2','testing'),(220,'2019-06-27',31553,'2','test'),(221,'2019-07-02',31554,'2','test'),(243,'2019-07-11',31590,'2','test'),(244,'2019-07-12',31623,'2','test'),(246,'2019-07-15',31627,'2',''),(247,'2019-07-25',31628,'2','gfdgfg'),(248,'2019-08-02',31629,'2',''),(249,'2019-08-05',31628,'2','test'),(250,'2019-08-06',2,'2','close notes'),(252,'2019-08-07',3,'2','notes closed'),(253,'2019-08-07',4,'2','dn '),(254,'2019-08-07',5,'2','wo closed'),(255,'2019-08-10',6,'2','dn'),(262,'2019-08-10',6,'2','test'),(263,'2019-08-10',6,'2','test'),(264,'2019-08-10',6,'2',''),(265,'2019-08-12',7,'2','terst'),(266,'2019-08-13',7,'2','test');

--
-- Table structure for table `work_flow_config`
--

CREATE TABLE `work_flow_config` (
  `recnum` int(11) DEFAULT NULL,
  `stage` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `dept` varchar(255) DEFAULT NULL,
  `doc_type` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `email_list` varchar(255) DEFAULT NULL,
  `appr_type` varchar(10) DEFAULT NULL,
  `approval_by` varchar(10) DEFAULT NULL,
  `allow_cust_disp` varchar(10) DEFAULT NULL,
  `allow_print_disp` varchar(10) DEFAULT NULL,
  `allow_report_disp` varchar(10) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `cust_status_disp` varchar(100) DEFAULT NULL,
  `est_time` time DEFAULT NULL,
  `est_cost` float DEFAULT NULL,
  `act_status` varchar(10) DEFAULT NULL,
  `dependency` varchar(30) DEFAULT NULL,
  `approval` varchar(30) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `secondary_responsibility` varchar(100) DEFAULT NULL,
  `process` varchar(255) DEFAULT NULL,
  `when_process` varchar(255) DEFAULT NULL,
  `currency` varchar(45) DEFAULT NULL,
  `primary_responsibility` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `work_flow_config`
--

INSERT INTO `work_flow_config` VALUES (92,30,'Aerowings','Stores','WO','WO_Recd','testt@gmial.com','','','','','','2017-12-05','sa',NULL,NULL,'','01:03:00',100,'Active','',NULL,'FSI','stores','process','whenprocess','$','stores'),(93,40,'Aerowings','Production','WO','Docs_Recd','testt@gmial.com','','','','','','2017-12-05','sa',NULL,NULL,'','02:04:00',100,'Active','30',NULL,'FSI','stores','test','test','$','stores'),(94,50,'Aerowings','Production','WO','Recd_Material','testt@gmial.com','test','test','','','','2017-12-05','sa',NULL,NULL,'','01:01:00',100,'Active','40',NULL,'FSI','ppc1','test','test','$','ppc1'),(95,60,'Aerowings','Production','WO','Stage_Insp_Done','testt@gmial.com','','test','y','y','','2017-12-05','sa',NULL,NULL,'','01:03:00',100,'Active','50',NULL,'FSI','accounts','test','test','$','accounts'),(96,70,'Aerowings','Production','WO','Fitting Done','','test','test','','','','2017-12-05','sa',NULL,NULL,'','02:02:00',100,'Active','60',NULL,'FSI','Badari','test','test','$','Badari'),(97,80,'Aerowings','QA','WO','Recd_FG_For_FI','','test','test','','','','2017-12-05','sa',NULL,NULL,'','01:01:00',100,'Active','70',NULL,'FSI','accounts','test','test','$','stores'),(98,90,'Aerowings','QA','WO','FI_Completed','testt@gmial.com','','','','','','2017-12-05','sa',NULL,NULL,'','01:01:00',100,'Active','80',NULL,'FSI','Badari','test','test','$','Badari'),(100,10,'Ripple','Paint','WO','Int Wo Released','testt@gmial.com','test','yes','','y','','2017-12-21','sa',NULL,NULL,'','03:04:00',200,'Active','',NULL,'FSI','Badari','test','tste','$','Badari'),(101,20,'Ripple','Marketing','WO','Risk Analysis','testt@gmial.com','','','','y','','2017-12-21','sa',NULL,NULL,'','02:03:00',100,'Active','10',NULL,'FSI','accounts','tese','etret','$','accounts'),(102,30,'Ripple','PPC','WO','BOM','testt@gmial.com','','','','','','2017-12-21','sa',NULL,NULL,'','01:03:00',100,'Active','20',NULL,'FSI','Badari','test','test','$','Badari'),(103,40,'Ripple','PPC','WO','Purchase indents','testt@gmial.com','','','','','','2017-12-21','sa',NULL,NULL,'','03:03:00',100,'Active','30',NULL,'FSI','Badari','test','test','$','Badari'),(104,50,'Ripple','Stores','WO','Store Approval','testt@gmial.com','','','','','','2017-12-21','sa',NULL,NULL,'','03:04:00',100,'Active','40',NULL,'FSI','ppc1','test','test','$','ppc1'),(105,60,'Ripple','PPC','WO','RMPO for tools Consummables','','','','','','','2017-12-21','sa',NULL,NULL,'','01:04:00',100,'Active','50',NULL,'FSI','qas','test','test','$','stores'),(106,70,'Ripple','Stores','WO','Stores Recepts GRN','testt@gmial.com','','','','','','2017-12-21','sa',NULL,NULL,'','01:02:00',100,'Active','60',NULL,'FSI','Badari','testr','test','$','Badari'),(107,80,'Ripple','QA','WO','QA Inspection','','','','','','','2017-12-21','sa',NULL,NULL,'','03:03:00',100,'Active','70',NULL,'FSI','Badari','test','test','$','stores'),(108,90,'Ripple','PPC','WO','BOI','','','','','','','2017-12-21','sa',NULL,NULL,'','04:03:00',100,'Active','80',NULL,'FSI','Badari','test','test','$','Badari'),(109,100,'Ripple','PPC','WO','BOI  recd GRN','','','','','','','2017-12-21','sa',NULL,NULL,'','02:03:00',100,'Active','90',NULL,'FSI','Badari','test','test','$','Badari'),(110,110,'Ripple','PPC','WO','QA Insp','','','','','','','2017-12-21','sa',NULL,NULL,'','03:07:00',100,'Active','100',NULL,'FSI','Badari','test','test','$','Badari'),(111,120,'Ripple','Stores','WO','Stores create KIT & DOC','','','','','','','2017-12-21','sa',NULL,NULL,'','05:04:00',100,'Active','110',NULL,'FSI','Badari','test','test','$','Badari'),(112,130,'Ripple','Account','WO','Invoice by Account','','','','','','','2017-12-21','sa',NULL,NULL,'','04:02:00',100,'Active','120',NULL,'FSI','accounts','test','test','$','accounts'),(113,140,'Ripple','Packing','WO','packing','','','','','','','2017-12-21','sa',NULL,NULL,'','04:03:00',100,'Active','',NULL,'FSI','qas','test','test','$','qas');

--
-- Table structure for table `work_order`
--

CREATE TABLE `work_order` (
  `recnum` int(11) DEFAULT NULL,
  `wonum` varchar(50) DEFAULT NULL,
  `wotype` varchar(30) DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `po_num` varchar(100) DEFAULT NULL,
  `quote_num` varchar(100) DEFAULT NULL,
  `condition` varchar(100) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `wo2customer` int(11) DEFAULT NULL,
  `wo2contact` int(11) DEFAULT NULL,
  `wo2employee` int(11) DEFAULT NULL,
  `wo2type` int(11) DEFAULT NULL,
  `sch_due_date` date DEFAULT NULL,
  `actual_ship_date` date DEFAULT NULL,
  `reorder` varchar(20) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `last_modified_date` datetime DEFAULT NULL,
  `wo2wfconfig` int(11) DEFAULT NULL,
  `wo2mfg` int(11) DEFAULT NULL,
  `book_date` date DEFAULT NULL,
  `revised_ship_date` date DEFAULT NULL,
  `bomnum` varchar(20) DEFAULT NULL,
  `wo2bom` int(11) DEFAULT NULL,
  `filename1` varchar(255) DEFAULT NULL,
  `filename2` varchar(255) DEFAULT NULL,
  `filename3` varchar(255) DEFAULT NULL,
  `filename4` varchar(255) DEFAULT NULL,
  `link2masterdata` int(11) DEFAULT NULL,
  `grnnum` varchar(255) DEFAULT NULL,
  `qty` varchar(20) DEFAULT NULL,
  `sonum` varchar(30) DEFAULT NULL,
  `po_date` date DEFAULT NULL,
  `po_qty` float DEFAULT NULL,
  `partnum` varchar(100) DEFAULT NULL,
  `comp_qty` int(11) DEFAULT '0',
  `batchnum` varchar(100) DEFAULT NULL,
  `woclassif` varchar(20) DEFAULT NULL,
  `worefnum` varchar(20) DEFAULT NULL,
  `formrev` varchar(255) DEFAULT NULL,
  `remarks` text,
  `link2mps` int(11) DEFAULT NULL,
  `amendment_date` date DEFAULT NULL,
  `amendment_notes` varchar(255) DEFAULT NULL,
  `original_qty` float unsigned DEFAULT NULL,
  `cust_po_line_num` varchar(20) DEFAULT NULL,
  `treatment` varchar(50) DEFAULT NULL,
  `fai` varchar(10) DEFAULT NULL,
  `type_remarks` text,
  `crn_num` varchar(30) DEFAULT NULL,
  `dn_qty_sent` int(10) unsigned DEFAULT '0',
  `dn_qty_recd` int(10) unsigned DEFAULT '0',
  `stage_split` varchar(45) DEFAULT NULL,
  `approval` varchar(15) DEFAULT NULL,
  `approval_date` date DEFAULT NULL,
  `acc4dn` int(11) DEFAULT '0',
  `printflag` int(11) DEFAULT NULL,
  `printapproval` char(5) DEFAULT NULL,
  `printcount` int(11) DEFAULT NULL,
  `rm_spec` varchar(255) DEFAULT NULL,
  `rm_type` varchar(255) DEFAULT NULL,
  `assy_wonum` varchar(50) DEFAULT NULL,
  `priority` varchar(45) DEFAULT NULL,
  `dispatch_qty` int(11) DEFAULT '0',
  `ret_qty` int(11) DEFAULT '0',
  `rej_qty` int(11) DEFAULT '0',
  `rework_qty` int(11) DEFAULT '0',
  `assy_qty` int(11) DEFAULT '0',
  `approved_by` varchar(45) DEFAULT NULL,
  `cust_rew_qty` int(11) DEFAULT '0',
  `cust_rej_qty` int(11) DEFAULT NULL,
  `dnnum` char(10) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `link2suppdc` int(11) DEFAULT NULL,
  `other_match` int(11) DEFAULT NULL,
  `dc_num` varchar(50) DEFAULT NULL,
  `link2vendor` int(11) DEFAULT NULL,
  `rmpo_num` varchar(255) DEFAULT NULL,
  `mpsliflag` int(11) DEFAULT NULL,
  `mpsrevision` varchar(20) DEFAULT NULL,
  KEY `wpo` (`po_num`),
  KEY `ind_wonum` (`wonum`),
  KEY `ind_l2m` (`link2masterdata`),
  KEY `ind_wo_grn` (`grnnum`),
  KEY `ind_wo_recnum` (`recnum`),
  KEY `ind_wo2customer` (`wo2customer`),
  KEY `ind_crn` (`crn_num`),
  KEY `ind_wo_condition` (`condition`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `work_order`
--



