INSERT INTO `sale_payments` (`sale_pymnt_id`, `sale_id`, `sale_pymnt_ref_no`, `sale_pymnt_paying_by`, `sale_pymnt_amount`, `sale_pymnt_date_time`, `user_id`, `sale_pymnt_added_date_time`, `sale_pymnt_note`, `sale_pymnt_cheque_no`, `sale_pymnt_cheque_date`, `sale_pymnt_crdt_card_no`, `sale_pymnt_crdt_card_holder_name`, `sale_pymnt_crdt_card_type`, `sale_pymnt_crdt_card_month`, `sale_pymnt_crdt_card_year`, `sale_payment_type`, `sale_pymnt_balance_amount`, `sale_pymnt_given_amount`, `smp_id`) VALUES
(115280, 107549, '', 'cash', 10193.56, '2024-01-24', 0, '2024-01-24 09:47:00', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115281, 107550, '', 'cash', 6097.00, '2024-01-24', 0, '2024-01-24 09:47:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115282, 107551, '', 'cash', 440.00, '2024-01-24', 0, '2024-01-24 09:50:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115283, 107552, '', 'cash', 440.00, '2024-01-24', 0, '2024-01-24 09:52:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115284, 107553, '', 'cash', 3475.00, '2024-01-24', 0, '2024-01-24 09:57:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115285, 107554, '', 'cash', 40948.00, '2024-01-24', 0, '2024-01-24 09:58:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115286, 107555, '', 'cash', 129000.00, '2024-01-24', 0, '2024-01-24 10:02:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115287, 107556, '', 'cash', 300.00, '2024-01-24', 0, '2024-01-24 10:03:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115288, 107557, '', 'cash', 680.00, '2024-01-24', 0, '2024-01-24 10:05:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115289, 107558, '', 'cash', 195.00, '2024-01-24', 0, '2024-01-24 10:10:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115290, 107559, '', 'cash', 19273.60, '2024-01-24', 0, '2024-01-24 10:12:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115291, 107560, '', 'cash', 1420.00, '2024-01-24', 0, '2024-01-24 10:13:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115292, 107561, '', 'cash', 1150.00, '2024-01-24', 0, '2024-01-24 10:14:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115293, 107562, '', 'cash', 22500.00, '2024-01-24', 0, '2024-01-24 10:15:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115294, 107563, '', 'cash', 1326.00, '2024-01-24', 0, '2024-01-24 10:19:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115295, 107564, '', 'cash', 465.00, '2024-01-24', 0, '2024-01-24 10:26:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115296, 107565, '', 'cash', 1136.30, '2024-01-24', 0, '2024-01-24 10:27:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115297, 107566, '', 'cash', 570.66, '2024-01-24', 0, '2024-01-24 10:34:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115298, 107567, '', 'cash', 240.80, '2024-01-24', 0, '2024-01-24 10:37:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115299, 107568, '', 'cash', 1006.56, '2024-01-24', 0, '2024-01-24 10:39:07', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115300, 107569, '', 'cash', 570.00, '2024-01-24', 0, '2024-01-24 10:42:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115301, 107570, '', 'cash', 11194.00, '2024-01-24', 0, '2024-01-24 10:45:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115302, 107571, '', 'cash', 150.00, '2024-01-24', 0, '2024-01-24 10:51:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115303, 107572, '', 'cash', 15162.00, '2024-01-24', 0, '2024-01-24 10:53:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115304, 107573, '', 'cash', 14389.00, '2024-01-24', 0, '2024-01-24 10:53:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115305, 107574, '', 'cash', 4400.00, '2024-01-24', 0, '2024-01-24 10:58:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115306, 107575, '', 'cash', 15617.23, '2024-01-24', 0, '2024-01-24 10:58:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115307, 107576, '', 'cash', 200.00, '2024-01-24', 0, '2024-01-24 11:00:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115308, 107577, '', 'cash', 216.00, '2024-01-24', 0, '2024-01-24 11:14:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115309, 107578, '', 'cash', 2040.00, '2024-01-24', 0, '2024-01-24 11:21:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115310, 107579, '', 'cash', 500.00, '2024-01-24', 0, '2024-01-24 11:25:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115311, 107580, '', 'cash', 3100.00, '2024-01-24', 0, '2024-01-24 11:32:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115312, 107581, '', 'cash', 81325.00, '2024-01-24', 0, '2024-01-24 11:45:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115313, 107582, '', 'cash', 4700.00, '2024-01-24', 0, '2024-01-24 11:46:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115314, 107583, '', 'cash', 7452.00, '2024-01-24', 0, '2024-01-24 11:55:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115315, 107584, '', 'cash', 9650.00, '2024-01-24', 0, '2024-01-24 11:58:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115316, 107585, '', 'cash', 2730.00, '2024-01-24', 0, '2024-01-24 12:06:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115317, 107586, '', 'cash', 3920.00, '2024-01-24', 0, '2024-01-24 12:06:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115318, 107587, '', 'cash', 10118.00, '2024-01-24', 0, '2024-01-24 12:08:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115319, 107588, '', 'cash', 5144.30, '2024-01-24', 0, '2024-01-24 12:09:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115320, 107589, '', 'cash', 602.40, '2024-01-24', 0, '2024-01-24 12:11:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115321, 107590, '', 'cash', 7360.00, '2024-01-24', 0, '2024-01-24 12:17:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115322, 107591, '', 'cash', 9280.00, '2024-01-24', 0, '2024-01-24 12:20:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115323, 107592, '', 'cash', 999.00, '2024-01-24', 0, '2024-01-24 12:25:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115324, 107593, '', 'cash', 525.00, '2024-01-24', 0, '2024-01-24 12:30:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115325, 107594, '', 'cash', 38050.00, '2024-01-24', 0, '2024-01-24 12:37:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115326, 107595, '', 'cash', 1800.00, '2024-01-24', 0, '2024-01-24 12:41:45', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115327, 107596, '', 'cash', 4900.00, '2024-01-24', 0, '2024-01-24 12:45:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115328, 107597, '', 'cash', 7905.40, '2024-01-24', 0, '2024-01-24 12:45:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115329, 107598, '', 'cash', 9965.34, '2024-01-24', 0, '2024-01-24 12:50:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115330, 107599, '', 'cash', 4320.00, '2024-01-24', 0, '2024-01-24 12:51:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115331, 107600, '', 'cash', 30820.00, '2024-01-24', 0, '2024-01-24 12:53:14', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115332, 107601, '', 'cash', 1950.00, '2024-01-24', 0, '2024-01-24 12:58:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115333, 107602, '', 'cash', 20950.00, '2024-01-24', 0, '2024-01-24 13:03:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115334, 107603, '', 'cash', 4068.24, '2024-01-24', 0, '2024-01-24 13:06:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115335, 107604, '', 'cash', 11272.20, '2024-01-24', 0, '2024-01-24 13:10:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115336, 107605, '', 'cash', 51768.00, '2024-01-24', 0, '2024-01-24 13:15:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115337, 107606, '', 'cash', 3167.00, '2024-01-24', 0, '2024-01-24 13:27:04', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115338, 107607, '', 'cash', 15765.00, '2024-01-24', 0, '2024-01-24 13:28:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115339, 107608, '', 'cash', 5600.00, '2024-01-24', 0, '2024-01-24 13:29:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115340, 107609, '', 'cash', 15167.00, '2024-01-24', 0, '2024-01-24 13:30:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115341, 107610, '', 'cash', 5760.00, '2024-01-24', 0, '2024-01-24 13:32:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115342, 107611, '', 'cash', 503.50, '2024-01-24', 0, '2024-01-24 13:34:26', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115343, 107612, '', 'cash', 4240.00, '2024-01-24', 0, '2024-01-24 13:57:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115344, 107613, '', 'cash', 320.00, '2024-01-24', 0, '2024-01-24 14:02:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115345, 107614, '', 'cash', 7610.00, '2024-01-24', 0, '2024-01-24 14:02:43', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115346, 107615, '', 'cash', 6350.00, '2024-01-24', 0, '2024-01-24 14:04:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115347, 107616, '', 'cash', 1310.00, '2024-01-24', 0, '2024-01-24 14:07:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115348, 107617, '', 'cash', 9000.00, '2024-01-24', 0, '2024-01-24 14:18:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115349, 107618, '', 'cash', 3120.00, '2024-01-24', 0, '2024-01-24 14:28:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115350, 107619, '', 'cash', 24606.00, '2024-01-24', 0, '2024-01-24 14:35:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115351, 107620, '', 'cash', 3419.68, '2024-01-24', 0, '2024-01-24 14:40:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115352, 107621, '', 'cash', 2000.00, '2024-01-24', 0, '2024-01-24 14:43:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115353, 107622, '', 'cash', 130.00, '2024-01-24', 0, '2024-01-24 15:12:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115354, 107623, '', 'cash', 11250.00, '2024-01-24', 0, '2024-01-24 15:15:26', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115355, 107624, '', 'cash', 10797.75, '2024-01-24', 0, '2024-01-24 15:25:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115356, 107625, '', 'cash', 74850.14, '2024-01-24', 0, '2024-01-24 15:30:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115357, 107626, '', 'cash', 1675.00, '2024-01-24', 0, '2024-01-24 15:43:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115358, 107627, '', 'cash', 12760.00, '2024-01-24', 0, '2024-01-24 15:48:15', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115359, 107628, '', 'cash', 14800.00, '2024-01-24', 0, '2024-01-24 15:50:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115360, 107629, '', 'cash', 6580.00, '2024-01-24', 0, '2024-01-24 16:03:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115361, 107630, '', 'cash', 31500.00, '2024-01-24', 0, '2024-01-24 16:03:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115362, 107631, '', 'cash', 8412.50, '2024-01-24', 0, '2024-01-24 16:08:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115363, 107632, '', 'cash', 14810.00, '2024-01-24', 0, '2024-01-24 16:09:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115364, 107633, '', 'cash', 877.50, '2024-01-24', 0, '2024-01-24 16:10:07', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115365, 107634, '', 'cash', 1220.00, '2024-01-24', 0, '2024-01-24 16:22:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115366, 107635, '', 'cash', 2894.50, '2024-01-24', 0, '2024-01-24 16:26:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115367, 107636, '', 'cash', 292.50, '2024-01-24', 0, '2024-01-24 16:34:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115368, 107637, '', 'cash', 7718.08, '2024-01-24', 0, '2024-01-24 16:48:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115369, 107638, '', 'cash', 61940.00, '2024-01-24', 0, '2024-01-24 16:52:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115370, 107639, '', 'cash', 30710.00, '2024-01-24', 0, '2024-01-24 17:02:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115371, 107640, '', 'cash', 800.00, '2024-01-24', 0, '2024-01-24 17:03:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115372, 107641, '', 'cash', 1035.00, '2024-01-24', 0, '2024-01-24 17:06:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115373, 107642, '', 'cash', 15750.00, '2024-01-24', 0, '2024-01-24 17:08:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115374, 107643, '', 'cash', 475.32, '2024-01-24', 0, '2024-01-24 17:09:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115375, 107644, '', 'cash', 11000.00, '2024-01-24', 0, '2024-01-24 17:11:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115376, 107645, '', 'cash', 14709.00, '2024-01-24', 0, '2024-01-24 17:19:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115377, 107646, '', 'cash', 3040.00, '2024-01-24', 0, '2024-01-24 17:28:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115378, 107647, '', 'cash', 13225.00, '2024-01-24', 0, '2024-01-24 17:31:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115379, 107648, '', 'cash', 190.00, '2024-01-24', 0, '2024-01-24 17:36:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115380, 107649, '', 'cash', 370.00, '2024-01-24', 0, '2024-01-24 17:36:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115381, 107650, '', 'cash', 325.20, '2024-01-24', 0, '2024-01-24 17:44:45', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115382, 107651, '', 'cash', 4140.00, '2024-01-24', 0, '2024-01-24 17:48:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115383, 107652, '', 'cash', 19350.00, '2024-01-24', 0, '2024-01-24 17:56:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115384, 107653, '', 'cash', 5580.00, '2024-01-24', 0, '2024-01-24 17:58:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115385, 107654, '', 'cash', 5580.00, '2024-01-24', 0, '2024-01-24 17:59:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115386, 107655, '', 'cash', 4940.00, '2024-01-24', 0, '2024-01-24 18:10:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115387, 107656, '', 'cash', 785.00, '2024-01-24', 0, '2024-01-24 18:15:47', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115388, 107657, '', 'cash', 4840.00, '2024-01-24', 0, '2024-01-24 18:28:15', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115389, 107658, '', 'cash', 1253.10, '2024-01-24', 0, '2024-01-24 18:38:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115390, 107659, '', 'cash', 4768.70, '2024-01-24', 0, '2024-01-24 18:44:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115391, 107660, '', 'cash', 2120.00, '2024-01-24', 0, '2024-01-24 18:51:12', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115392, 107661, '', 'cash', 5080.00, '2024-01-24', 0, '2024-01-24 18:53:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115393, 107662, '', 'cash', 8630.00, '2024-01-26', 0, '2024-01-26 08:15:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115394, 107663, '', 'cash', 41000.00, '2024-01-26', 0, '2024-01-26 08:18:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115395, 107664, '', 'cash', 42310.00, '2024-01-26', 0, '2024-01-26 08:23:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115396, 107665, '', 'cash', 513700.00, '2024-01-26', 0, '2024-01-26 08:25:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115397, 107666, '', 'cash', 76200.00, '2024-01-26', 0, '2024-01-26 08:26:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115398, 107667, '', 'cash', 5385.00, '2024-01-26', 0, '2024-01-26 08:37:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115399, 107668, '', 'cash', 2026.25, '2024-01-26', 0, '2024-01-26 08:39:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115400, 107669, '', 'cash', 33700.00, '2024-01-26', 0, '2024-01-26 08:43:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115401, 107670, '', 'cash', 3482.25, '2024-01-26', 0, '2024-01-26 08:46:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115402, 107671, '', 'cash', 17350.00, '2024-01-26', 0, '2024-01-26 08:53:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115403, 107672, '', 'cash', 7500.00, '2024-01-26', 0, '2024-01-26 08:54:07', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115404, 107673, '', 'cash', 13150.00, '2024-01-26', 0, '2024-01-26 09:05:26', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115405, 107674, '', 'cash', 57900.00, '2024-01-26', 0, '2024-01-26 09:16:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115406, 107675, '', 'cash', 480.00, '2024-01-26', 0, '2024-01-26 09:25:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115407, 107676, '', 'cash', 7800.00, '2024-01-26', 0, '2024-01-26 09:29:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115408, 107677, '', 'cash', 5556.25, '2024-01-26', 0, '2024-01-26 09:30:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115409, 107678, '', 'cash', 2360.00, '2024-01-26', 0, '2024-01-26 09:35:34', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115410, 107679, '', 'cash', 6515.00, '2024-01-26', 0, '2024-01-26 09:39:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115411, 107680, '', 'cash', 350.00, '2024-01-26', 0, '2024-01-26 09:41:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115412, 107681, '', 'cash', 497.50, '2024-01-26', 0, '2024-01-26 09:41:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115413, 107682, '', 'cash', 519280.00, '2024-01-26', 0, '2024-01-26 09:57:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115414, 107683, '', 'cash', 29250.00, '2024-01-26', 0, '2024-01-26 09:58:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115415, 107684, '', 'cash', 2562.15, '2024-01-26', 0, '2024-01-26 10:00:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115416, 107685, '', 'cash', 6935.50, '2024-01-26', 0, '2024-01-26 10:05:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115417, 107686, '', 'cash', 1222.50, '2024-01-26', 0, '2024-01-26 10:06:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115418, 107687, '', 'cash', 1900.00, '2024-01-26', 0, '2024-01-26 10:13:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115419, 107688, '', 'cash', 27420.00, '2024-01-26', 0, '2024-01-26 10:18:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115420, 107689, '', 'cash', 13610.00, '2024-01-26', 0, '2024-01-26 10:19:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115421, 107690, '', 'cash', 133040.00, '2024-01-26', 0, '2024-01-26 10:20:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115422, 107691, '', 'cash', 20300.00, '2024-01-26', 0, '2024-01-26 10:26:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115423, 107692, '', 'cash', 60360.00, '2024-01-26', 0, '2024-01-26 10:28:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115424, 107693, '', 'cash', 44000.00, '2024-01-26', 0, '2024-01-26 10:29:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115425, 107694, '', 'cash', 3450.00, '2024-01-26', 0, '2024-01-26 10:31:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115426, 107695, '', 'cash', 3867.00, '2024-01-26', 0, '2024-01-26 10:31:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115427, 107696, '', 'cash', 190.00, '2024-01-26', 0, '2024-01-26 10:34:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115428, 107697, '', 'cash', 229000.00, '2024-01-26', 0, '2024-01-26 10:37:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115429, 107698, '', 'cash', 8460.00, '2024-01-26', 0, '2024-01-26 10:39:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115430, 107699, '', 'cash', 4400.00, '2024-01-26', 0, '2024-01-26 10:48:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115431, 107700, '', 'cash', 628.00, '2024-01-26', 0, '2024-01-26 10:51:15', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115432, 107701, '', 'cash', 105758.32, '2024-01-26', 0, '2024-01-26 10:52:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115433, 107702, '', 'cash', 20500.00, '2024-01-26', 0, '2024-01-26 11:01:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115434, 107703, '', 'cash', 5450.00, '2024-01-26', 0, '2024-01-26 11:06:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115435, 107704, '', 'cash', 53200.00, '2024-01-26', 0, '2024-01-26 11:10:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115436, 107705, '', 'cash', 43200.00, '2024-01-26', 0, '2024-01-26 11:15:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115437, 107706, '', 'cash', 236.99, '2024-01-26', 0, '2024-01-26 11:15:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115438, 107707, '', 'cash', 586.73, '2024-01-26', 0, '2024-01-26 11:16:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115439, 107708, '', 'cash', 662.70, '2024-01-26', 0, '2024-01-26 11:21:14', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115440, 107709, '', 'cash', 1435.00, '2024-01-26', 0, '2024-01-26 11:24:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115441, 107710, '', 'cash', 660.16, '2024-01-26', 0, '2024-01-26 11:27:00', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115442, 107712, '', 'cash', 200.00, '2024-01-26', 0, '2024-01-26 11:33:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115443, 107713, '', 'cash', 935.00, '2024-01-26', 0, '2024-01-26 11:37:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115444, 107714, '', 'cash', 249.61, '2024-01-26', 0, '2024-01-26 11:38:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115445, 107715, '', 'cash', 7312.00, '2024-01-26', 0, '2024-01-26 11:42:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115446, 107716, '', 'cash', 9200.00, '2024-01-26', 0, '2024-01-26 11:43:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115447, 107717, '', 'cash', 10200.00, '2024-01-26', 0, '2024-01-26 11:46:14', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115448, 107718, '', 'cash', 780.00, '2024-01-26', 0, '2024-01-26 12:02:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115449, 107719, '', 'cash', 57821.25, '2024-01-26', 0, '2024-01-26 12:09:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115450, 107720, '', 'cash', 1290.00, '2024-01-26', 0, '2024-01-26 12:28:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115451, 107721, '', 'cash', 5745.00, '2024-01-26', 0, '2024-01-26 12:28:34', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115452, 107722, '', 'cash', 7010.00, '2024-01-26', 0, '2024-01-26 12:32:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115453, 107723, '', 'cash', 385.00, '2024-01-26', 0, '2024-01-26 12:41:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115454, 107724, '', 'cash', 26700.00, '2024-01-26', 0, '2024-01-26 12:48:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115455, 107725, '', 'cash', 5450.00, '2024-01-26', 0, '2024-01-26 13:03:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115456, 107726, '', 'cash', 71121.25, '2024-01-26', 0, '2024-01-26 13:13:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115457, 107727, '', 'cash', 211260.00, '2024-01-26', 0, '2024-01-26 13:36:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115458, 107728, '', 'cash', 960.00, '2024-01-26', 0, '2024-01-26 13:47:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115459, 107729, '', 'cash', 700.00, '2024-01-26', 0, '2024-01-26 13:50:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115460, 107730, '', 'cash', 210.00, '2024-01-26', 0, '2024-01-26 13:57:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115461, 107731, '', 'cash', 4740.00, '2024-01-26', 0, '2024-01-26 14:05:43', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115462, 107732, '', 'cash', 1833.20, '2024-01-26', 0, '2024-01-26 14:11:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115463, 107733, '', 'cash', 800.00, '2024-01-26', 0, '2024-01-26 14:13:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115464, 107734, '', 'cash', 1745.00, '2024-01-26', 0, '2024-01-26 14:15:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115465, 107735, '', 'cash', 10970.00, '2024-01-26', 0, '2024-01-26 14:27:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115466, 107736, '', 'cash', 13074.40, '2024-01-26', 0, '2024-01-26 14:30:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115467, 107737, '', 'cash', 902.75, '2024-01-26', 0, '2024-01-26 14:42:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115468, 107738, '', 'cash', 55000.00, '2024-01-26', 0, '2024-01-26 14:52:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115469, 107739, '', 'cash', 735.20, '2024-01-26', 0, '2024-01-26 14:53:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115470, 107740, '', 'cash', 10760.00, '2024-01-26', 0, '2024-01-26 14:54:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115471, 107741, '', 'cash', 595.00, '2024-01-26', 0, '2024-01-26 15:18:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115472, 107742, '', 'cash', 22500.00, '2024-01-26', 0, '2024-01-26 15:34:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115473, 107743, '', 'cash', 760.00, '2024-01-26', 0, '2024-01-26 15:49:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115474, 107744, '', 'cash', 11150.00, '2024-01-26', 0, '2024-01-26 15:51:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115475, 107745, '', 'cash', 1386.00, '2024-01-26', 0, '2024-01-26 16:11:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115476, 107746, '', 'cash', 16160.00, '2024-01-26', 0, '2024-01-26 16:13:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115477, 107747, '', 'cash', 980.00, '2024-01-26', 0, '2024-01-26 16:15:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115478, 107748, '', 'cash', 1090.00, '2024-01-26', 0, '2024-01-26 16:17:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115479, 107749, '', 'cash', 484.60, '2024-01-26', 0, '2024-01-26 16:22:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115480, 107750, '', 'cash', 60.00, '2024-01-26', 0, '2024-01-26 16:28:00', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115481, 107751, '', 'cash', 1798.00, '2024-01-26', 0, '2024-01-26 16:28:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115482, 107752, '', 'cash', 120.00, '2024-01-26', 0, '2024-01-26 16:30:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115483, 107753, '', 'cash', 3170.00, '2024-01-26', 0, '2024-01-26 16:36:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115484, 107754, '', 'cash', 14650.00, '2024-01-26', 0, '2024-01-26 16:38:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115485, 107755, '', 'cash', 2450.00, '2024-01-26', 0, '2024-01-26 16:42:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115486, 107756, '', 'cash', 5900.00, '2024-01-26', 0, '2024-01-26 16:43:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115487, 107757, '', 'cash', 3507.46, '2024-01-26', 0, '2024-01-26 16:44:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115488, 107758, '', 'cash', 6420.00, '2024-01-26', 0, '2024-01-26 17:00:14', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115489, 107759, '', 'cash', 75158.00, '2024-01-26', 0, '2024-01-26 17:02:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115490, 107760, '', 'cash', 5100.00, '2024-01-26', 0, '2024-01-26 17:09:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115491, 107761, '', 'cash', 3905.00, '2024-01-26', 0, '2024-01-26 17:09:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115492, 107762, '', 'cash', 1012.80, '2024-01-26', 0, '2024-01-26 17:36:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115493, 107763, '', 'cash', 5799.40, '2024-01-26', 0, '2024-01-26 17:37:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115494, 107764, '', 'cash', 14250.00, '2024-01-26', 0, '2024-01-26 17:38:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115495, 107765, '', 'cash', 2393.24, '2024-01-26', 0, '2024-01-26 17:44:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115496, 107766, '', 'cash', 1290.00, '2024-01-26', 0, '2024-01-26 17:45:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115497, 107767, '', 'cash', 6583.40, '2024-01-26', 0, '2024-01-26 17:47:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115498, 107768, '', 'cash', 8029.00, '2024-01-26', 0, '2024-01-26 17:55:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115499, 107769, '', 'cash', 620.00, '2024-01-26', 0, '2024-01-26 17:58:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115500, 107770, '', 'cash', 8029.00, '2024-01-26', 0, '2024-01-26 18:01:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115501, 107771, '', 'cash', 727.08, '2024-01-26', 0, '2024-01-26 18:08:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115502, 107772, '', 'cash', 585.80, '2024-01-26', 0, '2024-01-26 18:09:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115503, 107773, '', 'cash', 1624.00, '2024-01-26', 0, '2024-01-26 18:17:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115504, 107774, '', 'cash', 1200.00, '2024-01-27', 0, '2024-01-27 08:15:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115505, 107775, '', 'cash', 1410.00, '2024-01-27', 0, '2024-01-27 08:19:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115506, 107776, '', 'cash', 1675.00, '2024-01-27', 0, '2024-01-27 08:20:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115507, 107777, '', 'cash', 7140.00, '2024-01-27', 0, '2024-01-27 08:22:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115508, 107778, '', 'cash', 398.00, '2024-01-27', 0, '2024-01-27 08:22:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115509, 107779, '', 'cash', 2290.00, '2024-01-27', 0, '2024-01-27 08:25:34', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115510, 107780, '', 'cash', 195.00, '2024-01-27', 0, '2024-01-27 08:34:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115511, 107781, '', 'cash', 17500.00, '2024-01-27', 0, '2024-01-27 08:35:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115512, 107782, '', 'cash', 31500.00, '2024-01-27', 0, '2024-01-27 08:36:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115513, 107783, '', 'cash', 1810.20, '2024-01-27', 0, '2024-01-27 08:43:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115514, 107784, '', 'cash', 420.00, '2024-01-27', 0, '2024-01-27 08:45:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115515, 107785, '', 'cash', 5715.00, '2024-01-27', 0, '2024-01-27 08:48:26', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115516, 107786, '', 'cash', 3625.00, '2024-01-27', 0, '2024-01-27 08:53:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115517, 107787, '', 'cash', 133600.00, '2024-01-27', 0, '2024-01-27 08:53:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115518, 107788, '', 'cash', 2766.00, '2024-01-27', 0, '2024-01-27 08:54:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115519, 107789, '', 'cash', 1380.00, '2024-01-27', 0, '2024-01-27 09:00:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115520, 107790, '', 'cash', 480.00, '2024-01-27', 0, '2024-01-27 09:04:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115521, 107791, '', 'cash', 160.00, '2024-01-27', 0, '2024-01-27 09:05:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115522, 107792, '', 'cash', 51159.00, '2024-01-27', 0, '2024-01-27 09:05:43', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115523, 107793, '', 'cash', 41000.00, '2024-01-27', 0, '2024-01-27 09:09:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115524, 107794, '', 'cash', 31750.00, '2024-01-27', 0, '2024-01-27 09:11:04', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115525, 107795, '', 'cash', 20500.00, '2024-01-27', 0, '2024-01-27 09:12:23', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115526, 107796, '', 'cash', 540.00, '2024-01-27', 0, '2024-01-27 09:13:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115527, 107797, '', 'cash', 2485.00, '2024-01-27', 0, '2024-01-27 09:15:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115528, 107798, '', 'cash', 540.00, '2024-01-27', 0, '2024-01-27 09:20:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115529, 107799, '', 'cash', 4200.00, '2024-01-27', 0, '2024-01-27 09:23:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115530, 107800, '', 'cash', 1545.00, '2024-01-27', 0, '2024-01-27 09:31:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115531, 107801, '', 'cash', 21600.00, '2024-01-27', 0, '2024-01-27 09:34:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115532, 107802, '', 'cash', 5690.00, '2024-01-27', 0, '2024-01-27 09:38:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115533, 107803, '', 'cash', 440.00, '2024-01-27', 0, '2024-01-27 09:41:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115534, 107804, '', 'cash', 2037.75, '2024-01-27', 0, '2024-01-27 09:44:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115535, 107805, '', 'cash', 435.00, '2024-01-27', 0, '2024-01-27 09:49:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115536, 107806, '', 'cash', 3675.00, '2024-01-27', 0, '2024-01-27 09:50:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115537, 107807, '', 'cash', 3950.00, '2024-01-27', 0, '2024-01-27 09:52:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115538, 107808, '', 'cash', 5840.00, '2024-01-27', 0, '2024-01-27 09:54:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115539, 107809, '', 'cash', 2198.25, '2024-01-27', 0, '2024-01-27 09:58:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115540, 107810, '', 'cash', 6900.00, '2024-01-27', 0, '2024-01-27 10:00:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115541, 107811, '', 'cash', 7240.00, '2024-01-27', 0, '2024-01-27 10:02:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115542, 107812, '', 'cash', 2200.00, '2024-01-27', 0, '2024-01-27 10:12:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115543, 107813, '', 'cash', 30280.00, '2024-01-27', 0, '2024-01-27 10:13:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115544, 107814, '', 'cash', 1000.00, '2024-01-27', 0, '2024-01-27 10:13:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115545, 107815, '', 'cash', 7500.00, '2024-01-27', 0, '2024-01-27 10:14:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115546, 107816, '', 'cash', 8350.00, '2024-01-27', 0, '2024-01-27 10:14:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115547, 107817, '', 'cash', 640.00, '2024-01-27', 0, '2024-01-27 10:15:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115548, 107818, '', 'cash', 1580.50, '2024-01-27', 0, '2024-01-27 10:24:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115549, 107819, '', 'cash', 2700.00, '2024-01-27', 0, '2024-01-27 10:31:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115550, 107820, '', 'cash', 3169.50, '2024-01-27', 0, '2024-01-27 10:34:34', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115551, 107821, '', 'cash', 1350.00, '2024-01-27', 0, '2024-01-27 10:37:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115552, 107822, '', 'cash', 61870.00, '2024-01-27', 0, '2024-01-27 10:39:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115553, 107823, '', 'cash', 5347.45, '2024-01-27', 0, '2024-01-27 10:41:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115554, 107824, '', 'cash', 2975.00, '2024-01-27', 0, '2024-01-27 10:42:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115555, 107825, '', 'cash', 6250.00, '2024-01-27', 0, '2024-01-27 10:46:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115556, 107826, '', 'cash', 9080.00, '2024-01-27', 0, '2024-01-27 10:48:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115557, 107827, '', 'cash', 5300.00, '2024-01-27', 0, '2024-01-27 10:53:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115558, 107828, '', 'cash', 7060.00, '2024-01-27', 0, '2024-01-27 10:56:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115559, 107829, '', 'cash', 5160.00, '2024-01-27', 0, '2024-01-27 10:57:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115560, 107830, '', 'cash', 6530.00, '2024-01-27', 0, '2024-01-27 10:58:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115561, 107831, '', 'cash', 7600.00, '2024-01-27', 0, '2024-01-27 10:58:47', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115562, 107832, '', 'cash', 4400.00, '2024-01-27', 0, '2024-01-27 10:59:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115563, 107833, '', 'cash', 2450.00, '2024-01-27', 0, '2024-01-27 11:01:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115564, 107834, '', 'cash', 606.56, '2024-01-27', 0, '2024-01-27 11:02:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115565, 107835, '', 'cash', 9319.00, '2024-01-27', 0, '2024-01-27 11:03:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115566, 107836, '', 'cash', 2187.61, '2024-01-27', 0, '2024-01-27 11:04:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115567, 107837, '', 'cash', 68.50, '2024-01-27', 0, '2024-01-27 11:07:04', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115568, 107838, '', 'cash', 8150.00, '2024-01-27', 0, '2024-01-27 11:08:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115569, 107839, '', 'cash', 1600.00, '2024-01-27', 0, '2024-01-27 11:10:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115570, 107840, '', 'cash', 4855.00, '2024-01-27', 0, '2024-01-27 11:10:26', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115571, 107841, '', 'cash', 44000.00, '2024-01-27', 0, '2024-01-27 11:16:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115572, 107842, '', 'cash', 19700.00, '2024-01-27', 0, '2024-01-27 11:16:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115573, 107843, '', 'cash', 3563.00, '2024-01-27', 0, '2024-01-27 11:26:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115574, 107844, '', 'cash', 205.00, '2024-01-27', 0, '2024-01-27 11:28:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115575, 107845, '', 'cash', 3250.00, '2024-01-27', 0, '2024-01-27 11:28:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115576, 107846, '', 'cash', 4250.00, '2024-01-27', 0, '2024-01-27 11:30:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115577, 107847, '', 'cash', 4407.00, '2024-01-27', 0, '2024-01-27 11:34:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115578, 107848, '', 'cash', 3250.00, '2024-01-27', 0, '2024-01-27 11:34:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115579, 107849, '', 'cash', 22159.12, '2024-01-27', 0, '2024-01-27 11:40:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115580, 107850, '', 'cash', 9955.00, '2024-01-27', 0, '2024-01-27 11:41:23', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115581, 107851, '', 'cash', 6187.20, '2024-01-27', 0, '2024-01-27 11:45:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115582, 107852, '', 'cash', 1450.00, '2024-01-27', 0, '2024-01-27 11:46:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115583, 107853, '', 'cash', 960.00, '2024-01-27', 0, '2024-01-27 11:48:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115584, 107854, '', 'cash', 240.00, '2024-01-27', 0, '2024-01-27 11:48:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115585, 107855, '', 'cash', 107.20, '2024-01-27', 0, '2024-01-27 11:51:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115586, 107856, '', 'cash', 2253.60, '2024-01-27', 0, '2024-01-27 11:51:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115587, 107857, '', 'cash', 10350.00, '2024-01-27', 0, '2024-01-27 11:55:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115588, 107858, '', 'cash', 11535.00, '2024-01-27', 0, '2024-01-27 11:58:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115589, 107859, '', 'cash', 630.00, '2024-01-27', 0, '2024-01-27 11:59:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115590, 107860, '', 'cash', 182.00, '2024-01-27', 0, '2024-01-27 12:07:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115591, 107861, '', 'cash', 565.00, '2024-01-27', 0, '2024-01-27 12:08:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115592, 107862, '', 'cash', 27240.00, '2024-01-27', 0, '2024-01-27 12:12:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115593, 107863, '', 'cash', 6472.25, '2024-01-27', 0, '2024-01-27 12:15:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115594, 107864, '', 'cash', 6585.10, '2024-01-27', 0, '2024-01-27 12:16:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115595, 107865, '', 'cash', 2995.00, '2024-01-27', 0, '2024-01-27 12:27:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115596, 107866, '', 'cash', 400.00, '2024-01-27', 0, '2024-01-27 12:38:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115597, 107867, '', 'cash', 2611.50, '2024-01-27', 0, '2024-01-27 12:42:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115598, 107868, '', 'cash', 1908.00, '2024-01-27', 0, '2024-01-27 12:42:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115599, 107869, '', 'cash', 480.00, '2024-01-27', 0, '2024-01-27 12:44:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115600, 107870, '', 'cash', 118567.00, '2024-01-27', 0, '2024-01-27 12:46:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115601, 107871, '', 'cash', 358.20, '2024-01-27', 0, '2024-01-27 12:49:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115602, 107872, '', 'cash', 1020.00, '2024-01-27', 0, '2024-01-27 12:57:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115603, 107873, '', 'cash', 2200.00, '2024-01-27', 0, '2024-01-27 13:01:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115604, 107874, '', 'cash', 1800.00, '2024-01-27', 0, '2024-01-27 13:02:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115605, 107875, '', 'cash', 580.00, '2024-01-27', 0, '2024-01-27 13:04:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115606, 107876, '', 'cash', 550.00, '2024-01-27', 0, '2024-01-27 13:10:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115607, 107877, '', 'cash', 119732.00, '2024-01-27', 0, '2024-01-27 13:11:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115608, 107878, '', 'cash', 1235.00, '2024-01-27', 0, '2024-01-27 13:23:04', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115609, 107879, '', 'cash', 1395.00, '2024-01-27', 0, '2024-01-27 13:27:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115610, 107880, '', 'cash', 25070.00, '2024-01-27', 0, '2024-01-27 13:30:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115611, 107881, '', 'cash', 405.00, '2024-01-27', 0, '2024-01-27 13:32:12', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115612, 107882, '', 'cash', 1100.00, '2024-01-27', 0, '2024-01-27 13:38:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115613, 107883, '', 'cash', 4750.00, '2024-01-27', 0, '2024-01-27 13:39:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115614, 107884, '', 'cash', 470.25, '2024-01-27', 0, '2024-01-27 13:52:15', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115615, 107885, '', 'cash', 23720.00, '2024-01-27', 0, '2024-01-27 13:58:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115616, 107886, '', 'cash', 7800.00, '2024-01-27', 0, '2024-01-27 14:10:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115617, 107887, '', 'cash', 436.00, '2024-01-27', 0, '2024-01-27 14:16:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0);
INSERT INTO `sale_payments` (`sale_pymnt_id`, `sale_id`, `sale_pymnt_ref_no`, `sale_pymnt_paying_by`, `sale_pymnt_amount`, `sale_pymnt_date_time`, `user_id`, `sale_pymnt_added_date_time`, `sale_pymnt_note`, `sale_pymnt_cheque_no`, `sale_pymnt_cheque_date`, `sale_pymnt_crdt_card_no`, `sale_pymnt_crdt_card_holder_name`, `sale_pymnt_crdt_card_type`, `sale_pymnt_crdt_card_month`, `sale_pymnt_crdt_card_year`, `sale_payment_type`, `sale_pymnt_balance_amount`, `sale_pymnt_given_amount`, `smp_id`) VALUES
(115618, 107888, '', 'cash', 1120.00, '2024-01-27', 0, '2024-01-27 14:24:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115619, 107889, '', 'cash', 17780.00, '2024-01-27', 0, '2024-01-27 14:31:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115620, 107890, '', 'cash', 1040.00, '2024-01-27', 0, '2024-01-27 14:36:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115621, 107891, '', 'cash', 4465.00, '2024-01-27', 0, '2024-01-27 14:45:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115622, 107892, '', 'cash', 965.00, '2024-01-27', 0, '2024-01-27 14:57:04', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115623, 107893, '', 'cash', 31500.00, '2024-01-27', 0, '2024-01-27 15:00:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115624, 107894, '', 'cash', 716.50, '2024-01-27', 0, '2024-01-27 15:01:15', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115625, 107895, '', 'cash', 1605.00, '2024-01-27', 0, '2024-01-27 15:03:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115626, 107896, '', 'cash', 66000.00, '2024-01-27', 0, '2024-01-27 15:06:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115627, 107897, '', 'cash', 6870.00, '2024-01-27', 0, '2024-01-27 15:08:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115628, 107898, '', 'cash', 1000.00, '2024-01-27', 0, '2024-01-27 15:11:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115629, 107899, '', 'cash', 3232.00, '2024-01-27', 0, '2024-01-27 15:12:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115630, 107900, '', 'cash', 74220.00, '2024-01-27', 0, '2024-01-27 15:16:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115631, 107901, '', 'cash', 910.00, '2024-01-27', 0, '2024-01-27 15:28:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115632, 107902, '', 'cash', 2785.00, '2024-01-27', 0, '2024-01-27 15:44:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115633, 107903, '', 'cash', 883.04, '2024-01-27', 0, '2024-01-27 15:46:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115634, 107904, '', 'cash', 20500.00, '2024-01-27', 0, '2024-01-27 15:51:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115635, 107905, '', 'cash', 2700.00, '2024-01-27', 0, '2024-01-27 15:56:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115636, 107906, '', 'cash', 75.00, '2024-01-27', 0, '2024-01-27 15:59:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115637, 107907, '', 'cash', 160.00, '2024-01-27', 0, '2024-01-27 16:03:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115638, 107909, '', 'cash', 12365.00, '2024-01-27', 0, '2024-01-27 16:18:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115639, 107910, '', 'cash', 4020.00, '2024-01-27', 0, '2024-01-27 16:30:55', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115640, 107911, '', 'cash', 2555.00, '2024-01-27', 0, '2024-01-27 16:31:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115641, 107912, '', 'cash', 1513.00, '2024-01-27', 0, '2024-01-27 16:34:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115642, 107913, '', 'cash', 899.00, '2024-01-27', 0, '2024-01-27 16:35:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115643, 107914, '', 'cash', 3446.80, '2024-01-27', 0, '2024-01-27 16:40:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115644, 107915, '', 'cash', 46100.00, '2024-01-27', 0, '2024-01-27 16:43:12', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115645, 107916, '', 'cash', 3558.00, '2024-01-27', 0, '2024-01-27 16:44:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115646, 107917, '', 'cash', 5600.00, '2024-01-27', 0, '2024-01-27 16:47:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115647, 107918, '', 'cash', 3000.00, '2024-01-27', 0, '2024-01-27 16:47:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115648, 107919, '', 'cash', 75200.00, '2024-01-27', 0, '2024-01-27 16:49:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115649, 107920, '', 'cash', 640.00, '2024-01-27', 0, '2024-01-27 16:51:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115650, 107921, '', 'cash', 325.00, '2024-01-27', 0, '2024-01-27 16:56:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115651, 107922, '', 'cash', 882.50, '2024-01-27', 0, '2024-01-27 16:58:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115652, 107923, '', 'cash', 3332.00, '2024-01-27', 0, '2024-01-27 17:01:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115653, 107924, '', 'cash', 15000.00, '2024-01-27', 0, '2024-01-27 17:05:23', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115654, 107925, '', 'cash', 5510.00, '2024-01-27', 0, '2024-01-27 17:08:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115655, 107926, '', 'cash', 544.64, '2024-01-27', 0, '2024-01-27 17:10:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115656, 107927, '', 'cash', 800.00, '2024-01-27', 0, '2024-01-27 17:10:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115657, 107928, '', 'cash', 4710.00, '2024-01-27', 0, '2024-01-27 17:15:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115658, 107929, '', 'cash', 22340.00, '2024-01-27', 0, '2024-01-27 17:18:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115659, 107930, '', 'cash', 3960.00, '2024-01-27', 0, '2024-01-27 17:24:23', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115660, 107931, '', 'cash', 575.00, '2024-01-27', 0, '2024-01-27 17:39:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115661, 107932, '', 'cash', 208094.00, '2024-01-27', 0, '2024-01-27 17:41:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115662, 107933, '', 'cash', 144.00, '2024-01-27', 0, '2024-01-27 17:41:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115663, 107934, '', 'cash', 5000.00, '2024-01-27', 0, '2024-01-27 17:44:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115664, 107935, '', 'cash', 13400.00, '2024-01-27', 0, '2024-01-27 17:45:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115665, 107936, '', 'cash', 1824.00, '2024-01-27', 0, '2024-01-27 17:49:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115666, 107937, '', 'cash', 4340.00, '2024-01-27', 0, '2024-01-27 17:52:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115667, 107938, '', 'cash', 850.00, '2024-01-27', 0, '2024-01-27 18:00:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115668, 107939, '', 'cash', 1170.00, '2024-01-27', 0, '2024-01-27 18:01:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115669, 107940, '', 'cash', 3993.00, '2024-01-27', 0, '2024-01-27 18:03:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115670, 107941, '', 'cash', 3765.00, '2024-01-27', 0, '2024-01-27 18:05:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115671, 107942, '', 'cash', 31500.00, '2024-01-27', 0, '2024-01-27 18:06:34', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115672, 107943, '', 'cash', 1768.10, '2024-01-27', 0, '2024-01-27 18:15:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115673, 107944, '', 'cash', 7736.00, '2024-01-27', 0, '2024-01-27 18:22:23', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115674, 107945, '', 'cash', 2200.00, '2024-01-27', 0, '2024-01-27 18:34:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115675, 107946, '', 'cash', 10000.00, '2024-01-28', 0, '2024-01-28 08:16:19', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115676, 107947, '', 'cash', 55000.00, '2024-01-28', 0, '2024-01-28 08:23:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115677, 107948, '', 'cash', 2600.00, '2024-01-28', 0, '2024-01-28 08:29:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115678, 107949, '', 'cash', 6380.00, '2024-01-28', 0, '2024-01-28 08:29:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115679, 107950, '', 'cash', 20300.00, '2024-01-28', 0, '2024-01-28 08:31:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115680, 107951, '', 'cash', 18550.00, '2024-01-28', 0, '2024-01-28 08:35:12', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115681, 107952, '', 'cash', 965.60, '2024-01-28', 0, '2024-01-28 08:41:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115682, 107953, '', 'cash', 560.00, '2024-01-28', 0, '2024-01-28 08:42:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115683, 107954, '', 'cash', 81000.00, '2024-01-28', 0, '2024-01-28 08:43:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115684, 107955, '', 'cash', 385.00, '2024-01-28', 0, '2024-01-28 08:48:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115685, 107956, '', 'cash', 2760.00, '2024-01-28', 0, '2024-01-28 08:52:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115686, 107957, '', 'cash', 2432.00, '2024-01-28', 0, '2024-01-28 08:54:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115687, 107958, '', 'cash', 18490.00, '2024-01-28', 0, '2024-01-28 08:57:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115688, 107959, '', 'cash', 19970.00, '2024-01-28', 0, '2024-01-28 08:58:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115689, 107960, '', 'cash', 38100.00, '2024-01-28', 0, '2024-01-28 09:03:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115690, 107961, '', 'cash', 10055.00, '2024-01-28', 0, '2024-01-28 09:07:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115691, 107962, '', 'cash', 1025.00, '2024-01-28', 0, '2024-01-28 09:09:02', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115692, 107963, '', 'cash', 534.00, '2024-01-28', 0, '2024-01-28 09:09:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115693, 107964, '', 'cash', 44680.96, '2024-01-28', 0, '2024-01-28 09:11:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115694, 107965, '', 'cash', 1515.00, '2024-01-28', 0, '2024-01-28 09:12:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115695, 107966, '', 'cash', 760.00, '2024-01-28', 0, '2024-01-28 09:13:43', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115696, 107967, '', 'cash', 31250.00, '2024-01-28', 0, '2024-01-28 09:14:34', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115697, 107968, '', 'cash', 1180.00, '2024-01-28', 0, '2024-01-28 09:15:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115698, 107969, '', 'cash', 39145.96, '2024-01-28', 0, '2024-01-28 09:17:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115699, 107970, '', 'cash', 2400.00, '2024-01-28', 0, '2024-01-28 09:21:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115700, 107971, '', 'cash', 2790.00, '2024-01-28', 0, '2024-01-28 09:23:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115701, 107972, '', 'cash', 9350.00, '2024-01-28', 0, '2024-01-28 09:23:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115702, 107973, '', 'cash', 1450.00, '2024-01-28', 0, '2024-01-28 09:26:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115703, 107974, '', 'cash', 4837.00, '2024-01-28', 0, '2024-01-28 09:28:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115704, 107975, '', 'cash', 39400.00, '2024-01-28', 0, '2024-01-28 09:30:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115705, 107976, '', 'cash', 135900.00, '2024-01-28', 0, '2024-01-28 09:32:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115706, 107977, '', 'cash', 47100.00, '2024-01-28', 0, '2024-01-28 09:35:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115707, 107978, '', 'cash', 33225.00, '2024-01-28', 0, '2024-01-28 09:39:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115708, 107979, '', 'cash', 36686.50, '2024-01-28', 0, '2024-01-28 09:40:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115709, 107980, '', 'cash', 3994.00, '2024-01-28', 0, '2024-01-28 09:47:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115710, 107981, '', 'cash', 56250.00, '2024-01-28', 0, '2024-01-28 09:52:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115711, 107982, '', 'cash', 480.00, '2024-01-28', 0, '2024-01-28 09:58:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115712, 107983, '', 'cash', 11700.00, '2024-01-28', 0, '2024-01-28 10:00:06', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115713, 107984, '', 'cash', 2640.00, '2024-01-28', 0, '2024-01-28 10:00:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115714, 107985, '', 'cash', 600.00, '2024-01-28', 0, '2024-01-28 10:02:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115715, 107986, '', 'cash', 2720.00, '2024-01-28', 0, '2024-01-28 10:03:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115716, 107987, '', 'cash', 800.00, '2024-01-28', 0, '2024-01-28 10:11:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115717, 107988, '', 'cash', 534.00, '2024-01-28', 0, '2024-01-28 10:12:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115718, 107989, '', 'cash', 63.80, '2024-01-28', 0, '2024-01-28 10:14:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115719, 107990, '', 'cash', 280.50, '2024-01-28', 0, '2024-01-28 10:17:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115720, 107991, '', 'cash', 5600.00, '2024-01-28', 0, '2024-01-28 10:19:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115721, 107992, '', 'cash', 3000.00, '2024-01-28', 0, '2024-01-28 10:21:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115722, 107993, '', 'cash', 13910.00, '2024-01-28', 0, '2024-01-28 10:26:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115723, 107994, '', 'cash', 2643.05, '2024-01-28', 0, '2024-01-28 10:37:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115724, 107995, '', 'cash', 6522.50, '2024-01-28', 0, '2024-01-28 10:39:45', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115725, 107996, '', 'cash', 42304.20, '2024-01-28', 0, '2024-01-28 10:40:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115726, 107997, '', 'cash', 864.32, '2024-01-28', 0, '2024-01-28 10:42:05', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115727, 107998, '', 'cash', 2520.00, '2024-01-28', 0, '2024-01-28 10:44:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115728, 107999, '', 'cash', 5270.61, '2024-01-28', 0, '2024-01-28 10:47:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115729, 108000, '', 'cash', 250.00, '2024-01-28', 0, '2024-01-28 10:48:07', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115730, 108001, '', 'cash', 4290.00, '2024-01-28', 0, '2024-01-28 10:50:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115731, 108002, '', 'cash', 13337.00, '2024-01-28', 0, '2024-01-28 10:52:00', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115732, 108003, '', 'cash', 667.00, '2024-01-28', 0, '2024-01-28 10:54:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115733, 108004, '', 'cash', 1900.00, '2024-01-28', 0, '2024-01-28 10:55:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115734, 108005, '', 'cash', 4709.20, '2024-01-28', 0, '2024-01-28 10:59:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115735, 108006, '', 'cash', 6015.15, '2024-01-28', 0, '2024-01-28 11:05:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115736, 108007, '', 'cash', 260.00, '2024-01-28', 0, '2024-01-28 11:10:23', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115737, 108008, '', 'cash', 22.50, '2024-01-28', 0, '2024-01-28 11:11:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115738, 108009, '', 'cash', 11500.00, '2024-01-28', 0, '2024-01-28 11:14:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115739, 108010, '', 'cash', 26727.86, '2024-01-28', 0, '2024-01-28 11:20:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115740, 108011, '', 'cash', 26305.00, '2024-01-28', 0, '2024-01-28 11:23:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115741, 108012, '', 'cash', 26990.10, '2024-01-28', 0, '2024-01-28 11:24:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115742, 108013, '', 'cash', 477.20, '2024-01-28', 0, '2024-01-28 11:40:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115743, 108014, '', 'cash', 621.75, '2024-01-28', 0, '2024-01-28 11:42:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115744, 108015, '', 'cash', 6400.00, '2024-01-28', 0, '2024-01-28 11:42:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115745, 108016, '', 'cash', 1563.00, '2024-01-28', 0, '2024-01-28 11:44:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115746, 108017, '', 'cash', 399.60, '2024-01-28', 0, '2024-01-28 11:46:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115747, 108018, '', 'cash', 2600.00, '2024-01-28', 0, '2024-01-28 11:47:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115748, 108019, '', 'cash', 1873.32, '2024-01-28', 0, '2024-01-28 11:50:07', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115749, 108020, '', 'cash', 760.00, '2024-01-28', 0, '2024-01-28 11:52:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115750, 108021, '', 'cash', 345.00, '2024-01-28', 0, '2024-01-28 11:55:38', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115751, 108022, '', 'cash', 437.00, '2024-01-28', 0, '2024-01-28 11:59:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115752, 108023, '', 'cash', 900.00, '2024-01-28', 0, '2024-01-28 12:00:42', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115753, 108024, '', 'cash', 1388.00, '2024-01-28', 0, '2024-01-28 12:01:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115754, 108025, '', 'cash', 16500.00, '2024-01-28', 0, '2024-01-28 12:04:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115755, 108026, '', 'cash', 3295.00, '2024-01-28', 0, '2024-01-28 12:06:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115756, 108027, '', 'cash', 1088.00, '2024-01-28', 0, '2024-01-28 12:12:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115757, 108028, '', 'cash', 148.30, '2024-01-28', 0, '2024-01-28 12:14:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115758, 108029, '', 'cash', 32372.00, '2024-01-28', 0, '2024-01-28 12:14:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115759, 108030, '', 'cash', 31700.00, '2024-01-28', 0, '2024-01-28 12:21:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115760, 108031, '', 'cash', 8250.64, '2024-01-28', 0, '2024-01-28 12:25:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115761, 108032, '', 'cash', 6520.00, '2024-01-28', 0, '2024-01-28 12:27:24', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115762, 108033, '', 'cash', 66305.00, '2024-01-28', 0, '2024-01-28 12:27:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115763, 108034, '', 'cash', 5820.00, '2024-01-28', 0, '2024-01-28 12:31:45', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115764, 108035, '', 'cash', 1585.00, '2024-01-28', 0, '2024-01-28 12:37:35', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115765, 108036, '', 'cash', 2056.00, '2024-01-28', 0, '2024-01-28 12:40:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115766, 108037, '', 'cash', 1160.00, '2024-01-28', 0, '2024-01-28 12:41:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115767, 108038, '', 'cash', 923.95, '2024-01-28', 0, '2024-01-28 12:50:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115768, 108039, '', 'cash', 40100.00, '2024-01-28', 0, '2024-01-28 12:50:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115769, 108040, '', 'cash', 516.00, '2024-01-28', 0, '2024-01-28 12:54:00', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115770, 108041, '', 'cash', 1894.00, '2024-01-28', 0, '2024-01-28 13:12:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115771, 108042, '', 'cash', 1650.00, '2024-01-28', 0, '2024-01-28 13:16:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115772, 108043, '', 'cash', 10370.00, '2024-01-28', 0, '2024-01-28 13:32:11', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115773, 108044, '', 'cash', 490.00, '2024-01-28', 0, '2024-01-28 13:34:44', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115774, 108045, '', 'cash', 430.00, '2024-01-28', 0, '2024-01-28 13:36:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115775, 108046, '', 'cash', 60700.00, '2024-01-28', 0, '2024-01-28 13:36:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115776, 108047, '', 'cash', 2480.00, '2024-01-28', 0, '2024-01-28 13:39:32', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115777, 108048, '', 'cash', 2586.00, '2024-01-28', 0, '2024-01-28 13:39:50', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115778, 108049, '', 'cash', 21500.00, '2024-01-28', 0, '2024-01-28 14:01:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115779, 108050, '', 'cash', 5236.39, '2024-01-28', 0, '2024-01-28 14:09:17', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115780, 108051, '', 'cash', 2520.00, '2024-01-28', 0, '2024-01-28 14:21:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115781, 108052, '', 'cash', 7500.00, '2024-01-28', 0, '2024-01-28 14:22:12', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115782, 108053, '', 'cash', 750.00, '2024-01-28', 0, '2024-01-28 14:24:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115783, 108054, '', 'cash', 454.00, '2024-01-28', 0, '2024-01-28 14:25:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115784, 108055, '', 'cash', 13450.00, '2024-01-28', 0, '2024-01-28 14:26:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115785, 108056, '', 'cash', 14400.00, '2024-01-28', 0, '2024-01-28 14:33:25', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115786, 108057, '', 'cash', 1000.00, '2024-01-28', 0, '2024-01-28 14:45:18', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115787, 108058, '', 'cash', 9839.75, '2024-01-28', 0, '2024-01-28 14:56:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115788, 108059, '', 'cash', 56495.00, '2024-01-28', 0, '2024-01-28 14:58:13', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115789, 108060, '', 'cash', 724.00, '2024-01-28', 0, '2024-01-28 15:02:26', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115790, 108061, '', 'cash', 1068.00, '2024-01-28', 0, '2024-01-28 15:10:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115791, 108062, '', 'cash', 2790.00, '2024-01-28', 0, '2024-01-28 15:13:01', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115792, 108063, '', 'cash', 1100.00, '2024-01-28', 0, '2024-01-28 15:14:03', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115793, 108064, '', 'cash', 2440.00, '2024-01-28', 0, '2024-01-28 15:16:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115794, 108065, '', 'cash', 300.00, '2024-01-28', 0, '2024-01-28 15:25:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115795, 108066, '', 'cash', 33730.00, '2024-01-28', 0, '2024-01-28 15:28:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115796, 108067, '', 'cash', 898.40, '2024-01-28', 0, '2024-01-28 15:29:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115797, 108068, '', 'cash', 3750.00, '2024-01-28', 0, '2024-01-28 15:30:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115798, 108069, '', 'cash', 2750.00, '2024-01-28', 0, '2024-01-28 15:31:12', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115799, 108070, '', 'cash', 720.00, '2024-01-28', 0, '2024-01-28 15:32:16', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115800, 108071, '', 'cash', 2280.00, '2024-01-28', 0, '2024-01-28 15:36:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115801, 108072, '', 'cash', 1935.00, '2024-01-28', 0, '2024-01-28 15:47:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115802, 108073, '', 'cash', 2215.00, '2024-01-28', 0, '2024-01-28 15:52:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115803, 108074, '', 'cash', 2300.00, '2024-01-28', 0, '2024-01-28 15:59:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115804, 108075, '', 'cash', 2310.00, '2024-01-28', 0, '2024-01-28 16:06:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115805, 108076, '', 'cash', 1185.00, '2024-01-28', 0, '2024-01-28 16:06:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115806, 108077, '', 'cash', 4900.00, '2024-01-28', 0, '2024-01-28 16:12:33', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115807, 108078, '', 'cash', 49960.00, '2024-01-28', 0, '2024-01-28 16:14:27', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115808, 108079, '', 'cash', 1214.00, '2024-01-28', 0, '2024-01-28 16:14:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115809, 108080, '', 'cash', 1216.00, '2024-01-28', 0, '2024-01-28 16:22:10', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115810, 108081, '', 'cash', 7595.00, '2024-01-28', 0, '2024-01-28 16:28:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115811, 108082, '', 'cash', 50120.00, '2024-01-28', 0, '2024-01-28 16:28:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115812, 108083, '', 'cash', 975.00, '2024-01-28', 0, '2024-01-28 16:31:56', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115813, 108085, '', 'cash', 975.00, '2024-01-28', 0, '2024-01-28 16:33:51', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115814, 108086, '', 'cash', 885.00, '2024-01-28', 0, '2024-01-28 16:43:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115815, 108087, '', 'cash', 11000.00, '2024-01-28', 0, '2024-01-28 16:44:49', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115816, 108088, '', 'cash', 5094.00, '2024-01-28', 0, '2024-01-28 16:44:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115817, 108089, '', 'cash', 300.00, '2024-01-28', 0, '2024-01-28 16:45:30', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115818, 108090, '', 'cash', 1745.00, '2024-01-28', 0, '2024-01-28 16:49:29', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115819, 108091, '', 'cash', 31200.00, '2024-01-28', 0, '2024-01-28 16:49:31', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115820, 108092, '', 'cash', 295.00, '2024-01-28', 0, '2024-01-28 16:50:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115821, 108093, '', 'cash', 2680.00, '2024-01-28', 0, '2024-01-28 16:51:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115822, 108094, '', 'cash', 4400.00, '2024-01-28', 0, '2024-01-28 16:55:09', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115823, 108095, '', 'cash', 780.00, '2024-01-28', 0, '2024-01-28 17:05:28', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115824, 108096, '', 'cash', 988.75, '2024-01-28', 0, '2024-01-28 17:09:20', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115825, 108097, '', 'cash', 6115.00, '2024-01-28', 0, '2024-01-28 17:21:48', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115826, 108098, '', 'cash', 900.00, '2024-01-28', 0, '2024-01-28 17:23:08', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115827, 108099, '', 'cash', 1000.00, '2024-01-28', 0, '2024-01-28 17:23:36', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115828, 108100, '', 'cash', 7530.00, '2024-01-28', 0, '2024-01-28 17:26:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115829, 108101, '', 'cash', 1700.00, '2024-01-28', 0, '2024-01-28 17:27:21', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115830, 108102, '', 'cash', 1825.00, '2024-01-28', 0, '2024-01-28 17:29:46', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115831, 108103, '', 'cash', 20800.00, '2024-01-28', 0, '2024-01-28 17:31:59', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115832, 108104, '', 'cash', 4400.00, '2024-01-28', 0, '2024-01-28 17:32:53', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115833, 108105, '', 'cash', 3680.00, '2024-01-28', 0, '2024-01-28 17:33:52', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115834, 108106, '', 'cash', 3975.00, '2024-01-28', 0, '2024-01-28 17:35:58', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115835, 108107, '', 'cash', 358.80, '2024-01-28', 0, '2024-01-28 17:39:40', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115836, 108108, '', 'cash', 4190.00, '2024-01-28', 0, '2024-01-28 17:39:54', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115837, 108109, '', 'cash', 1026.00, '2024-01-28', 0, '2024-01-28 17:46:57', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115838, 108110, '', 'cash', 2950.00, '2024-01-28', 0, '2024-01-28 17:48:37', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115839, 108111, '', 'cash', 13800.00, '2024-01-28', 0, '2024-01-28 17:56:41', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115840, 108112, '', 'cash', 7500.00, '2024-01-28', 0, '2024-01-28 17:57:22', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115841, 108113, '', 'cash', 2736.00, '2024-01-28', 0, '2024-01-28 18:17:07', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115842, 108114, '', 'cash', 5094.00, '2024-01-28', 0, '2024-01-28 18:17:47', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0),
(115843, 108115, '', 'cash', 2490.00, '2024-01-28', 0, '2024-01-28 18:25:39', '', '', '0000-00-00', '', '', 'visa', '', '', 'sale', 0.00, 0.00, 0);

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `service_id` int NOT NULL,
  `service_responsible_person` varchar(150) NOT NULL,
  `service_customer_id` int NOT NULL,
  `product_charge_type` varchar(50) NOT NULL,
  `service_diposit` decimal(25,2) NOT NULL,
  `service_return_date` date NOT NULL,
  `service_reference_no` varchar(55) DEFAULT '0',
  `warehouse_id` int NOT NULL,
  `service_datetime` date NOT NULL,
  `service_note` varchar(1000) DEFAULT '0',
  `service_inv_total` decimal(25,2) NOT NULL,
  `service_total` decimal(25,2) NOT NULL,
  `service_inv_discount` varchar(20) DEFAULT '0',
  `service_discount` varchar(50) NOT NULL,
  `service_discount_amt` decimal(10,0) NOT NULL,
  `service_vat` decimal(10,0) NOT NULL,
  `service_net_total` decimal(10,0) NOT NULL,
  `service_inv_discount_amount` decimal(25,2) NOT NULL,
  `cus_name` varchar(100) NOT NULL,
  `user_id` int DEFAULT '0',
  `service_datetime_created` datetime NOT NULL,
  `service_prepared_status` varchar(50) NOT NULL DEFAULT '0',
  `service_authorized_status` varchar(50) NOT NULL,
  `service_checked_status` varchar(50) NOT NULL DEFAULT '0',
  `service_approved_status` varchar(50) NOT NULL DEFAULT '0',
  `nature_of_work` varchar(255) NOT NULL,
  `current_mileage` varchar(100) NOT NULL,
  `prepared_user` int NOT NULL,
  `prepared_status` varchar(30) NOT NULL,
  `approved_status` varchar(30) NOT NULL,
  `approved_user` int NOT NULL,
  `reserved_status` varchar(30) NOT NULL,
  `reserved_user` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `service_items`
--

CREATE TABLE `service_items` (
  `serviceitm_id` int NOT NULL,
  `service_id` int NOT NULL,
  `product_id` int NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `product_unit` varchar(50) NOT NULL,
  `product_service_charge` decimal(10,0) NOT NULL,
  `serviceitm_qty` decimal(10,2) NOT NULL,
  `serviceitm_dis` varchar(20) NOT NULL,
  `serviceitm_dis_val` decimal(10,0) NOT NULL,
  `serviceitm_added_date` date NOT NULL,
  `sub_total_item` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `supp_id` int NOT NULL,
  `cr_limit_id` int DEFAULT '0',
  `country_id` int DEFAULT '0',
  `supp_company_name` varchar(150) DEFAULT '0',
  `supp_code` varchar(50) NOT NULL,
  `supp_company_phone` varchar(50) DEFAULT '0',
  `supp_city` int DEFAULT '0',
  `supp_state` varchar(150) DEFAULT '0',
  `supp_fax` varchar(50) DEFAULT '0',
  `supp_postal_code` varchar(50) DEFAULT '0',
  `supp_address` varchar(100) DEFAULT '0',
  `supp_email` varchar(100) DEFAULT '0',
  `supp_contact_person_name` varchar(150) DEFAULT '0',
  `supp_contact_person_phone` varchar(50) DEFAULT '0',
  `supp_contact_person_email` varchar(50) DEFAULT '0',
  `supp_bank` varchar(50) DEFAULT '0',
  `supp_bank_branch` varchar(50) DEFAULT '0',
  `supp_account_number` varchar(150) DEFAULT '0',
  `supp_credit_period` varchar(100) DEFAULT '0',
  `supp_status` int DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`supp_id`, `cr_limit_id`, `country_id`, `supp_company_name`, `supp_code`, `supp_company_phone`, `supp_city`, `supp_state`, `supp_fax`, `supp_postal_code`, `supp_address`, `supp_email`, `supp_contact_person_name`, `supp_contact_person_phone`, `supp_contact_person_email`, `supp_bank`, `supp_bank_branch`, `supp_account_number`, `supp_credit_period`, `supp_status`) VALUES
(1, 0, 251, 'NILKAMAL', '04', '0778144782', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(2, 0, 251, 'KENTEN', '05', '0777199764', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(3, 0, 251, 'COLOMBO', '07', '0112331405', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(4, 0, 251, 'COLOMBO (CLOTHES)', '08', '0773753808', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(5, 0, 251, 'SILVER', '09', '0768234641', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(6, 0, 251, 'SST', '10', '0773627552', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(7, 0, 251, 'ALUMINIUM', '11', ' 0779466096', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(8, 0, 251, 'SAMADEE', '13', '0773496600', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(9, 0, 251, 'JAYARATHNA', '15', '0773612977', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(10, 0, 251, 'RICHSONIC ', '18', '0773867269', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(11, 0, 251, 'TAIKO', '19', '0772386920', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(12, 0, 251, 'OLIVE', '21', '0772674194', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(13, 0, 251, 'LAUGFS', '23', '0776489754', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(14, 0, 251, 'DISANAYAKA', '24', '0779840418', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(15, 0, 251, 'LAKTHARA', '26', '0713173625', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(16, 0, 251, 'PUJITHA', '28', '0774784430', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(17, 0, 251, 'JANAKA', '30', '0767274646', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(18, 0, 251, 'PILLOW', '31', '0778819197', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(19, 0, 251, 'RAJAPAKSHA', '32', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(20, 0, 251, 'MEEGODA ALMARI', '33', '0714132169', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(21, 0, 251, 'DINESH ALMARI', '34', '0710563080', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(22, 0, 251, 'AMILA', '35', '0779856483', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(23, 0, 251, 'TEAK BED', '36', '0112757241', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(24, 0, 251, 'DARANI ', '37', '0772280062', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(25, 0, 251, 'SIGIRI', '38', '0766036710', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(26, 0, 251, 'TST', '39', '0779008584', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(27, 0, 251, 'DUMALA', '41  ', '0774307660', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(28, 0, 251, 'HEMANTHA (PTS)', '42', '0776021807', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(29, 0, 251, 'FRIENDS', '43', '0752494737', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(30, 0, 251, 'SONICO', '44', '0776667001', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(31, 0, 251, 'DOLL', '45', '0778674095', 0, '', '', '', 'PADUKKA', '', '', '', '', '', '', '', '', 1),
(32, 0, 251, 'LIBRARY CUPBOARD', '46', '0779173390', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(33, 0, 251, 'NILMINI NET', '47', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(34, 0, 251, 'ASIAN', '48', '0776223678', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(35, 0, 251, 'MALSHA DRILL', '49(I)', '0779921046', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(36, 0, 251, 'PUREIT FILTER', '49(II)', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(37, 0, 251, 'SUN FLOWER (KDM)', '49(III)', '0779583872', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(38, 0, 251, 'PITTHALA', '49(IV)', '0812575062', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(39, 0, 251, 'TRICYCLE', '49(v)', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(40, 0, 251, 'SAWANDI', '49(VI)', '0771570326', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(41, 0, 251, 'SAHANSA (T. STEEL)', '49(VII)', '0712151599', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(42, 0, 251, 'SUNIL (WATTI)', '49(VIII)', '0712306585', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(43, 0, 251, 'TVS (GLASS)', '49(IX)', '0775785345', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(44, 0, 251, 'VST', '49(X)', '0713550411', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(45, 0, 251, 'BANKU HIRAMANA', '49(XI)', '0723333076', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(46, 0, 251, 'TRAVELING BAG', '49(XII)', '0716255003', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(47, 0, 251, 'ASIRI MAL POCHCHI', '49(XIII)', '0771346935', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(48, 0, 251, 'NADEESHAN', '52(I)', '0757298093', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(49, 0, 251, 'KAWASHI', '52(II)', '0773274426', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(50, 0, 251, 'LAKSHAPANA', '52(III)', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(51, 0, 251, 'MITHSU', '52(IV)', '0773655988', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(52, 0, 251, 'EKANAYAKA', '52(v)', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(53, 0, 251, 'DULAN', '52(VI)', '0779515144', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(54, 0, 251, 'AR (M)', '02', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(55, 0, 251, 'PH', '03', '0773185064', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(56, 0, 251, 'DSI', '06', '0772910510', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(57, 0, 251, 'RN TRADING', '12', '0714197552', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(58, 0, 251, 'AMI', '14', '0771513914', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(59, 0, 251, 'RIK', '16', '0773210262', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(60, 0, 251, 'ORIN', '17', '0774498119', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(61, 0, 251, 'SHELL', '22', '0112752761', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(62, 0, 251, 'ALCO', '25', '0773843804', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(63, 0, 251, 'PIY', '01(I)', '0773671702', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(64, 0, 251, 'INN', '01(II)', '0773671702', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(65, 0, 251, 'DAX', '01(III)', '0773671702', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(66, 0, 251, 'SAMPATH ENTERPRISES', '53', '', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(67, 0, 251, 'SAMPATH ENTERPRISES (2)', '54', '', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(68, 0, 251, 'SAMPATH ENTERPRISES (3)', '55', '', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(69, 0, 251, 'SAMPATH ENTERPRISES (4)', '56', '', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(70, 0, 251, 'SAMPATH ENTERPRISES (5)', '57', '', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(71, 0, 251, 'AR (T)', '02 (I)', '0', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(72, 0, 251, 'NEW RETURN', '58', '0777371176', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(73, 0, 251, 'SHIRAN', '59', '077', 0, '', '', '', 'MEEEGODA', '', '', '', '', '', '', '', '', 1),
(74, 0, 251, 'POOLUX', '60', '077', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(75, 0, 251, 'IMITIAS ', '61', '0770226448', 0, '', '', '', 'COLOMBO', '', '', '', '', '', '', '', '', 1),
(76, 0, 251, 'BOX KNIFE', '62', '0', 0, '', '', '', 'COLOMBO', '', '', '', '', '', '', '', '', 1),
(77, 0, 251, 'ENEX', '63', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(78, 0, 251, 'PH (P)', '64', '0', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(79, 0, 251, 'CAMY ', '65', '0', 0, '', '', '', 'COLOMBO', '', '', '', '', '', '', '', '', 1),
(80, 0, 251, 'SN BEERALU', '66', '0', 0, '', '', '', 'PILIYANDALA', '', '', '', '', '', '', '', '', 1),
(81, 0, 251, 'PRINCE SPORTS', '70', '0778288841', 0, '', '', '', 'KALAGEDIHENA', '', '', '', '', '', '', '', '', 1),
(82, 0, 251, 'CTC', '71', '0', 0, '', '', '', 'ANURADHAPURA', '', '', '', '', '', '', '', '', 1),
(83, 0, 251, 'LANKA POLY BAGS', '72', '0114332310', 0, '', '', '', 'WATTHALA', '', '', '', '', '', '', '', '', 1),
(84, 0, 251, 'SINERU ', '73', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(85, 0, 251, 'GALAGEDARA SHOWROOM', '74', '774569056', 0, '', '', '', 'GALAGEDARA', '', '', '', '', '', '', '', '', 1),
(86, 0, 251, 'THUVA TRADERS', '75', '0777375229', 0, '', '', '', 'COLOMBO 12', '', '', '', '', '', '', '', '', 1),
(87, 0, 251, 'LEGEND ', '76', '0', 0, '', '', '', 'COLOMBO', '', '', '', '', '', '', '', '', 1),
(88, 0, 251, 'SRI LANKA TRADERS', '77', '0774400344/0778294402', 0, '', '', '', 'MAHARAGAMA', '', '', '', '', '', '', '', '', 1),
(89, 0, 251, 'MANATHUNGA UNCLE ', '78', '0', 0, '', '', '', 'HOMAGAMA', '', '', '', '', '', '', '', '', 1),
(90, 0, 251, 'CMC', '79', '0768691448', 0, '', '', '', 'GODAGAMA', '', '', '', '', '', '', '', '', 1),
(91, 0, 251, 'WAJIRA', '80', '0769416086', 0, '', '', '', 'WATERAKA ', '', '', '', '', '', '', '', '', 1),
(93, 0, 251, 'LASANTHA CLOTH', '81', '0', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(94, 0, 251, 'MOHAN ENTERPRISES', '82', '0715640400', 0, '', '', '', 'MEEGODA', '', '', '', '', '', '', '', '', 1),
(95, 0, 251, 'SUMITH (RN)', '83', '0714197552', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(96, 0, 251, 'BABY & BABY', '84', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(97, 0, 251, 'JTC', '85', '0', 0, '', '', '', 'MEEGODA ', '', '', '', '', '', '', '', '', 1),
(98, 0, 251, 'UNIVERSAL LANKA', '86', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(99, 0, 251, 'HELENSTRO', '87', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(100, 0, 251, 'RANGE ', '88', '0', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(101, 0, 251, 'GAGANI FURNICURE', '89', '0729819490', 0, '', '', '', '0', '', '', '', '', '', '', '', '', 1),
(102, 0, 251, 'KUNDAN', '90', '0', 0, '', '', '', 'COLOMBO', '', '', '', '', '', '', '', '', 1),
(103, 0, 251, 'ASD', 'ASD', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(104, 0, 251, 'ALVIS', 'ALVS', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(105, 0, 251, 'ST. ANTHONY\'S COATINGS (PVT) LTD', '0001', '0112691897', 0, '', '', '', '752/5 DR.DANISTER DE SILVA MW, COLOMBO 10', '', '', '0772930012', '', '', '', '', '', 1),
(106, 0, 251, 'SINVA ADHESIVES (PVT) LTD', '0002', '0112767888', 0, '', '', '', '15, SIRIWARDANA RD, DEHIWALA', '', '', '0773469736', '', '', '', '', '', 1),
(107, 0, 251, 'POLYCROME', '0003', '', 0, '', '', '', '50/A , KIRIDIWELA RD , YAKKALA', '', '', '0764405706', '', '', '', '', '', 1),
(108, 0, 251, 'JINASENA HARDWARE', '0004', '0332222421', 0, '', '', '', 'GAMPAHA', '', '', '0776368014', '', '', '', '', '', 1),
(109, 0, 251, 'TITAN DISTRIBUTES', '0005', '0112956261', 0, '', '', '', 'NO16, GUNASEKARA, MATTHUMAGALA, RAGAMA', '', '', '0710381307', '', '', '', '', '', 1),
(110, 0, 251, 'ANURADHA ENTERPRISES', '0006', '', 0, '', '', '', 'URAPOLA', '', '', '0701996026', '', '', '', '', '', 1),
(111, 0, 251, 'SOLEX MARKETING (PVT) LTD', '0007', '0112931407', 0, '', '', '', 'NO39, NEW NUGE RD, PELIYAGODA', '', '', '0701187622', '', '', '', '', '', 1),
(112, 0, 251, 'ROYAL PAINTS LANKA (PVT) LTD', '0008', '0332237513', 0, '', '', '', '271/1 ISURU UYANA, BATAPOTHA, GAMPAHA', '', '', '0761373919', '', '', '', '', '', 1),
(113, 0, 251, 'MAHESHAN HARDWARE', '0009', '0332298498', 0, '', '', '', 'MAGALEGODA, WEYANGODA', '', '', '0777766562', '', '', '', '', '', 1),
(114, 0, 251, 'LIYANAGE ENTERPRISES ', '0010', '0334944880', 0, '', '', '', 'GAMPAHA', '', '', '0766450539', '', '', '', '', '', 1),
(115, 0, 251, 'NIPPOLAC ', 'NPPON01', '011-4600400', 0, '', '', '', 'NO.69 A,BUTHGAMUWA RD,RAJAGIRIYA.', '', '', '', '', '', '', '', '', 1),
(116, 0, 251, 'SUPRA CHEMICAL INDUSTRIES', 'SUPRA01', '0777-570513', 0, '', '', '', '102/A, KAHANTHOTA RD, MALABE.', '', '', '', '', '', '', '', '', 1),
(117, 0, 251, 'SWISSTEK (CEYLON) PLC', 'SWISSTEK01', '011-2912987', 0, '', '', '', 'NO.293/1B, KANDY ROAD, GALLA JUNCTION, KIRIBATHGODA.', '', '', '', '', '', '', '', '', 1),
(118, 0, 251, 'JINASENA (PVT)  LTD', 'JINASENA001', '', 0, '', '', '', 'NO.186,ELVITIGALA MW,COLOMBO 08.', '', '', '', '', '', '', '', '', 1),
(119, 0, 251, 'POLYCROME', 'POLYCROME', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(120, 0, 251, 'A.S.D TRADING', 'ASD1', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(121, 0, 251, 'MACO PAINT & CHEMICAL INDUSTRIES', 'MACO001', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(122, 0, 251, 'NATURE PAINTS & CHEMICAL INDUSTRES', 'NATURE', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(123, 0, 251, 'ACL CABLES', 'ACL', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1),
(124, 0, 251, 'TITAN ENTERPRICES', 'TITAN', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1);

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

--
-- Table structure for table `table 42`
--

CREATE TABLE `table 42` (
  `COL 1` varchar(9) DEFAULT '0',
  `COL 2` varchar(12) DEFAULT '0',
  `COL 3` varchar(31) DEFAULT '0',
  `COL 4` varchar(5) DEFAULT '0',
  `COL 5` varchar(4) DEFAULT '0',
  `COL 6` varchar(10) DEFAULT '0',
  `COL 7` varchar(10) DEFAULT '0',
  `COL 8` varchar(3) DEFAULT '0',
  `COL 9` varchar(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `table 42`
--

INSERT INTO `table 42` (`COL 1`, `COL 2`, `COL 3`, `COL 4`, `COL 5`, `COL 6`, `COL 7`, `COL 8`, `COL 9`) VALUES
('ACESSORY', 'TAPE', 'ABRO TAPE', '180', '220', '', '', '180', '720'),
('ACESSORY', 'TAPE', 'REKIN TAPE', '65', '80', '', '', '50', '100'),
('ACESSORY', 'TAPE', 'DOUBLE TAPE 3M 1 INCH', '1200', '1450', '', '', '10', '20'),
('ACESSORY', 'TAPE', 'DOUBLE TAPE 3M 1/2  INCH', '1100', '1275', '', '', '10', '20'),
('ACESSORY', 'TAPE', 'DOUBLE TAPE 3M 1/2  INCH 5METER', '460', '500', '', '', '10', '15'),
('ACESSORY', 'TAPE', 'DOUBLE TAPE LOCAL 1 INCH', '350', '450', '', '', '5', '10'),
('ACESSORY', 'TAPE', 'DOUBLE TAPE LOCAL 1/2 INCH', '175', '275', '', '', '10', '15'),
('ACESSORY', 'TAPE', 'JOINT TAPE 100M', '0', '0', '', '', '0', '0'),
('ACESSORY', 'TAPE', 'JOINT TAPE 75M', '0', '0', '', '', '0', '0'),
('ACESSORY', 'TAPE', 'JOINT TAPE 50M', '0', '0', '', '', '0', '0'),
('ACESSORY', 'TAPE', 'JOINT TAPE 25M', '0', '0', '', '', '0', '0'),
('', '', '', '', '', '', '', '', ''),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'CUTTING DISC', 'ALMT CUTTING DISC 4 1/2 INCH', '130', '140', '', '', '10', '15'),
('ACESSORY', 'CUTTING DISC', 'ALMT CUTTING DISC 4  INCH', '100', '120', '', '', '10', '15'),
('ACESSORY', 'BRUSH', 'CUP BRUSH', '250', '325', '', '', '3', '6'),
('ACESSORY', 'BRUSH', 'WIRE BRUSH', '243.7', '325', '', '', '3', '6'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'GUM', 'GIRB 500ML', '562.5', '750', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MULTIBOND E-FIX 100G', '112.5', '150', '', '', '4', '8'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'GUM', 'MULTIBOND 1LTR     494', '671.2', '895', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MULTIBOND 500ML 494', '345', '460', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MULTIBOND 250ML 494', '202.5', '270', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MULTIBOND 100ML 494', '116.2', '155', '', '', '4', '8'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'GUM', 'MACKBOND 1LTR     369', '1410', '1880', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MACKBOND 500ML 369', '780', '1040', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MACKBOND 250ML 369', '255', '340', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MACKBOND 100ML 369', '120', '160', '', '', '4', '8'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'GUM', 'MACKBOND 1LTR     464', '585', '780', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MACKBOND 500ML 464', '187.5', '250', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MACKBOND 250ML 464', '108.7', '145', '', '', '4', '8'),
('ACESSORY', 'GUM', 'MACKBOND 100ML 464', '75', '100', '', '', '4', '8'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'SPRAY GUN', 'FAZAL HIGH PRESSURE GUN', '787.5', '1050', '', '', '2', '6'),
('ACESSORY', 'SPRAY GUN', 'VOYLET HVLP SPARAY GUN', '2550', '3400', '', '', '2', '6'),
('ACESSORY', 'SPRAY GUN', 'ALMT HIGH PRESURE GUN', '1275', '1700', '', '', '2', '6'),
('ACESSORY', 'SPRAY GUN', 'F75 SPRAY GUN', '1387.', '1850', '', '', '2', '6'),
('ACESSORY', 'SPRAY GUN', 'F75 PC4', '1275', '1700', '', '', '2', '6'),
('ACESSORY', 'SPRAY GUN', 'ALMT PC4', '1387.', '1850', '', '', '2', '6'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'SCAPERS', 'ALMT SCAPERS 3 INCH', '75', '100', '', '', '6', '12'),
('ACESSORY', 'SCAPERS', 'ALMT SCAPERS 2 INCH', '75', '100', '', '', '6', '12'),
('ACESSORY', 'SCAPERS', 'ALMT SCAPERS 1 INCH', '75', '100', '', '', '6', '12'),
('', '', '', '', '', '', '', '', ''),
('ACESSORY', 'SCAPERS', 'PLASTIC SACPERS', '90', '120', '', '', '6', '12'),
('', '', '', '', '', '', '', '', ''),
('', '', '', '', '', '', '', '', ''),
('', '', '', '', '', '', '', '', ''),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 100', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 120', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 150', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 180', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 220', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 240', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 280', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 320', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 400', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 600', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 800', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 1000', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 1200', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 1500', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 2000', '42.5', '75', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS BLACK 2500', '42.5', '75', '', '', '30', '50'),
('', '', ' ', '', '', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS WHITE 40', '47.5', '60', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS WHITE 60', '47.5', '60', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS WHITE 80', '47.5', '60', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS WHITE 100', '47.5', '60', '', '', '30', '50'),
('ACESSOERY', 'SAND PAPER', 'SAND PAPERS WHITE 120', '47.5', '60', '', '', '30', '50');

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

--
-- Table structure for table `TABLE 53`
--

CREATE TABLE `TABLE 53` (
  `COL 1` varchar(13) DEFAULT NULL,
  `COL 2` varchar(5) DEFAULT NULL,
  `COL 3` varchar(36) DEFAULT NULL,
  `COL 4` decimal(6,1) DEFAULT NULL,
  `COL 5` int DEFAULT NULL,
  `COL 6` int DEFAULT NULL,
  `COL 7` int DEFAULT NULL,
  `COL 8` int DEFAULT NULL,
  `COL 9` int DEFAULT NULL,
  `COL 10` int DEFAULT NULL,
  `COL 11` int DEFAULT NULL,
  `COL 12` varchar(4) DEFAULT NULL,
  `COL 13` varchar(6) DEFAULT NULL,
  `COL 14` varchar(4) DEFAULT NULL,
  `COL 15` varchar(3) DEFAULT NULL,
  `COL 16` varchar(3) DEFAULT NULL,
  `COL 17` varchar(15) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `TABLE 53`
--

INSERT INTO `TABLE 53` (`COL 1`, `COL 2`, `COL 3`, `COL 4`, `COL 5`, `COL 6`, `COL 7`, `COL 8`, `COL 9`, `COL 10`, `COL 11`, `COL 12`, `COL 13`, `COL 14`, `COL 15`, `COL 16`, `COL 17`) VALUES
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BRILLIANT WHITE 1L', 747.5, 1150, 6, 0, 1, 10, 1150, 1150, 'NONE', 'THAMES', 'THMS', 'PNT', '1L', 'BRILLIANT WHITE'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BLACK 1L', 747.5, 1150, 6, 0, 1, 10, 1150, 1150, 'NONE', 'THAMES', 'THMS', 'PNT', '1L', 'BLACK'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BRILLIANT WHITE 4L', 2892.5, 4450, 6, 0, 1, 10, 4450, 4450, 'NONE', 'THAMES', 'THMS', 'PNT', '4L', 'BRILLIANT WHITE'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BLACK 4L', 2892.5, 4450, 6, 0, 1, 10, 4450, 4450, 'NONE', 'THAMES', 'THMS', 'PNT', '4L', 'BLACK'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BRILLIANT WHITE 10L', 6922.5, 10650, 6, 0, 1, 10, 10650, 10650, 'NONE', 'THAMES', 'THMS', 'PNT', '10L', 'BRILLIANT WHITE'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BLACK 10L', 6922.5, 10650, 6, 0, 1, 10, 10650, 10650, 'NONE', 'THAMES', 'THMS', 'PNT', '10L', 'BLACK'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BRILLIANT WHITE 20L', 13682.5, 21050, 6, 0, 1, 10, 21050, 21050, 'NONE', 'THAMES', 'THMS', 'PNT', '20L', 'BRILLIANT WHITE'),
('WATERPROOFING', 'PAINT', 'THAMES AQUASEALE BLACK 20L', 13682.5, 21050, 6, 0, 1, 10, 21050, 21050, 'NONE', 'THAMES', 'THMS', 'PNT', '20L', 'BLACK');

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

--
-- Table structure for table `TABLE 54`
--

CREATE TABLE `TABLE 54` (
  `COL 1` varchar(9) DEFAULT NULL,
  `COL 2` varchar(22) DEFAULT NULL,
  `COL 3` varchar(31) DEFAULT NULL,
  `COL 4` decimal(5,2) DEFAULT NULL,
  `COL 5` decimal(5,2) DEFAULT NULL,
  `COL 6` int DEFAULT NULL,
  `COL 7` int DEFAULT NULL,
  `COL 8` int DEFAULT NULL,
  `COL 9` int DEFAULT NULL,
  `COL 10` decimal(5,2) DEFAULT NULL,
  `COL 11` decimal(5,2) DEFAULT NULL,
  `COL 12` varchar(4) DEFAULT NULL,
  `COL 13` varchar(9) DEFAULT NULL,
  `COL 14` varchar(4) DEFAULT NULL,
  `COL 15` varchar(6) DEFAULT NULL,
  `COL 16` varchar(10) DEFAULT NULL,
  `COL 17` varchar(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `TABLE 54`
--

INSERT INTO `TABLE 54` (`COL 1`, `COL 2`, `COL 3`, `COL 4`, `COL 5`, `COL 6`, `COL 7`, `COL 8`, `COL 9`, `COL 10`, `COL 11`, `COL 12`, `COL 13`, `COL 14`, `COL 15`, `COL 16`, `COL 17`) VALUES
('ALUMINIUM', 'LADDER', 'POLYGLASS LADDER 4', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'LDR', '4', '.'),
('ALUMINIUM', 'LADDER', 'POLYGLASS LADDER 5', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'LDR', '5', '.'),
('ALUMINIUM', 'LADDER', 'POLYGLASS LADDER 6', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'LDR', '6', '.'),
('ALUMINIUM', 'LADDER', 'POLYGLASS LADDER 7', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'LDR', '7', '.'),
('ALUMINIUM', 'LADDER', 'POLYGLASS LADDER 8', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'LDR', '8', '.'),
('ALUMINIUM', 'LADDER', 'POLYGLASS LADDER 10', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'LDR', '10', '.'),
('ALUMINIUM', 'STEP LADDER', 'POLYGLASS STEP LADDER 20', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'STLD', '20', '.'),
('ALUMINIUM', 'STEP LADDER', 'POLYGLASS STEP LADDER DOUBLE 10', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'POLYGLASS', 'PLGS', 'STLD', '10', '.'),
('ALUMINIUM', 'MAIN T-BAR', 'T-BAR 12 WHITE', 230.00, 275.00, 6, 0, 1, 10, 275.00, 275.00, 'NONE', 'CHINESE', 'CHN', 'MTB', '12', 'WHITE'),
('ALUMINIUM', 'MAIN T-BAR', 'T-BAR 12 BLACK', 255.00, 295.00, 6, 0, 1, 10, 295.00, 295.00, 'NONE', 'CHINESE', 'CHN', 'MTB', '12', 'BLACK'),
('ALUMINIUM', 'COST T-BAR', 'T-BAR 4 WHITE', 75.00, 95.00, 6, 0, 1, 10, 95.00, 95.00, 'NONE', 'CHINESE', 'CHN', 'CTB', '4', 'WHITE'),
('ALUMINIUM', 'COST T-BAR', 'T-BAR 4 BLACK', 78.00, 110.00, 6, 0, 1, 10, 110.00, 110.00, 'NONE', 'CHINESE', 'CHN', 'CTB', '4', 'BLACK'),
('ALUMINIUM', 'COST T-BAR', 'T-BAR 2 WHITE', 42.00, 65.00, 6, 0, 1, 10, 65.00, 65.00, 'NONE', 'CHINESE', 'CHN', 'CTB', '2', 'WHITE'),
('ALUMINIUM', 'COST T-BAR', 'T-BAR 2 BLACK', 50.00, 75.00, 6, 0, 1, 10, 75.00, 75.00, 'NONE', 'CHINESE', 'CHN', 'CTB', '2', 'BLACK'),
('ALUMINIUM', 'T-BAR', 'T-BAR 12 WHITE', 337.00, 420.00, 6, 0, 1, 10, 420.00, 420.00, 'NONE', 'CHINESE', 'CHN', 'TBR', '12', 'WHITE'),
('ALUMINIUM', 'T-BAR', 'T-BAR 12 SILVER', 285.00, 325.00, 6, 0, 1, 10, 325.00, 325.00, 'NONE', 'CHINESE', 'CHN', 'TBR', '12', 'SILVER'),
('ALUMINIUM', 'WALL ANGLE', 'WALL ANGLE', 143.00, 180.00, 6, 0, 1, 10, 180.00, 180.00, 'NONE', 'CHINESE', 'CHN', 'WLAN', '', '.'),
('ALUMINIUM', 'L-ANGLE', 'L-ANGLE 1 X 1', 375.00, 410.00, 6, 0, 1, 10, 410.00, 410.00, 'NONE', 'CHINESE', 'CHN', 'LANG', '1 X 1', '.'),
('ALUMINIUM', 'L-ANGLE', 'L-ANGLE 3/4 X 3/4', 390.00, 430.00, 6, 0, 1, 10, 430.00, 430.00, 'NONE', 'CHINESE', 'CHN', 'LANG', '3/4 X 3/4', '.'),
('ALUMINIUM', 'L-ANGLE', 'L-ANGLE 1/2 X 1/2', 165.00, 210.00, 6, 0, 1, 10, 210.00, 210.00, 'NONE', 'CHINESE', 'CHN', 'LANG', '1/2 X 1/2', '.'),
('ALUMINIUM', 'BOXBAR', 'BOXBAR LITE 2 X 1', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'BXBR', '2 X 1', 'LITE'),
('ALUMINIUM', 'BOXBAR', 'BOXBAR HEAVY 2 X 1', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'BXBR', '2 X 1', 'HEAVY'),
('ALUMINIUM', 'CURTAIN BAR', 'CURTAIN BAR', 450.00, 550.00, 6, 0, 1, 10, 550.00, 550.00, 'NONE', 'CHINESE', 'CHN', 'CRBR', '', '.'),
('ALUMINIUM', 'CURTAIN RUNNERS', 'CURTAIN RUNNERS', 1.00, 2.50, 6, 0, 1, 10, 2.50, 2.50, 'NONE', 'CHINESE', 'CHN', 'CRRN', '', '.'),
('ALUMINIUM', 'CURTAIN HOOCKS', 'CURTAIN HOOCKS', 1.00, 2.50, 6, 0, 1, 10, 2.50, 2.50, 'NONE', 'CHINESE', 'CHN', 'CRHK', '', '.'),
('ALUMINIUM', 'CURTAIN N-CAP', 'CURTAIN N-CAP', 5.50, 12.00, 6, 0, 1, 10, 12.00, 12.00, 'NONE', 'CHINESE', 'CHN', 'CRNC', '', '.'),
('ALUMINIUM', 'CURTAIN BRACKET', 'CURTAIN BRACKET', 15.00, 25.00, 6, 0, 1, 10, 25.00, 25.00, 'NONE', 'CHINESE', 'CHN', 'CRBK', '', '.'),
('ALUMINIUM', 'CURTAIN DOUBLE BRACKET', 'CURTAIN DOUBLE BRACKET', 45.00, 65.00, 6, 0, 1, 10, 65.00, 65.00, 'NONE', 'CHINESE', 'CHN', 'CRDB', '', '.'),
('ALUMINIUM', 'TILE PATI', 'TILE PATI LITE', 135.00, 200.00, 6, 0, 1, 10, 200.00, 200.00, 'NONE', 'CHINESE', 'CHN', 'TP', '', '.'),
('ALUMINIUM', 'TILE PATI', 'TILE PATI HEAVY', 230.00, 350.00, 6, 0, 1, 10, 350.00, 350.00, 'NONE', 'CHINESE', 'CHN', 'TP', '', '.'),
('ALUMINIUM', 'L-BRACKET', 'L-BRACKET 4 X 5', 20.00, 35.00, 6, 0, 1, 10, 35.00, 35.00, 'NONE', 'CHINESE', 'CHN', 'LBRK', '4 X 5', '.'),
('ALUMINIUM', 'L-BRACKET', 'L-BRACKET 5 X 6', 25.00, 40.00, 6, 0, 1, 10, 40.00, 40.00, 'NONE', 'CHINESE', 'CHN', 'LBRK', '5 X 6', '.'),
('ALUMINIUM', 'L-BRACKET', 'L-BRACKET 6 X 8', 40.00, 60.00, 6, 0, 1, 10, 60.00, 60.00, 'NONE', 'CHINESE', 'CHN', 'LBRK', '6 X 8', '.'),
('ALUMINIUM', 'L-BRACKET', 'L-BRACKET 8 X 10', 50.00, 70.00, 6, 0, 1, 10, 70.00, 70.00, 'NONE', 'CHINESE', 'CHN', 'LBRK', '8 X 10', '.'),
('ALUMINIUM', 'L-BRACKET', 'L-BRACKET 10 X 12', 65.00, 85.00, 6, 0, 1, 10, 85.00, 85.00, 'NONE', 'CHINESE', 'CHN', 'LBRK', '10 X 12', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 1/8 X 1/2 (1000PCS)', 875.00, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '1/8 X 1/2', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 1/8 X 3/4 (1000PCS)', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '1/8 X 3/4', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 1/8 X 1 (1000PCS)', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '1/8 X 1', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 1/8 X 1/4 (1000PCS)', 728.00, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '1/8 X 1/4', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 3/8 X 1/8 (1000PCS)', 791.70, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '3/8 X 1/8', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 5/32 X 1/2 (1000PCS)', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '5/32 X 1/2', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 5/32 X 3/8 (1000PCS)', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '5/32 X 3/8', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 5/32 X 5/8 (500PCS)', 737.10, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '5/32 X 5/8', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 5/32 X 3/4 (500PCS)', 786.80, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '5/32 X 3/4', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 5/32 X 1 (500PCS)', 976.50, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '5/32 X 1', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 3/16 X 3/8 (500PCS)', 791.70, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '3/16 X 3/8', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 3/16 X 1/2 (500PCS)', 893.90, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '3/16 X 1/2', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 3/16 X 5/8 (500PCS)', 987.70, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '3/16 X 5/8', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 3/16 X 3/4 (500PCS)', 999.99, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '3/16 X 3/4', '.'),
('ALUMINIUM', 'POP RIVET (P)', 'POP RIVET 3/16 X 1 (400PCS)', 896.00, 999.99, 6, 0, 1, 10, 999.99, 999.99, 'NONE', 'CHINESE', 'CHN', 'PRT(P)', '3/16 X 1', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 1/8 X 1/2', 0.87, 1.50, 6, 0, 1, 10, 1.50, 1.50, 'NONE', 'CHINESE', 'CHN', 'PRT', '1/8 X 1/2', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 1/8 X 3/4', 1.00, 1.50, 6, 0, 1, 10, 1.50, 1.50, 'NONE', 'CHINESE', 'CHN', 'PRT', '1/8 X 3/4', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 1/8 X 1', 1.35, 1.75, 6, 0, 1, 10, 1.75, 1.75, 'NONE', 'CHINESE', 'CHN', 'PRT', '1/8 X 1', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 1/8 X 1/4', 0.72, 1.00, 6, 0, 1, 10, 1.00, 1.00, 'NONE', 'CHINESE', 'CHN', 'PRT', '1/8 X 1/4', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 3/8 X 1/8', 0.80, 1.25, 6, 0, 1, 10, 1.25, 1.25, 'NONE', 'CHINESE', 'CHN', 'PRT', '3/8 X 1/8', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 5/32 X 1/2', 1.20, 1.75, 6, 0, 1, 10, 1.75, 1.75, 'NONE', 'CHINESE', 'CHN', 'PRT', '5/32 X 1/2', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 5/32 X 3/8', 1.00, 1.50, 6, 0, 1, 10, 1.50, 1.50, 'NONE', 'CHINESE', 'CHN', 'PRT', '5/32 X 3/8', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 5/32 X 5/8', 1.47, 2.00, 6, 0, 1, 10, 2.00, 2.00, 'NONE', 'CHINESE', 'CHN', 'PRT', '5/32 X 5/8', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 5/32 X 3/4', 1.57, 2.25, 6, 0, 1, 10, 2.25, 2.25, 'NONE', 'CHINESE', 'CHN', 'PRT', '5/32 X 3/4', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 5/32 X 1', 1.95, 2.50, 6, 0, 1, 10, 2.50, 2.50, 'NONE', 'CHINESE', 'CHN', 'PRT', '5/32 X 1', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 3/16 X 3/8', 1.50, 2.00, 6, 0, 1, 10, 2.00, 2.00, 'NONE', 'CHINESE', 'CHN', 'PRT', '3/16 X 3/8', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 3/16 X 1/2', 1.80, 2.50, 6, 0, 1, 10, 2.50, 2.50, 'NONE', 'CHINESE', 'CHN', 'PRT', '3/16 X 1/2', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 3/16 X 5/8', 2.00, 2.75, 6, 0, 1, 10, 2.75, 2.75, 'NONE', 'CHINESE', 'CHN', 'PRT', '3/16 X 5/8', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 3/16 X 3/4', 2.15, 3.00, 6, 0, 1, 10, 3.00, 3.00, 'NONE', 'CHINESE', 'CHN', 'PRT', '3/16 X 3/4', '.'),
('ALUMINIUM', 'POP RIVET', 'POP RIVET 3/16 X 1', 2.25, 3.00, 6, 0, 1, 10, 3.00, 3.00, 'NONE', 'CHINESE', 'CHN', 'PRT', '3/16 X 1', '.');

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

--
-- Table structure for table `TABLE 55`
--

CREATE TABLE `TABLE 55` (
  `COL 1` varchar(16) DEFAULT NULL,
  `COL 2` varchar(11) DEFAULT NULL,
  `COL 3` varchar(31) DEFAULT NULL,
  `COL 4` decimal(6,2) DEFAULT NULL,
  `COL 5` int DEFAULT NULL,
  `COL 6` int DEFAULT NULL,
  `COL 7` int DEFAULT NULL,
  `COL 8` int DEFAULT NULL,
  `COL 9` int DEFAULT NULL,
  `COL 10` int DEFAULT NULL,
  `COL 11` int DEFAULT NULL,
  `COL 12` varchar(4) DEFAULT NULL,
  `COL 13` varchar(5) DEFAULT NULL,
  `COL 14` varchar(3) DEFAULT NULL,
  `COL 15` varchar(4) DEFAULT NULL,
  `COL 16` varchar(9) DEFAULT NULL,
  `COL 17` varchar(5) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `TABLE 55`
--

INSERT INTO `TABLE 55` (`COL 1`, `COL 2`, `COL 3`, `COL 4`, `COL 5`, `COL 6`, `COL 7`, `COL 8`, `COL 9`, `COL 10`, `COL 11`, `COL 12`, `COL 13`, `COL 14`, `COL 15`, `COL 16`, `COL 17`) VALUES
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 1/8 30M', 27.20, 32, 6, 0, 1, 10, 32, 32, 'NONE', 'S-LON', 'SLN', 'CRHS', '1/8 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 3/16 30M', 33.15, 39, 6, 0, 1, 10, 39, 39, 'NONE', 'S-LON', 'SLN', 'CRHS', '3/16 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 1/4 30M', 59.50, 70, 6, 0, 1, 10, 70, 70, 'NONE', 'S-LON', 'SLN', 'CRHS', '1/4 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 5/16 30M', 51.00, 60, 6, 0, 1, 10, 60, 60, 'NONE', 'S-LON', 'SLN', 'CRHS', '5/16 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 3/8 30M', 79.05, 93, 6, 0, 1, 10, 93, 93, 'NONE', 'S-LON', 'SLN', 'CRHS', '3/8 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 1/2 30M', 93.50, 110, 6, 0, 1, 10, 110, 110, 'NONE', 'S-LON', 'SLN', 'CRHS', '1/2 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE HEAVY 5/8 30M', 110.50, 130, 6, 0, 1, 10, 130, 130, 'NONE', 'S-LON', 'SLN', 'CRHS', '5/8 30MM', 'HEAVY'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE LITE 1/8 30M', 18.70, 22, 6, 0, 1, 10, 22, 22, 'NONE', 'S-LON', 'SLN', 'CRHS', '1/8 30MM', 'LITE'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE LITE 3/16 30M', 19.55, 23, 6, 0, 1, 10, 23, 23, 'NONE', 'S-LON', 'SLN', 'CRHS', '3/16 30MM', 'LITE'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE LITE 1/4 30M', 32.30, 38, 6, 0, 1, 10, 38, 38, 'NONE', 'S-LON', 'SLN', 'CRHS', '1/4 30MM', 'LITE'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE LITE 5/16 30M', 33.15, 39, 6, 0, 1, 10, 39, 39, 'NONE', 'S-LON', 'SLN', 'CRHS', '5/16 30MM', 'LITE'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE LITE 3/8 30M', 35.70, 42, 6, 0, 1, 10, 42, 42, 'NONE', 'S-LON', 'SLN', 'CRHS', '3/8 30MM', 'LITE'),
('P.V.C & FITTINGG', 'CLEAR HOSE', 'SLON CLEAR HOSE LITE 1/2 30M', 51.00, 60, 6, 0, 1, 10, 60, 60, 'NONE', 'S-LON', 'SLN', 'CRHS', '1/2 30MM', 'LITE'),
('P.V.C & FITTINGG', 'BALL VALVE', 'SLON BALL VALVE 20MM', 117.00, 180, 6, 0, 1, 10, 180, 180, 'NONE', 'S-LON', 'SLN', 'BLVL', '20MM', ''),
('P.V.C & FITTINGG', 'BALL VALVE', 'SLON BALL VALVE 25MM', 182.00, 280, 6, 0, 1, 10, 280, 280, 'NONE', 'S-LON', 'SLN', 'BLVL', '25MM', ''),
('P.V.C & FITTINGG', 'BALL VALVE', 'SLON BALL VALVE 32MM', 224.25, 345, 6, 0, 1, 10, 345, 345, 'NONE', 'S-LON', 'SLN', 'BLVL', '32MM', ''),
('P.V.C & FITTINGG', 'BALL VALVE', 'SLON BALL VALVE 40MM', 354.25, 545, 6, 0, 1, 10, 545, 545, 'NONE', 'S-LON', 'SLN', 'BLVL', '40MM', ''),
('P.V.C & FITTINGG', 'BALL VALVE', 'SLON BALL VALVE 50MM', 458.25, 705, 6, 0, 1, 10, 705, 705, 'NONE', 'S-LON', 'SLN', 'BLVL', '50MM', ''),
('P.V.C & FITTINGG', 'BALL VALVE', 'SLON BALL VALVE 63MM', 637.00, 980, 6, 0, 1, 10, 980, 980, 'NONE', 'S-LON', 'SLN', 'BLVL', '63MM', ''),
('P.V.C & FITTINGG', 'GARDEN HOSE', 'SLON GARDEN HOSE  15MM 1/2 BLUE', 900.00, 1125, 6, 0, 1, 10, 1125, 1125, 'NONE', 'S-LON', 'SLN', 'GDHS', '15MM 1/2', 'BLUE'),
('P.V.C & FITTINGG', 'GARDEN HOSE', 'SLON GARDEN HOSE  30MM 1/2 BLUE', 1800.00, 2250, 6, 0, 1, 10, 2250, 2250, 'NONE', 'S-LON', 'SLN', 'GDHS', '30MM 1/2', 'BLUE'),
('P.V.C & FITTINGG', 'GARDEN HOSE', 'SLON GARDEN HOSE  15MM 3/4 BLUE', 1716.00, 2145, 6, 0, 1, 10, 2145, 2145, 'NONE', 'S-LON', 'SLN', 'GDHS', '15MM 3/4', 'BLUE'),
('P.V.C & FITTINGG', 'GARDEN HOSE', 'SLON GARDEN HOSE  30MM 3/4 BLUE', 3432.00, 4290, 6, 0, 1, 10, 4290, 4290, 'NONE', 'S-LON', 'SLN', 'GDHS', '30MM 3/4', 'BLUE'),
('P.V.C & FITTINGG', 'GARDEN HOSE', 'SLON GARDEN HOSE  15MM 1 BLUE', 2472.00, 3090, 6, 0, 1, 10, 3090, 3090, 'NONE', 'S-LON', 'SLN', 'GDHS', '15MM 1', 'BLUE'),
('P.V.C & FITTINGG', 'GARDEN HOSE', 'SLON GARDEN HOSE  30MM 1 BLUE', 4944.00, 6180, 6, 0, 1, 10, 6180, 6180, 'NONE', 'S-LON', 'SLN', 'GDHS', '30MM 1', 'BLUE');

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

--
-- Table structure for table `tax_rates`
--

CREATE TABLE `tax_rates` (
  `id` int NOT NULL,
  `name` varchar(55) NOT NULL,
  `rate` decimal(4,2) NOT NULL,
  `type` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tax_rates`
--

INSERT INTO `tax_rates` (`id`, `name`, `rate`, `type`) VALUES
(1, 'No Tax', 0.00, '2'),
(2, 'VAT', 24.00, '1'),
(3, 'GST', 6.00, '1'),
(4, 'PVM', 21.00, '1');

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

--
-- Table structure for table `temp`
--

CREATE TABLE `temp` (
  `id` int NOT NULL,
  `cat` varchar(200) NOT NULL,
  `subcat` varchar(200) NOT NULL,
  `namesim` varchar(200) NOT NULL,
  `namecap` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `temp_2`
--

CREATE TABLE `temp_2` (
  `category` varchar(100) NOT NULL,
  `sub_category` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `temp_s`
--

CREATE TABLE `temp_s` (
  `category` varchar(100) NOT NULL,
  `sub_category` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `unit_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `temp_s_with_grn`
--

CREATE TABLE `temp_s_with_grn` (
  `category` varchar(100) NOT NULL,
  `sub_category` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `unit_id` int NOT NULL,
  `qty` float NOT NULL,
  `min_qty` float NOT NULL,
  `max_qty` float NOT NULL,
  `credit_salling_price` double NOT NULL,
  `wholesale_price` varchar(100) NOT NULL,
  `barcode` varchar(50) DEFAULT NULL,
  `brand` varchar(25) DEFAULT NULL,
  `code_1` varchar(25) NOT NULL DEFAULT '',
  `code_2` varchar(25) NOT NULL DEFAULT '',
  `capacity` varchar(25) NOT NULL DEFAULT '',
  `color` varchar(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `temp_s_with_grn`
--

INSERT INTO `temp_s_with_grn` (`category`, `sub_category`, `name`, `cost`, `price`, `unit_id`, `qty`, `min_qty`, `max_qty`, `credit_salling_price`, `wholesale_price`, `barcode`, `brand`, `code_1`, `code_2`, `capacity`, `color`) VALUES
('Category', 'Sub Category', 'Product Name', 'Cost', 'Cash Price', 0, 0, 0, 0, 0, 'whole_sale_price', 'barcode', 'Brand', 'Shortcode', 'Shortcode', 'Capacity', 'Color'),
('PAINT', 'MULTIBOND', 'MULTIBOND GRIP 1L', '0', '1685', 0, 0, 0, 0, 0, '0', 'NONE', 'GUM', 'MULTIBNGRIP ', '', '1L', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND MB303 1L', '0', '1100', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN MB303 ', '', '1L', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND MB303 4L', '0', '3425', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN MB303 ', '', '4L', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 364 125ML', '0', '445', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 364 ', '', '125ML', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 364 250ML', '0', '810', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 364 ', '', '250ML', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 364 500L', '0', '0', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 364 ', '', '500ML', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 364 1L', '0', '2460', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 364 ', '', '1L', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 494 125ml', '0', '225', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 494 ', '', '125ML', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 494 250ml', '0', '400', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 494 ', '', '250ML', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 494 500ml', '0', '720', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 494 ', '', '500ML', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND 494 1L', '0', '1295', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN 494', '', '1L', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND STEEL EPOXY 4 MINT 10g', '0', '180', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN STEELEPOXY 4MINT ', '', '10g', ''),
('PAINT', 'MULTIBOND', 'MULTIBOND CONTACT ADHESIVE 7ML', '0', '130', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MULTIBN CONTACT ADHESIVE ', '', '7ml', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 100G', '0', '155', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '100G', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 250G', '0', '245', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '250G', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 500G', '0', '375', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '500G', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 1KG', '0', '590', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '1KG', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 1 1/2KG', '0', '1095', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '1 1/2KG', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 10KG', '0', '4860', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '10KG', ''),
('PAINT', 'CHEMIFIX ', 'CHEMIFIX 20KG', '0', '8535', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CHEMIFIX ', '', '20KG', ''),
('PAINT', 'SH', 'SH 125G', '0', '235', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SH ', '', '125G', ''),
('PAINT', 'SH', 'SH 250G', '0', '290', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SH ', '', '250G', ''),
('PAINT', 'SH', 'SH 500G', '0', '435', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SH ', '', '500G', ''),
('PAINT', 'SH', 'SH 1KG', '0', '830', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SH ', '', '1KG', ''),
('PAINT', 'SH', 'SH 5KG', '0', '2955', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SH ', '', '5KG', ''),
('PAINT', 'SH', 'SH 2KG', '0', '1335', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SH ', '', '2KG', ''),
('PAINT', 'FEVIBOND', 'FEVIBOND 10ML', '0', '90', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'FEVIBOND ', '', '10ML', ''),
('PAINT', 'FEVIBOND', 'FEVIBOND 20ML', '0', '135', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'FEVIBOND ', '', '20ML', ''),
('PAINT', 'FEVIBOND', 'FEVIBOND 50ML', '0', '135', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'FEVIBOND ', '', '50ML', ''),
('PAINT', 'SUPER GLUE', 'SUPER GLUE 3G', '0', '60', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'SUPER GLUE ', '', '3G', ''),
('PAINT', 'SUPER GLUE', 'MAXMO SUPER GLUE 4G', '0', '70', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'MAXMO SUPER GLUE ', '', '4G', ''),
('PAINT', 'EPIFIX', 'EPIFIX  TUBE', '0', '260', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'EPIFIX  TUBE', '', '', ''),
('PAINT', 'EPIFIX', 'EPIFIX  230G', '0', '470', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'EPIFIX  230G', '', '230G', ''),
('PAINT', 'EPIFIX', 'EPIFIX  500G', '0', '875', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'EPIFIX  500G', '', '500G', ''),
('PAINT', 'EPIFIX', 'EPIFIX  1L', '0', '1635', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'EPIFIX  1L', '', '', ''),
('PAINT', 'CRACK FAST', 'CRACK FAST 500G', '0', '805', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CRACK FAST ', '', '500G', ''),
('PAINT', 'CRACK FAST', 'CRACK FAST 1L', '0', '1295', 0, 0, 0, 0, 0, '', 'NONE', 'GUM', 'CRACK FAST ', '', '1L', ''),
('PAINT', '', '', '', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', ''),
('PAINT', '', '', '', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', ''),
('PAINT', '', '', '', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', ''),
('PAINT', '', '', '', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', '');

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

--
-- Table structure for table `temp_s_with_grn_v1`
--

CREATE TABLE `temp_s_with_grn_v1` (
  `category` varchar(100) NOT NULL,
  `sub_category` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `unit_id` int NOT NULL,
  `qty` float NOT NULL,
  `min_qty` float NOT NULL,
  `max_qty` float NOT NULL,
  `credit_salling_price` double NOT NULL,
  `wholesale_price` varchar(100) NOT NULL,
  `barcode` varchar(50) DEFAULT NULL,
  `brand` varchar(25) DEFAULT NULL,
  `code_1` varchar(25) NOT NULL DEFAULT '',
  `code_2` varchar(25) NOT NULL DEFAULT '',
  `capacity` varchar(25) NOT NULL DEFAULT '',
  `color` varchar(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `temp_s_with_grn_v1`
--

INSERT INTO `temp_s_with_grn_v1` (`category`, `sub_category`, `name`, `cost`, `price`, `unit_id`, `qty`, `min_qty`, `max_qty`, `credit_salling_price`, `wholesale_price`, `barcode`, `brand`, `code_1`, `code_2`, `capacity`, `color`) VALUES
('OTHER', 'CABEL TIE  P', 'CABEL TIE 3 X 100MM', '57', '157', 6, 0, 1, 10, 157, '157', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3X100MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABEL TIE 3 X 150MM', '87', '187', 6, 0, 1, 10, 187, '187', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3X150MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABEL TIE 3 X 200MM', '125', '225', 6, 0, 1, 10, 225, '225', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3X200MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABEL TIE 3 X 250MM', '185', '285', 6, 0, 1, 10, 285, '285', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3X250MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABEL TIE 3 X 300MM', '225', '325', 6, 0, 1, 10, 325, '325', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3X300MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 250MM', '245', '345', 6, 0, 1, 10, 345, '345', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 250MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 300MM', '306', '406', 6, 0, 1, 10, 406, '406', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 300MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 200MM', '200', '300', 6, 0, 1, 10, 300, '300', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 200MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 4 X 200MM', '185', '285', 6, 0, 1, 10, 285, '285', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '4 X 200MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 4 X 250MM', '225', '325', 6, 0, 1, 10, 325, '325', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '4 X 250MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 4 X 300MM', '275', '375', 6, 0, 1, 10, 375, '375', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '4 X 300MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 5 X 250MM', '302', '402', 6, 0, 1, 10, 402, '402', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '5 X 250MM', '.'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 100MM BLACK', '75', '175', 6, 0, 1, 10, 175, '175', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 100MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 150MM BLACK', '85', '185', 6, 0, 1, 10, 185, '185', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 150MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 200MM BLACK', '122', '222', 6, 0, 1, 10, 222, '222', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 200MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 250MM BLACK', '150', '250', 6, 0, 1, 10, 250, '250', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 250MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 3.6 X 300MM BLACK', '200', '300', 6, 0, 1, 10, 300, '300', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '3.6 X 300MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 4.8 X 200MM BLACK', '260', '360', 6, 0, 1, 10, 360, '360', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '4.8 X 200MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 4.8 X 300MM BLACK', '270', '370', 6, 0, 1, 10, 370, '370', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '4.8 X 300MM', 'BLACK'),
('OTHER', 'CABEL TIE  P', 'CABLE TIE 4.8 X 350MM BLACK', '280', '380', 6, 0, 1, 10, 380, '380', 'NONE', 'OTHER', 'OTHR', 'CABEL TIE', '5.8 X 350MM', 'BLACK');

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

--
-- Table structure for table `transfer`
--

CREATE TABLE `transfer` (
  `trnsfr_id` int NOT NULL,
  `trnsfr_reference_no` varchar(55) NOT NULL,
  `trnsfr_datetime` date NOT NULL,
  `trnsfr_from_warehouse_id` int NOT NULL,
  `trnsfr_to_warehouse_id` int NOT NULL,
  `trnsfr_note` varchar(1000) DEFAULT '0',
  `user_id` varchar(255) DEFAULT '0',
  `trnsfr_total` decimal(25,2) NOT NULL,
  `trnsfr_datetime_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `transfer_item`
--

CREATE TABLE `transfer_item` (
  `trnsfr_itm_id` int NOT NULL,
  `trnsfr_id` int NOT NULL,
  `product_id` int NOT NULL,
  `trnsfr_itm_quantity` decimal(10,2) NOT NULL,
  `trnsfr_itm_unit_price` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `user_group`
--

CREATE TABLE `user_group` (
  `user_group_id` int NOT NULL,
  `user_group_name` varchar(100) DEFAULT '0',
  `user_group_status` int DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group`
--

INSERT INTO `user_group` (`user_group_id`, `user_group_name`, `user_group_status`) VALUES
(1, 'Owner', 1),
(2, 'Super Administrator', 1),
(3, 'Sales Staff', 1);

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

--
-- Table structure for table `user_group_permission`
--

CREATE TABLE `user_group_permission` (
  `usrgp_permission_id` int NOT NULL,
  `user_group_id` int NOT NULL,
  `usrgp_permission_page` varchar(33) NOT NULL,
  `usrgp_permission_view` int NOT NULL,
  `usrgp_permission_add` int NOT NULL,
  `usrgp_permission_edit` int NOT NULL,
  `usrgp_permission_delete` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group_permission`
--

INSERT INTO `user_group_permission` (`usrgp_permission_id`, `user_group_id`, `usrgp_permission_page`, `usrgp_permission_view`, `usrgp_permission_add`, `usrgp_permission_edit`, `usrgp_permission_delete`) VALUES
(1, 1, 'users', 1, 1, 1, 1),
(2, 1, 'sales', 1, 1, 1, 1),
(3, 1, 'products', 1, 1, 1, 1),
(4, 2, 'users', 1, 1, 1, 1),
(5, 2, 'sales', 1, 1, 1, 1),
(6, 2, 'products', 1, 1, 1, 1),
(7, 3, 'users', 0, 0, 0, 0),
(8, 3, 'sales', 1, 1, 0, 0),
(9, 3, 'products', 1, 0, 0, 0),
(10, 1, 'quotations', 1, 1, 1, 1),
(11, 2, 'quotations', 1, 1, 1, 1),
(12, 3, 'quotations', 1, 1, 0, 0),
(13, 1, 'customer', 1, 1, 1, 1),
(14, 2, 'customer', 1, 1, 1, 1),
(15, 3, 'customer', 1, 1, 0, 0),
(16, 1, 'grn', 1, 1, 1, 1),
(17, 2, 'grn', 1, 1, 1, 1),
(18, 3, 'grn', 0, 0, 0, 0),
(19, 1, 'suppliers', 1, 1, 1, 1),
(20, 2, 'suppliers', 1, 1, 1, 1),
(21, 3, 'suppliers', 1, 0, 0, 0),
(22, 1, 'report', 1, 1, 1, 1),
(23, 2, 'report', 1, 1, 1, 1),
(24, 3, 'report', 0, 0, 0, 0),
(25, 1, 'settings', 1, 1, 1, 1),
(26, 2, 'settings', 1, 1, 1, 1),
(27, 3, 'settings', 0, 0, 0, 0),
(28, 1, 'damage_products', 1, 1, 1, 1),
(29, 2, 'damage_products', 1, 1, 1, 1),
(30, 3, 'damage_products', 1, 1, 0, 0),
(31, 1, 'transfers', 1, 1, 1, 1),
(32, 2, 'transfers', 1, 1, 1, 1),
(33, 3, 'transfers', 1, 1, 0, 0);

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

--
-- Table structure for table `user_group_permission_page`
--

CREATE TABLE `user_group_permission_page` (
  `user_group_prmsn_page_id` int NOT NULL,
  `user_group_permission_page_name` varchar(30) NOT NULL,
  `user_group_permission_page_display_name` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group_permission_page`
--

INSERT INTO `user_group_permission_page` (`user_group_prmsn_page_id`, `user_group_permission_page_name`, `user_group_permission_page_display_name`) VALUES
(1, 'products', 'Products'),
(2, 'users', 'Users'),
(3, 'sales', 'Sales'),
(4, 'quotations', 'Quotations'),
(5, 'customer', 'Customer'),
(6, 'grn', 'GRN'),
(7, 'suppliers', 'Suppliers'),
(8, 'report', 'Report'),
(9, 'settings', 'Settings '),
(10, 'damage_products', 'Damage Products  '),
(11, 'transfers', 'Transfers  ');

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

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` int NOT NULL,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(55) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `status` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` (`id`, `code`, `name`, `address`, `city`, `phone`, `email`, `status`) VALUES
(2, 'LE', 'LIYANAGE ENTERPRISES', '278, Colombo Road, Kidagammulla, Gampaha', '', '0772009729  / 0332228881 /  0711235520', 'rupundilliyanage@gmail.com', 1),
(3, 'L2', 'LIYANAGE ENTERPRISES(LE)', '117/16,Oruthota Road,Mudungoda', '', '077 531 5412 / 076 945 9401 / 033 222 6845', 'liyanageenterprises12@gmail.com', 1);

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

--
-- Table structure for table `warehouses_products`
--

CREATE TABLE `warehouses_products` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `warehouse_id` int NOT NULL,
  `quantity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`cus_id`),
  ADD UNIQUE KEY `cus_code` (`cus_code`),
  ADD UNIQUE KEY `cus_code_2` (`cus_code`);

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

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`exp_id`),
  ADD UNIQUE KEY `exp_reference_no` (`exp_reference_no`);

--
-- Indexes for table `fi_table`
--
ALTER TABLE `fi_table`
  ADD PRIMARY KEY (`fi_id`);

--
-- Indexes for table `fi_types`
--
ALTER TABLE `fi_types`
  ADD PRIMARY KEY (`fi_type_id`);

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

--
-- Indexes for table `master_brand`
--
ALTER TABLE `master_brand`
  ADD PRIMARY KEY (`brand_id`);

--
-- Indexes for table `mstr_bank`
--
ALTER TABLE `mstr_bank`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `mstr_city`
--
ALTER TABLE `mstr_city`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `cname` (`cname`),
  ADD KEY `cname_2` (`cname`);

--
-- Indexes for table `mstr_country`
--
ALTER TABLE `mstr_country`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `mstr_cr_limit`
--
ALTER TABLE `mstr_cr_limit`
  ADD PRIMARY KEY (`cr_limit_id`);

--
-- Indexes for table `mstr_fi_type`
--
ALTER TABLE `mstr_fi_type`
  ADD PRIMARY KEY (`fi_type_id`);

--
-- Indexes for table `mstr_location`
--
ALTER TABLE `mstr_location`
  ADD PRIMARY KEY (`location_id`);

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

--
-- Indexes for table `mstr_unit`
--
ALTER TABLE `mstr_unit`
  ADD PRIMARY KEY (`unit_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`product_id`),
  ADD KEY `FK_item` (`cat_id`);

--
-- Indexes for table `product_category`
--
ALTER TABLE `product_category`
  ADD KEY `cat_id` (`cat_id`);

--
-- Indexes for table `product_damage`
--
ALTER TABLE `product_damage`
  ADD PRIMARY KEY (`pdmg_id`);

--
-- Indexes for table `product_damage_item`
--
ALTER TABLE `product_damage_item`
  ADD PRIMARY KEY (`pdmgitm_id`);

--
-- Indexes for table `product_stock`
--
ALTER TABLE `product_stock`
  ADD PRIMARY KEY (`product_stock_id`);

--
-- Indexes for table `product_sub_category`
--
ALTER TABLE `product_sub_category`
  ADD KEY `sub_cat_id` (`sub_cat_id`);

--
-- Indexes for table `product_type`
--
ALTER TABLE `product_type`
  ADD PRIMARY KEY (`product_type_id`);

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

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

--
-- Indexes for table `purchase_items_serial`
--
ALTER TABLE `purchase_items_serial`
  ADD PRIMARY KEY (`pis_id`),
  ADD UNIQUE KEY `pis_number` (`pis_number`);

--
-- Indexes for table `purchase_return`
--
ALTER TABLE `purchase_return`
  ADD PRIMARY KEY (`pur_rtn_id`);

--
-- Indexes for table `purchase_return_items`
--
ALTER TABLE `purchase_return_items`
  ADD PRIMARY KEY (`pur_rtn_itm_id`);

--
-- Indexes for table `quotations`
--
ALTER TABLE `quotations`
  ADD PRIMARY KEY (`qts_id`);

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

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`sale_id`),
  ADD UNIQUE KEY `sale_reference_no` (`sale_reference_no`),
  ADD UNIQUE KEY `sale_reference_no_2` (`sale_reference_no`),
  ADD UNIQUE KEY `sale_reference_no_3` (`sale_reference_no`);

--
-- Indexes for table `sales_return`
--
ALTER TABLE `sales_return`
  ADD PRIMARY KEY (`sl_rtn_id`);

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

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

--
-- Indexes for table `sale_multiple_payment`
--
ALTER TABLE `sale_multiple_payment`
  ADD PRIMARY KEY (`smp_id`),
  ADD UNIQUE KEY `smp_no` (`smp_no`);

--
-- Indexes for table `sale_payments`
--
ALTER TABLE `sale_payments`
  ADD PRIMARY KEY (`sale_pymnt_id`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`service_id`);

--
-- Indexes for table `service_items`
--
ALTER TABLE `service_items`
  ADD PRIMARY KEY (`serviceitm_id`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`supp_id`),
  ADD KEY `FK_supplier` (`cr_limit_id`);

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

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

--
-- Indexes for table `transfer`
--
ALTER TABLE `transfer`
  ADD PRIMARY KEY (`trnsfr_id`);

--
-- Indexes for table `transfer_item`
--
ALTER TABLE `transfer_item`
  ADD PRIMARY KEY (`trnsfr_itm_id`);

--
-- Indexes for table `user_group`
--
ALTER TABLE `user_group`
  ADD PRIMARY KEY (`user_group_id`);

--
-- Indexes for table `user_group_permission`
--
ALTER TABLE `user_group_permission`
  ADD PRIMARY KEY (`usrgp_permission_id`);

--
-- Indexes for table `user_group_permission_page`
--
ALTER TABLE `user_group_permission_page`
  ADD PRIMARY KEY (`user_group_prmsn_page_id`),
  ADD UNIQUE KEY `user_group_permission_page_name` (`user_group_permission_page_name`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `cus_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `cus_pricing`
--
ALTER TABLE `cus_pricing`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `exp_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fi_table`
--
ALTER TABLE `fi_table`
  MODIFY `fi_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5318;

--
-- AUTO_INCREMENT for table `fi_types`
--
ALTER TABLE `fi_types`
  MODIFY `fi_type_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7821;

--
-- AUTO_INCREMENT for table `master_brand`
--
ALTER TABLE `master_brand`
  MODIFY `brand_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=147;

--
-- AUTO_INCREMENT for table `mstr_bank`
--
ALTER TABLE `mstr_bank`
  MODIFY `bank_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `mstr_city`
--
ALTER TABLE `mstr_city`
  MODIFY `cid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2092;

--
-- AUTO_INCREMENT for table `mstr_country`
--
ALTER TABLE `mstr_country`
  MODIFY `country_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=252;

--
-- AUTO_INCREMENT for table `mstr_cr_limit`
--
ALTER TABLE `mstr_cr_limit`
  MODIFY `cr_limit_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mstr_fi_type`
--
ALTER TABLE `mstr_fi_type`
  MODIFY `fi_type_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mstr_location`
--
ALTER TABLE `mstr_location`
  MODIFY `location_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mstr_status`
--
ALTER TABLE `mstr_status`
  MODIFY `status_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mstr_unit`
--
ALTER TABLE `mstr_unit`
  MODIFY `unit_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `product_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18554;

--
-- AUTO_INCREMENT for table `product_category`
--
ALTER TABLE `product_category`
  MODIFY `cat_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `product_damage`
--
ALTER TABLE `product_damage`
  MODIFY `pdmg_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_damage_item`
--
ALTER TABLE `product_damage_item`
  MODIFY `pdmgitm_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_stock`
--
ALTER TABLE `product_stock`
  MODIFY `product_stock_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_sub_category`
--
ALTER TABLE `product_sub_category`
  MODIFY `sub_cat_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=723;

--
-- AUTO_INCREMENT for table `product_type`
--
ALTER TABLE `product_type`
  MODIFY `product_type_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2360;

--
-- AUTO_INCREMENT for table `purchase_items`
--
ALTER TABLE `purchase_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5307;

--
-- AUTO_INCREMENT for table `purchase_items_serial`
--
ALTER TABLE `purchase_items_serial`
  MODIFY `pis_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_return_items`
--
ALTER TABLE `purchase_return_items`
  MODIFY `pur_rtn_itm_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `quotations`
--
ALTER TABLE `quotations`
  MODIFY `qts_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `quotations_items`
--
ALTER TABLE `quotations_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `sale_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108116;

--
-- AUTO_INCREMENT for table `sales_return`
--
ALTER TABLE `sales_return`
  MODIFY `sl_rtn_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sales_return_items`
--
ALTER TABLE `sales_return_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sale_items`
--
ALTER TABLE `sale_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=323259;

--
-- AUTO_INCREMENT for table `sale_multiple_payment`
--
ALTER TABLE `sale_multiple_payment`
  MODIFY `smp_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sale_payments`
--
ALTER TABLE `sale_payments`
  MODIFY `sale_pymnt_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115844;

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `service_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_items`
--
ALTER TABLE `service_items`
  MODIFY `serviceitm_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `supp_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT for table `tax_rates`
--
ALTER TABLE `tax_rates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `temp`
--
ALTER TABLE `temp`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transfer`
--
ALTER TABLE `transfer`
  MODIFY `trnsfr_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transfer_item`
--
ALTER TABLE `transfer_item`
  MODIFY `trnsfr_itm_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_group`
--
ALTER TABLE `user_group`
  MODIFY `user_group_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user_group_permission`
--
ALTER TABLE `user_group_permission`
  MODIFY `usrgp_permission_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `user_group_permission_page`
--
ALTER TABLE `user_group_permission_page`
  MODIFY `user_group_prmsn_page_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `warehouses`
--
ALTER TABLE `warehouses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `warehouses_products`
--
ALTER TABLE `warehouses_products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

