########## 1. LES DEUX FACTURES ##########

=== FACTURES ===
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | entity=1 | datec=2026-08-08 22:46:29 | date_valid=2026-08-10 | datef=2026-07-17 | libelle= | total_ht=62.64000000 | total_tva=12.53000000 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | fk_soc=318 | fk_user_author=1 | fk_user_valid=1 | note_private=[AGENTCOMPTA] Brouillon créé automatiquement par IA
Confiance : 0.95
Modèle : (défaut)
Source : WURTH 07-06.pdf
Hash : 2b3d2ccfbe61694dcbf96c7c058b2ed7452ec728427cc5798e3255afb77db9aa
ID intake : 107 | note_public= | fk_mode_reglement=3 | date_lim_reglement=2026-08-31 | model_pdf= | tiers=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)
ERR: Unknown column 'total_tva' in 'field list'

=== LIGNES facture rowid=136 (SI2607-0019) ===
(vide)
ERR: Unknown column 'p.fk_user_creat' in 'field list'

=== PAIEMENTS facture rowid=136 ===
(vide)

=== ECRITURES compta facture rowid=136 ===
(vide)

=== EXTRAFIELDS rowid=136 ===
(vide)

########## 1bis. AUTRES FACTURES DU MEME MONTANT / MEME PIECE ##########

=== MONTANT 75.17 ===
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | fk_soc=318 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)

=== REF_SUPPLIER 4335371605 ou 07/06 ===
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)

=== FACTURES du 2026-07-17 ===
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)
rowid=314 | ref=SI2607-0159 | ref_supplier=07/07 | datef=2026-07-17 | total_ttc=192.60000000 | fk_statut=1 | paye=0 | nom=MPI

########## 5. LES TIERS ##########

=== SOCIETES concernees ===
rowid=318 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | name_alias= | siren= | siret= | ape= | idprof4= | tva_intra=FR15929591741 | code_fournisseur=SU2608-00015 | code_compta_fournisseur= | address= | zip= | town= | datec=2026-08-08 16:47:48 | fournisseur=1 | status=1

=== SOCIETES nom ASTURIENNE/WURTH/SAINT-GOBAIN ===
rowid=318 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | siren= | siret= | tva_intra=FR15929591741 | code_fournisseur=SU2608-00015 | code_compta_fournisseur= | town=
rowid=342 | nom=Würth France SAS | siren= | siret= | tva_intra= | code_fournisseur=SU2608-00027 | code_compta_fournisseur= | town=

=== TOUTES FACTURES du tiers 318 ===
rowid=103 | ref=SI2606-0022 | ref_supplier=651C0003943793 | datef=2026-06-30 | total_ht=1742.49000000 | total_ttc=2090.99000000 | fk_statut=2 | paye=1 | libelle=
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | total_ht=62.64000000 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | libelle=
rowid=124 | ref=SI2607-0005 | ref_supplier=651C0003968958 | datef=2026-07-31 | total_ht=10641.86000000 | total_ttc=12770.24000000 | fk_statut=1 | paye=0 | libelle=

########## 3. RELEVE BANCAIRE ##########
-> nb mouvements de 75,17 : 0
--- opérations juillet contenant ASTURIENNE / WURTH / GOBAIN / POINT P ---
--- toutes opérations entre 70 et 80 EUR (débit) ---
  2026-01-07 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - P105209385 71820020600014 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P105209385 71820020600014 2
  2026-02-09 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P106619085 71820020600015 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P106619085 71820020600015 2
  2026-03-09 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P108013666 71820020600016 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P108013666 71820020600016 2
  2026-04-07 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P109413762 71820020600017 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P109413762 71820020600017 2
  2026-05-04 | -78.56 | Paiement par carte X4074 DRIVE BETON THUE ET 02/05
  2026-05-07 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P110798771 71820020600018 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P110798771 71820020600018 2
  2026-06-08 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P112182771 71820020600019 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P112182771 71820020600019 2
  2026-06-11 | -70 | Paiement par carte X4074 LE BUFFAROT ST MARTI 10/06
  2026-07-07 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P113601122 71820020600020 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P113601122 71820020600020 2
  2026-08-07 | -78.89 | Prélèvement GAN ASS ENC PREL CLIENT - Gan Assurances - P115026030 71820020600021 MSIAGCO0176655620240910 FR10ZZZ004486 SMIA-P115026030 71820020600021 2

########## 2. REGISTRE ASSISTANTE ##########
nb entrées: 159
REG: piece=07/27 date=2026-07-01 four=ASTURIENNE ht=1742.49 tva=348.5 ttc=2090.99 lib=ACHAT MAT 1è FOURNITURES ech=2026-07-31
REG: piece=02/05 date=2026-02-12 four=WURTH ht=23.6 tva=4.72 ttc=28.32 lib=ACHAT MAT 1è FOURNITURES ech=2026-03-31
REG: piece=03/20 date=2026-03-12 four=WURTH ht=36 tva=7.2 ttc=43.2 lib=ACHAT MAT 1è FOURNITURES ech=2026-04-30
REG: piece=04/07 date=2026-04-14 four=WURTH ht=37.45 tva=7.49 ttc=44.94 lib=PETIT MATERIEL ET OUTILLAGE ech=2026-05-31
REG: piece=06/19 date=2026-06-29 four=WURTH ht=152.25 tva=30.45 ttc=182.7 lib=ACHAT MAT 1è FOURNITURES ech=2026-07-31
REG: piece=07/04 date=2026-07-13 four=WURTH ht=163.6 tva=32.72 ttc=196.32 lib=ACHAT MAT 1è FOURNITURES ech=2026-08-31
REG: piece=07/06 date=2026-07-17 four=WURTH ht=62.64 tva=12.53 ttc=75.17 lib=ACHAT MAT 1è FOURNITURES ech=2026-08-31
REG: piece=07/26 date=2026-07-29 four=WURTH ht=128.06 tva=25.61 ttc=153.67 lib=PETIT MATERIEL ET OUTILLAGE ech=2026-08-31
REG: piece=07/28 date=2026-07-31 four=ASTURIENNE ht=10641.86 tva=2128.37 ttc=12770.23 lib=ACHAT MAT 1è FOURNITURES ech=2026-08-31
--- registre : entrées de juillet 2026 ---
  piece=07/16 2026-07-22 AMAZON ttc=189.05 PETIT MATERIEL ET OUTILLAGE
  piece=07/17 2026-07-22 AMAZON ttc=217.55 PETIT MATERIEL ET OUTILLAGE
  piece=07/18 2026-07-22 AMAZON ttc=24.85 PETIT MATERIEL ET OUTILLAGE
  piece=07/19 2026-07-23 AMAZON ttc=15.82 PETIT MATERIEL ET OUTILLAGE
  piece=07/20 2026-07-23 AMAZON ttc=15.12 PETIT MATERIEL ET OUTILLAGE
  piece=07/21 2026-07-28 AMAZON ttc=11.75 PETIT MATERIEL ET OUTILLAGE
  piece=07/22 2026-07-28 AMAZON ttc=56.59 PETIT MATERIEL ET OUTILLAGE
  piece=07/23 2026-07-28 AMAZON ttc=40.79 PETIT MATERIEL ET OUTILLAGE
  piece=07/24 2026-07-29 AMAZON ttc=16.62 PETIT MATERIEL ET OUTILLAGE
  piece=07/25 2026-07-29 AMAZON ttc=209 PETIT MATERIEL ET OUTILLAGE
  piece=07/08 2026-07-01 ARCELOR MITTAL ttc=316.48 ACHAT MAT 1è FOURNITURES
  piece=07/27 2026-07-01 ASTURIENNE ttc=2090.99 ACHAT MAT 1è FOURNITURES
  piece=07/10 2026-07-16 DECHARENTON ttc=93.8 PETIT MATERIEL ET OUTILLAGE
  piece=07/02 2026-07-09 FOURNISSEURS DIVERS ttc=41.26 ACHAT MAT 1è FOURNITURES
  piece=07/05 2026-07-09 FOURNISSEURS DIVERS ttc=330 SOUS TRAITANCE GENERALE
  piece=07/15 2026-07-29 FOURNISSEURS DIVERS ttc=130.8 PUBLICITES ET ANNONCES
  piece=07/30 2026-07-29 FOURNISSEURS DIVERS ttc=193.2 FRAIS D'ACTES ET CONTENTIEUX
  piece=07/14 2026-07-29 INPI ttc=1.24 FRAIS D'ACTES ET CONTENTIEUX
  piece=07/12 2026-07-27 METALMAQ ttc=2712 IMMO - MATERIEL INDUSTRIEL
  piece=07/09 2026-07-16 OCMANDY ttc=49.58 ENTRETIEN ET REPARATION SUR MATERIEL INDUSTRIEL
  piece=07/01 2026-07-01 SCI MARLEG ttc=4800 LOCATION IMMOBILIERE
  piece=07/32 2026-07-13 TAUPIN ttc=112.32 ACHAT MAT 1è FOURNITURES
  piece=07/33 2026-07-22 WELDOM ttc=93.6 EAU ELECTRICITE GAZ
  piece=07/34 2026-07-24 OVH Cloud ttc=21.49 SOUS TRAITANCE INFORMATIQUE
  piece=07/07 2026-07-17 MPI ttc=192.6 ACHAT MAT 1è FOURNITURES
  piece=07/29 2026-07-09 NLJ ttc=120 ACHAT MAT 1è FOURNITURES
  piece=07/31 2026-07-31 FOURNISSEURS DIVERS ttc=178.2 ACHAT MAT 1è FOURNITURES
  piece=07/03 2026-07-10 TACHER ACOGEX ttc=369 HONORAIRES COMPTABLES
  piece=07/11 2026-07-23 EDF ttc=140.33 EAU ELECTRICITE GAZ
  piece=07/13 2026-07-28 ARCELOR MITTAL ttc=209.09 ACHAT MAT 1è FOURNITURES
  piece=07/04 2026-07-13 WURTH ttc=196.32 ACHAT MAT 1è FOURNITURES
  piece=07/06 2026-07-17 WURTH ttc=75.17 ACHAT MAT 1è FOURNITURES
  piece=07/26 2026-07-29 WURTH ttc=153.67 PETIT MATERIEL ET OUTILLAGE
  piece=07/28 2026-07-31 ASTURIENNE ttc=12770.23 ACHAT MAT 1è FOURNITURES

########## 4. BANQUE DOLIBARR : lignes 75.17 ##########

=== llx_bank 75.17 ===
(vide)

=== paiements fourn 75.17 ===
(vide)

########## SERIE DES NUMEROS 43353xxxxx ##########

=== ref_supplier 43% ===
rowid=131 | ref=SI2602-0033 | ref_supplier=4334153589 | datef=2026-02-12 | total_ttc=28.32000000 | fk_statut=2 | paye=1 | nom=Würth France SAS
rowid=132 | ref=SI2603-0030 | ref_supplier=4334393179 | datef=2026-03-12 | total_ttc=43.20000000 | fk_statut=2 | paye=1 | nom=Würth France SAS
rowid=133 | ref=SI2604-0027 | ref_supplier=4334656108 | datef=2026-04-14 | total_ttc=44.94000000 | fk_statut=2 | paye=1 | nom=Würth France SAS
rowid=134 | ref=SI2606-0023 | ref_supplier=4335225117 | datef=2026-06-29 | total_ttc=182.70000000 | fk_statut=2 | paye=1 | nom=Würth France SAS
rowid=135 | ref=SI2607-0020 | ref_supplier=4335343640 | datef=2026-07-13 | total_ttc=196.32000000 | fk_statut=1 | paye=0 | nom=Würth France SAS
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)
rowid=142 | ref=SI2607-0007 | ref_supplier=4335464405 | datef=2026-07-29 | total_ttc=153.67000000 | fk_statut=1 | paye=0 | nom=Würth France SAS

########## SEQUENCE SI2607 ##########

=== SI2607* ===
rowid=102 | ref=SI2607-0003 | ref_supplier=FR79160621 | datef=2026-07-24 | datec=2026-08-08 16:47:28 | total_ttc=21.49000000 | fk_statut=2 | paye=1 | nom=OVHcloud (OVH)
rowid=125 | ref=SI2607-0004 | ref_supplier=42318 | datef=2026-07-31 | datec=2026-08-08 20:48:57 | total_ttc=178.20000000 | fk_statut=1 | paye=0 | nom=Cœugnet Matériaux
rowid=124 | ref=SI2607-0005 | ref_supplier=651C0003968958 | datef=2026-07-31 | datec=2026-08-08 20:48:47 | total_ttc=12770.24000000 | fk_statut=1 | paye=0 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)
rowid=142 | ref=SI2607-0007 | ref_supplier=4335464405 | datef=2026-07-29 | datec=2026-08-09 04:43:43 | total_ttc=153.67000000 | fk_statut=1 | paye=0 | nom=Würth France SAS
rowid=105 | ref=SI2607-0009 | ref_supplier=FR61R0BOABEI | datef=2026-07-29 | datec=2026-08-08 16:48:09 | total_ttc=209.00000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=123 | ref=SI2607-0010 | ref_supplier=FR61QY4HABEI | datef=2026-07-28 | datec=2026-08-08 20:48:26 | total_ttc=11.75000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=104 | ref=SI2607-0011 | ref_supplier=FR61QOZ4ABEI | datef=2026-07-28 | datec=2026-08-08 16:47:58 | total_ttc=56.59000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=108 | ref=SI2607-0013 | ref_supplier=FR61PB0VABEI | datef=2026-07-23 | datec=2026-08-08 16:49:24 | total_ttc=15.12000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=141 | ref=SI2607-0015 | ref_supplier=22701INV/0007654 | datef=2026-07-22 | datec=2026-08-09 04:43:25 | total_ttc=93.60000000 | fk_statut=2 | paye=1 | nom=FOUQUES (BRICO ST MARTIN) / Weldom St Martin De Fontenay
rowid=122 | ref=SI2607-0016 | ref_supplier=FR61PACSABEI | datef=2026-07-22 | datec=2026-08-08 20:48:15 | total_ttc=217.55000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=121 | ref=SI2607-0017 | ref_supplier=FR61P3QFABEI | datef=2026-07-22 | datec=2026-08-08 20:48:03 | total_ttc=189.05000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=109 | ref=SI2607-0018 | ref_supplier=FR61PADAABEI | datef=2026-07-22 | datec=2026-08-08 16:49:34 | total_ttc=24.85000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | datec=2026-08-08 22:46:29 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT)
rowid=135 | ref=SI2607-0020 | ref_supplier=4335343640 | datef=2026-07-13 | datec=2026-08-08 22:46:15 | total_ttc=196.32000000 | fk_statut=1 | paye=0 | nom=Würth France SAS
rowid=186 | ref=SI2607-0047 | ref_supplier=07/19 | datef=2026-07-23 | datec=2026-08-09 12:08:40 | total_ttc=15.82000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=187 | ref=SI2607-0048 | ref_supplier=07/23 | datef=2026-07-28 | datec=2026-08-09 12:08:40 | total_ttc=40.79000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=188 | ref=SI2607-0049 | ref_supplier=07/24 | datef=2026-07-29 | datec=2026-08-09 12:08:40 | total_ttc=16.62000000 | fk_statut=2 | paye=1 | nom=Amazon Business EU S.à.r.l, Succursale Française
rowid=190 | ref=SI2607-0051 | ref_supplier=07/08 | datef=2026-07-01 | datec=2026-08-09 12:08:40 | total_ttc=316.48000000 | fk_statut=2 | paye=1 | nom=ArcelorMittal Distribution Solutions France
rowid=217 | ref=SI2607-0078 | ref_supplier=07/02 | datef=2026-07-09 | datec=2026-08-09 12:08:41 | total_ttc=41.26000000 | fk_statut=2 | paye=1 | nom=Divers au comptant
rowid=219 | ref=SI2607-0080 | ref_supplier=07/05 | datef=2026-07-09 | datec=2026-08-09 12:08:41 | total_ttc=330.00000000 | fk_statut=2 | paye=1 | nom=Divers au comptant
rowid=221 | ref=SI2607-0082 | ref_supplier=07/15 | datef=2026-07-29 | datec=2026-08-09 12:08:41 | total_ttc=130.80000000 | fk_statut=2 | paye=1 | nom=Divers au comptant
rowid=242 | ref=SI2607-0102 | ref_supplier=07/01 | datef=2026-07-01 | datec=2026-08-09 12:08:42 | total_ttc=4800.00000000 | fk_statut=2 | paye=1 | nom=SCI MARLEG
rowid=265 | ref=SI2607-0125 | ref_supplier=07/29 | datef=2026-07-09 | datec=2026-08-09 12:08:43 | total_ttc=120.00000000 | fk_statut=1 | paye=0 | nom=NLJ
rowid=267 | ref=SI2607-0127 | ref_supplier=07/03 | datef=2026-07-10 | datec=2026-08-09 12:08:43 | total_ttc=369.00000000 | fk_statut=2 | paye=1 | nom=TACHER ACOGEX
rowid=289 | ref=SI2607-0138 | ref_supplier=07/14 | datef=2026-07-29 | datec=2026-08-09 12:09:29 | total_ttc=1.24000000 | fk_statut=2 | paye=1 | nom=INPI
rowid=299 | ref=SI2607-0148 | ref_supplier=07/12 | datef=2026-07-27 | datec=2026-08-09 12:09:29 | total_ttc=2712.00000000 | fk_statut=2 | paye=1 | nom=METALMAQ
rowid=307 | ref=SI2607-0156 | ref_supplier=07/09 | datef=2026-07-16 | datec=2026-08-09 12:09:30 | total_ttc=49.58000000 | fk_statut=2 | paye=1 | nom=OCMANDY
rowid=313 | ref=SI2607-0158 | ref_supplier=07/32 | datef=2026-07-13 | datec=2026-08-09 12:09:30 | total_ttc=112.32000000 | fk_statut=2 | paye=1 | nom=TAUPIN
rowid=314 | ref=SI2607-0159 | ref_supplier=07/07 | datef=2026-07-17 | datec=2026-08-09 12:09:30 | total_ttc=192.60000000 | fk_statut=1 | paye=0 | nom=MPI
rowid=315 | ref=SI2607-0160 | ref_supplier=07/11 | datef=2026-07-23 | datec=2026-08-09 12:09:30 | total_ttc=140.33000000 | fk_statut=2 | paye=1 | nom=EDF
rowid=405 | ref=SI2607-0197 | ref_supplier=07/10 | datef=2026-07-16 | datec=2026-08-09 12:18:39 | total_ttc=93.80000000 | fk_statut=2 | paye=1 | nom=Decharenton
rowid=408 | ref=SI2607-0198 | ref_supplier=07/13 | datef=2026-07-28 | datec=2026-08-09 12:18:39 | total_ttc=209.09000000 | fk_statut=1 | paye=0 | nom=ARCELOR MITTAL
rowid=442 | ref=SI2607-0206 | ref_supplier=428164BP0-202607 | datef=2026-07-19 | datec=2026-08-09 22:36:27 | total_ttc=1768.14000000 | fk_statut=2 | paye=1 | nom=LIXXBAIL (Crédit Agricole Leasing)
rowid=445 | ref=SI2607-0210 | ref_supplier=5801562824 | datef=2026-07-31 | datec=2026-08-10 08:01:05 | total_ttc=340.94000000 | fk_statut=1 | paye=0 | nom=Air Liquide France Industrie - IM
rowid=461 | ref=SI2607-0226 | ref_supplier=REPAS-20260722-11680 | datef=2026-07-22 | datec=2026-08-10 10:03:05 | total_ttc=116.80000000 | fk_statut=2 | paye=1 | nom=Divers au comptant
rowid=474 | ref=SI2607-0239 | ref_supplier=FOURN-20260728-20000 | datef=2026-07-28 | datec=2026-08-10 10:55:43 | total_ttc=200.00000000 | fk_statut=2 | paye=1 | nom=Divers au comptant

FIN