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
piece_num int
doc_date date
doc_type varchar(30) latin1_swedish_ci
doc_ref varchar(300) latin1_swedish_ci
fk_doc int
fk_docdet int
thirdparty_code varchar(32) latin1_swedish_ci
subledger_account varchar(32) latin1_swedish_ci
subledger_label varchar(255) latin1_swedish_ci
numero_compte varchar(32) latin1_swedish_ci
label_compte varchar(255) latin1_swedish_ci
label_operation varchar(255) latin1_swedish_ci
debit double(24,8)
credit double(24,8)
montant double(24,8)
sens varchar(1) latin1_swedish_ci
multicurrency_amount double(24,8)
multicurrency_code varchar(255) latin1_swedish_ci
lettering_code varchar(255) latin1_swedish_ci
date_lettering datetime
date_lim_reglement datetime
fk_user_author int
fk_user_modif int
date_creation datetime
tms timestamp
fk_user int
code_journal varchar(32) latin1_swedish_ci
journal_label varchar(255) latin1_swedish_ci
date_validated datetime
date_export datetime
import_key varchar(14) latin1_swedish_ci
extraparams varchar(255) latin1_swedish_ci