<?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="ER5" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="0.75"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="AS_SITE_CODE" class="java.lang.String"/>
	<parameter name="FROM_DATE" class="java.util.Date"/>
	<parameter name="TO_DATE" class="java.util.Date"/>
	<queryString>
		<![CDATA[SELECT    (SITE.DESCR||','||SITE.ADD1||','||SITE.CITY) AS SITEADD,
          BOM.BOM_CODE AS BOMCODE,
          BOMDET.ITEM_CODE,
          SITEREGNO.REG_NO AS REGNO,
          ITEM.DESCR AS PRINCIPAL_INPUT,
          NVL(ITEM.TAX_CHAP,' ') AS CENVAT_PRINCIPAL_INPUT,
          ITEM.UNIT AS PRINCIPAL_ITEM_UNIT,
          BOM.DESCR AS FINISHED_GOODS,
          NVL(A.TAX_CHAP,' ') AS CENVAT_FINISHED_GOODS,
          BOM.UNIT AS FG_UNIT,
          BOM.BATCH_QTY AS FG_BATCH_SIZE,
          SUM(BOMDET.QTY_PER) AS QTY_REQD
FROM      BOM,BOMDET,SITE,SITEREGNO,ITEM,ITEM A
where     bom.bom_code         = bomdet.bom_code
and       bomdet.item_code     = item.item_code
and       bom.item_code        = a.item_code
and       bom.active           = 'Y'
and       bom.confirmed        = 'Y'
and       bomdet.item_category = 'A'
and       bomdet.crit_item     = 'Y'
and       site.site_code       = siteregno.site_code
and       siteregno.ref_code   = 'EXC_ECCNO'
and      (BOM.BOM_CODE,site.site_code)   IN ( SELECT DISTINCT BOM_CODE,site_code FROM WORKORDER                                               WHERE  site_code = '$P!{AS_SITE_CODE}'
                                              and ord_DATE BETWEEN $P{FROM_DATE}
                                                               and $P{TO_DATE})
  GROUP BY (SITE.DESCR||','||SITE.ADD1||','||SITE.CITY),
          BOM.BOM_CODE,
          BOMDET.ITEM_CODE,
          SITEREGNO.REG_NO,
          ITEM.DESCR,
          NVL(ITEM.TAX_CHAP,' '),
          ITEM.UNIT,
          BOM.DESCR ,
          NVL(A.TAX_CHAP,' '),
          BOM.UNIT,
          BOM.BATCH_QTY
 ORDER BY BOM.BOM_CODE,BOMDET.ITEM_CODE]]>
	</queryString>
	<field name="SITEADD" class="java.lang.String"/>
	<field name="BOMCODE" class="java.lang.String"/>
	<field name="ITEM_CODE" class="java.lang.String"/>
	<field name="REGNO" class="java.lang.String"/>
	<field name="PRINCIPAL_INPUT" class="java.lang.String"/>
	<field name="CENVAT_PRINCIPAL_INPUT" class="java.lang.String"/>
	<field name="PRINCIPAL_ITEM_UNIT" class="java.lang.String"/>
	<field name="FINISHED_GOODS" class="java.lang.String"/>
	<field name="CENVAT_FINISHED_GOODS" class="java.lang.String"/>
	<field name="FG_UNIT" class="java.lang.String"/>
	<field name="FG_BATCH_SIZE" class="java.lang.Double"/>
	<field name="QTY_REQD" class="java.lang.Double"/>
	<variable name="SRNO" class="java.lang.Integer" resetType="None" calculation="DistinctCount">
		<variableExpression><![CDATA[$F{BOMCODE}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="134" splitType="Stretch">
			<staticText>
				<reportElement x="335" y="0" width="73" height="16"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[FORM   ER-5]]></text>
			</staticText>
			<staticText>
				<reportElement x="253" y="17" width="267" height="16"/>
				<textElement/>
				<text><![CDATA[{ sub-rule (1) of rule 9A of CENVAT Credit Rules, 2004 }]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="38" width="146" height="19"/>
				<textElement/>
				<text><![CDATA[1. Name of the Manufacturer :]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="58" width="176" height="20"/>
				<textElement/>
				<text><![CDATA[2. PAN based Registration  Number :]]></text>
			</staticText>
			<textField>
				<reportElement x="177" y="58" width="100" height="20"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{REGNO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1" y="78" width="113" height="17"/>
				<textElement/>
				<text><![CDATA[3. Annual Declaration :]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="95" width="146" height="17"/>
				<textElement/>
				<text><![CDATA[(I) New Declaration :  New]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="112" width="287" height="20"/>
				<textElement/>
				<text><![CDATA[(II) Amendments to Declaration already filed ]]></text>
			</staticText>
			<textField pattern="MMM-yy" isBlankWhenNull="false">
				<reportElement x="116" y="78" width="40" height="20"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{FROM_DATE}]]></textFieldExpression>
			</textField>
			<textField pattern="MMM-yy" isBlankWhenNull="false">
				<reportElement x="181" y="78" width="40" height="20"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{TO_DATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="157" y="78" width="23" height="20"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[To]]></text>
			</staticText>
			<textField>
				<reportElement x="146" y="38" width="653" height="20"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SITEADD}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="121" splitType="Stretch">
			<line>
				<reportElement x="29" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="40" y="1" width="210" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ Description of   principal inputs]]></text>
			</staticText>
			<line>
				<reportElement x="253" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="255" y="1" width="60" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Central Excise Tariff Sub-Heading No. of principal inputs]]></text>
			</staticText>
			<line>
				<reportElement x="318" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="321" y="1" width="53" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ Quantity  Code]]></text>
			</staticText>
			<line>
				<reportElement x="376" y="2" width="2" height="117"/>
			</line>
			<staticText>
				<reportElement x="378" y="2" width="186" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ Description of finished goods in which principal input mentioned in column (2) is used]]></text>
			</staticText>
			<line>
				<reportElement x="565" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="568" y="1" width="54" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ Central Excise Tariff Sub- Heading No. of finished goods]]></text>
			</staticText>
			<line>
				<reportElement x="623" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="626" y="1" width="33" height="85"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Quantity Code]]></text>
			</staticText>
			<line>
				<reportElement x="659" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="661" y="2" width="75" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Quantity of principal input mentioned in column (2) required for use in the manufacture of unit quantity of finished goods mentioned in column (5)]]></text>
			</staticText>
			<line>
				<reportElement x="737" y="2" width="1" height="117"/>
			</line>
			<line>
				<reportElement x="0" y="86" width="802" height="1"/>
			</line>
			<staticText>
				<reportElement x="668" y="89" width="68" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Batch Size]]></text>
			</staticText>
			<staticText>
				<reportElement x="740" y="89" width="62" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Qty. required]]></text>
			</staticText>
			<line>
				<reportElement x="1" y="103" width="802" height="1"/>
			</line>
			<line>
				<reportElement x="0" y="1" width="802" height="1"/>
			</line>
			<line>
				<reportElement x="0" y="119" width="802" height="1"/>
			</line>
			<line>
				<reportElement x="0" y="2" width="1" height="117"/>
			</line>
			<line>
				<reportElement x="802" y="2" width="1" height="117"/>
			</line>
			<staticText>
				<reportElement x="1" y="106" width="26" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[ 1]]></text>
			</staticText>
			<staticText>
				<reportElement x="37" y="106" width="205" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[2]]></text>
			</staticText>
			<staticText>
				<reportElement x="255" y="106" width="64" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[3]]></text>
			</staticText>
			<staticText>
				<reportElement x="321" y="106" width="53" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[4]]></text>
			</staticText>
			<staticText>
				<reportElement x="394" y="105" width="147" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[5]]></text>
			</staticText>
			<staticText>
				<reportElement x="568" y="106" width="54" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[6]]></text>
			</staticText>
			<staticText>
				<reportElement x="626" y="106" width="33" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[7]]></text>
			</staticText>
			<staticText>
				<reportElement x="677" y="106" width="59" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[8]]></text>
			</staticText>
			<staticText>
				<reportElement x="740" y="106" width="60" height="12"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[9]]></text>
			</staticText>
			<staticText>
				<reportElement x="3" y="3" width="26" height="84"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[S.No]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="70" splitType="Prevent">
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="31" y="1" width="222" height="67"/>
				<textElement textAlignment="Left">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PRINCIPAL_INPUT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="255" y="0" width="61" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CENVAT_PRINCIPAL_INPUT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="321" y="0" width="56" height="21"/>
				<textElement textAlignment="Center">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PRINCIPAL_ITEM_UNIT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="378" y="0" width="186" height="67"/>
				<textElement textAlignment="Left">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FINISHED_GOODS}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="626" y="0" width="33" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FG_UNIT}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="668" y="0" width="68" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{FG_BATCH_SIZE}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.000" isBlankWhenNull="false">
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="740" y="0" width="60" height="20"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{QTY_REQD}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToBandHeight" x="3" y="0" width="26" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{SRNO}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="378" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="802" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="1" y="69" width="801" height="1"/>
			</line>
			<line>
				<reportElement x="318" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="623" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="659" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="565" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="253" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="29" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="737" y="-1" width="1" height="69"/>
			</line>
			<line>
				<reportElement x="0" y="-1" width="1" height="69"/>
			</line>
			<textField>
				<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="568" y="1" width="54" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CENVAT_FINISHED_GOODS}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="184" splitType="Stretch">
			<staticText>
				<reportElement x="3" y="0" width="797" height="184"/>
				<textElement>
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[NOTE:-
 Please indicate the abbreviation referred to in instruction No.7 mentioned in Form E.R-1 and Form E.R-3 specified in the
 Government of India.Ministry of Finance (Department of Revenue) vide No.25/2004-Central Excise (N.T.) dated the 27th
 September,2004 published vide G.S.R.No. 643(E) dated the 25th September 2004.

 5. (i) I\We hereby declare that the information given above is true ,correct and complete in every respect to the best of
        my\our knowledge and belief.

    (ii) I\We are authorised to sign this return.
                                                                                                                                                                                                                          (Authorised Signatory)

                                                                                                              ACKNOWLEDGMENT
  Declaration for the Financial Year:
  Date of Reciept:
]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
