<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad  -->
<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="notaPago" pageWidth="245" pageHeight="380" columnWidth="200" leftMargin="10" rightMargin="35" topMargin="20" bottomMargin="10" uuid="6eb66b6b-9a20-4723-a05c-9f52ec31a413">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="rosa"/>
	<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="656"/>
	<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="330"/>
	<parameter name="P1" class="java.lang.Integer">
		<parameterDescription><![CDATA[Id de titulo]]></parameterDescription>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT
	p_dp.fecha_pago,
	p_dp.derecho_Propietario,
	CONCAT( s.apellido_Paterno, ' ', s.apellido_Materno, ' ', s.nombres, ' con C.I. :', s.ci ) AS Pagado,
	p_dp.id_Pago,
	es.nombre AS estado_Pago,
	
	
	dp.total_bs,
	
	
	
	CONCAT(
		UCASE(
		LEFT ( lower ( dp.total_bs_literal ), 1 )),
	SUBSTRING( lower ( dp.total_bs_literal), 2 )) AS total_bs_literal,
	
	

	dp.nro_Acciones,
	a.alias,
	ta.nombre AS tipo_socio,
	
	
	
	
	
	
	
	CONCAT(
		UCASE(
		LEFT ( lower ( aux.nombre), 1 )),
	SUBSTRING( lower ( aux.nombre), 2 )) AS tipo_pago,
	
	
	
	
	CONCAT(
		'Sacaba ',
		DAY ( p_dp.fecha_pago ),
		' de ',
	CASE
			MONTH ( p_dp.fecha_pago ) 
			WHEN 1 THEN
			'Enero' 
			WHEN 2 THEN
			'Febrero' 
			WHEN 3 THEN
			'Marzo' 
			WHEN 4 THEN
			'Abril' 
			WHEN 5 THEN
			'Mayo' 
			WHEN 6 THEN
			'Junio' 
			WHEN 7 THEN
			'Julio' 
			WHEN 8 THEN
			'Agosto' 
			WHEN 9 THEN
			'Septiembre' 
			WHEN 10 THEN
			'Octubre' 
			WHEN 11 THEN
			'Noviembre' 
			WHEN 12 THEN
			'Diciembre' 
		END,
		' del ',
		YEAR ( p_dp.fecha_pago ) 
	) AS fecha_pago_literal 
FROM
	pago_dp AS p_dp
	INNER JOIN socio AS s ON p_dp.accionista = s.id_Socio
	INNER JOIN aux AS es ON p_dp.estado = es.id_aux
	INNER JOIN derecho_propietario AS dp ON p_dp.derecho_Propietario = dp.id_derecho_Propietario
	INNER JOIN aux AS a ON s.ci_procedencia = a.id_aux
	INNER JOIN aux AS ta ON s.tipo_accionista = ta.id_aux
	INNER JOIN aux ON p_dp.tipo_pago = aux.id_aux

	where 	p_dp.id_Pago = $P{P1}]]>
	</queryString>
	<field name="fecha_pago" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.name" value="fecha_Pago"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="derecho_Propietario" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="derecho_Propietario"/>
		<property name="com.jaspersoft.studio.field.label" value="derecho_Propietario"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="Pagado" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="Pagado"/>
		<property name="com.jaspersoft.studio.field.label" value="Pagado"/>
	</field>
	<field name="id_Pago" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="id_Pago"/>
		<property name="com.jaspersoft.studio.field.label" value="id_Pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="estado_Pago" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="estado_Pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="total_bs" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="total_bs"/>
		<property name="com.jaspersoft.studio.field.label" value="total_bs"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="total_bs_literal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="total_bs_literal"/>
		<property name="com.jaspersoft.studio.field.label" value="total_bs_literal"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="nro_Acciones" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="nro_Acciones"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Acciones"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="alias" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="alias"/>
		<property name="com.jaspersoft.studio.field.label" value="alias"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="tipo_socio" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="tipo_socio"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="tipo_pago" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="tipo_pago"/>
		<property name="com.jaspersoft.studio.field.label" value="tipo_pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="fecha_pago_literal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="fecha_pago_literal"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_pago_literal"/>
	</field>
	<pageHeader>
		<band height="350" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField pattern="#,000.###;(#,000.###-)">
				<reportElement x="0" y="50" width="200" height="21" forecolor="#F52C16" uuid="c9ea00d2-927f-413d-9ae6-aea85d4d4839">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA["RECIBO N° " +$F{id_Pago}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="201" width="200" height="15" uuid="7c9271f1-13aa-485d-9e2b-cace0185bdb6">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{fecha_pago_literal}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="262" width="200" height="15" uuid="112af00c-9c15-4a91-8dd7-1121ecf729c8">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[ENTREGUE CONFORME]]></text>
			</staticText>
			<line>
				<reportElement x="24" y="261" width="151" height="1" uuid="9efb0aab-864e-4204-beb2-72ed302dd27f">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="0" y="314" width="200" height="15" uuid="ebecc0d4-2254-4d96-a125-34940c310d3c">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[RECIBI CONFORME]]></text>
			</staticText>
			<line>
				<reportElement x="24" y="313" width="151" height="1" uuid="554e796c-f981-4fdc-ab8c-89cadd5a454a">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<textField textAdjust="StretchHeight">
				<reportElement x="70" y="95" width="128" height="25" uuid="4d9e2347-4362-435e-ba2f-8758ca3dd39d">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="9"/>
					<paragraph lineSpacing="Single" lineSpacingSize="0.0"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Pagado}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="30" width="180" height="10" uuid="50b676c1-377d-43b8-8884-6e0584ac6e90">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[TELF. 4703288-4703398]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="40" width="180" height="10" uuid="d22aeb0c-ec4e-437f-8082-1602635423ef">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[SACABA - COCHABAMBA - BOLIVIA]]></text>
			</staticText>
			<textField pattern="d/M/yyyy  h:mm a">
				<reportElement x="89" y="334" width="111" height="15" uuid="8074e08b-1147-45b3-a683-36d10ffe2098">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="334" width="89" height="15" uuid="f20cf21f-11c2-4843-ba17-a3b8669bf8c2">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[Impreso el: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="0" width="180" height="10" uuid="8c7850e1-e71e-4d50-b90e-93d190e605b8">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[E°S°  TRANS ROSA DE LIMA S.A.]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="10" width="180" height="20" uuid="5619d2e6-6b47-4b3c-ae6d-378c9415d1cb">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[AV. BARRIENTOS S/N  KM 16 ZONA VILLA OBRA OBRAJES]]></text>
			</staticText>
			<textField pattern="#,##0.00#;(#,##0.00#-)">
				<reportElement x="147" y="76" width="50" height="13" uuid="e48e8c35-daf8-4f5e-8085-97fb7d56499e">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total_bs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="70" y="123" width="128" height="25" uuid="98cf166c-3437-44c8-af56-2f5b5b90eff8">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total_bs_literal}+" Bolivianos"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="70" y="152" width="128" height="25" uuid="8dacd67a-9e02-41f4-8e05-090dbdea5dcb">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA["Pago de dividendos gestion 2021 de "+$F{nro_Acciones} +" acciones"]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight">
				<reportElement x="70" y="182" width="128" height="12" uuid="a7a9b13d-92ce-480a-ae5f-f14f1a802198">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tipo_pago}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="17" y="95" width="52" height="12" uuid="ed034f58-3a98-4dd1-9157-69a2b8cd832b">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[Pagado a:]]></text>
			</staticText>
			<staticText>
				<reportElement x="17" y="123" width="52" height="12" uuid="b8644e74-acf1-4a61-a7a0-77f04e1acffe">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[La suma de:]]></text>
			</staticText>
			<staticText>
				<reportElement x="17" y="152" width="52" height="12" uuid="3d70d7d0-931b-4d45-85bf-318251ad3f62">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[Concepto:]]></text>
			</staticText>
			<staticText>
				<reportElement x="17" y="182" width="52" height="12" uuid="4af42dbc-9626-4c5c-808a-8d8db9caad96">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[Pago en:]]></text>
			</staticText>
			<staticText>
				<reportElement x="97" y="76" width="50" height="13" uuid="67ae690d-275c-470c-baed-9d2c7b939986">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[Bs.-  ]]></text>
			</staticText>
		</band>
	</pageHeader>
</jasperReport>
