Recent
`admingregz_db`.`soperacioninv`
`phpmyadmin`.`pma__savedsearches`
`mysql`.`time_zone`
`phpmyadmin`.`pma__table_coords`
`mysql`.`time_zone_leap_second`
`admingregz_db`.`sconvenios`
`mysql`.`gtid_slave_pos`
`admingregz_db`.`scuentasxpagar`
`admingregz_db`.`scajamayor`
`mysql`.`time_zone_name`
Favorites
There are no favorite tables.
New
admingregz_db
information_schema
mysql
nominagregz_db
performance_schema
phpmyadmin
stockmap_db
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: admingregz_db
Table: soperacioninv
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Tracking
Triggers
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Table structure
Table structure
Settings for the table structure (list of columns).
Table structure
Hide table structure actions
Whether the table structure actions should be hidden.
Show column comments
Whether column comments should be shown in table structure view
Default transformations
Default transformations for Hex
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
2
Default transformations for Substring
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 all …
Default transformations for Bool2Text
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
T F
Default transformations for External
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 local
Default transformations for Inline
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 100
Default transformations for TextImageLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 50
Default transformations for TextLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Table structure
Relation view
soperacioninv
#
Name
Type
Collation
Attributes
Null
Default
Comments
Extra
Action
1
_recno
int(11)
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
2
FTI_AUTOINCREMENT
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
3
FTI_DOCUMENTO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
4
FTI_TIPO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
5
FTI_STATUS
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
6
FTI_VISIBLE
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
7
FTI_FECHAEMISION
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
8
FTI_DEPOSITOSOURCE
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
9
FTI_DEPOSITODESTINO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
10
FTI_TOTALITEMS
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
11
FTI_TOTALITEMSINICIAL
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
12
FTI_MONEDA
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
13
FTI_FACTORCAMBIO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
14
FTI_TOTALCOSTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
15
FTI_TOTALCOSTOREAL
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
16
FTI_CLASIFICACION
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
17
FTI_DESCRIPCLASIFY
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
18
FTI_USER
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
19
FTI_AUTORIZADOPOR
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
20
FTI_PROPOSITO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
21
FTI_RESPONSABLE
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
22
FTI_DETALLE
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
23
FTI_TIENELOTES
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
24
FTI_UPDATEITEMS
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
25
FTI_TOTALBRUTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
26
FTI_DESCUENTO1PORCENT
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
27
FTI_DESCUENTO1MONTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
28
FTI_DESCUENTO1ORIGEN
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
29
FTI_DESCUENTO2PORCENT
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
30
FTI_DESCUENTO2MONTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
31
FTI_DESCUENTO2ORIGEN
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
32
FTI_DESCUENTOPARCIAL
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
33
FTI_FLETEPORCENT
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
34
FTI_FLETEMONEDA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
35
FTI_FLETEORIGEN
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
36
FTI_BASEIMPONIBLE
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
37
FTI_BASEIMPONIBLE2
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
38
FTI_IMPUESTO1PORCENT
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
39
FTI_IMPUESTO1MONTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
40
FTI_IMPUESTO2PORCENT
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
41
FTI_IMPUESTO2MONTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
42
FTI_DESCUENTOCUADRE
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
43
FTI_TOTALNETO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
44
FTI_FECHAVENCIDO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
45
FTI_DIASVENCIMIENTO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
46
FTI_RIFCLIENTE
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
47
FTI_NITCLIENTE
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
48
FTI_PERSONACONTACTO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
49
FTI_TELEFONOCONTACTO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
50
FTI_DIRECCIONDESPACHO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
51
FTI_DETALLECOMENTARIO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
52
FTI_ORDENCOMPRA
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
53
FTI_PLANILLAIMPORTACION
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
54
FTI_EXISTEPLANILLAIMPORTACION
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
55
FTI_PORCENTFLETESINASIGNAR
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
56
FTI_SALDOOPERACION
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
57
FTI_MONEDAPAGO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
58
FTI_FORMADEPAGO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
59
FTI_TOTALPRECIO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
60
FTI_VUELTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
61
FTI_AUTORIZADOS
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
62
FTI_EXCENTO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
63
FTI_COSTODEVENTA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
64
FTI_TIPOOPERACIONORIGEN
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
65
FTI_DOCUMENTOORIGEN
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
66
FTI_FROMCOMPUESTOS
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
67
FTI_VENDEDORASIGNADO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
68
FTI_ZONAVENTA
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
69
FTI_PENDINGFORPRINT
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
70
FTI_COBRADORASIGNADO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
71
FTI_COMISIONCOBROS
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
72
FTI_COMISIONCOBROSBLOQUEADA
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
73
FTI_FACTURASLOTERANDOM
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
74
FTI_MULTIPLEVENDEDOR
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
75
FTI_MULTIPLEDEPOSITO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
76
FTI_TIMESAVED
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
77
FTI_TIPOPRECIO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
78
BASE_AUTOINCREMENT
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
79
FTI_SERIE
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
80
FTI_NAMEFORMATO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
81
FTI_MACHINENAME
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
82
FTI_COMISIONVENTA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
83
FTI_MONTOPAGADO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
84
FTI_MONTOPERIODO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
85
FTI_PORCENTPERIODO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
86
FTI_HORA
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
87
FTI_GUIADESPACHO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
88
FTI_NORECIBOCAJA
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
89
FTI_CTOCOSTO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
90
FTI_COSTOACTUALNACIONAL
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
91
FTI_COSTOACTUALEX
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
92
FTI_PREFIXINVENTARIO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
93
FTI_NUMEROCONTROL
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
94
FTI_COSTOAJUSTADO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
95
FTI_FACTORREFERENCIA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
96
FTI_FACTORREFERENCIA2
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
97
FTI_FINICIAL
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
98
FTI_FINTERESES
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
99
FTI_FINTERESESP
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
100
FTI_FMANEJO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
101
FTI_FMANEJOP
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
102
FTI_FEXTRAORDINARIA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
103
FTI_FCTDEXTRAORDINARIA
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
104
FTI_FINTEXTRAORDINARIA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
105
FTI_FMTOCUOTA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
106
FTI_FCTDCUOTA
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
107
FTI_FCOBRANZA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
108
FTI_TOTALFINANCIADO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
109
FTI_DETALLEGIROS
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
110
FTI_SALDOFINANCIAR
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
111
FTI_PRIMERACUOTA
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
112
FTI_CAPITALCUOTAEXTRA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
113
FTI_CREDICARD
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
114
FTI_MAQUINAFISCAL
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
115
FTI_TOTALPAGINAS
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
116
FTI_SUCURSALORIGEN
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
117
FTI_FECHALIBRO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
118
FTI_IVAINTERESES
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
119
FTI_REIMPRESAFISCAL
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
120
FTI_DCTOFISCALORIGEN
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
121
FTI_FECHAFACTURA
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
122
FTI_DCTOIVA
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
123
FTI_MONEDACAMBIO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
124
FTI_TIPOFACTORCAMBIO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
125
FTI_ORIGENCAMBIO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
126
FTI_FACTORVUELTO
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
127
FTI_CODECAMBIO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
128
FTI_VUELTOORG
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
129
FTI_VTANAPAGO
bigint(20)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
130
FTI_MULTIVUELTO
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
131
FTI_EXTRAFIELD01
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
132
FTI_EXTRAFIELD02
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
133
FTI_EXTRAFIELD03
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
134
FTI_EXTRAFIELD04
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
135
FTI_EXTRAFIELD05
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
136
FTI_BASEIGTF
double
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
Check all
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Add to central columns
Remove from central columns
Move columns
Move the columns by dragging them up and down.
Preview SQL
Loading…
Error
Print
Propose table structure
Track table
Move columns
Normalize
Add
column(s)
at beginning of table
after _recno
after FTI_AUTOINCREMENT
after FTI_DOCUMENTO
after FTI_TIPO
after FTI_STATUS
after FTI_VISIBLE
after FTI_FECHAEMISION
after FTI_DEPOSITOSOURCE
after FTI_DEPOSITODESTINO
after FTI_TOTALITEMS
after FTI_TOTALITEMSINICIAL
after FTI_MONEDA
after FTI_FACTORCAMBIO
after FTI_TOTALCOSTO
after FTI_TOTALCOSTOREAL
after FTI_CLASIFICACION
after FTI_DESCRIPCLASIFY
after FTI_USER
after FTI_AUTORIZADOPOR
after FTI_PROPOSITO
after FTI_RESPONSABLE
after FTI_DETALLE
after FTI_TIENELOTES
after FTI_UPDATEITEMS
after FTI_TOTALBRUTO
after FTI_DESCUENTO1PORCENT
after FTI_DESCUENTO1MONTO
after FTI_DESCUENTO1ORIGEN
after FTI_DESCUENTO2PORCENT
after FTI_DESCUENTO2MONTO
after FTI_DESCUENTO2ORIGEN
after FTI_DESCUENTOPARCIAL
after FTI_FLETEPORCENT
after FTI_FLETEMONEDA
after FTI_FLETEORIGEN
after FTI_BASEIMPONIBLE
after FTI_BASEIMPONIBLE2
after FTI_IMPUESTO1PORCENT
after FTI_IMPUESTO1MONTO
after FTI_IMPUESTO2PORCENT
after FTI_IMPUESTO2MONTO
after FTI_DESCUENTOCUADRE
after FTI_TOTALNETO
after FTI_FECHAVENCIDO
after FTI_DIASVENCIMIENTO
after FTI_RIFCLIENTE
after FTI_NITCLIENTE
after FTI_PERSONACONTACTO
after FTI_TELEFONOCONTACTO
after FTI_DIRECCIONDESPACHO
after FTI_DETALLECOMENTARIO
after FTI_ORDENCOMPRA
after FTI_PLANILLAIMPORTACION
after FTI_EXISTEPLANILLAIMPORTACION
after FTI_PORCENTFLETESINASIGNAR
after FTI_SALDOOPERACION
after FTI_MONEDAPAGO
after FTI_FORMADEPAGO
after FTI_TOTALPRECIO
after FTI_VUELTO
after FTI_AUTORIZADOS
after FTI_EXCENTO
after FTI_COSTODEVENTA
after FTI_TIPOOPERACIONORIGEN
after FTI_DOCUMENTOORIGEN
after FTI_FROMCOMPUESTOS
after FTI_VENDEDORASIGNADO
after FTI_ZONAVENTA
after FTI_PENDINGFORPRINT
after FTI_COBRADORASIGNADO
after FTI_COMISIONCOBROS
after FTI_COMISIONCOBROSBLOQUEADA
after FTI_FACTURASLOTERANDOM
after FTI_MULTIPLEVENDEDOR
after FTI_MULTIPLEDEPOSITO
after FTI_TIMESAVED
after FTI_TIPOPRECIO
after BASE_AUTOINCREMENT
after FTI_SERIE
after FTI_NAMEFORMATO
after FTI_MACHINENAME
after FTI_COMISIONVENTA
after FTI_MONTOPAGADO
after FTI_MONTOPERIODO
after FTI_PORCENTPERIODO
after FTI_HORA
after FTI_GUIADESPACHO
after FTI_NORECIBOCAJA
after FTI_CTOCOSTO
after FTI_COSTOACTUALNACIONAL
after FTI_COSTOACTUALEX
after FTI_PREFIXINVENTARIO
after FTI_NUMEROCONTROL
after FTI_COSTOAJUSTADO
after FTI_FACTORREFERENCIA
after FTI_FACTORREFERENCIA2
after FTI_FINICIAL
after FTI_FINTERESES
after FTI_FINTERESESP
after FTI_FMANEJO
after FTI_FMANEJOP
after FTI_FEXTRAORDINARIA
after FTI_FCTDEXTRAORDINARIA
after FTI_FINTEXTRAORDINARIA
after FTI_FMTOCUOTA
after FTI_FCTDCUOTA
after FTI_FCOBRANZA
after FTI_TOTALFINANCIADO
after FTI_DETALLEGIROS
after FTI_SALDOFINANCIAR
after FTI_PRIMERACUOTA
after FTI_CAPITALCUOTAEXTRA
after FTI_CREDICARD
after FTI_MAQUINAFISCAL
after FTI_TOTALPAGINAS
after FTI_SUCURSALORIGEN
after FTI_FECHALIBRO
after FTI_IVAINTERESES
after FTI_REIMPRESAFISCAL
after FTI_DCTOFISCALORIGEN
after FTI_FECHAFACTURA
after FTI_DCTOIVA
after FTI_MONEDACAMBIO
after FTI_TIPOFACTORCAMBIO
after FTI_ORIGENCAMBIO
after FTI_FACTORVUELTO
after FTI_CODECAMBIO
after FTI_VUELTOORG
after FTI_VTANAPAGO
after FTI_MULTIVUELTO
after FTI_EXTRAFIELD01
after FTI_EXTRAFIELD02
after FTI_EXTRAFIELD03
after FTI_EXTRAFIELD04
after FTI_EXTRAFIELD05
after FTI_BASEIGTF
Indexes
Loading
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Rename
Drop
PRIMARY
BTREE
Yes
No
_recno
3494
A
No
Create an index on
columns
Loading
Preview SQL
Loading…
Partitions
No partitioning defined!
Information
Space usage
Data
3.5
MiB
Index
0
B
Overhead
4.0
MiB
Effective
-507,904
B
Total
3.5
MiB
Optimize table
Row statistics
Format
dynamic
Collation
utf8mb4_general_ci
Next autoindex
0
Creation
Nov 19, 2026 at 03:02 PM
Last update
Nov 19, 2026 at 03:02 PM
Last check
Nov 19, 2026 at 10:17 PM