AGM (4) Gestion Tributaria (3) IAE

 

1. IAE Bonificacione y exenciones (IAEBONIFICACIONESEXENCIONES.xls)

-------------------------------------
-- IAE BONIFICACIONES Y EXENCIONES 
-------------------------------------
SELECT 
  IIAE.NUMERO_FIJO_IIAE AS REFERENCIA_IAE,
  IIAE.NIF_IIAE AS NIF,
  IIAE.NOMBRE_IIAE AS NOMBRE_RS,
  TBFI.COD_BBIA AS COD_Z_BON_EXE,
  IIAE.BENEF_FISCAL_LIT_IIAE AS DESCRIPCION,
  IIAE.PORCENTAJE_BENEF_FISCAL_IIAE AS PORC_BON,
  TO_CHAR(BEIA.ANYO_INICIO_BEIA)|| '0101'   AS F_INI_BE,
  IIAE.FECHA_LIMITE_BENEF_IIAE AS F_FIN_BE
--  SELECT *
FROM "OPS$GTTORA".IIAE_INFO_IAE IIAE
LEFT JOIN OPS$GTTORA.OTIA_OBJETO_TRIBUTARIO_IAE OTIA ON OTIA.NUMERO_FIJO_OTIA  =IIAE.NUMERO_FIJO_IIAE AND OTIA.EJER_EFECTIVIDAD_OTIA =IIAE.EJER_EFECTIVIDAD_IIAE 
LEFT JOIN "OPS$GTTORA".BEIA_BENEFICIOS_IAE BEIA ON BEIA.ID_EPER_OT =OTIA.ID_EPER_OT 
  AND NOT EXISTS (
    SELECT * FROM OPS$GTTORA.BEIA_BENEFICIOS_IAE BEIA1 
    WHERE BEIA1.ID_EPER_OT =OTIA.ID_EPER_OT 
      AND BEIA1.ANYO_INICIO_BEIA<BEIA.ANYO_INICIO_BEIA
  )
  LEFT JOIN "OPS$GTTORA".TBFI_TIPO_BENEFICIO_FISCAL_IAE TBFI ON TBFI.ID_TBFI =beia.ID_TBFI 
WHERE IIAE.EJER_EFECTIVIDAD_IIAE >=2023 AND IIAE.PORCENTAJE_BENEF_FISCAL_IIAE >'000'
ORDER BY IIAE.NUMERO_FIJO_IIAE ; 

2. IAE Domiciliaciones (IAEDOMICILIACIONES.xls)

-------------------------------------
-- IAE DOMICILIACIONES
-------------------------------------
SELECT
  IIAE.NUMERO_FIJO_IIAE AS REFERENCIA_IAE,
  IIAE.NIF_IIAE AS NIF,
  IIAE.NOMBRE_IIAE AS NOMBRE_RS,
  SUBSTR(NVL(REGE.IBAN_REGE,DOMI.IBAN_DOMI), 1, 2)   AS DOM_COD_PAIS,
  SUBSTR(NVL(REGE.IBAN_REGE,DOMI.IBAN_DOMI), 3, 2)   AS DOM_IBAN_DC,
  SUBSTR(NVL(REGE.IBAN_REGE,DOMI.IBAN_DOMI), 5, 4)   AS DOM_ENTIDAD,
  SUBSTR(NVL(REGE.IBAN_REGE,DOMI.IBAN_DOMI), 9, 4)   AS DOM_OFICINA,
  SUBSTR(NVL(REGE.IBAN_REGE,DOMI.IBAN_DOMI),13, 2)   AS DOM_DC,
  SUBSTR(NVL(REGE.IBAN_REGE,DOMI.IBAN_DOMI),15,10)   AS DOM_CUENTA,
  NVL(PPPP.FECHA_OPERACION_PPP, DOMI.FECHA_ALTA_DOMI) AS FECHA_DOMICILIACION,
  '?????' AS MANDATO_SEPA
FROM "OPS$GTTORA".IIAE_INFO_IAE IIAE
LEFT JOIN OPS$GTTORA.OTIA_OBJETO_TRIBUTARIO_IAE OTIA ON OTIA.NUMERO_FIJO_OTIA  =IIAE.NUMERO_FIJO_IIAE AND OTIA.EJER_EFECTIVIDAD_OTIA =IIAE.EJER_EFECTIVIDAD_IIAE 
LEFT JOIN OPS$GTTORA.DOMI_DOMICILIACIONES DOMI 
    ON DOMI.ID_EPER_OT=OTIA.ID_EPER_OT AND DOMI.ESTADO_DOMI='A'  
    AND NOT EXISTS (
      SELECT * FROM OPS$GTTORA.DOMI_DOMICILIACIONES DOMI1 
      WHERE DOMI1.ID_EPER_OT=DOMI.ID_EPER_OT 
        AND DOMI1.ESTADO_DOMI='A'
        AND DOMI1.FECHA_ALTA_DOMI>DOMI.FECHA_ALTA_DOMI
    )
LEFT JOIN OPS$GTTORA.EPER_ELEMENTOS_PERSONA EPER ON EPER.ID_EPER = OTIA.ID_EPER_OT
LEFT JOIN OPS$GTTORA.EPER_ELEMENTOS_PERSONA EPER_PPP ON EPER_PPP.ID_PERS =EPER.ID_EPER AND EPER_PPP.TIPO_EPER ='PP'
LEFT JOIN OPS$GTTORA.PPPP_PAGO_PLAZOS PPPP ON PPPP.ID_EPER=EPER_PPP.ID_EPER AND PPPP.COD_PPSI ='AC' 
LEFT JOIN OPS$GTTORA.REGE_REGISTRO_ENTRADA REGE ON REGE.ID_EPER_SP= PPPP.ID_EPER_SP 
WHERE IIAE.EJER_EFECTIVIDAD_IIAE >=2023 AND DOMI.IBAN_DOMI IS NOT NULL OR REGE.IBAN_REGE IS NOT NULL
ORDER BY IIAE.NUMERO_FIJO_IIAE ;