===== DESCRIBE llx_bank =====
SQL: SHOW FULL COLUMNS FROM llx_bank
  Field=rowid | Type=int | Collation= | Null=NO | Key=PRI | Default= | Extra=auto_increment | Privileges=select,insert,update,references | Comment=
  Field=datec | Type=datetime | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=tms | Type=timestamp | Collation= | Null=YES | Key= | Default=CURRENT_TIMESTAMP | Extra=DEFAULT_GENERATED on update CURRENT_TIMESTAMP | Privileges=select,insert,update,references | Comment=
  Field=datev | Type=date | Collation= | Null=YES | Key=MUL | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=dateo | Type=date | Collation= | Null=YES | Key=MUL | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=amount | Type=double(24,8) | Collation= | Null=NO | Key= | Default=0.00000000 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=amount_main_currency | Type=double(24,8) | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=label | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_account | Type=int | Collation= | Null=YES | Key=MUL | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_user_author | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_user_rappro | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_type | Type=varchar(6) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=num_releve | Type=varchar(50) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key=MUL | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=num_chq | Type=varchar(50) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=numero_compte | Type=varchar(32) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=rappro | Type=tinyint | Collation= | Null=YES | Key=MUL | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=note | Type=text | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_bordereau | Type=int | Collation= | Null=YES | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=position | Type=int | Collation= | Null=YES | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=banque | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=emetteur | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=author | Type=varchar(40) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=origin_id | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=origin_type | Type=varchar(64) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=import_key | Type=varchar(14) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
-- 25 ligne(s)

===== DESCRIBE llx_bank_account =====
SQL: SHOW FULL COLUMNS FROM llx_bank_account
  Field=rowid | Type=int | Collation= | Null=NO | Key=PRI | Default= | Extra=auto_increment | Privileges=select,insert,update,references | Comment=
  Field=datec | Type=datetime | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=tms | Type=timestamp | Collation= | Null=YES | Key= | Default=CURRENT_TIMESTAMP | Extra=DEFAULT_GENERATED on update CURRENT_TIMESTAMP | Privileges=select,insert,update,references | Comment=
  Field=ref | Type=varchar(12) | Collation=utf8mb4_0900_ai_ci | Null=NO | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=label | Type=varchar(50) | Collation=utf8mb4_0900_ai_ci | Null=NO | Key=MUL | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=entity | Type=int | Collation= | Null=NO | Key= | Default=1 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_user_author | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_user_modif | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=bank | Type=varchar(60) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=code_banque | Type=varchar(128) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=code_guichet | Type=varchar(6) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=number | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=cle_rib | Type=varchar(5) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=bic | Type=varchar(11) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=bic_intermediate | Type=varchar(11) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=iban_prefix | Type=varchar(80) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=country_iban | Type=varchar(2) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=cle_iban | Type=varchar(2) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=domiciliation | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=pti_in_ctti | Type=smallint | Collation= | Null=YES | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=state_id | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_pays | Type=int | Collation= | Null=NO | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=proprio | Type=varchar(60) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=owner_address | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=owner_zip | Type=varchar(25) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=owner_town | Type=varchar(50) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=owner_country_id | Type=int | Collation= | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=courant | Type=smallint | Collation= | Null=NO | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=clos | Type=smallint | Collation= | Null=NO | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=rappro | Type=smallint | Collation= | Null=YES | Key= | Default=1 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=url | Type=varchar(128) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=account_number | Type=varchar(32) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=fk_accountancy_journal | Type=int | Collation= | Null=YES | Key=MUL | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=currency_code | Type=varchar(3) | Collation=utf8mb4_0900_ai_ci | Null=NO | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=min_allowed | Type=int | Collation= | Null=YES | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=min_desired | Type=int | Collation= | Null=YES | Key= | Default=0 | Extra= | Privileges=select,insert,update,references | Comment=
  Field=comment | Type=text | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=note_public | Type=text | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=model_pdf | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=import_key | Type=varchar(14) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=extraparams | Type=varchar(255) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=ics | Type=varchar(32) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
  Field=ics_transfer | Type=varchar(32) | Collation=utf8mb4_0900_ai_ci | Null=YES | Key= | Default= | Extra= | Privileges=select,insert,update,references | Comment=
-- 43 ligne(s)

===== COMPTES BANCAIRES =====
SQL: SELECT rowid, ref, label, bank, courant, clos, rappro, entity, account_number, fk_accountancy_journal, date_solde, solde FROM llx_bank_account
ERREUR: Unknown column 'date_solde' in 'field list'

===== CONSTANTES CLES =====
SQL: SELECT name, value, entity FROM llx_const WHERE name IN ('BANK_DISABLE_DIRECT_INPUT','BANK_STATEMENT_REGEX_RULE','MAIN_ALLOW_AUTOMATIC_CONCILIATION','BANK_REPORT_LAST_NUM_RELEVE','NW_RECEIPTNUMBERFORMAT','BANK_CAN_RECONCILIATE_CASHACCOUNT','ACCOUNTING_BANK_CONCILIATED','ACCOUNTING_DATE_START_BINDING','BANK_USE_OLD_VARIOUS_PAYMENT','MAIN_MODULE_IMPORT','MAIN_MODULE_ACCOUNTING','MAIN_MODULE_BANQUE','ACCOUNTANCY_FISCAL_PERIOD_MODE','BANK_ASK_PAYMENT_BANK_DURING_RECONCILIATION') ORDER BY name
  name=MAIN_MODULE_ACCOUNTING | value=1 | entity=1
  name=MAIN_MODULE_BANQUE | value=1 | entity=1
  name=MAIN_MODULE_IMPORT | value=1 | entity=1
-- 3 ligne(s)

===== MODULES ACTIFS =====
SQL: SELECT name, value FROM llx_const WHERE name LIKE 'MAIN_MODULE_%' AND value='1' ORDER BY name
  name=MAIN_MODULE_ACCOUNTING | value=1
  name=MAIN_MODULE_AGENDA | value=1
  name=MAIN_MODULE_AGENTCOMPTA | value=1
  name=MAIN_MODULE_AI | value=1
  name=MAIN_MODULE_API | value=1
  name=MAIN_MODULE_AUTOPRODUCTS | value=1
  name=MAIN_MODULE_BANQUE | value=1
  name=MAIN_MODULE_BARCODE | value=1
  name=MAIN_MODULE_BLOCKEDLOG | value=1
  name=MAIN_MODULE_BOM | value=1
  name=MAIN_MODULE_BOOKMARK | value=1
  name=MAIN_MODULE_CALCULETTEPLIAGE | value=1
  name=MAIN_MODULE_CATEGORIE | value=1
  name=MAIN_MODULE_CHANGETIERS | value=1
  name=MAIN_MODULE_COMMANDE | value=1
  name=MAIN_MODULE_CONTRAT | value=1
  name=MAIN_MODULE_CRON | value=1
  name=MAIN_MODULE_DAV | value=1
  name=MAIN_MODULE_DEBUGBAR | value=1
  name=MAIN_MODULE_ECM | value=1
  name=MAIN_MODULE_EMAILCOLLECTOR | value=1
  name=MAIN_MODULE_EVENTORGANIZATION | value=1
  name=MAIN_MODULE_EVENTORGANIZATION_MODELS | value=1
  name=MAIN_MODULE_EVENTORGANIZATION_TRIGGERS | value=1
  name=MAIN_MODULE_EXPEDITION | value=1
  name=MAIN_MODULE_EXPENSEREPORT | value=1
  name=MAIN_MODULE_EXPORT | value=1
  name=MAIN_MODULE_EXTERNALRSS | value=1
  name=MAIN_MODULE_FACTURE | value=1
  name=MAIN_MODULE_FCKEDITOR | value=1
  name=MAIN_MODULE_FICHEINTER | value=1
  name=MAIN_MODULE_FOURNISSEUR | value=1
  name=MAIN_MODULE_HOLIDAY | value=1
  name=MAIN_MODULE_HRM | value=1
  name=MAIN_MODULE_HRM_MODELS | value=1
  name=MAIN_MODULE_IMPORT | value=1
  name=MAIN_MODULE_KNOWLEDGEMANAGEMENT | value=1
  name=MAIN_MODULE_KNOWLEDGEMANAGEMENT_MODELS | value=1
  name=MAIN_MODULE_LOAN | value=1
  name=MAIN_MODULE_MAILING | value=1
  name=MAIN_MODULE_MARGIN | value=1
  name=MAIN_MODULE_MODULEBUILDER | value=1
  name=MAIN_MODULE_MRP | value=1
  name=MAIN_MODULE_MULTICURRENCY | value=1
  name=MAIN_MODULE_NOTIFICATION | value=1
  name=MAIN_MODULE_OAUTH | value=1
  name=MAIN_MODULE_OPENIDCONNECT | value=1
  name=MAIN_MODULE_PARTNERSHIP | value=1
  name=MAIN_MODULE_PARTNERSHIP_MODELS | value=1
  name=MAIN_MODULE_PAYMENTBYBANKTRANSFER | value=1
  name=MAIN_MODULE_PRELEVEMENT | value=1
  name=MAIN_MODULE_PRINTING | value=1
  name=MAIN_MODULE_PRODUCT | value=1
  name=MAIN_MODULE_PRODUCTBATCH | value=1
  name=MAIN_MODULE_PROJET | value=1
  name=MAIN_MODULE_PROPALE | value=1
  name=MAIN_MODULE_RECEIPTPRINTER | value=1
  name=MAIN_MODULE_RECEPTION | value=1
  name=MAIN_MODULE_RESOURCE | value=1
  name=MAIN_MODULE_SCANINVOICES | value=1
  name=MAIN_MODULE_SCANINVOICES_MODELS | value=1
  name=MAIN_MODULE_SERVICE | value=1
  name=MAIN_MODULE_SOCIETE | value=1
  name=MAIN_MODULE_STOCK | value=1
  name=MAIN_MODULE_SUPPLIERPROPOSAL | value=1
  name=MAIN_MODULE_SYSLOG | value=1
  name=MAIN_MODULE_TAX | value=1
  name=MAIN_MODULE_TEKNIPLI | value=1
  name=MAIN_MODULE_TEKNIPLI_TRIGGERS | value=1
  name=MAIN_MODULE_TICKET | value=1
  name=MAIN_MODULE_TICKET_TRIGGERS | value=1
  name=MAIN_MODULE_USER | value=1
  name=MAIN_MODULE_VARIANTS | value=1
  name=MAIN_MODULE_WEBHOOK | value=1
  name=MAIN_MODULE_WEBHOOK_MODELS | value=1
  name=MAIN_MODULE_WEBHOOK_TRIGGERS | value=1
  name=MAIN_MODULE_WEBPORTAL | value=1
  name=MAIN_MODULE_WEBSITE | value=1
  name=MAIN_MODULE_WORKFLOW | value=1
  name=MAIN_MODULE_WORKSTATION | value=1
  name=MAIN_MODULE_WORKSTATION_MODELS | value=1
-- 81 ligne(s)

===== REPARTITION llx_bank PAR rappro =====
SQL: SELECT rappro, COUNT(*) nb, MIN(dateo) mind, MAX(dateo) maxd, ROUND(SUM(amount),2) somme FROM llx_bank GROUP BY rappro
  rappro=0 | nb=50 | mind=2025-01-01 | maxd=2026-07-20 | somme=122828.39
  rappro=1 | nb=300 | mind=2025-12-31 | maxd=2026-08-07 | somme=23702.25
-- 2 ligne(s)

===== REPARTITION PAR num_releve =====
SQL: SELECT CASE WHEN num_releve IS NULL THEN 'NULL' WHEN num_releve='' THEN 'VIDE' ELSE num_releve END AS nr, COUNT(*) nb, ROUND(SUM(amount),2) somme FROM llx_bank GROUP BY nr ORDER BY nb DESC
  nr=202607 | nb=55 | somme=-152.32
  nr=NULL | nb=50 | somme=122828.39
  nr=202604 | nb=48 | somme=5643.07
  nr=202605 | nb=46 | somme=-13966.97
  nr=202606 | nb=42 | somme=-306.6
  nr=202603 | nb=37 | somme=-13280.85
  nr=202601 | nb=28 | somme=-31132.18
  nr=202602 | nb=27 | somme=21379.74
  nr=202608 | nb=16 | somme=18517.11
  nr=202512 | nb=1 | somme=37001.25
-- 10 ligne(s)

===== llx_bank PAR ANNEE ET rappro =====
SQL: SELECT fk_account, YEAR(dateo) an, rappro, COUNT(*) nb, ROUND(SUM(amount),2) somme FROM llx_bank GROUP BY fk_account, an, rappro ORDER BY an
  fk_account=2 | an=2025 | rappro=0 | nb=44 | somme=119828.66
  fk_account=1 | an=2025 | rappro=1 | nb=1 | somme=37001.25
  fk_account=1 | an=2026 | rappro=1 | nb=299 | somme=-13299
  fk_account=1 | an=2026 | rappro=0 | nb=6 | somme=2999.73
-- 4 ligne(s)

===== REPARTITION fk_type =====
SQL: SELECT fk_type, COUNT(*) nb FROM llx_bank GROUP BY fk_type ORDER BY nb DESC
  fk_type=VIR | nb=237
  fk_type=PRE | nb=73
  fk_type=CB | nb=34
  fk_type=SOLD | nb=3
  fk_type=CHQ | nb=3
-- 5 ligne(s)

===== TYPES DE PAIEMENT c_paiement =====
SQL: SELECT code, libelle, type, active, accountancy_code FROM llx_c_paiement WHERE entity IN (1) ORDER BY code
  code=BANCON | libelle=Bancontact | type=1 | active=0 | accountancy_code=
  code=CB | libelle=Credit card | type=2 | active=1 | accountancy_code=
  code=CHQ | libelle=Cheque | type=2 | active=1 | accountancy_code=
  code=FAC | libelle=Factor | type=2 | active=0 | accountancy_code=
  code=GIR | libelle=Giropay | type=1 | active=0 | accountancy_code=
  code=IDE | libelle=iDeal | type=1 | active=0 | accountancy_code=
  code=KLA | libelle=Klarna | type=1 | active=0 | accountancy_code=
  code=LCR | libelle=LCR | type=2 | active=0 | accountancy_code=
  code=LIQ | libelle=Cash | type=2 | active=1 | accountancy_code=
  code=PPL | libelle=PayPal | type=1 | active=0 | accountancy_code=
  code=PRE | libelle=Direct Debit | type=2 | active=1 | accountancy_code=
  code=SOF | libelle=Sofort | type=1 | active=0 | accountancy_code=
  code=TIP | libelle=TIP | type=2 | active=0 | accountancy_code=
  code=TRA | libelle=Traite | type=2 | active=0 | accountancy_code=
  code=VAD | libelle=Online payment | type=2 | active=0 | accountancy_code=
  code=VIR | libelle=Credit Transfer | type=2 | active=1 | accountancy_code=
-- 16 ligne(s)

===== BOOKKEEPING doc_type=bank =====
SQL: SELECT COUNT(*) nb, COUNT(DISTINCT fk_doc) nbdoc FROM llx_accounting_bookkeeping WHERE doc_type='bank'
  nb=0 | nbdoc=0
-- 1 ligne(s)

===== BOOKKEEPING PAR doc_type =====
SQL: SELECT doc_type, COUNT(*) nb FROM llx_accounting_bookkeeping GROUP BY doc_type
-- 0 ligne(s)

===== BOOKKEEPING TOTAL =====
SQL: SELECT COUNT(*) nb FROM llx_accounting_bookkeeping
  nb=0
-- 1 ligne(s)

===== LIGNES AVEC fk_bordereau =====
SQL: SELECT COUNT(*) nb FROM llx_bank WHERE fk_bordereau > 0
  nb=0
-- 1 ligne(s)

===== LIGNES AVEC fk_user_rappro =====
SQL: SELECT COUNT(*) nb FROM llx_bank WHERE fk_user_rappro > 0
  nb=0
-- 1 ligne(s)

===== 10 DERNIERES LIGNES llx_bank =====
SQL: SELECT b.rowid, b.dateo, b.datev, b.amount, b.label, b.fk_type, b.num_chq, b.num_releve, b.rappro FROM llx_bank b WHERE b.fk_account=1 ORDER BY b.dateo DESC LIMIT 10
  rowid=387 | dateo=2026-08-07 | datev=2026-08-07 | amount=-66.60000000 | label=(AgentCompta) Paiement par carte X4074 LE BUFFAROT ST MARTI 06/08 | fk_type=CB | num_chq= | num_releve=202608 | rappro=1
  rowid=360 | dateo=2026-08-07 | datev=2026-08-07 | amount=-11.38000000 | label=Assurance | fk_type=PRE | num_chq= | num_releve=202608 | rappro=1
  rowid=359 | dateo=2026-08-07 | datev=2026-08-07 | amount=-57.53000000 | label=Assurance | fk_type=PRE | num_chq= | num_releve=202608 | rappro=1
  rowid=358 | dateo=2026-08-07 | datev=2026-08-07 | amount=-78.89000000 | label=Assurance | fk_type=PRE | num_chq= | num_releve=202608 | rappro=1
  rowid=357 | dateo=2026-08-07 | datev=2026-08-07 | amount=-130.01000000 | label=Assurance | fk_type=PRE | num_chq= | num_releve=202608 | rappro=1
  rowid=277 | dateo=2026-08-07 | datev=2026-08-07 | amount=-140.33000000 | label=(AgentCompta relevé) Prélèvement ELECTRICITE DE FRANCE - EDF - TEKNI-PLI Ref EDF:5623916760 RUM:MA970002376824 E 2026-08-07 MA970002376824 FR47EDF001007 Z005623916760 99285 2 FELIX 992 | fk_type=VIR | num_chq= | num_releve=202608 | rappro=1
  rowid=400 | dateo=2026-08-06 | datev=2026-08-06 | amount=-24.85000000 | label=(AgentCompta) Paiement par carte LIDL 24,85 | fk_type=CB | num_chq= | num_releve=202608 | rappro=1
  rowid=364 | dateo=2026-08-06 | datev=2026-08-06 | amount=11202.99000000 | label=(CustomerInvoicePayment) Solde relevé Normandie Biologi'K | fk_type=VIR | num_chq= | num_releve=202608 | rappro=1
  rowid=110 | dateo=2026-08-06 | datev=2026-08-06 | amount=329.50000000 | label=(CustomerInvoicePayment) | fk_type=VIR | num_chq= | num_releve=202608 | rappro=1
  rowid=301 | dateo=2026-08-05 | datev=2026-08-05 | amount=-18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | fk_type=PRE | num_chq= | num_releve=202608 | rappro=1
-- 10 ligne(s)

===== llx_bank_url TOTAL =====
SQL: SELECT COUNT(*) nb FROM llx_bank_url
  nb=634
-- 1 ligne(s)

===== llx_bank_url PAR type =====
SQL: SELECT type, COUNT(*) nb FROM llx_bank_url GROUP BY type
  type=payment | nb=112
  type=company | nb=279
  type=payment_supplier | nb=159
  type=loan | nb=8
  type=payment_loan | nb=8
  type=payment_various | nb=68
-- 6 ligne(s)

===== agentcompta_match PAR status =====
SQL: SELECT status, COUNT(*) nb FROM llx_agentcompta_match GROUP BY status
  status=rejected | nb=3
  status=validated | nb=351
-- 2 ligne(s)

===== MODELES D'IMPORT ENREGISTRES =====
SQL: SELECT rowid, label, type, entity FROM llx_import_model
-- 0 ligne(s)

===== FIN =====