- ,CodSucursal As COD_SUCURSAL
- ,Sucursales.Nombre As SUCURSAL
- ,PuntoVenta As PUNTO_VENTA
- ,Poliza As POLIZA
- ,TipoDocTomador As TIPO_DOC_TOMADOR
- ,NroDocTomador As NRO_DOC_TOMADOR
- ,NombreTomador As NOMBRE_TOMADOR
- ,ClaveAgente As CLAVE_AGENTE
- ,NombreAgente As NOMBRE_AGENTE
- ,Comision As COMISION
- ,Producto As PRODUCTO
- ,VigenciaDesde As VIGENCIA_DESDE
- ,VigenciaHasta As VIGENCIA_HASTA
- ,TipoDocAsegurado As TIPO_DOC_ASEGURADO
- ,NroDocAsegurado As NRO_DOC_ASEGURADO
- ,NombreAsegurado As NOMBRE_ASEGURADO
- ,NombreBeneficiario As NOMBRE_BENEFICIARIO
- ,Marca As MARCA
- ,Clase As CLASE
- ,GrupoTarifa As GRUPO_TARIFACION
- ,TipoVehiculo As TIPO_VEHICULO
- ,CodigoFasecolda As CODIGO_FASECOLDA
- ,Modelo As MODELO
- ,Placa As PLACA
- ,UsoServicio As USO_SERVICIO
- ,DptoMovilizacion As DEPARTAMENTO_MOVILIZACION
- ,LimiteRCE As LIMITE_RCE
- ,VlrCascoAnterior As VLR_CASCO_ANO_ANTERIOR
- ,VlrAccesorios As VLR_ACCESORIOS
- ,VlrAseguradoAnterior As VLR_ASEGURADO_ANO_ANTERIOR
- ,PrimaAnterior As PRIMA_ANO_ANTERIOR
- ,FasecoldaVigente As FASECOLDA_VIGENTE
- ,(FasecoldaVigente+VlrAccesorios) As VALOR_ASEGURADO_RENOVACION
- ,BNRRenovacion As BNR_RENOVACION
- ,ObservacionPoliza As OBSERVACION_POLIZA
- ,ClasificacionRiesgo As CLASIFICACION_RIESGO
- ,HabilitadaPeau As HABILITADA_EN_PEAU_SI_NO
- ,PrimaRenoSinIva As PRIMA_RENOVACION_ANTES_DE_IVA
- ,IncrementoPrima As INCREMENTODEPRIMA_SI_NO_OP_A
- ,VlrAmpAdicionales As VLR_AMP_ADICIONALES
- ,PrimSinAmpAdicionales As PRIMA_SIN_AMP_ADICIONALES
- ,IncrementoPrimaB As INCREMENTODEPRIMA_SI_NO_OP_B
- ,FormaEmision As FORMA_DE_EMISION
- ,ObservacionGeneral As OBSERVACION_GENERAL
- ,DadoBaja As "CLIENTE_DADO_DE_BAJA"
- ,MotivoBaja As "MOTIVO_BAJA"
- ,ActivaBaja As "ACTIVA_CLIENTE_BAJA"
Don't like ads? PRO users don't see any ads ;-)
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
create a new version of this paste
RAW Paste Data