| _recno |
int(11)
|
|
|
|
| FI_CODIGO |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_DESCRIPCION |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_CATEGORIA |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_DESCRIPCIONDETALLADA |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_VENDEDOR |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_STATUS |
bigint(20)
|
|
|
|
| FI_UNIDAD |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_TIPOCODIGOBARRA |
bigint(20)
|
|
|
|
| FI_IMAGEN |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_SUSTITUTO1 |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_SUSTITUTO2 |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_SUSTITUTO3 |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_REFERENCIA |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_MARCA |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_MONEDA |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_FACTORCONVERSION |
double
|
|
|
|
| FI_UNDEXISTENCIA2 |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_PUESTO |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_SUJETOACOMISION |
bigint(20)
|
|
|
|
| FI_MONTOCOMISION |
double
|
|
|
|
| FI_CUENTASCONTABLES |
bigint(20)
|
|
|
|
| FI_PESOPRODUCTO |
double
|
|
|
|
| FI_DIASDEREPOSICION |
bigint(20)
|
|
|
|
| FI_PRESENTACION |
bigint(20)
|
|
|
|
| FI_GARANTIA |
bigint(20)
|
|
|
|
| FI_SUSTITUTO4 |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_SUSTITUTO5 |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_MONTOCOMISIONP |
bigint(20)
|
|
|
|
| FI_DEPOSITOS |
bigint(20)
|
|
|
|
| FI_OFERTAS |
bigint(20)
|
|
|
|
| FI_VENCIMIENTOS |
bigint(20)
|
|
|
|
| FI_CLASIFICACION |
bigint(20)
|
|
|
|
| FI_MANEJOINVENTARIO |
bigint(20)
|
|
|
|
| FI_SERIALES |
bigint(20)
|
|
|
|
| FI_CREACION |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_INVENTARIOINICIALUNIDADES |
double
|
|
|
|
| FI_INVENTARIOINICIALCOSTO |
double
|
|
|
|
| FI_CAPACIDAD |
double
|
|
|
|
| FI_EXISTDECIMAL |
bigint(20)
|
|
|
|
| FI_COMPUESTOSERIALES |
bigint(20)
|
|
|
|
| FI_VENDEDORFIJO |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_VENDEDORFIJOACTIVO |
bigint(20)
|
|
|
|
| FI_MODELO |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_SUBCATEGORIA |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_PESOAFECTACOSTO |
bigint(20)
|
|
|
|
| FI_IMPRESORA |
longtext
|
utf8mb4_general_ci
|
|
|
| BASE_AUTOINCREMENT |
bigint(20)
|
|
|
|
| FI_ZEXTRA1 |
double
|
|
|
|
| FI_ZEXTRA2 |
double
|
|
|
|
| FI_ZEXTRA3 |
double
|
|
|
|
| FI_ZEXTRA4 |
double
|
|
|
|
| FI_ZEXTRA5 |
double
|
|
|
|
| FI_ZEXTRA6 |
double
|
|
|
|
| FI_ZEXTRA1VENTA |
bigint(20)
|
|
|
|
| FI_ZEXTRA2VENTA |
bigint(20)
|
|
|
|
| FI_ZEXTRA3VENTA |
bigint(20)
|
|
|
|
| FI_ZEXTRA4VENTA |
bigint(20)
|
|
|
|
| FI_ZEXTRA5VENTA |
bigint(20)
|
|
|
|
| FI_ZEXTRA6VENTA |
bigint(20)
|
|
|
|
| FI_ZEXTRA1VENTAMOD |
bigint(20)
|
|
|
|
| FI_ZEXTRA2VENTAMOD |
bigint(20)
|
|
|
|
| FI_ZEXTRA3VENTAMOD |
bigint(20)
|
|
|
|
| FI_ZEXTRA4VENTAMOD |
bigint(20)
|
|
|
|
| FI_ZEXTRA5VENTAMOD |
bigint(20)
|
|
|
|
| FI_ZEXTRA6VENTAMOD |
bigint(20)
|
|
|
|
| FI_INTERNET |
bigint(20)
|
|
|
|
| FI_BALANZA |
bigint(20)
|
|
|
|
| FI_CODIGOBARRA |
bigint(20)
|
|
|
|
| FI_PRECIOLISTA |
bigint(20)
|
|
|
|
| FI_APROVECHAPORC |
double
|
|
|
|
| FI_ARANCEL |
longtext
|
utf8mb4_general_ci
|
|
|
| FI_POSENTREGA |
bigint(20)
|
|
|
|