INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10204, 20003, '', '10204', 'E', 1, '<p>\n	Dear Arun...i was not sure if the ticket no. 10200 is same as below. Anyways the ticket is to have a&nbsp;<span style=\"background-color: rgb(255, 255, 0);\">Notify</span>&nbsp;field to send a mail notifying that an Inspection has been planned as per the details and date in the form.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 58620 characters]\" /></p>\n', '2020-07-15 09:04:17', '', 'Nancy Avila', 7, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-15 09:04:17', 10, '2020-07-22 21:58:48');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10205, 20003, '', '10205', 'E', 1, '<p>\n	Dear Arun..see below comment...the downloaded report shows a wrong output for BRAND NAME. When i downloaded it shows the real brand name, but Frederic gets it as a number. See below Brand name column. It Should be shown as JUNGHENRICH in this example. For your info...The only difference between me and Frederic is i am an admin user vs Frederic is a normal user.</p>\n<p>\n	Pls check.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65098 characters]', '2020-07-15 09:12:13', '', 'Nancy Avila', 7, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-15 09:12:13', 10, '2020-07-16 14:07:10');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10206, 20003, '', '10206', 'E', 1, '<p>\n	Dear Arun...correction to support ticket 10205..the problem is slightly different...see uploaded attachement.</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<table align=\"left\" cellpadding=\"0\" cellspacing=\"0\">\n	<tbody>\n		<tr>\n			<td height=\"0\">\n				&nbsp;</td>\n			<td>\n				&nbsp;</td>\n			<td>\n				&nbsp;</td>\n			<td>\n				&nbsp;</td>\n		</tr>\n		<tr>\n			<td height=\"8\">\n				&nbsp;</td>\n			<td align=\"left\" rowspan=\"2\">\n				<img alt=\"Text Box: This Report is from the listings page à Export pdf…see difference in BRAND and header with BlueSKY Address \" height=\"52\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png\" width=\"546\" /></td>\n		</tr>\n		<tr>\n			<td height=\"44\">\n				&nbsp;</td>\n			<td>\n				&nbsp;</td>\n			<td align=\"left\" rowspan=\"2\">\n				<img alt=\"Text Box: This Report is from the Report page à Export pdf…see difference in BRAND and header with title Employee List instead of Equipment List\n\n\" height=\"52\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image002.png\" width=\"546\" /></td>\n		</tr>\n		<tr>\n			<td height=\"8\">\n				&nbsp;</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img height=\"776\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image004.png\" width=\"835\" />&nbsp;<img height=\"782\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image006.png\" width=\"879\" /></p>\n', '2020-07-15 09:28:08', 'Arun Upload Regarding Equipment list.pdf', 'Javeed Sathar', 7, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-15 09:28:08', 10, '2020-07-16 14:16:09'),
(10207, 20058, '', '10207', 'E', 1, '<p>\n	Logo Changing</p>\n', '2020-07-15 12:12:38', 'WhatsApp Image 2020-07-15 at 12.09.22 PM.jpeg', 'JOHN', 173, 12, '2020-07-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-15 12:12:38', 1, '2020-07-21 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10208, 20003, '', '10208', 'E', 1, '<p>\n	Dear Arun</p>\n<p>\n	Kindly manage changes as per below details</p>\n<p>\n	1. In SOP Tab please change the name as per below list</p>\n<p>\n	List to <strong>Packing Instrictions List</strong></p>\n<p>\n	Operational&nbsp; Instructions to <strong>Packing Instructions View</strong></p>\n<p>\n	IMS Document to <strong>IMS Documents List</strong></p>\n<p>\n	IMS View to <strong>IMS Documents View</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	2. In SOP <strong>Packing Instruction View </strong>there is no back option&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	3. Removed the video in IMS Document List</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 11928 characters]\" /></p>\n<p>\n	&nbsp;</p>\n<p>\n	4. Under IMS Documents View add another tab&nbsp;<strong>Communication and Training</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	5. In order to record the data of staff reading and or viewed the video it should be directly captured in <strong>Employee-Competency</strong></p>\n<p>\n	While uploading the data to Packing Instruction List and IMS Documents List the below should be added</p>\n<p>\n	- Category - with the dropdown list of Category as per Employee Listings</p>\n<p>\n	- Training Provider: By default it is Inhouse-Online</p>\n<p>\n	- Tr. Hours - for video as video timings and for PDF 5 minutes per page</p>\n<p>\n	&nbsp;</p>\n<p>\n	In <strong>Packing Instructions List</strong></p>\n<p>\n	Change Title to <strong>Training Name</strong></p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 36004 characters]\" /></p>\n<p>\n	&nbsp;</p>\n<p>\n	In IMS Documents List</p>\n<p>\n	Change Name to <strong>Training Name</strong></p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 16029 characters]', '2020-07-15 14:55:06', '', 'Nancy Avila', 7, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-15 14:55:06', 1, '2020-07-22 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10224, 20001, '', '10224', 'I', 1, '<p>\n	put a check for the following</p>\n<p>\n	Credit note date should not go beyond sales invoice date</p>\n<p>\n	Debit Note date should note go beyond Purchase Invoice date</p>\n', '2020-07-21 09:25:21', '', 'JOHN', 3, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-21 09:25:21', 1, '2020-08-17 05:00:01'),
(10209, 20063, '', '10209', 'I', 1, '<p>\n	https://www.blueskyerp.me/erplite/<br />\n	<br />\n	Go to Sales-Orders<br />\n	Click Convert to Delivery<br />\n	Go to Terms &amp; Conditions Tab<br />\n	Hide Terms Dropdownlist and the Publish Button</p>\n', '2020-07-15 16:05:32', '', 'JOHN', 189, 12, '2020-07-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-15 16:05:32', 69, '2020-07-15 17:08:01'),
(10211, 20003, '', '10211', 'E', 1, '<p>\n	Dear arun, Same as ticket # 10197 ..regarding the emails header.</p>\n', '2020-07-16 16:03:40', 'Arun mail header ticket.pdf', 'Javeed Sathar', 7, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-16 16:03:40', 10, '2020-07-22 22:00:25'),
(10210, 20019, '', '10210', 'E', 1, '<p>\n	HR index page correction, notes, controller, create page etc</p>\n', '2020-07-16 10:39:24', '', 'JOHN', 57, 12, '2020-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-16 10:39:24', 1, '2020-07-28 05:00:02'),
(10212, 20003, '', '10212', 'E', 1, '<p>\n	Dear Arun,...Meeting minutes to also covert to action list with a tick box</p>\n', '2020-07-16 16:14:44', '', 'Javeed Sathar', 7, 12, '2020-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-16 16:14:44', 10, '2020-07-20 10:55:14'),
(10213, 20003, '', '10213', 'E', 1, '<p>\n	Dear Arun....Inspection menu to have Notify field and Start button for all assignees and self assignee...</p>\n', '2020-07-16 16:15:33', '', 'Javeed Sathar', 7, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-16 16:15:33', 10, '2020-07-22 22:00:41'),
(10214, 20049, '', '10214', 'E', 1, '<p class=\"MsoNormal\">\n	<span style=\"font-size:11.0pt\">Could you please add the below payment terms in ERP lite.</span></p>\n<p class=\"MsoNormal\">\n	<span style=\"font-size:11.0pt\">&nbsp;</span><span style=\"font-size:11.0pt\">Irrevocable and Confirmed LC</span></p>\n<ol start=\"1\" style=\"margin-top:0cm\" type=\"1\">\n	<li class=\"MsoListParagraph\" style=\"margin-left:0cm;mso-list:l0 level1 lfo1\">\n		<span style=\"font-size:11.0pt\">LC at sight</span></li>\n	<li class=\"MsoListParagraph\" style=\"margin-left:0cm;mso-list:l0 level1 lfo1\">\n		<span style=\"font-size:11.0pt\">30 days Credit LC</span></li>\n	<li class=\"MsoListParagraph\" style=\"margin-left:0cm;mso-list:l0 level1 lfo1\">\n		<span style=\"font-size:11.0pt\">45 days Credit LC</span></li>\n	<li class=\"MsoListParagraph\" style=\"margin-left:0cm;mso-list:l0 level1 lfo1\">\n		<span style=\"font-size:11.0pt\">20% advance payment and remaining on Irrevocable and Confirmed LC</span></li>\n</ol>\n', '2020-07-16 17:05:13', '', 'JOHN', 146, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-16 17:05:13', 1, '2020-07-22 05:00:02'),
(10215, 20001, '', '10215', 'E', 1, '<p>\n	Stock value is not updating properly</p>\n', '2020-07-18 10:14:06', '', 'Acecentro User', 1, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-07-18 10:14:06', 1, '2021-03-07 06:00:02'),
(10216, 20001, '', '10216', 'E', 1, '<p>\n	Please add the &#39;valid without signature&#39; clause in Invoice, PO, Order and Quatation in both Sale and Hire module.<br />\n	<br />\n	Example for Invoice : <strong>This invoice has been electronically generated by Ace Centro Enterprises (ACE) on 09/07/2020 10:42:44 am and is valid without signature.</strong></p>\n', '2020-07-18 10:17:28', '', 'Acecentro User', 1, 12, '2020-07-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-07-18 10:17:28', 1, '2020-07-31 05:00:04'),
(10217, 20028, '', '10217', 'E', 2, '<p>\n	Mumayaz - Finance Module copy</p>\n', '2020-07-19 08:12:12', '', 'JOHN', 83, 12, '2020-07-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-19 08:12:12', 1, '2020-07-27 05:00:02'),
(10218, 20003, '', '10218', 'E', 1, '<p>\n	Hi Arun...in the new changes to meeting minutes, where we added &quot;Action List&quot;...the mail subject is showing Minutes of Meeting and the pdf is also showing Minutes of meeting. Pls make it change according to the selection in the form. See uploaded attachment.</p>\n<p>\n	&nbsp;</p>\n<p>\n	Thanks,</p>\n', '2020-07-19 12:57:15', 'arun meeting minutes update 19July.pdf', 'Javeed Sathar', 7, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-19 12:57:15', 10, '2020-07-22 22:01:17'),
(10219, 20006, '', '10219', 'E', 1, '<p class=\"MsoNormal\">\n	GI Vocher : 208045,&nbsp; 208044</p>\n<p>\n	&nbsp;Both showing as allocated ,but no allocation is available .pls remove allocation urgently.</p>\n', '2020-07-19 16:03:08', 'juelmin190720.png', 'JOHN', 17, 12, '2020-07-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-19 16:03:08', 1, '2020-07-26 05:00:02'),
(10220, 20037, '', '10220', 'E', 1, '<p>\n	As discussed please note that &nbsp;the TA # 7361215, There are 2 invoices involved in this shipment&nbsp; but bluesky is giving only the details of one invoice</p>\n<p>\n	At the same time we noticed some DNs don&#39;t have TA numbers on the same date. Assuming this could be the details of second invoice</p>\n<p>\n	Please check on this and do the needful to get the complete details</p>\n', '2020-07-20 09:10:28', 'hilti200720.jpg', 'JOHN', 110, 4, '2021-02-09', 0, '0000-00-00', '', 2, '0', '', '30005', 0, 0, '', '', 69, '2020-07-20 09:10:28', 69, '2021-02-09 12:23:11'),
(10221, 20002, '', '10221', 'E', 1, '<p>\n	Can you explain the highlighted?</p>\n<p>\n	The current scenario is each every transaction has to be verified by us, whether it is posted to exact ledgers or not. Now we are spending most of our time for said verification.</p>\n<p>\n	We understand your finance module is a special software, first we have to enter the transaction and then verify whether it is debited/credited to correct account or not.</p>\n', '2020-07-20 10:15:59', 'norden200720.png', 'JOHN', 5, 12, '2020-07-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-20 10:15:59', 1, '2020-07-27 05:00:02'),
(10222, 20003, '', '10222', 'E', 1, '<p>\n	Dear Arun...No Start button for assignee yet &amp;</p>\n<p>\n	No Notify emails are going.</p>\n<p>\n	Pls check.</p>\n', '2020-07-20 10:52:20', 'Arun Inspection_No Start button11.pdf', 'Javeed Sathar', 7, 12, '2020-07-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-20 10:52:20', 1, '2020-07-27 05:00:02'),
(10223, 20003, '', '10223', 'E', 1, '<p>\n	Dear Arun...email address not reflecting the type of email. pls check.</p>\n', '2020-07-20 10:53:15', 'Arun Address not reflecting on email.pdf', 'Javeed Sathar', 7, 12, '2020-07-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-20 10:53:15', 1, '2020-07-27 05:00:02'),
(10225, 20013, '', '10225', 'I', 1, '<p>\n	put a check for the following</p>\n<p>\n	Credit note date should not go beyond sales invoice date</p>\n<p>\n	Debit Note date should note go beyond Purchase Invoice date</p>\n', '2020-07-21 09:25:40', '', 'JOHN', 39, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-21 09:25:40', 1, '2020-08-26 05:00:01'),
(10226, 20002, '', '10226', 'I', 1, '<p>\n	put a check for the following</p>\n<p>\n	Credit note date should not go beyond sales invoice date</p>\n<p>\n	Debit Note date should note go beyond Purchase Invoice date</p>\n', '2020-07-21 09:26:03', '', 'JOHN', 5, 12, '2020-08-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-21 09:26:03', 1, '2020-08-14 05:00:07'),
(10227, 20001, '', '10227', 'I', 1, '<p>\n	In reports &gt;Inventory&gt; Transaction Detail - bring a new coloumn , and show customer name in case of delivery and supplier name in case of material receipt/qc. whereever not possible leave it blank like transfers, issue, receipts etc</p>\n', '2020-07-21 09:29:00', '', 'JOHN', 3, 12, '2020-10-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-21 09:29:00', 1, '2020-10-27 06:00:02'),
(10228, 20010, '', '10228', 'E', 1, '<p>\n	Can we make some request? Is it ok for you to delete all the data on the inventory and purchase module?</p>\n<p>\n	We entered some data, but recently we made some changes, and it&#39;s easier for us to start from scratch than editing it,</p>\n', '2020-07-21 10:31:30', '', 'JOHN', 29, 12, '2020-07-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-21 10:31:30', 1, '2020-07-27 05:00:02'),
(10229, 20019, '', '10229', 'E', 2, '<p>\n	Recruitment Module Revamp</p>\n', '2020-07-21 15:36:21', '', 'JOHN', 56, 12, '2020-07-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-21 15:36:21', 1, '2020-07-31 05:00:04'),
(10230, 20003, '', '10230', 'I', 2, '<p>\n	Mobile App for chaloub. Android</p>\n', '2020-07-22 08:29:12', '', 'JOHN', 8, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2020-07-22 08:29:12', 1, '2022-07-29 05:00:04'),
(10231, 20008, '', '10231', 'I', 1, '<p>\n	Please find attached the file and the comments below based on our discussion:</p>\n<p>\n	Scheme A &ndash; Applicable to all Consultants</p>\n<p>\n	Scheme B &ndash; Applicable to Non-Centurion Consultants for prior period cases for Claw backs &amp; Reinstatements.</p>\n', '2020-07-22 13:00:02', 'Copy of Calculation for Gargash Commission.xlsx', 'JOHN', 23, 4, '2021-02-18', 0, '0000-00-00', '', 2, '0', '', '30003', 0, 0, '', '', 69, '2020-07-22 13:00:02', 69, '2021-02-18 17:27:22'),
(10232, 20003, '', '10232', 'E', 1, '<p>\n	Dear Arun...COMPANY menu review...thanks!!</p>\n', '2020-07-22 14:29:51', 'Company menu.pdf', 'Javeed Sathar', 7, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-22 14:29:51', 10, '2020-08-12 11:42:21'),
(10233, 20013, '', '10233', 'E', 1, '<p>\n	Hello Support,</p>\n<p>\n	CRM Stock balance available in Inventory/Transaction report and Bin wise report is not matching for ceratin items.&nbsp; Ex. 491RU-HFO. We have reported this variation issues since year back and till now it is not fixed. Kindly fix now send me a simple output of variation where stock for each item level and bin level.</p>\n<p>\n	&nbsp;</p>\n<p>\n	Urgent!</p>\n<p>\n	&nbsp;</p>\n', '2020-07-22 15:22:01', '', 'Ramachandiran V', 37, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2020-07-22 15:22:01', 1, '2021-01-18 06:00:02'),
(10234, 20003, '', '10234', 'E', 1, '<p>\n	Inspection Toggle Button</p>\n', '2020-07-22 17:49:39', '', 'JOHN', 8, 12, '2020-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-22 17:49:39', 10, '2020-07-28 10:24:47'),
(10235, 20003, '', '10235', 'E', 1, '<p>\n	Dear Arun...pls add a category to show in the listings : Meeting or Action List. See attchaed email and other filters..thanks !!</p>\n', '2020-07-22 22:03:33', 'meeting menu small changes.pdf', 'Javeed Sathar', 7, 12, '2020-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-22 22:03:33', 10, '2020-07-28 10:24:29'),
(10236, 20003, '', '10236', 'E', 1, '<p>\n	Hi Manu...the attached is teh current email formats i am receiving...pls see there are somemore discrepancies.</p>\n<p>\n	&nbsp;</p>\n<p>\n	Pls check..thanks !!</p>\n', '2020-07-23 12:01:22', 'email header format.pdf', 'Javeed Sathar', 7, 12, '2020-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-23 12:01:22', 10, '2020-07-28 10:27:47'),
(10237, 20001, '', '10237', 'I', 1, '<p>\n	Report -&gt;Inventory-&gt; Stock Transsaction Ledger</p>\n<p>\n	Insert a new coloumn customer/Vendor and display customer name in case of sales/sales return and vendor in case of Purchase/purchase return</p>\n<p>\n	and also check the opening quantity and transaction quantity if a different date is selected- its wrongly coming</p>\n<p>\n	make pdf and excel also</p>\n', '2020-07-25 10:18:51', '', 'JOHN', 2, 12, '2020-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-25 10:18:51', 1, '2020-08-09 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10238, 20002, '', '10238', 'E', 0, '<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65491 characters]', '2020-07-26 09:17:10', '', 'Tebin Kalam', 4, 12, '2020-07-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-07-26 09:17:10', 9, '2020-07-26 09:21:20');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10239, 20002, '', '10239', 'E', 1, '<p>\n	Please change below Invoice date to 26/07/2020, Delivery note made on 26<sup>th</sup>.</p>\n<table border=\"1\" cellpadding=\"0\" style=\"width:1227px;\" width=\"1227\">\n	<tbody>\n		<tr>\n			<td>\n				<p>\n					&nbsp;36896</p>\n			</td>\n			<td>\n				<p>\n					TI-411018</p>\n			</td>\n			<td>\n				<p>\n					211019</p>\n			</td>\n			<td>\n				<p>\n					23/07/2020</p>\n			</td>\n			<td>\n				<p>\n					Atlas Telecom</p>\n			</td>\n			<td>\n				<p>\n					Binu George</p>\n			</td>\n			<td>\n				<p>\n					AED</p>\n			</td>\n			<td>\n				<p align=\"right\">\n					1,598.90</p>\n			</td>\n			<td>\n				<p align=\"right\">\n					33,576.91</p>\n			</td>\n			<td>\n				<p>\n					Invoiced</p>\n			</td>\n			<td>\n				<p>\n					No</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2020-07-26 09:34:30', '', 'JOHN', 5, 12, '2020-08-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-26 09:34:30', 1, '2020-08-01 05:00:02'),
(10240, 20019, '', '10240', 'I', 1, '<p>\n	Test</p>\n', '2020-07-26 16:22:30', '', 'Arun', 56, 12, '2020-07-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 1, '2020-07-26 16:22:30', 1, '2020-07-26 16:24:58'),
(10241, 20019, '', '10241', 'E', 1, '<p>\n	HRMS - Appraisal - Revamp</p>\n', '2020-07-28 08:45:22', '', 'JOHN', 56, 12, '2020-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-28 08:45:22', 1, '2020-08-09 05:00:02'),
(10242, 20004, '', '10242', 'E', 1, '<p>\n	&nbsp;</p>\n<p class=\"MsoNormal\" style=\"margin-bottom:0in;margin-bottom:.0001pt;line-height:\nnormal\">\n	<span style=\"font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;\nmso-fareast-font-family:&quot;Times New Roman&quot;\">Please note below screen shot for GMC ZY32560 . We are not able to generate DA because less quantity available </span></p>\n<p class=\"MsoNormal\" style=\"margin-bottom:0in;margin-bottom:.0001pt;line-height:\nnormal\">\n	<span style=\"font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;\nmso-fareast-font-family:&quot;Times New Roman&quot;\">We did investigation and noticed that order no. 51011 has an issue. Two times out entry is showing instead of one</span></p>\n<p class=\"MsoNormal\" style=\"margin-bottom:0in;margin-bottom:.0001pt;line-height:\nnormal\">\n	<span style=\"font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;\nmso-fareast-font-family:&quot;Times New Roman&quot;\">Please check and solve this issue urgently.</span></p>\n<p class=\"MsoNormal\" style=\"margin-bottom:0in;margin-bottom:.0001pt;line-height:\nnormal\">\n	<span style=\"font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;\nmso-fareast-font-family:&quot;Times New Roman&quot;\">Attached transaction report for your reference </span></p>\n<p>\n	<!--[if gte mso 9]><xml>\n <o:OfficeDocumentSettings>\n  <o:AllowPNG/>\n </o:OfficeDocumentSettings>\n</xml><![endif]--><!--[if gte mso 9]><xml>\n <w:WordDocument>\n  <w:View>Normal</w:View>\n  <w:Zoom>0</w:Zoom>\n  <w:TrackMoves/>\n  <w:TrackFormatting/>\n  <w:PunctuationKerning/>\n  <w:ValidateAgainstSchemas/>\n  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>\n  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>\n  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>\n  <w:DoNotPromoteQF/>\n  <w:LidThemeOther>EN-US</w:LidThemeOther>\n  <w:LidThemeAsian>X-NONE</w:LidThemeAsian>\n  <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>\n  <w:Compatibility>\n   <w:BreakWrappedTables/>\n   <w:SnapToGridInCell/>\n   <w:WrapTextWithPunct/>\n   <w:UseAsianBreakRules/>\n   <w:DontGrowAutofit/>\n   <w:SplitPgBreakAndParaMark/>\n   <w:EnableOpenTypeKerning/>\n   <w:DontFlipMirrorIndents/>\n   <w:OverrideTableStyleHps/>\n  </w:Compatibility>\n  <m:mathPr>\n   <m:mathFont m:val=\"Cambria Math\"/>\n   <m:brkBin m:val=\"before\"/>\n   <m:brkBinSub m:val=\"&#45;-\"/>\n   <m:smallFrac m:val=\"off\"/>\n   <m:dispDef/>\n   <m:lMargin m:val=\"0\"/>\n   <m:rMargin m:val=\"0\"/>\n   <m:defJc m:val=\"centerGroup\"/>\n   <m:wrapIndent m:val=\"1440\"/>\n   <m:intLim m:val=\"subSup\"/>\n   <m:naryLim m:val=\"undOvr\"/>\n  </m:mathPr></w:WordDocument>\n</xml><![endif]--><!--[if gte mso 9]><xml>\n <w:LatentStyles DefLockedState=\"false\" DefUnhideWhenUsed=\"false\"\n  DefSemiHidden=\"false\" DefQFormat=\"false\" DefPriority=\"99\"\n  LatentStyleCount=\"371\">\n  <w:LsdException Locked=\"false\" Priority=\"0\" QFormat=\"true\" Name=\"Normal\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 7\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 8\"/>\n  <w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"heading 9\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 6\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 7\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 8\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index 9\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 7\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 8\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"toc 9\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Normal Indent\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"footnote text\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"annotation text\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"header\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"footer\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"index heading\"/>\n  <w:LsdException Locked=\"false\" Priority=\"35\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"caption\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"table of figures\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"envelope address\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"envelope return\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"footnote reference\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"annotation reference\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"line number\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"page number\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"endnote reference\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"endnote text\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"table of authorities\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"macro\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"toa heading\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Bullet\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Number\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Bullet 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Bullet 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Bullet 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Bullet 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Number 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Number 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Number 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Number 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"10\" QFormat=\"true\" Name=\"Title\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Closing\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Signature\"/>\n  <w:LsdException Locked=\"false\" Priority=\"1\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"Default Paragraph Font\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text Indent\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Continue\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Continue 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Continue 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Continue 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"List Continue 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Message Header\"/>\n  <w:LsdException Locked=\"false\" Priority=\"11\" QFormat=\"true\" Name=\"Subtitle\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Salutation\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Date\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text First Indent\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text First Indent 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Note Heading\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text Indent 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Body Text Indent 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Block Text\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Hyperlink\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"FollowedHyperlink\"/>\n  <w:LsdException Locked=\"false\" Priority=\"22\" QFormat=\"true\" Name=\"Strong\"/>\n  <w:LsdException Locked=\"false\" Priority=\"20\" QFormat=\"true\" Name=\"Emphasis\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Document Map\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Plain Text\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"E-mail Signature\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Top of Form\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Bottom of Form\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Normal (Web)\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Acronym\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Address\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Cite\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Code\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Definition\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Keyboard\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Preformatted\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Sample\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Typewriter\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"HTML Variable\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Normal Table\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"annotation subject\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"No List\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Outline List 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Outline List 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Outline List 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Simple 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Simple 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Simple 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Classic 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Classic 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Classic 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Classic 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Colorful 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Colorful 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Colorful 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Columns 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Columns 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Columns 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Columns 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Columns 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 6\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 7\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Grid 8\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 4\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 5\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 6\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 7\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table List 8\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table 3D effects 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table 3D effects 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table 3D effects 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Contemporary\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Elegant\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Professional\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Subtle 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Subtle 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Web 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Web 2\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Web 3\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Balloon Text\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" Name=\"Table Grid\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" UnhideWhenUsed=\"true\"\n   Name=\"Table Theme\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" Name=\"Placeholder Text\"/>\n  <w:LsdException Locked=\"false\" Priority=\"1\" QFormat=\"true\" Name=\"No Spacing\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1 Accent 1\"/>\n  <w:LsdException Locked=\"false\" SemiHidden=\"true\" Name=\"Revision\"/>\n  <w:LsdException Locked=\"false\" Priority=\"34\" QFormat=\"true\"\n   Name=\"List Paragraph\"/>\n  <w:LsdException Locked=\"false\" Priority=\"29\" QFormat=\"true\" Name=\"Quote\"/>\n  <w:LsdException Locked=\"false\" Priority=\"30\" QFormat=\"true\"\n   Name=\"Intense Quote\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"60\" Name=\"Light Shading Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"61\" Name=\"Light List Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"62\" Name=\"Light Grid Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"63\" Name=\"Medium Shading 1 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"64\" Name=\"Medium Shading 2 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"65\" Name=\"Medium List 1 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"66\" Name=\"Medium List 2 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"67\" Name=\"Medium Grid 1 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"68\" Name=\"Medium Grid 2 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"69\" Name=\"Medium Grid 3 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"70\" Name=\"Dark List Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"71\" Name=\"Colorful Shading Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"72\" Name=\"Colorful List Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"73\" Name=\"Colorful Grid Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"19\" QFormat=\"true\"\n   Name=\"Subtle Emphasis\"/>\n  <w:LsdException Locked=\"false\" Priority=\"21\" QFormat=\"true\"\n   Name=\"Intense Emphasis\"/>\n  <w:LsdException Locked=\"false\" Priority=\"31\" QFormat=\"true\"\n   Name=\"Subtle Reference\"/>\n  <w:LsdException Locked=\"false\" Priority=\"32\" QFormat=\"true\"\n   Name=\"Intense Reference\"/>\n  <w:LsdException Locked=\"false\" Priority=\"33\" QFormat=\"true\" Name=\"Book Title\"/>\n  <w:LsdException Locked=\"false\" Priority=\"37\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" Name=\"Bibliography\"/>\n  <w:LsdException Locked=\"false\" Priority=\"39\" SemiHidden=\"true\"\n   UnhideWhenUsed=\"true\" QFormat=\"true\" Name=\"TOC Heading\"/>\n  <w:LsdException Locked=\"false\" Priority=\"41\" Name=\"Plain Table 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"42\" Name=\"Plain Table 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"43\" Name=\"Plain Table 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"44\" Name=\"Plain Table 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"45\" Name=\"Plain Table 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"40\" Name=\"Grid Table Light\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\" Name=\"Grid Table 1 Light\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\" Name=\"Grid Table 6 Colorful\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\" Name=\"Grid Table 7 Colorful\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"Grid Table 1 Light Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"Grid Table 6 Colorful Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"Grid Table 7 Colorful Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"Grid Table 1 Light Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"Grid Table 6 Colorful Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"Grid Table 7 Colorful Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"Grid Table 1 Light Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"Grid Table 6 Colorful Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"Grid Table 7 Colorful Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"Grid Table 1 Light Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"Grid Table 6 Colorful Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"Grid Table 7 Colorful Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"Grid Table 1 Light Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"Grid Table 6 Colorful Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"Grid Table 7 Colorful Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"Grid Table 1 Light Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"Grid Table 2 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"Grid Table 3 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"Grid Table 4 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"Grid Table 5 Dark Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"Grid Table 6 Colorful Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"Grid Table 7 Colorful Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\" Name=\"List Table 1 Light\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\" Name=\"List Table 6 Colorful\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\" Name=\"List Table 7 Colorful\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"List Table 1 Light Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4 Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"List Table 6 Colorful Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"List Table 7 Colorful Accent 1\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"List Table 1 Light Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4 Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"List Table 6 Colorful Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"List Table 7 Colorful Accent 2\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"List Table 1 Light Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4 Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"List Table 6 Colorful Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"List Table 7 Colorful Accent 3\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"List Table 1 Light Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4 Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"List Table 6 Colorful Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"List Table 7 Colorful Accent 4\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"List Table 1 Light Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4 Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"List Table 6 Colorful Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"List Table 7 Colorful Accent 5\"/>\n  <w:LsdException Locked=\"false\" Priority=\"46\"\n   Name=\"List Table 1 Light Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"47\" Name=\"List Table 2 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"48\" Name=\"List Table 3 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"49\" Name=\"List Table 4 Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"50\" Name=\"List Table 5 Dark Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"51\"\n   Name=\"List Table 6 Colorful Accent 6\"/>\n  <w:LsdException Locked=\"false\" Priority=\"52\"\n   Name=\"List Table 7 Colorful Accent 6\"/>\n </w:LatentStyles>\n</xml><![endif]--><!--[if gte mso 10]>\n<style>\n /* Style Definitions */\n table.MsoNormalTable\n	{mso-style-name:\"Table Normal\";\n	mso-tstyle-rowband-size:0;\n	mso-tstyle-colband-size:0;\n	mso-style-noshow:yes;\n	mso-style-priority:99;\n	mso-style-parent:\"\";\n	mso-padding-alt:0in 5.4pt 0in 5.4pt;\n	mso-para-margin-top:0in;\n	mso-para-margin-right:0in;\n	mso-para-margin-bottom:8.0pt;\n	mso-para-margin-left:0in;\n	line-height:107%;\n	mso-pagination:widow-orphan;\n	font-size:11.0pt;\n	font-family:\"Calibri\",\"sans-serif\";\n	mso-ascii-font-family:Calibri;\n	mso-ascii-theme-font:minor-latin;\n	mso-hansi-font-family:Calibri;\n	mso-hansi-theme-font:minor-latin;\n	mso-bidi-font-family:\"Times New Roman\";\n	mso-bidi-theme-font:minor-bidi;}\n</style>\n<![endif]--></p>\n', '2020-07-28 08:47:46', 'transfer_record (29).xlsx', 'JOHN', 11, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-28 08:47:46', 1, '2020-08-17 05:00:01'),
(10326, 20003, '', '10326', 'E', 1, '<p>\n	Dear Manu....In teh service request menu after filtering and downloading to excel teh result is not matching as per filter. In teh example we selected UAE - JAFZA but teh excel result shows all countries. pls check. Attached pdf.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-30 00:19:29', 'Wrong filtering to excel 30Aug.pdf', 'Javeed Sathar', 7, 12, '2020-09-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-30 00:19:29', 1, '2020-09-08 05:00:02'),
(10246, 20064, '', '10246', 'I', 2, '<p>\n	Support Instalation at FGT</p>\n', '2020-07-29 09:27:20', '', 'JOHN', 191, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-29 09:27:20', 1, '2020-08-17 05:00:01'),
(10264, 20019, '', '10264', 'E', 1, '<p>\n	Bluesky.ae website</p>\n', '2020-08-07 08:28:01', '', 'JOHN', 56, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-07 08:28:01', 1, '2020-08-17 05:00:01'),
(10311, 20001, '', '10311', 'I', 1, '<p>\n	Edit Order - select any terms &amp; conditions, change it , its not saving</p>\n<p>\n	also without selecting a terms, if something is typed, it shows error</p>\n', '2020-08-20 10:54:17', '', 'JOHN', 2, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-20 10:54:17', 1, '2020-08-26 05:00:01'),
(10243, 20001, '', '10243', 'E', 1, '<p>\n	Salary posting issue</p>\n', '2020-07-28 10:17:10', '', 'JOHN', 2, 12, '2020-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-28 10:17:10', 1, '2020-08-03 05:00:01'),
(10244, 20003, '', '10244', 'E', 1, '<p>\n	Dear Manu...pls add : (pdf attached for reference)</p>\n<p>\n	1) Flter of &#39;Inspect Type&#39; on the inspection listings with multiple select</p>\n<p>\n	2) Add multiple select for Assigned to&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-07-28 10:22:06', 'Inspect menu 2.pdf', 'Javeed Sathar', 7, 12, '2020-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-28 10:22:06', 10, '2020-08-03 13:44:28'),
(10245, 20003, '', '10245', 'E', 1, '<p>\n	Dear Manu ...not 100% cleared . pls check pdf attached. some are capital letters and some are small letters.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-07-28 10:29:36', 'email formats82.pdf', 'Javeed Sathar', 7, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-28 10:29:36', 10, '2020-08-16 12:51:39'),
(10247, 20021, '', '10247', 'E', 1, '<p>\n	Website migration</p>\n', '2020-07-29 12:35:31', '', 'JOHN', 62, 12, '2020-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-29 12:35:31', 1, '2020-08-09 05:00:02'),
(10248, 20019, '', '10248', 'E', 1, '<p>\n	Leave Migration system for old leaves</p>\n<p>\n	only the record migration</p>\n', '2020-08-03 11:06:58', '', 'JOHN', 56, 12, '2020-08-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-03 11:06:58', 1, '2020-08-10 05:00:01'),
(10249, 20001, '', '10249', 'I', 1, '<p>\n	Invoice date and time creation - correct in all records in database, change in program, change in audit log etc</p>\n<p>\n	invoice design problem - splitting into 2 pages issue</p>\n', '2020-07-29 11:11:04', '', 'JOHN', 2, 12, '2020-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-03 11:11:04', 1, '2020-08-09 05:00:02'),
(10250, 20003, '', '10250', 'E', 1, '<p>\n	Dear Manu,</p>\n<p>\n	Pls add as attached above on the CAR menu. Pls ignore CAR menu update.pdf . Take into consideration CAR menu update1.pdf</p>\n<p>\n	To add a selection in teh drop down list : Customer Complaint</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-04 10:48:31', 'CAR menu update.pdf,CAR menu update1.pdf', 'Javeed Sathar', 7, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-04 10:48:31', 10, '2020-08-12 11:49:34'),
(10251, 20003, '', '10251', 'E', 1, '<p>\n	Hi Manu,</p>\n<p>\n	Visual reminder in the meeting menu. see attcahed.</p>\n<p>\n	thanks</p>\n', '2020-08-04 10:58:00', 'Meeting menu update1.pdf', 'Javeed Sathar', 7, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-04 10:58:00', 10, '2020-08-12 11:45:43'),
(10252, 20003, '', '10252', 'E', 1, '<p>\n	Hi Manu...continuatio of 10232 service request of Company menu.</p>\n', '2020-08-04 15:32:15', 'Company menu267.pdf', 'Javeed Sathar', 7, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-04 15:32:15', 10, '2020-08-12 11:41:56'),
(10253, 20002, '', '10253', 'E', 2, '<p>\n	When converting from Order to DO , before saving we have to collect two additional information</p>\n<p>\n	1. Delivery Location - Text - Eg Naif , Deira</p>\n<p>\n	2. Delivery Contact&nbsp; - Text - Mr. Muhamed / 050 1234567</p>\n<p>\n	and these should be printed on DO print</p>\n<p>\n	For older DO&#39;s - The field will be blank</p>\n', '2020-08-04 16:45:34', '', 'JOHN', 5, 12, '2020-08-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-04 16:45:34', 1, '2020-08-11 05:00:01'),
(10254, 20019, '', '10254', 'E', 2, '<p>\n	Salary Record Migration in HR</p>\n', '2020-08-05 08:32:09', '', 'JOHN', 56, 12, '2020-12-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-05 08:32:09', 1, '2020-12-17 06:00:02'),
(10255, 20019, '', '10255', 'E', 1, '<p>\n	https://cumuluserp.me/development/demoerp/index.php?r=site/index</p>\n<p>\n	DEMO/demo/demo</p>\n<p>\n	provide support button at LEFT bottom</p>\n', '2020-08-05 10:58:02', '', 'JOHN', 56, 12, '2020-08-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-05 10:58:02', 1, '2020-08-14 05:00:07'),
(10256, 20003, '', '10256', 'E', 1, '<p>\n	Hi Manu...pls increase the height of the cell for recording findings as attached.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-05 16:39:02', 'Inspection Menu 5th Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-05 16:39:02', 10, '2020-08-12 11:44:47'),
(10257, 20003, '', '10257', 'E', 1, '<p>\n	Hi Manu, regarding the Company Menu, continuation of 10252...pls see attcahed to make the features fields dynamic.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-05 16:47:05', 'Company Menu 5th Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-05 16:47:05', 10, '2020-08-12 11:42:04'),
(10258, 20001, '', '10258', 'I', 1, '<p>\n	ACE HR posting issue</p>\n<p>\n	1) Take general Ledger, Select date Range 01/07/20 to 31/07/20</p>\n<p>\n	Select salary Payable account</p>\n<p>\n	9th line missing and the amount 1987.04 wrong (300 something only correct)</p>\n<p>\n	<span style=\"background-color:#ffff00;\">Reason - May be he has pre join deduction aas he is a new employee</span></p>\n<p>\n	2) Salary Paying date (via cash , cheque, sif, exchange) should be collected and this date to be used in posting, now current date is used</p>\n', '2020-08-06 10:06:34', '', 'JOHN', 2, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-06 10:06:34', 1, '2020-08-16 05:00:02'),
(10259, 20001, '', '10259', 'I', 1, '<p>\n	1. Salary Paying date (via cash , cheque, sif, exchange) should be collected and this date to be used in posting, now current date is used</p>\n<p>\n	2. at the payment module, the total has to be displayed at the bottom side, on selection of check box</p>\n<p>\n	(both issues we have discussed over phone)</p>\n', '2020-08-06 10:08:40', '', 'JOHN', 2, 12, '2020-08-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-06 10:08:40', 1, '2020-08-12 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10260, 20001, '', '10260', 'E', 1, '<p>\n	<br />\n	<span style=\"color:#ff0000;\"><u><span style=\"font-size: 18px; cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\">**<span style=\"font-size: 18px; cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\"><b style=\"font-size: 18px; color: rgb(102, 0, 153); cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\"><i>Very</i></b><span style=\"cursor: pointer;\">&nbsp;</span><b style=\"font-size: 18px; color: rgb(102, 0, 153); cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\"><i>Important</i></b></span></span></u></span><u><span style=\"font-size: 18px; cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\"><span style=\"font-size: 18px; cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\"><b style=\"font-size: 18px; color: rgb(102, 0, 153); cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\"><i></i></b></span></span></u><span style=\"color:#ff0000;\"><u><span style=\"font-size: 18px; cursor: pointer; text-decoration-line: none; font-family: arial, sans-serif;\">***</span></u></span></p>\n<p>\n	<span style=\"color:#ffffff;\"><span style=\"font-size:14px;\"><span style=\"font-family: Ubuntu, sans-serif; text-transform: capitalize;\"><span style=\"background-color:#ff0000;\">In The Hire Inventory, We Are Not Able To See In Which Rack The Spare Parts Are Stored.&nbsp;</span></span></span></span></p>\n<p>\n	<span style=\"color:#ffffff;\"><span style=\"font-size:14px;\"><span style=\"background-color:#ff0000;\">Case # 10149. We are waiting for morethan one month</span></span></span></p>\n<p>\n	&nbsp;</p>\n', '2020-08-06 10:44:33', '', 'Acecentro User', 1, 12, '2020-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-08-06 10:44:33', 1, '2020-08-23 05:00:03'),
(10261, 20001, '', '10261', 'E', 1, '<p>\n	<span style=\"color:#ff0000;\"><span style=\"font-family: Ubuntu, sans-serif; font-size: 14.3px; white-space: nowrap; background-color: rgb(245, 245, 245);\">**Re creating***<br />\n	Stock value is not updating properly Case # 10215</span></span></p>\n', '2020-08-06 10:47:05', '', 'Acecentro User', 1, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-08-06 10:47:05', 1, '2021-03-07 06:00:02'),
(10262, 20002, '', '10262', 'E', 1, '<p>\n	When the sales invoice amount (FOC) is posted, customer name and lead owner name not showing</p>\n', '2020-08-06 16:57:09', '', 'JOHN', 5, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-06 16:57:09', 1, '2020-08-16 05:00:02'),
(10263, 20002, '', '10263', 'E', 1, '<p>\n	Stock cheking module</p>\n', '2020-08-06 17:48:35', '', 'JOHN', 5, 12, '2020-11-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-06 17:48:35', 1, '2020-11-25 06:00:02'),
(10265, 20019, '', '10265', 'E', 1, '<p>\n	New report in support</p>\n<p>\n	(see attched File)</p>\n', '2020-08-08 09:14:47', 'report in support.docx', 'JOHN', 56, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-08 09:14:47', 1, '2020-08-16 05:00:02'),
(10266, 20020, '', '10266', 'E', 5, '<p>\n	Software &amp; Mobile App integration</p>\n', '2020-08-08 15:37:45', '', 'JOHN', 59, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2020-08-08 15:37:45', 1, '2022-07-29 05:00:04'),
(10267, 20042, '', '10267', 'E', 1, '<p>\n	Dear Team</p>\n<div>\n	&nbsp;</div>\n<div>\n	Please note the attached statement&nbsp;&nbsp;J1/8992 - J1/6669 showing negative figures&nbsp;.</div>\n<div>\n	&nbsp;</div>\n<p>\n	Pls rectify urgently</p>\n<br clear=\"all\" />\n<div>\n	&nbsp;</div>\n<p>\n	--</p>\n<br />\n<div>\n	<font color=\"#0000ff\" face=\"georgia, serif\" size=\"4\"><b>Anil.D.Vijay</b></font></div>\n<div>\n	<font color=\"#0000ff\" face=\"georgia, serif\">Managing Partner&nbsp;</font></div>\n<div>\n	<font color=\"#0000ff\" face=\"georgia, serif\">Lebeaute</font></div>\n<div>\n	<br />\n	<br />\n	&nbsp;</div>\n', '2020-08-08 17:17:46', '', 'JOHN', 125, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-08 17:17:46', 1, '2020-08-16 05:00:02'),
(10268, 20002, '', '10268', 'E', 1, '<p>\n	Inventory search for 354-SSCSC02</p>\n<p>\n	in the gid @PO quantity it shows -620</p>\n<p>\n	click the deallocate &amp;pO detail</p>\n<p>\n	in the PO section, see the error</p>\n<p>\n	Actually PO 600731 (File ID 25806), This material is received in MR701579</p>\n<p>\n	&nbsp;</p>\n', '2020-08-09 14:56:54', 'norden090820.png', 'JOHN', 5, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-09 14:56:54', 1, '2020-08-16 05:00:02'),
(10269, 20002, '', '10269', 'E', 1, '<p>\n	Please change lead owner to Hameed Faisel in Quote File 34207</p>\n', '2020-08-09 16:19:22', '', 'Sobha Cherian', 4, 12, '2020-08-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-08-09 16:19:22', 1, '2020-08-15 05:00:01'),
(10270, 20032, '', '10270', 'E', 1, '<p>\n	Data Migration</p>\n', '2020-08-09 18:01:31', '', 'JOHN', 95, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-09 18:01:31', 1, '2020-08-16 05:00:02'),
(10275, 20004, '', '10275', 'E', 1, '<p>\n	Check and correct the out bound Delivery note with and without zero connecting in background Eg: 049389 &amp; 49389, Pre invoice 49301</p>\n', '2020-08-11 11:08:37', '', 'JOHN', 11, 12, '2020-09-22', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-08-11 11:08:37', 1, '2020-09-22 05:00:01'),
(10271, 20001, '', '10271', 'E', 1, '<p>\n	BHUSHAN BANSODE</p>\n<p>\n	please remove july&nbsp; annual leave to Absent&nbsp; for the following days</p>\n<p>\n	Bhushan - 1,14,,16,19,21,23,26,28&nbsp; AL-&gt;AB</p>\n', '2020-08-10 16:08:49', '', 'JOHN', 2, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-10 16:08:49', 1, '2020-08-16 05:00:02'),
(10272, 20001, '', '10272', 'E', 1, '<p>\n	Go to Purchase Order</p>\n<p>\n	Search for File Id 1363 / PO 600012</p>\n<p>\n	Take the print Menu</p>\n<p>\n	2 options</p>\n<p>\n	1. Print with Part number rename to print with OEM number</p>\n<p>\n	2. Print with OEM number rename to print with part number</p>\n<p>\n	---</p>\n<p>\n	when the PO is converting to MR</p>\n<p>\n	In the detail tab, in item now oem number is coming, can you show the part numner also there?</p>\n', '2020-08-10 17:47:33', '', 'JOHN', 2, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-10 17:47:33', 1, '2020-08-17 05:00:01'),
(10273, 20028, '', '10273', 'E', 1, '<p>\n	Real Estate DB change</p>\n', '2020-08-11 09:23:34', '', 'JOHN', 83, 12, '2020-08-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 09:23:34', 1, '2020-08-18 05:00:02'),
(10274, 20048, '', '10274', 'E', 1, '<p>\n	ENV-HCV5F-30R-17 is showing 5nos free Qty in Inventory , but in stock ledger it is only 1 no.</p>\n', '2020-08-11 10:34:39', 'hcv5f.png', 'JOHN', 5, 12, '2020-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 10:34:39', 1, '2020-08-25 05:00:02'),
(10276, 20004, '', '10276', 'E', 1, '<p>\n	Need another report&nbsp; same as - outbound report - Export Shipment Report</p>\n<p>\n	name it as export shipment report - BL date</p>\n<p>\n	thedate filter should take BL date into consideration</p>\n<p>\n	In the final invoice, when BOE date is entered , copy same to BL date (Make it mandatory also)</p>\n', '2020-08-11 11:17:55', '', 'JOHN', 11, 12, '2020-08-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 11:17:55', 1, '2020-08-18 05:00:02'),
(10277, 20019, '', '10277', 'E', 2, '<p>\n	Employee Visa , stamping expence calculator</p>\n', '2020-08-11 11:38:27', 'Expence calc.xlsx', 'JOHN', 56, 12, '2020-08-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 11:38:27', 1, '2020-08-24 05:00:02'),
(10278, 20004, '', '10278', 'E', 2, '<p>\n	Check the possibility of displaying quantity of item in inventory grid or inventory edit window</p>\n', '2020-08-11 11:52:14', '', 'JOHN', 11, 12, '2020-08-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 11:52:14', 1, '2020-08-18 05:00:02'),
(10279, 20001, '', '10279', 'I', 1, '<p>\n	ACE 05-02-00210<br />\n	inventory item<br />\n	Serial no 1412150500... showing on site<br />\n	but in Hire dashboard, no such machine<br />\n	<br />\n	&nbsp;</p>\n', '2020-08-11 12:24:54', '', 'JOHN', 2, 12, '2020-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 12:24:54', 1, '2020-08-23 05:00:03'),
(10280, 20062, '', '10280', 'I', 1, '<p>\n	in ARK login, replace &quot;Ace Enterprises &quot; with &quot; ARK Enterprises&quot; in all printouts signing area</p>\n<p>\n	Eg, DO, Order, Invoice etc etc</p>\n', '2020-08-11 17:29:20', '', 'JOHN', 185, 12, '2020-08-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-11 17:29:20', 1, '2020-08-18 05:00:02'),
(10281, 20002, '', '10281', 'E', 1, '<p>\n	Kindly note we cannot see the material PO qty&rsquo;s in Inventory for all new LPO&rsquo;s, Please find below screenshots of new LPO line item 1 &amp;2.</p>\n<p>\n	Please look into this matter very urgently as we cannot track the ordered qty in inventory.</p>\n', '2020-08-12 09:54:16', 'norden1208.jpg', 'JOHN', 5, 12, '2020-08-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-12 09:54:16', 1, '2020-08-19 05:00:01'),
(10282, 20001, '', '10282', 'E', 1, '<p>\n	Employee PPE Report needed, with date range filter, employee filter,</p>\n<p>\n	reference, employee name , cost, date of issue needed</p>\n<p>\n	PDF &amp; Excel needed</p>\n<p>\n	Same Header &amp; Footer to be used</p>\n', '2020-08-12 11:02:51', '', 'JOHN', 2, 12, '2020-08-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-12 11:02:51', 1, '2020-08-22 05:00:02'),
(10283, 20003, '', '10283', 'E', 1, '<p>\n	Dear Manu,</p>\n<p>\n	Continuation of compnay menu...10257. Some spelling and title corrections. after this pls tracfser the menu to teh main desktop.</p>\n<p>\n	thanks,</p>\n', '2020-08-12 11:44:30', 'Company Menu 12th Aug92.pdf', 'Javeed Sathar', 7, 12, '2020-08-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-12 11:44:30', 10, '2020-08-13 17:36:07'),
(10284, 20003, '', '10284', 'E', 1, '<p>\n	Dear Manu,</p>\n<p>\n	Attachment for 10245 regarding the correction of email header format.</p>\n<p>\n	thanks,</p>\n', '2020-08-12 11:53:26', 'Email header format correction.pdf', 'Javeed Sathar', 7, 12, '2020-08-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-12 11:53:26', 10, '2020-08-13 17:36:49'),
(10292, 20003, '', '10292', 'E', 1, '<p>\n	Dear Manu...pls fix this bug on teh listings page of CAR menu. See attached pdf.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-16 12:51:12', 'CAR listings bug 16th Aug 2020.pdf', 'Javeed Sathar', 7, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-16 12:51:12', 0, '2020-08-17 11:11:24'),
(10285, 20062, '', '10285', 'E', 1, '<p>\n	Change the footer for ARK</p>\n<p>\n	<span style=\"left: 98.1533px; top: 1345.09px; font-size: 12.5px; font-family: sans-serif; transform: scaleX(0.99978);\">This invoice has been electronically generated by ARK Engineering Services (ARK) on 11/08/2020 03:35:27 pm and is valid without signature.</span></p>\n', '2020-08-12 12:03:42', 'ark footer.png', 'JOHN', 185, 12, '2021-07-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-12 12:03:42', 1, '2021-07-02 05:00:05'),
(10286, 20048, '', '10286', 'E', 1, '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n	<tbody>\n		<tr>\n			<td style=\"width:312px;\">\n				<p>\n					ENV-HVD7M-30R-16</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p style=\"margin-left:.5in;\">\n	the below model camera &nbsp;we have sold out the entire quantity &nbsp;last month but the quantity is still&nbsp; showing in the inventory page .</p>\n<p style=\"margin-left:.5in;\">\n	&nbsp;</p>\n<p style=\"margin-left:.5in;\">\n	In the &nbsp;transaction details page showing balance quantity as Zero, but in the inventory page showing 20 nos. Please solve this issue ASAP.&nbsp;</p>\n<p style=\"margin-left:.5in;\">\n	&nbsp;</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:623px;\" width=\"623\">\n	<tbody>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					Part Code</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					ENV-HVD7M-30R-16</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					Purchase Bonded invoice &nbsp;Date</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					13/06/2019</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					Purchase &nbsp;Qty</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					20 Nos</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					Outbound Date</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					22/07/2020</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					Sale Qty</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					20 Nos</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					Sale Date</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					24/07/2020</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"width:311px;\">\n				<p>\n					CRM invoice number</p>\n			</td>\n			<td style=\"width:311px;\">\n				<p>\n					400956</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2020-08-12 14:51:50', '', 'Shabil -', 142, 12, '2020-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2020-08-12 14:51:50', 1, '2020-08-25 05:00:02'),
(10287, 20019, '', '10287', 'E', 1, '<p>\n	DEMO ERP&nbsp; HR Needs following</p>\n<p>\n	Notification</p>\n<p>\n	Purchase request</p>\n<p>\n	Expence</p>\n<p>\n	expence from request to be moved under employee and rename as Expence Submission</p>\n', '2020-08-12 15:56:22', '', 'JOHN', 56, 12, '2020-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-12 15:56:22', 1, '2020-08-23 05:00:03'),
(10288, 20008, '', '10288', 'E', 1, '<p>\n	please check policy numbers <span style=\"font-size:9.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;background:white\"> 6225322 and </span><span style=\"font-size:9.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;background:whitesmoke\">6293727 as the uploaded documents are in ZIP file.</span></p>\n', '2020-08-13 16:31:42', '', 'JOHN', 23, 12, '2020-09-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-13 16:31:42', 1, '2020-09-14 05:00:02'),
(10289, 20003, '', '10289', 'E', 1, '<p>\n	Dear Manu...Company&#39;s master menu is showing error while creating the master listings...see attached.</p>\n', '2020-08-13 17:35:11', 'Company\'s Master Menu 13th Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-13 17:35:11', 10, '2020-08-16 12:51:27'),
(10290, 20004, '', '10290', 'E', 1, '<p>\n	Please note below screen shot for GMC ZY32560 . We are not able to generate DA because less quantity available</p>\n<p>\n	We did investigation and noticed that order no. 51011 has an issue. Two times out entry is showing instead of one</p>\n', '2020-08-15 12:50:33', '', 'JOHN', 11, 12, '2020-09-22', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-08-15 12:50:33', 1, '2020-09-22 05:00:01'),
(10291, 20002, '', '10291', 'I', 1, '<p>\n	Item No NAC-1201RC purchase 110 qty at 0.00, purchased 100 qty at 0.33 fils, and debit note for 100 @0.33, stock as of report showa 110 qt @0.00</p>\n', '2020-08-16 08:15:26', '', 'JOHN', 5, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-08-16 08:15:26', 1, '2022-07-29 05:00:04'),
(10293, 20003, '', '10293', 'E', 1, '<p>\n	Dear Manu...pls delete attached obsolete data from employee menu...thanks !!</p>\n', '2020-08-16 17:28:44', 'Employee Menu to delete obsolete data.pdf', 'Javeed Sathar', 7, 12, '2020-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-16 17:28:44', 0, '2020-08-17 11:11:34'),
(10294, 20001, '', '10294', 'E', 1, '<p>\n	Small small issues like, serial number change, old sold machine , hire inventory damage machine colour etc</p>\n', '2020-08-17 10:24:38', '', 'JOHN', 2, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-17 10:24:38', 1, '2020-08-26 05:00:01'),
(10295, 20003, '', '10295', 'E', 1, '<p>\n	Dear Manu...there is a bug on service request menu : Under &#39;Country&#39; and &#39;Location&#39;. The &#39;Location&#39; selection disappears and is not be saved until the country is unslected and reselected. Only then teh entry is allowed to be saved. pls check.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-17 11:14:01', '', 'Javeed Sathar', 7, 12, '2020-08-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-17 11:14:01', 10, '2020-08-19 20:52:14'),
(10296, 20014, '', '10296', 'E', 1, '<p>\n	when the payment is saved, another new blank payment voucher should load</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 24624 characters]\" /></p>\n', '2020-08-17 11:14:22', '', 'JOHN', 41, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-08-17 11:14:22', 1, '2022-07-29 05:00:04'),
(10297, 20014, '', '10297', 'E', 1, '<p>\n	Admin Transaction Report - Sales manfilter- Excel Download problem</p>\n', '2020-08-17 17:53:01', '', 'JOHN', 41, 12, '2020-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-17 17:53:01', 1, '2020-08-23 05:00:03'),
(10299, 20019, '', '10299', 'E', 3, '<p>\n	E Sell New</p>\n<p>\n	outlet 1 customer/vendor showing in Outlet 2 sale/purchaseDebit</p>\n<p>\n	check credit note date &gt;=sales&nbsp; invoice date</p>\n<p>\n	check Debit Note date &gt;= Purchase Invoice Date</p>\n<p>\n	&nbsp;</p>\n', '2020-08-18 09:03:51', '', 'JOHN', 56, 12, '2020-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-18 09:03:51', 1, '2020-08-25 05:00:02'),
(10300, 20001, '', '10300', 'E', 1, '<p>\n	Hiring Transaction Ledger</p>\n<p>\n	need a&nbsp; customer name &amp; serial Number coloumn (if any)</p>\n', '2020-08-18 10:00:20', '', 'JOHN', 2, 12, '2020-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-18 10:00:20', 1, '2020-08-25 05:00:02'),
(10301, 20002, '', '10301', 'E', 1, '<p>\n	We are not able to remove special handling charges from below LPO. Please remove it from LPO to get LPO approval.</p>\n<p>\n	PO <span style=\"font-size:10.5pt;font-family:Ubuntu\">601112</span></p>\n<p class=\"MsoNormal\">\n	<span style=\"font-size:10.5pt;font-family:Ubuntu\">File ID 37292</span></p>\n<p>\n	UNV Digital Technologies Company Limited</p>\n<p class=\"MsoNormal\">\n	&nbsp;</p>\n', '2020-08-18 15:29:49', '', 'JOHN', 5, 12, '2020-08-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-18 15:29:49', 1, '2020-08-24 05:00:02'),
(10302, 20007, '', '10302', 'E', 1, '<p>\n	Outstanding Report correction</p>\n', '2020-08-19 09:35:30', '', 'JOHN', 20, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-19 09:35:30', 1, '2020-08-26 05:00:01'),
(10303, 20019, '', '10303', 'E', 1, '<p>\n	E Sell New</p>\n<p>\n	1. Order taking consolidation etc (see attached file)</p>\n<p>\n	2, at the time of sale , display available quantity in his warehouse as a label</p>\n', '2020-08-19 09:46:48', 'E Sell order taking.xlsx', 'JOHN', 56, 12, '2020-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-19 09:46:48', 1, '2020-09-01 05:00:01'),
(10304, 20002, '', '10304', 'E', 1, '<p>\n	Hi John,</p>\n<p>\n	As discussed can I get a report of all the items quoted with unit price for Al Rashid Trading &amp; Contracting Co.Ltd. Consider only those quotes which are in AED .&nbsp;</p>\n', '2020-08-19 12:30:04', '', 'Sobha Cherian', 4, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-08-19 12:30:04', 1, '2020-08-26 05:00:01'),
(10305, 20006, '', '10305', 'E', 1, '<p class=\"MsoNormal\">\n	Please unallocate the below vouchers immediately, so as to clear the outstanding of our sales staff.</p>\n<p class=\"MsoNormal\">\n	&nbsp;04/08/2020 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AG/280593</p>\n<p>\n	09/08/2020 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AG/280629</p>\n', '2020-08-19 15:53:59', '', 'JOHN', 17, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-19 15:53:59', 1, '2020-08-26 05:00:01'),
(10306, 20019, '', '10306', 'E', 1, '<p>\n	Training Module</p>\n', '2020-08-18 12:00:54', '', 'JOHN', 56, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-19 16:00:54', 1, '2020-08-26 05:00:01'),
(10307, 20003, '', '10307', 'E', 1, '<p>\n	Dear Manu....in the Facility Menu : The Notify mails are not going for Documents and Records.</p>\n<p>\n	Plus the visibility of selected names to improve. See attcahed sheet.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-19 20:51:48', 'Facility Menu 19 aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-19 20:51:48', 1, '2020-08-28 05:00:04'),
(10308, 20003, '', '10308', 'E', 1, '<p>\n	Dear Manu...can we gave the option to upload Outlook mail formats...?</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks</p>\n', '2020-08-19 20:54:56', 'CAR upload format 19 Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-19 20:54:56', 1, '2020-08-26 05:00:01'),
(10309, 20003, '', '10309', 'E', 1, '<p>\n	Dear Manu...pls increse the size of upload feature...on Records and Documents..thanks!! see attached.</p>\n', '2020-08-19 20:58:23', 'Facility Menu upload size 19 Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-19 20:58:23', 1, '2020-08-26 05:00:01'),
(10310, 20003, '', '10310', 'E', 1, '<p>\n	Dear Manu...pls add excel download feature in the Service menu...see attached.</p>\n', '2020-08-19 21:01:23', 'Service request Menu download feature 19 Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-19 21:01:23', 1, '2020-08-26 05:00:01'),
(10312, 20003, '', '10312', 'E', 1, '<p>\n	Dear Manu...pls see attached pdf on a issue in SOP screen with the back button...thanks!!</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2020-08-20 11:10:14', 'SOP back button 20 Aug.pdf', 'Javeed Sathar', 7, 12, '2020-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-20 11:10:14', 1, '2020-08-26 05:00:01'),
(10313, 20007, '', '10313', 'E', 1, '<p>\n	Purchase payment amount entered is correct and says amounts are not matching. Pls fix this as well</p>\n<p>\n	see attached sreenshot</p>\n', '2020-08-20 11:21:39', 'fst200820.jpg', 'JOHN', 20, 12, '2020-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-20 11:21:39', 1, '2020-09-01 05:00:01'),
(10314, 20048, '', '10314', 'E', 1, '<p>\n	Need to amend the report with the below points.</p>\n<ul>\n	<li>\n		Total quantity &amp; total value are showing for the category 181-365 days and &gt;365 days are not correct.</li>\n	<li>\n		Add one column to the right of total bond value, that shows total bond value*total bond qty</li>\n	<li>\n		Change the title total bond value to bond value and name the new column as Total bond value.</li>\n	<li>\n		Need to show all columns total below</li>\n</ul>\n', '2020-08-24 08:08:10', '', 'JOHN', 143, 12, '2020-08-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-24 08:08:10', 1, '2020-08-31 05:00:01'),
(10315, 20049, '', '10315', 'E', 1, '<p>\n	Quotation Approval Button</p>\n<p>\n	After approval only convert and print</p>\n<p>\n	show a margin (profit) button and printout - for a comparison of sales Price (taken from current quotation) and cost price ( (Taken live from system at time of margin checking)</p>\n<p>\n	&nbsp;</p>\n', '2020-08-24 15:49:28', '', 'JOHN', 146, 12, '2020-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-24 15:49:28', 1, '2020-09-04 05:00:08'),
(10316, 20028, '', '10316', 'E', 1, '<p>\n	Mumayaz VT 0 HR</p>\n<p>\n	unlock July salary</p>\n', '2020-08-24 16:04:33', '', 'JOHN', 83, 12, '2020-09-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-24 16:04:33', 69, '2020-09-06 09:42:27');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10317, 20002, '', '10317', 'E', 1, '<p>\n	Please sort the below inventory problem for item 132T-278822GY. Should be zero stock but showing 1 piece in inventory query.</p>\n', '2020-08-24 17:09:55', 'norden240820-1.jpg,norden240820.jpg', 'JOHN', 5, 12, '2020-08-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-24 17:09:55', 1, '2020-08-31 05:00:01'),
(10318, 20049, '', '10318', 'E', 1, '<p>\n	Your attention is invited to LPO no 60001 as attached and Quote Number&nbsp;<span style=\"background-color: rgb(245, 245, 245);\"><font face=\"Ubuntu, sans-serif\" style=\"background-color: inherit;\"><span style=\"font-size: 14.300000190734863px; white-space: nowrap;\">10635. &nbsp;The LPO has been made in currency USD and normally while taking stock in it has to convert to GBP. &nbsp;Unfortunately its&nbsp;coming in USD. &nbsp;Please have a look and take necessary step to correct the same.</span></font></span></p>\n', '2020-08-25 17:47:23', '', 'JOHN', 146, 12, '2020-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-25 17:47:23', 1, '2020-09-04 05:00:08'),
(10319, 20019, '', '10319', 'E', 1, '<p>\n	Passport ID/ Emirates ID scanner configuration</p>\n', '2020-08-25 08:15:10', '', 'JOHN', 56, 12, '2020-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-25 08:15:10', 1, '2020-09-01 05:00:01'),
(10320, 20019, '', '10320', 'E', 2, '<p>\n	HR software - Gratuity - Limited/ unlimited quantity</p>\n', '2020-08-26 08:34:57', '', 'JOHN', 56, 12, '2020-09-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-26 08:34:57', 1, '2020-09-09 05:00:02'),
(10321, 20002, '', '10321', 'E', 1, '<p>\n	Disabled customers - not needed in finance new voucher entries</p>\n', '2020-08-26 10:05:55', '', 'JOHN', 5, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-08-26 10:05:55', 1, '2022-07-29 05:00:04'),
(10322, 20019, '', '10322', 'E', 5, '<p>\n	ERPlite -&nbsp; Aplha finance integration</p>\n', '2020-08-26 12:59:51', '', 'JOHN', 56, 12, '2020-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-26 12:59:51', 1, '2020-09-12 05:00:02'),
(10323, 20003, '', '10323', 'E', 1, '<p>\n	Dear Manu, pls ensure for Inpsection meny where we combine teh rpeorts teh CAR references should appear automatically as attcahed pdf.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-26 16:16:31', 'Inspection summary issue 26 Aug.pdf', 'Javeed Sathar', 7, 12, '2020-09-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-26 16:16:31', 1, '2020-09-09 05:00:02'),
(10324, 20003, '', '10324', 'E', 1, '<p>\n	Dear Manu, pls see some improvements for the inspection menu as attcached.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-26 16:17:07', 'Inspection menu 26th Aug.pdf', 'Javeed Sathar', 7, 12, '2020-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-26 16:17:07', 1, '2020-09-04 05:00:08'),
(10325, 20003, '', '10325', 'E', 1, '<p>\n	Facility Mail -</p>\n', '2020-08-27 17:13:50', '', 'JOHN', 8, 12, '2020-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-08-27 17:13:50', 1, '2020-09-04 05:00:08'),
(10327, 20003, '', '10327', 'E', 1, '<p>\n	Dear Manu...i have sent an email on 30th Aug about changing fonts in teh service menu and asset menu. Pls chekc and revert.</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n', '2020-08-30 00:20:36', '', 'Javeed Sathar', 7, 12, '2020-09-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-30 00:20:36', 1, '2020-09-08 05:00:02'),
(10328, 20003, '', '10328', 'E', 1, '<p>\n	Dear John, Manu... Facility Records deletion is not working. After deletion records are still appearing..pls check..thanks</p>\n', '2020-08-30 12:34:27', 'Facility Records deletion not working.pdf', 'Javeed Sathar', 7, 12, '2020-09-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-08-30 12:34:27', 1, '2020-09-08 05:00:02'),
(10329, 20036, '', '10329', 'I', 1, '<p>\n	<span style=\"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D\">Please find below and kindly do the needful fix. I spend 30 mins. Looking for the error why my audit was mismatching. I found out that on the Main View of the available qty of the table shows 384 box while upon clicking the action button &ldquo;Availability&rdquo; it&rsquo;s showing the correct stock which is 382. Why I am getting discrepancies of 2 box?</span></p>\n', '2020-09-01 08:07:51', 'hayat010920.png', 'JOHN', 107, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-09-01 08:07:51', 1, '2022-07-29 05:00:04'),
(10330, 20013, '', '10330', 'E', 1, '<p>\n	Customer currency change to USD for Non UAE customers</p>\n', '2020-09-01 08:08:56', '', 'JOHN', 38, 12, '2020-09-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-01 08:08:56', 1, '2020-09-07 05:00:02'),
(10331, 20019, '', '10331', 'E', 1, '<p>\n	Alpha- Remove the printer footer</p>\n', '2020-09-01 08:40:53', '', 'JOHN', 56, 12, '2020-09-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-01 08:40:53', 1, '2020-09-09 05:00:02'),
(10342, 20065, '', '10342', 'E', 2, '<p>\n	HR Instalation</p>\n', '2020-09-07 12:30:49', '', 'JOHN', 194, 12, '2020-12-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-07 12:30:49', 1, '2020-12-15 06:00:01'),
(10332, 20007, '', '10332', 'E', 1, '<p>\n	Receipt - report correction</p>\n', '2020-09-01 12:04:47', '', 'JOHN', 20, 12, '2020-09-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-01 12:04:47', 1, '2020-09-18 05:00:04'),
(10333, 20022, '', '10333', 'E', 1, '<p>\n	Kindly change as per the attached file.Telephone number and TRN as same.</p>\n<div>\n	<br />\n	<br />\n	&nbsp;</div>\n', '2020-09-01 12:09:27', 'CHANGES-1.pdf', 'JOHN', 65, 12, '2020-09-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-01 12:09:27', 1, '2020-09-07 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10334, 20013, '', '10334', 'E', 1, '<p>\n	NB141207-000DR - Opening Balance is in negative (-1).&nbsp;</p>\n<p>\n	Fix to 0 as Opening Balance</p>\n<p>\n	&nbsp;</p>\n<p>\n	Also, ensure to check all other items 0 as Opening Balance incase of any negative.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65277 characters]', '2020-09-02 15:03:10', 'NB141207-000DR_Transaction.pdf', 'Ramachandiran V', 37, 12, '2020-10-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-09-02 15:03:10', 1, '2020-10-26 06:00:02');
