{"$schema":"https://json-schema.org/draft/2020-12/schema","title":"Aged Payables — Balance fournisseurs âgée (BE)","description":"Belgian aged payables report per Loi 2.8.2002 (Directive 2011/7/EU). Ageing buckets: 0-30, 31-60, 61-90, >90, disputed. PCMN account 44.","type":"object","additionalProperties":false,"required":["letter","entity","report_date","suppliers"],"properties":{"letter":{"type":"object","additionalProperties":false,"required":["place","date","language"],"properties":{"place":{"type":"string"},"date":{"type":"string","format":"date"},"language":{"type":"string","enum":["fr","nl","de","en"]},"reference":{"type":"string"}}},"entity":{"type":"object","additionalProperties":false,"required":["name","bce_number"],"properties":{"name":{"type":"string"},"bce_number":{"type":"string","pattern":"^[0-9]{4}\\.[0-9]{3}\\.[0-9]{3}$"},"vat_number":{"type":"string","pattern":"^BE0[0-9]{9}$"},"legal_form":{"type":"string"},"prepared_by":{"type":"string"}}},"report_date":{"type":"string","format":"date","description":"Snapshot date for the ageing analysis."},"late_payment_rate_pct":{"type":"number","description":"Current late payment interest rate (BCE rate + 8 pp, Loi 2.8.2002 Art. 6)."},"suppliers":{"type":"array","description":"One row per supplier with outstanding balance.","items":{"type":"object","additionalProperties":false,"required":["supplier_name","pcmn_account","current","days_31_60","days_61_90","days_over_90","disputed","total"],"properties":{"supplier_name":{"type":"string"},"vat_number":{"type":"string"},"pcmn_account":{"type":"string","description":"PCMN sub-account e.g. 440, 441."},"current":{"type":"number","description":"Outstanding 0-30 days (EUR)."},"days_31_60":{"type":"number","description":"Outstanding 31-60 days (EUR)."},"days_61_90":{"type":"number","description":"Outstanding 61-90 days (EUR)."},"days_over_90":{"type":"number","description":"Outstanding over 90 days (EUR)."},"disputed":{"type":"number","description":"Disputed or legal proceedings (EUR)."},"total":{"type":"number","description":"Total outstanding (EUR)."},"credit_limit":{"type":"number","description":"Agreed credit limit (EUR)."},"notes":{"type":"string"}}}},"totals":{"type":"object","additionalProperties":false,"description":"Column totals for ageing buckets.","properties":{"current":{"type":"number"},"days_31_60":{"type":"number"},"days_61_90":{"type":"number"},"days_over_90":{"type":"number"},"disputed":{"type":"number"},"total":{"type":"number"},"pcmn_44_balance":{"type":"number","description":"PCMN account 44 balance — must equal totals.total."}}}}}