== 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] => ecadca7b-8dd0-4a76-861f-bf95b4d88088
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.sKauHfZ+/IjmI3KIiKjzaLEWfO+8y0Hn6w3hCPUHLYk=
    [iban] => FR7616606000242422500600113
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 380733d8-3fe6-4cb7-a3ac-b5f407c31656
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-20
    [balance] => 2879.64
    [balance_date] => 2026-08-08 18:15:09
    [pending_json] => []
    [last_sync] => 2026-08-08 18:15:09
    [last_attempt] => 2026-10-21 13:45:30
    [last_status] => unmapped
    [last_error] => Aucun compte Dolibarr associé — association requise avant synchro.
    [status] => active
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-10-21 13:45:28
)

stdClass Object
(
    [rowid] => 2
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => ff5c5bb9-f32d-4504-9e84-44af5159d4a2
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.r3jsYzShRPex8JsAo26YeYGIH6DmjERh2mTh8wrLySw=
    [iban] => FR7616606052138488109336679
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 380733d8-3fe6-4cb7-a3ac-b5f407c31656
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-20
    [balance] => 13290.31
    [balance_date] => 2026-08-08 18:15:10
    [pending_json] => []
    [last_sync] => 2026-08-08 18:15:10
    [last_attempt] => 2026-10-21 13:45:30
    [last_status] => unmapped
    [last_error] => Aucun compte Dolibarr associé — association requise avant synchro.
    [status] => active
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-10-21 13:45:28
)

stdClass Object
(
    [rowid] => 3
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => c4eccb6d-f1cd-4cee-ad8f-20cbae2905f1
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.8f5lBEVa0f+M/S9ZxBbDCiG2ALtB9yjEt3Nr4DJN6HY=
    [iban] => FR7616606450110016774587631
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 380733d8-3fe6-4cb7-a3ac-b5f407c31656
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-20
    [balance] => 84848.40
    [balance_date] => 2026-08-08 18:15:12
    [pending_json] => []
    [last_sync] => 2026-08-08 18:17:13
    [last_attempt] => 2026-10-21 13:45:30
    [last_status] => unmapped
    [last_error] => Aucun compte Dolibarr associé — association requise avant synchro.
    [status] => active
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-10-21 13:45:28
)

stdClass Object
(
    [rowid] => 4
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => 698c4bd7-4996-4893-b220-ac9557bcd20d
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.rui56mHCReFnyDQz8GgHIh18cclpuAxcoUol05iwAxQ=
    [iban] => FR7616606050118489487333640
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => a8008cda-fea9-4ffe-8b6d-8d08c6cb830b
    [reference] => eb
    [fk_bank_account] => 1
    [consent_expiration] => 2026-11-22
    [balance] => 12723.73
    [balance_date] => 2026-10-21 13:45:38
    [pending_json] => [{"_solde":{"nature":"CLBD","comptabilise":12723.73,"disponible":12723.73,"releve_le":"2026-10-21 13:45:38"}}]
    [last_sync] => 2026-10-21 13:45:41
    [last_attempt] => 2026-10-21 13:45:41
    [last_status] => ok
    [last_error] => 
    [status] => active
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-10-21 13:45:40
)

stdClass Object
(
    [rowid] => 5
    [entity] => 1
    [provider] => enablebanking
    [gc_account_id] => 105743bc-aba7-477a-8794-d08f3ad9b912
    [ext_hash] => WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.wQhNFJVR3nCtGPZOVCu7TvTikFyOaseILRp5CIh5cnY=
    [iban] => FR7616606050118490472149129
    [institution_id] => Crédit Agricole de Normandie
    [institution_name] => Crédit Agricole de Normandie
    [requisition_id] => 380733d8-3fe6-4cb7-a3ac-b5f407c31656
    [reference] => eb
    [fk_bank_account] => 
    [consent_expiration] => 2026-11-20
    [balance] => 149.76
    [balance_date] => 2026-08-08 18:17:15
    [pending_json] => []
    [last_sync] => 2026-08-08 18:17:15
    [last_attempt] => 2026-10-21 13:45:41
    [last_status] => unmapped
    [last_error] => Aucun compte Dolibarr associé — association requise avant synchro.
    [status] => active
    [date_creation] => 2026-08-08 11:55:09
    [tms] => 2026-10-21 13:45:40
)