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
codigo char(12) utf8mb3_bin
totaleuros decimal(15,7)
hora time
direccion char(100) utf8mb3_bin
codpago char(10) utf8mb3_bin
tasaconv decimal(14,8)
codejercicio char(4) utf8mb3_bin
totalivaportes decimal(9,7)
total decimal(15,7)
tpv tinyint(1)
pordtoesp decimal(10,7)
idasiento int
automatica tinyint(1)
irpf decimal(10,7)
nombrecliente char(100) utf8mb3_bin
idfactura int
ivaportes decimal(9,7)
observaciones mediumtext utf8mb3_bin
porcomision decimal(10,7)
codcliente char(6) utf8mb3_bin
codpais char(20) utf8mb3_bin
deabono tinyint(1)
editable tinyint(1)
codalmacen char(4) utf8mb3_bin
coddir int
cifnif char(20) utf8mb3_bin
nogenerarasiento tinyint(1)
codliquidacion char(10) utf8mb3_bin
idfacturarect int
netosindtoesp decimal(15,7)
provincia char(100) utf8mb3_bin
codimpuestoportes char(10) utf8mb3_bin
codigorect char(12) utf8mb3_bin
totalrecargo decimal(17,7)
totalportes decimal(15,7)
codagente char(10) utf8mb3_bin
recfinanciero decimal(10,7)
totalreportes decimal(9,7)
dtoesp decimal(15,7)
fecha date
idpagodevol int
neto decimal(15,7)
nomodelo347 tinyint(1)
reportes decimal(9,7)
totalirpf decimal(15,7)
apartado char(10) utf8mb3_bin
codserie char(2) utf8mb3_bin
codpostal char(10) utf8mb3_bin
netoportes decimal(15,7)
idprovincia int
totaliva decimal(15,7)
excluir303 tinyint(1)
ciudad char(100) utf8mb3_bin
numero char(12) utf8mb3_bin
coddivisa char(3) utf8mb3_bin