=== A. factures du plan ===
rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | datef=2026-07-17 | total_ht=62.64000000 | total_tva=12.53000000 | total_ttc=75.17000000 | fk_statut=1 | paye=0 | close_code= | fk_soc=318 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | nbpai=0 | mtpai=0.00000000 | nbecm=0 | 
rowid=199 | ref=SI2603-0060 | ref_supplier=03/12 | datef=2026-03-10 | total_ht=3343.00000000 | total_tva=0.00000000 | total_ttc=3343.00000000 | fk_statut=2 | paye=1 | close_code= | fk_soc=288 | nom=Divers au comptant | nbpai=1 | mtpai=3343.00000000 | nbecm=0 | 
rowid=232 | ref=SI2601-0092 | ref_supplier=01/04 | datef=2026-01-14 | total_ht=95.00000000 | total_tva=19.00000000 | total_ttc=114.00000000 | fk_statut=2 | paye=1 | close_code= | fk_soc=286 | nom=NLJ | nbpai=1 | mtpai=114.00000000 | nbecm=0 | 
rowid=233 | ref=SI2602-0093 | ref_supplier=02/02 | datef=2026-02-01 | total_ht=100.50000000 | total_tva=20.10000000 | total_ttc=120.60000000 | fk_statut=2 | paye=1 | close_code= | fk_soc=286 | nom=NLJ | nbpai=1 | mtpai=120.60000000 | nbecm=0 | 
rowid=265 | ref=SI2607-0125 | ref_supplier=07/29 | datef=2026-07-09 | total_ht=100.00000000 | total_tva=20.00000000 | total_ttc=120.00000000 | fk_statut=1 | paye=0 | close_code= | fk_soc=286 | nom=NLJ | nbpai=0 | mtpai=0.00000000 | nbecm=0 | 
rowid=274 | ref=SI2605-0132 | ref_supplier=06/05 | datef=2026-05-11 | total_ht=5000.00000000 | total_tva=1000.00000000 | total_ttc=6000.00000000 | fk_statut=1 | paye=0 | close_code= | fk_soc=355 | nom=DEVELOPIMMO | nbpai=0 | mtpai=0.00000000 | nbecm=0 | 
rowid=294 | ref=SI2606-0143 | ref_supplier=06/13 | datef=2026-06-19 | total_ht=-11.00000000 | total_tva=-2.20000000 | total_ttc=-13.20000000 | fk_statut=1 | paye=0 | close_code= | fk_soc=359 | nom=KDI | nbpai=0 | mtpai=0.00000000 | nbecm=0 | 
rowid=304 | ref=SI2605-0153 | ref_supplier=05/20 | datef=2026-05-21 | total_ht=900.00000000 | total_tva=180.00000000 | total_ttc=1080.00000000 | fk_statut=1 | paye=0 | close_code= | fk_soc=362 | nom=NOTAIRE | nbpai=0 | mtpai=0.00000000 | nbecm=0 | 
rowid=443 | ref=SI2605-0207 | ref_supplier=D&A-BAIL-2026 | datef=2026-05-19 | total_ht=1500.00000000 | total_tva=300.00000000 | total_ttc=1800.00000000 | fk_statut=2 | paye=1 | close_code= | fk_soc=378 | nom=D&A - CAEN CHATEAU Notaire | nbpai=1 | mtpai=1800.00000000 | nbecm=0 | 
rowid=444 | ref=SI2605-0208 | ref_supplier=DEVELOPIMMO-BAIL-2026 | datef=2026-05-19 | total_ht=5000.00000000 | total_tva=1000.00000000 | total_ttc=6000.00000000 | fk_statut=2 | paye=1 | close_code= | fk_soc=355 | nom=DEVELOPIMMO | nbpai=1 | mtpai=6000.00000000 | nbecm=0 | 
rowid=445 | ref=SI2607-0210 | ref_supplier=5801562824 | datef=2026-07-31 | total_ht=284.11000000 | total_tva=56.83000000 | total_ttc=340.94000000 | fk_statut=1 | paye=0 | close_code= | fk_soc=381 | nom=Air Liquide France Industrie - IM | nbpai=0 | mtpai=0.00000000 | nbecm=0 | 

=== B. lignes + ventilation ===
fk_facture_fourn=136 | rowid=426 | descr=Foret métal - FORET DIN 338 HSS SMART STEP Ø6,8MM  | total_ht=31.90000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=136 | rowid=427 | descr=Taraud machine, trous débouchants - TAR MACHINE HS | total_ht=30.74000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=199 | rowid=527 | descr=ACHAT MAT 1è FOURNITURES | total_ht=3343.00000000 | tva_tx=0.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=232 | rowid=560 | descr=ACHAT MAT 1è FOURNITURES | total_ht=95.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=233 | rowid=561 | descr=ACHAT MAT 1è FOURNITURES | total_ht=100.50000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=265 | rowid=593 | descr=ACHAT MAT 1è FOURNITURES | total_ht=100.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=274 | rowid=600 | descr=FRAIS DIVERS | total_ht=5000.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107526 | account_number=628 | label=Autres prestations de services | 
fk_facture_fourn=294 | rowid=612 | descr=ACHAT MAT 1è FOURNITURES | total_ht=-11.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 
fk_facture_fourn=304 | rowid=622 | descr=HONORAIRES JURIDIQUES | total_ht=900.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107491 | account_number=6226 | label=Honoraires | 
fk_facture_fourn=443 | rowid=785 | descr=Honoraires de bail commercial — SCI MARLEG / TEKNI | total_ht=1500.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107491 | account_number=6226 | label=Honoraires | 
fk_facture_fourn=444 | rowid=787 | descr=Honoraires de négociation sur location
Location SC | total_ht=5000.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107488 | account_number=6222 | label=Commissions et courtages sur ventes | 
fk_facture_fourn=445 | rowid=788 | descr=Facture ECOPASS de location payée d'avance à la so | total_ht=284.11000000 | tva_tx=20.0000 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures | 

=== C. ECM ===
rowid=1799 | label=59f837bb3c7498b786d0f5731782d004 | src_object_type=facture_fourn | src_object_id=136 | filepath=fournisseur/facture/6/3/SI2607-0019 | filename=WURTH 07-06.pdf | 
rowid=1862 | label=887013673ed9edf22e3e399f66aeee22 | src_object_type=facture_fourn | src_object_id=445 | filepath=fournisseur/facture/5/4/SI2607-0210 | filename=5801562824-1.pdf | 

=== D. intake ===
rowid=20 | filename=NLJ 01-04.pdf | status=validated | fk_target_type=invoice_supplier | fk_target_id=97 | date_validated=2026-08-09 04:33:18 | 
rowid=56 | filename=jlautour_FAC5050744.pdf | status=awaiting_validation | fk_target_type=invoice_supplier | fk_target_id=100 | date_validated= | 
rowid=91 | filename=AUTOSEN 03-12.pdf | status=validated | fk_target_type=invoice_supplier | fk_target_id=148 | date_validated=2026-08-09 05:44:04 | 
rowid=107 | filename=WURTH 07-06.pdf | status=validated | fk_target_type=invoice_supplier | fk_target_id=136 | date_validated=2026-08-09 04:33:36 | 
rowid=151 | filename=KDI 06-13.pdf | status=awaiting_validation | fk_target_type=invoice_supplier | fk_target_id=415 | date_validated= | 
rowid=165 | filename=NLJ 02-02.pdf | status=awaiting_validation | fk_target_type=invoice_supplier | fk_target_id=423 | date_validated= | 
rowid=170 | filename=NOTAIRE 06-04.pdf | status=awaiting_validation | fk_target_type=invoice_supplier | fk_target_id=426 | date_validated= | 
rowid=197 | filename=5801562824-1.pdf | status=awaiting_validation | fk_target_type=invoice_supplier | fk_target_id=445 | date_validated= | 

=== E. nb brouillons ===
nb=0 | ttc=0.00000000 | 

=== F. liste brouillons ===

=== G. bookkeeping ===
nb=0 |