===== A. Ventilation du paiement PAY2510-0023 (8884.06) =====
rowid=47 | fid=66 | ref=FA2510-0060 | total_ttc=951.03000000 | impute=951.03000000 | diff=0 | paye=1 | fk_statut=2
rowid=48 | fid=68 | ref=FA2510-0062 | total_ttc=493.05000000 | impute=493.05000000 | diff=0 | paye=1 | fk_statut=2
rowid=49 | fid=69 | ref=FA2510-0063 | total_ttc=555.00000000 | impute=555.00000000 | diff=0 | paye=1 | fk_statut=2
rowid=50 | fid=70 | ref=FA2510-0064 | total_ttc=1213.94000000 | impute=1213.94000000 | diff=0 | paye=1 | fk_statut=2
rowid=51 | fid=73 | ref=FA2510-0067 | total_ttc=3559.06000000 | impute=3559.04000000 | diff=0.02 | paye=1 | fk_statut=2
rowid=52 | fid=75 | ref=FA2510-0069 | total_ttc=2112.00000000 | impute=2112.00000000 | diff=0 | paye=1 | fk_statut=2
(6 lignes)

===== B. Total des 6 factures vs virement =====
somme_ttc_6_factures=8884.08000000 | somme_imputee=8884.06000000
(1 lignes)

===== C. Comptes bancaires =====
rowid=1 | ref=Tekni-pli | label=Compte Courant | number=84894873336 | clos=0 | currency_code=EUR
rowid=2 | ref=HIST25 | label=Historique 2025 (exercice clos) — ne pas utiliser | number= | clos=1 | currency_code=EUR
(2 lignes)

===== D. Les 25 lignes avec ecart >0.005 (seuil abaisse) =====
rowid=1184 | ref=FA2605-0212 | datef=2026-05-11 | qty=16 | subprice=36.10000000 | remise_percent=0 | total_ht=577.54000000 | calc=577.6 | delta=-0.06
rowid=340 | ref=FA2510-0067 | datef=2025-10-19 | qty=7 | subprice=27.85000000 | remise_percent=0 | total_ht=194.98000000 | calc=194.95 | delta=0.03
rowid=1185 | ref=FA2605-0212 | datef=2026-05-11 | qty=14 | subprice=2.60000000 | remise_percent=0 | total_ht=36.38000000 | calc=36.4 | delta=-0.02
rowid=337 | ref=FA2510-0067 | datef=2025-10-19 | qty=4 | subprice=24.25000000 | remise_percent=0 | total_ht=96.98000000 | calc=97 | delta=-0.02
rowid=146 | ref=FA2509-0033 | datef=2025-09-09 | qty=4 | subprice=68.22000000 | remise_percent=0 | total_ht=272.86000000 | calc=272.88 | delta=-0.02
rowid=339 | ref=FA2510-0067 | datef=2025-10-19 | qty=3 | subprice=45.18000000 | remise_percent=0 | total_ht=135.52000000 | calc=135.54 | delta=-0.02
rowid=841 | ref=FA2602-0138 | datef=2026-02-10 | qty=5 | subprice=30.91500000 | remise_percent=0 | total_ht=154.58000000 | calc=154.57 | delta=0.01
rowid=1725 | ref=FA2605-0343 | datef=2026-05-27 | qty=1 | subprice=206.32500000 | remise_percent=0 | total_ht=206.33000000 | calc=206.32 | delta=0.01
rowid=1595 | ref=FA2608-0309 | datef=2026-08-03 | qty=1 | subprice=68.96500000 | remise_percent=0 | total_ht=68.97000000 | calc=68.96 | delta=0.01
rowid=450 | ref=FA2512-0088 | datef=2025-12-22 | qty=2 | subprice=32.15000000 | remise_percent=5 | total_ht=61.09000000 | calc=61.08 | delta=0.01
rowid=445 | ref=FA2512-0088 | datef=2025-12-22 | qty=1 | subprice=29.50000000 | remise_percent=5 | total_ht=28.03000000 | calc=28.02 | delta=0.01
rowid=502 | ref=FA2512-0102 | datef=2025-12-23 | qty=2 | subprice=11.87250000 | remise_percent=0 | total_ht=23.75000000 | calc=23.74 | delta=0.01
rowid=287 | ref=FA2510-0062 | datef=2025-10-19 | qty=1 | subprice=12.54500000 | remise_percent=0 | total_ht=12.55000000 | calc=12.54 | delta=0.01
rowid=280 | ref=FA2510-0062 | datef=2025-10-19 | qty=1 | subprice=26.58500000 | remise_percent=0 | total_ht=26.59000000 | calc=26.58 | delta=0.01
rowid=1626 | ref=FA2608-0315 | datef=2026-08-03 | qty=1 | subprice=20.86500000 | remise_percent=0 | total_ht=20.87000000 | calc=20.86 | delta=0.01
rowid=772 | ref=FA2602-0132 | datef=2026-02-09 | qty=1 | subprice=14.88500000 | remise_percent=0 | total_ht=14.89000000 | calc=14.88 | delta=0.01
rowid=861 | ref=FA2602-0142 | datef=2026-02-25 | qty=1 | subprice=10.80500000 | remise_percent=0 | total_ht=10.81000000 | calc=10.8 | delta=0.01
rowid=91 | ref=FA2507-0018 | datef=2025-07-24 | qty=1 | subprice=51.52500000 | remise_percent=0 | total_ht=51.53000000 | calc=51.52 | delta=0.01
rowid=157 | ref=FA2509-0036 | datef=2025-09-14 | qty=2 | subprice=29.61250000 | remise_percent=0 | total_ht=59.23000000 | calc=59.22 | delta=0.01
rowid=1392 | ref=FA2607-0261 | datef=2026-07-02 | qty=1 | subprice=28.92500000 | remise_percent=0 | total_ht=28.93000000 | calc=28.92 | delta=0.01
rowid=1906 | ref=FA2609-0373 | datef=2026-09-28 | qty=1 | subprice=96.98500000 | remise_percent=0 | total_ht=96.99000000 | calc=96.98 | delta=0.01
rowid=1904 | ref=FA2609-0373 | datef=2026-09-28 | qty=1 | subprice=96.98500000 | remise_percent=0 | total_ht=96.99000000 | calc=96.98 | delta=0.01
rowid=2001 | ref=FA2610-0390 | datef=2026-10-21 | qty=23 | subprice=28.63500000 | remise_percent=0 | total_ht=658.61000000 | calc=658.6 | delta=0.01
rowid=1390 | ref=FA2607-0260 | datef=2026-07-01 | qty=5 | subprice=38.24900000 | remise_percent=0 | total_ht=191.25000000 | calc=191.24 | delta=0.01
rowid=751 | ref=FA2601-0127 | datef=2026-01-27 | qty=3 | subprice=44.87500000 | remise_percent=0 | total_ht=134.63000000 | calc=134.62 | delta=0.01
rowid=485 | ref=FA2512-0097 | datef=2025-12-22 | qty=1 | subprice=200.10000000 | remise_percent=15 | total_ht=170.09000000 | calc=170.08 | delta=0.01
rowid=448 | ref=FA2512-0088 | datef=2025-12-22 | qty=4 | subprice=37.37500000 | remise_percent=5 | total_ht=142.03000000 | calc=142.02 | delta=0.01
rowid=334 | ref=FA2510-0067 | datef=2025-10-19 | qty=6 | subprice=23.24000000 | remise_percent=0 | total_ht=139.43000000 | calc=139.44 | delta=-0.01
(28 lignes)

===== E. Meme controle sur les lignes de COMMANDE =====
nb=361 | ecarts=6
(1 lignes)

===== F. Meme controle sur les lignes de DEVIS =====
nb=2376 | ecarts=33
(1 lignes)

===== G. Detail commandes en ecart =====
rowid=387 | ref=CO2610-0056 | lid=1851 | qty=1 | subprice=32.48500000 | total_ht=32.49000000 | calc=32.48 | delta=0.01 | description=ALU 15/10 Satiné - RAL 7016 - DEV:425mm LONG:1000mm (2 plis) EXT - Précadre — appui (face 332, rejingot 18, recul 45, oreilles 40) - Options: Perçage / usinage spécifique
rowid=387 | ref=CO2610-0056 | lid=1858 | qty=2 | subprice=21.37250000 | total_ht=42.75000000 | calc=42.74 | delta=0.01 | description=ALU 15/10 Satiné - RAL 7016 - DEV:145mm LONG:2500mm (4 plis) EXT - Double Pince
rowid=390 | ref=CO2610-0059 | lid=1874 | qty=1 | subprice=21.12500000 | total_ht=21.13000000 | calc=21.12 | delta=0.01 | description=ALU 15/10 Satiné - RAL 7016 - DEV:95mm LONG:2500mm (2 plis) EXT
rowid=335 | ref=CO2609-0007 | lid=1389 | qty=1 | subprice=96.98500000 | total_ht=96.99000000 | calc=96.98 | delta=0.01 | description=ALU 15/10 Texturé - RAL 9005 - DEV:390mm LONG:2500mm (4 plis) EXT - Précadre — jambage GAUCHE (joue 265, L = tableau + 46) - Options: Perçage / usinage spécifique
rowid=335 | ref=CO2609-0007 | lid=1391 | qty=1 | subprice=96.98500000 | total_ht=96.99000000 | calc=96.98 | delta=0.01 | description=ALU 15/10 Texturé - RAL 9005 - DEV:390mm LONG:2500mm (4 plis) INT - Précadre — jambage DROIT (joue 265, L = tableau + 46) - Options: Perçage / usinage spécifique
rowid=383 | ref=CO2610-0052 | lid=1832 | qty=23 | subprice=28.63500000 | total_ht=658.61000000 | calc=658.6 | delta=0.01 | description=ALU 15/10 Satiné - RAL 7003 - DEV:300mm LONG:1750mm (3 plis) EXT
(6 lignes)

===== H. FA2607-0291 =====
rowid=313 | ref=FA2607-0291 | datef=2026-07-29 | total_ttc=32.67000000 | paye=1 | fk_statut=2
(1 lignes)

===== H2. Paiements FA2607-0291 =====
rowid=368 | fk_paiement=131 | ref=PAY2609-0126 | datep=2026-09-01 00:00:00 | amount=14136.63000000 | impute=32.67000000 | fk_bank=457
(1 lignes)

FIN