btnmw-was-app/REKON/template/PrimaWithdrawalMatch.jrxml

<?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="PrimaWithdrawalMatch" language="groovy" pageWidth="2520" pageHeight="1190" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="2520" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="1242"/>
	<property name="ireport.y" value="0"/>
	<parameter name="START_DATE" class="java.util.Date">
		<defaultValueExpression><![CDATA[new java.util.Date()]]></defaultValueExpression>
	</parameter>
	<parameter name="END_DATE" class="java.util.Date">
		<defaultValueExpression><![CDATA[new Date()]]></defaultValueExpression>
	</parameter>
	<parameter name="STR_DATE" class="java.util.Date" isForPrompting="false">
		<defaultValueExpression><![CDATA[new java.util.Date($P{START_DATE}.getTime() - 24*60*60*1000)]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT * FROM (SELECT DATE(A01)CORE01,(A02)CORE02,(A03)CORE03,(A06)CORE06,(A07)CORE07,(A14)CORE14,(A15)CORE15,
(A16)CORE16, (A21)CORE21,(A22)CORE22 FROM MWTEMP.TEMPTABLE WHERE A03 IN ('5130','5131') AND A22 = 'BTN_PRIMA'
AND ((A01 = $P{STR_DATE} and substr(A02,1,2) >= '23') OR (A01 = $P{END_DATE} and substr(A02,1,2) < '23')))
AS CORE FULL JOIN (SELECT DATE(A01)PRIMA01,(A02)PRIMA02,(A03)PRIMA03,(A04)PRIMA04,(A05)PRIMA05,(A06)PRIMA06,
(A07)PRIMA07,(A08)PRIMA08,(A09)PRIMA09, (A10)PRIMA10, (A11)PRIMA11, (A12)PRIMA12, (A14)PRIMA14,
(A15)PRIMA15,(A16)PRIMA16,(A17)PRIMA17,(A22)PRIMA22  FROM MWTEMP.TEMPTABLE WHERE A22 LIKE $P{START_DATE}||'_PRIMA_R1' AND ((A01 = $P{STR_DATE} and substr(A02,1,2) >= '23') OR
(A01 = $P{END_DATE} and substr(A02,1,2) < '23'))) AS PRIMA ON CORE.CORE01 = PRIMA.PRIMA01
AND CORE.CORE02 = PRIMA.PRIMA02 AND CORE.CORE14= PRIMA.PRIMA14
WHERE ((PRIMA.PRIMA17 = 'BERHASIL' AND CORE.CORE14 IS NOT NULL)) AND CORE.CORE03 NOT IN('5132','5133')
ORDER BY CORE.CORE01]]>
	</queryString>
	<field name="CORE01" class="java.sql.Date"/>
	<field name="CORE02" class="java.lang.String"/>
	<field name="CORE03" class="java.lang.String"/>
	<field name="CORE06" class="java.lang.String"/>
	<field name="CORE07" class="java.lang.String"/>
	<field name="CORE14" class="java.lang.String"/>
	<field name="CORE15" class="java.lang.String"/>
	<field name="CORE16" class="java.lang.String"/>
	<field name="CORE21" class="java.lang.String"/>
	<field name="CORE22" class="java.lang.String"/>
	<field name="PRIMA01" class="java.sql.Date"/>
	<field name="PRIMA02" class="java.lang.String"/>
	<field name="PRIMA03" class="java.lang.String"/>
	<field name="PRIMA04" class="java.lang.String"/>
	<field name="PRIMA05" class="java.lang.String"/>
	<field name="PRIMA06" class="java.lang.String"/>
	<field name="PRIMA07" class="java.lang.String"/>
	<field name="PRIMA08" class="java.lang.String"/>
	<field name="PRIMA09" class="java.lang.String"/>
	<field name="PRIMA10" class="java.lang.String"/>
	<field name="PRIMA11" class="java.lang.String"/>
	<field name="PRIMA12" class="java.lang.String"/>
	<field name="PRIMA14" class="java.lang.String"/>
	<field name="PRIMA15" class="java.lang.String"/>
	<field name="PRIMA16" class="java.lang.String"/>
	<field name="PRIMA17" class="java.lang.String"/>
	<field name="PRIMA22" class="java.lang.String"/>
	<variable name="COUNT" class="java.lang.Integer" resetType="Group" resetGroup="STATUS" incrementType="Column">
		<variableExpression><![CDATA[$V{COUNT}+1]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="STATUS_DESC" class="java.lang.String" resetType="Group" resetGroup="STATUS">
		<variableExpression><![CDATA["Prima approve and Core approve"]]></variableExpression>
		<initialValueExpression><![CDATA["Prima approve and Core approve"]]></initialValueExpression>
	</variable>
	<variable name="SUM_CORE" class="java.math.BigDecimal" resetType="Group" resetGroup="STATUS" calculation="Sum">
		<variableExpression><![CDATA[$F{CORE06}==null?java.math.BigDecimal.ZERO:new java.math.BigDecimal($F{CORE06})]]></variableExpression>
		<initialValueExpression><![CDATA[BigDecimal.ZERO]]></initialValueExpression>
	</variable>
	<variable name="SUM_PRIMA" class="java.math.BigDecimal" resetType="Group" resetGroup="STATUS" calculation="Sum">
		<variableExpression><![CDATA[$F{PRIMA06}==null?java.math.BigDecimal.ZERO:new BigDecimal(NumberFormat.getNumberInstance(new Locale("en")).parse($F{PRIMA06}))]]></variableExpression>
		<initialValueExpression><![CDATA[BigDecimal.ZERO]]></initialValueExpression>
	</variable>
	<variable name="ZERO_APPEND" class="java.lang.String">
		<variableExpression><![CDATA["0000000000000000"]]></variableExpression>
		<initialValueExpression><![CDATA[""]]></initialValueExpression>
	</variable>
	<variable name="TEMP" class="java.lang.String">
		<variableExpression><![CDATA[($V{ZERO_APPEND}.concat($F{CORE16})).substring(($V{ZERO_APPEND}.concat($F{CORE16})).length()-16,($V{ZERO_APPEND}.concat($F{CORE16})).length())]]></variableExpression>
		<initialValueExpression><![CDATA[""]]></initialValueExpression>
	</variable>
	<variable name="SOURCE" class="java.lang.String">
		<variableExpression><![CDATA[new SimpleDateFormat("yyMMdd").format(new SimpleDateFormat("yyyy-MM-dd").parse($F{PRIMA22}.substring(0, $F{PRIMA22}.indexOf("_PRIMA_"))))+$F{PRIMA22}.substring( $F{PRIMA22}.lastIndexOf("_")+1)+".TXT"]]></variableExpression>
	</variable>
	<group name="STATUS">
		<groupExpression><![CDATA[$F{PRIMA11}]]></groupExpression>
		<groupHeader>
			<band height="80">
				<staticText>
					<reportElement x="0" y="60" width="37" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[No]]></text>
				</staticText>
				<staticText>
					<reportElement x="37" y="60" width="90" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Date]]></text>
				</staticText>
				<staticText>
					<reportElement x="127" y="60" width="87" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Time]]></text>
				</staticText>
				<staticText>
					<reportElement x="214" y="60" width="128" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Reff]]></text>
				</staticText>
				<staticText>
					<reportElement x="342" y="60" width="143" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Amount]]></text>
				</staticText>
				<staticText>
					<reportElement x="485" y="60" width="70" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Trans Code]]></text>
				</staticText>
				<staticText>
					<reportElement x="555" y="60" width="130" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Account No]]></text>
				</staticText>
				<staticText>
					<reportElement x="815" y="60" width="117" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Term-ID]]></text>
				</staticText>
				<staticText>
					<reportElement x="1022" y="60" width="87" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Time]]></text>
				</staticText>
				<staticText>
					<reportElement x="932" y="60" width="90" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Date]]></text>
				</staticText>
				<staticText>
					<reportElement x="1398" y="60" width="143" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Amount]]></text>
				</staticText>
				<staticText>
					<reportElement x="1109" y="60" width="161" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Card No]]></text>
				</staticText>
				<staticText>
					<reportElement x="1270" y="60" width="128" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Reff]]></text>
				</staticText>
				<staticText>
					<reportElement x="1757" y="60" width="79" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[STS]]></text>
				</staticText>
				<staticText>
					<reportElement x="1836" y="60" width="48" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[err_code]]></text>
				</staticText>
				<staticText>
					<reportElement x="2139" y="60" width="120" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Location]]></text>
				</staticText>
				<staticText>
					<reportElement x="2259" y="60" width="117" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Term-ID]]></text>
				</staticText>
				<staticText>
					<reportElement x="932" y="40" width="1588" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[PRIMA]]></text>
				</staticText>
				<staticText>
					<reportElement x="0" y="40" width="932" height="20"/>
					<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"/>
					<text><![CDATA[CORE BTN]]></text>
				</staticText>
				<staticText>
					<reportElement x="0" y="0" width="90" height="20"/>
					<box leftPadding="3">
						<topPen lineWidth="1.0" lineStyle="Solid"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0" lineStyle="Solid"/>
						<rightPen lineWidth="0.0" lineStyle="Solid"/>
					</box>
					<textElement/>
					<text><![CDATA[Status    :]]></text>
				</staticText>
				<textField>
					<reportElement x="90" y="0" width="2430" height="20"/>
					<box leftPadding="3">
						<topPen lineWidth="1.0" lineStyle="Solid"/>
						<leftPen lineWidth="0.0" lineStyle="Solid"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0" lineStyle="Solid"/>
					</box>
					<textElement/>
					<textFieldExpression class="java.lang.String"><![CDATA[$V{STATUS_DESC}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="685" y="60" width="130" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Rekening To]]></text>
				</staticText>
				<staticText>
					<reportElement x="2044" y="60" width="95" height="20"/>
					<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"/>
					<text><![CDATA[Trace-No]]></text>
				</staticText>
				<staticText>
					<reportElement x="1954" y="60" width="90" height="20"/>
					<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"/>
					<text><![CDATA[ Auth-Resp]]></text>
				</staticText>
				<staticText>
					<reportElement x="1884" y="60" width="70" height="20"/>
					<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"/>
					<text><![CDATA[RT-CD]]></text>
				</staticText>
				<staticText>
					<reportElement x="0" y="20" width="90" height="20"/>
					<box leftPadding="3">
						<topPen lineWidth="1.0" lineStyle="Solid"/>
						<leftPen lineWidth="1.0" lineStyle="Solid"/>
						<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					</box>
					<textElement/>
					<text><![CDATA[Periode :]]></text>
				</staticText>
				<textField pattern="dd-MM-yyyy">
					<reportElement x="90" y="20" width="71" height="20"/>
					<box leftPadding="3" rightPadding="3"/>
					<textElement/>
					<textFieldExpression class="java.util.Date"><![CDATA[$P{START_DATE}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="161" y="20" width="14" height="20"/>
					<box leftPadding="3"/>
					<textElement/>
					<text><![CDATA[to]]></text>
				</staticText>
				<textField pattern="dd-MM-yyyy">
					<reportElement x="175" y="20" width="2345" height="20"/>
					<box leftPadding="3">
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement/>
					<textFieldExpression class="java.util.Date"><![CDATA[$P{END_DATE}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="1617" y="60" width="140" height="20"/>
					<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"/>
					<text><![CDATA[Comp-amount]]></text>
				</staticText>
				<staticText>
					<reportElement x="1541" y="60" width="76" height="20"/>
					<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"/>
					<text><![CDATA[Type]]></text>
				</staticText>
				<staticText>
					<reportElement x="2376" y="60" width="144" height="20"/>
					<box>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Source]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="21">
				<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="false">
					<reportElement x="342" y="1" width="143" height="20"/>
					<box rightPadding="3"/>
					<textElement textAlignment="Right"/>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_CORE}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00">
					<reportElement x="1399" y="1" width="142" height="20"/>
					<box rightPadding="3"/>
					<textElement textAlignment="Right"/>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_PRIMA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="214" y="1" width="128" height="20"/>
					<box rightPadding="2"/>
					<textElement textAlignment="Right"/>
					<text><![CDATA[Rp.]]></text>
				</staticText>
				<staticText>
					<reportElement x="37" y="1" width="177" height="20"/>
					<textElement/>
					<text><![CDATA[Total Nominal]]></text>
				</staticText>
				<staticText>
					<reportElement x="1270" y="1" width="128" height="20"/>
					<textElement textAlignment="Right"/>
					<text><![CDATA[Rp.]]></text>
				</staticText>
				<line>
					<reportElement x="0" y="0" width="2520" height="1"/>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="30" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="2520" height="30"/>
				<textElement textAlignment="Center">
					<font size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[PRIMA WITHDRAWAL MATCH]]></text>
			</staticText>
		</band>
	</title>
	<detail>
		<band height="20" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement x="37" y="0" width="90" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{CORE01}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="127" y="0" width="87" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CORE02}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="214" y="0" width="128" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CORE14}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="342" y="0" width="143" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[new BigDecimal($F{CORE06})]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="485" y="0" width="70" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CORE03}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="555" y="0" width="130" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{TEMP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="815" y="0" width="117" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CORE15}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement x="932" y="0" width="90" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{PRIMA01}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1022" y="0" width="87" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA02}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1109" y="0" width="161" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA05}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1270" y="0" width="129" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA14}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="1399" y="0" width="142" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[new BigDecimal(NumberFormat.getNumberInstance(new Locale("en")).parse($F{PRIMA06}))]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1757" y="0" width="79" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA11}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1836" y="0" width="48" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA12}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="2139" y="0" width="120" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA16}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="2259" y="0" width="117" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA15}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="37" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{COUNT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="685" y="0" width="130" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[($V{ZERO_APPEND}.concat($F{CORE07})).substring(($V{ZERO_APPEND}.concat($F{CORE07})).length()-16,($V{ZERO_APPEND}.concat($F{CORE07})).length())]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="2044" y="0" width="95" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA10}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1954" y="0" width="90" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA09}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1884" y="0" width="70" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA08}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="1541" y="0" width="76" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMA04}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="1617" y="0" width="140" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[new BigDecimal(NumberFormat.getNumberInstance(new Locale("en")).parse($F{PRIMA07}))]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="2376" y="0" width="144" height="20"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{SOURCE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>