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(30) latin1_swedish_ci
entity int
ref_ext varchar(255) latin1_swedish_ci
ref_int varchar(255) latin1_swedish_ci
ref_client varchar(255) latin1_swedish_ci
type smallint
fk_soc int Browse foreign values Browse foreign values
datec datetime
datef date
date_pointoftax date
date_valid date
tms timestamp
date_closing datetime
paye smallint
remise_percent double
remise_absolue double
remise double
close_code varchar(16) latin1_swedish_ci
close_note varchar(128) latin1_swedish_ci
tva double(24,8)
localtax1 double(24,8)
localtax2 double(24,8)
revenuestamp double(24,8)
total double(24,8)
total_ttc double(24,8)
fk_statut smallint
fk_user_author int
fk_user_modif int
fk_user_valid int
fk_user_closing int
module_source varchar(32) latin1_swedish_ci
pos_source varchar(32) latin1_swedish_ci
fk_fac_rec_source int
fk_facture_source int Browse foreign values Browse foreign values
fk_projet int Browse foreign values Browse foreign values
increment varchar(10) latin1_swedish_ci
fk_account int
fk_currency varchar(3) latin1_swedish_ci
fk_cond_reglement int
fk_mode_reglement int
date_lim_reglement date
note_private text latin1_swedish_ci
note_public text latin1_swedish_ci
model_pdf varchar(255) latin1_swedish_ci
last_main_doc varchar(255) latin1_swedish_ci
fk_incoterms int
location_incoterms varchar(255) latin1_swedish_ci
situation_cycle_ref smallint
situation_counter smallint
situation_final smallint
retained_warranty double
retained_warranty_date_limit date
retained_warranty_fk_cond_reglement int
import_key varchar(14) latin1_swedish_ci
extraparams varchar(255) 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)