=== COLS payment_various ===
{"Field":"rowid","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"ref","Type":"varchar(30)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"num_payment","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"label","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"tms","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}
{"Field":"datec","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"datep","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"datev","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"sens","Type":"smallint","Null":"NO","Key":"","Default":"0","Extra":""}
{"Field":"amount","Type":"double(24,8)","Null":"NO","Key":"","Default":"0.00000000","Extra":""}
{"Field":"fk_typepayment","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}
{"Field":"accountancy_code","Type":"varchar(32)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"subledger_account","Type":"varchar(32)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_projet","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"entity","Type":"int","Null":"NO","Key":"","Default":"1","Extra":""}
{"Field":"note","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_bank","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_author","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_modif","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
-- 19 lignes

=== COLS facturedet ===
{"Field":"rowid","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"fk_facture","Type":"int","Null":"NO","Key":"MUL","Default":null,"Extra":""}
{"Field":"fk_parent_line","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_product","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"label","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"vat_src_code","Type":"varchar(10)","Null":"YES","Key":"","Default":"","Extra":""}
{"Field":"tva_tx","Type":"double(7,4)","Null":"YES","Key":"","Default":null,"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":null,"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":null,"Extra":""}
{"Field":"qty","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"remise_percent","Type":"double","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"remise","Type":"double","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"fk_remise_except","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"subprice","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"subprice_ttc","Type":"double(24,8)","Null":"YES","Key":"","Default":"0.00000000","Extra":""}
{"Field":"price","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"total_ht","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"total_tva","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"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":null,"Extra":""}
{"Field":"product_type","Type":"int","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"date_start","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_end","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"info_bits","Type":"int","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"buy_price_ht","Type":"double(24,8)","Null":"YES","Key":"","Default":"0.00000000","Extra":""}
{"Field":"fk_product_fournisseur_price","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"batch","Type":"varchar(128)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_warehouse","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"special_code","Type":"int","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"rang","Type":"int","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"fk_contract_line","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_unit","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"import_key","Type":"varchar(14)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_code_ventilation","Type":"int","Null":"NO","Key":"MUL","Default":"0","Extra":""}
{"Field":"situation_percent","Type":"double","Null":"YES","Key":"","Default":"100","Extra":""}
{"Field":"fk_prev_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_author","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_user_modif","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_multicurrency","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"multicurrency_code","Type":"varchar(3)","Null":"YES","Key":"","Default":null,"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":"ref_ext","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"extraparams","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
-- 51 lignes

=== COLS facture_fourn_det ===
{"Field":"rowid","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"}
{"Field":"fk_facture_fourn","Type":"int","Null":"NO","Key":"MUL","Default":null,"Extra":""}
{"Field":"fk_parent_line","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"fk_product","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"ref","Type":"varchar(128)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"label","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"pu_ht","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"pu_ttc","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"qty","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"remise_percent","Type":"double","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"fk_remise_except","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"vat_src_code","Type":"varchar(10)","Null":"YES","Key":"","Default":"","Extra":""}
{"Field":"tva_tx","Type":"double(7,4)","Null":"YES","Key":"","Default":null,"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":null,"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":null,"Extra":""}
{"Field":"total_ht","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"tva","Type":"double(24,8)","Null":"YES","Key":"","Default":null,"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":null,"Extra":""}
{"Field":"product_type","Type":"int","Null":"YES","Key":"","Default":"0","Extra":""}
{"Field":"date_start","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"date_end","Type":"datetime","Null":"YES","Key":"","Default":null,"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":null,"Extra":""}
{"Field":"fk_unit","Type":"int","Null":"YES","Key":"MUL","Default":null,"Extra":""}
{"Field":"fk_multicurrency","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""}
{"Field":"multicurrency_code","Type":"varchar(3)","Null":"YES","Key":"","Default":null,"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":null,"Extra":""}
-- 40 lignes

=== COMPTES BANCAIRES ===
ERREUR: Unknown column 'accountancy_journal' in 'field list'

=== TABLES tva ===
{"Tables_in_teknipndolibarr (%tva%)":"llx_c_tva"}
{"Tables_in_teknipndolibarr (%tva%)":"llx_tva"}
-- 2 lignes

=== TABLES payment ===
{"Tables_in_teknipndolibarr (%payment%)":"llx_c_payment_term"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_donation"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_expensereport"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_loan"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_salary"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_various"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_various_extrafields"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_payment_vat"}
{"Tables_in_teknipndolibarr (%payment%)":"llx_paymentexpensereport_expensereport"}
-- 9 lignes