===== COLS DET =====
Field=rowid | Type=int | Null=NO | Key=PRI | Default= | Extra=auto_increment
Field=fk_facture_fourn | Type=int | Null=NO | Key=MUL | Default= | Extra=
Field=fk_parent_line | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_product | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=ref | Type=varchar(128) | Null=YES | Key= | Default= | Extra=
Field=label | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=description | Type=text | Null=YES | Key= | Default= | Extra=
Field=pu_ht | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=pu_ttc | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=qty | Type=double | Null=YES | Key= | Default= | Extra=
Field=remise_percent | Type=double | Null=YES | Key= | Default=0 | Extra=
Field=fk_remise_except | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=vat_src_code | Type=varchar(10) | Null=YES | Key= | Default= | Extra=
Field=tva_tx | Type=double(7,4) | Null=YES | Key= | Default= | Extra=
Field=localtax1_tx | Type=double(7,4) | Null=YES | Key= | Default=0.0000 | Extra=
Field=localtax1_type | Type=varchar(10) | Null=YES | Key= | Default= | Extra=
Field=localtax2_tx | Type=double(7,4) | Null=YES | Key= | Default=0.0000 | Extra=
Field=localtax2_type | Type=varchar(10) | Null=YES | Key= | Default= | Extra=
Field=total_ht | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=tva | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=total_localtax1 | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=total_localtax2 | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=total_ttc | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=product_type | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=date_start | Type=datetime | Null=YES | Key= | Default= | Extra=
Field=date_end | Type=datetime | Null=YES | Key= | Default= | Extra=
Field=info_bits | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=fk_code_ventilation | Type=int | Null=NO | Key=MUL | Default=0 | Extra=
Field=special_code | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=rang | Type=int | Null=YES | Key= | Default=0 | Extra=
Field=import_key | Type=varchar(14) | Null=YES | Key= | Default= | Extra=
Field=fk_unit | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=fk_multicurrency | Type=int | Null=YES | Key= | Default= | Extra=
Field=multicurrency_code | Type=varchar(3) | Null=YES | Key= | Default= | Extra=
Field=multicurrency_subprice | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_subprice_ttc | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_total_ht | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_total_tva | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_total_ttc | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=extraparams | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
(40 lignes)

===== LIGNES =====
ERR Unknown column 'total_tva' in 'field list'

===== SOCIETES =====
rowid=316 | nom=SCP Sophie JONVAL et Aurélien LÉGER - Greffe du tribunal de commerce de CAEN | name_alias= | siren= | siret= | tva_intra=FR86322212523 | code_fournisseur=SU2608-00013 | datec=2026-08-08 16:46:56 | zip= | town= | address=
rowid=341 | nom=Bricoman Magasin-dépôt Caen Colombelles | name_alias= | siren= | siret= | tva_intra=FR27420809923 | code_fournisseur= | datec=2026-08-08 22:33:38 | zip=14460 | town=Colombelles | address=27, rue Jean Monnet, 14460 COLOMBELLES
rowid=343 | nom=YESSS CAEN EST | name_alias= | siren= | siret= | tva_intra=FR41319883344 | code_fournisseur=SU2608-00028 | datec=2026-08-08 22:46:47 | zip= | town= | address=
rowid=345 | nom=Brico Dépôt Caen (Carpiquet) | name_alias= | siren= | siret= | tva_intra= | code_fournisseur=SU2608-00035 | datec=2026-08-09 04:32:43 | zip= | town= | address=14650 Caen (Carpiquet)
rowid=346 | nom=Greffe du tribunal de commerce de CAEN - SCP Sophie JONVAL et Aurélien LÉGER | name_alias= | siren= | siret= | tva_intra=FR86322212523 | code_fournisseur= | datec=2026-08-09 04:38:02 | zip=14054 | town=CAEN CEDEX 4 | address=Place Gambetta, Palais de justice - CS 55445 - 14054 CAEN CEDEX 4
rowid=347 | nom=SCI MARLEG | name_alias= | siren= | siret= | tva_intra= | code_fournisseur=SU2608-00029 | datec=2026-08-09 11:32:14 | zip= | town= | address=
rowid=355 | nom=DEVELOPIMMO | name_alias= | siren= | siret= | tva_intra= | code_fournisseur=SU2608-00042 | datec=2026-08-09 12:09:29 | zip= | town= | address=
rowid=362 | nom=NOTAIRE | name_alias= | siren= | siret= | tva_intra= | code_fournisseur=SU2608-00049 | datec=2026-08-09 12:09:30 | zip= | town= | address=
rowid=377 | nom=CECILE BUREL JENNIFER BARDET - Notaires | name_alias= | siren= | siret= | tva_intra=FR96314429796 | code_fournisseur=SU2608-00064 | datec=2026-08-09 13:01:18 | zip= | town= | address=
rowid=378 | nom=D&A - CAEN CHATEAU Notaire | name_alias= | siren= | siret= | tva_intra=FR82883257644 | code_fournisseur=SU2608-00065 | datec=2026-08-09 13:01:34 | zip= | town= | address=
(10 lignes)

===== TOUTES FACTURES DE CES TIERS =====
fk_soc=347 | rowid=238 | ref=SI2605-0098 | ref_supplier=05/23 | datef=2026-05-22 | total_ht=8000.00000000 | total_ttc=8000.00000000 | fk_statut=2 | paye=1
fk_soc=347 | rowid=239 | ref=SI2605-0099 | ref_supplier=05/24 | datef=2026-05-22 | total_ht=1677.42000000 | total_ttc=2012.90000000 | fk_statut=2 | paye=1
fk_soc=347 | rowid=240 | ref=SI2605-0100 | ref_supplier=05/16 | datef=2026-05-28 | total_ht=4000.00000000 | total_ttc=4800.00000000 | fk_statut=2 | paye=1
fk_soc=347 | rowid=241 | ref=SI2606-0101 | ref_supplier=06/11 | datef=2026-06-18 | total_ht=2322.58000000 | total_ttc=2787.10000000 | fk_statut=2 | paye=1
fk_soc=347 | rowid=242 | ref=SI2607-0102 | ref_supplier=07/01 | datef=2026-07-01 | total_ht=4000.00000000 | total_ttc=4800.00000000 | fk_statut=2 | paye=1
fk_soc=355 | rowid=274 | ref=SI2605-0132 | ref_supplier=06/05 | datef=2026-05-11 | total_ht=5000.00000000 | total_ttc=6000.00000000 | fk_statut=1 | paye=0
fk_soc=355 | rowid=444 | ref=SI2605-0208 | ref_supplier=DEVELOPIMMO-BAIL-2026 | datef=2026-05-19 | total_ht=5000.00000000 | total_ttc=6000.00000000 | fk_statut=2 | paye=1
fk_soc=362 | rowid=304 | ref=SI2605-0153 | ref_supplier=05/20 | datef=2026-05-21 | total_ht=900.00000000 | total_ttc=1080.00000000 | fk_statut=1 | paye=0
fk_soc=362 | rowid=305 | ref=SI2605-0154 | ref_supplier=05/21 | datef=2026-05-21 | total_ht=425.00000000 | total_ttc=485.01000000 | fk_statut=1 | paye=0
fk_soc=378 | rowid=443 | ref=SI2605-0207 | ref_supplier=D&A-BAIL-2026 | datef=2026-05-19 | total_ht=1500.00000000 | total_ttc=1800.00000000 | fk_statut=2 | paye=1
(10 lignes)