82,676.85 


SELECT CODIGO_TTR,CODIGOIDENTIFICACION_PAD,VALORIVA_CAF as VALORIVA_CAF,round(TOTAL_CAF,2) as TOTAL_CAF,NUMEROCOMPROBANTES as NUMEROCOMPROBANTES from (SELECT CODIGO_TTR,CODIGOIDENTIFICACION_PAD,VALORIVA_CAF as VALORIVA_CAF,round(TOTAL_CAF,2)-VALORIVA_CAF as TOTAL_CAF,serial_caf as NUMEROCOMPROBANTES  from sritipotransaccion,padres,padres_alumno,paralelo_alumno,cabecerafactura where sritipotransaccion.identificacion_ttr=padres.tipoidentificacion_pad and sritipotransaccion.transaccion_ttr='VENTA' and paralelo_alumno.serial_paralu=cabecerafactura.serial_paralu and padres.serial_pad=padres_alumno.serial_pad and padres_alumno.serial_alu=paralelo_alumno.serial_alu and estado_caf<>'ANULADA' and YEAR(fecha_caf)='2014' and MONTH(fecha_caf)='01' and repreEconomico_palu='SI'  UNION SELECT CODIGO_TTR,if (CEDULA_ORP ='',DOCUMENTOIDENTIDAD_CLI,CEDULA_ORP) as CODIGOIDENTIFICACION_PAD,SUMAIVA12_ORP as VALORIVA_CAF,TOTAL_ORP-SUMAIVA12_ORP as TOTAL_CAF,serial_orp as NUMEROCOMPROBANTES   from sritipotransaccion,cliente,ordenpedido where  cliente.serial_cli=ordenpedido.serial_cli and  sritipotransaccion.identificacion_ttr=if (length(cedula_orp)<=0,tipodocumento_cli,if(length(cedula_orp)>10,'RUC','CEDULA')) and sritipotransaccion.transaccion_ttr='VENTA' and estado_orp='FACTURADO' and YEAR(fecha_orp)='2014' and MONTH(fecha_orp)='01'  group by CODIGOIDENTIFICACION_PAD ) AS facturasventa



SELECT CODIGO_TTR,NUMERO_CAF,VALORIVA_CAF as VALORIVA_CAF,round(TOTAL_CAF,2) as TOTAL_CAF,NUMEROCOMPROBANTES as NUMEROCOMPROBANTES from (SELECT CODIGO_TTR,NUMERO_CAF,VALORIVA_CAF as VALORIVA_CAF,round(TOTAL_CAF,2)-VALORIVA_CAF as TOTAL_CAF,serial_caf as NUMEROCOMPROBANTES  from sritipotransaccion,padres,padres_alumno,paralelo_alumno,cabecerafactura where sritipotransaccion.identificacion_ttr=padres.tipoidentificacion_pad and sritipotransaccion.transaccion_ttr='VENTA' and paralelo_alumno.serial_paralu=cabecerafactura.serial_paralu and padres.serial_pad=padres_alumno.serial_pad and padres_alumno.serial_alu=paralelo_alumno.serial_alu and estado_caf<>'ANULADA' and YEAR(fecha_caf)='2014' and MONTH(fecha_caf)='01' and repreEconomico_palu='SI'  UNION SELECT CODIGO_TTR,if (CEDULA_ORP ='',DOCUMENTOIDENTIDAD_CLI,CEDULA_ORP) as NUMERO_CAF,SUMAIVA12_ORP as VALORIVA_CAF,TOTAL_ORP-SUMAIVA12_ORP as TOTAL_CAF,serial_orp as NUMEROCOMPROBANTES   from sritipotransaccion,cliente,ordenpedido where  cliente.serial_cli=ordenpedido.serial_cli and  sritipotransaccion.identificacion_ttr=if (length(cedula_orp)<=0,tipodocumento_cli,if(length(cedula_orp)>10,'RUC','CEDULA')) and sritipotransaccion.transaccion_ttr='VENTA' and estado_orp='FACTURADO' and YEAR(fecha_orp)='2014' and MONTH(fecha_orp)='01'  ORDER BY NUMERO_CAF ) AS facturasventa





SELECT CODIGO_TTR,NUMERO_CAF,VALORIVA_CAF as VALORIVA_CAF,round(TOTAL_CAF,2) as TOTAL_CAF,NUMEROCOMPROBANTES as NUMEROCOMPROBANTES from (SELECT CODIGO_TTR,NUMERO_CAF,VALORIVA_CAF as VALORIVA_CAF,round(TOTAL_CAF,2)-VALORIVA_CAF as TOTAL_CAF,serial_caf as NUMEROCOMPROBANTES  from sritipotransaccion,padres,padres_alumno,paralelo_alumno,cabecerafactura where sritipotransaccion.identificacion_ttr=padres.tipoidentificacion_pad and sritipotransaccion.transaccion_ttr='VENTA' and paralelo_alumno.serial_paralu=cabecerafactura.serial_paralu and padres.serial_pad=padres_alumno.serial_pad and padres_alumno.serial_alu=paralelo_alumno.serial_alu and estado_caf<>'ANULADA' and YEAR(fecha_caf)='2014' and MONTH(fecha_caf)='01' and repreEconomico_palu='SI'  UNION SELECT CODIGO_TTR,if (CEDULA_ORP ='',DOCUMENTOIDENTIDAD_CLI,CEDULA_ORP) as NUMERO_CAF,SUMAIVA12_ORP as VALORIVA_CAF,TOTAL_ORP-SUMAIVA12_ORP as TOTAL_CAF,serial_orp as NUMEROCOMPROBANTES   from sritipotransaccion,cliente,ordenpedido where  cliente.serial_cli=ordenpedido.serial_cli and  sritipotransaccion.identificacion_ttr=if (length(cedula_orp)<=0,tipodocumento_cli,if(length(cedula_orp)>10,'RUC','CEDULA')) and sritipotransaccion.transaccion_ttr='VENTA' and estado_orp='FACTURADO' and YEAR(fecha_orp)='2014' and MONTH(fecha_orp)='01'   ) AS facturasventa


//PARA IDENTIFICAR TIPO IDENTIFIACION DEL PADRE QUE NO SUBE AL ATS

SELECT DISTINCT alumno.serial_alu, estado_alu, apellido_alu, apellido_pad, nombre_pad, codigoIdentificacion_pad, tipoidentificacion_pad
FROM periodo, seccion, nivel, paralelo, paralelo_alumno, alumno, padres_alumno, padres
WHERE padres_alumno.serial_alu = alumno.serial_alu
AND padres.serial_pad = padres_alumno.serial_pad
AND seccion.serial_sec = nivel.serial_sec
AND periodo.serial_per = paralelo_alumno.serial_per
AND nivel.serial_niv = paralelo.serial_niv
AND paralelo.serial_par = paralelo_alumno.serial_par
AND paralelo_alumno.serial_alu = alumno.serial_alu
AND nombre_sec NOT LIKE '%INSCRITO%'
AND nombre_sec NOT LIKE '%RETIRADO%'
AND nombre_sec NOT LIKE '%XXXXX%'
AND nombre_sec NOT LIKE '%INTERCAMBIO%'
AND nombre_sec NOT LIKE '%EMPRESARI%'
AND paralelo_alumno.activo_paralu = 's'
AND numeromatricula_paralu >0
AND periodo.serial_per =7
AND repreEconomico_palu = "SI"
and tipoidentificaCion_pad!="CEDULA"