--
-- Host: pmAnywhere3.db.11472283.hostedresource.com    Database: pmAnywhere3
-- ------------------------------------------------------


--
-- Dumping data for table `submittal`
--
-- WHERE:  companyID=28

INSERT INTO `submittal` VALUES (653,624,63,'',NULL,0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(654,625,63,'',NULL,0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(655,686,63,'',NULL,0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(659,690,63,'',NULL,0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(668,699,63,'',NULL,0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(669,700,63,'',NULL,0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2389,2400,97,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2436,2442,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2437,2443,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2438,2444,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2680,2714,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2696,2733,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(2982,3021,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(3402,3414,199,'<p>n</p>\r\n','<p>n</p>\r\n',1,'        ','Complete','2016-08-16',197,197,68,197,'m','2016-08-17','m','','m','m1','m','m','Team',69,28),(3403,3413,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','0','','','','','',NULL,NULL,28),(3404,3418,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3416,3430,199,'','',4,' reject','Complete','2016-08-18',199,198,198,68,'123','2016-08-18','er','','','','','','Associate',10,28),(3554,3541,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3555,3542,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3557,3544,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3650,3638,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3655,3643,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3680,2401,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3706,3687,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3707,3592,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(3866,3846,199,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4153,3894,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4154,4167,237,'final draft comments','dfsdfmnbmnbmnbnmbmnmn',1,'   fsdfsdf','Complete','2017-12-23',242,233,242,69,'1','2017-01-02','myselt','','testname','123','not available','15','Client',18,28),(4164,4171,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4179,4190,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4180,4172,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4181,3896,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4190,4201,237,'Final Draft, is Final','None',6,' Final ','Complete','2018-01-22',242,232,233,197,'675/99i/0pou','2018-00-11','th','','56','123512351235','23455','34666','Vendor',197,28),(4191,4203,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4195,4207,237,'Whats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single comment','Whats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single commentWhats a comment if there is not a single comment',2,' Whats a comment if there is not a single comment ','Complete','2018-01-22',197,197,197,197,'1254rt/.2135','2018-01-01','nonne','','BLAC','','','','Consultant',6,28),(4196,4208,237,'Guidelines for the Design and Construction of Stormwater Management Systems Developed by the New York City Department of Environmental Protection in consultation with the New York City Department of Buildings July 2012Guidelines for the Design and Construction of Stormwater Management Systems Developed by the New York City Department of Environmental Protection in consultation with the New York City Department of Buildings July 2012Guidelines for the Design and Construction of Stormwater Management Systems Developed by the New York City Department of Environmental Protection in consultation with the New York City Department of Buildings July 2012Guidelines for the Design and Construction of Stormwater Management Systems Developed by the New York City Department of Environmental Protection in consultation with the New York City Department of Buildings July 2012Guidelines for the Design and Construction of Stormwater Management Systems Developed by the New York City Department of Environmental Protection in consultation with the New York City Department of Buildings July 2012Guidelines for the Design and Construction of Stormwater Management Systems Developed by the New York City Department of Environmental Protection in consultation with the New York City Department of Buildings July 2012','none',1,'Guidelines','Complete','2018-01-25',242,197,197,197,'TEST/REPLY/001','0000-00-00','No Name','','','91010101','','','Vendor',198,28),(4197,4202,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4198,4204,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4199,4209,237,'<p>TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v</p>\r\n','<p>TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 TETSING/ LOCK/25JAN18 v v</p>\r\n',1,' ssss ','Complete','2018-04-18',242,237,69,197,'SAPNGFR/ 001','2018-04-18','No Name','','DHL','71647164873461287','H','OOO19','Associate',15,28),(4200,4213,237,'<p>I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.&nbsp;I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.</p>\r\n','<p>I mean even I post a coI mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.mment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.I mean even I post a comment on an older topic, that topic with its comment should always be on the top of the table.</p>\r\n',1,' Tags and Tags and Tags, test','Complete','2018-01-30',242,69,197,197,'EDR/REP/0001/2018-99','2001-01-01','No Name','','GHTY','4365654557577','F','H','Vendor',198,28),(4201,3895,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4202,4214,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4203,4215,237,'<p>While everybody can receive documents, only Full Control and Consolidate can edit/ delete/ hide others received documents. Normal users can edit / hide their own documents</p>\r\n','<p>While everybody can receive documents, only Full Control and Consolidate can edit/ delete/ hide others received documents. Normal users can edit / hide their own documents</p>\r\n',1,' test','Complete','2018-02-03',197,242,237,197,'789','2018-02-03','No Name','','ARAMAX','455475756','3','4','Vendor',201,28),(4204,4216,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4205,4217,237,'<p>f</p>\r\n','<p>f</p>\r\n',1,' f','Complete','2018-02-09',248,69,237,197,'444444','2018-02-09','reseiver','','rt','343426','6','7','Associate',15,28),(4206,4226,237,'<p>final</p>\r\n','<p>test</p>\r\n',1,' nice, awesome, great  ','Complete','2018-04-05',197,242,248,248,'123','2018-02-16','Ad','','panda','1','2','','Team',248,28),(4207,4227,237,'','',0,'','Pending','',0,0,0,0,'','0000-00-00','','','','','','','',0,28),(4208,4228,237,'<p>nothing to say</p>\r\n','<p>still testing</p>\r\n',1,' doc ','Pending','2018-02-16',197,242,197,248,'1','2018-02-16','Adeel','','panda','1','2','','Client',18,28),(4209,4229,237,'','',1,' ','Pending','2018-03-02',248,248,248,248,'1','2018-03-02','Adeel','','','','','','Associate',15,28);


