-- Synthetic records only. Load using a database administrator/ingestion login. INSERT INTO fg_finance.inputs(client_id,kind,source_id,revision,payload) VALUES ('demo-client','invoice-review','invoice-demo-001','1','{"currency":"CAD","province":"ON","place_of_supply_confirmed":true,"tax_treatment":"standard","date":"2026-10-25","destination":"review","lines":[{"description":"Example service","amount":100}],"document_total":113,"file":{"bytes":10000,"mime":"application/pdf","pages":1,"extraction_reviewed":true}}'), ('demo-client','overdue-reminders','invoice-demo-002','1','{"currency":"CAD","invoice_number":"DEMO-002","due_date":"2026-10-01","balance":113,"reminders_sent":0,"disputed":false,"do_not_contact":false,"email":"test@example.com"}'), ('demo-client','missing-documents','client-demo-2025-checklist','1','{"tax_year":2025,"approved_checklist":["T4","approved expense summary"],"received_documents":["T4"],"email":"test@example.com","secure_upload_url":"https://example.com/secure-portal"}'), ('demo-client','reconciliation','bank-demo-2026-10','1','{"currency":"CAD","bank":[{"id":"B1","reference":"REF1","date":"2026-10-25","amount":113}],"ledger":[{"id":"L1","reference":"REF1","date":"2026-10-25","amount":113}]}'), ('demo-client','payroll-checks','payroll-demo-2026-10','1','{"currency":"CAD","employees":[{"id":"E1","gross_pay":3000,"previous_gross_pay":2000,"hours":80}]}'), ('demo-client','financial-report','report-demo-2026-10','1','{"rows":[{"currency":"CAD","revenue":1000,"expense":400,"tax_collected":130,"tax_paid":52,"budget":350}]}'), ('demo-client','deadline-alerts','filing-demo-2026-10','1','{"label":"Demonstration obligation only","due_date":"2026-10-31","deadline_confirmed":true,"authority_url":"https://www.canada.ca/","email":"test@example.com"}'), ('demo-client','timesheet-reminders','employee-demo-period-2026-10-23','1','{"active":true,"submitted":false,"period_end":"2026-10-23","email":"test@example.com"}') ON CONFLICT(client_id,kind,source_id,revision) DO NOTHING;