cols gcaccount: rowid,entity,provider,gc_account_id,ext_hash,iban,institution_id,institution_name,requisition_id,reference,fk_bank_account,consent_expiration,balance,balance_date,pending_json,last_sync,last_attempt,last_status,last_error,status,date_creation,tms
{"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\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"380733d8-3fe6-4cb7-a3ac-b5f407c31656","reference":"eb","fk_bank_account":null,"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\u00e9 \u2014 association requise avant synchro.","status":"active","date_creation":"2026-08-08 11:55:09","tms":"2026-10-21 13:45:28"}
{"rowid":"2","entity":"1","provider":"enablebanking","gc_account_id":"ff5c5bb9-f32d-4504-9e84-44af5159d4a2","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.r3jsYzShRPex8JsAo26YeYGIH6DmjERh2mTh8wrLySw=","iban":"FR7616606052138488109336679","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"380733d8-3fe6-4cb7-a3ac-b5f407c31656","reference":"eb","fk_bank_account":null,"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\u00e9 \u2014 association requise avant synchro.","status":"active","date_creation":"2026-08-08 11:55:09","tms":"2026-10-21 13:45:28"}
{"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\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"380733d8-3fe6-4cb7-a3ac-b5f407c31656","reference":"eb","fk_bank_account":null,"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\u00e9 \u2014 association requise avant synchro.","status":"active","date_creation":"2026-08-08 11:55:09","tms":"2026-10-21 13:45:28"}
{"rowid":"4","entity":"1","provider":"enablebanking","gc_account_id":"698c4bd7-4996-4893-b220-ac9557bcd20d","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.rui56mHCReFnyDQz8GgHIh18cclpuAxcoUol05iwAxQ=","iban":"FR7616606050118489487333640","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit 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":null,"status":"active","date_creation":"2026-08-08 11:55:09","tms":"2026-10-21 13:45:40"}
{"rowid":"5","entity":"1","provider":"enablebanking","gc_account_id":"105743bc-aba7-477a-8794-d08f3ad9b912","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.wQhNFJVR3nCtGPZOVCu7TvTikFyOaseILRp5CIh5cnY=","iban":"FR7616606050118490472149129","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"380733d8-3fe6-4cb7-a3ac-b5f407c31656","reference":"eb","fk_bank_account":null,"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\u00e9 \u2014 association requise avant synchro.","status":"active","date_creation":"2026-08-08 11:55:09","tms":"2026-10-21 13:45:40"}

=== PAYMENT_VARIOUS FISCAUX ===
2026-01-28 code=44551 sens=0 montant=7014.00000000 TVA CA3 de décembre 2025 — solde la dette d'ouverture
2026-03-25 code=44551 sens=0 montant=2367.00000000 TVA CA3 de mars 2026
2026-05-15 code=444 sens=0 montant=4385.00000000 Impôt sur les sociétés — solde la dette d'ouverture
2026-05-28 code=44551 sens=0 montant=1272.00000000 TVA CA3 de mai 2026
2026-06-17 code=444 sens=0 montant=1096.00000000 Acompte d'impôt sur les sociétés 2026
2026-06-24 code=44551 sens=0 montant=3.00000000 TVA CA3 de juin 2026
2026-08-26 code=44551 sens=0 montant=3617.00000000 DGFiP TVA
2026-09-16 code=444 sens=0 montant=1096.00000000 DGFiP IS
2026-09-29 code=44551 sens=0 montant=5550.00000000 TVA CA3 de septembre 2026 — TVA1-092026

=== PAYMENT_VARIOUS 455 ===
2026-05-18 code=455 sens=1 montant=118.80000000 Compte courant d'associé
2026-05-29 code=455 sens=1 montant=500.00000000 Compte courant d'associé
2026-05-30 code=455 sens=0 montant=500.00000000 Compte courant d'associé
2026-06-23 code=455 sens=1 montant=590.40000000 Compte courant d'associé
2026-06-23 code=455 sens=1 montant=10000.00000000 Compte courant d'associé

=== PAYMENT_LOAN DETAIL ===
2026-01-06 00:00:00 cap=342.77000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-02-05 00:00:00 cap=344.08000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-03-05 00:00:00 cap=345.40000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-04-08 00:00:00 cap=346.72000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-05-05 00:00:00 cap=348.04000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-06-05 00:00:00 cap=349.37000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-07-07 00:00:00 cap=350.71000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-08-05 00:00:00 cap=352.05000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-09-05 00:00:00 cap=353.40000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026
2026-10-05 12:00:00 cap=354.75000000 int=0.00000000 ass=0.00000000 Prêt Crédit Agricole 10003101334 — reprise au 01/01/2026

=== STOCK CHEMIN 2 (SQL direct, PMP/cost/fourn) ===
stock SQL direct: 38562.64 (44 produits en stock)

=== 411/401 CHEMIN 2 : total factures - total paiements (agrégats séparés) ===
411: ttc=38307.97 (n=41) - paiements=553.11 - avoirs=0 = 37754.86
401: ttc=19897.89 (n=12) - paiements=0 - avoirs=0 = 19897.89