<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="formato_pago_contratista_2020_1" language="groovy" pageWidth="612" pageHeight="792" orientation="Landscape" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/formato_pago_contratista_2020_1"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="id_contratista" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_contrato" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_formato_pago" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT

tab0.estado_general,

comis.resolucion,

tab0.id_formato_pago as id_formato_pago,
tab0.id_contratista as id_contratista,
tab0.id_contrato as id_contrato,
tab0.id_numero_pago as id_numero_pago,
tab0.fecha_ini_pago as fecha_ini_pago,
tab0.fecha_fin_pago as fecha_fin_pago,
tab0.valor_mensual as valor_mensual, tab0.valor_iva_reg as valor_iva_reg,
tab0.dias_liq as dias_liq,
tab0.valor_pagar as valor_pagar, tab0.numero_planilla as numero_planilla,
tab0.valor_ingresos as valor_ingresos, tab0.aporte_salud as aporte_salud,
tab0.aporte_pension as aporte_pension, tab0.aporte_fsp as aporte_fsp,
tab0.aporte_arl as aporte_arl, tab0.id_tipo_riesgo as id_tipo_riesgo,
tab0.aporte_volun_pen as aporte_volun_pen, tab0.aporte_volun_afc as aporte_volun_afc,
tab0.valor_intereses_vivienda as valor_intereses_vivienda, tab0.valor_dependientes as valor_dependientes,
tab0.valor_medicina as valor_medicina,


nvl(sumanm.SUM_RP_DETALLES,0) + nvl(sumsgr.sum_rp_detalles,0) as valor_contrato,

tab0.valor_base_reten as valor_base_reten,
tab0.valor_retencion as valor_retencion, tab0.tarifa_reten as tarifa_reten, tab0.valor_iva as valor_iva,
tab0.tarifa_iva as tarifa_iva, tab0.valor_ica as valor_ica, tab0.valor_ica_extra as valor_ica_extra, tab0.tarifa_ica as tarifa_ica,
tab0.valor_a_pagar as valor_a_pagar, tab0.valor_comisiones as valor_comisiones,
NUMERO_A_TEXTO(tab0.valor_a_pagar) as total_a_pagar_texto,
tab0.valor_base_ica as valor_base_ica,
tab0.fecha_log as fecha_log,
tab0.usuario_log as usuario_log, tab0.valor_embargo as valor_embargo,
tab0.valor_ing_comisiones as valor_ing_comisiones, tab0.valor_total_reten as valor_total_reten,
tab0.firmado as firmado,
tab0.revisado as revisado,
tab0.autorizado as autorizado,
tab0.radicado as radicado,
tab0.APROBADO as APROBADO,
tab0.estado,
tab0.NUMERO_RADICADO,
tab0.aplica_planilla_aportes,
to_char(tab0.FECHA_RADICADO,'dd/mm/yyyy') as FECHA_RADICADO,
to_char(tab0.FECHA_AUTORIZADO,'dd/mm/yyyy') as FECHA_AUTORIZADO,
nvl(to_char(tab0.FECHA_APROBADO,'dd/mm/yyyy'),' ') as FECHA_APROBADO,
nvl(tab0.valor_deduccion,0) as valor_deduccion,


tab1.num_contrato as num_contrato, tab1.id_anhos as id_anhos,
tab1.fecha_contrato as fecha_contrato,
tab1.objeto as objeto, tab1.obligaciones as obligaciones, tab1.estado as estado_contrato,
''  || ' ' || anmrps.rp_detalles  as rp_anm , '' || ' ' || sgrrps.rp_detalles  as rp_sgr, tab1.rp_anm||tab1.rp_sgr as rp,
case when tab1.rp_anm is null then 0 else
  case when tab1.rp_sgr is null then 100 else
    case when ROUND((tab1.valor_anm*100)/(tab1.valor_anm+tab1.valor_sgr)) - 0.5 = (tab1.valor_anm*100)/(tab1.valor_anm+tab1.valor_sgr)
      then (tab1.valor_anm*100)/(tab1.valor_anm+tab1.valor_sgr) else ROUND((tab1.valor_anm*100)/(tab1.valor_anm+tab1.valor_sgr)) end
  end
end as porc_anm,
case when tab1.rp_sgr is null then 0 else
  case when tab1.rp_anm is null then 100 else
    case when ROUND((tab1.valor_sgr*100)/(tab1.valor_anm+tab1.valor_sgr))- 0.5 = (tab1.valor_sgr*100)/(tab1.valor_anm+tab1.valor_sgr)
      then (tab1.valor_sgr*100)/(tab1.valor_anm+tab1.valor_sgr) else ROUND((tab1.valor_sgr*100)/(tab1.valor_anm+tab1.valor_sgr)) end
  end
end as porc_sgr,

case when sumanm.sum_rp_detalles is null then 0 else
  case when sumsgr.sum_rp_detalles is null then 100 else
    case when ROUND((sumanm.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles)) - 0.5 = (sumanm.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles)
      then (sumanm.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles) else ROUND((sumanm.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles)) end
  end
end as porc_anm_d,


case when sumsgr.sum_rp_detalles is null then 0 else
  case when sumanm.sum_rp_detalles is null then 100 else
    case when ROUND((sumsgr.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles))- 0.5 = (sumsgr.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles)
      then (sumsgr.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles) else ROUND((sumsgr.sum_rp_detalles*100)/(sumanm.sum_rp_detalles+sumsgr.sum_rp_detalles)) end
  end
end as porc_sgr_d,



tab1.fecha_rp as fecha_rp,
tab1.fecha_poliza as fecha_poliza,
tab1.valor_anm as valor_anm, tab1.cdp_anm as cdp_anm,
tab1.fecha_cdp_anm as fecha_cdp_anm,
tab1.valor_sgr as valor_sgr, tab1.cdp_sgr as cdp_sgr,
tab1.fecha_cdp_sgr as fecha_cdp_sgr,
tab1.dependencia as dependencia, tab1.meses_plazo as meses_plazo, tab1.dias_plazo as dias_plazo,
tab1.fecha_plazo as fecha_plazo,
tab1.id_supervisor as id_supervisor,
tab1.id_apoyo_supervisor as id_apoyo_supervisor, tab1.valor_anm+tab1.valor_sgr as valor_contrato,

tab1.tipo_recurso as tipo_recurso, tab2.id_tipo_doc as id_tipo_doc, tab2.num_doc as num_doc,
tab2.razon_social as razon_social, tab2.correo as correo, tab2.id_ciudad as id_ciudad,
tab2.estado as estado_contratista, tab2.id_tipo_regimen as id_tipo_regimen,
tab2.mas_empleados as mas_empleados, tab2.declarante_renta as declarante_renta,
tab2.pensionado as pensionado, tab2.embargo as embargo, tab2.valor_embargo as valor_embargo_contra,
tab2.num_doc||' - '||tab2.razon_social as completo,
tab2.dependiente as dependiente,
tdcontra.abreviacion as tipo_doc_contra,
tab2.codigo_fondo_salud,
tab2.NIT_FONDO_SALUD,
tab2.razon_social_fondo_salud,
tab2.ID_FONDO_PENSION,
tab2.codigo_fondo_pension,
tab2.NIT_FONDO_PENSION,
tab2.razon_social_fondo_pension,
tab2.ID_CAJA_COMP,
tab2.codigo_caja_comp,
tab2.NIT_FONDO_CAJA_COMP,
tab2.razon_social_caja_comp,
tab2.ID_FONDO_ARL,
tab2.codigo_fondo_arl,
tab2.NIT_FONDO_ARL,
tab2.razon_social_fondo_arl,

tab3.descripcion as tipo_regimen,
tab3.aplica_iva as aplica_iva, tab4.numero as numero, tab4.descripcion as numero_pago,
tab5.codigo as codigo, tab5.descripcion as descripcion_riesgo,
tab5.valor as valor_riesgo,
tab5.codigo as codigo_riesgo,

nvl(ciu.nit,' ') as nit_ciudad,
--ciu.nombre as nombre_ciudad,
--acta.ciudad_acta as nombre_ciudad,
ciudadacta.nombre as nombre_ciudad,
ciu.tarifa_ica as tarifa_ica_ciudad,
ciu.base_deveg,
ciu.base_deduc,
ciu.tarifa_ica_extra as tarifa_ica_extra,
uvt.vigencia,
uvt.valor_uvt,

nvl(ter.num_doc,tercon.num_doc) as num_doc_sup,
nvl(ter.razon_soc,tercon.razon_soc) as razon_soc_sup,
nvl(sup.CARGO,supcon.CARGO) as cargo_sup,

nvl(nvl(ter_apo.num_doc,ter_apocon.num_doc),'NA') as num_doc_apo,
nvl(ter_apo.razon_soc,ter_apocon.razon_soc) as razon_soc_apo,
nvl(apo.cargo,apocon.cargo) as cargo_apo,

case when deducc.fecha_ini<tab0.FECHA_ini_PAGO then to_char(tab0.FECHA_ini_PAGO,'DD/MM/YYYY') else to_char(deducc.fecha_ini,'DD/MM/YYYY')  end as fecha_ini_deducc,
case when deducc.fecha_fin>tab0.FECHA_fin_PAGO then to_char(tab0.FECHA_fin_PAGO,'DD/MM/YYYY')  else to_char(deducc.fecha_fin,'DD/MM/YYYY')  end as fecha_fin_deducc,

(case when deducc.fecha_fin>tab0.FECHA_fin_PAGO then tab0.FECHA_fin_PAGO else deducc.fecha_fin end -
case when deducc.fecha_ini<tab0.FECHA_ini_PAGO then tab0.FECHA_ini_PAGO else deducc.fecha_ini end)+1
as dias_deduccion,
deducc.descripcion as descripcion_deduccion,

tab1.aplica_rp_doble,
tab1.rp_anm_old,
tab1.rp_sgr_old,

tab0.valor_rp_anm_cont,
tab0.valor_rp_sgr_cont,
tab0.valor_rp_anm_doble,
tab0.valor_rp_sgr_doble,
tab0.valor_caja_comp,

case

when tab1.aplica_rp_doble = 1 and tab1.rp_anm_old is not null
then tab1.rp_anm || '(' || replace(TO_CHAR(tab0.valor_rp_anm_cont, 'FM9,999,999,999'),',','.') || ',00)'
|| ' - ' || tab1.rp_anm_old || '(' || replace(TO_CHAR(tab0.valor_rp_anm_doble, 'FM9,999,999,999'),',','.') || ',00)'

when tab1.aplica_rp_doble = 1 and tab1.rp_sgr_old is not null
then tab1.rp_sgr || '(' || replace(TO_CHAR(tab0.valor_rp_sgr_cont, 'FM9,999,999,999'),',','.') || ',00)'
|| ' - ' || tab1.rp_sgr_old || '(' || replace(TO_CHAR(tab0.valor_rp_sgr_doble, 'FM9,999,999,999'),',','.') || ',00)'

else '' end as rp_doble,

tab0.id_declara_jura_nov,
tab0.fecha_consigna_afc as fecha_consigna_afc,
tab0.fecha_consigna_volun_pen,
tab0.anho_gravable_int_viv,
tab0.anho_gravable_medicina,

declara.fecha as fecha_declara_jura_nov,
declara.id_tipo_condiciones as id_tipo_condiciones,
declara.tipo_condiciones as tipo_condiciones,
declara.dependiente as dependiente_declara,

tab0.valor_aporte_solidario,
case when tab0.aplica_pension_menor = 1 and tab0.aplica_text_aporte_solidario = 1 then ' 5. Me acojo al Aporte de Pensión del 3% de conformidad con el Decreto 558 de 2020 y la Resolución 686 de 2020. 6. Manifiesto que de manera voluntaria deseo contribuir al pago del impuesto solidario Covid 19- de conformidad con el Decreto 568 de 2020.'
     when tab0.aplica_pension_menor = 1 then ' 5. Me acojo al Aporte de Pensión del 3% de conformidad con el Decreto 558 de 2020 y la Resolución 686 de 2020.'
     when tab0.aplica_text_aporte_solidario = 1 then ' 5. Manifiesto que de manera voluntaria deseo contribuir al pago del impuesto solidario Covid 19- de conformidad con el Decreto 568 de 2020.'
    else ' ' end as tex_anexo_2020,

tab0.valor_otra_entidad,
tab0.base_aporte_solidario,
tab0.base_proporcion_apo_solid,

tab0.tarifa_estampilla,
tab0.valor_estampilla,
tab0.valor_base_estampilla

FROM RVC_FORMATO_PAGO_V tab0

LEFT JOIN RVC_CONTRATO_V tab1 ON tab0.id_contrato = tab1.id_contrato

--LEFT JOIN RVC_ACTA_INICIO_V acta ON tab1.num_contrato = acta.num_contrato
LEFT JOIN RVC_ACTA_INICIO acta ON tab1.num_contrato = acta.num_contrato

LEFT JOIN CIUDAD ciudadacta on acta.id_ciudad = ciudadacta.id

LEFT JOIN RVC_CONTRATISTA_V tab2 ON tab0.id_contratista = tab2.id_contratista

LEFT JOIN RVC_TIPO_REGIMEN tab3 ON tab0.id_tipo_regimen = tab3.id_tipo_regimen

LEFT JOIN RVC_NUMERO_PAGO tab4 ON tab0.id_numero_pago = tab4.id_numero_pago

LEFT JOIN RVC_TIPO_RIESGO tab5 ON tab0.id_tipo_riesgo = tab5.id_tipo_riesgo

LEFT JOIN CIUDAD ciu on ciu.id = tab2.id_ciudad

LEFT JOIN TS_UVT uvt on uvt.vigencia = tab1.id_anhos

LEFT JOIN RVC_CONTRATO_COMAS_RPS_V anmrps ON tab1.id_contrato=anmrps.id_contrato and anmrps.tipo_recurso=0

LEFT JOIN RVC_CONTRATO_COMAS_RPS_V sgrrps ON tab1.id_contrato=sgrrps.id_contrato and sgrrps.tipo_recurso=1



LEFT JOIN RVC_CONTRATO_RPS_SUM_RECURSO_V sumanm ON tab1.id_contrato=sumanm.id_contrato and sumanm.tipo_recurso=0

LEFT JOIN RVC_CONTRATO_RPS_SUM_RECURSO_V sumsgr ON tab1.id_contrato=sumsgr.id_contrato and sumsgr.tipo_recurso=1

left join rvc_supervisor sup on sup.ID_SUPERVISOR = tab0.USUARIO_AUTORIZADO
left join interceros ter on ter.ID_MAE_TER = sup.ID_MAE_TER

left join rvc_supervisor supcon on supcon.ID_SUPERVISOR = tab1.ID_SUPERVISOR
left join interceros tercon on tercon.ID_MAE_TER = supcon.ID_MAE_TER

left join rvc_apoyo_supervisor apo on tab0.USUARIO_REVISADO=apo.id_apoyo_supervisor
left join interceros ter_apo on ter_apo.id_mae_ter=apo.id_mae_ter

left join rvc_apoyo_supervisor apocon on tab1.id_apoyo_supervisor=apocon.id_apoyo_supervisor
left join interceros ter_apocon on ter_apocon.id_mae_ter=apocon.id_mae_ter

left join TIPO_DOCUMENTO tdcontra on tab2.id_tipo_doc=tdcontra.id_tipo_doc

left join (
  SELECT a.id_novedad_suspension,
  a.fecha_ini,
  a.fecha_fin,
  a.id_contratista as id_contra,
  a.id_tipo_novedad_suspension,
  b.descripcion
FROM rvc_novedad_suspension a
left join rvc_tipo_novedad_suspension b on a.id_tipo_novedad_suspension=b.id_tipo_novedad_suspension
)deducc on tab0.id_contratista=deducc.id_contra and (deducc.fecha_ini<=tab0.FECHA_FIN_PAGO and deducc.fecha_fin>=tab0.FECHA_INI_PAGO)

left join(

    select
    id_formato_pago,
    LISTAGG(resolucion || ' RP: ' || id_rp_comis || ' VALOR:' || TO_CHAR(valor,'FM999,999,999'), ', ') WITHIN GROUP (ORDER BY resolucion)  as resolucion
    from rvc_comision_form_pago
    group by
    id_formato_pago

)comis
on comis.id_formato_pago = tab0.id_formato_pago

left join (select
          id_declara_jura_nov,
          fecha ,
          id_tipo_condiciones,
          tipo_condiciones,
	dependiente
          from rvc_declara_jura_nov_v
          group by id_declara_jura_nov,fecha ,id_tipo_condiciones,tipo_condiciones,dependiente) declara on declara.id_declara_jura_nov = tab0.id_declara_jura_nov

WHERE
tab0.id_formato_pago =  $P{id_formato_pago}
AND tab0.id_contratista =  $P{id_contratista}
AND tab0.id_contrato =  $P{id_contrato}

ORDER BY
tab2.num_doc,
tab1.id_anhos,
tab1.num_contrato,
tab4.numero,
tab0.numero_planilla]]>
	</queryString>
	<field name="ESTADO_GENERAL" class="java.math.BigDecimal"/>
	<field name="RESOLUCION" class="java.lang.String"/>
	<field name="ID_FORMATO_PAGO" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="FECHA_INI_PAGO" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN_PAGO" class="java.sql.Timestamp"/>
	<field name="VALOR_MENSUAL" class="java.math.BigDecimal"/>
	<field name="VALOR_IVA_REG" class="java.math.BigDecimal"/>
	<field name="DIAS_LIQ" class="java.math.BigDecimal"/>
	<field name="VALOR_PAGAR" class="java.math.BigDecimal"/>
	<field name="NUMERO_PLANILLA" class="java.math.BigDecimal"/>
	<field name="VALOR_INGRESOS" class="java.math.BigDecimal"/>
	<field name="APORTE_SALUD" class="java.math.BigDecimal"/>
	<field name="APORTE_PENSION" class="java.math.BigDecimal"/>
	<field name="APORTE_FSP" class="java.math.BigDecimal"/>
	<field name="APORTE_ARL" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_RIESGO" class="java.math.BigDecimal"/>
	<field name="APORTE_VOLUN_PEN" class="java.math.BigDecimal"/>
	<field name="APORTE_VOLUN_AFC" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERESES_VIVIENDA" class="java.math.BigDecimal"/>
	<field name="VALOR_DEPENDIENTES" class="java.math.BigDecimal"/>
	<field name="VALOR_MEDICINA" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="VALOR_BASE_RETEN" class="java.math.BigDecimal"/>
	<field name="VALOR_RETENCION" class="java.math.BigDecimal"/>
	<field name="TARIFA_RETEN" class="java.math.BigDecimal"/>
	<field name="VALOR_IVA" class="java.math.BigDecimal"/>
	<field name="TARIFA_IVA" class="java.math.BigDecimal"/>
	<field name="VALOR_ICA" class="java.math.BigDecimal"/>
	<field name="VALOR_ICA_EXTRA" class="java.math.BigDecimal"/>
	<field name="TARIFA_ICA" class="java.math.BigDecimal"/>
	<field name="VALOR_A_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_COMISIONES" class="java.math.BigDecimal"/>
	<field name="TOTAL_A_PAGAR_TEXTO" class="java.lang.String"/>
	<field name="VALOR_BASE_ICA" class="java.math.BigDecimal"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.lang.String"/>
	<field name="VALOR_EMBARGO" class="java.math.BigDecimal"/>
	<field name="VALOR_ING_COMISIONES" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL_RETEN" class="java.math.BigDecimal"/>
	<field name="FIRMADO" class="java.math.BigDecimal"/>
	<field name="REVISADO" class="java.math.BigDecimal"/>
	<field name="AUTORIZADO" class="java.math.BigDecimal"/>
	<field name="RADICADO" class="java.math.BigDecimal"/>
	<field name="APROBADO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="NUMERO_RADICADO" class="java.math.BigDecimal"/>
	<field name="APLICA_PLANILLA_APORTES" class="java.math.BigDecimal"/>
	<field name="FECHA_RADICADO" class="java.lang.String"/>
	<field name="FECHA_AUTORIZADO" class="java.lang.String"/>
	<field name="FECHA_APROBADO" class="java.lang.String"/>
	<field name="VALOR_DEDUCCION" class="java.math.BigDecimal"/>
	<field name="NUM_CONTRATO" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="FECHA_CONTRATO" class="java.sql.Timestamp"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="OBLIGACIONES" class="java.lang.String"/>
	<field name="ESTADO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="RP_ANM" class="java.lang.String"/>
	<field name="RP_SGR" class="java.lang.String"/>
	<field name="RP" class="java.lang.String"/>
	<field name="PORC_ANM" class="java.math.BigDecimal"/>
	<field name="PORC_SGR" class="java.math.BigDecimal"/>
	<field name="PORC_ANM_D" class="java.math.BigDecimal"/>
	<field name="PORC_SGR_D" class="java.math.BigDecimal"/>
	<field name="FECHA_RP" class="java.sql.Timestamp"/>
	<field name="FECHA_POLIZA" class="java.sql.Timestamp"/>
	<field name="VALOR_ANM" class="java.math.BigDecimal"/>
	<field name="CDP_ANM" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP_ANM" class="java.sql.Timestamp"/>
	<field name="VALOR_SGR" class="java.math.BigDecimal"/>
	<field name="CDP_SGR" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP_SGR" class="java.sql.Timestamp"/>
	<field name="DEPENDENCIA" class="java.lang.String"/>
	<field name="MESES_PLAZO" class="java.math.BigDecimal"/>
	<field name="DIAS_PLAZO" class="java.math.BigDecimal"/>
	<field name="FECHA_PLAZO" class="java.sql.Timestamp"/>
	<field name="ID_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="ID_APOYO_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="TIPO_RECURSO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOCIAL" class="java.lang.String"/>
	<field name="CORREO" class="java.lang.String"/>
	<field name="ID_CIUDAD" class="java.math.BigDecimal"/>
	<field name="ESTADO_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_REGIMEN" class="java.math.BigDecimal"/>
	<field name="MAS_EMPLEADOS" class="java.math.BigDecimal"/>
	<field name="DECLARANTE_RENTA" class="java.math.BigDecimal"/>
	<field name="PENSIONADO" class="java.math.BigDecimal"/>
	<field name="EMBARGO" class="java.math.BigDecimal"/>
	<field name="VALOR_EMBARGO_CONTRA" class="java.math.BigDecimal"/>
	<field name="COMPLETO" class="java.lang.String"/>
	<field name="DEPENDIENTE" class="java.math.BigDecimal"/>
	<field name="TIPO_DOC_CONTRA" class="java.lang.String"/>
	<field name="CODIGO_FONDO_SALUD" class="java.lang.String"/>
	<field name="NIT_FONDO_SALUD" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_FONDO_SALUD" class="java.lang.String"/>
	<field name="ID_FONDO_PENSION" class="java.math.BigDecimal"/>
	<field name="CODIGO_FONDO_PENSION" class="java.lang.String"/>
	<field name="NIT_FONDO_PENSION" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_FONDO_PENSION" class="java.lang.String"/>
	<field name="ID_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="CODIGO_CAJA_COMP" class="java.lang.String"/>
	<field name="NIT_FONDO_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_CAJA_COMP" class="java.lang.String"/>
	<field name="ID_FONDO_ARL" class="java.math.BigDecimal"/>
	<field name="CODIGO_FONDO_ARL" class="java.lang.String"/>
	<field name="NIT_FONDO_ARL" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_FONDO_ARL" class="java.lang.String"/>
	<field name="TIPO_REGIMEN" class="java.lang.String"/>
	<field name="APLICA_IVA" class="java.math.BigDecimal"/>
	<field name="NUMERO" class="java.math.BigDecimal"/>
	<field name="NUMERO_PAGO" class="java.lang.String"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="DESCRIPCION_RIESGO" class="java.lang.String"/>
	<field name="VALOR_RIESGO" class="java.math.BigDecimal"/>
	<field name="CODIGO_RIESGO" class="java.lang.String"/>
	<field name="NIT_CIUDAD" class="java.lang.String"/>
	<field name="NOMBRE_CIUDAD" class="java.lang.String"/>
	<field name="TARIFA_ICA_CIUDAD" class="java.math.BigDecimal"/>
	<field name="BASE_DEVEG" class="java.math.BigDecimal"/>
	<field name="BASE_DEDUC" class="java.math.BigDecimal"/>
	<field name="TARIFA_ICA_EXTRA" class="java.math.BigDecimal"/>
	<field name="VIGENCIA" class="java.lang.String"/>
	<field name="VALOR_UVT" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_SUP" class="java.lang.String"/>
	<field name="RAZON_SOC_SUP" class="java.lang.String"/>
	<field name="CARGO_SUP" class="java.lang.String"/>
	<field name="NUM_DOC_APO" class="java.lang.String"/>
	<field name="RAZON_SOC_APO" class="java.lang.String"/>
	<field name="CARGO_APO" class="java.lang.String"/>
	<field name="FECHA_INI_DEDUCC" class="java.lang.String"/>
	<field name="FECHA_FIN_DEDUCC" class="java.lang.String"/>
	<field name="DIAS_DEDUCCION" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_DEDUCCION" class="java.lang.String"/>
	<field name="APLICA_RP_DOBLE" class="java.math.BigDecimal"/>
	<field name="RP_ANM_OLD" class="java.math.BigDecimal"/>
	<field name="RP_SGR_OLD" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_ANM_CONT" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_SGR_CONT" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_ANM_DOBLE" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_SGR_DOBLE" class="java.math.BigDecimal"/>
	<field name="VALOR_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="RP_DOBLE" class="java.lang.String"/>
	<field name="ID_DECLARA_JURA_NOV" class="java.math.BigDecimal"/>
	<field name="FECHA_CONSIGNA_AFC" class="java.sql.Timestamp"/>
	<field name="FECHA_CONSIGNA_VOLUN_PEN" class="java.sql.Timestamp"/>
	<field name="ANHO_GRAVABLE_INT_VIV" class="java.math.BigDecimal"/>
	<field name="ANHO_GRAVABLE_MEDICINA" class="java.math.BigDecimal"/>
	<field name="FECHA_DECLARA_JURA_NOV" class="java.sql.Timestamp"/>
	<field name="ID_TIPO_CONDICIONES" class="java.lang.String"/>
	<field name="TIPO_CONDICIONES" class="java.lang.String"/>
	<field name="DEPENDIENTE_DECLARA" class="java.math.BigDecimal"/>
	<field name="VALOR_APORTE_SOLIDARIO" class="java.math.BigDecimal"/>
	<field name="TEX_ANEXO_2020" class="java.lang.String"/>
	<field name="VALOR_OTRA_ENTIDAD" class="java.math.BigDecimal"/>
	<field name="BASE_APORTE_SOLIDARIO" class="java.math.BigDecimal"/>
	<field name="BASE_PROPORCION_APO_SOLID" class="java.math.BigDecimal"/>
	<field name="TARIFA_ESTAMPILLA" class="java.math.BigDecimal"/>
	<field name="VALOR_ESTAMPILLA" class="java.math.BigDecimal"/>
	<field name="VALOR_BASE_ESTAMPILLA" class="java.math.BigDecimal"/>
	<background>
		<band height="752" splitType="Stretch">
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1" && $F{REVISADO}.toString()=="0" && $F{AUTORIZADO}.toString()=="0" && $F{ESTADO}.toString()=="1" && $F{RADICADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmfirmado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1" && $F{REVISADO}.toString()=="1" && $F{AUTORIZADO}.toString()=="0" && $F{ESTADO}.toString()=="1" && $F{RADICADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmrevisado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1" && $F{REVISADO}.toString()=="1" && $F{AUTORIZADO}.toString()=="1" && $F{ESTADO}.toString()=="1" && $F{RADICADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmautorizado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmrechazado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{RADICADO}.toString()=="1" && $F{ESTADO}.toString()=="1" && $F{APROBADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmradicado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL}.toString()=="6" && $F{ESTADO}.toString()=="1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmaprobado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="98" y="130" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL}.toString()=="7" && $F{ESTADO}.toString()=="1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmpagado"]]></imageExpression>
			</image>
		</band>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="133" y="0" width="350" height="50"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[FORMATO PAGO CONTRATISTAS
VICEPRESIDENCIA ADMINISTRATIVA Y FINANCIERA
GRUPO DE RECURSOS FINANCIEROS]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="133" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<textField>
				<reportElement x="483" y="50" width="89" height="10"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Ciudad:" + $F{NOMBRE_CIUDAD}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="483" y="0" width="89" height="10"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{TIPO_RECURSO} == 0
    ? "Recurso: ANM"
    : $F{TIPO_RECURSO} == 1
        ? "Recurso: SGR"
        : "Recurso: COMPARTIDO"
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="483" y="10" width="89" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{NUMERO_RADICADO} != ""
    ? "DOCUMENTO EQUIVALENTE No." + $F{NUMERO_RADICADO}
    : "DOCUMENTO EQUIVALENTE No."
)]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="197" splitType="Stretch">
			<rectangle>
				<reportElement mode="Transparent" x="0" y="91" width="572" height="90"/>
			</rectangle>
			<textField>
				<reportElement mode="Transparent" x="0" y="76" width="572" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["DATOS DEL CONTRATO Y PERIODO ACTUAL DE PAGO"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="0" y="1" width="572" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["DATOS DEL CONTRATISTA"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="16" width="131" height="15"/>
				<box leftPadding="2">
					<leftPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Nombres y apellidos del contratista:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="31" width="131" height="15"/>
				<box leftPadding="2">
					<leftPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Correo electronico del contratista:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="46" width="131" height="15"/>
				<box leftPadding="2">
					<leftPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Tipo documento:]]></text>
			</staticText>
			<staticText>
				<reportElement x="352" y="46" width="109" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Tiene dependientes económicos?]]></text>
			</staticText>
			<staticText>
				<reportElement x="352" y="16" width="109" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Règimen del IVA:]]></text>
			</staticText>
			<staticText>
				<reportElement x="352" y="31" width="109" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Usted tiene dos o mas empleados?]]></text>
			</staticText>
			<staticText>
				<reportElement x="231" y="61" width="58" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Es Pensionado?]]></text>
			</staticText>
			<textField>
				<reportElement x="131" y="16" width="200" height="15"/>
				<box leftPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="131" y="31" width="200" height="15"/>
				<box leftPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CORREO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="131" y="46" width="100" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_DOC_CONTRA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="46" width="111" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{DEPENDIENTE} == 1
    ? "SI"
    : "NO"
)]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="289" y="61" width="63" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{PENSIONADO} == 1
    ? "SI"
    : "NO"
)]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="16" width="111" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_REGIMEN}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="31" width="111" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{MAS_EMPLEADOS} == 1
    ? "SI"
    : "NO"
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="91" width="76" height="15"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Contrato No.]]></text>
			</staticText>
			<staticText>
				<reportElement x="331" y="91" width="80" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Registro Presupuestal:]]></text>
			</staticText>
			<textField>
				<reportElement x="411" y="91" width="20" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="7" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["ANM"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="76" y="91" width="85" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_CONTRATO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="181" width="572" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["RESUMEN PAGOS GENERADOS EN EL PERIODO OBJETO DE PAGO"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="61" width="131" height="15"/>
				<box leftPadding="2">
					<leftPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Documento del contratista:]]></text>
			</staticText>
			<textField>
				<reportElement x="131" y="61" width="100" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="106" width="76" height="15"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Valor Contrato:]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="76" y="106" width="85" height="15"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="121" width="76" height="15"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Valor Bruto del Pago:]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="76" y="121" width="85" height="15"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_MENSUAL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="76" y="136" width="85" height="15"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_COMISIONES}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="136" width="76" height="15"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Valor Comisiones:]]></text>
			</staticText>
			<staticText>
				<reportElement x="331" y="121" width="80" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Número de Pago:]]></text>
			</staticText>
			<textField>
				<reportElement x="411" y="121" width="161" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_NUMERO_PAGO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd-MMM-yyyy">
				<reportElement x="411" y="136" width="161" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_INI_PAGO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="331" y="136" width="80" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Periodo de pago del:]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy">
				<reportElement x="411" y="151" width="161" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_FIN_PAGO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="331" y="151" width="80" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Periodo de pago al:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="76" width="131" height="15"/>
				<box leftPadding="2">
					<leftPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<textField>
				<reportElement x="411" y="106" width="20" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="7" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["SGR"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="431" y="91" width="110" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RP_ANM}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="541" y="91" width="30" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PORC_ANM_D}.toString()+"%"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="431" y="106" width="110" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RP_SGR}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="541" y="106" width="30" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PORC_SGR_D}.toString()+"%"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="151" width="76" height="15"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Valor Deducciones:]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
				<reportElement x="76" y="151" width="85" height="15"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_DEDUCCION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="161" y="121" width="24" height="15"/>
				<box leftPadding="2">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Dias:]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="185" y="121" width="19" height="15"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DIAS_DEDUCCION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="204" y="121" width="28" height="15"/>
				<box leftPadding="2">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Fecha:]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="232" y="121" width="100" height="15"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[($F{FECHA_INI_DEDUCC}==null
?" "
:$F{FECHA_INI_DEDUCC}.toString()+"-"+$F{FECHA_FIN_DEDUCC}.toString()
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="161" y="136" width="71" height="30"/>
				<box leftPadding="2">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Motivo:]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="232" y="136" width="100" height="30"/>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_DEDUCCION}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="61" width="111" height="15"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{DEPENDIENTE} == 1
    ? $F{TIPO_CONDICIONES}
    : ""
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="352" y="61" width="109" height="15"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Tipo dependientes económicos:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="166" width="76" height="15" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{VALOR_APORTE_SOLIDARIO} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Valor Otra Entidad:]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
				<reportElement x="76" y="166" width="85" height="15" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{VALOR_APORTE_SOLIDARIO} > 0]]></printWhenExpression>
				</reportElement>
				<box rightPadding="2">
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_OTRA_ENTIDAD}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="247">
			<rectangle>
				<reportElement mode="Transparent" x="300" y="219" width="272" height="28"/>
			</rectangle>
			<rectangle>
				<reportElement mode="Transparent" x="300" y="120" width="272" height="99"/>
			</rectangle>
			<rectangle>
				<reportElement mode="Transparent" x="0" y="120" width="271" height="127"/>
			</rectangle>
			<rectangle>
				<reportElement mode="Transparent" x="0" y="0" width="271" height="75"/>
			</rectangle>
			<rectangle>
				<reportElement mode="Transparent" x="301" y="0" width="271" height="75"/>
			</rectangle>
			<staticText>
				<reportElement x="302" y="9" width="150" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[Retención IVA 15%]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="161" y="60" width="110" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_A_PAGAR}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="161" y="45" width="110" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PAGAR}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="302" y="18" width="150" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[Retención ICA del periodo]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="452" y="27" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ICA_EXTRA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="452" y="0" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_RETENCION}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="161" y="0" width="110" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_INGRESOS}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="302" y="27" width="150" height="9"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Sobretasa Bomberil"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="45" width="151" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[TOTAL INGRESOS DEL PERIODO]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="452" y="18" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ICA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="60" width="151" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="SansSerif" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL A PAGAR]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="161" y="30" width="110" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ING_COMISIONES}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="452" y="9" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_IVA_REG}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="0" width="151" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Ingresos por honorarios]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="30" width="151" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Ingresos por comisiones]]></text>
			</staticText>
			<textField>
				<reportElement mode="Transparent" x="0" y="90" width="572" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["LIQUIDACIÓN DEDUCCIONES"]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="452" y="61" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{NUMERO_PLANILLA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="461" y="228" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_BASE_RETEN}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="302" y="61" width="150" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[No. Planilla PILA, o , No. Radicación pago SS]]></text>
			</staticText>
			<staticText>
				<reportElement x="301" y="228" width="160" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Valor Base retención en la fuente]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="461" y="120" width="110" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_SALUD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="461" y="144" width="110" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_FSP}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="461" y="132" width="110" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_PENSION}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="162" y="237" width="109" height="10"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_VOLUN_AFC}+$F{APORTE_VOLUN_PEN}+$F{VALOR_INTERESES_VIVIENDA}+$F{VALOR_DEPENDIENTES}+$F{VALOR_MEDICINA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="301" y="237" width="160" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Base retención ICA]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="237" width="161" height="10"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[SUBTOTAL DESCUENTO BASE NETA:]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="461" y="237" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_BASE_ICA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="210" y="136" width="60" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_VOLUN_PEN}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="210" y="128" width="60" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_VOLUN_AFC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1" y="144" width="160" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Intereses prestamo de Vivienda]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="128" width="160" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Aportes voluntarios a cuentas AFC]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="136" width="160" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Aporte voluntario a fondos de pensiones]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="210" y="144" width="60" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_INTERESES_VIVIENDA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="210" y="152" width="60" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_DEPENDIENTES}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1" y="152" width="160" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Dependientes hasta]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="210" y="160" width="60" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_MEDICINA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1" y="160" width="160" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Salud (Prepagada) hasta]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="15" width="151" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<text><![CDATA[Valor IVA]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="161" y="15" width="110" height="15"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_IVA}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="461" y="201" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["0"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="301" y="201" width="160" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[EMBARGO JUDICIALES (BANCO AGRARIO Nit: 800.837.800)]]></text>
			</staticText>
			<textField>
				<reportElement mode="Transparent" x="0" y="75" width="572" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TOTAL_A_PAGAR_TEXTO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="302" y="45" width="150" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[TOTAL RETENCIONES PRESENTE PAGO]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="452" y="45" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_TOTAL_RETEN}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="301" y="180" width="160" height="12">
					<printWhenExpression><![CDATA[$F{VALOR_ICA_EXTRA} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[Nit Municipio Beneficiario de la retencion por ICA y porcentaje de la tarifa]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="461" y="180" width="110" height="12">
					<printWhenExpression><![CDATA[$F{VALOR_ICA_EXTRA} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ICA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="105" width="271" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["DESCUENTO BASE NETA DE RETENCIONES"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="300" y="105" width="272" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["DESCUENTO APORTES SEGURIDAD SOCIAL Y OTROS"]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="461" y="168" width="110" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CAJA_COMP}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="301" y="120" width="160" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_FONDO_SALUD}+" - "+$F{RAZON_SOCIAL_FONDO_SALUD}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="301" y="132" width="160" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_FONDO_PENSION}+" - "+$F{RAZON_SOCIAL_FONDO_PENSION}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="301" y="144" width="160" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_FONDO_PENSION}+" - "+$F{RAZON_SOCIAL_FONDO_PENSION}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="301" y="168" width="160" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_FONDO_CAJA_COMP}+" - "+$F{RAZON_SOCIAL_CAJA_COMP}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="301" y="156" width="160" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_FONDO_ARL}+" - "+$F{RAZON_SOCIAL_FONDO_ARL}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="461" y="156" width="110" height="12"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_ARL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="302" y="54" width="260" height="7"/>
				<box leftPadding="3"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Ciudad o Municipio "+$F{NOMBRE_CIUDAD}+"     No. Nit "+$F{NIT_CIUDAD}+""]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="161" y="128" width="49" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_CONSIGNA_AFC}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="161" y="136" width="49" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_CONSIGNA_VOLUN_PEN}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="161" y="152" width="49" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{DEPENDIENTE_DECLARA}.toString()=="1"?$F{FECHA_DECLARA_JURA_NOV}:null]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="161" y="144" width="49" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ANHO_GRAVABLE_INT_VIV}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="161" y="160" width="49" height="8"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ANHO_GRAVABLE_MEDICINA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="301" y="192" width="160" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<text><![CDATA[Total descuentos aportes seguridad social]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="461" y="192" width="110" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_SALUD}+$F{APORTE_PENSION}+$F{APORTE_FSP}+$F{APORTE_ARL}+$F{VALOR_CAJA_COMP}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="120" width="161" height="8" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CONCEPTO"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="161" y="120" width="49" height="8" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["FECHA"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="210" y="120" width="61" height="8" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["VALOR"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="461" y="219" width="110" height="9" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{VALOR_APORTE_SOLIDARIO} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{BASE_PROPORCION_APO_SOLID}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="301" y="219" width="160" height="9" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{VALOR_APORTE_SOLIDARIO} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="6"/>
				</textElement>
				<text><![CDATA[Valor Base Aporte Covid-19]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)">
				<reportElement x="452" y="36" width="110" height="9" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{VALOR_APORTE_SOLIDARIO} > 0 || $F{VALOR_ESTAMPILLA} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_APORTE_SOLIDARIO} + $F{VALOR_ESTAMPILLA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="302" y="36" width="150" height="9" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{VALOR_APORTE_SOLIDARIO} > 0 || $F{VALOR_ESTAMPILLA} > 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{VALOR_APORTE_SOLIDARIO} > 0
    ? "Aporte Solidario Covid-19"
    : "Descuento Estampilla"
)]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="302" y="0" width="150" height="9"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA["Retención en la fuente del periodo. Tarifa: " +$F{TARIFA_RETEN}.toString()+ "%"]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="223">
			<rectangle>
				<reportElement mode="Transparent" x="-1" y="1" width="572" height="82"/>
			</rectangle>
			<image>
				<reportElement x="352" y="20" width="53" height="51">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:firma_general_anm_2020"]]></imageExpression>
			</image>
			<rectangle>
				<reportElement mode="Transparent" x="-1" y="98" width="572" height="125"/>
			</rectangle>
			<textField>
				<reportElement mode="Opaque" x="404" y="198" width="156" height="10" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Supervisor"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="404" y="137" width="156" height="10" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_APO}!=null?"Apoyo Supervisor":""]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="405" y="22" width="156" height="20" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[($F{FIRMADO}.toString()=="1"?"Firmado por: ":"")+$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="-1" y="11" width="353" height="72"/>
				<box topPadding="2" leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="Arial" size="7" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["1. Cumpli a cabalidad las actividades del objeto contractual arriba descritas. 2. Los documentos soporte suministrados contienen el pago de seguridad social en salud y pensión. Los aportes voluntarios a cuentas AFC y FVP. Correspondientes a los ingresos provenientes del contrato objeto del presente pago y certifico que no han sido utilizados en la disminución de la base de Retención en la fuente en ningún otro contrato. 3. Toda la información aquí suministrada es verídica. 4. He leido y entendido la descripción de cada uno de los campos aquí diligenciados." + $F{TEX_ANEXO_2020}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="1" width="352" height="10"/>
				<box>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7" isBold="false"/>
				</textElement>
				<text><![CDATA[PARA LOS EFECTOS LEGALES CERTIFICO, BAJO JURAMENTO, QUE: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="405" y="42" width="156" height="15"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7" isBold="false"/>
				</textElement>
				<text><![CDATA[Contratista]]></text>
			</staticText>
			<textField>
				<reportElement mode="Transparent" x="-1" y="83" width="572" height="15" forecolor="#000000"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CERTIFICACIÓN DEL SUPERVISOR DEL CONTRATO"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="352" y="163" width="220" height="6"/>
				<box>
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="351" y="98" width="220" height="10"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="-1" y="98" width="352" height="20"/>
				<box leftPadding="2">
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="7" isBold="false"/>
				</textElement>
				<text><![CDATA[En mi calidad de supervisor del contrato de prestación de servicios personales aquí relacionado, CERTIFICO:]]></text>
			</staticText>
			<image>
				<reportElement x="351" y="108" width="53" height="51">
					<printWhenExpression><![CDATA[$F{REVISADO}.toString()=="1"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:firma_general_anm_2020"]]></imageExpression>
			</image>
			<image>
				<reportElement x="351" y="169" width="53" height="51">
					<printWhenExpression><![CDATA[$F{AUTORIZADO}.toString()=="1"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:firma_general_anm_2020"]]></imageExpression>
			</image>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="404" y="117" width="156" height="20" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_APO}!=null?(($F{REVISADO}.toString()=="1"?"Revisado por: ":"")+$F{RAZON_SOC_APO}):null]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="404" y="178" width="156" height="20" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[($F{AUTORIZADO}.toString()=="1"?"Autorizado por: ":"")+$F{RAZON_SOC_SUP}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="118" width="351" height="105" forecolor="#000000"/>
				<box topPadding="2" leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="html">
					<font fontName="Arial" size="7" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["- Que el contratista cumplió a cabalidad las obligaciones contractuales pactadas."+"<br>"+
"- Que el contratista desarrolló las actividades descritas en el informe de actividades adjunto, dentro del periodo de cobro."+"<br>"+
($F{APLICA_PLANILLA_APORTES}.toString()=="1"?
    "- Que he verificado el pago de los aportes obligatorios al Sistema de Seguridad Social realizados por el contratista por medio de la planilla relacionada en el presente informe y que los mismos han sido liquidados de conformidad con las normas vigentes."+"<br>"
    :"- Yo "+$F{RAZON_SOCIAL}+", identificado con la Cédula de Ciudadanía No "+$F{NUM_DOC}+", de manera voluntaria autorizo para que la Agencia Nacional de Minería realice el descuento de los aportes a la seguridad social de mis honorarios mensuales, y que los mismos sean trasladados a los fondos informados en el presente formato, mediante planilla tipo “Y”, cotizante 59 - Independiente con Contrato de Prestación de servicios superior a un mes. "+"<br>"
)]]></textFieldExpression>
			</textField>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="20" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="352" height="10" forecolor="#575757" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[false]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{NUMERO_RADICADO} != ""
    ? "No. Radicado: "+$F{NUMERO_RADICADO}+" - fecha Radicado: "+$F{FECHA_RADICADO}+" - fecha de aprobación: "+$F{FECHA_APROBADO}+""
    : ""
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="10" width="352" height="10" isRemoveLineWhenBlank="true" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( !$F{RESOLUCION}.isEmpty()
    ? "Resoluciones de comisión: " + $F{RESOLUCION}
    : ""
)]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="572" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
