===== T. Lignes banque des paiements ARBRE + apport 10000 ===== SELECT rowid,datev,amount,label,num_releve,rappro,fk_type FROM llx_bank WHERE rowid IN (25,36,448,350) rowid=25 | datev=2025-11-04 | amount=3600.00000000 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=36 | datev=2025-12-23 | amount=720.00000000 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=350 | datev=2026-06-23 | amount=10000.00000000 | label=Compte courant d'associé | num_releve=202606 | rappro=1 | fk_type=VIR rowid=448 | datev=2026-05-30 | amount=2190.99000000 | label=(CustomerInvoicePayment) Virement Julien Lautour - Arbre de Fer ADF-001 a 004 | num_releve=202605 | rappro=1 | fk_type=VIR (4 lignes) ===== U. Toutes lignes banque liees au tiers 212 ===== SELECT b.rowid,b.datev,b.amount,b.label FROM llx_bank b JOIN llx_bank_url u ON u.fk_bank=b.rowid WHERE u.type='company' AND u.url_id=212 ORDER BY b.datev rowid=25 | datev=2025-11-04 | amount=3600.00000000 | label=(CustomerInvoicePayment) rowid=36 | datev=2025-12-23 | amount=720.00000000 | label=(CustomerInvoicePayment) rowid=448 | datev=2026-05-30 | amount=2190.99000000 | label=(CustomerInvoicePayment) Virement Julien Lautour - Arbre de Fer ADF-001 a 004 rowid=96 | datev=2026-06-23 | amount=217.44000000 | label=(CustomerInvoicePayment) rowid=469 | datev=2026-08-18 | amount=590.40000000 | label=(AgentCompta) VIREMENT EN VOTRE FAVEUR M JULIEN LAUTOUR EI Loyer Juille Loyer Juillet (5 lignes) ===== V. Credits 500-700 EUR depuis juin ===== SELECT rowid,datev,amount,label FROM llx_bank WHERE fk_account=1 AND amount>0 AND datev>='2026-06-01' AND datev<='2026-08-19' AND amount>=500 AND amount<=700 ORDER BY datev rowid=90 | datev=2026-06-01 | amount=516.05000000 | label=(CustomerInvoicePayment) rowid=441 | datev=2026-06-02 | amount=619.97000000 | label=(CustomerInvoicePayment) Virement Normandie Bois Koncept 2026-REF-NBK-001 rowid=443 | datev=2026-06-02 | amount=554.40000000 | label=(CustomerInvoicePayment) Virement Normandie Bois Koncept 2026-REF-NBK-003 rowid=349 | datev=2026-06-23 | amount=590.40000000 | label=Compte courant d'associé rowid=97 | datev=2026-07-01 | amount=676.25000000 | label=(CustomerInvoicePayment) rowid=403 | datev=2026-07-20 | amount=584.43000000 | label=(CustomerInvoicePayment) Virement PM BATIMENT SAS — Tendance Menuiserie rowid=439 | datev=2026-08-06 | amount=692.38000000 | label=(CustomerInvoicePayment) Virement RAULIN INVEST — fac 178/180/188/189/116 rowid=469 | datev=2026-08-18 | amount=590.40000000 | label=(AgentCompta) VIREMENT EN VOTRE FAVEUR M JULIEN LAUTOUR EI Loyer Juille Loyer Juillet (8 lignes) ===== W. Apport 10000 du 23/06 ===== SELECT b.rowid,b.datev,b.amount,b.label,u.type,u.label AS ulabel FROM llx_bank b LEFT JOIN llx_bank_url u ON u.fk_bank=b.rowid AND u.type='company' WHERE b.rowid=350 rowid=350 | datev=2026-06-23 | amount=10000.00000000 | label=Compte courant d'associé | type=NULL | ulabel=NULL (1 lignes) ===== X. Perimetre banque ===== SELECT MAX(datev) AS dmax, COUNT(*) AS n FROM llx_bank WHERE fk_account=1 dmax=2026-10-17 | n=429 (1 lignes)