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
id int(11)
dr_num varchar(50) latin1_swedish_ci
uom_name varchar(50) latin1_swedish_ci
ITEM_CODE varchar(100) latin1_swedish_ci
item_name varchar(255) latin1_swedish_ci
item_id int(50)
QTY int(50)
price decimal(50,2)
inv_no varchar(100) latin1_swedish_ci
inv_id int(100)
client_name varchar(100) latin1_swedish_ci
client_id int(50)
status varchar(11) latin1_swedish_ci
GUID varchar(50) latin1_swedish_ci
UID int(50)
TITLEID int(50)
PRJID int(50)
PROJECT varchar(255) latin1_swedish_ci
po_num varchar(200) latin1_swedish_ci
DR_DATE date
vat_code varchar(50) latin1_swedish_ci
VATABLE int(1)
ACID int(11)
account_code varchar(20) latin1_swedish_ci
ts timestamp
TRANSDATE date
po_cost decimal(50,6)
tempAR_amt decimal(50,6)
tempInc_amt decimal(50,6)
tempCogs_amt decimal(50,6)
tempInv_amt decimal(50,6)