{"data":[{"id":"0e0be327-52c3-4aac-953d-dc08f20544cd","notes":"Event invoice for First Step Program","amount":800,"status":"draft","paid_at":null,"pdf_url":null,"sent_at":null,"due_date":"2026-08-22","subtotal":800,"tax_rate":0,"contact_id":"3f81d7b7-f082-430c-b608-694cd4c72ac7","created_at":"2026-08-15T22:33:56.681769+00:00","created_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","invoice_id":"BP-2026-236629","line_items":[{"amount":800,"description":"Small Coquito Icey samples"}],"tax_amount":0,"updated_at":"2026-09-17T20:28:51.588056+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-08-15","customer_name":"Mohawk Valley Community College","document_kind":"invoice","payment_terms":null,"pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"766cfaa7-ac42-46c8-bbef-69d13268a29d","customer_email":null,"document_subtype":"standard","event_booking_id":"ffcc4a95-5b69-4aea-b912-ea0b5aa2fa47","payment_provider":null,"document_metadata":{},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":"3f81d7b7-f082-430c-b608-694cd4c72ac7","payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"385f3582-1b06-5a13-85b5-ad36fa03d401","notes":"Sample demo estimate — awaiting customer approval.","amount":265,"status":"draft","paid_at":null,"pdf_url":null,"sent_at":null,"due_date":"2026-09-03","subtotal":265,"tax_rate":0,"contact_id":"385f3582-1b06-5a13-85b5-ad36fa03b401","created_at":"2026-08-30T16:33:19.062332+00:00","created_by":null,"invoice_id":"DEMO-EST-1001","line_items":[{"rate":205,"quantity":1,"description":"Living room + hallway carpet cleaning"},{"rate":60,"quantity":1,"description":"Pet-odor treatment"}],"tax_amount":0,"updated_at":"2026-09-17T20:28:51.588056+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-08-31","customer_name":"Maria Demo","document_kind":"invoice","payment_terms":"Due on completion","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"385f3582-1b06-5a13-85b5-ad36fa03b397","customer_email":"maria.demo@example.com","document_subtype":"standard","event_booking_id":null,"payment_provider":null,"document_metadata":{},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":"385f3582-1b06-5a13-85b5-ad36fa03b401","payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"385f3582-1b06-5a13-85b5-ad36fa03d402","notes":"Sample demo invoice — scheduled job, payment due after service.","amount":189,"status":"sent","paid_at":null,"pdf_url":null,"sent_at":null,"due_date":"2026-09-02","subtotal":189,"tax_rate":0,"contact_id":"385f3582-1b06-5a13-85b5-ad36fa03b402","created_at":"2026-08-29T16:33:19.062332+00:00","created_by":null,"invoice_id":"DEMO-INV-1002","line_items":[{"rate":189,"quantity":1,"description":"Move-out carpet cleaning — 2 bedrooms + stairs"}],"tax_amount":0,"updated_at":"2026-09-17T20:28:51.588056+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-08-30","customer_name":"David Demo","document_kind":"invoice","payment_terms":"Due on completion","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"385f3582-1b06-5a13-85b5-ad36fa03b397","customer_email":"david.demo@example.com","document_subtype":"standard","event_booking_id":null,"payment_provider":null,"document_metadata":{},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":"385f3582-1b06-5a13-85b5-ad36fa03b402","payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"385f3582-1b06-5a13-85b5-ad36fa03d403","notes":"Sample demo invoice — completed and paid; good repeat-service candidate.","amount":420,"status":"paid","paid_at":"2026-08-30T20:33:19.062332+00:00","pdf_url":null,"sent_at":null,"due_date":"2026-08-30","subtotal":420,"tax_rate":0,"contact_id":"385f3582-1b06-5a13-85b5-ad36fa03b403","created_at":"2026-08-28T16:33:19.062332+00:00","created_by":null,"invoice_id":"DEMO-INV-1003","line_items":[{"rate":210,"quantity":2,"description":"Turnover carpet cleaning — 2 sample units"}],"tax_amount":0,"updated_at":"2026-09-17T20:28:51.588056+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-08-29","customer_name":"Sunrise Property Demo","document_kind":"invoice","payment_terms":"Due on completion","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"385f3582-1b06-5a13-85b5-ad36fa03b397","customer_email":"leasing.demo@example.com","document_subtype":"standard","event_booking_id":null,"payment_provider":null,"document_metadata":{},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":"385f3582-1b06-5a13-85b5-ad36fa03b403","payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"9957c5ec-6372-4fdf-b504-fe3f94579f8e","notes":"DEMO ONLY - simulated paid invoice; no charge or transfer occurred.","amount":12239.06,"status":"paid","paid_at":"2026-08-21T23:14:14.731873+00:00","pdf_url":null,"sent_at":null,"due_date":"2026-08-21","subtotal":11438.37,"tax_rate":7,"contact_id":"03f3c255-cd5b-470e-81ab-27ad7195074a","created_at":"2026-08-17T23:14:14.731873+00:00","created_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","invoice_id":"RF-DEMO-INV-1001","line_items":[{"amount":12239.06,"quantity":1,"unit_price":12239.06,"description":"Architectural shingle roof replacement"}],"tax_amount":800.69,"updated_at":"2026-08-31T23:14:14.731873+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":"DEMO-CLAIM-1001","invoice_date":"2026-08-17","customer_name":"DEMO - Carter Residence","document_kind":"invoice","payment_terms":"Paid in demo record","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","customer_email":"redfish.golden@example.com","document_subtype":"standard","event_booking_id":null,"payment_provider":"demo","document_metadata":{},"insurance_carrier":"DEMO carrier","source_proposal_id":null,"canonical_contact_id":"03f3c255-cd5b-470e-81ab-27ad7195074a","payment_provider_status":"simulated_no_charge","payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"336c4b88-3cc6-410c-9a7e-5a97eb8e2aa4","notes":"DEMO ONLY - outstanding invoice; it was not emailed and has no payment link.","amount":14140,"status":"sent","paid_at":null,"pdf_url":null,"sent_at":null,"due_date":"2026-09-07","subtotal":14140,"tax_rate":0,"contact_id":"f383cefb-b208-47f5-9860-29f98cfd4dbb","created_at":"2026-08-31T23:14:14.731873+00:00","created_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","invoice_id":"RF-DEMO-INV-1002","line_items":[{"amount":14140,"quantity":1,"unit_price":14140,"description":"Roof replacement balance"}],"tax_amount":0,"updated_at":"2026-08-31T23:14:14.731873+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-08-31","customer_name":"DEMO - Collins Active Installation","document_kind":"invoice","payment_terms":"Due on completion","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","customer_email":"redfish.active@example.com","document_subtype":"standard","event_booking_id":null,"payment_provider":"demo","document_metadata":{},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":"f383cefb-b208-47f5-9860-29f98cfd4dbb","payment_provider_status":"not_sent","payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"35b80b3a-7cd2-4ddf-a87b-865793f2bac8","notes":"Starter order request for Pizza Boys. Quantities are confirmed before invoicing. No payment is due until the order is confirmed.","amount":0,"status":"draft","paid_at":null,"pdf_url":null,"sent_at":null,"due_date":null,"subtotal":0,"tax_rate":0,"contact_id":"2e3c4d76-baef-498c-b3ec-f4b4d128ad7e","created_at":"2026-09-15T14:08:23.170945+00:00","created_by":null,"invoice_id":"BP-2026-303188","line_items":[{"rate":2.25,"amount":0,"source":"product","quantity":0,"description":"Push Pop","package_size":"push_pop","package_label":"Push Pop"},{"rate":7,"amount":0,"source":"product","quantity":0,"description":"Pint (16 oz)","package_size":"pint","package_label":"Pint (16 oz)"},{"rate":12,"amount":0,"source":"product","quantity":0,"description":"Half Gallon","package_size":"half_gallon","package_label":"Half Gallon"}],"tax_amount":0,"updated_at":"2026-09-17T20:28:51.588056+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-09-15","customer_name":"Pizza Boys","document_kind":"order_request","payment_terms":"No payment due until confirmed","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"766cfaa7-ac42-46c8-bbef-69d13268a29d","customer_email":null,"document_subtype":"standard","event_booking_id":null,"payment_provider":null,"document_metadata":{},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":null,"payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"d256f923-207d-4b17-97cc-387b3b55592f","notes":"PROOF fee invoice tracking exists for the demo PA claim file","amount":48500,"status":"sent","paid_at":null,"pdf_url":null,"sent_at":"2026-07-04T17:54:18.149269+00:00","due_date":"2026-07-18","subtotal":48500,"tax_rate":0,"contact_id":"encore-pa-proof-20260704-001","created_at":"2026-07-04T17:54:18.149269+00:00","created_by":null,"invoice_id":"ENCORE-PA-DEMO-INV-001","line_items":[],"tax_amount":0,"updated_at":"2026-07-04T17:54:18.149269+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":"CLM-DEMO-PA-001","invoice_date":"2026-07-04","customer_name":"Demo Policyholder","document_kind":"invoice","payment_terms":"10 percent PA fee due on settlement proceeds, demo invoice for proof only","pdf_file_path":null,"policy_number":"POL-DEMO-PA-001","render_bucket":null,"tenant_org_id":"fe5cc9d9-c2fe-4062-84c7-a334663cd63c","customer_email":null,"document_subtype":"settlement","event_booking_id":null,"payment_provider":null,"document_metadata":{"zip":"32901","city":"Melbourne","state":"FL","rep_name":"Encore Demo Adjuster","rep_email":"adjuster@example.test","rep_phone":"3215550100","invoice_html":"<p>Demo Encore PA fee invoice.</p>","template_tone":"Standard","deposit_amount":0,"homeowner_name":"Demo Policyholder","original_total":4850,"property_address":"100 Demo Claim Way","insurance_payment":0,"remaining_balance":4850,"settlement_amount":48500,"settlement_discount":0},"insurance_carrier":"Demo Mutual Insurance","source_proposal_id":null,"canonical_contact_id":null,"payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null},{"id":"db87fbb0-9e0c-437a-92ea-28acffd61878","notes":"Redfish demo retail roofing receivable tied to the existing production project.","amount":17640,"status":"sent","paid_at":null,"pdf_url":null,"sent_at":"2026-09-01T19:13:04.890644+00:00","due_date":"2026-09-14","subtotal":17640,"tax_rate":0,"contact_id":"f383cefb-b208-47f5-9860-29f98cfd4dbb","created_at":"2026-09-01T19:13:04.890644+00:00","created_by":null,"invoice_id":"RF-DEMO-RET-001","line_items":[],"tax_amount":0,"updated_at":"2026-09-01T19:13:04.890644+00:00","payment_url":null,"render_hash":null,"rendered_at":null,"claim_number":null,"invoice_date":"2026-08-30","customer_name":"DEMO - Collins Active Installation","document_kind":"invoice","payment_terms":"Balance due upon substantial completion.","pdf_file_path":null,"policy_number":null,"render_bucket":null,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","customer_email":null,"document_subtype":"settlement","event_booking_id":null,"payment_provider":null,"document_metadata":{"zip":"32780","city":"Titusville","state":"FL","rep_name":null,"rep_email":null,"rep_phone":null,"invoice_html":"","template_tone":"Standard","deposit_amount":3500,"homeowner_name":"DEMO - Collins Active Installation","original_total":17640,"property_address":"150 Redfish Demo Way","insurance_payment":0,"remaining_balance":14140,"settlement_amount":17640,"settlement_discount":0},"insurance_carrier":null,"source_proposal_id":null,"canonical_contact_id":"f383cefb-b208-47f5-9860-29f98cfd4dbb","payment_provider_status":null,"payment_provider_link_id":null,"payment_provider_order_id":null,"payment_provider_payment_id":null}],"rows":9,"limit":200,"table":"invoices","format":"knocklaunch-table-chunk-v1","offset":0,"schema":"public"}