-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Sep 03, 2026 at 06:13 PM -- Server version: 11.8.8-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `ah_pos` -- -- -------------------------------------------------------- -- -- Table structure for table `account_chart` -- CREATE TABLE `account_chart` ( `AccCode` int(11) NOT NULL, `Type` varchar(20) DEFAULT NULL, `Category` varchar(50) DEFAULT NULL, `Sub_Category` varchar(150) DEFAULT NULL, `Grp` varchar(150) DEFAULT NULL, `AccName` varchar(50) DEFAULT NULL, `Referance` varchar(50) DEFAULT NULL, `Address` text DEFAULT NULL, `Contact_person` varchar(50) DEFAULT NULL, `Designation` varchar(50) DEFAULT NULL, `Phone_No` varchar(50) DEFAULT NULL, `cus_serial` int(11) DEFAULT NULL, `custype` varchar(50) DEFAULT NULL, `Fax_No` varchar(50) DEFAULT NULL, `Mobile_No` varchar(50) DEFAULT NULL, `Email_add` varchar(50) DEFAULT NULL, `employee_wise` varchar(3) DEFAULT NULL, `bank` varchar(150) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `account_chart` -- INSERT INTO `account_chart` (`AccCode`, `Type`, `Category`, `Sub_Category`, `Grp`, `AccName`, `Referance`, `Address`, `Contact_person`, `Designation`, `Phone_No`, `cus_serial`, `custype`, `Fax_No`, `Mobile_No`, `Email_add`, `employee_wise`, `bank`) VALUES (40, 'Liabilities', ' Capital Employed', 'Long Tarm Liabilities', 'Tax Payable', 'Value Added Tax', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (41, 'Expenses', ' Administrative Cost', 'Indirect Expenses', 'Advance and Deposits', 'Inventory', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (42, 'Income', ' Revenue', 'Indirect Income', 'Income', 'Service', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (127, NULL, NULL, NULL, 'CandS', 'Capital', NULL, 'Dhak', NULL, NULL, NULL, NULL, 'supplier', NULL, '00000000000', NULL, NULL, NULL), (128, 'Assets', ' Current Assets', 'Cash and Bank', 'Cash in Hand', 'Cash', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (129, 'Assets', ' Current Assets', 'Cash and Bank', 'Cash at Bank', 'Bank', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (130, 'Assets', ' Current Assets', 'Cash and Bank', 'Cash at MobileBank', 'MbileBank', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (131, NULL, NULL, NULL, 'CandS', 'RR Enterpries', NULL, 'Savar Bazar Road, Savar, Dhaka', NULL, NULL, NULL, NULL, 'supplier', NULL, '01959595964', NULL, NULL, NULL), (133, NULL, NULL, NULL, 'CandS', 'Silpi / Polas', NULL, 'Sekandar ar Basa', NULL, NULL, NULL, NULL, 'customer', NULL, '01950114951', NULL, NULL, NULL), (134, NULL, NULL, NULL, 'CandS', 'Ayesha apa', NULL, 'Fojol ar Basa', NULL, NULL, NULL, NULL, 'customer', NULL, '01908591640', NULL, NULL, NULL), (135, NULL, NULL, NULL, 'CandS', 'Sattar Kaka', NULL, 'Dosaid', NULL, NULL, NULL, NULL, 'customer', NULL, '01917735972', NULL, NULL, NULL), (136, NULL, NULL, NULL, 'CandS', 'Monsur', NULL, 'Owner', '', NULL, '', NULL, 'customer', NULL, '01849551624', '', NULL, NULL), (137, NULL, NULL, NULL, 'CandS', 'Radhuni (Square)', NULL, '48,Square centre, Mohakhali C/A Dhaka -1212', NULL, NULL, NULL, NULL, 'supplier', NULL, '01744603764', NULL, NULL, NULL), (138, NULL, NULL, NULL, 'CandS', 'Fahimer Maa', NULL, 'Ripon Sorker (Basa)', NULL, NULL, NULL, NULL, 'customer', NULL, '01929452578', NULL, NULL, NULL), (139, NULL, NULL, NULL, 'CandS', 'Thai', NULL, 'Dhaka', NULL, NULL, NULL, NULL, 'supplier', NULL, '88-02-44613187', NULL, NULL, NULL), (140, NULL, NULL, NULL, 'CandS', 'Anwar Enterprise (Ali)', NULL, 'kolma savar', NULL, NULL, NULL, NULL, 'supplier', NULL, '01977344220', NULL, NULL, NULL), (141, NULL, NULL, NULL, 'CandS', 'Tamim Enterprise (Ruchi) (square)', NULL, 'SR Ismail', NULL, NULL, NULL, NULL, 'supplier', NULL, '01763037834', NULL, NULL, NULL), (142, NULL, NULL, NULL, 'CandS', 'asadul vai', NULL, 'Ripon sorkarer basa', NULL, NULL, NULL, NULL, 'customer', NULL, '01753027053', NULL, NULL, NULL), (143, NULL, NULL, NULL, 'CandS', 'akij food', NULL, 'anarkoli', NULL, NULL, NULL, NULL, 'supplier', NULL, '01335216482', NULL, NULL, NULL), (144, NULL, NULL, NULL, 'CandS', 'Aminul vai Fatema narsary', NULL, 'Fatema Narsary', NULL, NULL, NULL, NULL, 'customer', NULL, '01713825898', NULL, NULL, NULL), (145, NULL, NULL, NULL, NULL, 'Redaon Stor', NULL, 'Dosaid Bazar', NULL, NULL, NULL, NULL, 'supplier', NULL, '01646908983', NULL, NULL, NULL), (146, NULL, NULL, NULL, 'CandS', 'Salahin', NULL, 'surjo miahr bari', NULL, NULL, NULL, NULL, 'customer', NULL, '01345960090', NULL, NULL, NULL), (147, NULL, NULL, NULL, NULL, 'M/S Sadia Traders ( Bashundhara )', NULL, 'Ashulia Bazar , Ashulia ,Dhaka', NULL, NULL, NULL, NULL, 'supplier', NULL, '01782897606', NULL, NULL, NULL), (148, NULL, NULL, NULL, 'CandS', 'Akash Maih', NULL, NULL, NULL, NULL, NULL, NULL, 'customer', NULL, '01765975686', NULL, NULL, NULL), (149, NULL, NULL, NULL, 'CandS', 'Alom Vai', NULL, 'Riponer Basa', NULL, NULL, NULL, NULL, 'customer', NULL, '017166055580', NULL, NULL, NULL), (150, NULL, NULL, NULL, NULL, 'DEKKO', NULL, '', NULL, NULL, NULL, NULL, 'supplier', NULL, '+8809666774400', NULL, NULL, NULL), (151, NULL, NULL, NULL, NULL, 'Sarker & Brothers (lactogen)', NULL, 'Savar Baar ,Savar', NULL, NULL, NULL, NULL, 'supplier', NULL, '01711688196', NULL, NULL, NULL), (152, NULL, NULL, NULL, NULL, 'Mgi', NULL, '', NULL, NULL, NULL, NULL, 'supplier', NULL, '01886727284', NULL, NULL, NULL), (153, NULL, NULL, NULL, NULL, 'Saad', NULL, 'Biroliya', NULL, NULL, NULL, NULL, 'supplier', NULL, '01881202020', NULL, NULL, NULL), (154, NULL, NULL, NULL, NULL, 'Diploma Milk', NULL, '', NULL, NULL, NULL, NULL, 'supplier', NULL, '01996622885', NULL, NULL, NULL), (155, NULL, NULL, NULL, NULL, 'Shahabuddin (DIM)', NULL, 'Dosaid Bazar', NULL, NULL, NULL, NULL, 'supplier', NULL, '01925668142', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `account_types` -- CREATE TABLE `account_types` ( `id` int(11) NOT NULL, `type_name` varchar(50) NOT NULL, `code_range_start` int(11) NOT NULL, `code_range_end` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `audit_logs` -- CREATE TABLE `audit_logs` ( `id` bigint(20) NOT NULL, `user_id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `action_type` varchar(50) NOT NULL, `table_name` varchar(100) NOT NULL, `record_id` bigint(20) NOT NULL, `description` text DEFAULT NULL, `details` text DEFAULT NULL, `old_data` longtext DEFAULT NULL, `new_data` longtext DEFAULT NULL, `changed_fields` text DEFAULT NULL, `ip_address` varchar(100) DEFAULT NULL, `user_agent` text DEFAULT NULL, `session_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `audit_logs` -- INSERT INTO `audit_logs` (`id`, `user_id`, `username`, `action_type`, `table_name`, `record_id`, `description`, `details`, `old_data`, `new_data`, `changed_fields`, `ip_address`, `user_agent`, `session_id`, `created_at`) VALUES (1, 7, 'Md. Liton Chowdhury', 'UPDATE', 'quotations', 2, NULL, 'Quotation Updated', NULL, NULL, NULL, '2401:1900:18b:fce2:d125:5343:c529:2886', NULL, NULL, '2026-05-21 02:13:40'), (2, 7, 'Khan', 'CREATE', 'quotations', 0, NULL, 'Quotation Created', NULL, NULL, NULL, '2401:1900:18b:fce2:598b:d1de:bba9:31f0', NULL, NULL, '2026-05-22 19:02:10'), (3, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 10:23:13'), (4, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 13:54:41'), (5, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:01:54'), (6, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:05:59'), (7, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created Successfully', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:08:38'), (8, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:10:47'), (9, 7, 'Khan', 'CREATE', 'quotations', 4, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 14:18:43'), (10, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:36:10'), (11, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:37:31'), (12, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:42:37'), (13, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:46:22'), (14, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 15:58:08'), (15, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:02:54'), (16, 7, 'Khan', 'CREATE', 'quotations', 6, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:15:33'), (17, 7, 'Khan', 'CREATE', 'quotations', 7, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:20:44'), (18, 7, 'Khan', 'CREATE', 'quotations', 8, NULL, 'Quotation Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-24 16:31:24'), (19, 7, 'Khan', 'CREATE', 'central_store', 0, NULL, 'Stock Receive Created', NULL, NULL, NULL, '2401:1900:18b:fce2:612d:d7b3:acb1:d381', NULL, NULL, '2026-05-24 18:30:28'), (20, 7, 'Khan', 'CREATE', 'purchases', 10, NULL, 'Purchase Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-26 07:21:10'), (21, 7, 'Khan', 'CREATE', 'purchases', 11, NULL, 'Purchase Created', NULL, NULL, NULL, '202.83.124.205', NULL, NULL, '2026-05-26 08:59:39'); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE `banks` ( `id` int(10) UNSIGNED NOT NULL, `bank_name` varchar(150) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `bank_accounts` -- CREATE TABLE `bank_accounts` ( `id` int(10) UNSIGNED NOT NULL, `account_chart_code` int(11) NOT NULL, `account_name` varchar(150) NOT NULL, `account_no` varchar(100) NOT NULL, `bank_name` varchar(150) NOT NULL, `swift_code` varchar(50) DEFAULT NULL, `branch_name` varchar(150) DEFAULT NULL, `account_type` varchar(50) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bank_accounts` -- INSERT INTO `bank_accounts` (`id`, `account_chart_code`, `account_name`, `account_no`, `bank_name`, `swift_code`, `branch_name`, `account_type`, `status`, `created_at`) VALUES (1, 129, 'Khan Engineering Corporation', '123456', 'Dutch Bangla Bank PLC', NULL, 'Dhaka', 'Current', 1, '2026-08-28 19:21:12'), (2, 129, 'Khan Engineering Corporation', '1452366', 'Brac Bank PLC', '25362', 'Dhaka Dakshin', 'Current', 1, '2026-08-28 19:28:04'); -- -------------------------------------------------------- -- -- Table structure for table `bill_ledger` -- CREATE TABLE `bill_ledger` ( `id` int(11) NOT NULL, `date` date DEFAULT NULL, `bill_no` varchar(50) NOT NULL, `voucher_no` varchar(100) DEFAULT NULL, `account_code` int(11) DEFAULT NULL, `account_name` varchar(255) DEFAULT NULL, `debit` decimal(18,2) DEFAULT 0.00, `credit` decimal(18,2) DEFAULT 0.00, `narration` text DEFAULT NULL, `reference_table` varchar(100) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bill_ledger` -- INSERT INTO `bill_ledger` (`id`, `date`, `bill_no`, `voucher_no`, `account_code`, `account_name`, `debit`, `credit`, `narration`, `reference_table`, `reference_id`, `created_by`, `created_at`) VALUES (53, '2026-08-29', 'PUR-1', 'PUR-1', 127, 'Capital', 0.00, 7795.38, 'Purchase Invoice #1 | 7 up 1.75L x 13, 7 up 1L x 13, 7 up 200ml x 25, Aci aerosol insect spray 250ml x 1, Aci aerosol insect spray 350ml x 1, Aci aerosol insect spray 475ml x 1, Agar Agar 20g x 5, Alooz Tomato flavour chips 18g x 29, Amer acar 400g x 2, Angelic fresh citrus burst 300ml x 1, Angelic fresh csparfrfing orange 300ml x 2, Angelic fresh orchid breege 300ml x 1, Apple Jelly 350g x 1, Badam Bhaja 16g x 24, Badami Biscuits 200g x 2, bakery fresh sweet toast biscuit 180g x 4, Bashundhara Facial Tissue 200pce x 8, Bashundhara Restaurant napkin Tissue 100pce x 1, Biscotti Cookies Biscuits 60g x 14', 'purchases', 38, 101, '2026-08-29 11:36:25'), (54, '2026-08-29', 'PUR-2', 'PUR-2', 127, 'Capital', 0.00, 10354.68, 'Purchase Invoice #2 | Bombay Sweets Chanachur 80g x 11, Bombay Sweets Chanachur 150g x 3, Boom Chocolale x 80, Butterful biscuit x 20, Clear Shampoo x 2, Condensed filled milk 400g x 37, Coconut Biscuit 90g x 10, Cute cold cream 100g x 12, Cute cold cream 50 x 6, Cute perfumed coconut hair oil 330ml x 1, Dabur Amla hair oil 180ml x 10, Dettol Aloe vera 120g x 3, Dove Shampoo 330g x 2, Dove Shampoo 80g x 1', 'purchases', 39, 101, '2026-08-29 11:43:07'), (56, '2026-08-29', 'PUR-3', 'PUR-3', 127, 'Capital', 0.00, 947.10, 'Purchase Invoice #3 | Energy Plus Biscuits 40g x 63, Euro FAI-Ming coil x 35', 'purchases', 40, 101, '2026-08-29 11:48:08'), (58, '2026-08-29', 'PUR-5', 'PUR-5', 127, 'Capital', 0.00, 4262.00, 'Purchase Invoice #5 | Glow & Lovely Facewash 100g x 1, Glow & Lovely Re- New Bright creme 25g x 9, Glow & Lovely Re- New Bright creme 47g x 3, Glow & Lovely Re- New Bright creme 50g x 1, Glow & Lovely Re- New Bright creme 80g x 6, Gogg bodu spray 120ml x 1', 'purchases', 42, 101, '2026-08-29 12:03:30'), (59, '2026-08-29', 'PUR-6', 'PUR-6', 127, 'Capital', 0.00, 385.00, 'Purchase Invoice #6 | Havoc Gole 200ml x 1', 'purchases', 43, 101, '2026-08-29 12:04:32'), (60, '2026-08-29', 'PUR-7', 'PUR-7', 127, 'Capital', 0.00, 2535.00, 'Purchase Invoice #7 | Himalaya Neem face wash 100ml x 2, Himalaya Neem face wash 50ml x 10, Himalaya Neem Soap 100g x 4, HimalayaPrickly heat baby powder 100g x 5', 'purchases', 44, 101, '2026-08-29 12:10:14'), (61, '2026-08-29', 'PUR-8', 'PUR-8', 127, 'Capital', 0.00, 5076.00, 'Purchase Invoice #8 | Hot Tomato Sauce 250g x 2, Horlicks 500g x 1, Hot Tometo sos 200g x 4, Hot tometo sos 320g x 3, Hot tometo sos 500g x 6, Icon Soyabean Oil 1L x 3, Icon Soyabean Oil 500ml x 5, Johnson\'s baby lotion with aloe & vitamin B5 100ml x 3, Johnson\'s baby powder 100g x 3, Johnson\'s baby powder 50g x 3', 'purchases', 45, 101, '2026-08-29 12:20:50'), (62, '2026-08-29', 'PUR-9', 'PUR-9', 127, 'Capital', 0.00, 1960.00, 'Purchase Invoice #9 | Johnson\'s baby shampoo 100ml x 2, Johnson\'s baby shampoo 50ml x 3, Johnson\'s milk + rice cream 30g x 3, Johnson\'s milk + rice cream 50g x 5', 'purchases', 46, 101, '2026-08-29 12:25:58'), (64, '2026-08-29', 'PUR-10', 'PUR-10', 127, 'Capital', 0.00, 4491.00, 'Purchase Invoice #10 | Johnson\'s top-to-toe hair & body bath 100ml x 2, Johnson\'s top-to-toe hair & body bath 200ml x 3, Jolpy acar 400g x 2, Joya Sanitary napkin belt regular flow 8 pads b x 33, Joya Sanitary napkin wings regular flow 8 pads b x 6, Jui Natural pure coconut oil 200ml x 3', 'purchases', 47, 101, '2026-08-29 12:29:49'), (65, '2026-08-29', 'PUR-11', 'PUR-11', 127, 'Capital', 0.00, 3255.00, 'Purchase Invoice #11 | Jui Natural pure coconut oil 350ml x 4, Junior Horlicks stage 2 500g x 2, Kolson Macaroni Assorted Pack 200g x 7, Kolson Macaroni Assorted Pack 400g x 10', 'purchases', 48, 101, '2026-08-29 12:32:20'), (66, '2026-08-29', 'PUR-12', 'PUR-12', 127, 'Capital', 0.00, 1544.00, 'Purchase Invoice #12 | Kumarika hear oil 300ml x 3, Lactogen-02 x 2', 'purchases', 49, 101, '2026-08-29 12:38:03'), (67, '2026-08-29', 'PUR-13', 'PUR-13', 127, 'Capital', 0.00, 2136.00, 'Purchase Invoice #13 | Lactogen-04 x 2, Lactogen-1 x 2, M.cup 40g x 17, Magic Fresh natural gel toothpaste 90g x 5', 'purchases', 50, 101, '2026-08-29 12:46:06'), (68, '2026-08-29', 'PUR-14', 'PUR-14', 127, 'Capital', 0.00, 4796.90, 'Purchase Invoice #14 | Masranga Silver king koyel x 50, Meril Baby Lotion 100ml x 20, Meril Petroliam jelly 50ml x 3, Mirinda 200ml x 3, Misty Boray acar 350g x 2, Mr.Cookie butter coconut biscuit 35g x 3, Mum mum baby pant diaper 4 pcs XL x 4, Mum mum baby pant diaper 5 pcs L x 2', 'purchases', 51, 101, '2026-08-29 12:56:48'), (69, '2026-08-29', 'PUR-15', 'PUR-15', 127, 'Capital', 0.00, 1868.00, 'Purchase Invoice #15 | Navratna oil Ayurvedic cool INDIAN 100ml x 2, Navratna oil Ayurvedic cool 100ml x 3, Navratna oil Ayurvedic cool 50ml x 3, Nescafe Classic 24g x 3, Nutty Biscuits 50g x 26', 'purchases', 52, 101, '2026-08-29 13:08:58'), (70, '2026-08-29', 'PUR-16', 'PUR-16', 127, 'Capital', 0.00, 1470.00, 'Purchase Invoice #16 | Olive oil 100ml (bangla) x 3, Olive oil 100ml (INDIAN) x 3', 'purchases', 53, 101, '2026-08-29 13:10:34'), (71, '2026-08-29', 'PUR-17', 'PUR-17', 127, 'Capital', 0.00, 5812.00, 'Purchase Invoice #17 | Olive oil 150g (INDIAN) x 1, Parachute 300ml x 2, Parachute 175ml x 2, Parachute 33ml x 5, Parachute 95ml x 3, Parachute Belyfull 100ml x 6, Parachute Belyfull 200ml x 1, Parachute Belyfull 300ml x 2, Parachute Belyfull 35ml x 12, Parachute Extra care 300ml x 3, Pond,s bright beauty creme 23g x 8', 'purchases', 54, 101, '2026-08-29 13:22:17'), (72, '2026-08-29', 'PUR-18', 'PUR-18', 127, 'Capital', 0.00, 1435.00, 'Purchase Invoice #18 | Pond,s bright beauty creme 35g (INDIAN) x 4, Pond,s bright beauty creme 50g (INDIAN) x 1', 'purchases', 55, 101, '2026-08-29 13:25:18'), (73, '2026-08-29', 'PUR-19', 'PUR-19', 127, 'Capital', 0.00, 2201.42, 'Purchase Invoice #19 | Pond,s bright beauty creme 35g x 5, Pond,s bright beauty facewash 100g x 6', 'purchases', 56, 101, '2026-08-29 13:27:22'), (74, '2026-08-29', 'PUR-20', 'PUR-20', 127, 'Capital', 0.00, 1600.00, 'Purchase Invoice #20 | Pond,s Bright beauty facewash 50g (INDIAN) x 8', 'purchases', 57, 101, '2026-08-29 13:35:34'), (75, '2026-08-29', 'PUR-21', 'PUR-21', 127, 'Capital', 0.00, 1880.00, 'Purchase Invoice #21 | Pond,s moisturising body lotiom 100g x 9, Pond,s moisturising body lotiom 200g x 2, Pond,s Sandal Powder 100g x 1', 'purchases', 58, 101, '2026-08-29 13:39:34'), (76, '2026-08-29', 'PUR-22', 'PUR-22', 127, 'Capital', 0.00, 1449.00, 'Purchase Invoice #22 | Patata Spicy Biscuits 50g x 19, Pumpkin hair oil 100ml x 1, Pumpkin hair oil 200ml x 5, Pumpkin hair oil 50ml x 1', 'purchases', 59, 101, '2026-08-29 13:46:59'), (77, '2026-08-29', 'PUR-23', 'PUR-23', 127, 'Capital', 0.00, 5675.00, 'Purchase Invoice #23 | Pusti 1L x 5, Pusti 2L x 4, Pusti 3L x 2, Pusti 5L x 2', 'purchases', 60, 101, '2026-08-29 13:48:43'), (78, '2026-08-29', 'PUR-24', 'PUR-24', 127, 'Capital', 0.00, 463.50, 'Purchase Invoice #24 | Radhuni Doniyar gora 100g x 9', 'purchases', 61, 101, '2026-08-29 13:52:15'), (79, '2026-08-29', 'PUR-25', 'PUR-25', 127, 'Capital', 0.00, 2237.90, 'Purchase Invoice #25 | Radhuni Doniyar gora 50g x 9, Radhuni Gorom masalar gora 15g x 20, Radhuni Gorom masalar gora 40g x 16', 'purchases', 62, 101, '2026-08-29 13:57:12'), (80, '2026-08-29', 'PUR-26', 'PUR-26', 127, 'Capital', 0.00, 6801.10, 'Purchase Invoice #26 | Radhuni Halim mix masala 200g x 2, Radhuni Holuder gora 100g x 12, Radhuni Holuder gora 50g x 10, Radhuni Jirar gora 15g x 8, Radhuni Jirar gora 50g x 9, Radhuni kasundi 285ml x 3, Radhuni Khicuri masla 20g x 13, Radhuni Mangser Masla 20g x 33, Radhuni Moricer gora 50g x 27, Radhuni pacforun 50g x 17, Radhuni Ready mix biryani masala 40g x 34, Radhuni Ready mix Rost masala 35g x 14, Radhuni Readymix Bar-B-Q masala 50g x 3', 'purchases', 63, 101, '2026-08-29 14:07:07'), (81, '2026-08-29', 'PUR-27', 'PUR-27', 127, 'Capital', 0.00, 25756.32, 'Purchase Invoice #27 | Radhuni Readymix Cotpoti masala 50g x 2, Radhuni Readymix Gorur Mangser masala 100g x 3, Radhuni Readymix Gorur mangser masala 25g x 29, Radhuni Readymix Kachchi biryani masala 40g x 4, Radhuni Readymix Kala vuna masala 80g x 3, Radhuni Readymix Maser masala 20g x 16, Radhuni Readymix Murgir Mangser masala 100g x 1, Radhuni Readymix Murgir mangser masala 25g x 24, Radhuni Readymix Tehari masala 40g x 5, Red Chili sos 240g x 4, Revive Lotion 100ml x 3, Revive Lotion 200ml x 1, Rexona Quantum dry anti-stain 45ml x 1, Rexonapowder dry + brightening 45ml x 1', 'purchases', 64, 101, '2026-08-29 14:15:38'), (82, '2026-08-29', 'PUR-28', 'PUR-28', 127, 'Capital', 0.00, 5694.20, 'Purchase Invoice #28 | Signal + Coil x 135, Simla tee bag 100g x 8, Sipco 200g x 5, Sipco 500g x 1, Sooper Dooper Biscuits 40g x 10, Sorishar Oil 1L x 3, Sorishar Oil 500m x 2, Sorishar Oil 250ml x 6, Sorishar Oil 80ml x 25, Soya sos 200ml x 2, Soya sos 285ml x 1', 'purchases', 65, 101, '2026-08-29 14:24:43'), (83, '2026-08-29', 'PUR-29', 'PUR-29', 127, 'Capital', 0.00, 315.00, 'Purchase Invoice #29 | Tasting Salt 100g x 9', 'purchases', 66, 101, '2026-08-29 14:31:22'), (84, '2026-08-29', 'PUR-30', 'PUR-30', 127, 'Capital', 0.00, 1212.00, 'Purchase Invoice #30 | Tasting Salt 18g x 31, Tasting Salt 40g x 29, Thai Baby Pants diaper L 34pce x 1', 'purchases', 67, 101, '2026-08-29 14:38:06'), (85, '2026-08-29', 'PUR-31', 'PUR-31', 127, 'Capital', 0.00, 4974.90, 'Purchase Invoice #31 | Thai Baby Pants diaper L 5pce x 4, Thai Baby Pants diaper M 40pce x 1, Thai Baby Pants diaper M 5pce x 2, Thai Baby Pants diaper New Born 5pce x 1, Thai Baby Pants diaper S 42pce x 1, Thai Baby Pants diaper S 5pce x 4, Thai Baby Pants diaper XL 4pce x 2, Tibet Glycerin 60g x 10, Tibet Prickly Heat Skin Powder 100g x 33, Tibet snow 50g x 4, TIP crispy salted biscuits 60g x 15, Vaseline intensive care 100g x 2, Vaseline peroliam jelly 9g x 1', 'purchases', 68, 101, '2026-08-29 14:45:56'), (87, '2026-08-29', 'PUR-32', 'PUR-32', 127, 'Capital', 0.00, 825.00, 'Purchase Invoice #32 | Veet pure hair removal cream 25g x 6, White Tone Face Cream 25g x 3', 'purchases', 69, 101, '2026-08-29 14:48:58'), (88, '2026-08-29', 'PUR-33', 'PUR-33', 127, 'Capital', 0.00, 135.00, 'Purchase Invoice #33 | White Tone Face Powder 30g x 1', 'purchases', 70, 101, '2026-08-29 14:49:36'), (89, '2026-08-29', 'PUR-34', 'PUR-34', 127, 'Capital', 0.00, 1872.00, 'Purchase Invoice #34 | Tibet Luxury talcum powder 100g x 39', 'purchases', 71, 101, '2026-08-29 14:53:22'), (90, '2026-08-29', 'PUR-35', 'PUR-35', 127, 'Capital', 0.00, 675.00, 'Purchase Invoice #35 | Tibet Luxury talcum powder 50g x 25', 'purchases', 72, 101, '2026-08-29 14:54:53'), (91, '2026-08-29', 'PUR-36', 'PUR-36', 127, 'Capital', 0.00, 480.00, 'Purchase Invoice #36 | Ice cool pricly heat skin powder 100g x 10', 'purchases', 73, 101, '2026-08-29 14:55:57'), (92, '2026-08-29', 'PUR-37', 'PUR-37', 127, 'Capital', 0.00, 2341.00, 'Purchase Invoice #37 | Horlicks 250g x 1, Junior Horlicks stage 1 500g x 2, Horlicks 18g x 23, Glumax D 18g x 50, Dove Serum bar 50g x 1, Dove Serum bar 125g x 2', 'purchases', 74, 101, '2026-08-29 16:19:22'), (93, '2026-08-29', 'PUR-38', 'PUR-38', 127, 'Capital', 0.00, 4395.00, 'Purchase Invoice #38 | Wheel 2in 1 Clean & Fresh 1000g x 22, Wheel 2in 1 Clean & Fresh 500g x 27', 'purchases', 75, 101, '2026-08-29 16:51:50'), (94, '2026-08-29', 'PUR-39', 'PUR-39', 127, 'Capital', 0.00, 34510.67, 'Purchase Invoice #39 | Wheel 2in 1 Clean & Fresh 200g x 73, Wheel 125g x 61, Rin Advanced 1000g x 45, Rin Advanced 500g x 198, Rin Advanced 200g x 79, Surf excel 450 x 9, Lux Bouncy & Bright 125g x 7, Lux Smooth & Radiant 125g x 7, Lux Bright Glow 150g x 18, Lux Flaw-less Glow 150g x 9, Lux Bright Glow 100g x 18', 'purchases', 76, 101, '2026-08-29 17:15:16'), (95, '2026-08-29', 'PUR-40', 'PUR-40', 127, 'Capital', 0.00, 1550.00, 'Purchase Invoice #40 | Lux Flaw-less Glow 90g x 21, Lux Bright Glow 90g x 10', 'purchases', 77, 101, '2026-08-29 17:22:18'), (96, '2026-08-29', 'PUR-41', 'PUR-41', 127, 'Capital', 0.00, 2565.00, 'Purchase Invoice #41 | Lifebuoy Lemon fresh 90g x 6, Lifebuoy Skin protect+ 90g x 20, Lifebuoy Total 10 90g x 19, Lifebuoy Lemon fresh 90g x 7', 'purchases', 78, 101, '2026-08-29 17:35:19'), (97, '2026-08-29', 'PUR-42', 'PUR-42', 127, 'Capital', 0.00, 9076.99, 'Purchase Invoice #42 | Vim 300g x 104, Vim 75g x 403, Vim 200g x 17, Vim 475g x 14', 'purchases', 79, 101, '2026-08-29 17:54:25'), (98, '2026-08-29', 'PUR-43', 'PUR-43', 127, 'Capital', 0.00, 620.00, 'Purchase Invoice #43 | Lifebuoy mild care hdndwash 200g x 3, Lifebuoy mild care handwash 170g x 4', 'purchases', 80, 101, '2026-08-29 18:04:36'), (99, '2026-08-29', 'PUR-44', 'PUR-44', 127, 'Capital', 0.00, 160.00, 'Purchase Invoice #44 | Lifebuoy lemon fresh handwash 170g x 2', 'purchases', 81, 101, '2026-08-29 18:11:33'), (100, '2026-08-29', 'PUR-45', 'PUR-45', 127, 'Capital', 0.00, 400.00, 'Purchase Invoice #45 | Lifebuoy lemon fresh handwash 200g x 3, Lifebuoy Total 10 Handwash 200g x 1', 'purchases', 82, 101, '2026-08-29 18:19:20'), (101, '2026-08-29', 'PUR-46', 'PUR-46', 127, 'Capital', 0.00, 6853.00, 'Purchase Invoice #46 | Closeup menthol fresh 85g x 10, Closeup menthol fresh 145g x 12, Pepsodent Germicheck + 40g x 29, Pepsodent Germicheck + 85g x 19, Pepsodent Germicheck + 190g x 10, Pepsodent Germicheck + 190+20g x 2', 'purchases', 83, 101, '2026-08-29 18:38:53'), (102, '2026-08-29', 'PUR-47', 'PUR-47', 127, 'Capital', 0.00, 480.00, 'Purchase Invoice #47 | Pepsodent Germicheck Tooth powder+ 95g x 10', 'purchases', 84, 101, '2026-08-29 18:43:09'), (103, '2026-08-29', 'PUR-48', 'PUR-48', 127, 'Capital', 0.00, 587.50, 'Purchase Invoice #48 | Mini Lux 25g x 31, Mini Lifebuoy lemon fresh 27g x 16', 'purchases', 85, 101, '2026-08-29 18:48:39'), (104, '2026-08-29', 'PUR-49', 'PUR-49', 127, 'Capital', 0.00, 212.50, 'Purchase Invoice #49 | Mini Lifebuoy total 10 27g x 17', 'purchases', 86, 101, '2026-08-29 18:50:56'), (105, '2026-08-29', 'PUR-50', 'PUR-50', 127, 'Capital', 0.00, 6662.50, 'Purchase Invoice #50 | Sunsilk Black shampoo 170g x 5, Sunsilk Golapi shampoo 340g x 1, Surf Excel 35g x 501, Surf Excel 18g x 274', 'purchases', 87, 101, '2026-08-29 19:03:38'), (106, '2026-08-29', 'PUR-51', 'PUR-51', 127, 'Capital', 0.00, 528.50, 'Purchase Invoice #51 | Thai Baby Pants diaper XXL 4pce x 1, Feeding Bottle Taper 250ml/80z x 1, Feeding Bottle Taper 60ml/20z x 2, Thai Silicone Nipple S (0-4) month x 11', 'purchases', 88, 101, '2026-08-29 19:12:51'), (107, '2026-08-29', 'PUR-52', 'PUR-52', 127, 'Capital', 0.00, 3567.75, 'Purchase Invoice #52 | Magic tuth powder 100g x 16, Magic tuth powder 50g x 55, Chamak 50g x 14, Chamak 100g x 18, Hot tomata sos 350g x 1, Tomato Ketchup 350g x 2', 'purchases', 89, 101, '2026-08-29 19:20:50'), (108, '2026-08-29', 'PUR-53', 'PUR-53', 127, 'Capital', 0.00, 1610.10, 'Purchase Invoice #53 | Meril Glisarin 60g x 11, Meril milk soap 100g x 20', 'purchases', 90, 101, '2026-08-29 19:35:21'), (109, '2026-08-29', 'PUR-54', 'PUR-54', 127, 'Capital', 0.00, 8004.70, 'Purchase Invoice #54 | Meril Pure milk soap 100g x 23, Meril milk & Kiwi soap 100g x 7, Chashi sugandhi chinigura chal 1kg x 21, Ruchi muri 400g x 2, Ruchi muri 200g x 6, Ruchi Jal Chanacur 150g x 8, Ruchi Jal Chanacur 300g x 6, Ruchi Bar-B-Q Chanacur 150g x 8, Ruchi Bar-B-Q Chanacur 300g x 7', 'purchases', 91, 101, '2026-08-29 19:52:25'), (110, '2026-08-29', 'PUR-55', 'PUR-55', 127, 'Capital', 0.00, 1264.00, 'Purchase Invoice #55 | Ruchi Jal Chanacur 22g x 26, Ruchi Bar-B-Q Chanacur 22g x 31, Ruchi Peanut Bar 15g x 31, Family pack magic herbal toothpaste 200g x 4', 'purchases', 92, 101, '2026-08-29 20:01:27'), (111, '2026-08-29', 'PUR-56', 'PUR-56', 127, 'Capital', 0.00, 2006.00, 'Purchase Invoice #56 | Orsaline x 94, Taste me orange flavored 16g x 15, Taste me mango flavored 16g x 32, Kolson Macaroni Assorted Pack 500g x 2, Kolson Special Lascha Semai 180g x 26', 'purchases', 93, 101, '2026-08-29 20:08:43'), (112, '2026-08-29', 'PUR-57', 'PUR-57', 127, 'Capital', 0.00, 2948.00, 'Purchase Invoice #57 | Baking Powder 100g x 21, Custard Powder 100g x 8, Corn Flour 100g x 19, Tasty Bit Salt 100g x 8, Bit Salt 100g x 15, Cocoa powder 50g x 6', 'purchases', 94, 101, '2026-08-29 20:17:51'), (113, '2026-08-29', 'PUR-58', 'PUR-58', 127, 'Capital', 0.00, 1898.00, 'Purchase Invoice #58 | Vinegar 300m x 3, Vinegar 550m x 2, Lily beli pearls beauty soap 100g x 11, Lily milk bath beauty soap 100g x 11, Dettol original 70g x 6, Dettol neem 75 x 3, Dettole Skincare 70g x 3', 'purchases', 95, 101, '2026-08-29 20:24:56'), (114, '2026-08-29', 'PUR-59', 'PUR-59', 127, 'Capital', 0.00, 300.00, 'Purchase Invoice #59 | Dettole Skincare 120g x 4', 'purchases', 96, 101, '2026-08-29 20:28:13'), (115, '2026-08-29', 'PUR-60', 'PUR-60', 127, 'Capital', 0.00, 168.00, 'Purchase Invoice #60 | Dettole Skincare 70g x 3', 'purchases', 97, 101, '2026-08-29 20:31:12'), (116, '2026-08-29', 'PUR-61', 'PUR-61', 127, 'Capital', 0.00, 2361.50, 'Purchase Invoice #61 | Sunlite heavy duty bettry x 19, Sunlite Liter x 29, Sun chips 20g x 1, Sun chips tamato tango 20g x 6, Kalojira rosun acar 200g x 1, Mixt acar 400g x 1, Hot Tometo sos 160g x 1, Hot Tomato Sauce 250g x 2, Hot tometo sos 320g x 3, Ziroos 14g x 37, Mr.noodles stick 120g x 18', 'purchases', 98, 101, '2026-08-29 20:50:28'), (117, '2026-08-29', 'PUR-62', 'PUR-62', 127, 'Capital', 0.00, 170.00, 'Purchase Invoice #62 | Hot Tomato Sauce 250g x 2', 'purchases', 99, 101, '2026-08-29 20:53:00'), (118, '2026-08-29', 'PUR-63', 'PUR-63', 127, 'Capital', 0.00, 4738.40, 'Purchase Invoice #63 | Mr. Noodlse Magic Masala 248g x 9, Mr. Noodlse korean 4 pcs 248g x 3, Mr. Noodlse Magic Masala 16 pcs 992g x 2, Mr. Noodlse koriean 8 pcs 496g x 4, Mr. Noodlse Magic Masala 8 pcs 496g x 4, Potata 12g x 86, Mafin cak 16g x 30, Mr. Noodles 30g x 59, Mr.Ramen noodles carbonara 85g x 1, Spcal Tost 250g x 5, Sweet tost 180g x 11', 'purchases', 100, 101, '2026-08-29 21:13:49'), (119, '2026-08-29', 'PUR-64', 'PUR-64', 127, 'Capital', 0.00, 697.08, 'Purchase Invoice #64 | Potata spicy 192g x 3, Kasmery tee 15g x 9, Tee milk instant 15g x 7, Kofi hous 3in 1 14g x 38', 'purchases', 101, 101, '2026-08-29 21:16:06'), (120, '2026-08-30', 'PUR-65', 'PUR-65', 127, 'Capital', 0.00, 1554.20, 'Purchase Invoice #65 | Poteto stic chips 12g x 6, Hot tometo sos 8g x 466, Treat Milk Chocolate Bar 55g x 13', 'purchases', 102, 101, '2026-08-30 03:32:00'), (121, '2026-08-30', 'PUR-66', 'PUR-66', 127, 'Capital', 0.00, 652.00, 'Purchase Invoice #66 | MIsty Boroy x 79, Mr. Noodles Ramen Cheese 58g x 2, Mr. Noodle Ramen Hot Chicken 2X 85g x 3, Sixers Choocolate bar 14g x 13, Milk Bar Choocolate 11g x 4', 'purchases', 103, 101, '2026-08-30 03:42:06'), (122, '2026-08-30', 'PUR-67', 'PUR-67', 127, 'Capital', 0.00, 916.00, 'Purchase Invoice #67 | Belgio Milk Bar 25g x 5, Belgio Strawberry Milk 25g x 2, Belgio Coffee Choocolate 25g x 1, Premio Choco Card 25g x 15, Mama Choocolate Wafer x 3, Coco Choco x 7, Premio Choco Bueno 20g x 10, Buddy Center Filled Wafer 12g x 4, Mama Rollo Wafer 8g x 26, Treat Almond Choocolate 4g x 23, Hurry My Loave Chocolate Wafer 20g x 4, Joyful Orange 100g x 1', 'purchases', 104, 101, '2026-08-30 04:03:33'), (123, '2026-08-30', 'PUR-68', 'PUR-68', 127, 'Capital', 0.00, 155.00, 'Purchase Invoice #68 | Joyful Chocolate 100g x 2, Bubble Gum Orange 14g x 7', 'purchases', 105, 101, '2026-08-30 04:07:53'), (124, '2026-08-30', 'PUR-69', 'PUR-69', 127, 'Capital', 0.00, 1022.73, 'Purchase Invoice #69 | Bubble Gum Banana 14g x 2, Bubble Gum Strawberry 14g x 2, Hurray Gems x 30, Crimaon Choxolate Coon x 28, Wonder Kids 8g x 29, Fried Peas 10g x 8', 'purchases', 106, 101, '2026-08-30 04:38:04'), (125, '2026-08-30', 'PUR-70', 'PUR-70', 127, 'Capital', 0.00, 1497.50, 'Purchase Invoice #70 | Mma Strawberry Wafer 13g x 78, Chco beam Gems 7g x 22, Mango Bar 14g x 19, Rusk x 3, MIlk full cream liqud milk 500ml x 7, MIlk full cream liqud milk 200ml x 12, Jhal Muri 20g x 16', 'purchases', 107, 101, '2026-08-30 04:46:35'), (126, '2026-08-30', 'PUR-71', 'PUR-71', 127, 'Capital', 0.00, 136.26, 'Purchase Invoice #71 | Mounten Dew 200ml x 6', 'purchases', 108, 101, '2026-08-30 05:07:52'), (127, '2026-08-30', 'PUR-72', 'PUR-72', 127, 'Capital', 0.00, 690.00, 'Purchase Invoice #72 | Smc Plus Electrolyte Lemon Drinks 200ml x 12, Smc Plus Electrolyte Drinks 200ml x 11', 'purchases', 109, 101, '2026-08-30 05:10:47'), (128, '2026-08-30', 'PUR-73', 'PUR-73', 127, 'Capital', 0.00, 1665.00, 'Purchase Invoice #73 | Lacchi Frutfan 80ml x 66, Frooto mango fruit Drink 1L x 3, Frooto mango fruit Drink 500ml x 5, Oscar malt beverage 330ml x 15, Oscar malt beverage 250ml x 13', 'purchases', 110, 101, '2026-08-30 05:37:45'), (129, '2026-08-30', 'PUR-74', 'PUR-74', 127, 'Capital', 0.00, 234.00, 'Purchase Invoice #74 | Nutty Biscuits 175g x 2, Premium Toast Biscuits 185g x 3', 'purchases', 111, 101, '2026-08-30 05:41:17'), (130, '2026-08-30', 'PUR-75', 'PUR-75', 127, 'Capital', 0.00, 185.94, 'Purchase Invoice #75 | Knock Wafer Biscuits & chocolate 25g x 15, Knock chocolate coated wafer biscuit with milk cream 25g x 3', 'purchases', 112, 101, '2026-08-30 06:04:28'), (131, '2026-08-30', 'PUR-76', 'PUR-76', 127, 'Capital', 0.00, 160.00, 'Purchase Invoice #76 | Nice Biscuits40g x 19, Orange bite biscuits 40g x 1', 'purchases', 113, 101, '2026-08-30 06:08:07'), (132, '2026-08-30', 'PUR-77', 'PUR-77', 127, 'Capital', 0.00, 920.00, 'Purchase Invoice #77 | Magi-4pac-Nodles x 5, Magi-8pac-Nodles x 3', 'purchases', 114, 101, '2026-08-30 06:09:44'), (133, '2026-08-30', 'PUR-78', 'PUR-78', 127, 'Capital', 0.00, 4072.80, 'Purchase Invoice #78 | Fresh Instant noodels 8 packt 496g x 6, Fresh korean hot & spicy instant noodels 8 packt 496g x 3, Fresh Instant noodels 30g x 5, Fresh Chilli powder 50g x 10, Fresh Turmeric powder 50g x 9, Fresh toilet tissue gold 120g x 1, Fresh toilet tissue white 80g x 17, Fresh Packajed Driking Water 2L x 11, Fresh Packajed Driking Water 1L x 3, Fresh Packajed Driking Water 500ml x 5, Gear 250ml x 39, Fresh UP 250ml x 30', 'purchases', 115, 101, '2026-08-30 06:54:17'), (134, '2026-08-30', 'PUR-79', 'PUR-79', 127, 'Capital', 0.00, 810.40, 'Purchase Invoice #79 | Fresh Googly 250ml x 26, Fresh Googly 500ml x 12', 'purchases', 116, 101, '2026-08-30 06:58:50'), (135, '2026-08-30', 'PUR-80', 'PUR-80', 127, 'Capital', 0.00, 3346.37, 'Purchase Invoice #80 | Farm Fresh Toned milk 500ml x 6, Farm Fresh Chocolate milk 200ml x 3, Farm Fresh Mango milk 200ml x 5, Farm Fresh UHT Chocolate milk 250ml x 18, Farm Fresh UHT Mango milk 200ml x 13, Mojo 250ml x 24, Mojo 500ml x 27, Mojo 2l x 5', 'purchases', 117, 101, '2026-08-30 07:07:25'), (136, '2026-08-30', 'PUR-81', 'PUR-81', 127, 'Capital', 0.00, 4193.98, 'Purchase Invoice #81 | Mojo 1 Ltr x 13, Speed 250ml x 77, Speed ken 250ml x 8, Cheese Puffs 14g x 33, Krancho Potato Crackers chips 15g x 20, Elano Dipstik Chocolate 33g x 2, Fondala milk chocolate bar 20g x 1, Fondala milk chocolate bar 10g x 21, Elano Tempt Chocolate 55g x 5, Fast milk Bread 600g x 1, Fast milk Bread 300g x 2', 'purchases', 118, 101, '2026-08-30 07:16:22'), (137, '2026-08-30', 'PUR-82', 'PUR-82', 127, 'Capital', 0.00, 406.50, 'Purchase Invoice #82 | Fast milk Butter Bread 115g x 4, Fast White Bread 70g x 5, Fast Mixed Fruit Cake 210g x 3', 'purchases', 119, 101, '2026-08-30 07:19:32'), (138, '2026-08-30', 'PUR-83', 'PUR-83', 127, 'Capital', 0.00, 160.00, 'Purchase Invoice #83 | Fast Vanilla Pound Cake 90g x 2', 'purchases', 120, 101, '2026-08-30 07:28:10'), (139, '2026-08-30', 'PUR-84', 'PUR-84', 127, 'Capital', 0.00, 760.00, 'Purchase Invoice #84 | Fast mixed fruits cup cake 18g x 12, Fast soft cake vanilla 40g x 8, Fast lauer cake chocolate 17g x 20, Fast Butter bun Bread 38g x 8, Fast chocolate bun bread 38g x 6, Pillow chocolate filled wafer biscuits 19g x 33', 'purchases', 121, 101, '2026-08-30 07:32:17'), (140, '2026-08-30', 'PUR-85', 'PUR-85', 127, 'Capital', 0.00, 542.42, 'Purchase Invoice #85 | Rong buzz rockzz Chocobin 13g x 6, Fast Chocolate pound cake 37g x 5, Mum mum baby pant diaper 4 pcs XL x 4, Fizzo apple flavored 250ml x 1', 'purchases', 122, 101, '2026-08-30 07:34:28'), (141, '2026-08-30', 'PUR-86', 'PUR-86', 127, 'Capital', 0.00, 1062.00, 'Purchase Invoice #86 | Savlon Fresh soap 100g x 10, Savlon mild soap 100g x 8', 'purchases', 123, 101, '2026-08-30 07:46:24'), (142, '2026-08-30', 'PUR-87', 'PUR-87', 127, 'Capital', 0.00, 65.00, 'Purchase Invoice #87 | Savlon Fresh Soap 125g x 1', 'purchases', 124, 101, '2026-08-30 07:49:08'), (143, '2026-08-30', 'PUR-88', 'PUR-88', 127, 'Capital', 0.00, 1440.00, 'Purchase Invoice #88 | Savlon ocean blue 200g x 4, Savlon aloe vera 200g x 5, Savlon lemon burst 200g x 7', 'purchases', 125, 101, '2026-08-30 08:14:52'), (144, '2026-08-30', 'PUR-89', 'PUR-89', 127, 'Capital', 0.00, 2837.00, 'Purchase Invoice #89 | Coca Cola 1.75L x 10, Bombay Sweets Chanachur 500g x 3, Bombay Sweets Chanachur 300g x 6, Bombay Sweets Chanachur 150g x 2, Bombay Sweets Chanachur 45g x 18, Bombay Sweets Chanachur 18g x 4, Mr.Twist Potato Snacks crisdy chips 15g x 21', 'purchases', 126, 101, '2026-08-30 08:28:11'), (145, '2026-08-30', 'PUR-90', 'PUR-90', 127, 'Capital', 0.00, 248.00, 'Purchase Invoice #90 | Potato Crackers tomato Flavour chips 10g x 31', 'purchases', 127, 101, '2026-08-30 08:33:07'), (146, '2026-08-30', 'PUR-91', 'PUR-91', 127, 'Capital', 0.00, 899.00, 'Purchase Invoice #91 | Bashundhara Gold Toilet Tissue 76g x 26, Bashundhara Toilet Tissue 76g x 9', 'purchases', 128, 101, '2026-08-30 08:35:57'), (147, '2026-08-30', 'PUR-92', 'PUR-92', 127, 'Capital', 0.00, 7.50, 'Purchase Invoice #92 | Bashundhara pocket Tissue Wallet 20pce x 1', 'purchases', 129, 101, '2026-08-30 08:36:52'), (148, '2026-08-30', 'PUR-93', 'PUR-93', 127, 'Capital', 0.00, 948.00, 'Purchase Invoice #93 | Dano Daily pusti milk 200g x 2, Dano Daily pusti milk 10g x 81', 'purchases', 130, 101, '2026-08-30 08:38:30'), (149, '2026-08-30', 'PUR-94', 'PUR-94', 127, 'Capital', 0.00, 5695.00, 'Purchase Invoice #94 | Mediplus DS 140g x 24, Mediplus DS 40g x 20, Mediplus DS 90g x 29', 'purchases', 131, 101, '2026-08-30 08:41:39'), (150, '2026-08-30', 'PUR-95', 'PUR-95', 127, 'Capital', 0.00, 630.00, 'Purchase Invoice #95 | Ist x 18', 'purchases', 132, 101, '2026-08-30 08:43:05'), (151, '2026-08-30', 'PUR-96', 'PUR-96', 127, 'Capital', 0.00, 477.00, 'Purchase Invoice #96 | Horlicks Cookies biscuit 250g x 9', 'purchases', 133, 101, '2026-08-30 08:49:17'), (152, '2026-08-30', 'PUR-97', 'PUR-97', 127, 'Capital', 0.00, 2516.00, 'Purchase Invoice #97 | Diploma instant full cream milk powder 200g x 1, Diploma instant full cream milk powder 50g x 4, Diploma instant full cream milk powder 500g x 2, Diploma instant full cream milk powder 100g x 3, Poppers corn-coconaut puffs 11g x 25, Poppers corn-coconaut puffs 25g x 32, Fresh Turmeric powder 50g x 6', 'purchases', 134, 101, '2026-08-30 08:59:31'), (153, '2026-08-30', 'PUR-98', 'PUR-98', 127, 'Capital', 0.00, 150.00, 'Purchase Invoice #98 | Special Chanachur 280g x 2', 'purchases', 135, 101, '2026-08-30 09:02:29'), (154, '2026-08-30', 'PUR-99', 'PUR-99', 127, 'Capital', 0.00, 425.00, 'Purchase Invoice #99 | Tea-Time cookies biscuit 600g x 1, Ghee Toast 250g x 5', 'purchases', 136, 101, '2026-08-30 09:04:38'), (155, '2026-08-30', 'PUR-100', 'PUR-100', 127, 'Capital', 0.00, 672.00, 'Purchase Invoice #100 | Nick Neck Chocolate 16g x 64, Bourbon Chocolate cream sandwich biscuit 180g x 4', 'purchases', 137, 101, '2026-08-30 09:07:10'), (156, '2026-08-30', 'PUR-101', 'PUR-101', 127, 'Capital', 0.00, 2193.00, 'Purchase Invoice #101 | Kumarika hear oil 400ml x 1, Kumarika hear oil 200ml x 2, Kumarika hear oil 100ml x 9, Kumarika hear oil 50ml x 5', 'purchases', 138, 101, '2026-08-30 09:13:55'), (157, '2026-08-30', 'PUR-102', 'PUR-102', 127, 'Capital', 0.00, 912.00, 'Purchase Invoice #102 | Milk Marie 200g x 6, Mighty chips 14g x 29, Mirzapore tea bags 50g x 14', 'purchases', 139, 101, '2026-08-30 09:24:07'), (158, '2026-08-30', 'PUR-103', 'PUR-103', 127, 'Capital', 0.00, 875.00, 'Purchase Invoice #103 | Mirzapore Best Leaf tea 100g x 3, Mirzapore tea bags 100g x 8', 'purchases', 140, 101, '2026-08-30 09:30:14'), (159, '2026-08-30', 'PUR-104', 'PUR-104', 127, 'Capital', 0.00, 731.50, 'Purchase Invoice #104 | Johnson\'s wiyh milk,turmeric & shea butter baby soap 50g x 3, Johnson\'s wiyh milk,turmeric & shea butter baby soap 75g x 4', 'purchases', 141, 101, '2026-08-30 09:42:09'), (160, '2026-08-30', 'PUR-105', 'PUR-105', 127, 'Capital', 0.00, 703.50, 'Purchase Invoice #105 | Johnson\'s baby oil 100ml x 3', 'purchases', 142, 101, '2026-08-30 09:46:55'), (161, '2026-08-30', 'PUR-106', 'PUR-106', 127, 'Capital', 0.00, 2388.00, 'Purchase Invoice #106 | keya white plus detergent powder 500g x 35, Keya super beauty soap pink 100g x 3, Keya super beauty soap green 100g x 3', 'purchases', 143, 101, '2026-08-30 09:52:27'), (162, '2026-08-30', 'PUR-107', 'PUR-107', 127, 'Capital', 0.00, 1280.00, 'Purchase Invoice #107 | Sandalina sandal & moisturiser Soap 125g x 12, Sandalina sandal & moisturiser Soap 100g x 7, Sandalina sandal & moisturiser Soap 75g x 5', 'purchases', 144, 101, '2026-08-30 09:56:05'), (163, '2026-08-30', 'PUR-108', 'PUR-108', 127, 'Capital', 0.00, 6610.00, 'Purchase Invoice #108 | Tibet 570 laundry soap 125g x 57, Tabet ball soap x 92, Fast Wash synthetic detergent powder 200g x 67, Fast Wash synthetic detergent powder 500g x 14, Tibet Glycerin 125g x 4', 'purchases', 145, 101, '2026-08-30 10:07:05'), (164, '2026-08-30', 'PUR-109', 'PUR-109', 127, 'Capital', 0.00, 416.00, 'Purchase Invoice #109 | Maggi healthe soups corn with chicken flavor 20g x 8', 'purchases', 146, 101, '2026-08-30 10:18:02'), (165, '2026-08-30', 'PUR-110', 'PUR-110', 127, 'Capital', 0.00, 468.00, 'Purchase Invoice #110 | Maggi healthe soups thai 35g x 9', 'purchases', 147, 101, '2026-08-30 10:19:46'), (166, '2026-08-30', 'PUR-111', 'PUR-111', 127, 'Capital', 0.00, 870.00, 'Purchase Invoice #111 | Mr. Noodles Mugol Kachchi 480g x 6', 'purchases', 148, 101, '2026-08-30 10:21:40'), (167, '2026-08-30', 'PUR-112', 'PUR-112', 127, 'Capital', 0.00, 382.50, 'Purchase Invoice #112 | Nescafe 3 in 1 Original x 18, Maggi sad a magik x 35', 'purchases', 149, 101, '2026-08-30 10:23:49'), (168, '2026-08-30', 'PUR-113', 'PUR-113', 127, 'Capital', 0.00, 1345.75, 'Purchase Invoice #113 | Nescafe Classic 0.9 gram x 131, LEXUS Biscuits x 10, Energy Plus Biscuits 16g x 23', 'purchases', 150, 101, '2026-08-30 10:29:59'), (169, '2026-08-30', 'PUR-114', 'PUR-114', 127, 'Capital', 0.00, 840.00, 'Purchase Invoice #114 | Energy Plus Biscuits 185g x 21', 'purchases', 151, 101, '2026-08-30 10:31:07'), (170, '2026-08-30', 'PUR-115', 'PUR-115', 127, 'Capital', 0.00, 1388.25, 'Purchase Invoice #115 | Vermicelli Shemai 200g x 7, Dairy milk chocolate 12g x 136, Dairy milk chocolate 6g x 28, Litchi drinks 125g x 1, Tiffin cake 11g x 41', 'purchases', 152, 101, '2026-08-30 10:45:13'), (171, '2026-08-29', 'PUR-4', 'PUR-4', 127, 'Capital', 0.00, 4576.50, 'Purchase Invoice #4 | Eva by kumarika 200ml x 3, Fit 60g x 19, Fresh hand towel 150 pce x 5, Garnier bright complete vitamin-c face wash 100g x 7, Garnier bright complete vitamin-c face wash 50g x 8', 'purchases', 41, 101, '2026-08-30 10:50:14'), (172, '2026-08-30', 'PUR-116', 'PUR-116', 127, 'Capital', 0.00, 5673.78, 'Purchase Invoice #116 | Sunslik Balck Minipac SHampoo 5.25g x 2133', 'purchases', 153, 101, '2026-08-30 11:00:23'), (173, '2026-08-30', 'PUR-117', 'PUR-117', 127, 'Capital', 0.00, 90.44, 'Purchase Invoice #117 | Sunslick Minipac Shampoo Pink 5.25g x 34', 'purchases', 154, 101, '2026-08-30 11:14:28'), (174, '2026-08-30', 'PUR-118', 'PUR-118', 127, 'Capital', 0.00, 324.00, 'Purchase Invoice #118 | Fresh Exercise Book Math x 12', 'purchases', 155, 101, '2026-08-30 11:35:07'), (175, '2026-08-30', 'PUR-119', 'PUR-119', 127, 'Capital', 0.00, 220.00, 'Purchase Invoice #119 | Classic Dark Chocolate 25g x 10', 'purchases', 156, 101, '2026-08-30 11:38:44'), (176, '2026-08-30', 'PUR-120', 'PUR-120', 127, 'Capital', 0.00, 97.50, 'Purchase Invoice #120 | Strawberry Milk Chocolate 16g x 15', 'purchases', 157, 101, '2026-08-30 11:40:52'), (177, '2026-08-30', 'PUR-121', 'PUR-121', 127, 'Capital', 0.00, 210.00, 'Purchase Invoice #121 | Kitkat 4 F 38.5g x 3', 'purchases', 158, 101, '2026-08-30 11:43:51'), (178, '2026-08-30', 'PUR-122', 'PUR-122', 127, 'Capital', 0.00, 473.00, 'Purchase Invoice #122 | Kitkat 2F 19g x 11', 'purchases', 159, 101, '2026-08-30 11:47:08'), (179, '2026-08-30', 'PUR-123', 'PUR-123', 127, 'Capital', 0.00, 165.00, 'Purchase Invoice #123 | Kitkat 3F 28.5g x 3', 'purchases', 160, 101, '2026-08-30 11:48:14'), (180, '2026-08-30', 'PUR-124', 'PUR-124', 127, 'Capital', 0.00, 612.00, 'Purchase Invoice #124 | LF Dairy Milk Surprise pack 36g x 10, LF Dairy Milk 34g x 16, LF Dairy Milk 20g x 25', 'purchases', 161, 101, '2026-08-30 12:00:00'), (181, '2026-08-30', 'PUR-125', 'PUR-125', 127, 'Capital', 0.00, 1781.50, 'Purchase Invoice #125 | GP Minute Card 29Tk45Delta HMI\r\nModel: DOP 107BV\r\nBrand: Delta\r\nMade in China', 2.00, 'Pcs', 10000.00, 5.00, 10500.00, 21000.00), (55, 4, 'product', 'dfsdf', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (56, 4, 'product', 'dsfsdfsdf', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (57, 5, 'product', 'dsfsdf', 1.00, 'Pcs', 4545.00, 5.00, 4772.25, 4772.25), (58, 5, 'service', 'sdfsdf', 1.00, 'Job', 454.00, 5.00, 476.70, 476.70), (59, 6, 'product', 'df', 1.00, 'Pcs', 545.00, 5.00, 572.25, 572.25), (60, 6, 'service', 'dfd', 1.00, 'Job', 454.00, 5.00, 476.70, 476.70), (61, 7, 'product', 'dsfsd', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (62, 8, 'product', 'dsfsd', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00), (63, 9, 'product', '', 1.00, 'Pcs', 500.00, 5.00, 525.00, 525.00); -- -------------------------------------------------------- -- -- Table structure for table `quotation_terms` -- CREATE TABLE `quotation_terms` ( `id` int(11) NOT NULL, `quotation_id` int(11) DEFAULT NULL, `item_type` varchar(50) NOT NULL DEFAULT 'terms', `item_terms` varchar(20) DEFAULT NULL, `item_name` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `quotation_terms` -- INSERT INTO `quotation_terms` (`id`, `quotation_id`, `item_type`, `item_terms`, `item_name`) VALUES (51, 1, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX excluded)'), (52, 1, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (53, 1, 'terms', 'Delivery', '06 day working days from date of work order'), (54, 1, 'terms', 'Offer time ', '15 days from the date of this offer.'), (55, 1, 'terms', 'Warranty', '12 Months warranty except burn and physical broken issues'), (86, 3, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX included)'), (87, 3, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (88, 3, 'terms', 'Delivery', '01 day working days from date of work order'), (89, 3, 'terms', 'Offer time ', '15 days from the date of this offer.'), (90, 5, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX excluded)'), (91, 5, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (92, 5, 'terms', 'Delivery', '06 day working days from date of work order'), (93, 5, 'terms', 'Offer time ', '15 days from the date of this offer.'), (94, 5, 'terms', 'Warranty', '12 Months warranty except burn and physical broken issues'), (95, 9, 'terms', 'Price & VAT', 'Quoted price is in local currency (VAT & TAX excluded)'), (96, 9, 'terms', 'Payment', '70% advance with work order rest of 30% after successfully delivery goods.'), (97, 9, 'terms', 'Delivery', '06 day working days from date of work order'), (98, 9, 'terms', 'Offer time ', '15 days from the date of this offer.'), (99, 9, 'terms', 'Warranty', '12 Months warranty except burn and physical broken issues'); -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE `role` ( `role_rolecode` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `role` -- INSERT INTO `role` (`role_rolecode`) VALUES ('Accounts'), ('admin'), ('Dealer / Customer'), ('Manager'), ('super admin'); -- -------------------------------------------------------- -- -- Table structure for table `role_rights` -- CREATE TABLE `role_rights` ( `rr_rolecode` varchar(50) NOT NULL, `rr_modulecode` varchar(25) NOT NULL, `receive` enum('yes','no') NOT NULL DEFAULT 'no', `payment` enum('yes','no') NOT NULL DEFAULT 'no', `journal` enum('yes','no') NOT NULL DEFAULT 'no', `dbook` enum('yes','no') NOT NULL DEFAULT 'no', `cashbank` enum('yes','no') NOT NULL DEFAULT 'no', `allladger` enum('yes','no') NOT NULL DEFAULT 'no', `tl` enum('yes','no') NOT NULL DEFAULT 'no', `pl` enum('yes','no') NOT NULL DEFAULT 'no', `bl` enum('yes','no') NOT NULL DEFAULT 'no', `preceive` enum('yes','no') NOT NULL DEFAULT 'no', `pissue` enum('yes','no') NOT NULL DEFAULT 'no', `requisition` enum('yes','no') NOT NULL DEFAULT 'no', `ssumary` enum('yes','no') NOT NULL DEFAULT 'no', `gsumary` enum('yes','no') NOT NULL DEFAULT 'no', `iv` enum('yes','no') NOT NULL DEFAULT 'no', `salaryst` enum('yes','no') NOT NULL DEFAULT 'no', `pladger` enum('yes','no') NOT NULL DEFAULT 'no', `spayable` enum('yes','no') NOT NULL DEFAULT 'no', `asalary` enum('yes','no') NOT NULL DEFAULT 'no', `rsalary` enum('yes','no') NOT NULL DEFAULT 'no', `others` enum('yes','no') NOT NULL DEFAULT 'no', `cu` enum('yes','no') NOT NULL DEFAULT 'no', `ca` enum('yes','no') NOT NULL DEFAULT 'no', `ce` enum('yes','no') NOT NULL DEFAULT 'no', `rr_edit` enum('yes','no') NOT NULL DEFAULT 'no', `rr_delete` enum('yes','no') NOT NULL DEFAULT 'no', `rr_view` enum('yes','no') NOT NULL DEFAULT 'no', `Dealer` enum('yes','no') NOT NULL DEFAULT 'no' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales` -- CREATE TABLE `sales` ( `id` int(11) NOT NULL, `date` date NOT NULL, `sale_no` int(11) NOT NULL, `company_id` int(11) NOT NULL DEFAULT 1, `branch_id` int(11) NOT NULL DEFAULT 1, `customer_id` int(11) NOT NULL, `product_subtotal` decimal(12,2) DEFAULT NULL, `product_discount` decimal(18,2) NOT NULL DEFAULT 0.00, `product_vat_percent` decimal(10,2) NOT NULL DEFAULT 0.00, `product_vat` decimal(18,2) NOT NULL DEFAULT 0.00, `grand_total` decimal(18,2) NOT NULL DEFAULT 0.00, `paid` decimal(18,2) NOT NULL DEFAULT 0.00, `due` decimal(18,2) NOT NULL DEFAULT 0.00, `change_amount` decimal(18,2) NOT NULL DEFAULT 0.00, `invoice_status` enum('Due','Paid','Cancelled') NOT NULL DEFAULT 'Due', `remarks` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `date`, `sale_no`, `company_id`, `branch_id`, `customer_id`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_vat`, `grand_total`, `paid`, `due`, `change_amount`, `invoice_status`, `remarks`, `created_by`, `created_at`) VALUES (4, '2026-08-29', 1, 1, 1, 0, 70.00, 0.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 11:44:56'), (5, '2026-08-29', 2, 1, 1, 0, 70.00, 0.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 11:44:56'), (6, '2026-08-29', 3, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 13:10:58'), (8, '2026-08-29', 4, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 16:33:27'), (9, '2026-08-29', 5, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 17:23:06'), (10, '2026-08-29', 6, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 17:35:55'), (11, '2026-08-29', 7, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 20:11:39'), (12, '2026-08-29', 8, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-29 20:51:21'), (13, '2026-08-30', 9, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 03:04:06'), (14, '2026-08-30', 10, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 03:32:53'), (15, '2026-08-30', 11, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 04:47:14'), (16, '2026-08-30', 12, 1, 1, 0, 230.00, 5.00, 0.00, 0.00, 225.00, 500.00, 0.00, 275.00, 'Paid', NULL, 101, '2026-08-30 04:49:27'), (17, '2026-08-30', 13, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 05:11:51'), (18, '2026-08-30', 14, 1, 1, 133, 345.00, 0.00, 0.00, 0.00, 345.00, 0.00, 345.00, 0.00, 'Due', NULL, 101, '2026-08-30 05:19:41'), (19, '2026-08-30', 15, 1, 1, 0, 45.00, 5.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 05:23:35'), (20, '2026-08-30', 16, 1, 1, 134, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-08-30 05:31:15'), (21, '2026-08-30', 17, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 05:42:06'), (22, '2026-08-30', 18, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 06:36:24'), (23, '2026-08-30', 19, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 06:40:19'), (25, '2026-08-30', 20, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 06:55:15'), (26, '2026-08-30', 21, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 06:59:54'), (27, '2026-08-30', 22, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:09:46'), (28, '2026-08-30', 23, 1, 1, 0, 180.00, 0.00, 0.00, 0.00, 180.00, 180.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:23:26'), (29, '2026-08-30', 24, 1, 1, 0, 90.00, 0.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:24:18'), (30, '2026-08-30', 25, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:24:39'), (31, '2026-08-30', 26, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:37:10'), (32, '2026-08-30', 27, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:54:43'), (33, '2026-08-30', 28, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 07:55:05'), (34, '2026-08-30', 29, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 08:20:50'), (35, '2026-08-30', 30, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 08:29:50'), (36, '2026-08-30', 31, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 09:16:03'), (37, '2026-08-30', 32, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 09:17:53'), (38, '2026-08-30', 33, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 09:26:34'), (39, '2026-08-30', 34, 1, 1, 135, 220.00, 0.00, 0.00, 0.00, 220.00, 0.00, 220.00, 0.00, 'Due', NULL, 101, '2026-08-30 09:35:59'), (40, '2026-08-30', 35, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 09:48:31'), (41, '2026-08-30', 36, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 09:51:12'), (42, '2026-08-30', 37, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 09:59:39'), (43, '2026-08-30', 38, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 10:04:28'), (44, '2026-08-30', 39, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 10:09:58'), (45, '2026-08-30', 40, 1, 1, 136, 20.00, 0.00, 0.00, 0.00, 20.00, 0.00, 20.00, 0.00, 'Due', NULL, 101, '2026-08-30 10:12:13'), (46, '2026-08-30', 41, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 35.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 10:18:56'), (47, '2026-08-30', 42, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 10:39:01'), (48, '2026-08-30', 43, 1, 1, 0, 38.00, 0.00, 0.00, 0.00, 38.00, 38.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 10:50:55'), (49, '2026-08-30', 44, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 11:00:40'), (50, '2026-08-30', 45, 1, 1, 133, 36.00, 0.00, 0.00, 0.00, 36.00, 0.00, 36.00, 0.00, 'Due', NULL, 101, '2026-08-30 11:01:23'), (51, '2026-08-30', 46, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 11:08:26'), (52, '2026-08-30', 47, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 11:09:16'), (53, '2026-08-30', 48, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 11:15:35'), (54, '2026-08-30', 49, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 11:52:21'), (55, '2026-08-30', 50, 1, 1, 136, 55.00, 0.00, 0.00, 0.00, 55.00, 0.00, 55.00, 0.00, 'Due', NULL, 101, '2026-08-30 12:03:31'), (56, '2026-08-30', 51, 1, 1, 136, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-08-30 12:04:18'), (57, '2026-08-30', 52, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:11:46'), (58, '2026-08-30', 53, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:14:38'), (59, '2026-08-30', 54, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:15:27'), (60, '2026-08-30', 55, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:16:28'), (61, '2026-08-30', 56, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:22:55'), (62, '2026-08-30', 57, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:27:58'), (63, '2026-08-30', 58, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:31:22'), (64, '2026-08-30', 59, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:32:19'), (65, '2026-08-30', 60, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 12:38:51'), (66, '2026-08-30', 61, 1, 1, 0, 610.00, 0.00, 0.00, 0.00, 610.00, 700.00, 0.00, 90.00, 'Paid', NULL, 101, '2026-08-30 13:00:06'), (67, '2026-08-30', 62, 1, 1, 0, 290.00, 0.00, 0.00, 0.00, 290.00, 290.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 13:46:46'), (69, '2026-08-30', 63, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:11:38'), (70, '2026-08-30', 64, 1, 1, 138, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-08-30 14:16:34'), (71, '2026-08-30', 65, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:17:13'), (72, '2026-08-30', 66, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:25:16'), (73, '2026-08-30', 67, 1, 1, 0, 90.00, 0.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:29:34'), (74, '2026-08-30', 68, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:31:19'), (75, '2026-08-30', 69, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:42:55'), (76, '2026-08-30', 70, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:43:41'), (77, '2026-08-30', 71, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 14:44:48'), (78, '2026-08-30', 72, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 15:10:48'), (79, '2026-08-30', 73, 1, 1, 0, 80.00, 0.00, 0.00, 0.00, 80.00, 80.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 15:19:20'), (80, '2026-08-30', 74, 1, 1, 0, 105.00, 5.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 15:30:20'), (81, '2026-08-30', 75, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 15:39:02'), (82, '2026-08-30', 76, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 15:41:27'), (83, '2026-08-30', 77, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 15:56:10'), (84, '2026-08-30', 78, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:01:01'), (85, '2026-08-30', 79, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:04:19'), (86, '2026-08-30', 80, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:05:03'), (87, '2026-08-30', 81, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:05:11'), (88, '2026-08-30', 82, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:10:58'), (89, '2026-08-30', 83, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:12:57'), (90, '2026-08-30', 84, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:14:29'), (91, '2026-08-30', 85, 1, 1, 0, 20.00, 5.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:15:54'), (92, '2026-08-30', 86, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:24:46'), (93, '2026-08-30', 87, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:26:13'), (95, '2026-08-30', 88, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:31:54'), (96, '2026-08-30', 89, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:39:53'), (97, '2026-08-30', 90, 1, 1, 0, 70.00, 0.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:51:43'), (98, '2026-08-30', 91, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:54:04'), (99, '2026-08-30', 92, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 16:59:58'), (100, '2026-08-30', 93, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 17:22:23'), (101, '2026-08-30', 94, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 17:27:18'), (102, '2026-08-30', 95, 1, 1, 0, 160.00, 0.00, 0.00, 0.00, 160.00, 160.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 17:46:43'), (103, '2026-08-30', 96, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 17:52:49'), (104, '2026-08-30', 97, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 18:06:23'), (105, '2026-08-30', 98, 1, 1, 0, 48.00, 0.00, 0.00, 0.00, 48.00, 48.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 18:50:39'), (106, '2026-08-30', 99, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-30 19:12:20'), (107, '2026-08-30', 100, 1, 1, 136, 100.00, 20.00, 0.00, 0.00, 80.00, 0.00, 80.00, 0.00, 'Due', NULL, 101, '2026-08-30 19:13:07'), (108, '2026-08-31', 101, 1, 1, 0, 34.00, 0.00, 0.00, 0.00, 34.00, 34.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:10:19'), (109, '2026-08-31', 102, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:11:12'), (110, '2026-08-31', 103, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:11:58'), (111, '2026-08-31', 104, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:12:39'), (112, '2026-08-31', 105, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:25:20'), (113, '2026-08-31', 106, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:26:06'), (114, '2026-08-31', 107, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:39:12'), (115, '2026-08-31', 108, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:49:22'), (116, '2026-08-31', 109, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:53:09'), (117, '2026-08-31', 110, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 02:53:33'), (118, '2026-08-31', 111, 1, 1, 0, 155.00, 10.00, 0.00, 0.00, 145.00, 150.00, 0.00, 5.00, 'Paid', NULL, 101, '2026-08-31 03:15:37'), (119, '2026-08-31', 112, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 03:20:52'), (120, '2026-08-31', 113, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 03:22:30'), (121, '2026-08-31', 114, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 03:32:33'), (122, '2026-08-31', 115, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 03:37:32'), (123, '2026-08-31', 116, 1, 1, 0, 130.00, 0.00, 0.00, 0.00, 130.00, 130.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 03:59:31'), (124, '2026-08-31', 117, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 04:01:21'), (125, '2026-08-31', 118, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 04:32:29'), (126, '2026-08-31', 119, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 04:34:12'), (127, '2026-08-31', 120, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 04:48:15'), (128, '2026-08-31', 121, 1, 1, 0, 26.00, 0.00, 0.00, 0.00, 26.00, 26.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 04:54:43'), (129, '2026-08-31', 122, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 04:59:45'), (130, '2026-08-31', 123, 1, 1, 136, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-08-31 05:02:28'), (131, '2026-08-31', 124, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:20:20'), (132, '2026-08-31', 125, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:25:15'), (133, '2026-08-31', 126, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:26:07'), (134, '2026-08-31', 127, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:29:33'), (135, '2026-08-31', 128, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:42:25'), (136, '2026-08-31', 129, 1, 1, 133, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-08-31 05:43:56'), (137, '2026-08-31', 130, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:45:10'), (138, '2026-08-31', 131, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 05:57:31'), (139, '2026-08-31', 132, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 06:05:55'), (140, '2026-08-31', 133, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 06:08:42'), (141, '2026-08-31', 134, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 06:15:26'), (142, '2026-08-31', 135, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 06:42:38'), (143, '2026-08-31', 136, 1, 1, 0, 220.00, 0.00, 0.00, 0.00, 220.00, 220.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 06:49:46'), (144, '2026-08-31', 137, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 07:03:46'), (145, '2026-08-31', 138, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 07:13:55'), (146, '2026-08-31', 139, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 07:19:31'), (147, '2026-08-31', 140, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 07:30:15'), (148, '2026-08-31', 141, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 07:33:16'), (149, '2026-08-31', 142, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 07:37:34'), (150, '2026-08-31', 143, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 08:06:05'), (151, '2026-08-31', 144, 1, 1, 136, 50.00, 0.00, 0.00, 0.00, 50.00, 0.00, 50.00, 0.00, 'Due', NULL, 101, '2026-08-31 08:07:48'), (152, '2026-08-31', 145, 1, 1, 133, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-08-31 08:13:23'), (153, '2026-08-31', 146, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 08:15:43'), (154, '2026-08-31', 147, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 08:16:31'), (155, '2026-08-31', 148, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 08:18:17'), (156, '2026-08-31', 149, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 09:31:18'), (157, '2026-08-31', 150, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 09:35:32'), (158, '2026-08-31', 151, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 09:41:30'), (159, '2026-08-31', 152, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 10:25:09'), (160, '2026-08-31', 153, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 10:34:59'), (161, '2026-08-31', 154, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 10:37:40'), (162, '2026-08-31', 155, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 10:41:30'), (163, '2026-08-31', 156, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 10:56:38'), (164, '2026-08-31', 157, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:10:05'), (165, '2026-08-31', 158, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:20:41'), (166, '2026-08-31', 159, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:26:57'), (167, '2026-08-31', 160, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:27:34'), (168, '2026-08-31', 161, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:30:12'), (169, '2026-08-31', 162, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:34:32'), (170, '2026-08-31', 163, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:38:46'), (171, '2026-08-31', 164, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:39:49'), (172, '2026-08-31', 165, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:45:16'), (173, '2026-08-31', 166, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 11:51:15'), (174, '2026-08-31', 167, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:03:35'), (175, '2026-08-31', 168, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:05:42'), (176, '2026-08-31', 169, 1, 1, 134, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 0, '2026-08-31 12:07:01'), (177, '2026-08-31', 170, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:13:20'), (178, '2026-08-31', 171, 1, 1, 136, 25.00, 0.00, 0.00, 0.00, 25.00, 0.00, 25.00, 0.00, 'Due', NULL, 0, '2026-08-31 12:14:09'), (179, '2026-08-31', 172, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:16:06'), (180, '2026-08-31', 173, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:19:32'), (181, '2026-08-31', 174, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:21:29'), (182, '2026-08-31', 175, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:24:21'), (183, '2026-08-31', 176, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:25:27'), (184, '2026-08-31', 177, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:27:31'), (185, '2026-08-31', 178, 1, 1, 0, 420.00, 0.00, 0.00, 0.00, 420.00, 500.00, 0.00, 80.00, 'Paid', NULL, 0, '2026-08-31 12:29:31'), (186, '2026-08-31', 179, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:38:02'), (187, '2026-08-31', 180, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:43:43'), (188, '2026-08-31', 181, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:47:10'), (189, '2026-08-31', 182, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:47:48'), (190, '2026-08-31', 183, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:49:21'), (191, '2026-08-31', 184, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 12:52:21'), (192, '2026-08-31', 185, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:07:11'), (193, '2026-08-31', 186, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:08:29'), (194, '2026-08-31', 187, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:13:16'), (195, '2026-08-31', 188, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:13:46'), (196, '2026-08-31', 189, 1, 1, 0, 80.00, 10.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:20:06'), (197, '2026-08-31', 190, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:21:27'), (199, '2026-08-31', 191, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:23:51'), (200, '2026-08-31', 192, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:32:17'), (201, '2026-08-31', 193, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:36:52'), (202, '2026-08-31', 194, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:39:34'), (203, '2026-08-31', 195, 1, 1, 0, 210.00, 10.00, 0.00, 0.00, 200.00, 200.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:41:10'), (204, '2026-08-31', 196, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:45:12'), (205, '2026-08-31', 197, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 13:50:08'), (206, '2026-08-31', 198, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:00:24'), (207, '2026-08-31', 199, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:02:34'), (208, '2026-08-31', 200, 1, 1, 138, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 0, '2026-08-31 14:02:59'), (209, '2026-08-31', 201, 1, 1, 0, 355.00, 15.00, 0.00, 0.00, 340.00, 340.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:13:07'), (210, '2026-08-31', 202, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:17:57'), (211, '2026-08-31', 203, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:22:44'), (212, '2026-08-31', 204, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:40:15'), (213, '2026-08-31', 205, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:50:43'), (214, '2026-08-31', 206, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 14:51:57'), (215, '2026-08-31', 207, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:01:06'), (216, '2026-08-31', 208, 1, 1, 0, 95.00, 5.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:05:09'), (217, '2026-08-31', 209, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:08:52'), (219, '2026-08-31', 210, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:15:22'), (221, '2026-08-31', 211, 1, 1, 133, 20.00, 0.00, 0.00, 0.00, 20.00, 0.00, 20.00, 0.00, 'Due', NULL, 0, '2026-08-31 15:20:46'), (222, '2026-08-31', 212, 1, 1, 0, 175.00, 0.00, 0.00, 0.00, 175.00, 175.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:23:43'), (223, '2026-08-31', 213, 1, 1, 0, 65.00, 0.00, 0.00, 0.00, 65.00, 65.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:26:42'), (224, '2026-08-31', 214, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 15:40:07'), (225, '2026-08-31', 215, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 16:00:10'), (226, '2026-08-31', 216, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 16:06:50'), (227, '2026-08-31', 217, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-08-31 16:18:42'), (228, '2026-08-31', 218, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 16:57:48'), (229, '2026-08-31', 219, 1, 1, 0, 205.00, 5.00, 0.00, 0.00, 200.00, 200.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 17:05:01'), (230, '2026-08-31', 220, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 17:27:38'), (231, '2026-08-31', 221, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 17:36:20'), (232, '2026-08-31', 222, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 17:39:14'), (233, '2026-08-31', 223, 1, 1, 0, 65.00, 0.00, 0.00, 0.00, 65.00, 65.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 17:42:27'), (234, '2026-08-31', 224, 1, 1, 0, 110.00, 20.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-08-31 17:56:02'), (235, '2026-09-01', 225, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 04:15:25'), (236, '2026-09-01', 226, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 04:17:04'), (237, '2026-09-01', 227, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 04:31:54'), (238, '2026-09-01', 228, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 04:34:27'), (239, '2026-09-01', 229, 1, 1, 133, 45.00, 0.00, 0.00, 0.00, 45.00, 0.00, 45.00, 0.00, 'Due', NULL, 101, '2026-09-01 04:41:12'), (240, '2026-09-01', 230, 1, 1, 0, 75.00, 0.00, 0.00, 0.00, 75.00, 75.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 04:44:57'), (241, '2026-09-01', 231, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 04:47:30'), (242, '2026-09-01', 232, 1, 1, 0, 85.00, 0.00, 0.00, 0.00, 85.00, 200.00, 0.00, 115.00, 'Paid', NULL, 101, '2026-09-01 05:00:35'), (243, '2026-09-01', 233, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 05:03:03'), (244, '2026-09-01', 234, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 05:28:14'), (245, '2026-09-01', 235, 1, 1, 0, 90.00, 0.00, 0.00, 0.00, 90.00, 500.00, 0.00, 410.00, 'Paid', NULL, 101, '2026-09-01 05:39:22'), (246, '2026-09-01', 236, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 05:40:21'), (247, '2026-09-01', 237, 1, 1, 0, 240.00, 0.00, 0.00, 0.00, 240.00, 240.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 05:45:53'), (248, '2026-09-01', 238, 1, 1, 0, 45.00, 0.00, 0.00, 0.00, 45.00, 100.00, 0.00, 55.00, 'Paid', NULL, 101, '2026-09-01 05:51:41'), (249, '2026-09-01', 239, 1, 1, 0, 85.00, 0.00, 0.00, 0.00, 85.00, 85.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 05:54:48'), (250, '2026-09-01', 240, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 06:12:51'), (251, '2026-09-01', 241, 1, 1, 0, 570.00, 0.00, 0.00, 0.00, 570.00, 570.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 06:17:47'), (252, '2026-09-01', 242, 1, 1, 142, 40.00, 0.00, 0.00, 0.00, 40.00, 0.00, 40.00, 0.00, 'Due', NULL, 101, '2026-09-01 06:45:36'), (253, '2026-09-01', 243, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 06:58:45'), (254, '2026-09-01', 244, 1, 1, 0, 88.00, 0.00, 0.00, 0.00, 88.00, 88.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 07:24:32'), (255, '2026-09-01', 245, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 07:28:41'), (256, '2026-09-01', 246, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-01 08:02:15'), (257, '2026-09-01', 247, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-01 08:05:14'), (258, '2026-09-01', 248, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-01 08:07:25'), (259, '2026-09-01', 249, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 08:30:23'), (260, '2026-09-01', 250, 1, 1, 0, 150.00, 0.00, 0.00, 0.00, 150.00, 150.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 08:37:09'), (261, '2026-09-01', 251, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 08:37:26'), (262, '2026-09-01', 252, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 1000.00, 0.00, 975.00, 'Paid', NULL, 101, '2026-09-01 08:41:49'), (263, '2026-09-01', 253, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 08:44:45'), (264, '2026-09-01', 254, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 08:53:17'), (265, '2026-09-01', 255, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 09:06:17'), (266, '2026-09-01', 256, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 09:13:48'), (267, '2026-09-01', 257, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 09:17:37'), (268, '2026-09-01', 258, 1, 1, 133, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-09-01 09:19:31'), (269, '2026-09-01', 259, 1, 1, 133, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-09-01 09:27:44'), (270, '2026-09-01', 260, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 09:37:11'), (271, '2026-09-01', 261, 1, 1, 133, 40.00, 0.00, 0.00, 0.00, 40.00, 0.00, 40.00, 0.00, 'Due', NULL, 101, '2026-09-01 09:38:04'), (272, '2026-09-01', 262, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 09:39:12'), (273, '2026-09-01', 263, 1, 1, 136, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-09-01 09:45:51'), (274, '2026-09-01', 264, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 200.00, 0.00, 150.00, 'Paid', NULL, 101, '2026-09-01 09:47:50'), (275, '2026-09-01', 265, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 09:54:43'), (276, '2026-09-01', 266, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:00:10'), (277, '2026-09-01', 267, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:01:55'), (278, '2026-09-01', 268, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:04:39'), (279, '2026-09-01', 269, 1, 1, 133, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-09-01 10:14:23'), (280, '2026-09-01', 270, 1, 1, 0, 160.00, 0.00, 0.00, 0.00, 160.00, 200.00, 0.00, 40.00, 'Paid', NULL, 101, '2026-09-01 10:28:44'), (281, '2026-09-01', 271, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:30:56'), (282, '2026-09-01', 272, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:45:47'), (283, '2026-09-01', 273, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:46:36'), (284, '2026-09-01', 274, 1, 1, 0, 105.00, 5.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:48:50'), (285, '2026-09-01', 275, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 10:49:38'), (286, '2026-09-01', 276, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:07:53'), (287, '2026-09-01', 277, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:08:18'), (288, '2026-09-01', 278, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:11:22'), (289, '2026-09-01', 279, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:20:28'), (290, '2026-09-01', 280, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:22:13'), (291, '2026-09-01', 281, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:25:05'), (292, '2026-09-01', 282, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:25:44'), (293, '2026-09-01', 283, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:27:26'), (294, '2026-09-01', 284, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:31:44'), (295, '2026-09-01', 285, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:32:53'), (296, '2026-09-01', 286, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:35:17'), (297, '2026-09-01', 287, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 500.00, 0.00, 465.00, 'Paid', NULL, 101, '2026-09-01 11:35:50'), (298, '2026-09-01', 288, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:37:40'), (299, '2026-09-01', 289, 1, 1, 135, 75.00, 0.00, 0.00, 0.00, 75.00, 0.00, 75.00, 0.00, 'Due', NULL, 101, '2026-09-01 11:40:44'), (300, '2026-09-01', 290, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:42:26'), (301, '2026-09-01', 291, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:46:13'), (302, '2026-09-01', 292, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:54:27'), (303, '2026-09-01', 293, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 11:59:14'), (304, '2026-09-01', 294, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:01:11'), (305, '2026-09-01', 295, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:08:22'), (306, '2026-09-01', 296, 1, 1, 134, 85.00, 0.00, 0.00, 0.00, 85.00, 0.00, 85.00, 0.00, 'Due', NULL, 101, '2026-09-01 12:11:48'), (307, '2026-09-01', 297, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 1000.00, 0.00, 950.00, 'Paid', NULL, 101, '2026-09-01 12:16:38'), (308, '2026-09-01', 298, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:17:22'), (309, '2026-09-01', 299, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:18:04'), (310, '2026-09-01', 300, 1, 1, 0, 20.00, 5.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:26:02'), (311, '2026-09-01', 301, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:26:13'), (312, '2026-09-01', 302, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:35:06'), (313, '2026-09-01', 303, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:40:27'), (314, '2026-09-01', 304, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:43:15'), (315, '2026-09-01', 305, 1, 1, 0, 175.00, 5.00, 0.00, 0.00, 170.00, 170.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:46:22'), (316, '2026-09-01', 306, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:52:26'), (317, '2026-09-01', 307, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:54:29'), (318, '2026-09-01', 308, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:56:33'), (319, '2026-09-01', 309, 1, 1, 0, 105.00, 5.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 12:58:33'), (320, '2026-09-01', 310, 1, 1, 133, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-09-01 13:02:58'), (321, '2026-09-01', 311, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:03:18'), (322, '2026-09-01', 312, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:15:39'), (323, '2026-09-01', 313, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:19:15'), (324, '2026-09-01', 314, 1, 1, 0, 51.00, 1.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:38:43'), (325, '2026-09-01', 315, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:41:00'), (326, '2026-09-01', 316, 1, 1, 0, 105.00, 0.00, 0.00, 0.00, 105.00, 105.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:47:55'), (327, '2026-09-01', 317, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:48:21'), (328, '2026-09-01', 318, 1, 1, 0, 190.00, 0.00, 0.00, 0.00, 190.00, 190.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:54:39'), (329, '2026-09-01', 319, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 13:55:15'), (330, '2026-09-01', 320, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:03:02'), (331, '2026-09-01', 321, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:05:41'), (332, '2026-09-01', 322, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:07:43'), (333, '2026-09-01', 323, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:08:39'), (334, '2026-09-01', 324, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:40:44'), (335, '2026-09-01', 325, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:41:10'), (336, '2026-09-01', 326, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:45:37'), (337, '2026-09-01', 327, 1, 1, 0, 105.00, 5.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:55:19'), (338, '2026-09-01', 328, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:57:54'), (339, '2026-09-01', 329, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 14:59:51'), (340, '2026-09-01', 330, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 15:04:56'), (342, '2026-09-01', 331, 1, 1, 0, 425.00, 30.00, 0.00, 0.00, 395.00, 1000.00, 0.00, 605.00, 'Paid', NULL, 101, '2026-09-01 15:08:07'), (343, '2026-09-01', 332, 1, 1, 134, 106.00, 0.00, 0.00, 0.00, 106.00, 0.00, 106.00, 0.00, 'Due', NULL, 101, '2026-09-01 15:12:25'), (344, '2026-09-01', 333, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 15:14:08'), (345, '2026-09-01', 334, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 15:17:32'), (346, '2026-09-01', 335, 1, 1, 0, 70.00, 0.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 15:20:13'), (347, '2026-09-01', 336, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 15:58:51'), (348, '2026-09-01', 337, 1, 1, 0, 240.00, 0.00, 0.00, 0.00, 240.00, 500.00, 0.00, 260.00, 'Paid', NULL, 101, '2026-09-01 16:09:16'), (349, '2026-09-01', 338, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:13:21'), (350, '2026-09-01', 339, 1, 1, 0, 85.00, 5.00, 0.00, 0.00, 80.00, 80.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:18:03'), (351, '2026-09-01', 340, 1, 1, 0, 1045.00, 55.00, 0.00, 0.00, 990.00, 990.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:21:45'), (352, '2026-09-01', 341, 1, 1, 144, 30.00, 0.00, 0.00, 0.00, 30.00, 100.00, 0.00, 70.00, 'Paid', NULL, 101, '2026-09-01 16:25:29'), (353, '2026-09-01', 342, 1, 1, 0, 200.00, 0.00, 0.00, 0.00, 200.00, 200.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:32:15'), (354, '2026-09-01', 343, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:49:46'), (355, '2026-09-01', 344, 1, 1, 0, 174.00, 0.00, 0.00, 0.00, 174.00, 174.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:55:40'), (356, '2026-09-01', 345, 1, 1, 0, 75.00, 0.00, 0.00, 0.00, 75.00, 75.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 16:59:22'), (357, '2026-09-01', 346, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:03:33'), (358, '2026-09-01', 347, 1, 1, 0, 75.00, 5.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:06:15'), (359, '2026-09-01', 348, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:07:06'), (360, '2026-09-01', 349, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:13:02'), (361, '2026-09-01', 350, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:20:10'), (362, '2026-09-01', 351, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:21:27'), (363, '2026-09-01', 352, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:27:48'), (364, '2026-09-01', 353, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:30:53'), (365, '2026-09-01', 354, 1, 1, 0, 80.00, 0.00, 0.00, 0.00, 80.00, 80.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:51:49'), (366, '2026-09-01', 355, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 17:58:24'), (367, '2026-09-01', 356, 1, 1, 0, 55.00, 0.00, 0.00, 0.00, 55.00, 55.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 18:08:23'), (368, '2026-09-01', 357, 1, 1, 146, 40.00, 0.00, 0.00, 0.00, 40.00, 0.00, 40.00, 0.00, 'Due', NULL, 101, '2026-09-01 18:19:12'), (369, '2026-09-01', 358, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-01 18:20:33'), (370, '2026-09-02', 359, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:08:45'), (371, '2026-09-02', 360, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:24:52'), (372, '2026-09-02', 361, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:26:29'), (373, '2026-09-02', 362, 1, 1, 0, 70.00, 0.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:32:08'), (374, '2026-09-02', 363, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:35:23'), (375, '2026-09-02', 364, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:39:55'), (376, '2026-09-02', 365, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:40:33'), (377, '2026-09-02', 366, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:43:08'), (378, '2026-09-02', 367, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:49:10'), (379, '2026-09-02', 368, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:51:31'), (380, '2026-09-02', 369, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 01:55:57'), (381, '2026-09-02', 370, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 02:05:57'), (382, '2026-09-02', 371, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 02:12:55'), (383, '2026-09-02', 372, 1, 1, 146, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-09-02 02:30:06'), (384, '2026-09-02', 373, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 02:31:46'), (385, '2026-09-02', 374, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 02:50:48'), (386, '2026-09-02', 375, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 02:56:34'), (387, '2026-09-02', 376, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 03:01:26'), (388, '2026-09-02', 377, 1, 1, 0, 96.00, 0.00, 0.00, 0.00, 96.00, 96.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 03:04:08'), (389, '2026-09-02', 378, 1, 1, 0, 98.00, 0.00, 0.00, 0.00, 98.00, 100.00, 0.00, 2.00, 'Paid', NULL, 101, '2026-09-02 03:08:50'), (391, '2026-09-02', 379, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 03:27:58'), (392, '2026-09-02', 380, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 03:30:12'), (393, '2026-09-02', 381, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 03:36:05'), (394, '2026-09-02', 382, 1, 1, 0, 34.00, 0.00, 0.00, 0.00, 34.00, 100.00, 0.00, 66.00, 'Paid', NULL, 101, '2026-09-02 03:43:34'), (395, '2026-09-02', 383, 1, 1, 148, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-09-02 03:50:22'), (396, '2026-09-02', 384, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 03:53:08'), (397, '2026-09-02', 385, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:04:44'), (398, '2026-09-02', 386, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:16:17'), (399, '2026-09-02', 387, 1, 1, 149, 210.00, 0.00, 0.00, 0.00, 210.00, 0.00, 210.00, 0.00, 'Due', NULL, 101, '2026-09-02 04:19:44'), (400, '2026-09-02', 388, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:22:27'), (401, '2026-09-02', 389, 1, 1, 0, 298.00, 0.00, 0.00, 0.00, 298.00, 298.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:24:57'), (402, '2026-09-02', 390, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 100.00, 0.00, 70.00, 'Paid', NULL, 101, '2026-09-02 04:29:38'), (403, '2026-09-02', 391, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:31:12'), (404, '2026-09-02', 392, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:32:10'), (405, '2026-09-02', 393, 1, 1, 144, 20.00, 0.00, 0.00, 0.00, 20.00, 0.00, 20.00, 0.00, 'Due', NULL, 101, '2026-09-02 04:33:25'), (406, '2026-09-02', 394, 1, 1, 133, 45.00, 0.00, 0.00, 0.00, 45.00, 0.00, 45.00, 0.00, 'Due', NULL, 101, '2026-09-02 04:37:34'), (407, '2026-09-02', 395, 1, 1, 0, 85.00, 0.00, 0.00, 0.00, 85.00, 100.00, 0.00, 15.00, 'Paid', NULL, 101, '2026-09-02 04:39:13'); INSERT INTO `sales` (`id`, `date`, `sale_no`, `company_id`, `branch_id`, `customer_id`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_vat`, `grand_total`, `paid`, `due`, `change_amount`, `invoice_status`, `remarks`, `created_by`, `created_at`) VALUES (408, '2026-09-02', 396, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:42:51'), (409, '2026-09-02', 397, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:49:03'), (410, '2026-09-02', 398, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:50:39'), (411, '2026-09-02', 399, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:54:41'), (412, '2026-09-02', 400, 1, 1, 0, 15.00, 0.00, 0.00, 0.00, 15.00, 15.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 04:58:31'), (413, '2026-09-02', 401, 1, 1, 0, 188.00, 0.00, 0.00, 0.00, 188.00, 188.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:03:34'), (414, '2026-09-02', 402, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:20:13'), (415, '2026-09-02', 403, 1, 1, 0, 148.00, 0.00, 0.00, 0.00, 148.00, 148.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:30:58'), (416, '2026-09-02', 404, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:33:10'), (417, '2026-09-02', 405, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:33:11'), (418, '2026-09-02', 406, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:36:31'), (419, '2026-09-02', 407, 1, 1, 148, 3.00, 0.00, 0.00, 0.00, 3.00, 0.00, 3.00, 0.00, 'Due', NULL, 101, '2026-09-02 05:37:02'), (420, '2026-09-02', 408, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:44:22'), (421, '2026-09-02', 409, 1, 1, 0, 140.00, 40.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:56:52'), (422, '2026-09-02', 410, 1, 1, 0, 140.00, 40.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 05:56:53'), (423, '2026-09-02', 411, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 06:06:46'), (424, '2026-09-02', 412, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 06:12:49'), (425, '2026-09-02', 413, 1, 1, 0, 80.00, 0.00, 0.00, 0.00, 80.00, 80.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 06:42:52'), (426, '2026-09-02', 414, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 06:43:02'), (427, '2026-09-02', 415, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 06:50:42'), (428, '2026-09-02', 416, 1, 1, 0, 160.00, 0.00, 0.00, 0.00, 160.00, 160.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 06:58:16'), (429, '2026-09-02', 417, 1, 1, 0, 65.00, 0.00, 0.00, 0.00, 65.00, 100.00, 0.00, 35.00, 'Paid', NULL, 101, '2026-09-02 07:04:42'), (430, '2026-09-02', 418, 1, 1, 0, 44.00, 0.00, 0.00, 0.00, 44.00, 44.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:06:48'), (431, '2026-09-02', 419, 1, 1, 133, 48.00, 0.00, 0.00, 0.00, 48.00, 0.00, 48.00, 0.00, 'Due', NULL, 101, '2026-09-02 07:14:21'), (432, '2026-09-02', 420, 1, 1, 0, 144.00, 0.00, 0.00, 0.00, 144.00, 144.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:14:40'), (433, '2026-09-02', 421, 1, 1, 0, 175.00, 5.00, 0.00, 0.00, 170.00, 170.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:16:50'), (434, '2026-09-02', 422, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:26:29'), (435, '2026-09-02', 423, 1, 1, 0, 70.00, 0.00, 0.00, 0.00, 70.00, 70.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:27:05'), (436, '2026-09-02', 424, 1, 1, 0, 58.00, 0.00, 0.00, 0.00, 58.00, 58.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:28:27'), (437, '2026-09-02', 425, 1, 1, 148, 5.00, 0.00, 0.00, 0.00, 5.00, 0.00, 5.00, 0.00, 'Due', NULL, 101, '2026-09-02 07:42:12'), (438, '2026-09-02', 426, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:48:17'), (439, '2026-09-02', 427, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:52:25'), (440, '2026-09-02', 428, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 07:55:21'), (441, '2026-09-02', 429, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 08:02:27'), (442, '2026-09-02', 430, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 08:05:47'), (443, '2026-09-02', 431, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 08:07:34'), (444, '2026-09-02', 432, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 08:08:07'), (445, '2026-09-02', 433, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 08:17:10'), (446, '2026-09-02', 434, 1, 1, 133, 70.00, 0.00, 0.00, 0.00, 70.00, 0.00, 70.00, 0.00, 'Due', NULL, 101, '2026-09-02 08:19:57'), (447, '2026-09-02', 435, 1, 1, 0, 140.00, 40.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 08:24:02'), (448, '2026-09-02', 436, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:02:57'), (449, '2026-09-02', 437, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:09:41'), (450, '2026-09-02', 438, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:17:55'), (451, '2026-09-02', 439, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:21:25'), (452, '2026-09-02', 440, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:23:50'), (453, '2026-09-02', 441, 1, 1, 0, 55.00, 0.00, 0.00, 0.00, 55.00, 55.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:34:56'), (454, '2026-09-02', 442, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:47:40'), (455, '2026-09-02', 443, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:48:23'), (456, '2026-09-02', 444, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 09:52:52'), (457, '2026-09-02', 445, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:06:37'), (458, '2026-09-02', 446, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:07:26'), (459, '2026-09-02', 447, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:14:29'), (460, '2026-09-02', 448, 1, 1, 0, 65.00, 5.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:20:52'), (461, '2026-09-02', 449, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:30:42'), (462, '2026-09-02', 450, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 50.00, 0.00, 30.00, 'Paid', NULL, 0, '2026-09-02 10:39:15'), (463, '2026-09-02', 451, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:48:19'), (464, '2026-09-02', 452, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 10:50:42'), (465, '2026-09-02', 453, 1, 1, 0, 120.00, 10.00, 0.00, 0.00, 110.00, 500.00, 0.00, 390.00, 'Paid', NULL, 0, '2026-09-02 11:03:49'), (466, '2026-09-02', 454, 1, 1, 0, 80.00, 0.00, 0.00, 0.00, 80.00, 80.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:06:18'), (467, '2026-09-02', 455, 1, 1, 0, 90.00, 0.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:10:24'), (468, '2026-09-02', 456, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:12:11'), (469, '2026-09-02', 457, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:18:39'), (470, '2026-09-02', 458, 1, 1, 0, 328.00, 0.00, 0.00, 0.00, 328.00, 500.00, 0.00, 172.00, 'Paid', NULL, 0, '2026-09-02 11:24:34'), (471, '2026-09-02', 459, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 35.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:26:07'), (472, '2026-09-02', 460, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:26:54'), (473, '2026-09-02', 461, 1, 1, 134, 105.00, 0.00, 0.00, 0.00, 105.00, 0.00, 105.00, 0.00, 'Due', NULL, 0, '2026-09-02 11:42:45'), (474, '2026-09-02', 462, 1, 1, 0, 48.00, 0.00, 0.00, 0.00, 48.00, 48.00, 0.00, 0.00, 'Paid', NULL, 0, '2026-09-02 11:53:41'), (475, '2026-09-02', 463, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 11:56:23'), (476, '2026-09-02', 464, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 11:59:37'), (477, '2026-09-02', 465, 1, 1, 0, 185.00, 5.00, 0.00, 0.00, 180.00, 1000.00, 0.00, 820.00, 'Paid', NULL, 101, '2026-09-02 12:10:50'), (478, '2026-09-02', 466, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:11:49'), (479, '2026-09-02', 467, 1, 1, 146, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-09-02 12:19:50'), (480, '2026-09-02', 468, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:20:26'), (481, '2026-09-02', 469, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:25:38'), (482, '2026-09-02', 470, 1, 1, 0, 130.00, 0.00, 0.00, 0.00, 130.00, 130.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:33:11'), (483, '2026-09-02', 471, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:38:55'), (484, '2026-09-02', 472, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:45:30'), (485, '2026-09-02', 473, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 35.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:50:13'), (486, '2026-09-02', 474, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:50:48'), (487, '2026-09-02', 475, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:51:33'), (488, '2026-09-02', 476, 1, 1, 0, 95.00, 5.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 12:59:49'), (489, '2026-09-02', 477, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:08:11'), (490, '2026-09-02', 478, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:11:44'), (491, '2026-09-02', 479, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:16:46'), (492, '2026-09-02', 480, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:18:36'), (493, '2026-09-02', 481, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:24:07'), (494, '2026-09-02', 482, 1, 1, 0, 145.00, 0.00, 0.00, 0.00, 145.00, 500.00, 0.00, 355.00, 'Paid', NULL, 101, '2026-09-02 13:28:01'), (495, '2026-09-02', 483, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:29:53'), (496, '2026-09-02', 484, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:33:18'), (497, '2026-09-02', 485, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:39:38'), (498, '2026-09-02', 486, 1, 1, 0, 125.00, 15.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 13:52:48'), (499, '2026-09-02', 487, 1, 1, 0, 90.00, 0.00, 0.00, 0.00, 90.00, 90.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:01:25'), (500, '2026-09-02', 488, 1, 1, 0, 55.00, 0.00, 0.00, 0.00, 55.00, 55.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:04:12'), (501, '2026-09-02', 489, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:04:55'), (502, '2026-09-02', 490, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:08:12'), (503, '2026-09-02', 491, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:11:14'), (504, '2026-09-02', 492, 1, 1, 0, 210.00, 0.00, 0.00, 0.00, 210.00, 500.00, 0.00, 290.00, 'Paid', NULL, 101, '2026-09-02 14:16:32'), (505, '2026-09-02', 493, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:24:39'), (506, '2026-09-02', 494, 1, 1, 0, 110.00, 10.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:42:43'), (507, '2026-09-02', 495, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:43:28'), (508, '2026-09-02', 496, 1, 1, 0, 48.00, 0.00, 0.00, 0.00, 48.00, 48.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:44:51'), (509, '2026-09-02', 497, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 14:48:50'), (510, '2026-09-02', 498, 1, 1, 0, 190.00, 0.00, 0.00, 0.00, 190.00, 190.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:04:11'), (511, '2026-09-02', 499, 1, 1, 0, 45.00, 0.00, 0.00, 0.00, 45.00, 45.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:05:39'), (512, '2026-09-02', 500, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:08:49'), (513, '2026-09-02', 501, 1, 1, 0, 84.00, 4.00, 0.00, 0.00, 80.00, 80.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:17:14'), (514, '2026-09-02', 502, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:19:42'), (515, '2026-09-02', 503, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:20:30'), (516, '2026-09-02', 504, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:28:09'), (517, '2026-09-02', 505, 1, 1, 0, 80.00, 80.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 15:51:03'), (518, '2026-09-02', 506, 1, 1, 0, 230.00, 0.00, 0.00, 0.00, 230.00, 230.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:04:44'), (519, '2026-09-02', 507, 1, 1, 133, 185.00, 0.00, 0.00, 0.00, 185.00, 0.00, 185.00, 0.00, 'Due', NULL, 101, '2026-09-02 16:08:26'), (520, '2026-09-02', 508, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:08:47'), (521, '2026-09-02', 509, 1, 1, 146, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:10:26'), (522, '2026-09-02', 510, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 35.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:11:45'), (523, '2026-09-02', 511, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:15:43'), (524, '2026-09-02', 512, 1, 1, 146, 40.00, 0.00, 0.00, 0.00, 40.00, 0.00, 40.00, 0.00, 'Due', NULL, 101, '2026-09-02 16:21:20'), (525, '2026-09-02', 513, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:47:38'), (526, '2026-09-02', 514, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:48:28'), (527, '2026-09-02', 515, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:48:42'), (528, '2026-09-02', 516, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 16:51:18'), (529, '2026-09-02', 517, 1, 1, 0, 125.00, 0.00, 0.00, 0.00, 125.00, 125.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 17:26:39'), (530, '2026-09-02', 518, 1, 1, 148, 10.00, 0.00, 0.00, 0.00, 10.00, 0.00, 10.00, 0.00, 'Due', NULL, 101, '2026-09-02 17:27:07'), (531, '2026-09-02', 519, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 17:33:32'), (532, '2026-09-02', 520, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-02 17:33:33'), (533, '2026-09-03', 521, 1, 1, 0, 65.00, 5.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 02:15:02'), (534, '2026-09-03', 522, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 02:36:44'), (535, '2026-09-03', 523, 1, 1, 0, 135.00, 0.00, 0.00, 0.00, 135.00, 135.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 02:53:14'), (538, '2026-09-03', 524, 1, 1, 0, 115.00, 0.00, 0.00, 0.00, 115.00, 175.00, 0.00, 60.00, 'Paid', NULL, 101, '2026-09-03 03:17:11'), (540, '2026-09-03', 525, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 03:33:26'), (541, '2026-09-03', 526, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 03:54:00'), (542, '2026-09-03', 527, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 04:10:58'), (543, '2026-09-03', 528, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 04:22:59'), (544, '2026-09-03', 529, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 04:32:20'), (545, '2026-09-03', 530, 1, 1, 146, 3.00, 0.00, 0.00, 0.00, 3.00, 0.00, 3.00, 0.00, 'Due', NULL, 101, '2026-09-03 04:32:47'), (546, '2026-09-03', 531, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 04:44:22'), (547, '2026-09-03', 532, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 04:58:37'), (548, '2026-09-03', 533, 1, 1, 0, 106.00, 1.00, 0.00, 0.00, 105.00, 105.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 05:29:02'), (549, '2026-09-03', 534, 1, 1, 0, 600.00, 0.00, 0.00, 0.00, 600.00, 700.00, 0.00, 100.00, 'Paid', NULL, 101, '2026-09-03 05:35:02'), (550, '2026-09-03', 535, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 05:42:25'), (551, '2026-09-03', 536, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 05:52:19'), (552, '2026-09-03', 537, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 05:56:28'), (553, '2026-09-03', 538, 1, 1, 142, 30.00, 0.00, 0.00, 0.00, 30.00, 0.00, 30.00, 0.00, 'Due', NULL, 101, '2026-09-03 06:04:18'), (554, '2026-09-03', 539, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:05:23'), (555, '2026-09-03', 540, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:13:58'), (556, '2026-09-03', 541, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:18:13'), (557, '2026-09-03', 542, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:28:40'), (558, '2026-09-03', 543, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:30:24'), (559, '2026-09-03', 544, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:31:57'), (560, '2026-09-03', 545, 1, 1, 0, 49.00, 0.00, 0.00, 0.00, 49.00, 50.00, 0.00, 1.00, 'Paid', NULL, 101, '2026-09-03 06:45:56'), (561, '2026-09-03', 546, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:49:24'), (562, '2026-09-03', 547, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 06:55:35'), (563, '2026-09-03', 548, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 07:18:39'), (564, '2026-09-03', 549, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 07:33:17'), (565, '2026-09-03', 550, 1, 1, 136, 105.00, 0.00, 0.00, 0.00, 105.00, 0.00, 105.00, 0.00, 'Due', NULL, 101, '2026-09-03 07:35:04'), (566, '2026-09-03', 551, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 07:35:26'), (567, '2026-09-03', 552, 1, 1, 133, 50.00, 0.00, 0.00, 0.00, 50.00, 0.00, 50.00, 0.00, 'Due', NULL, 101, '2026-09-03 07:41:16'), (568, '2026-09-03', 553, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 07:47:48'), (569, '2026-09-03', 554, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 07:50:12'), (570, '2026-09-03', 555, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 07:53:00'), (571, '2026-09-03', 556, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 09:25:45'), (572, '2026-09-03', 557, 1, 1, 146, 5.00, 0.00, 0.00, 0.00, 5.00, 0.00, 5.00, 0.00, 'Due', NULL, 101, '2026-09-03 09:26:42'), (573, '2026-09-03', 558, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 09:33:58'), (574, '2026-09-03', 559, 1, 1, 134, 90.00, 0.00, 0.00, 0.00, 90.00, 0.00, 90.00, 0.00, 'Due', NULL, 101, '2026-09-03 09:41:17'), (575, '2026-09-03', 560, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 09:42:24'), (576, '2026-09-03', 561, 1, 1, 0, 140.00, 0.00, 0.00, 0.00, 140.00, 140.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 09:44:40'), (577, '2026-09-03', 562, 1, 1, 148, 10.00, 0.00, 0.00, 0.00, 10.00, 5.00, 5.00, 0.00, 'Due', NULL, 101, '2026-09-03 09:52:45'), (578, '2026-09-03', 563, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 09:56:00'), (579, '2026-09-03', 564, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 09:57:21'), (580, '2026-09-03', 565, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:02:31'), (581, '2026-09-03', 566, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:12:20'), (582, '2026-09-03', 567, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:17:09'), (583, '2026-09-03', 568, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:22:24'), (584, '2026-09-03', 569, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:25:42'), (585, '2026-09-03', 570, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:37:01'), (586, '2026-09-03', 571, 1, 1, 0, 108.00, 0.00, 0.00, 0.00, 108.00, 110.00, 0.00, 2.00, 'Paid', NULL, 101, '2026-09-03 10:44:22'), (587, '2026-09-03', 572, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:47:53'), (588, '2026-09-03', 573, 1, 1, 0, 22.00, 0.00, 0.00, 0.00, 22.00, 22.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 10:59:28'), (589, '2026-09-03', 574, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 11:09:36'), (590, '2026-09-03', 575, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 11:19:58'), (591, '2026-09-03', 576, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 11:26:12'), (592, '2026-09-03', 577, 1, 1, 0, 100.00, 0.00, 0.00, 0.00, 100.00, 100.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 11:34:03'), (593, '2026-09-03', 578, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 11:50:38'), (594, '2026-09-03', 579, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:12:48'), (595, '2026-09-03', 580, 1, 1, 0, 118.00, 0.00, 0.00, 0.00, 118.00, 118.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:17:07'), (596, '2026-09-03', 581, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 35.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:20:04'), (597, '2026-09-03', 582, 1, 1, 0, 60.00, 0.00, 0.00, 0.00, 60.00, 60.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:26:04'), (598, '2026-09-03', 583, 1, 1, 0, 24.00, 0.00, 0.00, 0.00, 24.00, 24.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:29:52'), (600, '2026-09-03', 584, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:50:31'), (601, '2026-09-03', 585, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 12:57:41'), (602, '2026-09-03', 586, 1, 1, 0, 25.00, 0.00, 0.00, 0.00, 25.00, 25.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 13:02:04'), (603, '2026-09-03', 587, 1, 1, 0, 120.00, 0.00, 0.00, 0.00, 120.00, 120.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 13:12:12'), (604, '2026-09-03', 588, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 13:35:01'), (605, '2026-09-03', 589, 1, 1, 0, 190.00, 0.00, 0.00, 0.00, 190.00, 190.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 13:44:41'), (606, '2026-09-03', 590, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:04:55'), (607, '2026-09-03', 591, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:07:06'), (608, '2026-09-03', 592, 1, 1, 0, 188.00, 0.00, 0.00, 0.00, 188.00, 188.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:19:48'), (609, '2026-09-03', 593, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:20:03'), (610, '2026-09-03', 594, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:23:38'), (611, '2026-09-03', 595, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:28:36'), (612, '2026-09-03', 596, 1, 1, 0, 40.00, 0.00, 0.00, 0.00, 40.00, 40.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:28:37'), (613, '2026-09-03', 597, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 50.00, 0.00, 45.00, 'Paid', NULL, 101, '2026-09-03 14:29:14'), (614, '2026-09-03', 598, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:29:29'), (615, '2026-09-03', 599, 1, 1, 0, 795.00, 15.00, 0.00, 0.00, 780.00, 780.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:37:16'), (616, '2026-09-03', 600, 1, 1, 0, 35.00, 0.00, 0.00, 0.00, 35.00, 35.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:44:02'), (617, '2026-09-03', 601, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:44:34'), (618, '2026-09-03', 602, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:46:14'), (619, '2026-09-03', 603, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 14:59:42'), (620, '2026-09-03', 604, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:01:02'), (621, '2026-09-03', 605, 1, 1, 148, 20.00, 0.00, 0.00, 0.00, 20.00, 0.00, 20.00, 0.00, 'Due', NULL, 101, '2026-09-03 15:05:59'), (622, '2026-09-03', 606, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:09:54'), (623, '2026-09-03', 607, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:23:42'), (624, '2026-09-03', 608, 1, 1, 0, 475.00, 5.00, 0.00, 0.00, 470.00, 470.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:36:41'), (625, '2026-09-03', 609, 1, 1, 0, 110.00, 0.00, 0.00, 0.00, 110.00, 110.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:42:12'), (626, '2026-09-03', 610, 1, 1, 0, 5.00, 0.00, 0.00, 0.00, 5.00, 5.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:43:23'), (627, '2026-09-03', 611, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:44:23'), (628, '2026-09-03', 612, 1, 1, 0, 30.00, 0.00, 0.00, 0.00, 30.00, 30.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:44:24'), (629, '2026-09-03', 613, 1, 1, 0, 65.00, 0.00, 0.00, 0.00, 65.00, 65.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:45:10'), (630, '2026-09-03', 614, 1, 1, 0, 10.00, 0.00, 0.00, 0.00, 10.00, 10.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:46:41'), (631, '2026-09-03', 615, 1, 1, 0, 560.00, 10.00, 0.00, 0.00, 550.00, 550.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:49:26'), (632, '2026-09-03', 616, 1, 1, 0, 9.00, 0.00, 0.00, 0.00, 9.00, 9.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:58:31'), (633, '2026-09-03', 617, 1, 1, 0, 50.00, 0.00, 0.00, 0.00, 50.00, 50.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:58:58'), (634, '2026-09-03', 618, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 15:59:45'), (635, '2026-09-03', 619, 1, 1, 0, 20.00, 0.00, 0.00, 0.00, 20.00, 20.00, 0.00, 0.00, 'Paid', NULL, 101, '2026-09-03 16:00:02'); -- -------------------------------------------------------- -- -- Table structure for table `sales_invoices` -- CREATE TABLE `sales_invoices` ( `id` int(11) NOT NULL, `invoice_no` int(11) NOT NULL, `invoice_date` date NOT NULL, `company_id` int(11) DEFAULT NULL, `branch_id` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `product_subtotal` decimal(18,2) NOT NULL DEFAULT 0.00, `product_discount` decimal(18,2) NOT NULL DEFAULT 0.00, `product_vat_percent` decimal(10,2) NOT NULL DEFAULT 0.00, `product_vat` decimal(18,2) NOT NULL DEFAULT 0.00, `product_total` decimal(18,2) NOT NULL DEFAULT 0.00, `service_subtotal` decimal(18,2) NOT NULL DEFAULT 0.00, `service_discount` decimal(18,2) NOT NULL DEFAULT 0.00, `service_vat_percent` decimal(10,2) NOT NULL DEFAULT 0.00, `service_vat` decimal(18,2) NOT NULL DEFAULT 0.00, `service_total` decimal(18,2) NOT NULL DEFAULT 0.00, `grand_total` decimal(18,2) NOT NULL DEFAULT 0.00, `remarks` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales_invoices` -- INSERT INTO `sales_invoices` (`id`, `invoice_no`, `invoice_date`, `company_id`, `branch_id`, `customer_id`, `product_subtotal`, `product_discount`, `product_vat_percent`, `product_vat`, `product_total`, `service_subtotal`, `service_discount`, `service_vat_percent`, `service_vat`, `service_total`, `grand_total`, `remarks`, `created_by`, `created_at`) VALUES (1, 1, '2026-07-28', 1, 1, 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 05:24:21'), (2, 2, '2026-07-28', 1, 1, 1, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 07:59:23'), (3, 3, '2026-07-28', 1, 1, 2, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:01:22'), (4, 4, '2026-07-28', 1, 1, 1, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:19:33'), (5, 5, '2026-07-28', 1, 1, 31, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:23:50'), (6, 6, '2026-07-28', 1, 1, 21, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 1, '2026-07-28 08:36:33'); -- -------------------------------------------------------- -- -- Table structure for table `sales_invoice_items` -- CREATE TABLE `sales_invoice_items` ( `id` int(11) NOT NULL, `invoice_id` int(11) NOT NULL, `sale_id` int(11) NOT NULL, `item_type` enum('product','service') NOT NULL, `product_id` int(11) DEFAULT NULL, `item_name` text DEFAULT NULL, `qty` decimal(12,2) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `rate` decimal(12,2) DEFAULT NULL, `amount` decimal(18,2) DEFAULT NULL, `cost_rate` decimal(12,2) NOT NULL DEFAULT 0.00, `cost_amount` decimal(18,2) NOT NULL DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales_items` -- CREATE TABLE `sales_items` ( `id` int(11) NOT NULL, `sale_id` int(11) DEFAULT NULL, `item_type` enum('product','service') NOT NULL, `product_id` int(11) DEFAULT NULL, `item_name` text DEFAULT NULL, `qty` decimal(12,2) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `rate` decimal(12,2) DEFAULT NULL, `amount` decimal(18,2) DEFAULT NULL, `cost_rate` decimal(12,2) NOT NULL DEFAULT 0.00, `cost_amount` decimal(18,2) NOT NULL DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales_items` -- INSERT INTO `sales_items` (`id`, `sale_id`, `item_type`, `product_id`, `item_name`, `qty`, `unit`, `rate`, `amount`, `cost_rate`, `cost_amount`) VALUES (3, 4, 'product', 395, 'Alooz Tomato flavour chips 18g', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (4, 4, 'product', 365, 'Energy Plus Biscuits 40g', 5.00, 'Pcs', 10.00, 50.00, 0.00, 0.00), (5, 5, 'product', 395, 'Alooz Tomato flavour chips 18g', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (6, 5, 'product', 365, 'Energy Plus Biscuits 40g', 5.00, 'Pcs', 10.00, 50.00, 0.00, 0.00), (7, 6, 'product', 485, 'Mirinda 200ml', 2.00, 'Pcs', 25.00, 50.00, 0.00, 0.00), (8, 8, 'product', 395, 'Alooz Tomato flavour chips 18g', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (9, 9, 'product', 391, 'Bombay Sweets Chanachur 80g', 1.00, 'Pcs', 30.00, 30.00, 0.00, 0.00), (10, 10, 'product', 365, 'Energy Plus Biscuits 40g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (11, 11, 'product', 360, 'Biscotti Cookies Biscuits 60g', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (12, 12, 'product', 360, 'Biscotti Cookies Biscuits 60g', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (13, 13, 'product', 34, 'Ziroos 14g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (14, 14, 'product', 32, 'Boom Chocolale', 1.00, 'Pcs', 5.00, 5.00, 0.00, 0.00), (15, 15, 'product', 54, 'MIsty Boroy', 2.00, 'Pcs', 5.00, 10.00, 0.00, 0.00), (16, 16, 'product', 190, 'Chashi sugandhi chinigura chal 1kg', 1.00, 'Pcs', 230.00, 230.00, 0.00, 0.00), (17, 17, 'product', 50, 'Kofi hous 3in 1 14g', 3.00, 'Pcs', 10.00, 30.00, 0.00, 0.00), (18, 18, 'product', 18, 'Hot Tometo sos 200g', 1.00, 'Pcs', 90.00, 90.00, 0.00, 0.00), (19, 18, 'product', 486, 'Mounten Dew 200ml', 1.00, 'Pcs', 25.00, 25.00, 0.00, 0.00), (20, 18, 'product', 190, 'Chashi sugandhi chinigura chal 1kg', 1.00, 'Pcs', 230.00, 230.00, 0.00, 0.00), (21, 19, 'product', 157, 'Corn Flour 100g', 1.00, 'Pcs', 45.00, 45.00, 0.00, 0.00), (22, 20, 'product', 34, 'Ziroos 14g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (23, 21, 'product', 54, 'MIsty Boroy', 1.00, 'Pcs', 5.00, 5.00, 0.00, 0.00), (24, 22, 'product', 376, 'Sooper Dooper Biscuits 40g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (25, 23, 'product', 73, 'Bubble Gum Orange 14g', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (26, 25, 'product', 474, 'Gear 250ml', 1.00, 'Pcs', 25.00, 25.00, 0.00, 0.00), (27, 26, 'product', 34, 'Ziroos 14g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (28, 27, 'product', 433, 'Joya Sanitary napkin belt regular flow 8 pads b', 1.00, 'Pcs', 60.00, 60.00, 0.00, 0.00), (29, 28, 'product', 408, 'Mojo 2l', 1.00, 'Pcs', 120.00, 120.00, 0.00, 0.00), (30, 28, 'product', 395, 'Alooz Tomato flavour chips 18g', 3.00, 'Pcs', 20.00, 60.00, 0.00, 0.00), (31, 29, 'product', 483, '7 up 1L', 1.00, 'Pcs', 90.00, 90.00, 0.00, 0.00), (32, 30, 'product', 57, 'Sixers Choocolate bar 14g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (33, 31, 'product', 43, 'Mr. Noodles 30g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (34, 32, 'product', 365, 'Energy Plus Biscuits 40g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (35, 33, 'product', 427, 'Pillow chocolate filled wafer biscuits 19g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (36, 34, 'product', 425, 'Fast Butter bun Bread 38g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (37, 35, 'product', 415, 'Fondala milk chocolate bar 10g', 2.00, 'Pcs', 10.00, 20.00, 0.00, 0.00), (38, 36, 'product', 44, 'Mr.Ramen noodles carbonara 85g', 1.00, 'Pcs', 50.00, 50.00, 0.00, 0.00), (39, 36, 'product', 55, 'Mr. Noodles Ramen Cheese 58g', 1.00, 'Pcs', 50.00, 50.00, 0.00, 0.00), (40, 37, 'product', 53, 'Treat Milk Chocolate Bar 55g', 1.00, 'Pcs', 50.00, 50.00, 0.00, 0.00), (41, 38, 'product', 41, 'Potata 12g', 1.00, 'Pcs', 5.00, 5.00, 0.00, 0.00), (42, 39, 'product', 287, 'Parachute 175ml', 1.00, 'Pcs', 220.00, 220.00, 0.00, 0.00), (43, 40, 'product', 433, 'Joya Sanitary napkin belt regular flow 8 pads b', 1.00, 'Pcs', 60.00, 60.00, 0.00, 0.00), (44, 41, 'product', 365, 'Energy Plus Biscuits 40g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (45, 42, 'product', 425, 'Fast Butter bun Bread 38g', 2.00, 'Pcs', 10.00, 20.00, 0.00, 0.00), (46, 42, 'product', 426, 'Fast chocolate bun bread 38g', 2.00, 'Pcs', 10.00, 20.00, 0.00, 0.00), (47, 43, 'product', 445, 'Bashundhara pocket Tissue Wallet 20pce', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (48, 44, 'product', 226, 'Ruchi Peanut Bar 15g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (49, 44, 'product', 415, 'Fondala milk chocolate bar 10g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (50, 45, 'product', 473, 'Fresh Packajed Driking Water 500ml', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (51, 46, 'product', 435, 'Smc Plus Electrolyte Drinks 200ml', 1.00, 'Pcs', 35.00, 35.00, 0.00, 0.00), (52, 47, 'product', 399, 'Jhal Muri 20g', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (53, 48, 'product', 177, 'Sorishar Oil 80ml', 1.00, 'Pcs', 38.00, 38.00, 0.00, 0.00), (54, 49, 'product', 387, 'Tiffin cake 11g', 2.00, 'Pcs', 5.00, 10.00, 0.00, 0.00), (55, 50, 'product', 497, 'Sunslik Balck Minipac SHampoo 5.25g', 12.00, 'Pcs', 3.00, 36.00, 0.00, 0.00), (56, 51, 'product', 475, 'Fresh UP 250ml', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (57, 52, 'product', 486, 'Mounten Dew 200ml', 1.00, 'Pcs', 25.00, 25.00, 0.00, 0.00), (59, 53, 'product', 41, 'Potata biscut 12g', 2.00, 'Pcs', 5.00, 10.00, 0.00, 0.00), (60, 54, 'product', 398, 'Dano Daily pusti milk 10g', 2.00, 'Pcs', 10.00, 20.00, 0.00, 0.00), (61, 55, 'product', 409, 'Speed 250ml', 1.00, 'Pcs', 30.00, 30.00, 0.00, 0.00), (62, 55, 'product', 484, '7 up 200ml', 1.00, 'Pcs', 25.00, 25.00, 0.00, 0.00), (63, 56, 'product', 409, 'Speed 250ml', 1.00, 'Pcs', 30.00, 30.00, 0.00, 0.00), (64, 57, 'product', 224, 'Ruchi Jal Chanacur 22g', 2.00, 'Pcs', 10.00, 20.00, 0.00, 0.00), (65, 58, 'product', 417, 'Fast milk Bread 600g', 1.00, 'Pcs', 100.00, 100.00, 0.00, 0.00), (66, 59, 'product', 389, 'Bombay Sweets Chanachur 300g', 1.00, 'Pcs', 100.00, 100.00, 0.00, 0.00), (67, 60, 'product', 353, 'Mighty chips 14g', 2.00, 'Pcs', 10.00, 20.00, 0.00, 0.00), (68, 61, 'product', 473, 'Fresh Packajed Driking Water 500ml', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (69, 62, 'product', 33, 'Lacchi Frutfan 80ml', 1.00, 'Pcs', 10.00, 10.00, 0.00, 0.00), (70, 63, 'product', 498, 'Sunslick Minipac Shampoo Pink 5.25g', 5.00, 'Pcs', 3.00, 15.00, 0.00, 0.00), (71, 63, 'product', 139, 'Mini Lux 25g', 1.00, 'Pcs', 15.00, 15.00, 0.00, 0.00), (72, 64, 'product', 418, 'Fast milk Bread 300g', 1.00, 'Pcs', 60.00, 60.00, 0.00, 0.00), (73, 65, 'product', 475, 'Fresh UP 250ml', 1.00, 'Pcs', 20.00, 20.00, 0.00, 0.00), (74, 66, 'product', 190, 'Chashi sugandhi chinigura chal 1kg', 2.00, 'Pcs', 230.00, 460.00, 0.00, 0.00), (75, 66, 'product', 464, 'Coca Cola 1.75L', 1.00, 'Pcs', 150.00, 150.00, 0.00, 0.00), (76, 67, 'product', 509, 'GP Minute Card 29Tk45