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":"a51918bb-dbff-4ece-8177-5de6ecadaca3","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.sKauHfZ+\/IjmI3KIiKjzaLEWfO+8y0Hn6w3hCPUHLYk=","iban":"FR7616606000242422500600113","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"072de84f-e466-4dcc-a3ab-7b31e7210e67","reference":"eb","fk_bank_account":null,"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\u00e9 le 09\/08\/2026 : ne appartient pas \u00e0 TEKNI-PLI (d\u00e9cision de l'artisan).","status":"disabled","date_creation":"2026-08-08 11:55:09","tms":"2026-08-09 22:50:08"}
{"rowid":"2","entity":"1","provider":"enablebanking","gc_account_id":"b18c887a-9050-4a33-910c-9b560f73948b","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.r3jsYzShRPex8JsAo26YeYGIH6DmjERh2mTh8wrLySw=","iban":"FR7616606052138488109336679","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"072de84f-e466-4dcc-a3ab-7b31e7210e67","reference":"eb","fk_bank_account":null,"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\u00e9 le 09\/08\/2026 : ne appartient pas \u00e0 TEKNI-PLI (d\u00e9cision de l'artisan).","status":"disabled","date_creation":"2026-08-08 11:55:09","tms":"2026-08-09 22:50:08"}
{"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\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"072de84f-e466-4dcc-a3ab-7b31e7210e67","reference":"eb","fk_bank_account":null,"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\u00e9 le 09\/08\/2026 : ne appartient pas \u00e0 TEKNI-PLI (d\u00e9cision de l'artisan).","status":"disabled","date_creation":"2026-08-08 11:55:09","tms":"2026-08-09 22:50:08"}
{"rowid":"4","entity":"1","provider":"enablebanking","gc_account_id":"54b37edc-8217-47d6-8026-315789563529","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.rui56mHCReFnyDQz8GgHIh18cclpuAxcoUol05iwAxQ=","iban":"FR7616606050118489487333640","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit 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":null,"status":"active","date_creation":"2026-08-08 11:55:09","tms":"2026-08-10 07:30:14"}
{"rowid":"5","entity":"1","provider":"enablebanking","gc_account_id":"6ee2422e-694b-4c99-afe5-7a9d0a5f4147","ext_hash":"WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.wQhNFJVR3nCtGPZOVCu7TvTikFyOaseILRp5CIh5cnY=","iban":"FR7616606050118490472149129","institution_id":"Cr\u00e9dit Agricole de Normandie","institution_name":"Cr\u00e9dit Agricole de Normandie","requisition_id":"072de84f-e466-4dcc-a3ab-7b31e7210e67","reference":"eb","fk_bank_account":null,"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\u00e9 le 09\/08\/2026 : ne appartient pas \u00e0 TEKNI-PLI (d\u00e9cision de l'artisan).","status":"disabled","date_creation":"2026-08-08 11:55:09","tms":"2026-08-09 22:50:08"}

=== 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

=== 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-05-30 code=455 sens=1 montant=2190.99000000 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

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

=== 411/401 CHEMIN 2 : total factures - total paiements (agrégats séparés) ===
411: ttc=33409.04 (n=53) - paiements=1030.36 - avoirs=0 = 32378.68
401: ttc=30309.53 (n=17) - paiements=0 - avoirs=0 = 30309.53