exercices: id, id_copro, debut, fin, nom, namecode, cloture, encours
budget_provisoire: id, id_copro, id_exercice, type_charge, id_cle, montant, validated
plan_comptable: id, numero_compte, libelle, type_compte, id_copro, id_entite, type_entite, actif, date_creation, date_modification, classe
ecritures_comptables: id, numero_ecriture, id_copro, id_exercice, date_ecriture, libelle, type_ecriture, source_id, source_type, montant_total, valide, lettre, date_validation, user_validation, date_creation, date_modification, created_by
lignes_ecritures: id, id_ecriture, numero_ligne, numero_compte, libelle_ligne, debit, credit, date_echeance, id_tiers, type_tiers, lettre, date_lettrage, date_creation
factures: id, id_copro, id_exercice, fichier_nom, fichier_chemin, fichier_type, fichier_taille, fichier_hash, fournisseur_nom, fournisseur_id, montant_ttc, montant_ht, montant_tva, date_facture, pattern_date_facture_detected, date_echeance, pattern_date_echeance_detected, numero_facture, pattern_numero_detected, reference, id_operation_bancaire, date_paiement, mode_paiement, id_ecriture_comptable, compte_401, id_travaux, compte_charge, paye_par_fond_travaux, id_ecriture_fond_travaux, exclure_budget_reel, statut, confiance_score, necessite_validation, valide_par, valide_le, texte_ocr, created_at, updated_at, created_by
fournisseurs: id, id_copro, nom, compte_401, type, siret
taux_fond_travaux: id, id_copro, id_exercice, taux

--- EXERCICES ---
(empty)

--- BUDGET ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bp.type_id' in 'on clause'

--- PLAN COMPTABLE ---
ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'code' in 'order clause'

--- ECRITURES COUNT ---
{"cnt":0}

--- FACTURES ---
{"cnt":0,"total":null}

--- FOURNISSEURS ---
{"id":82,"id_copro":51,"nom":"EDF","compte_401":"401001EDF","type":1,"siret":null}
{"id":83,"id_copro":51,"nom":"INTER-NET PROPRET\u00c9","compte_401":"401002IN","type":4,"siret":null}
{"id":84,"id_copro":51,"nom":"ALLIANZ IMMEUBLE","compte_401":"401003ALLIANZ","type":5,"siret":null}
{"id":85,"id_copro":51,"nom":"ORONA","compte_401":"401004ORONA","type":4,"siret":null}

--- TAUX ---
(empty)

--- AGs ---
(empty)

=== FIN ===