=== DESCRIBE llx_bank_account === rowid | int | null=NO | def= datec | datetime | null=YES | def= tms | timestamp | null=YES | def=CURRENT_TIMESTAMP ref | varchar(12) | null=NO | def= label | varchar(50) | null=NO | def= entity | int | null=NO | def=1 fk_user_author | int | null=YES | def= fk_user_modif | int | null=YES | def= bank | varchar(60) | null=YES | def= code_banque | varchar(128) | null=YES | def= code_guichet | varchar(6) | null=YES | def= number | varchar(255) | null=YES | def= cle_rib | varchar(5) | null=YES | def= bic | varchar(11) | null=YES | def= bic_intermediate | varchar(11) | null=YES | def= iban_prefix | varchar(80) | null=YES | def= country_iban | varchar(2) | null=YES | def= cle_iban | varchar(2) | null=YES | def= domiciliation | varchar(255) | null=YES | def= pti_in_ctti | smallint | null=YES | def=0 state_id | int | null=YES | def= fk_pays | int | null=NO | def= proprio | varchar(60) | null=YES | def= owner_address | varchar(255) | null=YES | def= owner_zip | varchar(25) | null=YES | def= owner_town | varchar(50) | null=YES | def= owner_country_id | int | null=YES | def= courant | smallint | null=NO | def=0 clos | smallint | null=NO | def=0 rappro | smallint | null=YES | def=1 url | varchar(128) | null=YES | def= account_number | varchar(32) | null=YES | def= fk_accountancy_journal | int | null=YES | def= currency_code | varchar(3) | null=NO | def= min_allowed | int | null=YES | def=0 min_desired | int | null=YES | def=0 comment | text | null=YES | def= note_public | text | null=YES | def= model_pdf | varchar(255) | null=YES | def= import_key | varchar(14) | null=YES | def= extraparams | varchar(255) | null=YES | def= ics | varchar(32) | null=YES | def= ics_transfer | varchar(32) | null=YES | def= === llx_bank_account rowid=1 (valeurs non vides) === rowid = 1 datec = 2025-09-06 06:28:38 tms = 2025-09-06 06:28:38 ref = Tekni-pli label = Compte Courant entity = 1 bank = Crédit Agricole de Normandie code_banque = 16606 code_guichet = 05011 number = 84894873336 cle_rib = 40 bic = AGRIFRPP866 iban_prefix = FR76 1660 6050 1184 8948 7333 640 domiciliation = CR DE NORMANDIE CAEN-AVENUE DU 6 JUIN pti_in_ctti = 1 state_id = 316 fk_pays = 1 proprio = S.A.S. TEKNI-PLI owner_address = 13 C RUE DU CLOS SAINT JOSEPH owner_zip = 14320 owner_town = ST MARTIN DE FONTENAY owner_country_id = 1 courant = 1 clos = 0 rappro = 1 account_number = 1 currency_code = EUR min_allowed = 0 min_desired = 0 === 10 premieres lignes llx_bank fk_account=1 par dateo === 402 | o=2025-12-31 | v=2025-12-31 | c=2026-08-10 11:09:08 | 37001.25 | type=SOLD | rappro=1 | rel=202512 | auth=1 | Solde au 31/12/2025 — comptes annuels signés TACHER ACOGEX, poste 512 (confirmé par le relevé : 29 521,40 au 09/08/2026 + 7 479,85 de flux) 47 | o=2026-01-04 | v=2026-01-04 | c=2026-02-10 16:19:19 | 1083.36 | type=VIR | rappro=1 | rel=202601 | auth=87 | (CustomerInvoicePayment) 46 | o=2026-01-05 | v=2026-01-05 | c=2026-02-10 16:18:04 | 264.58 | type=VIR | rappro=1 | rel=202601 | auth=87 | (CustomerInvoicePayment) 230 | o=2026-01-05 | v=2026-01-05 | c=2026-08-09 21:24:09 | -369.00 | type=VIR | rappro=1 | rel=202601 | auth=1 | (AgentCompta relevé) Prélèvement TACHER ACOGEX - 00260008090 TAC99415205072024 FR21ZZZ433222 214770 45 | o=2026-01-06 | v=2026-01-06 | c=2026-02-10 16:09:42 | 730.82 | type=VIR | rappro=1 | rel=202601 | auth=87 | (CustomerInvoicePayment) 173 | o=2026-01-06 | v=2026-01-06 | c=2026-08-09 14:03:03 | -133.94 | type=VIR | rappro=1 | rel=202601 | auth=1 | (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 05/01 174 | o=2026-01-06 | v=2026-01-06 | c=2026-08-09 14:03:03 | -19.49 | type=VIR | rappro=1 | rel=202601 | auth=1 | (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PAYL 05/01 231 | o=2026-01-06 | v=2026-01-06 | c=2026-08-09 21:24:09 | -90.00 | type=VIR | rappro=1 | rel=202601 | auth=1 | (AgentCompta relevé) Paiement par carte X4074 BRICO SAINT MART 05/01 278 | o=2026-01-06 | v=2026-01-06 | c=2026-08-09 21:31:37 | -342.77 | type=PRE | rappro=1 | rel=202601 | auth=1 | Remboursement de prêt 10003101334 — capital 286 | o=2026-01-06 | v=2026-01-06 | c=2026-08-09 21:31:38 | -61.15 | type=PRE | rappro=1 | rel=202601 | auth=1 | Remboursement de prêt 10003101334 — intérêts === Existe-t-il des lignes type SOLD (tous comptes) ? === 1 | acc=2 | 2025-09-06 | 3790.83000000 | (Solde initial) 401 | acc=2 | 2025-01-01 | 0.00000000 | (InitialBankBalance) 402 | acc=1 | 2025-12-31 | 37001.25000000 | Solde au 31/12/2025 — comptes annuels signés TACHER ACOGEX, poste 512 (confirmé par le relevé : 29 521,40 au 09/08/2026 + 7 479,85 de flux) total SOLD = 3 === Repartition par fk_type sur tout llx_bank fk_account=1 === VIR | n=214 | somme=29821.48 PRE | n=77 | somme=-34773.70 CB | n=56 | somme=-3952.60 CHQ | n=2 | somme=1099.08 SOLD | n=1 | somme=37001.25