== cols gcaccount ==
rowid int
entity int
provider varchar(20)
gc_account_id varchar(255)
ext_hash varchar(128)
iban varchar(34)
institution_id varchar(100)
institution_name varchar(255)
requisition_id varchar(255)
reference varchar(255)
fk_bank_account int
consent_expiration date
balance decimal(15,2)
balance_date datetime
pending_json text
last_sync datetime
last_attempt datetime
last_status varchar(30)
last_error varchar(500)
status varchar(20)
date_creation datetime
tms timestamp
== rows gcaccount ==
stdClass Object
(
    [rowid] => 1
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => a51918bb-dbff-4ece-8177-5de6ecadaca3
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.sKauHfZ+/IjmI3KIiKjzaLEWfO+8y0Hn6w3hCPUHLYk=
    [iban] => FR7616606000242422500600113
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 072de84f-e466-4dcc-a3ab-7b31e7210e67
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-06
    [balance] => 2879.64
    [balance_date] => 2026-08-08 18:15:09
    [pending_json] => []
    [last_sync] => 2026-08-08 18:15:09
    [last_attempt] => 2026-08-09 19:00:04
    [last_status] => unmapped
    [last_error] => Compte coupé le 09/08/2026 : ne appartient pas à TEKNI-PLI (décision de l'artisan).
    [status] => disabled
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-08-09 22:50:08
)

stdClass Object
(
    [rowid] => 2
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => b18c887a-9050-4a33-910c-9b560f73948b
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.r3jsYzShRPex8JsAo26YeYGIH6DmjERh2mTh8wrLySw=
    [iban] => FR7616606052138488109336679
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 072de84f-e466-4dcc-a3ab-7b31e7210e67
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-06
    [balance] => 13290.31
    [balance_date] => 2026-08-08 18:15:10
    [pending_json] => []
    [last_sync] => 2026-08-08 18:15:10
    [last_attempt] => 2026-08-09 19:00:04
    [last_status] => unmapped
    [last_error] => Compte coupé le 09/08/2026 : ne appartient pas à TEKNI-PLI (décision de l'artisan).
    [status] => disabled
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-08-09 22:50:08
)

stdClass Object
(
    [rowid] => 3
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => 52ba1831-6df6-4dda-8fc8-a7f1a76ee2ec
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.8f5lBEVa0f+M/S9ZxBbDCiG2ALtB9yjEt3Nr4DJN6HY=
    [iban] => FR7616606450110016774587631
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 072de84f-e466-4dcc-a3ab-7b31e7210e67
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-06
    [balance] => 84848.40
    [balance_date] => 2026-08-08 18:15:12
    [pending_json] => []
    [last_sync] => 2026-08-08 18:17:13
    [last_attempt] => 2026-08-09 19:00:04
    [last_status] => unmapped
    [last_error] => Compte coupé le 09/08/2026 : ne appartient pas à TEKNI-PLI (décision de l'artisan).
    [status] => disabled
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-08-09 22:50:08
)

stdClass Object
(
    [rowid] => 4
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => 54b37edc-8217-47d6-8026-315789563529
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.rui56mHCReFnyDQz8GgHIh18cclpuAxcoUol05iwAxQ=
    [iban] => FR7616606050118489487333640
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 072de84f-e466-4dcc-a3ab-7b31e7210e67
    [reference] => eb
    [fk_bank_account] => 1
    [consent_expiration] => 2026-11-06
    [balance] => 29521.40
    [balance_date] => 2026-08-10 07:30:14
    [pending_json] => []
    [last_sync] => 2026-08-10 07:30:14
    [last_attempt] => 2026-08-10 07:30:14
    [last_status] => ok
    [last_error] => 
    [status] => active
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-08-10 07:30:14
)

stdClass Object
(
    [rowid] => 5
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => 6ee2422e-694b-4c99-afe5-7a9d0a5f4147
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.wQhNFJVR3nCtGPZOVCu7TvTikFyOaseILRp5CIh5cnY=
    [iban] => FR7616606050118490472149129
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 072de84f-e466-4dcc-a3ab-7b31e7210e67
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-06
    [balance] => 149.76
    [balance_date] => 2026-08-08 18:17:15
    [pending_json] => []
    [last_sync] => 2026-08-08 18:17:15
    [last_attempt] => 2026-08-09 19:00:15
    [last_status] => unmapped
    [last_error] => Compte coupé le 09/08/2026 : ne appartient pas à TEKNI-PLI (décision de l'artisan).
    [status] => disabled
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-08-09 22:50:08
)