===== A. Ecritures diverses 48 et 56 =====
SELECT * FROM llx_payment_various WHERE rowid IN (48,56)
  rowid=48 | ref=NULL | num_payment= | label=Compte courant d'associé | tms=2026-08-10 08:13:01 | datec=2026-08-10 08:13:01 | datep=2026-05-18 | datev=2026-05-18 | sens=1 | amount=118.80000000 | fk_typepayment=2 | accountancy_code=455 | subledger_account= | fk_projet=0 | entity=1 | note=NULL | fk_bank=341 | fk_user_author=1 | fk_user_modif=NULL
  rowid=56 | ref=NULL | num_payment= | label=Compte courant d'associé | tms=2026-08-10 08:13:01 | datec=2026-08-10 08:13:01 | datep=2026-06-23 | datev=2026-06-23 | sens=1 | amount=590.40000000 | fk_typepayment=2 | accountancy_code=455 | subledger_account= | fk_projet=0 | entity=1 | note=NULL | fk_bank=349 | fk_user_author=1 | fk_user_modif=NULL
  (2 lignes)

===== B. Factures ARBRE DE FER (fk_soc 212) =====
SELECT f.rowid,f.ref,f.datef,f.total_ht,f.total_tva,f.total_ttc,f.fk_statut,f.paye,f.last_main_doc,f.tms,COALESCE(SUM(pf.amount),0) AS regle FROM llx_facture f LEFT JOIN llx_paiement_facture pf ON pf.fk_facture=f.rowid WHERE f.fk_soc=212 GROUP BY f.rowid ORDER BY f.datef
  rowid=71 | ref=FA2510-0065 | datef=2025-10-19 | total_ht=3000.00000000 | total_tva=600.00000000 | total_ttc=3600.00000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2510-0065/FA2510-0065.pdf | tms=2025-11-13 11:33:54 | regle=3600.00000000
  rowid=94 | ref=FA2512-0086 | datef=2025-12-22 | total_ht=600.00000000 | total_tva=120.00000000 | total_ttc=720.00000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2512-0086/FA2512-0086.pdf | tms=2025-12-30 09:12:21 | regle=720.00000000
  rowid=204 | ref=FA2604-0184 | datef=2026-04-18 | total_ht=99.00000000 | total_tva=19.80000000 | total_ttc=118.80000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2604-0184/FA2604-0184.pdf | tms=2026-06-26 11:16:03 | regle=118.80000000
  rowid=247 | ref=FA2605-0225 | datef=2026-05-21 | total_ht=82.20000000 | total_tva=16.44000000 | total_ttc=98.64000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2605-0225/FA2605-0225.pdf | tms=2026-06-26 11:16:04 | regle=98.64000000
  rowid=373 | ref=FA2605-0343 | datef=2026-05-27 | total_ht=206.33000000 | total_tva=41.26000000 | total_ttc=247.59000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2605-0343/FA2605-0343.pdf | tms=2026-08-10 18:54:50 | regle=247.59000000
  rowid=374 | ref=FA2605-0339 | datef=2026-05-27 | total_ht=984.00000000 | total_tva=0.00000000 | total_ttc=984.00000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2605-0339/FA2605-0339.pdf | tms=2026-08-10 18:54:50 | regle=984.00000000
  rowid=375 | ref=FA2605-0340 | datef=2026-05-27 | total_ht=184.50000000 | total_tva=36.90000000 | total_ttc=221.40000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2605-0340/FA2605-0340.pdf | tms=2026-08-10 18:54:50 | regle=221.40000000
  rowid=376 | ref=FA2605-0341 | datef=2026-05-27 | total_ht=615.00000000 | total_tva=123.00000000 | total_ttc=738.00000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2605-0341/FA2605-0341.pdf | tms=2026-08-10 18:54:50 | regle=738.00000000
  rowid=377 | ref=FA2606-0342 | datef=2026-06-01 | total_ht=492.00000000 | total_tva=98.40000000 | total_ttc=590.40000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2606-0342/FA2606-0342.pdf | tms=2026-10-01 12:29:54 | regle=590.40000000
  rowid=426 | ref=FA2607-0384 | datef=2026-07-01 | total_ht=492.00000000 | total_tva=98.40000000 | total_ttc=590.40000000 | fk_statut=1 | paye=0 | last_main_doc=NULL | tms=2026-10-19 10:25:55 | regle=0.00000000
  (10 lignes)

===== C. Paiements/factures ARBRE DE FER =====
SELECT pf.rowid,pf.fk_paiement,pf.fk_facture,pf.amount,p.ref,p.datep,p.fk_bank,f.ref AS facref,f.total_ttc FROM llx_paiement_facture pf JOIN llx_paiement p ON p.rowid=pf.fk_paiement JOIN llx_facture f ON f.rowid=pf.fk_facture WHERE f.fk_soc=212 ORDER BY p.datep
  rowid=53 | fk_paiement=24 | fk_facture=71 | amount=3600.00000000 | ref=PAY2511-0024 | datep=2025-11-04 12:00:00 | fk_bank=25 | facref=FA2510-0065 | total_ttc=3600.00000000
  rowid=68 | fk_paiement=35 | fk_facture=94 | amount=720.00000000 | ref=PAY2512-0034 | datep=2025-12-23 12:00:00 | fk_bank=36 | facref=FA2512-0086 | total_ttc=720.00000000
  rowid=344 | fk_paiement=127 | fk_facture=373 | amount=247.59000000 | ref=PAY2605-0122 | datep=2026-05-30 00:00:00 | fk_bank=448 | facref=FA2605-0343 | total_ttc=247.59000000
  rowid=345 | fk_paiement=127 | fk_facture=374 | amount=984.00000000 | ref=PAY2605-0122 | datep=2026-05-30 00:00:00 | fk_bank=448 | facref=FA2605-0339 | total_ttc=984.00000000
  rowid=346 | fk_paiement=127 | fk_facture=375 | amount=221.40000000 | ref=PAY2605-0122 | datep=2026-05-30 00:00:00 | fk_bank=448 | facref=FA2605-0340 | total_ttc=221.40000000
  rowid=347 | fk_paiement=127 | fk_facture=376 | amount=738.00000000 | ref=PAY2605-0122 | datep=2026-05-30 00:00:00 | fk_bank=448 | facref=FA2605-0341 | total_ttc=738.00000000
  rowid=194 | fk_paiement=95 | fk_facture=204 | amount=118.80000000 | ref=PAY2606-0090 | datep=2026-06-23 12:00:00 | fk_bank=96 | facref=FA2604-0184 | total_ttc=118.80000000
  rowid=195 | fk_paiement=95 | fk_facture=247 | amount=98.64000000 | ref=PAY2606-0090 | datep=2026-06-23 12:00:00 | fk_bank=96 | facref=FA2605-0225 | total_ttc=98.64000000
  rowid=380 | fk_paiement=138 | fk_facture=377 | amount=590.40000000 | ref=PAY2608-0133 | datep=2026-08-18 00:00:00 | fk_bank=469 | facref=FA2606-0342 | total_ttc=590.40000000
  (9 lignes)

===== D. Lignes de la facture 377 =====
SELECT rowid,ref,label,description,total_ht,total_ttc,tva_tx,qty FROM llx_facturedet WHERE fk_facture=377
ERREUR: Unknown column 'ref' in 'field list'

===== E. Detail facture 377 =====
SELECT rowid,ref,datef,total_ht,total_tva,total_ttc,fk_statut,paye,last_main_doc,note_private,note_public,fk_user_author,datec FROM llx_facture WHERE rowid=377
  rowid=377 | ref=FA2606-0342 | datef=2026-06-01 | total_ht=492.00000000 | total_tva=98.40000000 | total_ttc=590.40000000 | fk_statut=2 | paye=1 | last_main_doc=facture/FA2606-0342/FA2606-0342.pdf | note_private=AgentCompta — saisie sur instruction de l'artisan (10/08/2026), reproduite à l'identique de la pièce 2026-REF-ADF-005
émise le 2026-06-01. Sous-location de 12,30 % du bail SCI MARLEG (sous-bail du 19/05/2026). PARTIE LIÉE (société de Julien Lautour). | note_public=NULL | fk_user_author=1 | datec=2026-08-10 18:53:48
  (1 lignes)

===== F. ARBRE DE FER par date de creation =====
SELECT rowid,ref,datef,datec,total_ttc,fk_statut,paye FROM llx_facture WHERE fk_soc=212 ORDER BY datec
  rowid=71 | ref=FA2510-0065 | datef=2025-10-19 | datec=2025-10-19 19:59:04 | total_ttc=3600.00000000 | fk_statut=2 | paye=1
  rowid=94 | ref=FA2512-0086 | datef=2025-12-22 | datec=2025-12-22 09:41:59 | total_ttc=720.00000000 | fk_statut=2 | paye=1
  rowid=204 | ref=FA2604-0184 | datef=2026-04-18 | datec=2026-04-18 15:48:29 | total_ttc=118.80000000 | fk_statut=2 | paye=1
  rowid=247 | ref=FA2605-0225 | datef=2026-05-21 | datec=2026-05-21 08:20:05 | total_ttc=98.64000000 | fk_statut=2 | paye=1
  rowid=373 | ref=FA2605-0343 | datef=2026-05-27 | datec=2026-08-10 18:53:48 | total_ttc=247.59000000 | fk_statut=2 | paye=1
  rowid=374 | ref=FA2605-0339 | datef=2026-05-27 | datec=2026-08-10 18:53:48 | total_ttc=984.00000000 | fk_statut=2 | paye=1
  rowid=375 | ref=FA2605-0340 | datef=2026-05-27 | datec=2026-08-10 18:53:48 | total_ttc=221.40000000 | fk_statut=2 | paye=1
  rowid=376 | ref=FA2605-0341 | datef=2026-05-27 | datec=2026-08-10 18:53:48 | total_ttc=738.00000000 | fk_statut=2 | paye=1
  rowid=377 | ref=FA2606-0342 | datef=2026-06-01 | datec=2026-08-10 18:53:48 | total_ttc=590.40000000 | fk_statut=2 | paye=1
  rowid=426 | ref=FA2607-0384 | datef=2026-07-01 | datec=2026-10-19 10:25:55 | total_ttc=590.40000000 | fk_statut=1 | paye=0
  (10 lignes)

===== G. Factures a 118,80 =====
SELECT rowid,ref,datef,total_ttc,fk_statut,paye,fk_soc FROM llx_facture WHERE total_ttc BETWEEN 118.79 AND 118.81
  rowid=204 | ref=FA2604-0184 | datef=2026-04-18 | total_ttc=118.80000000 | fk_statut=2 | paye=1 | fk_soc=212
  (1 lignes)

===== H. Mouvements banque 20-26 juin 2026 =====
SELECT b.rowid,b.datev,b.amount,b.label,b.fk_type,b.num_releve FROM llx_bank b WHERE b.fk_account=1 AND b.datev BETWEEN '2026-06-20' AND '2026-06-26' ORDER BY b.datev,b.rowid
  rowid=218 | datev=2026-06-22 | amount=-3807.98000000 | label=(AgentCompta relevé) Virement émis VIR INST vers ARCELORMITTAL DIST - fa04/14 arcelor TEKNI PLI | fk_type=VIR | num_releve=202606
  rowid=362 | datev=2026-06-22 | amount=7000.00000000 | label=(CustomerInvoicePayment) Acompte Normandie Biologi'K | fk_type=VIR | num_releve=202606
  rowid=96 | datev=2026-06-23 | amount=217.44000000 | label=(CustomerInvoicePayment) | fk_type=VIR | num_releve=202606
  rowid=194 | datev=2026-06-23 | amount=-2787.10000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SCI MARLEG SCI MARLEG MAI 2026 TEKNI PLI SCI MARLEG | fk_type=VIR | num_releve=202606
  rowid=349 | datev=2026-06-23 | amount=590.40000000 | label=Compte courant d'associé | fk_type=VIR | num_releve=202606
  rowid=350 | datev=2026-06-23 | amount=10000.00000000 | label=Compte courant d'associé | fk_type=VIR | num_releve=202606
  rowid=316 | datev=2026-06-24 | amount=-3.00000000 | label=TVA CA3 de juin 2026 | fk_type=PRE | num_releve=202606
  rowid=100 | datev=2026-06-26 | amount=832.23000000 | label=(CustomerInvoicePayment) | fk_type=VIR | num_releve=NULL
  rowid=217 | datev=2026-06-26 | amount=-6000.00000000 | label=(AgentCompta relevé) Virement émis VIR INST vers NOREQUIPEMENTS - FA06/16 NOREQUIPEMENTS VTE2026/073 TEKNIPLI | fk_type=VIR | num_releve=202606
  rowid=446 | datev=2026-06-26 | amount=858.43000000 | label=(CustomerInvoicePayment) Virement Normandie Bois Koncept 2026-REF-NBK-006 | fk_type=VIR | num_releve=202606
  (10 lignes)

===== I. Mouvements banque 14-22 mai 2026 =====
SELECT b.rowid,b.datev,b.amount,b.label,b.fk_type FROM llx_bank b WHERE b.fk_account=1 AND b.datev BETWEEN '2026-05-14' AND '2026-05-22' ORDER BY b.datev,b.rowid
  rowid=87 | datev=2026-05-15 | amount=5001.91000000 | label=(CustomerInvoicePayment) | fk_type=VIR
  rowid=206 | datev=2026-05-15 | amount=-19819.92000000 | label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | fk_type=VIR
  rowid=313 | datev=2026-05-15 | amount=-4385.00000000 | label=Impôt sur les sociétés — solde la dette d'ouverture | fk_type=PRE
  rowid=418 | datev=2026-05-15 | amount=253.43000000 | label=Remboursement Verpakgigant | fk_type=CB
  rowid=340 | datev=2026-05-16 | amount=-22.00000000 | label=Frais bancaires | fk_type=PRE
  rowid=341 | datev=2026-05-18 | amount=118.80000000 | label=Compte courant d'associé | fk_type=VIR
  rowid=419 | datev=2026-05-18 | amount=-5.99000000 | label=Uber One — nature à confirmer | fk_type=CB
  rowid=89 | datev=2026-05-19 | amount=1557.85000000 | label=(CustomerInvoicePayment) | fk_type=VIR
  rowid=306 | datev=2026-05-19 | amount=-1768.14000000 | label=Prélèvement LIXXBAIL — crédit-bail 428164BP0 | fk_type=PRE
  rowid=318 | datev=2026-05-19 | amount=-17812.90000000 | label=Virement notaire D&A CAEN CHATEAU — bail commercial SCI MARLEG | fk_type=VIR
  rowid=361 | datev=2026-05-19 | amount=7000.00000000 | label=(CustomerInvoicePayment) Acompte Normandie Biologi'K | fk_type=VIR
  rowid=370 | datev=2026-05-19 | amount=-550.00000000 | label=Virement notaire du 19/05 — part non justifiée | fk_type=VIR
  rowid=420 | datev=2026-05-20 | amount=-31.70000000 | label=Fournitures d'atelier — Delvia (TVA non récupérée faute de pièce) | fk_type=CB
  rowid=88 | datev=2026-05-21 | amount=912.00000000 | label=(CustomerInvoicePayment) | fk_type=VIR
  rowid=259 | datev=2026-05-22 | amount=-295.97000000 | label=(AgentCompta relevé) Vi émis à l'étranger J2602012627 FURNEAUX RIDDALL CO | fk_type=VIR
  rowid=368 | datev=2026-05-22 | amount=-231.52000000 | label=(AgentCompta) Paiement par carte BULTEAU SYSTEMS | fk_type=CB
  (16 lignes)

===== J. Nb factures ARBRE =====
SELECT COUNT(*) AS n FROM llx_facture WHERE fk_soc=212
  n=10
  (1 lignes)

===== K. Avoirs ARBRE =====
SELECT rowid,ref,datef,total_ttc,fk_statut,type FROM llx_facture WHERE fk_soc=212 AND type<>0
  (0 lignes)