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)
CVDate date
CVNUM varchar(20) utf8_general_ci
APVNUM varchar(255) utf8_general_ci
APVDATE date
APV_GUID varchar(50) utf8_general_ci
SUPID int(11)
VendorName varchar(255) utf8_general_ci
Address varchar(255) utf8_general_ci
PAYEEID int(11)
CHKDATE date
CHKNUM varchar(25) utf8_general_ci
GUID varchar(50) utf8_general_ci
BankName varchar(255) utf8_general_ci
Bank int(11)
BankAMT decimal(26,6)
APVAMT decimal(26,6)
TITLEID int(2)
PRJID int(2)
JID int(11)
PREPAREDBY int(11)
REVIEWBY int(11)
AUTHORIZEDBY int(11)
PMTSTAT varchar(25) utf8_general_ci
STATUS varchar(50) utf8_general_ci
CheckEntryStat varchar(25) utf8_general_ci
ReleasedStat varchar(25) utf8_general_ci
Remarks varchar(255) utf8_general_ci
Types varchar(50) utf8_general_ci
Date1 date
Date2 date
WTAXACID int(11)
IsBank varchar(10) utf8_general_ci