<?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="documento_soporte_2021" language="groovy" pageWidth="612" pageHeight="792" 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="33"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/documento_soporte"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="id_formato_pago" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="numero_letras" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_pago_obl_form_pago" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select distinct


'Resolución DIAN' as res,
(select
REPLACE(
to_char(wm_concat(distinct case when habilitacion = 1 then 'Habilitación' else 'Autorización' end ||
' No ' || resolucion_numero ||' Rango del ' || prefijo || ' ' ||
numero_ini || ' a ' || prefijo || ' ' || numero_fin  || ' '
|| case when habilitacion = 1 then fecha_inicio||'-'||fecha_fin else'' end))
,',',' <br> ') as resol
from(
    select
    id,
    descripcion,
    resolucion_numero,
    to_char(fecha_inicio,'dd/mm/yyyy') as fecha_inicio,
    to_char(fecha_fin,'dd/mm/yyyy') as fecha_fin,
    numero_ini,
    numero_fin,
    numero_actual,
    prefijo,
    id_modulo,
    id_caja_menor,
    habilitacion,
    id_origen
    from RESOL_NUMERACION_DIAN
    where
    DESCRIPCION = 'DOCUMENTO SOPORTE RVC'
    and (habilitacion = 0 or sysdate between fecha_inicio and fecha_fin)

    order by
    id
)) as text_resol,

(SELECT max(nombre_empresa) FROM datos_compania where id = 1) as nombre_empresa,
tab0.*,
--Datos Formato
to_char(tab1.fecha_ini_pago,'dd/mm/yyyy') as Fecha_ini_pago_texto,
to_char(tab1.fecha_fin_pago,'dd/mm/yyyy') as Fecha_fin_pago_texto,
tab1.numero_radicado,
tab1.id_numero_pago,
tab1.valor_pagar,
tab1.valor_a_pagar,
tab1.valor_retencion,
tab1.valor_ica,
tab1.valor_ica_extra,
NUMERO_A_TEXTO(tab1.valor_a_pagar) as TOTAL_TEXTO,
-- Datos Contratista
tab2.num_doc,
tab2.razon_social,
tab2.correo,
tab2.telefono,
tab2.direccion,
tab2.departamento,
tab2.municipio,
--Datos Contrato
tab3.num_contrato,
--Datos Resolucion
tab4.descripcion as descripcion_resolucion,
tab4.resolucion_numero,
to_char(tab4.fecha_inicio,'dd/mm/yyyy') as Fecha_inicio_texto,
to_char(tab4.fecha_fin,'dd/mm/yyyy') as Fecha_fin_texto,
tab4.numero_ini as numero_ini_resolucion,
tab4.numero_fin as numero_fin_resolucion,
tab4.prefijo as prefijo_resolucion,

pago.fecha_proc as fecha_pago

from RVC_PAGO_OBL_FORM_PAGO tab0
left join RVC_FORMATO_PAGO tab1 on tab1.id_formato_pago = tab0.id_formato_pago
left join rvc_contratista_v tab2 on tab2.id_contratista=tab1.id_contratista
left join rvc_contrato tab3 on tab3.id_contrato = tab1.id_contrato

--left join ts_pago_obl pago on pago.id_pago_obl = tab0.id_pago_obl
--left join ts_emision_pago emi on emi.id_emision_pago = pago.id_emision_pago
LEFT JOIN (

        select
        0 as sgr,
        tab8.fecha_proc,
        tab6.*
        from TS_PAGO_OBL tab6
        LEFT JOIN TS_EMISION_PAGO tab8 on tab8.id_emision_pago = tab6.id_emision_pago

        union

        select
        1 as sgr,
        tab8.fecha_proc,
        tab6.*
        from erp_sgr.TS_PAGO_OBL tab6
        LEFT JOIN erp_sgr.TS_EMISION_PAGO tab8 on tab8.id_emision_pago = tab6.id_emision_pago

    )pago
    on pago.ID_PAGO_OBL = tab0.ID_PAGO_OBL
    and pago.sgr = tab0.sgr

left join resol_numeracion_dian tab4 on tab4.descripcion = 'DOCUMENTO SOPORTE RVC' and trunc(pago.fecha_proc) between tab4.fecha_inicio and tab4.fecha_fin

where
tab0.id_pago_obl_form_pago = $P{id_pago_obl_form_pago}]]>
	</queryString>
	<field name="RES" class="java.lang.String"/>
	<field name="TEXT_RESOL" class="java.lang.String"/>
	<field name="NOMBRE_EMPRESA" class="java.lang.String"/>
	<field name="ID_PAGO_OBL_FORM_PAGO" class="java.math.BigDecimal"/>
	<field name="ID_FORMATO_PAGO" class="java.math.BigDecimal"/>
	<field name="ID_PAGO_OBL" class="java.math.BigDecimal"/>
	<field name="SGR" class="java.math.BigDecimal"/>
	<field name="DOCUMENTO_SOPORTE" class="java.math.BigDecimal"/>
	<field name="GENERADO" class="java.math.BigDecimal"/>
	<field name="FECHA_GENERADO" class="java.sql.Timestamp"/>
	<field name="ADJUNTO" class="java.lang.String"/>
	<field name="FECHA_INI_PAGO_TEXTO" class="java.lang.String"/>
	<field name="FECHA_FIN_PAGO_TEXTO" class="java.lang.String"/>
	<field name="NUMERO_RADICADO" class="java.math.BigDecimal"/>
	<field name="ID_NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="VALOR_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_A_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_RETENCION" class="java.math.BigDecimal"/>
	<field name="VALOR_ICA" class="java.math.BigDecimal"/>
	<field name="VALOR_ICA_EXTRA" class="java.math.BigDecimal"/>
	<field name="TOTAL_TEXTO" class="java.lang.String"/>
	<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="TELEFONO" class="java.lang.String"/>
	<field name="DIRECCION" class="java.lang.String"/>
	<field name="DEPARTAMENTO" class="java.lang.String"/>
	<field name="MUNICIPIO" class="java.lang.String"/>
	<field name="NUM_CONTRATO" class="java.lang.String"/>
	<field name="DESCRIPCION_RESOLUCION" class="java.lang.String"/>
	<field name="RESOLUCION_NUMERO" class="java.lang.String"/>
	<field name="FECHA_INICIO_TEXTO" class="java.lang.String"/>
	<field name="FECHA_FIN_TEXTO" class="java.lang.String"/>
	<field name="NUMERO_INI_RESOLUCION" class="java.math.BigDecimal"/>
	<field name="NUMERO_FIN_RESOLUCION" class="java.math.BigDecimal"/>
	<field name="PREFIJO_RESOLUCION" class="java.lang.String"/>
	<field name="FECHA_PAGO" class="java.sql.Timestamp"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<columnHeader>
		<band height="246" splitType="Stretch">
			<staticText>
				<reportElement mode="Transparent" x="0" y="220" width="357" height="26" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DETALLE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="457" y="220" width="115" height="26" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="357" y="220" width="30" height="26" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CANT.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="387" y="220" width="70" height="26" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[SUB TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="0" width="572" height="133"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="387" y="133" width="185" height="87"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="446" y="161" width="110" height="23" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MUNICIPIO} + " - " + $F{DEPARTAMENTO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="75" y="161" width="119" height="12"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="154" y="0" width="402" height="35"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[DOCUMENTO SOPORTE EN ADQUISICIONES EFECTUADAS
A NO OBLIGADOS A FACTURAR]]></text>
			</staticText>
			<textField>
				<reportElement x="75" y="149" width="312" height="12"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="446" y="186" width="110" height="12" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TELEFONO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="396" y="161" width="50" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Ciudad: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="161" width="65" height="12"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[NIT / C.C:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="75" y="174" width="312" height="12" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIRECCION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="149" width="65" height="12"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Señores:]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="396" y="186" width="50" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Telefono: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="174" width="65" height="12" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{DIRECCION}!=null]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Direccion:]]></text>
			</staticText>
			<staticText>
				<reportElement x="387" y="74" width="85" height="30"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[DOCUMENTO SOPORTE No.]]></text>
			</staticText>
			<textField>
				<reportElement x="472" y="74" width="84" height="30"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PREFIJO_RESOLUCION} + " " + $F{DOCUMENTO_SOPORTE}.toString()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="396" y="147" width="50" height="14"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha:]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="446" y="147" width="110" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_PAGO}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="6" y="6" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="10" y="186" width="65" height="12"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Email:]]></text>
			</staticText>
			<textField>
				<reportElement x="75" y="186" width="119" height="12"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CORREO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="133" width="387" height="87"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField>
				<reportElement x="6" y="46" width="148" height="25"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["NIT 900.500.018-2\n"+
"Calle 26 No. 59-51 Torre 4 Pisos(8,9 y 10)\n"+
"Tel: (571) 220 19 19\n"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="10" y="79" width="350" height="15"/>
				<box leftPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RES}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="10" y="94" width="350" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" markup="html">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TEXT_RESOL}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="219" splitType="Stretch">
			<rectangle>
				<reportElement stretchType="RelativeToTallestObject" x="457" y="0" width="115" height="125"/>
			</rectangle>
			<rectangle>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="457" height="125"/>
			</rectangle>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="457" y="0" width="15" height="125" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\$"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="357" height="125"/>
				<box topPadding="5" leftPadding="2" bottomPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" markup="none">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Formato de Pago por concepto de pago de "+$F{FECHA_INI_PAGO_TEXTO}+" al "+$F{FECHA_FIN_PAGO_TEXTO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="472" y="0" width="100" height="125"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PAGAR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="357" y="0" width="30" height="125"/>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[1]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="387" y="0" width="70" height="125"/>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PAGAR}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="457" y="149" width="15" height="12" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\$"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="357" y="137" width="100" height="12"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[RETEFUENTE]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="185" width="100" height="34"/>
				<box topPadding="1" leftPadding="1" bottomPadding="1">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[OBSERVACIONES:]]></text>
			</staticText>
			<staticText>
				<reportElement x="357" y="125" width="100" height="12"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[SUBTOTAL]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="100" y="185" width="472" height="34"/>
				<box topPadding="1" leftPadding="1">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA["Radicado No. "+$F{NUMERO_RADICADO}.toString()+", Formato de Pago No. "+$F{ID_NUMERO_PAGO}.toString()+" del contrato "+$F{NUM_CONTRATO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="125" width="29" height="60"/>
				<box topPadding="1" leftPadding="1" bottomPadding="1">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[SON:]]></text>
			</staticText>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="472" y="149" width="100" height="12" backcolor="#D2D0D0"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ICA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="472" y="125" width="100" height="12" backcolor="#D2D0D0"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PAGAR}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="457" y="173" width="15" height="12" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\$"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="357" y="173" width="100" height="12"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[NETO A PAGAR]]></text>
			</staticText>
			<textField>
				<reportElement mode="Opaque" x="457" y="125" width="15" height="12" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\$"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="29" y="125" width="328" height="60"/>
				<box topPadding="1" leftPadding="1">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement>
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TOTAL_TEXTO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="457" y="137" width="15" height="12" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\$"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="472" y="137" width="100" height="12" backcolor="#D2D0D0"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_RETENCION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="357" y="149" width="100" height="12"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[RETE ICA]]></text>
			</staticText>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="472" y="173" width="100" height="12" backcolor="#D2D0D0"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_A_PAGAR}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="357" y="161" width="100" height="12"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[SOBRETASA BOMBERIL]]></text>
			</staticText>
			<textField>
				<reportElement mode="Opaque" x="457" y="161" width="15" height="12" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\$"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="472" y="161" width="100" height="12" backcolor="#D2D0D0"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ICA_EXTRA}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="44" splitType="Stretch">
			<staticText>
				<reportElement x="146" y="17" width="98" height="12"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[ELABORADO POR:]]></text>
			</staticText>
			<textField>
				<reportElement x="244" y="17" width="213" height="12"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_EMPRESA}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<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>
