<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.6.final using JasperReports Library version 6.20.6-5c96b6aa8a39ac1dc6b6bea4b81168e16dd39231  -->
<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="Document Lines" language="groovy" pageWidth="511" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="511" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="0ea03c33-cee9-4aa5-b7a2-e829a06f336b">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="DataAdapter.xml"/>
	<property name="com.jaspersoft.studio.unit." value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<template><![CDATA["styles.jrtx"]]></template>
	<parameter name="RECORD_ID" class="java.lang.Integer" isForPrompting="false">
		<defaultValueExpression><![CDATA[109]]></defaultValueExpression>
	</parameter>
	<parameter name="CURRENT_LANG" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["de_DE"]]></defaultValueExpression>
	</parameter>
	<parameter name="CURRENCY_PATTERN" class="java.lang.String" isForPrompting="false"/>
	<parameter name="P_MsgHelper" class="java.lang.Object" isForPrompting="false"/>
	<queryString language="SQL">
		<![CDATA[SELECT
    ilt.line,
    ilt.linenetamt,
    ilt.qtyinvoiced,
    ilt.qtyentered,
    ilt.uomsymbol,
    ilt.c_uom_name,
    COALESCE(pt.Name, ct.Name, ilt.name) AS name,
    COALESCE(pt.Description, ilt.description) AS description,
    ilt.documentnote,
    ilt.productvalue,
    ilt.priceentered,
    ilt.priceactual,
    ilt.productdescription,
    ilt.m_product_id,
    ilt.paymentrule,
    ilt.c_invoice_id AS record_id,
    COALESCE(pt.Description, p.description) AS p_description
FROM c_invoice_linetax_v ilt
JOIN c_invoiceline il
    ON il.c_invoiceline_id = ilt.c_invoiceline_id
LEFT JOIN M_Product p
    ON p.M_Product_ID = ilt.M_Product_ID
LEFT JOIN M_Product_Trl pt
    ON pt.M_Product_ID = p.M_Product_ID AND pt.AD_Language = $P{CURRENT_LANG}
LEFT JOIN C_Charge_Trl ct
    ON ct.C_Charge_ID = il.C_Charge_ID AND ct.AD_Language = $P{CURRENT_LANG}
WHERE ilt.c_invoice_id = $P{RECORD_ID}
  AND (ilt.m_product_id IS NOT NULL OR il.c_charge_id IS NOT NULL)
ORDER BY ilt.line]]>
	</queryString>
	<field name="line" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="line"/>
		<property name="com.jaspersoft.studio.field.label" value="line"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="linenetamt" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="linenetamt"/>
		<property name="com.jaspersoft.studio.field.label" value="linenetamt"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="qtyinvoiced" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="qtyinvoiced"/>
		<property name="com.jaspersoft.studio.field.label" value="qtyinvoiced"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="qtyentered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="qtyentered"/>
		<property name="com.jaspersoft.studio.field.label" value="qtyentered"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="uomsymbol" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="uomsymbol"/>
		<property name="com.jaspersoft.studio.field.label" value="uomsymbol"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="c_uom_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="c_uom_name"/>
		<property name="com.jaspersoft.studio.field.label" value="c_uom_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="name"/>
		<property name="com.jaspersoft.studio.field.label" value="name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="description" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="description"/>
		<property name="com.jaspersoft.studio.field.label" value="description"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="documentnote" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="documentnote"/>
		<property name="com.jaspersoft.studio.field.label" value="documentnote"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="productvalue" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="productvalue"/>
		<property name="com.jaspersoft.studio.field.label" value="productvalue"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="priceentered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="priceentered"/>
		<property name="com.jaspersoft.studio.field.label" value="priceentered"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="priceactual" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="priceactual"/>
		<property name="com.jaspersoft.studio.field.label" value="priceactual"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="productdescription" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="productdescription"/>
		<property name="com.jaspersoft.studio.field.label" value="productdescription"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="m_product_id" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="m_product_id"/>
		<property name="com.jaspersoft.studio.field.label" value="m_product_id"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="paymentrule" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="paymentrule"/>
		<property name="com.jaspersoft.studio.field.label" value="paymentrule"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="record_id" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="record_id"/>
		<property name="com.jaspersoft.studio.field.label" value="record_id"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_invoice_linetax_v"/>
	</field>
	<field name="p_description" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="p_description"/>
		<property name="com.jaspersoft.studio.field.label" value="p_description"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="m_product"/>
	</field>
	<columnHeader>
		<band height="16" splitType="Stretch">
			<property name="local_mesure_unitheight" value="pixel"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="10" y="2" width="53" height="12" uuid="2e595f78-574e-42bd-a118-790265bdcefc"/>
				<textElement textAlignment="Left" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"QtyEntered", "Quantity")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="65" y="2" width="50" height="12" uuid="425914f1-f661-4b34-abce-8150f0840daa"/>
				<textElement textAlignment="Left" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"ProdCode", "Code")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="348" y="2" width="60" height="12" uuid="ca36e9e4-0dea-4699-ac68-87f1d80a19e6"/>
				<textElement textAlignment="Right" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"PriceActual", "Unit Price")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="108" y="2" width="228" height="12" uuid="b65f3f60-a99e-4f93-a280-0d0646ed8936"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"Description", "Description")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToBandHeight" x="420" y="2" width="84" height="12" uuid="3afe14d3-589b-4664-a56a-29b4f2fe4a0d"/>
				<textElement textAlignment="Right" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"Total","Total")]]></textFieldExpression>
			</textField>
			<line>
				<reportElement mode="Opaque" x="0" y="0" width="511" height="1" forecolor="#FFFFFF" uuid="7f4746d6-d2ab-404d-8ba0-dab6ecc017c6">
					<property name="local_mesure_unitx" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
					<property name="local_mesure_unity" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
			</line>
			<line>
				<reportElement x="0" y="15" width="511" height="1" uuid="dc5992d7-efe9-47c6-bef9-eabc64c2d5aa">
					<property name="local_mesure_unity" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="38" splitType="Stretch">
			<property name="local_mesure_unitheight" value="pixel"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement style="Report Monospace Font" x="0" y="2" width="26" height="12" uuid="749469f7-379e-4a2d-8fb1-2ed644127053">
					<property name="local_mesure_unitwidth" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{qtyentered}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="29" y="2" width="40" height="12" uuid="9dd51c6d-4a54-49f0-8645-3c04bada200d">
					<property name="local_mesure_unitx" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
					<property name="local_mesure_unitwidth" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{uomsymbol}]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight">
				<reportElement style="Report Standard Font" x="108" y="2" width="228" height="12" uuid="e68539fe-fa17-4e7d-be1b-ef0ee048e507"/>
				<textElement>
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight" isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="108" y="26" width="228" height="12" isRemoveLineWhenBlank="true" uuid="b8769f51-1192-405a-a812-45391ed452c4"/>
				<textElement>
					<font fontName="SansSerif" size="8" isItalic="true"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{description} != null && $F{description}.equals($F{name})) ? null : $F{description}]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight" isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="108" y="14" width="228" height="12" isRemoveLineWhenBlank="true" uuid="1e7508ac-42df-4cc7-acd7-5cbca24e4bb6"/>
				<textElement>
					<font fontName="SansSerif" size="8" isItalic="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{documentnote}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement style="Report Standard Font" x="70" y="2" width="36" height="12" uuid="d31fabde-d6e2-4e00-aabb-9e4e7eb1235f"/>
				<textElement textAlignment="Left">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{productvalue}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement style="Header" x="348" y="2" width="72" height="12" uuid="a1f666cd-d621-4225-9502-6ac0656f8f9f"/>
				<textElement textAlignment="Right">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{priceentered} == null ? "" : new DecimalFormat($P{CURRENCY_PATTERN}).format($F{priceentered})]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement style="Report Monospace Font" x="420" y="2" width="84" height="12" uuid="f45c7fcb-f922-4fc3-808b-c18f25ab9fa0"/>
				<textElement textAlignment="Right">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{linenetamt} == null ? "" : new DecimalFormat($P{CURRENCY_PATTERN}).format($F{linenetamt})]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="5" splitType="Stretch">
			<property name="local_mesure_unitheight" value="pixel"/>
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<line>
				<reportElement x="0" y="1" width="511" height="1" uuid="3e603075-2028-4342-8597-f065dc0f0f6e">
					<property name="local_mesure_unity" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
			</line>
		</band>
	</columnFooter>
</jasperReport>
