| _recno |
int(11)
|
|
|
|
| DUMMYKEY |
longtext
|
utf8mb4_general_ci
|
|
|
| NO_APARTADO |
bigint(20)
|
|
|
|
| NO_FACTURA |
bigint(20)
|
|
|
|
| NO_FACTURALOTE |
bigint(20)
|
|
|
|
| NO_PRESUPUESTO |
bigint(20)
|
|
|
|
| NO_NOTAENTREGA |
bigint(20)
|
|
|
|
| NO_PEDIDO |
bigint(20)
|
|
|
|
| NO_DEVOLUCION |
bigint(20)
|
|
|
|
| NO_TRANSFERENCIAS |
bigint(20)
|
|
|
|
| NO_CARGOS |
bigint(20)
|
|
|
|
| NO_DESCARGOS |
bigint(20)
|
|
|
|
| NO_AJUSTESINV |
bigint(20)
|
|
|
|
| NO_RECIBOCAJA |
bigint(20)
|
|
|
|
| NO_PLANILLA |
bigint(20)
|
|
|
|
| NO_NOTASCREDITO |
bigint(20)
|
|
|
|
| NO_NOTASDEBITO |
bigint(20)
|
|
|
|
| NO_NOTASCREDITOPROV |
bigint(20)
|
|
|
|
| NO_NOTASDEBITOPROV |
bigint(20)
|
|
|
|
| NO_CONSTANCIARETENCION |
bigint(20)
|
|
|
|
| NO_REQUISICION |
bigint(20)
|
|
|
|
| NO_SOLCOTIZA |
bigint(20)
|
|
|
|
| NO_ORDENCOMPRA |
bigint(20)
|
|
|
|
| NO_COMPRAS |
bigint(20)
|
|
|
|
| NO_DEVOLUCIONCOMPRA |
bigint(20)
|
|
|
|
| NO_NOTAENTREGAPROV |
bigint(20)
|
|
|
|
| NO_PRXSERIALIZACION |
bigint(20)
|
|
|
|
| MESES_PRESUPUESTOS |
bigint(20)
|
|
|
|
| MESES_PEDIDOS |
bigint(20)
|
|
|
|
| MESES_ORDENESCOMPRA |
bigint(20)
|
|
|
|
| IMPUESTO1 |
longtext
|
utf8mb4_general_ci
|
|
|
| IMPUESTO2 |
longtext
|
utf8mb4_general_ci
|
|
|
| MTO_IMPUESTO1 |
double
|
|
|
|
| MTO_IMPUESTO2 |
double
|
|
|
|
| ACTIVAR_IMPUESTO1 |
bigint(20)
|
|
|
|
| ACTIVAR_IMPUESTO2 |
bigint(20)
|
|
|
|
| SERIALES_POSTVENTA |
bigint(20)
|
|
|
|
| SUMARFLETEIMP1VENTAS |
bigint(20)
|
|
|
|
| SUMARFLETEIMP2VENTAS |
bigint(20)
|
|
|
|
| SUMARFLETEIMP1COMPRAS |
bigint(20)
|
|
|
|
| SUMARFLETEIMP2COMPRAS |
bigint(20)
|
|
|
|
| UTILIZARCTMOSVENTAS |
bigint(20)
|
|
|
|
| TIEMPOCHEQUEUSUARIOS |
bigint(20)
|
|
|
|
| TIEMPOINACTIVOAPLICACION |
bigint(20)
|
|
|
|
| BLOQUEODEUSUARIOS |
bigint(20)
|
|
|
|
| APARIENCIA3D |
bigint(20)
|
|
|
|
| LONGITUDPASSWORD |
bigint(20)
|
|
|
|
| PORCPRONTOPAGO |
double
|
|
|
|
| DIASPRONTOPAGO |
bigint(20)
|
|
|
|
| DECIMALESXDEFECTO |
bigint(20)
|
|
|
|
| SERIALES_POSTCOMPRA |
bigint(20)
|
|
|
|
| UTILIZARCTMOSCOMPRAS |
bigint(20)
|
|
|
|
| REDONDEOVENTAS |
longtext
|
utf8mb4_general_ci
|
|
|
| REDONDEOCOMPRAS |
longtext
|
utf8mb4_general_ci
|
|
|
| MONEDA_DEFECTO |
longtext
|
utf8mb4_general_ci
|
|
|
| ACTIVAR_SOMBRA |
bigint(20)
|
|
|
|
| NOMBRE_PRECIO1 |
longtext
|
utf8mb4_general_ci
|
|
|
| NOMBRE_PRECIO2 |
longtext
|
utf8mb4_general_ci
|
|
|
| NOMBRE_PRECIO3 |
longtext
|
utf8mb4_general_ci
|
|
|
| NOMBRE_PRECIO4 |
longtext
|
utf8mb4_general_ci
|
|
|
| NOMBRE_PRECIO5 |
longtext
|
utf8mb4_general_ci
|
|
|
| NOMBRE_PRECIO6 |
longtext
|
utf8mb4_general_ci
|
|
|
| MTO_IMPUESTO1P |
bigint(20)
|
|
|
|
| MTO_IMPUESTO2P |
bigint(20)
|
|
|
|
| PORCPRONTOPAGOP |
bigint(20)
|
|
|
|
| AUTOCODECATEGORIA |
bigint(20)
|
|
|
|
| FILLCODECATEGORIA |
bigint(20)
|
|
|
|
| AUTOCODEINVENTARIO |
bigint(20)
|
|
|
|
| FILLCODEINVENTARIO |
bigint(20)
|
|
|
|
| AUTOCODEZONA |
bigint(20)
|
|
|
|
| FILLCODEZONA |
bigint(20)
|
|
|
|
| AUTOCODECLIENTE |
bigint(20)
|
|
|
|
| FILLCODECLIENTE |
bigint(20)
|
|
|
|
| AUTOCODEVENDEDOR |
bigint(20)
|
|
|
|
| FILLCODEVENDEDOR |
bigint(20)
|
|
|
|
| AUTOCODEPROVEEDOR |
bigint(20)
|
|
|
|
| FILLCODEPROVEEDOR |
bigint(20)
|
|
|
|
| AUTOCODECONCEPTO |
bigint(20)
|
|
|
|
| FILLCODECONCEPTO |
bigint(20)
|
|
|
|
| AUTOCODEBENEFICIARIO |
bigint(20)
|
|
|
|
| FILLCODEBENEFICIARIO |
bigint(20)
|
|
|
|
| PRXCODECATEGORIA |
double
|
|
|
|
| PRXCODEINVENTARIO |
double
|
|
|
|
| PRXCODEZONAS |
double
|
|
|
|
| PRXCODECLIENTE |
double
|
|
|
|
| PRXCODEVENDEDOR |
double
|
|
|
|
| PRXCODEPROVEEDOR |
double
|
|
|
|
| PRXCODECONCEPTO |
double
|
|
|
|
| PRXCODEBENEFICIARIO |
double
|
|
|
|
| DESCUENTOPRONTOPAGO |
longtext
|
utf8mb4_general_ci
|
|
|
| INTERESMORA |
double
|
|
|
|
| KEYAPARTADO |
longtext
|
utf8mb4_general_ci
|
|
|
| IDENTIDADFISCAL1 |
longtext
|
utf8mb4_general_ci
|
|
|
| IDENTIDADFISCAL2 |
longtext
|
utf8mb4_general_ci
|
|
|
| COMISIONVENTASAFTERCANCEL |
bigint(20)
|
|
|
|
| FECHA_INICIOPERIODO |
longtext
|
utf8mb4_general_ci
|
|
|
| FECHA_FINALPERIODO |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMEPERIODO |
longtext
|
utf8mb4_general_ci
|
|
|
| DESCRIPCIONPERIODOS |
longtext
|
utf8mb4_general_ci
|
|
|
| ESTADANO2000 |
longtext
|
utf8mb4_general_ci
|
|
|
| ESTADANO1999 |
longtext
|
utf8mb4_general_ci
|
|
|
| ESTADANO1998 |
longtext
|
utf8mb4_general_ci
|
|
|
| FECHA_ULTIMAFACTURA |
longtext
|
utf8mb4_general_ci
|
|
|
| MONTO_ULTIMAFACTURA |
double
|
|
|
|
| CANTIDAD_ULTIMAFACTURA |
double
|
|
|
|
| AJUSTEDETALLADO |
bigint(20)
|
|
|
|
| IMP_DEBITOBANCARIO |
double
|
|
|
|
| UTILIDADENPORCENTAJE |
bigint(20)
|
|
|
|
| CERRARCUENTASXCOBRAR |
bigint(20)
|
|
|
|
| CERRARCUENTASXPAGAR |
bigint(20)
|
|
|
|
| MESES_HISTORICO |
bigint(20)
|
|
|
|
| NAMEAUTORIZADOS |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMEMATRICES |
longtext
|
utf8mb4_general_ci
|
|
|
| NO_COMPROBANTEEGRESO |
bigint(20)
|
|
|
|
| NO_COMPROBANTEDEBITO |
bigint(20)
|
|
|
|
| NO_COMPROBANTEDEPOSITO |
bigint(20)
|
|
|
|
| NO_COMPROBANTECREDITO |
bigint(20)
|
|
|
|
| DIASDIF_MISMOBANCO |
bigint(20)
|
|
|
|
| DIASDIF_OTROSBANCOS |
bigint(20)
|
|
|
|
| DIASDIF_FUERAPLAZA |
bigint(20)
|
|
|
|
| VERSION_UPDATE |
double
|
|
|
|
| NAMEFLETEVENTA |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMEFLETECOMPRA |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMEGIROS |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMECOMISION |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMECLASIFICACION |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMEPESO |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMEEXISTENCIA |
longtext
|
utf8mb4_general_ci
|
|
|
| MONTOFLETEDEFECTO |
double
|
|
|
|
| SERIECREADAPOR |
longtext
|
utf8mb4_general_ci
|
|
|
| TIPOSERIE |
bigint(20)
|
|
|
|
| NO_ORDENSERVICIO |
bigint(20)
|
|
|
|
| NO_GUIADESPACHO |
bigint(20)
|
|
|
|
| SERIALESUNICOS |
bigint(20)
|
|
|
|
| SERIALESXDEPOSITO |
bigint(20)
|
|
|
|
| NO_PEDIDOPENDIENTE |
bigint(20)
|
|
|
|
| NO_LOCKRECORD |
bigint(20)
|
|
|
|
| NO_USEESTADISTICAS |
bigint(20)
|
|
|
|
| MAXTRANSBANCO |
bigint(20)
|
|
|
|
| NO_GRUPOGASTO |
longtext
|
utf8mb4_general_ci
|
|
|
| ULTFECHACONTABINIT |
longtext
|
utf8mb4_general_ci
|
|
|
| ULTFECHACONTABFIN |
longtext
|
utf8mb4_general_ci
|
|
|
| FORMATOFECHA |
bigint(20)
|
|
|
|
| NO_RETENCIONPROVEEDOR |
bigint(20)
|
|
|
|
| NO_RETENCIONESPECIAL |
bigint(20)
|
|
|
|
| CONTRIBUYENTE_ESPECIAL |
bigint(20)
|
|
|
|
| CLASIFICACION_RETENCION |
longtext
|
utf8mb4_general_ci
|
|
|
| PORCENT_ESPECIAL |
double
|
|
|
|
| NO_CONTROL |
bigint(20)
|
|
|
|
| UNASOLARETENCION |
bigint(20)
|
|
|
|
| NO_CONSECUTIVO |
bigint(20)
|
|
|
|
| MODO_IVA |
longtext
|
utf8mb4_general_ci
|
|
|
| DECIMALES_CANTIDAD |
bigint(20)
|
|
|
|
| CLASIFICACION_RETENCION_CLIENT |
longtext
|
utf8mb4_general_ci
|
|
|
| ACTIVAR_CODIGOUNICO |
bigint(20)
|
|
|
|
| NAMENDCLIENTE |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMENDPROVEEDOR |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMENCCLIENTE |
longtext
|
utf8mb4_general_ci
|
|
|
| NAMENCPROVEEDOR |
longtext
|
utf8mb4_general_ci
|
|
|
| ABRENDCLIENTE |
longtext
|
utf8mb4_general_ci
|
|
|
| ABRENDPROVEEDOR |
longtext
|
utf8mb4_general_ci
|
|
|
| ABRENCCLIENTE |
longtext
|
utf8mb4_general_ci
|
|
|
| ABRENCPROVEEDOR |
longtext
|
utf8mb4_general_ci
|
|
|
| CIERRE_DONE |
bigint(20)
|
|
|
|
| TIPOCOSTO |
longtext
|
utf8mb4_general_ci
|
|
|
| VIGENCIA_CARNET |
bigint(20)
|
|
|
|
| ACTIVE_CUENTASC |
bigint(20)
|
|
|
|
| ACTIVE_CUENTASP |
bigint(20)
|
|
|
|
| MONEDA_REFERENCIA |
longtext
|
utf8mb4_general_ci
|
|
|
| REDONDEOIVA_VENTAS |
bigint(20)
|
|
|
|
| REDONDEOIVA_COMPRAS |
bigint(20)
|
|
|
|
| BLOCKAUTODROP |
bigint(20)
|
|
|
|
| NAME_DETALLE |
longtext
|
utf8mb4_general_ci
|
|
|
| NO_RECIBOCAJACHICA |
bigint(20)
|
|
|
|
| NO_ORDENPAGO |
bigint(20)
|
|
|
|
| CLASIFICACION_CARGOS |
longtext
|
utf8mb4_general_ci
|
|
|
| CLASIFICACION_DESCARGOS |
longtext
|
utf8mb4_general_ci
|
|
|
| IGUALARCORRELATIVO |
bigint(20)
|
|
|
|
| MODORETENCIONVENTA |
bigint(20)
|
|
|
|
| MODORETENCIONCOMPRA |
bigint(20)
|
|
|
|
| NO_ORDENENSAMBLE |
bigint(20)
|
|
|
|
| DEPOSITO_ENSAMBLE |
longtext
|
utf8mb4_general_ci
|
|
|
| DEPOSITO_ENSAMBLETRANSITO |
longtext
|
utf8mb4_general_ci
|
|
|
| CLASIFICA_ENSAMBLECARGO |
longtext
|
utf8mb4_general_ci
|
|
|
| CLASIFICA_ENSAMBLEDESCARGO |
longtext
|
utf8mb4_general_ci
|
|
|
| CLASIFICA_ENSAMBLETRASLADO |
longtext
|
utf8mb4_general_ci
|
|
|
| IGUALARCORRELATIVOCOMPRA |
bigint(20)
|
|
|
|
| MOSTRARALLDEPOSITOS |
bigint(20)
|
|
|
|
| UNIDAD_TRIBUTARIA |
double
|
|
|
|
| ESTADO_NAME |
longtext
|
utf8mb4_general_ci
|
|
|
| ESTADO_VALUE |
longtext
|
utf8mb4_general_ci
|
|
|
| CIUDAD_NAME |
longtext
|
utf8mb4_general_ci
|
|
|
| CIUDAD_VALUE |
longtext
|
utf8mb4_general_ci
|
|
|
| MUNICIPIO_NAME |
longtext
|
utf8mb4_general_ci
|
|
|
| MUNICIPIO_VALUE |
longtext
|
utf8mb4_general_ci
|
|
|
| TIPO_PERSONAJURIDICA |
longtext
|
utf8mb4_general_ci
|
|
|
| NO_CAUSACION |
bigint(20)
|
|
|
|
| NO_CAJACHICA |
bigint(20)
|
|
|
|
| TIPO_CONVENIOVALIDA |
bigint(20)
|
|
|
|
| TIPO_CALCULOUTILIDAD |
bigint(20)
|
|
|
|
| NO_NOTAXRETENCIONCXP |
bigint(20)
|
|
|
|
| BUSQUEDA_ASTERISCO |
bigint(20)
|
|
|
|
| DEPOSITO_ENSAMBLEDESTINO |
longtext
|
utf8mb4_general_ci
|
|
|
| MTO_DCTOIVA |
double
|
|
|
|
| MTO_TOPEDCTOIVA |
double
|
|
|
|
| ULTIMA_RECONVERSION |
double
|
|
|
|
| DIAS_RECONVERSION |
bigint(20)
|
|
|
|
| UTILIZA_FACTOR |
longtext
|
utf8mb4_general_ci
|
|
|
| UTILIZA_FACTOR2 |
longtext
|
utf8mb4_general_ci
|
|
|
| UTILIZA_FACTOR3 |
longtext
|
utf8mb4_general_ci
|
|
|
| UTILIZA_FACTOR4 |
longtext
|
utf8mb4_general_ci
|
|
|
| UTILIZA_FACTOR5 |
longtext
|
utf8mb4_general_ci
|
|
|
| ACTIVAR_LIMITEDIVISAS |
bigint(20)
|
|
|
|
| IGTF_BASE |
bigint(20)
|
|
|
|
| IGTF_CXC |
bigint(20)
|
|
|
|
| IGTF_CXP |
bigint(20)
|
|
|
|
| CARGOSPRONTOPAGO |
bigint(20)
|
|
|
|
| PRECIOMORA |
bigint(20)
|
|
|
|