COLS DET: rowid,fk_facture_fourn,fk_parent_line,fk_product,ref,label,description,pu_ht,pu_ttc,qty,remise_percent,fk_remise_except,vat_src_code,tva_tx,localtax1_tx,localtax1_type,localtax2_tx,localtax2_type,total_ht,tva,total_localtax1,total_localtax2,total_ttc,product_type,date_start,date_end,info_bits,fk_code_ventilation,special_code,rang,import_key,fk_unit,fk_multicurrency,multicurrency_code,multicurrency_subprice,multicurrency_subprice_ttc,multicurrency_total_ht,multicurrency_total_tva,multicurrency_total_ttc,extraparams === C. lignes 294 et 415 === rowid=612 | fk_facture_fourn=294 | fk_parent_line= | fk_product= | ref= | label= | description=ACHAT MAT 1è FOURNITURES | pu_ht=-11.00000000 | pu_ttc=-13.20000000 | qty=1 | remise_percent=0 | fk_remise_except= | vat_src_code= | tva_tx=20.0000 | localtax1_tx=0.0000 | localtax1_type=0 | localtax2_tx=0.0000 | localtax2_type=0 | total_ht=-11.00000000 | tva=-2.20000000 | total_localtax1=0.00000000 | total_localtax2=0.00000000 | total_ttc=-13.20000000 | product_type=0 | date_start= | date_end= | info_bits=0 | fk_code_ventilation=100107436 | special_code=0 | rang=1 | import_key= | fk_unit= | fk_multicurrency=0 | multicurrency_code=EUR | multicurrency_subprice=-11.00000000 | multicurrency_subprice_ttc=0.00000000 | multicurrency_total_ht=-11.00000000 | multicurrency_total_tva=-2.20000000 | multicurrency_total_ttc=-13.20000000 | extraparams= | (1 lignes) === D. paiements lies factures KDI === rowid=142 | fk_paiementfourn=120 | fk_facturefourn=290 | amount=1799.66000000 | multicurrency_code= | multicurrency_tx=1.00000000 | multicurrency_amount=1799.66000000 | rowid=147 | fk_paiementfourn=125 | fk_facturefourn=291 | amount=1081.20000000 | multicurrency_code= | multicurrency_tx=1.00000000 | multicurrency_amount=1081.20000000 | rowid=166 | fk_paiementfourn=144 | fk_facturefourn=292 | amount=980.10000000 | multicurrency_code= | multicurrency_tx=1.00000000 | multicurrency_amount=980.10000000 | (3 lignes) === E. paiements detail === rowid=120 | datep=2026-02-16 00:00:00 | amount=1799.66000000 | num_paiement= | note=AgentCompta — relevé Crédit Agricole du 2026-02-16 Libellé : Virement émis VIR INST vers KDI (Toles) - ACOMPTE KDI 1021289610 TEKNIPLI Facture : SI2602-0139 | fk_bank=234 | rowid=125 | datep=2026-03-16 00:00:00 | amount=1081.20000000 | num_paiement= | note=AgentCompta — relevé Crédit Agricole du 2026-03-16 Libellé : Paiement par carte X4074 KDI AUBERVILLIERS 13/03 Facture : SI2603-0140 | fk_bank=239 | rowid=144 | datep=2026-05-13 00:00:00 | amount=980.10000000 | num_paiement= | note=AgentCompta — relevé Crédit Agricole du 2026-05-13 Libellé : Virement émis VIR INST vers KDI - ACOMPTE KDI PROFORMA 9011592073 TEKNIPLI Facture : SI2605-0141 | fk_bank=258 | (3 lignes)