<?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="Footer" language="groovy" pageWidth="511" pageHeight="45" whenNoDataType="AllSectionsNoDetail" columnWidth="511" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="e6609d9d-ff80-4849-87e3-17c73f20f011">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="DataAdapter.xml"/>
	<style name="Report Monospace Font" fontName="DejaVu Sans Mono"/>
	<style name="Report Standard Font" fontName="DejaVu Sans"/>
	<parameter name="AD_ORG_ID" class="java.lang.Integer" isForPrompting="false">
		<defaultValueExpression><![CDATA[11]]></defaultValueExpression>
	</parameter>
	<parameter name="P_MsgHelper" class="java.lang.Object" isForPrompting="false"/>
	<parameter name="CURRENT_LANG" class="java.lang.String" isForPrompting="false">
		<parameterDescription><![CDATA[]]></parameterDescription>
		<defaultValueExpression><![CDATA["de_DE"]]></defaultValueExpression>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT ad_org.companyname AS name,
	ad_org.description,
	c_location.city,
	c_location.postal,
	c_location.address1,
	c_location.address2,
	c_location.address3,
	c_location.address4,
	ad_orginfo.phone,
	ad_orginfo.fax,
	ad_orginfo.email,
	ad_orginfo.taxid,
	ad_orginfo.receiptfootermsg,
	COALESCE(c_Bank.name,'') AS bank_Name,
	COALESCE(C_BankAccount.iban_footer,'') AS iban
FROM ad_org
	 INNER JOIN ad_orginfo ON 
	 ad_orginfo.ad_org_id = ad_org.ad_org_id
	 INNER JOIN c_location ON 
	 ad_orginfo.c_location_id = c_location.c_location_id 
	LEFT JOIN C_Bank ON ad_orginfo.transferbank_id = c_bank.c_bank_id
	LEFT JOIN C_BankAccount ON ad_orginfo.transferbank_id = c_BankAccount.c_bank_id
WHERE ad_org.ad_org_id = $P{AD_ORG_ID}]]>
	</queryString>
	<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="ad_org"/>
	</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="ad_org"/>
	</field>
	<field name="city" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="city"/>
		<property name="com.jaspersoft.studio.field.label" value="city"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_location"/>
	</field>
	<field name="postal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="postal"/>
		<property name="com.jaspersoft.studio.field.label" value="postal"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_location"/>
	</field>
	<field name="address1" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="address1"/>
		<property name="com.jaspersoft.studio.field.label" value="address1"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_location"/>
	</field>
	<field name="address2" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="address2"/>
		<property name="com.jaspersoft.studio.field.label" value="address2"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_location"/>
	</field>
	<field name="address3" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="address3"/>
		<property name="com.jaspersoft.studio.field.label" value="address3"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_location"/>
	</field>
	<field name="address4" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="address4"/>
		<property name="com.jaspersoft.studio.field.label" value="address4"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="c_location"/>
	</field>
	<field name="phone" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="phone"/>
		<property name="com.jaspersoft.studio.field.label" value="phone"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ad_orginfo"/>
	</field>
	<field name="fax" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="fax"/>
		<property name="com.jaspersoft.studio.field.label" value="fax"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ad_orginfo"/>
	</field>
	<field name="email" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="email"/>
		<property name="com.jaspersoft.studio.field.label" value="email"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ad_orginfo"/>
	</field>
	<field name="taxid" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="taxid"/>
		<property name="com.jaspersoft.studio.field.label" value="taxid"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ad_orginfo"/>
	</field>
	<field name="receiptfootermsg" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="receiptfootermsg"/>
		<property name="com.jaspersoft.studio.field.label" value="receiptfootermsg"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ad_orginfo"/>
	</field>
	<field name="bank_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="bank_name"/>
		<property name="com.jaspersoft.studio.field.label" value="bank_name"/>
	</field>
	<field name="iban" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="iban"/>
		<property name="com.jaspersoft.studio.field.label" value="iban"/>
	</field>
	<detail>
		<band height="29" splitType="Stretch">
			<textField textAdjust="StretchHeight">
				<reportElement style="Report Standard Font" stretchType="RelativeToTallestObject" x="0" y="0" width="156" height="24" uuid="3e42d439-f8cd-48e4-b904-a1597c916c02"/>
				<textElement>
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{name}+"\n"+($F{receiptfootermsg}!=null?$F{receiptfootermsg}.replaceAll("\\\\(n|r)","\n"):"")]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight">
				<reportElement style="Report Standard Font" stretchType="RelativeToTallestObject" x="168" y="0" width="168" height="24" uuid="1efca5e2-3edc-4dd5-947c-afbcb826b33e"/>
				<textElement>
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{phone}!=null?"Telefon: "+$F{phone}+"\n":"")+($F{fax}!=null?"Fax: "+$F{fax}+"\n":"")+($F{email}!=null?"EMail: "+$F{email}:"")]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight">
				<reportElement style="Report Standard Font" stretchType="RelativeToTallestObject" x="348" y="0" width="156" height="24" uuid="ef574fcb-1723-4296-bfb9-3e111073de04"/>
				<textElement>
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"BX_UST", "USt-ID: ") + $F{taxid} +"\n" + $P{P_MsgHelper}.getClass().getMethod("getMsg",String.class,String.class).invoke($P{P_MsgHelper},"IBAN", "IBAN")+": "+$F{iban}+"\n"+$F{bank_name}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
