=== 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=351    2026-01-04 -> 2026-08-07  somme=-9015.85
rejected             n=3      2026-03-12 -> 2026-04-30  somme=1536.00

=== total + remplissage fk_bank_line / fk_payment ===
stdClass Object
(
    [tot] => 354
    [nbl] => 0
    [npay] => 117
    [ntgt] => 354
)

=== target_type ===
apport_cca           2
aucun                99
facture_client       53
facture_fourn        120
groupe_client        1
groupe_fourn         5
groupe_propal        2
impot                1
prelevement_recurrent 37
recurrent            25
salaire              1
tva                  5
virement_interne     3