===== COMPTES BANCAIRES =====
SQL: SELECT rowid, ref, label, bank, courant, clos, rappro, entity, account_number, fk_accountancy_journal, currency_code, min_allowed FROM llx_bank_account
  rowid=1 | ref=Tekni-pli | label=Compte Courant | bank=Crédit Agricole de Normandie | courant=1 | clos=0 | rappro=1 | entity=1 | account_number=1 | fk_accountancy_journal= | currency_code=EUR | min_allowed=0
  rowid=2 | ref=HIST25 | label=Historique 2025 (exercice clos) — ne pas utiliser | bank= | courant=0 | clos=1 | rappro=1 | entity=1 | account_number=512 | fk_accountancy_journal= | currency_code=EUR | min_allowed=0
-- 2 ligne(s)

===== JOURNAUX COMPTABLES =====
SQL: SELECT rowid, code, label, nature, active FROM llx_accounting_journal WHERE entity IN (1)
  rowid=1 | code=VT | label=ACCOUNTING_SELL_JOURNAL | nature=2 | active=1
  rowid=2 | code=AC | label=ACCOUNTING_PURCHASE_JOURNAL | nature=3 | active=1
  rowid=3 | code=BQ | label=FinanceJournal | nature=4 | active=1
  rowid=4 | code=OD | label=ACCOUNTING_MISCELLANEOUS_JOURNAL | nature=1 | active=1
  rowid=5 | code=AN | label=ACCOUNTING_HAS_NEW_JOURNAL | nature=9 | active=1
  rowid=6 | code=ER | label=ExpenseReportsJournal | nature=5 | active=1
  rowid=7 | code=INV | label=InventoryJournal | nature=8 | active=1
-- 7 ligne(s)

===== PLAN COMPTABLE nb comptes =====
SQL: SELECT COUNT(*) nb FROM llx_accounting_account WHERE entity=1
  nb=2741
-- 1 ligne(s)

===== EXERCICES COMPTABLES =====
SQL: SELECT COUNT(*) nb FROM llx_accounting_fiscalyear WHERE entity=1
  nb=0
-- 1 ligne(s)

===== CONST BANK_* =====
SQL: SELECT name, value FROM llx_const WHERE name LIKE 'BANK\_%' ORDER BY name
  name=BANK_ADDON_PDF | value=sepamandate
  name=BANK_COLORIZE_MOVEMENT | value=1
-- 2 ligne(s)

===== CONST ACCOUNTING_*/ACCOUNTANCY_* =====
SQL: SELECT name, value FROM llx_const WHERE name LIKE 'ACCOUNTING\_%' OR name LIKE 'ACCOUNTANCY\_%' ORDER BY name
  name=ACCOUNTING_ACCOUNT_SUSPENSE | value=471
  name=ACCOUNTING_ACCOUNT_TRANSFER_CASH | value=58
  name=ACCOUNTING_EXPORT_DATE | value=%Y-%m-%d
  name=ACCOUNTING_EXPORT_FORMAT | value=csv
  name=ACCOUNTING_EXPORT_MODELCSV | value=1
  name=ACCOUNTING_EXPORT_SEPARATORCSV | value=,
  name=ACCOUNTING_LENGTH_AACCOUNT | value=
  name=ACCOUNTING_LENGTH_GACCOUNT | value=
-- 8 ligne(s)

===== PAIEMENTS DIVERS (payment_various) =====
SQL: SELECT COUNT(*) nb FROM llx_payment_various
  nb=68
-- 1 ligne(s)

===== UTILISATEURS =====
SQL: SELECT u.rowid, u.login, u.admin, u.statut FROM llx_user u
  rowid=1 | login=Nico | admin=1 | statut=1
  rowid=80 | login=j.lautour | admin=1 | statut=1
  rowid=85 | login=nicolas.lecocq | admin=0 | statut=1
  rowid=87 | login=lulu | admin=1 | statut=1
  rowid=88 | login=VDéveloppeur | admin=1 | statut=1
-- 5 ligne(s)

===== DROITS MODULE BANQUE =====
SQL: SELECT r.id, r.libelle, r.module, r.perms, r.subperms FROM llx_rights_def r WHERE r.module='banque' AND r.entity=1
  id=111 | libelle=Read bank account and transactions | module=banque | perms=lire | subperms=
  id=112 | libelle=Creer/modifier montant/supprimer ecriture bancaire | module=banque | perms=modifier | subperms=
  id=113 | libelle=Configurer les comptes bancaires (creer, gerer categories) | module=banque | perms=configurer | subperms=
  id=114 | libelle=Rapprocher les ecritures bancaires | module=banque | perms=consolidate | subperms=
  id=115 | libelle=Exporter transactions et releves | module=banque | perms=export | subperms=
  id=116 | libelle=Virements entre comptes | module=banque | perms=transfer | subperms=
  id=117 | libelle=Gerer les envois de cheques | module=banque | perms=cheque | subperms=
-- 7 ligne(s)

===== LIGNES 2026 SANS bank_url =====
SQL: SELECT COUNT(*) nb FROM llx_bank b WHERE b.fk_account=1 AND YEAR(b.dateo)=2026 AND NOT EXISTS (SELECT 1 FROM llx_bank_url u WHERE u.fk_bank=b.rowid)
  nb=0
-- 1 ligne(s)

===== LIGNES 2026 AVEC payment_supplier =====
SQL: SELECT COUNT(*) nb FROM llx_bank b WHERE b.fk_account=1 AND YEAR(b.dateo)=2026 AND EXISTS (SELECT 1 FROM llx_bank_url u WHERE u.fk_bank=b.rowid AND u.type='payment_supplier')
  nb=159
-- 1 ligne(s)

===== SOLDE CUMULE llx_bank compte 1 =====
SQL: SELECT ROUND(SUM(amount),2) total FROM llx_bank WHERE fk_account=1
  total=26701.98
-- 1 ligne(s)

===== FIN =====