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)
FIC_CODEITEM longtext
FIC_PERCIBIDO bigint(20)
FIC_IMP01ACTIVO bigint(20)
FIC_IMP01PORCENT bigint(20)
FIC_IMP01EXENTO bigint(20)
FIC_IMP01MONTO double
FIC_IMP02ACTIVO bigint(20)
FIC_IMP02PORCENT bigint(20)
FIC_IMP02EXENTO bigint(20)
FIC_IMP02MONTO double
FIC_COSTOANTBOLIVARES double
FIC_COSTOACTBOLIVARES double
FIC_COSTOPROMEDIO double
FIC_COSTOANTEXTRANJERO double
FIC_COSTOACTEXTRANJERO double
FIC_COSTOPROMEDIOEXTRANJERO double
FIC_COSTOREFERENCIA double
FIC_P01PORCENTUTILIDAD bigint(20)
FIC_P01UTILIDAD double
FIC_P01PRECIOSINIMPUESTO double
FIC_P01IMTOIMPUESTO01 double
FIC_P01IMTOIMPUESTO02 double
FIC_P01IPRECIOTOTAL double
FIC_P01PORCENTUTILIDADEXT bigint(20)
FIC_P01UTILIDADEXT double
FIC_P01PRECIOTOTALEXT double
FIC_P01TIPOROUND bigint(20)
FIC_P02PORCENTUTILIDAD bigint(20)
FIC_P02UTILIDAD double
FIC_P02PRECIOSINIMPUESTO double
FIC_P02IMTOIMPUESTO01 double
FIC_P02IMTOIMPUESTO02 double
FIC_P02IPRECIOTOTAL double
FIC_P02PORCENTUTILIDADEXT bigint(20)
FIC_P02UTILIDADEXT double
FIC_P02PRECIOTOTALEXT double
FIC_P02TIPOROUND bigint(20)
FIC_P03PORCENTUTILIDAD bigint(20)
FIC_P03UTILIDAD double
FIC_P03PRECIOSINIMPUESTO double
FIC_P03IMTOIMPUESTO01 double
FIC_P03IMTOIMPUESTO02 double
FIC_P03IPRECIOTOTAL double
FIC_P03PORCENTUTILIDADEXT bigint(20)
FIC_P03UTILIDADEXT double
FIC_P03PRECIOTOTALEXT double
FIC_P03TIPOROUND bigint(20)
FIC_P04PORCENTUTILIDAD bigint(20)
FIC_P04UTILIDAD double
FIC_P04PRECIOSINIMPUESTO double
FIC_P04IMTOIMPUESTO01 double
FIC_P04IMTOIMPUESTO02 double
FIC_P04IPRECIOTOTAL double
FIC_P04PORCENTUTILIDADEXT bigint(20)
FIC_P04UTILIDADEXT double
FIC_P04PRECIOTOTALEXT double
FIC_P04TIPOROUND bigint(20)
FIC_P05PORCENTUTILIDAD bigint(20)
FIC_P05UTILIDAD double
FIC_P05PRECIOSINIMPUESTO double
FIC_P05IMTOIMPUESTO01 double
FIC_P05IMTOIMPUESTO02 double
FIC_P05IPRECIOTOTAL double
FIC_P05PORCENTUTILIDADEXT bigint(20)
FIC_P05UTILIDADEXT double
FIC_P05PRECIOTOTALEXT double
FIC_P05TIPOROUND bigint(20)
FIC_P06PORCENTUTILIDAD bigint(20)
FIC_P06UTILIDAD double
FIC_P06PRECIOSINIMPUESTO double
FIC_P06IMTOIMPUESTO01 double
FIC_P06IMTOIMPUESTO02 double
FIC_P06IPRECIOTOTAL double
FIC_P06PORCENTUTILIDADEXT bigint(20)
FIC_P06UTILIDADEXT double
FIC_P06PRECIOTOTALEXT double
FIC_P06TIPOROUND bigint(20)


Column Type Function Null Value
_recno int(11)
FIC_CODEITEM longtext
FIC_PERCIBIDO bigint(20)
FIC_IMP01ACTIVO bigint(20)
FIC_IMP01PORCENT bigint(20)
FIC_IMP01EXENTO bigint(20)
FIC_IMP01MONTO double
FIC_IMP02ACTIVO bigint(20)
FIC_IMP02PORCENT bigint(20)
FIC_IMP02EXENTO bigint(20)
FIC_IMP02MONTO double
FIC_COSTOANTBOLIVARES double
FIC_COSTOACTBOLIVARES double
FIC_COSTOPROMEDIO double
FIC_COSTOANTEXTRANJERO double
FIC_COSTOACTEXTRANJERO double
FIC_COSTOPROMEDIOEXTRANJERO double
FIC_COSTOREFERENCIA double
FIC_P01PORCENTUTILIDAD bigint(20)
FIC_P01UTILIDAD double
FIC_P01PRECIOSINIMPUESTO double
FIC_P01IMTOIMPUESTO01 double
FIC_P01IMTOIMPUESTO02 double
FIC_P01IPRECIOTOTAL double
FIC_P01PORCENTUTILIDADEXT bigint(20)
FIC_P01UTILIDADEXT double
FIC_P01PRECIOTOTALEXT double
FIC_P01TIPOROUND bigint(20)
FIC_P02PORCENTUTILIDAD bigint(20)
FIC_P02UTILIDAD double
FIC_P02PRECIOSINIMPUESTO double
FIC_P02IMTOIMPUESTO01 double
FIC_P02IMTOIMPUESTO02 double
FIC_P02IPRECIOTOTAL double
FIC_P02PORCENTUTILIDADEXT bigint(20)
FIC_P02UTILIDADEXT double
FIC_P02PRECIOTOTALEXT double
FIC_P02TIPOROUND bigint(20)
FIC_P03PORCENTUTILIDAD bigint(20)
FIC_P03UTILIDAD double
FIC_P03PRECIOSINIMPUESTO double
FIC_P03IMTOIMPUESTO01 double
FIC_P03IMTOIMPUESTO02 double
FIC_P03IPRECIOTOTAL double
FIC_P03PORCENTUTILIDADEXT bigint(20)
FIC_P03UTILIDADEXT double
FIC_P03PRECIOTOTALEXT double
FIC_P03TIPOROUND bigint(20)
FIC_P04PORCENTUTILIDAD bigint(20)
FIC_P04UTILIDAD double
FIC_P04PRECIOSINIMPUESTO double
FIC_P04IMTOIMPUESTO01 double
FIC_P04IMTOIMPUESTO02 double
FIC_P04IPRECIOTOTAL double
FIC_P04PORCENTUTILIDADEXT bigint(20)
FIC_P04UTILIDADEXT double
FIC_P04PRECIOTOTALEXT double
FIC_P04TIPOROUND bigint(20)
FIC_P05PORCENTUTILIDAD bigint(20)
FIC_P05UTILIDAD double
FIC_P05PRECIOSINIMPUESTO double
FIC_P05IMTOIMPUESTO01 double
FIC_P05IMTOIMPUESTO02 double
FIC_P05IPRECIOTOTAL double
FIC_P05PORCENTUTILIDADEXT bigint(20)
FIC_P05UTILIDADEXT double
FIC_P05PRECIOTOTALEXT double
FIC_P05TIPOROUND bigint(20)
FIC_P06PORCENTUTILIDAD bigint(20)
FIC_P06UTILIDAD double
FIC_P06PRECIOSINIMPUESTO double
FIC_P06IMTOIMPUESTO01 double
FIC_P06IMTOIMPUESTO02 double
FIC_P06IPRECIOTOTAL double
FIC_P06PORCENTUTILIDADEXT bigint(20)
FIC_P06UTILIDADEXT double
FIC_P06PRECIOTOTALEXT double
FIC_P06TIPOROUND bigint(20)

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

Continue insertion with rows