=== F1 lignes bancaires 28/07-03/08 avec lien objet ===
  [1] rowid=102 | dateo=2026-07-28 | datev=2026-07-28 | amount=5015.74000000 | label=(CustomerInvoicePayment) | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment | url_id=101
  [2] rowid=167 | dateo=2026-07-28 | datev=2026-07-28 | amount=-2712.00000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 METALMAQ GAVA        27/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=53
  [3] rowid=399 | dateo=2026-07-28 | datev=2026-07-28 | amount=-200.00000000 | label=(AgentCompta) Paiement par carte X7200 CARREFOUR MARKET ST 27/07 | num_releve=202607 | rappro=1 | fk_type=CB | urltype=payment_supplier | url_id=205
  [4] rowid=162 | dateo=2026-07-29 | datev=2026-07-29 | amount=-209.00000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=48
  [5] rowid=163 | dateo=2026-07-29 | datev=2026-07-29 | amount=-16.62000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=49
  [6] rowid=164 | dateo=2026-07-29 | datev=2026-07-29 | amount=-56.59000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=50
  [7] rowid=165 | dateo=2026-07-29 | datev=2026-07-29 | amount=-40.79000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=51
  [8] rowid=166 | dateo=2026-07-29 | datev=2026-07-29 | amount=-11.75000000 | label=(AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=52
  [9] rowid=161 | dateo=2026-07-30 | datev=2026-07-30 | amount=-1.24000000 | label=(AgentCompta) PAIEMENT PAR CARTE X7200 INPI VADS 92 COURBEV 29/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=47
  [10] rowid=275 | dateo=2026-07-30 | datev=2026-07-30 | amount=-130.80000000 | label=(AgentCompta relevé) Paiement par carte X7200 MEDIALEX RENNES 29/07 | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=161
  [11] rowid=317 | dateo=2026-07-30 | datev=2026-07-30 | amount=2194.00000000 | label=Remboursement DGFiP — crédit de TVA | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_various | url_id=25
  [12] rowid=103 | dateo=2026-07-31 | datev=2026-07-31 | amount=3120.00000000 | label=(CustomerInvoicePayment) | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment | url_id=102
  [13] rowid=209 | dateo=2026-07-31 | datev=2026-07-31 | amount=-8804.22000000 | label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=95
  [14] rowid=356 | dateo=2026-07-31 | datev=2026-07-31 | amount=-1627.13000000 | label=Salaire net | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_various | url_id=63
  [15] rowid=453 | dateo=2026-07-31 | datev=2026-07-31 | amount=32.57000000 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | num_releve=202607 | rappro=1 | fk_type=VIR | urltype=payment_various | url_id=105
  [16] rowid=160 | dateo=2026-08-03 | datev=2026-08-03 | amount=-1290.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/27 SELLERIE THOMAS F267110 TEKNIPLI | num_releve=202608 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=46
  [17] rowid=212 | dateo=2026-08-03 | datev=2026-08-03 | amount=-3240.00000000 | label=(AgentCompta relevé) Virement émis WEB GREGOIRE DONNART 26-08-12 TE - FA08/01 DONNART 26-08-12 TEKNIPLI | num_releve=202608 | rappro=1 | fk_type=VIR | urltype=payment_supplier | url_id=98

=== F2 lignes entre 32 et 33 EUR ===
  [1] rowid=76 | dateo=2026-04-25 | amount=32.33000000 | label=(CustomerInvoicePayment) | num_releve=202604 | rappro=1 | fk_type=VIR
  [2] rowid=453 | dateo=2026-07-31 | amount=32.57000000 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | num_releve=202607 | rappro=1 | fk_type=VIR

=== F3 rappro sans releve (doit etre 0) ===
  [1] nb=0

=== F4 releve sans rappro (doit etre 0) ===
  [1] nb=0

=== F5 bank_url type=payment orphelins ===
  (aucune ligne)

=== F6 bank_url type=payment_various orphelins ===
  (aucune ligne)

=== F7 bank_url type=payment_supplier orphelins ===
  (aucune ligne)

=== F8 paiement fournisseur 112 (le url_id=112 trouve) ===
  [1] rowid=112 | datep=2026-03-03 00:00:00 | amount=120.60000000 | fk_bank=226

=== F9 types de paiement ===
ERREUR: Unknown column 'rowid' in 'field list'

=== F10 ligne bancaire du debit INPI 225.77 ===
  [1] rowid=431 | dateo=2026-07-21 | amount=-225.77000000 | label=Redevance INPI — dépôt/renouvellement de marque | fk_type=CB | num_releve=202607

=== F11 repartition fk_type compte 1 ===
  [1] fk_type=VIR | nb=281
  [2] fk_type=CHQ | nb=2
  [3] fk_type=PRE | nb=89
  [4] fk_type=CB | nb=56
  [5] fk_type=SOLD | nb=1

=== G1 DDL llx_facture (tms) ===
  [1] Table=llx_facture | Create Table=CREATE TABLE `llx_facture` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_client` varchar(255) DEFAULT NULL,
  `type` smallint NOT NULL DEFAULT '0',
  `subtype` smallint DEFAULT NULL,
  `fk_soc` int NOT NULL,
  `datec` datetime DEFAULT NULL,
  `datef` date DEFAULT NULL,
  `date_pointoftax` date DEFAULT NULL,
  `date_valid` date DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `date_closing` datetime DEFAULT NULL,
  `paye` smallint NOT NULL DEFAULT '0',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `close_code` varchar(16) DEFAULT NULL,
  `close_missing_amount` double(24,8) DEFAULT NULL,
  `close_note` varchar(128) DEFAULT NULL,
  `total_tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `revenuestamp` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_statut` smallint NOT NULL DEFAULT '0',
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `fk_user_closing` int DEFAULT NULL,
  `module_source` varchar(32) DEFAULT NULL,
  `pos_source` varchar(32) DEFAULT NULL,
  `fk_fac_rec_source` int DEFAULT NULL,
  `fk_facture_source` int DEFAULT NULL,
  `fk_projet` int DEFAULT NULL,
  `increment` varchar(10) DEFAULT NULL,
  `fk_account` int DEFAULT NULL,
  `fk_currency` varchar(3) DEFAULT NULL,
  `fk_cond_reglement` int NOT NULL DEFAULT '1',
  `fk_mode_reglement` int DEFAULT NULL,
  `date_lim_reglement` date DEFAULT NULL,
  `payment_reference` varchar(25) DEFAULT NULL,
  `dispute_status` int DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `fk_input_reason` int DEFAULT NULL,
  `fk_incoterms` int DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `fk_transport_mode` int DEFAULT NULL,
  `prorata_discount` double DEFAULT NULL,
  `situation_cycle_ref` int DEFAULT NULL,
  `situation_counter` smallint DEFAULT NULL,
  `situation_final` smallint DEFAULT NULL,
  `retained_warranty` double DEFAULT NULL,
  `retained_warranty_date_limit` date DEFAULT NULL,
  `retained_warranty_fk_cond_reglement` int DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `is_also_delivery_note` tinyint NOT NULL DEFAULT '0',
  `fk_multicurrency` int DEFAULT NULL,
  `multicurrency_code` varchar(3) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  `ip` varchar(250) DEFAULT NULL,
  `pos_print_counter` int DEFAULT '0',
  `email_sent_counter` int DEFAULT '0',
  `fk_thirdparty_rib_id` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_facture_ref` (`ref`,`entity`),
  KEY `idx_facture_fk_soc` (`fk_soc`),
  KEY `idx_facture_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_fk_user_valid` (`fk_user_valid`),
  KEY `idx_facture_fk_facture_source` (`fk_facture_source`),
  KEY `idx_facture_fk_projet` (`fk_projet`),
  KEY `idx_facture_fk_account` (`fk_account`),
  KEY `idx_facture_fk_currency` (`fk_currency`),
  KEY `idx_facture_fk_statut` (`fk_statut`),
  KEY `idx_facture_datef` (`datef`),
  KEY `idx_facture_tms` (`tms`),
  KEY `idx_facture_fk_input_reason` (`fk_input_reason`),
  CONSTRAINT `fk_facture_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_facture_fk_input_reason` FOREIGN KEY (`fk_input_reason`) REFERENCES `llx_c_input_reason` (`rowid`),
  CONSTRAINT `fk_facture_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  CONSTRAINT `fk_facture_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_facture_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_facture_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=433 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

=== G2 tms factures voisines ===
  [1] rowid=313 | ref=FA2607-0291 | tms=2026-10-21 12:54:37 | datec=2026-07-29 08:08:30 | paye=1 | fk_statut=2
  [2] rowid=314 | ref=FA2607-0292 | tms=2026-10-21 12:54:40 | datec=2026-07-29 08:38:02 | paye=1 | fk_statut=2
  [3] rowid=315 | ref=FA2607-0293 | tms=2026-10-21 12:54:43 | datec=2026-07-29 08:38:30 | paye=1 | fk_statut=2

=== G3 derniers reglements clients ===
  [1] rowid=148 | datep=2026-08-11 00:00:00 | datec=2026-10-19 10:25:56 | tms=2026-10-19 10:25:56 | amount=1478.40000000 | fk_bank=535 | num_paiement=8299011324396 | note=AgentCompta — match #1034
Libellé : VIREMENT EN VOTRE FAVEUR VIR INST de Normandie Bois Konce Loyer aout SCTINSTOUTEfT8tObOQkmTo40qhrpc4A
  [2] rowid=147 | datep=2026-10-15 00:00:00 | datec=2026-10-18 06:36:57 | tms=2026-10-18 06:36:58 | amount=742.80000000 | fk_bank=530 | num_paiement=8388450007074 | note=AgentCompta — règlement groupé, match #1144
Factures : FA2609-0361 + FA2608-0351
Libellé : VIREMENT EN VOTRE FAVEUR RENAULT TRUCKS 6402484973 FA 2609-0361,FA2608-0351, 6402484973
  [3] rowid=146 | datep=2026-10-01 00:00:00 | datec=2026-10-18 06:32:22 | tms=2026-10-18 06:32:22 | amount=2964.00000000 | fk_bank=529 | num_paiement=8373050012558 | note=AgentCompta — règlement groupé, match #1122
Factures : FA2608-0329 + FA2608-0349
Libellé : VIREMENT EN VOTRE FAVEUR RENAULT TRUCKS 6402476661 FA2608-0329,FA2608-0349, 6402476661
  [4] rowid=145 | datep=2026-09-24 00:00:00 | datec=2026-10-18 06:32:22 | tms=2026-10-18 06:32:22 | amount=587.36000000 | fk_bank=528 | num_paiement=8365290008105 | note=AgentCompta — règlement groupé, match #1112
Factures : FA2608-0344 + FA2608-0345 + FA2608-0346
Libellé : VIREMENT EN VOTRE FAVEUR RENAULT TRUCKS 6402473178 FA2608-0344,FA 2608-0345,FA2608-0346, 6402473178
  [5] rowid=144 | datep=2026-10-08 00:00:00 | datec=2026-10-18 06:32:21 | tms=2026-10-18 06:32:22 | amount=9202.20000000 | fk_bank=527 | num_paiement=8380760007819 | note=AgentCompta — règlement groupé, match #1138
Factures : FA2609-0357 + FA2609-0358 + FA2609-0359 + FA2609-0356 + FA2608-0350 + FA2608-0348
Libellé : VIREMENT EN VOTRE FAVEUR RENAULT TRUCKS 6402479974 FA2609-0357,FA2609-358,FA2609-0359,FA2609-0356,FA2608-0350,FA2608-0348, 6402479974
  [6] rowid=143 | datep=2026-10-16 00:00:00 | datec=2026-10-18 06:30:33 | tms=2026-10-18 06:30:33 | amount=557.42000000 | fk_bank=516 | num_paiement=8352672470805 | note=AgentCompta — match #1145
Libellé : VIREMENT EN VOTRE FAVEUR Tekni-pli S.A.S.   ACVR HOME Tekni-pli
  [7] rowid=142 | datep=2026-09-30 00:00:00 | datec=2026-10-11 18:45:32 | tms=2026-10-11 18:45:31 | amount=108.21000000 | fk_bank=503 | num_paiement=8371420001176 | note=AgentCompta — match #1120
Libellé : VIREMENT EN VOTRE FAVEUR EBP COUVERTURE VIREMENT VERS TEK 0370 - LEBOUCHER - SAINT SYLVAIN VIREMENT VERS TEKNI PLI PLIAGE ET A
  [8] rowid=141 | datep=2026-10-05 00:00:00 | datec=2026-10-11 18:44:42 | tms=2026-10-11 18:44:41 | amount=238.39000000 | fk_bank=501 | num_paiement=8375830022559 | note=AgentCompta — match #1128
Libellé : VIREMENT EN VOTRE FAVEUR LMI FA2609-0376 LMI FA2609-0376 LMI

=== G4 derniers paiements divers ===
  [1] rowid=123 | datec=2026-10-18 06:30:34 | datep=2026-10-07 | amount=11.38000000 | sens=0 | accountancy_code=616 | label=GAN, quatre contrats | fk_bank=526
  [2] rowid=122 | datec=2026-10-18 06:30:34 | datep=2026-10-07 | amount=57.53000000 | sens=0 | accountancy_code=616 | label=GAN, quatre contrats | fk_bank=525
  [3] rowid=121 | datec=2026-10-18 06:30:34 | datep=2026-10-07 | amount=78.89000000 | sens=0 | accountancy_code=616 | label=GAN, quatre contrats | fk_bank=524
  [4] rowid=120 | datec=2026-10-18 06:30:34 | datep=2026-10-07 | amount=130.01000000 | sens=0 | accountancy_code=616 | label=GAN, quatre contrats | fk_bank=523
  [5] rowid=119 | datec=2026-10-18 06:30:34 | datep=2026-09-16 | amount=1096.00000000 | sens=0 | accountancy_code=444 | label=DGFiP IS | fk_bank=522
  [6] rowid=118 | datec=2026-10-18 06:30:34 | datep=2026-08-26 | amount=3617.00000000 | sens=0 | accountancy_code=44551 | label=DGFiP TVA | fk_bank=521
  [7] rowid=117 | datec=2026-10-18 06:30:34 | datep=2026-10-14 | amount=31.40000000 | sens=0 | accountancy_code=627 | label=Cotisation du compte CA | fk_bank=520
  [8] rowid=116 | datec=2026-10-18 06:30:33 | datep=2026-10-05 | amount=49.17000000 | sens=0 | accountancy_code=6611 | label=Prêt, intérêts | fk_bank=518

=== G5 evenements agenda INPI/facture ===
  [1] id=5873 | ref=5873 | datep=2026-09-13 08:10:49 | label=Facture FA2607-0291 passée à payée | note=Facture FA2607-0291 passée à payée
Invoice set to paid by the payment->create() of payment PAY2609-0126 because the remain to pay is 0 | elementtype=invoice | fk_element=313
  [2] id=5589 | ref=5589 | datep=2026-08-27 08:35:57 | label=Relevé de factures - SAS TEKNI-PLI | note=Relevé multi-factures TEKNI-PLI

À: contact@sarlmac.com
Factures: FA2607-0267, FA2607-0268, FA2607-0269, FA2607-0270, FA2607-0279, FA2607-0286, FA2607-0287, FA2607-0291, FA2607-0292, FA2607-0293, FA2607-0294, FA2607-0296, FA2608-0300, FA2608-0302, FA2608-0307, FA2608-0330
Total restant dû: 14 136,63 € | elementtype=NULL | fk_element=NULL
  [3] id=5320 | ref=5320 | datep=2026-08-24 18:43:05 | label=Relevé de factures - SAS TEKNI-PLI | note=Relevé multi-factures TEKNI-PLI

À: contact@sarlmac.com
Factures: FA2607-0267, FA2607-0268, FA2607-0269, FA2607-0270, FA2607-0279, FA2607-0286, FA2607-0287, FA2607-0291, FA2607-0292, FA2607-0293, FA2607-0294, FA2607-0296, FA2608-0300, FA2608-0302, FA2608-0307, FA2608-0330
Total restant dû: 14 136,63 € | elementtype=NULL | fk_element=NULL
  [4] id=5319 | ref=5319 | datep=2026-08-24 18:43:04 | label=Relevé de factures - SAS TEKNI-PLI | note=Relevé multi-factures TEKNI-PLI

À: contact@sarlmac.com
Factures: FA2607-0267, FA2607-0268, FA2607-0269, FA2607-0270, FA2607-0279, FA2607-0286, FA2607-0287, FA2607-0291, FA2607-0292, FA2607-0293, FA2607-0294, FA2607-0296, FA2608-0300, FA2608-0302, FA2608-0307, FA2608-0330
Total restant dû: 14 136,63 € | elementtype=NULL | fk_element=NULL
  [5] id=4548 | ref=4548 | datep=2026-08-09 12:09:29 | label=Third party INPI created | note=Third party INPI created | elementtype=NULL | fk_element=NULL
  [6] id=4032 | ref=4032 | datep=2026-07-29 08:08:32 | label=Facture FA2607-0291 - SAS TEKNI-PLI | note=Envoi automatique via TEKNI-PLI (Facturer+Envoyer 1-clic)

À: contact@sarlmac.com
Facture: FA2607-0291
Propale: PR2607-0396
Fiches: 1 | elementtype=invoice | fk_element=313
  [7] id=4031 | ref=4031 | datep=2026-07-29 08:08:30 | label=Facture FA2607-0291 validée | note=Facture FA2607-0291 validée | elementtype=invoice | fk_element=313

=== G6 releve 202607 ===
  [1] nb=63 | tot=994.64

=== G7 releve 202607 credits ===
  [1] nb=16 | tot=52779.37

=== G8 comptes bancaires ===
  [1] rowid=1 | ref=Tekni-pli | label=Compte Courant | courant=1 | clos=0 | entity=1
  [2] rowid=2 | ref=HIST25 | label=Historique 2025 (exercice clos) — ne pas utiliser | courant=0 | clos=1 | entity=1