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)
SOFID int(11)
SOFDescription varchar(255) latin1_swedish_ci
AccountID int(3)
Account varchar(255) latin1_swedish_ci
APPID int(11)
DEPID int(11)
DepartmentName varchar(100) latin1_swedish_ci
YR int(4)
ItemID int(11)
ItemDescription varchar(255) latin1_swedish_ci
Qty int(11)
UoM varchar(100) latin1_swedish_ci
Cost decimal(26,6)
TotalCost decimal(26,6)
ModeofProc varchar(255) latin1_swedish_ci
Jan double
Feb double
mar double
Apr double
may double
Jun double
Jul double
Aug double
Sept double
Oct_ double
Nov double
Dec_ double
JanAmt decimal(26,6)
FebAmt decimal(26,6)
MarAmt decimal(26,6)
AprAmt decimal(26,6)
MayAmt decimal(26,6)
JunAmt decimal(26,6)
JulAmt decimal(26,6)
AugAmt decimal(26,6)
SeptAmt decimal(26,6)
OctAmt decimal(26,6)
NovAmt decimal(26,6)
DecAmt decimal(26,6)
UID int(11)
ts timestamp
ModeofEntry varchar(1) latin1_swedish_ci