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
JDID int(11)
LogID int(11)
journal_id int(3)
account_id int(11)
subsidiary varchar(255) utf8_general_ci
subsidiary_type varchar(50) utf8_general_ci
bank varchar(5) utf8_general_ci
SUBACCOUNTID int(11)
Memorandom varchar(255) utf8_general_ci
GroupEntryD varchar(50) utf8_general_ci
RECONDATE varchar(20) utf8_general_ci
_CMP int(11)
_BRN int(11)
_CHR int(11)
INV_REF varchar(255) utf8_general_ci
GS varchar(30) utf8_general_ci
DEBITS decimal(26,6)
CREDITS decimal(26,6)
DueDate date
ATC_CODE varchar(255) utf8_general_ci
ATC_RATE double
ATC_DESCRIPTION varchar(255) utf8_general_ci
imported_from_excel int(1)
WVAT varchar(3) utf8_general_ci
UNITID int(11)
UNITNAME varchar(100) utf8_general_ci
SOF varchar(255) utf8_general_ci
SOFID int(11)
SOFCode varchar(100) utf8_general_ci
SubFundName varchar(255) utf8_general_ci
SubFundID int(11)
FundClassName varchar(255) utf8_general_ci
FundClassID int(11)