Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
rowid int
fk_facture int
fk_parent_line int
fk_product int
label varchar(255) latin1_swedish_ci
description text latin1_swedish_ci
vat_src_code varchar(10) latin1_swedish_ci
tva_tx double(6,3)
localtax1_tx double(6,3)
localtax1_type varchar(10) latin1_swedish_ci
localtax2_tx double(6,3)
localtax2_type varchar(10) latin1_swedish_ci
qty double
remise_percent double
remise double
fk_remise_except int
subprice double(24,8)
price double(24,8)
total_ht double(24,8)
total_tva double(24,8)
total_localtax1 double(24,8)
total_localtax2 double(24,8)
total_ttc double(24,8)
product_type int
date_start datetime
date_end datetime
info_bits int
buy_price_ht double(24,8)
fk_product_fournisseur_price int
special_code int
rang int
fk_contract_line int
fk_unit int
import_key varchar(14) latin1_swedish_ci
fk_code_ventilation int
situation_percent double
fk_prev_id int
fk_user_author int
fk_user_modif int
fk_multicurrency int
multicurrency_code varchar(255) latin1_swedish_ci
multicurrency_subprice double(24,8)
multicurrency_total_ht double(24,8)
multicurrency_total_tva double(24,8)
multicurrency_total_ttc double(24,8)