INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cb011ff0-884a-4218-99e1-a9e4783fb262', '18304e74-0118-43cd-b31b-054ca7140ef3', '8afe958d-428e-43df-8036-310f8171a733', 'Aluminium Radiator', NULL, NULL, '19.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cb0e7407-410b-47a0-a5c7-0ca133f0a6fa', '4d25a13f-c472-4266-a4d8-ef9501e24704', 'a5b686ad-9079-433c-8c13-68ae15265509', 'Newspaper', NULL, NULL, '62.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cc419f9d-632e-4a9b-ad29-5f3250ab3b5d', 'b88322ef-b8ad-4bd9-8d36-3a23b883f427', '27a9a2ce-08db-4d1f-8883-65c4a7c42de1', 'Book', NULL, NULL, '40.00', '55.00', '0.00', '5.00', '2200.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cc8c073a-c09c-45a3-8b15-e45d2f449bb9', 'e2ec0ed3-ac3c-4868-ba92-ecfc52389b51', '0e995b57-2d95-415d-adc4-f9491fa2ffbe', 'Syntex', NULL, NULL, '12.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ccbfdc8e-1ff1-41d6-a2ec-95744f9b1869', '4a348600-4a39-422e-ae42-187bd8809f50', 'c57e437b-8f8f-42f2-b2fd-a507ac6e790b', 'Mixy Kadak', NULL, NULL, '38.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cd0fe567-3eb2-4bbe-99ba-eecacb9fc747', '3d8f8c4a-ab34-44be-ad9b-5b3693ad1d78', 'b9d810ee-8496-4c40-8e6a-fb9e1788b9e9', 'Bike', NULL, NULL, '87.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cd23b33b-eb8a-42e7-aecb-35ca9f314c43', 'a04db748-8819-4f3c-a0b6-68ac65c2a092', '2381d9d2-3fbb-47fc-86b6-27adc94b39b3', 'TV kadak', NULL, NULL, '74.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cdd01347-d8ae-488f-bf6c-fb75b199f6b9', '51a0cecd-b5a9-431a-a13d-700053a245ee', '34aceffb-6639-4ddc-b160-a2a145114032', 'Thanni Cover', NULL, NULL, '13.00', '59.00', '0.00', '18.00', '767.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ce7b36ac-9aeb-412a-bece-109c5ebebea2', 'dbeeb12b-c597-4686-87f5-911dee5dc8e3', 'f319e7e2-bb59-451f-8d4c-a1260e2e4762', 'Moodi-2', NULL, NULL, '76.00', '20.00', '0.00', '18.00', '1520.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cea1770f-e716-49ec-a99e-55414c8c4bd7', 'a5ac3c65-b92d-4106-ab21-179779867fdb', '500909c4-a9b0-4d3c-bdee-f495fcec66e0', 'Bed', NULL, NULL, '94.00', '39.00', '0.00', '18.00', '3666.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cee64d77-ac25-47eb-b12c-88a04adf0cf4', 'd87b77f6-2bf5-445e-97e2-e53be81c05b0', '03343b33-787b-479e-a056-ff8a42f5c783', 'Bommai', NULL, NULL, '72.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cf0bd2e5-8be0-484e-9960-12ec29a5628c', '0fc5fc45-58c9-4cbf-8230-dfc90101ec30', '2381d9d2-3fbb-47fc-86b6-27adc94b39b3', 'TV kadak', NULL, NULL, '23.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d16efbea-a9d1-4b78-ab90-b878df28b5ff', '6bd44ea7-d0cd-48a3-925a-0c9340c74ee6', '3e00bf1e-c018-42f4-8fc1-d5ae6d111a38', 'Brake shoe', NULL, NULL, '89.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d1dd16f0-8728-4bdd-85a8-bd5f0b4ed84a', 'b4580712-04c0-4832-9f8f-4a45c06873a7', '89c94811-7134-4f19-bbb3-92507a199cd5', 'Grade', NULL, NULL, '33.00', '50.00', '0.00', '18.00', '1650.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d259922e-3d0e-4fde-b685-d86961a079dc', 'e057cefe-1718-4ba5-b209-62d9669e198d', '5dc05d3b-b70c-487d-b4f3-519cc33e23c4', 'PP', NULL, NULL, '58.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d2bbfe68-7c2a-4c0e-8445-e862ad249406', '6775e5a9-9af9-4c7a-8762-c1a2d8949fca', '89c94811-7134-4f19-bbb3-92507a199cd5', 'Grade', NULL, NULL, '100.00', '50.00', '0.00', '18.00', '5000.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d3e1cfba-4c39-4417-b0ac-9094e3997f6d', 'be5c9158-0e5b-4b00-8a7f-8e82a41c1835', '8af15895-fc70-4ff6-811b-d27075f5b666', 'Tyre', NULL, NULL, '25.00', '62.00', '0.00', '5.00', '1550.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d3ee66fc-501c-4c1c-8b1b-c32fc52e0021', '95ad9be5-5682-4cee-8c4c-34472b15fbaf', 'a1912cf1-626e-4afc-98e3-8eca2cddf7ab', 'SS', NULL, NULL, '36.00', '40.00', '0.00', '5.00', '1440.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d42919ce-40cc-4d42-b0df-c2c55a0c8473', 'bd41bcfb-1020-45f7-ad10-7f9ec7e0bfa7', 'a5b686ad-9079-433c-8c13-68ae15265509', 'Newspaper', NULL, NULL, '56.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d44df05a-fb74-47f3-b643-2a21983a8571', '261078ba-007c-4516-8e54-c2066d80878d', '30a33bd1-d7f8-4187-ad72-7eaf0daf5d2d', 'Udha', NULL, NULL, '42.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d5cfbb0f-9900-479f-a588-11237cf8866c', 'b65338ef-5a8c-4df0-8c0d-2a0ef8ebf218', '30a33bd1-d7f8-4187-ad72-7eaf0daf5d2d', 'Udha', NULL, NULL, '90.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d7230696-ce4c-4cfb-8ae9-89d51972d08a', 'c5f90c03-14f7-49a0-9222-7b06678f9128', '4c6cb695-319c-4755-ade2-aec38e3539ff', 'Tube-Cycle', NULL, NULL, '91.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d744c54e-5070-4083-895a-1018cadd602c', 'e9ab4964-4e85-4d49-83a3-a171e6cb46ae', 'f50d6dcc-861d-48ac-86b0-50ef278bce7e', 'Serattai', NULL, NULL, '106.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d7c50085-01c2-48e2-9820-55fdfa8c6ee8', 'c270bf06-6c33-4a07-bcd0-a307534797b5', '4c6cb695-319c-4755-ade2-aec38e3539ff', 'Tube-Cycle', NULL, NULL, '83.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d7d8a3a5-8d7f-4355-a711-1809fee001f3', '607dfa2c-81f5-4b0b-b792-9ee4fa697f16', '5dc05d3b-b70c-487d-b4f3-519cc33e23c4', 'PP', NULL, NULL, '53.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d8489bf4-1a7e-430b-bfc7-668ace2f3af7', '9fed33c1-6d29-4242-b543-4f60ec12ed2f', '94135124-0a6a-49eb-8005-e4917606e2ef', 'Crystal', NULL, NULL, '105.00', '54.00', '0.00', '18.00', '5670.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d8f57e20-f361-4d97-9ab7-01b5bfc15f22', 'fdb2d430-67ca-4f7e-98ad-843ab4030345', 'c7b43091-b894-4cd6-8f2c-787cb9b2b8a5', 'Food Paper', NULL, NULL, '90.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('da8c3f67-b3e7-433c-9397-a3f42f4d9b5c', '1aab8ef0-d523-407e-947d-fac6221ee063', '9250761b-4666-48d0-a500-9183e1f3dba5', 'VMS', NULL, NULL, '57.00', '27.00', '0.00', '18.00', '1539.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('db3d30f4-7c0c-4fbb-ac65-ee082d555f51', 'a0e567a9-b21a-4b4a-8339-c3a8c44bdbc6', 'f50d6dcc-861d-48ac-86b0-50ef278bce7e', 'Serattai', NULL, NULL, '104.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dbb1aaed-7dca-46b3-9eae-2ecbdee6074b', '112b6cee-51e8-4424-9aeb-1cde793d4fd0', '818e778a-c7c2-411c-a797-f32fded0cbba', 'Kadak', NULL, NULL, '65.00', '43.00', '0.00', '18.00', '2795.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dbc1432a-0652-4325-bd98-59c72a48de77', 'eb6936a3-f804-4beb-b92d-db4c66679b8d', '842d8cbf-6a55-449a-82b1-22eab8776672', 'Chair', NULL, NULL, '27.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dced70f4-28d7-40f5-9a4b-af25242a0bdb', 'ebed3606-a692-41be-9d8d-acea5bf55151', 'b30ba819-e99e-4929-a063-c93bb8fd34a4', 'Battery', NULL, NULL, '13.00', '35.00', '0.00', '5.00', '455.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dd1de3af-e4fa-4ce1-b69b-799a0c916351', '9816e78b-3951-446c-9f5d-9beba02fcd64', '27a9a2ce-08db-4d1f-8883-65c4a7c42de1', 'Book', NULL, NULL, '55.00', '55.00', '0.00', '5.00', '3025.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('de5c0588-af7f-4fc4-b69f-e61eed8532ae', 'eb50e9e1-dda6-4865-844e-44f735a8f6de', '8afe958d-428e-43df-8036-310f8171a733', 'Aluminium Radiator', NULL, NULL, '43.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('de76e785-698d-4e35-bafa-f65b31a1a8e3', 'a4e2cac2-4ecf-4d57-b606-6f6f6147813b', 'c7b43091-b894-4cd6-8f2c-787cb9b2b8a5', 'Food Paper', NULL, NULL, '24.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('def2c8c8-c305-42e0-8019-330a8be1be15', 'e35630a2-6a70-40e2-afa0-8ff0ce37002e', 'dac5f8d6-9ce0-4c46-81bf-6582d9db3efa', 'Kadak', NULL, NULL, '87.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('df212a15-d0c7-4563-b58c-4faf4cf77c04', '43add38d-e3d8-463b-88d6-70ea969d6893', 'c57e437b-8f8f-42f2-b2fd-a507ac6e790b', 'Mixy Kadak', NULL, NULL, '73.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('df9a605f-672a-4dc6-81c4-7e64e226813f', 'fdb2d430-67ca-4f7e-98ad-843ab4030345', 'a13af35a-f223-4ff2-a9c9-f506e4110a30', 'Battery', NULL, NULL, '63.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dfd11cc3-3ecb-405f-8b87-a653bd925038', 'bd48c167-e2f3-464c-8934-0fee3265c8dd', '34aceffb-6639-4ddc-b160-a2a145114032', 'Thanni Cover', NULL, NULL, '14.00', '59.00', '0.00', '18.00', '826.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dfe037df-5dd9-4721-98a6-65cf728a67b5', 'dba2ed22-bc76-403d-94af-f25058d18284', '47e57e58-a51a-4f65-b10c-c51f4e2c31db', 'Thanni Cover', NULL, NULL, '74.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dfe5e97e-5180-4f4a-9b2e-578d83aa6743', '22ab9f62-9ca6-4f41-9fa9-5fa1f30c2beb', '03343b33-787b-479e-a056-ff8a42f5c783', 'Bommai', NULL, NULL, '56.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e02de319-ba1f-49f1-814c-73b144457ff1', '76998c17-c189-45c9-955e-7f3a8f526771', '842d8cbf-6a55-449a-82b1-22eab8776672', 'Chair', NULL, NULL, '31.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e05e8c1a-855c-4998-b2e1-c511e68c4b41', '4850b002-c7ab-4c15-87f4-57923851ab94', '034ba453-b186-4927-945c-cec10cd53f61', 'MS', NULL, NULL, '16.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e0be993a-1488-450a-b816-256d6012a16f', 'c4f58ceb-d681-436f-96ab-f647c8cbef60', '5b0eaece-0e63-4e27-8eb3-ef1433323c3d', 'Chinna Battery', NULL, NULL, '41.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e1127b7a-98f7-4671-ba5c-dce27ac0fe8b', '4308c87e-c192-4372-935e-084b2a0ae8f4', '034ba453-b186-4927-945c-cec10cd53f61', 'MS', NULL, NULL, '104.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e1c0f87c-7422-4bff-b75e-5b83e315dd91', '9aec8576-8e87-41e7-87e5-89d7cf3f2e73', '27a9a2ce-08db-4d1f-8883-65c4a7c42de1', 'Book', NULL, NULL, '46.00', '55.00', '0.00', '5.00', '2530.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e1c7cce8-6b85-45d3-9daf-e770724871ef', '3772b918-16cc-4c1e-baba-f7f40d623f96', '62551ab6-a8be-4b71-987a-d652e511fb38', 'Book', NULL, NULL, '37.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e2544b98-5fdc-4705-b109-9ebd8dcd9a5e', '2f455932-3a32-4218-8f87-944963f4e268', '7eff38fb-841f-4693-9c9f-ded8bf73b620', 'Copper', NULL, NULL, '94.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e3398057-d0ea-48dd-a518-ad93269ee311', 'c13b39d5-4b35-47c2-805f-10e09db699d5', 'a13af35a-f223-4ff2-a9c9-f506e4110a30', 'Battery', NULL, NULL, '63.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e33ff41a-243c-4997-8cc5-9b4e6a0a613a', '4de61e3a-cc31-499d-bddc-f40e92387281', '2e9cc3c0-e8a2-486a-85f0-1efd4c3fb35c', 'Thagaram', NULL, NULL, '96.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e40bb08c-0afc-43db-a508-898445f88e79', 'f84b9b23-7e07-449a-b498-ccd22413e0e7', '0e995b57-2d95-415d-adc4-f9491fa2ffbe', 'Syntex', NULL, NULL, '10.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e4422614-d7ec-4af7-9cd1-a5a3c93ce66b', 'c2376c02-660a-404a-bf60-4a2feeb6ea6f', '2381d9d2-3fbb-47fc-86b6-27adc94b39b3', 'TV kadak', NULL, NULL, '73.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e4bd1544-1e13-4b33-b2a7-f7bfbb4bc1ee', '346446bb-c4d3-49f0-ad73-2c7bd18f7339', '034ba453-b186-4927-945c-cec10cd53f61', 'MS', NULL, NULL, '81.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e52ea5f9-8fc6-4640-be1f-086841df03db', '70c4de54-e8b0-4020-9d3f-96afd5a62006', '8196dca5-60fb-42fc-93ca-2ed9e8746002', 'Aluminium Radiator', NULL, NULL, '35.00', '38.00', '0.00', '5.00', '1330.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e5329fd4-3106-413e-aeb9-340c9b9a51ee', 'd256d1d7-e8d7-4f33-9d79-109bae77f9d9', '34aceffb-6639-4ddc-b160-a2a145114032', 'Thanni Cover', NULL, NULL, '87.00', '59.00', '0.00', '18.00', '5133.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e5793af8-2d19-4431-83aa-3434d0f36579', 'eb6936a3-f804-4beb-b92d-db4c66679b8d', 'c57e437b-8f8f-42f2-b2fd-a507ac6e790b', 'Mixy Kadak', NULL, NULL, '100.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e5ad8ba7-e8bb-4e4e-b0e1-bf1f2a9267c5', '7e1e43c7-7b00-4aae-8523-488f2839a3bf', '3f454755-a724-475f-b1ee-da42744567ef', 'Note', NULL, NULL, '13.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e614f018-367e-4fbc-b09f-529db6d19756', '2de38345-bb4b-427a-9673-c2a954d7edf2', '9e393a98-936d-43ea-ad86-53f9dc234256', 'Moodi-2', NULL, NULL, '20.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e66aa12e-9175-48e0-a9a8-51d71be807d0', '94b2d12d-4e05-4f6d-922f-73d7e6a72d29', '62551ab6-a8be-4b71-987a-d652e511fb38', 'Book', NULL, NULL, '73.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e7816a61-e6bc-43b1-9b84-0c9cd52f501a', '4d25a13f-c472-4266-a4d8-ef9501e24704', 'aeca435d-f209-45ed-9bf8-18bf23ca6fd6', 'Copper Radiator', NULL, NULL, '13.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e8137077-1357-4c5c-929d-74dbabd9e323', 'afd4f92a-0f5f-4974-b8e7-35410de3d701', 'cf0719bb-3a16-41a7-a5bb-01ce9574256d', 'Door PVC', NULL, NULL, '93.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e9a38dc9-8e49-4925-bb6c-f383bd56393f', 'ab9cdf85-27ac-4dc4-8561-76a5d9a1cd3d', '31150efd-7dac-42a4-9d4e-1b3c761a71fd', 'Newspaper', NULL, NULL, '93.00', '32.00', '0.00', '5.00', '2976.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e9bd4dfb-5e5b-4cc4-bd1f-c68bfec7bbee', 'afd4f92a-0f5f-4974-b8e7-35410de3d701', '848ee0b2-2027-47f8-9e47-670dfc1fa48b', 'VMS', NULL, NULL, '62.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('eae069b9-8aee-48af-9396-6cf45c08ead2', 'c4a3ea30-827e-441f-9210-b3e730b16f91', '07af2aa1-a67e-46be-90a4-8fd352851813', 'Wire Koodai', NULL, NULL, '45.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ec41d809-baee-4990-9dbe-5be43d1a026a', '72b9d9b9-0b91-465c-b794-12e398f9e5e8', '9dbd8f4c-af42-4fdb-aed1-f00b4fbb3858', 'PVC', NULL, NULL, '84.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ece72593-5d38-4723-96df-b1a1c002c512', '8115fe79-4e02-4866-8099-057a8c8e95f1', 'dac5f8d6-9ce0-4c46-81bf-6582d9db3efa', 'Kadak', NULL, NULL, '98.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ed41690a-ea0f-4894-bbb4-478b9ba507e4', '2f1236ea-137c-4be5-a2d9-f9ece47a9f7e', '30a33bd1-d7f8-4187-ad72-7eaf0daf5d2d', 'Udha', NULL, NULL, '49.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ed66522b-2fb7-46e2-b83b-c067fe6b79d6', 'be5c9158-0e5b-4b00-8a7f-8e82a41c1835', 'be109b95-1b45-479e-b7e2-5dc98800f4dc', 'Matti', NULL, NULL, '48.00', '44.00', '0.00', '5.00', '2112.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ee3fbcab-d75c-445c-be51-1872e80c49c6', 'fdb2d430-67ca-4f7e-98ad-843ab4030345', 'a14ad477-72c0-424a-a278-1d4696b208e3', 'Pithalai', NULL, NULL, '108.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ee7923de-34a5-4315-b431-10b35765af11', '19e34932-c55f-46eb-a002-8867eb91ec9a', '8196dca5-60fb-42fc-93ca-2ed9e8746002', 'Aluminium Radiator', NULL, NULL, '24.00', '38.00', '0.00', '5.00', '912.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ee7d6490-c7a6-4641-b476-484ce70ba849', '6bd44ea7-d0cd-48a3-925a-0c9340c74ee6', '9dbd8f4c-af42-4fdb-aed1-f00b4fbb3858', 'PVC', NULL, NULL, '97.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('eef669f4-a826-48e6-acd1-8e5eea452884', '488e51e8-d5dd-4e82-a987-a1aec321d5a4', '0a7b00f3-66db-48c0-ac17-885cfc507bd8', 'Tube-Bike', NULL, NULL, '53.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ef1e11b1-7f5f-4fa5-9811-81b219b51cb1', '3fdb3a18-1e0c-4c07-b462-31661193eee0', 'd3abde56-4801-44de-9209-56874148d86a', 'Bed', NULL, NULL, '77.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f0a16468-b656-458e-883e-f4f2d15db848', '99699f55-471c-42f0-80bc-c3d9b66cbdfb', '20b3b2f9-16d0-4815-9909-6e36ec672a7b', 'BC', NULL, NULL, '49.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f108d764-b597-4796-83e3-99b04d92eb06', '261078ba-007c-4516-8e54-c2066d80878d', '0e995b57-2d95-415d-adc4-f9491fa2ffbe', 'Syntex', NULL, NULL, '67.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f1853ee8-7b8c-4123-acd2-273f56a89a4f', '3f640636-4b61-465f-bedc-8b2daf76ce2b', '51e9957f-f016-4f24-be24-cc9c46ed59f4', 'Copper Radiator', NULL, NULL, '70.00', '33.00', '0.00', '18.00', '2310.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f1884d11-f710-47cf-8db0-51a7a8e0622f', 'fc70c781-f1ae-4e95-9ceb-8ab4e0e4bbc9', '1284b049-7381-4219-9494-d40ceceeb679', 'Udaiyal', NULL, NULL, '93.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f20bb1b9-66b3-4dd6-a439-1d40d539ade8', '50c88d54-3a44-45d0-b68b-c7998276c6b6', 'cdcd4692-f37e-4ce1-868f-d26e70408953', 'Bommai', NULL, NULL, '97.00', '31.00', '0.00', '5.00', '3007.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f23ab92c-bcba-4bd7-ba0c-b2070c4822e9', 'd87b77f6-2bf5-445e-97e2-e53be81c05b0', 'd15fedb5-5071-48e9-8098-55ef402168a1', 'Matti', NULL, NULL, '48.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f289d78c-d702-4267-b6fc-6cc50cc2185c', '341b5f1f-91e9-4a19-87aa-2b755f9def2a', '4d2e223d-bc67-4e29-b2ad-481805f4ba00', 'Thagaram', NULL, NULL, '30.00', '63.00', '0.00', '18.00', '1890.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f2acb7ab-4506-48c5-8fc0-20df1a733ebb', '2f628d10-48d3-44ad-92eb-d8b482efea49', 'c57e437b-8f8f-42f2-b2fd-a507ac6e790b', 'Mixy Kadak', NULL, NULL, '19.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f2d76d8f-4a5c-490c-89a7-8afd4e720163', 'afd4f92a-0f5f-4974-b8e7-35410de3d701', '2e9cc3c0-e8a2-486a-85f0-1efd4c3fb35c', 'Thagaram', NULL, NULL, '75.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f2ea3828-f1f6-41d9-8d0d-ca0c26953ab1', '41cff981-c64f-495b-a866-4b55d0c12657', '4d2e223d-bc67-4e29-b2ad-481805f4ba00', 'Thagaram', NULL, NULL, '84.00', '63.00', '0.00', '18.00', '5292.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f3140194-3976-4221-a858-74df2ccc8be3', '2ffb5a8f-634a-462a-a500-8c537fa4a2de', '842d8cbf-6a55-449a-82b1-22eab8776672', 'Chair', NULL, NULL, '30.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f3f48b4a-e399-4d2b-9467-9f4992de906b', 'bd41bcfb-1020-45f7-ad10-7f9ec7e0bfa7', '37d90e82-5069-4b72-85a2-014f2530ae75', 'Beer Tin', NULL, NULL, '66.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f435177e-ee37-47e8-ba4f-a823c7c4d2c5', '9f9925f8-026c-4834-ab27-6a2f2e42e811', 'd6f82fc3-6c07-43da-bc70-ee7979711394', 'Attai', NULL, NULL, '84.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f4727c00-aaee-41e5-b4c3-5fa59d12cc55', 'c96d8435-4a93-4386-bb58-4c0a0388790b', '20fb0a80-9fe6-4f1c-a8f7-ef2022270a6f', 'Note', NULL, NULL, '53.00', '42.00', '0.00', '18.00', '2226.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f49ddfba-fa48-421d-8735-8f09c7d8e4fc', '341b5f1f-91e9-4a19-87aa-2b755f9def2a', '83236763-2ae8-4f41-894a-b09289e43727', 'Bike', NULL, NULL, '108.00', '56.00', '0.00', '5.00', '6048.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f4cd99e7-2848-42eb-aa68-2a72a5548105', 'bd53f73e-a0c6-47e3-8105-0df5a870b7ff', '2e9cc3c0-e8a2-486a-85f0-1efd4c3fb35c', 'Thagaram', NULL, NULL, '108.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f607aa48-6f28-440b-9483-50528cfa7210', '3a254550-af30-47ba-90f7-30e24903cdd8', '8ae8a67b-b300-44c5-b92a-f8ba98f3a6f1', 'Tube-Bike', NULL, NULL, '15.00', '53.00', '0.00', '18.00', '795.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f61f3776-0ce3-4bce-8c97-55ae2886909e', '76998c17-c189-45c9-955e-7f3a8f526771', 'a14ad477-72c0-424a-a278-1d4696b208e3', 'Pithalai', NULL, NULL, '65.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f6d865db-100a-4843-a0fe-1ef641e780d2', 'c4f58ceb-d681-436f-96ab-f647c8cbef60', '074bef30-5f93-4d9c-bd86-89e2704d6322', 'Kudam', NULL, NULL, '55.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f81e854c-3a10-43e0-9861-eea2c1b7b64d', '49902db3-9511-449b-87ff-01537981b5ba', 'a5b686ad-9079-433c-8c13-68ae15265509', 'Newspaper', NULL, NULL, '72.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f88cb05d-717d-4a6c-8e2d-26a854df2512', '95ad9be5-5682-4cee-8c4c-34472b15fbaf', '5b4ff90c-850a-4ab7-bf7c-b47f80f859af', 'Pithalai', NULL, NULL, '32.00', '59.00', '0.00', '18.00', '1888.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f981d5f5-77b9-4042-a7ea-32b3d15b912e', '79ebaa7d-7f3f-46b1-94ed-09d5bb05fa24', '2381d9d2-3fbb-47fc-86b6-27adc94b39b3', 'TV kadak', NULL, NULL, '102.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fa60d029-f05c-41aa-bef3-006be569c4a7', 'bd41bcfb-1020-45f7-ad10-7f9ec7e0bfa7', 'c7b43091-b894-4cd6-8f2c-787cb9b2b8a5', 'Food Paper', NULL, NULL, '96.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fa6e4a69-2e11-4fd2-a6de-78241e10b010', '2a30ed5b-4b0e-44e6-b61b-19e75cc572ad', '3517aec5-bef7-47a3-b7f4-c381ddf219db', 'Periya Battery', NULL, NULL, '74.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fab73c4b-cd90-4407-9697-d896be6590b8', '346446bb-c4d3-49f0-ad73-2c7bd18f7339', '3f454755-a724-475f-b1ee-da42744567ef', 'Note', NULL, NULL, '98.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fb16aad2-bc01-4676-9ac6-15eb4af2663e', '4308c87e-c192-4372-935e-084b2a0ae8f4', '848ee0b2-2027-47f8-9e47-670dfc1fa48b', 'VMS', NULL, NULL, '93.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fb340967-338c-48ba-b56e-a914d36f5c28', '81d048fb-73f5-427a-90dd-a111969e643f', '94135124-0a6a-49eb-8005-e4917606e2ef', 'Crystal', NULL, NULL, '24.00', '54.00', '0.00', '18.00', '1296.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fb677832-2366-4798-a80f-e0b51f57cc11', 'c4a3ea30-827e-441f-9210-b3e730b16f91', 'd6f82fc3-6c07-43da-bc70-ee7979711394', 'Attai', NULL, NULL, '89.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fb6820b2-0ecb-45f7-8422-9db12b48e998', '86a36ff5-c340-43d8-bef4-15d4cbf909bf', 'aeca435d-f209-45ed-9bf8-18bf23ca6fd6', 'Copper Radiator', NULL, NULL, '91.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fcffa7b1-c2f1-4412-bd54-d6c901642079', 'a0e567a9-b21a-4b4a-8339-c3a8c44bdbc6', 'c338f92a-30f3-4eef-a244-1659f9c94974', 'Car', NULL, NULL, '92.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fd2bd8b0-7bb6-4f3a-97ee-634bdd53e87d', 'ac53b63b-0d44-4a4c-93e1-27cb41c979b5', 'aeca435d-f209-45ed-9bf8-18bf23ca6fd6', 'Copper Radiator', NULL, NULL, '35.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fe377a48-58ba-4a3d-ab80-74c1e8bcf6fc', '7a7f45d5-08fb-40ef-b380-8424341c7c46', '47e57e58-a51a-4f65-b10c-c51f4e2c31db', 'Thanni Cover', NULL, NULL, '105.00', '0.00', '0.00', '18.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fe8507a6-26a7-491d-b946-bc89d45725b2', '3feb4635-2d63-4852-b2ed-6c7949e8df36', '9f269cab-f05c-4917-a0fa-5f46f93d5acb', 'Eeya kindu', NULL, NULL, '85.00', '35.00', '0.00', '5.00', '2975.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ff08f347-5110-4275-97ad-a771f5ea4595', '8115fe79-4e02-4866-8099-057a8c8e95f1', 'd15fedb5-5071-48e9-8098-55ef402168a1', 'Matti', NULL, NULL, '17.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `bill_items` (`id`, `bill_id`, `item_id`, `item_name`, `hsn_code`, `unit`, `quantity`, `unit_price`, `discount_percent`, `tax_rate`, `total_price`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ffce8df1-8bf2-4827-be52-5663fd679bca', 'ff56c52b-a139-45ce-8533-229c83f94cc2', '03343b33-787b-479e-a056-ff8a42f5c783', 'Bommai', NULL, NULL, '35.00', '0.00', '0.00', '5.00', '0.00', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);

-- TABLE: payments
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('020e9ac1-0955-4a6a-842d-7ff9f31c770f', 'b88322ef-b8ad-4bd9-8d36-3a23b883f427', '13ed9aeb-c38c-480e-94b4-bd977af41382', 'out', '2026-05-14 00:26:33', '16621.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('06c93821-fee2-4344-8795-865553fc455a', 'dbeeb12b-c597-4686-87f5-911dee5dc8e3', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', 'out', '2026-05-29 00:26:33', '6827.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0a9fe3d8-a047-4176-80f9-6dd9516bc2ce', '2963ca45-1415-465d-8c5b-51d7fd725d9c', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', 'out', '2026-04-19 00:26:33', '9128.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0b534885-be1d-4d72-92f6-e18c4a4c3a87', '9816e78b-3951-446c-9f5d-9beba02fcd64', '7090eee5-197d-4dcf-a509-536622452d5c', 'out', '2026-04-28 00:26:33', '8687.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0c39cd95-2602-48ff-9601-99e7b126e54f', '9fed33c1-6d29-4242-b543-4f60ec12ed2f', '29b3435d-0bee-4b96-92bb-10c43f482b90', 'out', '2026-04-21 00:26:33', '14984.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0d74a2f7-12b0-4f4e-b436-a25166ac16b6', '383d7221-a87e-4a1d-93c0-899bb1e77508', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', 'out', '2026-05-14 00:26:33', '7014.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('15886d09-143a-4168-869a-88b5f2fa7940', 'ab9cdf85-27ac-4dc4-8561-76a5d9a1cd3d', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', 'out', '2026-07-07 00:26:33', '6654.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('17f9bff7-9bb1-49f4-917f-4fe6fca8772c', '1aab8ef0-d523-407e-947d-fac6221ee063', 'c02518fd-c412-4249-b633-88da66b81ab7', 'out', '2026-06-28 00:26:33', '4980.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1e855e5e-ddff-4948-8554-1826c447ac8a', 'ebed3606-a692-41be-9d8d-acea5bf55151', 'eb109f35-7a6d-4f62-8f66-e0712076b5bb', 'out', '2026-04-20 00:26:33', '14569.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1ec24966-064f-4f6c-8640-7d486026c549', 'b3095450-a725-4909-91da-612224482aec', '29b3435d-0bee-4b96-92bb-10c43f482b90', 'out', '2026-06-06 00:26:33', '4288.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2338e976-b1cf-4ce1-b7e9-93e60dcbc3b5', 'c4b217fc-6cba-4dcd-b5f3-37d172b5e28a', 'c02518fd-c412-4249-b633-88da66b81ab7', 'out', '2026-06-21 00:26:33', '9943.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('26419fb9-6fa8-4c5b-87be-dbf4f3c8393d', '6b7ab46f-7b18-4bbf-9847-4988f62cd66c', '29b3435d-0bee-4b96-92bb-10c43f482b90', 'out', '2026-07-03 00:26:33', '4146.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3477c932-cd21-4f0a-b253-1120e0b0f1aa', '7424714d-26f5-4dfb-8365-0dcb860e39b8', 'daa6557d-2131-4f0d-9703-620f1898bb78', 'out', '2026-05-24 00:26:33', '7974.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('38f3a419-4254-4e54-aeff-b966cbe436cd', 'd2387d12-6872-40cd-b307-768e73684040', '29b3435d-0bee-4b96-92bb-10c43f482b90', 'out', '2026-05-15 00:26:33', '11688.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('41b6a27f-7c33-4f26-aa22-d1d6c4926522', '8a9e6d83-9de0-41e2-9474-5e810dd080fb', '8eecceb9-342b-41d2-b690-b4db77524b91', 'out', '2026-07-09 00:26:33', '2331.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('45bb78dd-5626-46aa-858b-91df490bb281', '341b5f1f-91e9-4a19-87aa-2b755f9def2a', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', 'out', '2026-04-21 00:26:33', '7237.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4f02023c-74b8-4403-afba-e24d2294c145', '3f640636-4b61-465f-bedc-8b2daf76ce2b', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', 'out', '2026-07-04 00:26:33', '6441.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('504e29c9-a466-4dad-88dd-7d63b7a51237', '86c56474-ddd1-4b76-b444-1e07e9bc3e49', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', 'out', '2026-06-05 00:26:33', '1359.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6da5fa2b-4839-4f07-8638-8c29fc9824bc', 'bd48c167-e2f3-464c-8934-0fee3265c8dd', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', 'out', '2026-04-23 00:26:33', '975.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('78ac19b6-9196-4672-912b-0b83071d33dd', '19e34932-c55f-46eb-a002-8867eb91ec9a', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', 'out', '2026-06-11 00:26:33', '2313.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7b132818-c00f-4673-b6b4-7fccc01d52fb', '3feb4635-2d63-4852-b2ed-6c7949e8df36', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', 'out', '2026-06-19 00:26:33', '6152.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8028fd01-edde-454e-a67b-a3964ff8158d', '9aec8576-8e87-41e7-87e5-89d7cf3f2e73', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', 'out', '2026-06-17 00:26:33', '5332.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('86140098-d540-4f51-a37f-bab28e23873e', '3ed55931-eb43-4544-a391-8e8ce432ad45', 'daa6557d-2131-4f0d-9703-620f1898bb78', 'out', '2026-05-14 00:26:33', '7048.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8c3ca243-0f02-454f-911f-825c08a86f7f', 'a0aae7a7-605f-4e5a-a4d1-9cb74db3fb28', 'ce9aeb70-45b6-44f0-a8ec-e02369558a2a', 'out', '2026-06-10 00:26:33', '2439.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('92f1a1fd-370e-42c1-9e06-097dbba32e91', 'be5c9158-0e5b-4b00-8a7f-8e82a41c1835', 'ce9aeb70-45b6-44f0-a8ec-e02369558a2a', 'out', '2026-06-12 00:26:33', '5296.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('96aa6203-a678-41d5-ab1e-7e5297657edd', '55c293b0-d4ca-4df1-b89f-d390fdd94404', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', 'out', '2026-05-10 00:26:33', '21669.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('993449c0-8292-4c54-a6b8-48f18e0803dd', '91b0b84c-47c6-425a-85eb-1e63d45d04c5', '7090eee5-197d-4dcf-a509-536622452d5c', 'out', '2026-06-18 00:26:33', '5352.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9fcd9dae-2f6e-41d8-b564-6135030ea476', '51a0cecd-b5a9-431a-a13d-700053a245ee', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', 'out', '2026-04-14 00:26:33', '6148.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a1cf1e28-f767-45bd-a12b-f2c54f1bb397', '95ad9be5-5682-4cee-8c4c-34472b15fbaf', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', 'out', '2026-06-07 00:26:33', '2380.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a4499789-14c0-45ba-b5bf-f74b361cc675', '81d048fb-73f5-427a-90dd-a111969e643f', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', 'out', '2026-05-20 00:26:33', '16606.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a7ac294c-6a88-4b36-931b-797d1e8ff23d', '1f685fa8-60af-4fc9-ae7e-4695dc9ebabe', '101da879-b8ca-419a-bc8f-3cc8fc437769', 'out', '2026-07-02 00:26:33', '2279.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a9a73c96-79b1-426e-be41-35114bb97248', '41cff981-c64f-495b-a866-4b55d0c12657', '7090eee5-197d-4dcf-a509-536622452d5c', 'out', '2026-05-18 00:26:33', '11930.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b0e255f8-999f-4efe-99ff-a771dd4679a9', 'f00baa4e-866c-412c-b90a-21c7bf7452a8', 'e0e63936-74fa-4388-95cb-2726382d5764', 'out', '2026-05-18 00:26:33', '2180.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ba5fd49c-7c32-4c01-9283-e68229ebe868', 'ef4fbf93-1e1c-491b-8ac7-ad6b62c01b64', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', 'out', '2026-06-28 00:26:33', '3856.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('bbb347e2-292d-4219-863d-300371c6e7b1', 'bb92e644-5be0-48b7-a7bd-d6f62d34b2f7', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', 'out', '2026-04-30 00:26:33', '5599.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('bc780f6a-1add-46aa-bcc9-bf700e4c3943', '64b5c3a6-c150-4c6d-983a-12ab5b4cdad0', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', 'out', '2026-04-13 00:26:33', '2961.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c06bfe9d-8d0e-4e45-a2d0-a56275aa5480', '298ecf4f-366c-46ff-99e3-28849d9e4ee2', '29b3435d-0bee-4b96-92bb-10c43f482b90', 'out', '2026-06-23 00:26:33', '4836.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c4075c45-aa28-49e2-8daf-a33da76c85d5', 'b4580712-04c0-4832-9f8f-4a45c06873a7', '101da879-b8ca-419a-bc8f-3cc8fc437769', 'out', '2026-07-06 00:26:33', '5171.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c48a49cc-e26a-4ecd-9faf-02e12df0b238', '20714c7f-fe28-4318-8597-aa619b2224d6', 'c02518fd-c412-4249-b633-88da66b81ab7', 'out', '2026-05-28 00:26:33', '14339.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c4c0cb34-9526-4061-92fc-8ba42797fbae', 'c96d8435-4a93-4386-bb58-4c0a0388790b', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', 'out', '2026-07-08 00:26:33', '8994.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c8d4c748-30dd-48dd-81bf-280c511a0f35', '3ac5eacb-bd94-4493-93b9-eca72d79e40f', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', 'out', '2026-05-15 00:26:33', '10345.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cae2ef63-9ed0-4588-8d37-469245ffa038', 'd68d3799-45b8-4cbe-afdc-7982356e19fc', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', 'out', '2026-04-15 00:26:33', '1277.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d1898157-850f-4f3e-834a-ef52cc25411c', 'dcf76cad-775f-4b97-b6d7-3e5ed568b890', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', 'out', '2026-06-20 00:26:33', '207.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d6482834-a5f6-4531-bb6c-669df63b20c4', '24d20977-00c4-490c-b382-1a23b4cc60f8', 'e0e63936-74fa-4388-95cb-2726382d5764', 'out', '2026-04-29 00:26:33', '4260.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e7c9faa7-8fe0-471c-a5b7-6fb59b3b8d17', '645efeac-ae96-4dc7-8ca0-e2306841eef6', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', 'out', '2026-04-21 00:26:33', '7749.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ef8c495a-34a4-4717-babf-29c0439ab83d', '6775e5a9-9af9-4c7a-8762-c1a2d8949fca', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', 'out', '2026-04-24 00:26:33', '4663.50', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('efcc6ec0-5b4e-4eee-b9ae-04e288d8c362', 'a5ac3c65-b92d-4106-ab21-179779867fdb', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', 'out', '2026-05-19 00:26:33', '11199.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f131790d-dd31-4c05-9f8a-826ed5a395d3', '25140a05-c96b-4b38-b07d-7da3fb234fef', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', 'out', '2026-06-29 00:26:33', '9553.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f31a00ac-0e85-4c0f-a7a9-4b5a7c8859ba', '5e14fa6f-2243-47b5-8f29-1ac4c8b748ff', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', 'out', '2026-06-17 00:26:33', '9056.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `payments` (`id`, `bill_id`, `party_id`, `type`, `date`, `amount`, `payment_mode`, `reference_number`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f41934d6-7f3c-4975-8553-42d4fe95759d', 'd256d1d7-e8d7-4f33-9d79-109bae77f9d9', '7c070003-29af-48fb-88ef-ec752cd440b1', 'out', '2026-06-05 00:26:33', '7780.00', 'cash', NULL, NULL, '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);

-- TABLE: party_ledgers
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('001da87f-9a35-45ce-9017-0b64cab6b9ca', '615fa6aa-6fd8-4492-966b-395f5ef34a4c', '2026-05-15 00:26:33', 'sale', 'e97a0373-ec2f-4b42-ad19-188e0f3bc03a', '0.00', '0.00', '0.00', 'Bill INV-2026-0067', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('03872cbe-2b78-4da6-adae-c2c1713d0cef', '7090eee5-197d-4dcf-a509-536622452d5c', '2026-06-18 00:26:33', 'payment_out', '993449c0-8292-4c54-a6b8-48f18e0803dd', '5352.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0045', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('03bda5a8-14b6-4aa9-a40f-508069862a16', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-06-29 00:26:33', 'payment_out', 'f131790d-dd31-4c05-9f8a-826ed5a395d3', '9553.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0051', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('042cf6dc-9d1c-4562-a986-f7fab28ecc12', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-04-24 00:26:33', 'payment_out', 'ef8c495a-34a4-4717-babf-29c0439ab83d', '4663.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0056', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('04f3836e-5822-443f-aab7-bf15b773bcf6', '615fa6aa-6fd8-4492-966b-395f5ef34a4c', '2026-05-24 00:26:33', 'sale', '045465ea-e3e6-4e3e-877e-f51e3695b459', '0.00', '0.00', '0.00', 'Bill INV-2026-0059', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('07489939-e5ad-4819-9851-8eab35d4e663', '6592be06-2ef6-4d47-8b92-d943db8b83cf', '2026-05-18 00:26:33', 'sale', 'e057cefe-1718-4ba5-b209-62d9669e198d', '0.00', '0.00', '0.00', 'Bill INV-2026-0017', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('07a66ace-7a16-4002-a313-8bfbb164c3bb', 'b2e2cd31-ee41-4984-883e-731ca4251732', '2026-07-05 00:26:34', 'sale', '7a7f45d5-08fb-40ef-b380-8424341c7c46', '0.00', '0.00', '0.00', 'Bill INV-2026-0114', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('081e0499-07ca-4f96-9052-1c9b09e442ba', '7af0f6f0-aaf9-4841-a383-c1e8f03cd9e9', '2026-06-20 00:26:33', 'sale', '7a26b25b-c31d-4cc4-a655-ab338b2880da', '0.00', '0.00', '0.00', 'Bill INV-2026-0037', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('082e489c-1144-46cb-b6dd-fbaf5baf26b5', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', '2026-06-28 00:26:33', 'purchase', 'ef4fbf93-1e1c-491b-8ac7-ad6b62c01b64', '0.00', '3856.00', '3856.00', 'Bill PUR-2026-0049', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('08615261-860e-444f-86c8-16b3a0c98ca3', '9bc66362-54ca-43b9-b805-40d6c7cc149e', '2026-04-29 00:26:33', 'sale', '2af38da7-2d76-42ef-a0a2-2836271b98e4', '0.00', '0.00', '0.00', 'Bill INV-2026-0055', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0b425065-1a51-48f0-b327-f6eb38ea4b61', 'ba49bbc5-a47d-4a73-a0fc-17a222512e7b', '2026-05-29 00:26:33', 'sale', '2f1236ea-137c-4be5-a2d9-f9ece47a9f7e', '0.00', '0.00', '0.00', 'Bill INV-2026-0052', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0c8170c8-54b1-42aa-a154-4cf93ae01124', 'f34db23f-5c0f-4299-ac73-3fa09897e3bf', '2026-05-29 00:26:33', 'purchase', '3a254550-af30-47ba-90f7-30e24903cdd8', '0.00', '13241.00', '13241.00', 'Bill PUR-2026-0010', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0eee13cc-3723-49c3-9471-bdac5dc195dc', '95fa4fa7-e4f3-41eb-87eb-40cd3175b966', '2026-06-06 00:26:33', 'sale', 'afd4f92a-0f5f-4974-b8e7-35410de3d701', '0.00', '0.00', '0.00', 'Bill INV-2026-0056', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0f472c68-2da3-4bf3-9581-1494a68602e5', 'c02518fd-c412-4249-b633-88da66b81ab7', '2026-06-28 00:26:33', 'purchase', '1aab8ef0-d523-407e-947d-fac6221ee063', '0.00', '4980.00', '4980.00', 'Bill PUR-2026-0030', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('10693d00-d1e4-4405-997f-b3a30b404283', '3585dbf2-303a-4e34-9bef-14f47bac2f1b', '2026-05-09 00:26:33', 'sale', 'f63878dd-7612-4dc1-a657-6385a030044b', '0.00', '0.00', '0.00', 'Bill INV-2026-0039', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('12d37e20-a965-4992-b4e6-d0c98a4c3da2', '859f03f3-0d7e-4a12-8b47-16db4d534435', '2026-05-21 00:26:33', 'sale', 'c270bf06-6c33-4a07-bcd0-a307534797b5', '0.00', '0.00', '0.00', 'Bill INV-2026-0014', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('13777186-3ecf-407d-a994-88a7fb700060', 'e0e63936-74fa-4388-95cb-2726382d5764', '2026-05-18 00:26:33', 'payment_out', 'b0e255f8-999f-4efe-99ff-a771dd4679a9', '2180.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0050', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('13906859-7d2f-4a77-a7fc-2c2dc46d314f', 'c02518fd-c412-4249-b633-88da66b81ab7', '2026-06-28 00:26:33', 'payment_out', '17f9bff7-9bb1-49f4-917f-4fe6fca8772c', '4980.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0030', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('14c7f4e4-f900-4a57-81b4-0df67eb247ac', '32e0edbd-6dd5-489d-8c97-5abacfcad2a6', '2026-07-01 00:26:33', 'sale', '1c98b4af-ab91-44ab-b232-255bda2cfd3f', '0.00', '0.00', '0.00', 'Bill INV-2026-0020', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('171fa0c5-646f-440f-9d64-908ea5220971', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-05-15 00:26:33', 'purchase', 'd2387d12-6872-40cd-b307-768e73684040', '0.00', '11688.00', '11688.00', 'Bill PUR-2026-0055', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('17e87d3a-40ab-4080-a1a1-b491e26f7782', '691bfdad-0719-49d2-8a5e-004e733aedde', '2026-06-24 00:26:34', 'sale', '2ee233c8-4e88-4007-ad89-bff4a8894319', '0.00', '0.00', '0.00', 'Bill INV-2026-0111', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('18156aca-bc33-4b13-ad2e-b5fceb2be129', 'a39b3f86-5d91-4818-99af-ea175b09a3b7', '2026-05-15 00:26:34', 'sale', '8c8681c3-6050-4df1-a917-3867d5b3d8fd', '0.00', '0.00', '0.00', 'Bill INV-2026-0118', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('18afd07a-5c5a-407b-88d2-b3440d3c85f1', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-04-24 00:26:33', 'purchase', '6775e5a9-9af9-4c7a-8762-c1a2d8949fca', '0.00', '9327.00', '9327.00', 'Bill PUR-2026-0056', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('18c81b9f-5821-4fc8-8457-b904127972e4', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', '2026-06-11 00:26:33', 'payment_out', '78ac19b6-9196-4672-912b-0b83071d33dd', '2313.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0024', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1910d799-ae0a-4bca-adee-ee96808b8def', '7090eee5-197d-4dcf-a509-536622452d5c', '2026-05-18 00:26:33', 'purchase', '41cff981-c64f-495b-a866-4b55d0c12657', '0.00', '11930.00', '11930.00', 'Bill PUR-2026-0019', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('19ba9b66-f6af-4ddc-a2a6-5ace6c53b0f8', 'a1a705bf-1ed5-4613-95c9-e8e22cb26738', '2026-05-17 00:26:33', 'sale', 'a93d5cce-15ae-4043-8ad5-07847ffd4048', '0.00', '0.00', '0.00', 'Bill INV-2026-0045', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1a92f234-412d-4a6d-94b4-9fd14aed427d', '13ed9aeb-c38c-480e-94b4-bd977af41382', '2026-05-14 00:26:33', 'purchase', 'b88322ef-b8ad-4bd9-8d36-3a23b883f427', '0.00', '16621.00', '16621.00', 'Bill PUR-2026-0002', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1abddd78-be87-4ead-9ce9-c7c81d349c4e', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-07-03 00:26:33', 'purchase', '6b7ab46f-7b18-4bbf-9847-4988f62cd66c', '0.00', '4146.00', '4146.00', 'Bill PUR-2026-0040', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1d6ec650-1fd9-4a36-896e-ce06db422f47', '60afb66d-6dfe-4a51-862f-e58d07f32488', '2026-07-06 00:26:34', 'sale', '292e5641-29a5-4497-b4aa-9f86a1f06c7c', '0.00', '0.00', '0.00', 'Bill INV-2026-0097', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1dc5983b-f202-4cd2-9092-fe686c2f5964', '953f19e3-8ada-4ca9-9f8d-91b6a62c06c7', '2026-05-26 00:26:33', 'sale', '2dbe9a17-c452-45d5-8aa7-55d32066a7f0', '0.00', '0.00', '0.00', 'Bill INV-2026-0004', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1dfeb86d-ca8b-4562-adcb-ae370279400a', '859f03f3-0d7e-4a12-8b47-16db4d534435', '2026-06-07 00:26:33', 'sale', '488e51e8-d5dd-4e82-a987-a1aec321d5a4', '0.00', '0.00', '0.00', 'Bill INV-2026-0028', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2192de1d-142f-4004-9195-284aadf51e9a', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-06-06 00:26:33', 'purchase', 'b3095450-a725-4909-91da-612224482aec', '0.00', '4288.00', '4288.00', 'Bill PUR-2026-0052', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('21c0869f-b22c-47f5-9ea5-1bb524f52565', '32e0edbd-6dd5-489d-8c97-5abacfcad2a6', '2026-05-20 00:26:33', 'sale', 'bd53f73e-a0c6-47e3-8105-0df5a870b7ff', '0.00', '0.00', '0.00', 'Bill INV-2026-0027', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('21f9d473-fd5a-48ac-8287-c0391a6f05e5', 'defbe322-77c9-41a4-9a2a-817972a586fd', '2026-07-04 00:26:33', 'sale', '9da8c19e-21a0-4de0-afd9-9547c852f0e3', '0.00', '0.00', '0.00', 'Bill INV-2026-0070', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('224da6f9-5ee6-4759-8ae8-b2f6b88c436d', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-06-20 00:26:33', 'purchase', 'dcf76cad-775f-4b97-b6d7-3e5ed568b890', '0.00', '415.00', '415.00', 'Bill PUR-2026-0009', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2547fdbd-8101-40ed-9ea1-20c59ca2905c', 'febe6996-959b-4b68-84fc-b8d42feb35f2', '2026-07-03 00:26:33', 'sale', 'c2376c02-660a-404a-bf60-4a2feeb6ea6f', '0.00', '0.00', '0.00', 'Bill INV-2026-0042', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('28c6c34c-4aa5-4a8d-9065-fab719c289fd', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-06-20 00:26:33', 'payment_out', 'd1898157-850f-4f3e-834a-ef52cc25411c', '207.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0009', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('28fd3579-53ab-411f-bd69-7ab790e546bb', '7af0f6f0-aaf9-4841-a383-c1e8f03cd9e9', '2026-06-15 00:26:34', 'sale', 'f319ab72-8f67-43cf-8b86-994c74207fbb', '0.00', '0.00', '0.00', 'Bill INV-2026-0090', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2a0cbc64-1f82-4744-bf74-ed8a5e83ced2', 'f89c5907-c1f0-4e4a-b475-1f06fa155910', '2026-05-27 00:26:33', 'sale', '94b2d12d-4e05-4f6d-922f-73d7e6a72d29', '0.00', '0.00', '0.00', 'Bill INV-2026-0063', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2a110b3b-d00a-4927-95f7-90437bf1a67a', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-04-21 00:26:33', 'payment_out', '0c39cd95-2602-48ff-9601-99e7b126e54f', '14984.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0059', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2b678222-8a98-4380-b30e-72887f96c028', 'e0e63936-74fa-4388-95cb-2726382d5764', '2026-04-29 00:26:33', 'payment_out', 'd6482834-a5f6-4531-bb6c-669df63b20c4', '4260.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0025', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2cc28dc7-498f-47ec-b583-865432343434', 'defbe322-77c9-41a4-9a2a-817972a586fd', '2026-05-20 00:26:33', 'sale', 'fdb2d430-67ca-4f7e-98ad-843ab4030345', '0.00', '0.00', '0.00', 'Bill INV-2026-0021', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2e5f0e00-63a6-492b-a417-0002483c9345', '3585dbf2-303a-4e34-9bef-14f47bac2f1b', '2026-06-11 00:26:34', 'sale', '7e1e43c7-7b00-4aae-8523-488f2839a3bf', '0.00', '0.00', '0.00', 'Bill INV-2026-0095', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('2eac069f-4c09-4a66-9e2d-648967f96118', '7090eee5-197d-4dcf-a509-536622452d5c', '2026-04-28 00:26:33', 'purchase', '9816e78b-3951-446c-9f5d-9beba02fcd64', '0.00', '8687.00', '8687.00', 'Bill PUR-2026-0048', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('30d9e3b3-4982-4718-b6bd-282b6ca2c37e', 'ce9aeb70-45b6-44f0-a8ec-e02369558a2a', '2026-06-12 00:26:33', 'purchase', 'be5c9158-0e5b-4b00-8a7f-8e82a41c1835', '0.00', '10592.00', '10592.00', 'Bill PUR-2026-0036', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3139a7c0-67f4-4973-be96-22d7b4a26c9b', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', '2026-05-10 00:26:33', 'payment_out', '96aa6203-a678-41d5-ab1e-7e5297657edd', '21669.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0021', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('31fdd41f-d11f-4a52-8f20-809bf0e59539', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-04-30 00:26:33', 'purchase', 'bb92e644-5be0-48b7-a7bd-d6f62d34b2f7', '0.00', '11198.00', '11198.00', 'Bill PUR-2026-0035', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('321e132c-4215-4d75-a091-04f1b1a9181a', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-05-19 00:26:33', 'payment_out', 'efcc6ec0-5b4e-4eee-b9ae-04e288d8c362', '11199.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0060', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('32679d40-4436-4663-a116-13aca43133da', '4a10fbee-bc16-486d-9f84-8997b6572067', '2026-05-25 00:26:34', 'sale', '9eef7770-d93c-4a05-a322-f07b6ad30613', '0.00', '0.00', '0.00', 'Bill INV-2026-0106', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('33303b1f-9394-483c-9994-9de16dc4281f', '32e0edbd-6dd5-489d-8c97-5abacfcad2a6', '2026-07-05 00:26:34', 'sale', 'fc70c781-f1ae-4e95-9ceb-8ab4e0e4bbc9', '0.00', '0.00', '0.00', 'Bill INV-2026-0117', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('33318194-f004-4b2e-82b3-bdab54e372e4', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-04-14 00:26:33', 'payment_out', '9fcd9dae-2f6e-41d8-b564-6135030ea476', '6148.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0023', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('33d2a060-b5b2-41aa-8682-e20eccbcfb16', 'c02518fd-c412-4249-b633-88da66b81ab7', '2026-06-21 00:26:33', 'purchase', 'c4b217fc-6cba-4dcd-b5f3-37d172b5e28a', '0.00', '9943.00', '9943.00', 'Bill PUR-2026-0053', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3526dfca-9856-4fe2-9248-a792a7406eac', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-05-11 00:26:33', 'purchase', '546d40be-3ea1-462a-8eca-ffe275b3d0d2', '0.00', '4459.00', '4459.00', 'Bill PUR-2026-0037', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('354d8972-d361-4113-873e-9c310f5cb2e3', '13ed9aeb-c38c-480e-94b4-bd977af41382', '2026-04-16 00:26:33', 'purchase', '2916a65c-7789-48a0-aac5-1f0827ff0b8e', '0.00', '11822.00', '11822.00', 'Bill PUR-2026-0041', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('37ca52d6-df6f-4f0a-b0f2-7e458d5fcedf', '101da879-b8ca-419a-bc8f-3cc8fc437769', '2026-07-06 00:26:33', 'payment_out', 'c4075c45-aa28-49e2-8daf-a33da76c85d5', '5171.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0013', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('381ba76a-2a44-411c-96f5-2844a00cf1f9', 'defbe322-77c9-41a4-9a2a-817972a586fd', '2026-06-28 00:26:33', 'sale', '2f628d10-48d3-44ad-92eb-d8b482efea49', '0.00', '0.00', '0.00', 'Bill INV-2026-0024', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3a7d6280-9d86-46dc-b641-ff835802a394', 'b1508ef9-da0d-4435-aa8c-8c62d0b0c320', '2026-05-14 00:26:34', 'sale', 'ff72ee35-01cd-4dcf-b377-7ddf7e03107d', '0.00', '0.00', '0.00', 'Bill INV-2026-0105', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3cb0e535-3a70-4003-ab14-6a0aa8137afc', '6093f0ed-9b6c-4ece-941f-a22f35787113', '2026-06-16 00:26:33', 'sale', '99699f55-471c-42f0-80bc-c3d9b66cbdfb', '0.00', '0.00', '0.00', 'Bill INV-2026-0060', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('3d0b3e23-7f3f-4b56-b2ed-68115e0641c8', 'a39b3f86-5d91-4818-99af-ea175b09a3b7', '2026-05-01 00:26:33', 'sale', '8f3022ed-761e-4515-9a3f-dfc56e747a42', '0.00', '0.00', '0.00', 'Bill INV-2026-0041', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('41cea4bf-c11e-4338-a8e4-2c7cdb4da331', 'daa6557d-2131-4f0d-9703-620f1898bb78', '2026-05-14 00:26:33', 'payment_out', '86140098-d540-4f51-a37f-bab28e23873e', '7048.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0027', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('42622be4-39e8-449b-b1c2-52472aa910ac', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', '2026-05-20 00:26:33', 'purchase', '81d048fb-73f5-427a-90dd-a111969e643f', '0.00', '16606.00', '16606.00', 'Bill PUR-2026-0001', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('429070cf-fee2-4ea3-adc9-4e0aa02a681a', 'ef79b832-e98a-4349-919e-5385758281ca', '2026-05-24 00:26:33', 'sale', '904c69c0-5654-4729-8c37-40a7fe8c3314', '0.00', '0.00', '0.00', 'Bill INV-2026-0068', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('431b94f2-451b-49ac-a90a-fafe28421574', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-05-15 00:26:33', 'payment_out', '38f3a419-4254-4e54-aeff-b966cbe436cd', '11688.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0055', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('44c6eda4-25ca-43fa-a234-13de40641a12', '953f19e3-8ada-4ca9-9f8d-91b6a62c06c7', '2026-04-22 00:26:34', 'sale', 'cc073781-c42a-4ef3-8874-f8551ba9181d', '0.00', '0.00', '0.00', 'Bill INV-2026-0086', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('489fe156-de30-4b1c-93ac-44101fbbe79e', '34baeed3-a1cc-4d60-9076-66ae7d62e365', '2026-04-15 00:26:33', 'sale', 'c5f90c03-14f7-49a0-9222-7b06678f9128', '0.00', '0.00', '0.00', 'Bill INV-2026-0006', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('48eda073-bd41-4a8e-9b93-de8fa57161db', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-04-21 00:26:33', 'payment_out', 'e7c9faa7-8fe0-471c-a5b7-6fb59b3b8d17', '7749.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0057', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4a899d46-81d8-434d-9763-3aa9f19740b9', '462f1d74-95f1-4208-bbe9-4b121bd93537', '2026-06-15 00:26:33', 'sale', 'bca352dd-1c4f-4c32-a180-179442519459', '0.00', '0.00', '0.00', 'Bill INV-2026-0019', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4c76e8ec-7905-4c78-93a9-b7b88ec8d065', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-07-07 00:26:33', 'payment_out', '15886d09-143a-4168-869a-88b5f2fa7940', '6654.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0044', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4cb3497f-c137-4774-88a7-7f54e084f331', 'febe6996-959b-4b68-84fc-b8d42feb35f2', '2026-06-19 00:26:34', 'sale', 'bcb527ff-fc54-4e85-99f9-5c2809ac2413', '0.00', '0.00', '0.00', 'Bill INV-2026-0092', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4cec651a-a529-48dd-8c16-a8b92920ca17', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-07-02 00:26:34', 'sale', 'bf81f2a5-cf85-4cec-84f5-043e83e4cff5', '0.00', '0.00', '0.00', 'Bill INV-2026-0080', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4d03ec87-c938-4d0f-b340-129103b5dc43', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-05-24 00:26:33', 'sale', '2c52ad76-efe0-44ad-ae28-ae9db62a8eb8', '0.00', '0.00', '0.00', 'Bill INV-2026-0005', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('50770009-85f9-41ee-998d-fb039e1961e1', '462f1d74-95f1-4208-bbe9-4b121bd93537', '2026-05-11 00:26:33', 'sale', 'dba2ed22-bc76-403d-94af-f25058d18284', '0.00', '0.00', '0.00', 'Bill INV-2026-0065', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5275a4af-c174-4306-a0ec-f8a254cc8334', '8eecceb9-342b-41d2-b690-b4db77524b91', '2026-07-09 00:26:33', 'purchase', '8a9e6d83-9de0-41e2-9474-5e810dd080fb', '0.00', '2331.00', '2331.00', 'Bill PUR-2026-0014', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('53abb97d-30e2-4b3e-83c7-7e6c89737b3c', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-06-17 00:26:33', 'payment_out', 'f31a00ac-0e85-4c0f-a7a9-4b5a7c8859ba', '9056.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0034', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('54b60914-2c1b-4aee-8dc0-a9ee82aa57b4', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', '2026-06-19 00:26:33', 'purchase', '3feb4635-2d63-4852-b2ed-6c7949e8df36', '0.00', '12304.00', '12304.00', 'Bill PUR-2026-0058', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5580dc06-2cc2-4b91-b3c6-c75bc4c7c735', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', '2026-05-10 00:26:33', 'purchase', '55c293b0-d4ca-4df1-b89f-d390fdd94404', '0.00', '21669.00', '21669.00', 'Bill PUR-2026-0021', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('59e81b8a-88ed-488b-8be3-74cfc977e13f', 'defbe322-77c9-41a4-9a2a-817972a586fd', '2026-06-29 00:26:34', 'sale', 'e60a082f-c192-49aa-b6da-c77a1421176b', '0.00', '0.00', '0.00', 'Bill INV-2026-0075', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('59fdc6c1-3f53-4263-be6f-80ddf55edac5', '60afb66d-6dfe-4a51-862f-e58d07f32488', '2026-05-21 00:26:33', 'sale', '0fc5fc45-58c9-4cbf-8230-dfc90101ec30', '0.00', '0.00', '0.00', 'Bill INV-2026-0058', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5a88ab10-693d-4673-a827-984b3defc521', 'ce9aeb70-45b6-44f0-a8ec-e02369558a2a', '2026-06-12 00:26:33', 'payment_out', '92f1a1fd-370e-42c1-9e06-097dbba32e91', '5296.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0036', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5c764e59-e43d-46f9-96ef-24724e63cb76', 'f34db23f-5c0f-4299-ac73-3fa09897e3bf', '2026-05-20 00:26:33', 'purchase', '70c4de54-e8b0-4020-9d3f-96afd5a62006', '0.00', '1397.00', '1397.00', 'Bill PUR-2026-0038', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5cfb21ba-856b-4e6a-9d2e-a23757a9ac45', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-06-17 00:26:33', 'purchase', '9aec8576-8e87-41e7-87e5-89d7cf3f2e73', '0.00', '5332.00', '5332.00', 'Bill PUR-2026-0039', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5e6fe460-34dd-4850-9f67-95493de00dae', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-04-23 00:26:33', 'payment_out', '6da5fa2b-4839-4f07-8638-8c29fc9824bc', '975.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0026', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5f24570e-36e6-445b-bf14-01aa341f7bd1', '3f2f0ea8-2b72-4a6e-b52f-ebbaaed54b2d', '2026-05-12 00:26:34', 'sale', 'a4e2cac2-4ecf-4d57-b606-6f6f6147813b', '0.00', '0.00', '0.00', 'Bill INV-2026-0108', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('604e70fb-ed42-4196-bb89-c431e0f83116', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-04-15 00:26:33', 'payment_out', 'cae2ef63-9ed0-4588-8d37-469245ffa038', '1277.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0020', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('620f48c9-d19f-4672-b28a-d6bea7cf6425', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-07-04 00:26:33', 'payment_out', '4f02023c-74b8-4403-afba-e24d2294c145', '6441.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0028', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('637f412d-5b75-410f-b64e-69b9a79e02ec', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-06-29 00:26:33', 'purchase', '25140a05-c96b-4b38-b07d-7da3fb234fef', '0.00', '9553.00', '9553.00', 'Bill PUR-2026-0051', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6402fb0f-aa10-42a9-b279-3e9ad0865726', '5ea4b50f-6f1e-4b91-acb9-9ff5943d61bb', '2026-05-21 00:26:33', 'sale', '4a348600-4a39-422e-ae42-187bd8809f50', '0.00', '0.00', '0.00', 'Bill INV-2026-0035', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('647270df-3870-49c7-a884-a62a8920169b', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-07-08 00:26:33', 'purchase', 'c96d8435-4a93-4386-bb58-4c0a0388790b', '0.00', '8994.00', '8994.00', 'Bill PUR-2026-0054', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6679afb2-6360-41c1-b374-8710144ea411', 'ce9aeb70-45b6-44f0-a8ec-e02369558a2a', '2026-06-10 00:26:33', 'purchase', 'a0aae7a7-605f-4e5a-a4d1-9cb74db3fb28', '0.00', '2439.00', '2439.00', 'Bill PUR-2026-0007', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('66e4d4e7-4d75-49bd-9458-24504db3fe2b', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-04-21 00:26:33', 'purchase', '9fed33c1-6d29-4242-b543-4f60ec12ed2f', '0.00', '14984.00', '14984.00', 'Bill PUR-2026-0059', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('68811d1e-017c-4e73-ba5c-8806214f8c06', '691bfdad-0719-49d2-8a5e-004e733aedde', '2026-07-06 00:26:34', 'sale', '4850b002-c7ab-4c15-87f4-57923851ab94', '0.00', '0.00', '0.00', 'Bill INV-2026-0110', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('69d6ee23-79a9-4336-8dcc-5d744930a48e', '8eecceb9-342b-41d2-b690-b4db77524b91', '2026-07-09 00:26:33', 'payment_out', '41b6a27f-7c33-4f26-aa22-d1d6c4926522', '2331.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0014', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6a4cdc47-8d1c-4a4a-9e88-19de1fa94f82', 'f89c5907-c1f0-4e4a-b475-1f06fa155910', '2026-04-15 00:26:33', 'sale', 'c4f58ceb-d681-436f-96ab-f647c8cbef60', '0.00', '0.00', '0.00', 'Bill INV-2026-0057', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6a5b801f-bf58-4aa4-93b3-fcb611e91e19', 'c02518fd-c412-4249-b633-88da66b81ab7', '2026-06-21 00:26:33', 'payment_out', '2338e976-b1cf-4ce1-b7e9-93e60dcbc3b5', '9943.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0053', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6a9eadc0-b34c-408d-991c-5918f267a332', '3585dbf2-303a-4e34-9bef-14f47bac2f1b', '2026-06-25 00:26:34', 'sale', '79ebaa7d-7f3f-46b1-94ed-09d5bb05fa24', '0.00', '0.00', '0.00', 'Bill INV-2026-0081', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6adad6ff-4c46-4dc4-bc08-f20006806738', 'e0e63936-74fa-4388-95cb-2726382d5764', '2026-04-29 00:26:33', 'purchase', '24d20977-00c4-490c-b382-1a23b4cc60f8', '0.00', '8521.00', '8521.00', 'Bill PUR-2026-0025', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6b811fec-3b7d-4964-b624-b246ad085de2', '3f27a857-f4d8-4097-82f3-b90fb0fd77d7', '2026-07-10 00:26:33', 'purchase', '50c88d54-3a44-45d0-b68b-c7998276c6b6', '0.00', '13079.00', '13079.00', 'Bill PUR-2026-0033', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6d539263-43d9-475d-b563-63b965bea46d', '6592be06-2ef6-4d47-8b92-d943db8b83cf', '2026-05-31 00:26:34', 'sale', '4ee89f1d-b37d-4399-acc5-45e4c0c8f683', '0.00', '0.00', '0.00', 'Bill INV-2026-0088', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6deb5d57-a990-4a63-a16e-6fcd83a01950', '953f19e3-8ada-4ca9-9f8d-91b6a62c06c7', '2026-04-13 00:26:33', 'sale', '290c3161-602b-4d00-844a-0e05e990e53b', '0.00', '0.00', '0.00', 'Bill INV-2026-0025', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6df1e12e-035e-4b35-bb9b-472d8ec9d464', '4a10fbee-bc16-486d-9f84-8997b6572067', '2026-06-28 00:26:34', 'sale', '261078ba-007c-4516-8e54-c2066d80878d', '0.00', '0.00', '0.00', 'Bill INV-2026-0116', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6efe0251-06a7-4722-9f0f-eb4ad0a51577', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-06-05 00:26:33', 'purchase', '86c56474-ddd1-4b76-b444-1e07e9bc3e49', '0.00', '1359.00', '1359.00', 'Bill PUR-2026-0006', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6f5cc3e6-1b8d-4ed6-b6c5-6268872bf7d8', '3585dbf2-303a-4e34-9bef-14f47bac2f1b', '2026-06-20 00:26:33', 'sale', '8301e8e8-5f08-4074-abde-28013641fd2c', '0.00', '0.00', '0.00', 'Bill INV-2026-0053', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6f7cf360-8e2f-4a3f-be76-b6155f10b5da', '953f19e3-8ada-4ca9-9f8d-91b6a62c06c7', '2026-06-01 00:26:33', 'sale', '2c9c163f-d25a-437c-ae80-0863e7417144', '0.00', '0.00', '0.00', 'Bill INV-2026-0034', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('6f81688c-f69a-4069-a7a7-6451ad523b72', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-04-15 00:26:33', 'purchase', 'd68d3799-45b8-4cbe-afdc-7982356e19fc', '0.00', '2554.00', '2554.00', 'Bill PUR-2026-0020', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('70c0a154-43b5-40be-9382-93c1db93179c', '32e0edbd-6dd5-489d-8c97-5abacfcad2a6', '2026-05-05 00:26:34', 'sale', 'd73a57f3-dba8-484e-85e6-1fd4858f05c6', '0.00', '0.00', '0.00', 'Bill INV-2026-0115', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('70dfbabc-e3e4-4476-a475-8af494bdee85', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', '2026-06-19 00:26:33', 'payment_out', '7b132818-c00f-4673-b6b4-7fccc01d52fb', '6152.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0058', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('72fdd7e3-c837-4e6d-a0fc-fdcafc7c0239', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-05-02 00:26:33', 'purchase', '772a5059-1486-47c5-9578-295007a7c3b5', '0.00', '3704.00', '3704.00', 'Bill PUR-2026-0043', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('77ffb096-0f36-4ba1-befd-4dd4df6bca06', '3f2f0ea8-2b72-4a6e-b52f-ebbaaed54b2d', '2026-06-14 00:26:34', 'sale', '4d25a13f-c472-4266-a4d8-ef9501e24704', '0.00', '0.00', '0.00', 'Bill INV-2026-0091', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('78a9f925-90f0-4c97-98a6-38e8ecfb34be', 'ba49bbc5-a47d-4a73-a0fc-17a222512e7b', '2026-06-06 00:26:33', 'sale', 'a0e567a9-b21a-4b4a-8339-c3a8c44bdbc6', '0.00', '0.00', '0.00', 'Bill INV-2026-0002', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('79abe4dc-e97e-4471-8ea7-6e5a0afaaabe', '646193a4-2b3e-4fc3-ab98-c096a37a2841', '2026-06-06 00:26:33', 'sale', '16bf3d2a-dcfe-4d29-918b-a69b7b53daeb', '0.00', '0.00', '0.00', 'Bill INV-2026-0012', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7ab7df8e-3b9a-4960-b2ec-973cfa0005db', 'c4b9a9e4-271b-4fbf-9418-297e99bba442', '2026-05-16 00:26:33', 'sale', 'eb50e9e1-dda6-4865-844e-44f735a8f6de', '0.00', '0.00', '0.00', 'Bill INV-2026-0049', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7b52b777-08c4-4399-b3ee-bd121111da74', 'b1508ef9-da0d-4435-aa8c-8c62d0b0c320', '2026-05-21 00:26:33', 'sale', 'fff431bc-2a33-4bcf-963b-c2415fe95311', '0.00', '0.00', '0.00', 'Bill INV-2026-0001', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7bbf5cd8-a082-4069-adfc-9fcb54d175ab', 'defbe322-77c9-41a4-9a2a-817972a586fd', '2026-07-04 00:26:34', 'sale', '22ab9f62-9ca6-4f41-9fa9-5fa1f30c2beb', '0.00', '0.00', '0.00', 'Bill INV-2026-0100', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7bc1fca9-679b-401b-854c-ef626ed0835f', 'ce9aeb70-45b6-44f0-a8ec-e02369558a2a', '2026-06-10 00:26:33', 'payment_out', '8c3ca243-0f02-454f-911f-825c08a86f7f', '2439.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0007', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7bffbedb-8d6b-484b-abdd-1451d2ebdab4', '7c070003-29af-48fb-88ef-ec752cd440b1', '2026-06-05 00:26:33', 'purchase', 'd256d1d7-e8d7-4f33-9d79-109bae77f9d9', '0.00', '7780.00', '7780.00', 'Bill PUR-2026-0008', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7d1787fc-70a8-4f05-9bad-7482004a6b4c', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-05-11 00:26:33', 'sale', '8228a310-56f2-4c92-89fe-6f5d9b71891e', '0.00', '0.00', '0.00', 'Bill INV-2026-0069', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7d23fdb7-3b20-45db-b827-5705a996cdfb', '13ed9aeb-c38c-480e-94b4-bd977af41382', '2026-05-14 00:26:33', 'payment_out', '020e9ac1-0955-4a6a-842d-7ff9f31c770f', '16621.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0002', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e30580f-1596-47ee-a73b-66e72f2a7243', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-05-19 00:26:33', 'purchase', 'a5ac3c65-b92d-4106-ab21-179779867fdb', '0.00', '11199.00', '11199.00', 'Bill PUR-2026-0060', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e35be7a-8a4f-4867-81a3-4e40c3a6a1da', '7af0f6f0-aaf9-4841-a383-c1e8f03cd9e9', '2026-06-09 00:26:34', 'sale', 'fd9f165c-cd2a-4a17-8cec-ffc526e3ac46', '0.00', '0.00', '0.00', 'Bill INV-2026-0084', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7fdaa3bc-56be-461c-b91e-84f554009d90', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-04-14 00:26:33', 'sale', '24af123b-9e01-4c3f-b6ea-410c48325ec3', '0.00', '0.00', '0.00', 'Bill INV-2026-0026', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7fe96a92-bfa2-4966-af02-6d29f91575c7', '4a10fbee-bc16-486d-9f84-8997b6572067', '2026-04-28 00:26:33', 'sale', 'cae151e7-fa0a-482a-9ae9-3ac7b71c583d', '0.00', '0.00', '0.00', 'Bill INV-2026-0054', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('80033504-3545-4a71-8e96-e79d044adc63', 'b1508ef9-da0d-4435-aa8c-8c62d0b0c320', '2026-07-09 00:26:34', 'sale', '2b8ce6e8-7040-424e-8bb1-928ef0539698', '0.00', '0.00', '0.00', 'Bill INV-2026-0078', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('816cd85a-e1d3-4029-8cac-5e758549959c', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-06-12 00:26:33', 'purchase', 'ba93e3af-6716-49a0-8d91-b14612e07223', '0.00', '24674.00', '24674.00', 'Bill PUR-2026-0005', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8299d721-3291-4224-b41b-cbad8864cab7', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-04-21 00:26:33', 'purchase', '341b5f1f-91e9-4a19-87aa-2b755f9def2a', '0.00', '14475.00', '14475.00', 'Bill PUR-2026-0047', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('84bb56eb-40e7-459e-880a-8bdda67bdebc', 'defbe322-77c9-41a4-9a2a-817972a586fd', '2026-05-05 00:26:33', 'sale', 'c4a3ea30-827e-441f-9210-b3e730b16f91', '0.00', '0.00', '0.00', 'Bill INV-2026-0046', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('852fbac2-bb89-40bd-b5ee-3a8426b763ca', '7090eee5-197d-4dcf-a509-536622452d5c', '2026-05-18 00:26:33', 'payment_out', 'a9a73c96-79b1-426e-be41-35114bb97248', '11930.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0019', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('869f5226-e76f-4b67-9dca-596e173c1069', 'e0e63936-74fa-4388-95cb-2726382d5764', '2026-05-23 00:26:33', 'purchase', '112b6cee-51e8-4424-9aeb-1cde793d4fd0', '0.00', '11643.00', '11643.00', 'Bill PUR-2026-0011', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8862ab84-923e-446d-a57b-b55b64f890f8', '691bfdad-0719-49d2-8a5e-004e733aedde', '2026-04-26 00:26:33', 'sale', '4b329cd8-f35f-483a-acce-a3140cbf870e', '0.00', '0.00', '0.00', 'Bill INV-2026-0038', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('88657328-24ba-4705-b2db-beef421d73cf', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-07-03 00:26:33', 'payment_out', '26419fb9-6fa8-4c5b-87be-dbf4f3c8393d', '4146.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0040', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8c029da1-6a67-4a16-acb8-9740a610defc', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-05-14 00:26:33', 'payment_out', '0d74a2f7-12b0-4f4e-b436-a25166ac16b6', '7014.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0032', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8cf4d8e6-d0f2-4a14-892f-7a71f113c232', '8363a724-4fa1-4ab9-96b4-4f42cf03164c', '2026-05-09 00:26:33', 'sale', '86a36ff5-c340-43d8-bef4-15d4cbf909bf', '0.00', '0.00', '0.00', 'Bill INV-2026-0061', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8efcd8e8-8b21-4764-b7d8-85b0f1731f3c', 'ef79b832-e98a-4349-919e-5385758281ca', '2026-04-21 00:26:34', 'sale', 'e9180e51-c374-4240-ad5e-1e2f1c9bae62', '0.00', '0.00', '0.00', 'Bill INV-2026-0102', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('8fcb76f3-dad1-4567-9e33-2de77ca6925d', '81e9d1fc-d64d-43b8-b02d-4ed1f1646ec0', '2026-06-30 00:26:34', 'sale', 'd60dcea8-5398-4e8c-a8dd-1137c28482c4', '0.00', '0.00', '0.00', 'Bill INV-2026-0119', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('93a3b23f-0f5d-43a6-bfde-c30d080ed841', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-04-21 00:26:33', 'purchase', '645efeac-ae96-4dc7-8ca0-e2306841eef6', '0.00', '7749.00', '7749.00', 'Bill PUR-2026-0057', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('944360bd-b73a-4572-848c-efd02e909a9b', '615fa6aa-6fd8-4492-966b-395f5ef34a4c', '2026-04-13 00:26:34', 'sale', 'ac53b63b-0d44-4a4c-93e1-27cb41c979b5', '0.00', '0.00', '0.00', 'Bill INV-2026-0087', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('970731d5-94a1-4403-b3b3-2d52b929cac1', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-05-05 00:26:33', 'sale', '607dfa2c-81f5-4b0b-b792-9ee4fa697f16', '0.00', '0.00', '0.00', 'Bill INV-2026-0071', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('987d8dc5-a30f-4147-aa67-289190cf9fad', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-05-29 00:26:33', 'payment_out', '06c93821-fee2-4344-8795-865553fc455a', '6827.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0004', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9cd741d2-4d6b-4922-81cc-ac8b27330f3c', '95fa4fa7-e4f3-41eb-87eb-40cd3175b966', '2026-05-18 00:26:33', 'sale', 'f84b9b23-7e07-449a-b498-ccd22413e0e7', '0.00', '0.00', '0.00', 'Bill INV-2026-0040', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9d7664f2-f391-4a38-80ad-5579c508d9c8', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-05-30 00:26:33', 'purchase', '974649b5-bfad-4b82-ae35-06d97085db7e', '0.00', '5282.00', '5282.00', 'Bill PUR-2026-0031', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9d7bb541-d961-4f43-9c80-a1ca0a51114d', 'e41c62c7-407c-4def-ad89-ef31bdf69578', '2026-06-08 00:26:33', 'sale', 'b65338ef-5a8c-4df0-8c0d-2a0ef8ebf218', '0.00', '0.00', '0.00', 'Bill INV-2026-0072', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9e0a9b88-d76d-4bec-98a4-8d14b244a7bb', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-07-07 00:26:33', 'purchase', 'ab9cdf85-27ac-4dc4-8561-76a5d9a1cd3d', '0.00', '6654.00', '6654.00', 'Bill PUR-2026-0044', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9efefb42-8139-428e-b334-f4c353abd742', 'e0e63936-74fa-4388-95cb-2726382d5764', '2026-05-18 00:26:33', 'purchase', 'f00baa4e-866c-412c-b90a-21c7bf7452a8', '0.00', '4360.00', '4360.00', 'Bill PUR-2026-0050', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9f4ad7e3-ef3d-4724-acdb-dda3e8536f3b', 'eb109f35-7a6d-4f62-8f66-e0712076b5bb', '2026-04-20 00:26:33', 'payment_out', '1e855e5e-ddff-4948-8554-1826c447ac8a', '14569.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0003', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9f66c677-7bb1-4497-8095-e147869bdee9', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-04-30 00:26:33', 'payment_out', 'bbb347e2-292d-4219-863d-300371c6e7b1', '5599.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0035', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9ff0497d-cc0c-42b5-b3d5-de1dd8c3978f', 'a9f20156-f1e5-46d2-98b2-37e8fccfdb9c', '2026-05-16 00:26:33', 'sale', 'ff56c52b-a139-45ce-8533-229c83f94cc2', '0.00', '0.00', '0.00', 'Bill INV-2026-0016', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a179cf98-d604-4a8d-84dd-5709ef2cc47f', '691bfdad-0719-49d2-8a5e-004e733aedde', '2026-06-26 00:26:33', 'sale', 'e9ab4964-4e85-4d49-83a3-a171e6cb46ae', '0.00', '0.00', '0.00', 'Bill INV-2026-0033', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a1eda74d-0252-43af-ab45-39ffc831cb35', 'c02518fd-c412-4249-b633-88da66b81ab7', '2026-05-28 00:26:33', 'payment_out', 'c48a49cc-e26a-4ecd-9faf-02e12df0b238', '14339.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0012', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a2345fc4-b6a4-4ee4-bc3b-e1f6cb8b1025', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-05-29 00:26:33', 'purchase', 'dbeeb12b-c597-4686-87f5-911dee5dc8e3', '0.00', '6827.00', '6827.00', 'Bill PUR-2026-0004', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a25d9261-c0e7-4cc2-be77-116529003c67', 'daa6557d-2131-4f0d-9703-620f1898bb78', '2026-05-14 00:26:33', 'purchase', '3ed55931-eb43-4544-a391-8e8ce432ad45', '0.00', '14097.00', '14097.00', 'Bill PUR-2026-0027', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a2bbf9d6-8c0c-49f0-a640-495e12221650', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-04-13 00:26:33', 'purchase', '64b5c3a6-c150-4c6d-983a-12ab5b4cdad0', '0.00', '2961.00', '2961.00', 'Bill PUR-2026-0042', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a5ea04f6-9772-4f37-8b8f-cfcf9662dc79', 'a39b3f86-5d91-4818-99af-ea175b09a3b7', '2026-05-12 00:26:33', 'sale', '00f14d57-83ff-4bcb-bd5e-c20a120455ac', '0.00', '0.00', '0.00', 'Bill INV-2026-0029', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a8ad77cb-c9a4-4fe3-8158-e480b2a8052f', '32e0edbd-6dd5-489d-8c97-5abacfcad2a6', '2026-05-26 00:26:34', 'sale', 'bd41bcfb-1020-45f7-ad10-7f9ec7e0bfa7', '0.00', '0.00', '0.00', 'Bill INV-2026-0089', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a8c9e6d2-53f8-4698-afdd-0bf3fc481816', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-06-17 00:26:33', 'payment_out', '8028fd01-edde-454e-a67b-a3964ff8158d', '5332.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0039', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('aafbebf1-ee70-485c-b9f9-20933e5f0d1f', '5ea4b50f-6f1e-4b91-acb9-9ff5943d61bb', '2026-07-03 00:26:34', 'sale', '2f455932-3a32-4218-8f87-944963f4e268', '0.00', '0.00', '0.00', 'Bill INV-2026-0077', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ad394acc-042c-477b-a2f2-1696531f95f5', '7090eee5-197d-4dcf-a509-536622452d5c', '2026-06-18 00:26:33', 'purchase', '91b0b84c-47c6-425a-85eb-1e63d45d04c5', '0.00', '5352.00', '5352.00', 'Bill PUR-2026-0045', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('afd141dd-3384-4f25-b58b-8ec188906d31', '691bfdad-0719-49d2-8a5e-004e733aedde', '2026-04-25 00:26:34', 'sale', '43add38d-e3d8-463b-88d6-70ea969d6893', '0.00', '0.00', '0.00', 'Bill INV-2026-0079', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b08e6e5b-ebfd-4035-b689-5540f26c0d5c', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-04-19 00:26:33', 'payment_out', '0a9fe3d8-a047-4176-80f9-6dd9516bc2ce', '9128.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0018', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b2bebcdb-97b8-4328-8758-a7fd9fe0aff1', 'af3d02af-a28f-4060-9ec1-2a2f7d782bbd', '2026-06-22 00:26:33', 'sale', 'ff7cd5aa-37b7-4ee0-aa38-4f1aca62d057', '0.00', '0.00', '0.00', 'Bill INV-2026-0031', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b2d8eb82-9d18-456a-abc4-91aa9cb4b388', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-05-17 00:26:33', 'sale', '20835c3c-9cbf-4891-b3a2-2694d5238e8a', '0.00', '0.00', '0.00', 'Bill INV-2026-0044', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b2f5379c-0616-4b1a-990e-dcdd2af21ebf', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-06-07 00:26:33', 'payment_out', 'a1cf1e28-f767-45bd-a12b-f2c54f1bb397', '2380.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0046', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b47d46c6-b399-4ef5-86d8-9f04f2bfdf87', 'eb109f35-7a6d-4f62-8f66-e0712076b5bb', '2026-04-20 00:26:33', 'purchase', 'ebed3606-a692-41be-9d8d-acea5bf55151', '0.00', '14569.00', '14569.00', 'Bill PUR-2026-0003', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b4c4d292-4d5b-4332-81cc-28d0480e1ce3', '859f03f3-0d7e-4a12-8b47-16db4d534435', '2026-07-09 00:26:34', 'sale', 'eb6936a3-f804-4beb-b92d-db4c66679b8d', '0.00', '0.00', '0.00', 'Bill INV-2026-0107', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b4eb5423-4e72-42b3-bea5-9013d56f8b93', '9bd93dbd-0dff-47ad-aef7-d7be3691f5d2', '2026-06-28 00:26:33', 'payment_out', 'ba5fd49c-7c32-4c01-9283-e68229ebe868', '3856.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0049', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b55e7784-b40b-46e1-a790-ab727f081a40', '9bc66362-54ca-43b9-b805-40d6c7cc149e', '2026-07-07 00:26:33', 'sale', '4b157140-5dbc-4021-8d97-0cd4f911063a', '0.00', '0.00', '0.00', 'Bill INV-2026-0013', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b602bd6f-6667-43e0-86ff-d9a327b18d97', '5ea4b50f-6f1e-4b91-acb9-9ff5943d61bb', '2026-05-24 00:26:33', 'sale', '49902db3-9511-449b-87ff-01537981b5ba', '0.00', '0.00', '0.00', 'Bill INV-2026-0051', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b6c5c2b2-7e95-4785-8a64-5e410e56b546', '101da879-b8ca-419a-bc8f-3cc8fc437769', '2026-07-06 00:26:33', 'purchase', 'b4580712-04c0-4832-9f8f-4a45c06873a7', '0.00', '10343.00', '10343.00', 'Bill PUR-2026-0013', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b8d7fec2-9f32-4fe7-9594-2ae9e1b4c9db', 'ab93477d-c898-4ca8-be18-2a2aa2e33fe4', '2026-04-13 00:26:33', 'payment_out', 'bc780f6a-1add-46aa-bcc9-bf700e4c3943', '2961.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0042', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('bdcc0df7-f177-4232-853b-1991ad32b4e9', '13ed9aeb-c38c-480e-94b4-bd977af41382', '2026-05-06 00:26:33', 'purchase', 'bdd3c4ce-a116-4ecd-a582-7d78eefaba54', '0.00', '3044.00', '3044.00', 'Bill PUR-2026-0015', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c0bed46f-770d-41e6-8949-f572b3a19e6b', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', '2026-05-15 00:26:33', 'purchase', '3ac5eacb-bd94-4493-93b9-eca72d79e40f', '0.00', '10345.00', '10345.00', 'Bill PUR-2026-0017', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c167cc35-01ee-492d-acd3-2f35221bd4c4', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', '2026-05-15 00:26:33', 'payment_out', 'c8d4c748-30dd-48dd-81bf-280c511a0f35', '10345.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0017', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c28e6df1-9b61-4cff-bb3b-df72bfa012d3', '7af0f6f0-aaf9-4841-a383-c1e8f03cd9e9', '2026-06-29 00:26:34', 'sale', 'a7bb3fa2-0ebd-42d9-9d55-235f1040fd17', '0.00', '0.00', '0.00', 'Bill INV-2026-0085', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c32909e5-a231-4b0c-8888-6f4e1eba3d21', 'c4b9a9e4-271b-4fbf-9418-297e99bba442', '2026-05-11 00:26:34', 'sale', '2a30ed5b-4b0e-44e6-b61b-19e75cc572ad', '0.00', '0.00', '0.00', 'Bill INV-2026-0096', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c3fc4bcd-6088-4374-ad57-e51bedf91813', '5ea4b50f-6f1e-4b91-acb9-9ff5943d61bb', '2026-04-24 00:26:33', 'sale', '806426e7-b08d-4f23-ab2b-244e86a33c89', '0.00', '0.00', '0.00', 'Bill INV-2026-0022', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c45d7c66-1625-41ea-9e3a-05a777225e35', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-06-06 00:26:33', 'payment_out', '1ec24966-064f-4f6c-8640-7d486026c549', '4288.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0052', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c4865ac3-d7f9-40dd-9057-23d5abe3b7d2', '101da879-b8ca-419a-bc8f-3cc8fc437769', '2026-07-02 00:26:33', 'payment_out', 'a7ac294c-6a88-4b36-931b-797d1e8ff23d', '2279.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0029', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c55443d0-1423-4665-929b-ce92ce06c5c6', '6592be06-2ef6-4d47-8b92-d943db8b83cf', '2026-04-13 00:26:34', 'sale', 'ace78616-807f-49a9-af6f-cfb054bfef77', '0.00', '0.00', '0.00', 'Bill INV-2026-0112', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c627fd06-1548-425e-b52e-01961a399774', 'ba49bbc5-a47d-4a73-a0fc-17a222512e7b', '2026-06-14 00:26:34', 'sale', '6ca1ad81-963a-4e48-8390-1911abe29045', '0.00', '0.00', '0.00', 'Bill INV-2026-0120', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c6c65216-ea7d-4856-9527-6e8be60aa612', 'af3d02af-a28f-4060-9ec1-2a2f7d782bbd', '2026-05-27 00:26:33', 'sale', '346446bb-c4d3-49f0-ad73-2c7bd18f7339', '0.00', '0.00', '0.00', 'Bill INV-2026-0023', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c7a47a19-9a30-4ee3-a449-e931d75da32a', '7af0f6f0-aaf9-4841-a383-c1e8f03cd9e9', '2026-05-15 00:26:33', 'sale', 'de85d80b-2e7d-4254-8d2e-07978f5cd61b', '0.00', '0.00', '0.00', 'Bill INV-2026-0036', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c8f3ef84-aea9-4fdb-9d56-6fcc953736cd', 'a39b3f86-5d91-4818-99af-ea175b09a3b7', '2026-05-27 00:26:33', 'sale', '2de38345-bb4b-427a-9673-c2a954d7edf2', '0.00', '0.00', '0.00', 'Bill INV-2026-0050', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ca5d7aef-bd7e-4ed3-9fce-befebd26a3c0', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-04-21 00:26:33', 'payment_out', '45bb78dd-5626-46aa-858b-91df490bb281', '7237.50', '0.00', '0.00', 'Payment for Bill PUR-2026-0047', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cb758011-9f33-409a-b075-346b948095b1', '32e0edbd-6dd5-489d-8c97-5abacfcad2a6', '2026-05-27 00:26:33', 'sale', 'cc6ea8da-ebfb-40d5-bae2-efb5251421bb', '0.00', '0.00', '0.00', 'Bill INV-2026-0043', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cc7842a7-9f08-4454-a0b6-09eb6e927b2b', '81e9d1fc-d64d-43b8-b02d-4ed1f1646ec0', '2026-04-14 00:26:33', 'sale', '3753cd55-d40d-4c17-9c84-c9de6cafc16a', '0.00', '0.00', '0.00', 'Bill INV-2026-0066', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cc90c0d4-dfb3-4715-b4fa-1916ffdf8b82', '34baeed3-a1cc-4d60-9076-66ae7d62e365', '2026-05-24 00:26:34', 'sale', '372a8530-e794-4669-835c-5c682c0bc00a', '0.00', '0.00', '0.00', 'Bill INV-2026-0099', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cd8c1944-86c4-4584-8b5f-7bb6ed1efff4', '8363a724-4fa1-4ab9-96b4-4f42cf03164c', '2026-06-22 00:26:34', 'sale', '19c0b29a-d8c6-4caa-b1fa-f2154e835be8', '0.00', '0.00', '0.00', 'Bill INV-2026-0113', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cda0b2b9-a846-4c35-9f83-c2e6bb74fc21', 'a9f20156-f1e5-46d2-98b2-37e8fccfdb9c', '2026-07-02 00:26:33', 'sale', '18304e74-0118-43cd-b31b-054ca7140ef3', '0.00', '0.00', '0.00', 'Bill INV-2026-0030', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cf1310b7-7b30-4bb1-bbae-c1cc2aa72236', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-06-16 00:26:34', 'sale', '3fdb3a18-1e0c-4c07-b462-31661193eee0', '0.00', '0.00', '0.00', 'Bill INV-2026-0103', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('cfeb9f2b-d7f5-490a-bd16-ddd633c10219', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', '2026-06-11 00:26:33', 'purchase', '19e34932-c55f-46eb-a002-8867eb91ec9a', '0.00', '4627.00', '4627.00', 'Bill PUR-2026-0024', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d0aa7f8b-3cae-46fa-8dc3-2a4f152dec58', '462f1d74-95f1-4208-bbe9-4b121bd93537', '2026-06-08 00:26:34', 'sale', 'a04db748-8819-4f3c-a0b6-68ac65c2a092', '0.00', '0.00', '0.00', 'Bill INV-2026-0076', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d30d6226-6c57-4617-aaff-30c0320e2e59', '7090eee5-197d-4dcf-a509-536622452d5c', '2026-04-28 00:26:33', 'payment_out', '0b534885-be1d-4d72-92f6-e18c4a4c3a87', '8687.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0048', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d35292f0-a5c9-4e36-9906-26eca06ee03d', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-04-21 00:26:33', 'sale', '1fb66e5f-32b7-4765-bfb9-31dc9c9818f5', '0.00', '0.00', '0.00', 'Bill INV-2026-0007', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d6e1a85a-ab0b-4c28-a1e4-ae00ead53dba', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-04-14 00:26:33', 'purchase', '51a0cecd-b5a9-431a-a13d-700053a245ee', '0.00', '12296.00', '12296.00', 'Bill PUR-2026-0023', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d81461fb-021b-4b09-987c-4b430b3c9557', '58c42d77-5206-47a1-8566-f9fbeb222b8b', '2026-06-16 00:26:33', 'sale', '2ffb5a8f-634a-462a-a500-8c537fa4a2de', '0.00', '0.00', '0.00', 'Bill INV-2026-0047', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d8874dd7-a4d6-483f-a0a9-079dacef6e5a', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-06-23 00:26:33', 'purchase', '298ecf4f-366c-46ff-99e3-28849d9e4ee2', '0.00', '4836.00', '4836.00', 'Bill PUR-2026-0022', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('d8fa09a2-e727-4a17-94c9-c94b7822b26c', 'a1a705bf-1ed5-4613-95c9-e8e22cb26738', '2026-06-21 00:26:34', 'sale', '8115fe79-4e02-4866-8099-057a8c8e95f1', '0.00', '0.00', '0.00', 'Bill INV-2026-0082', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('da03280a-3f53-4cd9-af72-7563616e57a3', 'febe6996-959b-4b68-84fc-b8d42feb35f2', '2026-05-20 00:26:33', 'sale', '3d8f8c4a-ab34-44be-ad9b-5b3693ad1d78', '0.00', '0.00', '0.00', 'Bill INV-2026-0009', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('da7f7a32-7d76-43bf-8148-836d260e1dcc', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-06-07 00:26:33', 'purchase', '95ad9be5-5682-4cee-8c4c-34472b15fbaf', '0.00', '4760.00', '4760.00', 'Bill PUR-2026-0046', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dadc06eb-84e7-4557-9f27-228e64e314be', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-04-23 00:26:33', 'purchase', 'bd48c167-e2f3-464c-8934-0fee3265c8dd', '0.00', '975.00', '975.00', 'Bill PUR-2026-0026', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dc8e4f57-ad16-4ed2-8e99-6ac8c877af45', '95fa4fa7-e4f3-41eb-87eb-40cd3175b966', '2026-06-27 00:26:34', 'sale', '76bec39f-1de8-414d-a7d4-9fe980c7e70a', '0.00', '0.00', '0.00', 'Bill INV-2026-0098', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('dd00205e-3704-4863-ae77-cb56e2d9ee2e', 'febe6996-959b-4b68-84fc-b8d42feb35f2', '2026-04-25 00:26:33', 'sale', '0db78f51-59b4-4273-9fbf-afc88dad1238', '0.00', '0.00', '0.00', 'Bill INV-2026-0003', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('de34c062-4b62-4c3b-ac11-23bba210f7d3', 'daa6557d-2131-4f0d-9703-620f1898bb78', '2026-05-24 00:26:33', 'payment_out', '3477c932-cd21-4f0a-b253-1120e0b0f1aa', '7974.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0016', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('de87c845-729d-4555-845f-f5df8938fbbd', '3585dbf2-303a-4e34-9bef-14f47bac2f1b', '2026-05-29 00:26:34', 'sale', 'd87b77f6-2bf5-445e-97e2-e53be81c05b0', '0.00', '0.00', '0.00', 'Bill INV-2026-0094', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e01445cc-d18a-4638-94ca-00f0348deb14', '646193a4-2b3e-4fc3-ab98-c096a37a2841', '2026-06-05 00:26:33', 'sale', '4308c87e-c192-4372-935e-084b2a0ae8f4', '0.00', '0.00', '0.00', 'Bill INV-2026-0062', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e32d83da-1cb0-4e29-b5a9-6e000d6fe412', 'c02518fd-c412-4249-b633-88da66b81ab7', '2026-05-28 00:26:33', 'purchase', '20714c7f-fe28-4318-8597-aa619b2224d6', '0.00', '14339.00', '14339.00', 'Bill PUR-2026-0012', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e3c38488-5781-472c-8234-696efa71953e', '859f03f3-0d7e-4a12-8b47-16db4d534435', '2026-05-01 00:26:34', 'sale', 'e35630a2-6a70-40e2-afa0-8ff0ce37002e', '0.00', '0.00', '0.00', 'Bill INV-2026-0104', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e46de10a-a80c-4775-b831-13dbce7dc5a5', 'add72a01-49ef-4194-ae1c-f1a4254d1dfa', '2026-05-14 00:26:33', 'purchase', '383d7221-a87e-4a1d-93c0-899bb1e77508', '0.00', '7014.00', '7014.00', 'Bill PUR-2026-0032', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e5adbd74-5486-4cc0-9d0b-c20189ad6e5a', '6592be06-2ef6-4d47-8b92-d943db8b83cf', '2026-04-25 00:26:34', 'sale', 'f60de494-7672-49c9-8ae6-041b72c48a6b', '0.00', '0.00', '0.00', 'Bill INV-2026-0109', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e5e95c28-881b-4d0f-a282-cf69d9dda07f', 'af3d02af-a28f-4060-9ec1-2a2f7d782bbd', '2026-07-11 00:26:34', 'sale', '3772b918-16cc-4c1e-baba-f7f40d623f96', '0.00', '0.00', '0.00', 'Bill INV-2026-0083', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e675fdbf-e1af-48fa-8823-b7940a071e66', '953f19e3-8ada-4ca9-9f8d-91b6a62c06c7', '2026-05-30 00:26:33', 'sale', 'edacb994-be0f-4ce8-9898-0519f9fffa4b', '0.00', '0.00', '0.00', 'Bill INV-2026-0011', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e6e948b5-6d55-4738-b4d3-8a9c803a78f8', '7c070003-29af-48fb-88ef-ec752cd440b1', '2026-06-05 00:26:33', 'payment_out', 'f41934d6-7f3c-4975-8553-42d4fe95759d', '7780.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0008', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e7b917f1-e0b6-4ca2-aa81-4ff2ef034980', '953f19e3-8ada-4ca9-9f8d-91b6a62c06c7', '2026-05-24 00:26:33', 'sale', '9f9925f8-026c-4834-ab27-6a2f2e42e811', '0.00', '0.00', '0.00', 'Bill INV-2026-0010', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e7f4a68c-15e7-4040-8182-b47e5b26a31a', '75ac953e-9a2e-4fad-a22b-74edc241a5aa', '2026-05-20 00:26:33', 'payment_out', 'a4499789-14c0-45ba-b5bf-f74b361cc675', '16606.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0001', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e8bf5783-2a6f-4d2b-9a9a-19d52011e792', '29b3435d-0bee-4b96-92bb-10c43f482b90', '2026-06-23 00:26:33', 'payment_out', 'c06bfe9d-8d0e-4e45-a2d0-a56275aa5480', '4836.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0022', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e969f592-23f0-4ae2-9395-4962d1d5bd70', '60afb66d-6dfe-4a51-862f-e58d07f32488', '2026-04-13 00:26:34', 'sale', '72b9d9b9-0b91-465c-b794-12e398f9e5e8', '0.00', '0.00', '0.00', 'Bill INV-2026-0074', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('eca3707d-d894-4c3f-9ca3-5a015f534745', '3cb004c6-4f8d-4b0e-935c-d8fbdc9978f3', '2026-06-05 00:26:33', 'payment_out', '504e29c9-a466-4dad-88dd-7d63b7a51237', '1359.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0006', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ed3cba37-c5cd-4fb2-bfab-0af859bc605e', '462f1d74-95f1-4208-bbe9-4b121bd93537', '2026-05-05 00:26:33', 'sale', '6bd44ea7-d0cd-48a3-925a-0c9340c74ee6', '0.00', '0.00', '0.00', 'Bill INV-2026-0064', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('edf5c228-097c-4f78-9138-1d0b0798f3ba', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-07-08 00:26:33', 'payment_out', 'c4c0cb34-9526-4061-92fc-8ba42797fbae', '8994.00', '0.00', '0.00', 'Payment for Bill PUR-2026-0054', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f1dab8e7-5860-4b36-a14c-350fc47c90ad', '5ea4b50f-6f1e-4b91-acb9-9ff5943d61bb', '2026-06-25 00:26:33', 'sale', 'a82a0cf7-2dd2-4596-bfd4-b4873946bb5a', '0.00', '0.00', '0.00', 'Bill INV-2026-0008', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f301d349-234c-45db-ba2a-b0687d4b6d8d', 'b1508ef9-da0d-4435-aa8c-8c62d0b0c320', '2026-05-23 00:26:33', 'sale', 'e2ec0ed3-ac3c-4868-ba92-ecfc52389b51', '0.00', '0.00', '0.00', 'Bill INV-2026-0015', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f350f65f-c4c0-4e06-8aa4-04813ea18385', '101da879-b8ca-419a-bc8f-3cc8fc437769', '2026-07-02 00:26:33', 'purchase', '1f685fa8-60af-4fc9-ae7e-4695dc9ebabe', '0.00', '2279.00', '2279.00', 'Bill PUR-2026-0029', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f461913c-377e-41b2-8cf4-c10f74fa12ff', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-07-04 00:26:33', 'purchase', '3f640636-4b61-465f-bedc-8b2daf76ce2b', '0.00', '6441.00', '6441.00', 'Bill PUR-2026-0028', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f4e6b857-537c-4f0c-88e0-2a13b5c8fe73', '5ea4b50f-6f1e-4b91-acb9-9ff5943d61bb', '2026-06-30 00:26:33', 'sale', 'c13b39d5-4b35-47c2-805f-10e09db699d5', '0.00', '0.00', '0.00', 'Bill INV-2026-0048', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f53fdbf1-f825-4c08-8c65-e29ed8db356c', '4dd5a30a-c998-40cb-8182-c100d8c3e46e', '2026-04-19 00:26:33', 'purchase', '2963ca45-1415-465d-8c5b-51d7fd725d9c', '0.00', '9128.00', '9128.00', 'Bill PUR-2026-0018', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f5ca143e-4562-46f9-9a26-21ebe1fdd07d', 'a39b3f86-5d91-4818-99af-ea175b09a3b7', '2026-05-13 00:26:34', 'sale', '03461ac5-3a47-426c-b1c4-9b146e9fda0a', '0.00', '0.00', '0.00', 'Bill INV-2026-0101', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f6209770-a3eb-4e84-8aca-6f5c927f8c8e', 'b2e2cd31-ee41-4984-883e-731ca4251732', '2026-05-08 00:26:34', 'sale', '76998c17-c189-45c9-955e-7f3a8f526771', '0.00', '0.00', '0.00', 'Bill INV-2026-0093', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f9613628-b2d9-43fe-97bd-f53de503b761', 'f7a79ca7-8f82-4cab-a07d-9fac04ee0e25', '2026-06-17 00:26:33', 'purchase', '5e14fa6f-2243-47b5-8f29-1ac4c8b748ff', '0.00', '9056.00', '9056.00', 'Bill PUR-2026-0034', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fabc7640-6aff-429f-b7c9-e73859a49182', 'daa6557d-2131-4f0d-9703-620f1898bb78', '2026-05-24 00:26:33', 'purchase', '7424714d-26f5-4dfb-8365-0dcb860e39b8', '0.00', '7974.00', '7974.00', 'Bill PUR-2026-0016', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fad1b7de-0d29-4375-9240-b079d8b93f29', '615fa6aa-6fd8-4492-966b-395f5ef34a4c', '2026-05-01 00:26:33', 'sale', 'cfdff5ae-0784-4fbf-a05c-2dc28c3c9dbe', '0.00', '0.00', '0.00', 'Bill INV-2026-0032', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fb04b249-2d61-44b1-b7ba-259c3b602702', '6093f0ed-9b6c-4ece-941f-a22f35787113', '2026-06-24 00:26:34', 'sale', 'aef370a1-15e2-427a-bba8-e7062d9c700f', '0.00', '0.00', '0.00', 'Bill INV-2026-0073', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `party_ledgers` (`id`, `party_id`, `transaction_date`, `type`, `reference_id`, `debit`, `credit`, `balance`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ffc39179-2bad-4632-8115-ba6cb4f5d54f', '81e9d1fc-d64d-43b8-b02d-4ed1f1646ec0', '2026-05-08 00:26:33', 'sale', '4de61e3a-cc31-499d-bddc-f40e92387281', '0.00', '0.00', '0.00', 'Bill INV-2026-0018', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);

-- TABLE: expense_categories
INSERT IGNORE INTO `expense_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES ('018e3d23-821f-4ead-bcb8-092860454967', 'Miscellaneous', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `expense_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0d81dff4-50a7-40b9-90d6-951bad322f62', 'Transport', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `expense_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES ('5ba0fd6b-2eed-4717-a202-051bcb515052', 'Salary', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `expense_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES ('717d1cdd-147b-4bbe-8953-430bbf341201', 'Rent', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);
INSERT IGNORE INTO `expense_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e3784df1-d8ca-4e61-a0c5-8157b3032d15', 'Utilities', '2026-07-11 05:56:33', '2026-07-11 05:56:33', NULL);

-- TABLE: expenses
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('05aacc09-1431-47f7-bb46-edb9f0c12f56', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-06-30 00:26:34', '543.36', 'bank', 'Labour Tea Expense', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('07d0aaef-63fb-4cba-bed1-fee228e47534', 'e3784df1-d8ca-4e61-a0c5-8157b3032d15', '2026-07-05 00:26:34', '1903.75', 'upi', 'Water Can', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('18237745-1f60-4544-9f6d-13eaff8e92a0', '5ba0fd6b-2eed-4717-a202-051bcb515052', '2026-07-09 00:26:34', '1164.83', 'card', 'Water Can', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('1ebd46d2-69d1-4ce0-b63b-e8610b330d7a', 'e3784df1-d8ca-4e61-a0c5-8157b3032d15', '2026-05-02 00:26:34', '789.99', 'card', 'Diesel for Generator', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('307500ea-0363-4386-91a1-1f499711ac1b', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-06-02 00:26:34', '162.58', 'card', 'EB Bill - Godown', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('37ca8769-51ee-4a07-81a7-a74b398d41e9', '018e3d23-821f-4ead-bcb8-092860454967', '2026-06-26 00:26:34', '591.84', 'bank', 'Auto Fare for Transport', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4754f616-8666-4515-9057-8f0d3994aed7', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-06-11 00:26:34', '1499.09', 'upi', 'Loading/Unloading Charges', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('4dc772dc-f3d3-49e1-9a86-94d318a6a9f7', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-06-20 00:26:34', '983.30', 'cash', 'Loading/Unloading Charges', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('519c939c-0083-46d0-a4a3-9fd8886f771b', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-06-19 00:26:34', '385.73', 'card', 'EB Bill - Godown', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('65b375ac-058e-4e95-a77f-56e1bfa833c2', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-06-28 00:26:34', '1857.68', 'upi', 'Lorry Freight - TN 65', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('662f4957-5fc2-4449-99c7-2abdb21b65ff', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-05-06 00:26:34', '497.12', 'cash', 'Office Cleaning', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7e5c77e8-8285-4a22-85bf-6a7c2988b696', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-05-18 00:26:34', '285.31', 'upi', 'Water Can', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('7ffb466a-b0eb-47d6-9e3c-724eb851d132', '018e3d23-821f-4ead-bcb8-092860454967', '2026-06-25 00:26:34', '735.95', 'card', 'Loading/Unloading Charges', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('94ccf083-c781-4825-a29a-256f6c9896fe', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-05-27 00:26:34', '353.78', 'cash', 'Staff Advance - Muthu', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('9f62b7ff-1d41-4f0a-a1f8-8e93f0b3e6f5', '5ba0fd6b-2eed-4717-a202-051bcb515052', '2026-04-17 00:26:34', '1670.51', 'cash', 'Stationery items', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a1455175-14a6-4ab3-8d0b-22549cda1777', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-04-24 00:26:34', '142.94', 'card', 'Labour Tea Expense', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('a63b56f2-8a78-48a5-96eb-4ebc1010abe2', '018e3d23-821f-4ead-bcb8-092860454967', '2026-07-04 00:26:34', '1112.07', 'bank', 'Auto Fare for Transport', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('ad9c4b46-d060-47ea-b1f7-1ff312e0c228', '5ba0fd6b-2eed-4717-a202-051bcb515052', '2026-05-27 00:26:34', '1671.21', 'card', 'Diesel for Generator', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('b16e5655-99bb-4a4b-b699-a2f04dc667c0', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-07-01 00:26:34', '708.39', 'cash', 'Water Can', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c050a58a-07c7-43bd-ab94-b77d022b9376', '5ba0fd6b-2eed-4717-a202-051bcb515052', '2026-06-29 00:26:34', '78.49', 'card', 'Auto Fare for Transport', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c2efd965-0fef-47fb-bbe4-be6a6775f2cc', 'e3784df1-d8ca-4e61-a0c5-8157b3032d15', '2026-07-03 00:26:34', '1578.05', 'cash', 'Stationery items', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c3f02e73-c114-427d-acf5-8b8203ce94cf', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-06-09 00:26:34', '542.35', 'upi', 'Office Cleaning', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c54159d5-c686-4539-a8f8-144d2dbf4456', 'e3784df1-d8ca-4e61-a0c5-8157b3032d15', '2026-05-07 00:26:34', '870.69', 'card', 'Staff Advance - Muthu', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('c7fc689b-1b32-4725-b57f-57b924387850', '018e3d23-821f-4ead-bcb8-092860454967', '2026-04-30 00:26:34', '792.07', 'card', 'Diesel for Generator', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e31622a2-d783-481b-962f-d95ffd10dc55', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-04-26 00:26:34', '988.99', 'bank', 'Stationery items', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('e3168ec3-a829-4e81-9259-50338fdcdd80', '018e3d23-821f-4ead-bcb8-092860454967', '2026-06-28 00:26:34', '1195.77', 'upi', 'EB Bill - Godown', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f324c0b4-17f7-457a-a389-a702904dd619', '5ba0fd6b-2eed-4717-a202-051bcb515052', '2026-04-16 00:26:34', '1646.87', 'bank', 'Labour Tea Expense', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('f3cfc5e6-e0fc-46e8-9193-164f990dfeae', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-06-01 00:26:34', '1813.67', 'card', 'Loading/Unloading Charges', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('face7113-e6d1-499e-9e48-1ef55295bb03', '0d81dff4-50a7-40b9-90d6-951bad322f62', '2026-06-20 00:26:34', '615.89', 'bank', 'Office Cleaning', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);
INSERT IGNORE INTO `expenses` (`id`, `category_id`, `date`, `amount`, `payment_mode`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fe72e055-b28c-4dd1-b64c-9c019f17b82d', '717d1cdd-147b-4bbe-8953-430bbf341201', '2026-05-19 00:26:34', '1849.52', 'cash', 'Labour Tea Expense', '2026-07-11 05:56:34', '2026-07-11 05:56:34', NULL);

