--- colonnes intake ---
 rowid
 entity
 filename
 file_path
 file_hash
 file_size
 mime_type
 doc_type
 confidence
 fk_target_type
 fk_target_id
 status
 error_message
 extracted_data
 tokens_input
 tokens_output
 api_cost_eur
 date_intake
 date_processed
 date_validated
 fk_user_validate
 tms

=== INTAKE 107 ===
rowid=107 | entity=1 | filename=WURTH 07-06.pdf | file_path=/home/teknipn/documents/agentcompta/processed/2026-08/WURTH 07-06_1786242816.pdf | file_hash=2b3d2ccfbe61694dcbf96c7c058b2ed7452ec728427cc5798e3255afb77db9aa | file_size=332083 | mime_type=application/pdf | doc_type=invoice_supplier | confidence=0.9500 | fk_target_type=invoice_supplier | fk_target_id=136 | status=validated | error_message=Brouillon facture fournisseur #136 créé — à contrôler puis valider dans Dolibarr. | extracted_data={"supplier":{"name":"WÜRTH France","siret":"92959174100012","vat_number":"FR15929591741","iban":null,"email":"rouen.commercial@wurth.fr","address":"WURTH PROXI SHOP CAEN, 400 BOULEVARD CHARLES CROS, 14123, IFS"},"invoice":{"ref":"4335371605","date":"2026-07-17","due_date":"2026-08-31","currency":"EUR","total_ht":62.64,"total_tva":12.53,"total_ttc":75.17,"payment_terms":"30 jours fin de mois","pay... | tokens_input=3763 | tokens_output=689 | api_cost_eur=0.0151 | date_intake=2026-08-08 22:25:15 | date_processed=2026-08-09 00:46:18 | date_validated=2026-08-09 04:33:36 | fk_user_validate=1 | tms=2026-08-09 04:33:36
---
ERR: Unknown column 'statut' in 'field list'

=== INTAKE fichiers WURTH ===
(vide)

--- colonnes echeance ---
 rowid
 entity
 date_echeance
 montant
 libelle
 fk_soc
 statut
 fk_match
 date_creation
 tms
ERR: Unknown column 'fk_facture_fourn' in 'where clause'

=== ECHEANCES factures 136/269/135/142/124 ===
(vide)

--- log agentcompta contenant SI2607-0019 ou 0129 ou 136 ---
 rowid
 entity
 date_call
 operation
 fk_intake
 related_object
 related_id
 model
 prompt_excerpt
 response_excerpt
 tokens_input
 tokens_output
 cost_eur
 duration_ms
 status
 error_message
 fk_user
ERR: Unknown column 'message' in 'where clause'

=== LOG ===
(vide)

--- ventil_log ---
ERR: Unknown column 'fk_facture_fourn' in 'where clause'

=== VENTIL LOG ===
(vide)

--- llx_agentcompta_match sur 75.17 ---
ERR: Unknown column 'fk_facture_fourn' in 'where clause'

=== MATCH ===
(vide)

--- Statut effets : toutes echeances WURTH ---
ERR: Unknown column 'e.fk_facture_fourn' in 'on clause'

=== ECH WURTH ===
(vide)

--- toutes factures fourn en BROUILLON avec une ref definitive ---

=== BROUILLONS AVEC REF ===
(vide)

--- doublons potentiels globaux (meme montant + meme date, refs differentes) ---

=== DOUBLONS ===
(vide)

FIN3