=== DESCRIBE llx_agentcompta_match ===
rowid                  int              null=NO   def=NULL
entity                 int              null=NO   def=1
fk_intake              int              null=YES  def=NULL
fk_bank_account        int              null=YES  def=NULL
bank_line_date         date             null=YES  def=NULL
bank_line_label        varchar(500)     null=YES  def=NULL
bank_line_amount       decimal(12,2)    null=YES  def=NULL
bank_line_ref          varchar(100)     null=YES  def=NULL
fk_bank_line           int              null=YES  def=NULL
target_type            varchar(30)      null=YES  def=NULL
fk_target              int              null=YES  def=NULL
target_label           varchar(255)     null=YES  def=NULL
grouped_targets        text             null=YES  def=NULL
match_score            decimal(5,4)     null=YES  def=NULL
match_reason           text             null=YES  def=NULL
is_partial             tinyint(1)       null=YES  def=0
suggested_amount       decimal(12,2)    null=YES  def=NULL
status                 varchar(20)      null=NO   def=proposed
fk_user_decided        int              null=YES  def=NULL
date_decided           datetime         null=YES  def=NULL
date_creation          datetime         null=YES  def=NULL
tms                    timestamp        null=NO   def=CURRENT_TIMESTAMP
fk_payment             int              null=YES  def=NULL

=== status counts ===
validated            n=77     2026-08-05 -> 2026-10-17  somme=-12898.91
proposed             n=17     2026-08-13 -> 2026-10-21  somme=-1889.82
auto_validated       n=3      2026-08-18 -> 2026-10-19  somme=-2377.94
rejected             n=2      2026-08-31 -> 2026-09-02  somme=0.00

=== total + remplissage fk_bank_line / fk_payment ===
stdClass Object
(
    [tot] => 99
    [nbl] => 77
    [npay] => 67
    [ntgt] => 99
)

=== target_type ===
aucun                12
facture_client       16
facture_fourn        37
frais_bancaires      1
groupe_client        8
groupe_fourn         3
prelevement_recurrent 6
recurrent            14
tva                  1
urssaf               1