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