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
entity int
datec datetime
tms timestamp
fk_product int Browse foreign values Browse foreign values
fk_soc int
ref_fourn varchar(30) latin1_swedish_ci
desc_fourn text latin1_swedish_ci
fk_availability int
price double(24,8)
quantity double
remise_percent double
remise double
unitprice double(24,8)
charges double(24,8)
default_vat_code varchar(10) latin1_swedish_ci
barcode varchar(180) latin1_swedish_ci
fk_barcode_type int
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
info_bits int
fk_user int
fk_supplier_price_expression int
import_key varchar(14) latin1_swedish_ci
delivery_time_days int
supplier_reputation varchar(10) latin1_swedish_ci
fk_multicurrency int
multicurrency_code varchar(255) latin1_swedish_ci
multicurrency_tx double(24,8)
multicurrency_unitprice double(24,8)
multicurrency_price double(24,8)