{"ok":true,"success":true,"canonical":true,"marker":"CODEX780_REPORTING_BI_AUDIT_COMPLIANCE_COMPLETION","sourceTruth":"latest CODEX775 truth only","version":"codex780-reporting-bi-audit-compliance-completion-v1","routeOwner":"backend/server.js","frontendRoot":"frontend/app","forbiddenFrontendRoot":"frontend/src/app","tradeCoreJs":"NOT_RECREATED_NOT_TOUCHED","route":"/api/trade-core/erp/reporting-bi-audit-compliance-completion/dashboard","key":"dashboard","label":"Reporting BI audit compliance dashboard","routes":["/api/trade-core/erp/reporting-bi-audit-compliance-completion/readiness","/api/trade-core/erp/reporting-bi-audit-compliance-completion/dashboard","/api/trade-core/erp/reporting-bi-audit-compliance-completion/cfo-ceo-dashboards","/api/trade-core/erp/reporting-bi-audit-compliance-completion/erp-reports","/api/trade-core/erp/reporting-bi-audit-compliance-completion/marketplace-reports","/api/trade-core/erp/reporting-bi-audit-compliance-completion/audit-trail","/api/trade-core/erp/reporting-bi-audit-compliance-completion/compliance-evidence","/api/trade-core/erp/reporting-bi-audit-compliance-completion/document-readiness","/api/trade-core/erp/reporting-bi-audit-compliance-completion/kpi-rollups","/api/trade-core/erp/reporting-bi-audit-compliance-completion/export-tables","/api/trade-core/erp/reporting-bi-audit-compliance-completion/missing-report-gaps"],"status":"REPORTING_BI_AUDIT_COMPLIANCE_COMPLETE","readOnly":true,"selectOnly":true,"noDbSchemaChange":true,"noDbMutation":true,"noFakeCompletion":true,"noFakeBusinessData":true,"noBusinessDataMutation":true,"noReportWriteAutomation":true,"noExportMutation":true,"noDocumentMutation":true,"noAuditMutation":true,"noComplianceMutation":true,"noWorkflowMutation":true,"noInvoiceMutation":true,"noAccountingPostingMutation":true,"noMoneyMovement":true,"noExternalApiCall":true,"noAutomationEnablement":true,"automationEnabled":false,"noSchedulerEnablement":true,"noDuplicateRoutes":true,"duplicateRoutes":[],"reportsCompleted":[{"key":"cfo_ceo_dashboards","label":"CFO/CEO dashboards","sourceRouteCount":4,"sourceTableCount":5},{"key":"erp_reports","label":"ERP reports","sourceRouteCount":5,"sourceTableCount":5},{"key":"marketplace_reports","label":"Marketplace reports","sourceRouteCount":4,"sourceTableCount":3},{"key":"audit_trail","label":"Audit trail","sourceRouteCount":5,"sourceTableCount":3},{"key":"compliance_evidence","label":"Compliance evidence","sourceRouteCount":5,"sourceTableCount":4},{"key":"document_readiness","label":"Document readiness","sourceRouteCount":4,"sourceTableCount":4},{"key":"kpi_rollups","label":"KPI rollups","sourceRouteCount":5,"sourceTableCount":6},{"key":"export_tables","label":"Export-ready tables","sourceRouteCount":4,"sourceTableCount":6}],"reportReadbacks":[{"key":"cfo_ceo_dashboards","label":"CFO/CEO dashboards","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/erp/executive-dashboards/readiness","/api/trade-core/erp/executive-dashboards/ceo-dashboard/readback","/api/trade-core/erp/executive-dashboards/cfo-dashboard/readback","/api/trade-core/erp/bi/dashboard-readbacks/executive-kpi-readiness"],"missingSourceRoutes":[],"sourceTables":["erp_journal_headers","erp_journal_lines","erp_invoices","erp_receipts","trade_wallet_ledger"],"tableSummary":{"tableCount":5,"existingTableCount":5,"populatedTableCount":5,"missingTableCount":0,"rowCountTotal":311,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"erp_reports","label":"ERP reports","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/erp/reporting-center/readiness","/api/trade-core/erp/reporting-center/dashboard","/api/trade-core/erp/reporting-center/templates","/api/trade-core/erp/reporting/export-readiness","/api/trade-core/erp/accounting-posting-engine/journal-lines"],"missingSourceRoutes":[],"sourceTables":["erp_journal_headers","erp_journal_lines","erp_vendor_ledger","erp_invoices","erp_purchase_orders"],"tableSummary":{"tableCount":5,"existingTableCount":5,"populatedTableCount":5,"missingTableCount":0,"rowCountTotal":224,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"marketplace_reports","label":"Marketplace reports","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/listings/:moduleKey","/api/trade-core/comparison/:moduleKey","/api/rfq/analytics","/api/trade-core/erp/final-hardening/api-consistency/marketplace-api-consistency"],"missingSourceRoutes":[],"sourceTables":["trade_orders","trade_activity_log","trade_documents"],"tableSummary":{"tableCount":3,"existingTableCount":3,"populatedTableCount":3,"missingTableCount":0,"rowCountTotal":302,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"audit_trail","label":"Audit trail","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/erp/audit-timeline","/api/trade-core/erp/audit-dashboard","/api/trade-core/erp/audit-evidence-catalog","/api/trade-core/erp/workflow-rbac/timeline","/api/trade-core/erp/finance-chain-replay-audit"],"missingSourceRoutes":[],"sourceTables":["trade_activity_log","ach_admin_audit_trail","erp_workflow_events"],"tableSummary":{"tableCount":3,"existingTableCount":3,"populatedTableCount":3,"missingTableCount":0,"rowCountTotal":79,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"compliance_evidence","label":"Compliance evidence","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/documents/compliance/readiness","/api/trade-core/erp/compliance/readiness","/api/trade-core/erp/document-payment-logistics-compliance/readiness","/api/trade-core/erp/final-operation-depth/compliance-document-evidence/readiness","/api/trade-core/erp/tax/statutory-compliance-evidence/readiness"],"missingSourceRoutes":[],"sourceTables":["trade_documents","erp_invoices","erp_purchase_receipts","trade_activity_log"],"tableSummary":{"tableCount":4,"existingTableCount":4,"populatedTableCount":4,"missingTableCount":0,"rowCountTotal":170,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"document_readiness","label":"Document readiness","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/documents/foundation","/api/trade-core/documents/admin/readiness","/api/trade-core/documents/compliance/readiness","/api/trade-core/erp/document-payment-logistics-compliance/readiness"],"missingSourceRoutes":[],"sourceTables":["trade_documents","erp_invoices","erp_purchase_orders","erp_purchase_receipts"],"tableSummary":{"tableCount":4,"existingTableCount":4,"populatedTableCount":4,"missingTableCount":0,"rowCountTotal":120,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"kpi_rollups","label":"KPI rollups","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/erp/enterprise-kpi-dashboard","/api/trade-core/erp/kpi-summary","/api/trade-core/erp/business-integration-final/kpis","/api/trade-core/erp/reporting/kpi-dashboard","/api/trade-core/erp/reporting/kpi-export-cfo-dashboard-evidence/readiness"],"missingSourceRoutes":[],"sourceTables":["erp_journal_headers","erp_journal_lines","trade_inventory_snapshots","erp_inventory_movement_ledger","erp_production_batches","erp_purchase_orders"],"tableSummary":{"tableCount":6,"existingTableCount":6,"populatedTableCount":6,"missingTableCount":0,"rowCountTotal":263,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]},{"key":"export_tables","label":"Export-ready tables","status":"REPORT_READBACK_READY","sourceRoutes":["/api/trade-core/erp/reporting-center/export-queue","/api/trade-core/erp/reporting-center/pdf-queue","/api/trade-core/erp/reporting/export-readiness","/api/trade-core/erp/final-operation-depth/reporting-export-evidence/readiness"],"missingSourceRoutes":[],"sourceTables":["erp_journal_headers","erp_journal_lines","erp_invoices","erp_vendor_ledger","erp_inventory_movement_ledger","trade_documents"],"tableSummary":{"tableCount":6,"existingTableCount":6,"populatedTableCount":6,"missingTableCount":0,"rowCountTotal":315,"warningCount":0,"readinessPercent":100,"status":"ERP_BUSINESS_CHAIN_EXECUTION_READBACK_READY","warnings":[]},"gaps":[]}],"reportingBiAuditComplianceAggregate":{"reportCount":8,"completedReportCount":8,"gapCount":0,"tableCount":36,"existingTableCount":36,"populatedTableCount":36,"missingTableCount":0,"rowCountTotal":1784,"readinessPercent":100,"status":"REPORTING_BI_AUDIT_COMPLIANCE_COMPLETE"},"missingReportGaps":[],"requestReadback":{"method":"GET","queryKeys":[],"limit":5},"payloadFocus":"reportingBiAuditComplianceAggregate","generatedAt":"2026-07-17T06:47:56.120Z"}