=== A. FACTURE 294 COMPLETE === rowid=[294] ref=[SI2606-0143] ref_supplier=[06/13] datef=[2026-06-19] date_lim_reglement=[2026-05-26] type=[0] fk_statut=[2] paye=[0] fk_soc=[359] total_ht=[-11.00000000] total_tva=[-2.20000000] total_ttc=[-13.20000000] fk_facture_source=[] datec=[2026-08-09 12:09:29] close_code=[other] note_private=[Repris de la comptabilité Excel de l'assistante de direction — pièce 06/13 (ACHAT MAT 1è FOURNITURES). [AgentCompta 09/08/2026] Numéro réel du fournisseur : 3410281941. Doublon (PROV415) supprimé, son justificatif scanné a été repris ici.] -- 1 ligne(s) === B. LIGNES DE 294 === ERR Unknown column 'subprice' in 'field list' === C. TIERS 359 === rowid=[359] nom=[KDI] code_fournisseur=[SU2608-00046] fournisseur=[1] -- 1 ligne(s) === D. TOUTES PIECES DU TIERS 359 === rowid=[290] ref=[SI2602-0139] ref_supplier=[02/06] datef=[2026-02-19] type=[0] fk_statut=[2] paye=[1] total_ht=[1499.72000000] total_tva=[299.94000000] total_ttc=[1799.66000000] fk_facture_source=[] rowid=[291] ref=[SI2603-0140] ref_supplier=[03/08] datef=[2026-03-13] type=[0] fk_statut=[2] paye=[1] total_ht=[901.00000000] total_tva=[180.20000000] total_ttc=[1081.20000000] fk_facture_source=[] rowid=[292] ref=[SI2605-0141] ref_supplier=[05/14] datef=[2026-05-12] type=[0] fk_statut=[2] paye=[1] total_ht=[816.75000000] total_tva=[163.35000000] total_ttc=[980.10000000] fk_facture_source=[] rowid=[293] ref=[SI2606-0142] ref_supplier=[06/12] datef=[2026-06-05] type=[0] fk_statut=[2] paye=[0] total_ht=[1485.00000000] total_tva=[297.00000000] total_ttc=[1782.00000000] fk_facture_source=[] rowid=[294] ref=[SI2606-0143] ref_supplier=[06/13] datef=[2026-06-19] type=[0] fk_statut=[2] paye=[0] total_ht=[-11.00000000] total_tva=[-2.20000000] total_ttc=[-13.20000000] fk_facture_source=[] -- 5 ligne(s) === E. TYPES PRESENTS DANS LA BASE === type=[0] nb=[256] s=[293843.83000000] -- 1 ligne(s) === F. NB PIECES NEGATIVES === nb=[1] mini=[-13.20000000] -- 1 ligne(s) === F2. PIECES total_ht<0 === rowid=[294] ref=[SI2606-0143] total_ht=[-11.00000000] total_ttc=[-13.20000000] -- 1 ligne(s) === G. LIENS PAIEMENT SUR 294 === -- 0 ligne(s) === H. REPARTITION STATUT/PAYE/TYPE === fk_statut=[1] paye=[0] type=[0] nb=[12] s=[19897.89] fk_statut=[2] paye=[0] type=[0] nb=[10] s=[16557.48] fk_statut=[2] paye=[1] type=[0] nb=[222] s=[250351.21] fk_statut=[3] paye=[0] type=[0] nb=[12] s=[7037.25] -- 4 ligne(s)