INSERT INTO `finance_h_accurate_integration_logs` (`id`, `event_source`, `po_id`, `po_number`, `user_id`, `user_name`, `message`, `stack_trace`, `created_at`, `updated_at`) VALUES
(365, 'validasi_realisasi_sampling', 48766, '313.Q-DSR-P.III.2026', 363, 'Savira Ramadhanti', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48766)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-25 09:50:37', '2026-03-25 09:50:37'),
(366, 'validasi_sampel_dikirim', 48671, '35.GMP/MW.MRFR-P.III.2026', 87, 'Khuswatun Khasanah', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/SampelKirimController.php(289): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48671)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\SampelKirimController->update(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\SampelKirimController), \'update\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/laravel/frame', '2026-03-26 02:41:03', '2026-03-26 02:41:03'),
(367, 'validasi_realisasi_sampling', 48741, '424.Q-NDS-P.III.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48741)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 06:24:20', '2026-03-26 06:24:20'),
(368, 'validasi_realisasi_sampling', 48782, '347.Q-ZR-P.III.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48782)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 06:27:47', '2026-03-26 06:27:47'),
(369, 'validasi_realisasi_sampling', 48769, '427.Q-NDS-P.III.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48769)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 06:28:22', '2026-03-26 06:28:22'),
(370, 'validasi_realisasi_sampling', 48388, '225.GMP.MRV-P.III.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Customer Accurate untuk PT APERINDO PRIMA MANDIRI tidak ditemukan.', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(37): App\\Services\\AccurateSalesOrderIntegrationService->resolveCustomerNo(Object(stdClass))\n#1 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48388)\n#2 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#7 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#19 /home/persadal/group_app/jadwals', '2026-03-26 06:36:26', '2026-03-26 06:36:26'),
(371, 'validasi_realisasi_sampling', 48658, '250.GMP.MRV-P.III.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48658)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 06:36:43', '2026-03-26 06:36:43'),
(372, 'validasi_realisasi_sampling', 48726, '252.GMP.MRV-P.III.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48726)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 07:10:31', '2026-03-26 07:10:31'),
(373, 'validasi_sampel_dikirim', 48857, '355.Q-ZR-P.III.2026', 87, 'Khuswatun Khasanah', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/SampelKirimController.php(289): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48857)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\SampelKirimController->update(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\SampelKirimController), \'update\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/laravel/frame', '2026-03-26 07:14:29', '2026-03-26 07:14:29'),
(374, 'validasi_realisasi_sampling', 48647, '296.Q-DSR-P.III.2026', 363, 'Savira Ramadhanti', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48647)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 08:36:38', '2026-03-26 08:36:38'),
(375, 'validasi_realisasi_sampling', 47634, '192.Q-DSR-P.II.2026', 363, 'Savira Ramadhanti', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(47634)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 08:37:00', '2026-03-26 08:37:00');
INSERT INTO `finance_h_accurate_integration_logs` (`id`, `event_source`, `po_id`, `po_number`, `user_id`, `user_name`, `message`, `stack_trace`, `created_at`, `updated_at`) VALUES
(376, 'validasi_realisasi_sampling', 48595, '132.Q-NTR-P.III.2026', 115, 'Seli Tamara', 'FAILED | Accurate sales-order/detail.do gagal. Response: {\"s\":\"false\"}', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(1002): App\\Services\\AccurateSalesOrderIntegrationService->assertAccurateResponseSuccessful(\'sales-order/det...\', Array)\n#1 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(38): App\\Services\\AccurateSalesOrderIntegrationService->post(\'sales-order/det...\', Array)\n#2 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(1955): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(48595)\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#7 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#19 /home/persadal/group_app/jadwalsampling/vendor/', '2026-03-26 09:54:25', '2026-03-26 09:54:25'),
(377, 'validasi_sampel_dikirim', 48898, '447.Q-NDS-P.III.2026', 87, 'Khuswatun Khasanah', 'SUCCESS | {\"s\":true,\"d\":[\"Pesanan Penjualan \\\"447.Q-NDS-P.III.2026\\\" berhasil disimpan\"]}', NULL, '2026-03-27 05:09:37', '2026-03-27 05:09:37'),
(378, 'validasi_realisasi_sampling', 46720, '75.GMP.MRV-P.I.2026', 192, 'Caesar Rasendria Achmad', 'FAILED | Customer Accurate untuk PT SINERGI GULA NUSANTARA PG SEMBORO tidak ditemukan.', '#0 /home/persadal/group_app/jadwalsampling/app/Services/AccurateSalesOrderIntegrationService.php(37): App\\Services\\AccurateSalesOrderIntegrationService->resolveCustomerNo(Object(stdClass))\n#1 /home/persadal/group_app/jadwalsampling/app/Http/Controllers/DashboardController.php(2029): App\\Services\\AccurateSalesOrderIntegrationService->syncByPoId(46720)\n#2 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\\Http\\Controllers\\DashboardController->selesaiSampling(Object(Illuminate\\Http\\Request))\n#3 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\DashboardController), \'selesaiSampling\')\n#4 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\\Routing\\Route->runController()\n#5 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()\n#6 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#7 /home/persadal/group_app/jadwalsampling/app/Http/Middleware/UserAuth.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#8 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\UserAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#9 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#10 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#11 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#12 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#13 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#14 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#15 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#16 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))\n#17 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#18 /home/persadal/group_app/jadwalsampling/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#19 /home/persadal/group_app/jadwals', '2026-03-27 06:17:53', '2026-03-27 06:17:53');

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

--
-- Struktur dari tabel `finance_h_budget_logs`
--

CREATE TABLE `finance_h_budget_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `company_id` int UNSIGNED DEFAULT NULL,
  `branch_id` int UNSIGNED DEFAULT NULL,
  `department_id` int UNSIGNED DEFAULT NULL,
  `coa_id` int UNSIGNED DEFAULT NULL,
  `period_year` int UNSIGNED DEFAULT NULL,
  `period_month` int UNSIGNED DEFAULT NULL,
  `allocated_amount` decimal(18,2) UNSIGNED DEFAULT '0.00',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `finance_m_banks`
--

CREATE TABLE `finance_m_banks` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `finance_m_banks`
--

INSERT INTO `finance_m_banks` (`id`, `uuid`, `name`, `code`, `created_at`, `updated_at`, `deleted_at`, `updated_ip`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, NULL, 'Bank BRI', '002', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(2, NULL, 'Bank Mandiri', '008', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(3, NULL, 'Bank BNI', '009', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(4, NULL, 'Bank BCA', '014', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(5, NULL, 'Bank Danamon', '011', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(6, NULL, 'Bank Permata', '013', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(7, NULL, 'Bank Panin', '019', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(8, NULL, 'Bank CIMB Niaga', '022', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(9, NULL, 'Bank UOB Indonesia', '023', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(10, NULL, 'Bank OCBC NISP', '028', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(11, NULL, 'Bank Artha Graha Internasional', '037', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(12, NULL, 'Bank JTrust Indonesia', '095', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(13, NULL, 'Bank Maybank Indonesia', '016', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(14, NULL, 'Bank Mega', '426', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(15, NULL, 'Bank Bukopin', '441', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(16, NULL, 'Bank BTPN', '213', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(17, NULL, 'Bank Sinarmas', '153', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(18, NULL, 'Bank Commonwealth', '950', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(19, NULL, 'Bank HSBC Indonesia', '041', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(20, NULL, 'Bank BRI Agroniaga', '494', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(21, NULL, 'Bank Mestika Dharma', '151', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(22, NULL, 'Bank Syariah Indonesia (BSI)', '451', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(23, NULL, 'Bank Muamalat Indonesia', '147', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(24, NULL, 'Bank Victoria International', '566', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(25, NULL, 'Bank Neo Commerce', '490', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(26, NULL, 'Bank Jago', '542', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(27, NULL, 'Bank KB Bukopin Syariah', '521', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(28, NULL, 'Bank BCA Syariah', '536', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(29, NULL, 'Bank Mandiri Taspen', '564', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(30, NULL, 'Bank QNB Indonesia', '167', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(31, NULL, 'Bank Capital Indonesia', '054', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(32, NULL, 'Bank DBS Indonesia', '046', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(33, NULL, 'Bank Woori Saudara', '212', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(34, NULL, 'Bank Mayapada Internasional', '097', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(35, NULL, 'Bank Ina Perdana', '513', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(36, NULL, 'Bank MNC Internasional', '485', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(37, NULL, 'Bank BJB Syariah', '425', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(38, NULL, 'Bank Aceh', '116', '2026-01-12 03:20:40', '2026-04-08 06:38:52', NULL, NULL, NULL, NULL, NULL),
(39, NULL, 'Bank Aceh Syariah', '116', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(40, NULL, 'Bank Sumut', '117', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(41, NULL, 'Bank Sumut Syariah', '117', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(42, NULL, 'Bank Nagari', '118', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(43, NULL, 'Bank Nagari Syariah', '118', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(44, NULL, 'Bank Riau Kepri', '119', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(45, NULL, 'Bank Riau Kepri Syariah', '119', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(46, NULL, 'Bank Jambi', '115', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(47, NULL, 'Bank Jambi Syariah', '115', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(48, NULL, 'Bank Bengkulu', '133', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(49, NULL, 'Bank Bengkulu Syariah', '133', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(50, NULL, 'Bank Sumsel Babel', '120', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(51, NULL, 'Bank Sumsel Babel Syariah', '120', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(52, NULL, 'Bank DKI', '111', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(53, NULL, 'Bank DKI Syariah', '111', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(54, NULL, 'Bank BJB', '110', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(55, NULL, 'Bank BPD DIY', '112', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(56, NULL, 'Bank BPD DIY Syariah', '112', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(57, NULL, 'Bank Jateng', '113', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(58, NULL, 'Bank Jateng Syariah', '113', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(59, NULL, 'Bank Jatim', '114', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(60, NULL, 'Bank Jatim Syariah', '114', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(61, NULL, 'Bank Kalbar', '123', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(62, NULL, 'Bank Kalbar Syariah', '123', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(63, NULL, 'Bank Kalteng', '125', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(64, NULL, 'Bank Kalteng Syariah', '125', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(65, NULL, 'Bank Kaltimtara', '124', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(66, NULL, 'Bank Kaltimtara Syariah', '124', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(67, NULL, 'Bank Kalsel', '122', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(68, NULL, 'Bank Kalsel Syariah', '122', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(69, NULL, 'Bank Sulselbar', '126', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(70, NULL, 'Bank Sultra', '135', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(71, NULL, 'Bank Sultra Syariah', '135', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(72, NULL, 'Bank SulutGo', '127', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(73, NULL, 'Bank SulutGo Syariah', '127', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(74, NULL, 'Bank NTB Syariah', '128', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(75, NULL, 'Bank NTT', '130', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(76, NULL, 'Bank Maluku Malut', '131', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(77, NULL, 'Bank Papua', '132', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(78, NULL, 'Bank Lampung', '121', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(79, NULL, 'Bank Sulteng', '134', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(80, NULL, 'Bank Sulteng Syariah', '134', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(81, NULL, 'Bank Sahabat Sampoerna', '523', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(82, NULL, 'Bank Amar Indonesia', '531', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(83, NULL, 'Bank Index Selindo', '555', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(84, NULL, 'Bank Ganesha', '161', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(85, NULL, 'Bank Oke Indonesia', '526', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(86, NULL, 'Bank Nationalnobu (Nobu Bank)', '503', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(87, NULL, 'Bank Mayora', '553', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(88, NULL, 'Bank Victoria Syariah', '405', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(89, NULL, 'Bank Mitraniaga', '491', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(90, NULL, 'Bank Harda Internasional', '567', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(91, NULL, 'Bank of America', '033', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(92, NULL, 'Bank of China', '069', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(93, NULL, 'Bank ANZ Indonesia', '061', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(94, NULL, 'Bank Citibank', '031', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(95, NULL, 'Bank Standard Chartered', '050', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(96, NULL, 'Bank Deutsche Bank', '067', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(97, NULL, 'Bank JP Morgan Chase', '032', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(98, NULL, 'Bank Resona Perdania', '047', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(99, NULL, 'Bank Shinhan Indonesia', '152', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(100, NULL, 'Bank KEB Hana Indonesia', '484', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(101, NULL, 'Bank Sumitomo Mitsui Indonesia', '045', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(102, NULL, 'Bank Mizuho Indonesia', '048', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(103, NULL, 'Bank MUFG (MUFG Bank)', '042', '2026-01-12 03:20:40', '2026-01-12 03:20:40', NULL, NULL, NULL, NULL, NULL),
(104, NULL, 'Smoke Test Bank Updated', 'SMOKE-20260408124100-U', '2026-04-08 05:41:00', '2026-04-08 05:41:00', '2026-04-08 05:41:00', NULL, NULL, NULL, NULL),
(105, NULL, 'bank coba', '1234', '2026-04-08 06:39:12', '2026-04-08 06:46:50', '2026-04-08 06:46:50', NULL, NULL, NULL, NULL);

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

--
-- Struktur dari tabel `finance_m_budgets`
--

CREATE TABLE `finance_m_budgets` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `company_id` int UNSIGNED DEFAULT NULL,
  `branch_id` int UNSIGNED DEFAULT NULL,
  `department_id` int UNSIGNED DEFAULT NULL,
  `coa_id` int UNSIGNED DEFAULT NULL,
  `source_account_id` int UNSIGNED DEFAULT NULL,
  `period_year` int UNSIGNED DEFAULT NULL,
  `period_month` int UNSIGNED DEFAULT NULL,
  `allocated_amount` decimal(18,2) UNSIGNED DEFAULT '0.00',
  `used_amount` decimal(13,2) UNSIGNED DEFAULT '0.00',
  `is_active` tinyint(1) DEFAULT '1',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `finance_m_budgets`
--

INSERT INTO `finance_m_budgets` (`id`, `uuid`, `name`, `description`, `company_id`, `branch_id`, `department_id`, `coa_id`, `source_account_id`, `period_year`, `period_month`, `allocated_amount`, `used_amount`, `is_active`, `start_date`, `end_date`, `created_by`, `updated_by`, `deleted_by`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'Budget ITsa', 'desc 1', 1, 1, 2, 7, 1, 2026, 1, 1500000.00, 0.00, 1, '2025-11-30', '2025-12-30', 1, 1, NULL, '127.0.0.1', '2025-11-16 22:26:51', '2026-01-04 04:52:48', NULL),
(2, NULL, 'Budget Operasional', NULL, 1, 1, 1, 3, 1, 2026, 1, 20000000.00, 0.00, 1, '2026-01-01', '2026-01-31', 1, 1, NULL, '127.0.0.1', '2026-01-11 12:38:56', '2026-01-12 10:26:49', NULL),
(3, NULL, 'Budget Operation Januari', NULL, 1, 1, 1, 3, 1, 2026, 1, 20000000.00, 0.00, 1, '2026-01-01', '2026-01-31', 1, 1, NULL, '127.0.0.1', '2026-01-11 12:40:32', '2026-01-11 12:40:32', NULL),
(4, NULL, 'budget cobas', 'asd', 1, 1, 7, 403, 2, 2026, NULL, 1230000.00, 0.00, 1, '2026-04-09', '2026-04-30', NULL, NULL, NULL, NULL, '2026-04-08 23:12:36', '2026-04-08 23:34:08', '2026-04-08 23:34:08');

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

--
-- Struktur dari tabel `finance_m_chart_of_accounts`
--

CREATE TABLE `finance_m_chart_of_accounts` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` enum('asset','liability','equity','revenue','expense') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parent_id` bigint UNSIGNED DEFAULT NULL,
  `normal_balance` enum('debit','credit') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_active` tinyint(1) DEFAULT '1',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `finance_m_chart_of_accounts`
--

INSERT INTO `finance_m_chart_of_accounts` (`id`, `uuid`, `code`, `name`, `type`, `parent_id`, `normal_balance`, `description`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, '1101', 'KAS', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(2, NULL, '110101', 'Kas Kecil - HO', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(3, NULL, '110102', 'Kas Kecil - Bank BCA Syariah (Mojokerto) Rek. 0625455555', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(4, NULL, '110103', 'Kas Kecil - Bank BCA Syariah (Semarang) Rek. 0625555800', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(5, NULL, '110104', 'Kas Kecil - Bank BCA Syariah (Depok) Rek. 0625555123', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(6, NULL, '110105', 'Kas Operasional - Direksi', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(7, NULL, '110106', 'Kas Operasional - Office', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(8, NULL, '1102', 'BANK - IDR', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(9, NULL, '110201', 'Bank IDR - BCA Syariah Rek. 0625555545', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(10, NULL, '110202', 'Bank IDR - BRI Rek. 5501001075300', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(11, NULL, '110203', 'Bank IDR - Jatim Rek. 0821001901', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(12, NULL, '110204', 'Bank IDR - BMT a.n SUTRI UMAROH Rek. 2060000617', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(13, NULL, '110205', 'Bank IDR - BSI a.n SITI UMAROH Rek. 7189269158', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(14, NULL, '110206', 'Bank IDR - BCA a.n KINANAH Rek. 6140750482', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(15, NULL, '110207', 'Bank IDR - BRI (OP) a.n ALFY SURURI Rek. 320201038891531', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(16, NULL, '110208', 'Bank IDR - BCA a.n Graha Mutu Persada PT 0508309999', 'asset', 8, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(17, NULL, '11021', 'INVESTASI EMAS', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(18, NULL, '1102101', 'Tabungan Emas', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(19, NULL, '1102302', 'Investasi Saham - PT Labtek Prima Indonesia', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(20, NULL, '1103', 'PIUTANG USAHA', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(21, NULL, '110301', 'Piutang Usaha', 'asset', 20, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(22, NULL, '110302', 'Piutang Usaha - Suspend', 'asset', 20, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(23, NULL, '1104', 'PIUTANG LAIN-LAIN - BERELASI', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(24, NULL, '110401', 'Piutang Berelasi - Direksi', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(25, NULL, '110402', 'Piutang Berelasi - Karyawan', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(26, NULL, '110403', 'Piutang Berelasi - PT Solusi Kerja Nusantara', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(27, NULL, '110404', 'Piutang Berelasi - PT Eco Persada Laboratory', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(28, NULL, '110405', 'Piutang Berelasi - PT Sentra Alam Persada', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(29, NULL, '110406', 'Piutang Berelasi - PT Quality Supply Management', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(30, NULL, '110407', 'Piutang Berelasi - PT Labtek Prima Indonesia', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(31, NULL, '110408', 'Piutang Berelasi - PT Graha Nusantara Investama', 'asset', 23, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(32, NULL, '11041', 'Cadangan Kerugian Piutang', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(33, NULL, '11042', 'UANG MUKA PEMBELIAN', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(34, NULL, '1104201', 'Uang Muka Pembelian', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(35, NULL, '1105', 'PERSEDIAAN', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(36, NULL, '110501', 'Persediaan Baku - Bahan Kima', 'asset', 35, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(37, NULL, '110502', 'Persediaan Baku - Barang Habis Pakai', 'asset', 35, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(38, NULL, '110503', 'Pekerjaan Dalam Proses', 'asset', 35, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(39, NULL, '110504', 'Persediaan - Dalam Perjalanan', 'asset', 35, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(40, NULL, '1106', 'UANG MUKA', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(41, NULL, '110601', 'Uang Muka Keperluan Dinas - Teknis', 'asset', 40, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(42, NULL, '110602', 'Uang Muka Keperluan Dinas - Non Teknis', 'asset', 40, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(43, NULL, '110603', 'Uang Muka Pembelian Aset', 'asset', 40, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(44, NULL, '11061', 'Uang Muka Pembelian Barang & Jasa', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(45, NULL, '11062', 'Uang Muka Investasi', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(46, NULL, '11063', 'Transaksi Aset Tetap', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(47, NULL, '1107', 'BIAYA DIBAYAR DIMUKA', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(48, NULL, '110701', 'Biaya Dibayar Dimuka - Sewa Kendaraan', 'asset', 47, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(49, NULL, '110702', 'Biaya Dibayar Dimuka - Sewa Bangunan', 'asset', 47, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(50, NULL, '110703', 'Biaya Dibayar Dimuka - Asuransi', 'asset', 47, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(51, NULL, '110704', 'Biaya Dibayar Dimuka - Deposit', 'asset', 47, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(52, NULL, '1108', 'PAJAK DIBAYAR DIMUKA', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(53, NULL, '110801', 'Pajak Dibayar Dimuka - PPN Masukan', 'asset', 52, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(54, NULL, '110802', 'Pajak Dibayar Dimuka - PPh 21', 'asset', 52, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(55, NULL, '110803', 'Pajak Dibayar Dimuka - PPh 22', 'asset', 52, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(56, NULL, '110804', 'Pajak Dibayar Dimuka - PPh 23', 'asset', 52, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(57, NULL, '110805', 'Pajak Dibayar Dimuka - PPh 25', 'asset', 52, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(58, NULL, '110806', 'Pajak Dibayar Dimuka - PPh Ps 4 (2)', 'asset', 52, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(59, NULL, '1210', 'NILAI PEROLEHAN - ASET TETAP', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(60, NULL, '121001', 'Nilai Perolehan - Tanah', 'asset', 59, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(61, NULL, '121002', 'Nilai Perolehan - Bangunan & Instalasi', 'asset', 59, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(62, NULL, '121003', 'Nilai Perolehan - Mesin', 'asset', 59, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(63, NULL, '121004', 'Nilai Perolehan - Peralatan Teknis', 'asset', 59, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(64, NULL, '121005', 'Nilai Perolehan - Peralatan Kantor', 'asset', 59, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(65, NULL, '121006', 'Nilai Perolehan - Kendaraan', 'asset', 59, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(66, NULL, '1220', 'AKUMULASI PENYUSUTAN', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(67, NULL, '122001', 'Akumulasi Penyusutan - Bangunan & Instalasi', 'asset', 66, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(68, NULL, '122002', 'Akumulasi Penyusutan - Mesin', 'asset', 66, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(69, NULL, '122003', 'Akumulasi Penyusutan - Peralatan Teknis', 'asset', 66, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(70, NULL, '122004', 'Akumulasi Penyusutan - Peralatan Kantor', 'asset', 66, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(71, NULL, '122005', 'Akumulasi Penyusutan - Kendaraan', 'asset', 66, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(72, NULL, '1300', 'ASET TIDAK LANCAR LAINNYA', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(73, NULL, '130001', 'Aset Lancar Lainnya - Proyek Dalam Penyelesaian', 'asset', 72, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(74, NULL, '130002', 'Aset Lancar Lainnya - Penyertaan Saham', 'asset', 72, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(75, NULL, '130003', 'Aset Lancar Lainnya - Bank Garansi', 'asset', 72, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(76, NULL, '1400', 'ASET TIDAK BERWUJUD', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(77, NULL, '140001', 'Aset Tidak Berwujud - Hak Merek', 'asset', 76, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(78, NULL, '140002', 'Aset Tidak Berwujud - Hak Cipta', 'asset', 76, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(79, NULL, '140003', 'Aset Tidak Berwujud - Good Will', 'asset', 76, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(80, NULL, '140004', 'Aset Tidak Berwujud - Hak & Lisensi', 'asset', 76, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(81, NULL, '140005', 'Aset Tidak Berwujud - Perangkat Lunak (Software)', 'asset', 76, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(82, NULL, '2110', 'UTANG USAHA', 'liability', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(83, NULL, '211001', 'Utang Usaha - Bahan Baku', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(84, NULL, '211002', 'Utang Usaha - Perlengkapan', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(85, NULL, '211003', 'Utang Usaha - Subkon', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(86, NULL, '211004', 'Utang Usaha - Pembelian Aset Tetap', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(87, NULL, '211005', 'Utang Usaha - Sewa Peralatan', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(88, NULL, '211006', 'Utang Usaha - Kalibrasi Peralatan', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(89, NULL, '211007', 'Utang Usaha - Keperluan Umum', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(90, NULL, '211008', 'Utang Usaha - Ekspedisi', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(91, NULL, '211009', 'Utang Usaha - Pembiayaan Pihak Ketiga / Murabahah', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(92, NULL, '211010', 'Utang Usaha - Pembiayaan Pihak Ketiga / Mudharabah', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(93, NULL, '211011', 'Utang Jk Panjang - Pembiayaan Pihak Ketiga / Musyarakah', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(94, NULL, '211012', 'Utang Jk Panjang - Investasi Pihak Ketiga / Syirkah', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(95, NULL, '211013', 'Utang Jk Panjang - Investasi Pihak Ketiga / Syirkah', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(96, NULL, '211014', 'Utang Usaha - Pihak Berelasi PT Graha Nusantara Investama', 'liability', 82, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(97, NULL, '2120', 'BIAYA YANG MASIH HARUS DIBAYAR', 'liability', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(98, NULL, '212001', 'Biaya Yg Masih Harus Dibayar - Komisi Penjualan', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(99, NULL, '212002', 'Biaya Yg Masih Harus Dibayar - Gaji/Upah/Lembur', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(100, NULL, '212003', 'Biaya Yg Masih Harus Dibayar - Bonus/THR', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(101, NULL, '212004', 'Biaya Yg Masih Harus Dibayar - BPJS Kes', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(102, NULL, '212005', 'Biaya Yg Masih Harus Dibayar - BPJS TK', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(103, NULL, '212006', 'Biaya Yg Masih Harus Dibayar - Listrik/Air', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(104, NULL, '212007', 'Biaya Yg Masih Harus Dibayar - Bagi Hasil', 'liability', 97, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(105, NULL, '2130', 'UTANG PAJAK', 'liability', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(106, NULL, '213001', 'Utang Pajak - PPN Keluaran', 'liability', 105, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(107, NULL, '213002', 'Utang Pajak - PPh 21/26', 'liability', 105, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(108, NULL, '213003', 'Utang Pajak - PPh 23/26', 'liability', 105, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(109, NULL, '213004', 'Utang Pajak - PPh 29', 'liability', 105, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(110, NULL, '213005', 'Utang Pajak - PPh Ps 4 (2)', 'liability', 105, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(111, NULL, '213006', 'Utang Pajak - PPh 25', 'liability', 105, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(112, NULL, '2140', 'UTANG BELUM DITAGIH', 'liability', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(113, NULL, '214001', 'Utang Pembelian Belum Ditagih', 'liability', 112, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(114, NULL, '2150', 'UANG MUKA PENJUALAN', 'liability', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(115, NULL, '215001', 'Uang Muka Penjualan', 'liability', 114, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(116, NULL, '2200', 'UTANG JANGKA PANJANG', 'liability', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(117, NULL, '220001', 'Utang Jk Panjang - Pinjaman Bank', 'liability', 116, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(118, NULL, '3001', 'MODAL', 'equity', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(119, NULL, '300101', 'Modal Disetor - Tn Lutfi Hakim', 'equity', 118, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(120, NULL, '300102', 'Modal Disetor - Ny. Mahmudah', 'equity', 118, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(121, NULL, '300103', 'Modal Disetor - Ny. Izun Nisa', 'equity', 118, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(122, NULL, '300104', 'Modal Disetor - Tn. Muadz Abdullah Hammam', 'equity', 118, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(123, NULL, '3002', 'Dividen', 'equity', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(124, NULL, '3003', 'LABA', 'equity', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(125, NULL, '300301', 'Laba Ditahan', 'equity', 124, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(126, NULL, '300302', 'Laba Tahun Berjalan', 'equity', 124, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(127, NULL, '300303', 'Opening Balance Equity', 'equity', 124, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(128, NULL, '4001', 'PENDAPATAN USAHA', 'revenue', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(129, NULL, '400101', 'Penjualan Inhouse', 'revenue', 128, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(130, NULL, '400102', 'Penjualan Subcont', 'revenue', 128, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(131, NULL, '400103', 'Penjualan Akomodasi', 'revenue', 128, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(132, NULL, '4002', 'POTONGAN PENDAPATAN', 'revenue', NULL, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(133, NULL, '400201', 'Potongan Penjualan - Inhouse', 'revenue', 132, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(134, NULL, '400202', 'Potongan - Penjualan Subcont', 'revenue', 132, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(135, NULL, '400203', 'Retur Penjualan', 'revenue', 132, 'credit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(136, NULL, '5000', 'BEBAN POKOK PENJUALAN', 'expense', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(137, NULL, '5001', 'BIAYA BAHAN BAKU LANGSUNG', 'expense', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(138, NULL, '500101', 'Biaya Bahan Baku - Kimia', 'expense', 137, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(139, NULL, '500102', 'Biaya Bahan Baku - Habis Pakai', 'expense', 137, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(140, NULL, '500103', 'Biaya Subcont Pihak Ketiga', 'expense', 137, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(141, NULL, '500104', 'Biaya Bahan Baku - Selisih Stock Opname', 'expense', 137, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(142, NULL, '5002', 'BIAYA TENAGA KERJA LANGSUNG', 'expense', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(143, NULL, '500201', 'BTKL - Gaji/Upah', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(144, NULL, '500202', 'BTKL - Thr/Bonus', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(145, NULL, '500203', 'BTKL - Lembur', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(146, NULL, '500204', 'BTKL - Tunjangan Jabatan', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(147, NULL, '500205', 'BTKL - PPh Pasal 21', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(148, NULL, '500206', 'BTKL - Tunj. Transport', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(149, NULL, '500207', 'BTKL - Penggantian Pengobatan', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(150, NULL, '500208', 'BTKL - Tunj. Uang Makan', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(151, NULL, '500209', 'BTKL - Tunj. Sampling', 'expense', 142, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(152, NULL, '5003', 'HPP Pengujian', 'expense', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(153, NULL, '500301', 'BTKL - Natura - Seragam', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(154, NULL, '500302', 'BTKL - Natura - Latihan & Pendidikan', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(155, NULL, '500303', 'BTKL - Natura - Gathering', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(156, NULL, '500304', 'BTKL - Natura - Klinik/MCU', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(157, NULL, '500305', 'BTKL - Natura - Catering', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(158, NULL, '500306', 'BTKL - Natura - BPJS TK JKK, JKM', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(159, NULL, '500307', 'BTKL - Natura - BPJS Kesehatan', 'expense', 152, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(160, NULL, '5004', 'HPP Biaya Lain-Lain Pengujian', 'expense', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(161, NULL, '500401', 'BTKL - Beban Tenaga Outsourshing/Magang', 'expense', 160, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(162, NULL, '5005', 'BIAYA OVERHEAD', 'expense', NULL, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(163, NULL, '500501', 'Biaya Tidak Langsung Tenaga Kerja', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(164, NULL, '50050101', 'BTL - TK - Gaji/Upah', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(165, NULL, '50050102', 'BTL - TK - Thr/Bonus', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(166, NULL, '50050104', 'BTL - TK - Tunjangan Jabatan', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(167, NULL, '50050105', 'BTL - TK - PPh Pasal 21', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(168, NULL, '50050106', 'BTL - TK - Tunj. Transport', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(169, NULL, '50050107', 'BTL - TK - Penggantian Pengobatan', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(170, NULL, '50050108', 'BTL - TK - Tunj. Uang Makan', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(171, NULL, '50050109', 'BTL - TK - Natura - Seragam', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(172, NULL, '50050110', 'BTL - TK - Natura - Latihan & Pendidikan', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(173, NULL, '50050111', 'BTL - TK - Natura - Gathering', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(174, NULL, '50050112', 'BTL - TK - Natura - Klinik/MCU', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(175, NULL, '50050113', 'BTL - TK - Natura - Catering', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(176, NULL, '50050114', 'BTL - TK - Natura - BPJS TK JKK, JKM', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(177, NULL, '50050115', 'BTL - TK - Natura - BPJS Kesehatan', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(178, NULL, '50050116', 'BTL - TK - Beban Tenaga Outsourshing/Magang', 'expense', 163, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(179, NULL, '500502', 'BOH - Pengiriman', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(180, NULL, '50050201', 'BOH - Pengiriman - By Ekspedisi', 'expense', 179, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(181, NULL, '50050203', 'BOH - Pengiriman - BBM/Tol/Parkir', 'expense', 179, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(182, NULL, '50050204', 'BOH - Pengiriman - Charter Kendaraan', 'expense', 179, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(183, NULL, '500503', 'BOH - Dinas dalam Kota', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(184, NULL, '50050301', 'BOH - Dinas dalam Kota - Makan/Konsumsi', 'expense', 183, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(185, NULL, '50050302', 'BOH - Dinas dalam Kota - Transportasi', 'expense', 183, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(186, NULL, '50050303', 'BOH - Dinas dalam Kota - BBM/Tol/Parkir', 'expense', 183, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(187, NULL, '500504', 'BOH - Dinas Luar Kota', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(188, NULL, '50050401', 'BOH - Dinas Luar - Ticket/ Transportasi', 'expense', 187, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(189, NULL, '50050402', 'BOH - Dinas Luar - Penginapan & Akomodasi', 'expense', 187, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(190, NULL, '50050403', 'BOH - Dinas Luar - Makan/Konsumsi', 'expense', 187, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(191, NULL, '500505', 'BOH - Sertifikasi', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(192, NULL, '50050501', 'BOH - Sertifikasi - Petugas Sampling', 'expense', 191, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(193, NULL, '50050502', 'BOH - Sertifikasi - Analis', 'expense', 191, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(194, NULL, '50050503', 'BOH - Sertifikasi - K3/HSE', 'expense', 191, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(195, NULL, '50050504', 'BOH - Sertifikasi - Pekerja Ketinggian', 'expense', 191, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(196, NULL, '50050505', 'BOH - Sertifikasi - Pengelola Limbah', 'expense', 191, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(197, NULL, '50050506', 'BOH - Sertifikasi - Pemadam Kebakaran', 'expense', 191, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(198, NULL, '500506', 'BOH - Utilities & Komunikasi', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(199, NULL, '50050601', 'BOH - Utilities & Komunikasi - Listrik', 'expense', 198, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(200, NULL, '50050602', 'BOH - Utilities & Komunikasis - Air', 'expense', 198, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(201, NULL, '50050603', 'BOH - Utilities & Komunikasi - Internet', 'expense', 198, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(202, NULL, '50050604', 'BOH - Utilities & Komunikasi - Tlp/Pulsa', 'expense', 198, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(203, NULL, '500507', 'BOH - Asuransi', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(204, NULL, '50050701', 'BOH - Asuransi - Bangunan', 'expense', 203, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(205, NULL, '50050702', 'BOH - Asuransi - Mesin/Peralatan', 'expense', 203, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(206, NULL, '50050703', 'BOH - Asuransi - Kendaraan', 'expense', 203, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(207, NULL, '500508', 'BOH - Pemeliharaan/Perbaikan', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(208, NULL, '50050801', 'BOH - Pemeliharaan/Perbaikan - Mesin', 'expense', 207, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(209, NULL, '50050802', 'BOH - Pemeliharaan/Perbaikan - Peralatan Lab', 'expense', 207, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(210, NULL, '50050803', 'BOH - Pemeliharaan/Perbaikan - Peralatan Sampling', 'expense', 207, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(211, NULL, '500509', 'BOH - Penyusutuan dan Amortisasi', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(212, NULL, '50050901', 'BOH - Penyusutan - Bangunan & Instalasi', 'expense', 211, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(213, NULL, '50050902', 'BOH - Penyusutan - Mesin', 'expense', 211, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(214, NULL, '50050903', 'BOH - Penyusutan - Peralatan Teknis', 'expense', 211, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(215, NULL, '50050904', 'BOH - Penyusutan - Kendaraan', 'expense', 211, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(216, NULL, '50050905', 'BOH - Amortisasi Aset Tidak Berwujud - Hak & Lisensi', 'expense', 211, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(217, NULL, '50050906', 'BOH - Amortisasi Aset Tidak Berwujud - Perangkat Lunak (Software)', 'expense', 211, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(218, NULL, '500510', 'BOH - Sewa', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(219, NULL, '50051001', 'BOH - Sewa - Peralatan Laboratorium', 'expense', 218, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(220, NULL, '50051002', 'BOH - Sewa - Peralatan Sampling', 'expense', 218, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(221, NULL, '50051003', 'BOH - Sewa - Bangunan Laboratorium', 'expense', 218, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(222, NULL, '500511', 'BOH - Inventaris', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(223, NULL, '50051101', 'BOH - Inventaris - Perlengkapan Laboratorium', 'expense', 222, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(224, NULL, '50051102', 'BOH - Inventaris - Perlengkapan Sampling', 'expense', 222, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(225, NULL, '500512', 'BOH - Jasa Pihak Ketiga', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(226, NULL, '50051201', 'BOH - Jasa Pihak Ketiga - Tenaga Ahli Sampling', 'expense', 225, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(227, NULL, '50051202', 'BOH - Jasa Pihak Ketiga - Tenaga Ahli Laboratorium', 'expense', 225, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(228, NULL, '50051203', 'BOH - Jasa Pihak Ketiga - Pembuangan Limbah', 'expense', 225, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(229, NULL, '500513', 'BOH - Kantor', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(230, NULL, '50051301', 'BOH - Kantor - ATK', 'expense', 229, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(231, NULL, '50051302', 'BOH - Kantor - Fotokopi/Cetakan', 'expense', 229, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(232, NULL, '50051303', 'BOH - Kantor - Perlengkapan', 'expense', 229, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(233, NULL, '500514', 'BOH - Validitas', 'expense', 162, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(234, NULL, '50051401', 'BOH - Validitas - CRM', 'expense', 233, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(235, NULL, '50051402', 'BOH - Validitas - Kalibrasi', 'expense', 233, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(236, NULL, '50051403', 'BOH - Validitas - Uji Banding', 'expense', 233, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:02:21', '2025-11-10 09:02:21', NULL),
(237, NULL, '50051404', 'BOH - Validitas - Uji Profisiensi', 'expense', 233, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(238, NULL, '6000', 'BIAYA OPERASIONAL', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(239, NULL, '6001', 'BIAYA PENJUALAN', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(240, NULL, '600101', 'Biaya Tenaga Kerja Penjualan', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(241, NULL, '60010101', 'BP - TK - Gaji/Upah', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(242, NULL, '60010102', 'BP - TK - Thr/Bonus', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(243, NULL, '60010103', 'BP - TK - Lembur', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(244, NULL, '60010104', 'BP - TK - Tunjangan Jabatan', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(245, NULL, '60010105', 'BP - TK - PPh Pasal 21', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(246, NULL, '60010106', 'BP - TK - Tunj. Transport', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(247, NULL, '60010107', 'BP - TK - Penggantian Pengobatan', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(248, NULL, '60010108', 'BP - TK - Tunj. Uang Makan', NULL, 240, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(249, NULL, '60010201', 'BP - TK - Natura - Seragam', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(250, NULL, '60010202', 'BP - TK - Natura - Latihan & Pendidikan', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(251, NULL, '60010203', 'BP - TK - Natura - Gathering', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(252, NULL, '60010204', 'BP - TK - Natura - Klinik/MCU', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(253, NULL, '60010205', 'BP - TK - Natura - Catering', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(254, NULL, '60010206', 'BP - TK - Natura - BPJS TK JKK, JKM', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(255, NULL, '60010207', 'BP - TK - Natura - BPJS Kesehatan', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(256, NULL, '60010301', 'BP - TK - Beban Tenaga Outsourshing/Magang', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(257, NULL, '600104', 'Biaya Penjulan Iklan/Promosi', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(258, NULL, '60010401', 'BP - Iklan/Promosi - Advertising', NULL, 257, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(259, NULL, '60010402', 'BP - Iklan/Promosi - Event & Exhibition', NULL, 257, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(260, NULL, '60010403', 'BP - Iklan/Promosi - Out Door', NULL, 257, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(261, NULL, '60010404', 'BP - Iklan/Promosi - Sponsorhip', NULL, 257, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(262, NULL, '60010405', 'BP - Iklan/Promosi - Sales Promotion', NULL, 257, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(263, NULL, '60010406', 'BP - Iklan/Promosi - Merchandise', NULL, 257, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(264, NULL, '600105', 'BP - Dinas dalam Kota', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(265, NULL, '60010501', 'BP - Dinas dalam Kota - BBM/Tol/Parkir', NULL, 264, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(266, NULL, '60010502', 'BP - Dinas dalam Kota - Transportasi', NULL, 264, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(267, NULL, '60010503', 'BP - Dinas dalam Kota - Makan/Konsumsi', NULL, 264, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(268, NULL, '600106', 'BP - Dinas Luar Kota', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(269, NULL, '60010601', 'BP - Dinas Luar - Ticket/ Transportasi', NULL, 268, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(270, NULL, '60010602', 'BP - Dinas Luar - Penginapan & Akomodasi', NULL, 268, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(271, NULL, '600107', 'Biaya Penjualan - Komunikasi/Internet', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(272, NULL, '60010701', 'BP - Komunikasi/Internet - Pulsa HP', NULL, 271, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(273, NULL, '60010702', 'BP - Komunikasi/Internet - Tagihan Pascabayar', NULL, 271, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(274, NULL, '60010703', 'BP - Komunikasi/Internet - Aplikasi', NULL, 271, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(275, NULL, '600108', 'Biaya Penjualan - Asuransi', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(276, NULL, '60010801', 'BP - Asuransi - Bangunan', NULL, 275, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(277, NULL, '60010802', 'BP - Asuransi - Peralatan Kantor', NULL, 275, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(278, NULL, '60010803', 'BP - Asuransi - Kendaraan', NULL, 275, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(279, NULL, '600109', 'BP - Komisi - Komisi Penjualan', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(280, NULL, '600110', 'BP - Komisi - Komisi Penjualan PT QSM', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(281, NULL, '600111', 'BP - Komisi - Representasi/Sumb/ Entertaint', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(282, NULL, '600112', 'BP - Komisi - CSR', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(283, NULL, '600113', 'BP - Penyusutan dan Amortisasi', NULL, 239, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(284, NULL, '60011301', 'BP - Penyusutan - Kendaraan', NULL, 283, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(285, NULL, '60011302', 'BP - Penyusutan - Peralatan Kantor', NULL, 283, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(286, NULL, '60011303', 'BP - Amortisasi Aset Tidak Berwujud - Hak & Lisensi', NULL, 283, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(287, NULL, '60011304', 'BP - Amortisasi Aset Tidak Berwujud - Perangkat Lunak (Software)', NULL, 283, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(288, NULL, '6002', 'BIAYA UMUM & ADMINISTRASI', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(289, NULL, '600201', 'Biaya Tenaga Kerja Umum & Adminstrasi', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(290, NULL, '60020101', 'BUA - TK - Gaji/Upah', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(291, NULL, '60020102', 'BUA - TK - Thr/Bonus', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(292, NULL, '60020103', 'BUA - TK - Lembur', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(293, NULL, '60020104', 'BUA - TK - Tunjangan Jabatan', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(294, NULL, '60020105', 'BUA - TK - PPh Pasal 21', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(295, NULL, '60020106', 'BUA - TK - Tunj. Transport', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(296, NULL, '60020107', 'BUA - TK - Penggantian Pengobatan', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(297, NULL, '60020108', 'BUA - TK - Tunj. Uang Makan', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(298, NULL, '60020109', 'BUA - TK - Tunj. Insentif Penagihan', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(299, NULL, '60020110', 'BUA - TK - Natura - Seragam', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(300, NULL, '60020111', 'BUA - TK - Natura - Latihan & Pendidikan', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(301, NULL, '60020112', 'BUA - TK - Natura - Gathering', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(302, NULL, '60020113', 'BUA - TK - Natura - Klinik/MCU', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(303, NULL, '60020114', 'BUA - TK - Natura - Catering', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(304, NULL, '60020115', 'BUA - TK - Natura - BPJS TK JKK, JKM', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(305, NULL, '60020116', 'BUA - TK - Natura - BPJS Kesehatan', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL);
INSERT INTO `finance_m_chart_of_accounts` (`id`, `uuid`, `code`, `name`, `type`, `parent_id`, `normal_balance`, `description`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(306, NULL, '60020117', 'BUA - TK - Beban Tenaga Outsourshing/Magang', NULL, 289, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(307, NULL, '600202', 'BUA - Dinas dalam Kota', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(308, NULL, '60020201', 'BUA - Dinas dalam kota - BBM/Tol/Parkir', NULL, 307, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(309, NULL, '60020202', 'BUA - Dinas dalam kota - Transportasi', NULL, 307, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(310, NULL, '60020203', 'BUA - Dinas dalam kota - Makan/Konsumsi', NULL, 307, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(311, NULL, '600203', 'BUA - Dinas Luar Kota', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(312, NULL, '60020301', 'BUA - Dinas Luar - Ticket/ Transportasi', NULL, 311, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(313, NULL, '60020302', 'BUA - Dinas Luar - Penginapan & Akomodasi', NULL, 311, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(314, NULL, '600204', 'Biaya umum & Adm - Rekrutmen', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(315, NULL, '60020401', 'BUA - Rekruitmen - Event Bursa Loker', NULL, 314, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(316, NULL, '60020402', 'BUA - Rekruitmen - Iklan Loker', NULL, 314, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(317, NULL, '60020403', 'BUA - Rekruitmen - Head Hunter', NULL, 314, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(318, NULL, '600205', 'Biaya Umum & Adm - Utilities & Komunikasi', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(319, NULL, '60020501', 'BUA - Komunikasi dan Utilities - Listrik', NULL, 318, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(320, NULL, '60020502', 'BUA - Komunikasi dan Utilities - Air', NULL, 318, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(321, NULL, '60020503', 'BUA - Komunikasi dan Utilities - Internet', NULL, 318, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(322, NULL, '60020504', 'BUA - Komunikasi dan Utilities - Tlp/Pulsa', NULL, 318, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(323, NULL, '600206', 'BUA - Pemeliharaan/Perbaikan', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(324, NULL, '60020601', 'BUA - Pemeliharaan/Perbaikan - Bangunan', NULL, 323, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(325, NULL, '60020602', 'BUA - Pemeliharaan/Perbaikan - Sarana', NULL, 323, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(326, NULL, '60020603', 'BUA - Pemeliharaan/Perbaikan - Peralatan Kantor', NULL, 323, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(327, NULL, '60020604', 'BUA - Pemeliharaan/Perbaikan - Kendaraan', NULL, 323, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(328, NULL, '600207', 'BUA - Penyusutan dan Amortisasi', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(329, NULL, '60020701', 'BUA - Penyusutan - Bangunan', NULL, 328, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(330, NULL, '60020702', 'BUA - Penyusutan - Peralatan Kantor', NULL, 328, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(331, NULL, '60020703', 'BUA - Penyusutan - Kendaraan', NULL, 328, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(332, NULL, '60020704', 'BUA - Penyusutan - Lainnya', NULL, 328, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(333, NULL, '60020705', 'BUA - Amortisasi Aset Tidak Berwujud - Hak & Lisensi', NULL, 328, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(334, NULL, '60020706', 'BUA - Amortisasi Aset Tidak Berwujud - Perangkat Lunak (Software)', NULL, 328, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(335, NULL, '600208', 'BUA - Sewa', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(336, NULL, '60020801', 'BUA - Sewa - Bangunan', NULL, 335, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(337, NULL, '60020802', 'BUA - Sewa - Kendaraan', NULL, 335, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(338, NULL, '60020803', 'BUA - Sewa - Peralatan Kantor', NULL, 335, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(339, NULL, '600209', 'BUA - Inventaris', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(340, NULL, '60020901', 'BUA - Inventaris - Perlengkapan Kantor', NULL, 339, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(341, NULL, '600210', 'BUA - Jasa Pihak Ketiga', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(342, NULL, '60021001', 'BUA - Jasa Pihak Ketiga - Jasa Legal', NULL, 341, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(343, NULL, '60021002', 'BUA - Jasa Pihak Ketiga - Jasa Konsultan', NULL, 341, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(344, NULL, '60021003', 'BUA - Jasa Pihak Ketiga - Jasa Trainer/Pembicara', NULL, 341, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(345, NULL, '600211', 'BUA - Keperluan Rapat/Raker', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(346, NULL, '60021101', 'BUA - Keperlun Rapat/Raker - Transportasi/Ticket', NULL, 345, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(347, NULL, '60021102', 'BUA - Keperlun Rapat/Raker - Ruang Rapat', NULL, 345, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(348, NULL, '60021103', 'BUA - Keperlun Rapat/Raker - Penginapan/Akomodasi', NULL, 345, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(349, NULL, '60021104', 'BUA - Keperlun Rapat/Raker - Makan/Konsumsi', NULL, 345, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(350, NULL, '60021105', 'BUA - Keperlun Rapat/Raker - Lain lain', NULL, 345, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(351, NULL, '600212', 'BUA - Keperluan Kantor', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(352, NULL, '60021201', 'BUA - Keperluan Kantor - Iuran Keanggotaan', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(353, NULL, '60021202', 'BUA - Keperluan Kantor - Perizinan', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(354, NULL, '60021203', 'BUA - Keperluan Kantor - ATK', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(355, NULL, '60021204', 'BUA - Keperluan Kantor - Materai', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(356, NULL, '60021205', 'BUA - Keperluan Kantor - Cetakan & Fotokopi', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(357, NULL, '60021206', 'BUA - Keperluan Kantor - Pantry', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(358, NULL, '60021207', 'BUA - Keperluan Kantor - Air Minum', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(359, NULL, '60021208', 'BUA - Keperluan Kantor - Kebersihan', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(360, NULL, '60021209', 'BUA - Keperluan Kantor - Keamanan & Retribusi', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(361, NULL, '60021210', 'BUA - Keperluan Kantor - Donasi/Sumbangan', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(362, NULL, '60021211', 'BUA - Keperluan Kantor - Honor Pondokan', NULL, 351, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(363, NULL, '600213', 'BUA - Pengiriman', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(364, NULL, '60021301', 'BUA - Pengiriman - By Ekspedisi', NULL, 363, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(365, NULL, '60021302', 'BUA - Pengiriman - Transportasi Online', NULL, 363, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(366, NULL, '60021303', 'BUA - Pengiriman - BBM/Tol/Parkir', NULL, 363, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(367, NULL, '60021304', 'BUA - Pengiriman - Charter Kendaraan', NULL, 363, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(368, NULL, '600214', 'BUA - Asuransi', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(369, NULL, '60021401', 'BUA - Asuransi - Bangunan', NULL, 368, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(370, NULL, '60021402', 'BUA - Asuransi - Peralatan Kantor', NULL, 368, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(371, NULL, '60021403', 'BUA - Asuransi - Kendaraan', NULL, 368, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(372, NULL, '600215', 'BUA - Beban Bagi Hasil', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(373, NULL, '60021501', 'BUA - Beban Bagi Hasil - Pembiayaan', NULL, 372, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(374, NULL, '60021502', 'BUA - Beban Bagi Hasil - Investasi Pihak Ketiga', NULL, 372, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(375, NULL, '600216', 'BUA - Beban Pajak Lainnya', NULL, 288, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(376, NULL, '600216001', 'BUA - Beban Pajak Lainnya - PBB', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(377, NULL, '600216002', 'BUA - Beban Pajak Lainnya - Pajak Kendaraan', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(378, NULL, '600216003', 'BUA - Beban Pajak Lainnya - Pajak Iklan', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(379, NULL, '600216004', 'BUA - Beban Pajak Lainnya - Denda Pajak/STP', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(380, NULL, '6999', 'BUA - Beban Operasional - Lain - Lain', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(381, NULL, '7000', 'PENDAPATAN & BIAYA NON OPERASI', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(382, NULL, '7001', 'Pendapatan Non Operasi', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(383, NULL, '700101', 'Pendapatan Non Op - Jasa Giro/Bunga Rek Bank', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(384, NULL, '700102', 'Pendapatan Non Op - Bunga Deposito', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(385, NULL, '700103', 'Pendapatan Non Op - Laba Selisih Kurs', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(386, NULL, '700104', 'Pendapatan Non Op - Laba Penjualan Aset Tetap', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(387, NULL, '700105', 'Pendapatan Non Op - Penjualan Limbah', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(388, NULL, '700106', 'Pendapatan Non Op - Klaim', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(389, NULL, '700107', 'Pendapatan Non Op - Lain-lain', NULL, 382, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(390, NULL, '7002', 'Biaya Non Operasi', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(391, NULL, '700201', 'Biaya Non Operasi - Adm Bank', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(392, NULL, '700202', 'Biaya Non Operasi - Provisi', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(393, NULL, '700203', 'Biaya Non Operasi - Rugi Selisih Kurs', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(394, NULL, '700204', 'Biaya Non Operasi - Penghapusan Piutang Tak Tertagih', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(395, NULL, '700205', 'Biaya Non Operasi - Adm Pinjaman Bank', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(396, NULL, '700206', 'Biaya Non Operasi - Pajak Bunga Bank', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(397, NULL, '700207', 'Biaya Non Operasi - Lain - Lain', NULL, 390, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(398, NULL, '7201', 'Laba/Rugi Terealisasi', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(399, NULL, '720101', 'Laba/Rugi Terealisasi IDR', NULL, 398, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(400, NULL, '7202', 'Laba/Rugi Belum Terealisasi', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(401, NULL, '720201', 'Laba/Rugi Belum Terealisasi IDR', NULL, 400, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(402, NULL, '8000', 'PAJAK KINI', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 09:09:06', '2025-11-10 09:09:06', NULL),
(403, NULL, 'cbakn', 'coba akuns', 'asset', NULL, 'debit', NULL, 1, NULL, NULL, NULL, '127.0.0.1', '2026-04-08 06:47:34', '2026-04-08 06:52:58', NULL),
(404, NULL, 'bcakn', 'coba akun child', 'asset', 403, 'debit', NULL, 1, NULL, NULL, NULL, '127.0.0.1', '2026-04-08 06:52:33', '2026-04-08 06:52:33', NULL),
(405, NULL, 'CHILD140011', 'Child Smoke', 'asset', 1, 'debit', NULL, 1, NULL, NULL, NULL, NULL, '2026-04-08 07:00:11', '2026-04-08 07:00:11', '2026-04-08 07:00:11');

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

--
-- Struktur dari tabel `finance_m_source_accounts`
--

CREATE TABLE `finance_m_source_accounts` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_ip` varchar(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `finance_m_source_accounts`
--

INSERT INTO `finance_m_source_accounts` (`id`, `uuid`, `name`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_ip`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'Bank BCA Syariahs', 1, 1, 1, NULL, '2025-12-30 22:52:18', '127.0.0.1', '2026-01-04 10:42:08', NULL),
(2, NULL, 'Bank BRI', 1, 1, 1, NULL, '2026-01-04 03:42:02', '127.0.0.1', '2026-01-04 10:42:02', NULL);

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

--
-- Struktur dari tabel `finance_t_fund_payment_attachments`
--

CREATE TABLE `finance_t_fund_payment_attachments` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fund_request_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `finance_t_fund_requests`
--

CREATE TABLE `finance_t_fund_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `applicant_id` bigint UNSIGNED DEFAULT NULL,
  `company_id` int UNSIGNED DEFAULT NULL,
  `branch_id` int UNSIGNED DEFAULT NULL,
  `department_id` int UNSIGNED DEFAULT NULL,
  `code` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `order_number` int UNSIGNED DEFAULT NULL,
  `order_year` int UNSIGNED DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `invoice_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount` decimal(13,0) DEFAULT NULL,
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `budget_id` int UNSIGNED DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `scheduled_payment_date` datetime DEFAULT NULL,
  `cost_control_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cost_control_approved_by` bigint UNSIGNED DEFAULT NULL,
  `cost_control_approved_at` timestamp NULL DEFAULT NULL,
  `tax_officer_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tax_officer_approved_by` bigint UNSIGNED DEFAULT NULL,
  `tax_officer_approved_at` timestamp NULL DEFAULT NULL,
  `spv_finance_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `spv_finance_approved_by` bigint UNSIGNED DEFAULT NULL,
  `spv_finance_approved_at` timestamp NULL DEFAULT NULL,
  `manager_finance_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `manager_finance_approved_by` bigint UNSIGNED DEFAULT NULL,
  `manager_finance_approved_at` timestamp NULL DEFAULT NULL,
  `transfer_date` datetime DEFAULT NULL,
  `transfer_by` bigint UNSIGNED DEFAULT NULL,
  `paid_status` tinyint DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `bank_updated_at` timestamp NULL DEFAULT NULL,
  `bank_updated_by` bigint UNSIGNED DEFAULT NULL,
  `tax_object` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tax_amount` decimal(15,2) DEFAULT NULL,
  `paid_amount` decimal(15,2) DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'waiting',
  `paid_date` datetime DEFAULT NULL,
  `source_coa` int DEFAULT NULL,
  `submission_status` enum('OPEX','CAPEX','lainnya','') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `transaction_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `scheduled_payment` datetime DEFAULT NULL,
  `report_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `report_proof` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reported_at` timestamp NULL DEFAULT NULL,
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `finance_t_fund_requests`
--

INSERT INTO `finance_t_fund_requests` (`id`, `uuid`, `applicant_id`, `company_id`, `branch_id`, `department_id`, `code`, `order_number`, `order_year`, `description`, `invoice_number`, `amount`, `account_name`, `account_number`, `bank_id`, `budget_id`, `notes`, `scheduled_payment_date`, `cost_control_status`, `cost_control_approved_by`, `cost_control_approved_at`, `tax_officer_status`, `tax_officer_approved_by`, `tax_officer_approved_at`, `spv_finance_status`, `spv_finance_approved_by`, `spv_finance_approved_at`, `manager_finance_status`, `manager_finance_approved_by`, `manager_finance_approved_at`, `transfer_date`, `transfer_by`, `paid_status`, `paid_at`, `bank_updated_at`, `bank_updated_by`, `tax_object`, `tax_amount`, `paid_amount`, `status`, `paid_date`, `source_coa`, `submission_status`, `transaction_type`, `scheduled_payment`, `report_status`, `report_proof`, `reported_at`, `component`, `created_by`, `updated_by`, `deleted_by`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, 1, NULL, NULL, 'FR2025111100001', 1, 2025, 'coba pengajuan dana', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 05:22:48', '2025-11-17 05:32:45', NULL),
(2, NULL, 1, 1, NULL, NULL, 'FR2025111100002', 2, 2025, 'coba pengajuan dana', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 05:23:47', '2025-11-17 05:33:01', NULL),
(3, NULL, 1, 1, NULL, NULL, 'FR2025111100003', 3, 2025, 'asd', 'tidak ada', 159, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 05:40:10', '2025-11-17 05:33:01', NULL),
(4, NULL, 1, 1, NULL, NULL, 'FR2025111200004', 4, 2025, 'coba 1', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 19:27:34', '2025-11-17 05:33:01', NULL),
(5, NULL, 2, 2, NULL, NULL, 'FR2025111200005', 5, 2025, 'coba 2', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 19:29:51', '2025-11-17 05:33:01', NULL),
(6, NULL, 3, 3, NULL, NULL, 'FR2025111200006', 6, 2025, 'coba 3', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 19:30:51', '2025-11-17 05:33:01', NULL),
(7, NULL, 4, 4, NULL, NULL, 'FR2025111200007', 7, 2025, 'coba 4', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 19:33:00', '2025-11-17 05:33:01', NULL),
(8, NULL, 1, 1, NULL, NULL, 'FR2025111200008', 8, 2025, 'coba log', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 19:34:20', '2025-11-17 05:33:01', NULL),
(9, NULL, 2, 2, NULL, NULL, 'FR2025111200009', 9, 2025, 'coba log lagi', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 19:42:49', '2025-11-17 05:33:01', NULL),
(10, NULL, 3, 3, NULL, NULL, 'FR2025111200010', 10, 2025, 'coba', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 20:02:00', '2025-11-17 05:33:01', NULL),
(11, NULL, 1, 1, NULL, NULL, 'FR2025111200011', 11, 2025, 'coba', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-11 20:06:51', '2025-11-17 05:33:01', NULL),
(12, NULL, 0, 1, NULL, NULL, 'FR2025111700012', 12, 2025, 'coba', 'tidak ada', 1590000, 'msahrul', '0621477', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-16 19:27:09', '2025-11-17 05:33:01', NULL),
(13, NULL, 1, 1, 1, 1, 'FR2025111700013', 13, 2025, 'coba', 'tidak ada', 1000000, 'msahrul', '0621477', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-17 01:00:36', '2025-11-17 01:00:36', NULL),
(14, NULL, 1, 1, 1, 1, 'FR2025111700014', 14, 2025, 'coba', 'tidak ada', 1000000, 'msahrul', '0621477', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-17 01:03:55', '2025-11-17 01:03:55', NULL),
(15, NULL, 1, 1, 1, 1, 'FR2025111700015', 15, 2025, 'coba', 'tidak ada', 1000000, 'msahrul', '0621477', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2025-11-17 01:09:28', '2025-11-17 01:09:28', NULL),
(16, NULL, 1, 1, 100, 7, NULL, NULL, NULL, 'coba budget', 'tidak ada', 999998, 'msahrul', '0621477', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2026-01-01 06:42:55', '2026-01-01 06:42:55', NULL),
(17, NULL, 1, 1, 100, 7, NULL, NULL, NULL, 'coba budget', 'tidak ada', 999998, 'msahrul', '0621477', 4, 1, NULL, '2026-01-05 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 999998.00, 'waiting', NULL, NULL, 'OPEX', NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-01 07:04:10', '2026-01-05 00:54:49', NULL),
(18, NULL, 1, 1, 1, 3, NULL, NULL, NULL, 'Purchase office supplies for Q1 2024', 'INV-2024-001', 1000000, 'John Doe', '1234567890', 4, NULL, 'Attachment Links:\nhttps://drive.google.com/file/d/1Qij8F60zwf9OtfTg9x2AC79G9XjLYAwS/view?usp=sharing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-06 00:22:00', '2026-01-06 00:22:00', NULL),
(19, NULL, 1, 1, 1, 3, NULL, NULL, NULL, 'Purchase office supplies for Q2 2024', 'INV-2024-002', 1000000, 'John Doe', '1234567890', 4, NULL, 'Attachment Links:\nhttps://drive.google.com/file/d/1Qij8F60zwf9OtfTg9x2AC79G9XjLYAwS/view?usp=sharing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-06 00:22:00', '2026-01-06 00:22:00', NULL),
(20, NULL, 12, 1, 1, 7, NULL, NULL, NULL, 'testing 06/01/2026', 'TIDAK ADA', 10000000, 'msahrul', '0621477', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-06 00:23:46', '2026-01-06 00:23:46', NULL),
(21, NULL, 1, 1, 1, 3, NULL, NULL, NULL, 'Purchase office supplies for Q1 2024', 'INV-2024-001', 1000000, 'John Doe', '1234567890', 4, 1, 'Attachment Links:\nhttps://drive.google.com/file/d/1Qij8F60zwf9OtfTg9x2AC79G9XjLYAwS/view?usp=sharing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 1000000.00, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-06 00:26:04', '2026-01-11 11:23:39', NULL),
(22, NULL, 1, 1, 1, 3, NULL, NULL, NULL, 'Purchase office supplies for Q2 2024', 'INV-2024-002', 1000000, 'John Doe', '1234567890', 4, NULL, 'Attachment Links:\nhttps://drive.google.com/file/d/1Qij8F60zwf9OtfTg9x2AC79G9XjLYAwS/view?usp=sharing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-06 00:26:04', '2026-01-06 00:26:04', NULL),
(23, NULL, 1, 1, 1, 3, NULL, NULL, NULL, 'Purchase office supplies for Q1 2024', 'INV-2024-001', 1000000, 'John Doe', '1234567890', 4, NULL, 'Attachment Links:\nhttps://drive.google.com/file/d/1Qij8F60zwf9OtfTg9x2AC79G9XjLYAwS/view?usp=sharing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20000.00, 980000.00, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '127.0.0.1', '2026-01-06 00:29:34', '2026-01-12 04:46:15', NULL),
(24, NULL, 4, 1, 1, 7, 'FR/2026/04/0001', 1, 2026, 'coba deskrisp', 'inv001', 123000, 'msah', '12345431', 4, 1, NULL, '2026-04-17 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 123000.00, 'waiting', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-09 02:42:21', '2026-04-09 02:49:40', NULL);

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

--
-- Struktur dari tabel `finance_t_fund_request_attachments`
--

CREATE TABLE `finance_t_fund_request_attachments` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fund_request_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `finance_t_fund_request_attachments`
--

INSERT INTO `finance_t_fund_request_attachments` (`id`, `uuid`, `fund_request_id`, `name`, `path`, `created_by`, `updated_by`, `deleted_by`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 2, 'SO PT GMP SEPTEMBER 2026_pV29qRtw', 'fund_attachments/SO PT GMP SEPTEMBER 2026_pV29qRtw.pdf', NULL, NULL, NULL, NULL, '2025-11-11 12:22:48', '2025-11-12 11:26:16', NULL),
(2, NULL, 2, '1859. Surat pernyataan Direktur tentang SO PT GMP (1)_9CQZP97S', 'fund_attachments/1859. Surat pernyataan Direktur tentang SO PT GMP (1)_9CQZP97S.pdf', NULL, NULL, NULL, NULL, '2025-11-11 12:22:48', '2025-11-12 11:26:17', NULL),
(3, NULL, 2, 'SO PT GMP SEPTEMBER 2026_DBNlQw9Q', 'fund_attachments/SO PT GMP SEPTEMBER 2026_DBNlQw9Q.pdf', NULL, NULL, NULL, NULL, '2025-11-11 12:23:47', '2025-11-12 11:26:05', NULL),
(4, NULL, 2, '1859. Surat pernyataan Direktur tentang SO PT GMP (1)_Iw9rYVxN', 'fund_attachments/1859. Surat pernyataan Direktur tentang SO PT GMP (1)_Iw9rYVxN.pdf', NULL, NULL, NULL, NULL, '2025-11-11 12:23:47', '2025-11-12 11:26:07', NULL),
(5, NULL, 12, 'penawaran pt qsm_cO6qupBx', 'fund_attachments/penawaran pt qsm_cO6qupBx.pdf', NULL, NULL, NULL, NULL, '2025-11-17 02:27:10', '2025-11-17 02:27:10', NULL),
(6, NULL, 12, 'sampel_3aEt4nhp', 'fund_attachments/sampel_3aEt4nhp.pdf', NULL, NULL, NULL, NULL, '2025-11-17 02:27:10', '2025-11-17 02:27:10', NULL),
(7, NULL, 13, 'eCustomer_20251111_Yim9jnOV', 'fund_attachments/eCustomer_20251111_Yim9jnOV.pdf', NULL, NULL, NULL, NULL, '2025-11-17 08:00:36', '2025-11-17 08:00:36', NULL),
(8, NULL, 14, 'eCustomer_20251111_P3zlx1UO', 'fund_attachments/eCustomer_20251111_P3zlx1UO.pdf', NULL, NULL, NULL, NULL, '2025-11-17 08:03:55', '2025-11-17 08:03:55', NULL),
(9, NULL, 15, 'eCustomer_20251111_NLCwP4mx', 'fund_attachments/eCustomer_20251111_NLCwP4mx.pdf', NULL, NULL, NULL, NULL, '2025-11-17 08:09:28', '2025-11-17 08:09:28', NULL),
(10, NULL, 16, 'cuti 29-12-2025.pdf', 'fund-requests/1767274975_695679dfbfda9.pdf', 1, 1, NULL, NULL, '2026-01-01 06:42:56', '2026-01-01 06:42:56', NULL),
(11, NULL, 17, 'cuti 29-12-2025.pdf', 'fund-requests/1767276250_69567edad0895.pdf', 1, 1, NULL, NULL, '2026-01-01 07:04:10', '2026-01-01 07:04:10', NULL),
(12, NULL, 20, 'Comparison VPS.pdf', 'fund-requests/1767684226_695cb8826ab96.pdf', 1, 1, NULL, NULL, '2026-01-06 00:23:47', '2026-01-06 00:23:47', NULL),
(13, NULL, 24, 'F.SOP.HRD.17.01 FORMULIR PERINTAH KERJA LEMBUR.pdf', 'fund-requests/1775727741_69d7747d40533.pdf', NULL, NULL, NULL, NULL, '2026-04-09 02:42:21', '2026-04-09 02:42:21', NULL);

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

--
-- Struktur dari tabel `finance_t_fund_request_report_attachments`
--

CREATE TABLE `finance_t_fund_request_report_attachments` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fund_request_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `updated_ip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `finance_t_journal_details`
--

CREATE TABLE `finance_t_journal_details` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `journal_entry_id` bigint UNSIGNED NOT NULL,
  `account_id` bigint UNSIGNED NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `debit` decimal(18,2) DEFAULT '0.00',
  `credit` decimal(18,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `finance_t_journal_entries`
--

CREATE TABLE `finance_t_journal_entries` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `journal_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `journal_date` date NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reference_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reference_id` bigint DEFAULT NULL,
  `total_debit` decimal(18,2) DEFAULT '0.00',
  `total_credit` decimal(18,2) DEFAULT '0.00',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `approved_by` bigint UNSIGNED DEFAULT NULL,
  `status` enum('draft','posted','void') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `gris_m_actions`
--

CREATE TABLE `gris_m_actions` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `display_name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `order` int DEFAULT '0',
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_actions`
--

INSERT INTO `gris_m_actions` (`id`, `uuid`, `name`, `display_name`, `order`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `updated_ip`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`) VALUES
(1, NULL, 'create', 'Create', 1, 1, '2026-01-06 19:38:41', '2026-01-06 19:38:41', NULL, '127.0.0.1', 1, 1, NULL, NULL),
(2, NULL, 'read', 'Read', 2, 1, '2026-01-06 19:41:48', '2026-01-06 19:41:48', NULL, '127.0.0.1', 1, 1, NULL, NULL),
(3, NULL, 'update', 'Update', 3, 1, '2026-01-06 19:42:34', '2026-01-06 19:42:34', NULL, '127.0.0.1', 1, 1, NULL, NULL),
(4, NULL, 'delete', 'Delete', 4, 1, '2026-01-06 19:42:45', '2026-01-06 19:42:45', NULL, '127.0.0.1', 1, 1, NULL, NULL);

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

--
-- Struktur dari tabel `gris_m_apps`
--

CREATE TABLE `gris_m_apps` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `gris_m_app_modules`
--

CREATE TABLE `gris_m_app_modules` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `display_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `order` int DEFAULT '0',
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_app_modules`
--

INSERT INTO `gris_m_app_modules` (`id`, `uuid`, `name`, `display_name`, `icon`, `order`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `updated_ip`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`) VALUES
(1, NULL, 'company', 'Company', 'Building2', 0, 1, '2026-01-06 19:44:20', '2026-01-06 19:44:20', NULL, '127.0.0.1', 1, 1, NULL, NULL);

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

--
-- Struktur dari tabel `gris_m_branches`
--

CREATE TABLE `gris_m_branches` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `company_id` int UNSIGNED DEFAULT NULL,
  `region_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_lab` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_branches`
--

INSERT INTO `gris_m_branches` (`id`, `uuid`, `company_id`, `region_id`, `name`, `code`, `description`, `is_active`, `is_lab`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, 1, 'Mojokerto', 'MJK', 'SNI 7657:2010', 1, 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:45:36', '2026-02-18 20:28:37', NULL),
(2, NULL, 1, 2, 'Semarang', 'SMG', 'SNI 7657:2010', 1, 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:46:26', '2026-02-18 20:28:40', NULL),
(3, NULL, 1, 2, 'Depok', 'DPK', 'SNI 7657:2010', 1, 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:46:26', '2026-02-18 20:28:13', NULL),
(4, NULL, 1, 1, 'Kalimantan', NULL, NULL, 1, 0, 4, 4, NULL, NULL, '180.247.115.20', '2026-02-18 20:28:59', '2026-03-10 09:01:39', NULL),
(5, NULL, 1, 1, 'Morowali', 'MW', NULL, 1, 0, 4, 4, NULL, NULL, '180.247.115.20', '2026-02-18 20:29:18', '2026-03-10 09:01:43', NULL),
(6, NULL, 7, 1, 'EPL', 'EPL', NULL, 1, 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:46:26', '2026-03-10 08:59:37', NULL),
(100, NULL, 1, 1, 'Head Office', 'HO', NULL, 1, 0, 1, 4, NULL, NULL, '180.247.115.20', '2025-11-01 22:46:26', '2026-03-01 21:19:36', NULL);

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

--
-- Struktur dari tabel `gris_m_companies`
--

CREATE TABLE `gris_m_companies` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo_path` text COLLATE utf8mb4_general_ci,
  `is_active` tinyint(1) DEFAULT '1',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_companies`
--

INSERT INTO `gris_m_companies` (`id`, `uuid`, `name`, `logo_path`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'PT GRAHA MUTU PERSADA', NULL, 1, 1, NULL, NULL, NULL, NULL, '2025-11-01 21:54:01', NULL, NULL),
(2, NULL, 'PT GRAHA NUSANTARA INVESTAMA', NULL, 1, 1, NULL, NULL, NULL, NULL, '2025-11-01 21:48:46', NULL, NULL),
(3, NULL, 'PT LABTEK PRIMA INDONESIA', NULL, 1, 1, NULL, NULL, NULL, NULL, '2025-11-01 21:54:01', NULL, NULL),
(4, NULL, 'PT SENTRA ALAM PERSADA', NULL, 1, 1, NULL, NULL, NULL, NULL, '2025-11-01 21:54:01', NULL, NULL),
(5, NULL, 'PT QUALITY SUPPLY MANAGEMENT', NULL, 1, 1, NULL, NULL, NULL, NULL, '2025-11-01 21:54:01', NULL, NULL),
(6, NULL, 'PT ECO PERSADA LABORATORY', NULL, 1, 1, 1, NULL, NULL, '127.0.0.1', '2025-11-01 21:58:11', '2026-03-10 09:07:28', NULL),
(7, NULL, 'PT SOLUSI KERJA NUSANTARA', NULL, 1, 1, NULL, NULL, NULL, NULL, '2025-11-01 21:54:01', '2026-03-10 09:07:31', NULL);

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

--
-- Struktur dari tabel `gris_m_departments`
--

CREATE TABLE `gris_m_departments` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_ip` varchar(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `company_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `gris_m_departments`
--

INSERT INTO `gris_m_departments` (`id`, `uuid`, `code`, `name`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `created_at`, `updated_ip`, `updated_at`, `deleted_at`, `company_id`) VALUES
(1, NULL, 'OPR', 'Operation', 1, 1, 1, NULL, NULL, '2025-11-09 21:00:02', '127.0.0.1', '2026-01-07 14:05:47', NULL, NULL),
(2, NULL, 'FIN', 'Finances', 1, 1, 1, NULL, NULL, '2025-11-09 21:00:02', '127.0.0.1', '2026-01-07 14:05:47', NULL, NULL),
(3, NULL, 'HC', 'Human Capital', 1, 1, 1, NULL, NULL, '2025-11-09 21:00:02', '127.0.0.1', '2026-02-18 04:22:40', NULL, NULL),
(4, NULL, 'SMBDU', 'Marketing', 1, 1, NULL, NULL, NULL, '2025-11-09 21:00:02', NULL, '2026-02-18 04:22:47', NULL, NULL),
(5, NULL, 'SUS', 'Sustainability', 1, 1, NULL, NULL, NULL, '2025-11-09 21:00:02', NULL, '2026-01-07 14:05:47', NULL, NULL),
(6, NULL, 'SCM', 'Supply Chain', 1, 1, NULL, NULL, NULL, '2025-11-09 21:00:02', NULL, '2026-01-07 14:05:47', NULL, NULL),
(7, NULL, 'IT', 'IT', 1, 1, NULL, NULL, NULL, '2025-11-09 21:00:02', NULL, '2026-02-18 04:22:28', NULL, NULL);

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

--
-- Struktur dari tabel `gris_m_job_levels`
--

CREATE TABLE `gris_m_job_levels` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_job_levels`
--

INSERT INTO `gris_m_job_levels` (`id`, `uuid`, `name`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'CEO', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-19 04:01:07', NULL),
(2, NULL, 'Level C', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:10', NULL),
(3, NULL, 'Sekretaris Direktur', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-19 04:01:15', NULL),
(4, NULL, 'Kepala Cabang', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:21', NULL),
(5, NULL, 'Manager', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:27', NULL),
(6, NULL, 'Supervisor', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:33', NULL),
(7, NULL, 'Staff', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:37', NULL),
(8, NULL, 'Freelance', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:42', NULL),
(9, NULL, 'Internship', 1, 1, 4, NULL, NULL, '127.0.0.1', '2025-11-01 22:13:22', '2026-02-15 05:04:47', NULL);

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

--
-- Struktur dari tabel `gris_m_permissions`
--

CREATE TABLE `gris_m_permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `module_id` bigint UNSIGNED NOT NULL,
  `action_id` bigint UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `guard_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT 'web',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_permissions`
--

INSERT INTO `gris_m_permissions` (`id`, `uuid`, `module_id`, `action_id`, `name`, `guard_name`, `created_at`, `updated_at`, `deleted_at`, `updated_ip`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`) VALUES
(1, NULL, 1, 1, 'company.create', 'web', '2026-01-06 19:44:47', '2026-02-15 06:58:41', NULL, '127.0.0.1', 1, 4, NULL, NULL),
(2, NULL, 1, 2, 'company.read', 'web', '2026-01-06 19:44:47', '2026-02-15 06:58:41', NULL, '127.0.0.1', 1, 4, NULL, NULL),
(3, NULL, 1, 3, 'company.update', 'web', '2026-01-06 19:44:47', '2026-02-15 06:58:41', NULL, '127.0.0.1', 1, 4, NULL, NULL),
(4, NULL, 1, 4, 'company.delete', 'web', '2026-01-06 19:44:47', '2026-02-15 06:58:41', NULL, '127.0.0.1', 1, 4, NULL, NULL);

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

--
-- Struktur dari tabel `gris_m_positions`
--

CREATE TABLE `gris_m_positions` (
  `id` int UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `department_id` int UNSIGNED DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_ip` varchar(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `gris_m_positions`
--

INSERT INTO `gris_m_positions` (`id`, `uuid`, `department_id`, `code`, `name`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `created_at`, `updated_ip`, `updated_at`, `deleted_at`) VALUES
(1, NULL, NULL, NULL, 'CEO', 1, 4, 4, NULL, NULL, '2026-02-17 14:27:13', '127.0.0.1', '2026-02-19 02:12:08', NULL),
(2, NULL, NULL, NULL, 'Sekretaris Direktur', 1, 4, 4, NULL, NULL, '2026-02-17 14:27:21', '127.0.0.1', '2026-02-19 02:12:51', NULL),
(3, NULL, 1, NULL, 'East Region Head', 1, 4, 4, NULL, NULL, '2026-02-17 14:40:24', '127.0.0.1', '2026-02-19 02:36:39', NULL),
(4, NULL, 1, NULL, 'West Region Head', 1, 4, 4, NULL, NULL, '2026-02-17 14:40:36', '127.0.0.1', '2026-02-19 02:13:55', NULL),
(5, NULL, 1, NULL, 'Account Manager Depok', 1, 4, 4, NULL, NULL, '2026-02-17 14:40:59', '127.0.0.1', '2026-02-19 02:36:28', NULL),
(6, NULL, 1, NULL, 'Account Manager Semarang', 1, 4, 4, NULL, NULL, '2026-02-17 14:41:17', '127.0.0.1', '2026-02-19 02:36:21', NULL),
(7, NULL, 4, NULL, 'Account Manager Jawa', 1, 4, 4, NULL, NULL, '2026-02-17 14:41:29', '127.0.0.1', '2026-02-19 02:17:08', NULL),
(8, NULL, 1, NULL, 'Account Manager Sulawesi', 1, 4, 4, NULL, NULL, '2026-02-17 14:41:43', '127.0.0.1', '2026-02-19 02:19:18', NULL),
(9, NULL, 5, NULL, 'Koordinator Mutu', 1, 4, 4, NULL, NULL, '2026-02-17 14:42:03', '127.0.0.1', '2026-02-19 02:21:16', NULL),
(10, NULL, 4, NULL, 'Sales', 1, 4, 4, NULL, NULL, '2026-02-17 14:42:11', '127.0.0.1', '2026-02-19 02:14:01', NULL),
(11, NULL, 1, NULL, 'Analis', 1, 4, 4, NULL, NULL, '2026-02-17 14:42:26', '127.0.0.1', '2026-02-19 02:17:23', NULL),
(12, NULL, 1, NULL, 'Team Leader PPC', 1, 4, 4, NULL, NULL, '2026-02-17 14:42:37', '127.0.0.1', '2026-02-19 02:17:58', NULL),
(13, NULL, 4, NULL, 'Sales Admin', 0, 4, 4, 4, NULL, '2026-02-17 14:42:47', '127.0.0.1', '2026-02-19 02:37:37', '2026-02-18 19:37:37'),
(14, NULL, 1, NULL, 'Admin Cabang', 1, 4, 4, NULL, NULL, '2026-02-17 14:43:47', '127.0.0.1', '2026-02-19 02:17:30', NULL),
(15, NULL, 1, NULL, 'Support Admin', 0, 4, 4, 4, NULL, '2026-02-17 14:44:04', '127.0.0.1', '2026-02-19 02:38:24', '2026-02-18 19:38:24'),
(16, NULL, 1, NULL, 'Support PPC', 1, 4, 4, NULL, NULL, '2026-02-17 14:44:17', '127.0.0.1', '2026-02-19 02:18:09', NULL),
(17, NULL, 1, NULL, 'Admin Laboratorium', 1, 4, 4, NULL, NULL, '2026-02-17 14:44:29', '127.0.0.1', '2026-02-19 02:19:01', NULL),
(18, NULL, 3, NULL, 'Security', 1, 4, 4, NULL, NULL, '2026-02-17 14:44:39', '127.0.0.1', '2026-02-19 02:17:44', NULL),
(19, NULL, 1, NULL, 'Laboran', 1, 4, 4, NULL, NULL, '2026-02-17 14:44:49', '127.0.0.1', '2026-02-19 02:19:06', NULL),
(20, NULL, 2, NULL, 'Manager FAT', 1, 4, 4, NULL, NULL, '2026-02-17 14:45:04', '127.0.0.1', '2026-02-19 02:13:14', NULL),
(21, NULL, 2, NULL, 'Cost Managment and Budgeting', 1, 4, 4, NULL, NULL, '2026-02-17 14:45:17', '127.0.0.1', '2026-02-19 02:25:38', NULL),
(22, NULL, 2, NULL, 'Staff Tax', 1, 4, 4, NULL, NULL, '2026-02-17 14:45:26', '127.0.0.1', '2026-02-19 02:25:53', NULL),
(23, NULL, 2, NULL, 'Staff Accounting', 1, 4, 4, NULL, NULL, '2026-02-17 14:45:37', '127.0.0.1', '2026-02-19 02:25:59', NULL),
(24, NULL, 2, NULL, 'Staff AP', 1, 4, 4, NULL, NULL, '2026-02-17 14:45:45', '127.0.0.1', '2026-02-19 02:26:06', NULL),
(25, NULL, 2, NULL, 'Staff AR', 1, 4, 4, NULL, NULL, '2026-02-17 14:45:53', '127.0.0.1', '2026-02-19 02:26:11', NULL),
(26, NULL, 3, NULL, 'CHCO', 1, 4, 4, NULL, NULL, '2026-02-17 14:46:11', '127.0.0.1', '2026-02-19 02:12:12', NULL),
(27, NULL, 3, NULL, 'Supervisor Human Capital', 1, 4, 4, NULL, NULL, '2026-02-17 14:46:23', '127.0.0.1', '2026-02-19 02:27:30', NULL),
(28, NULL, 3, NULL, 'Manager GA-Legal', 1, 4, 4, NULL, NULL, '2026-02-17 14:46:34', '127.0.0.1', '2026-02-19 02:36:14', NULL),
(29, NULL, 3, NULL, 'OB/Driver', 1, 4, 4, NULL, NULL, '2026-02-17 14:46:47', '127.0.0.1', '2026-02-19 02:28:28', NULL),
(30, NULL, 3, NULL, 'Staff Training and Development', 1, 4, 4, NULL, NULL, '2026-02-17 14:46:58', '127.0.0.1', '2026-02-19 02:27:55', NULL),
(31, NULL, 3, NULL, 'Staff Compensation and Benefit', 0, 4, 4, 4, NULL, '2026-02-17 14:47:11', '127.0.0.1', '2026-02-19 02:35:39', '2026-02-18 19:35:39'),
(32, NULL, 4, NULL, 'Manager Marketing', 0, 4, 4, 4, NULL, '2026-02-17 14:47:29', '127.0.0.1', '2026-02-19 02:30:59', '2026-02-18 19:30:59'),
(33, NULL, 4, NULL, 'Manager BDU', 0, 4, 4, 4, NULL, '2026-02-17 14:47:37', '127.0.0.1', '2026-02-19 02:35:52', '2026-02-18 19:35:52'),
(34, NULL, 4, NULL, 'Marketing and Branding', 1, 4, 4, NULL, NULL, '2026-02-17 14:47:49', '127.0.0.1', '2026-02-19 02:30:50', NULL),
(35, NULL, 4, NULL, 'Partnership and Expansion', 1, 4, 4, NULL, NULL, '2026-02-17 14:48:02', '127.0.0.1', '2026-02-19 02:31:10', NULL),
(36, NULL, 5, NULL, 'Manager Sustainability', 1, 4, 4, NULL, NULL, '2026-02-17 14:48:14', '127.0.0.1', '2026-02-19 02:13:31', NULL),
(37, NULL, 6, NULL, 'Manager Supply Chain', 1, 4, 4, NULL, NULL, '2026-02-17 14:48:25', '127.0.0.1', '2026-02-19 02:13:22', NULL),
(38, NULL, 6, NULL, 'Supply Chain', 0, 4, 4, 4, NULL, '2026-02-17 14:48:35', '127.0.0.1', '2026-02-19 02:37:06', '2026-02-18 19:37:06'),
(39, NULL, 6, NULL, 'Procurement', 1, 4, 4, NULL, NULL, '2026-02-17 14:48:43', '127.0.0.1', '2026-02-19 02:34:15', NULL),
(40, NULL, 7, NULL, 'Manager IT', 1, 4, 4, NULL, NULL, '2026-02-17 14:48:50', '127.0.0.1', '2026-02-19 02:13:09', NULL),
(41, NULL, 7, NULL, 'Staff IT', 1, 4, 4, NULL, NULL, '2026-02-17 14:48:58', '127.0.0.1', '2026-02-19 02:35:27', NULL),
(42, NULL, 1, NULL, 'COO', 1, 4, 4, NULL, NULL, '2026-02-18 18:42:05', '127.0.0.1', '2026-02-19 02:12:21', NULL),
(43, NULL, 4, NULL, 'CMO', 1, 4, 4, NULL, NULL, '2026-02-18 19:08:36', '127.0.0.1', '2026-02-19 02:12:15', NULL),
(44, NULL, 4, NULL, 'PMO', 1, 4, 4, NULL, NULL, '2026-02-18 19:09:01', '127.0.0.1', '2026-02-19 02:34:23', NULL),
(45, NULL, 1, NULL, 'Koordinator Area Depok', 1, 4, 4, NULL, NULL, '2026-02-18 19:14:50', '127.0.0.1', '2026-02-19 02:14:50', NULL),
(46, NULL, 1, NULL, 'Koordinator Area Semarang', 1, 4, 4, NULL, NULL, '2026-02-18 19:18:28', '127.0.0.1', '2026-02-19 02:18:28', NULL),
(47, NULL, 1, NULL, 'Admin Lapangan', 1, 4, 4, NULL, NULL, '2026-02-18 19:18:47', '127.0.0.1', '2026-02-19 02:18:47', NULL),
(48, NULL, 1, NULL, 'Account Manager Kalimantan', 1, 4, 4, NULL, NULL, '2026-02-18 19:19:41', '127.0.0.1', '2026-02-19 02:19:41', NULL),
(49, NULL, 1, NULL, 'Admin RO', 1, 4, 4, NULL, NULL, '2026-02-18 19:20:53', '127.0.0.1', '2026-02-19 02:20:53', NULL),
(50, NULL, 1, NULL, 'Koordinator Lapangan', 1, 4, 4, NULL, NULL, '2026-02-18 19:21:29', '127.0.0.1', '2026-02-19 02:21:29', NULL),
(51, NULL, 1, NULL, 'Koordinator Laboratorium', 1, 4, 4, NULL, NULL, '2026-02-18 19:21:53', '127.0.0.1', '2026-02-19 02:21:53', NULL),
(52, NULL, 1, NULL, 'Senior Analis', 1, 4, 4, NULL, NULL, '2026-02-18 19:22:21', '127.0.0.1', '2026-02-19 02:22:21', NULL),
(53, NULL, 2, NULL, 'Supervisor FAT', 1, 4, 4, NULL, NULL, '2026-02-18 19:25:00', '127.0.0.1', '2026-02-19 02:25:00', NULL),
(54, NULL, 3, NULL, 'Staff Recruitment', 1, 4, 4, NULL, NULL, '2026-02-18 19:27:47', '127.0.0.1', '2026-02-19 02:27:47', NULL),
(55, NULL, 3, NULL, 'Staff Compensation and Benefit', 1, 4, 4, NULL, NULL, '2026-02-18 19:28:21', '127.0.0.1', '2026-02-19 02:36:52', NULL),
(56, NULL, 3, NULL, 'Staff GA Asset', 1, 4, 4, NULL, NULL, '2026-02-18 19:28:44', '127.0.0.1', '2026-02-19 02:28:44', NULL),
(57, NULL, 3, NULL, 'Staff Legal', 1, 4, 4, NULL, NULL, '2026-02-18 19:29:00', '127.0.0.1', '2026-02-19 02:29:00', NULL),
(58, NULL, 4, NULL, 'Manager Sales', 1, 4, 4, NULL, NULL, '2026-02-18 19:29:37', '127.0.0.1', '2026-02-19 02:29:37', NULL),
(59, NULL, 4, NULL, 'Manager Marketing and BDU', 1, 4, 4, NULL, NULL, '2026-02-18 19:29:48', '127.0.0.1', '2026-02-19 02:29:48', NULL),
(60, NULL, 4, NULL, 'Customer Care', 1, 4, 4, NULL, NULL, '2026-02-18 19:30:10', '127.0.0.1', '2026-02-19 02:30:10', NULL),
(61, NULL, 4, NULL, 'Admin Sales', 1, 4, 4, NULL, NULL, '2026-02-18 19:30:26', '127.0.0.1', '2026-02-19 02:30:26', NULL),
(62, NULL, 4, NULL, 'Design Graphic', 1, 4, 4, NULL, NULL, '2026-02-18 19:31:32', '127.0.0.1', '2026-02-19 02:31:32', NULL),
(63, NULL, 4, NULL, 'SEO and Web', 1, 4, 4, NULL, NULL, '2026-02-18 19:31:47', '127.0.0.1', '2026-02-19 02:31:47', NULL),
(64, NULL, 4, NULL, 'Marcom', 1, 4, 4, NULL, NULL, '2026-02-18 19:32:14', '127.0.0.1', '2026-02-19 02:32:14', NULL),
(65, NULL, 4, NULL, 'Telemarketing', 1, 4, 4, NULL, NULL, '2026-02-18 19:32:30', '127.0.0.1', '2026-02-19 02:32:30', NULL),
(66, NULL, NULL, NULL, 'Data Analyst', 1, 4, 4, NULL, NULL, '2026-02-18 19:32:45', '127.0.0.1', '2026-02-19 02:32:45', NULL),
(67, NULL, 4, NULL, 'Bussiness Inteligent', 1, 4, 4, NULL, NULL, '2026-02-18 19:33:05', '127.0.0.1', '2026-02-19 02:33:05', NULL),
(68, NULL, 5, NULL, 'Reasearch and Development', 1, 4, 4, NULL, NULL, '2026-02-18 19:33:27', '127.0.0.1', '2026-02-19 02:33:27', NULL),
(69, NULL, 6, NULL, 'Supply Planning', 1, 4, 4, NULL, NULL, '2026-02-18 19:34:07', '127.0.0.1', '2026-02-19 02:34:07', NULL),
(70, NULL, 6, NULL, 'Staff Transport', 1, 4, 4, NULL, NULL, '2026-02-18 19:34:40', '127.0.0.1', '2026-02-19 02:34:40', NULL),
(71, NULL, 6, NULL, 'Staff Warehouse', 1, 4, 4, NULL, NULL, '2026-02-18 19:34:53', '127.0.0.1', '2026-02-19 02:34:53', NULL),
(72, NULL, 1, NULL, 'Analis Biologi', 1, 4, 4, NULL, NULL, '2026-02-19 03:37:06', '127.0.0.1', '2026-02-19 10:37:06', NULL),
(73, NULL, 4, NULL, 'Supervisor Sales', 1, 4, 4, NULL, NULL, '2026-02-19 03:52:19', '127.0.0.1', '2026-02-19 10:52:19', NULL),
(74, NULL, 1, NULL, 'Analis Kimia', 1, 4, 4, NULL, NULL, '2026-02-19 03:58:50', '127.0.0.1', '2026-02-19 10:58:50', NULL),
(75, NULL, 4, NULL, 'Account Executive', 1, 4, 4, NULL, NULL, '2026-02-19 04:09:00', '127.0.0.1', '2026-02-19 11:09:00', NULL),
(76, NULL, 1, NULL, 'Intern PPC', 1, 4, 4, NULL, NULL, '2026-03-01 21:08:34', '180.247.115.20', '2026-03-02 04:08:34', NULL);

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

--
-- Struktur dari tabel `gris_m_regions`
--

CREATE TABLE `gris_m_regions` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `gris_m_regions`
--

INSERT INTO `gris_m_regions` (`id`, `uuid`, `company_id`, `name`, `code`, `description`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, NULL, 'East', NULL, NULL, 1, 4, 4, NULL, NULL, '127.0.0.1', '2026-02-18 18:26:51', '2026-02-18 18:26:51', NULL),
(2, NULL, NULL, 'West', NULL, NULL, 1, 4, 4, NULL, NULL, '127.0.0.1', '2026-02-18 18:26:56', '2026-02-18 18:26:56', NULL);

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

--
-- Struktur dari tabel `gris_m_roles`
--

CREATE TABLE `gris_m_roles` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `display_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `guard_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT 'web',
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_m_roles`
--

INSERT INTO `gris_m_roles` (`id`, `uuid`, `name`, `display_name`, `guard_name`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `updated_ip`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, NULL, 'Admin', NULL, NULL, 1, '2026-01-02 01:55:13', '2026-01-06 21:24:38', '2026-01-06 21:24:38', '127.0.0.1', NULL, 1, 1),
(2, NULL, 'User', NULL, NULL, 1, '2026-01-03 01:48:37', '2026-01-06 21:24:33', '2026-01-06 21:24:33', '127.0.0.1', NULL, 1, 1),
(3, NULL, 'Admin', NULL, 'web', 1, '2026-01-06 21:24:44', '2026-01-06 21:24:44', NULL, '127.0.0.1', 1, 1, NULL),
(4, NULL, 'User', NULL, 'web', 1, '2026-01-06 21:27:35', '2026-01-07 00:31:19', NULL, '127.0.0.1', 1, 1, NULL);

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

--
-- Struktur dari tabel `gris_p_role_permissions`
--

CREATE TABLE `gris_p_role_permissions` (
  `role_id` bigint UNSIGNED NOT NULL,
  `permission_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_p_role_permissions`
--

INSERT INTO `gris_p_role_permissions` (`role_id`, `permission_id`) VALUES
(3, 1),
(3, 2),
(4, 2),
(3, 3),
(3, 4);

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

--
-- Struktur dari tabel `gris_p_user_roles`
--

CREATE TABLE `gris_p_user_roles` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `roles` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `inactive_at` timestamp NULL DEFAULT NULL,
  `updated_ip` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `gris_p_user_roles`
--

INSERT INTO `gris_p_user_roles` (`id`, `user_id`, `roles`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `inactive_at`, `updated_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, '[3,4]', 1, 1, 1, NULL, NULL, '127.0.0.1', '2025-11-10 02:17:16', '2026-01-07 12:38:27', NULL),
(2, 2, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 02:17:16', '2025-11-10 02:17:39', NULL),
(3, 3, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 02:17:16', '2025-11-10 02:17:42', NULL),
(4, 4, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 02:17:16', '2025-11-10 02:17:45', NULL),
(5, 5, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-11-10 02:17:16', '2025-11-10 02:18:03', NULL);

--
-- Indeks untuk tabel yang dibuang
--

--
-- Indeks untuk tabel `finance_h_accurate_integration_logs`
--
ALTER TABLE `finance_h_accurate_integration_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_integrasi_accurate_id_po_index` (`po_id`),
  ADD KEY `log_integrasi_accurate_nomor_po_index` (`po_number`),
  ADD KEY `log_integrasi_accurate_id_user_index` (`user_id`);

--
-- Indeks untuk tabel `finance_h_budget_logs`
--
ALTER TABLE `finance_h_budget_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `finance_m_banks`
--
ALTER TABLE `finance_m_banks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_m_banks_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `finance_m_budgets`
--
ALTER TABLE `finance_m_budgets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_m_budgets_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `finance_m_chart_of_accounts`
--
ALTER TABLE `finance_m_chart_of_accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_m_chart_of_accounts_uuid_unique` (`uuid`),
  ADD KEY `parent_id` (`parent_id`);

--
-- Indeks untuk tabel `finance_m_source_accounts`
--
ALTER TABLE `finance_m_source_accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_m_source_accounts_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `finance_t_fund_payment_attachments`
--
ALTER TABLE `finance_t_fund_payment_attachments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_t_fund_payment_attachments_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `finance_t_fund_requests`
--
ALTER TABLE `finance_t_fund_requests`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_t_fund_requests_uuid_unique` (`uuid`),
  ADD KEY `idx_cost_control_status` (`cost_control_status`),
  ADD KEY `idx_tax_officer_status` (`tax_officer_status`),
  ADD KEY `idx_spv_finance_status` (`spv_finance_status`),
  ADD KEY `idx_manager_finance_status` (`manager_finance_status`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_transaction_type` (`transaction_type`),
  ADD KEY `idx_report_status` (`report_status`),
  ADD KEY `fk_cost_control_approver` (`cost_control_approved_by`),
  ADD KEY `fk_tax_officer_approver` (`tax_officer_approved_by`),
  ADD KEY `fk_spv_finance_approver` (`spv_finance_approved_by`),
  ADD KEY `fk_manager_finance_approver` (`manager_finance_approved_by`);

--
-- Indeks untuk tabel `finance_t_fund_request_attachments`
--
ALTER TABLE `finance_t_fund_request_attachments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_t_fund_request_attachments_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `finance_t_fund_request_report_attachments`
--
ALTER TABLE `finance_t_fund_request_report_attachments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_t_fund_request_report_attachments_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `finance_t_journal_details`
--
ALTER TABLE `finance_t_journal_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `finance_t_journal_details_uuid_unique` (`uuid`),
  ADD KEY `journal_entry_id` (`journal_entry_id`),
  ADD KEY `account_id` (`account_id`);

--
-- Indeks untuk tabel `finance_t_journal_entries`
--
ALTER TABLE `finance_t_journal_entries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `journal_no` (`journal_no`),
  ADD UNIQUE KEY `finance_t_journal_entries_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_actions`
--
ALTER TABLE `gris_m_actions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD UNIQUE KEY `gris_m_actions_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_apps`
--
ALTER TABLE `gris_m_apps`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_m_apps_slug_unique` (`slug`),
  ADD UNIQUE KEY `gris_m_apps_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_app_modules`
--
ALTER TABLE `gris_m_app_modules`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD UNIQUE KEY `gris_m_app_modules_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_branches`
--
ALTER TABLE `gris_m_branches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_branches_uuid_unique` (`uuid`),
  ADD KEY `m_branch_region_id_foreign` (`region_id`);

--
-- Indeks untuk tabel `gris_m_companies`
--
ALTER TABLE `gris_m_companies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_companies_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_departments`
--
ALTER TABLE `gris_m_departments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_departments_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_job_levels`
--
ALTER TABLE `gris_m_job_levels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_job_levels_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_permissions`
--
ALTER TABLE `gris_m_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD UNIQUE KEY `gris_m_permissions_uuid_unique` (`uuid`),
  ADD KEY `module_id` (`module_id`),
  ADD KEY `action_id` (`action_id`);

--
-- Indeks untuk tabel `gris_m_positions`
--
ALTER TABLE `gris_m_positions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_positions_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_regions`
--
ALTER TABLE `gris_m_regions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_regions_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_m_roles`
--
ALTER TABLE `gris_m_roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gris_m_roles_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `gris_p_role_permissions`
--
ALTER TABLE `gris_p_role_permissions`
  ADD PRIMARY KEY (`role_id`,`permission_id`),
  ADD KEY `permission_id` (`permission_id`);

--
-- Indeks untuk tabel `gris_p_user_roles`
--
ALTER TABLE `gris_p_user_roles`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `finance_h_accurate_integration_logs`
--
ALTER TABLE `finance_h_accurate_integration_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=379;

--
-- AUTO_INCREMENT untuk tabel `finance_h_budget_logs`
--
ALTER TABLE `finance_h_budget_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `finance_m_banks`
--
ALTER TABLE `finance_m_banks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- AUTO_INCREMENT untuk tabel `finance_m_budgets`
--
ALTER TABLE `finance_m_budgets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `finance_m_chart_of_accounts`
--
ALTER TABLE `finance_m_chart_of_accounts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=406;

--
-- AUTO_INCREMENT untuk tabel `finance_m_source_accounts`
--
ALTER TABLE `finance_m_source_accounts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `finance_t_fund_payment_attachments`
--
ALTER TABLE `finance_t_fund_payment_attachments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `finance_t_fund_requests`
--
ALTER TABLE `finance_t_fund_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT untuk tabel `finance_t_fund_request_attachments`
--
ALTER TABLE `finance_t_fund_request_attachments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `finance_t_fund_request_report_attachments`
--
ALTER TABLE `finance_t_fund_request_report_attachments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `finance_t_journal_details`
--
ALTER TABLE `finance_t_journal_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `finance_t_journal_entries`
--
ALTER TABLE `finance_t_journal_entries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `gris_m_actions`
--
ALTER TABLE `gris_m_actions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `gris_m_apps`
--
ALTER TABLE `gris_m_apps`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `gris_m_app_modules`
--
ALTER TABLE `gris_m_app_modules`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `gris_m_branches`
--
ALTER TABLE `gris_m_branches`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- AUTO_INCREMENT untuk tabel `gris_m_companies`
--
ALTER TABLE `gris_m_companies`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `gris_m_departments`
--
ALTER TABLE `gris_m_departments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `gris_m_job_levels`
--
ALTER TABLE `gris_m_job_levels`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `gris_m_permissions`
--
ALTER TABLE `gris_m_permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `gris_m_positions`
--
ALTER TABLE `gris_m_positions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT untuk tabel `gris_m_regions`
--
ALTER TABLE `gris_m_regions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `gris_m_roles`
--
ALTER TABLE `gris_m_roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `gris_p_user_roles`
--
ALTER TABLE `gris_p_user_roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `gris_m_branches`
--
ALTER TABLE `gris_m_branches`
  ADD CONSTRAINT `m_branch_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `gris_m_regions` (`id`);
COMMIT;

