-- http://www.phpmyadmin.net
--




--
-- Database: `siffsobm2`
--

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

--
-- Table structure for table `account_type`
--

CREATE TABLE IF NOT EXISTS `account_type` (
  `account_id` int(250) NOT NULL AUTO_INCREMENT,
  `account_name` varchar(250) NOT NULL,
  `order_id` int(250) NOT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `account_type`
--

INSERT INTO `account_type` (`account_id`, `account_name`, `order_id`) VALUES
(1, 'Asset', 2),
(2, 'Liability', 1),
(3, 'Income', 3),
(4, 'Expenses', 4);

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

--
-- Table structure for table `chart_of_account`
--

CREATE TABLE IF NOT EXISTS `chart_of_account` (
  `pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `branch_id` int(250) NOT NULL,
  `warehouse_id` int(150) NOT NULL,
  `account_id` int(250) NOT NULL,
  `level` int(100) NOT NULL,
  `parent_id` int(250) NOT NULL,
  `category_name` varchar(250) NOT NULL,
  `created_date` int(250) NOT NULL,
  `created_time` int(250) NOT NULL,
  `category_status` int(11) NOT NULL DEFAULT '1',
  `chart_of_acc_entry_status` int(250) NOT NULL,
  PRIMARY KEY (`pk_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1208 ;

--
-- Dumping data for table `chart_of_account`
--

INSERT INTO `chart_of_account` (`pk_id`, `category_id`, `branch_id`, `warehouse_id`, `account_id`, `level`, `parent_id`, `category_name`, `created_date`, `created_time`, `category_status`, `chart_of_acc_entry_status`) VALUES
(1146, 15, 41, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1145, 15, 40, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1144, 15, 39, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1143, 15, 38, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1142, 15, 37, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1141, 15, 36, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1140, 15, 0, 0, 2, 2, 7, 'GST', 1526581800, 1526626576, 1, 1),
(1139, 16, 0, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1138, 13, 0, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1127, 2, 0, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1128, 3, 0, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1129, 4, 0, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1130, 5, 0, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1131, 6, 0, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1132, 7, 0, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1133, 8, 0, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1134, 9, 0, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1135, 10, 0, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1136, 11, 0, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1137, 12, 0, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1176, 19, 0, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1175, 18, 0, 0, 3, 2, 8, 'Customers GST', 1526754600, 1526804787, 1, 1),
(1174, 17, 50, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1173, 17, 49, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1172, 17, 48, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1171, 17, 47, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1170, 17, 46, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1169, 17, 45, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1168, 17, 44, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1167, 17, 43, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1166, 17, 42, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1165, 17, 41, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1164, 17, 40, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1163, 17, 39, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1162, 17, 38, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1161, 17, 37, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1159, 17, 0, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1160, 17, 36, 0, 4, 2, 10, 'Suppliers GST', 1526754600, 1526795124, 1, 1),
(1154, 16, 36, 0, 1, 1, 0, 'Fixed Assets', 1526668200, 1526733701, 1, 1),
(1153, 15, 50, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1152, 15, 49, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1151, 15, 47, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1150, 15, 46, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1149, 15, 45, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1148, 15, 44, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1147, 15, 43, 0, 2, 2, 7, 'GST', 0, 0, 1, 1),
(1125, 16, 50, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1124, 13, 50, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1123, 12, 50, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1122, 11, 50, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1121, 10, 50, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1120, 9, 50, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1119, 8, 50, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1118, 7, 50, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1117, 6, 50, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1116, 5, 50, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1115, 4, 50, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1114, 3, 50, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1113, 2, 50, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1112, 1, 50, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1111, 16, 49, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1110, 13, 49, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1109, 12, 49, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1108, 11, 49, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1107, 10, 49, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1106, 9, 49, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1105, 8, 49, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1104, 7, 49, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1103, 6, 49, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1102, 5, 49, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1101, 4, 49, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1100, 3, 49, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1099, 2, 49, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1098, 1, 49, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1097, 16, 48, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1126, 1, 0, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1096, 13, 48, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1095, 12, 48, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1094, 11, 48, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1093, 10, 48, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1092, 9, 48, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1091, 8, 48, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1090, 7, 48, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1089, 6, 48, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1088, 5, 48, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1087, 4, 48, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1086, 3, 48, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1085, 2, 48, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1084, 1, 48, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1083, 16, 47, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1082, 13, 47, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1081, 12, 47, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1080, 11, 47, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1079, 10, 47, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1078, 9, 47, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1077, 8, 47, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1076, 7, 47, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1075, 6, 47, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1074, 5, 47, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1073, 4, 47, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1072, 3, 47, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1071, 2, 47, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1070, 1, 47, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1069, 16, 46, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1068, 13, 46, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1067, 12, 46, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1066, 11, 46, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1065, 10, 46, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1064, 9, 46, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1063, 8, 46, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1062, 7, 46, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1061, 6, 46, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1060, 5, 46, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1059, 4, 46, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1058, 3, 46, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1057, 2, 46, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1056, 1, 46, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1055, 16, 45, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1054, 13, 45, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1053, 12, 45, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1052, 11, 45, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1051, 10, 45, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1050, 9, 45, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1049, 8, 45, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1048, 7, 45, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1047, 6, 45, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1046, 5, 45, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1045, 4, 45, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1044, 3, 45, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1043, 2, 45, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1042, 1, 45, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1041, 16, 44, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1040, 13, 44, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1039, 12, 44, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1038, 11, 44, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1037, 10, 44, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1036, 9, 44, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1035, 8, 44, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1034, 7, 44, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1033, 6, 44, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1032, 5, 44, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1031, 4, 44, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1030, 3, 44, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1029, 2, 44, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1028, 1, 44, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1027, 16, 43, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1026, 13, 43, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1025, 12, 43, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1024, 11, 43, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1023, 10, 43, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1022, 9, 43, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1021, 8, 43, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1020, 7, 43, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1019, 6, 43, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1018, 5, 43, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1017, 4, 43, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1016, 3, 43, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1015, 2, 43, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1014, 1, 43, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1013, 16, 42, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(1012, 13, 42, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(1011, 12, 42, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(1010, 11, 42, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(1009, 10, 42, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(1008, 9, 42, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(1007, 8, 42, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(1006, 7, 42, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(1005, 6, 42, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(1004, 5, 42, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(1003, 4, 42, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(1002, 3, 42, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(1001, 2, 42, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(1000, 1, 42, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(999, 16, 41, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(998, 13, 41, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(997, 12, 41, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(996, 11, 41, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(995, 10, 41, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(994, 9, 41, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(993, 8, 41, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(992, 7, 41, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(991, 6, 41, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(990, 5, 41, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(989, 4, 41, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(988, 3, 41, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(987, 2, 41, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(986, 1, 41, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(985, 16, 40, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(984, 13, 40, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(983, 12, 40, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(982, 11, 40, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(981, 10, 40, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(980, 9, 40, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(979, 8, 40, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(978, 7, 40, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(977, 6, 40, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(976, 5, 40, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(975, 4, 40, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(974, 3, 40, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(973, 2, 40, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(972, 1, 40, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(971, 16, 39, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(970, 13, 39, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(969, 12, 39, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(968, 11, 39, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(967, 10, 39, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(966, 9, 39, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(965, 8, 39, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(964, 7, 39, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(963, 6, 39, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(962, 5, 39, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(961, 4, 39, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(960, 3, 39, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(959, 2, 39, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(958, 1, 39, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(957, 16, 38, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(956, 13, 38, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(955, 12, 38, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(954, 11, 38, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(953, 10, 38, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(952, 9, 38, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(951, 8, 38, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(950, 7, 38, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(949, 6, 38, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(948, 5, 38, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(947, 4, 38, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(946, 3, 38, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(945, 2, 38, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(944, 1, 38, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(942, 13, 37, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(943, 16, 37, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(941, 12, 37, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(940, 11, 37, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(939, 10, 37, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(938, 9, 37, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(937, 8, 37, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(936, 7, 37, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(935, 6, 37, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(934, 5, 37, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(933, 4, 37, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(932, 3, 37, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(931, 2, 37, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(930, 1, 37, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(928, 13, 36, 0, 3, 2, 8, 'Customers', 0, 0, 1, 1),
(929, 16, 36, 0, 4, 2, 10, 'Suppliers', 0, 0, 1, 1),
(927, 12, 36, 0, 1, 2, 1, 'Cash at Bank', 0, 0, 1, 1),
(926, 11, 36, 0, 1, 2, 1, 'Cash in Hand', 0, 0, 1, 1),
(924, 9, 36, 0, 4, 1, 0, 'Direct Expenses', 0, 0, 1, 0),
(925, 10, 36, 0, 4, 1, 0, 'Indirect Expenses', 0, 0, 1, 0),
(923, 8, 36, 0, 3, 1, 0, 'Direct Income', 0, 0, 1, 0),
(922, 7, 36, 0, 2, 1, 0, 'Taxes', 0, 0, 1, 0),
(921, 6, 36, 0, 2, 1, 0, 'Revenue Reserves', 0, 0, 1, 0),
(920, 5, 36, 0, 2, 1, 0, 'Sundry Creditors', 0, 0, 1, 0),
(919, 4, 36, 0, 1, 1, 0, 'Sundry Debtors', 0, 0, 1, 0),
(918, 3, 36, 0, 1, 1, 0, 'Damaged Stocks', 0, 0, 1, 0),
(917, 2, 36, 0, 1, 1, 0, 'Stocks', 0, 0, 1, 0),
(916, 1, 36, 0, 1, 1, 0, 'Current Assets', 0, 0, 1, 0),
(1177, 20, 0, 0, 4, 2, 10, 'Workshop Transfer GST', 1526927400, 1526973499, 1, 1),
(1178, 19, 36, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1179, 19, 37, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1180, 19, 38, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1181, 19, 39, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1182, 19, 40, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1183, 19, 41, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1184, 19, 42, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1185, 19, 43, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1186, 19, 44, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1187, 19, 45, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1188, 19, 46, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1189, 19, 47, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1190, 19, 48, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1191, 19, 49, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1192, 19, 50, 0, 4, 2, 10, 'Workshop Transfer', 1526927400, 1526973469, 1, 1),
(1193, 20, 36, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1194, 20, 37, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1195, 20, 38, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1196, 20, 39, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1197, 20, 40, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1198, 20, 41, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1199, 20, 42, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1200, 20, 43, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1201, 20, 44, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1202, 20, 45, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1203, 20, 46, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1204, 20, 47, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1205, 20, 48, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1206, 20, 49, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1),
(1207, 20, 50, 0, 4, 2, 10, 'Workshop Transfer GST', 1526581800, 1526973469, 1, 1);

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

--
-- Table structure for table `ledgers`
--

CREATE TABLE IF NOT EXISTS `ledgers` (
  `ledger_id` int(250) NOT NULL AUTO_INCREMENT,
  `branch_id` int(250) NOT NULL,
  `mis_id` int(150) NOT NULL,
  `category_id` int(250) NOT NULL,
  `ledger_type` int(11) NOT NULL,
  `ledger_name` text NOT NULL,
  `bank_account_number` int(250) NOT NULL,
  `created_date` int(250) NOT NULL,
  `created_time` int(250) NOT NULL,
  `ledger_status` int(11) NOT NULL DEFAULT '1',
  `ledger_hide_status` int(250) NOT NULL DEFAULT '0',
  `chart_of_acc_entry_status` int(250) NOT NULL,
  PRIMARY KEY (`ledger_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=766 ;

--
-- Dumping data for table `ledgers`
--

INSERT INTO `ledgers` (`ledger_id`, `branch_id`, `mis_id`, `category_id`, `ledger_type`, `ledger_name`, `bank_account_number`, `created_date`, `created_time`, `ledger_status`, `ledger_hide_status`, `chart_of_acc_entry_status`) VALUES
(64, 0, 0, 15, 0, 'GST', 0, 1526581800, 1526628327, 1, 0, 1),
(66, 0, 0, 13, 0, 'Customer', 0, 1526581800, 1526628969, 1, 0, 1),
(67, 0, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(68, 0, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(69, 36, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(70, 36, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(71, 36, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(72, 36, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(73, 37, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(74, 37, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(75, 37, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(76, 37, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(77, 38, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(78, 38, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(79, 38, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(80, 38, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(81, 39, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(82, 39, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(83, 39, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(84, 39, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(85, 40, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(86, 40, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(87, 40, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(88, 40, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(89, 41, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(90, 41, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(91, 41, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(92, 41, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(93, 42, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(94, 42, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(95, 42, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(96, 42, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(97, 43, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(98, 43, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(99, 43, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(100, 43, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(101, 44, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(102, 44, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(103, 44, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(104, 44, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(105, 45, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(106, 45, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(107, 45, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(108, 45, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(109, 46, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(110, 46, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(111, 46, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(112, 46, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(113, 47, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(114, 47, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(115, 47, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(116, 47, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(117, 48, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(118, 48, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(119, 48, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(120, 48, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(121, 49, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(122, 49, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(123, 49, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(124, 49, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(125, 50, 0, 15, 0, 'GST', 0, 0, 0, 1, 0, 1),
(126, 50, 0, 11, 0, 'Cash', 0, 0, 0, 1, 0, 1),
(127, 50, 0, 12, 0, 'Bank', 0, 0, 0, 1, 0, 1),
(128, 50, 0, 13, 0, 'Customer', 0, 0, 0, 1, 0, 1),
(748, 44, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(750, 48, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(746, 38, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(744, 46, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(742, 45, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(740, 39, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(738, 47, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(736, 42, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(734, 43, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(732, 0, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(730, 40, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(728, 37, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(726, 50, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(724, 49, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(722, 41, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(720, 36, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(718, 48, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(716, 44, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(199, 0, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(200, 36, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(201, 37, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(202, 38, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(203, 39, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(204, 40, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(205, 41, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(206, 42, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(207, 43, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(208, 44, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(209, 45, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(210, 46, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(211, 47, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(212, 48, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(213, 49, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(214, 50, 0, 18, 0, 'Customer GST', 0, 1526841000, 1526880204, 1, 0, 1),
(714, 38, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(710, 45, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(712, 46, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(708, 39, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(704, 42, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(706, 47, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(702, 43, 33, 16, 0, 'UNITEDDISTRIBUTORS', 0, 0, 0, 1, 0, 1),
(698, 40, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(700, 0, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(696, 37, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(692, 49, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(694, 50, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(690, 41, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(686, 48, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(688, 36, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(684, 44, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(680, 46, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(682, 38, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(678, 45, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(674, 47, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(676, 39, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(672, 42, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(670, 43, 31, 16, 0, 'SUZUKI MOTOR CORPORATION', 0, 0, 0, 1, 0, 1),
(249, 0, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(250, 0, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(251, 0, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(252, 0, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(253, 0, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(254, 0, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(255, 0, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(256, 0, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(257, 0, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(258, 0, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(259, 0, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(260, 0, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(261, 0, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(262, 0, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(263, 36, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(264, 36, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(265, 36, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(266, 36, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(267, 36, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(268, 36, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(269, 36, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(270, 36, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(271, 36, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(272, 36, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(273, 36, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(274, 36, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(275, 36, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(276, 36, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(277, 37, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(278, 37, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(279, 37, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(280, 37, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(281, 37, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(282, 37, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(283, 37, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(284, 37, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(285, 37, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(286, 37, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(287, 37, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(288, 37, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(289, 37, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(290, 37, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(291, 38, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(292, 38, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(293, 38, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(294, 38, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(295, 38, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(296, 38, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(297, 38, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(298, 38, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(299, 38, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(300, 38, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(301, 38, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(302, 38, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(303, 38, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(304, 38, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(305, 39, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(306, 39, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(307, 39, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(308, 39, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(309, 39, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(310, 39, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(311, 39, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(312, 39, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(313, 39, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(314, 39, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(315, 39, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(316, 39, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(317, 39, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(318, 39, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(319, 40, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(320, 40, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(321, 40, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(322, 40, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(323, 40, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(324, 40, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(325, 40, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(326, 40, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(327, 40, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(328, 40, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(329, 40, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(330, 40, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(331, 40, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(332, 40, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(333, 41, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(334, 41, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(335, 41, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(336, 41, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(337, 41, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(338, 41, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(339, 41, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(340, 41, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(341, 41, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(342, 41, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(343, 41, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(344, 41, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(345, 41, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(346, 41, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(347, 42, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(348, 42, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(349, 42, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(350, 42, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(351, 42, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(352, 42, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(353, 42, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(354, 42, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(355, 42, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(356, 42, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(357, 42, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(358, 42, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(359, 42, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(360, 42, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(361, 43, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(362, 43, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(363, 43, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(364, 43, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(365, 43, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(366, 43, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(367, 43, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(368, 43, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(369, 43, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(370, 43, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(371, 43, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(372, 43, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(373, 43, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(374, 43, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(375, 45, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(376, 45, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(377, 45, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(378, 45, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(379, 45, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(380, 45, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(381, 45, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(382, 45, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(383, 45, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(384, 45, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(385, 45, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(386, 45, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(387, 45, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(388, 45, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(389, 46, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(390, 46, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(391, 46, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(392, 46, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(393, 46, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(394, 46, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(395, 46, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(396, 46, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(397, 46, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(398, 46, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(399, 46, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(400, 46, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(401, 46, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(402, 46, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(403, 47, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(404, 47, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(405, 47, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(406, 47, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(407, 47, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(408, 47, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(409, 47, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(410, 47, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(411, 47, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(412, 47, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(413, 47, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(414, 47, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(415, 47, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(416, 47, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(417, 47, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(418, 48, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(419, 48, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(420, 48, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(421, 48, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(422, 48, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(423, 48, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(424, 48, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(425, 48, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(426, 48, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(427, 48, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(428, 48, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(429, 48, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(430, 48, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(431, 48, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(432, 49, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(433, 49, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(434, 49, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(435, 49, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(436, 49, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(437, 49, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(438, 49, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(439, 49, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(440, 49, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(441, 49, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(442, 49, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(443, 49, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(444, 49, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(445, 49, 50, 19, 0, 'Mangalore', 0, 1526581800, 1526628327, 1, 0, 1),
(446, 50, 36, 19, 0, 'MUTTOM', 0, 1526581800, 1526628327, 1, 0, 1),
(447, 50, 37, 19, 0, 'COLACHEL', 0, 1526581800, 1526628327, 1, 0, 1),
(448, 50, 38, 19, 0, 'ENAYAM', 0, 1526581800, 1526628327, 1, 0, 1),
(449, 50, 39, 19, 0, 'VALLAVILA', 0, 1526581800, 1526628327, 1, 0, 1),
(450, 50, 40, 19, 0, 'Koottappully', 0, 1526581800, 1526628327, 1, 0, 1),
(451, 50, 41, 19, 0, 'Chinnakottakuppam', 0, 1526581800, 1526628327, 1, 0, 1),
(452, 50, 42, 19, 0, 'Anjengo', 0, 1526581800, 1526628327, 1, 0, 1),
(453, 50, 43, 19, 0, 'Marianad', 0, 1526581800, 1526628327, 1, 0, 1),
(454, 50, 0, 19, 0, 'CENTRAL STORE', 0, 1526581800, 1526628327, 1, 0, 1),
(455, 50, 45, 19, 0, 'Vizhinjam', 0, 1526581800, 1526628327, 1, 0, 1),
(456, 50, 46, 19, 0, 'POOVAR', 0, 1526581800, 1526628327, 1, 0, 1),
(457, 50, 47, 19, 0, 'Neendakara', 0, 1526581800, 1526628327, 1, 0, 1),
(458, 50, 48, 19, 0, 'KOLLAM', 0, 1526581800, 1526628327, 1, 0, 1),
(459, 50, 49, 19, 0, 'Ambalappuzha', 0, 1526581800, 1526628327, 1, 0, 1),
(460, 0, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(461, 0, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(462, 0, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(463, 0, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(464, 0, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(465, 0, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(466, 0, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(467, 0, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(468, 0, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(469, 0, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(470, 0, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(471, 0, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(472, 0, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(473, 0, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(474, 36, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(475, 36, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(476, 36, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(477, 36, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(478, 36, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(479, 36, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(480, 36, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(481, 36, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(482, 36, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(483, 36, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(484, 36, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(485, 36, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(486, 36, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(487, 36, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(488, 37, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(489, 37, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(490, 37, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(491, 37, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(492, 37, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(493, 37, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(494, 37, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(495, 37, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(496, 37, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(497, 37, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(498, 37, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(499, 37, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(500, 37, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(501, 37, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(502, 38, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(503, 38, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(504, 38, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(505, 38, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(506, 38, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(507, 38, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(508, 38, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(509, 38, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(510, 38, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(511, 38, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(512, 38, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(513, 38, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(514, 38, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(515, 38, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(516, 39, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(517, 39, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(518, 39, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(519, 39, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(520, 39, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(521, 39, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(522, 39, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(523, 39, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(524, 39, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(525, 39, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(526, 39, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(527, 39, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(528, 39, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(529, 39, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(530, 40, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(531, 40, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(532, 40, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(533, 40, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(534, 40, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(535, 40, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(536, 40, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(537, 40, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(538, 40, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(539, 40, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(540, 40, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(541, 40, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(542, 40, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(543, 40, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(544, 41, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(545, 41, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(546, 41, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(547, 41, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(548, 41, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(549, 41, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(550, 41, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(551, 41, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(552, 41, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(553, 41, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(554, 41, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(555, 41, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(556, 41, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(557, 41, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(558, 42, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(559, 42, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(560, 42, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(561, 42, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(562, 42, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(563, 42, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(564, 42, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(565, 42, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(566, 42, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(567, 42, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(568, 42, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(569, 42, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(570, 42, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(571, 42, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(572, 43, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(573, 43, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(574, 43, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(575, 43, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(576, 43, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(577, 43, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(578, 43, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(579, 43, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(580, 43, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(581, 43, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(582, 43, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(583, 43, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(584, 43, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(585, 43, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(586, 45, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(587, 45, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(588, 45, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(589, 45, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(590, 45, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(591, 45, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(592, 45, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(593, 45, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(594, 45, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(595, 45, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(596, 45, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(597, 45, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(598, 45, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(599, 45, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(600, 46, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(601, 46, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(602, 46, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(603, 46, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(604, 46, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(605, 46, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(606, 46, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(607, 46, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(608, 46, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(609, 46, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(610, 46, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(611, 46, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(612, 46, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(613, 46, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(614, 47, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(615, 47, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(616, 47, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(617, 47, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(618, 47, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(619, 47, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(620, 47, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(621, 47, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(622, 47, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(623, 47, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(624, 47, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(625, 47, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(626, 47, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(627, 47, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(628, 48, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(629, 48, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(630, 48, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(631, 48, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(632, 48, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(633, 48, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(634, 48, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(635, 48, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(636, 48, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(637, 48, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(638, 48, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(639, 48, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(640, 48, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(641, 48, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(642, 49, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(643, 49, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(644, 49, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(645, 49, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(646, 49, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(647, 49, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(648, 49, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(649, 49, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(650, 49, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(651, 49, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(652, 49, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(653, 49, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(654, 49, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(655, 49, 50, 20, 0, 'Mangalore  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(656, 50, 36, 20, 0, 'MUTTOM GST', 0, 1526581800, 1526628327, 1, 0, 1),
(657, 50, 37, 20, 0, 'COLACHEL GST', 0, 1526581800, 1526628327, 1, 0, 1),
(658, 50, 38, 20, 0, 'ENAYAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(659, 50, 39, 20, 0, 'VALLAVILA GST', 0, 1526581800, 1526628327, 1, 0, 1),
(660, 50, 40, 20, 0, 'Koottappully GST', 0, 1526581800, 1526628327, 1, 0, 1),
(661, 50, 41, 20, 0, 'Chinnakottakuppam GST', 0, 1526581800, 1526628327, 1, 0, 1),
(662, 50, 42, 20, 0, 'Anjengo  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(663, 50, 43, 20, 0, 'Marianad GST', 0, 1526581800, 1526628327, 1, 0, 1),
(664, 50, 0, 20, 0, 'CENTRAL STORE  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(665, 50, 45, 20, 0, 'Vizhinjam  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(666, 50, 46, 20, 0, 'POOVAR  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(667, 50, 47, 20, 0, 'Neendakara  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(668, 50, 48, 20, 0, 'KOLLAM  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(669, 50, 49, 20, 0, 'Ambalappuzha  GST', 0, 1526581800, 1526628327, 1, 0, 1),
(752, 36, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(754, 41, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(756, 49, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(758, 50, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(760, 37, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(762, 40, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(764, 0, 32, 16, 0, 'Jojos Marketing', 0, 0, 0, 1, 0, 1),
(671, 43, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(673, 42, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(675, 47, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(677, 39, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(679, 45, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(681, 46, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(683, 38, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(685, 44, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(687, 48, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(689, 36, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(691, 41, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(693, 49, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(695, 50, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(697, 37, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(699, 40, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(701, 0, 31, 17, 0, 'SUZUKI MOTOR CORPORATION-GST', 0, 0, 0, 1, 0, 1),
(703, 43, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(705, 42, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(707, 47, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(709, 39, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(711, 45, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(713, 46, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(715, 38, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(717, 44, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(719, 48, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(721, 36, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(723, 41, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(725, 49, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(727, 50, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(729, 37, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(731, 40, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(733, 0, 33, 17, 0, 'UNITEDDISTRIBUTORS-GST', 0, 0, 0, 1, 0, 1),
(735, 43, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(737, 42, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(739, 47, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(741, 39, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(743, 45, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(745, 46, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(747, 38, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(749, 44, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(751, 48, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(753, 36, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(755, 41, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(757, 49, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(759, 50, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(761, 37, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(763, 40, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1),
(765, 0, 32, 17, 0, 'Jojos Marketing-GST', 0, 0, 0, 1, 0, 1);

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

--
-- Table structure for table `reports`
--

CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `report_name` varchar(250) NOT NULL,
  `order_id` int(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `reports`
--

INSERT INTO `reports` (`id`, `report_name`, `order_id`) VALUES
(1, 'Receipt', 1),
(2, 'Payment', 2),
(3, 'Journal', 3),
(4, 'Contra', 4),
(10, 'Day Book', 7);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `transaction_id` int(250) NOT NULL AUTO_INCREMENT,
  `voucher_id` double NOT NULL,
  `ledger_id` int(250) NOT NULL,
  `debit_amount` decimal(10,0) NOT NULL,
  `credit_amount` decimal(10,0) NOT NULL,
  `opening_balance` int(250) NOT NULL DEFAULT '0',
  `cheque_no` int(250) NOT NULL,
  `cheque_date` int(250) NOT NULL,
  `bank_date` int(250) NOT NULL,
  `bank_status` int(11) NOT NULL DEFAULT '0',
  `transaction_date` int(250) NOT NULL,
  `transaction_time` int(11) NOT NULL,
  `transaction_status` int(250) NOT NULL DEFAULT '1',
  `addmoreid` int(2) NOT NULL DEFAULT '1',
  `hide_status` int(250) NOT NULL DEFAULT '0',
  PRIMARY KEY (`transaction_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=264 ;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`transaction_id`, `voucher_id`, `ledger_id`, `debit_amount`, `credit_amount`, `opening_balance`, `cheque_no`, `cheque_date`, `bank_date`, `bank_status`, `transaction_date`, `transaction_time`, `transaction_status`, `addmoreid`, `hide_status`) VALUES
(1, 157, 95, 7975, 0, 0, 0, 0, 0, 0, 1524421800, 1527157566, 1, 1, 0),
(2, 157, 96, 0, 6497, 0, 0, 0, 0, 0, 1524421800, 1527157566, 1, 1, 0),
(3, 157, 206, 0, 1479, 0, 0, 0, 0, 0, 1524421800, 1527157566, 1, 2, 0),
(4, 158, 95, 1177, 0, 0, 0, 0, 0, 0, 1524508200, 1527158146, 1, 1, 0),
(5, 158, 96, 0, 954, 0, 0, 0, 0, 0, 1524508200, 1527158146, 1, 1, 0),
(6, 158, 206, 0, 223, 0, 0, 0, 0, 0, 1524508200, 1527158146, 1, 2, 0),
(7, 159, 95, 7599, 0, 0, 0, 0, 0, 0, 1524508200, 1527158292, 1, 1, 0),
(8, 159, 96, 0, 6440, 0, 0, 0, 0, 0, 1524508200, 1527158292, 1, 1, 0),
(9, 159, 206, 0, 1159, 0, 0, 0, 0, 0, 1524508200, 1527158292, 1, 2, 0),
(10, 160, 95, 2685, 0, 0, 0, 0, 0, 0, 1524594600, 1527159044, 1, 1, 0),
(11, 160, 96, 0, 2215, 0, 0, 0, 0, 0, 1524594600, 1527159044, 1, 1, 0),
(12, 160, 206, 0, 470, 0, 0, 0, 0, 0, 1524594600, 1527159044, 1, 2, 0),
(13, 161, 95, 7552, 0, 0, 0, 0, 0, 0, 1524681000, 1527159345, 1, 1, 0),
(14, 161, 96, 0, 5900, 0, 0, 0, 0, 0, 1524681000, 1527159345, 1, 1, 0),
(15, 161, 206, 0, 1652, 0, 0, 0, 0, 0, 1524681000, 1527159345, 1, 2, 0),
(16, 162, 95, 7833, 0, 0, 0, 0, 0, 0, 1524767400, 1527159761, 1, 1, 0),
(17, 162, 96, 0, 6198, 0, 0, 0, 0, 0, 1524767400, 1527159761, 1, 1, 0),
(18, 162, 206, 0, 1635, 0, 0, 0, 0, 0, 1524767400, 1527159761, 1, 2, 0),
(19, 163, 95, 4120, 0, 0, 0, 0, 0, 0, 1524853800, 1527160525, 1, 1, 0),
(20, 163, 96, 0, 3336, 0, 0, 0, 0, 0, 1524853800, 1527160525, 1, 1, 0),
(21, 163, 206, 0, 784, 0, 0, 0, 0, 0, 1524853800, 1527160525, 1, 2, 0),
(22, 164, 95, 7599, 0, 0, 0, 0, 0, 0, 1525026600, 1527160723, 1, 1, 0),
(23, 164, 96, 0, 6440, 0, 0, 0, 0, 0, 1525026600, 1527160723, 1, 1, 0),
(24, 164, 206, 0, 1159, 0, 0, 0, 0, 0, 1525026600, 1527160723, 1, 2, 0),
(25, 165, 107, 1145, 0, 0, 0, 0, 0, 0, 1527100200, 1527168185, 1, 1, 0),
(26, 165, 108, 0, 910, 0, 0, 0, 0, 0, 1527100200, 1527168185, 1, 1, 0),
(27, 165, 209, 0, 235, 0, 0, 0, 0, 0, 1527100200, 1527168185, 1, 2, 0),
(28, 166, 107, 571, 0, 0, 0, 0, 0, 0, 1527100200, 1527168441, 1, 1, 0),
(29, 166, 108, 0, 481, 0, 0, 0, 0, 0, 1527100200, 1527168441, 1, 1, 0),
(30, 166, 209, 0, 90, 0, 0, 0, 0, 0, 1527100200, 1527168441, 1, 2, 0),
(31, 167, 107, 1810, 0, 0, 0, 0, 0, 0, 1527100200, 1527169085, 1, 1, 0),
(32, 167, 108, 0, 1414, 0, 0, 0, 0, 0, 1527100200, 1527169085, 1, 1, 0),
(33, 167, 209, 0, 396, 0, 0, 0, 0, 0, 1527100200, 1527169085, 1, 2, 0),
(34, 168, 454, 140506, 0, 0, 0, 0, 0, 0, 1527100200, 1527171876, 1, 1, 0),
(35, 168, 664, 39015, 0, 0, 0, 0, 0, 0, 1527100200, 1527171876, 1, 2, 0),
(36, 168, 127, 0, 179521, 0, 0, 0, 0, 0, 1527100200, 1527171876, 1, 1, 0),
(37, 169, 68, 179521, 0, 0, 0, 0, 0, 0, 1527100200, 1527171876, 1, 1, 0),
(38, 169, 66, 0, 140506, 0, 0, 0, 0, 0, 1527100200, 1527171876, 1, 1, 0),
(39, 169, 199, 0, 39015, 0, 0, 0, 0, 0, 1527100200, 1527171876, 1, 2, 0),
(40, 170, 107, 118, 0, 0, 0, 0, 0, 0, 1527186600, 1527222254, 1, 1, 0),
(41, 170, 108, 0, 100, 0, 0, 0, 0, 0, 1527186600, 1527222254, 1, 1, 0),
(42, 170, 209, 0, 18, 0, 0, 0, 0, 0, 1527186600, 1527222254, 1, 2, 0),
(43, 171, 68, 13499, 0, 0, 0, 0, 0, 0, 1527186600, 1527226472, 1, 1, 0),
(44, 171, 66, 0, 11522, 0, 0, 0, 0, 0, 1527186600, 1527226472, 1, 1, 0),
(45, 171, 199, 0, 1978, 0, 0, 0, 0, 0, 1527186600, 1527226472, 1, 2, 0),
(46, 172, 75, 3318, 0, 0, 0, 0, 0, 0, 1522953000, 1527227691, 1, 1, 0),
(47, 172, 76, 0, 2592, 0, 0, 0, 0, 0, 1522953000, 1527227691, 1, 1, 0),
(48, 172, 201, 0, 726, 0, 0, 0, 0, 0, 1522953000, 1527227691, 1, 2, 0),
(49, 173, 75, 3748, 0, 0, 0, 0, 0, 0, 1522953000, 1527228462, 1, 1, 0),
(50, 173, 76, 0, 3051, 0, 0, 0, 0, 0, 1522953000, 1527228462, 1, 1, 0),
(51, 173, 201, 0, 697, 0, 0, 0, 0, 0, 1522953000, 1527228462, 1, 2, 0),
(52, 174, 75, 9105, 0, 0, 0, 0, 0, 0, 1523039400, 1527229196, 1, 1, 0),
(53, 174, 76, 0, 7144, 0, 0, 0, 0, 0, 1523039400, 1527229196, 1, 1, 0),
(54, 174, 201, 0, 1961, 0, 0, 0, 0, 0, 1523039400, 1527229196, 1, 2, 0),
(55, 175, 75, 5994, 0, 0, 0, 0, 0, 0, 1523212200, 1527229339, 1, 1, 0),
(56, 175, 76, 0, 5080, 0, 0, 0, 0, 0, 1523212200, 1527229339, 1, 1, 0),
(57, 175, 201, 0, 914, 0, 0, 0, 0, 0, 1523212200, 1527229339, 1, 2, 0),
(58, 176, 75, 6260, 0, 0, 0, 0, 0, 0, 1523298600, 1527229701, 1, 1, 0),
(59, 176, 76, 0, 4973, 0, 0, 0, 0, 0, 1523298600, 1527229701, 1, 1, 0),
(60, 176, 201, 0, 1287, 0, 0, 0, 0, 0, 1523298600, 1527229701, 1, 2, 0),
(61, 177, 75, 25344, 0, 0, 0, 0, 0, 0, 1523557800, 1527229870, 1, 1, 0),
(62, 177, 76, 0, 19800, 0, 0, 0, 0, 0, 1523557800, 1527229870, 1, 1, 0),
(63, 177, 201, 0, 5544, 0, 0, 0, 0, 0, 1523557800, 1527229870, 1, 2, 0),
(64, 178, 75, 6345, 0, 0, 0, 0, 0, 0, 1523298600, 1527230539, 1, 1, 0),
(65, 178, 76, 0, 5020, 0, 0, 0, 0, 0, 1523298600, 1527230539, 1, 1, 0),
(66, 178, 201, 0, 1325, 0, 0, 0, 0, 0, 1523298600, 1527230539, 1, 2, 0),
(67, 179, 75, 5043, 0, 0, 0, 0, 0, 0, 1523989800, 1527230957, 1, 1, 0),
(68, 179, 76, 0, 3981, 0, 0, 0, 0, 0, 1523989800, 1527230957, 1, 1, 0),
(69, 179, 201, 0, 1062, 0, 0, 0, 0, 0, 1523989800, 1527230957, 1, 2, 0),
(70, 180, 75, 3411, 0, 0, 0, 0, 0, 0, 1524421800, 1527231752, 1, 1, 0),
(71, 180, 76, 0, 2849, 0, 0, 0, 0, 0, 1524421800, 1527231752, 1, 1, 0),
(72, 180, 201, 0, 563, 0, 0, 0, 0, 0, 1524421800, 1527231752, 1, 2, 0),
(73, 181, 75, 2670, 0, 0, 0, 0, 0, 0, 1524853800, 1527232104, 1, 1, 0),
(74, 181, 76, 0, 2225, 0, 0, 0, 0, 0, 1524853800, 1527232104, 1, 1, 0),
(75, 181, 201, 0, 445, 0, 0, 0, 0, 0, 1524853800, 1527232104, 1, 2, 0),
(76, 182, 454, 4317, 0, 0, 0, 0, 0, 0, 1527186600, 1527233259, 1, 1, 0),
(77, 182, 664, 1154, 0, 0, 0, 0, 0, 0, 1527186600, 1527233259, 1, 2, 0),
(78, 182, 127, 0, 5471, 0, 0, 0, 0, 0, 1527186600, 1527233259, 1, 1, 0),
(79, 183, 68, 5471, 0, 0, 0, 0, 0, 0, 1527186600, 1527233259, 1, 1, 0),
(80, 183, 66, 0, 4317, 0, 0, 0, 0, 0, 1527186600, 1527233259, 1, 1, 0),
(81, 183, 199, 0, 1154, 0, 0, 0, 0, 0, 1527186600, 1527233259, 1, 2, 0),
(82, 184, 71, 10306, 0, 0, 0, 0, 0, 0, 1522953000, 1527233660, 1, 1, 0),
(83, 184, 72, 0, 8113, 0, 0, 0, 0, 0, 1522953000, 1527233660, 1, 1, 0),
(84, 184, 200, 0, 2193, 0, 0, 0, 0, 0, 1522953000, 1527233660, 1, 2, 0),
(85, 185, 71, 1938, 0, 0, 0, 0, 0, 0, 1523298600, 1527233926, 1, 1, 0),
(86, 185, 72, 0, 1576, 0, 0, 0, 0, 0, 1523298600, 1527233926, 1, 1, 0),
(87, 185, 200, 0, 362, 0, 0, 0, 0, 0, 1523298600, 1527233926, 1, 2, 0),
(88, 186, 71, 2439, 0, 0, 0, 0, 0, 0, 1523471400, 1527235243, 1, 1, 0),
(89, 186, 72, 0, 1947, 0, 0, 0, 0, 0, 1523471400, 1527235243, 1, 1, 0),
(90, 186, 200, 0, 492, 0, 0, 0, 0, 0, 1523471400, 1527235243, 1, 2, 0),
(91, 187, 426, 3934, 0, 0, 0, 0, 0, 0, 1527186600, 1527237997, 1, 1, 0),
(92, 187, 119, 0, 3934, 0, 0, 0, 0, 0, 1527186600, 1527237997, 1, 1, 0),
(93, 188, 68, 3934, 0, 0, 0, 0, 0, 0, 1527186600, 1527237997, 1, 1, 0),
(94, 188, 66, 0, 3934, 0, 0, 0, 0, 0, 1527186600, 1527237997, 1, 1, 0),
(95, 189, 71, 3581, 0, 0, 0, 0, 0, 0, 1523644200, 1527239089, 1, 1, 0),
(96, 189, 72, 0, 2859, 0, 0, 0, 0, 0, 1523644200, 1527239089, 1, 1, 0),
(97, 189, 200, 0, 722, 0, 0, 0, 0, 0, 1523644200, 1527239089, 1, 2, 0),
(98, 190, 71, 6806, 0, 0, 0, 0, 0, 0, 1523903400, 1527240170, 1, 1, 0),
(99, 190, 72, 0, 5432, 0, 0, 0, 0, 0, 1523903400, 1527240170, 1, 1, 0),
(100, 190, 200, 0, 1374, 0, 0, 0, 0, 0, 1523903400, 1527240170, 1, 2, 0),
(101, 191, 107, 12329, 0, 0, 0, 0, 0, 0, 1527186600, 1527241180, 1, 1, 0),
(102, 191, 108, 0, 9671, 0, 0, 0, 0, 0, 1527186600, 1527241180, 1, 1, 0),
(103, 191, 209, 0, 2658, 0, 0, 0, 0, 0, 1527186600, 1527241180, 1, 2, 0),
(104, 192, 107, 1910, 0, 0, 0, 0, 0, 0, 1527186600, 1527242813, 1, 1, 0),
(105, 192, 108, 0, 1616, 0, 0, 0, 0, 0, 1527186600, 1527242813, 1, 1, 0),
(106, 192, 209, 0, 294, 0, 0, 0, 0, 0, 1527186600, 1527242813, 1, 2, 0),
(107, 193, 107, 957, 0, 0, 0, 0, 0, 0, 1527186600, 1527243178, 1, 1, 0),
(108, 193, 108, 0, 771, 0, 0, 0, 0, 0, 1527186600, 1527243178, 1, 1, 0),
(109, 193, 209, 0, 186, 0, 0, 0, 0, 0, 1527186600, 1527243178, 1, 2, 0),
(110, 194, 71, 3427, 0, 0, 0, 0, 0, 0, 1524076200, 1527244352, 1, 1, 0),
(111, 194, 72, 0, 2741, 0, 0, 0, 0, 0, 1524076200, 1527244352, 1, 1, 0),
(112, 194, 200, 0, 686, 0, 0, 0, 0, 0, 1524076200, 1527244352, 1, 2, 0),
(113, 195, 71, 1755, 0, 0, 0, 0, 0, 0, 1524249000, 1527244833, 1, 1, 0),
(114, 195, 72, 0, 1410, 0, 0, 0, 0, 0, 1524249000, 1527244833, 1, 1, 0),
(115, 195, 200, 0, 345, 0, 0, 0, 0, 0, 1524249000, 1527244833, 1, 2, 0),
(116, 196, 71, 2751, 0, 0, 0, 0, 0, 0, 1524508200, 1527245331, 1, 1, 0),
(117, 196, 72, 0, 2188, 0, 0, 0, 0, 0, 1524508200, 1527245331, 1, 1, 0),
(118, 196, 200, 0, 563, 0, 0, 0, 0, 0, 1524508200, 1527245331, 1, 2, 0),
(119, 197, 71, 2441, 0, 0, 0, 0, 0, 0, 1524594600, 1527245558, 1, 1, 0),
(120, 197, 72, 0, 1979, 0, 0, 0, 0, 0, 1524594600, 1527245558, 1, 1, 0),
(121, 197, 200, 0, 462, 0, 0, 0, 0, 0, 1524594600, 1527245558, 1, 2, 0),
(122, 198, 354, 4363, 0, 0, 0, 0, 0, 0, 1527186600, 1527245624, 1, 1, 0),
(123, 198, 95, 0, 4363, 0, 0, 0, 0, 0, 1527186600, 1527245624, 1, 1, 0),
(124, 199, 68, 4363, 0, 0, 0, 0, 0, 0, 1527186600, 1527245624, 1, 1, 0),
(125, 199, 66, 0, 4363, 0, 0, 0, 0, 0, 1527186600, 1527245624, 1, 1, 0),
(126, 200, 71, 2064, 0, 0, 0, 0, 0, 0, 1524681000, 1527245872, 1, 1, 0),
(127, 200, 72, 0, 1652, 0, 0, 0, 0, 0, 1524681000, 1527245872, 1, 1, 0),
(128, 200, 200, 0, 412, 0, 0, 0, 0, 0, 1524681000, 1527245872, 1, 2, 0),
(129, 201, 71, 3991, 0, 0, 0, 0, 0, 0, 1524767400, 1527246076, 1, 1, 0),
(130, 201, 72, 0, 3138, 0, 0, 0, 0, 0, 1524767400, 1527246076, 1, 1, 0),
(131, 201, 200, 0, 854, 0, 0, 0, 0, 0, 1524767400, 1527246076, 1, 2, 0),
(132, 202, 71, 16756, 0, 0, 0, 0, 0, 0, 1524853800, 1527246169, 1, 1, 0),
(133, 202, 72, 0, 14200, 0, 0, 0, 0, 0, 1524853800, 1527246169, 1, 1, 0),
(134, 202, 200, 0, 2556, 0, 0, 0, 0, 0, 1524853800, 1527246169, 1, 2, 0),
(135, 203, 107, 909, 0, 0, 0, 0, 0, 0, 1527186600, 1527251466, 1, 1, 0),
(136, 203, 108, 0, 710, 0, 0, 0, 0, 0, 1527186600, 1527251466, 1, 1, 0),
(137, 203, 209, 0, 199, 0, 0, 0, 0, 0, 1527186600, 1527251466, 1, 2, 0),
(138, 204, 68, 1888, 0, 0, 0, 0, 0, 0, 1527273000, 1527320379, 1, 1, 0),
(139, 204, 66, 0, 1475, 0, 0, 0, 0, 0, 1527273000, 1527320379, 1, 1, 0),
(140, 204, 199, 0, 413, 0, 0, 0, 0, 0, 1527273000, 1527320379, 1, 2, 0),
(141, 205, 123, 8250, 0, 0, 0, 0, 0, 0, 1527273000, 1527320421, 1, 1, 0),
(142, 205, 124, 0, 6649, 0, 0, 0, 0, 0, 1527273000, 1527320421, 1, 1, 0),
(143, 205, 213, 0, 1601, 0, 0, 0, 0, 0, 1527273000, 1527320421, 1, 2, 0),
(144, 206, 123, 5531, 0, 0, 0, 0, 0, 0, 1524249000, 1527323799, 1, 1, 0),
(145, 206, 124, 0, 4396, 0, 0, 0, 0, 0, 1524249000, 1527323799, 1, 1, 0),
(146, 206, 213, 0, 1135, 0, 0, 0, 0, 0, 1524249000, 1527323799, 1, 2, 0),
(147, 207, 123, 1550, 0, 0, 0, 0, 0, 0, 1527273000, 1527324656, 1, 1, 0),
(148, 207, 124, 0, 1271, 0, 0, 0, 0, 0, 1527273000, 1527324656, 1, 1, 0),
(149, 207, 213, 0, 279, 0, 0, 0, 0, 0, 1527273000, 1527324656, 1, 2, 0),
(150, 208, 700, 226490, 0, 0, 0, 0, 0, 0, 1523557800, 1527325018, 1, 1, 0),
(151, 208, 701, 0, 0, 0, 0, 0, 0, 0, 1523557800, 1527325018, 1, 2, 0),
(152, 208, 68, 0, 226490, 0, 0, 0, 0, 0, 1523557800, 1527325018, 1, 1, 0),
(153, 209, 123, 2200, 0, 0, 0, 0, 0, 0, 1524421800, 1527325230, 1, 1, 0),
(154, 209, 124, 0, 1736, 0, 0, 0, 0, 0, 1524421800, 1527325230, 1, 1, 0),
(155, 209, 213, 0, 464, 0, 0, 0, 0, 0, 1524421800, 1527325230, 1, 2, 0),
(156, 210, 123, 2998, 0, 0, 0, 0, 0, 0, 1524508200, 1527327232, 1, 1, 0),
(157, 210, 124, 0, 2396, 0, 0, 0, 0, 0, 1524508200, 1527327232, 1, 1, 0),
(158, 210, 213, 0, 602, 0, 0, 0, 0, 0, 1524508200, 1527327232, 1, 2, 0),
(159, 211, 123, 3600, 0, 0, 0, 0, 0, 0, 1524594600, 1527327836, 1, 1, 0),
(160, 211, 124, 0, 2846, 0, 0, 0, 0, 0, 1524594600, 1527327836, 1, 1, 0),
(161, 211, 213, 0, 754, 0, 0, 0, 0, 0, 1524594600, 1527327836, 1, 2, 0),
(162, 212, 123, 1500, 0, 0, 0, 0, 0, 0, 1524594600, 1527328072, 1, 1, 0),
(163, 212, 124, 0, 1178, 0, 0, 0, 0, 0, 1524594600, 1527328072, 1, 1, 0),
(164, 212, 213, 0, 322, 0, 0, 0, 0, 0, 1524594600, 1527328072, 1, 2, 0),
(165, 213, 440, 1247, 0, 0, 0, 0, 0, 0, 1527273000, 1527328132, 1, 1, 0),
(166, 213, 123, 0, 1247, 0, 0, 0, 0, 0, 1527273000, 1527328132, 1, 1, 0),
(167, 214, 68, 1247, 0, 0, 0, 0, 0, 0, 1527273000, 1527328132, 1, 1, 0),
(168, 214, 66, 0, 1247, 0, 0, 0, 0, 0, 1527273000, 1527328132, 1, 1, 0),
(169, 215, 123, 8190, 0, 0, 0, 0, 0, 0, 1524681000, 1527329780, 1, 1, 0),
(170, 215, 124, 0, 6517, 0, 0, 0, 0, 0, 1524681000, 1527329780, 1, 1, 0),
(171, 215, 213, 0, 1673, 0, 0, 0, 0, 0, 1524681000, 1527329780, 1, 2, 0),
(172, 216, 312, 620, 0, 0, 0, 0, 0, 0, 1527273000, 1527330610, 1, 1, 0),
(173, 216, 523, 174, 0, 0, 0, 0, 0, 0, 1527273000, 1527330610, 1, 2, 0),
(174, 216, 83, 0, 794, 0, 0, 0, 0, 0, 1527273000, 1527330610, 1, 1, 0),
(175, 217, 68, 794, 0, 0, 0, 0, 0, 0, 1527273000, 1527330610, 1, 1, 0),
(176, 217, 66, 0, 620, 0, 0, 0, 0, 0, 1527273000, 1527330610, 1, 1, 0),
(177, 217, 199, 0, 174, 0, 0, 0, 0, 0, 1527273000, 1527330610, 1, 2, 0),
(178, 218, 123, 2570, 0, 0, 0, 0, 0, 0, 1524681000, 1527332118, 1, 1, 0),
(179, 218, 124, 0, 2055, 0, 0, 0, 0, 0, 1524681000, 1527332118, 1, 1, 0),
(180, 218, 213, 0, 515, 0, 0, 0, 0, 0, 1524681000, 1527332118, 1, 2, 0),
(181, 219, 123, 574, 0, 0, 0, 0, 0, 0, 1524681000, 1527332502, 1, 1, 0),
(182, 219, 124, 0, 460, 0, 0, 0, 0, 0, 1524681000, 1527332502, 1, 1, 0),
(183, 219, 213, 0, 114, 0, 0, 0, 0, 0, 1524681000, 1527332502, 1, 2, 0),
(184, 220, 68, 826, 0, 0, 0, 0, 0, 0, 1527445800, 1527492515, 1, 1, 0),
(185, 220, 66, 0, 646, 0, 0, 0, 0, 0, 1527445800, 1527492515, 1, 1, 0),
(186, 220, 199, 0, 180, 0, 0, 0, 0, 0, 1527445800, 1527492515, 1, 2, 0),
(187, 221, 68, 183, 0, 0, 0, 0, 0, 0, 1527445800, 1527493065, 1, 1, 0),
(188, 221, 66, 0, 144, 0, 0, 0, 0, 0, 1527445800, 1527493065, 1, 1, 0),
(189, 221, 199, 0, 39, 0, 0, 0, 0, 0, 1527445800, 1527493065, 1, 2, 0),
(190, 222, 99, 3371, 0, 0, 0, 0, 0, 0, 1525199400, 1527493613, 1, 1, 0),
(191, 222, 100, 0, 2800, 0, 0, 0, 0, 0, 1525199400, 1527493613, 1, 1, 0),
(192, 222, 207, 0, 571, 0, 0, 0, 0, 0, 1525199400, 1527493613, 1, 2, 0),
(193, 223, 99, 2620, 0, 0, 0, 0, 0, 0, 1527445800, 1527493871, 1, 1, 0),
(194, 223, 100, 0, 2220, 0, 0, 0, 0, 0, 1527445800, 1527493871, 1, 1, 0),
(195, 223, 207, 0, 400, 0, 0, 0, 0, 0, 1527445800, 1527493871, 1, 2, 0),
(196, 224, 99, 118, 0, 0, 0, 0, 0, 0, 1525199400, 1527493975, 1, 1, 0),
(197, 224, 100, 0, 100, 0, 0, 0, 0, 0, 1525199400, 1527493975, 1, 1, 0),
(198, 224, 207, 0, 18, 0, 0, 0, 0, 0, 1525199400, 1527493975, 1, 2, 0),
(199, 225, 0, 28350, 0, 0, 0, 0, 0, 0, 1523989800, 1527494036, 1, 1, 0),
(200, 225, 0, 7938, 0, 0, 0, 0, 0, 0, 1523989800, 1527494036, 1, 2, 0),
(201, 225, 68, 0, 36288, 0, 0, 0, 0, 0, 1523989800, 1527494036, 1, 1, 0),
(202, 226, 99, 236, 0, 0, 0, 0, 0, 0, 1525285800, 1527494166, 1, 1, 0),
(203, 226, 100, 0, 200, 0, 0, 0, 0, 0, 1525285800, 1527494166, 1, 1, 0),
(204, 226, 207, 0, 36, 0, 0, 0, 0, 0, 1525285800, 1527494166, 1, 2, 0),
(205, 227, 99, 354, 0, 0, 0, 0, 0, 0, 1525285800, 1527494332, 1, 1, 0),
(206, 227, 100, 0, 300, 0, 0, 0, 0, 0, 1525285800, 1527494332, 1, 1, 0),
(207, 227, 207, 0, 54, 0, 0, 0, 0, 0, 1525285800, 1527494332, 1, 2, 0),
(208, 228, 99, 781, 0, 0, 0, 0, 0, 0, 1525285800, 1527494538, 1, 1, 0),
(209, 228, 100, 0, 622, 0, 0, 0, 0, 0, 1525285800, 1527494538, 1, 1, 0),
(210, 228, 207, 0, 159, 0, 0, 0, 0, 0, 1525285800, 1527494538, 1, 2, 0),
(211, 229, 95, 3600, 0, 0, 0, 0, 0, 0, 1525199400, 1527502221, 1, 1, 0),
(212, 229, 96, 0, 2841, 0, 0, 0, 0, 0, 1525199400, 1527502221, 1, 1, 0),
(213, 229, 206, 0, 759, 0, 0, 0, 0, 0, 1525199400, 1527502221, 1, 2, 0),
(214, 230, 368, 1931, 0, 0, 0, 0, 0, 0, 1527445800, 1527504602, 1, 1, 0),
(215, 230, 99, 0, 1931, 0, 0, 0, 0, 0, 1527445800, 1527504602, 1, 1, 0),
(216, 231, 68, 1931, 0, 0, 0, 0, 0, 0, 1527445800, 1527504602, 1, 1, 0),
(217, 231, 66, 0, 1931, 0, 0, 0, 0, 0, 1527445800, 1527504602, 1, 1, 0),
(218, 232, 298, 42564, 0, 0, 0, 0, 0, 0, 1527445800, 1527509432, 1, 1, 0),
(219, 232, 509, 11889, 0, 0, 0, 0, 0, 0, 1527445800, 1527509432, 1, 2, 0),
(220, 232, 79, 0, 54453, 0, 0, 0, 0, 0, 1527445800, 1527509432, 1, 1, 0),
(221, 233, 68, 54453, 0, 0, 0, 0, 0, 0, 1527445800, 1527509432, 1, 1, 0),
(222, 233, 66, 0, 42564, 0, 0, 0, 0, 0, 1527445800, 1527509432, 1, 1, 0),
(223, 233, 199, 0, 11889, 0, 0, 0, 0, 0, 1527445800, 1527509432, 1, 2, 0),
(224, 234, 368, 7668, 0, 0, 0, 0, 0, 0, 1527532200, 1527579444, 1, 1, 0),
(225, 234, 99, 0, 7668, 0, 0, 0, 0, 0, 1527532200, 1527579444, 1, 1, 0),
(226, 235, 68, 7668, 0, 0, 0, 0, 0, 0, 1527532200, 1527579444, 1, 1, 0),
(227, 235, 66, 0, 7668, 0, 0, 0, 0, 0, 1527532200, 1527579444, 1, 1, 0),
(228, 236, 115, 1480, 0, 0, 0, 0, 0, 0, 1525199400, 1527580493, 1, 1, 0),
(229, 236, 116, 0, 1156, 0, 0, 0, 0, 0, 1525199400, 1527580493, 1, 1, 0),
(230, 236, 211, 0, 324, 0, 0, 0, 0, 0, 1525199400, 1527580493, 1, 2, 0),
(231, 237, 115, 18471, 0, 0, 0, 0, 0, 0, 1525199400, 1527581647, 1, 1, 0),
(232, 237, 116, 0, 14479, 0, 0, 0, 0, 0, 1525199400, 1527581647, 1, 1, 0),
(233, 237, 211, 0, 3993, 0, 0, 0, 0, 0, 1525199400, 1527581647, 1, 2, 0),
(234, 238, 115, 3347, 0, 0, 0, 0, 0, 0, 1525285800, 1527584077, 1, 1, 0),
(235, 238, 116, 0, 2777, 0, 0, 0, 0, 0, 1525285800, 1527584077, 1, 1, 0),
(236, 238, 211, 0, 570, 0, 0, 0, 0, 0, 1525285800, 1527584077, 1, 2, 0),
(237, 239, 68, 23600, 0, 0, 0, 0, 0, 0, 1527532200, 1527592254, 1, 1, 0),
(238, 239, 66, 0, 20000, 0, 0, 0, 0, 0, 1527532200, 1527592254, 1, 1, 0),
(239, 239, 199, 0, 3600, 0, 0, 0, 0, 0, 1527532200, 1527592254, 1, 2, 0),
(240, 240, 119, 1046, 0, 0, 0, 0, 0, 0, 1525285800, 1527593073, 1, 1, 0),
(241, 240, 120, 0, 829, 0, 0, 0, 0, 0, 1525285800, 1527593073, 1, 1, 0),
(242, 240, 212, 0, 217, 0, 0, 0, 0, 0, 1525285800, 1527593073, 1, 2, 0),
(243, 241, 68, 1318, 0, 0, 0, 0, 0, 0, 1527532200, 1527596262, 1, 1, 0),
(244, 241, 66, 0, 1066, 0, 0, 0, 0, 0, 1527532200, 1527596262, 1, 1, 0),
(245, 241, 199, 0, 252, 0, 0, 0, 0, 0, 1527532200, 1527596262, 1, 2, 0),
(246, 242, 68, 1453, 0, 0, 0, 0, 0, 0, 1527532200, 1527611344, 1, 1, 0),
(247, 242, 66, 0, 1211, 0, 0, 0, 0, 0, 1527532200, 1527611344, 1, 1, 0),
(248, 242, 199, 0, 242, 0, 0, 0, 0, 0, 1527532200, 1527611344, 1, 2, 0),
(249, 243, 68, 4761, 0, 0, 0, 0, 0, 0, 1527618600, 1527660684, 1, 1, 0),
(250, 243, 66, 0, 3720, 0, 0, 0, 0, 0, 1527618600, 1527660684, 1, 1, 0),
(251, 243, 199, 0, 1041, 0, 0, 0, 0, 0, 1527618600, 1527660684, 1, 2, 0),
(252, 244, 107, 236, 0, 0, 0, 0, 0, 0, 1527532200, 1527665873, 1, 1, 0),
(253, 244, 108, 0, 200, 0, 0, 0, 0, 0, 1527532200, 1527665873, 1, 1, 0),
(254, 244, 209, 0, 36, 0, 0, 0, 0, 0, 1527532200, 1527665873, 1, 2, 0),
(255, 245, 107, 346, 0, 0, 0, 0, 0, 0, 1527618600, 1527666073, 1, 1, 0),
(256, 245, 108, 0, 290, 0, 0, 0, 0, 0, 1527618600, 1527666073, 1, 1, 0),
(257, 245, 209, 0, 56, 0, 0, 0, 0, 0, 1527618600, 1527666073, 1, 2, 0),
(258, 246, 107, 2414, 0, 0, 0, 0, 0, 0, 1527618600, 1527674847, 1, 1, 0),
(259, 246, 108, 0, 1886, 0, 0, 0, 0, 0, 1527618600, 1527674847, 1, 1, 0),
(260, 246, 209, 0, 528, 0, 0, 0, 0, 0, 1527618600, 1527674847, 1, 2, 0),
(261, 247, 107, 15797, 0, 0, 0, 0, 0, 0, 1527618600, 1527675811, 1, 1, 0),
(262, 247, 108, 0, 12706, 0, 0, 0, 0, 0, 1527618600, 1527675811, 1, 1, 0),
(263, 247, 209, 0, 3091, 0, 0, 0, 0, 0, 1527618600, 1527675811, 1, 2, 0);

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

--
-- Table structure for table `vouchers`
--

CREATE TABLE IF NOT EXISTS `vouchers` (
  `voucher_id` int(100) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) NOT NULL,
  `warehouse_id` int(100) NOT NULL,
  `voucher_type` int(100) NOT NULL,
  `voucher_no` double NOT NULL,
  `debit_ledgers` varchar(1000) NOT NULL,
  `credit_ledgers` varchar(1000) NOT NULL,
  `narration` longtext NOT NULL,
  `voucher_date` int(100) NOT NULL,
  `voucher_time` int(100) NOT NULL,
  `voucher_status` int(100) NOT NULL DEFAULT '1',
  PRIMARY KEY (`voucher_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=248 ;

--
-- Dumping data for table `vouchers`
--

INSERT INTO `vouchers` (`voucher_id`, `branch_id`, `warehouse_id`, `voucher_type`, `voucher_no`, `debit_ledgers`, `credit_ledgers`, `narration`, `voucher_date`, `voucher_time`, `voucher_status`) VALUES
(177, 37, 0, 1, 1201804130001, '75', '76,201', 'Sales to AMAL STORE', 1523557800, 1527229870, 1),
(176, 37, 0, 1, 1201804100001, '75', '76,201', 'Sales to willson', 1523298600, 1527229701, 1),
(175, 37, 0, 1, 1201804090001, '75', '76,201', 'Sales to SDN STORE', 1523212200, 1527229339, 1),
(174, 37, 0, 1, 1201804070001, '75', '76,201', 'Sales to CHRISTEPHER', 1523039400, 1527229196, 1),
(173, 37, 0, 1, 1201804060002, '75', '76,201', 'Sales to Newton', 1522953000, 1527228462, 1),
(172, 37, 0, 1, 1201804060001, '75', '76,201', 'Sales to MAGESH', 1522953000, 1527227691, 1),
(171, 0, 0, 1, 1201805250001, '68', '66,199', 'Sales to BIJU', 1527186600, 1527226472, 1),
(170, 45, 0, 1, 1201805250001, '107', '108,209', 'Sales to signy', 1527186600, 1527222254, 1),
(169, 0, 0, 1, 1201805240001, '68', '66,199', 'Sales to SIFFS OBM WORKSHOP, Mangalore', 1527100200, 1527171876, 1),
(168, 50, 0, 2, 2201805240001, '454,664', '127', 'Payment to ', 1527100200, 1527171876, 1),
(167, 45, 0, 1, 1201805240003, '107', '108,209', 'Sales to NIJU', 1527100200, 1527169085, 1),
(166, 45, 0, 1, 1201805240002, '107', '108,209', 'Sales to jeri', 1527100200, 1527168441, 1),
(165, 45, 0, 1, 1201805240001, '107', '108,209', 'Sales to antony', 1527100200, 1527168185, 1),
(164, 42, 0, 1, 1201804300001, '95', '96,206', 'Sales to JAIMS', 1525026600, 1527160723, 1),
(163, 42, 0, 1, 1201804280001, '95', '96,206', 'Sales to CHRISTEPHER', 1524853800, 1527160525, 1),
(162, 42, 0, 1, 1201804270001, '95', '96,206', 'Sales to DAVEED', 1524767400, 1527159761, 1),
(161, 42, 0, 1, 1201804260001, '95', '96,206', 'Sales to CHRISTEPHER', 1524681000, 1527159345, 1),
(160, 42, 0, 1, 1201804250001, '95', '96,206', 'Sales to JOHNSON', 1524594600, 1527159044, 1),
(159, 42, 0, 1, 1201804240002, '95', '96,206', 'Sales to Raju', 1524508200, 1527158292, 1),
(158, 42, 0, 1, 1201804240001, '95', '96,206', 'Sales to CHRISTEPHER', 1524508200, 1527158146, 1),
(157, 42, 0, 1, 1201804230001, '95', '96,206', 'Sales to YESUDAS', 1524421800, 1527157566, 1),
(178, 37, 0, 1, 1201804100001, '75', '76,201', 'Sales to ROBINSON', 1523298600, 1527230539, 1),
(179, 37, 0, 1, 1201804180001, '75', '76,201', 'Sales to KUMAR', 1523989800, 1527230957, 1),
(180, 37, 0, 1, 1201804230001, '75', '76,201', 'Sales to willson', 1524421800, 1527231752, 1),
(181, 37, 0, 1, 1201804280001, '75', '76,201', 'Sales to THASON', 1524853800, 1527232104, 1),
(182, 50, 0, 2, 2201805250001, '454,664', '127', 'Payment to ', 1527186600, 1527233259, 1),
(183, 0, 0, 1, 1201805250002, '68', '66,199', 'Sales to SIFFS OBM WORKSHOP, Mangalore', 1527186600, 1527233259, 1),
(184, 36, 0, 1, 1201804060001, '71', '72,200', 'Sales to SUNEESH', 1522953000, 1527233660, 1),
(185, 36, 0, 1, 1201804100001, '71', '72,200', 'Sales to JEGAN', 1523298600, 1527233926, 1),
(186, 36, 0, 1, 1201804120001, '71', '72,200', 'Sales to Rajan', 1523471400, 1527235243, 1),
(187, 48, 0, 2, 2201805250001, '426', '119', 'Payment to ', 1527186600, 1527237997, 1),
(188, 0, 0, 1, 1201805250003, '68', '66', 'Sales to SIFFS OBM WORKSHOP, KOLLAM', 1527186600, 1527237997, 1),
(189, 36, 0, 1, 1201804140001, '71', '72,200', 'Sales to JEROM', 1523644200, 1527239089, 1),
(190, 36, 0, 1, 1201804170001, '71', '72,200', 'Sales to SAHAYA RAU', 1523903400, 1527240170, 1),
(191, 45, 0, 1, 1201805250002, '107', '108,209', 'Sales to stellas', 1527186600, 1527241180, 1),
(192, 45, 0, 1, 1201805250003, '107', '108,209', 'Sales to antony', 1527186600, 1527242813, 1),
(193, 45, 0, 1, 1201805250004, '107', '108,209', 'Sales to raju', 1527186600, 1527243178, 1),
(194, 36, 0, 1, 1201804190001, '71', '72,200', 'Sales to Anto', 1524076200, 1527244352, 1),
(195, 36, 0, 1, 1201804210001, '71', '72,200', 'Sales to JOHN', 1524249000, 1527244833, 1),
(196, 36, 0, 1, 1201804240001, '71', '72,200', 'Sales to MILTON', 1524508200, 1527245331, 1),
(197, 36, 0, 1, 1201804250001, '71', '72,200', 'Sales to SAJAN', 1524594600, 1527245558, 1),
(198, 42, 0, 2, 2201805250001, '354', '95', 'Payment to ', 1527186600, 1527245624, 1),
(199, 0, 0, 1, 1201805250004, '68', '66', 'Sales to SIFFS OBM WORKSHOP, Anjengo', 1527186600, 1527245624, 1),
(200, 36, 0, 1, 1201804260001, '71', '72,200', 'Sales to ANDREWS', 1524681000, 1527245872, 1),
(201, 36, 0, 1, 1201804270001, '71', '72,200', 'Sales to KUMAR', 1524767400, 1527246076, 1),
(202, 36, 0, 1, 1201804280001, '71', '72,200', 'Sales to ALBERT', 1524853800, 1527246169, 1),
(203, 45, 0, 1, 1201805250005, '107', '108,209', 'Sales to SHIJU', 1527186600, 1527251466, 1),
(204, 0, 0, 1, 1201805260001, '68', '66,199', 'Sales to DAVID', 1527273000, 1527320379, 1),
(205, 49, 0, 1, 1201805260001, '123', '124,213', 'Sales to Reghau', 1527273000, 1527320421, 1),
(206, 49, 0, 1, 1201804210001, '123', '124,213', 'Sales to Kunjumon', 1524249000, 1527323799, 1),
(207, 49, 0, 1, 1201805260002, '123', '124,213', 'Sales to Saji', 1527273000, 1527324656, 1),
(208, 0, 0, 2, 2201804130001, '700,701', '68', 'Payment to SUZUKI MOTOR CORPORATION', 1523557800, 1527325018, 1),
(209, 49, 0, 1, 1201804230001, '123', '124,213', 'Sales to Sukallin', 1524421800, 1527325230, 1),
(210, 49, 0, 1, 1201804240001, '123', '124,213', 'Sales to Kamala', 1524508200, 1527327232, 1),
(211, 49, 0, 1, 1201804250001, '123', '124,213', 'Sales to Shibu', 1524594600, 1527327836, 1),
(212, 49, 0, 1, 1201804250001, '123', '124,213', 'Sales to Parvattu vallam', 1524594600, 1527328072, 1),
(213, 49, 0, 2, 2201805260001, '440', '123', 'Payment to ', 1527273000, 1527328132, 1),
(214, 0, 0, 1, 1201805260002, '68', '66', 'Sales to SIFFS OBM WORKSHOP, Ambalappuzha', 1527273000, 1527328132, 1),
(215, 49, 0, 1, 1201804260001, '123', '124,213', 'Sales to Visbnu', 1524681000, 1527329780, 1),
(216, 39, 0, 2, 2201805260001, '312,523', '83', 'Payment to ', 1527273000, 1527330610, 1),
(217, 0, 0, 1, 1201805260003, '68', '66,199', 'Sales to SIFFS OBM WORKSHOP, VALLAVILA', 1527273000, 1527330610, 1),
(218, 49, 0, 1, 1201804260001, '123', '124,213', 'Sales to Sudheesh', 1524681000, 1527332118, 1),
(219, 49, 0, 1, 1201804260001, '123', '124,213', 'Sales to sunil', 1524681000, 1527332502, 1),
(220, 0, 0, 1, 1201805280001, '68', '66,199', 'Sales to ROKIYAS', 1527445800, 1527492515, 1),
(221, 0, 0, 1, 1201805280002, '68', '66,199', 'Sales to SUNIL', 1527445800, 1527493065, 1),
(222, 43, 0, 1, 1201805020001, '99', '100,207', 'Sales to Paniyadimma', 1525199400, 1527493613, 1),
(223, 43, 0, 1, 1201805280001, '99', '100,207', 'Sales to Stalin', 1527445800, 1527493871, 1),
(224, 43, 0, 1, 1201805020001, '99', '100,207', 'Sales to Dasan', 1525199400, 1527493975, 1),
(225, 0, 0, 2, 2201804180001, ',', '68', 'Payment to UNITED TECHNOLOGIES', 1523989800, 1527494036, 1),
(226, 43, 0, 1, 1201805030001, '99', '100,207', 'Sales to merlin', 1525285800, 1527494166, 1),
(227, 43, 0, 1, 1201805030001, '99', '100,207', 'Sales to merlin', 1525285800, 1527494332, 1),
(228, 43, 0, 1, 1201805030001, '99', '100,207', 'Sales to dasan', 1525285800, 1527494538, 1),
(229, 42, 0, 1, 1201805020001, '95', '96,206', 'Sales to revar islant', 1525199400, 1527502221, 1),
(230, 43, 0, 2, 2201805280001, '368', '99', 'Payment to ', 1527445800, 1527504602, 1),
(231, 0, 0, 1, 1201805280003, '68', '66', 'Sales to SIFFS OBM WORKSHOP, Marianad ', 1527445800, 1527504602, 1),
(232, 38, 0, 2, 2201805280001, '298,509', '79', 'Payment to ', 1527445800, 1527509432, 1),
(233, 0, 0, 1, 1201805280004, '68', '66,199', 'Sales to SIFFS OBM W/S, Enayam Puthenthurai ', 1527445800, 1527509432, 1),
(234, 43, 0, 2, 2201805290001, '368', '99', 'Payment to ', 1527532200, 1527579444, 1),
(235, 0, 0, 1, 1201805290001, '68', '66', 'Sales to SIFFS OBM WORKSHOP, Marianad ', 1527532200, 1527579444, 1),
(236, 47, 0, 1, 1201805020001, '115', '116,211', 'Sales to xavier', 1525199400, 1527580493, 1),
(237, 47, 0, 1, 1201805020002, '115', '116,211', 'Sales to nelson', 1525199400, 1527581647, 1),
(238, 47, 0, 1, 1201805030001, '115', '116,211', 'Sales to thadaus', 1525285800, 1527584077, 1),
(239, 0, 0, 1, 1201805290002, '68', '66,199', 'Sales to TK VENKATESH', 1527532200, 1527592254, 1),
(240, 48, 0, 1, 1201805030001, '119', '120,212', 'Sales to Jagan', 1525285800, 1527593073, 1),
(241, 0, 0, 1, 1201805290003, '68', '66,199', 'Sales to MAHENDRA BOAT CLUB POOVAR', 1527532200, 1527596262, 1),
(242, 0, 0, 1, 1201805290004, '68', '66,199', 'Sales to MANGROOS BACK WATERS', 1527532200, 1527611344, 1),
(243, 0, 0, 1, 1201805300001, '68', '66,199', 'Sales to DARVIN', 1527618600, 1527660684, 1),
(244, 45, 0, 1, 1201805290001, '107', '108,209', 'Sales to cristy', 1527532200, 1527665873, 1),
(245, 45, 0, 1, 1201805300001, '107', '108,209', 'Sales to jestin', 1527618600, 1527666073, 1),
(246, 45, 0, 1, 1201805300002, '107', '108,209', 'Sales to sheltan', 1527618600, 1527674847, 1),
(247, 45, 0, 1, 1201805300003, '107', '108,209', 'Sales to shyju', 1527618600, 1527675811, 1);

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

--
-- Table structure for table `voucher_type`
--

CREATE TABLE IF NOT EXISTS `voucher_type` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `voucher_name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `voucher_type`
--

INSERT INTO `voucher_type` (`id`, `voucher_name`) VALUES
(1, 'Receipt'),
(2, 'Payment'),
(3, 'Journal'),
(4, 'Contra'),
(5, 'Purchase'),
(6, 'Sales'),
(7, 'Day Book'),
(8, 'Purchase Return'),
(9, 'Sales Return'),
(10, 'Stock Transfer');
