=== A. comptes utiles ===
rowid=100107381 | account_number=486 | label=Charges constatées d'avance | active=1 | 
rowid=100105508 | account_number=486 | label=Charges constatées d'avance | active=1 | 
rowid=100108615 | account_number=486 | label=Charges constatées d'avance | active=1 | 
rowid=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | active=1 | 
rowid=100105579 | account_number=601 | label=Achats stockés - Matières premières et fournitures | active=1 | 
rowid=100108683 | account_number=601 | label=Achats stockés - approvisionnements | active=1 | 
rowid=100107439 | account_number=6022 | label=Fournitures consommables | active=1 | 
rowid=100105582 | account_number=6022 | label=Fournitures consommables | active=1 | 
rowid=100108697 | account_number=6022 | label=Produits d'entretien | active=1 | 
rowid=100107464 | account_number=6135 | label=Locations mobilières | active=1 | 
rowid=100105627 | account_number=6135 | label=Locations mobilières | active=1 | 
rowid=100107488 | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | 
rowid=100105655 | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | 
rowid=100108783 | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | 
rowid=100107491 | account_number=6226 | label=Honoraires | active=1 | 
rowid=100105658 | account_number=6226 | label=Honoraires | active=1 | 
rowid=100108787 | account_number=6226 | label=Autres honoraires | active=1 | 
rowid=100107526 | account_number=628 | label=Autres prestations de services | active=1 | 
rowid=100105689 | account_number=628 | label=Divers | active=1 | 
rowid=100108818 | account_number=628 | label=Divers | active=1 | 

=== B. charges 622x factures validees ===
account_number=6226 | label=Honoraires | nbl=10 | ht=4469.88000000 | 
account_number=6227 | label=Frais d'actes et de contentieux | nbl=1 | ht=1.24000000 | 
account_number=6222 | label=Commissions et courtages sur ventes | nbl=1 | ht=5000.00000000 | 

=== C. validees non payees avec mouvement bancaire de meme montant non affecte ===

=== D. tiers ===
ERR Unknown column 'fk_soc' in 'field list'

=== E. colonnes intake ===
Field=rowid | Type=int | Null=NO | Key=PRI | Default= | Extra=auto_increment | 
Field=entity | Type=int | Null=NO | Key=MUL | Default=1 | Extra= | 
Field=filename | Type=varchar(255) | Null=NO | Key= | Default= | Extra= | 
Field=file_path | Type=varchar(500) | Null=NO | Key= | Default= | Extra= | 
Field=file_hash | Type=varchar(64) | Null=NO | Key= | Default= | Extra= | 
Field=file_size | Type=int | Null=YES | Key= | Default= | Extra= | 
Field=mime_type | Type=varchar(100) | Null=YES | Key= | Default= | Extra= | 
Field=doc_type | Type=varchar(30) | Null=YES | Key= | Default= | Extra= | 
Field=confidence | Type=decimal(5,4) | Null=YES | Key= | Default= | Extra= | 
Field=fk_target_type | Type=varchar(50) | Null=YES | Key= | Default= | Extra= | 
Field=fk_target_id | Type=int | Null=YES | Key= | Default= | Extra= | 
Field=status | Type=varchar(20) | Null=NO | Key= | Default=new | Extra= | 
Field=error_message | Type=text | Null=YES | Key= | Default= | Extra= | 
Field=extracted_data | Type=longtext | Null=YES | Key= | Default= | Extra= | 
Field=tokens_input | Type=int | Null=YES | Key= | Default=0 | Extra= | 
Field=tokens_output | Type=int | Null=YES | Key= | Default=0 | Extra= | 
Field=api_cost_eur | Type=decimal(8,4) | Null=YES | Key= | Default=0.0000 | Extra= | 
Field=date_intake | Type=datetime | Null=YES | Key=MUL | Default= | Extra= | 
Field=date_processed | Type=datetime | Null=YES | Key= | Default= | Extra= | 
Field=date_validated | Type=datetime | Null=YES | Key= | Default= | Extra= | 
Field=fk_user_validate | Type=int | Null=YES | Key= | Default= | Extra= | 
Field=tms | Type=timestamp | Null=NO | Key= | Default=CURRENT_TIMESTAMP | Extra=DEFAULT_GENERATED on update CURRENT_TIMESTAMP | 

=== F. validees non payees ===
nb=17 |