===== 4. Comptes bancaires (label/clos) ===== rowid=1 | ref=Tekni-pli | label=Compte Courant | bank=Crédit Agricole de Normandie | clos=0 | courant=1 | entity=1 | number=84894873336 | comment= rowid=2 | ref=HIST25 | label=Historique 2025 (exercice clos) — ne pas utiliser | bank= | clos=1 | courant=0 | entity=1 | number= | comment= (2 lignes) ===== A. Montants au centime ===== ref=PAY2505-0014 | datep=2025-05-17 12:00:00 | fref=FA2507-0013 | datef=2025-07-23 | jours=67 | montant_paiement=59.04 | ttc_facture=59.04 | ecart=0 ref=PAY2507-0015 | datep=2025-07-08 12:00:00 | fref=FA2509-0043 | datef=2025-09-18 | jours=72 | montant_paiement=438.00 | ttc_facture=438.00 | ecart=0 (2 lignes) ===== B. Une seule facture par paiement ? ===== fk_paiement=14 | nb_factures=1 | total=59.04 fk_paiement=15 | nb_factures=1 | total=438 (2 lignes) ===== C. Compte 1 : lignes non rapprochees ===== rowid=49 | dateo=2026-01-16 | amount=973.68000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL rowid=52 | dateo=2026-01-22 | amount=432.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL rowid=54 | dateo=2026-02-05 | amount=499.11000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL rowid=100 | dateo=2026-06-26 | amount=832.23000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL (4 lignes) ===== D. Solde compte courant ===== solde_compte1=16033.9 (1 lignes) ===== E. Tous les paiements du compte 2 vs date facture ===== rowid=15 | ref=PAY2507-0015 | datep=2025-07-08 | fref=FA2509-0043 | datef=2025-09-18 | jours=72 | amount=438.00000000 rowid=14 | ref=PAY2505-0014 | datep=2025-05-17 | fref=FA2507-0013 | datef=2025-07-23 | jours=67 | amount=59.04000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0104 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0105 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0106 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0107 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0108 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0110 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0111 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=12 | ref=PAY2510-0012 | datep=2025-10-04 | fref=FA2510-0048 | datef=2025-10-04 | jours=0 | amount=5958.77000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0101 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0112 | datef=2025-12-23 | jours=0 | amount=7282.93000000 rowid=32 | ref=PAY2512-0031 | datep=2025-12-05 | fref=FA2512-0078 | datef=2025-12-04 | jours=-1 | amount=2725.90000000 rowid=36 | ref=PAY2512-0035 | datep=2025-12-23 | fref=FA2512-0089 | datef=2025-12-22 | jours=-1 | amount=7282.93000000 rowid=23 | ref=PAY2510-0023 | datep=2025-10-23 | fref=FA2510-0069 | datef=2025-10-22 | jours=-1 | amount=8884.06000000 rowid=35 | ref=PAY2512-0034 | datep=2025-12-23 | fref=FA2512-0086 | datef=2025-12-22 | jours=-1 | amount=720.00000000 rowid=32 | ref=PAY2512-0031 | datep=2025-12-05 | fref=FA2512-0079 | datef=2025-12-04 | jours=-1 | amount=2725.90000000 rowid=32 | ref=PAY2512-0031 | datep=2025-12-05 | fref=FA2512-0080 | datef=2025-12-04 | jours=-1 | amount=2725.90000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0019 | datef=2025-07-24 | jours=-1 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0018 | datef=2025-07-24 | jours=-1 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0017 | datef=2025-07-24 | jours=-1 | amount=10333.87000000 rowid=27 | ref=PAY2511-0027 | datep=2025-11-24 | fref=FA2511-0074 | datef=2025-11-22 | jours=-2 | amount=149.34000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0006 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0008 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0009 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0010 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0014 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0015 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0016 | datef=2025-07-23 | jours=-2 | amount=10333.87000000 rowid=20 | ref=PAY2510-0020 | datep=2025-10-21 | fref=FA2510-0059 | datef=2025-10-19 | jours=-2 | amount=2223.85000000 rowid=20 | ref=PAY2510-0020 | datep=2025-10-21 | fref=FA2510-0068 | datef=2025-10-19 | jours=-2 | amount=2223.85000000 rowid=13 | ref=PAY2510-0013 | datep=2025-10-07 | fref=FA2510-0049 | datef=2025-10-04 | jours=-3 | amount=1761.17000000 rowid=6 | ref=PAY2509-0006 | datep=2025-09-17 | fref=FA2509-0037 | datef=2025-09-14 | jours=-3 | amount=4899.73000000 rowid=6 | ref=PAY2509-0006 | datep=2025-09-17 | fref=FA2509-0036 | datef=2025-09-14 | jours=-3 | amount=4899.73000000 rowid=6 | ref=PAY2509-0006 | datep=2025-09-17 | fref=FA2509-0035 | datef=2025-09-14 | jours=-3 | amount=4899.73000000 rowid=23 | ref=PAY2510-0023 | datep=2025-10-23 | fref=FA2510-0060 | datef=2025-10-19 | jours=-4 | amount=8884.06000000 rowid=10 | ref=PAY2509-0010 | datep=2025-09-22 | fref=FA2509-0042 | datef=2025-09-18 | jours=-4 | amount=77.23000000 rowid=23 | ref=PAY2510-0023 | datep=2025-10-23 | fref=FA2510-0062 | datef=2025-10-19 | jours=-4 | amount=8884.06000000 rowid=23 | ref=PAY2510-0023 | datep=2025-10-23 | fref=FA2510-0063 | datef=2025-10-19 | jours=-4 | amount=8884.06000000 rowid=23 | ref=PAY2510-0023 | datep=2025-10-23 | fref=FA2510-0064 | datef=2025-10-19 | jours=-4 | amount=8884.06000000 rowid=23 | ref=PAY2510-0023 | datep=2025-10-23 | fref=FA2510-0067 | datef=2025-10-19 | jours=-4 | amount=8884.06000000 rowid=11 | ref=PAY2509-0011 | datep=2025-09-24 | fref=FA2509-0045 | datef=2025-09-19 | jours=-5 | amount=2954.39000000 rowid=11 | ref=PAY2509-0011 | datep=2025-09-24 | fref=FA2509-0046 | datef=2025-09-19 | jours=-5 | amount=2954.39000000 rowid=11 | ref=PAY2509-0011 | datep=2025-09-24 | fref=FA2509-0044 | datef=2025-09-18 | jours=-6 | amount=2954.39000000 rowid=11 | ref=PAY2509-0011 | datep=2025-09-24 | fref=FA2509-0040 | datef=2025-09-18 | jours=-6 | amount=2954.39000000 rowid=11 | ref=PAY2509-0011 | datep=2025-09-24 | fref=FA2509-0039 | datef=2025-09-18 | jours=-6 | amount=2954.39000000 rowid=6 | ref=PAY2509-0006 | datep=2025-09-17 | fref=FA2509-0034 | datef=2025-09-11 | jours=-6 | amount=4899.73000000 rowid=37 | ref=PAY2512-0036 | datep=2025-12-29 | fref=FA2512-0115 | datef=2025-12-23 | jours=-6 | amount=1288.09000000 rowid=4 | ref=PAY2507-0004 | datep=2025-07-25 | fref=FA2507-0004 | datef=2025-07-19 | jours=-6 | amount=10333.87000000 rowid=25 | ref=PAY2512-0025 | datep=2025-12-05 | fref=FA2511-0075 | datef=2025-11-28 | jours=-7 | amount=10082.97000000 rowid=34 | ref=PAY2512-0033 | datep=2025-12-29 | fref=FA2512-0097 | datef=2025-12-22 | jours=-7 | amount=204.10000000 rowid=43 | ref=PAY2512-0042 | datep=2025-12-30 | fref=FA2512-0114 | datef=2025-12-23 | jours=-7 | amount=92.22000000 rowid=41 | ref=PAY2512-0040 | datep=2025-12-31 | fref=FA2512-0100 | datef=2025-12-22 | jours=-9 | amount=137.60000000 rowid=5 | ref=PAY2509-0005 | datep=2025-09-17 | fref=FA2509-0032 | datef=2025-09-08 | jours=-9 | amount=2740.47000000 rowid=5 | ref=PAY2509-0005 | datep=2025-09-17 | fref=FA2509-0030 | datef=2025-09-08 | jours=-9 | amount=2740.47000000 rowid=9 | ref=PAY2509-0009 | datep=2025-09-28 | fref=FA2509-0041 | datef=2025-09-18 | jours=-10 | amount=360.00000000 rowid=7 | ref=PAY2509-0007 | datep=2025-09-19 | fref=FA2509-0033 | datef=2025-09-09 | jours=-10 | amount=5476.03000000 rowid=1 | ref=PAY2509-0001 | datep=2025-09-09 | fref=FA2508-0022 | datef=2025-08-29 | jours=-11 | amount=4085.45000000 rowid=2 | ref=PAY2507-0002 | datep=2025-07-22 | fref=FA2507-0001 | datef=2025-07-09 | jours=-13 | amount=5344.17000000 rowid=6 | ref=PAY2509-0006 | datep=2025-09-17 | fref=FA2509-0029 | datef=2025-09-03 | jours=-14 | amount=4899.73000000 rowid=8 | ref=PAY2509-0008 | datep=2025-09-23 | fref=FA2509-0031 | datef=2025-09-08 | jours=-15 | amount=452.74000000 rowid=6 | ref=PAY2509-0006 | datep=2025-09-17 | fref=FA2509-0023 | datef=2025-09-01 | jours=-16 | amount=4899.73000000 rowid=24 | ref=PAY2511-0024 | datep=2025-11-04 | fref=FA2510-0065 | datef=2025-10-19 | jours=-16 | amount=3600.00000000 rowid=22 | ref=PAY2510-0022 | datep=2025-10-23 | fref=FA2510-0050 | datef=2025-10-04 | jours=-19 | amount=2775.50000000 rowid=33 | ref=PAY2512-0032 | datep=2025-12-23 | fref=FA2511-0076 | datef=2025-11-28 | jours=-25 | amount=208.51000000 rowid=42 | ref=PAY2512-0041 | datep=2025-12-31 | fref=FA2512-0085 | datef=2025-12-05 | jours=-26 | amount=11282.52000000 rowid=42 | ref=PAY2512-0041 | datep=2025-12-31 | fref=FA2512-0084 | datef=2025-12-04 | jours=-27 | amount=11282.52000000 rowid=42 | ref=PAY2512-0041 | datep=2025-12-31 | fref=FA2512-0083 | datef=2025-12-04 | jours=-27 | amount=11282.52000000 rowid=3 | ref=PAY2508-0003 | datep=2025-08-21 | fref=FA2507-0005 | datef=2025-07-22 | jours=-30 | amount=478.80000000 rowid=39 | ref=PAY2512-0038 | datep=2025-12-11 | fref=FA2511-0072 | datef=2025-11-11 | jours=-30 | amount=4934.76000000 rowid=31 | ref=PAY2511-0030 | datep=2025-11-06 | fref=FA2510-0051 | datef=2025-10-06 | jours=-31 | amount=24.00000000 rowid=28 | ref=PAY2511-0028 | datep=2025-11-13 | fref=FA2510-0054 | datef=2025-10-13 | jours=-31 | amount=391.20000000 rowid=28 | ref=PAY2511-0028 | datep=2025-11-13 | fref=FA2510-0053 | datef=2025-10-13 | jours=-31 | amount=391.20000000 rowid=28 | ref=PAY2511-0028 | datep=2025-11-13 | fref=FA2510-0052 | datef=2025-10-13 | jours=-31 | amount=391.20000000 rowid=30 | ref=PAY2511-0029 | datep=2025-11-20 | fref=FA2510-0055 | datef=2025-10-16 | jours=-35 | amount=432.00000000 rowid=21 | ref=PAY2510-0021 | datep=2025-10-23 | fref=FA2509-0038 | datef=2025-09-17 | jours=-36 | amount=960.00000000 rowid=39 | ref=PAY2512-0038 | datep=2025-12-11 | fref=FA2511-0071 | datef=2025-11-05 | jours=-36 | amount=4934.76000000 rowid=39 | ref=PAY2512-0038 | datep=2025-12-11 | fref=FA2511-0070 | datef=2025-11-05 | jours=-36 | amount=4934.76000000 rowid=16 | ref=PAY2510-0016 | datep=2025-10-09 | fref=FA2509-0024 | datef=2025-09-01 | jours=-38 | amount=3702.96000000 rowid=16 | ref=PAY2510-0016 | datep=2025-10-09 | fref=FA2509-0025 | datef=2025-09-01 | jours=-38 | amount=3702.96000000 rowid=16 | ref=PAY2510-0016 | datep=2025-10-09 | fref=FA2509-0026 | datef=2025-09-01 | jours=-38 | amount=3702.96000000 rowid=16 | ref=PAY2510-0016 | datep=2025-10-09 | fref=FA2509-0027 | datef=2025-09-01 | jours=-38 | amount=3702.96000000 rowid=38 | ref=PAY2512-0037 | datep=2025-12-29 | fref=FA2511-0073 | datef=2025-11-19 | jours=-40 | amount=1369.58000000 rowid=26 | ref=PAY2511-0026 | datep=2025-11-27 | fref=FA2510-0056 | datef=2025-10-16 | jours=-42 | amount=710.64000000 rowid=40 | ref=PAY2512-0039 | datep=2025-12-30 | fref=FA2510-0057 | datef=2025-10-19 | jours=-72 | amount=5272.56000000 rowid=40 | ref=PAY2512-0039 | datep=2025-12-30 | fref=FA2510-0058 | datef=2025-10-19 | jours=-72 | amount=5272.56000000 rowid=40 | ref=PAY2512-0039 | datep=2025-12-30 | fref=FA2510-0061 | datef=2025-10-19 | jours=-72 | amount=5272.56000000 rowid=40 | ref=PAY2512-0039 | datep=2025-12-30 | fref=FA2510-0066 | datef=2025-10-19 | jours=-72 | amount=5272.56000000 rowid=19 | ref=PAY2510-0019 | datep=2025-10-14 | fref=FA2507-0007 | datef=2025-07-23 | jours=-83 | amount=456.42000000 rowid=18 | ref=PAY2510-0018 | datep=2025-10-14 | fref=FA2507-0011 | datef=2025-07-23 | jours=-83 | amount=21.91000000 rowid=17 | ref=PAY2510-0017 | datep=2025-10-14 | fref=FA2507-0012 | datef=2025-07-23 | jours=-83 | amount=684.35000000 (91 lignes) ===== F. Paiements voisins (contexte de saisie) ===== rowid=13 | ref=PAY2510-0013 | datec=2025-10-08 15:08:19 | tms=2025-10-08 15:08:19 | datep=2025-10-07 12:00:00 rowid=14 | ref=PAY2505-0014 | datec=2025-10-08 16:13:59 | tms=2025-10-08 16:14:00 | datep=2025-05-17 12:00:00 rowid=15 | ref=PAY2507-0015 | datec=2025-10-08 16:16:07 | tms=2025-10-08 16:16:07 | datep=2025-07-08 12:00:00 rowid=16 | ref=PAY2510-0016 | datec=2025-10-13 16:42:33 | tms=2025-10-13 16:42:34 | datep=2025-10-09 12:00:00 rowid=17 | ref=PAY2510-0017 | datec=2025-11-13 11:16:17 | tms=2025-11-13 11:16:17 | datep=2025-10-14 12:00:00 (5 lignes) ===== G. Nb ecritures comptables ===== nb=0 (1 lignes)