CREATE TABLE `item` (
  `item_id` int(11) NOT NULL,
  `item_name` varchar(45) DEFAULT NULL,
  `item_name_arabic` varchar(255) DEFAULT NULL,
  `income_ledger_ref` int(11) DEFAULT NULL,
  `expense_ledger_ref` int(11) DEFAULT NULL,
  `inventory_ledger_ref` int(11) DEFAULT NULL,
  `item_code` varchar(200) DEFAULT NULL,
  `item_type_ref` int(11) DEFAULT NULL,
  `item_category_ref` int(11) DEFAULT NULL,
  `uom_ref` int(11) DEFAULT NULL,
  `inventory_status` enum('service','inventory') DEFAULT NULL,
  `cost_price` decimal(10,2) DEFAULT '0.00',
  `sell_price` decimal(10,2) DEFAULT '0.00',
  `available_stock` varchar(45) DEFAULT NULL,
  `alert_point` int(11) DEFAULT NULL,
  `remark` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `vatable` tinyint(1) NOT NULL DEFAULT '1',
  `is_pos_visible` tinyint(1) DEFAULT '0',
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `item`
--

INSERT INTO `item` (`item_id`, `item_name`, `item_name_arabic`, `income_ledger_ref`, `expense_ledger_ref`, `inventory_ledger_ref`, `item_code`, `item_type_ref`, `item_category_ref`, `uom_ref`, `inventory_status`, `cost_price`, `sell_price`, `available_stock`, `alert_point`, `remark`, `created_date`, `is_active`, `vatable`, `is_pos_visible`, `is_deleted`) VALUES
(1, 'Fresh Cooled AI-1', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, 'service', 0.00, 1000.00, NULL, NULL, NULL, '2017-09-19 00:00:00', 1, 1, 0, NULL),
(2, 'Frozen Semen AI-3', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 0.00, 4000.00, NULL, NULL, NULL, '2017-09-19 00:00:00', 1, 1, 0, NULL),
(3, 'Semen Collection', 'خدمة تجميع السائل المنوي', NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 0.00, 500.00, NULL, NULL, NULL, '2017-10-09 00:00:00', 1, 1, 0, NULL),
(47, 'SAVIO', 'سافيو', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(48, 'MAHRANI HDM', 'مهراني اتش دي أم', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(49, 'MAGIC OF SHWAN', 'ماجيك أوف شاوان', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(50, 'PA PASCHAL', 'بي أية باسكال', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(51, 'MYSTICA STRIKE', 'ميستيكا ستريك', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(52, 'NESJ EL MACHIATTO', 'نيسج إل ماكياتو', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(53, 'MP MAGISTRATE', 'أم بي ماجيستريت', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(54, 'M. RAED', 'أم رائد', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(55, 'KAMSIN RODAN', 'كامسين رودان', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(56, 'AREEB AL SHAQAB', 'عريب الشقب', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(57, 'PRUSSIA MI', 'بروسيا أم اي', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(58, 'AL ASEEL', 'الأصيل', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(59, 'ETERNAL WISH-D', 'أتيرنال ويش - دي', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(60, 'JUST OF GLORY V', 'جيست او جلوريا في', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(61, 'CETULION', 'سيتوليون', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(63, 'HADIDY AL SHAQAB', 'حديدي الشقب', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(64, 'ABHA QATAR', 'أبها قطر', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(65, 'EDEN C', 'إيدنسي', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-13 00:00:00', 1, 1, 0, NULL),
(66, 'SAMEH AL RAYYAN', 'سامح الريان', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-14 00:00:00', 1, 1, 0, NULL),
(67, 'JUWEL OS', 'جويل  اوه  اس', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-14 00:00:00', 1, 1, 0, NULL),
(68, 'Doze _ ( ABHA QATAR )', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2017-12-29 00:00:00', 1, 1, 0, NULL),
(69, 'Doze _ ( HADIDY AL SHAQAB )', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2017-12-29 00:00:00', 1, 1, 0, NULL),
(70, 'Doze _ ( EDEN C )', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2017-12-29 00:00:00', 1, 1, 0, NULL),
(72, 'FUERTE', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-30 00:00:00', 1, 1, 0, NULL),
(73, 'EXCALIBUR EA', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-30 00:00:00', 1, 1, 0, NULL),
(74, 'Doze _ ( MAGIC OF SHWAN )', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2017-12-30 00:00:00', 1, 1, 0, NULL),
(75, 'COLINERO', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-30 00:00:00', 1, 1, 0, NULL),
(76, 'SHANGHAI EA', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2017-12-30 00:00:00', 1, 1, 0, NULL),
(77, 'ET Fresh/Frozen AI-2', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 10000.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(78, '30 Days PRegnancy', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 10000.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(79, 'Recipient Lease', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 10000.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(80, 'Foal Assistance', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 2000.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(81, 'Shoeing', NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, NULL, NULL, 300.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(82, 'Trim', NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, NULL, NULL, 120.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(83, 'Dental Services for Mare', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 500.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(84, 'Dental Services for Stallion', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 700.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(85, 'Boarding Monthly for Mare', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 2000.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(86, 'Boarding Monthly for Mare with Filly/Colt', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 2300.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(87, 'Boarding Monthly for Stallion', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 2300.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(88, 'Boarding Monthly for Recipient Mare', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 1200.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(89, 'Boarding Daily for Mare (More Than 10 Days)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 66.67, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(90, 'Boarding Daily Mare with Filly/Colt (10D Up)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 76.67, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(91, 'Boarding Daily for Stallion (10Days Up)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 76.67, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(92, 'Boarding Daily for Recipient Mare (10Days Up)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 40.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(93, 'Boarding Daily for Mare (Less Than 10 Days)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 75.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(94, 'Boarding Daily Mare with Filly/Colt(Less 10D)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 100.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(95, 'Boarding Daily for Stallion(Less than 10Days)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 100.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(96, 'Boarding Daily Recipient (Less than 10 Days)', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 40.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(97, 'Training Monthly for Stallion ', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 5000.00, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(98, 'Training Daily for Mare/Stallion/Filly/Colt', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 166.67, NULL, NULL, NULL, '2017-12-31 00:00:00', 1, 1, 0, NULL),
(99, 'M Lavage', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 200.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(100, 'M Palpation & Ultrasound', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 75.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(101, 'M Vulvoplastia', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 200.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(102, 'M Vac Rhinopneumo', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 200.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(103, 'M Prostin', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 50.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(104, 'M Deslorelin', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 110.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(105, 'M Oxytocin', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 10.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(106, 'M Dexa.', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 10.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(107, 'M Chorolun', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 120.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(108, 'M Regumate', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 100.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(109, 'M P4 Doze', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 120.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(110, 'M P4 Bottle', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 1600.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(111, 'M Plasma', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 1500.00, NULL, NULL, NULL, '2018-01-01 00:00:00', 1, 1, 1, NULL),
(112, 'M Swab', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 200.00, NULL, NULL, NULL, '2018-01-02 00:00:00', 1, 1, 1, NULL),
(113, 'M Horse Treatment', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2018-01-02 00:00:00', 1, 1, 0, NULL),
(114, 'M Doctor Fee', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 300.00, NULL, NULL, NULL, '2018-01-02 00:00:00', 1, 1, 0, NULL),
(115, 'FALAH AL THANI', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-02 00:00:00', 1, 1, 0, NULL),
(116, 'Mare apart baby', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2018-01-03 00:00:00', 1, 1, 0, NULL),
(117, 'EKS ALIHANDRO', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-03 00:00:00', 1, 1, 0, NULL),
(118, 'SALMAN AL WASEEL', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-03 00:00:00', 1, 1, 0, NULL),
(119, 'Tadawy Check Horse', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 300.00, NULL, NULL, NULL, '2018-01-03 00:00:00', 1, 1, 0, NULL),
(120, 'RFI FARID', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(121, 'ANSATA NILE ECHO', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(122, 'ALEXXANDERR', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(123, 'HAMAM AL JANADRIYAH', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(124, 'SMA MAGIC ONE', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(125, 'MARWAN AL SHAQAB', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(126, 'VALIDORO', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(127, 'HARIRY AL SHAQAB', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-05 00:00:00', 1, 1, 0, NULL),
(128, 'DOZE _ ( AJMAN MONISCIONE )', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1250.00, NULL, NULL, NULL, '2018-01-07 00:00:00', 1, 1, 0, NULL),
(129, 'M Nitrogen', NULL, NULL, NULL, NULL, NULL, NULL, 12, NULL, NULL, NULL, 30.00, NULL, NULL, NULL, '2018-01-07 00:00:00', 1, 1, 0, NULL),
(130, 'FAYYADH AL FAYYADH', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-10 00:00:00', 1, 1, 0, NULL),
(131, 'Outside Jump', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-13 00:00:00', 1, 1, 0, NULL),
(132, 'Water Powel', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 200.00, NULL, NULL, NULL, '2018-01-13 00:00:00', 1, 1, 0, NULL),
(133, 'Hilal Al Syed', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-15 00:00:00', 1, 1, 0, NULL),
(134, 'SHANNAN EL MADAN', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-23 00:00:00', 1, 1, 0, NULL),
(135, 'Doze _ NESJ EL MACHIATTO', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2018-01-25 00:00:00', 1, 1, 0, NULL),
(137, 'Kahil Al Shaqab', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-29 00:00:00', 1, 1, 0, NULL),
(138, 'Rubber Sheet Floor', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, 'inventory', NULL, 200.00, NULL, NULL, NULL, '2018-01-30 00:00:00', 1, 1, 0, NULL),
(139, 'KAIS', 'قيس', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-01-31 00:00:00', 1, 1, 0, NULL),
(140, 'Ajman Moniscione', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-06 00:00:00', 1, 1, 0, NULL),
(141, 'M Dogmatil', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 25.00, NULL, NULL, NULL, '2018-02-08 00:00:00', 1, 1, 1, NULL),
(142, 'M Bimozina', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 50.00, NULL, NULL, NULL, '2018-02-08 00:00:00', 1, 1, 1, NULL),
(143, 'M Enrofloxacina', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 100.00, NULL, NULL, NULL, '2018-02-08 00:00:00', 1, 1, 1, NULL),
(145, 'M Excenel', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 120.00, NULL, NULL, NULL, '2018-02-08 00:00:00', 1, 1, 1, NULL),
(146, 'Abha Qatar', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-08 00:00:00', 1, 1, 0, NULL),
(147, 'test item to be shown under ET', NULL, NULL, NULL, NULL, NULL, NULL, 14, NULL, NULL, NULL, 100.00, NULL, NULL, NULL, '2018-02-11 00:00:00', 1, 1, 0, NULL),
(148, 'ENAAQ AL THAQEB', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-15 00:00:00', 1, 1, 0, NULL),
(149, 'Fahad Al Tinhat', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-20 00:00:00', 1, 1, 0, NULL),
(150, 'Registration Fee', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 6000.00, NULL, NULL, NULL, '2018-02-20 00:00:00', 1, 1, 0, NULL),
(151, 'M Bemectin', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 40.00, NULL, NULL, NULL, '2018-02-20 00:00:00', 1, 1, 1, NULL),
(152, 'KANZ AL BEDAYER', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-25 00:00:00', 1, 1, 0, NULL),
(153, 'D MARAKSH', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-25 00:00:00', 1, 1, 0, NULL),
(154, 'M Flunexin', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 200.00, NULL, NULL, 'For 5 Days Treatment, Daily 10ml', '2018-02-26 00:00:00', 1, 1, 1, NULL),
(155, 'M Decomoton', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 30.00, NULL, NULL, '1 Doze = 2ml', '2018-02-26 00:00:00', 1, 1, 1, NULL),
(156, 'SHAKLAN', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-28 00:00:00', 1, 1, 0, NULL),
(157, 'AL DAJRAN', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-02-28 00:00:00', 1, 1, 0, NULL),
(158, 'MAGID MONISCIONE', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-03-01 00:00:00', 1, 1, 0, NULL),
(159, 'Semen Test', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 1000.00, NULL, NULL, NULL, '2018-03-01 00:00:00', 1, 1, 0, NULL),
(160, 'Free - No Boarding charges ', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '2018-03-01 00:00:00', 1, 1, 0, NULL),
(161, 'Free - No Service charges ', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '2018-03-01 00:00:00', 1, 1, 0, NULL),
(162, 'TR - Training horses special feed ', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00, 1000.00, NULL, NULL, NULL, '2018-03-06 00:00:00', 1, 1, 0, NULL),
(163, 'MIRACLE OF MARWAN', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-03-06 00:00:00', 1, 1, 0, NULL),
(164, 'NASEEM AL RASHEDIAH', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-03-07 00:00:00', 1, 1, 0, NULL),
(165, 'VEGAS HEC', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-03-07 00:00:00', 1, 1, 0, NULL),
(166, 'TADAWI', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-03-10 00:00:00', 1, 1, 0, NULL),
(167, 'EXCALIBUR EA', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, '2018-03-10 00:00:00', 1, 1, 0, NULL),
(168, 'Cutting', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 75.00, NULL, NULL, NULL, '2018-03-13 00:00:00', 1, 1, 0, NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `item_category`
--

CREATE TABLE `item_category` (
  `item_cat_id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `name_arabic` varchar(255) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `item_category`
--

INSERT INTO `item_category` (`item_cat_id`, `name`, `name_arabic`, `description`) VALUES
(1, 'Fresh Semens ', 'تلفيح بسائل منوي حديث', NULL),
(2, 'Frozen Semens', 'تلقيح بسائل منوي مجمد', NULL),
(3, 'Services', 'خدمات', NULL),
(4, 'Boarding', 'خدمات الإيواء و إقامة', NULL),
(5, 'Vet Fees', 'خدمات بيطرية', NULL),
(6, 'General Charge', 'خدمات عامة', NULL),
(7, 'Transportation', 'رسوم نقل', NULL),
(8, 'Account Adjustment', 'رسوم تعديل الحساب', NULL),
(9, 'Booking Fees', 'رسوم حجز', NULL),
(10, 'Miscellaneous', 'رسوم خدمات أخرى', NULL),
(11, 'Farrier', 'خدمات  بيطار', NULL),
(12, 'Vet Supplies/Medications', 'أدوية و لوازم بيطرية', NULL),
(13, 'Stud Fees	', 'رسوم المربط', NULL),
(14, 'Embryo Medicals', NULL, NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `item_transaction`
--

CREATE TABLE `item_transaction` (
  `item_transaction_id` int(11) NOT NULL,
  `description` varchar(45) DEFAULT NULL,
  `item_ref` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `transaction_type` enum('begining','purchase') DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `po_ref` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- بنية الجدول `item_type`
--

CREATE TABLE `item_type` (
  `item_type_id` int(11) NOT NULL,
  `type_name` varchar(45) DEFAULT NULL,
  `type_name_arabic` varchar(255) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `item_type`
--

INSERT INTO `item_type` (`item_type_id`, `type_name`, `type_name_arabic`, `description`) VALUES
(1, 'type1', NULL, NULL),
(2, 'type 2', NULL, NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `ledgers`
--

CREATE TABLE `ledgers` (
  `id` bigint(18) NOT NULL,
  `group_id` bigint(18) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name_ar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op_balance` decimal(25,3) NOT NULL DEFAULT '0.000',
  `op_balance_dc` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(2) NOT NULL DEFAULT '0',
  `reconciliation` int(1) NOT NULL DEFAULT '0',
  `notes` varchar(500) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `ledgers`
--

INSERT INTO `ledgers` (`id`, `group_id`, `name`, `name_ar`, `code`, `op_balance`, `op_balance_dc`, `type`, `reconciliation`, `notes`) VALUES
(5, 42, 'Samba (0634)', 'بنك سامبا ( الحساب الرئيسي )', '01-01-01-01-0002', 25497.490, 'D', 1, 0, ''),
(6, 42, 'Samba AJWAD', ' بنك سامبا  حساب أجود', '01-01-01-01-0001', 0.000, 'D', 1, 0, ''),
(7, 42, 'NCB', 'البنك الأهلي', '01-01-01-01-0003', 0.000, 'D', 1, 0, ''),
(9, 42, 'Al Inma', 'بنك الإنماء', '01-01-01-01-0005', 0.000, 'D', 1, 0, ''),
(10, 15, 'Customer Receivables ', 'ذمم مدينة - عملاء', '01-01-03-0001', 2173957.600, 'D', 0, 0, ''),
(12, 91, 'R.S Equine Reproduction (Supply  Medicine )', 'مورد الأدوية - روجر سوزا', ' 02-01-02-0008-001', 0.000, 'C', 0, 0, ''),
(13, 15, 'Other Receivables ', 'ذمم مدينة - أخرى', '01-01-03-0002', 0.000, 'D', 0, 0, ''),
(18, 50, 'Race Horse Cooked Mixed Feeds', 'أعلاف مخلوطة ', '01-01-04-06-0001', 0.000, 'D', 0, 0, ''),
(19, 50, 'Special Feeds for Training', 'أعلاف مخصصة  بقسم  التدريب', '01-01-04-06-0002', 0.000, 'D', 0, 0, ''),
(20, 17, 'Prepaid Rent', 'الإيجارات المدفوعة مقدماً', '01-01-05-0001', 20102.000, 'D', 0, 0, ''),
(21, 17, 'Prepaid insurance', 'التأمينات المدفوعة مقدماً', '01-01-05-0002', 16358.720, 'D', 0, 0, ''),
(22, 17, 'Other prepayments', 'المدفوعات المقدمة الأخرى', '01-01-05-0003', 0.000, 'D', 0, 0, ''),
(23, 17, 'Refundable deposits', 'الودائع القابلة للإسترداد', '01-01-05-0004', 0.000, 'D', 0, 0, ''),
(24, 17, 'Accrued Revenues', 'الإيرادات المستحقة', '01-01-05-0005', 0.000, 'D', 0, 0, ''),
(25, 55, 'Mare - Sale', 'الحاضنات المباعة', '01-01-02-01-0002', 79000.000, 'C', 0, 0, ''),
(26, 55, 'Mare - Donation', 'الحاضنات النافقة', '01-01-02-01-0003', 0.000, 'C', 0, 0, ''),
(27, 56, 'Acc depr-Office furnitures', 'مجمع إهلاك الأثاث المكتبي', '01-02-02-01-0001', 91506.000, 'C', 0, 0, ''),
(28, 57, 'Acc depr-Office equipments', 'مجمع إهلاك المعدات المكتبية', '01-02-02-02-0001', 54713.000, 'C', 0, 0, ''),
(29, 58, 'Acc depr-Computers and printers', 'مجمع إهلاك الكمبيوترات و الطابعات', '01-02-02-03-0001', 18950.000, 'C', 0, 0, ''),
(30, 59, 'Acc depr-mobile and other devices', 'مجمع إهلاك الجوالات وأجهزة الأتصال', '01-02-02-04-0001', 15847.500, 'C', 0, 0, ''),
(31, 60, 'Acc depr-medical equipments', 'مجمع إهلاك المعدات الطبية', '01-02-02-05-0001', 134039.000, 'C', 0, 0, ''),
(32, 61, 'Acc depr-other equipments', 'مجمع إهلاك المعدات الأخرى', '01-02-02-06-0001', 30912.000, 'C', 0, 0, ''),
(33, 62, 'Acc depr-vehicles', 'مجمع إهلاك السيارات', '01-02-02-07-0001', 67912.000, 'C', 0, 0, ''),
(34, 63, 'Acc depr-Building and improvements', 'مجمع إهلاك المباني و التطويرات', '01-02-02-08-0001', 1056626.000, 'C', 0, 0, ''),
(35, 66, 'Acc amort-computer software', 'مجمع اهلاك برامج الكمبيوتر', '                  01-01-06-01	-0001', 38622.000, 'C', 0, 0, ''),
(36, 24, 'Payable to customers', 'مبالغ مستحقة للعملاء', '02-01-02-0001', 0.000, 'C', 0, 0, ''),
(37, 24, 'Payable to employees', 'مبالغ مستحقة للموظفين', '02-01-02-0002', 11863.820, 'C', 0, 0, ''),
(39, 24, 'Other payable', 'مبالغ مستحقة أخرى', '02-01-02-0003', 0.000, 'C', 0, 0, ''),
(40, 23, 'Salaries payable-veterinarians', 'رواتب و أجور البيطرين المستحقة', '02-01-01-0001', 0.000, 'C', 0, 0, ''),
(41, 23, 'Salaries payable-trainer', 'رواتب و أجور المدربين المستحقة', '02-01-01-0002', 0.000, 'C', 0, 0, ''),
(42, 23, 'Salaries payable-groomers', 'رواتب و أجور العمال المستحقة', '02-01-01-0003', 0.000, 'C', 0, 0, ''),
(43, 23, 'Salaries payable-mgt & admin', 'رواتب و أجور الأداريين المستحقة', '02-01-01-0004', 0.000, 'C', 0, 0, ''),
(45, 25, 'Other liabilities', 'مطلوبات أخرى', '02-01-03-0002', 0.000, 'C', 0, 0, ''),
(46, 68, 'Advances from partners-nasir ', 'دفعات  نقدية من الشريك ناصر', '02-03-01-0001', 2344787.130, 'C', 0, 0, ''),
(47, 68, 'Advances from partners-nasir NCB', 'دفعات من الشريك ناصر - البنك الأهلي', '02-03-01-0002', 22596427.270, 'C', 0, 0, ''),
(48, 68, 'Advances from partners-nasir Al Rajhi', 'دفعات من الشريك ناصر - بنك الرجحي', '02-03-01-0003', 0.000, 'C', 0, 0, ''),
(49, 68, 'Advances from partners-nasir Riyad Bank', 'دفعات من الشريك ناصر - بنك الرياض', '02-03-01-0004', 137132.530, 'C', 0, 0, ''),
(50, 68, 'Advances from partners-abdullah albhian', 'دفعات من عبد الله البهيان ', '02-03-01-0005', 0.000, 'C', 0, 0, ''),
(51, 68, 'Advances from partners-abdulaziz al bargash ', 'دفعات من قسم التدريب - عبد العزيز ', '02-03-01-0006', 0.000, 'C', 0, 0, ''),
(52, 69, 'Advances from AUVA', 'دفعات من شركة التوريدات و المشاريع ( أوفا )', '02-03-02-0001', 0.000, 'C', 0, 0, ''),
(53, 69, 'Advances from Banan', 'دفعات من شركة بنان', '02-03-02-0002', 0.000, 'C', 0, 0, ''),
(54, 69, 'Advances from AJWAD', 'دفعات من مربط أجود', '02-03-02-0003', 0.000, 'C', 0, 0, ''),
(55, 69, 'Advances from MALATH', 'دفعات من شركة  ملاذ', '02-03-02-0004', 0.000, 'C', 0, 0, ''),
(56, 69, 'Advances from Mansoor Al Saeed', 'دفعات من  منصور السعيد', '02-03-02-0005', 0.000, 'C', 0, 0, ''),
(66, 48, 'Kahil Al Shaqab', 'كحيل الشقب', '01-01-04-04-0001', 176727.250, 'D', 0, 0, ''),
(67, 48, 'Wadee Al Shaqab', 'وادي الشقب', '01-01-04-04-0002', 47065.000, 'D', 0, 0, ''),
(68, 48, 'Marwan Al Shaqab', 'مروان الشقب', '01-01-04-04-0003', 0.000, 'D', 0, 0, ''),
(69, 48, 'Psytadel', 'بسايتديل', '01-01-04-04-0004', 0.000, 'D', 0, 0, ''),
(70, 48, 'Ajman Moniscione', 'عجمان مونيسيون', '01-01-04-04-0005', 171658.060, 'D', 0, 0, ''),
(71, 48, 'El Nabila B', 'النبيلة بي', '01-01-04-04-0006', 0.000, 'D', 0, 0, ''),
(72, 48, 'Muranas Jassehr', 'مروان جاسر', '01-01-04-04-0007', 0.000, 'D', 0, 0, ''),
(73, 48, 'Om El Bellisimo', 'أم البلسم', '01-01-04-04-0008', 0.000, 'D', 0, 0, ''),
(74, 48, 'Om El Shahmaan', 'أم الشهمان', '01-01-04-04-0009', 0.000, 'D', 0, 0, ''),
(75, 48, 'WH Justice', 'دابليو اتش جيستيس', '01-01-04-04-0010', 0.000, 'D', 0, 0, ''),
(76, 48, 'OFW Magic Wan', 'أو أف دابليو ماجيك وان', '01-01-04-04-0011', 0.000, 'D', 0, 0, ''),
(77, 48, 'Glorious Apal', 'جلوريا أبال', '01-01-04-04-0012', 0.000, 'D', 0, 0, ''),
(78, 48, 'Magnum Gold', 'ماجنوم جولد', '01-01-04-04-0013', 0.000, 'D', 0, 0, ''),
(79, 48, 'Ghazal Al Shaqab', 'غزال الشقب', '01-01-04-04-0014', 0.000, 'D', 0, 0, ''),
(80, 48, 'Ansata Nile Echo', 'أنساتا نايل أيكو', '01-01-04-04-0015', 38967.080, 'D', 0, 0, ''),
(81, 48, 'Hariry Al Shaqab', 'حريري الشقب', '01-01-04-04-0016', 47812.500, 'D', 0, 0, ''),
(82, 48, 'Fadi Al Shaqab', 'فادي الشقب', '01-01-04-04-0017', 78860.500, 'D', 0, 0, ''),
(83, 48, 'JJ Bellagio', 'جي جي بيلاجيو', '01-01-04-04-0018', 187900.000, 'D', 0, 0, ''),
(84, 48, 'Magic Magnifique', 'ماجيك ماجنيفيك', '01-01-04-04-0019', 0.000, 'D', 0, 0, ''),
(85, 48, 'SMA Magic One', 'أس أم أية ماجيك وان', '01-01-04-04-0020', 94206.880, 'D', 0, 0, ''),
(86, 50, 'Milk Powder', 'حليب مجفف', '01-01-04-06-0003', 0.000, 'D', 0, 0, ''),
(87, 50, 'Arasco Feeds', 'أعلاف أراسكو', '01-01-04-06-0004', 0.000, 'D', 0, 0, ''),
(88, 50, 'Animal Bran/Nakala Feeds', 'أعلاف نخالة', '01-01-04-06-0005', 0.000, 'D', 0, 0, ''),
(89, 50, 'Barley Feeds', 'أعلاف شعير', '01-01-04-06-0006', 0.000, 'D', 0, 0, ''),
(90, 50, 'Salt/Mila', 'ملــح', '01-01-04-06-0007', 0.000, 'D', 0, 0, ''),
(91, 50, 'Oil', 'زيت لتغذية الخيل', '01-01-04-06-0008', 0.000, 'D', 0, 0, ''),
(92, 50, 'Hay/Rothes - Small Cut', 'رودس -  صغير', '01-01-04-06-0009', 0.000, 'D', 0, 0, ''),
(93, 50, 'Hay/Rothes - Big Rolls', 'رودس - كبير', '01-01-04-06-0010', 0.000, 'D', 0, 0, ''),
(94, 50, 'Dry Alfalfa/Bersim - Cube Cut Bundle', 'برسيم جاف', '01-01-04-06-0011', 0.000, 'D', 0, 0, ''),
(95, 50, 'Fresh Alfalfa/Bersim - Per Bundle', 'برسيم اخضر  ليـن', '01-01-04-06-0012', 0.000, 'D', 0, 0, ''),
(96, 50, 'Wood Mulch/Saw Dust/Najara - Per Sack', 'نشارة أخشاب لغرف الخيل', '01-01-04-06-0013', 0.000, 'D', 0, 0, ''),
(102, 72, 'Advances to Mr. Nasir Al Fozan', 'دفعات الى الشريك ناصر', '01-01-07-01-0001', 12129748.860, 'D', 0, 0, ''),
(103, 72, 'Advances to AbdulAziz Al Bargash', 'دفعات إلى  قسم التدريب - عبد العزيز', '01-01-07-01-0002', 0.000, 'D', 0, 0, ''),
(104, 72, 'Advances to Abdullah Al Bhian', 'دفعات الى عبد الله البهيان ', '01-01-07-01-0003', 0.000, 'D', 0, 0, ''),
(105, 73, 'Advances to AUVA', 'دفعات الى شركة التوريدات و المشاريع ( اوفا )', '01-01-07-02-0001', 0.000, 'D', 0, 0, ''),
(106, 73, 'Advances to AJWAD', 'دفعات الى  مربط اجود', '01-01-07-02-0002', 0.000, 'D', 0, 0, ''),
(107, 73, 'Advances to BANAN', 'دفعات الى  شركة بنان ', '01-01-07-02-0003', 0.000, 'D', 0, 0, ''),
(108, 73, 'Advances to MALATH', 'دفعات الى  شركة ملاذ الخيل', '01-01-07-02-0004', 0.000, 'D', 0, 0, ''),
(109, 73, 'Advances to MILAD', 'دفعات الى  شركة ميلاد', '01-01-07-02-0005', 43604.000, 'D', 0, 0, ''),
(110, 73, 'Advances to Mansoor Al Saeed', 'دفعات الى  منصور السعيد', '01-01-07-02-0006', 0.000, 'D', 0, 0, ''),
(112, 73, 'Advances to TADAWI', 'دفعات الى شركة تداوي ', '01-01-07-02-0008', 0.000, 'D', 0, 0, ''),
(113, 69, 'Advances from TADAWI', 'دفعات من شركة تداوي', '02-03-02-0006', 0.000, 'C', 0, 0, ''),
(114, 69, 'Advances from MILAD', 'دفعات من شركة ميلاد', '02-03-02-0007', 0.000, 'C', 0, 0, ''),
(117, 29, 'Net Profit ', 'صافي الربح', '02-02-02-0001', 2574904.250, 'C', 0, 0, ''),
(118, 29, 'Net Loss', 'صافي الخسارة', '02-02-02-0002', 0.000, 'D', 0, 0, ''),
(119, 70, 'Revenue from Milad Services', 'ايرادات خدمات النشاط', '03-01-0001', 0.000, 'C', 0, 0, ''),
(122, 75, 'Medicine', 'أدوية ', '04-01-01-0001', 0.000, 'D', 0, 0, ''),
(123, 75, 'Medical Supply', 'لوازم طبية', '04-01-01-0002', 0.000, 'D', 0, 0, ''),
(124, 75, 'Training Feeds', 'أعلاف قسم التدريب', '04-01-01-0003', 0.000, 'D', 0, 0, ''),
(125, 75, 'Milk Powder', 'حليب مجفف', '04-01-01-0004', 0.000, 'D', 0, 0, ''),
(126, 75, 'Arasco Feeds', 'أعلاف أراسكو', '04-01-01-0005', 0.000, 'D', 0, 0, ''),
(127, 75, 'Animal Bran/Nakala Feeds', 'أعلاف نخالة', '04-01-01-0006', 0.000, 'D', 0, 0, ''),
(128, 75, 'Barley Feeds', 'أعلاف شعير', '04-01-01-0007', 0.000, 'D', 0, 0, ''),
(129, 75, 'Salt/Mila (cost)', 'ملــح', '04-01-01-0008', 0.000, 'D', 0, 0, ''),
(130, 75, 'Oil', 'زيوت لتغذية الخيل', '04-01-01-0009', 0.000, 'D', 0, 0, ''),
(131, 75, 'Hay/Rothes - Small Cut', 'رودس - صغير', '04-01-01-0010', 0.000, 'D', 0, 0, ''),
(132, 75, 'Hay/Rothes - Big Rolls', 'رودس - كبير', '04-01-01-0011', 0.000, 'D', 0, 0, ''),
(133, 75, 'Dry Alfalfa/Bersim - Cube Cut Bundle', 'برسيم  جاف', '04-01-01-0012', 0.000, 'D', 0, 0, ''),
(134, 75, 'Fresh Alfalfa/Bersim - Per Bundle', 'برسيم أخضر لين', '04-01-01-0013', 0.000, 'D', 0, 0, ''),
(135, 75, 'Wood Mulch/Saw Dust/Najara - Per Sack', 'نشارة أخشاب - لغرف الخيل', '04-01-01-0014', 0.000, 'D', 0, 0, ''),
(136, 75, 'Registration and Performance Show Fee', 'رسوم تسجيل و حضور عروض الخيل', '04-01-01-0015', 0.000, 'D', 0, 0, ''),
(137, 75, 'Winning Prize', 'جوائز الفائزين', '04-01-01-0016', 0.000, 'D', 0, 0, ''),
(138, 75, 'Trainer Visa', 'تأشيرات  المدربين', '04-01-01-0017', 0.000, 'D', 0, 0, ''),
(139, 75, 'Groomer Visa', 'تأشيرات العمال', '04-01-01-0018', 0.000, 'D', 0, 0, ''),
(140, 75, 'Driver Visa', 'تأشيرات السائقين', '04-01-01-0019', 0.000, 'D', 0, 0, ''),
(141, 75, 'Customs Clearance & Others', 'رسوم التخليص الجمركي', '04-01-01-0020', 0.000, 'D', 0, 0, ''),
(142, 75, 'Air Fare Show', 'تذاكر الطيران  لحضور عروض الخيل', '04-01-01-0021', 0.000, 'D', 0, 0, ''),
(143, 75, 'Transportation Show', 'مصاريف النقل - عروض الخيل', '04-01-01-0022', 0.000, 'D', 0, 0, ''),
(144, 75, 'Refreshment Show', 'مصاريف ضيافه - عروض الخيل', '04-01-01-0023', 0.000, 'D', 0, 0, ''),
(145, 76, 'Miscellaneous ', 'مصاريف متنوعة', '04-01-01-0024', 0.000, 'D', 0, 0, ''),
(146, 75, 'Doctors Fee Show', 'مصاريف للأطباء في العروض', '04-01-01-0025', 0.000, 'D', 0, 0, ''),
(147, 75, 'Hotel Show', 'إيجار فنادق - عروض الخيل', '04-01-01-0026', 0.000, 'D', 0, 0, ''),
(148, 75, 'Laboratory Test Show', 'رسوم المختبرات الطبية - عروض الخيل', '04-01-01-0027', 0.000, 'D', 0, 0, ''),
(149, 75, 'Vaccination Show', 'رسوم اللقاحات الطبية - عروض الخيل', '04-01-01-0028', 0.000, 'D', 0, 0, ''),
(150, 75, 'Horse Materials Training', ' لوازم للخيل - قسم التدريب', '04-01-01-0029', 0.000, 'D', 0, 0, ''),
(151, 75, 'Horse Materials Reproduction', 'لوازم للخيل - قسم التناسليات', '04-01-01-0030', 0.000, 'D', 0, 0, ''),
(152, 75, 'Vitamins/Supplements', 'فيتامينات و مكملات غذائية  للخيل', '04-01-01-0031', 0.000, 'D', 0, 0, ''),
(153, 75, 'Salary Veterinary', 'مرتبات البيطريين', '04-01-02-0001', 0.000, 'D', 0, 0, ''),
(154, 75, 'Salary Trainer', 'مرتبات المدربين', '04-01-02-0002', 0.000, 'D', 0, 0, ''),
(155, 75, 'Salary Groomer', 'مرتبات العمال', '04-01-02-0003', 0.000, 'D', 0, 0, ''),
(156, 76, 'Salary Management - Non-Saudi', 'رواتب الإداريين - غير السعوديين', '04-01-02-0004', 0.000, 'D', 0, 0, ''),
(158, 76, 'Recruiting Medical Expense', 'مصاريق التوظيف  الطبية', '04-01-02-0006', 0.000, 'D', 0, 0, ''),
(159, 76, 'Recruiting Translation & Attestation', 'مصاريف التصديقات  و الترجمة  الخاصة بالتوظيف', '04-01-02-0007', 0.000, 'D', 0, 0, ''),
(160, 76, 'Recruiting Incoming Air Ticket', 'تذاكر سفر للقادمين للتوظيف', '04-01-02-0008', 0.000, 'D', 0, 0, ''),
(161, 76, 'Recruiting Work Permit', 'رسوم رخص العمل', '04-01-02-0009', 0.000, 'D', 0, 0, ''),
(162, 76, 'Recruiting Work visa', 'رسوم تأشيرات العمل', '04-01-02-0010', 0.000, 'D', 0, 0, ''),
(163, 76, 'Recruiting Iqama ID', 'رسوم الإقامات', '04-01-02-0011', 0.000, 'D', 0, 0, ''),
(164, 76, 'Recruiting Doctors  Visa', 'رسوم  تأشيرات الأطباء', '04-01-02-0012', 0.000, 'D', 0, 0, ''),
(165, 76, 'Recruiting Immigration Reimbursement', 'مصاريف هجرة', '04-01-02-0013', 0.000, 'D', 0, 0, ''),
(166, 76, 'Annual Leave Ticket Non Saudi', 'تذاكر السفر السنوية للموظفين الغير سعوديين', '04-01-02-0014', 0.000, 'D', 0, 0, ''),
(167, 76, 'Special Air Ticket', 'تذاكر سفر خاصة', '04-01-02-0015', 0.000, 'D', 0, 0, ''),
(168, 76, 'Iqama Renewal', 'رسوم تجديد الإقامات', '04-01-02-0016', 0.000, 'D', 0, 0, ''),
(169, 76, 'Passport Renewal', 'رسوم تجديد جوازات السفر', '04-01-02-0017', 0.000, 'D', 0, 0, ''),
(170, 76, 'Changed Position', 'رسوم تغيير مهنة', '04-01-02-0018', 0.000, 'D', 0, 0, ''),
(171, 76, 'Exit/Re-Entry Visa', 'رسوم تأشيرات الخروج و العودة', '04-01-02-0019', 0.000, 'D', 0, 0, ''),
(172, 76, 'GOSI', 'رسوم التأمينات الإجتماعية', '04-01-02-0020', 0.000, 'D', 0, 0, ''),
(173, 76, 'Medication/Hospitalization', 'مصاريف طبية و علاجية', '04-01-02-0021', 0.000, 'D', 0, 0, ''),
(174, 76, 'Employee Other Benefits', 'مزايا أخرى للموظفين', '04-01-02-0022', 0.000, 'D', 0, 0, ''),
(175, 76, 'Bonus/Commission', 'عمولات و مكافأت ', '04-01-02-0023', 0.000, 'D', 0, 0, ''),
(176, 76, 'End of Service Award (EOSA)', 'مصاريف نهاية الخدمة ', '04-01-02-0024', 0.000, 'D', 0, 0, ''),
(177, 76, 'Advertising & Promotion', 'رسوم الدعايا و الإعلان', '04-01-01-0032', 0.000, 'D', 0, 0, ''),
(178, 76, 'Postage/Courier', 'رسوم البريد', '04-01-02-0025', 0.000, 'D', 0, 0, ''),
(179, 76, 'Office Supply', 'لوازم مكتبية', '04-01-02-0026', 0.000, 'D', 0, 0, ''),
(180, 76, 'Consummables', 'المواد الإستهلاكية', '04-01-02-0027', 0.000, 'D', 0, 0, ''),
(181, 75, 'Truck Rental', 'ايجار سيارات و شاحنات', '04-01-01-0033', 0.000, 'D', 0, 0, ''),
(182, 75, 'Manpower Rental', 'ايجار قوى عاملة', '04-01-01-0034', 0.000, 'D', 0, 0, ''),
(183, 75, 'Other Rentals', 'رسوم إيجارات أخرى', '04-01-01-0035', 0.000, 'D', 0, 0, ''),
(184, 76, 'Repair & Maint - Office Equipment', 'صيانة وإصلاح المعدات المكتبية', '04-01-02-0028', 0.000, 'D', 0, 0, ''),
(185, 76, 'Repair & Maint - Office Furniture & Fixtures', 'صيانة وإصلاح الأثاث المكتبي', '04-01-02-0029', 0.000, 'D', 0, 0, ''),
(186, 76, 'Repair & Maint - Vehicle', 'صيانة وإصلاح  السيارات', '04-01-02-0030', 0.000, 'D', 0, 0, ''),
(187, 76, 'Repair & Maint - Medical Equipment', 'صيانة وإصلاح المعدات الطبية', '04-01-02-0031', 0.000, 'D', 0, 0, ''),
(188, 76, 'Repair & Maint - Bldg & Improvement', 'صيانة وإصلاح  المباني ', '04-01-02-0032', 0.000, 'C', 0, 0, ''),
(189, 76, 'Repair & Maint - Computer & Printer', 'صيانة وإصلاح  الكمبيوترات و الطابعات', '04-01-02-0033', 0.000, 'D', 0, 0, ''),
(190, 76, 'Repair & Maint - Mobile', 'صيانة وإصلاح  الجولات و أجهزة الإتصال', '04-01-02-0034', 0.000, 'D', 0, 0, ''),
(191, 76, 'Repair & Maint - Other Equipment', 'صيانة وإصلاح المعدات الأخرى', '04-01-02-0035', 0.000, 'D', 0, 0, ''),
(192, 76, 'Repair & Maint - Others', 'صيانة و إصلاح معدات أخرى', '04-01-02-0036', 0.000, 'D', 0, 0, ''),
(193, 76, 'Water Bill', 'فواتير المياة', '04-01-02-0037', 0.000, 'D', 0, 0, ''),
(194, 76, 'Electricity Bill', 'فواتير الكهرباء', '04-01-02-0038', 0.000, 'D', 0, 0, ''),
(195, 76, 'Telephone/Mobile Bill', 'فواتير الهواتف و الجوالات', '04-01-02-0039', 0.000, 'D', 0, 0, ''),
(196, 76, 'Internet Bill', 'فواتير الأنترنت', '04-01-02-0040', 0.000, 'D', 0, 0, ''),
(197, 76, 'News & Magazine Subscription', 'رسوم اشتراكات الصحف و المجلات', '04-01-02-0041', 0.000, 'D', 0, 0, ''),
(198, 76, 'Website Subscription', 'رسوم اشتراكات مواقع الأنترنت ', '04-01-02-0042', 0.000, 'D', 0, 0, ''),
(199, 76, 'Petrol', 'محروقات', '04-01-02-0043', 0.000, 'D', 0, 0, ''),
(200, 76, 'Insurance Expense', 'مصاريف التأمين', '04-01-02-0044', 0.000, 'D', 0, 0, ''),
(202, 76, 'Donation', 'تعويضات', '04-01-02-0046', 0.000, 'D', 0, 0, ''),
(203, 76, 'Legal Fee', 'رسوم  وأتعاب قانونية', '04-01-02-0047', 0.000, 'D', 0, 0, ''),
(204, 76, 'Accounting/Audit Fee', 'رسوم و اتعاب مالية', '04-01-02-0048', 0.000, 'D', 0, 0, ''),
(205, 76, 'Government Fee - Chamber of Commerce, etc.', 'رسوم خدمات حكومية - تصديقات الغرفة التجارية', '04-01-02-0049', 0.000, 'D', 0, 0, ''),
(206, 77, 'Depreciation', 'مصروف إهلاك الاصول الثابتة', '04-01-03-0001', 0.000, 'D', 0, 0, ''),
(207, 77, 'Amortization', 'مصاريف إهلاك الأصول الغير ملموسة', '04-01-03-0002', 0.000, 'D', 0, 0, ''),
(208, 76, 'Bank Service Charge', 'رسوم خدمات بنكية', '04-01-02-0050', 0.000, 'D', 0, 0, ''),
(209, 80, 'Foreign Exchange Gain', 'أرباح تغيير عملات', '03-02-0001', 0.000, 'C', 0, 0, ''),
(210, 80, 'Miscellaneous Income', 'إيرادات متنوعة', '03-02-0002', 0.000, 'C', 0, 0, ''),
(211, 80, 'Gain on Biological Asset', 'أرباح بيع أصول بيولوجية', '03-02-0003', 0.000, 'C', 0, 0, ''),
(212, 80, 'Gain on Sale of Asset', 'أرباح بيع أصول', '03-02-0004', 0.000, 'C', 0, 0, ''),
(213, 80, 'Gain on Asset Write Down', 'أرباح أرتفاع قيمة الأصول', '03-02-0005', 0.000, 'C', 0, 0, ''),
(214, 81, 'Foreign Exchange Loss', 'خسائر تغيير العملات الأجنبية', '04-02-0001', 0.000, 'D', 0, 0, ''),
(215, 81, 'Loss on Biological Asset', 'خسائر بيع أصول بيولوجية', '04-02-0002', 0.000, 'D', 0, 0, ''),
(216, 81, 'Loss on Sale of Asset', 'خسائر بيع أصول ', '04-02-0003', 0.000, 'D', 0, 0, ''),
(217, 81, 'Loss on Asset Write Down', 'خسائر هبوط قيمة الاصول', '04-02-0004', 0.000, 'D', 0, 0, ''),
(218, 70, 'Other Revenue ', '', '03-01-0002', 0.000, 'C', 0, 0, ''),
(219, 24, 'Output Tax', 'ضرائب تم تحصيلها', '02-01-02-0004', 0.000, 'C', 0, 0, ''),
(220, 43, 'Cash on Hand', 'النقدية بالصندوق', '01-01-01-02-0001', 0.000, 'D', 1, 0, ''),
(221, 44, 'Petty Cash for MANSOUR', '  عهدة منصور السعيد ', '01-01-01-03-0001', 128033.740, 'D', 0, 0, ''),
(222, 63, 'Building And Improvements', 'المباني و التطويرات', '01-02-02-08-0002', 11663141.380, 'D', 0, 0, ''),
(223, 58, 'Computers and Printers', 'الكمبيوترات و الطابعات', '01-02-02-03-0002', 81715.500, 'D', 0, 0, ''),
(224, 60, 'Medical Equipments', 'المعدات الطبية', '01-02-02-05-0002', 350277.740, 'D', 0, 0, ''),
(225, 59, 'Mobile and Other Devices', 'الجوالات وأجهزة الأتصال', '01-02-02-04-0002', 53504.360, 'D', 0, 0, ''),
(226, 57, 'Office Equipments', 'معدات مكتبية', '01-02-02-02-0002', 259650.000, 'D', 0, 0, ''),
(227, 56, 'Office Furnitures', 'أثاث مكتبي', '01-02-02-01-0002', 326546.300, 'D', 0, 0, ''),
(228, 61, 'Other Equipments', 'المعدات الأخرى', '01-02-02-06-0002', 316977.930, 'D', 0, 0, ''),
(229, 62, 'Vehicles', 'السيارات', '01-02-02-07-0002', 307989.500, 'D', 0, 0, ''),
(230, 66, 'Computer Software', 'برامج كمبيوتر', '01-01-06-01-0002', 56498.000, 'D', 0, 0, ''),
(231, 64, 'Construction in Progress', 'مباني تحت الإنشاء', '01-02-05-01-0001', 68490.000, 'D', 0, 0, ''),
(232, 82, 'Input Tax', 'الضريبة المدفوعة', '01-01-08-0001', 0.000, 'D', 0, 0, ''),
(233, 28, 'Capital', 'رأس المال', '02-02-01-0001', 30000.000, 'C', 0, 0, ''),
(234, 74, 'Statutory Reserve', 'أحتياطي قانوني', '02-02-03-0001', 15000.000, 'C', 0, 0, ''),
(237, 24, 'Provision for Zakat', 'مخصص الزكاة الشرعية', '02-01-02-0005', 36824.000, 'C', 0, 0, ''),
(238, 24, 'Provision for Profit Share', 'مخصص أرباح الشركاء', '02-01-02-0006', 0.000, 'C', 0, 0, ''),
(239, 24, 'Provision for End of Service', 'مخصص نهاية الخدمة', '02-01-02-0007', 0.000, 'C', 0, 0, ''),
(240, 15, 'Allowance for Doubtful Account', 'مخصص الديون المشكوك في تحصيلها', '01-01-03-0003', 204613.000, 'C', 0, 0, ''),
(241, 76, 'Doubtful debts expenses', 'مصاريف الديون المشكوك في تحصيلها', '04-01-02-0051', 0.000, 'D', 0, 0, ''),
(242, 70, 'Riding ', 'غرادات ركوب الخيل', '03-01-0003', 0.000, 'C', 0, 0, ''),
(243, 76, 'Riding Expenses', 'مصاريف ركوب الخيل', '04-01-02-0052', 0.000, 'D', 0, 0, ''),
(244, 44, 'Petty Cash Joey', 'عهدة جوي', '01-01-01-03-0002', 0.000, 'D', 0, 0, ''),
(245, 44, 'Petty Cash -  Mohamed Majed', 'عهدة محمد ماجد', '01-01-01-03-0003', 0.000, 'D', 0, 0, ''),
(247, 75, 'Visitor Visa Fees', 'رسوم تأشيرات  الزيارة', '04-01-01-0036', 0.000, 'D', 0, 0, ''),
(248, 84, 'Joey Sarto Account', 'حساب  الموظف - جوي سارتو', '01-01-03-0005-0001', 0.000, 'D', 0, 0, ''),
(249, 84, 'SASI Accounts', 'حساب الموظف ساسي', '01-01-03-0005-0002', 3000.000, 'D', 0, 0, ''),
(250, 84, 'AHMED MAGDI Account', 'حساب الموظف - أحمد مجدي', '01-01-03-0005-0003', 0.000, 'D', 0, 0, ''),
(253, 84, 'Elsayed Ramdan Abd Elnaby Aly Account', 'حساب الموظف- السيد رمضان', '01-01-03-0005-0005', 0.000, 'D', 0, 0, ''),
(255, 84, 'RAZQAN ISSA Account', 'حساب الموظف- رزقان عيسى', '01-01-03-0005-0007', 0.000, 'D', 0, 0, ''),
(256, 84, 'Waleed Al Zahrani account', 'حساب الموظف- وليد الزهراني', '01-01-03-0005-0008', 0.000, 'D', 0, 0, ''),
(257, 84, 'RADWAN  HASSAN AHMED Account', 'حساب الموظف - رضوان حسن', '01-01-03-0005-0009', 0.000, 'D', 0, 0, ''),
(258, 84, 'JESSIE JAMES Account', 'حساب الموظف- جيسي جيمس', '01-01-03-0005-0010', 0.000, 'D', 0, 0, ''),
(259, 84, 'ASHOK RAM Account', 'حساب العامل - اشوك رام', '01-01-03-0005-0011', 0.000, 'D', 0, 0, ''),
(260, 84, 'TARIQ MOHAMED RAJ Account', 'حساب العامل - طارق محمد راج', '01-01-03-0005-0012', 0.000, 'D', 0, 0, ''),
(261, 76, 'Salary Management - Saudi', 'رواتب الإدارة - الموظفيين السعوديين', '04-01-02-0005', 0.000, 'D', 0, 0, ''),
(262, 76, 'Annual Leave Ticket Saudi', 'تذاكر السفر السنوي - للموظفين السعوديين', '04-01-02-0053', 0.000, 'D', 0, 0, ''),
(263, 76, 'Transportation Allowance - Saudi', 'بدل انتقال - سعوديين', '04-01-02-0056', 0.000, 'D', 0, 0, ''),
(264, 76, 'Transportaion Allowance - Non Suadi', 'بدل انتقال للموظفين الغير سعوديين', '04-01-02-0054', 0.000, 'D', 0, 0, ''),
(265, 76, 'Transfer sponsorship fees', 'رسوم نقل الكفالة ', '04-01-02-0055', 0.000, 'D', 0, 0, ''),
(267, 55, 'Recipient Mares (Buy)', 'شراء افراس حاضنة', '01-01-02-01-0001', 393664.190, 'D', 0, 0, ''),
(268, 89, 'Buy Horses for Riding ', 'شراء خيول للركوب', '01-01-02-02-0001', 0.000, 'D', 0, 0, ''),
(269, 89, 'Sale of Horses  Riding ', 'بيع خيول الركوب', '01-01-02-02-0002', 0.000, 'C', 0, 0, ''),
(270, 89, 'Donation - Riding Horses', 'تعويضات - خيول الركوب ', '01-01-02-02-0003', 0.000, 'C', 0, 0, ''),
(271, 75, 'Horses Hospital fee ', 'مصاريف  مستشفى  للخيل', '04-01-01-0037', 0.000, 'D', 0, 0, ''),
(272, 84, 'William Account', 'حساب وليم', '01-01-03-0005-0013', 0.000, 'D', 0, 0, ''),
(273, 84, 'Dayvory Account', 'حساب ديفوري', '01-01-03-0005-0014', 0.000, 'D', 0, 0, ''),
(274, 84, 'Arthuer Accountant', 'حساب ارثر', '01-01-03-0005-0015', 0.000, 'D', 0, 0, ''),
(275, 90, 'R.S Commission ', 'عمولات روجر سوزا', '04-01-02-0059-001', 0.000, 'D', 0, 0, ''),
(276, 91, 'Commission Payable for R.S Equine Rep.', 'مستحقات العمولات - روجر سوزا', '02-01-02-0009-002', 0.000, 'C', 0, 0, ''),
(277, 87, 'Housing Allowance for RAZQAN ISSA', 'بدل سكن للموظف رزقان عيسى', '04-01-02-0058-001', 0.000, 'D', 0, 0, ''),
(278, 87, 'Housing Allowance for HASSAN JABER', 'بدل سكن للموظف حسن جابر', '04-01-02-0058-002', 0.000, 'D', 0, 0, ''),
(279, 87, 'Housing Allowance for WALEED AL ZAHRANI', 'بدل سكن للموظف وليد الزهراني', '04-01-02-0058-003', 0.000, 'D', 0, 0, ''),
(280, 91, 'TADAWI Invoice Charge to MILAD Clients', 'فواتير تداوي المحملة على عملاء ميلاد', '02-01-02-0008-0003', 0.000, 'C', 0, 0, ''),
(281, 85, 'Ammar Qshoom Contractor', 'عهدة المقاول عمار قشووم', '01-01-03-0004-0001', 0.000, 'D', 0, 0, ''),
(285, 88, 'Accommodation Allowance Non Saudi', 'بدل سكن - غير سعودي', '04-01-02-0057-0001', 0.000, 'D', 0, 0, ''),
(288, 76, 'Traffic Violation Fee', 'مخالفات مرورية', '04-01-02-0057', 0.000, 'D', 0, 0, ''),
(289, 76, 'Exit/Re-Entry Visa Penalty', 'غرامات تأشيرات الخروج و العودة ', '04-01-02-0058', 0.000, 'D', 0, 0, ''),
(290, 76, 'Representation', 'مصاريف التمثيل', '04-01-02-0059', 0.000, 'C', 0, 0, ''),
(291, 24, 'Provision for Air Ticket', '', '02-01-02-0008', 0.000, 'C', 0, 0, ''),
(292, 24, 'Provision for Leave Payment', '', '02-01-02-0009', 0.000, 'C', 0, 0, ''),
(294, 84, 'Romel Lagoras', 'حساب الموظف رومل', '01-01-03-0005-0016', 2800.000, 'D', 0, 0, ''),
(295, 76, 'Salary Farrier', 'راتب اعمال البيطار', '04-01-02-0060', 0.000, 'D', 0, 0, ''),
(296, 76, 'Trainer/Handler Fee', 'مصاريف التدريب', '04-01-02-0061', 0.000, 'D', 0, 0, ''),
(297, 75, 'RS Equine Medicine Supply', 'مورد الأدوية - روجر سوزا', '04-01-01-0038', 0.000, 'D', 0, 0, ''),
(298, 76, 'Vacation Leave Payment (Non-Saudi)', 'راتب اجازه - غير سعودي', '04-01-02-0062', 0.000, 'D', 0, 0, ''),
(299, 76, 'Vacation Leave Payment (Saudi)', 'راتب اجازه - سعودي', '04-01-02-0063', 0.000, 'D', 0, 0, ''),
(300, 84, 'Ricardo Loyola', 'حساب الموظف ريكاردو', '01-01-03-0005-0017', 0.000, 'D', 0, 0, ''),
(301, 76, 'Wasil/PO Box ', 'بريد - واصل', '04-01-02-0064', 0.000, 'D', 0, 0, ''),
(302, 76, 'Car License (Renewal)', 'تجديد رخص السيارات', '04-01-02-0065', 0.000, 'D', 0, 0, ''),
(303, 88, 'Accommodation allowance - Joey Sarto', 'بدل سكن - جوي سارتو', '04-01-02-0057-0002', 0.000, 'D', 0, 0, ''),
(304, 88, 'Accommodation allowance - Hassan Jabr Mheh Mejrashi', 'بدل سكن - حسن جابر', '04-01-02-0057-0003', 0.000, 'D', 0, 0, ''),
(305, 88, 'Accommodation allowance - Rzqan Isa Hasan Mjthal', 'بدل سكن- رزقان', '04-01-02-0057-0004', 0.000, 'D', 0, 0, ''),
(306, 44, 'Petty Cash - Rajesh', 'عهدة الموظف راجيش', '01-01-01-03-0004', 0.000, 'D', 0, 0, ''),
(307, 75, 'Handling Fee', 'اتعاب مناولة و توصيل', '04-01-01-0039', 0.000, 'D', 0, 0, ''),
(309, 44, 'Petty Cash Ibrahim Mohammed Rasheid ', 'عهدة ابراهيم الرشيد', '01-01-01-03-0005', 0.000, 'D', 0, 0, ''),
(310, 84, 'Arthur Nascimento', 'حساب الموظف ارثر نسيمو', '01-01-03-0005-0018', 0.000, 'D', 0, 0, ''),
(311, 76, 'Transportation Expense', 'مصاريف النقل', '04-01-02-0066', 0.000, 'D', 0, 0, ''),
(313, 76, 'Overtime', 'بدل ساعات العمل الإضافية', '04-01-02-0067', 0.000, 'D', 0, 0, ''),
(314, 88, 'Accommodation allowance - Mohammed Rafi', 'بدل سكن - محمد رافيع', '04-01-02-0057-0005', 0.000, 'D', 0, 0, ''),
(315, 75, 'Government Customs Clearance', 'مصاريف حكومية - ( بيان ) تخليص جمركي ', '04-01-01-0040', 0.000, 'D', 0, 0, ''),
(316, 70, 'Winning Prize (Show)', 'إيرادات  جوائز من المسابقات', '03-01-0004', 0.000, 'C', 0, 0, ''),
(317, 70, 'Revenue from Show - Registration of Horse', 'إيرادات التسجبل في البطولات', '03-01-0005', 0.000, 'C', 0, 0, ''),
(318, 70, 'Other Revenue - Tractor Rental', 'ايرادات - استئجار حافلات', '03-01-0006', 0.000, 'C', 0, 0, ''),
(319, 70, 'Revenue - Sold Medicine', 'إيرادات بيع أدوية', '03-01-0007', 0.000, 'C', 0, 0, ''),
(320, 70, 'Revenue - Ultra Sound/Palpation', 'إيرادات جس الفرس', '03-01-0008', 0.000, 'C', 0, 0, ''),
(321, 84, 'Eduardo Ambid Tomas Account', 'حساب الموظف ادواردو', '01-01-03-0005-0019', 0.000, 'D', 0, 0, ''),
(322, 48, 'Kanz Albidayer', 'كنز البداير', '01-01-04-04-0021', 0.000, 'D', 0, 0, ''),
(323, 88, 'Khaled Taha', 'بدل سكن - خالد طه', '04-01-02-0057-0006', 0.000, 'D', 0, 0, ''),
(324, 88, 'Accommodation Allowance - Ahmed Majdi Mohammed Salem', 'بدل سكن - أحمد مجدي', '04-01-02-0057-0007', 0.000, 'D', 0, 0, ''),
(325, 88, 'Accommodation Allowance - Radwan Hassan Ahmed', 'بدل سكن - رضوان حسن', '04-01-02-0057-0008', 0.000, 'D', 0, 0, ''),
(326, 75, 'Farrier Commission', 'عمولة  اعمال البيطار', '04-01-01-0041', 0.000, 'D', 0, 0, ''),
(327, 49, 'Rubber Sheet Floor', '', '01-01-04-05-0001', 0.000, 'D', 0, 0, ''),
(328, 91, 'Hebei Jingyung Rubber Plastic Productions Co.', 'مصنع هبي للربلات', '02-01-02-0010', 0.000, 'C', 0, 0, ''),
(329, 76, 'E-load Visa', 'فيز الكترونية', '04-01-02-0068', 0.000, 'D', 0, 0, ''),
(330, 48, 'Excalibur EA', 'إكسيليبر - اي اية', '01-01-04-04-0022', 0.000, 'D', 0, 0, ''),
(331, 91, 'Wheel Information Technology', 'مقاول  صيانة الكاميرات - عجلة التقنية', '02-01-02-0008-0011', 0.000, 'C', 0, 0, ''),
(332, 48, 'Eks Alihandro', 'ايكس إليخاندرو', '01-01-04-04-0023', 0.000, 'D', 0, 0, ''),
(334, 48, 'Gazal Al Shaqab', 'غزال الشقب', '01-01-04-04-0025', 0.000, 'D', 0, 0, ''),
(335, 84, 'Muhammad Iqbal Aafriday Account', 'حساب الموظف محمد إقبال', '01-01-03-0005-0020', 0.000, 'D', 0, 0, ''),
(336, 76, 'Accommodation Rentals - Veterinary Doctors', 'ايجار سكن - الإطباء البيطريين', '04-01-02-0069', 0.000, 'D', 0, 0, ''),
(337, 44, 'Petty Cash - Sasi', 'عهدة ساسي', '01-01-01-03-0006', 0.000, 'D', 0, 0, ''),
(338, 84, 'Farmana Ali Account', 'حساب الموظف فرمان علي', '01-01-03-0005-0021', 0.000, 'D', 0, 0, ''),
(339, 76, 'Training/ Professional Development', 'مصاريف التدريب و التطوير المهني', '04-01-02-0070', 0.000, 'D', 0, 0, ''),
(340, 84, 'Hassan Haber Account', 'حساب الموظف حسن جابر', '01-01-03-0005-0022', 0.000, 'D', 0, 0, ''),
(341, 76, 'Meals & Entertainment ', 'وجبات الطعام و الترفيه', '04-01-02-0071', 0.000, 'D', 0, 0, ''),
(342, 70, 'Revenue - Swab', 'إيرادات تنظيف الرحم', '03-01-0009', 0.000, 'C', 0, 0, ''),
(343, 70, 'Revenue - Transportation', 'إيرادات نقل', '03-01-0010', 0.000, 'C', 0, 0, ''),
(344, 76, 'Stationery ', 'ادوات مكتبية', '04-01-02-0072', 0.000, 'D', 0, 0, ''),
(345, 76, 'Janitorial', 'خدمات الحراسة', '04-01-02-0073', 0.000, 'D', 0, 0, ''),
(346, 76, 'Medical Expenses - Employees', 'مصاريف علاجية  للموظفين', '04-01-02-0074', 0.000, 'D', 0, 0, ''),
(347, 76, 'Uniform Expenses', 'زي موحد', '04-01-02-0075', 0.000, 'D', 0, 0, ''),
(348, 75, 'Hotel Guest', 'ايجار فندق', '04-01-01-0042', 0.000, 'D', 0, 0, ''),
(349, 76, 'Tools & Materials', 'عدد و أدوات مستهلكهة', '04-01-02-0076', 0.000, 'D', 0, 0, ''),
(350, 76, 'Landscaping expenses', 'مصاريف المسطحات الخضراء و الزراعة', '04-01-02-0077', 0.000, 'D', 0, 0, ''),
(351, 76, 'Sewer expenses', 'مصاريف خدمات الصرف الصحي', '04-01-02-0078', 0.000, 'D', 0, 0, ''),
(352, 76, 'Other Supplies', 'مستلزمات اخرى', '04-01-02-0079', 0.000, 'D', 0, 0, ''),
(353, 51, 'Prescription food', '', '01-01-04-07-0001', 0.000, 'D', 0, 0, ''),
(354, 75, 'Shoeing/ Trimming', 'تقليم  حافر الخيل', '04-01-01-0043', 0.000, 'D', 0, 0, ''),
(355, 50, 'Gain Freedom Feeds', 'اعلاف اخرى', '01-01-04-06-0014', 0.000, 'D', 0, 0, ''),
(356, 50, 'Gain Coarse Mix', 'اعلاف مخلوطة ', '01-01-04-06-0015', 0.000, 'D', 0, 0, ''),
(357, 84, 'Faisal Qasem Account', 'حساب الموظف فيصل قاسم', '01-01-03-0005-0023', 0.000, 'D', 0, 0, ''),
(358, 76, 'Commission - Tian Hua', 'عمولة مكتب - شبيح الريح', '04-01-02-0080', 0.000, 'D', 0, 0, ''),
(359, 83, 'Receivables from Suppliers', '', '01-01-03-0006-0001', 285989.110, 'D', 0, 0, ''),
(363, 55, 'Provision of Re-Evaluation', 'إعادة تقييم الأصول البيولوجية', '01-01-02-01-0004', 11064.190, 'C', 0, 0, ''),
(364, 70, 'Revenue - Lavage', 'إيرادات غسيل  الرحم', '03-01-0011', 0.000, 'C', 0, 0, ''),
(365, 70, 'Revenue - Other Services', 'إيرادات خدمات أخرى', '03-01-0012', 0.000, 'C', 0, 0, ''),
(366, 75, 'Miscellaneous Show', 'مصاريف مختلفة - عروض الخيل', '04-01-01-0044', 0.000, 'D', 0, 0, ''),
(367, 75, 'Prescription Foods (Dietary)', 'وصفات و مكملات غذائية ', '04-01-01-0045', 0.000, 'D', 0, 0, ''),
(368, 75, 'Dietary Others', 'حميات غذائية', '04-01-01-0046', 0.000, 'D', 0, 0, ''),
(369, 44, 'Petty Cash - Jamal A. Aldandan', 'عهدة جمال الدندن', '01-01-01-03-0007', 0.000, 'D', 0, 0, ''),
(370, 75, 'Procedural Cost', 'تكاليف إجراءات أخرى', '04-01-01-0047', 0.000, 'D', 0, 0, ''),
(371, 75, 'Frozen Insemination (R)', 'مصاريف التلقيح المجمد', '04-01-01-0048', 0.000, 'D', 0, 0, ''),
(372, 75, 'Disposables (R)', 'مواد مستهلكه - تناسليات', '04-01-01-0049', 0.000, 'D', 0, 0, ''),
(374, 75, 'Doctors Fee (R)', 'مصاريف الإطباء', '04-01-01-0050', 0.000, 'D', 0, 0, ''),
(375, 75, 'Laboratory (R)', 'مصاريف  تحاليل و معامل ', '04-01-01-0051', 0.000, 'D', 0, 0, ''),
(376, 75, 'Vaccination (R)', 'مصاريف تلقيح', '04-01-01-0052', 0.000, 'D', 0, 0, ''),
(377, 91, 'Ramz Al-Sharq Co., LLC', 'صيدليات رمز الشرق', '02-01-02-0008-0012', 0.000, 'C', 0, 0, ''),
(378, 44, 'Petty cash - Ahmed Majdi Mohammed Salem', 'عهدة احمد مجدي سالم', '01-01-01-03-0008', 0.000, 'D', 0, 0, ''),
(380, 84, 'Juma Mohammed account', 'حساب الموظف جمعه', '01-01-03-0005-0024', 0.000, 'D', 0, 0, ''),
(381, 84, 'Valdeci Agrepino account', 'حساب الموظف فالديسي', '01-01-03-0005-0025', 0.000, 'D', 0, 0, ''),
(383, 84, 'Ibrahim Samaun', 'حساب الموظف ابراهيم سمعان', '01-01-03-0005-0026', 0.000, 'D', 0, 0, ''),
(388, 91, 'Hosinox Stainless Steel Products Co.', 'مورد مطابخ الألومنيوم - حسونيكس ', '02-01-02-0008-0013', 0.000, 'C', 0, 0, ''),
(389, 76, 'Government registration', 'رسوم حكومية و تسجيل', '04-01-02-0081', 0.000, 'D', 0, 0, ''),
(390, 91, 'Advance technics Contracting Est.', 'مؤسسة التكنولوجيا المتقدمة للمقاولات', '02-01-02-0008-0014', 0.000, 'C', 0, 0, ''),
(392, 75, 'Refreshment (General)', 'مصاريف ضيافه عامة', '04-01-01-0053', 0.000, 'D', 0, 0, ''),
(393, 75, 'Cleaning/Janitorial Supplies', 'ادوات و خامات للنظافة', '04-01-01-0054', 0.000, 'D', 0, 0, ''),
(394, 75, 'Travel expenses', 'مصاريف سفر  و رحلات', '04-01-01-0055', 0.000, 'D', 0, 0, ''),
(395, 76, 'Zakat Expense', 'مصاريف الزكاة', '04-01-02-0082', 0.000, 'D', 0, 0, ''),
(396, 80, 'Gain on Re-Evaluation of Assets', 'أرباح إعادة تقييم الأصول', '03-02-0006', 0.000, 'C', 0, 0, ''),
(397, 81, 'Loss on Re-Evaluation of Asset', 'خسائر   إعادة تقييم الأصول', '04-02-0005', 0.000, 'D', 0, 0, ''),
(398, 25, 'Accrued - Payroll', 'مستحقات الرواتب', '02-01-01-0005', 0.000, 'D', 0, 0, ''),
(399, 25, 'Accrued - Vacation Ticket', 'مستحقات رواتب الإجازات', '02-01-03-0006', 0.000, 'D', 0, 0, ''),
(400, 25, 'Accrued - Vacation Dues', 'مستحقات مخصص الإجازات', '02-01-03-0007', 0.000, 'D', 0, 0, ''),
(401, 25, 'Accrued- EOS Dues', 'مستحقات رواتب نهاية الخدمة', '02-01-03-0008', 0.000, 'D', 0, 0, ''),
(402, 50, 'Royal Feeds', 'اعلاف مميزة', '01-01-04-06-0016', 0.000, 'D', 0, 0, ''),
(403, 75, 'Customer Refund', 'استرداد مبالغ للعملاء', '04-01-01-0056', 0.000, 'D', 0, 0, ''),
(404, 76, 'Drivers License', 'رسوم رخص السائقيين', '04-01-02-0083', 0.000, 'D', 0, 0, ''),
(405, 81, 'Interest Expense', 'مصاريف فوائد', '04-02-0006', 0.000, 'D', 0, 0, ''),
(406, 85, 'Advances to ', '', '01-01-03-0004-0002', 0.000, 'D', 0, 0, ''),
(407, 92, 'Abdullah Ibrahim Al Abdul Alwahaab', 'عبدالله ابراهيم العبدالوهاب', '01-03-0001', 0.000, 'D', 0, 0, ''),
(408, 72, 'Advances to Mr. Nasir - Personal expenses', 'دفعات للسيد ناصر - مصاريف خاصة', '01-01-07-01-0004', 0.000, 'D', 0, 0, ''),
(409, 75, 'Race Horse Cooked Mixed Foods', 'اعلاف مخلوطة اخرى- عليقة', '04-01-01-0057', 0.000, 'D', 0, 0, ''),
(410, 75, 'Gain Freedom Feeds', 'اعلاف مخلوطة- ناعمة', '04-01-01-0058', 0.000, 'D', 0, 0, ''),
(411, 75, 'Gain Coarse Mix', 'اعلاف مخلوطة اخرى- عليقة', '04-01-01-0059', 0.000, 'D', 0, 0, ''),
(412, 75, 'Ajman Moniscione', 'حيوان منوي - عجمان منسيون', '04-01-01-0060', 0.000, 'D', 0, 0, ''),
(413, 75, 'Eks Alihandro', 'حيوان منوي - اسك اليخاندرو', '04-01-01-0061', 0.000, 'D', 0, 0, ''),
(414, 75, 'Excalibur EA', 'حيوان منو ي- اسكيليبر اي ايه', '04-01-01-0062', 0.000, 'D', 0, 0, ''),
(415, 75, 'Gazal Al Shaqab', 'حيوان منوي - غزال الشقب', '04-01-01-0063', 0.000, 'D', 0, 0, ''),
(416, 75, 'Kanz Albidayer', 'حيوان منوي - كنز البداير', '04-01-01-0064', 0.000, 'D', 0, 0, ''),
(417, 75, 'Wadee Al Shaqab', 'حيوان منوي - وادي الشقب', '04-01-01-0065', 0.000, 'D', 0, 0, ''),
(418, 75, 'Ansata Nile Echo', 'حيوان منوي - انساتا نايل ايكو', '04-01-01-0066', 0.000, 'D', 0, 0, ''),
(419, 75, 'Kahil Al Shaqab', 'حيوان منوي - كحيل الشقب', '04-01-01-0067', 0.000, 'D', 0, 0, ''),
(420, 75, 'Hariry Al Shaqab', 'حيوان منوي - حريري الشقب', '04-01-01-0068', 0.000, 'D', 0, 0, ''),
(421, 75, 'Fadi Al Shaqab', 'حيوان منوي - فادي الشقب', '04-01-01-0069', 0.000, 'D', 0, 0, ''),
(422, 75, 'SMA Magic one', 'حيوان منوي - اس ام ايه  ماجيك واان', '04-01-01-0070', 0.000, 'D', 0, 0, ''),
(423, 70, 'Sales Discount', '', '03-01-0047', 0.000, 'D', 0, 0, '');

-- --------------------------------------------------------

--
-- بنية الجدول `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- بنية الجدول `opening_cc`
--

CREATE TABLE `opening_cc` (
  `opening_id` int(11) NOT NULL,
  `op_balance` decimal(25,3) NOT NULL,
  `op_balance_dc` char(1) NOT NULL,
  `cc_id` int(11) NOT NULL,
  `ledger_id` int(11) NOT NULL,
  `updated_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `opening_cc`
--

INSERT INTO `opening_cc` (`opening_id`, `op_balance`, `op_balance_dc`, `cc_id`, `ledger_id`, `updated_date`) VALUES
(19, 0.000, 'C', 1, 12, '2018-04-17'),
(20, 0.000, 'C', 2, 12, '2018-04-17'),
(21, 0.000, 'C', 3, 12, '2018-04-17'),
(22, 0.000, 'C', 4, 12, '2018-04-17'),
(23, 0.000, 'D', 1, 13, '2018-04-17'),
(24, 0.000, 'D', 2, 13, '2018-04-17'),
(25, 0.000, 'D', 3, 13, '2018-04-17'),
(26, 0.000, 'D', 4, 13, '2018-04-17'),
(27, 0.000, 'D', 1, 111, '2018-02-27'),
(28, 0.000, 'D', 2, 111, '2018-02-27'),
(29, 0.000, 'D', 3, 111, '2018-02-27'),
(30, 0.000, 'D', 4, 111, '2018-02-27'),
(31, 0.000, 'C', 1, 240, '2018-05-16'),
(32, 204613.000, 'C', 2, 240, '2018-05-16'),
(33, 0.000, 'C', 3, 240, '2018-05-16'),
(34, 0.000, 'C', 4, 240, '2018-05-16'),
(35, 0.000, 'D', 1, 247, '2018-06-10'),
(36, 0.000, 'D', 2, 247, '2018-06-10'),
(37, 0.000, 'D', 3, 247, '2018-06-10'),
(38, 0.000, 'D', 4, 247, '2018-06-10'),
(39, 0.000, 'D', 1, 248, '2018-05-02'),
(40, 0.000, 'D', 2, 248, '2018-05-02'),
(41, 0.000, 'D', 3, 248, '2018-05-02'),
(42, 0.000, 'D', 4, 248, '2018-05-02'),
(43, 0.000, 'D', 1, 249, '2018-05-15'),
(44, 0.000, 'D', 2, 249, '2018-05-15'),
(45, 3000.000, 'D', 3, 249, '2018-05-15'),
(46, 0.000, 'D', 4, 249, '2018-05-15'),
(47, 0.000, 'D', 1, 250, '2018-04-17'),
(48, 0.000, 'D', 2, 250, '2018-04-17'),
(49, 0.000, 'D', 3, 250, '2018-04-17'),
(50, 0.000, 'D', 4, 250, '2018-04-17'),
(51, 0.000, 'D', 1, 251, '2018-04-17'),
(52, 0.000, 'D', 2, 251, '2018-04-17'),
(53, 0.000, 'D', 3, 251, '2018-04-17'),
(54, 0.000, 'D', 4, 251, '2018-04-17'),
(55, 0.000, 'D', 1, 253, '2018-05-02'),
(56, 0.000, 'D', 2, 253, '2018-05-02'),
(57, 0.000, 'D', 3, 253, '2018-05-02'),
(58, 0.000, 'D', 4, 253, '2018-05-02'),
(59, 0.000, 'D', 1, 254, '2018-04-17'),
(60, 0.000, 'D', 2, 254, '2018-04-17'),
(61, 0.000, 'D', 3, 254, '2018-04-17'),
(62, 0.000, 'D', 4, 254, '2018-04-17'),
(63, 0.000, 'D', 1, 255, '2018-04-17'),
(64, 0.000, 'D', 2, 255, '2018-04-17'),
(65, 0.000, 'D', 3, 255, '2018-04-17'),
(66, 0.000, 'D', 4, 255, '2018-04-17'),
(67, 0.000, 'D', 1, 256, '2018-06-05'),
(68, 0.000, 'D', 2, 256, '2018-06-05'),
(69, 0.000, 'D', 3, 256, '2018-06-05'),
(70, 0.000, 'D', 4, 256, '2018-06-05'),
(71, 0.000, 'D', 1, 257, '2018-04-17'),
(72, 0.000, 'D', 2, 257, '2018-04-17'),
(73, 0.000, 'D', 3, 257, '2018-04-17'),
(74, 0.000, 'D', 4, 257, '2018-04-17'),
(75, 0.000, 'D', 1, 258, '2018-04-17'),
(76, 0.000, 'D', 2, 258, '2018-04-17'),
(77, 0.000, 'D', 3, 258, '2018-04-17'),
(78, 0.000, 'D', 4, 258, '2018-04-17'),
(79, 0.000, 'D', 1, 259, '2018-04-17'),
(80, 0.000, 'D', 2, 259, '2018-04-17'),
(81, 0.000, 'D', 3, 259, '2018-04-17'),
(82, 0.000, 'D', 4, 259, '2018-04-17'),
(83, 0.000, 'D', 1, 260, '2018-04-17'),
(84, 0.000, 'D', 2, 260, '2018-04-17'),
(85, 0.000, 'D', 3, 260, '2018-04-17'),
(86, 0.000, 'D', 4, 260, '2018-04-17'),
(87, 0.000, 'D', 1, 261, '2018-04-23'),
(88, 0.000, 'D', 2, 261, '2018-04-23'),
(89, 0.000, 'D', 3, 261, '2018-04-23'),
(90, 0.000, 'D', 4, 261, '2018-04-23'),
(91, 0.000, 'D', 1, 166, '2018-06-10'),
(92, 0.000, 'D', 2, 166, '2018-06-10'),
(93, 0.000, 'D', 3, 166, '2018-06-10'),
(94, 0.000, 'D', 4, 166, '2018-06-10'),
(95, 0.000, 'D', 1, 262, '2018-04-17'),
(96, 0.000, 'D', 2, 262, '2018-04-17'),
(97, 0.000, 'D', 3, 262, '2018-04-17'),
(98, 0.000, 'D', 4, 262, '2018-04-17'),
(99, 0.000, 'D', 1, 263, '2018-04-17'),
(100, 0.000, 'D', 2, 263, '2018-04-17'),
(101, 0.000, 'D', 3, 263, '2018-04-17'),
(102, 0.000, 'D', 4, 263, '2018-04-17'),
(103, 0.000, 'D', 1, 264, '2018-04-17'),
(104, 0.000, 'D', 2, 264, '2018-04-17'),
(105, 0.000, 'D', 3, 264, '2018-04-17'),
(106, 0.000, 'D', 4, 264, '2018-04-17'),
(107, 0.000, 'D', 1, 265, '2018-04-17'),
(108, 0.000, 'D', 2, 265, '2018-04-17'),
(109, 0.000, 'D', 3, 265, '2018-04-17'),
(110, 0.000, 'D', 4, 265, '2018-04-17'),
(111, 0.000, 'D', 1, 266, '2018-02-28'),
(112, 0.000, 'D', 2, 266, '2018-02-28'),
(113, 0.000, 'D', 3, 266, '2018-02-28'),
(114, 0.000, 'D', 4, 266, '2018-02-28'),
(115, 780110.990, 'D', 1, 5, '2018-05-30'),
(116, 2781289.370, 'D', 2, 5, '2018-05-30'),
(117, 3535902.870, 'C', 3, 5, '2018-05-30'),
(118, 0.000, 'D', 4, 5, '2018-05-30'),
(119, 0.000, 'D', 1, 267, '2018-05-16'),
(120, 0.000, 'D', 2, 267, '2018-05-16'),
(121, 393661.190, 'D', 3, 267, '2018-05-16'),
(122, 0.000, 'D', 4, 267, '2018-05-16'),
(123, 0.000, 'C', 1, 25, '2018-05-16'),
(124, 0.000, 'C', 2, 25, '2018-05-16'),
(125, 79000.000, 'C', 3, 25, '2018-05-16'),
(126, 0.000, 'C', 4, 25, '2018-05-16'),
(127, 0.000, 'C', 1, 26, '2018-04-17'),
(128, 0.000, 'C', 2, 26, '2018-04-17'),
(129, 0.000, 'C', 3, 26, '2018-04-17'),
(130, 0.000, 'C', 4, 26, '2018-04-17'),
(131, 0.000, 'D', 1, 268, '2018-04-17'),
(132, 0.000, 'D', 2, 268, '2018-04-17'),
(133, 0.000, 'D', 3, 268, '2018-04-17'),
(134, 0.000, 'D', 4, 268, '2018-04-17'),
(135, 0.000, 'C', 1, 269, '2018-04-17'),
(136, 0.000, 'C', 2, 269, '2018-04-17'),
(137, 0.000, 'C', 3, 269, '2018-04-17'),
(138, 0.000, 'C', 4, 269, '2018-04-17'),
(139, 0.000, 'C', 1, 270, '2018-04-17'),
(140, 0.000, 'C', 2, 270, '2018-04-17'),
(141, 0.000, 'C', 3, 270, '2018-04-17'),
(142, 0.000, 'C', 4, 270, '2018-04-17'),
(143, 0.000, 'D', 1, 271, '2018-04-17'),
(144, 0.000, 'D', 2, 271, '2018-04-17'),
(145, 0.000, 'D', 3, 271, '2018-04-17'),
(146, 0.000, 'D', 4, 271, '2018-04-17'),
(147, 0.000, 'D', 1, 272, '2018-04-17'),
(148, 0.000, 'D', 2, 272, '2018-04-17'),
(149, 0.000, 'D', 3, 272, '2018-04-17'),
(150, 0.000, 'D', 4, 272, '2018-04-17'),
(151, 0.000, 'D', 1, 273, '2018-04-17'),
(152, 0.000, 'D', 2, 273, '2018-04-17'),
(153, 0.000, 'D', 3, 273, '2018-04-17'),
(154, 0.000, 'D', 4, 273, '2018-04-17'),
(155, 0.000, 'D', 1, 274, '2018-04-17'),
(156, 0.000, 'D', 2, 274, '2018-04-17'),
(157, 0.000, 'D', 3, 274, '2018-04-17'),
(158, 0.000, 'D', 4, 274, '2018-04-17'),
(159, 0.000, 'D', 1, 164, '2018-04-17'),
(160, 0.000, 'D', 2, 164, '2018-04-17'),
(161, 0.000, 'D', 3, 164, '2018-04-17'),
(162, 0.000, 'D', 4, 164, '2018-04-17'),
(163, 0.000, 'D', 1, 275, '2018-04-17'),
(164, 0.000, 'D', 2, 275, '2018-04-17'),
(165, 0.000, 'D', 3, 275, '2018-04-17'),
(166, 0.000, 'D', 4, 275, '2018-04-17'),
(167, 0.000, 'C', 1, 39, '2018-04-17'),
(168, 0.000, 'C', 2, 39, '2018-04-17'),
(169, 0.000, 'C', 3, 39, '2018-04-17'),
(170, 0.000, 'C', 4, 39, '2018-04-17'),
(171, 0.000, 'C', 1, 219, '2018-04-17'),
(172, 0.000, 'C', 2, 219, '2018-04-17'),
(173, 0.000, 'C', 3, 219, '2018-04-17'),
(174, 0.000, 'C', 4, 219, '2018-04-17'),
(175, 0.000, 'C', 1, 237, '2018-05-16'),
(176, 0.000, 'C', 2, 237, '2018-05-16'),
(177, 36824.000, 'C', 3, 237, '2018-05-16'),
(178, 0.000, 'C', 4, 237, '2018-05-16'),
(179, 0.000, 'C', 1, 238, '2018-04-17'),
(180, 0.000, 'C', 2, 238, '2018-04-17'),
(181, 0.000, 'C', 3, 238, '2018-04-17'),
(182, 0.000, 'C', 4, 238, '2018-04-17'),
(183, 0.000, 'C', 1, 239, '2018-04-17'),
(184, 0.000, 'C', 2, 239, '2018-04-17'),
(185, 0.000, 'C', 3, 239, '2018-04-17'),
(186, 0.000, 'C', 4, 239, '2018-04-17'),
(187, 0.000, 'C', 1, 276, '2018-04-17'),
(188, 0.000, 'C', 2, 276, '2018-04-17'),
(189, 0.000, 'C', 3, 276, '2018-04-17'),
(190, 0.000, 'C', 4, 276, '2018-04-17'),
(191, 0.000, 'D', 1, 277, '2018-04-17'),
(192, 0.000, 'D', 2, 277, '2018-04-17'),
(193, 0.000, 'D', 3, 277, '2018-04-17'),
(194, 0.000, 'D', 4, 277, '2018-04-17'),
(195, 0.000, 'D', 1, 278, '2018-04-17'),
(196, 0.000, 'D', 2, 278, '2018-04-17'),
(197, 0.000, 'D', 3, 278, '2018-04-17'),
(198, 0.000, 'D', 4, 278, '2018-04-17'),
(199, 0.000, 'D', 1, 279, '2018-04-17'),
(200, 0.000, 'D', 2, 279, '2018-04-17'),
(201, 0.000, 'D', 3, 279, '2018-04-17'),
(202, 0.000, 'D', 4, 279, '2018-04-17'),
(203, 0.000, 'C', 1, 280, '2018-04-17'),
(204, 0.000, 'C', 2, 280, '2018-04-17'),
(205, 0.000, 'C', 3, 280, '2018-04-17'),
(206, 0.000, 'C', 4, 280, '2018-04-17'),
(207, 0.000, 'D', 1, 281, '2018-07-18'),
(208, 0.000, 'D', 2, 281, '2018-07-18'),
(209, 0.000, 'D', 3, 281, '2018-07-18'),
(210, 0.000, 'D', 4, 281, '2018-07-18'),
(211, 0.000, 'D', 1, 285, '2018-07-18'),
(212, 0.000, 'D', 2, 285, '2018-07-18'),
(213, 0.000, 'D', 3, 285, '2018-07-18'),
(214, 0.000, 'D', 4, 285, '2018-07-18'),
(215, 0.000, 'D', 1, 288, '2018-07-18'),
(216, 0.000, 'D', 2, 288, '2018-07-18'),
(217, 0.000, 'D', 3, 288, '2018-07-18'),
(218, 0.000, 'D', 4, 288, '2018-07-18'),
(219, 0.000, 'D', 1, 289, '2018-07-18'),
(220, 0.000, 'D', 2, 289, '2018-07-18'),
(221, 0.000, 'D', 3, 289, '2018-07-18'),
(222, 0.000, 'D', 4, 289, '2018-07-18'),
(223, 0.000, 'D', 1, 290, '2018-07-18'),
(224, 0.000, 'D', 2, 290, '2018-07-18'),
(225, 0.000, 'C', 3, 290, '2018-07-18'),
(226, 0.000, 'D', 4, 290, '2018-07-18'),
(227, 0.000, 'C', 1, 291, '2018-04-17'),
(228, 0.000, 'C', 2, 291, '2018-04-17'),
(229, 0.000, 'C', 3, 291, '2018-04-17'),
(230, 0.000, 'C', 4, 291, '2018-04-17'),
(231, 0.000, 'C', 1, 292, '2018-04-17'),
(232, 0.000, 'C', 2, 292, '2018-04-17'),
(233, 0.000, 'C', 3, 292, '2018-04-17'),
(234, 0.000, 'C', 4, 292, '2018-04-17'),
(235, 0.000, 'C', 1, 46, '2018-05-16'),
(236, 0.000, 'C', 2, 46, '2018-05-16'),
(237, 2344787.130, 'C', 3, 46, '2018-05-16'),
(238, 0.000, 'C', 4, 46, '2018-05-16'),
(239, 0.000, 'D', 1, 293, '2018-04-05'),
(240, 0.000, 'D', 2, 293, '2018-04-05'),
(241, 0.000, 'D', 3, 293, '2018-04-05'),
(242, 0.000, 'D', 4, 293, '2018-04-05'),
(243, 0.000, 'D', 1, 294, '2018-07-18'),
(244, 0.000, 'D', 2, 294, '2018-07-18'),
(245, 2800.000, 'D', 3, 294, '2018-07-18'),
(246, 0.000, 'D', 4, 294, '2018-07-18'),
(247, 0.000, 'D', 1, 295, '2018-07-18'),
(248, 0.000, 'D', 2, 295, '2018-07-18'),
(249, 0.000, 'D', 3, 295, '2018-07-18'),
(250, 0.000, 'D', 4, 295, '2018-07-18'),
(251, 0.000, 'D', 1, 296, '2018-07-18'),
(252, 0.000, 'D', 2, 296, '2018-07-18'),
(253, 0.000, 'D', 3, 296, '2018-07-18'),
(254, 0.000, 'D', 4, 296, '2018-07-18'),
(255, 0.000, 'D', 1, 297, '2018-07-18'),
(256, 0.000, 'D', 2, 297, '2018-07-18'),
(257, 0.000, 'D', 3, 297, '2018-07-18'),
(258, 0.000, 'D', 4, 297, '2018-07-18'),
(259, 0.000, 'D', 1, 298, '2018-07-18'),
(260, 0.000, 'D', 2, 298, '2018-07-18'),
(261, 0.000, 'D', 3, 298, '2018-07-18'),
(262, 0.000, 'D', 4, 298, '2018-07-18'),
(263, 0.000, 'D', 1, 299, '2018-07-18'),
(264, 0.000, 'D', 2, 299, '2018-07-18'),
(265, 0.000, 'D', 3, 299, '2018-07-18'),
(266, 0.000, 'D', 4, 299, '2018-07-18'),
(267, 0.000, 'D', 1, 300, '2018-07-18'),
(268, 0.000, 'D', 2, 300, '2018-07-18'),
(269, 0.000, 'D', 3, 300, '2018-07-18'),
(270, 0.000, 'D', 4, 300, '2018-07-18'),
(271, 0.000, 'D', 1, 301, '2018-07-18'),
(272, 0.000, 'D', 2, 301, '2018-07-18'),
(273, 0.000, 'D', 3, 301, '2018-07-18'),
(274, 0.000, 'D', 4, 301, '2018-07-18'),
(275, 0.000, 'D', 1, 302, '2018-07-18'),
(276, 0.000, 'D', 2, 302, '2018-07-18'),
(277, 0.000, 'D', 3, 302, '2018-07-18'),
(278, 0.000, 'D', 4, 302, '2018-07-18'),
(279, 0.000, 'D', 1, 6, '2018-04-17'),
(280, 0.000, 'D', 2, 6, '2018-04-17'),
(281, 0.000, 'D', 3, 6, '2018-04-17'),
(282, 0.000, 'D', 4, 6, '2018-04-17'),
(283, 0.000, 'D', 1, 7, '2018-04-17'),
(284, 0.000, 'D', 2, 7, '2018-04-17'),
(285, 0.000, 'D', 3, 7, '2018-04-17'),
(286, 0.000, 'D', 4, 7, '2018-04-17'),
(287, 0.000, 'D', 1, 8, '2018-04-17'),
(288, 0.000, 'D', 2, 8, '2018-04-17'),
(289, 0.000, 'D', 3, 8, '2018-04-17'),
(290, 0.000, 'D', 4, 8, '2018-04-17'),
(291, 0.000, 'D', 1, 9, '2018-04-17'),
(292, 0.000, 'D', 2, 9, '2018-04-17'),
(293, 0.000, 'D', 3, 9, '2018-04-17'),
(294, 0.000, 'D', 4, 9, '2018-04-17'),
(295, 0.000, 'D', 1, 220, '2018-04-17'),
(296, 0.000, 'D', 2, 220, '2018-04-17'),
(297, 0.000, 'D', 3, 220, '2018-04-17'),
(298, 0.000, 'D', 4, 220, '2018-04-17'),
(299, 0.000, 'D', 1, 221, '2018-06-03'),
(300, 0.000, 'D', 2, 221, '2018-06-03'),
(301, 128033.740, 'D', 3, 221, '2018-06-03'),
(302, 0.000, 'D', 4, 221, '2018-06-03'),
(303, 0.000, 'D', 1, 244, '2018-04-17'),
(304, 0.000, 'D', 2, 244, '2018-04-17'),
(305, 0.000, 'D', 3, 244, '2018-04-17'),
(306, 0.000, 'D', 4, 244, '2018-04-17'),
(307, 0.000, 'D', 1, 245, '2018-04-17'),
(308, 0.000, 'D', 2, 245, '2018-04-17'),
(309, 0.000, 'D', 3, 245, '2018-04-17'),
(310, 0.000, 'D', 4, 245, '2018-04-17'),
(311, 0.000, 'D', 1, 10, '2018-05-15'),
(312, 2173957.600, 'D', 2, 10, '2018-05-15'),
(313, 0.000, 'D', 3, 10, '2018-05-15'),
(314, 0.000, 'D', 4, 10, '2018-05-15'),
(315, 0.000, 'D', 1, 66, '2018-05-16'),
(316, 176727.250, 'D', 2, 66, '2018-05-16'),
(317, 0.000, 'D', 3, 66, '2018-05-16'),
(318, 0.000, 'D', 4, 66, '2018-05-16'),
(319, 0.000, 'D', 1, 67, '2018-05-16'),
(320, 47065.000, 'D', 2, 67, '2018-05-16'),
(321, 0.000, 'D', 3, 67, '2018-05-16'),
(322, 0.000, 'D', 4, 67, '2018-05-16'),
(323, 0.000, 'D', 1, 68, '2018-04-17'),
(324, 0.000, 'D', 2, 68, '2018-04-17'),
(325, 0.000, 'D', 3, 68, '2018-04-17'),
(326, 0.000, 'D', 4, 68, '2018-04-17'),
(327, 0.000, 'D', 1, 69, '2018-04-17'),
(328, 0.000, 'D', 2, 69, '2018-04-17'),
(329, 0.000, 'D', 3, 69, '2018-04-17'),
(330, 0.000, 'D', 4, 69, '2018-04-17'),
(331, 0.000, 'D', 1, 70, '2018-05-16'),
(332, 171658.060, 'D', 2, 70, '2018-05-16'),
(333, 0.000, 'D', 3, 70, '2018-05-16'),
(334, 0.000, 'D', 4, 70, '2018-05-16'),
(335, 0.000, 'D', 1, 71, '2018-04-17'),
(336, 0.000, 'D', 2, 71, '2018-04-17'),
(337, 0.000, 'D', 3, 71, '2018-04-17'),
(338, 0.000, 'D', 4, 71, '2018-04-17'),
(339, 0.000, 'D', 1, 72, '2018-04-17'),
(340, 0.000, 'D', 2, 72, '2018-04-17'),
(341, 0.000, 'D', 3, 72, '2018-04-17'),
(342, 0.000, 'D', 4, 72, '2018-04-17'),
(343, 0.000, 'D', 1, 73, '2018-04-17'),
(344, 0.000, 'D', 2, 73, '2018-04-17'),
(345, 0.000, 'D', 3, 73, '2018-04-17'),
(346, 0.000, 'D', 4, 73, '2018-04-17'),
(347, 0.000, 'D', 1, 74, '2018-04-17'),
(348, 0.000, 'D', 2, 74, '2018-04-17'),
(349, 0.000, 'D', 3, 74, '2018-04-17'),
(350, 0.000, 'D', 4, 74, '2018-04-17'),
(351, 0.000, 'D', 1, 75, '2018-04-17'),
(352, 0.000, 'D', 2, 75, '2018-04-17'),
(353, 0.000, 'D', 3, 75, '2018-04-17'),
(354, 0.000, 'D', 4, 75, '2018-04-17'),
(355, 0.000, 'D', 1, 76, '2018-04-17'),
(356, 0.000, 'D', 2, 76, '2018-04-17'),
(357, 0.000, 'D', 3, 76, '2018-04-17'),
(358, 0.000, 'D', 4, 76, '2018-04-17'),
(359, 0.000, 'D', 1, 77, '2018-04-17'),
(360, 0.000, 'D', 2, 77, '2018-04-17'),
(361, 0.000, 'D', 3, 77, '2018-04-17'),
(362, 0.000, 'D', 4, 77, '2018-04-17'),
(363, 0.000, 'D', 1, 78, '2018-04-17'),
(364, 0.000, 'D', 2, 78, '2018-04-17'),
(365, 0.000, 'D', 3, 78, '2018-04-17'),
(366, 0.000, 'D', 4, 78, '2018-04-17'),
(367, 0.000, 'D', 1, 79, '2018-04-17'),
(368, 0.000, 'D', 2, 79, '2018-04-17'),
(369, 0.000, 'D', 3, 79, '2018-04-17'),
(370, 0.000, 'D', 4, 79, '2018-04-17'),
(371, 0.000, 'D', 1, 80, '2018-05-16'),
(372, 38967.080, 'D', 2, 80, '2018-05-16'),
(373, 0.000, 'D', 3, 80, '2018-05-16'),
(374, 0.000, 'D', 4, 80, '2018-05-16'),
(375, 0.000, 'D', 1, 81, '2018-05-16'),
(376, 47812.500, 'D', 2, 81, '2018-05-16'),
(377, 0.000, 'D', 3, 81, '2018-05-16'),
(378, 0.000, 'D', 4, 81, '2018-05-16'),
(379, 0.000, 'D', 1, 82, '2018-05-16'),
(380, 78860.500, 'D', 2, 82, '2018-05-16'),
(381, 0.000, 'D', 3, 82, '2018-05-16'),
(382, 0.000, 'D', 4, 82, '2018-05-16'),
(383, 0.000, 'D', 1, 83, '2018-05-16'),
(384, 187900.000, 'D', 2, 83, '2018-05-16'),
(385, 0.000, 'D', 3, 83, '2018-05-16'),
(386, 0.000, 'D', 4, 83, '2018-05-16'),
(387, 0.000, 'D', 1, 84, '2018-04-17'),
(388, 0.000, 'D', 2, 84, '2018-04-17'),
(389, 0.000, 'D', 3, 84, '2018-04-17'),
(390, 0.000, 'D', 4, 84, '2018-04-17'),
(391, 0.000, 'D', 1, 85, '2018-05-16'),
(392, 94206.880, 'D', 2, 85, '2018-05-16'),
(393, 0.000, 'D', 3, 85, '2018-05-16'),
(394, 0.000, 'D', 4, 85, '2018-05-16'),
(395, 0.000, 'D', 1, 18, '2018-04-17'),
(396, 0.000, 'D', 2, 18, '2018-04-17'),
(397, 0.000, 'D', 3, 18, '2018-04-17'),
(398, 0.000, 'D', 4, 18, '2018-04-17'),
(399, 0.000, 'D', 1, 19, '2018-04-17'),
(400, 0.000, 'D', 2, 19, '2018-04-17'),
(401, 0.000, 'D', 3, 19, '2018-04-17'),
(402, 0.000, 'D', 4, 19, '2018-04-17'),
(403, 0.000, 'D', 1, 86, '2018-04-17'),
(404, 0.000, 'D', 2, 86, '2018-04-17'),
(405, 0.000, 'D', 3, 86, '2018-04-17'),
(406, 0.000, 'D', 4, 86, '2018-04-17'),
(407, 0.000, 'D', 1, 87, '2018-04-17'),
(408, 0.000, 'D', 2, 87, '2018-04-17'),
(409, 0.000, 'D', 3, 87, '2018-04-17'),
(410, 0.000, 'D', 4, 87, '2018-04-17'),
(411, 0.000, 'D', 1, 88, '2018-04-17'),
(412, 0.000, 'D', 2, 88, '2018-04-17'),
(413, 0.000, 'D', 3, 88, '2018-04-17'),
(414, 0.000, 'D', 4, 88, '2018-04-17'),
(415, 0.000, 'D', 1, 89, '2018-04-17'),
(416, 0.000, 'D', 2, 89, '2018-04-17'),
(417, 0.000, 'D', 3, 89, '2018-04-17'),
(418, 0.000, 'D', 4, 89, '2018-04-17'),
(419, 0.000, 'D', 1, 90, '2018-04-17'),
(420, 0.000, 'D', 2, 90, '2018-04-17'),
(421, 0.000, 'D', 3, 90, '2018-04-17'),
(422, 0.000, 'D', 4, 90, '2018-04-17'),
(423, 0.000, 'D', 1, 91, '2018-06-28'),
(424, 0.000, 'D', 2, 91, '2018-06-28'),
(425, 0.000, 'D', 3, 91, '2018-06-28'),
(426, 0.000, 'D', 4, 91, '2018-06-28'),
(427, 0.000, 'D', 1, 92, '2018-04-17'),
(428, 0.000, 'D', 2, 92, '2018-04-17'),
(429, 0.000, 'D', 3, 92, '2018-04-17'),
(430, 0.000, 'D', 4, 92, '2018-04-17'),
(431, 0.000, 'D', 1, 93, '2018-04-17'),
(432, 0.000, 'D', 2, 93, '2018-04-17'),
(433, 0.000, 'D', 3, 93, '2018-04-17'),
(434, 0.000, 'D', 4, 93, '2018-04-17'),
(435, 0.000, 'D', 1, 94, '2018-04-17'),
(436, 0.000, 'D', 2, 94, '2018-04-17'),
(437, 0.000, 'D', 3, 94, '2018-04-17'),
(438, 0.000, 'D', 4, 94, '2018-04-17'),
(439, 0.000, 'D', 1, 95, '2018-04-17'),
(440, 0.000, 'D', 2, 95, '2018-04-17'),
(441, 0.000, 'D', 3, 95, '2018-04-17'),
(442, 0.000, 'D', 4, 95, '2018-04-17'),
(443, 0.000, 'D', 1, 96, '2018-04-17'),
(444, 0.000, 'D', 2, 96, '2018-04-17'),
(445, 0.000, 'D', 3, 96, '2018-04-17'),
(446, 0.000, 'D', 4, 96, '2018-04-17'),
(447, 0.000, 'D', 1, 20, '2018-05-16'),
(448, 0.000, 'D', 2, 20, '2018-05-16'),
(449, 20102.000, 'D', 3, 20, '2018-05-16'),
(450, 0.000, 'D', 4, 20, '2018-05-16'),
(451, 0.000, 'D', 1, 21, '2018-05-16'),
(452, 0.000, 'D', 2, 21, '2018-05-16'),
(453, 16358.720, 'D', 3, 21, '2018-05-16'),
(454, 0.000, 'D', 4, 21, '2018-05-16'),
(455, 0.000, 'D', 1, 22, '2018-04-17'),
(456, 0.000, 'D', 2, 22, '2018-04-17'),
(457, 0.000, 'D', 3, 22, '2018-04-17'),
(458, 0.000, 'D', 4, 22, '2018-04-17'),
(459, 0.000, 'D', 1, 23, '2018-04-17'),
(460, 0.000, 'D', 2, 23, '2018-04-17'),
(461, 0.000, 'D', 3, 23, '2018-04-17'),
(462, 0.000, 'D', 4, 23, '2018-04-17'),
(463, 0.000, 'D', 1, 24, '2018-04-17'),
(464, 0.000, 'D', 2, 24, '2018-04-17'),
(465, 0.000, 'D', 3, 24, '2018-04-17'),
(466, 0.000, 'D', 4, 24, '2018-04-17'),
(467, 0.000, 'C', 1, 35, '2018-05-16'),
(468, 0.000, 'C', 2, 35, '2018-05-16'),
(469, 38622.000, 'C', 3, 35, '2018-05-16'),
(470, 0.000, 'C', 4, 35, '2018-05-16'),
(471, 0.000, 'D', 1, 230, '2018-05-16'),
(472, 0.000, 'D', 2, 230, '2018-05-16'),
(473, 56498.000, 'D', 3, 230, '2018-05-16'),
(474, 0.000, 'D', 4, 230, '2018-05-16'),
(475, 0.000, 'D', 1, 102, '2018-06-03'),
(476, 0.000, 'D', 2, 102, '2018-06-03'),
(477, 12129748.860, 'D', 3, 102, '2018-06-03'),
(478, 0.000, 'D', 4, 102, '2018-06-03'),
(479, 0.000, 'D', 1, 103, '2018-04-17'),
(480, 0.000, 'D', 2, 103, '2018-04-17'),
(481, 0.000, 'D', 3, 103, '2018-04-17'),
(482, 0.000, 'D', 4, 103, '2018-04-17'),
(483, 0.000, 'D', 1, 104, '2018-04-17'),
(484, 0.000, 'D', 2, 104, '2018-04-17'),
(485, 0.000, 'D', 3, 104, '2018-04-17'),
(486, 0.000, 'D', 4, 104, '2018-04-17'),
(487, 0.000, 'D', 1, 105, '2018-04-17'),
(488, 0.000, 'D', 2, 105, '2018-04-17'),
(489, 0.000, 'D', 3, 105, '2018-04-17'),
(490, 0.000, 'D', 4, 105, '2018-04-17'),
(491, 0.000, 'D', 1, 106, '2018-04-17'),
(492, 0.000, 'D', 2, 106, '2018-04-17'),
(493, 0.000, 'D', 3, 106, '2018-04-17'),
(494, 0.000, 'D', 4, 106, '2018-04-17'),
(495, 0.000, 'D', 1, 107, '2018-04-17'),
(496, 0.000, 'D', 2, 107, '2018-04-17'),
(497, 0.000, 'D', 3, 107, '2018-04-17'),
(498, 0.000, 'D', 4, 107, '2018-04-17'),
(499, 0.000, 'D', 1, 108, '2018-04-17'),
(500, 0.000, 'D', 2, 108, '2018-04-17'),
(501, 0.000, 'D', 3, 108, '2018-04-17'),
(502, 0.000, 'D', 4, 108, '2018-04-17'),
(503, 0.000, 'D', 1, 109, '2018-05-16'),
(504, 0.000, 'D', 2, 109, '2018-05-16'),
(505, 43604.000, 'D', 3, 109, '2018-05-16'),
(506, 0.000, 'D', 4, 109, '2018-05-16'),
(507, 0.000, 'D', 1, 110, '2018-04-17'),
(508, 0.000, 'D', 2, 110, '2018-04-17'),
(509, 0.000, 'D', 3, 110, '2018-04-17'),
(510, 0.000, 'D', 4, 110, '2018-04-17'),
(511, 0.000, 'D', 1, 112, '2018-04-17'),
(512, 0.000, 'D', 2, 112, '2018-04-17'),
(513, 0.000, 'D', 3, 112, '2018-04-17'),
(514, 0.000, 'D', 4, 112, '2018-04-17'),
(515, 0.000, 'D', 1, 232, '2018-04-17'),
(516, 0.000, 'D', 2, 232, '2018-04-17'),
(517, 0.000, 'D', 3, 232, '2018-04-17'),
(518, 0.000, 'D', 4, 232, '2018-04-17'),
(519, 0.000, 'C', 1, 27, '2018-05-16'),
(520, 0.000, 'C', 2, 27, '2018-05-16'),
(521, 91506.000, 'C', 3, 27, '2018-05-16'),
(522, 0.000, 'C', 4, 27, '2018-05-16'),
(523, 0.000, 'D', 1, 227, '2018-05-16'),
(524, 0.000, 'D', 2, 227, '2018-05-16'),
(525, 326546.300, 'D', 3, 227, '2018-05-16'),
(526, 0.000, 'D', 4, 227, '2018-05-16'),
(527, 0.000, 'C', 1, 28, '2018-05-16'),
(528, 0.000, 'C', 2, 28, '2018-05-16'),
(529, 54713.000, 'C', 3, 28, '2018-05-16'),
(530, 0.000, 'C', 4, 28, '2018-05-16'),
(531, 0.000, 'D', 1, 226, '2018-07-18'),
(532, 0.000, 'D', 2, 226, '2018-07-18'),
(533, 259650.000, 'D', 3, 226, '2018-07-18'),
(534, 0.000, 'D', 4, 226, '2018-07-18'),
(535, 0.000, 'C', 1, 29, '2018-05-16'),
(536, 0.000, 'C', 2, 29, '2018-05-16'),
(537, 18950.000, 'C', 3, 29, '2018-05-16'),
(538, 0.000, 'C', 4, 29, '2018-05-16'),
(539, 0.000, 'D', 1, 223, '2018-05-16'),
(540, 0.000, 'D', 2, 223, '2018-05-16'),
(541, 81715.500, 'D', 3, 223, '2018-05-16'),
(542, 0.000, 'D', 4, 223, '2018-05-16'),
(543, 0.000, 'C', 1, 30, '2018-05-16'),
(544, 0.000, 'C', 2, 30, '2018-05-16'),
(545, 15847.500, 'C', 3, 30, '2018-05-16'),
(546, 0.000, 'C', 4, 30, '2018-05-16'),
(547, 0.000, 'D', 1, 225, '2018-05-16'),
(548, 0.000, 'D', 2, 225, '2018-05-16'),
(549, 53504.360, 'D', 3, 225, '2018-05-16'),
(550, 0.000, 'D', 4, 225, '2018-05-16'),
(551, 0.000, 'C', 1, 31, '2018-05-16'),
(552, 0.000, 'C', 2, 31, '2018-05-16'),
(553, 134039.000, 'C', 3, 31, '2018-05-16'),
(554, 0.000, 'C', 4, 31, '2018-05-16'),
(555, 0.000, 'D', 1, 224, '2018-05-16'),
(556, 0.000, 'D', 2, 224, '2018-05-16'),
(557, 350277.740, 'D', 3, 224, '2018-05-16'),
(558, 0.000, 'D', 4, 224, '2018-05-16'),
(559, 0.000, 'C', 1, 32, '2018-05-16'),
(560, 0.000, 'C', 2, 32, '2018-05-16'),
(561, 30912.000, 'C', 3, 32, '2018-05-16'),
(562, 0.000, 'C', 4, 32, '2018-05-16'),
(563, 0.000, 'D', 1, 228, '2018-05-16'),
(564, 0.000, 'D', 2, 228, '2018-05-16'),
(565, 316977.930, 'D', 3, 228, '2018-05-16'),
(566, 0.000, 'D', 4, 228, '2018-05-16'),
(567, 0.000, 'C', 1, 33, '2018-05-16'),
(568, 0.000, 'C', 2, 33, '2018-05-16'),
(569, 67912.000, 'C', 3, 33, '2018-05-16'),
(570, 0.000, 'C', 4, 33, '2018-05-16'),
(571, 0.000, 'D', 1, 229, '2018-05-16'),
(572, 0.000, 'D', 2, 229, '2018-05-16'),
(573, 307989.500, 'D', 3, 229, '2018-05-16'),
(574, 0.000, 'D', 4, 229, '2018-05-16'),
(575, 0.000, 'C', 1, 34, '2018-05-16'),
(576, 0.000, 'C', 2, 34, '2018-05-16'),
(577, 1056626.000, 'C', 3, 34, '2018-05-16'),
(578, 0.000, 'C', 4, 34, '2018-05-16'),
(579, 0.000, 'D', 1, 222, '2018-05-16'),
(580, 0.000, 'D', 2, 222, '2018-05-16'),
(581, 11663141.380, 'D', 3, 222, '2018-05-16'),
(582, 0.000, 'D', 4, 222, '2018-05-16'),
(583, 0.000, 'D', 1, 231, '2018-05-16'),
(584, 0.000, 'D', 2, 231, '2018-05-16'),
(585, 68490.000, 'D', 3, 231, '2018-05-16'),
(586, 0.000, 'D', 4, 231, '2018-05-16'),
(587, 0.000, 'D', 1, 122, '2018-06-10'),
(588, 0.000, 'D', 2, 122, '2018-06-10'),
(589, 0.000, 'D', 3, 122, '2018-06-10'),
(590, 0.000, 'D', 4, 122, '2018-06-10'),
(591, 0.000, 'D', 1, 123, '2018-06-10'),
(592, 0.000, 'D', 2, 123, '2018-06-10'),
(593, 0.000, 'D', 3, 123, '2018-06-10'),
(594, 0.000, 'D', 4, 123, '2018-06-10'),
(595, 0.000, 'D', 1, 124, '2018-06-10'),
(596, 0.000, 'D', 2, 124, '2018-06-10'),
(597, 0.000, 'D', 3, 124, '2018-06-10'),
(598, 0.000, 'D', 4, 124, '2018-06-10'),
(599, 0.000, 'D', 1, 125, '2018-04-17'),
(600, 0.000, 'D', 2, 125, '2018-04-17'),
(601, 0.000, 'D', 3, 125, '2018-04-17'),
(602, 0.000, 'D', 4, 125, '2018-04-17'),
(603, 0.000, 'D', 1, 126, '2018-06-10'),
(604, 0.000, 'D', 2, 126, '2018-06-10'),
(605, 0.000, 'D', 3, 126, '2018-06-10'),
(606, 0.000, 'D', 4, 126, '2018-06-10'),
(607, 0.000, 'D', 1, 127, '2018-06-10'),
(608, 0.000, 'D', 2, 127, '2018-06-10'),
(609, 0.000, 'D', 3, 127, '2018-06-10'),
(610, 0.000, 'D', 4, 127, '2018-06-10'),
(611, 0.000, 'D', 1, 128, '2018-06-10'),
(612, 0.000, 'D', 2, 128, '2018-06-10'),
(613, 0.000, 'D', 3, 128, '2018-06-10'),
(614, 0.000, 'D', 4, 128, '2018-06-10'),
(615, 0.000, 'D', 1, 129, '2018-06-10'),
(616, 0.000, 'D', 2, 129, '2018-06-10'),
(617, 0.000, 'D', 3, 129, '2018-06-10'),
(618, 0.000, 'D', 4, 129, '2018-06-10'),
(619, 0.000, 'D', 1, 130, '2018-06-10'),
(620, 3870.000, 'D', 2, 130, '2018-06-10'),
(621, 0.000, 'D', 3, 130, '2018-06-10'),
(622, 0.000, 'D', 4, 130, '2018-06-10'),
(623, 0.000, 'D', 1, 131, '2018-06-10'),
(624, 0.000, 'D', 2, 131, '2018-06-10'),
(625, 0.000, 'D', 3, 131, '2018-06-10'),
(626, 0.000, 'D', 4, 131, '2018-06-10'),
(627, 0.000, 'D', 1, 132, '2018-06-10'),
(628, 0.000, 'D', 2, 132, '2018-06-10'),
(629, 0.000, 'D', 3, 132, '2018-06-10'),
(630, 0.000, 'D', 4, 132, '2018-06-10'),
(631, 0.000, 'D', 1, 133, '2018-06-10'),
(632, 0.000, 'D', 2, 133, '2018-06-10'),
(633, 0.000, 'D', 3, 133, '2018-06-10'),
(634, 0.000, 'D', 4, 133, '2018-06-10'),
(635, 0.000, 'D', 1, 134, '2018-06-10'),
(636, 0.000, 'D', 2, 134, '2018-06-10'),
(637, 0.000, 'D', 3, 134, '2018-06-10'),
(638, 0.000, 'D', 4, 134, '2018-06-10'),
(639, 0.000, 'D', 1, 135, '2018-06-10'),
(640, 0.000, 'D', 2, 135, '2018-06-10'),
(641, 0.000, 'D', 3, 135, '2018-06-10'),
(642, 0.000, 'D', 4, 135, '2018-06-10'),
(643, 0.000, 'D', 1, 136, '2018-06-10'),
(644, 0.000, 'D', 2, 136, '2018-06-10'),
(645, 0.000, 'D', 3, 136, '2018-06-10'),
(646, 0.000, 'D', 4, 136, '2018-06-10'),
(647, 0.000, 'D', 1, 137, '2018-04-17'),
(648, 0.000, 'D', 2, 137, '2018-04-17'),
(649, 0.000, 'D', 3, 137, '2018-04-17'),
(650, 0.000, 'D', 4, 137, '2018-04-17'),
(651, 0.000, 'D', 1, 138, '2018-06-10'),
(652, 0.000, 'D', 2, 138, '2018-06-10'),
(653, 0.000, 'D', 3, 138, '2018-06-10'),
(654, 0.000, 'D', 4, 138, '2018-06-10'),
(655, 0.000, 'D', 1, 139, '2018-06-10'),
(656, 0.000, 'D', 2, 139, '2018-06-10'),
(657, 0.000, 'D', 3, 139, '2018-06-10'),
(658, 0.000, 'D', 4, 139, '2018-06-10'),
(659, 0.000, 'D', 1, 140, '2018-06-10'),
(660, 0.000, 'D', 2, 140, '2018-06-10'),
(661, 0.000, 'D', 3, 140, '2018-06-10'),
(662, 0.000, 'D', 4, 140, '2018-06-10'),
(663, 0.000, 'D', 1, 141, '2018-06-10'),
(664, 0.000, 'D', 2, 141, '2018-06-10'),
(665, 0.000, 'D', 3, 141, '2018-06-10'),
(666, 0.000, 'D', 4, 141, '2018-06-10'),
(667, 0.000, 'D', 1, 142, '2018-06-10'),
(668, 0.000, 'D', 2, 142, '2018-06-10'),
(669, 0.000, 'D', 3, 142, '2018-06-10'),
(670, 0.000, 'D', 4, 142, '2018-06-10'),
(671, 0.000, 'D', 1, 143, '2018-06-10'),
(672, 0.000, 'D', 2, 143, '2018-06-10'),
(673, 0.000, 'D', 3, 143, '2018-06-10'),
(674, 0.000, 'D', 4, 143, '2018-06-10'),
(675, 0.000, 'D', 1, 144, '2018-06-10'),
(676, 0.000, 'D', 2, 144, '2018-06-10'),
(677, 0.000, 'D', 3, 144, '2018-06-10'),
(678, 0.000, 'D', 4, 144, '2018-06-10'),
(679, 0.000, 'D', 1, 145, '2018-06-10'),
(680, 0.000, 'D', 2, 145, '2018-06-10'),
(681, 0.000, 'D', 3, 145, '2018-06-10'),
(682, 0.000, 'D', 4, 145, '2018-06-10'),
(683, 0.000, 'D', 1, 146, '2018-06-10'),
(684, 0.000, 'D', 2, 146, '2018-06-10'),
(685, 0.000, 'D', 3, 146, '2018-06-10'),
(686, 0.000, 'D', 4, 146, '2018-06-10'),
(687, 0.000, 'D', 1, 147, '2018-06-10'),
(688, 0.000, 'D', 2, 147, '2018-06-10'),
(689, 0.000, 'D', 3, 147, '2018-06-10'),
(690, 0.000, 'D', 4, 147, '2018-06-10'),
(691, 0.000, 'D', 1, 148, '2018-06-10'),
(692, 0.000, 'D', 2, 148, '2018-06-10'),
(693, 0.000, 'D', 3, 148, '2018-06-10'),
(694, 0.000, 'D', 4, 148, '2018-06-10'),
(695, 0.000, 'D', 1, 149, '2018-06-10'),
(696, 0.000, 'D', 2, 149, '2018-06-10'),
(697, 0.000, 'D', 3, 149, '2018-06-10'),
(698, 0.000, 'D', 4, 149, '2018-06-10'),
(699, 0.000, 'D', 1, 150, '2018-06-10'),
(700, 0.000, 'D', 2, 150, '2018-06-10'),
(701, 0.000, 'D', 3, 150, '2018-06-10'),
(702, 0.000, 'D', 4, 150, '2018-06-10'),
(703, 0.000, 'D', 1, 151, '2018-04-17'),
(704, 0.000, 'D', 2, 151, '2018-04-17'),
(705, 0.000, 'D', 3, 151, '2018-04-17'),
(706, 0.000, 'D', 4, 151, '2018-04-17'),
(707, 0.000, 'D', 1, 152, '2018-06-10'),
(708, 0.000, 'D', 2, 152, '2018-06-10'),
(709, 0.000, 'D', 3, 152, '2018-06-10'),
(710, 0.000, 'D', 4, 152, '2018-06-10'),
(711, 0.000, 'D', 1, 177, '2018-06-11'),
(712, 0.000, 'D', 2, 177, '2018-06-11'),
(713, 0.000, 'D', 3, 177, '2018-06-11'),
(714, 0.000, 'D', 4, 177, '2018-06-11'),
(715, 0.000, 'D', 1, 181, '2018-06-10'),
(716, 0.000, 'D', 2, 181, '2018-06-10'),
(717, 0.000, 'D', 3, 181, '2018-06-10'),
(718, 0.000, 'D', 4, 181, '2018-06-10'),
(719, 0.000, 'D', 1, 182, '2018-06-10'),
(720, 0.000, 'D', 2, 182, '2018-06-10'),
(721, 0.000, 'D', 3, 182, '2018-06-10'),
(722, 0.000, 'D', 4, 182, '2018-06-10'),
(723, 0.000, 'C', 1, 183, '2018-06-10'),
(724, 0.000, 'D', 2, 183, '2018-06-10'),
(725, 0.000, 'D', 3, 183, '2018-06-10'),
(726, 0.000, 'D', 4, 183, '2018-06-10'),
(727, 0.000, 'D', 1, 153, '2018-07-18'),
(728, 0.000, 'D', 2, 153, '2018-07-18'),
(729, 0.000, 'D', 3, 153, '2018-07-18'),
(730, 0.000, 'D', 4, 153, '2018-07-18'),
(731, 0.000, 'D', 1, 154, '2018-06-13'),
(732, 0.000, 'D', 2, 154, '2018-06-13'),
(733, 0.000, 'D', 3, 154, '2018-06-13'),
(734, 0.000, 'D', 4, 154, '2018-06-13'),
(735, 0.000, 'D', 1, 155, '2018-06-13'),
(736, 0.000, 'D', 2, 155, '2018-06-13'),
(737, 0.000, 'D', 3, 155, '2018-06-13'),
(738, 0.000, 'D', 4, 155, '2018-06-13'),
(739, 0.000, 'D', 1, 156, '2018-06-10'),
(740, 0.000, 'D', 2, 156, '2018-06-10'),
(741, 0.000, 'D', 3, 156, '2018-06-10'),
(742, 0.000, 'D', 4, 156, '2018-06-10'),
(743, 0.000, 'D', 1, 158, '2018-04-17'),
(744, 0.000, 'D', 2, 158, '2018-04-17'),
(745, 0.000, 'D', 3, 158, '2018-04-17'),
(746, 0.000, 'D', 4, 158, '2018-04-17'),
(747, 0.000, 'D', 1, 159, '2018-04-17'),
(748, 0.000, 'D', 2, 159, '2018-04-17'),
(749, 0.000, 'D', 3, 159, '2018-04-17'),
(750, 0.000, 'D', 4, 159, '2018-04-17'),
(751, 0.000, 'D', 1, 160, '2018-06-10'),
(752, 0.000, 'D', 2, 160, '2018-06-10'),
(753, 0.000, 'D', 3, 160, '2018-06-10'),
(754, 0.000, 'D', 4, 160, '2018-06-10'),
(755, 0.000, 'D', 1, 161, '2018-06-10'),
(756, 0.000, 'D', 2, 161, '2018-06-10'),
(757, 0.000, 'D', 3, 161, '2018-06-10'),
(758, 0.000, 'D', 4, 161, '2018-06-10'),
(759, 0.000, 'D', 1, 162, '2018-06-10'),
(760, 0.000, 'D', 2, 162, '2018-06-10'),
(761, 0.000, 'D', 3, 162, '2018-06-10'),
(762, 0.000, 'D', 4, 162, '2018-06-10'),
(763, 0.000, 'D', 1, 163, '2018-06-10'),
(764, 0.000, 'D', 2, 163, '2018-06-10'),
(765, 0.000, 'D', 3, 163, '2018-06-10'),
(766, 0.000, 'D', 4, 163, '2018-06-10'),
(767, 0.000, 'D', 1, 165, '2018-06-10'),
(768, 0.000, 'D', 2, 165, '2018-06-10'),
(769, 0.000, 'D', 3, 165, '2018-06-10'),
(770, 0.000, 'D', 4, 165, '2018-06-10'),
(771, 0.000, 'D', 1, 167, '2018-06-10'),
(772, 0.000, 'D', 2, 167, '2018-06-10'),
(773, 0.000, 'D', 3, 167, '2018-06-10'),
(774, 0.000, 'D', 4, 167, '2018-06-10'),
(775, 0.000, 'D', 1, 168, '2018-06-10'),
(776, 0.000, 'D', 2, 168, '2018-06-10'),
(777, 0.000, 'D', 3, 168, '2018-06-10'),
(778, 0.000, 'D', 4, 168, '2018-06-10'),
(779, 0.000, 'D', 1, 169, '2018-04-17'),
(780, 0.000, 'D', 2, 169, '2018-04-17'),
(781, 0.000, 'D', 3, 169, '2018-04-17'),
(782, 0.000, 'D', 4, 169, '2018-04-17'),
(783, 0.000, 'D', 1, 170, '2018-04-17'),
(784, 0.000, 'D', 2, 170, '2018-04-17'),
(785, 0.000, 'D', 3, 170, '2018-04-17'),
(786, 0.000, 'D', 4, 170, '2018-04-17'),
(787, 0.000, 'D', 1, 171, '2018-06-10'),
(788, 0.000, 'D', 2, 171, '2018-06-10'),
(789, 0.000, 'D', 3, 171, '2018-06-10'),
(790, 0.000, 'D', 4, 171, '2018-06-10'),
(791, 0.000, 'D', 1, 172, '2018-06-10'),
(792, 0.000, 'D', 2, 172, '2018-06-10'),
(793, 0.000, 'D', 3, 172, '2018-06-10'),
(794, 0.000, 'D', 4, 172, '2018-06-10'),
(795, 0.000, 'D', 1, 173, '2018-06-10'),
(796, 0.000, 'D', 2, 173, '2018-06-10'),
(797, 0.000, 'D', 3, 173, '2018-06-10'),
(798, 0.000, 'D', 4, 173, '2018-06-10'),
(799, 0.000, 'D', 1, 174, '2018-04-17'),
(800, 0.000, 'D', 2, 174, '2018-04-17'),
(801, 0.000, 'D', 3, 174, '2018-04-17'),
(802, 0.000, 'D', 4, 174, '2018-04-17'),
(803, 0.000, 'D', 1, 175, '2018-06-10'),
(804, 0.000, 'D', 2, 175, '2018-06-10'),
(805, 0.000, 'D', 3, 175, '2018-06-10'),
(806, 0.000, 'D', 4, 175, '2018-06-10'),
(807, 0.000, 'D', 1, 176, '2018-06-10'),
(808, 0.000, 'D', 2, 176, '2018-06-10'),
(809, 0.000, 'D', 3, 176, '2018-06-10'),
(810, 0.000, 'D', 4, 176, '2018-06-10'),
(811, 0.000, 'D', 1, 178, '2018-06-10'),
(812, 0.000, 'D', 2, 178, '2018-06-10'),
(813, 0.000, 'D', 3, 178, '2018-06-10'),
(814, 0.000, 'D', 4, 178, '2018-06-10'),
(815, 0.000, 'D', 1, 179, '2018-06-10'),
(816, 0.000, 'D', 2, 179, '2018-06-10'),
(817, 0.000, 'D', 3, 179, '2018-06-10'),
(818, 0.000, 'D', 4, 179, '2018-06-10'),
(819, 0.000, 'D', 1, 180, '2018-04-17'),
(820, 0.000, 'D', 2, 180, '2018-04-17'),
(821, 0.000, 'D', 3, 180, '2018-04-17'),
(822, 0.000, 'D', 4, 180, '2018-04-17'),
(823, 0.000, 'D', 1, 184, '2018-06-10'),
(824, 0.000, 'D', 2, 184, '2018-06-10'),
(825, 0.000, 'D', 3, 184, '2018-06-10'),
(826, 0.000, 'D', 4, 184, '2018-06-10'),
(827, 0.000, 'D', 1, 185, '2018-06-10'),
(828, 0.000, 'D', 2, 185, '2018-06-10'),
(829, 0.000, 'D', 3, 185, '2018-06-10'),
(830, 0.000, 'D', 4, 185, '2018-06-10'),
(831, 0.000, 'D', 1, 186, '2018-06-10'),
(832, 0.000, 'D', 2, 186, '2018-06-10'),
(833, 0.000, 'D', 3, 186, '2018-06-10'),
(834, 0.000, 'D', 4, 186, '2018-06-10'),
(835, 0.000, 'D', 1, 187, '2018-06-10'),
(836, 0.000, 'D', 2, 187, '2018-06-10'),
(837, 0.000, 'D', 3, 187, '2018-06-10'),
(838, 0.000, 'D', 4, 187, '2018-06-10'),
(839, 0.000, 'D', 1, 188, '2018-06-10'),
(840, 0.000, 'D', 2, 188, '2018-06-10'),
(841, 0.000, 'C', 3, 188, '2018-06-10'),
(842, 0.000, 'D', 4, 188, '2018-06-10'),
(843, 0.000, 'D', 1, 189, '2018-04-17'),
(844, 0.000, 'D', 2, 189, '2018-04-17'),
(845, 0.000, 'D', 3, 189, '2018-04-17'),
(846, 0.000, 'D', 4, 189, '2018-04-17'),
(847, 0.000, 'D', 1, 190, '2018-04-17'),
(848, 0.000, 'D', 2, 190, '2018-04-17'),
(849, 0.000, 'D', 3, 190, '2018-04-17'),
(850, 0.000, 'D', 4, 190, '2018-04-17'),
(851, 0.000, 'D', 1, 191, '2018-06-10'),
(852, 0.000, 'D', 2, 191, '2018-06-10'),
(853, 0.000, 'D', 3, 191, '2018-06-10'),
(854, 0.000, 'D', 4, 191, '2018-06-10'),
(855, 0.000, 'D', 1, 192, '2018-07-18'),
(856, 0.000, 'D', 2, 192, '2018-07-18'),
(857, 0.000, 'D', 3, 192, '2018-07-18'),
(858, 0.000, 'D', 4, 192, '2018-07-18'),
(859, 0.000, 'D', 1, 193, '2018-06-10'),
(860, 0.000, 'D', 2, 193, '2018-06-10'),
(861, 0.000, 'D', 3, 193, '2018-06-10'),
(862, 0.000, 'D', 4, 193, '2018-06-10'),
(863, 0.000, 'D', 1, 194, '2018-06-10'),
(864, 0.000, 'D', 2, 194, '2018-06-10'),
(865, 0.000, 'D', 3, 194, '2018-06-10'),
(866, 0.000, 'D', 4, 194, '2018-06-10'),
(867, 0.000, 'D', 1, 195, '2018-06-10'),
(868, 0.000, 'D', 2, 195, '2018-06-10'),
(869, 0.000, 'D', 3, 195, '2018-06-10'),
(870, 0.000, 'D', 4, 195, '2018-06-10'),
(871, 0.000, 'D', 1, 196, '2018-06-10'),
(872, 0.000, 'D', 2, 196, '2018-06-10'),
(873, 0.000, 'D', 3, 196, '2018-06-10'),
(874, 0.000, 'D', 4, 196, '2018-06-10'),
(875, 0.000, 'D', 1, 196, '2018-04-17'),
(876, 0.000, 'D', 2, 196, '2018-04-17'),
(877, 0.000, 'D', 3, 196, '2018-04-17'),
(878, 0.000, 'D', 4, 196, '2018-04-17'),
(879, 0.000, 'D', 1, 197, '2018-04-17'),
(880, 0.000, 'D', 2, 197, '2018-04-17'),
(881, 0.000, 'D', 3, 197, '2018-04-17'),
(882, 0.000, 'D', 4, 197, '2018-04-17'),
(883, 0.000, 'D', 1, 198, '2018-06-10'),
(884, 0.000, 'D', 2, 198, '2018-06-10'),
(885, 0.000, 'D', 3, 198, '2018-06-10'),
(886, 0.000, 'D', 4, 198, '2018-06-10'),
(887, 0.000, 'D', 1, 199, '2018-06-10'),
(888, 0.000, 'D', 2, 199, '2018-06-10'),
(889, 0.000, 'D', 3, 199, '2018-06-10'),
(890, 0.000, 'D', 4, 199, '2018-06-10'),
(891, 0.000, 'D', 1, 200, '2018-06-10'),
(892, 0.000, 'D', 2, 200, '2018-06-10'),
(893, 0.000, 'D', 3, 200, '2018-06-10'),
(894, 0.000, 'D', 4, 200, '2018-06-10'),
(895, 0.000, 'D', 1, 202, '2018-04-17'),
(896, 0.000, 'D', 2, 202, '2018-04-17'),
(897, 0.000, 'D', 3, 202, '2018-04-17'),
(898, 0.000, 'D', 4, 202, '2018-04-17'),
(899, 0.000, 'D', 1, 203, '2018-06-10'),
(900, 0.000, 'D', 2, 203, '2018-06-10'),
(901, 0.000, 'D', 3, 203, '2018-06-10'),
(902, 0.000, 'D', 4, 203, '2018-06-10'),
(903, 0.000, 'D', 1, 204, '2018-06-10'),
(904, 0.000, 'D', 2, 204, '2018-06-10'),
(905, 0.000, 'D', 3, 204, '2018-06-10'),
(906, 0.000, 'D', 4, 204, '2018-06-10'),
(907, 0.000, 'D', 1, 205, '2018-06-10'),
(908, 0.000, 'D', 2, 205, '2018-06-10'),
(909, 0.000, 'D', 3, 205, '2018-06-10'),
(910, 0.000, 'D', 4, 205, '2018-06-10'),
(911, 0.000, 'D', 1, 208, '2018-06-10'),
(912, 0.000, 'D', 2, 208, '2018-06-10'),
(913, 0.000, 'D', 3, 208, '2018-06-10'),
(914, 0.000, 'D', 4, 208, '2018-06-10'),
(915, 0.000, 'D', 1, 241, '2018-07-18'),
(916, 0.000, 'D', 2, 241, '2018-07-18'),
(917, 0.000, 'D', 3, 241, '2018-07-18'),
(918, 0.000, 'D', 4, 241, '2018-07-18'),
(919, 0.000, 'D', 1, 243, '2018-07-18'),
(920, 0.000, 'D', 2, 243, '2018-07-18'),
(921, 0.000, 'D', 3, 243, '2018-07-18'),
(922, 0.000, 'D', 4, 243, '2018-07-18'),
(923, 0.000, 'D', 1, 206, '2018-06-10'),
(924, 0.000, 'D', 2, 206, '2018-06-10'),
(925, 0.000, 'D', 3, 206, '2018-06-10'),
(926, 0.000, 'D', 4, 206, '2018-06-10'),
(927, 0.000, 'D', 1, 207, '2018-06-10'),
(928, 0.000, 'D', 2, 207, '2018-06-10'),
(929, 0.000, 'D', 3, 207, '2018-06-10'),
(930, 0.000, 'D', 4, 207, '2018-06-10'),
(931, 0.000, 'D', 1, 214, '2018-04-17'),
(932, 0.000, 'D', 2, 214, '2018-04-17'),
(933, 0.000, 'D', 3, 214, '2018-04-17'),
(934, 0.000, 'D', 4, 214, '2018-04-17'),
(935, 0.000, 'D', 1, 215, '2018-04-17'),
(936, 0.000, 'D', 2, 215, '2018-04-17'),
(937, 0.000, 'D', 3, 215, '2018-04-17'),
(938, 0.000, 'D', 4, 215, '2018-04-17'),
(939, 0.000, 'D', 1, 216, '2018-04-17'),
(940, 0.000, 'D', 2, 216, '2018-04-17'),
(941, 0.000, 'D', 3, 216, '2018-04-17'),
(942, 0.000, 'D', 4, 216, '2018-04-17'),
(943, 0.000, 'D', 1, 217, '2018-04-17'),
(944, 0.000, 'D', 2, 217, '2018-04-17'),
(945, 0.000, 'D', 3, 217, '2018-04-17'),
(946, 0.000, 'D', 4, 217, '2018-04-17'),
(947, 0.000, 'C', 1, 119, '2018-06-10'),
(948, 0.000, 'C', 2, 119, '2018-06-10'),
(949, 0.000, 'C', 3, 119, '2018-06-10'),
(950, 0.000, 'C', 4, 119, '2018-06-10'),
(951, 0.000, 'C', 1, 218, '2019-11-16'),
(952, 0.000, 'C', 2, 218, '2019-11-16'),
(953, 0.000, 'C', 3, 218, '2019-11-16'),
(954, 0.000, 'C', 4, 218, '2019-11-16'),
(955, 0.000, 'C', 1, 242, '2018-07-18'),
(956, 0.000, 'C', 2, 242, '2018-07-18'),
(957, 0.000, 'C', 3, 242, '2018-07-18'),
(958, 0.000, 'C', 4, 242, '2018-07-18'),
(959, 0.000, 'C', 1, 209, '2018-07-18'),
(960, 0.000, 'C', 2, 209, '2018-07-18'),
(961, 0.000, 'C', 3, 209, '2018-07-18'),
(962, 0.000, 'C', 4, 209, '2018-07-18'),
(963, 0.000, 'C', 1, 210, '2018-06-10'),
(964, 0.000, 'C', 2, 210, '2018-06-10'),
(965, 0.000, 'C', 3, 210, '2018-06-10'),
(966, 0.000, 'C', 4, 210, '2018-06-10'),
(967, 0.000, 'C', 1, 211, '2018-04-17'),
(968, 0.000, 'C', 2, 211, '2018-04-17'),
(969, 0.000, 'C', 3, 211, '2018-04-17'),
(970, 0.000, 'C', 4, 211, '2018-04-17'),
(971, 0.000, 'C', 1, 212, '2018-04-17'),
(972, 0.000, 'C', 2, 212, '2018-04-17'),
(973, 0.000, 'C', 3, 212, '2018-04-17'),
(974, 0.000, 'C', 4, 212, '2018-04-17'),
(975, 0.000, 'C', 1, 213, '2018-04-17'),
(976, 0.000, 'C', 2, 213, '2018-04-17'),
(977, 0.000, 'C', 3, 213, '2018-04-17'),
(978, 0.000, 'C', 4, 213, '2018-04-17'),
(979, 0.000, 'C', 1, 40, '2018-04-17'),
(980, 0.000, 'C', 2, 40, '2018-04-17'),
(981, 0.000, 'C', 3, 40, '2018-04-17'),
(982, 0.000, 'C', 4, 40, '2018-04-17'),
(983, 0.000, 'C', 1, 41, '2018-04-17'),
(984, 0.000, 'C', 2, 41, '2018-04-17'),
(985, 0.000, 'C', 3, 41, '2018-04-17'),
(986, 0.000, 'C', 4, 41, '2018-04-17'),
(987, 0.000, 'C', 1, 42, '2018-04-17'),
(988, 0.000, 'C', 2, 42, '2018-04-17'),
(989, 0.000, 'C', 3, 42, '2018-04-17'),
(990, 0.000, 'C', 4, 42, '2018-04-17'),
(991, 0.000, 'C', 1, 43, '2018-04-17'),
(992, 0.000, 'C', 2, 43, '2018-04-17'),
(993, 0.000, 'C', 3, 43, '2018-04-17'),
(994, 0.000, 'C', 4, 43, '2018-04-17'),
(995, 0.000, 'C', 1, 36, '2018-04-17'),
(996, 0.000, 'C', 2, 36, '2018-04-17'),
(997, 0.000, 'C', 3, 36, '2018-04-17'),
(998, 0.000, 'C', 4, 36, '2018-04-17'),
(999, 0.000, 'C', 1, 37, '2018-05-16'),
(1000, 0.000, 'C', 2, 37, '2018-05-16'),
(1001, 11863.820, 'C', 3, 37, '2018-05-16'),
(1002, 0.000, 'C', 4, 37, '2018-05-16'),
(1003, 0.000, 'C', 1, 44, '2018-05-20'),
(1004, 0.000, 'C', 2, 44, '2018-05-20'),
(1005, 0.000, 'C', 3, 44, '2018-05-20'),
(1006, 0.000, 'C', 4, 44, '2018-05-20'),
(1007, 0.000, 'C', 1, 45, '2018-04-17'),
(1008, 0.000, 'C', 2, 45, '2018-04-17'),
(1009, 0.000, 'C', 3, 45, '2018-04-17'),
(1010, 0.000, 'C', 4, 45, '2018-04-17'),
(1011, 0.000, 'C', 1, 233, '2018-05-16'),
(1012, 0.000, 'C', 2, 233, '2018-05-16'),
(1013, 30000.000, 'C', 3, 233, '2018-05-16'),
(1014, 0.000, 'C', 4, 233, '2018-05-16'),
(1015, 0.000, 'C', 1, 117, '2018-06-10'),
(1016, 0.000, 'C', 2, 117, '2018-06-10'),
(1017, 1365159.260, 'C', 3, 117, '2018-06-10'),
(1018, 0.000, 'C', 4, 117, '2018-06-10'),
(1019, 0.000, 'D', 1, 118, '2018-04-17'),
(1020, 0.000, 'D', 2, 118, '2018-04-17'),
(1021, 0.000, 'D', 3, 118, '2018-04-17'),
(1022, 0.000, 'D', 4, 118, '2018-04-17'),
(1023, 0.000, 'C', 1, 234, '2018-05-16'),
(1024, 0.000, 'C', 2, 234, '2018-05-16'),
(1025, 15000.000, 'C', 3, 234, '2018-05-16'),
(1026, 0.000, 'C', 4, 234, '2018-05-16'),
(1027, 0.000, 'C', 1, 47, '2018-05-16'),
(1028, 0.000, 'C', 2, 47, '2018-05-16'),
(1029, 22596427.270, 'C', 3, 47, '2018-05-16'),
(1030, 0.000, 'C', 4, 47, '2018-05-16'),
(1031, 0.000, 'C', 1, 48, '2018-04-17'),
(1032, 0.000, 'C', 2, 48, '2018-04-17'),
(1033, 0.000, 'C', 3, 48, '2018-04-17'),
(1034, 0.000, 'C', 4, 48, '2018-04-17'),
(1035, 0.000, 'C', 1, 49, '2018-05-16'),
(1036, 0.000, 'C', 2, 49, '2018-05-16'),
(1037, 137132.530, 'C', 3, 49, '2018-05-16'),
(1038, 0.000, 'C', 4, 49, '2018-05-16'),
(1039, 0.000, 'C', 1, 50, '2018-04-17'),
(1040, 0.000, 'C', 2, 50, '2018-04-17'),
(1041, 0.000, 'C', 3, 50, '2018-04-17'),
(1042, 0.000, 'C', 4, 50, '2018-04-17'),
(1043, 0.000, 'C', 1, 51, '2018-04-17'),
(1044, 0.000, 'C', 2, 51, '2018-04-17'),
(1045, 0.000, 'C', 3, 51, '2018-04-17'),
(1046, 0.000, 'C', 4, 51, '2018-04-17'),
(1047, 0.000, 'C', 1, 52, '2018-04-17'),
(1048, 0.000, 'C', 2, 52, '2018-04-17'),
(1049, 0.000, 'C', 3, 52, '2018-04-17'),
(1050, 0.000, 'C', 4, 52, '2018-04-17'),
(1051, 0.000, 'C', 1, 53, '2018-04-17'),
(1052, 0.000, 'C', 2, 53, '2018-04-17'),
(1053, 0.000, 'C', 3, 53, '2018-04-17'),
(1054, 0.000, 'C', 4, 53, '2018-04-17'),
(1055, 0.000, 'C', 1, 54, '2018-04-17'),
(1056, 0.000, 'C', 2, 54, '2018-04-17'),
(1057, 0.000, 'C', 3, 54, '2018-04-17'),
(1058, 0.000, 'C', 4, 54, '2018-04-17'),
(1059, 0.000, 'C', 1, 55, '2018-04-17'),
(1060, 0.000, 'C', 2, 55, '2018-04-17'),
(1061, 0.000, 'C', 3, 55, '2018-04-17'),
(1062, 0.000, 'C', 4, 55, '2018-04-17'),
(1063, 0.000, 'C', 1, 56, '2018-04-17'),
(1064, 0.000, 'C', 2, 56, '2018-04-17'),
(1065, 0.000, 'C', 3, 56, '2018-04-17'),
(1066, 0.000, 'C', 4, 56, '2018-04-17'),
(1067, 0.000, 'C', 1, 113, '2018-04-17'),
(1068, 0.000, 'C', 2, 113, '2018-04-17'),
(1069, 0.000, 'C', 3, 113, '2018-04-17'),
(1070, 0.000, 'C', 4, 113, '2018-04-17'),
(1071, 0.000, 'C', 1, 114, '2018-04-17'),
(1072, 0.000, 'C', 2, 114, '2018-04-17'),
(1073, 0.000, 'C', 3, 114, '2018-04-17'),
(1074, 0.000, 'C', 4, 114, '2018-04-17'),
(1075, 0.000, 'D', 1, 302, '2018-04-17'),
(1076, 0.000, 'D', 2, 302, '2018-04-17'),
(1077, 0.000, 'D', 3, 302, '2018-04-17'),
(1078, 0.000, 'D', 4, 302, '2018-04-17'),
(1079, 0.000, 'D', 1, 303, '2018-07-18'),
(1080, 0.000, 'D', 2, 303, '2018-07-18'),
(1081, 0.000, 'D', 3, 303, '2018-07-18'),
(1082, 0.000, 'D', 4, 303, '2018-07-18'),
(1083, 0.000, 'D', 1, 304, '2018-07-18'),
(1084, 0.000, 'D', 2, 304, '2018-07-18'),
(1085, 0.000, 'D', 3, 304, '2018-07-18'),
(1086, 0.000, 'D', 4, 304, '2018-07-18'),
(1087, 0.000, 'D', 1, 305, '2018-07-18'),
(1088, 0.000, 'D', 2, 305, '2018-07-18'),
(1089, 0.000, 'D', 3, 305, '2018-07-18'),
(1090, 0.000, 'D', 4, 305, '2018-07-18'),
(1091, 0.000, 'D', 1, 306, '2018-07-18'),
(1092, 0.000, 'D', 2, 306, '2018-07-18'),
(1093, 0.000, 'D', 3, 306, '2018-07-18'),
(1094, 0.000, 'D', 4, 306, '2018-07-18'),
(1095, 0.000, 'D', 1, 307, '2018-07-18'),
(1096, 0.000, 'D', 2, 307, '2018-07-18'),
(1097, 0.000, 'D', 3, 307, '2018-07-18'),
(1098, 0.000, 'D', 4, 307, '2018-07-18'),
(1099, 0.000, 'D', 1, 308, '2018-04-24'),
(1100, 0.000, 'D', 2, 308, '2018-04-24'),
(1101, 0.000, 'D', 3, 308, '2018-04-24'),
(1102, 0.000, 'D', 4, 308, '2018-04-24'),
(1103, 0.000, 'D', 1, 309, '2018-07-18'),
(1104, 0.000, 'D', 2, 309, '2018-07-18'),
(1105, 0.000, 'D', 3, 309, '2018-07-18'),
(1106, 0.000, 'D', 4, 309, '2018-07-18'),
(1107, 0.000, 'D', 1, 310, '2018-07-18'),
(1108, 0.000, 'D', 2, 310, '2018-07-18'),
(1109, 0.000, 'D', 3, 310, '2018-07-18'),
(1110, 0.000, 'D', 4, 310, '2018-07-18'),
(1111, 0.000, 'D', 1, 311, '2018-07-18'),
(1112, 0.000, 'D', 2, 311, '2018-07-18'),
(1113, 0.000, 'D', 3, 311, '2018-07-18'),
(1114, 0.000, 'D', 4, 311, '2018-07-18'),
(1115, 0.000, 'D', 1, 312, '2018-04-23'),
(1116, 0.000, 'D', 2, 312, '2018-04-23'),
(1117, 0.000, 'D', 3, 312, '2018-04-23'),
(1118, 0.000, 'D', 4, 312, '2018-04-23'),
(1119, 0.000, 'D', 1, 313, '2018-07-18'),
(1120, 0.000, 'D', 2, 313, '2018-07-18'),
(1121, 0.000, 'D', 3, 313, '2018-07-18'),
(1122, 0.000, 'D', 4, 313, '2018-07-18'),
(1123, 0.000, 'D', 1, 314, '2018-07-18'),
(1124, 0.000, 'D', 2, 314, '2018-07-18'),
(1125, 0.000, 'D', 3, 314, '2018-07-18'),
(1126, 0.000, 'D', 4, 314, '2018-07-18'),
(1127, 0.000, 'D', 1, 315, '2018-07-18'),
(1128, 0.000, 'D', 2, 315, '2018-07-18'),
(1129, 0.000, 'D', 3, 315, '2018-07-18'),
(1130, 0.000, 'D', 4, 315, '2018-07-18'),
(1131, 0.000, 'C', 1, 316, '2018-07-18'),
(1132, 0.000, 'C', 2, 316, '2018-07-18'),
(1133, 0.000, 'C', 3, 316, '2018-07-18'),
(1134, 0.000, 'C', 4, 316, '2018-07-18'),
(1135, 0.000, 'C', 1, 317, '2018-07-18'),
(1136, 0.000, 'C', 2, 317, '2018-07-18'),
(1137, 0.000, 'C', 3, 317, '2018-07-18'),
(1138, 0.000, 'C', 4, 317, '2018-07-18'),
(1139, 0.000, 'C', 1, 318, '2018-07-18'),
(1140, 0.000, 'C', 2, 318, '2018-07-18'),
(1141, 0.000, 'C', 3, 318, '2018-07-18'),
(1142, 0.000, 'C', 4, 318, '2018-07-18'),
(1143, 0.000, 'C', 1, 319, '2018-07-18'),
(1144, 0.000, 'C', 2, 319, '2018-07-18'),
(1145, 0.000, 'C', 3, 319, '2018-07-18'),
(1146, 0.000, 'C', 4, 319, '2018-07-18'),
(1147, 0.000, 'C', 1, 320, '2018-07-18'),
(1148, 0.000, 'C', 2, 320, '2018-07-18'),
(1149, 0.000, 'C', 3, 320, '2018-07-18'),
(1150, 0.000, 'C', 4, 320, '2018-07-18'),
(1151, 0.000, 'D', 1, 321, '2018-07-18'),
(1152, 0.000, 'D', 2, 321, '2018-07-18'),
(1153, 0.000, 'D', 3, 321, '2018-07-18'),
(1154, 0.000, 'D', 4, 321, '2018-07-18'),
(1155, 0.000, 'D', 1, 322, '2018-07-18'),
(1156, 0.000, 'D', 2, 322, '2018-07-18'),
(1157, 0.000, 'D', 3, 322, '2018-07-18'),
(1158, 0.000, 'D', 4, 322, '2018-07-18'),
(1159, 0.000, 'D', 1, 323, '2018-07-18'),
(1160, 0.000, 'D', 2, 323, '2018-07-18'),
(1161, 0.000, 'D', 3, 323, '2018-07-18'),
(1162, 0.000, 'D', 4, 323, '2018-07-18'),
(1163, 0.000, 'D', 1, 324, '2018-07-18'),
(1164, 0.000, 'D', 2, 324, '2018-07-18'),
(1165, 0.000, 'D', 3, 324, '2018-07-18'),
(1166, 0.000, 'D', 4, 324, '2018-07-18'),
(1167, 0.000, 'D', 1, 325, '2018-07-18'),
(1168, 0.000, 'D', 2, 325, '2018-07-18'),
(1169, 0.000, 'D', 3, 325, '2018-07-18'),
(1170, 0.000, 'D', 4, 325, '2018-07-18'),
(1171, 0.000, 'D', 1, 326, '2018-07-18'),
(1172, 0.000, 'D', 2, 326, '2018-07-18'),
(1173, 0.000, 'D', 3, 326, '2018-07-18'),
(1174, 0.000, 'D', 4, 326, '2018-07-18'),
(1175, 0.000, 'D', 1, 327, '2018-04-29'),
(1176, 0.000, 'D', 2, 327, '2018-04-29'),
(1177, 0.000, 'D', 3, 327, '2018-04-29'),
(1178, 0.000, 'D', 4, 327, '2018-04-29'),
(1179, 0.000, 'C', 1, 328, '2018-07-18'),
(1180, 0.000, 'C', 2, 328, '2018-07-18'),
(1181, 0.000, 'C', 3, 328, '2018-07-18'),
(1182, 0.000, 'C', 4, 328, '2018-07-18'),
(1183, 0.000, 'D', 1, 329, '2018-07-18'),
(1184, 0.000, 'D', 2, 329, '2018-07-18'),
(1185, 0.000, 'D', 3, 329, '2018-07-18'),
(1186, 0.000, 'D', 4, 329, '2018-07-18'),
(1187, 0.000, 'D', 1, 330, '2018-07-18'),
(1188, 0.000, 'D', 2, 330, '2018-07-18'),
(1189, 0.000, 'D', 3, 330, '2018-07-18'),
(1190, 0.000, 'D', 4, 330, '2018-07-18'),
(1191, 0.000, 'C', 1, 331, '2018-07-18'),
(1192, 0.000, 'C', 2, 331, '2018-07-18'),
(1193, 0.000, 'C', 3, 331, '2018-07-18'),
(1194, 0.000, 'C', 4, 331, '2018-07-18'),
(1195, 0.000, 'D', 1, 332, '2018-07-18'),
(1196, 0.000, 'D', 2, 332, '2018-07-18'),
(1197, 0.000, 'D', 3, 332, '2018-07-18'),
(1198, 0.000, 'D', 4, 332, '2018-07-18'),
(1199, 0.000, 'D', 1, 333, '2018-04-30'),
(1200, 0.000, 'D', 2, 333, '2018-04-30'),
(1201, 0.000, 'D', 3, 333, '2018-04-30'),
(1202, 0.000, 'D', 4, 333, '2018-04-30'),
(1203, 0.000, 'D', 1, 334, '2018-07-18'),
(1204, 0.000, 'D', 2, 334, '2018-07-18'),
(1205, 0.000, 'D', 3, 334, '2018-07-18'),
(1206, 0.000, 'D', 4, 334, '2018-07-18'),
(1207, 0.000, 'D', 1, 335, '2018-07-18'),
(1208, 0.000, 'D', 2, 335, '2018-07-18'),
(1209, 0.000, 'D', 3, 335, '2018-07-18'),
(1210, 0.000, 'D', 4, 335, '2018-07-18'),
(1211, 0.000, 'D', 1, 336, '2018-07-18'),
(1212, 0.000, 'D', 2, 336, '2018-07-18'),
(1213, 0.000, 'D', 3, 336, '2018-07-18'),
(1214, 0.000, 'D', 4, 336, '2018-07-18'),
(1215, 0.000, 'D', 1, 337, '2018-07-18'),
(1216, 0.000, 'D', 2, 337, '2018-07-18'),
(1217, 0.000, 'D', 3, 337, '2018-07-18'),
(1218, 0.000, 'D', 4, 337, '2018-07-18'),
(1219, 0.000, 'D', 1, 338, '2018-07-18'),
(1220, 0.000, 'D', 2, 338, '2018-07-18'),
(1221, 0.000, 'D', 3, 338, '2018-07-18'),
(1222, 0.000, 'D', 4, 338, '2018-07-18'),
(1223, 0.000, 'D', 1, 339, '2018-07-18'),
(1224, 0.000, 'D', 2, 339, '2018-07-18'),
(1225, 0.000, 'D', 3, 339, '2018-07-18'),
(1226, 0.000, 'D', 4, 339, '2018-07-18'),
(1227, 0.000, 'D', 1, 340, '2018-07-18'),
(1228, 0.000, 'D', 2, 340, '2018-07-18'),
(1229, 0.000, 'D', 3, 340, '2018-07-18'),
(1230, 0.000, 'D', 4, 340, '2018-07-18'),
(1231, 0.000, 'D', 1, 341, '2018-07-18'),
(1232, 0.000, 'D', 2, 341, '2018-07-18'),
(1233, 0.000, 'D', 3, 341, '2018-07-18'),
(1234, 0.000, 'D', 4, 341, '2018-07-18'),
(1235, 0.000, 'C', 1, 342, '2018-07-18'),
(1236, 0.000, 'C', 2, 342, '2018-07-18'),
(1237, 0.000, 'C', 3, 342, '2018-07-18'),
(1238, 0.000, 'C', 4, 342, '2018-07-18'),
(1239, 0.000, 'C', 1, 343, '2018-07-18'),
(1240, 0.000, 'C', 2, 343, '2018-07-18'),
(1241, 0.000, 'C', 3, 343, '2018-07-18'),
(1242, 0.000, 'C', 4, 343, '2018-07-18'),
(1243, 0.000, 'D', 1, 344, '2018-07-18'),
(1244, 0.000, 'D', 2, 344, '2018-07-18'),
(1245, 0.000, 'D', 3, 344, '2018-07-18'),
(1246, 0.000, 'D', 4, 344, '2018-07-18'),
(1247, 0.000, 'D', 1, 345, '2018-07-18'),
(1248, 0.000, 'D', 2, 345, '2018-07-18'),
(1249, 0.000, 'D', 3, 345, '2018-07-18'),
(1250, 0.000, 'D', 4, 345, '2018-07-18'),
(1251, 0.000, 'D', 1, 346, '2018-07-18'),
(1252, 0.000, 'D', 2, 346, '2018-07-18'),
(1253, 0.000, 'D', 3, 346, '2018-07-18'),
(1254, 0.000, 'D', 4, 346, '2018-07-18'),
(1255, 0.000, 'D', 1, 347, '2018-07-18'),
(1256, 0.000, 'D', 2, 347, '2018-07-18'),
(1257, 0.000, 'D', 3, 347, '2018-07-18'),
(1258, 0.000, 'D', 4, 347, '2018-07-18'),
(1259, 0.000, 'D', 1, 348, '2018-07-18'),
(1260, 0.000, 'D', 2, 348, '2018-07-18'),
(1261, 0.000, 'D', 3, 348, '2018-07-18'),
(1262, 0.000, 'D', 4, 348, '2018-07-18'),
(1263, 0.000, 'D', 1, 349, '2018-07-18'),
(1264, 0.000, 'D', 2, 349, '2018-07-18'),
(1265, 0.000, 'D', 3, 349, '2018-07-18'),
(1266, 0.000, 'D', 4, 349, '2018-07-18'),
(1267, 0.000, 'D', 1, 350, '2018-07-18'),
(1268, 0.000, 'D', 2, 350, '2018-07-18'),
(1269, 0.000, 'D', 3, 350, '2018-07-18'),
(1270, 0.000, 'D', 4, 350, '2018-07-18'),
(1271, 0.000, 'D', 1, 351, '2018-07-18'),
(1272, 0.000, 'D', 2, 351, '2018-07-18'),
(1273, 0.000, 'D', 3, 351, '2018-07-18'),
(1274, 0.000, 'D', 4, 351, '2018-07-18'),
(1275, 0.000, 'D', 1, 352, '2018-07-18'),
(1276, 0.000, 'D', 2, 352, '2018-07-18'),
(1277, 0.000, 'D', 3, 352, '2018-07-18'),
(1278, 0.000, 'D', 4, 352, '2018-07-18'),
(1279, 0.000, 'D', 1, 353, '2018-05-13'),
(1280, 0.000, 'D', 2, 353, '2018-05-13'),
(1281, 0.000, 'D', 3, 353, '2018-05-13'),
(1282, 0.000, 'D', 4, 353, '2018-05-13'),
(1283, 0.000, 'D', 1, 354, '2018-07-18'),
(1284, 0.000, 'D', 2, 354, '2018-07-18'),
(1285, 0.000, 'D', 3, 354, '2018-07-18'),
(1286, 0.000, 'D', 4, 354, '2018-07-18'),
(1287, 0.000, 'D', 1, 355, '2018-07-18'),
(1288, 0.000, 'D', 2, 355, '2018-07-18'),
(1289, 0.000, 'D', 3, 355, '2018-07-18'),
(1290, 0.000, 'D', 4, 355, '2018-07-18'),
(1291, 0.000, 'D', 1, 356, '2018-07-18'),
(1292, 0.000, 'D', 2, 356, '2018-07-18'),
(1293, 0.000, 'D', 3, 356, '2018-07-18'),
(1294, 0.000, 'D', 4, 356, '2018-07-18');
INSERT INTO `opening_cc` (`opening_id`, `op_balance`, `op_balance_dc`, `cc_id`, `ledger_id`, `updated_date`) VALUES
(1295, 0.000, 'D', 1, 357, '2018-07-18'),
(1296, 0.000, 'D', 2, 357, '2018-07-18'),
(1297, 0.000, 'D', 3, 357, '2018-07-18'),
(1298, 0.000, 'D', 4, 357, '2018-07-18'),
(1299, 0.000, 'D', 1, 358, '2018-07-18'),
(1300, 0.000, 'D', 2, 358, '2018-07-18'),
(1301, 0.000, 'D', 3, 358, '2018-07-18'),
(1302, 0.000, 'D', 4, 358, '2018-07-18'),
(1303, 0.000, 'D', 1, 359, '2018-05-16'),
(1304, 0.000, 'D', 2, 359, '2018-05-16'),
(1305, 285989.110, 'D', 3, 359, '2018-05-16'),
(1306, 0.000, 'D', 4, 359, '2018-05-16'),
(1307, 0.000, 'C', 1, 363, '2018-07-18'),
(1308, 0.000, 'C', 2, 363, '2018-07-18'),
(1309, 11064.190, 'C', 3, 363, '2018-07-18'),
(1310, 0.000, 'C', 4, 363, '2018-07-18'),
(1311, 0.000, 'C', 1, 364, '2018-07-18'),
(1312, 0.000, 'C', 2, 364, '2018-07-18'),
(1313, 0.000, 'C', 3, 364, '2018-07-18'),
(1314, 0.000, 'C', 4, 364, '2018-07-18'),
(1315, 0.000, 'C', 1, 365, '2018-07-18'),
(1316, 0.000, 'C', 2, 365, '2018-07-18'),
(1317, 0.000, 'C', 3, 365, '2018-07-18'),
(1318, 0.000, 'C', 4, 365, '2018-07-18'),
(1319, 0.000, 'D', 1, 366, '2018-07-18'),
(1320, 0.000, 'D', 2, 366, '2018-07-18'),
(1321, 0.000, 'D', 3, 366, '2018-07-18'),
(1322, 0.000, 'D', 4, 366, '2018-07-18'),
(1323, 0.000, 'D', 1, 367, '2018-07-18'),
(1324, 0.000, 'D', 2, 367, '2018-07-18'),
(1325, 0.000, 'D', 3, 367, '2018-07-18'),
(1326, 0.000, 'D', 4, 367, '2018-07-18'),
(1327, 0.000, 'D', 1, 368, '2018-07-18'),
(1328, 0.000, 'D', 2, 368, '2018-07-18'),
(1329, 0.000, 'D', 3, 368, '2018-07-18'),
(1330, 0.000, 'D', 4, 368, '2018-07-18'),
(1331, 0.000, 'D', 1, 369, '2018-07-18'),
(1332, 0.000, 'D', 2, 369, '2018-07-18'),
(1333, 0.000, 'D', 3, 369, '2018-07-18'),
(1334, 0.000, 'D', 4, 369, '2018-07-18'),
(1335, 0.000, 'D', 1, 370, '2018-07-18'),
(1336, 0.000, 'D', 2, 370, '2018-07-18'),
(1337, 0.000, 'D', 3, 370, '2018-07-18'),
(1338, 0.000, 'D', 4, 370, '2018-07-18'),
(1339, 0.000, 'D', 1, 371, '2018-07-18'),
(1340, 0.000, 'D', 2, 371, '2018-07-18'),
(1341, 0.000, 'D', 3, 371, '2018-07-18'),
(1342, 0.000, 'D', 4, 371, '2018-07-18'),
(1343, 0.000, 'D', 1, 372, '2018-07-18'),
(1344, 0.000, 'D', 2, 372, '2018-07-18'),
(1345, 0.000, 'D', 3, 372, '2018-07-18'),
(1346, 0.000, 'D', 4, 372, '2018-07-18'),
(1347, 0.000, 'D', 1, 373, '2018-05-16'),
(1348, 0.000, 'D', 2, 373, '2018-05-16'),
(1349, 0.000, 'D', 3, 373, '2018-05-16'),
(1350, 0.000, 'D', 4, 373, '2018-05-16'),
(1351, 0.000, 'D', 1, 374, '2018-07-18'),
(1352, 0.000, 'D', 2, 374, '2018-07-18'),
(1353, 0.000, 'D', 3, 374, '2018-07-18'),
(1354, 0.000, 'D', 4, 374, '2018-07-18'),
(1355, 0.000, 'D', 1, 375, '2018-07-18'),
(1356, 0.000, 'D', 2, 375, '2018-07-18'),
(1357, 0.000, 'D', 3, 375, '2018-07-18'),
(1358, 0.000, 'D', 4, 375, '2018-07-18'),
(1359, 0.000, 'D', 1, 376, '2018-07-18'),
(1360, 0.000, 'D', 2, 376, '2018-07-18'),
(1361, 0.000, 'D', 3, 376, '2018-07-18'),
(1362, 0.000, 'D', 4, 376, '2018-07-18'),
(1363, 0.000, 'C', 1, 377, '2018-07-18'),
(1364, 0.000, 'C', 2, 377, '2018-07-18'),
(1365, 0.000, 'C', 3, 377, '2018-07-18'),
(1366, 0.000, 'C', 4, 377, '2018-07-18'),
(1367, 0.000, 'D', 1, 378, '2018-07-18'),
(1368, 0.000, 'D', 2, 378, '2018-07-18'),
(1369, 0.000, 'D', 3, 378, '2018-07-18'),
(1370, 0.000, 'D', 4, 378, '2018-07-18'),
(1371, 0.000, 'D', 1, 379, '2018-05-17'),
(1372, 0.000, 'D', 2, 379, '2018-05-17'),
(1373, 0.000, 'D', 3, 379, '2018-05-17'),
(1374, 0.000, 'D', 4, 379, '2018-05-17'),
(1375, 0.000, 'D', 1, 380, '2018-07-18'),
(1376, 0.000, 'D', 2, 380, '2018-07-18'),
(1377, 0.000, 'D', 3, 380, '2018-07-18'),
(1378, 0.000, 'D', 4, 380, '2018-07-18'),
(1379, 0.000, 'D', 1, 381, '2018-07-18'),
(1380, 0.000, 'D', 2, 381, '2018-07-18'),
(1381, 0.000, 'D', 3, 381, '2018-07-18'),
(1382, 0.000, 'D', 4, 381, '2018-07-18'),
(1383, 0.000, 'D', 1, 382, '2018-06-02'),
(1384, 0.000, 'D', 2, 382, '2018-06-02'),
(1385, 0.000, 'D', 3, 382, '2018-06-02'),
(1386, 0.000, 'D', 4, 382, '2018-06-02'),
(1387, 0.000, 'D', 1, 383, '2018-07-18'),
(1388, 0.000, 'D', 2, 383, '2018-07-18'),
(1389, 0.000, 'D', 3, 383, '2018-07-18'),
(1390, 0.000, 'D', 4, 383, '2018-07-18'),
(1391, 0.000, 'C', 1, 388, '2018-07-18'),
(1392, 0.000, 'C', 2, 388, '2018-07-18'),
(1393, 0.000, 'C', 3, 388, '2018-07-18'),
(1394, 0.000, 'C', 4, 388, '2018-07-18'),
(1395, 0.000, 'D', 1, 389, '2018-07-18'),
(1396, 0.000, 'D', 2, 389, '2018-07-18'),
(1397, 0.000, 'D', 3, 389, '2018-07-18'),
(1398, 0.000, 'D', 4, 389, '2018-07-18'),
(1399, 0.000, 'C', 1, 390, '2018-07-18'),
(1400, 0.000, 'C', 2, 390, '2018-07-18'),
(1401, 0.000, 'C', 3, 390, '2018-07-18'),
(1402, 0.000, 'C', 4, 390, '2018-07-18'),
(1403, 0.000, 'D', 1, 391, '2018-05-17'),
(1404, 0.000, 'D', 2, 391, '2018-05-17'),
(1405, 0.000, 'D', 3, 391, '2018-05-17'),
(1406, 0.000, 'D', 4, 391, '2018-05-17'),
(1407, 0.000, 'D', 1, 392, '2018-07-18'),
(1408, 0.000, 'D', 2, 392, '2018-07-18'),
(1409, 0.000, 'D', 3, 392, '2018-07-18'),
(1410, 0.000, 'D', 4, 392, '2018-07-18'),
(1411, 0.000, 'D', 1, 393, '2018-07-18'),
(1412, 0.000, 'D', 2, 393, '2018-07-18'),
(1413, 0.000, 'D', 3, 393, '2018-07-18'),
(1414, 0.000, 'D', 4, 393, '2018-07-18'),
(1415, 0.000, 'D', 1, 394, '2018-07-18'),
(1416, 0.000, 'D', 2, 394, '2018-07-18'),
(1417, 0.000, 'D', 3, 394, '2018-07-18'),
(1418, 0.000, 'D', 4, 394, '2018-07-18'),
(1419, 0.000, 'D', 1, 395, '2018-07-18'),
(1420, 0.000, 'D', 2, 395, '2018-07-18'),
(1421, 0.000, 'D', 3, 395, '2018-07-18'),
(1422, 0.000, 'D', 4, 395, '2018-07-18'),
(1423, 0.000, 'C', 1, 396, '2018-07-18'),
(1424, 0.000, 'C', 2, 396, '2018-07-18'),
(1425, 0.000, 'C', 3, 396, '2018-07-18'),
(1426, 0.000, 'C', 4, 396, '2018-07-18'),
(1427, 0.000, 'D', 1, 397, '2018-07-18'),
(1428, 0.000, 'D', 2, 397, '2018-07-18'),
(1429, 0.000, 'D', 3, 397, '2018-07-18'),
(1430, 0.000, 'D', 4, 397, '2018-07-18'),
(1431, 0.000, 'D', 1, 398, '2018-07-18'),
(1432, 0.000, 'D', 2, 398, '2018-07-18'),
(1433, 0.000, 'D', 3, 398, '2018-07-18'),
(1434, 0.000, 'D', 4, 398, '2018-07-18'),
(1435, 0.000, 'D', 1, 399, '2018-07-18'),
(1436, 0.000, 'D', 2, 399, '2018-07-18'),
(1437, 0.000, 'D', 3, 399, '2018-07-18'),
(1438, 0.000, 'D', 4, 399, '2018-07-18'),
(1439, 0.000, 'D', 1, 400, '2018-07-18'),
(1440, 0.000, 'D', 2, 400, '2018-07-18'),
(1441, 0.000, 'D', 3, 400, '2018-07-18'),
(1442, 0.000, 'D', 4, 400, '2018-07-18'),
(1443, 0.000, 'D', 1, 401, '2018-07-18'),
(1444, 0.000, 'D', 2, 401, '2018-07-18'),
(1445, 0.000, 'D', 3, 401, '2018-07-18'),
(1446, 0.000, 'D', 4, 401, '2018-07-18'),
(1447, 0.000, 'D', 1, 402, '2018-07-18'),
(1448, 0.000, 'D', 2, 402, '2018-07-18'),
(1449, 0.000, 'D', 3, 402, '2018-07-18'),
(1450, 0.000, 'D', 4, 402, '2018-07-18'),
(1451, 0.000, 'D', 1, 403, '2018-07-18'),
(1452, 0.000, 'D', 2, 403, '2018-07-18'),
(1453, 0.000, 'D', 3, 403, '2018-07-18'),
(1454, 0.000, 'D', 4, 403, '2018-07-18'),
(1455, 0.000, 'D', 1, 404, '2018-07-18'),
(1456, 0.000, 'D', 2, 404, '2018-07-18'),
(1457, 0.000, 'D', 3, 404, '2018-07-18'),
(1458, 0.000, 'D', 4, 404, '2018-07-18'),
(1459, 0.000, 'D', 1, 405, '2018-07-18'),
(1460, 0.000, 'D', 2, 405, '2018-07-18'),
(1461, 0.000, 'D', 3, 405, '2018-07-18'),
(1462, 0.000, 'D', 4, 405, '2018-07-18'),
(1463, 0.000, 'D', 1, 406, '2018-06-06'),
(1464, 0.000, 'D', 2, 406, '2018-06-06'),
(1465, 0.000, 'D', 3, 406, '2018-06-06'),
(1466, 0.000, 'D', 4, 406, '2018-06-06'),
(1467, 0.000, 'D', 1, 407, '2018-07-18'),
(1468, 0.000, 'D', 2, 407, '2018-07-18'),
(1469, 0.000, 'D', 3, 407, '2018-07-18'),
(1470, 0.000, 'D', 4, 407, '2018-07-18'),
(1471, 0.000, 'D', 1, 408, '2018-07-18'),
(1472, 0.000, 'D', 2, 408, '2018-07-18'),
(1473, 0.000, 'D', 3, 408, '2018-07-18'),
(1474, 0.000, 'D', 4, 408, '2018-07-18'),
(1475, 0.000, 'D', 1, 409, '2018-07-18'),
(1476, 0.000, 'D', 2, 409, '2018-07-18'),
(1477, 0.000, 'D', 3, 409, '2018-07-18'),
(1478, 0.000, 'D', 4, 409, '2018-07-18'),
(1479, 0.000, 'D', 1, 409, '2018-06-25'),
(1480, 0.000, 'D', 2, 409, '2018-06-25'),
(1481, 0.000, 'D', 3, 409, '2018-06-25'),
(1482, 0.000, 'D', 4, 409, '2018-06-25'),
(1483, 0.000, 'D', 1, 410, '2018-07-18'),
(1484, 0.000, 'D', 2, 410, '2018-07-18'),
(1485, 0.000, 'D', 3, 410, '2018-07-18'),
(1486, 0.000, 'D', 4, 410, '2018-07-18'),
(1487, 0.000, 'D', 1, 411, '2018-07-18'),
(1488, 0.000, 'D', 2, 411, '2018-07-18'),
(1489, 0.000, 'D', 3, 411, '2018-07-18'),
(1490, 0.000, 'D', 4, 411, '2018-07-18'),
(1491, 0.000, 'D', 1, 412, '2018-07-18'),
(1492, 0.000, 'D', 2, 412, '2018-07-18'),
(1493, 0.000, 'D', 3, 412, '2018-07-18'),
(1494, 0.000, 'D', 4, 412, '2018-07-18'),
(1495, 0.000, 'D', 1, 413, '2018-07-18'),
(1496, 0.000, 'D', 2, 413, '2018-07-18'),
(1497, 0.000, 'D', 3, 413, '2018-07-18'),
(1498, 0.000, 'D', 4, 413, '2018-07-18'),
(1499, 0.000, 'D', 1, 414, '2018-07-18'),
(1500, 0.000, 'D', 2, 414, '2018-07-18'),
(1501, 0.000, 'D', 3, 414, '2018-07-18'),
(1502, 0.000, 'D', 4, 414, '2018-07-18'),
(1503, 0.000, 'D', 1, 415, '2018-07-18'),
(1504, 0.000, 'D', 2, 415, '2018-07-18'),
(1505, 0.000, 'D', 3, 415, '2018-07-18'),
(1506, 0.000, 'D', 4, 415, '2018-07-18'),
(1507, 0.000, 'D', 1, 416, '2018-07-18'),
(1508, 0.000, 'D', 2, 416, '2018-07-18'),
(1509, 0.000, 'D', 3, 416, '2018-07-18'),
(1510, 0.000, 'D', 4, 416, '2018-07-18'),
(1511, 0.000, 'D', 1, 417, '2018-07-18'),
(1512, 0.000, 'D', 2, 417, '2018-07-18'),
(1513, 0.000, 'D', 3, 417, '2018-07-18'),
(1514, 0.000, 'D', 4, 417, '2018-07-18'),
(1515, 0.000, 'D', 1, 418, '2018-07-18'),
(1516, 0.000, 'D', 2, 418, '2018-07-18'),
(1517, 0.000, 'D', 3, 418, '2018-07-18'),
(1518, 0.000, 'D', 4, 418, '2018-07-18'),
(1519, 0.000, 'D', 1, 419, '2018-07-18'),
(1520, 0.000, 'D', 2, 419, '2018-07-18'),
(1521, 0.000, 'D', 3, 419, '2018-07-18'),
(1522, 0.000, 'D', 4, 419, '2018-07-18'),
(1523, 0.000, 'D', 1, 420, '2018-07-18'),
(1524, 0.000, 'D', 2, 420, '2018-07-18'),
(1525, 0.000, 'D', 3, 420, '2018-07-18'),
(1526, 0.000, 'D', 4, 420, '2018-07-18'),
(1527, 0.000, 'D', 1, 421, '2018-07-18'),
(1528, 0.000, 'D', 2, 421, '2018-07-18'),
(1529, 0.000, 'D', 3, 421, '2018-07-18'),
(1530, 0.000, 'D', 4, 421, '2018-07-18'),
(1531, 0.000, 'D', 1, 422, '2018-07-18'),
(1532, 0.000, 'D', 2, 422, '2018-07-18'),
(1533, 0.000, 'D', 3, 422, '2018-07-18'),
(1534, 0.000, 'D', 4, 422, '2018-07-18'),
(1535, 0.000, 'D', 1, 423, '2019-11-16'),
(1536, 0.000, 'D', 2, 423, '2019-11-16'),
(1537, 0.000, 'D', 3, 423, '2019-11-16'),
(1538, 0.000, 'D', 4, 423, '2019-11-16');

-- --------------------------------------------------------

--
-- بنية الجدول `procedure_status`
--

CREATE TABLE `procedure_status` (
  `procedure_status_id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `procedure_status`
--

INSERT INTO `procedure_status` (`procedure_status_id`, `name`, `description`, `is_active`) VALUES
(1, 'Done', NULL, 1),
(2, 'Progress', NULL, NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `procedure_type`
--

CREATE TABLE `procedure_type` (
  `id_procedure_type` int(11) NOT NULL,
  `procedure_type_name` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `procedure_type`
--

INSERT INTO `procedure_type` (`id_procedure_type`, `procedure_type_name`, `description`) VALUES
(1, 'Breeding', NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `purchase_order`
--

CREATE TABLE `purchase_order` (
  `purchase_order_id` int(11) NOT NULL,
  `description` varchar(45) DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `done_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- بنية الجدول `purchase_orders_items`
--

CREATE TABLE `purchase_orders_items` (
  `purchase_order_item_id` int(11) NOT NULL,
  `purchase_order_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `quantity` float(11,2) NOT NULL,
  `price` float(11,2) NOT NULL DEFAULT '0.00',
  `currency_id` int(11) NOT NULL,
  `note` text NOT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- بنية الجدول `show_class`
--

CREATE TABLE `show_class` (
  `show_class_id` int(11) NOT NULL,
  `show_name` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `show_class`
--

INSERT INTO `show_class` (`show_class_id`, `show_name`, `description`) VALUES
(1, 'GCC Golden Show', NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `tags`
--

CREATE TABLE `tags` (
  `id` bigint(18) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `color` char(6) COLLATE utf8_unicode_ci NOT NULL,
  `background` char(6) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `tags`
--

INSERT INTO `tags` (`id`, `title`, `color`, `background`) VALUES
(1, 'System Generated', 'green', ''),
(2, 'Manual', 'blue', '');

-- --------------------------------------------------------

--
-- بنية الجدول `uom`
--

CREATE TABLE `uom` (
  `uom_id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- إرجاع أو استيراد بيانات الجدول `uom`
--

INSERT INTO `uom` (`uom_id`, `name`, `description`) VALUES
(1, 'UOM', 'description'),
(2, 'Bottle', NULL),
(3, 'kilo', NULL),
(4, 'Milli', NULL);

-- --------------------------------------------------------

--
-- بنية الجدول `u_groups`
--

CREATE TABLE `u_groups` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `acc_logs`
--
ALTER TABLE `acc_logs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `activity_cal`
--
ALTER TABLE `activity_cal`
  ADD PRIMARY KEY (`activity_cal_id`),
  ADD KEY `activity_cal_horse_idx` (`horse_ref`),
  ADD KEY `activity_cal_activity_idx` (`activity_type_ref`);

--
-- Indexes for table `activity_type`
--
ALTER TABLE `activity_type`
  ADD PRIMARY KEY (`activity_type_id`);

--
-- Indexes for table `admin_groups`
--
ALTER TABLE `admin_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admin_login_attempts`
--
ALTER TABLE `admin_login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admin_users_groups`
--
ALTER TABLE `admin_users_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`,`group_id`),
  ADD KEY `group_id` (`group_id`);

--
-- Indexes for table `appointment`
--
ALTER TABLE `appointment`
  ADD PRIMARY KEY (`appointment_id`),
  ADD KEY `customer_ref` (`customer_ref`);

--
-- Indexes for table `apps_countries`
--
ALTER TABLE `apps_countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `boarding_rate`
--
ALTER TABLE `boarding_rate`
  ADD PRIMARY KEY (`boarding_rate_id`);

--
-- Indexes for table `boarding_rooms`
--
ALTER TABLE `boarding_rooms`
  ADD PRIMARY KEY (`room_id`);

--
-- Indexes for table `checkup`
--
ALTER TABLE `checkup`
  ADD PRIMARY KEY (`checkup_id`),
  ADD KEY `mare_ref` (`mare_ref`,`stallion_ref`,`done_by`);

--
-- Indexes for table `cost_center`
--
ALTER TABLE `cost_center`
  ADD PRIMARY KEY (`cost_center_id`);

--
-- Indexes for table `currency`
--
ALTER TABLE `currency`
  ADD PRIMARY KEY (`currency_id`);

--
-- Indexes for table `customer_group`
--
ALTER TABLE `customer_group`
  ADD PRIMARY KEY (`customer_group_id`);

--
-- Indexes for table `entries`
--
ALTER TABLE `entries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD KEY `id` (`id`),
  ADD KEY `tag_id` (`tag_id`),
  ADD KEY `entrytype_id` (`entrytype_id`);

--
-- Indexes for table `entryitems`
--
ALTER TABLE `entryitems`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD KEY `id` (`id`),
  ADD KEY `entry_id` (`entry_id`),
  ADD KEY `ledger_id` (`ledger_id`);

--
-- Indexes for table `entrytypes`
--
ALTER TABLE `entrytypes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD UNIQUE KEY `label` (`label`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `feed_program`
--
ALTER TABLE `feed_program`
  ADD PRIMARY KEY (`feed_program_id`);

--
-- Indexes for table `feed_sch`
--
ALTER TABLE `feed_sch`
  ADD PRIMARY KEY (`feed_sch_id`),
  ADD KEY `feed_item_idx` (`feed_ref`),
  ADD KEY `feed_horse_idx` (`horse_ref`),
  ADD KEY `feed_prog_idx` (`program_ref`),
  ADD KEY `feed_uom_idx` (`uom_ref`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `id` (`id`),
  ADD KEY `parent_id` (`parent_id`);

--
-- Indexes for table `horse`
--
ALTER TABLE `horse`
  ADD PRIMARY KEY (`horse_id`),
  ADD KEY `fk_horse_location_idx` (`location_ref`),
  ADD KEY `fk_group_group_idx` (`category_ref`),
  ADD KEY `fk_horse_group_idx` (`group_ref`),
  ADD KEY `created_user` (`created_user`,`related_customer`),
  ADD KEY `horse_ibfk_1` (`related_customer`);

--
-- Indexes for table `horse_boarding`
--
ALTER TABLE `horse_boarding`
  ADD PRIMARY KEY (`horse_boarding_id`);

--
-- Indexes for table `horse_category`
--
ALTER TABLE `horse_category`
  ADD PRIMARY KEY (`horse_category_id`);

--
-- Indexes for table `horse_entry_log`
--
ALTER TABLE `horse_entry_log`
  ADD PRIMARY KEY (`entry_log_id`);

--
-- Indexes for table `horse_group`
--
ALTER TABLE `horse_group`
  ADD PRIMARY KEY (`horse_group_id`);

--
-- Indexes for table `horse_insurance`
--
ALTER TABLE `horse_insurance`
  ADD PRIMARY KEY (`insurance_id`),
  ADD KEY `fk_horse_insurance_horse_idx` (`horse_ref`);

--
-- Indexes for table `horse_location`
--
ALTER TABLE `horse_location`
  ADD PRIMARY KEY (`horse_location_id`);

--
-- Indexes for table `horse_nomination`
--
ALTER TABLE `horse_nomination`
  ADD PRIMARY KEY (`nom_id`),
  ADD KEY `fk_horse_nomination_horse_idx` (`horse_ref`);

--
-- Indexes for table `horse_owner`
--
ALTER TABLE `horse_owner`
  ADD PRIMARY KEY (`horse_owner_id`),
  ADD KEY `fk_horse_owner_customer_idx` (`customer_ref`),
  ADD KEY `fk_horse_owner_horse_idx` (`horse_ref`);

--
-- Indexes for table `horse_pedigree`
--
ALTER TABLE `horse_pedigree`
  ADD PRIMARY KEY (`pedigree_id`);

--
-- Indexes for table `horse_procedure`
--
ALTER TABLE `horse_procedure`
  ADD PRIMARY KEY (`horse_procedure_id`),
  ADD KEY `fk_horse_procedure` (`horse_ref`),
  ADD KEY `fk_horse_procedure_status` (`status_ref`),
  ADD KEY `fk_horse_procedure_type` (`type_ref`),
  ADD KEY `fk_horse_item` (`item_ref`),
  ADD KEY `created_user` (`created_user`,`transaction_ref`,`checkup_ref`,`cc_id`),
  ADD KEY `transaction_ref` (`transaction_ref`);

--
-- Indexes for table `horse_show`
--
ALTER TABLE `horse_show`
  ADD PRIMARY KEY (`show_id`),
  ADD KEY `fk_horse_show_show_class_idx` (`class_ref`),
  ADD KEY `fk_horse_show_horse_idx` (`horse_ref`);

--
-- Indexes for table `horse_stallion`
--
ALTER TABLE `horse_stallion`
  ADD PRIMARY KEY (`horse_stallion_id`);

--
-- Indexes for table `horse_status`
--
ALTER TABLE `horse_status`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`invoice_id`),
  ADD KEY `customer_ref` (`customer_ref`,`created_by`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `invoice_code` (`invoice_code`);

--
-- Indexes for table `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `forage_uom_idx` (`uom_ref`),
  ADD KEY `item_item_cat_idx` (`item_category_ref`),
  ADD KEY `item_item_type_idx` (`item_type_ref`),
  ADD KEY `ledger_ref` (`income_ledger_ref`);

--
-- Indexes for table `item_category`
--
ALTER TABLE `item_category`
  ADD PRIMARY KEY (`item_cat_id`);

--
-- Indexes for table `item_transaction`
--
ALTER TABLE `item_transaction`
  ADD PRIMARY KEY (`item_transaction_id`);

--
-- Indexes for table `item_type`
--
ALTER TABLE `item_type`
  ADD PRIMARY KEY (`item_type_id`);

--
-- Indexes for table `ledgers`
--
ALTER TABLE `ledgers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `id` (`id`),
  ADD KEY `group_id` (`group_id`);

--
-- Indexes for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `opening_cc`
--
ALTER TABLE `opening_cc`
  ADD PRIMARY KEY (`opening_id`);

--
-- Indexes for table `procedure_status`
--
ALTER TABLE `procedure_status`
  ADD PRIMARY KEY (`procedure_status_id`);

--
-- Indexes for table `procedure_type`
--
ALTER TABLE `procedure_type`
  ADD PRIMARY KEY (`id_procedure_type`);

--
-- Indexes for table `purchase_order`
--
ALTER TABLE `purchase_order`
  ADD PRIMARY KEY (`purchase_order_id`),
  ADD KEY `done_by` (`done_by`);

--
-- Indexes for table `purchase_orders_items`
--
ALTER TABLE `purchase_orders_items`
  ADD PRIMARY KEY (`purchase_order_item_id`),
  ADD KEY `purchase_order_id` (`purchase_order_id`,`item_id`),
  ADD KEY `item_id` (`item_id`);

--
-- Indexes for table `show_class`
--
ALTER TABLE `show_class`
  ADD PRIMARY KEY (`show_class_id`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`),
  ADD UNIQUE KEY `title` (`title`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `uom`
--
ALTER TABLE `uom`
  ADD PRIMARY KEY (`uom_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `acc_logs`
--
ALTER TABLE `acc_logs`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `activity_cal`
--
ALTER TABLE `activity_cal`
  MODIFY `activity_cal_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `activity_type`
--
ALTER TABLE `activity_type`
  MODIFY `activity_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `admin_groups`
--
ALTER TABLE `admin_groups`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `admin_login_attempts`
--
ALTER TABLE `admin_login_attempts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_users_groups`
--
ALTER TABLE `admin_users_groups`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `appointment`
--
ALTER TABLE `appointment`
  MODIFY `appointment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apps_countries`
--
ALTER TABLE `apps_countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=296;

--
-- AUTO_INCREMENT for table `boarding_rate`
--
ALTER TABLE `boarding_rate`
  MODIFY `boarding_rate_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `boarding_rooms`
--
ALTER TABLE `boarding_rooms`
  MODIFY `room_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `checkup`
--
ALTER TABLE `checkup`
  MODIFY `checkup_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1209;

--
-- AUTO_INCREMENT for table `cost_center`
--
ALTER TABLE `cost_center`
  MODIFY `cost_center_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `currency`
--
ALTER TABLE `currency`
  MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_group`
--
ALTER TABLE `customer_group`
  MODIFY `customer_group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `entries`
--
ALTER TABLE `entries`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=550;

--
-- AUTO_INCREMENT for table `entryitems`
--
ALTER TABLE `entryitems`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11148;

--
-- AUTO_INCREMENT for table `entrytypes`
--
ALTER TABLE `entrytypes`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `feed_program`
--
ALTER TABLE `feed_program`
  MODIFY `feed_program_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `feed_sch`
--
ALTER TABLE `feed_sch`
  MODIFY `feed_sch_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;

--
-- AUTO_INCREMENT for table `horse`
--
ALTER TABLE `horse`
  MODIFY `horse_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3490;

--
-- AUTO_INCREMENT for table `horse_boarding`
--
ALTER TABLE `horse_boarding`
  MODIFY `horse_boarding_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_category`
--
ALTER TABLE `horse_category`
  MODIFY `horse_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `horse_entry_log`
--
ALTER TABLE `horse_entry_log`
  MODIFY `entry_log_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_group`
--
ALTER TABLE `horse_group`
  MODIFY `horse_group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `horse_insurance`
--
ALTER TABLE `horse_insurance`
  MODIFY `insurance_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_location`
--
ALTER TABLE `horse_location`
  MODIFY `horse_location_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `horse_nomination`
--
ALTER TABLE `horse_nomination`
  MODIFY `nom_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_owner`
--
ALTER TABLE `horse_owner`
  MODIFY `horse_owner_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_pedigree`
--
ALTER TABLE `horse_pedigree`
  MODIFY `pedigree_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_procedure`
--
ALTER TABLE `horse_procedure`
  MODIFY `horse_procedure_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2319;

--
-- AUTO_INCREMENT for table `horse_show`
--
ALTER TABLE `horse_show`
  MODIFY `show_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `horse_stallion`
--
ALTER TABLE `horse_stallion`
  MODIFY `horse_stallion_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=453;

--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1982;

--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `item`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=169;

--
-- AUTO_INCREMENT for table `item_category`
--
ALTER TABLE `item_category`
  MODIFY `item_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `item_transaction`
--
ALTER TABLE `item_transaction`
  MODIFY `item_transaction_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `item_type`
--
ALTER TABLE `item_type`
  MODIFY `item_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ledgers`
--
ALTER TABLE `ledgers`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=424;

--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `opening_cc`
--
ALTER TABLE `opening_cc`
  MODIFY `opening_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1539;

--
-- AUTO_INCREMENT for table `procedure_status`
--
ALTER TABLE `procedure_status`
  MODIFY `procedure_status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `procedure_type`
--
ALTER TABLE `procedure_type`
  MODIFY `id_procedure_type` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `purchase_order`
--
ALTER TABLE `purchase_order`
  MODIFY `purchase_order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_orders_items`
--
ALTER TABLE `purchase_orders_items`
  MODIFY `purchase_order_item_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `show_class`
--
ALTER TABLE `show_class`
  MODIFY `show_class_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `uom`
--
ALTER TABLE `uom`
  MODIFY `uom_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- قيود الجداول المُلقاة.
--

--
-- قيود الجداول `activity_cal`
--
ALTER TABLE `activity_cal`
  ADD CONSTRAINT `activity_cal_activity` FOREIGN KEY (`activity_type_ref`) REFERENCES `activity_type` (`activity_type_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `activity_cal_horse` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `admin_users_groups`
--
ALTER TABLE `admin_users_groups`
  ADD CONSTRAINT `admin_users_groups_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_users` (`id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `admin_users_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `admin_groups` (`id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `appointment`
--
ALTER TABLE `appointment`
  ADD CONSTRAINT `appointment_ibfk_1` FOREIGN KEY (`customer_ref`) REFERENCES `customer` (`customer_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `checkup`
--
ALTER TABLE `checkup`
  ADD CONSTRAINT `fk_horse_ref_mare` FOREIGN KEY (`mare_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `entries`
--
ALTER TABLE `entries`
  ADD CONSTRAINT `acc_entries_fk_check_entrytype_id` FOREIGN KEY (`entrytype_id`) REFERENCES `entrytypes` (`id`),
  ADD CONSTRAINT `acc_entries_fk_check_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`);

--
-- قيود الجداول `entryitems`
--
ALTER TABLE `entryitems`
  ADD CONSTRAINT `acc_entryitems_fk_check_entry_id` FOREIGN KEY (`entry_id`) REFERENCES `entries` (`id`),
  ADD CONSTRAINT `acc_entryitems_fk_check_ledger_id` FOREIGN KEY (`ledger_id`) REFERENCES `ledgers` (`id`);

--
-- قيود الجداول `feed_sch`
--
ALTER TABLE `feed_sch`
  ADD CONSTRAINT `feed_horse` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `feed_item` FOREIGN KEY (`feed_ref`) REFERENCES `item` (`item_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `feed_prog` FOREIGN KEY (`program_ref`) REFERENCES `feed_program` (`feed_program_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `feed_uom` FOREIGN KEY (`uom_ref`) REFERENCES `uom` (`uom_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `groups`
--
ALTER TABLE `groups`
  ADD CONSTRAINT `acc_groups_fk_check_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `groups` (`id`);

--
-- قيود الجداول `horse`
--
ALTER TABLE `horse`
  ADD CONSTRAINT `fk_horse_category` FOREIGN KEY (`category_ref`) REFERENCES `horse_category` (`horse_category_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_group` FOREIGN KEY (`group_ref`) REFERENCES `horse_group` (`horse_group_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_location` FOREIGN KEY (`location_ref`) REFERENCES `horse_location` (`horse_location_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `horse_ibfk_1` FOREIGN KEY (`related_customer`) REFERENCES `customer` (`customer_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `horse_ibfk_2` FOREIGN KEY (`created_user`) REFERENCES `admin_users` (`id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `horse_insurance`
--
ALTER TABLE `horse_insurance`
  ADD CONSTRAINT `fk_horse_insurance_horse` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `horse_nomination`
--
ALTER TABLE `horse_nomination`
  ADD CONSTRAINT `fk_horse_nomination_horse` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `horse_owner`
--
ALTER TABLE `horse_owner`
  ADD CONSTRAINT `fk_horse_owner_customer` FOREIGN KEY (`customer_ref`) REFERENCES `customer` (`customer_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_owner_horse` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `horse_procedure`
--
ALTER TABLE `horse_procedure`
  ADD CONSTRAINT `fk_horse_item` FOREIGN KEY (`item_ref`) REFERENCES `item` (`item_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_procedure` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_procedure_status` FOREIGN KEY (`status_ref`) REFERENCES `procedure_status` (`procedure_status_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_procedure_type` FOREIGN KEY (`type_ref`) REFERENCES `procedure_type` (`id_procedure_type`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `horse_procedure_ibfk_1` FOREIGN KEY (`created_user`) REFERENCES `admin_users` (`id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `horse_show`
--
ALTER TABLE `horse_show`
  ADD CONSTRAINT `fk_horse_show_horse` FOREIGN KEY (`horse_ref`) REFERENCES `horse` (`horse_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_horse_show_show_class` FOREIGN KEY (`class_ref`) REFERENCES `show_class` (`show_class_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `invoice`
--
ALTER TABLE `invoice`
  ADD CONSTRAINT `invoice_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admin_users` (`id`),
  ADD CONSTRAINT `invoice_ibfk_2` FOREIGN KEY (`customer_ref`) REFERENCES `customer` (`customer_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `item`
--
ALTER TABLE `item`
  ADD CONSTRAINT `fk_item_item_cat` FOREIGN KEY (`item_category_ref`) REFERENCES `item_category` (`item_cat_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_item_item_type` FOREIGN KEY (`item_type_ref`) REFERENCES `item_type` (`item_type_id`) ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_item_uom` FOREIGN KEY (`uom_ref`) REFERENCES `uom` (`uom_id`) ON UPDATE NO ACTION;

--
-- قيود الجداول `ledgers`
--
ALTER TABLE `ledgers`
  ADD CONSTRAINT `acc_ledgers_fk_check_group_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`);

--
-- قيود الجداول `purchase_order`
--
ALTER TABLE `purchase_order`
  ADD CONSTRAINT `purchase_order_ibfk_1` FOREIGN KEY (`done_by`) REFERENCES `admin_users` (`id`);

--
-- قيود الجداول `purchase_orders_items`
--
ALTER TABLE `purchase_orders_items`
  ADD CONSTRAINT `purchase_orders_items_ibfk_1` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_order` (`purchase_order_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `purchase_orders_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `item` (`item_id`) ON UPDATE NO ACTION;
COMMIT;

