=== A) factures fournisseur issues des intakes marketplace === ff#104 SI2607-0011 ref_f=FR61QOZ4ABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-28 HT=47.16000000 TVA=9.43000000 st=2 ff#105 SI2607-0009 ref_f=FR61R0BOABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-29 HT=174.17000000 TVA=34.83000000 st=2 ff#108 SI2607-0013 ref_f=FR61PB0VABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-23 HT=12.60000000 TVA=2.52000000 st=2 ff#109 SI2607-0018 ref_f=FR61PADAABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-22 HT=20.71000000 TVA=4.14000000 st=2 ff#120 SI2601-0034 ref_f=FR6GNUABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-01-05 HT=111.61000000 TVA=22.32000000 st=2 ff#121 SI2607-0017 ref_f=FR61P3QFABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-22 HT=157.54000000 TVA=31.51000000 st=2 ff#122 SI2607-0016 ref_f=FR61PACSABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-22 HT=181.29000000 TVA=36.26000000 st=2 ff#123 SI2607-0010 ref_f=FR61QY4HABEI -> soc=319 pays=1 Amazon Business EU S.à.r.l, Succursale | 2026-07-28 HT=9.79000000 TVA=1.96000000 st=2 === B) les 3 tiers francises douteux : rattachements === soc=321 : facture_fourn=1 facture=0 bank_url company=0 soc=348 : facture_fourn=0 facture=0 bank_url company=0 soc=349 : facture_fourn=0 facture=0 bank_url company=0 === C) factures fournisseur A 0 DE TVA sur les 35 francises === soc=318 ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUT SI2605-0290 2026-05-27 HT=2464.00000000 TVA=0 st=3 soc=319 Amazon Business EU S.à.r.l, Succursal SI2601-0040 2026-01-05 HT=19.49000000 TVA=0 st=2 soc=319 Amazon Business EU S.à.r.l, Succursal SI2602-0043 2026-02-18 HT=15.82000000 TVA=0 st=3 soc=319 Amazon Business EU S.à.r.l, Succursal SI2602-0044 2026-02-18 HT=29.16000000 TVA=0 st=3 soc=319 Amazon Business EU S.à.r.l, Succursal SI2605-0045 2026-05-02 HT=15.82000000 TVA=0 st=2 soc=319 Amazon Business EU S.à.r.l, Succursal SI2607-0047 2026-07-23 HT=15.82000000 TVA=0 st=2 soc=319 Amazon Business EU S.à.r.l, Succursal SI2607-0049 2026-07-29 HT=16.62000000 TVA=0 st=2 soc=321 huizhoushizhenxindianzikejiyouxiangong SI2607-0287 2026-07-29 HT=16.62000000 TVA=0 st=3 soc=322 GRÉGOIRE DONNART SI2603-0083 2026-03-31 HT=2970.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2605-0084 2026-05-03 HT=2295.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2606-0086 2026-06-03 HT=1080.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2606-0085 2026-06-03 HT=675.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2606-0087 2026-06-30 HT=2565.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2608-0088 2026-08-03 HT=3240.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2609-0275 2026-09-01 HT=675.00000000 TVA=0 st=2 soc=322 GRÉGOIRE DONNART SI2610-0299 2026-10-13 HT=2700.00000000 TVA=0 st=2 soc=395 shenzhenshitianpengshengkejiyouxiangon SI2608-0280 2026-08-29 HT=33.32000000 TVA=0 st=2 soc=396 POWER TOOLS MAREK BIELESZ SPOLKA KOMAN SI2608-0285 2026-08-21 HT=19.17000000 TVA=0 st=2 TOTAL HT sans TVA sur tiers francises = 18 845,84 EUR sur 18 factures === D) totaux achats sur les 43 tiers === 35 francises : 122 factures, HT=70347.17 TVA=10332.45 TTC=80679.62 8 restes croatie : 14 factures, HT=1128.01 TVA=222.44 TTC=1350.45 === E) doublons de n TVA parmi les 35 + collision avec le n de TVA de l'entreprise === TVA FR03440279214 x2 -> ids=399,340 : BULTEAU SYSTEMS || BULTEAU SYSTEMS TVA FR07892610262 x2 -> ids=391,329 : SARL ABORDS ET PAYSAGES || SARL ABORDS ET PAYSAGES TVA FR86322212523 x2 -> ids=346,316 : Greffe du tribunal de commerce de CAEN - SCP Sophie JONVAL et Aurélien LÉGER || SCP Sophie JONVAL et Aurélien LÉGER TVA FR88403432693 x2 -> ids=393,394 : ETABLISSEMENTS JACQUET || ETABLISSEMENTS JACQUET n TVA de l'entreprise = FR15929591741 === F) tables tracant un changement aujourd'hui (hors societe) === facture : 82 ligne(s) touchee(s) aujourd'hui facture_fourn : 72 ligne(s) touchee(s) aujourd'hui facturedet : pas de colonne tms facture_fourn_det : pas de colonne tms bank : 85 ligne(s) touchee(s) aujourd'hui paiement : 21 ligne(s) touchee(s) aujourd'hui accounting_bookkeeping : 0 ligne(s) touchee(s) aujourd'hui