{
"_links": {
"aging_global": "/api/suppliers/aging?as_of=2026-05-13&bucket_type=standard",
"self": "/api/payables/to-pay?as_of=2026-05-13&days_to_due_max=7&include_overdue=true&bucket_type=standard"
},
"as_of_date": "2026-05-13",
"cache": {
"age_seconds": 0,
"cached_at": "2026-05-13T17:00:00-04:00",
"expires_at": "2026-05-13T21:00:00-04:00",
"force_refreshed": false,
"key_hash": "sha1:abc...",
"status": "miss",
"ttl_policy": "current_period_4h",
"ttl_remaining_seconds": 14400
},
"filter": {
"bucket_type": "standard",
"days_to_due_max": 7,
"include_overdue": true,
"include_zero_balance": false,
"limit": 500,
"sort_by": "days_to_due_asc"
},
"items": [
{
"_links": {
"invoice_detail": "/api/suppliers/invoices-ap/by-id/4801",
"supplier_overview": "/api/suppliers/by-id/7/overview",
"supplier_statement": "/api/suppliers/by-id/7/statement?from=2025-05-13&to=2026-05-13"
},
"amount_original": 12500,
"amount_paid": 0,
"amount_remaining": 12500,
"bucket": "days_0_30",
"days_to_due": -29,
"due_date": "2026-04-14",
"invoice": {
"code": "F-87521",
"date": "2026-03-15",
"id": 4801,
"reference": "BC-22198",
"transaction_type": {
"code": "invoice",
"id": 2,
"label": "Facture"
}
},
"is_credit": false,
"is_overdue": true,
"supplier": {
"code": "HERCULE",
"id": 7,
"name": "Hercule Construction"
}
}
],
"metadata": {
"extracted_at": "2026-05-13T17:00:00-04:00",
"limit_applied": 500,
"organisation_id": "constructions_jimmy_roy",
"scope": "open_invoices_only",
"sdk_indexes_used": {
"invoice_ap": [
3,
9
],
"payment_line_ap": 1
},
"suppliers_scanned": 42,
"truncated": false
},
"summary": {
"aging_percentages": {
"days_0_30": 24.3,
"days_30_60": 43.8,
"days_60_90": 18.9,
"days_over_90": 9.2
},
"aging_summary": {
"days_0_30": 21150,
"days_30_60": 38200,
"days_60_90": 16500,
"days_over_90": 8000
},
"credits_amount": 3350,
"credits_count": 1,
"currency": "CAD",
"due_within_7d_amount": 100300,
"due_within_7d_count": 14,
"invoices_due_amount": 187500,
"invoices_due_count": 28,
"net_to_pay": 184150,
"overdue_amount": 87200,
"overdue_count": 14,
"suppliers_count": 12,
"total_amount": 184150,
"total_invoices": 29
}
}