== llx_agentcompta_match ==
rowid int
entity int
fk_intake int
fk_bank_account int
bank_line_date date
bank_line_label varchar(500)
bank_line_amount decimal(12,2)
bank_line_ref varchar(100)
fk_bank_line int
target_type varchar(30)
fk_target int
target_label varchar(255)
grouped_targets text
match_score decimal(5,4)
match_reason text
is_partial tinyint(1)
suggested_amount decimal(12,2)
status varchar(20)
fk_user_decided int
date_decided datetime
date_creation datetime
tms timestamp
fk_payment int
== llx_bank_account ==
rowid int
datec datetime
tms timestamp
ref varchar(12)
label varchar(50)
entity int
fk_user_author int
fk_user_modif int
bank varchar(60)
code_banque varchar(128)
code_guichet varchar(6)
number varchar(255)
cle_rib varchar(5)
bic varchar(11)
bic_intermediate varchar(11)
iban_prefix varchar(80)
country_iban varchar(2)
cle_iban varchar(2)
domiciliation varchar(255)
pti_in_ctti smallint
state_id int
fk_pays int
proprio varchar(60)
owner_address varchar(255)
owner_zip varchar(25)
owner_town varchar(50)
owner_country_id int
courant smallint
clos smallint
rappro smallint
url varchar(128)
account_number varchar(32)
fk_accountancy_journal int
currency_code varchar(3)
min_allowed int
min_desired int
comment text
note_public text
model_pdf varchar(255)
import_key varchar(14)
extraparams varchar(255)
ics varchar(32)
ics_transfer varchar(32)
== bank_account rows ==
1 | Tekni-pli | Compte Courant | clos=0
2 | HIST25 | Historique 2025 (exercice clos) — ne pas utiliser | clos=1