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
ref varchar(50) latin1_swedish_ci
entity int
ref_number_int int
ref_ext int
total_ht double(24,8)
total_tva double(24,8)
localtax1 double(24,8)
localtax2 double(24,8)
total_ttc double(24,8)
date_debut date
date_fin date
date_create datetime
date_valid datetime
date_approve datetime
date_refuse datetime
date_cancel datetime
tms timestamp
fk_user_author int
fk_user_modif int
fk_user_valid int
fk_user_validator int
fk_user_approve int
fk_user_refuse int
fk_user_cancel int
fk_statut int
fk_c_paiement int
paid smallint
note_public text latin1_swedish_ci
note_private text latin1_swedish_ci
detail_refuse varchar(255) latin1_swedish_ci
detail_cancel varchar(255) latin1_swedish_ci
integration_compta int
fk_bank_account int
model_pdf varchar(50) latin1_swedish_ci
fk_multicurrency int
multicurrency_code varchar(255) latin1_swedish_ci
multicurrency_tx double(24,8)
multicurrency_total_ht double(24,8)
multicurrency_total_tva double(24,8)
multicurrency_total_ttc double(24,8)
import_key varchar(14) latin1_swedish_ci
extraparams varchar(255) latin1_swedish_ci