INSERT INTO `payment_events` (`id`, `gateway`, `event_type`, `reference_id`, `transaction_id`, `amount`, `payload`, `processed`, `company_id`, `processed_at`, `created_at`) VALUES
(517, 'proxypay', 'synced_payment', '355185553', '841704923783', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766115509\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T03:39:13Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841704923783,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":355185553,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4923783}', 0, NULL, NULL, '2026-04-30 21:53:55'),
(518, 'proxypay', 'synced_payment', '748800699', '841704944042', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766115925\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T03:46:55Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841704944042,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":748800699,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4944042}', 0, NULL, NULL, '2026-04-30 21:53:56'),
(519, 'proxypay', 'synced_payment', '201720377', '841704951390', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766116159\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T03:49:46Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841704951390,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":201720377,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4951390}', 0, NULL, NULL, '2026-04-30 21:53:56'),
(520, 'proxypay', 'synced_payment', '254653294', '841704967701', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766116445\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T03:54:43Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841704967701,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":254653294,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4967701}', 0, NULL, NULL, '2026-04-30 21:53:58'),
(521, 'proxypay', 'synced_payment', '528498954', '841704993431', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766116820\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:00:54Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841704993431,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":528498954,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4993431}', 0, NULL, NULL, '2026-04-30 21:53:59'),
(522, 'proxypay', 'synced_payment', '903109364', '841705006132', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766117023\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:04:52Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705006132,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":903109364,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5006132}', 0, NULL, NULL, '2026-04-30 21:53:59'),
(523, 'proxypay', 'synced_payment', '558104641', '841705013217', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766117191\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:07:02Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705013217,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":558104641,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5013217}', 0, NULL, NULL, '2026-04-30 21:54:00'),
(524, 'proxypay', 'synced_payment', '112157408', '841705019178', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766117294\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:08:42Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705019178,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":112157408,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5019178}', 0, NULL, NULL, '2026-04-30 21:54:00'),
(525, 'proxypay', 'synced_payment', '563970029', '841705037665', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766117587\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:13:35Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705037665,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":563970029,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5037665}', 0, NULL, NULL, '2026-04-30 21:55:37'),
(526, 'proxypay', 'synced_payment', '904534262', '841705043879', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766117666\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:15:13Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705043879,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":904534262,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5043879}', 0, NULL, NULL, '2026-04-30 21:55:37'),
(527, 'proxypay', 'synced_payment', '549298961', '841705063686', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766117961\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:20:04Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705063686,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":549298961,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5063686}', 0, NULL, NULL, '2026-04-30 21:55:38'),
(528, 'proxypay', 'synced_payment', '254433470', '841705082105', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766118222\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:24:11Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705082105,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":254433470,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5082105}', 0, NULL, NULL, '2026-04-30 21:55:38'),
(529, 'proxypay', 'synced_payment', '522349495', '841705143076', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766118907\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:35:27Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705143076,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":522349495,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5143076}', 0, NULL, NULL, '2026-04-30 21:55:43'),
(530, 'proxypay', 'synced_payment', '714810639', '841705164342', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766119094\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:38:52Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705164342,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":714810639,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5164342}', 0, NULL, NULL, '2026-04-30 21:55:43'),
(531, 'proxypay', 'synced_payment', '186869133', '841705268095', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766119888\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:52:13Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705268095,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":186869133,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5268095}', 0, NULL, NULL, '2026-04-30 21:55:45'),
(532, 'proxypay', 'synced_payment', '222274499', '841705305340', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766120124\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T04:56:21Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705305340,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":222274499,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5305340}', 0, NULL, NULL, '2026-04-30 21:55:45'),
(533, 'proxypay', 'synced_payment', '458135586', '841705382775', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766120578\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T05:03:38Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705382775,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":458135586,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5382775}', 0, NULL, NULL, '2026-04-30 21:55:46'),
(534, 'proxypay', 'synced_payment', '434450347', '841705427398', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766120843\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T05:08:01Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705427398,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":434450347,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5427398}', 0, NULL, NULL, '2026-04-30 21:55:46'),
(535, 'proxypay', 'synced_payment', '290166524', '841705451459', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766120989\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T05:10:15Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841705451459,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":290166524,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5451459}', 0, NULL, NULL, '2026-04-30 21:55:47'),
(536, 'proxypay', 'synced_payment', '192224537', '841709768864', 30000.00, '{\"amount\":\"30000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 12\\u00ba Classe (Est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1019_43040_1766132376\",\"student_id\":\"1019 -\"},\"datetime\":\"2025-12-19T08:22:19Z\",\"entity_id\":647,\"fee\":\"225.00\",\"id\":841709768864,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":192224537,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":9768864}', 0, NULL, NULL, '2026-04-30 21:55:47'),
(537, 'proxypay', 'synced_payment', '674275947', '841710310195', 37296.00, '{\"amount\":\"37296.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_933_41723_1766133516\",\"student_id\":\"933 -\"},\"datetime\":\"2025-12-19T08:39:36Z\",\"entity_id\":647,\"fee\":\"279.72\",\"id\":841710310195,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":674275947,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":10310195}', 0, NULL, NULL, '2026-04-30 21:55:48'),
(538, 'proxypay', 'synced_payment', '800497998', '841711085343', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1596_43119_1766134811\",\"student_id\":\"1596 -\"},\"datetime\":\"2025-12-19T09:03:57Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":841711085343,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":800497998,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11085343}', 0, NULL, NULL, '2026-04-30 21:55:48'),
(539, 'proxypay', 'synced_payment', '410646225', '841711656007', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766135974\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T09:21:38Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841711656007,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":410646225,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11656007}', 0, NULL, NULL, '2026-04-30 21:55:49'),
(540, 'proxypay', 'synced_payment', '766698891', '841712705107', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766137920\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T09:53:50Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841712705107,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":766698891,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12705107}', 0, NULL, NULL, '2026-04-30 21:55:49'),
(541, 'proxypay', 'synced_payment', '815420607', '841712995740', 75000.00, '{\"amount\":\"75000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio Eletr\\u00f3nica Telecomunica\\u00e7\\u00f5es (EET)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3476_43184_1766138492\",\"student_id\":\"3476 -\"},\"datetime\":\"2025-12-19T10:02:43Z\",\"entity_id\":647,\"fee\":\"562.50\",\"id\":841712995740,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":815420607,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12995740}', 0, NULL, NULL, '2026-04-30 21:55:51'),
(542, 'proxypay', 'synced_payment', '413159420', '841714049543', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766140459\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-19T10:35:21Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841714049543,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":413159420,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":14049543}', 0, NULL, NULL, '2026-04-30 21:55:51'),
(543, 'proxypay', 'synced_payment', '221038468', '841716270322', 30000.00, '{\"amount\":\"30000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 12\\u00ba Classe (Est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1493_43048_1766144508\",\"student_id\":\"1493 -\"},\"datetime\":\"2025-12-19T11:44:58Z\",\"entity_id\":647,\"fee\":\"225.00\",\"id\":841716270322,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":221038468,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":16270322}', 0, NULL, NULL, '2026-04-30 21:55:52'),
(544, 'proxypay', 'synced_payment', '362498594', '841719379815', 30000.00, '{\"amount\":\"30000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 12\\u00ba Classe (Est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1541_43050_1766150037\",\"student_id\":\"1541 -\"},\"datetime\":\"2025-12-19T13:22:03Z\",\"entity_id\":647,\"fee\":\"225.00\",\"id\":841719379815,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":362498594,\"terminal_id\":\"0000505401\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":38,\"terminal_transaction_id\":132,\"terminal_type\":\"ATM\",\"transaction_id\":19379815}', 0, NULL, NULL, '2026-04-30 21:55:53'),
(545, 'proxypay', 'synced_payment', '148401161', '841721872272', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1225_43106_1766155064\",\"student_id\":\"1225 -\"},\"datetime\":\"2025-12-19T14:38:45Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":841721872272,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":148401161,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":21872272}', 0, NULL, NULL, '2026-04-30 21:55:53'),
(546, 'proxypay', 'synced_payment', '185606704', '841722992443', 37296.00, '{\"amount\":\"37296.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2809_39951_1766157155\",\"student_id\":\"2809 -\"},\"datetime\":\"2025-12-19T15:14:04Z\",\"entity_id\":647,\"fee\":\"279.72\",\"id\":841722992443,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":185606704,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":22992443}', 0, NULL, NULL, '2026-04-30 21:55:53'),
(547, 'proxypay', 'synced_payment', '442067173', '841723379987', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_925_43099_1766156627\",\"student_id\":\"925 -\"},\"datetime\":\"2025-12-19T15:26:23Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":841723379987,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":442067173,\"terminal_id\":\"0000505401\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":38,\"terminal_transaction_id\":281,\"terminal_type\":\"ATM\",\"transaction_id\":23379987}', 0, NULL, NULL, '2026-04-30 21:55:54'),
(548, 'proxypay', 'synced_payment', '938039953', '841723418362', 37296.00, '{\"amount\":\"37296.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Outubro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_925_41367_1766156581\",\"student_id\":\"925 -\"},\"datetime\":\"2025-12-19T15:27:37Z\",\"entity_id\":647,\"fee\":\"279.72\",\"id\":841723418362,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":938039953,\"terminal_id\":\"0000505401\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":38,\"terminal_transaction_id\":286,\"terminal_type\":\"ATM\",\"transaction_id\":23418362}', 0, NULL, NULL, '2026-04-30 21:55:54'),
(549, 'proxypay', 'synced_payment', '783624424', '841726038028', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1003_43102_1766162973\",\"student_id\":\"1003 -\"},\"datetime\":\"2025-12-19T16:52:07Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":841726038028,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-19T19:00:00Z\",\"period_id\":8417,\"period_start_datetime\":\"2025-12-18T19:00:00Z\",\"product_id\":1,\"reference_id\":783624424,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":26038028}', 0, NULL, NULL, '2026-04-30 21:55:55'),
(550, 'proxypay', 'synced_payment', '191124787', '841902996898', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766267605\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-20T21:54:27Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841902996898,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":191124787,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":2996898}', 0, NULL, NULL, '2026-04-30 21:55:55'),
(551, 'proxypay', 'synced_payment', '624813540', '841903175652', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766268569\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-20T22:10:13Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841903175652,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":624813540,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3175652}', 0, NULL, NULL, '2026-04-30 21:55:56'),
(552, 'proxypay', 'synced_payment', '194488076', '841903644981', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766271758\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-20T23:03:20Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841903644981,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":194488076,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3644981}', 0, NULL, NULL, '2026-04-30 21:55:57'),
(553, 'proxypay', 'synced_payment', '286754073', '841903747310', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766272634\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-20T23:17:49Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841903747310,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":286754073,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3747310}', 0, NULL, NULL, '2026-04-30 21:55:57'),
(554, 'proxypay', 'synced_payment', '307011169', '841903816135', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT MV)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766273296\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-20T23:28:48Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841903816135,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":307011169,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3816135}', 0, NULL, NULL, '2026-04-30 21:55:58'),
(555, 'proxypay', 'synced_payment', '696651022', '841903913576', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (Rbio)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766274356\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-20T23:46:29Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841903913576,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":696651022,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3913576}', 0, NULL, NULL, '2026-04-30 21:55:59'),
(556, 'proxypay', 'synced_payment', '658973632', '841904039671', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (AEN)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766275953\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-21T00:13:14Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841904039671,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":658973632,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4039671}', 0, NULL, NULL, '2026-04-30 21:55:59'),
(557, 'proxypay', 'synced_payment', '967042723', '841904045294', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (PT JI)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766276052\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-21T00:14:34Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841904045294,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":967042723,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4045294}', 0, NULL, NULL, '2026-04-30 21:56:00'),
(558, 'proxypay', 'synced_payment', '610393985', '841904186215', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (URG-EMRG)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766278194\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-21T00:50:48Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841904186215,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":610393985,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4186215}', 0, NULL, NULL, '2026-04-30 21:56:00'),
(559, 'proxypay', 'synced_payment', '961826888', '841904219076', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste - P- ITBC e 2 convidados\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_1122_1766278766\",\"student_id\":\"4314\",\"student_name\":\"Juliana Cassova Damiano Teste2\"},\"datetime\":\"2025-12-21T01:00:05Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841904219076,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":961826888,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4219076}', 0, NULL, NULL, '2026-04-30 21:56:00'),
(560, 'proxypay', 'synced_payment', '214885522', '841904227986', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (LE)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766278936\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-21T01:02:38Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":841904227986,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":214885522,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4227986}', 0, NULL, NULL, '2026-04-30 21:56:01'),
(561, 'proxypay', 'synced_payment', '969133461', '841906480854', 25771.00, '{\"amount\":\"25771.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"7\\u00aa a 8\\u00aa Classe (Fevereiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_414_36673_1766301359\",\"student_id\":\"414 -\"},\"datetime\":\"2025-12-21T07:18:40Z\",\"entity_id\":647,\"fee\":\"193.28\",\"id\":841906480854,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":969133461,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":6480854}', 0, NULL, NULL, '2026-04-30 21:56:01'),
(562, 'proxypay', 'synced_payment', '290547923', '841906571896', 24060.00, '{\"amount\":\"24060.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"5\\u00aa Classe (Fevereiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_416_36677_1766301781\",\"student_id\":\"416 -\"},\"datetime\":\"2025-12-21T07:24:05Z\",\"entity_id\":647,\"fee\":\"180.45\",\"id\":841906571896,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":290547923,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":6571896}', 0, NULL, NULL, '2026-04-30 21:56:03'),
(563, 'proxypay', 'synced_payment', '681467306', '841907837992', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4479_40621_1766305859\",\"student_id\":\"4479 -\"},\"datetime\":\"2025-12-21T08:31:47Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":841907837992,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":681467306,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":7837992}', 0, NULL, NULL, '2026-04-30 21:56:03'),
(564, 'proxypay', 'synced_payment', '961801196', '841908263065', 37296.00, '{\"amount\":\"37296.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2425_41548_1766306935\",\"student_id\":\"2425 -\"},\"datetime\":\"2025-12-21T08:53:04Z\",\"entity_id\":647,\"fee\":\"279.72\",\"id\":841908263065,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":961801196,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8263065}', 0, NULL, NULL, '2026-04-30 21:56:04'),
(565, 'proxypay', 'synced_payment', '646061521', '841910164002', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2369_37885_1766311928\",\"student_id\":\"2369 -\"},\"datetime\":\"2025-12-21T10:24:28Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":841910164002,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":646061521,\"terminal_id\":\"0000312208\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":50,\"terminal_transaction_id\":1470,\"terminal_type\":\"ATM\",\"transaction_id\":10164002}', 0, NULL, NULL, '2026-04-30 21:56:04'),
(566, 'proxypay', 'synced_payment', '132797746', '841912670631', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3036_37578_1766319556\",\"student_id\":\"3036 -\"},\"datetime\":\"2025-12-21T12:20:58Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":841912670631,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-21T19:00:00Z\",\"period_id\":8419,\"period_start_datetime\":\"2025-12-20T19:00:00Z\",\"product_id\":1,\"reference_id\":132797746,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12670631}', 0, NULL, NULL, '2026-04-30 21:56:05'),
(567, 'proxypay', 'synced_payment', '841345408', '842000932754', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/cassenda.anuarite.com\\/webhook_direto.php\",\"description\":\"teste (PN)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3665_20789_1766346282\",\"student_id\":\"3665 -\"},\"datetime\":\"2025-12-21T19:47:14Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842000932754,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":841345408,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":932754}', 0, NULL, NULL, '2026-04-30 21:56:05'),
(568, 'proxypay', 'synced_payment', '254946671', '842002071158', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/cassenda.anuarite.com\\/webhook_direto.php\",\"description\":\"teste (PN)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3665_20789_1766350312\",\"student_id\":\"3665 -\"},\"datetime\":\"2025-12-21T20:53:09Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842002071158,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":254946671,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":2071158}', 0, NULL, NULL, '2026-04-30 21:56:06'),
(569, 'proxypay', 'synced_payment', '291968321', '842003038551', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/cassenda.anuarite.com\\/webhook_direto.php\",\"description\":\"teste (Outubro Volta)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3665_20789_1766354969\",\"student_id\":\"3665 -\"},\"datetime\":\"2025-12-21T22:10:06Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842003038551,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":291968321,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3038551}', 0, NULL, NULL, '2026-04-30 21:56:06'),
(570, 'proxypay', 'synced_payment', '847021485', '842004567564', 10.00, '{\"amount\":\"10.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Grupo teste (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4314_40478_1766380544\",\"student_id\":\"4314 -\"},\"datetime\":\"2025-12-22T05:16:24Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842004567564,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":847021485,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4567564}', 0, NULL, NULL, '2026-04-30 21:56:07'),
(571, 'proxypay', 'synced_payment', '967637569', '842011239454', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2255_36369_1766388513\",\"student_id\":\"2255 -\"},\"datetime\":\"2025-12-22T09:47:47Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842011239454,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":967637569,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11239454}', 0, NULL, NULL, '2026-04-30 21:56:07'),
(572, 'proxypay', 'synced_payment', '649123952', '842011373155', 25711.00, '{\"amount\":\"25711.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"7\\u00aa a 8\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1796_38589_1766395825\",\"student_id\":\"1796 -\"},\"datetime\":\"2025-12-22T09:51:55Z\",\"entity_id\":647,\"fee\":\"192.83\",\"id\":842011373155,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":649123952,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11373155}', 0, NULL, NULL, '2026-04-30 21:56:08'),
(573, 'proxypay', 'synced_payment', '719698657', '842011513782', 25771.00, '{\"amount\":\"25771.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"9\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1795_38586_1766397318\",\"student_id\":\"1795 -\"},\"datetime\":\"2025-12-22T09:56:15Z\",\"entity_id\":647,\"fee\":\"193.28\",\"id\":842011513782,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":719698657,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11513782}', 0, NULL, NULL, '2026-04-30 21:56:09'),
(574, 'proxypay', 'synced_payment', '174115190', '842012472251', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_723_37506_1766398906\",\"student_id\":\"723 -\"},\"datetime\":\"2025-12-22T10:24:48Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842012472251,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":174115190,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12472251}', 0, NULL, NULL, '2026-04-30 21:56:10'),
(575, 'proxypay', 'synced_payment', '888084979', '842012702788', 35245.20, '{\"amount\":\"35245.20\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4554_41153_1766399364\",\"student_id\":\"4554 -\"},\"datetime\":\"2025-12-22T10:31:36Z\",\"entity_id\":647,\"fee\":\"264.34\",\"id\":842012702788,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":888084979,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12702788}', 0, NULL, NULL, '2026-04-30 21:56:10');
INSERT INTO `payment_events` (`id`, `gateway`, `event_type`, `reference_id`, `transaction_id`, `amount`, `payload`, `processed`, `company_id`, `processed_at`, `created_at`) VALUES
(576, 'proxypay', 'synced_payment', '217602757', '842015804814', 30000.00, '{\"amount\":\"30000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 12\\u00ba Classe (Est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1175_43041_1766384759\",\"student_id\":\"1175 -\"},\"datetime\":\"2025-12-22T12:04:43Z\",\"entity_id\":647,\"fee\":\"225.00\",\"id\":842015804814,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":217602757,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":15804814}', 0, NULL, NULL, '2026-04-30 21:56:11'),
(577, 'proxypay', 'synced_payment', '266264170', '842016982938', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"13\\u00aa Classe Poli (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_31_37088_1766407149\",\"student_id\":\"31 -\"},\"datetime\":\"2025-12-22T12:41:02Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842016982938,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":266264170,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":16982938}', 0, NULL, NULL, '2026-04-30 21:56:11'),
(578, 'proxypay', 'synced_payment', '593278030', '842019528832', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3088_40404_1766411770\",\"student_id\":\"3088 -\"},\"datetime\":\"2025-12-22T13:58:29Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":842019528832,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":593278030,\"terminal_id\":\"0000059551\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":89,\"terminal_transaction_id\":509,\"terminal_type\":\"ATM\",\"transaction_id\":19528832}', 0, NULL, NULL, '2026-04-30 21:56:12'),
(579, 'proxypay', 'synced_payment', '591991537', '842020109568', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_697_40476_1766411624\",\"student_id\":\"697 -\"},\"datetime\":\"2025-12-22T14:16:03Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842020109568,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-22T19:00:00Z\",\"period_id\":8420,\"period_start_datetime\":\"2025-12-21T19:00:00Z\",\"product_id\":1,\"reference_id\":591991537,\"terminal_id\":\"0000059552\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":47,\"terminal_transaction_id\":478,\"terminal_type\":\"ATM\",\"transaction_id\":20109568}', 0, NULL, NULL, '2026-04-30 21:56:12'),
(580, 'proxypay', 'synced_payment', '748670362', '842106918058', 6000.00, '{\"amount\":\"6000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Cadeira de Urinologia (CUri)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_695_43211_1766470367\",\"student_id\":\"695 -\"},\"datetime\":\"2025-12-23T06:13:54Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842106918058,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-23T19:00:00Z\",\"period_id\":8421,\"period_start_datetime\":\"2025-12-22T19:00:00Z\",\"product_id\":1,\"reference_id\":748670362,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":6918058}', 0, NULL, NULL, '2026-04-30 21:56:13'),
(581, 'proxypay', 'synced_payment', '768724642', '842110609565', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1498_43114_1766477037\",\"student_id\":\"1498 -\"},\"datetime\":\"2025-12-23T08:18:51Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":842110609565,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-23T19:00:00Z\",\"period_id\":8421,\"period_start_datetime\":\"2025-12-22T19:00:00Z\",\"product_id\":1,\"reference_id\":768724642,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":10609565}', 0, NULL, NULL, '2026-04-30 21:56:14'),
(582, 'proxypay', 'synced_payment', '421285856', '842114022383', 6000.00, '{\"amount\":\"6000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Cadeira de Urinologia (CUri)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_290_43204_1766483705\",\"student_id\":\"290 -\"},\"datetime\":\"2025-12-23T09:57:02Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842114022383,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-23T19:00:00Z\",\"period_id\":8421,\"period_start_datetime\":\"2025-12-22T19:00:00Z\",\"product_id\":1,\"reference_id\":421285856,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":14022383}', 0, NULL, NULL, '2026-04-30 21:56:15'),
(583, 'proxypay', 'synced_payment', '866932272', '842114665896', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2626_41592_1766484789\",\"student_id\":\"2626 -\"},\"datetime\":\"2025-12-23T10:15:15Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842114665896,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-23T19:00:00Z\",\"period_id\":8421,\"period_start_datetime\":\"2025-12-22T19:00:00Z\",\"product_id\":1,\"reference_id\":866932272,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":14665896}', 0, NULL, NULL, '2026-04-30 21:56:15'),
(584, 'proxypay', 'synced_payment', '393863350', '842116668492', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1902_40061_1766488140\",\"student_id\":\"1902 -\"},\"datetime\":\"2025-12-23T11:11:27Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842116668492,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-23T19:00:00Z\",\"period_id\":8421,\"period_start_datetime\":\"2025-12-22T19:00:00Z\",\"product_id\":1,\"reference_id\":393863350,\"terminal_id\":\"0000059997\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":4,\"terminal_transaction_id\":36,\"terminal_type\":\"ATM\",\"transaction_id\":16668492}', 0, NULL, NULL, '2026-04-30 21:56:16'),
(585, 'proxypay', 'synced_payment', '784359453', '842210364580', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa Classe Complexo e Poli (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3980_36727_1766561577\",\"student_id\":\"3980 -\"},\"datetime\":\"2025-12-24T07:35:05Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842210364580,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":784359453,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":10364580}', 0, NULL, NULL, '2026-04-30 21:56:16'),
(586, 'proxypay', 'synced_payment', '625864118', '842211013964', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa Classe Complexo e Poli (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1690_38896_1766562679\",\"student_id\":\"1690 -\"},\"datetime\":\"2025-12-24T07:53:08Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842211013964,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":625864118,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11013964}', 0, NULL, NULL, '2026-04-30 21:56:19'),
(587, 'proxypay', 'synced_payment', '654072606', '842212384623', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_935_39979_1766564665\",\"student_id\":\"935 -\"},\"datetime\":\"2025-12-24T08:30:58Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842212384623,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":654072606,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12384623}', 0, NULL, NULL, '2026-04-30 21:56:19'),
(588, 'proxypay', 'synced_payment', '764496283', '842212693489', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3116_36705_1766565383\",\"student_id\":\"3116 -\"},\"datetime\":\"2025-12-24T08:39:29Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842212693489,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":764496283,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12693489}', 0, NULL, NULL, '2026-04-30 21:56:20'),
(589, 'proxypay', 'synced_payment', '673464525', '842213117651', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4044_37264_1766566162\",\"student_id\":\"4044 -\"},\"datetime\":\"2025-12-24T08:51:05Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842213117651,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":673464525,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":13117651}', 0, NULL, NULL, '2026-04-30 21:56:20'),
(590, 'proxypay', 'synced_payment', '737418228', '842216322846', 24060.00, '{\"amount\":\"24060.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"6\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1312_36108_1766571145\",\"student_id\":\"1312 -\"},\"datetime\":\"2025-12-24T10:17:54Z\",\"entity_id\":647,\"fee\":\"180.45\",\"id\":842216322846,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":737418228,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":16322846}', 0, NULL, NULL, '2026-04-30 21:56:21'),
(591, 'proxypay', 'synced_payment', '617029030', '842216504630', 20617.00, '{\"amount\":\"20617.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Inicia\\u00e7\\u00e3o a 4\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1317_36104_1766571689\",\"student_id\":\"1317 -\"},\"datetime\":\"2025-12-24T10:22:49Z\",\"entity_id\":647,\"fee\":\"154.63\",\"id\":842216504630,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":617029030,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":16504630}', 0, NULL, NULL, '2026-04-30 21:56:21'),
(592, 'proxypay', 'synced_payment', '867501078', '842216650067', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1322_36081_1766571960\",\"student_id\":\"1322 -\"},\"datetime\":\"2025-12-24T10:26:49Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842216650067,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":867501078,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":16650067}', 0, NULL, NULL, '2026-04-30 21:56:22'),
(593, 'proxypay', 'synced_payment', '712231972', '842222937894', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"13\\u00aa Classe Poli (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3415_41775_1766582222\",\"student_id\":\"3415 -\"},\"datetime\":\"2025-12-24T13:18:02Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842222937894,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-24T19:00:00Z\",\"period_id\":8422,\"period_start_datetime\":\"2025-12-23T19:00:00Z\",\"product_id\":1,\"reference_id\":712231972,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":22937894}', 0, NULL, NULL, '2026-04-30 21:56:22'),
(594, 'proxypay', 'synced_payment', '908288783', '842309828091', 6000.00, '{\"amount\":\"6000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Cadeira Educa\\u00e7\\u00e3o F\\u00edsica (CEF)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1059_43215_1766655359\",\"student_id\":\"1059 -\"},\"datetime\":\"2025-12-25T09:38:29Z\",\"entity_id\":647,\"fee\":\"140.00\",\"id\":842309828091,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-25T19:00:00Z\",\"period_id\":8423,\"period_start_datetime\":\"2025-12-24T19:00:00Z\",\"product_id\":1,\"reference_id\":908288783,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":9828091}', 0, NULL, NULL, '2026-04-30 21:56:23'),
(595, 'proxypay', 'synced_payment', '606816120', '842312329463', 35245.20, '{\"amount\":\"35245.20\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1123_37123_1766662728\",\"student_id\":\"1123 -\"},\"datetime\":\"2025-12-25T11:44:52Z\",\"entity_id\":647,\"fee\":\"264.34\",\"id\":842312329463,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-25T19:00:00Z\",\"period_id\":8423,\"period_start_datetime\":\"2025-12-24T19:00:00Z\",\"product_id\":1,\"reference_id\":606816120,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12329463}', 0, NULL, NULL, '2026-04-30 21:56:24'),
(596, 'proxypay', 'synced_payment', '753293553', '842314784791', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3026_35952_1766671432\",\"student_id\":\"3026 -\"},\"datetime\":\"2025-12-25T14:09:10Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842314784791,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-25T19:00:00Z\",\"period_id\":8423,\"period_start_datetime\":\"2025-12-24T19:00:00Z\",\"product_id\":1,\"reference_id\":753293553,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":14784791}', 0, NULL, NULL, '2026-04-30 21:56:24'),
(597, 'proxypay', 'synced_payment', '799035891', '842405827239', 20617.00, '{\"amount\":\"20617.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Inicia\\u00e7\\u00e3o a 4\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4280_39217_1766735679\",\"student_id\":\"4280 -\"},\"datetime\":\"2025-12-26T07:58:26Z\",\"entity_id\":647,\"fee\":\"154.63\",\"id\":842405827239,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":799035891,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5827239}', 0, NULL, NULL, '2026-04-30 21:56:25'),
(598, 'proxypay', 'synced_payment', '615489897', '842405954832', 25711.00, '{\"amount\":\"25711.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"7\\u00aa a 8\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2911_38963_1766736191\",\"student_id\":\"2911 -\"},\"datetime\":\"2025-12-26T08:04:20Z\",\"entity_id\":647,\"fee\":\"192.83\",\"id\":842405954832,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":615489897,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5954832}', 0, NULL, NULL, '2026-04-30 21:56:25'),
(599, 'proxypay', 'synced_payment', '802878757', '842406117234', 20617.00, '{\"amount\":\"20617.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Inicia\\u00e7\\u00e3o a 4\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2910_38967_1766736653\",\"student_id\":\"2910 -\"},\"datetime\":\"2025-12-26T08:11:48Z\",\"entity_id\":647,\"fee\":\"154.63\",\"id\":842406117234,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":802878757,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":6117234}', 0, NULL, NULL, '2026-04-30 21:56:25'),
(600, 'proxypay', 'synced_payment', '332287738', '842410500052', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa Classe Complexo e Poli (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2587_40224_1766746272\",\"student_id\":\"2587 -\"},\"datetime\":\"2025-12-26T11:09:23Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842410500052,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":332287738,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":10500052}', 0, NULL, NULL, '2026-04-30 21:56:25'),
(601, 'proxypay', 'synced_payment', '305587770', '842411643859', 35245.20, '{\"amount\":\"35245.20\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4614_41676_1766750005\",\"student_id\":\"4614 -\"},\"datetime\":\"2025-12-26T11:55:02Z\",\"entity_id\":647,\"fee\":\"264.34\",\"id\":842411643859,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":305587770,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11643859}', 0, NULL, NULL, '2026-04-30 21:56:26'),
(602, 'proxypay', 'synced_payment', '322445294', '842412209193', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4557_41170_1766751426\",\"student_id\":\"4557 -\"},\"datetime\":\"2025-12-26T12:17:56Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":842412209193,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":322445294,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12209193}', 0, NULL, NULL, '2026-04-30 21:56:26'),
(603, 'proxypay', 'synced_payment', '983152854', '842415991724', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3863_35771_1766761559\",\"student_id\":\"3863 -\"},\"datetime\":\"2025-12-26T15:07:39Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":842415991724,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":983152854,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":15991724}', 0, NULL, NULL, '2026-04-30 21:56:26'),
(604, 'proxypay', 'synced_payment', '907874748', '842419602712', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3878_35880_1766759759\",\"student_id\":\"3878 -\"},\"datetime\":\"2025-12-26T17:55:19Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842419602712,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-26T19:00:00Z\",\"period_id\":8424,\"period_start_datetime\":\"2025-12-25T19:00:00Z\",\"product_id\":1,\"reference_id\":907874748,\"terminal_id\":\"0000501502\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":85,\"terminal_transaction_id\":345,\"terminal_type\":\"ATM\",\"transaction_id\":19602712}', 0, NULL, NULL, '2026-04-30 21:56:26'),
(605, 'proxypay', 'synced_payment', '174465138', '842504753168', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1059_42859_1766816312\",\"student_id\":\"1059 -\"},\"datetime\":\"2025-12-27T06:19:51Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":842504753168,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-27T19:00:00Z\",\"period_id\":8425,\"period_start_datetime\":\"2025-12-26T19:00:00Z\",\"product_id\":1,\"reference_id\":174465138,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4753168}', 0, NULL, NULL, '2026-04-30 21:56:27'),
(606, 'proxypay', 'synced_payment', '117841866', '842505152773', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2991_43145_1766817970\",\"student_id\":\"2991 -\"},\"datetime\":\"2025-12-27T06:49:04Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":842505152773,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-27T19:00:00Z\",\"period_id\":8425,\"period_start_datetime\":\"2025-12-26T19:00:00Z\",\"product_id\":1,\"reference_id\":117841866,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":5152773}', 0, NULL, NULL, '2026-04-30 21:56:27'),
(607, 'proxypay', 'synced_payment', '921436988', '842511804569', 25711.00, '{\"amount\":\"25711.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"7\\u00aa a 8\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_751_36544_1766835454\",\"student_id\":\"751 -\"},\"datetime\":\"2025-12-27T11:42:58Z\",\"entity_id\":647,\"fee\":\"192.83\",\"id\":842511804569,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-27T19:00:00Z\",\"period_id\":8425,\"period_start_datetime\":\"2025-12-26T19:00:00Z\",\"product_id\":1,\"reference_id\":921436988,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11804569}', 0, NULL, NULL, '2026-04-30 21:56:27'),
(608, 'proxypay', 'synced_payment', '840205058', '842511860460', 24060.00, '{\"amount\":\"24060.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"6\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_752_38336_1766835859\",\"student_id\":\"752 -\"},\"datetime\":\"2025-12-27T11:45:12Z\",\"entity_id\":647,\"fee\":\"180.45\",\"id\":842511860460,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-27T19:00:00Z\",\"period_id\":8425,\"period_start_datetime\":\"2025-12-26T19:00:00Z\",\"product_id\":1,\"reference_id\":840205058,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11860460}', 0, NULL, NULL, '2026-04-30 21:56:27'),
(609, 'proxypay', 'synced_payment', '479825310', '842512081886', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"13\\u00aa Classe Poli (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2002_39412_1766836400\",\"student_id\":\"2002 -\"},\"datetime\":\"2025-12-27T11:54:09Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842512081886,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-27T19:00:00Z\",\"period_id\":8425,\"period_start_datetime\":\"2025-12-26T19:00:00Z\",\"product_id\":1,\"reference_id\":479825310,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12081886}', 0, NULL, NULL, '2026-04-30 21:56:28'),
(610, 'proxypay', 'synced_payment', '376635119', '842703994658', 24060.00, '{\"amount\":\"24060.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"6\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_19_35970_1766985913\",\"student_id\":\"19 -\"},\"datetime\":\"2025-12-29T05:29:02Z\",\"entity_id\":647,\"fee\":\"180.45\",\"id\":842703994658,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":376635119,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":3994658}', 0, NULL, NULL, '2026-04-30 21:56:28'),
(611, 'proxypay', 'synced_payment', '105068154', '842704495911', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3517_39539_1766987503\",\"student_id\":\"3517 -\"},\"datetime\":\"2025-12-29T06:17:07Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842704495911,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":105068154,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":4495911}', 0, NULL, NULL, '2026-04-30 21:56:28'),
(612, 'proxypay', 'synced_payment', '680545698', '842706965997', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4279_39212_1766996221\",\"student_id\":\"4279 -\"},\"datetime\":\"2025-12-29T08:18:55Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":842706965997,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":680545698,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":6965997}', 0, NULL, NULL, '2026-04-30 21:56:28'),
(613, 'proxypay', 'synced_payment', '409414731', '842707148616', 22678.70, '{\"amount\":\"22678.70\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Inicia\\u00e7\\u00e3o a 4\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3066_38024_1766996663\",\"student_id\":\"3066 -\"},\"datetime\":\"2025-12-29T08:25:56Z\",\"entity_id\":647,\"fee\":\"170.09\",\"id\":842707148616,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":409414731,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":7148616}', 0, NULL, NULL, '2026-04-30 21:56:29'),
(614, 'proxypay', 'synced_payment', '346197948', '842707414169', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_500_43083_1766997292\",\"student_id\":\"500 -\"},\"datetime\":\"2025-12-29T08:35:55Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":842707414169,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":346197948,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":7414169}', 0, NULL, NULL, '2026-04-30 21:56:29'),
(615, 'proxypay', 'synced_payment', '735243050', '842707488348', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1720_39030_1766997463\",\"student_id\":\"1720 -\"},\"datetime\":\"2025-12-29T08:38:41Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842707488348,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":735243050,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":7488348}', 0, NULL, NULL, '2026-04-30 21:56:30'),
(616, 'proxypay', 'synced_payment', '723973835', '842707708683', 28977.60, '{\"amount\":\"28977.60\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/cassenda.anuarite.com\\/webhook_direto.php\",\"description\":\"9\\u00aa Classe (PN)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3956_19662_1766986411\",\"student_id\":\"3956 -\"},\"datetime\":\"2025-12-29T08:46:50Z\",\"entity_id\":647,\"fee\":\"217.33\",\"id\":842707708683,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":723973835,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":7708683}', 0, NULL, NULL, '2026-04-30 21:56:30'),
(617, 'proxypay', 'synced_payment', '769089846', '842708103337', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1498_40410_1766998810\",\"student_id\":\"1498 -\"},\"datetime\":\"2025-12-29T09:01:04Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842708103337,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":769089846,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8103337}', 0, NULL, NULL, '2026-04-30 21:56:31'),
(618, 'proxypay', 'synced_payment', '947828301', '842708167157', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Fevereiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1498_40410_1766998965\",\"student_id\":\"1498 -\"},\"datetime\":\"2025-12-29T09:03:22Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842708167157,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":947828301,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8167157}', 0, NULL, NULL, '2026-04-30 21:56:31'),
(619, 'proxypay', 'synced_payment', '711215603', '842708225576', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Mar\\u00e7o)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1498_40410_1766999075\",\"student_id\":\"1498 -\"},\"datetime\":\"2025-12-29T09:05:28Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842708225576,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":711215603,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8225576}', 0, NULL, NULL, '2026-04-30 21:56:31'),
(620, 'proxypay', 'synced_payment', '711215603', '842708225576', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Mar\\u00e7o)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1498_40410_1766999075\",\"student_id\":\"1498 -\"},\"datetime\":\"2025-12-29T09:05:28Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842708225576,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":711215603,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8225576}', 0, NULL, NULL, '2026-04-30 21:56:31'),
(621, 'proxypay', 'synced_payment', '440860989', '842708519691', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1654_43121_1766999667\",\"student_id\":\"1654 -\"},\"datetime\":\"2025-12-29T09:15:55Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":842708519691,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":440860989,\"terminal_id\":\"0000059505\",\"terminal_location\":\"LUANDA\",\"terminal_period_id\":60,\"terminal_transaction_id\":1566,\"terminal_type\":\"ATM\",\"transaction_id\":8519691}', 0, NULL, NULL, '2026-04-30 21:56:32'),
(622, 'proxypay', 'synced_payment', '485544453', '842708524102', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa Classe Complexo e Poli (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4527_40918_1766998240\",\"student_id\":\"4527 -\"},\"datetime\":\"2025-12-29T09:16:05Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842708524102,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":485544453,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8524102}', 0, NULL, NULL, '2026-04-30 21:56:32'),
(623, 'proxypay', 'synced_payment', '217910924', '842708552051', 37296.00, '{\"amount\":\"37296.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1654_41614_1766999639\",\"student_id\":\"1654 -\"},\"datetime\":\"2025-12-29T09:17:05Z\",\"entity_id\":647,\"fee\":\"279.72\",\"id\":842708552051,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":217910924,\"terminal_id\":\"0000059505\",\"terminal_location\":\"LUANDA\",\"terminal_period_id\":60,\"terminal_transaction_id\":1571,\"terminal_type\":\"ATM\",\"transaction_id\":8552051}', 0, NULL, NULL, '2026-04-30 21:56:32'),
(624, 'proxypay', 'synced_payment', '608034761', '842709056706', 60000.00, '{\"amount\":\"60000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 13\\u00aa Classe (est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1316_43108_1767000772\",\"student_id\":\"1316 -\"},\"datetime\":\"2025-12-29T09:34:54Z\",\"entity_id\":647,\"fee\":\"450.00\",\"id\":842709056706,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":608034761,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":9056706}', 0, NULL, NULL, '2026-04-30 21:56:32'),
(625, 'proxypay', 'synced_payment', '944617387', '842709519081', 28348.10, '{\"amount\":\"28348.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"7\\u00aa a 8\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_458_38851_1767001784\",\"student_id\":\"458 -\"},\"datetime\":\"2025-12-29T09:50:57Z\",\"entity_id\":647,\"fee\":\"212.61\",\"id\":842709519081,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":944617387,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":9519081}', 0, NULL, NULL, '2026-04-30 21:56:33'),
(626, 'proxypay', 'synced_payment', '468695443', '842709630991', 26466.00, '{\"amount\":\"26466.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"5\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_457_38845_1767002016\",\"student_id\":\"457 -\"},\"datetime\":\"2025-12-29T09:54:51Z\",\"entity_id\":647,\"fee\":\"198.50\",\"id\":842709630991,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":468695443,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":9630991}', 0, NULL, NULL, '2026-04-30 21:56:33'),
(627, 'proxypay', 'synced_payment', '807887405', '842718310680', 24060.00, '{\"amount\":\"24060.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"5\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4459_40515_1767020175\",\"student_id\":\"4459 -\"},\"datetime\":\"2025-12-29T14:57:49Z\",\"entity_id\":647,\"fee\":\"180.45\",\"id\":842718310680,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":807887405,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":18310680}', 0, NULL, NULL, '2026-04-30 21:56:34'),
(628, 'proxypay', 'synced_payment', '367807237', '842718573788', 20617.00, '{\"amount\":\"20617.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Inicia\\u00e7\\u00e3o a 4\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4460_40520_1767020776\",\"student_id\":\"4460 -\"},\"datetime\":\"2025-12-29T15:07:21Z\",\"entity_id\":647,\"fee\":\"154.63\",\"id\":842718573788,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-29T19:00:00Z\",\"period_id\":8427,\"period_start_datetime\":\"2025-12-28T19:00:00Z\",\"product_id\":1,\"reference_id\":367807237,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":18573788}', 0, NULL, NULL, '2026-04-30 21:56:34'),
(629, 'proxypay', 'synced_payment', '970585328', '842806953072', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4617_41718_1767077702\",\"student_id\":\"4617 -\"},\"datetime\":\"2025-12-30T06:56:38Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842806953072,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":970585328,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":6953072}', 0, NULL, NULL, '2026-04-30 21:56:35'),
(630, 'proxypay', 'synced_payment', '749358434', '842807982349', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2230_40180_1767080115\",\"student_id\":\"2230 -\"},\"datetime\":\"2025-12-30T07:36:02Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842807982349,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":749358434,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":7982349}', 0, NULL, NULL, '2026-04-30 21:56:36'),
(631, 'proxypay', 'synced_payment', '713571240', '842808072261', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3344_40183_1767080290\",\"student_id\":\"3344 -\"},\"datetime\":\"2025-12-30T07:39:12Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":842808072261,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":713571240,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":8072261}', 0, NULL, NULL, '2026-04-30 21:56:36'),
(632, 'proxypay', 'synced_payment', '190948827', '842810084299', 30000.00, '{\"amount\":\"30000.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"Est\\u00e1gio 12\\u00ba Classe (Est\\u00e1gio Sa\\u00fade)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2706_43060_1767083663\",\"student_id\":\"2706 -\"},\"datetime\":\"2025-12-30T08:44:29Z\",\"entity_id\":647,\"fee\":\"225.00\",\"id\":842810084299,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":190948827,\"terminal_id\":\"0000059975\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":56,\"terminal_transaction_id\":892,\"terminal_type\":\"ATM\",\"transaction_id\":10084299}', 0, NULL, NULL, '2026-04-30 21:56:37'),
(633, 'proxypay', 'synced_payment', '927909450', '842810664517', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3267_38054_1767085041\",\"student_id\":\"3267 -\"},\"datetime\":\"2025-12-30T09:02:14Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842810664517,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":927909450,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":10664517}', 0, NULL, NULL, '2026-04-30 21:56:37');
INSERT INTO `payment_events` (`id`, `gateway`, `event_type`, `reference_id`, `transaction_id`, `amount`, `payload`, `processed`, `company_id`, `processed_at`, `created_at`) VALUES
(634, 'proxypay', 'synced_payment', '887145847', '842811581434', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"13\\u00aa Classe Poli (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1089_38028_1767086865\",\"student_id\":\"1089 -\"},\"datetime\":\"2025-12-30T09:29:56Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842811581434,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":887145847,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":11581434}', 0, NULL, NULL, '2026-04-30 21:56:38'),
(635, 'proxypay', 'synced_payment', '867830521', '842813929130', 35245.20, '{\"amount\":\"35245.20\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Novembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3653_37979_1767091002\",\"student_id\":\"3653 -\"},\"datetime\":\"2025-12-30T10:39:50Z\",\"entity_id\":647,\"fee\":\"264.34\",\"id\":842813929130,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":867830521,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":13929130}', 0, NULL, NULL, '2026-04-30 21:56:38'),
(636, 'proxypay', 'synced_payment', '895223835', '842814103733', 32308.10, '{\"amount\":\"32308.10\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3653_37979_1767091348\",\"student_id\":\"3653 -\"},\"datetime\":\"2025-12-30T10:45:00Z\",\"entity_id\":647,\"fee\":\"242.31\",\"id\":842814103733,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":895223835,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":14103733}', 0, NULL, NULL, '2026-04-30 21:56:39'),
(637, 'proxypay', 'synced_payment', '273685277', '842823437164', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_939_37575_1767094268\",\"student_id\":\"939 -\"},\"datetime\":\"2025-12-30T15:38:12Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842823437164,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":273685277,\"terminal_id\":\"0000190501\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":82,\"terminal_transaction_id\":386,\"terminal_type\":\"ATM\",\"transaction_id\":23437164}', 0, NULL, NULL, '2026-04-30 21:56:39'),
(638, 'proxypay', 'synced_payment', '122620136', '842823493119', 29371.00, '{\"amount\":\"29371.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"10\\u00aa a 11\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_4098_37712_1767093777\",\"student_id\":\"4098 -\"},\"datetime\":\"2025-12-30T15:40:06Z\",\"entity_id\":647,\"fee\":\"220.28\",\"id\":842823493119,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":122620136,\"terminal_id\":\"0000190501\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":82,\"terminal_transaction_id\":391,\"terminal_type\":\"ATM\",\"transaction_id\":23493119}', 0, NULL, NULL, '2026-04-30 21:56:40'),
(639, 'proxypay', 'synced_payment', '204634550', '842823753960', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_940_38520_1767094901\",\"student_id\":\"940 -\"},\"datetime\":\"2025-12-30T15:48:53Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842823753960,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":204634550,\"terminal_id\":\"0000190501\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":82,\"terminal_transaction_id\":402,\"terminal_type\":\"ATM\",\"transaction_id\":23753960}', 0, NULL, NULL, '2026-04-30 21:56:40'),
(640, 'proxypay', 'synced_payment', '615789078', '842828785179', 31005.60, '{\"amount\":\"31005.60\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/cassenda.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa Classe (PN)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_3484_20442_1767109706\",\"student_id\":\"3484 -\"},\"datetime\":\"2025-12-30T18:40:04Z\",\"entity_id\":647,\"fee\":\"232.54\",\"id\":842828785179,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-30T19:00:00Z\",\"period_id\":8428,\"period_start_datetime\":\"2025-12-29T19:00:00Z\",\"product_id\":1,\"reference_id\":615789078,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":28785179}', 0, NULL, NULL, '2026-04-30 21:56:41'),
(641, 'proxypay', 'synced_payment', '344717845', '842905683650', 34188.00, '{\"amount\":\"34188.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Dezembro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1603_38674_1767157136\",\"student_id\":\"1603 -\"},\"datetime\":\"2025-12-31T05:47:04Z\",\"entity_id\":647,\"fee\":\"256.41\",\"id\":842905683650,\"parameter_id\":0,\"period_end_datetime\":\"2025-12-31T19:00:00Z\",\"period_id\":8429,\"period_start_datetime\":\"2025-12-30T19:00:00Z\",\"product_id\":1,\"reference_id\":344717845,\"terminal_id\":\"0000550403\",\"terminal_location\":\"Luanda\",\"terminal_period_id\":70,\"terminal_transaction_id\":618,\"terminal_type\":\"ATM\",\"transaction_id\":5683650}', 0, NULL, NULL, '2026-04-30 21:56:41'),
(642, 'proxypay', 'synced_payment', '538445632', '842912150087', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_442_37710_1767174407\",\"student_id\":\"442 -\"},\"datetime\":\"2025-12-31T09:48:01Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842912150087,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-31T19:00:00Z\",\"period_id\":8429,\"period_start_datetime\":\"2025-12-30T19:00:00Z\",\"product_id\":1,\"reference_id\":538445632,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12150087}', 0, NULL, NULL, '2026-04-30 21:56:42'),
(643, 'proxypay', 'synced_payment', '117159163', '842912547186', 25711.00, '{\"amount\":\"25711.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"7\\u00aa a 8\\u00aa Classe (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_2967_36266_1767175166\",\"student_id\":\"2967 -\"},\"datetime\":\"2025-12-31T09:59:53Z\",\"entity_id\":647,\"fee\":\"192.83\",\"id\":842912547186,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-31T19:00:00Z\",\"period_id\":8429,\"period_start_datetime\":\"2025-12-30T19:00:00Z\",\"product_id\":1,\"reference_id\":117159163,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":12547186}', 0, NULL, NULL, '2026-04-30 21:56:43'),
(644, 'proxypay', 'synced_payment', '169976838', '842917636297', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa a 13\\u00aa Classe Sa\\u00fade (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1313_38908_1767183942\",\"student_id\":\"1313 -\"},\"datetime\":\"2025-12-31T12:27:07Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842917636297,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-31T19:00:00Z\",\"period_id\":8429,\"period_start_datetime\":\"2025-12-30T19:00:00Z\",\"product_id\":1,\"reference_id\":169976838,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":17636297}', 0, NULL, NULL, '2026-04-30 21:56:43'),
(645, 'proxypay', 'synced_payment', '444200546', '842921943505', 31080.00, '{\"amount\":\"31080.00\",\"custom_fields\":{\"callback_url\":\"https:\\/\\/kilamba.anuarite.com\\/webhook_direto.php\",\"description\":\"12\\u00aa Classe Complexo e Poli (Janeiro)\",\"fee_type\":\"school_fee\",\"invoice_id\":\"FEE_1310_37828_1767191837\",\"student_id\":\"1310 -\"},\"datetime\":\"2025-12-31T14:44:57Z\",\"entity_id\":647,\"fee\":\"233.10\",\"id\":842921943505,\"parameter_id\":1,\"period_end_datetime\":\"2025-12-31T19:00:00Z\",\"period_id\":8429,\"period_start_datetime\":\"2025-12-30T19:00:00Z\",\"product_id\":1,\"reference_id\":444200546,\"terminal_id\":\"0000000000\",\"terminal_location\":\"Internet\",\"terminal_period_id\":0,\"terminal_transaction_id\":0,\"terminal_type\":\"MB\",\"transaction_id\":21943505}', 0, NULL, NULL, '2026-04-30 21:56:44');

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

--
-- Table structure for table `payment_references`
--

CREATE TABLE `payment_references` (
  `id` bigint(20) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `reference_id` varchar(50) NOT NULL,
  `entity_id` varchar(20) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `plan_id` int(11) DEFAULT NULL,
  `plan_name` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` enum('pending','paid','expired','cancelled') DEFAULT 'pending',
  `end_datetime` datetime DEFAULT NULL,
  `custom_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`custom_fields`)),
  `paid_at` datetime DEFAULT NULL,
  `payment_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_data`)),
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_references`
--

INSERT INTO `payment_references` (`id`, `company_id`, `reference_id`, `entity_id`, `amount`, `plan_id`, `plan_name`, `description`, `status`, `end_datetime`, `custom_fields`, `paid_at`, `payment_data`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 3, '130571709', '647', 2.00, 9, 'Starter', 'Subscrição SANA ERP — Starter', 'pending', '2026-05-30 23:59:59', NULL, NULL, NULL, 3, '2026-04-30 21:26:46', '2026-04-30 21:26:46'),
(2, 3, '828649182', '647', 2.00, 9, 'Starter', 'Subscrição SANA ERP — Starter', 'pending', '2026-05-30 23:59:59', NULL, NULL, NULL, 3, '2026-04-30 21:41:28', '2026-04-30 21:41:28'),
(3, 3, '414324591', '647', 2.00, 9, 'Starter', 'Subscrição SANA ERP — Starter', 'pending', '2026-05-30 23:59:59', NULL, NULL, NULL, 3, '2026-04-30 21:50:22', '2026-04-30 21:50:22');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `permissions`, `created_at`) VALUES
(1, 'Administrador', 'Acesso total ao sistema', '{\"all\": true}', '2026-04-15 14:40:20'),
(2, 'Gestor Financeiro', 'Gestão de contas e relatórios', '{\"finance\": true, \"reports\": true}', '2026-04-15 14:40:20'),
(3, 'RH', 'Gestão de pessoal e salários', '{\"rh\": true}', '2026-04-15 14:40:20');

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

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `max_users` int(11) DEFAULT 0,
  `max_employees` int(11) DEFAULT 0,
  `price` decimal(15,2) DEFAULT 0.00,
  `validity_days` int(11) DEFAULT 30,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `description` text DEFAULT NULL,
  `modules` text DEFAULT NULL,
  `is_recommended` tinyint(1) DEFAULT 0,
  `modules_enabled` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`modules_enabled`)),
  `is_unlimited` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` (`id`, `name`, `max_users`, `max_employees`, `price`, `validity_days`, `created_at`, `description`, `modules`, `is_recommended`, `modules_enabled`, `is_unlimited`) VALUES
(9, 'Starter', 1, 1, 2.00, 30, '2026-04-17 11:33:50', 'Ideal para pequenas empresas que estão a iniciar a digitalização SAP.', '[\"hr\"]', 0, '[\"hr\",\"finance\",\"accounting\",\"reports\",\"ai\"]', 0),
(10, 'Gold Global', 2, 10, 250000.00, 30, '2026-04-17 11:33:50', 'Controlo total para empresas em expansão regional e suporte prioritário.', '[\"hr\"]', 1, '[\"hr\"]', 0),
(11, 'Platinum Unlimit', 0, 0, 300000.00, 30, '2026-04-17 11:33:50', 'Poder ilimitado para grandes grupos económicos e infra dedicada.', 'Acesso Total + Consultoria', 0, '[]', 0),
(13, 'Teste', 1, 10, 0.00, 15, '2026-04-19 01:29:10', NULL, '[\"hr\",\"polos\"]', 0, '[\"hr\",\"polos\"]', 0);

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

--
-- Table structure for table `support_manuals`
--

CREATE TABLE `support_manuals` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `file_size` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT 'PDF',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_manuals`
--

INSERT INTO `support_manuals` (`id`, `title`, `description`, `content`, `file_path`, `file_size`, `type`, `created_at`) VALUES
(1, 'Guia de Primeiro Acesso', 'Configuração inicial da empresa.', '# Guia de Primeiro Acesso\n\nBem-vindo ao SANA ERP. Siga estes passos para configurar a sua empresa...', 'uploads/support/manual_acesso.pdf', '2.4 MB', 'PDF', '2026-04-30 00:04:55'),
(2, 'Segurança e Dados', 'Protocolos de privacidade.', '# Segurança e Dados\n\nA sua segurança é a nossa prioridade...', 'uploads/support/seguranca.pdf', '1.8 MB', 'PDF', '2026-04-30 00:04:55');
INSERT INTO `support_manuals` (`id`, `title`, `description`, `content`, `file_path`, `file_size`, `type`, `created_at`) VALUES
(4, 'Cadastrar Colaborador', NULL, '<p>Conteudo para teste <a href=\"app/rh/colaboradores\" target=\"_blank\">Clique</a> aqui para continuar a acessar<img src=\"data:image/jpeg;base64,[encoded data, 261044 characters]\"></p><p><br></p><p>Asset: A financial item that has value reflected in the SAP Asset module, generally as a depreciating financial asset. A fixed asset is a tangible item that has value reflected in the financial system.</p><p>ATP: Available To Promise is the quantity still available to MRP for new sales orders and is calculated from the warehouse stock. Material Availability and the Lead Time are used to calculate ATP.</p><p>ATR: Acquire To Retire is a end-to-end process that represents the lifecycle of a piece of equipment from birth to retirement.</p><p>AWS: Adherence to Work Schedules is a metric used to provide a visual representation of the work-life balance of field employees.</p><p>Balance (FI): An amount resulting from the difference between the debit and credit side of an account or document. There are the following types of balances: Credit balance and Debit balance.</p><p>Balance Sheet Adjustment (FI): A retroactive assignment of receivables, payables, and taxes to business areas or profit centers (or both). Typically, this assignment is required in situations where the corresponding fields for account assignment were not specified when posting the original document. An account assignment may be missing because the user was not able to specify just one account assignment for a particular item in an invoice. This would make it necessary to create several items out of this item (to be avoided where possible). Balance sheet adjustment is made at a specific key date during closing operations.</p><p>Bar Code: Standardized characters of a symbol made up of a group of lines and spaces that can be recognized by an optical scanner. Bar codes uniquely identify article data, production numbers or transport units, for example. They can also contain additional information such as batch number, expiration date or weight. Basin: Represent the engine for our future growth and enable our corporate strategy. The five Basins are: Americas Land, Offshore Atlantic, Russia and Central Asia, Asia, and Middle East &amp; North Africa. Batch Number: Is a subset of Material in inventory. Cable is batched managed in SAP.</p><p>BCoE: Billing Center of Excellence. This is one of Schlumberger’s work groups.</p><p>BDV: Business Data Validation.</p><p>BI: Business Intelligence consolidate processes and tools used to collect and analyze raw data in a way that supports more informed business decisions.</p><p>Black Out: Legacy and/or new systems are unavailable as data and transactions are loaded. Transfer/validate open transactions from current systems to SAP.</p><p>Blackline: The BlackLine Reconciliation Management Solution standardizes and automates all types of reconciliations, including general ledger and balance sheet account, bank, credit card, cash, inventory, investment, or any other type of reconciliation. Streamlining the reconciliation process prevents material</p>', NULL, NULL, 'PDF', '2026-04-30 18:43:16');

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

--
