<?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="invoice_summary_report" pageWidth="1602" pageHeight="595" orientation="Landscape" columnWidth="1566" leftMargin="18" rightMargin="18" topMargin="18" bottomMargin="18">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="117"/>
	<property name="ireport.y" value="0"/>
	<parameter name="P_SITE_CODE" class="java.lang.String"/>
	<parameter name="P_FR_DATE" class="java.util.Date">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="P_TO_DATE" class="java.util.Date">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
	DISTORD_ISS.tran_id,
	DISTORD_ISS.TRAN_DATE AS TRAN_DATE ,
	DISTORD_ISS.GP_NO,
	DISTORD_ISS.GP_DATE AS GP_DATE,
	DISTORD_ISS.SITE_CODE__DLV AS SUNDRY_CODE,
	B.DESCR AS DESCR,
	B.CITY AS LOCATION,
	'D-ISS' AS TYPE,
	DISTORD_ISSDET.item_code AS ITEM_CODE,
	ITEM.DESCR AS ITEM_DESCR,
	SUM(DISTORD_ISSDET.QUANTITY) AS QUANTITY,
	DISTORD_ISSDET.UNIT,
	ITEM.ITEM_SER,
	DISTORD_ISS.CURR_CODE,
	distord_iss.exch_rate,
	SUM(DISTORD_ISSDET.AMOUNT) AS AMOUNT,
	SUM(nvl((ddf_get_tax_details_taxcurr('D-ISS',DISTORD_ISS.TRAN_ID,DISTORD_ISSDET.LINE_NO,'CUSTOM_TAX_CODE','T')),0)) CUSTOM_DUTY,
	SUM(nvl((ddf_get_tax_details_taxcurr('D-ISS',DISTORD_ISS.TRAN_ID,DISTORD_ISSDET.LINE_NO,'EXC_TAX_CODE_INV','T')),0)) EXCISE_DUTY,
	SUM(nvl((ddf_get_tax_details_taxcurr('D-ISS',DISTORD_ISS.TRAN_ID,DISTORD_ISSDET.LINE_NO,'CESS_TAX_CODE_INV','T')),0)) EDU_CESS,
	SUM(nvl((ddf_get_tax_details_taxcurr('D-ISS',DISTORD_ISS.TRAN_ID,DISTORD_ISSDET.LINE_NO,'SHEC_TAX_CODE_INV','T')),0)) SHEC_CESS,
	SUM(nvl((ddf_get_tax_details_taxcurr('D-ISS',DISTORD_ISS.TRAN_ID,DISTORD_ISSDET.LINE_NO,'SAD_TAX_CODE_INV','T')),0)) SAD,
	SUM(DISTORD_ISSDET.NET_AMT) AS NET_AMT,
	DISTORD_ISS.LR_NO,
	DISTORD_ISS.LR_DATE AS LR_DATE ,
	transporter.tran_name as tran_name,
	(CASE WHEN DDF_RETURNORDTYPE_RG1(DISTORD_ISS.TRAN_ID) IN ('FE') AND DDF_GET_TAX_DETAILS_DUTY_FREE('D-ISS',DISTORD_ISS.TRAN_ID) > 0 THEN 'Under Bond' WHEN DDF_RETURNORDTYPE_RG1(DISTORD_ISS.TRAN_ID) IN ('FE') AND DDF_GET_TAX_DETAILS_DUTY_FREE('D-ISS',DISTORD_ISS.TRAN_ID) <= 0 THEN 'Under Rebate' ELSE NULL END )
	 AS CATEGORY
FROM
	DISTORD_ISS ,
	DISTORD_ISSDET ,
	SITE,
	ITEM,
	SITE B,
	transporter
WHERE
	(DISTORD_ISS.TRAN_ID = DISTORD_ISSDET.TRAN_ID)
	AND	(DISTORD_ISS.SITE_CODE = SITE.SITE_CODE)
	AND	(DISTORD_ISS.SITE_CODE__DLV = B.SITE_CODE)
	AND	(DISTORD_ISSDET.ITEM_CODE   = ITEM.ITEM_CODE)
	AND (DISTORD_ISS.TRAN_CODE      = TRANSPORTER.TRAN_CODE(+))
	AND	DISTORD_ISS.TRAN_DATE          BETWEEN $P{P_FR_DATE} AND $P{P_TO_DATE}
  AND SITE.SITE_CODE__EXC            IN ($P{P_SITE_CODE})
	AND	DISTORD_ISS.CONFIRMED       = 'Y'
	AND	DISTORD_ISS.TRAN_TYPE          IN ('FE','IT','CC','CT','IF')
GROUP BY
	DISTORD_ISS.tran_id, DISTORD_ISS.TRAN_DATE, DISTORD_ISS.GP_NO,	DISTORD_ISS.GP_DATE, DISTORD_ISS.SITE_CODE__DLV, B.DESCR, B.CITY,
	'D-ISS', distord_issdet.item_code, ITEM.DESCR, DISTORD_ISSDET.UNIT, ITEM.ITEM_SER, DISTORD_ISS.CURR_CODE, distord_iss.exch_rate,
	DISTORD_ISS.LR_NO, DISTORD_ISS.LR_DATE, transporter.tran_name,
	(CASE WHEN DDF_RETURNORDTYPE_RG1(DISTORD_ISS.TRAN_ID) IN ('FE') AND DDF_GET_TAX_DETAILS_DUTY_FREE('D-ISS',DISTORD_ISS.TRAN_ID) > 0 THEN 'UnderBond' WHEN DDF_RETURNORDTYPE_RG1(DISTORD_ISS.TRAN_ID) IN ('FE') AND DDF_GET_TAX_DETAILS_DUTY_FREE('D-ISS',DISTORD_ISS.TRAN_ID) <= 0 THEN 'Under Rebate' ELSE NULL END )
UNION ALL
SELECT
	INVOICE.INVOICE_ID AS TRAN_ID,
	INVOICE.TRAN_DATE AS TRAN_DATE,
	DESPATCH.GP_NO,
	DESPATCH.GP_DATE  AS GP_DATE ,
	INVOICE.CUST_CODE AS SUNDRY_CODE,
	CUSTOMER.CUST_NAME AS DESCR,
	CUSTOMER.CITY AS LOCATION,
	'S-INV' as type,
	INVOICE_TRACE.ITEM_CODE AS ITEM_CODE,
	ITEM.DESCR  AS ITEM_DESCR,
	SUM(INVOICE_TRACE.QUANTITY) AS QUANTITY,
	INVOICE_TRACE.UNIT,
	ITEM.ITEM_SER,
	INVOICE.CURR_CODE,
	INVOICE.EXCH_RATE,
	SUM(INVOICE_TRACE.NET_AMT - INVOICE_TRACE.TAX_AMT) AS AMOUNT,
	SUM(nvl((ddf_get_tax_details_taxcurr('S-INV',INVOICE.INVOICE_ID,INVOICE_TRACE.LINE_NO,'CUSTOM_TAX_CODE','T')),0)) CUSTOM_DUTY,
	SUM(nvl((ddf_get_tax_details_taxcurr('S-INV',INVOICE.INVOICE_ID,INVOICE_TRACE.LINE_NO,'EXC_TAX_CODE_INV','T')),0)) EXCISE_DUTY,
	SUM(nvl((ddf_get_tax_details_taxcurr('S-INV',INVOICE.INVOICE_ID,INVOICE_TRACE.LINE_NO,'CESS_TAX_CODE_INV','T')),0)) EDU_CESS,
	SUM(nvl((ddf_get_tax_details_taxcurr('S-INV',INVOICE.INVOICE_ID,INVOICE_TRACE.LINE_NO,'SHEC_TAX_CODE_INV','T')),0)) 	SHEC_CESS,
	SUM(NVL((DDF_GET_TAX_DETAILS_TAXCURR('S-INV',INVOICE.INVOICE_ID,INVOICE_TRACE.LINE_NO,'SAD_TAX_CODE_INV','T')),0)) SAD,
  SUM(INVOICE_TRACE.NET_AMT) NET_AMT,
	DESPATCH.LR_NO,
	DESPATCH.LR_DATE AS LR_DATE,
	transporter.tran_name as tran_name,
	(case when (sorder.order_type in ('EF','EB')) AND ddf_get_tax_details_duty_free('S-INV',INVOICE_TRACE.INVOICE_id) > 0 then 'Under Bond' when (sorder.order_type in ('EF','EB')) AND ddf_get_tax_details_duty_free('S-INV',INVOICE_TRACE.INVOICE_id) <= 0 then 'Under Rebate' else null END ) 
  AS CATEGORY
FROM
		INVOICE,
		INVOICE_TRACE ,
		DESPATCH ,
		SORDER,
		SITE ,
		ITEM,
		CUSTOMER,
		transporter
WHERE
	(INVOICE.INVOICE_ID = INVOICE_TRACE.INVOICE_ID)
	AND     (INVOICE_TRACE.DESP_ID = DESPATCH.DESP_ID)
	AND     (DESPATCH.SORD_NO = SORDER.SALE_ORDER)
	and	  (DESPATCH.tran_code = transporter.tran_code(+))
	AND     (INVOICE.SITE_CODE = SITE.SITE_CODE)
	AND     (INVOICE.CUST_CODE = CUSTOMER.CUST_CODE)
	AND     (INVOICE_TRACE.ITEM_CODE = ITEM.ITEM_CODE)
	AND     INVOICE.TRAN_DATE     BETWEEN $P{P_FR_DATE} AND $P{P_TO_DATE}
AND     SITE.SITE_CODE__EXC     IN ($P{P_SITE_CODE})
	AND     INVOICE.CONFIRMED = 'Y'
	AND     SORDER.order_type IN ('B','EB','EF','F','P','RM','S','CP','FB')
GROUP  BY
	INVOICE.INVOICE_ID, INVOICE.TRAN_DATE, DESPATCH.GP_NO, DESPATCH.GP_DATE, INVOICE.CUST_CODE, CUSTOMER.CUST_NAME,CUSTOMER.CITY,
	'S-INV', INVOICE_TRACE.ITEM_CODE, ITEM.DESCR, INVOICE_TRACE.UNIT, ITEM.ITEM_SER, INVOICE.CURR_CODE, INVOICE.EXCH_RATE, DESPATCH.LR_NO,
	DESPATCH.LR_DATE, transporter.tran_name,
	(case when (sorder.order_type in ('EF','EB')) AND 	ddf_get_tax_details_duty_free('S-INV',INVOICE_TRACE.INVOICE_id) > 0 then'Under Bond' 	WHEN (SORDER.ORDER_TYPE IN ('EF','EB')) AND 	DDF_GET_TAX_DETAILS_DUTY_FREE('S-INV',INVOICE_TRACE.INVOICE_ID) 	<= 0 THEN 'Under Rebate' ELSE NULL END )
UNION ALL
SELECT
		PORCP.TRAN_ID,
		PORCP.TRAN_DATE,
		PORCP.excise_ref AS GP_NO,
		PORCP.TRAN_DATE AS GP_DATE,
		SUPPLIER.SUPP_code AS SUNDRY_CODE,
		SUPPLIER.SUPP_NAME AS DESCR,
		SUPPLIER.CITY AS LOCATION,
		'P-RET' AS TYPE,
		PORCPDET.item_code AS ITEM_CODE,
		ITEM.DESCR  AS ITEM_DESCR,
		SUM(PORCPDET.QUANTITY) AS QUANTITY,
		PORCPDET.unit,
		item.item_ser,
		PORCP.CURR_CODE,
		PORCP.EXCH_RATE,
		SUM((PORCPDET.NET_AMT - PORCPDET.TAX_AMT)) AS AMOUNT ,
		SUM(nvl((ddf_get_tax_details_taxcurr('P-RET',PORCP.TRAN_ID,PORCPDET.LINE_NO,'CUSTOM_TAX_CODE','T')),0)) CUSTOM_DUTY,
		SUM(nvl((ddf_get_tax_details_taxcurr('P-RET',PORCP.TRAN_ID,PORCPDET.LINE_NO,'EXC_TAX_CODE_INV','T')),0)) EXCISE_DUTY,
		SUM(nvl((ddf_get_tax_details_taxcurr('P-RET',PORCP.TRAN_ID,PORCPDET.LINE_NO,'CESS_TAX_CODE_INV','T')),0)) EDU_CESS,
		SUM(nvl((ddf_get_tax_details_taxcurr('P-RET',PORCP.TRAN_ID,PORCPDET.LINE_NO,'SHEC_TAX_CODE_INV','T')),0)) SHEC_CESS,
		SUM(nvl((ddf_get_tax_details_taxcurr('P-RET',PORCP.TRAN_ID,PORCPDET.LINE_NO,'SAD_TAX_CODE_INV','T')),0)) SAD,
		SUM((PORCPDET.NET_AMT)) AS NET_AMT,
		PORCP.LR_NO,
		PORCP.LR_DATE,
		transporter.tran_name,
		NULL AS CATEGORY
from
		PORCP ,
		PORCPDET ,
		site ,
		item ,
		SUPPLIER,
		transporter
where
	(PORCP.tran_id = PORCPDET.tran_id)
	AND     (PORCP.SITE_CODE      = SITE.SITE_CODE)
	and     (PORCP.SUPP_code      = SUPPLIER.SUPP_CODE)
	AND     (PORCPDET.ITEM_CODE   = ITEM.ITEM_CODE)
	and 	  (porcp.tran_code = transporter.tran_code (+))
	AND     PORCP.TRAN_SER       = 'P-RET'
	AND     PORCP.TRAN_DATE       BETWEEN $P{P_FR_DATE} AND $P{P_TO_DATE}
AND     SITE.SITE_CODE__EXC     IN ($P{P_SITE_CODE})
	AND     PORCP.CONFIRMED      = 'Y'
GROUP   BY
	PORCP.TRAN_ID,PORCP.TRAN_DATE, PORCP.EXCISE_REF, PORCP.TRAN_DATE, SUPPLIER.SUPP_CODE, SUPPLIER.SUPP_NAME, SUPPLIER.CITY,
	'P-RET', PORCPDET.ITEM_CODE, ITEM.DESCR, PORCPDET.UNIT, ITEM.ITEM_SER, PORCP.CURR_CODE, PORCP.EXCH_RATE, PORCP.LR_NO, PORCP.LR_DATE,
	TRANSPORTER.TRAN_NAME, NULL
ORDER BY GP_NO,TRAN_ID]]>
	</queryString>
	<field name="TRAN_ID" class="java.lang.String"/>
	<field name="TRAN_DATE" class="java.util.Date"/>
	<field name="GP_NO" class="java.lang.String"/>
	<field name="GP_DATE" class="java.util.Date"/>
	<field name="SUNDRY_CODE" class="java.lang.String"/>
	<field name="DESCR" class="java.lang.String"/>
	<field name="LOCATION" class="java.lang.String"/>
	<field name="TYPE" class="java.lang.String"/>
	<field name="ITEM_CODE" class="java.lang.String"/>
	<field name="ITEM_DESCR" class="java.lang.String"/>
	<field name="QUANTITY" class="java.lang.Double"/>
	<field name="UNIT" class="java.lang.String"/>
	<field name="ITEM_SER" class="java.lang.String"/>
	<field name="CURR_CODE" class="java.lang.String"/>
	<field name="EXCH_RATE" class="java.lang.Double"/>
	<field name="AMOUNT" class="java.lang.Double"/>
	<field name="CUSTOM_DUTY" class="java.lang.Double"/>
	<field name="EXCISE_DUTY" class="java.lang.Double"/>
	<field name="EDU_CESS" class="java.lang.Double"/>
	<field name="SHEC_CESS" class="java.lang.Double"/>
	<field name="SAD" class="java.lang.Double"/>
	<field name="NET_AMT" class="java.lang.Double"/>
	<field name="LR_NO" class="java.lang.String"/>
	<field name="LR_DATE" class="java.util.Date"/>
	<field name="TRAN_NAME" class="java.lang.String"/>
	<field name="CATEGORY" class="java.lang.String"/>
	<variable name="TRAN_ID_1" class="java.lang.Integer" resetType="Column" calculation="DistinctCount">
		<variableExpression><![CDATA[$F{TRAN_ID}]]></variableExpression>
	</variable>
	<variable name="As_oth_tax" class="java.lang.Double">
		<variableExpression><![CDATA[new java.lang.Double(Math.abs($F{NET_AMT}.doubleValue()-($F{AMOUNT}.doubleValue()+ $F{CUSTOM_DUTY}.doubleValue()+$F{EXCISE_DUTY}.doubleValue()+ $F{EDU_CESS}.doubleValue()
+$F{SHEC_CESS}.doubleValue()+$F{SAD}.doubleValue())))]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement x="637" y="0" width="221" height="25"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice Summary Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="22" splitType="Stretch">
			<staticText>
				<reportElement x="1" y="0" width="47" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Transaction
Id]]></text>
			</staticText>
			<staticText>
				<reportElement x="49" y="0" width="48" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Transaction Date]]></text>
			</staticText>
			<staticText>
				<reportElement x="98" y="0" width="28" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice
no]]></text>
			</staticText>
			<staticText>
				<reportElement x="128" y="0" width="48" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Invoice
Date]]></text>
			</staticText>
			<staticText>
				<reportElement x="176" y="0" width="39" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Sundry
Code]]></text>
			</staticText>
			<staticText>
				<reportElement x="216" y="0" width="123" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Sundry Description]]></text>
			</staticText>
			<staticText>
				<reportElement x="341" y="0" width="46" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Location Description]]></text>
			</staticText>
			<staticText>
				<reportElement x="388" y="0" width="30" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Type]]></text>
			</staticText>
			<staticText>
				<reportElement x="419" y="0" width="53" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Item Code]]></text>
			</staticText>
			<staticText>
				<reportElement x="595" y="0" width="34" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Quantity]]></text>
			</staticText>
			<staticText>
				<reportElement x="635" y="0" width="28" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Unit]]></text>
			</staticText>
			<staticText>
				<reportElement x="663" y="0" width="29" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Item Series]]></text>
			</staticText>
			<staticText>
				<reportElement x="708" y="0" width="35" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Curr Code]]></text>
			</staticText>
			<staticText>
				<reportElement x="743" y="0" width="32" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Ex Rate]]></text>
			</staticText>
			<staticText>
				<reportElement x="776" y="0" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Amount]]></text>
			</staticText>
			<staticText>
				<reportElement x="832" y="0" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Custom Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="888" y="0" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Excise Duty]]></text>
			</staticText>
			<staticText>
				<reportElement x="944" y="0" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Edu Cess]]></text>
			</staticText>
			<staticText>
				<reportElement x="1001" y="0" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Shec Cess]]></text>
			</staticText>
			<staticText>
				<reportElement x="1057" y="0" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[SAD]]></text>
			</staticText>
			<staticText>
				<reportElement x="1190" y="0" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Net
Amount]]></text>
			</staticText>
			<staticText>
				<reportElement x="1279" y="0" width="64" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[LRNo]]></text>
			</staticText>
			<staticText>
				<reportElement x="1343" y="0" width="43" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[LR Date]]></text>
			</staticText>
			<staticText>
				<reportElement x="1391" y="0" width="93" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<text><![CDATA[Transporter
Name]]></text>
			</staticText>
			<staticText>
				<reportElement x="472" y="0" width="123" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Item Description]]></text>
			</staticText>
			<staticText>
				<reportElement x="1514" y="0" width="50" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Category]]></text>
			</staticText>
			<line>
				<reportElement x="1" y="21" width="2231" height="1"/>
			</line>
			<staticText>
				<reportElement x="1114" y="2" width="76" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Other Tax]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="21" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="1" y="1" width="47" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TRAN_ID}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="98" y="1" width="28" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{GP_NO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="176" y="1" width="39" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SUNDRY_CODE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="216" y="1" width="123" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESCR}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="341" y="1" width="46" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LOCATION}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="388" y="1" width="30" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TYPE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="419" y="1" width="53" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ITEM_CODE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="595" y="1" width="34" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{QUANTITY}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="635" y="1" width="28" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{UNIT}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="663" y="1" width="29" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ITEM_SER}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="708" y="1" width="35" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CURR_CODE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="743" y="1" width="32" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{EXCH_RATE}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="776" y="1" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{AMOUNT}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="832" y="1" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{CUSTOM_DUTY}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="888" y="1" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{EXCISE_DUTY}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="944" y="1" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{EDU_CESS}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1000" y="1" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{SHEC_CESS}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1057" y="1" width="55" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{SAD}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00" isBlankWhenNull="false">
				<reportElement x="1190" y="1" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{NET_AMT}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1279" y="1" width="64" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LR_NO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="472" y="1" width="123" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ITEM_DESCR}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1514" y="1" width="50" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CATEGORY}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="49" y="1" width="48" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{TRAN_DATE}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="128" y="1" width="48" height="20"/>
				<textElement>
					<font fontName="Arial" size="8" isItalic="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{GP_DATE}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="1343" y="1" width="43" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{LR_DATE}]]></textFieldExpression>
			</textField>
			<textField  isBlankWhenNull="true">
				<reportElement x="1391" y="1" width="123" height="20"/>
				<textElement>
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TRAN_NAME}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00">
				<reportElement x="1114" y="1" width="76" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{As_oth_tax}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
