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 bigint(20)
idaperturacaja int(11)
tipo_factura varchar(10) utf8_general_ci
var_conseg varchar(10) utf8_general_ci
numero int(11)
fecha_factura date
horafactura time
fecha_vencimiento date
idtbordenpedido varchar(256) utf8_general_ci
cliente_id bigint(20)
estado varchar(20) utf8_general_ci
credito varchar(100) utf8_general_ci
subtotal decimal(10,2)
dto decimal(10,2)
gastos_envio decimal(10,2)
CodImp1 varchar(10) utf8_general_ci
CodImp2 varchar(10) utf8_general_ci
CodImp3 varchar(10) utf8_general_ci
CodImp4 varchar(10) utf8_general_ci
porciento2 decimal(4,2)
porciento3 decimal(4,2)
porciento4 decimal(4,2)
ValImp2 decimal(10,2)
ValImp3 decimal(10,2)
ValImp4 decimal(10,2)
iva decimal(10,2)
anticipo decimal(10,2)
propina decimal(10,2)
total decimal(14,2)
met_pago varchar(10) utf8_general_ci
anulada tinyint(4)
obs text utf8_general_ci
codQR varchar(256) utf8_general_ci
impresion varchar(10) utf8_general_ci
pagorecibido decimal(10,2)
pagorecibidootro decimal(10,2)
cambio decimal(10,2)
mesa int(11)
camarero int(11)
tiempo int(11)
user varchar(30) utf8_general_ci
nota text utf8_general_ci
cotizacion int(11)
estadopre int(11)
remision int(11)
facContingencia varchar(10) utf8_general_ci
moneda int(11)
resolucion int(11)