=== A. Toutes factures fourn avec reste != 0 (paye 0 et 1) ===
rowid=124 | ref=SI2607-0005 | ref_supplier=651C0003968958 | datef=2026-07-31 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | paye=0 | fk_statut=2 | close_code=other | ttc=12770.24 | regle=12770.23 | reste=0.01
rowid=182 | ref=SI2602-0043 | ref_supplier=02/11 | datef=2026-02-18 | nom=Amazon Business EU S.à.r.l, Succursale Française | paye=0 | fk_statut=3 | close_code=abandon | ttc=15.82 | regle=0 | reste=15.82
rowid=183 | ref=SI2602-0044 | ref_supplier=02/12 | datef=2026-02-18 | nom=Amazon Business EU S.à.r.l, Succursale Française | paye=0 | fk_statut=3 | close_code=abandon | ttc=29.16 | regle=0 | reste=29.16
rowid=264 | ref=SI2606-0124 | ref_supplier=06/26 | datef=2026-06-29 | nom=NLJ | paye=0 | fk_statut=1 | close_code= | ttc=115.44 | regle=0 | reste=115.44
rowid=293 | ref=SI2606-0142 | ref_supplier=06/12 | datef=2026-06-05 | nom=KDI | paye=0 | fk_statut=2 | close_code=other | ttc=1782 | regle=0 | reste=1782
rowid=294 | ref=SI2606-0143 | ref_supplier=06/13 | datef=2026-06-19 | nom=KDI | paye=0 | fk_statut=2 | close_code=other | ttc=-13.2 | regle=0 | reste=-13.2
rowid=305 | ref=SI2605-0154 | ref_supplier=05/21 | datef=2026-05-21 | nom=NOTAIRE | paye=0 | fk_statut=1 | close_code= | ttc=485.01 | regle=0 | reste=485.01
rowid=314 | ref=SI2607-0159 | ref_supplier=07/07 | datef=2026-07-17 | nom=MPI | paye=0 | fk_statut=3 | close_code=abandon | ttc=192.6 | regle=0 | reste=192.6
rowid=445 | ref=SI2607-0210 | ref_supplier=5801562824 | datef=2026-07-31 | nom=Air Liquide France Industrie - IM | paye=0 | fk_statut=2 | close_code=other | ttc=340.94 | regle=340.93 | reste=0.01
rowid=477 | ref=SI2604-0242 | ref_supplier=UBERFRAEATS-3374-14-2026-0000127 | datef=2026-04-16 | nom=Uber Eats France SAS | paye=0 | fk_statut=2 | close_code=other | ttc=5.99 | regle=0 | reste=5.99
rowid=478 | ref=SI2605-0243 | ref_supplier=UBERFRAEATS-3374-14-2026-0000161 | datef=2026-05-16 | nom=Uber Eats France SAS | paye=0 | fk_statut=2 | close_code=other | ttc=5.99 | regle=0 | reste=5.99
rowid=479 | ref=SI2606-0244 | ref_supplier=UBERFRAEATS-3374-14-2026-0000192 | datef=2026-06-16 | nom=Uber Eats France SAS | paye=0 | fk_statut=2 | close_code=other | ttc=5.99 | regle=0 | reste=5.99
rowid=481 | ref=SI2607-0246 | ref_supplier=UBERFRAEATS-3374-14-2026-0000226 | datef=2026-07-17 | nom=Uber Eats France SAS | paye=0 | fk_statut=2 | close_code=other | ttc=5.99 | regle=0 | reste=5.99
rowid=485 | ref=SI2608-0250 | ref_supplier=ES261012067 | datef=2026-08-25 | nom=EQUIPEMENTS SCIENTIFIQUES S.A.S | paye=0 | fk_statut=2 | close_code=other | ttc=1303.69 | regle=1303.68 | reste=0.01
rowid=488 | ref=SI2607-0253 | ref_supplier=FA2607-0283 | datef=2026-07-22 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | paye=0 | fk_statut=3 | close_code=abandon | ttc=515.51 | regle=0 | reste=515.51
rowid=489 | ref=SI2608-0254 | ref_supplier=FA2608-0322 | datef=2026-08-05 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | paye=0 | fk_statut=3 | close_code=abandon | ttc=1152.35 | regle=0 | reste=1152.35
rowid=491 | ref=SI2608-0255 | ref_supplier=FA2608-0308 | datef=2026-08-03 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | paye=0 | fk_statut=3 | close_code=abandon | ttc=626.58 | regle=0 | reste=626.58
rowid=496 | ref=SI2609-0260 | ref_supplier=00270001549 | datef=2026-09-08 | nom=TACHER ACOGEX | paye=0 | fk_statut=1 | close_code= | ttc=51.84 | regle=0 | reste=51.84
rowid=497 | ref=SI2609-0261 | ref_supplier=FR80031482 | datef=2026-09-01 | nom=OVHcloud (OVH) | paye=0 | fk_statut=2 | close_code=other | ttc=349.85 | regle=349.84 | reste=0.01
rowid=500 | ref=SI2609-0263 | ref_supplier=4335826593 | datef=2026-09-24 | nom=Würth France SAS | paye=0 | fk_statut=1 | close_code= | ttc=59.76 | regle=0 | reste=59.76
rowid=501 | ref=SI2609-0264 | ref_supplier=26029293 | datef=2026-09-30 | nom=ALMET PARIS | paye=0 | fk_statut=1 | close_code= | ttc=6699.54 | regle=0 | reste=6699.54
rowid=506 | ref=SI2610-0269 | ref_supplier=26029841 | datef=2026-10-07 | nom=ALMET PARIS | paye=0 | fk_statut=1 | close_code= | ttc=830.55 | regle=0 | reste=830.55
rowid=507 | ref=SI2609-0270 | ref_supplier=VEN739486 | datef=2026-09-30 | nom=MULTILAQUE | paye=0 | fk_statut=1 | close_code= | ttc=3517.2 | regle=0 | reste=3517.2
rowid=508 | ref=SI2609-0271 | ref_supplier=FA-26000913 | datef=2026-09-30 | nom=Fondation LES ATELIERS DU MOULIN A VENT - ESAT DE LA FONDATION RICHARD | paye=0 | fk_statut=1 | close_code= | ttc=599.88 | regle=0 | reste=599.88
rowid=509 | ref=SI2609-0272 | ref_supplier=F267303 | datef=2026-09-09 | nom=Sellerie Thomas | paye=0 | fk_statut=1 | close_code= | ttc=334.8 | regle=0 | reste=334.8
rowid=510 | ref=SI2607-0273 | ref_supplier=FAC5050744 | datef=2026-07-31 | nom=NORMANDIE ACIERS DECOUPE (NLJ) | paye=0 | fk_statut=3 | close_code=abandon | ttc=120 | regle=0 | reste=120
rowid=516 | ref=SI2607-0279 | ref_supplier=FR601K9LC1EC3I | datef=2026-07-28 | nom=ets legrand eurl | paye=0 | fk_statut=3 | close_code=abandon | ttc=40.79 | regle=0 | reste=40.79
rowid=520 | ref=SI2607-0283 | ref_supplier=DE60008H9FG3VI | datef=2026-07-23 | nom=Shenzhenshi Fengmaishiyeyouxiangongsi | paye=0 | fk_statut=3 | close_code=abandon | ttc=15.82 | regle=0 | reste=15.82
rowid=524 | ref=SI2607-0287 | ref_supplier=FR6000IQ4M4KVI | datef=2026-07-29 | nom=huizhoushizhenxindianzikejiyouxiangongsi | paye=0 | fk_statut=3 | close_code=abandon | ttc=16.62 | regle=0 | reste=16.62
rowid=527 | ref=SI2605-0290 | ref_supplier=2026-REF-NBK-002 | datef=2026-05-27 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | paye=0 | fk_statut=3 | close_code=abandon | ttc=2464 | regle=0 | reste=2464
rowid=528 | ref=SI2605-0291 | ref_supplier=2026-REF-NBK-004 | datef=2026-05-27 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | paye=0 | fk_statut=3 | close_code=abandon | ttc=1848 | regle=0 | reste=1848
rowid=534 | ref=SI2610-0297 | ref_supplier=26030416 | datef=2026-10-14 | nom=ALMET PARIS | paye=0 | fk_statut=1 | close_code= | ttc=3081.84 | regle=0 | reste=3081.84
rowid=535 | ref=SI2610-0298 | ref_supplier=26030415 | datef=2026-10-14 | nom=ALMET PARIS | paye=0 | fk_statut=1 | close_code= | ttc=1983.63 | regle=0 | reste=1983.63
rowid=538 | ref=SI2610-0301 | ref_supplier=F267440 | datef=2026-10-20 | nom=Sellerie Thomas | paye=0 | fk_statut=1 | close_code= | ttc=2138.4 | regle=0 | reste=2138.4
rowid=205 | ref=SI2604-0066 | ref_supplier=04/09 | datef=2026-04-28 | nom=Divers au comptant | paye=1 | fk_statut=2 | close_code= | ttc=293.32 | regle=293.31 | reste=0.01
rowid=211 | ref=SI2605-0072 | ref_supplier=05/18 | datef=2026-05-22 | nom=Divers au comptant | paye=1 | fk_statut=2 | close_code= | ttc=231.53 | regle=231.52 | reste=0.01
-- 36 ligne(s)

=== B. Ventilation du reste par paye/statut ===
paye=0 | fk_statut=2 | nb=10 | somme_reste=1792.8
paye=0 | fk_statut=3 | nb=12 | somme_reste=7037.25
paye=1 | fk_statut=2 | nb=2 | somme_reste=0.02
paye=0 | fk_statut=1 | nb=12 | somme_reste=19897.89
-- 4 ligne(s)

=== C. Remises/avoirs imputes sur 205/211 ===
-- 0 ligne(s)

=== D. Colonnes facture_fourn_det ===
Field=rowid | Type=int | Null=NO | Key=PRI | Default= | Extra=auto_increment
Field=fk_facture_fourn | Type=int | Null=NO | Key=MUL | Default= | Extra=
Field=fk_parent_line | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_product | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=ref | Type=varchar(128) | Null=YES | Key= | Default= | Extra=
Field=label | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=description | Type=text | Null=YES | Key= | Default= | Extra=
Field=pu_ht | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=pu_ttc | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=qty | Type=double | Null=YES | Key= | Default= | Extra=
Field=remise_percent | Type=double | Null=YES | Key= | Default=0 | Extra=
Field=fk_remise_except | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=vat_src_code | Type=varchar(10) | Null=YES | Key= | Default= | Extra=
Field=tva_tx | Type=double(7,4) | Null=YES | Key= | Default= | Extra=
Field=localtax1_tx | Type=double(7,4) | Null=YES | Key= | Default=0.0000 | Extra=
Field=localtax1_type | Type=varchar(10) | Null=YES | Key= | Default= | Extra=
Field=localtax2_tx | Type=double(7,4) | Null=YES | Key= | Default=0.0000 | Extra=
Field=localtax2_type | Type=varchar(10) | Null=YES | Key= | Default= | Extra=
Field=total_ht | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=tva | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=total_localtax1 | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=total_localtax2 | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=total_ttc | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=product_type | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=date_start | Type=datetime | Null=YES | Key= | Default= | Extra=
Field=date_end | Type=datetime | Null=YES | Key= | Default= | Extra=
Field=info_bits | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=fk_code_ventilation | Type=int | Null=NO | Key=MUL | Default=0 | Extra=
Field=special_code | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=rang | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=import_key | Type=varchar(14) | Null=YES | Key= | Default= | Extra=
Field=fk_unit | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=fk_multicurrency | Type=int | Null=YES | Key= | Default= | Extra=
Field=multicurrency_code | Type=varchar(3) | Null=YES | Key= | Default= | Extra=
Field=multicurrency_subprice | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_subprice_ttc | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_total_ht | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_total_tva | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_total_ttc | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=extraparams | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
-- 40 ligne(s)