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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Edit mode
Customize edit mode.
Edit mode
Documentation Disallow BLOB and BINARY columns from editing. Restore default value
Documentation Display the function fields in edit/insert mode. Restore default value
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode. Restore default value
Documentation How many rows can be inserted at one time. Restore default value
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value. Restore default value
Documentation A dropdown will be used if fewer items are present. Restore default value
Text fields
Customize text input fields.
Text fields
Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Column Type Function Null Value
_recno int(11)
FCC_CODIGO longtext
FCC_FECHAEMISION longtext
FCC_CODIGOUNICO bigint(20)
FCC_CODAUTORIZADO longtext
FCC_DOCUMENTOAPARTADO longtext
FCC_NUMERO longtext
FCC_CODIGOUNICO2 bigint(20)
FCC_NUMERO2 longtext
FCC_TIPOTRANSACCION bigint(20)
FCC_TIPOOPERACION longtext
FCC_DESCRIPCIONMOV longtext
FCC_FECHAVENCIMIENTO longtext
FCC_FECHAPROXIMA longtext
FCC_MONTODOCUMENTO double
FCC_SALDODOCUMENTO double
FCC_SALDOMONEDAEXT double
FCC_ULTABONODCTO longtext
FCC_ULTABONOMTO double
FCC_ULTFECHAABONO longtext
FCC_IMPUESTOORG double
FCC_AFECTACOMISIONES bigint(20)
FCC_AFECTAVENTASMES bigint(20)
FCC_AFECTALIBROVENTAS bigint(20)
FCC_MTOCOMISION double
FCC_COSTOOPERACION double
FCC_ESPAGO bigint(20)
FCC_ESCHEQUE bigint(20)
FCC_NROVENDEDOR longtext
FCC_ESRETENCION bigint(20)
FCC_FLAGAUDITORIA bigint(20)
FCC_MONTORETENCION double
FCC_INCLUIRLIBROIVA bigint(20)
FCC_MONTOIVA double
FCC_CODERETENCION longtext
FCC_BASERETENCION double
FCC_BASEIMPONIBLE double
FCC_BASEIMPONIBLE2 double
FCC_MULTIPLERETENCION bigint(20)
FCC_MONTOMONEDAEXT double
FCC_FACTORCAMBIO double
FCC_IMPUESTO1 double
FCC_IMPUESTO1PORCENT bigint(20)
FCC_MTOIMPUESTO1 double
FCC_IMPUESTO2 double
FCC_IMPUESTO2PORCENT bigint(20)
FCC_MTOIMPUESTO2 double
FCC_ESCHEQUEDEVUELTO bigint(20)
FCC_VIENEDE bigint(20)
FCC_FORMAPAGO longtext
FCC_MONTOPAGOADELANTADO double
FCC_DEPOSITADO bigint(20)
FCC_USUARIO bigint(20)
FCC_DOCUMENTOORIGEN longtext
FCC_DOCUMENTOAFECTADO longtext
FCC_MONEDA bigint(20)
FCC_FECHARECEPCION longtext
FCC_MARKPERIODO bigint(20)
FCC_PAGOORIGINAL double
FCC_CONVERTED bigint(20)
FCC_ULTFECHAMORA longtext
FCC_ULTFECHADESCUENTO longtext
BASE_AUTOINCREMENT bigint(20)
FCC_CONTROL longtext
FCC_DESCRIPCION longtext
FCC_NIT longtext
FCC_RIF longtext
FCC_TELEFONO longtext
FCC_DIRECCION longtext
FCC_NUMERORETENCION longtext
FCC_HORAEMISION longtext
FCC_SERIE longtext
FCC_CTOCOSTO longtext
FCC_SUSTRAENDO double
FCC_REFERENCIA longtext
FCC_FECHAPAGO longtext
FCC_ENTERADO bigint(20)
FCC_VTANAPAGO bigint(20)


Column Type Function Null Value
_recno int(11)
FCC_CODIGO longtext
FCC_FECHAEMISION longtext
FCC_CODIGOUNICO bigint(20)
FCC_CODAUTORIZADO longtext
FCC_DOCUMENTOAPARTADO longtext
FCC_NUMERO longtext
FCC_CODIGOUNICO2 bigint(20)
FCC_NUMERO2 longtext
FCC_TIPOTRANSACCION bigint(20)
FCC_TIPOOPERACION longtext
FCC_DESCRIPCIONMOV longtext
FCC_FECHAVENCIMIENTO longtext
FCC_FECHAPROXIMA longtext
FCC_MONTODOCUMENTO double
FCC_SALDODOCUMENTO double
FCC_SALDOMONEDAEXT double
FCC_ULTABONODCTO longtext
FCC_ULTABONOMTO double
FCC_ULTFECHAABONO longtext
FCC_IMPUESTOORG double
FCC_AFECTACOMISIONES bigint(20)
FCC_AFECTAVENTASMES bigint(20)
FCC_AFECTALIBROVENTAS bigint(20)
FCC_MTOCOMISION double
FCC_COSTOOPERACION double
FCC_ESPAGO bigint(20)
FCC_ESCHEQUE bigint(20)
FCC_NROVENDEDOR longtext
FCC_ESRETENCION bigint(20)
FCC_FLAGAUDITORIA bigint(20)
FCC_MONTORETENCION double
FCC_INCLUIRLIBROIVA bigint(20)
FCC_MONTOIVA double
FCC_CODERETENCION longtext
FCC_BASERETENCION double
FCC_BASEIMPONIBLE double
FCC_BASEIMPONIBLE2 double
FCC_MULTIPLERETENCION bigint(20)
FCC_MONTOMONEDAEXT double
FCC_FACTORCAMBIO double
FCC_IMPUESTO1 double
FCC_IMPUESTO1PORCENT bigint(20)
FCC_MTOIMPUESTO1 double
FCC_IMPUESTO2 double
FCC_IMPUESTO2PORCENT bigint(20)
FCC_MTOIMPUESTO2 double
FCC_ESCHEQUEDEVUELTO bigint(20)
FCC_VIENEDE bigint(20)
FCC_FORMAPAGO longtext
FCC_MONTOPAGOADELANTADO double
FCC_DEPOSITADO bigint(20)
FCC_USUARIO bigint(20)
FCC_DOCUMENTOORIGEN longtext
FCC_DOCUMENTOAFECTADO longtext
FCC_MONEDA bigint(20)
FCC_FECHARECEPCION longtext
FCC_MARKPERIODO bigint(20)
FCC_PAGOORIGINAL double
FCC_CONVERTED bigint(20)
FCC_ULTFECHAMORA longtext
FCC_ULTFECHADESCUENTO longtext
BASE_AUTOINCREMENT bigint(20)
FCC_CONTROL longtext
FCC_DESCRIPCION longtext
FCC_NIT longtext
FCC_RIF longtext
FCC_TELEFONO longtext
FCC_DIRECCION longtext
FCC_NUMERORETENCION longtext
FCC_HORAEMISION longtext
FCC_SERIE longtext
FCC_CTOCOSTO longtext
FCC_SUSTRAENDO double
FCC_REFERENCIA longtext
FCC_FECHAPAGO longtext
FCC_ENTERADO bigint(20)
FCC_VTANAPAGO bigint(20)

and then
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.

Continue insertion with rows