--- COLS match
{"Field":"rowid","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"entity","Type":"int","Null":"NO","Key":"MUL","Default":"1","Extra":""}
{"Field":"fk_intake","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"fk_bank_account","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"bank_line_date","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"bank_line_label","Type":"varchar(500)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"bank_line_amount","Type":"decimal(12,2)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"bank_line_ref","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_bank_line","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"target_type","Type":"varchar(30)","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"fk_target","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"target_label","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"grouped_targets","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"match_score","Type":"decimal(5,4)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"match_reason","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"is_partial","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"suggested_amount","Type":"decimal(12,2)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"status","Type":"varchar(20)","Null":"NO","Key":"","Default":"proposed","Extra":""}
{"Field":"fk_user_decided","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_decided","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_creation","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"tms","Type":"timestamp","Null":"NO","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}
{"Field":"fk_payment","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
--- PAIEMENTS FOURN 2026 par annee de facture
{"an":"2026","fk_statut":"2","n":"178","montant":"205103.76000000"}
--- FACTURES FOURN < 2026
{"n":"0","ht":null,"ttc":null}
--- FACTURES CLIENT < 2026
{"n":"115","ht":"172129.48000000"}