=== FOURN TVA=0 janv-juin ===
rowid=238 | ref=SI2605-0098 | ref_supplier=05/23 | datef=2026-05-22 | nom=SCI MARLEG | total_ht=8000.00000000 | total_tva=0.00000000 | total_ttc=8000.00000000
rowid=199 | ref=SI2603-0060 | ref_supplier=03/12 | datef=2026-03-10 | nom=Divers au comptant | total_ht=3343.00000000 | total_tva=0.00000000 | total_ttc=3343.00000000
rowid=215 | ref=SI2606-0076 | ref_supplier=06/14 | datef=2026-06-17 | nom=Divers au comptant | total_ht=3210.12000000 | total_tva=0.00000000 | total_ttc=3210.12000000
rowid=223 | ref=SI2603-0083 | ref_supplier=03/07 | datef=2026-03-31 | nom=GRÉGOIRE DONNART | total_ht=2970.00000000 | total_tva=0.00000000 | total_ttc=2970.00000000
rowid=227 | ref=SI2606-0087 | ref_supplier=06/24 | datef=2026-06-30 | nom=GRÉGOIRE DONNART | total_ht=2565.00000000 | total_tva=0.00000000 | total_ttc=2565.00000000
rowid=527 | ref=SI2605-0290 | ref_supplier=2026-REF-NBK-002 | datef=2026-05-27 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | total_ht=2464.00000000 | total_tva=0.00000000 | total_ttc=2464.00000000
rowid=224 | ref=SI2605-0084 | ref_supplier=05/03 | datef=2026-05-03 | nom=GRÉGOIRE DONNART | total_ht=2295.00000000 | total_tva=0.00000000 | total_ttc=2295.00000000
rowid=198 | ref=SI2603-0059 | ref_supplier=03/11 | datef=2026-03-10 | nom=Divers au comptant | total_ht=1806.72000000 | total_tva=0.00000000 | total_ttc=1806.72000000
rowid=196 | ref=SI2603-0057 | ref_supplier=03/01 | datef=2026-03-04 | nom=Divers au comptant | total_ht=1500.00000000 | total_tva=0.00000000 | total_ttc=1500.00000000
rowid=226 | ref=SI2606-0086 | ref_supplier=06/03 | datef=2026-06-03 | nom=GRÉGOIRE DONNART | total_ht=1080.00000000 | total_tva=0.00000000 | total_ttc=1080.00000000
rowid=200 | ref=SI2603-0061 | ref_supplier=03/13 | datef=2026-03-20 | nom=Divers au comptant | total_ht=920.70000000 | total_tva=0.00000000 | total_ttc=920.70000000
rowid=225 | ref=SI2606-0085 | ref_supplier=06/02 | datef=2026-06-03 | nom=GRÉGOIRE DONNART | total_ht=675.00000000 | total_tva=0.00000000 | total_ttc=675.00000000
rowid=201 | ref=SI2603-0062 | ref_supplier=03/14 | datef=2026-03-26 | nom=Divers au comptant | total_ht=404.79000000 | total_tva=0.00000000 | total_ttc=404.79000000
rowid=220 | ref=SI2606-0081 | ref_supplier=06/32 | datef=2026-06-18 | nom=Divers au comptant | total_ht=313.51000000 | total_tva=0.00000000 | total_ttc=313.51000000
rowid=212 | ref=SI2605-0073 | ref_supplier=05/17 | datef=2026-05-26 | nom=Divers au comptant | total_ht=295.97000000 | total_tva=0.00000000 | total_ttc=295.97000000
rowid=271 | ref=SI2603-0131 | ref_supplier=03/15 | datef=2026-03-04 | nom=ANTAI | total_ht=287.76000000 | total_tva=0.00000000 | total_ttc=287.76000000
rowid=296 | ref=SI2604-0145 | ref_supplier=04/05 | datef=2026-04-08 | nom=LA POSTE | total_ht=36.19000000 | total_tva=0.00000000 | total_ttc=36.19000000
rowid=298 | ref=SI2606-0147 | ref_supplier=06/10 | datef=2026-06-10 | nom=LA POSTE | total_ht=36.19000000 | total_tva=0.00000000 | total_ttc=36.19000000
rowid=297 | ref=SI2606-0146 | ref_supplier=06/01 | datef=2026-06-05 | nom=LA POSTE | total_ht=31.19000000 | total_tva=0.00000000 | total_ttc=31.19000000
rowid=183 | ref=SI2602-0044 | ref_supplier=02/12 | datef=2026-02-18 | nom=Amazon Business EU S.à.r.l, Succursale Française | total_ht=29.16000000 | total_tva=0.00000000 | total_ttc=29.16000000
rowid=295 | ref=SI2603-0144 | ref_supplier=03/24 | datef=2026-03-18 | nom=LA POSTE | total_ht=22.39000000 | total_tva=0.00000000 | total_ttc=22.39000000
rowid=179 | ref=SI2601-0040 | ref_supplier=01/09 | datef=2026-01-05 | nom=Amazon Business EU S.à.r.l, Succursale Française | total_ht=19.49000000 | total_tva=0.00000000 | total_ttc=19.49000000
rowid=184 | ref=SI2605-0045 | ref_supplier=05/07 | datef=2026-05-02 | nom=Amazon Business EU S.à.r.l, Succursale Française | total_ht=15.82000000 | total_tva=0.00000000 | total_ttc=15.82000000
rowid=182 | ref=SI2602-0043 | ref_supplier=02/11 | datef=2026-02-18 | nom=Amazon Business EU S.à.r.l, Succursale Française | total_ht=15.82000000 | total_tva=0.00000000 | total_ttc=15.82000000
rowid=197 | ref=SI2603-0058 | ref_supplier=03/23 | datef=2026-03-05 | nom=Divers au comptant | total_ht=7.17000000 | total_tva=0.00000000 | total_ttc=7.17000000
-- 25 lignes

=== total FOURN TVA=0 ===
ht_sans_tva=32344.99 | nb=25
-- 1 lignes

=== taux TVA lignes fourn janv-juin ===
ERR: Unknown column 'fd.total_tva' in 'field list'
=== taux TVA lignes clients janv-juin ===
tva_tx=20.0000 | nb=702 | ht=135176.34 | tva=27035.43
tva_tx=0.0000 | nb=2 | ht=3448 | tva=0
-- 2 lignes

=== FOURN mars 2026 detail ===
rowid=177 | ref=SI2603-0038 | ref_supplier=03/21 | datef=2026-03-31 | nom=ALMET PARIS | total_ht=8449.00000000 | total_tva=1689.80000000
rowid=113 | ref=SI2603-0031 | ref_supplier=26008094 | datef=2026-03-11 | nom=ALMET PARIS | total_ht=8067.60000000 | total_tva=1613.52000000
rowid=192 | ref=SI2603-0053 | ref_supplier=03/22 | datef=2026-03-31 | nom=Cœugnet Matériaux | total_ht=5131.92000000 | total_tva=1026.38000000
rowid=199 | ref=SI2603-0060 | ref_supplier=03/12 | datef=2026-03-10 | nom=Divers au comptant | total_ht=3343.00000000 | total_tva=0.00000000
rowid=223 | ref=SI2603-0083 | ref_supplier=03/07 | datef=2026-03-31 | nom=GRÉGOIRE DONNART | total_ht=2970.00000000 | total_tva=0.00000000
rowid=198 | ref=SI2603-0059 | ref_supplier=03/11 | datef=2026-03-10 | nom=Divers au comptant | total_ht=1806.72000000 | total_tva=0.00000000
rowid=404 | ref=SI2603-0196 | ref_supplier=03/09 | datef=2026-03-23 | nom=SAS COMAT METAL INDUSTRIE | total_ht=1582.09000000 | total_tva=316.42000000
rowid=196 | ref=SI2603-0057 | ref_supplier=03/01 | datef=2026-03-04 | nom=Divers au comptant | total_ht=1500.00000000 | total_tva=0.00000000
rowid=438 | ref=SI2603-0202 | ref_supplier=428164BP0-202603 | datef=2026-03-19 | nom=LIXXBAIL (Crédit Agricole Leasing) | total_ht=1476.20000000 | total_tva=291.94000000
rowid=279 | ref=SI2603-0136 | ref_supplier=03/03 | datef=2026-03-09 | nom=EQUIPEMENT SCIENTIFIQUE | total_ht=1155.09000000 | total_tva=231.02000000
rowid=244 | ref=SI2603-0104 | ref_supplier=03/17 | datef=2026-03-01 | nom=Sellerie Thomas | total_ht=1120.00000000 | total_tva=224.00000000
rowid=245 | ref=SI2603-0105 | ref_supplier=03/18 | datef=2026-03-10 | nom=Sellerie Thomas | total_ht=1120.00000000 | total_tva=224.00000000
rowid=236 | ref=SI2603-0096 | ref_supplier=03/02 | datef=2026-03-01 | nom=SCI DU CLOS | total_ht=1090.00000000 | total_tva=218.00000000
rowid=200 | ref=SI2603-0061 | ref_supplier=03/13 | datef=2026-03-20 | nom=Divers au comptant | total_ht=920.70000000 | total_tva=0.00000000
rowid=291 | ref=SI2603-0140 | ref_supplier=03/08 | datef=2026-03-13 | nom=KDI | total_ht=901.00000000 | total_tva=180.20000000
rowid=201 | ref=SI2603-0062 | ref_supplier=03/14 | datef=2026-03-26 | nom=Divers au comptant | total_ht=404.79000000 | total_tva=0.00000000
rowid=399 | ref=SI2603-0192 | ref_supplier=03/10 | datef=2026-03-24 | nom=ARCELOR MITTAL | total_ht=354.75000000 | total_tva=70.95000000
rowid=250 | ref=SI2603-0110 | ref_supplier=03/04 | datef=2026-03-10 | nom=TACHER ACOGEX | total_ht=307.50000000 | total_tva=61.50000000
rowid=117 | ref=SI2603-0029 | ref_supplier=FA26000349 | datef=2026-03-31 | nom=Fondation LES ATELIERS DU MOULIN A VENT - ESAT DE LA FONDATION RICHARD | total_ht=299.94000000 | total_tva=59.99000000
rowid=271 | ref=SI2603-0131 | ref_supplier=03/15 | datef=2026-03-04 | nom=ANTAI | total_ht=287.76000000 | total_tva=0.00000000
rowid=396 | ref=SI2603-0189 | ref_supplier=03/19 | datef=2026-03-13 | nom=Amazon Business EU S.à.r.l, Succursale Française | total_ht=249.17000000 | total_tva=49.83000000
rowid=464 | ref=SI2603-0229 | ref_supplier=FOURN-20260316-10013 | datef=2026-03-16 | nom=Divers au comptant | total_ht=83.44000000 | total_tva=16.69000000
rowid=466 | ref=SI2603-0231 | ref_supplier=FOURN-20260330-10005 | datef=2026-03-30 | nom=Divers au comptant | total_ht=83.38000000 | total_tva=16.67000000
rowid=465 | ref=SI2603-0230 | ref_supplier=FOURN-20260324-10001 | datef=2026-03-24 | nom=Divers au comptant | total_ht=83.34000000 | total_tva=16.67000000
rowid=256 | ref=SI2603-0116 | ref_supplier=03/25 | datef=2026-03-19 | nom=FOUQUES (BRICO ST MARTIN) / Weldom St Martin De Fontenay | total_ht=75.00000000 | total_tva=15.00000000
rowid=339 | ref=SI2603-0166 | ref_supplier=03/16 | datef=2026-03-31 | nom=DHL International Express (France) SAS | total_ht=52.67000000 | total_tva=3.33000000
rowid=280 | ref=SI2603-0137 | ref_supplier=03/06 | datef=2026-03-12 | nom=EQUIPEMENT SCIENTIFIQUE | total_ht=44.24000000 | total_tva=8.85000000
rowid=132 | ref=SI2603-0030 | ref_supplier=4334393179 | datef=2026-03-12 | nom=Würth France SAS | total_ht=36.00000000 | total_tva=7.20000000
rowid=451 | ref=SI2603-0216 | ref_supplier=REPAS-20260316-03760 | datef=2026-03-16 | nom=Divers au comptant | total_ht=34.18000000 | total_tva=3.42000000
rowid=295 | ref=SI2603-0144 | ref_supplier=03/24 | datef=2026-03-18 | nom=LA POSTE | total_ht=22.39000000 | total_tva=0.00000000
rowid=197 | ref=SI2603-0058 | ref_supplier=03/23 | datef=2026-03-05 | nom=Divers au comptant | total_ht=7.17000000 | total_tva=0.00000000
-- 31 lignes