=== A1 facture FA2607-0291 === SQL: SELECT rowid,ref,ref_ext,entity,fk_soc,type,datef,total_ht,total_tva,total_ttc,paye,fk_statut,close_code,close_note,tms,datec FROM llx_facture WHERE ref='FA2607-0291' [1] rowid=313 | ref=FA2607-0291 | ref_ext=NULL | entity=1 | fk_soc=251 | type=0 | datef=2026-07-29 | total_ht=27.22000000 | total_tva=5.45000000 | total_ttc=32.67000000 | paye=1 | fk_statut=2 | close_code=NULL | close_note=NULL | tms=2026-10-21 12:54:37 | datec=2026-07-29 08:08:30 === A2 tiers de la facture === SQL: SELECT f.rowid,f.ref,s.rowid as socid,s.nom FROM llx_facture f LEFT JOIN llx_societe s ON s.rowid=f.fk_soc WHERE f.ref='FA2607-0291' [1] rowid=313 | ref=FA2607-0291 | socid=251 | nom=SARL MAC === A3 lignes de la facture === SQL: SELECT rowid,fk_facture,description,qty,total_ht,total_ttc,product_type,fk_product FROM llx_facturedet WHERE fk_facture=(SELECT rowid FROM llx_facture WHERE ref='FA2607-0291') [1] rowid=1520 | fk_facture=313 | description=ALU 15/10 Satiné - RAL 7039 S - DEV:40mm LONG:3000mm (1 plis) INT | qty=4 | total_ht=27.22000000 | total_ttc=32.67000000 | product_type=0 | fk_product=NULL === A4 paiements affectes a la facture === SQL: SELECT pf.rowid,pf.fk_paiement,pf.fk_facture,pf.amount,pf.multicurrency_amount FROM llx_paiement_facture pf WHERE pf.fk_facture=(SELECT rowid FROM llx_facture WHERE ref='FA2607-0291') [1] rowid=368 | fk_paiement=131 | fk_facture=313 | amount=32.67000000 | multicurrency_amount=32.67000000 === A5 total regle sur la facture === SQL: SELECT COALESCE(SUM(pf.amount),0) as total_regle FROM llx_paiement_facture pf WHERE pf.fk_facture=(SELECT rowid FROM llx_facture WHERE ref='FA2607-0291') [1] total_regle=32.67000000 === A6 toutes les factures du tiers === SQL: SELECT f.rowid,f.ref,f.datef,f.total_ttc,f.paye,f.fk_statut FROM llx_facture f WHERE f.fk_soc=(SELECT fk_soc FROM llx_facture WHERE ref='FA2607-0291') ORDER BY f.rowid [1] rowid=82 | ref=FA2511-0075 | datef=2025-11-28 | total_ttc=10082.97000000 | paye=1 | fk_statut=2 [2] rowid=96 | ref=FA2512-0088 | datef=2025-12-22 | total_ttc=1141.82000000 | paye=1 | fk_statut=2 [3] rowid=98 | ref=FA2512-0090 | datef=2025-12-22 | total_ttc=1458.46000000 | paye=1 | fk_statut=2 [4] rowid=99 | ref=FA2512-0091 | datef=2025-12-22 | total_ttc=178.49000000 | paye=1 | fk_statut=2 [5] rowid=100 | ref=FA2512-0092 | datef=2025-12-22 | total_ttc=261.55000000 | paye=1 | fk_statut=2 [6] rowid=153 | ref=FA2602-0135 | datef=2026-02-10 | total_ttc=2685.10000000 | paye=1 | fk_statut=2 [7] rowid=155 | ref=FA2602-0136 | datef=2026-02-10 | total_ttc=5179.15000000 | paye=1 | fk_statut=2 [8] rowid=156 | ref=FA2602-0137 | datef=2026-02-10 | total_ttc=3221.73000000 | paye=1 | fk_statut=2 [9] rowid=157 | ref=FA2602-0138 | datef=2026-02-10 | total_ttc=907.59000000 | paye=1 | fk_statut=2 [10] rowid=158 | ref=FA2602-0139 | datef=2026-02-10 | total_ttc=500.36000000 | paye=1 | fk_statut=2 [11] rowid=172 | ref=FA2603-0152 | datef=2026-03-14 | total_ttc=7490.81000000 | paye=1 | fk_statut=2 [12] rowid=175 | ref=FA2603-0155 | datef=2026-03-14 | total_ttc=855.22000000 | paye=1 | fk_statut=2 [13] rowid=176 | ref=FA2603-0156 | datef=2026-03-14 | total_ttc=4392.57000000 | paye=1 | fk_statut=2 [14] rowid=177 | ref=FA2603-0157 | datef=2026-03-14 | total_ttc=1087.56000000 | paye=1 | fk_statut=2 [15] rowid=179 | ref=FA2603-0159 | datef=2026-03-14 | total_ttc=515.37000000 | paye=1 | fk_statut=2 [16] rowid=188 | ref=FA2604-0168 | datef=2026-04-08 | total_ttc=407.81000000 | paye=1 | fk_statut=2 [17] rowid=189 | ref=FA2604-0169 | datef=2026-04-08 | total_ttc=178.41000000 | paye=1 | fk_statut=2 [18] rowid=190 | ref=FA2604-0170 | datef=2026-04-08 | total_ttc=2447.51000000 | paye=1 | fk_statut=2 [19] rowid=191 | ref=FA2604-0171 | datef=2026-04-08 | total_ttc=118.71000000 | paye=1 | fk_statut=2 [20] rowid=192 | ref=FA2604-0172 | datef=2026-04-08 | total_ttc=118.50000000 | paye=1 | fk_statut=2 [21] rowid=193 | ref=FA2604-0173 | datef=2026-04-08 | total_ttc=8542.95000000 | paye=1 | fk_statut=2 [22] rowid=195 | ref=FA2604-0175 | datef=2026-04-17 | total_ttc=40.49000000 | paye=1 | fk_statut=2 [23] rowid=202 | ref=FA2604-0182 | datef=2026-04-18 | total_ttc=89.29000000 | paye=1 | fk_statut=2 [24] rowid=211 | ref=FA2604-0191 | datef=2026-04-18 | total_ttc=185.43000000 | paye=1 | fk_statut=2 [25] rowid=213 | ref=FA2604-0193 | datef=2026-04-18 | total_ttc=227.85000000 | paye=1 | fk_statut=2 [26] rowid=216 | ref=FA2604-0196 | datef=2026-04-18 | total_ttc=885.39000000 | paye=1 | fk_statut=2 [27] rowid=217 | ref=FA2604-0197 | datef=2026-04-18 | total_ttc=206.35000000 | paye=1 | fk_statut=2 [28] rowid=230 | ref=FA2604-0209 | datef=2026-04-18 | total_ttc=1912.40000000 | paye=1 | fk_statut=2 [29] rowid=234 | ref=FA2605-0212 | datef=2026-05-11 | total_ttc=736.71000000 | paye=1 | fk_statut=2 [30] rowid=235 | ref=FA2605-0213 | datef=2026-05-11 | total_ttc=6171.83000000 | paye=1 | fk_statut=2 [31] rowid=236 | ref=FA2605-0214 | datef=2026-05-11 | total_ttc=359.77000000 | paye=1 | fk_statut=2 [32] rowid=240 | ref=FA2605-0218 | datef=2026-05-12 | total_ttc=335.00000000 | paye=1 | fk_statut=2 [33] rowid=241 | ref=FA2605-0219 | datef=2026-05-12 | total_ttc=295.37000000 | paye=1 | fk_statut=2 [34] rowid=242 | ref=FA2605-0220 | datef=2026-05-20 | total_ttc=2388.72000000 | paye=1 | fk_statut=2 [35] rowid=246 | ref=FA2605-0224 | datef=2026-05-21 | total_ttc=3916.11000000 | paye=1 | fk_statut=2 [36] rowid=249 | ref=FA2605-0227 | datef=2026-05-26 | total_ttc=5114.81000000 | paye=1 | fk_statut=2 [37] rowid=252 | ref=FA2605-0230 | datef=2026-05-29 | total_ttc=521.88000000 | paye=1 | fk_statut=2 [38] rowid=253 | ref=FA2605-0231 | datef=2026-05-29 | total_ttc=457.28000000 | paye=1 | fk_statut=2 [39] rowid=258 | ref=FA2606-0236 | datef=2026-06-04 | total_ttc=32.10000000 | paye=1 | fk_statut=2 [40] rowid=260 | ref=FA2606-0238 | datef=2026-06-09 | total_ttc=2164.68000000 | paye=1 | fk_statut=2 [41] rowid=262 | ref=FA2606-0240 | datef=2026-06-09 | total_ttc=2059.08000000 | paye=1 | fk_statut=2 [42] rowid=269 | ref=FA2606-0247 | datef=2026-06-19 | total_ttc=70.36000000 | paye=1 | fk_statut=2 [43] rowid=270 | ref=FA2606-0248 | datef=2026-06-22 | total_ttc=325.68000000 | paye=1 | fk_statut=2 [44] rowid=276 | ref=FA2606-0254 | datef=2026-06-29 | total_ttc=1082.34000000 | paye=1 | fk_statut=2 [45] rowid=279 | ref=FA2606-0257 | datef=2026-06-29 | total_ttc=1066.64000000 | paye=1 | fk_statut=2 [46] rowid=280 | ref=FA2606-0258 | datef=2026-06-29 | total_ttc=348.17000000 | paye=1 | fk_statut=2 [47] rowid=284 | ref=FA2607-0262 | datef=2026-07-09 | total_ttc=488.14000000 | paye=1 | fk_statut=2 [48] rowid=286 | ref=FA2607-0264 | datef=2026-07-10 | total_ttc=1917.96000000 | paye=1 | fk_statut=2 [49] rowid=288 | ref=FA2607-0266 | datef=2026-07-10 | total_ttc=2790.87000000 | paye=1 | fk_statut=2 [50] rowid=289 | ref=FA2607-0267 | datef=2026-07-13 | total_ttc=177.19000000 | paye=1 | fk_statut=2 [51] rowid=290 | ref=FA2607-0268 | datef=2026-07-15 | total_ttc=2790.87000000 | paye=1 | fk_statut=2 [52] rowid=291 | ref=FA2607-0269 | datef=2026-07-15 | total_ttc=2790.87000000 | paye=1 | fk_statut=2 [53] rowid=292 | ref=FA2607-0270 | datef=2026-07-16 | total_ttc=633.76000000 | paye=1 | fk_statut=2 [54] rowid=301 | ref=FA2607-0279 | datef=2026-07-21 | total_ttc=1737.31000000 | paye=1 | fk_statut=2 [55] rowid=308 | ref=FA2607-0286 | datef=2026-07-27 | total_ttc=376.05000000 | paye=1 | fk_statut=2 [56] rowid=309 | ref=FA2607-0287 | datef=2026-07-27 | total_ttc=1989.88000000 | paye=1 | fk_statut=2 [57] rowid=313 | ref=FA2607-0291 | datef=2026-07-29 | total_ttc=32.67000000 | paye=1 | fk_statut=2 [58] rowid=314 | ref=FA2607-0292 | datef=2026-07-29 | total_ttc=27.07000000 | paye=1 | fk_statut=2 [59] rowid=315 | ref=FA2607-0293 | datef=2026-07-29 | total_ttc=49.00000000 | paye=1 | fk_statut=2 [60] rowid=316 | ref=FA2607-0294 | datef=2026-07-29 | total_ttc=204.27000000 | paye=1 | fk_statut=2 [61] rowid=318 | ref=FA2607-0296 | datef=2026-07-30 | total_ttc=541.47000000 | paye=1 | fk_statut=2 [62] rowid=322 | ref=FA2608-0300 | datef=2026-08-03 | total_ttc=478.20000000 | paye=1 | fk_statut=2 [63] rowid=324 | ref=FA2608-0302 | datef=2026-08-03 | total_ttc=593.63000000 | paye=1 | fk_statut=2 [64] rowid=329 | ref=FA2608-0307 | datef=2026-08-03 | total_ttc=344.12000000 | paye=1 | fk_statut=2 [65] rowid=352 | ref=FA2608-0330 | datef=2026-08-07 | total_ttc=1370.27000000 | paye=1 | fk_statut=2 [66] rowid=391 | ref=FA2608-0352 | datef=2026-08-31 | total_ttc=2914.67000000 | paye=0 | fk_statut=1 [67] rowid=392 | ref=FA2608-0353 | datef=2026-08-31 | total_ttc=601.50000000 | paye=0 | fk_statut=1 [68] rowid=432 | ref=FA2610-0390 | datef=2026-10-21 | total_ttc=8817.24000000 | paye=0 | fk_statut=1 === B1 llx_bank #453 === SQL: SELECT rowid,datec,dateo,datev,amount,label,fk_account,fk_type,num_chq,num_releve,rappro,fk_user_author,fk_user_rappro,note,fk_bordereau FROM llx_bank WHERE rowid=453 [1] rowid=453 | datec=2026-08-19 10:28:06 | dateo=2026-07-31 | datev=2026-07-31 | amount=32.57000000 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | fk_account=1 | fk_type=VIR | num_chq=NULL | num_releve=202607 | rappro=1 | fk_user_author=1 | fk_user_rappro=1 | note=Justification (corrigé le 19/08/2026, contrôle adverse) : ce crédit de 32,57 € figurait au relevé du Crédit Agricole sous le libellé « AVOIR CARTE X4074 INPI VADS 30/07 » et avait été enregistré à tort comme un RÈGLEMENT CLIENT de SARL MAC sur la facture FA2607-0291 (paiement #112, ligne bancaire #126, tous deux supprimés). C'est le remboursement partiel de la redevance INPI payée le 21/07 (225,77 €, paiement divers #96, compte 6354) : il vient donc en diminution de cette charge. FA2607-0291 (32,67 €) reste due par SARL MAC. | fk_bordereau=0 === B2 llx_bank_url de #453 === SQL: SELECT rowid,fk_bank,url_id,url,label,type FROM llx_bank_url WHERE fk_bank=453 [1] rowid=803 | fk_bank=453 | url_id=105 | url=/compta/bank/various_payment/card.php?id= | label=(VariousPayment) | type=payment_various === B3 llx_payment_various #105 === SQL: SELECT rowid,tms,datec,datep,datev,sens,amount,fk_typepayment,num_payment,label,accountancy_code,subledger_account,fk_bank,fk_user_author,fk_user_modif,entity,fk_projet,note FROM llx_payment_various WHERE rowid=105 [1] rowid=105 | tms=2026-08-19 10:45:57 | datec=2026-08-19 10:28:06 | datep=2026-07-31 | datev=2026-07-31 | sens=1 | amount=32.57000000 | fk_typepayment=2 | num_payment= | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | accountancy_code=6354 | subledger_account= | fk_bank=453 | fk_user_author=1 | fk_user_modif=NULL | entity=1 | fk_projet=0 | note=Justification (corrigé le 19/08/2026, contrôle adverse) : ce crédit de 32,57 € figurait au relevé du Crédit Agricole sous le libellé « AVOIR CARTE X4074 INPI VADS 30/07 » et avait été enregistré à tort comme un RÈGLEMENT CLIENT de SARL MAC sur la facture FA2607-0291 (paiement #112, ligne bancaire #126, tous deux supprimés). C'est le remboursement partiel de la redevance INPI payée le 21/07 (225,77 €, paiement divers #96, compte 6354) : il vient donc en diminution de cette charge. FA2607-0291 (32,67 €) reste due par SARL MAC. === B4 toute ligne bancaire de 32.57 sur compte 1 === SQL: SELECT rowid,dateo,datev,amount,label,num_releve,rappro,fk_account FROM llx_bank WHERE fk_account=1 AND amount=32.57 [1] rowid=453 | dateo=2026-07-31 | datev=2026-07-31 | amount=32.57000000 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | num_releve=202607 | rappro=1 | fk_account=1 === B5 tout paiement divers de 32.57 === SQL: SELECT rowid,amount,sens,fk_bank,accountancy_code,datep,label FROM llx_payment_various WHERE amount=32.57 [1] rowid=105 | amount=32.57000000 | sens=1 | fk_bank=453 | accountancy_code=6354 | datep=2026-07-31 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque === C1 llx_bank #126 (doit etre vide) === SQL: SELECT rowid,dateo,amount,label,fk_account,num_releve,rappro FROM llx_bank WHERE rowid=126 (aucune ligne) === C2 llx_bank_url fk_bank=126 (doit etre vide) === SQL: SELECT rowid,fk_bank,url_id,url,label,type FROM llx_bank_url WHERE fk_bank=126 (aucune ligne) === C3 llx_bank_url url_id=112 type paiement (doit etre vide) === SQL: SELECT rowid,fk_bank,url_id,url,label,type FROM llx_bank_url WHERE url_id=112 AND type IN ('payment','payment_various','payment_supplier') [1] rowid=455 | fk_bank=226 | url_id=112 | url=/fourn/paiement/card.php?id= | label=(paiement) | type=payment_supplier [2] rowid=858 | fk_bank=484 | url_id=112 | url=/compta/bank/various_payment/card.php?id= | label=(VariousPayment) | type=payment_various === C4 llx_paiement #112 (doit etre vide) === SQL: SELECT rowid,datec,datep,amount,fk_bank,fk_paiement,num_paiement,note FROM llx_paiement WHERE rowid=112 (aucune ligne) === C5 llx_paiement_facture fk_paiement=112 (doit etre vide) === SQL: SELECT rowid,fk_paiement,fk_facture,amount FROM llx_paiement_facture WHERE fk_paiement=112 (aucune ligne) === C6 llx_paiement pointant sur bank 126 (doit etre vide) === SQL: SELECT rowid,datep,amount,fk_bank FROM llx_paiement WHERE fk_bank=126 (aucune ligne) === C7 llx_bank_url orphelins (fk_bank inexistant) === SQL: SELECT bu.rowid,bu.fk_bank,bu.type,bu.url_id FROM llx_bank_url bu LEFT JOIN llx_bank b ON b.rowid=bu.fk_bank WHERE b.rowid IS NULL (aucune ligne) === C8 llx_paiement_facture orphelins === SQL: SELECT pf.rowid,pf.fk_paiement,pf.fk_facture,pf.amount FROM llx_paiement_facture pf LEFT JOIN llx_paiement p ON p.rowid=pf.fk_paiement WHERE p.rowid IS NULL (aucune ligne) === C9 llx_paiement pointant sur une ligne bancaire disparue === SQL: SELECT p.rowid,p.amount,p.fk_bank FROM llx_paiement p LEFT JOIN llx_bank b ON b.rowid=p.fk_bank WHERE p.fk_bank>0 AND b.rowid IS NULL (aucune ligne) === C10 payment_various orphelins === SQL: SELECT pv.rowid,pv.amount,pv.fk_bank FROM llx_payment_various pv LEFT JOIN llx_bank b ON b.rowid=pv.fk_bank WHERE pv.fk_bank>0 AND b.rowid IS NULL (aucune ligne) === C11 max rowid llx_bank === SQL: SELECT MAX(rowid) as maxbank FROM llx_bank [1] maxbank=535 === C12 max rowid llx_paiement === SQL: SELECT MAX(rowid) as maxpaiement FROM llx_paiement [1] maxpaiement=148 === C13 max rowid payment_various === SQL: SELECT MAX(rowid) as maxpv FROM llx_payment_various [1] maxpv=123 === D1 solde total compte 1 === SQL: SELECT COUNT(*) as nb, ROUND(SUM(amount),2) as solde FROM llx_bank WHERE fk_account=1 [1] nb=429 | solde=16033.9 === D2 solde rapproche compte 1 === SQL: SELECT ROUND(SUM(amount),2) as solde_rappro FROM llx_bank WHERE fk_account=1 AND rappro=1 [1] solde_rappro=13296.88 === D3 totaux par releve === SQL: SELECT num_releve, COUNT(*) nb, ROUND(SUM(amount),2) tot FROM llx_bank WHERE fk_account=1 AND num_releve IS NOT NULL AND num_releve<>'' GROUP BY num_releve ORDER BY num_releve [1] num_releve=202512 | nb=1 | tot=37001.25 [2] num_releve=202601 | nb=34 | tot=-32692.78 [3] num_releve=202602 | nb=29 | tot=21328.77 [4] num_releve=202603 | nb=38 | tot=-13286.85 [5] num_releve=202604 | nb=52 | tot=2668.52 [6] num_releve=202605 | nb=54 | tot=-15988.7 [7] num_releve=202606 | nb=50 | tot=7442.26 [8] num_releve=202607 | nb=63 | tot=994.64 [9] num_releve=202608 | nb=47 | tot=-12843.88 [10] num_releve=202609 | nb=36 | tot=13577.65 [11] num_releve=202610 | nb=21 | tot=5096 === D4 comptes bancaires === SQL: SELECT rowid,ref,label,courant,clos,solde,date_solde FROM llx_bank_account ORDER BY rowid ERREUR: Unknown column 'solde' in 'field list' === D5 solde au 31/07 (dateo) === SQL: SELECT ROUND(SUM(amount),2) as solde_au_3107 FROM llx_bank WHERE fk_account=1 AND dateo<='2026-07-31' [1] solde_au_3107=10204.13 === E1 nb ecritures comptables === SQL: SELECT COUNT(*) as nb_ecritures FROM llx_accounting_bookkeeping [1] nb_ecritures=0 === E2 ecritures 6354 / facture / INPI === SQL: SELECT rowid,doc_date,doc_ref,doc_type,numero_compte,label_compte,debit,credit,fk_doc,fk_docdet FROM llx_accounting_bookkeeping WHERE numero_compte LIKE '6354%' OR doc_ref LIKE '%FA2607-0291%' OR doc_ref LIKE '%INPI%' (aucune ligne) === E3 tous les paiements divers sur 6354 === SQL: SELECT rowid,label,accountancy_code,subledger_account,amount,sens,datep,fk_bank FROM llx_payment_various WHERE accountancy_code LIKE '6354%' ORDER BY datep [1] rowid=96 | label=Redevance INPI — dépôt/renouvellement de marque | accountancy_code=6354 | subledger_account= | amount=225.77000000 | sens=0 | datep=2026-07-21 | fk_bank=431 [2] rowid=105 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | accountancy_code=6354 | subledger_account= | amount=32.57000000 | sens=1 | datep=2026-07-31 | fk_bank=453 === E4 net compte 6354 (paiements divers) === SQL: SELECT ROUND(SUM(CASE WHEN sens=0 THEN amount ELSE 0 END),2) as debit_6354, ROUND(SUM(CASE WHEN sens=1 THEN amount ELSE 0 END),2) as credit_6354, ROUND(SUM(CASE WHEN sens=0 THEN amount ELSE -amount END),2) as net_6354 FROM llx_payment_various WHERE accountancy_code LIKE '6354%' [1] debit_6354=225.77 | credit_6354=32.57 | net_6354=193.2 === E5 factures fournisseur de 32.57/32.67 === SQL: SELECT ff.rowid,ff.ref,ff.datef,ff.total_ht,ff.total_ttc,ff.paye,ff.fk_statut FROM llx_facture_fourn ff WHERE ff.total_ttc IN (32.57,32.67) (aucune ligne) === E6 CA facture juillet 2026 === SQL: SELECT COUNT(*) nb, ROUND(SUM(total_ht),2) ca_ht, ROUND(SUM(total_ttc),2) ttc FROM llx_facture WHERE entity=1 AND fk_statut IN (1,2) AND type IN (0,1,2,3,5) AND datef>='2026-07-01' AND datef<='2026-07-31' [1] nb=42 | ca_ht=32481.43 | ttc=38977.6 === E7 comptes utilises en compta === SQL: SELECT numero_compte,COUNT(*) nb FROM llx_accounting_bookkeeping GROUP BY numero_compte ORDER BY numero_compte (aucune ligne) === F1 lignes bancaires fin juillet === SQL: SELECT rowid,dateo,datev,amount,label,num_releve,rappro,fk_type,num_chq FROM llx_bank WHERE fk_account=1 AND dateo BETWEEN '2026-07-25' AND '2026-08-05' ORDER BY dateo,rowid [1] rowid=274 | dateo=2026-07-27 | datev=2026-07-27 | amount=-21.49000000 | label=(AgentCompta relevé) Prélèvement OVH SAS - OVH - payment for order 254839526 OVH-MWLN9900088F FR90ZZZ460983 TWLN43276712F | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [2] rowid=432 | dateo=2026-07-27 | datev=2026-07-27 | amount=26.40000000 | label=Avoir KDI reçu — remboursement client 3813883 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [3] rowid=102 | dateo=2026-07-28 | datev=2026-07-28 | amount=5015.74000000 | label=(CustomerInvoicePayment) | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [4] rowid=167 | dateo=2026-07-28 | datev=2026-07-28 | amount=-2712.00000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 METALMAQ GAVA 27/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8301280158261 [5] rowid=399 | dateo=2026-07-28 | datev=2026-07-28 | amount=-200.00000000 | label=(AgentCompta) Paiement par carte X7200 CARREFOUR MARKET ST 27/07 | num_releve=202607 | rappro=1 | fk_type=CB | num_chq=NULL [6] rowid=162 | dateo=2026-07-29 | datev=2026-07-29 | amount=-209.00000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8302780170759 [7] rowid=163 | dateo=2026-07-29 | datev=2026-07-29 | amount=-16.62000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8302780170758 [8] rowid=164 | dateo=2026-07-29 | datev=2026-07-29 | amount=-56.59000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8302150175678 [9] rowid=165 | dateo=2026-07-29 | datev=2026-07-29 | amount=-40.79000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8302150175677 [10] rowid=166 | dateo=2026-07-29 | datev=2026-07-29 | amount=-11.75000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8302150175679 [11] rowid=161 | dateo=2026-07-30 | datev=2026-07-30 | amount=-1.24000000 | label=(AgentCompta) PAIEMENT PAR CARTE X7200 INPI VADS 92 COURBEV 29/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=8304270151476 [12] rowid=275 | dateo=2026-07-30 | datev=2026-07-30 | amount=-130.80000000 | label=(AgentCompta relevé) Paiement par carte X7200 MEDIALEX RENNES 29/07 | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [13] rowid=317 | dateo=2026-07-30 | datev=2026-07-30 | amount=2194.00000000 | label=Remboursement DGFiP — crédit de TVA | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [14] rowid=103 | dateo=2026-07-31 | datev=2026-07-31 | amount=3120.00000000 | label=(CustomerInvoicePayment) | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [15] rowid=209 | dateo=2026-07-31 | datev=2026-07-31 | amount=-8804.22000000 | label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [16] rowid=356 | dateo=2026-07-31 | datev=2026-07-31 | amount=-1627.13000000 | label=Salaire net | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [17] rowid=453 | dateo=2026-07-31 | datev=2026-07-31 | amount=32.57000000 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | num_releve=202607 | rappro=1 | fk_type=VIR | num_chq=NULL [18] rowid=160 | dateo=2026-08-03 | datev=2026-08-03 | amount=-1290.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/27 SELLERIE THOMAS F267110 TEKNIPLI | num_releve=202608 | rappro=1 | fk_type=VIR | num_chq=8299010589152 [19] rowid=212 | dateo=2026-08-03 | datev=2026-08-03 | amount=-3240.00000000 | label=(AgentCompta relevé) Virement émis WEB GREGOIRE DONNART 26-08-12 TE - FA08/01 DONNART 26-08-12 TEKNIPLI | num_releve=202608 | rappro=1 | fk_type=VIR | num_chq=NULL [20] rowid=506 | dateo=2026-08-04 | datev=2026-08-04 | amount=-8.94000000 | label=(AgentCompta) Paiement carte — FR61SK8IABEI (remplace le paiement divers #98) | num_releve=202608 | rappro=1 | fk_type=CB | num_chq=NULL [21] rowid=507 | dateo=2026-08-04 | datev=2026-08-04 | amount=-46.89000000 | label=(AgentCompta) Paiement carte — RN1935981 (remplace le paiement divers #99) | num_releve=202608 | rappro=1 | fk_type=CB | num_chq=NULL [22] rowid=108 | dateo=2026-08-05 | datev=2026-08-05 | amount=100.41000000 | label=(CustomerInvoicePayment) | num_releve=202608 | rappro=1 | fk_type=VIR | num_chq=NULL [23] rowid=109 | dateo=2026-08-05 | datev=2026-08-05 | amount=12346.02000000 | label=(CustomerInvoicePayment) | num_releve=202608 | rappro=1 | fk_type=VIR | num_chq=NULL [24] rowid=285 | dateo=2026-08-05 | datev=2026-08-06 | amount=-352.05000000 | label=Remboursement de prêt 10003101334 — capital | num_releve=202608 | rappro=1 | fk_type=PRE | num_chq=NULL [25] rowid=293 | dateo=2026-08-05 | datev=2026-08-05 | amount=-51.87000000 | label=Remboursement de prêt 10003101334 — intérêts | num_releve=202608 | rappro=1 | fk_type=PRE | num_chq=NULL [26] rowid=301 | dateo=2026-08-05 | datev=2026-08-05 | amount=-18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | num_releve=202608 | rappro=1 | fk_type=PRE | num_chq=NULL [27] rowid=458 | dateo=2026-08-05 | datev=2026-08-05 | amount=-369.00000000 | label=(AgentCompta) PRELEVEMENT TACHER ACOGEX 00260023175 231805 TAC99415205072024 FR21ZZZ433222 | num_releve=202608 | rappro=1 | fk_type=VIR | num_chq=8309800375014 [28] rowid=508 | dateo=2026-08-05 | datev=2026-08-05 | amount=-56.53000000 | label=(AgentCompta) Paiement carte — FR61SVYHABEI (remplace le paiement divers #100) | num_releve=202608 | rappro=1 | fk_type=CB | num_chq=NULL [29] rowid=509 | dateo=2026-08-05 | datev=2026-08-05 | amount=-28.26000000 | label=(AgentCompta) Paiement carte — FR61SOAUABEI (remplace le paiement divers #101) | num_releve=202608 | rappro=1 | fk_type=CB | num_chq=NULL === F2 bank_url fin juillet === SQL: SELECT rowid,fk_bank,type,url_id,label,url FROM llx_bank_url WHERE fk_bank IN (SELECT rowid FROM llx_bank WHERE fk_account=1 AND dateo BETWEEN '2026-07-25' AND '2026-08-05') [1] rowid=551 | fk_bank=274 | type=payment_supplier | url_id=160 | label=(paiement) | url=/fourn/paiement/card.php?id= [2] rowid=552 | fk_bank=274 | type=company | url_id=317 | label=OVHcloud (OVH) | url=/fourn/card.php?socid= [3] rowid=769 | fk_bank=432 | type=payment_various | url_id=97 | label=(VariousPayment) | url=/compta/bank/various_payment/card.php?id= [4] rowid=201 | fk_bank=102 | type=payment | url_id=101 | label=(paiement) | url=/compta/paiement/card.php?id= [5] rowid=202 | fk_bank=102 | type=company | url_id=225 | label=Renault Trucks | url=/comm/card.php?socid= [6] rowid=331 | fk_bank=167 | type=payment_supplier | url_id=53 | label=(paiement) | url=/fourn/paiement/card.php?id= [7] rowid=332 | fk_bank=167 | type=company | url_id=361 | label=METALMAQ | url=/fourn/card.php?socid= [8] rowid=735 | fk_bank=399 | type=payment_supplier | url_id=205 | label=(paiement) | url=/fourn/paiement/card.php?id= [9] rowid=736 | fk_bank=399 | type=company | url_id=288 | label=Divers au comptant | url=/fourn/card.php?socid= [10] rowid=321 | fk_bank=162 | type=payment_supplier | url_id=48 | label=(paiement) | url=/fourn/paiement/card.php?id= [11] rowid=322 | fk_bank=162 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [12] rowid=323 | fk_bank=163 | type=payment_supplier | url_id=49 | label=(paiement) | url=/fourn/paiement/card.php?id= [13] rowid=324 | fk_bank=163 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [14] rowid=325 | fk_bank=164 | type=payment_supplier | url_id=50 | label=(paiement) | url=/fourn/paiement/card.php?id= [15] rowid=326 | fk_bank=164 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [16] rowid=327 | fk_bank=165 | type=payment_supplier | url_id=51 | label=(paiement) | url=/fourn/paiement/card.php?id= [17] rowid=328 | fk_bank=165 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [18] rowid=329 | fk_bank=166 | type=payment_supplier | url_id=52 | label=(paiement) | url=/fourn/paiement/card.php?id= [19] rowid=330 | fk_bank=166 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [20] rowid=319 | fk_bank=161 | type=payment_supplier | url_id=47 | label=(paiement) | url=/fourn/paiement/card.php?id= [21] rowid=320 | fk_bank=161 | type=company | url_id=358 | label=INPI | url=/fourn/card.php?socid= [22] rowid=553 | fk_bank=275 | type=payment_supplier | url_id=161 | label=(paiement) | url=/fourn/paiement/card.php?id= [23] rowid=554 | fk_bank=275 | type=company | url_id=288 | label=Divers au comptant | url=/fourn/card.php?socid= [24] rowid=613 | fk_bank=317 | type=payment_various | url_id=25 | label=(VariousPayment) | url=/compta/bank/various_payment/card.php?id= [25] rowid=203 | fk_bank=103 | type=payment | url_id=102 | label=(paiement) | url=/compta/paiement/card.php?id= [26] rowid=204 | fk_bank=103 | type=company | url_id=305 | label=EARL LES CAVALIERS DE BONNEFOI 61 | url=/comm/card.php?socid= [27] rowid=417 | fk_bank=209 | type=payment_supplier | url_id=95 | label=(paiement) | url=/fourn/paiement/card.php?id= [28] rowid=421 | fk_bank=209 | type=company | url_id=314 | label=ArcelorMittal Distribution Solutions France | url=/fourn/card.php?socid= [29] rowid=418 | fk_bank=209 | type=company | url_id=318 | label=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | url=/fourn/card.php?socid= [30] rowid=419 | fk_bank=209 | type=company | url_id=336 | label=Cœugnet Matériaux | url=/fourn/card.php?socid= [31] rowid=420 | fk_bank=209 | type=company | url_id=342 | label=Würth France SAS | url=/fourn/card.php?socid= [32] rowid=422 | fk_bank=209 | type=company | url_id=372 | label=ARCELOR MITTAL | url=/fourn/card.php?socid= [33] rowid=655 | fk_bank=356 | type=payment_various | url_id=63 | label=(VariousPayment) | url=/compta/bank/various_payment/card.php?id= [34] rowid=803 | fk_bank=453 | type=payment_various | url_id=105 | label=(VariousPayment) | url=/compta/bank/various_payment/card.php?id= [35] rowid=317 | fk_bank=160 | type=payment_supplier | url_id=46 | label=(paiement) | url=/fourn/paiement/card.php?id= [36] rowid=318 | fk_bank=160 | type=company | url_id=235 | label=Sellerie Thomas | url=/fourn/card.php?socid= [37] rowid=427 | fk_bank=212 | type=payment_supplier | url_id=98 | label=(paiement) | url=/fourn/paiement/card.php?id= [38] rowid=428 | fk_bank=212 | type=company | url_id=322 | label=GRÉGOIRE DONNART | url=/fourn/card.php?socid= [39] rowid=899 | fk_bank=506 | type=payment_supplier | url_id=238 | label=(paiement) | url=/fourn/paiement/card.php?id= [40] rowid=900 | fk_bank=506 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [41] rowid=901 | fk_bank=507 | type=payment_supplier | url_id=239 | label=(paiement) | url=/fourn/paiement/card.php?id= [42] rowid=902 | fk_bank=507 | type=company | url_id=400 | label=STAHLWERK Schweissgeräte GmbH | url=/fourn/card.php?socid= [43] rowid=213 | fk_bank=108 | type=payment | url_id=107 | label=(paiement) | url=/compta/paiement/card.php?id= [44] rowid=214 | fk_bank=108 | type=company | url_id=226 | label=SARL EBP COUVERTURE | url=/comm/card.php?socid= [45] rowid=215 | fk_bank=109 | type=payment | url_id=108 | label=(paiement) | url=/compta/paiement/card.php?id= [46] rowid=216 | fk_bank=109 | type=company | url_id=251 | label=SARL MAC | url=/comm/card.php?socid= [47] rowid=574 | fk_bank=285 | type=loan | url_id=1 | label= | url=/loan/card.php?id= [48] rowid=573 | fk_bank=285 | type=payment_loan | url_id=8 | label=(payment) | url=/loan/payment/card.php?id= [49] rowid=582 | fk_bank=293 | type=payment_various | url_id=8 | label=(VariousPayment) | url=/compta/bank/various_payment/card.php?id= [50] rowid=590 | fk_bank=301 | type=payment_various | url_id=16 | label=(VariousPayment) | url=/compta/bank/various_payment/card.php?id= [51] rowid=812 | fk_bank=458 | type=payment_supplier | url_id=211 | label=(paiement) | url=/fourn/paiement/card.php?id= [52] rowid=813 | fk_bank=458 | type=company | url_id=334 | label=TACHER ACOGEX | url=/fourn/card.php?socid= [53] rowid=903 | fk_bank=508 | type=payment_supplier | url_id=240 | label=(paiement) | url=/fourn/paiement/card.php?id= [54] rowid=904 | fk_bank=508 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid= [55] rowid=905 | fk_bank=509 | type=payment_supplier | url_id=241 | label=(paiement) | url=/fourn/paiement/card.php?id= [56] rowid=906 | fk_bank=509 | type=company | url_id=319 | label=Amazon Business EU S.à.r.l, Succursale Française | url=/fourn/card.php?socid=