Skip to content

Instantly share code, notes, and snippets.

@claudiucotan

claudiucotan/SaleOrder.rptdesign Secret

Created January 16, 2024 07:31
Show Gist options
  • Save claudiucotan/6aaffebd6dc38d6e0ae7608e9884b8ad to your computer and use it in GitHub Desktop.
Save claudiucotan/6aaffebd6dc38d6e0ae7608e9884b8ad to your computer and use it in GitHub Desktop.
Download ZIP
SaleOrder.rptdesign
Raw
SaleOrder.rptdesign
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.9.0.v202202011729</property>
<list-property name="userProperties">
<structure>
<property name="name">test</property>
<property name="type">string</property>
</structure>
</list-property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">4330</property>
</structure>
<structure>
<property name="name">queryTimeOut</property>
<property name="id">4330</property>
</structure>
<structure>
<property name="name">rowFetchSize</property>
<property name="id">4330</property>
</structure>
<structure>
<property name="name">odaURL</property>
<property name="id">209</property>
<expression name="value" type="javascript">params["DBName"].value</expression>
</structure>
<structure>
<property name="name">odaUser</property>
<property name="id">209</property>
<expression name="value" type="javascript">params["UserName"].value</expression>
</structure>
<structure>
<property name="name">odaPassword</property>
<property name="id">209</property>
<expression name="value" type="javascript">params["Password"].value</expression>
</structure>
<structure>
<property name="name">odaDriverClass</property>
<property name="id">209</property>
<expression name="value" type="javascript">params["DefaultDriver"].value</expression>
</structure>
</list-property>
<property name="units">cm</property>
<method name="beforeFactory"><![CDATA[if(params["HeaderHeight"].value != 0 ) {
reportContext.getDesignHandle().findMasterPage("Simple MasterPage").setProperty("headerHeight",params["HeaderHeight"].value+"cm");
}
if(params["FooterHeight"].value != 0) {
reportContext.getDesignHandle().findMasterPage("Simple MasterPage").setProperty("footerHeight",params["FooterHeight"].value+"cm");
}]]></method>
<property name="layoutPreference">auto layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<scalar-parameter name="SaleOrderId" id="3265">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="UserName" id="3796">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="DBName" id="3797">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Password" id="3798">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Locale" id="3740">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">fr</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="AttachmentPath" id="3849">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant"></value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="DefaultDriver" id="3819">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">org.postgresql.Driver</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="ProformaInvoice" id="4308">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">boolean</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">False</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">check-box</property>
<structure name="format"/>
</scalar-parameter>
<scalar-parameter name="HeaderHeight" id="5372">
<property name="valueType">static</property>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="FooterHeight" id="5373">
<property name="valueType">static</property>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="AddressPositionSelect" id="5415">
<property name="valueType">static</property>
<property name="dataType">integer</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">0</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="209">
<list-property name="privateDriverProperties">
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">org.postgresql.Driver</property>
<property name="odaURL">jdbc:postgresql://localhost:5432/</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="SaleOrderDS" id="3669">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">id</property>
<property name="analysis">measure</property>
<text-property name="displayName">id</text-property>
<text-property name="heading">id</text-property>
</structure>
<structure>
<property name="columnName">saleOrderSeq</property>
<property name="analysis">dimension</property>
<text-property name="displayName">saleOrderSeq</text-property>
<text-property name="heading">saleOrderSeq</text-property>
</structure>
<structure>
<property name="columnName">CreationDate</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CreationDate</text-property>
<text-property name="heading">CreationDate</text-property>
</structure>
<structure>
<property name="columnName">SalemanName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">SalemanName</text-property>
<text-property name="heading">SalemanName</text-property>
</structure>
<structure>
<property name="columnName">SalemanPhone</property>
<property name="analysis">dimension</property>
<text-property name="displayName">SalemanPhone</text-property>
<text-property name="heading">SalemanPhone</text-property>
</structure>
<structure>
<property name="columnName">SalemanEmail</property>
<property name="analysis">dimension</property>
<text-property name="displayName">SalemanEmail</text-property>
<text-property name="heading">SalemanEmail</text-property>
</structure>
<structure>
<property name="columnName">DisplaySaleman</property>
<property name="analysis">measure</property>
<text-property name="displayName">DisplaySaleman</text-property>
<text-property name="heading">DisplaySaleman</text-property>
</structure>
<structure>
<property name="columnName">ShipmentDate</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ShipmentDate</text-property>
<text-property name="heading">ShipmentDate</text-property>
</structure>
<structure>
<property name="columnName">ClientBox</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ClientBox</text-property>
<text-property name="heading">ClientBox</text-property>
</structure>
<structure>
<property name="columnName">LegalNote</property>
<property name="analysis">dimension</property>
<text-property name="displayName">LegalNote</text-property>
<text-property name="heading">LegalNote</text-property>
</structure>
<structure>
<property name="columnName">DisplayDeliveryCondition</property>
<property name="analysis">measure</property>
<text-property name="displayName">DisplayDeliveryCondition</text-property>
<text-property name="heading">DisplayDeliveryCondition</text-property>
</structure>
<structure>
<property name="columnName">CompanyName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CompanyName</text-property>
<text-property name="heading">CompanyName</text-property>
</structure>
<structure>
<property name="columnName">logo_path</property>
<property name="analysis">dimension</property>
<text-property name="displayName">logo_path</text-property>
<text-property name="heading">logo_path</text-property>
</structure>
<structure>
<property name="columnName">logo_height</property>
<property name="analysis">measure</property>
<text-property name="displayName">logo_height</text-property>
<text-property name="heading">logo_height</text-property>
</structure>
<structure>
<property name="columnName">logo_width</property>
<property name="analysis">measure</property>
<text-property name="displayName">logo_width</text-property>
<text-property name="heading">logo_width</text-property>
</structure>
<structure>
<property name="columnName">CustomerCode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CustomerCode</text-property>
<text-property name="heading">CustomerCode</text-property>
</structure>
<structure>
<property name="columnName">partner_type_select</property>
<property name="analysis">measure</property>
<text-property name="displayName">partner_type_select</text-property>
<text-property name="heading">partner_type_select</text-property>
</structure>
<structure>
<property name="columnName">ClientPartName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ClientPartName</text-property>
<text-property name="heading">ClientPartName</text-property>
</structure>
<structure>
<property name="columnName">ClientPartFirstName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ClientPartFirstName</text-property>
<text-property name="heading">ClientPartFirstName</text-property>
</structure>
<structure>
<property name="columnName">ClientTitle</property>
<property name="analysis">measure</property>
<text-property name="displayName">ClientTitle</text-property>
<text-property name="heading">ClientTitle</text-property>
</structure>
<structure>
<property name="columnName">ContactName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ContactName</text-property>
<text-property name="heading">ContactName</text-property>
</structure>
<structure>
<property name="columnName">ContactFirstName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ContactFirstName</text-property>
<text-property name="heading">ContactFirstName</text-property>
</structure>
<structure>
<property name="columnName">invoicecountry</property>
<property name="analysis">dimension</property>
<text-property name="displayName">invoicecountry</text-property>
<text-property name="heading">invoicecountry</text-property>
</structure>
<structure>
<property name="columnName">DeliveryCountry</property>
<property name="analysis">dimension</property>
<text-property name="displayName">DeliveryCountry</text-property>
<text-property name="heading">DeliveryCountry</text-property>
</structure>
<structure>
<property name="columnName">invoicingAddress</property>
<property name="analysis">dimension</property>
<text-property name="displayName">invoicingAddress</text-property>
<text-property name="heading">invoicingAddress</text-property>
</structure>
<structure>
<property name="columnName">deliveryAddress</property>
<property name="analysis">dimension</property>
<text-property name="displayName">deliveryAddress</text-property>
<text-property name="heading">deliveryAddress</text-property>
</structure>
<structure>
<property name="columnName">PaymentCondName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">PaymentCondName</text-property>
<text-property name="heading">PaymentCondName</text-property>
</structure>
<structure>
<property name="columnName">PaymentMode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">PaymentMode</text-property>
<text-property name="heading">PaymentMode</text-property>
</structure>
<structure>
<property name="columnName">ex_tax_total</property>
<property name="analysis">measure</property>
<text-property name="displayName">ex_tax_total</text-property>
<text-property name="heading">ex_tax_total</text-property>
</structure>
<structure>
<property name="columnName">tax_total</property>
<property name="analysis">measure</property>
<text-property name="displayName">tax_total</text-property>
<text-property name="heading">tax_total</text-property>
</structure>
<structure>
<property name="columnName">in_tax_total</property>
<property name="analysis">measure</property>
<text-property name="displayName">in_tax_total</text-property>
<text-property name="heading">in_tax_total</text-property>
</structure>
<structure>
<property name="columnName">bank_address</property>
<property name="analysis">dimension</property>
<text-property name="displayName">bank_address</text-property>
<text-property name="heading">bank_address</text-property>
</structure>
<structure>
<property name="columnName">iban</property>
<property name="analysis">dimension</property>
<text-property name="displayName">iban</text-property>
<text-property name="heading">iban</text-property>
</structure>
<structure>
<property name="columnName">bic</property>
<property name="analysis">dimension</property>
<text-property name="displayName">bic</text-property>
<text-property name="heading">bic</text-property>
</structure>
<structure>
<property name="columnName">CurrencyCode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CurrencyCode</text-property>
<text-property name="heading">CurrencyCode</text-property>
</structure>
<structure>
<property name="columnName">external_reference</property>
<property name="analysis">dimension</property>
<text-property name="displayName">external_reference</text-property>
<text-property name="heading">external_reference</text-property>
</structure>
<structure>
<property name="columnName">header</property>
<property name="analysis">dimension</property>
<text-property name="displayName">header</text-property>
<text-property name="heading">header</text-property>
</structure>
<structure>
<property name="columnName">footer</property>
<property name="analysis">dimension</property>
<text-property name="displayName">footer</text-property>
<text-property name="heading">footer</text-property>
</structure>
<structure>
<property name="columnName">description</property>
<property name="analysis">dimension</property>
<text-property name="displayName">description</text-property>
<text-property name="heading">description</text-property>
</structure>
<structure>
<property name="columnName">durationValue</property>
<property name="analysis">measure</property>
<text-property name="displayName">durationValue</text-property>
<text-property name="heading">durationValue</text-property>
</structure>
<structure>
<property name="columnName">durationType</property>
<property name="analysis">measure</property>
<text-property name="displayName">durationType</text-property>
<text-property name="heading">durationType</text-property>
</structure>
<structure>
<property name="columnName">estimatedShippingDate</property>
<property name="analysis">dimension</property>
<text-property name="displayName">estimatedShippingDate</text-property>
<text-property name="heading">estimatedShippingDate</text-property>
</structure>
<structure>
<property name="columnName">deliveryCondition</property>
<property name="analysis">dimension</property>
<text-property name="displayName">deliveryCondition</text-property>
<text-property name="heading">deliveryCondition</text-property>
</structure>
<structure>
<property name="columnName">hideDiscount</property>
<property name="analysis">measure</property>
<text-property name="displayName">hideDiscount</text-property>
<text-property name="heading">hideDiscount</text-property>
</structure>
<structure>
<property name="columnName">displayProductCodeOnPrinting</property>
<property name="analysis">measure</property>
<text-property name="displayName">displayProductCodeOnPrinting</text-property>
<text-property name="heading">displayProductCodeOnPrinting</text-property>
</structure>
<structure>
<property name="columnName">displayTaxDetailOnPrinting</property>
<property name="analysis">measure</property>
<text-property name="displayName">displayTaxDetailOnPrinting</text-property>
<text-property name="heading">displayTaxDetailOnPrinting</text-property>
</structure>
<structure>
<property name="columnName">displayEstimShipDateOnPrinting</property>
<property name="analysis">measure</property>
<text-property name="displayName">displayEstimShipDateOnPrinting</text-property>
<text-property name="heading">displayEstimShipDateOnPrinting</text-property>
</structure>
<structure>
<property name="columnName">sale_order_type_select</property>
<property name="analysis">measure</property>
<text-property name="displayName">sale_order_type_select</text-property>
<text-property name="heading">sale_order_type_select</text-property>
</structure>
<structure>
<property name="columnName">status_select</property>
<property name="analysis">measure</property>
<text-property name="displayName">status_select</text-property>
<text-property name="heading">status_select</text-property>
</structure>
<structure>
<property name="columnName">specific_notes</property>
<property name="analysis">dimension</property>
<text-property name="displayName">specific_notes</text-property>
<text-property name="heading">specific_notes</text-property>
</structure>
<structure>
<property name="columnName">versionNumber</property>
<property name="analysis">measure</property>
<text-property name="displayName">versionNumber</text-property>
<text-property name="heading">versionNumber</text-property>
</structure>
<structure>
<property name="columnName">logoPosition</property>
<property name="analysis">measure</property>
<text-property name="displayName">logoPosition</text-property>
<text-property name="heading">logoPosition</text-property>
</structure>
<structure>
<property name="columnName">salesperson_signature_path</property>
<property name="analysis">dimension</property>
<text-property name="displayName">salesperson_signature_path</text-property>
<text-property name="heading">salesperson_signature_path</text-property>
</structure>
<structure>
<property name="columnName">periodicity_type_select</property>
<property name="analysis">measure</property>
<text-property name="displayName">periodicity_type_select</text-property>
<text-property name="heading">periodicity_type_select</text-property>
</structure>
<structure>
<property name="columnName">number_of_periods</property>
<property name="analysis">measure</property>
<text-property name="displayName">number_of_periods</text-property>
<text-property name="heading">number_of_periods</text-property>
</structure>
<structure>
<property name="columnName">subscription_text</property>
<property name="analysis">dimension</property>
<text-property name="displayName">subscription_text</text-property>
<text-property name="heading">subscription_text</text-property>
</structure>
<structure>
<property name="columnName">end_of_validity_date</property>
<property name="analysis">dimension</property>
<text-property name="displayName">end_of_validity_date</text-property>
<text-property name="heading">end_of_validity_date</text-property>
</structure>
<structure>
<property name="columnName">in_ati</property>
<property name="analysis">measure</property>
<text-property name="displayName">in_ati</text-property>
<text-property name="heading">in_ati</text-property>
</structure>
<structure>
<property name="columnName">isIspmRequired</property>
<property name="analysis">measure</property>
<text-property name="displayName">isIspmRequired</text-property>
<text-property name="heading">isIspmRequired</text-property>
</structure>
<structure>
<property name="columnName">displayCustomerCodeOnPrinting</property>
<property name="analysis">measure</property>
<text-property name="displayName">displayCustomerCodeOnPrinting</text-property>
<text-property name="heading">displayCustomerCodeOnPrinting</text-property>
</structure>
<structure>
<property name="columnName">displayProductPictureOnPrinting</property>
<property name="analysis">measure</property>
<text-property name="displayName">displayProductPictureOnPrinting</text-property>
<text-property name="heading">displayProductPictureOnPrinting</text-property>
</structure>
<structure>
<property name="columnName">ProformaComments</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ProformaComments</text-property>
<text-property name="heading">ProformaComments</text-property>
</structure>
<structure>
<property name="columnName">enablePackMangement</property>
<property name="analysis">measure</property>
<text-property name="displayName">enablePackMangement</text-property>
<text-property name="heading">enablePackMangement</text-property>
</structure>
<structure>
<property name="columnName">useSignature</property>
<property name="analysis">measure</property>
<text-property name="displayName">useSignature</text-property>
<text-property name="heading">useSignature</text-property>
</structure>
<structure>
<property name="columnName">contactPartnerTitleSelect</property>
<property name="analysis">measure</property>
<text-property name="displayName">contactPartnerTitleSelect</text-property>
<text-property name="heading">contactPartnerTitleSelect</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SaleOrderId</property>
<property name="nativeName"></property>
<property name="dataType">decimal</property>
<property name="nativeDataType">-5</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">saleOrderSeq</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CreationDate</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SalemanName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SalemanPhone</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">SalemanEmail</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">DisplaySaleman</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ShipmentDate</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ClientBox</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">LegalNote</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">DisplayDeliveryCondition</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">CompanyName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">logo_path</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">logo_height</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">logo_width</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CustomerCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">partner_type_select</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ClientPartName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">ClientPartFirstName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">ClientTitle</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">ContactName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">ContactFirstName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">invoicecountry</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">DeliveryCountry</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">invoicingAddress</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">deliveryAddress</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">PaymentCondName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">PaymentMode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">ex_tax_total</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">tax_total</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">in_tax_total</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">bank_address</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">iban</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">bic</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">35</property>
<property name="name">CurrencyCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">36</property>
<property name="name">external_reference</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">37</property>
<property name="name">header</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">38</property>
<property name="name">footer</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">39</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">40</property>
<property name="name">durationValue</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">41</property>
<property name="name">durationType</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">42</property>
<property name="name">estimatedShippingDate</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">43</property>
<property name="name">deliveryCondition</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">44</property>
<property name="name">hideDiscount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">45</property>
<property name="name">displayProductCodeOnPrinting</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">46</property>
<property name="name">displayTaxDetailOnPrinting</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">47</property>
<property name="name">displayEstimShipDateOnPrinting</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">48</property>
<property name="name">sale_order_type_select</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">49</property>
<property name="name">status_select</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">50</property>
<property name="name">specific_notes</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">51</property>
<property name="name">versionNumber</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">52</property>
<property name="name">logoPosition</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">53</property>
<property name="name">salesperson_signature_path</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">54</property>
<property name="name">periodicity_type_select</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">55</property>
<property name="name">number_of_periods</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">56</property>
<property name="name">subscription_text</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">57</property>
<property name="name">end_of_validity_date</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">58</property>
<property name="name">in_ati</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">59</property>
<property name="name">isIspmRequired</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">60</property>
<property name="name">displayCustomerCodeOnPrinting</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">61</property>
<property name="name">displayProductPictureOnPrinting</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">62</property>
<property name="name">ProformaComments</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">63</property>
<property name="name">enablePackMangement</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">64</property>
<property name="name">useSignature</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">65</property>
<property name="name">contactPartnerTitleSelect</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">66</property>
<property name="name">tableFontSize</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="nativeName">id</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">-5</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">saleOrderSeq</property>
<property name="nativeName">saleOrderSeq</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CreationDate</property>
<property name="nativeName">CreationDate</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SalemanName</property>
<property name="nativeName">SalemanName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SalemanPhone</property>
<property name="nativeName">SalemanPhone</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">SalemanEmail</property>
<property name="nativeName">SalemanEmail</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">DisplaySaleman</property>
<property name="nativeName">DisplaySaleman</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ShipmentDate</property>
<property name="nativeName">ShipmentDate</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ClientBox</property>
<property name="nativeName">ClientBox</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">LegalNote</property>
<property name="nativeName">LegalNote</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">DisplayDeliveryCondition</property>
<property name="nativeName">DisplayDeliveryCondition</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">CompanyName</property>
<property name="nativeName">CompanyName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">logo_path</property>
<property name="nativeName">logo_path</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">logo_height</property>
<property name="nativeName">logo_height</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">logo_width</property>
<property name="nativeName">logo_width</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CustomerCode</property>
<property name="nativeName">CustomerCode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">partner_type_select</property>
<property name="nativeName">partner_type_select</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ClientPartName</property>
<property name="nativeName">ClientPartName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">ClientPartFirstName</property>
<property name="nativeName">ClientPartFirstName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">ClientTitle</property>
<property name="nativeName">ClientTitle</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">ContactName</property>
<property name="nativeName">ContactName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">ContactFirstName</property>
<property name="nativeName">ContactFirstName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">invoicecountry</property>
<property name="nativeName">invoicecountry</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">DeliveryCountry</property>
<property name="nativeName">DeliveryCountry</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">invoicingAddress</property>
<property name="nativeName">invoicingAddress</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">deliveryAddress</property>
<property name="nativeName">deliveryAddress</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">PaymentCondName</property>
<property name="nativeName">PaymentCondName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">PaymentMode</property>
<property name="nativeName">PaymentMode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">ex_tax_total</property>
<property name="nativeName">ex_tax_total</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">tax_total</property>
<property name="nativeName">tax_total</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">in_tax_total</property>
<property name="nativeName">in_tax_total</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">bank_address</property>
<property name="nativeName">bank_address</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">iban</property>
<property name="nativeName">iban</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">bic</property>
<property name="nativeName">bic</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">35</property>
<property name="name">CurrencyCode</property>
<property name="nativeName">CurrencyCode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">36</property>
<property name="name">external_reference</property>
<property name="nativeName">external_reference</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">37</property>
<property name="name">header</property>
<property name="nativeName">header</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">38</property>
<property name="name">footer</property>
<property name="nativeName">footer</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">39</property>
<property name="name">description</property>
<property name="nativeName">description</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">40</property>
<property name="name">durationValue</property>
<property name="nativeName">durationValue</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">41</property>
<property name="name">durationType</property>
<property name="nativeName">durationType</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">42</property>
<property name="name">estimatedShippingDate</property>
<property name="nativeName">estimatedShippingDate</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">43</property>
<property name="name">deliveryCondition</property>
<property name="nativeName">deliveryCondition</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">44</property>
<property name="name">hideDiscount</property>
<property name="nativeName">hideDiscount</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">45</property>
<property name="name">displayProductCodeOnPrinting</property>
<property name="nativeName">displayProductCodeOnPrinting</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">46</property>
<property name="name">displayTaxDetailOnPrinting</property>
<property name="nativeName">displayTaxDetailOnPrinting</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">47</property>
<property name="name">displayEstimShipDateOnPrinting</property>
<property name="nativeName">displayEstimShipDateOnPrinting</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">48</property>
<property name="name">sale_order_type_select</property>
<property name="nativeName">sale_order_type_select</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">49</property>
<property name="name">status_select</property>
<property name="nativeName">status_select</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">50</property>
<property name="name">specific_notes</property>
<property name="nativeName">specific_notes</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">51</property>
<property name="name">versionNumber</property>
<property name="nativeName">versionNumber</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">52</property>
<property name="name">logoPosition</property>
<property name="nativeName">logoPosition</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">53</property>
<property name="name">salesperson_signature_path</property>
<property name="nativeName">salesperson_signature_path</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">54</property>
<property name="name">periodicity_type_select</property>
<property name="nativeName">periodicity_type_select</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">55</property>
<property name="name">number_of_periods</property>
<property name="nativeName">number_of_periods</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">56</property>
<property name="name">subscription_text</property>
<property name="nativeName">subscription_text</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">57</property>
<property name="name">end_of_validity_date</property>
<property name="nativeName">end_of_validity_date</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">58</property>
<property name="name">in_ati</property>
<property name="nativeName">in_ati</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">59</property>
<property name="name">isIspmRequired</property>
<property name="nativeName">isIspmRequired</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">60</property>
<property name="name">displayCustomerCodeOnPrinting</property>
<property name="nativeName">displayCustomerCodeOnPrinting</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">61</property>
<property name="name">displayProductPictureOnPrinting</property>
<property name="nativeName">displayProductPictureOnPrinting</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">62</property>
<property name="name">ProformaComments</property>
<property name="nativeName">ProformaComments</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">63</property>
<property name="name">enablePackMangement</property>
<property name="nativeName">enablePackMangement</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">64</property>
<property name="name">useSignature</property>
<property name="nativeName">useSignature</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">65</property>
<property name="name">contactPartnerTitleSelect</property>
<property name="nativeName">contactPartnerTitleSelect</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select SaleOrder.id, SaleOrder.sale_order_seq as "saleOrderSeq", SaleOrder.creation_date as "CreationDate",
CONCAT(SalemanPartner.name, ' ', SalemanPartner.first_name) as "SalemanName", SalemanPartner.fixed_phone as "SalemanPhone",
SalemanEmailAddress.address as "SalemanEmail", SaleConfig.display_saleman_on_printing as "DisplaySaleman",
SaleOrder.shipment_date as "ShipmentDate", SaleConfig.sale_order_client_box as "ClientBox",
SaleConfig.sale_order_legal_note as "LegalNote", SaleConfig.display_del_cond_on_printing as "DisplayDeliveryCondition",
Company.name as "CompanyName", coalesce(MetaFileTN.file_path, MetaFile.file_path) as logo_path,
Company.height as "logo_height", Company.width as "logo_width",
ClientPartner.partner_seq as "CustomerCode", ClientPartner.partner_type_select, ClientPartner.name as "ClientPartName",
ClientPartner.first_name as "ClientPartFirstName", ClientPartner.title_select as "ClientTitle",
ContactPartner.name as "ContactName", ContactPartner.first_name as "ContactFirstName",
InvoicingCountry.name as "invoicecountry", DeliveryCountry.name as "DeliveryCountry",
SaleOrder.main_invoicing_address_str as "invoicingAddress",
SaleOrder.delivery_address_str as "deliveryAddress",
PaymentCondition.name as "PaymentCondName", PaymentMode.name as "PaymentMode",
SaleOrder.ex_tax_total, SaleOrder.tax_total, SaleOrder.in_tax_total, BankAddress.address as "bank_address",
BankDetail.iban, Bank.code as "bic", Currency.code as "CurrencyCode", SaleOrder.external_reference,
PrintingSettings.pdf_header as "header", PrintingSettings.pdf_footer as "footer", SaleOrder.description as "description",
Duration.value as "durationValue", Duration.type_select as "durationType",
SaleOrder.estimated_shipping_date as "estimatedShippingDate", SaleOrder.delivery_condition as "deliveryCondition",
SaleOrder.hide_discount as "hideDiscount", SaleConfig.display_product_code_on_printing as "displayProductCodeOnPrinting",
SaleConfig.display_tax_detail_on_printing as "displayTaxDetailOnPrinting",
SaleConfig.display_estim_ship_date_on_printing as "displayEstimShipDateOnPrinting",
SaleOrder.sale_order_type_select,SaleOrder.status_select, SaleOrder.specific_notes,
SaleOrder.version_number as "versionNumber",
PrintingSettings.logo_position_select as "logoPosition",
SignatureFile.file_path as "salesperson_signature_path",
SaleOrder.periodicity_type_select,
SaleOrder.number_of_periods,
SaleOrder.subscription_text,
SaleOrder.end_of_validity_date,
SaleOrder.in_ati,
SaleOrder.is_ispm_required as "isIspmRequired",
SaleConfig.display_customer_code_on_printing as "displayCustomerCodeOnPrinting",
SaleConfig.display_product_picture_on_printing as "displayProductPictureOnPrinting",
SaleOrder.proforma_comments as "ProformaComments",
AppSale.enable_pack_management as "enablePackMangement",
SalespersonUser.use_signature_for_sales_quotations as "useSignature",
ContactPartner.title_select as "contactPartnerTitleSelect",
PrintingSettings.table_font_size as "tableFontSize"
from sale_sale_order as SaleOrder
left outer join base_company as Company on (SaleOrder.company = Company.id)
left outer join studio_app_sale as AppSale on true
left outer join meta_file as MetaFile on (MetaFile.id = Company.logo)
left outer join base_partner as ClientPartner on (SaleOrder.client_partner = ClientPartner.id)
left outer join base_partner as ContactPartner on (SaleOrder.contact_partner = ContactPartner.id)
left outer join base_address as InvoicingAddress on (SaleOrder.main_invoicing_address = InvoicingAddress.id)
left outer join base_country as InvoicingCountry on (InvoicingAddress.addressl7country = InvoicingCountry.id)
left outer join account_payment_condition as PaymentCondition on (SaleOrder.payment_condition = PaymentCondition.id)
left outer join account_payment_mode as PaymentMode on (SaleOrder.payment_mode = PaymentMode.id)
left outer join base_address as DeliveryAddress on (SaleOrder.delivery_address = DeliveryAddress.id)
left outer join base_country as DeliveryCountry on (DeliveryAddress.addressl7country = DeliveryCountry.id)
left outer join base_bank_details as BankDetail on (SaleOrder.company_bank_details = BankDetail.id)
left outer join base_currency as Currency on (SaleOrder.currency = Currency.id)
left outer join base_printing_settings as PrintingSettings on (SaleOrder.printing_settings = PrintingSettings.id AND
AppSale.printing_config_per_sale_order = true ) OR (Company.printing_settings = PrintingSettings.id
AND (AppSale.printing_config_per_sale_order = null OR AppSale.printing_config_per_sale_order = false
OR SaleOrder.printing_settings is null ))
left outer join auth_user as SalespersonUser on (SaleOrder.salesperson_user = SalespersonUser.id)
left outer join base_partner as SalemanPartner on (SalespersonUser.partner = SalemanPartner.id)
left outer join message_email_address as SalemanEmailAddress on (SalemanPartner.email_address = SalemanEmailAddress.id)
left outer join sale_sale_config as SaleConfig on (SaleConfig.company = Company.id)
left outer join base_duration as Duration on (SaleOrder.duration = Duration.id)
left outer join base_bank as Bank on (BankDetail.bank = Bank.id)
left outer join base_bank_address as BankAddress on (BankDetail.bank_address = BankAddress.id)
left outer join meta_file as SignatureFile on SalespersonUser.electronic_signature = SignatureFile.id
left outer join base_trading_name as TradingName on (TradingName.id = SaleOrder.trading_name)
left outer join meta_file as MetaFileTN on (MetaFileTN.id = TradingName.logo)
where SaleOrder.id = ?]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="OrderLineDS" id="3678">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">id</property>
<property name="analysis">measure</property>
<text-property name="displayName">id</text-property>
<text-property name="heading">id</text-property>
</structure>
<structure>
<property name="columnName">ProductName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ProductName</text-property>
<text-property name="heading">ProductName</text-property>
</structure>
<structure>
<property name="columnName">description</property>
<property name="analysis">dimension</property>
<text-property name="displayName">description</text-property>
<text-property name="heading">description</text-property>
</structure>
<structure>
<property name="columnName">product_type_select</property>
<property name="analysis">dimension</property>
<text-property name="displayName">product_type_select</text-property>
<text-property name="heading">product_type_select</text-property>
</structure>
<structure>
<property name="columnName">quantity</property>
<property name="analysis">measure</property>
<text-property name="displayName">quantity</text-property>
<text-property name="heading">quantity</text-property>
</structure>
<structure>
<property name="columnName">unit_price</property>
<property name="analysis">measure</property>
<text-property name="displayName">unit_price</text-property>
<text-property name="heading">unit_price</text-property>
</structure>
<structure>
<property name="columnName">totalDiscountAmount</property>
<property name="analysis">measure</property>
<text-property name="displayName">totalDiscountAmount</text-property>
<text-property name="heading">totalDiscountAmount</text-property>
</structure>
<structure>
<property name="columnName">ex_tax_total</property>
<property name="analysis">measure</property>
<text-property name="displayName">ex_tax_total</text-property>
<text-property name="heading">ex_tax_total</text-property>
</structure>
<structure>
<property name="columnName">in_tax_total</property>
<property name="analysis">measure</property>
<text-property name="displayName">in_tax_total</text-property>
<text-property name="heading">in_tax_total</text-property>
</structure>
<structure>
<property name="columnName">CurrencyCode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CurrencyCode</text-property>
<text-property name="heading">CurrencyCode</text-property>
</structure>
<structure>
<property name="columnName">tax_line</property>
<property name="analysis">measure</property>
<text-property name="displayName">tax_line</text-property>
<text-property name="heading">tax_line</text-property>
</structure>
<structure>
<property name="columnName">productPicture</property>
<property name="analysis">dimension</property>
<text-property name="displayName">productPicture</text-property>
<text-property name="heading">productPicture</text-property>
</structure>
<structure>
<property name="columnName">sequence</property>
<property name="analysis">measure</property>
<text-property name="displayName">sequence</text-property>
<text-property name="heading">sequence</text-property>
</structure>
<structure>
<property name="columnName">sale_order_type_select</property>
<property name="analysis">measure</property>
<text-property name="displayName">sale_order_type_select</text-property>
<text-property name="heading">sale_order_type_select</text-property>
</structure>
<structure>
<property name="columnName">typeSelect</property>
<property name="analysis">measure</property>
<text-property name="displayName">typeSelect</text-property>
<text-property name="heading">typeSelect</text-property>
</structure>
<structure>
<property name="columnName">in_ati</property>
<property name="analysis">measure</property>
<text-property name="displayName">in_ati</text-property>
<text-property name="heading">in_ati</text-property>
</structure>
<structure>
<property name="columnName">productCode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">productCode</text-property>
<text-property name="heading">productCode</text-property>
</structure>
<structure>
<property name="columnName">CustomerProductCode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CustomerProductCode</text-property>
<text-property name="heading">CustomerProductCode</text-property>
</structure>
<structure>
<property name="columnName">CustomerProductName</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CustomerProductName</text-property>
<text-property name="heading">CustomerProductName</text-property>
</structure>
<structure>
<property name="columnName">EstimatedShippingDate</property>
<property name="analysis">dimension</property>
<text-property name="displayName">EstimatedShippingDate</text-property>
<text-property name="heading">EstimatedShippingDate</text-property>
</structure>
<structure>
<property name="columnName">price_discounted</property>
<property name="analysis">measure</property>
<text-property name="displayName">price_discounted</text-property>
<text-property name="heading">price_discounted</text-property>
</structure>
<structure>
<property name="columnName">showTotal</property>
<property name="analysis">measure</property>
<text-property name="displayName">showTotal</text-property>
<text-property name="heading">showTotal</text-property>
</structure>
<structure>
<property name="columnName">hideUnitAmounts</property>
<property name="analysis">measure</property>
<text-property name="displayName">hideUnitAmounts</text-property>
<text-property name="heading">hideUnitAmounts</text-property>
</structure>
<structure>
<property name="columnName">UnitCode</property>
<property name="analysis">dimension</property>
<text-property name="displayName">UnitCode</text-property>
<text-property name="heading">UnitCode</text-property>
</structure>
<structure>
<property name="columnName">packHideUnitAmounts</property>
<property name="analysis">measure</property>
<text-property name="displayName">packHideUnitAmounts</text-property>
<text-property name="heading">packHideUnitAmounts</text-property>
</structure>
</list-property>
<list-property name="filter"/>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SaleOrderId</property>
<property name="nativeName"></property>
<property name="dataType">decimal</property>
<property name="nativeDataType">-5</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ProductName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">product_type_select</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">quantity</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">unit_price</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">totalDiscountAmount</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ex_tax_total</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">in_tax_total</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CurrencyCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">tax_line</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">productPicture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">sequence</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">sale_order_type_select</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">typeSelect</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">in_ati</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">productCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">CustomerProductCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">CustomerProductName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">EstimatedShippingDate</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">price_discounted</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">showTotal</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">hideUnitAmounts</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">UnitCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">packHideUnitAmounts</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</property>
<property name="nativeName">id</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">-5</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ProductName</property>
<property name="nativeName">ProductName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">description</property>
<property name="nativeName">description</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">product_type_select</property>
<property name="nativeName">product_type_select</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">quantity</property>
<property name="nativeName">quantity</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">unit_price</property>
<property name="nativeName">unit_price</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">totalDiscountAmount</property>
<property name="nativeName">totalDiscountAmount</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ex_tax_total</property>
<property name="nativeName">ex_tax_total</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">in_tax_total</property>
<property name="nativeName">in_tax_total</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CurrencyCode</property>
<property name="nativeName">CurrencyCode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">tax_line</property>
<property name="nativeName">tax_line</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">productPicture</property>
<property name="nativeName">productPicture</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">sequence</property>
<property name="nativeName">sequence</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">sale_order_type_select</property>
<property name="nativeName">sale_order_type_select</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">typeSelect</property>
<property name="nativeName">typeSelect</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">in_ati</property>
<property name="nativeName">in_ati</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">productCode</property>
<property name="nativeName">productCode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">CustomerProductCode</property>
<property name="nativeName">CustomerProductCode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">CustomerProductName</property>
<property name="nativeName">CustomerProductName</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">EstimatedShippingDate</property>
<property name="nativeName">EstimatedShippingDate</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">price_discounted</property>
<property name="nativeName">price_discounted</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">showTotal</property>
<property name="nativeName">showTotal</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">hideUnitAmounts</property>
<property name="nativeName">hideUnitAmounts</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">UnitCode</property>
<property name="nativeName">UnitCode</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">packHideUnitAmounts</property>
<property name="nativeName">packHideUnitAmounts</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-7</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[WITH SOL AS (
SELECT
SaleOrder.id as SaleOrderId,
SOLine.id,
SOLine.product_name as "ProductName",
ProductCategory.name as product_category_name,
SOLine.description,
Product.product_type_select,
SOLine.qty as "quantity",
(CASE WHEN SaleOrder.in_ati
THEN SOLine.in_tax_price
ELSE SOLine.price END)
as "unit_price",
(SOLine.price_discounted
- (CASE WHEN SaleOrder.in_ati
THEN SOLine.in_tax_price
ELSE SOLine.price END))
* SOLine.qty
as "totalDiscountAmount",
SOLine.ex_tax_total,
SOLine.in_tax_total,
Currency.code as "CurrencyCode",
TaxLine.value as "tax_line",
MetaFile.file_path as "productPicture",
SOLine.sequence,
SOLine.type_select as "typeSelect",
SaleOrder.in_ati,
Product.code as "productCode",
ProductCategory.code as product_category_code,
SaleOrder.sale_order_type_select,
CustomerCatalog.product_customer_code as "CustomerProductCode",
CustomerCatalog.product_customer_name as "CustomerProductName",
SOLine.estimated_shipping_date as "EstimatedShippingDate",
SOLine.price_discounted as "price_discounted",
SOLine.is_show_total as "showTotal",
SOLine.is_hide_unit_amounts as "hideUnitAmounts",
Unit.label_to_printing as "UnitCode",
(SELECT is_hide_unit_amounts from sale_sale_order_line as SOL
WHERE SOL.sale_order = SOLine.sale_order AND SOL.type_select IN (2, 3) AND SOL.sequence > SOLine.sequence order by SOL.sequence limit 1) as "packHideUnitAmounts"
from sale_sale_order as SaleOrder
left outer join sale_sale_order_line as SOLine on (SOLine.sale_order = SaleOrder.id)
left outer join base_product as Product on (SOLine.product = Product.id)
left outer join base_product_category as ProductCategory on (Product.product_category = ProductCategory.id)
left outer join base_unit as Unit on (SOLine.unit = Unit.id)
left outer join base_currency as Currency on (SaleOrder.currency = Currency.id)
left outer join account_tax_line as TaxLine on (SOLine.tax_line = TaxLine.id)
left outer join sale_customer_catalog as CustomerCatalog on (CustomerCatalog.product = Product.id and CustomerCatalog.customer_partner = SaleOrder.client_partner)
left outer join meta_file as MetaFile on (MetaFile.id = Product.picture)
where SaleOrder.id = ?)
SELECT
SOL.id,
SOL."ProductName",
SOL.description,
SOL.product_type_select,
SOL."quantity",
SOL."unit_price",
SOL."totalDiscountAmount",
SOL.ex_tax_total,
SOL.in_tax_total,
SOL."CurrencyCode",
SOL."tax_line",
SOL."productPicture",
SOL.sequence,
SOL.sale_order_type_select,
SOL."typeSelect",
SOL.in_ati,
SOL."productCode",
SOL."CustomerProductCode",
SOL."CustomerProductName",
SOL."EstimatedShippingDate",
SOL."price_discounted",
SOL."showTotal",
SOL."hideUnitAmounts",
SOL."UnitCode",
SOL."packHideUnitAmounts"
FROM SOL
LEFT JOIN studio_app_base AppBase ON (AppBase.id = (SELECT max(id) FROM studio_app_base))
LEFT JOIN sale_sale_order SaleOrder ON (SOL.SaleOrderId = SaleOrder.id)
WHERE AppBase.is_regroup_products_on_printings IS NULL OR AppBase.is_regroup_products_on_printings IS FALSE
OR SaleOrder.group_products_on_printings IS NULL OR SaleOrder.group_products_on_printings IS FALSE
OR ( (AppBase.regroup_products_type_select NOT LIKE '%products%' AND SOL.product_type_select = 'storable')
OR (AppBase.regroup_products_type_select NOT LIKE '%services%' AND SOL.product_type_select = 'service'))
UNION
SELECT
MIN(SOL.id) as id,
SOL.product_category_name as "ProductName",
null as description,
SOL.product_type_select,
SUM(SOL."quantity") as "quantity",
CASE WHEN SUM(SOL."quantity") != 0
THEN (SUM(SOL."unit_price" * SOL."quantity") / SUM(SOL."quantity"))
ELSE 0 END
as "unit_price",
SUM(SOL."totalDiscountAmount") as "totalDiscountAmount",
SUM(SOL.ex_tax_total) as ex_tax_total,
SUM(SOL.in_tax_total) as in_tax_total,
SOL."CurrencyCode",
null as "tax_line",
null as "productPicture",
MIN(SOL.sequence) as sequence,
null as sale_order_type_select,
MIN(SOL."typeSelect") as "typeSelect",
BOOL_AND(SOL.in_ati) as in_ati,
SOL.product_category_code as "productCode",
null as "CustomerProductCode",
null as "CustomerProductName",
MAX(SOL."EstimatedShippingDate") as "EstimatedShippingDate",
SUM(SOL."price_discounted") as "price_discounted",
BOOL_AND(SOL."showTotal") as "showTotal",
BOOL_OR(SOL."hideUnitAmounts") as "hideUnitAmounts",
SOL."UnitCode",
BOOL_AND(SOL."packHideUnitAmounts") as "packHideUnitAmounts"
FROM SOL
LEFT JOIN studio_app_base AppBase ON (AppBase.id = (SELECT max(id) FROM studio_app_base))
LEFT JOIN sale_sale_order SaleOrder ON (SOL.SaleOrderId = SaleOrder.id)
WHERE AppBase.is_regroup_products_on_printings IS TRUE AND SaleOrder.group_products_on_printings IS TRUE
AND AppBase.regroup_products_level_select = 'category'
AND ((AppBase.regroup_products_type_select LIKE '%products%' AND SOL.product_type_select = 'storable')
OR (AppBase.regroup_products_type_select LIKE '%services%' AND SOL.product_type_select = 'service'))
group by product_category_name, product_category_code, product_type_select, "UnitCode", "CurrencyCode"
UNION
SELECT
MIN(SOL.id) as id,
CASE WHEN (SOL.product_type_select LIKE 'storable')
THEN AppBase.regroup_products_label_products
ELSE AppBase.regroup_products_label_services END as "ProductName",
null as description,
SOL.product_type_select,
SUM(SOL."quantity") as "quantity",
CASE WHEN SUM(SOL."quantity") != 0
THEN (SUM(SOL."unit_price" * SOL."quantity") / SUM(SOL."quantity"))
ELSE 0 END
as "unit_price",
SUM(SOL."totalDiscountAmount") as "totalDiscountAmount",
SUM(SOL.ex_tax_total) as ex_tax_total,
SUM(SOL.in_tax_total) as in_tax_total,
SOL."CurrencyCode",
null as "tax_line",
null as "productPicture",
MIN(SOL.sequence) as sequence,
null as sale_order_type_select,
MIN(SOL."typeSelect") as "typeSelect",
BOOL_AND(SOL.in_ati) as in_ati,
null as "productCode",
null as "CustomerProductCode",
null as "CustomerProductName",
MAX(SOL."EstimatedShippingDate") as "EstimatedShippingDate",
SUM(SOL."price_discounted") as "price_discounted",
BOOL_AND(SOL."showTotal") as "showTotal",
BOOL_OR(SOL."hideUnitAmounts") as "hideUnitAmounts",
SOL."UnitCode",
BOOL_AND(SOL."packHideUnitAmounts") as "packHideUnitAmounts"
FROM SOL
LEFT JOIN studio_app_base AppBase ON (AppBase.id = (SELECT max(id) FROM studio_app_base))
LEFT JOIN sale_sale_order SaleOrder ON (SOL.SaleOrderId = SaleOrder.id)
WHERE AppBase.is_regroup_products_on_printings IS TRUE AND SaleOrder.group_products_on_printings IS TRUE
AND AppBase.regroup_products_level_select = 'global'
AND ((AppBase.regroup_products_type_select LIKE '%products%' AND SOL.product_type_select = 'storable')
OR (AppBase.regroup_products_type_select LIKE '%services%' AND SOL.product_type_select = 'service'))
group by AppBase.regroup_products_label_products, AppBase.regroup_products_label_services, SOL.product_type_select, SOL."UnitCode", SOL."CurrencyCode";
]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="SaleOrderLineTaxDS" id="3422">
<list-property name="columnHints">
<structure>
<property name="columnName">value</property>
<property name="analysis">measure</property>
<text-property name="displayName">value</text-property>
<text-property name="heading">value</text-property>
</structure>
<structure>
<property name="columnName">ex_tax_base</property>
<property name="analysis">measure</property>
<text-property name="displayName">ex_tax_base</text-property>
<text-property name="heading">ex_tax_base</text-property>
</structure>
<structure>
<property name="columnName">tax_total</property>
<property name="analysis">measure</property>
<text-property name="displayName">tax_total</text-property>
<text-property name="heading">tax_total</text-property>
</structure>
<structure>
<property name="columnName">sale_order_type_select</property>
<property name="analysis">measure</property>
<text-property name="displayName">sale_order_type_select</text-property>
<text-property name="heading">sale_order_type_select</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SaleOrderId</property>
<property name="nativeName"></property>
<property name="dataType">decimal</property>
<property name="nativeDataType">-5</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">value</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ex_tax_base</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">tax_total</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">sale_order_type_select</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">value</property>
<property name="nativeName">value</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ex_tax_base</property>
<property name="nativeName">ex_tax_base</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">tax_total</property>
<property name="nativeName">tax_total</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">sale_order_type_select</property>
<property name="nativeName">sale_order_type_select</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select TaxLine.value, SOLineTax.ex_tax_base, SOLineTax.tax_total, SOrder.sale_order_type_select
from sale_sale_order_line_tax as SOLineTax
inner join sale_sale_order as SOrder on (SOLineTax.sale_order = SOrder.id)
left outer join account_tax_line as TaxLine on (SOLineTax.tax_line = TaxLine.id)
where SOrder.id = ?
]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="TranslateDS" id="3799">
<list-property name="columnHints">
<structure>
<property name="columnName">message_key</property>
<property name="analysis">dimension</property>
<text-property name="displayName">message_key</text-property>
<text-property name="heading">message_key</text-property>
</structure>
<structure>
<property name="columnName">translation</property>
<property name="analysis">dimension</property>
<text-property name="displayName">translation</text-property>
<text-property name="heading">translation</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">-1</property>
<property name="position">1</property>
<property name="isInput">true</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">Locale</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">-1</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">message_key</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">translation</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">message_key</property>
<property name="nativeName">message_key</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">translation</property>
<property name="nativeName">translation</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select LangTranslate.message_key, LangTranslate.message_value as "translation"
from meta_translation as LangTranslate
where LangTranslate.message_key = ? and LangTranslate.language = ?]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<DataSetParameters>
<parameter>
<design:ParameterDefinition>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:identifier>
<design:name></design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>-1</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
</design:ParameterDefinition>
</parameter>
<parameter>
<design:ParameterDefinition>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:identifier>
<design:name></design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>-1</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
</design:ParameterDefinition>
</parameter>
</DataSetParameters>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="AppBaseDS" id="4330">
<list-property name="columnHints">
<structure>
<property name="columnName">nb_decimal_digit_for_unit_price</property>
<property name="analysis">measure</property>
<text-property name="displayName">nb_decimal_digit_for_unit_price</text-property>
<text-property name="heading">nb_decimal_digit_for_unit_price</text-property>
</structure>
<structure>
<property name="columnName">nb_decimal_digit_for_qty</property>
<property name="analysis">measure</property>
<text-property name="displayName">nb_decimal_digit_for_qty</text-property>
<text-property name="heading">nb_decimal_digit_for_qty</text-property>
</structure>
</list-property>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">nb_decimal_digit_for_unit_price</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">nb_decimal_digit_for_qty</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">nb_decimal_digit_for_unit_price</property>
<property name="nativeName">nb_decimal_digit_for_unit_price</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">nb_decimal_digit_for_qty</property>
<property name="nativeName">nb_decimal_digit_for_qty</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select nb_decimal_digit_for_unit_price,
nb_decimal_digit_for_qty
from studio_app_base]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>nb_decimal_digit_for_unit_price</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>nb_decimal_digit_for_unit_price</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>nb_decimal_digit_for_unit_price</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">a4</property>
<property name="topMargin">0.47625cm</property>
<property name="leftMargin">0.4in</property>
<property name="bottomMargin">0in</property>
<property name="rightMargin">0.15625in</property>
<property name="headerHeight">0cm</property>
<property name="footerHeight">2.4cm</property>
<page-footer>
<grid id="4314">
<property name="height">2.487083333333333cm</property>
<property name="width">19.446875cm</property>
<column id="4315">
<property name="width">15.980833333333335cm</property>
</column>
<column id="4410">
<property name="textAlign">right</property>
<property name="width">1.4479166666666667in</property>
</column>
<row id="4316">
<property name="height">0.5cm</property>
<cell id="4317">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">none</property>
<property name="borderLeftStyle">none</property>
<property name="borderRightStyle">none</property>
<text id="4318">
<property name="fontSize">9pt</property>
<property name="fontStyle">italic</property>
<property name="paddingBottom">5pt</property>
<property name="textAlign">justify</property>
<property name="dataSet">SaleOrderDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">specific_notes</property>
<text-property name="displayName">specific_notes</text-property>
<expression name="expression" type="javascript">dataSetRow["specific_notes"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["specific_notes"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4387">
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<cell id="4388">
<property name="borderBottomStyle">none</property>
<property name="borderLeftStyle">none</property>
<property name="borderRightStyle">none</property>
<property name="borderTopStyle">none</property>
<text id="4395">
<property name="fontSize">xx-small</property>
<property name="textAlign">left</property>
<property name="dataSet">SaleOrderDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">footer</property>
<text-property name="displayName">footer</text-property>
<expression name="expression" type="javascript">dataSetRow["footer"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["footer"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4409">
<grid id="5359">
<property name="width">3.5189583333333334cm</property>
<column id="5360">
<property name="width">6%</property>
</column>
<column id="5361">
<property name="width">3%</property>
</column>
<column id="5362">
<property name="width">6%</property>
</column>
<row id="5363">
<cell id="5364">
<auto-text id="5365">
<property name="type">page-number</property>
</auto-text>
</cell>
<cell id="5366">
<text id="5367">
<property name="textAlign">center</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[/]]></text-property>
</text>
</cell>
<cell id="5368">
<auto-text id="5369">
<property name="textAlign">left</property>
<property name="type">total-page</property>
</auto-text>
</cell>
</row>
</grid>
</cell>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="3342">
<property name="marginLeft">2pt</property>
<property name="width">7.5in</property>
<property name="dataSet">SaleOrderDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">id</property>
<text-property name="displayName">id</text-property>
<expression name="expression" type="javascript">dataSetRow["id"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">saleOrderSeq</property>
<text-property name="displayName">saleOrderSeq</text-property>
<expression name="expression" type="javascript">dataSetRow["saleOrderSeq"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CompanyName</property>
<text-property name="displayName">CompanyName</text-property>
<expression name="expression" type="javascript">dataSetRow["CompanyName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">logo_path</property>
<text-property name="displayName">logo_path</text-property>
<expression name="expression" type="javascript">dataSetRow["logo_path"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">partner_type_select</property>
<text-property name="displayName">partner_type_select</text-property>
<expression name="expression" type="javascript">dataSetRow["partner_type_select"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClientPartName</property>
<text-property name="displayName">ClientPartName</text-property>
<expression name="expression" type="javascript">dataSetRow["ClientPartName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ClientPartFirstName</property>
<text-property name="displayName">ClientPartFirstName</text-property>
<expression name="expression" type="javascript">dataSetRow["ClientPartFirstName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ClientTitle</property>
<text-property name="displayName">ClientTitle</text-property>
<expression name="expression" type="javascript">dataSetRow["ClientTitle"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ContactName</property>
<text-property name="displayName">ContactName</text-property>
<expression name="expression" type="javascript">dataSetRow["ContactName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ContactFirstName</property>
<text-property name="displayName">ContactFirstName</text-property>
<expression name="expression" type="javascript">dataSetRow["ContactFirstName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PaymentCondName</property>
<text-property name="displayName">PaymentCondName</text-property>
<expression name="expression" type="javascript">dataSetRow["PaymentCondName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PaymentMode</property>
<text-property name="displayName">PaymentMode</text-property>
<expression name="expression" type="javascript">dataSetRow["PaymentMode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">DeliveryCountry</property>
<text-property name="displayName">DeliveryCountry</text-property>
<expression name="expression" type="javascript">dataSetRow["DeliveryCountry"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ex_tax_total</property>
<text-property name="displayName">ex_tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["ex_tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">tax_total</property>
<text-property name="displayName">tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">in_tax_total</property>
<text-property name="displayName">in_tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["in_tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">bank_address</property>
<text-property name="displayName">bank_address</text-property>
<expression name="expression" type="javascript">dataSetRow["bank_address"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">iban</property>
<text-property name="displayName">iban</text-property>
<expression name="expression" type="javascript">dataSetRow["iban"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">bic</property>
<text-property name="displayName">bic</text-property>
<expression name="expression" type="javascript">dataSetRow["bic"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CurrencyCode</property>
<text-property name="displayName">CurrencyCode</text-property>
<expression name="expression" type="javascript">dataSetRow["CurrencyCode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">external_reference</property>
<text-property name="displayName">external_reference</text-property>
<expression name="expression" type="javascript">dataSetRow["external_reference"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">header</property>
<text-property name="displayName">header</text-property>
<expression name="expression" type="javascript">dataSetRow["header"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">footer</property>
<text-property name="displayName">footer</text-property>
<expression name="expression" type="javascript">dataSetRow["footer"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">description</property>
<text-property name="displayName">description</text-property>
<expression name="expression" type="javascript">dataSetRow["description"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CreationDate</property>
<text-property name="displayName">CreationDate</text-property>
<expression name="expression" type="javascript">dataSetRow["CreationDate"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">SalemanName</property>
<text-property name="displayName">SalemanName</text-property>
<expression name="expression" type="javascript">dataSetRow["SalemanName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SalemanPhone</property>
<text-property name="displayName">SalemanPhone</text-property>
<expression name="expression" type="javascript">dataSetRow["SalemanPhone"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SalemanEmail</property>
<text-property name="displayName">SalemanEmail</text-property>
<expression name="expression" type="javascript">dataSetRow["SalemanEmail"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">DisplaySaleman</property>
<text-property name="displayName">DisplaySaleman</text-property>
<expression name="expression" type="javascript">dataSetRow["DisplaySaleman"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ShipmentDate</property>
<text-property name="displayName">ShipmentDate</text-property>
<expression name="expression" type="javascript">dataSetRow["ShipmentDate"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">ClientBox</property>
<text-property name="displayName">ClientBox</text-property>
<expression name="expression" type="javascript">dataSetRow["ClientBox"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">DisplayDeliveryCondition</property>
<text-property name="displayName">DisplayDeliveryCondition</text-property>
<expression name="expression" type="javascript">dataSetRow["DisplayDeliveryCondition"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">deliveryCondition</property>
<text-property name="displayName">deliveryCondition</text-property>
<expression name="expression" type="javascript">dataSetRow["deliveryCondition"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">hideDiscount</property>
<text-property name="displayName">hideDiscount</text-property>
<expression name="expression" type="javascript">dataSetRow["hideDiscount"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">displayProductCodeOnPrinting</property>
<text-property name="displayName">displayProductCodeOnPrinting</text-property>
<expression name="expression" type="javascript">dataSetRow["displayProductCodeOnPrinting"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">displayTaxDetailOnPrinting</property>
<text-property name="displayName">displayTaxDetailOnPrinting</text-property>
<expression name="expression" type="javascript">dataSetRow["displayTaxDetailOnPrinting"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">sale_order_type_select</property>
<text-property name="displayName">sale_order_type_select</text-property>
<expression name="expression" type="javascript">dataSetRow["sale_order_type_select"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">status_select</property>
<text-property name="displayName">status_select</text-property>
<expression name="expression" type="javascript">dataSetRow["status_select"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">logoPosition</property>
<text-property name="displayName">logoPosition</text-property>
<expression name="expression" type="javascript">dataSetRow["logoPosition"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">deliveryAddress</property>
<text-property name="displayName">deliveryAddress</text-property>
<expression name="expression" type="javascript">dataSetRow["deliveryAddress"]</expression>
<property name="dataType">string</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">invoicingAddress</property>
<text-property name="displayName">invoicingAddress</text-property>
<expression name="expression" type="javascript">dataSetRow["invoicingAddress"]</expression>
<property name="dataType">string</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">invoicecountry</property>
<text-property name="displayName">invoicecountry</text-property>
<expression name="expression" type="javascript">dataSetRow["invoicecountry"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">specific_notes</property>
<text-property name="displayName">specific_notes</text-property>
<expression name="expression" type="javascript">dataSetRow["specific_notes"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">versionNumber</property>
<text-property name="displayName">Version Number</text-property>
<expression name="expression" type="javascript">dataSetRow["versionNumber"]</expression>
<property name="dataType">integer</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">salesperson_signature_path</property>
<text-property name="displayName">salesperson_signature_path</text-property>
<expression name="expression" type="javascript">dataSetRow["salesperson_signature_path"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">periodicity_type_select</property>
<text-property name="displayName">periodicity_type_select</text-property>
<expression name="expression" type="javascript">dataSetRow["periodicity_type_select"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">number_of_periods</property>
<text-property name="displayName">number_of_periods</text-property>
<expression name="expression" type="javascript">dataSetRow["number_of_periods"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">subscription_text</property>
<text-property name="displayName">subscription_text</text-property>
<expression name="expression" type="javascript">dataSetRow["subscription_text"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">LegalNote</property>
<text-property name="displayName">LegalNote</text-property>
<expression name="expression" type="javascript">dataSetRow["LegalNote"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">end_of_validity_date</property>
<text-property name="displayName">end_of_validity_date</text-property>
<expression name="expression" type="javascript">dataSetRow["end_of_validity_date"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">in_ati</property>
<text-property name="displayName">in_ati</text-property>
<expression name="expression" type="javascript">dataSetRow["in_ati"]</expression>
<property name="dataType">boolean</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">in_ati_1</property>
<text-property name="displayName">in_ati</text-property>
<expression name="expression" type="javascript">dataSetRow["in_ati"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CustomerCode</property>
<text-property name="displayName">CustomerCode</text-property>
<expression name="expression" type="javascript">dataSetRow["CustomerCode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">displayCustomerCodeOnPrinting</property>
<text-property name="displayName">displayCustomerCodeOnPrinting</text-property>
<expression name="expression" type="javascript">dataSetRow["displayCustomerCodeOnPrinting"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">displayProductPictureOnPrinting</property>
<text-property name="displayName">displayProductPictureOnPrinting</text-property>
<expression name="expression" type="javascript">dataSetRow["displayProductPictureOnPrinting"]</expression>
<property name="dataType">string</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">isIspmRequired</property>
<expression name="expression" type="javascript">dataSetRow["isIspmRequired"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">displayProductPictureOnPrinting_1</property>
<expression name="expression" type="javascript">dataSetRow["displayProductPictureOnPrinting"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">logo_height</property>
<text-property name="displayName">logo_height</text-property>
<expression name="expression" type="javascript">if(dataSetRow["logo_height"]>0){dataSetRow["logo_height"]+'px'}else{'60px'}</expression>
<property name="dataType">string</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">logo_width</property>
<text-property name="displayName">logo_width</text-property>
<expression name="expression" type="javascript">if(dataSetRow["logo_width"]>0){dataSetRow["logo_width"]+'px'}else{'154px'}</expression>
<property name="dataType">string</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">logo_height_1</property>
<text-property name="displayName">logo_height</text-property>
<expression name="expression" type="javascript">dataSetRow["logo_height"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">logo_width_1</property>
<text-property name="displayName">logo_width</text-property>
<expression name="expression" type="javascript">dataSetRow["logo_width"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ProformaComments</property>
<text-property name="displayName">ProformaComments</text-property>
<expression name="expression" type="javascript">dataSetRow["ProformaComments"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">durationValue</property>
<text-property name="displayName">durationValue</text-property>
<expression name="expression" type="javascript">dataSetRow["durationValue"]</expression>
<property name="dataType">integer</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">durationType</property>
<text-property name="displayName">durationType</text-property>
<expression name="expression" type="javascript">dataSetRow["durationType"]</expression>
<property name="dataType">integer</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">enablePackMangement</property>
<text-property name="displayName">enablePackMangement</text-property>
<expression name="expression" type="javascript">dataSetRow["enablePackMangement"]</expression>
<property name="dataType">boolean</property>
</structure>
<structure>
<property name="name">useSignature</property>
<text-property name="displayName">useSignature</text-property>
<expression name="expression" type="javascript">dataSetRow["useSignature"]</expression>
<property name="dataType">boolean</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">contactPartnerTitleSelect</property>
<text-property name="displayName">contactPartnerTitleSelect</text-property>
<expression name="expression" type="javascript">dataSetRow["contactPartnerTitleSelect"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">EndValidityDate</property>
<text-property name="displayName">EndValidityDate</text-property>
<expression name="expression" type="javascript">row["end_of_validity_date"]</expression>
<property name="dataType">date</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">displayEstimShipDateOnPrinting</property>
<text-property name="displayName">displayEstimShipDateOnPrinting</text-property>
<expression name="expression" type="javascript">dataSetRow["displayEstimShipDateOnPrinting"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">estimatedShippingDate</property>
<text-property name="displayName">estimatedShippingDate</text-property>
<expression name="expression" type="javascript">dataSetRow["estimatedShippingDate"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">dataSetRow["tableFontSize"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<method name="onPrepare"><![CDATA[String.prototype.repeat = String.prototype.repeat ||
function(n) {
if (n < 0) throw new RangeError("Invalid count value");
return new Array(n + 1).join(this.toString());
};]]></method>
<column id="3343">
<property name="width">1.15in</property>
</column>
<column id="3344">
<property name="width">1.15in</property>
</column>
<column id="3345">
<property name="width">1.15in</property>
</column>
<column id="3346">
<property name="width">0.6in</property>
</column>
<column id="4085">
<property name="width">1.15in</property>
</column>
<column id="3347">
<property name="width">1in</property>
</column>
<column id="4146">
<property name="width">0.9in</property>
</column>
<column id="3348">
<property name="width">0.4in</property>
</column>
<row id="3349">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="height">0.9789583333333334cm</property>
<list-property name="visibility">
<structure>
<property name="format">xlsx</property>
<expression name="valueExpr" type="javascript">true</expression>
</structure>
<structure>
<property name="format">docx</property>
<expression name="valueExpr" type="javascript">row["logoPosition"] == 3</expression>
</structure>
<structure>
<property name="format">pdf</property>
<expression name="valueExpr" type="javascript">row["logoPosition"] == 3</expression>
</structure>
</list-property>
<cell id="3350">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<method name="onRender"><![CDATA[var logoPosition = row["logoPosition"];
if (logoPosition == 2) {
this.getStyle().setTextAlign('right')
this.getStyle().setPaddingRight('10%');
}]]></method>
<property name="fontSize">8pt</property>
<property name="borderBottomStyle">none</property>
<property name="borderLeftStyle">none</property>
<property name="borderRightStyle">none</property>
<property name="borderTopStyle">none</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">left</property>
<property name="overflow">hidden</property>
<image id="5594">
<property name="marginLeft">0px</property>
<property name="display">block</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["logoPosition"] == 0</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.width = row["logo_width"];
this.height = row["logo_height"];]]></method>
<property name="source">file</property>
<expression name="uri" type="javascript">params["AttachmentPath"].value + row["logo_path"]</expression>
</image>
</cell>
<cell id="5679">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="fontSize">8pt</property>
<property name="borderBottomStyle">none</property>
<property name="borderLeftStyle">none</property>
<property name="borderRightStyle">none</property>
<property name="borderTopStyle">none</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">right</property>
<property name="overflow">hidden</property>
<text id="5682">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["logoPosition"] == null</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().setTextAlign('left')]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["header"] ? row["header"] : ""</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5604">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="height">0.9789583333333334cm</property>
<list-property name="visibility">
<structure>
<property name="format">docx</property>
<expression name="valueExpr" type="javascript">row["logoPosition"] != 3</expression>
</structure>
<structure>
<property name="format">pdf</property>
<expression name="valueExpr" type="javascript">row["logoPosition"] != 3</expression>
</structure>
<structure>
<property name="format">xlsx</property>
<expression name="valueExpr" type="javascript">true</expression>
</structure>
</list-property>
<cell id="5605">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="fontSize">8pt</property>
<property name="textAlign">left</property>
<text id="5681">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["header"] ? row["header"] : ""</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5670">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<image id="5614">
<property name="display">block</property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.width = row["logo_width"];
this.height = row["logo_height"];]]></method>
<property name="source">file</property>
<expression name="uri" type="javascript">params["AttachmentPath"].value + row["logo_path"]</expression>
</image>
</cell>
</row>
<row id="3833">
<property name="height">0.5cm</property>
<cell id="3834">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
</cell>
</row>
<row id="3363">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">params["AddressPositionSelect"].value == 1</expression>
</structure>
</list-property>
<cell id="3364">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3423">
<property name="fontSize">12pt</property>
<property name="fontWeight">bold</property>
<property name="marginLeft">5pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">params["ProformaInvoice"].value ? 'SaleOrder.proforma' : (row["status_select"] &lt; 3 ? 'SaleOrder.quote' : 'SaleOrder.order')</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> <VALUE-OF format="^">" "</VALUE-OF> <VALUE-OF>row._outer["saleOrderSeq"]</VALUE-OF> <VALUE-OF>if(row._outer["versionNumber"] > 1) {
"-"+row._outer["versionNumber"]
}</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="3367"/>
<cell id="4065"/>
<cell id="3368">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">none</property>
<property name="borderLeftStyle">none</property>
<property name="borderRightStyle">none</property>
<property name="borderTopStyle">none</property>
</cell>
</row>
<row id="3370">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">params["AddressPositionSelect"].value == 1</expression>
</structure>
</list-property>
<cell id="3371">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<grid id="3650">
<column id="3651"/>
<row id="3652">
<cell id="3653">
<text id="3425">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["CreationDate"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.date'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :&amp;nbsp;]]></text-property>
</text>
<data id="5399">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">CreationDate</property>
</data>
</cell>
</row>
<row id="4381">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["status_select"] > 2</expression>
</structure>
</list-property>
<cell id="4382">
<text id="4383">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.duration'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["durationValue"]</VALUE-OF> ]]></text-property>
</text>
<text id="5398">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["durationType"] == null || row._outer["durationType"] != 1</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'month'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
<text id="5409">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["durationType"] == null || row._outer["durationType"] != 2</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'days'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4384">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["status_select"] > 2</expression>
</structure>
</list-property>
<cell id="4385">
<text id="5492">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["end_of_validity_date"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.endOfValidityDate'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<data id="5410">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">EndValidityDate</property>
</data>
</cell>
</row>
<row id="3884">
<cell id="3885"/>
</row>
<row id="3882">
<cell id="3883">
<text id="3886">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplaySaleman"] == 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.salemanName'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["SalemanName"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4501">
<cell id="4502">
<text id="3889">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplaySaleman"] == 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.salemanEmail'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["SalemanEmail"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3887">
<cell id="3888">
<text id="3890">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplaySaleman"] == 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.salemanPhone'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["SalemanPhone"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3880">
<cell id="3881"/>
</row>
<row id="3654">
<cell id="3655">
<text id="3645">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentCondName"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.paymentCondition'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<text id="4307">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentCondName"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["PaymentCondName"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null) {
row["translation"]
} else {
row._outer["PaymentCondName"]
}</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3656">
<cell id="3657">
<text id="3646">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentMode"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.paymentMode'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<text id="4306">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentMode"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["PaymentMode"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null) {
row["translation"]
} else {
row._outer["PaymentMode"]
}</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3658">
<cell id="3659">
<text id="3647">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["external_reference"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.customerRef'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["external_reference"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3864">
<cell id="3865">
<text id="5489">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["ShipmentDate"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.shipmentDate'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<data id="5411">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">ShipmentDate</property>
</data>
</cell>
</row>
<row id="4503">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["displayCustomerCodeOnPrinting"] != 1</expression>
</structure>
</list-property>
<cell id="4504">
<text id="4509">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.customerCode'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["CustomerCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3660">
<cell id="3661"/>
</row>
</grid>
</cell>
<cell id="3374"/>
<cell id="4066">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<text id="3426">
<property name="fontSize">12pt</property>
<property name="fontWeight">bold</property>
<property name="marginLeft">0pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">if(row["ClientTitle"] == "1"){'M.'}
else if(row["ClientTitle"] == "2"){'Ms.'}
else if(row["ClientTitle"] == "3"){'Dr'}
else if(row["ClientTitle"] == "4"){'Prof.'}</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row._outer["partner_type_select"] != "1"){
if(params["Locale"].value != 'en') {
row["translation"]
} else {
row["message_key"]
}
}</VALUE-OF>
<VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row._outer["ClientPartName"]</VALUE-OF>
<VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>if(row._outer["partner_type_select"] != "1"){
row._outer["ClientPartFirstName"]
}</VALUE-OF>]]></text-property>
</text>
<text id="3662">
<property name="fontSize">12pt</property>
<property name="fontWeight">bold</property>
<property name="marginLeft">0pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["ContactName"] == null &amp;&amp; row._outer["ContactFirstName"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">if(row["contactPartnerTitleSelect"] == "1"){'M.'}
else if(row["contactPartnerTitleSelect"] == "2"){'Ms.'}
else if(row["contactPartnerTitleSelect"] == "3"){'Dr'}
else if(row["contactPartnerTitleSelect"] == "4"){'Prof.'}</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(params["Locale"].value != 'en') {
row["translation"]
} else {
row["message_key"]
}</VALUE-OF>
<VALUE-OF format="^">" "</VALUE-OF>
<VALUE-OF>row._outer["ContactName"]</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row._outer["ContactFirstName"]</VALUE-OF>]]></text-property>
</text>
<text id="3670">
<property name="textUnderline">underline</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["invoicingAddress"] == row._outer["deliveryAddress"] || row._outer["invoicingAddress"] == null || row._outer["invoicingAddress"] == "" || row._outer["deliveryAddress"] == null || row._outer["deliveryAddress"] == ""</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.invoicingAddrs'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
</text>
<text id="4309">
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["invoicingAddress"].replace(/\n/g, "<br>")</VALUE-OF>]]></text-property>
</text>
<label id="3644">
<property name="fontSize">1pt</property>
</label>
<text id="3671">
<property name="textUnderline">underline</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["invoicingAddress"] == row._outer["deliveryAddress"] || row._outer["invoicingAddress"] == null || row._outer["invoicingAddress"] == "" || row._outer["deliveryAddress"] == null || row._outer["deliveryAddress"] == ""</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.deliveryAddress'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<text id="4310">
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["invoicingAddress"] == row["deliveryAddress"]</expression>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["deliveryAddress"].replace(/\n/g, "<br>")</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5416">
<property name="height">0.238125cm</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">params["AddressPositionSelect"].value == 0</expression>
</structure>
</list-property>
<cell id="5417"/>
<cell id="5418"/>
<cell id="5419"/>
<cell id="5420"/>
<cell id="5421">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="5434">
<property name="fontSize">12pt</property>
<property name="fontWeight">bold</property>
<property name="marginLeft">5pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">params["ProformaInvoice"].value ? 'SaleOrder.proforma' : (row["status_select"] &lt; 3 ? 'SaleOrder.quote' : 'SaleOrder.order')</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> <VALUE-OF format="^">" "</VALUE-OF> <VALUE-OF>row._outer["saleOrderSeq"]</VALUE-OF> <VALUE-OF>if(row._outer["versionNumber"] > 1) {
"-"+row._outer["versionNumber"]
}</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5425">
<property name="height">0.238125cm</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">params["AddressPositionSelect"].value == 0</expression>
</structure>
</list-property>
<cell id="5426">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<text id="5435">
<property name="fontSize">12pt</property>
<property name="fontWeight">bold</property>
<property name="marginLeft">0pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row["partner_type_select"] != "1"){
if(row["ClientTitle"] == "1"){"M."}
else if(row["ClientTitle"]=="2"){"Mme"}
else if(row["ClientTitle"]=="3"){"Mlle"}
else if(row["ClientTitle"]=="4"){"Dr"}
else if(row["ClientTitle"]=="5"){"Prof."}
}</VALUE-OF>
<VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row["ClientPartName"]</VALUE-OF>
<VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>if(row["partner_type_select"] != "1"){
row["ClientPartFirstName"]
}</VALUE-OF>]]></text-property>
</text>
<text id="5436">
<property name="fontSize">12pt</property>
<property name="fontWeight">bold</property>
<property name="marginLeft">0pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["ContactName"] == null &amp;&amp; row._outer["ContactFirstName"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">if(row["contactPartnerTitleSelect"] == "1"){'M.'}
else if(row["contactPartnerTitleSelect"] == "2"){'Ms.'}
else if(row["contactPartnerTitleSelect"] == "3"){'Dr'}
else if(row["contactPartnerTitleSelect"] == "4"){'Prof.'}</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(params["Locale"].value != 'en') {
row["translation"]
} else {
row["message_key"]
}</VALUE-OF>
<VALUE-OF format="^">" "</VALUE-OF>
<VALUE-OF>row._outer["ContactName"]</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row._outer["ContactFirstName"]</VALUE-OF>]]></text-property>
</text>
<text id="5437">
<property name="textUnderline">underline</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["invoicingAddress"] == row._outer["deliveryAddress"] || row._outer["invoicingAddress"] == null || row._outer["invoicingAddress"] == "" || row._outer["deliveryAddress"] == null || row._outer["deliveryAddress"] == ""</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.invoicingAddrs'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
</text>
<text id="5438">
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["invoicingAddress"].replace(/\n/g, "<br>")</VALUE-OF>]]></text-property>
</text>
<label id="5439">
<property name="fontSize">1pt</property>
</label>
<text id="5440">
<property name="textUnderline">underline</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["invoicingAddress"] == row._outer["deliveryAddress"] || row._outer["invoicingAddress"] == null || row._outer["invoicingAddress"] == "" || row._outer["deliveryAddress"] == null || row._outer["deliveryAddress"] == ""</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.deliveryAddress'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<text id="5441">
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["invoicingAddress"] == row["deliveryAddress"]</expression>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["deliveryAddress"].replace(/\n/g, "<br>")</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5429"/>
<cell id="5430">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<grid id="5442">
<column id="5443"/>
<row id="5444">
<cell id="5445">
<text id="5446">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["CreationDate"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.date'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :&amp;nbsp;]]></text-property>
</text>
<data id="5447">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">CreationDate</property>
</data>
</cell>
</row>
<row id="5448">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["status_select"] > 2</expression>
</structure>
</list-property>
<cell id="5449">
<text id="5450">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.duration'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["durationValue"]</VALUE-OF> ]]></text-property>
</text>
<text id="5451">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["durationType"] == null || row._outer["durationType"] != 1</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'month'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
<text id="5452">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["durationType"] == null || row._outer["durationType"] != 2</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'days'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5453">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["status_select"] > 2</expression>
</structure>
</list-property>
<cell id="5454">
<text id="5493">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["end_of_validity_date"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.endOfValidityDate'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<data id="5455">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">EndValidityDate</property>
</data>
</cell>
</row>
<row id="5456">
<cell id="5457"/>
</row>
<row id="5458">
<cell id="5459">
<text id="5460">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplaySaleman"] == 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.salemanName'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["SalemanName"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5461">
<cell id="5462">
<text id="5463">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplaySaleman"] == 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.salemanEmail'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["SalemanEmail"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5464">
<cell id="5465">
<text id="5466">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplaySaleman"] == 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.salemanPhone'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["SalemanPhone"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5467">
<cell id="5468"/>
</row>
<row id="5469">
<cell id="5470">
<text id="5471">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentCondName"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.paymentCondition'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<text id="5472">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentCondName"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["PaymentCondName"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null) {
row["translation"]
} else {
row._outer["PaymentCondName"]
}</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5473">
<cell id="5474">
<text id="5475">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentMode"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.paymentMode'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<text id="5476">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["PaymentMode"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["PaymentMode"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null) {
row["translation"]
} else {
row._outer["PaymentMode"]
}</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5477">
<cell id="5478">
<text id="5479">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["external_reference"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.customerRef'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["external_reference"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5480">
<cell id="5481">
<text id="5491">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["ShipmentDate"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.shipmentDate'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : ]]></text-property>
</text>
<data id="5482">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">ShipmentDate</property>
</data>
</cell>
</row>
<row id="5483">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["displayCustomerCodeOnPrinting"] != 1</expression>
</structure>
</list-property>
<cell id="5484">
<text id="5485">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.customerCode'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["CustomerCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5486">
<cell id="5487"/>
</row>
</grid>
</cell>
</row>
<row id="3637">
<property name="height">0.238125cm</property>
<cell id="3638">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
</cell>
<cell id="3640"/>
<cell id="3641"/>
<cell id="4068"/>
<cell id="3642">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
</cell>
</row>
<row id="3891">
<property name="height">0.238125cm</property>
<cell id="3892">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<text id="3905">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="display">inline</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["estimatedShippingDate"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.estimatedDeliveryDate'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :&amp;nbsp;]]></text-property>
</text>
<data id="5496">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="display">inline</property>
<property name="resultSetColumn">estimatedShippingDate</property>
</data>
</cell>
</row>
<row id="3898">
<property name="height">0.238125cm</property>
<cell id="3899">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<text id="3906">
<property name="fontSize">9pt</property>
<property name="marginLeft">2pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["DisplayDeliveryCondition"] == false || row._outer["deliveryCondition"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.deliveryCondition'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF format="HTML">row._outer["deliveryCondition"]</VALUE-OF>
]]></text-property>
</text>
</cell>
</row>
<row id="4516">
<property name="height">0.238125cm</property>
<cell id="4517">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<text id="4518">
<property name="backgroundAttachment">scroll</property>
<property name="backgroundPositionX">0%</property>
<property name="backgroundPositionY">0%</property>
<property name="backgroundRepeat">repeat</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="fontStyle">normal</property>
<property name="fontVariant">normal</property>
<property name="color">black</property>
<property name="textLineThrough">none</property>
<property name="textOverline">none</property>
<property name="textUnderline">none</property>
<property name="borderBottomColor">black</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">black</property>
<property name="borderLeftStyle">none</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">black</property>
<property name="borderRightStyle">none</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">black</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">0pt</property>
<property name="marginLeft">2pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textIndent">0em</property>
<property name="letterSpacing">normal</property>
<property name="lineHeight">normal</property>
<property name="orphans">2</property>
<property name="textTransform">none</property>
<property name="whiteSpace">normal</property>
<property name="widows">2</property>
<property name="wordSpacing">normal</property>
<property name="display">block</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="showIfBlank">false</property>
<property name="canShrink">false</property>
<property name="overflow">hidden</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.isIspmRequired'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row._outer["isIspmRequired"] ? row["translation"] : null</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="3391">
<cell id="3392">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<label id="3606"/>
</cell>
</row>
<row id="4349">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sale_order_type_select"] != 2</expression>
</structure>
</list-property>
<cell id="4350">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="backgroundAttachment">scroll</property>
<property name="backgroundPositionX">0%</property>
<property name="backgroundPositionY">0%</property>
<property name="backgroundRepeat">repeat</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="fontStyle">normal</property>
<property name="fontVariant">normal</property>
<property name="color">black</property>
<property name="textLineThrough">none</property>
<property name="textOverline">none</property>
<property name="textUnderline">none</property>
<property name="borderBottomColor">black</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">black</property>
<property name="borderLeftStyle">none</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">black</property>
<property name="borderRightStyle">none</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">black</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">0pt</property>
<property name="marginLeft">2pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textIndent">0em</property>
<property name="letterSpacing">normal</property>
<property name="lineHeight">normal</property>
<property name="orphans">2</property>
<property name="textTransform">none</property>
<property name="whiteSpace">normal</property>
<property name="widows">2</property>
<property name="wordSpacing">normal</property>
<property name="display">block</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="showIfBlank">false</property>
<property name="canShrink">false</property>
<property name="overflow">hidden</property>
<text id="4359">
<property name="backgroundAttachment">scroll</property>
<property name="backgroundPositionX">0%</property>
<property name="backgroundPositionY">0%</property>
<property name="backgroundRepeat">repeat</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="fontStyle">normal</property>
<property name="fontVariant">normal</property>
<property name="color">black</property>
<property name="textLineThrough">none</property>
<property name="textOverline">none</property>
<property name="textUnderline">none</property>
<property name="borderBottomColor">black</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">black</property>
<property name="borderLeftStyle">none</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">black</property>
<property name="borderRightStyle">none</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">black</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">0pt</property>
<property name="marginLeft">2pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textIndent">0em</property>
<property name="letterSpacing">normal</property>
<property name="lineHeight">normal</property>
<property name="orphans">2</property>
<property name="textTransform">none</property>
<property name="whiteSpace">normal</property>
<property name="widows">2</property>
<property name="wordSpacing">normal</property>
<property name="display">block</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="showIfBlank">false</property>
<property name="canShrink">false</property>
<property name="overflow">hidden</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">"SaleOrder.subscriptionContract"</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
</text>
</cell>
<cell id="4353"/>
<cell id="4354"/>
<cell id="4355"/>
<cell id="4356"/>
<cell id="4357"/>
</row>
<row id="4340">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sale_order_type_select"] != 2</expression>
</structure>
</list-property>
<cell id="4341">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<text id="4360">
<property name="backgroundAttachment">scroll</property>
<property name="backgroundPositionX">0%</property>
<property name="backgroundPositionY">0%</property>
<property name="backgroundRepeat">repeat</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="fontStyle">normal</property>
<property name="fontVariant">normal</property>
<property name="color">black</property>
<property name="textLineThrough">none</property>
<property name="textOverline">none</property>
<property name="textUnderline">none</property>
<property name="borderBottomColor">black</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">black</property>
<property name="borderLeftStyle">none</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">black</property>
<property name="borderRightStyle">none</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">black</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">0pt</property>
<property name="marginLeft">2pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textIndent">0em</property>
<property name="letterSpacing">normal</property>
<property name="lineHeight">normal</property>
<property name="orphans">2</property>
<property name="textTransform">none</property>
<property name="whiteSpace">normal</property>
<property name="widows">2</property>
<property name="wordSpacing">normal</property>
<property name="display">inline</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="showIfBlank">false</property>
<property name="canShrink">false</property>
<property name="overflow">hidden</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">"SaleOrder.periodicity"</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
</text>
<text id="4362">
<property name="backgroundAttachment">scroll</property>
<property name="backgroundPositionX">0%</property>
<property name="backgroundPositionY">0%</property>
<property name="backgroundRepeat">repeat</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="fontStyle">normal</property>
<property name="fontVariant">normal</property>
<property name="color">black</property>
<property name="textLineThrough">none</property>
<property name="textOverline">none</property>
<property name="textUnderline">none</property>
<property name="borderBottomColor">black</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">black</property>
<property name="borderLeftStyle">none</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">black</property>
<property name="borderRightStyle">none</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">black</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">0pt</property>
<property name="marginLeft">2pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textIndent">0em</property>
<property name="letterSpacing">normal</property>
<property name="lineHeight">normal</property>
<property name="orphans">2</property>
<property name="textTransform">none</property>
<property name="whiteSpace">normal</property>
<property name="widows">2</property>
<property name="wordSpacing">normal</property>
<property name="display">inline</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="showIfBlank">false</property>
<property name="canShrink">false</property>
<property name="overflow">hidden</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">row["periodicity_type_select"] == 1 ? "day(s)" : "month(s)"</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row._outer["number_of_periods"]</VALUE-OF>&amp;nbsp;<VALUE-OF>row["translation"] != null &amp;&amp; row["translation"] != "" ? row["translation"] : row._outer["periodicity_type_select"] == 1 ? 'day(s)' : 'month(s)'</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4344"/>
<cell id="4345"/>
<cell id="4346"/>
<cell id="4347"/>
<cell id="4348"/>
</row>
<row id="4366">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sale_order_type_select"] != 2</expression>
</structure>
</list-property>
<cell id="4367">
<property name="colSpan">3</property>
<property name="rowSpan">2</property>
<text id="4375">
<property name="backgroundAttachment">scroll</property>
<property name="backgroundPositionX">0%</property>
<property name="backgroundPositionY">0%</property>
<property name="backgroundRepeat">repeat</property>
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="fontStyle">normal</property>
<property name="fontVariant">normal</property>
<property name="color">black</property>
<property name="textLineThrough">none</property>
<property name="textOverline">none</property>
<property name="textUnderline">none</property>
<property name="borderBottomColor">black</property>
<property name="borderBottomStyle">none</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">black</property>
<property name="borderLeftStyle">none</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">black</property>
<property name="borderRightStyle">none</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">black</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">0pt</property>
<property name="marginLeft">2pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textIndent">0em</property>
<property name="letterSpacing">normal</property>
<property name="lineHeight">normal</property>
<property name="orphans">2</property>
<property name="textTransform">none</property>
<property name="whiteSpace">normal</property>
<property name="widows">2</property>
<property name="wordSpacing">normal</property>
<property name="display">block</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="showIfBlank">false</property>
<property name="canShrink">false</property>
<property name="overflow">hidden</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["subscription_text"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4370"/>
<cell id="4371"/>
<cell id="4372"/>
<cell id="4373"/>
<cell id="4374"/>
</row>
<row id="4331">
<cell id="4365"/>
<cell id="4336"/>
<cell id="4337"/>
<cell id="4338"/>
<cell id="4339"/>
</row>
<row id="3956">
<cell id="3957"/>
<cell id="3958"/>
<cell id="3959"/>
<cell id="3960"/>
<cell id="4073"/>
<cell id="3961"/>
<cell id="4130"/>
<cell id="3962"/>
</row>
<row id="3963">
<cell id="3964">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<property name="color">black</property>
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">left</property>
<table name="SaleOrderLines1" id="4530">
<property name="marginLeft">0pt</property>
<property name="width">100%</property>
<property name="dataSet">OrderLineDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">id</property>
<text-property name="displayName">id</text-property>
<expression name="expression" type="javascript">dataSetRow["id"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">description</property>
<text-property name="displayName">description</text-property>
<expression name="expression" type="javascript">dataSetRow["description"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">quantity</property>
<text-property name="displayName">quantity</text-property>
<expression name="expression" type="javascript">dataSetRow["quantity"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">UnitCode</property>
<text-property name="displayName">UnitCode</text-property>
<expression name="expression" type="javascript">dataSetRow["UnitCode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ProductName</property>
<text-property name="displayName">ProductName</text-property>
<expression name="expression" type="javascript">dataSetRow["ProductName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">unit_price</property>
<text-property name="displayName">unit_price</text-property>
<expression name="expression" type="javascript">dataSetRow["unit_price"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">ex_tax_total</property>
<text-property name="displayName">ex_tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["ex_tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">in_tax_total</property>
<text-property name="displayName">in_tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["in_tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">CurrencyCode</property>
<text-property name="displayName">CurrencyCode</text-property>
<expression name="expression" type="javascript">dataSetRow["CurrencyCode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">tax_line</property>
<text-property name="displayName">tax_line</text-property>
<expression name="expression" type="javascript">dataSetRow["tax_line"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">productCode</property>
<text-property name="displayName">productCode</text-property>
<expression name="expression" type="javascript">dataSetRow["productCode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">productPicture</property>
<text-property name="displayName">productPicture</text-property>
<expression name="expression" type="javascript">dataSetRow["productPicture"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">totalDiscountAmount</property>
<text-property name="displayName">totalDiscountAmount</text-property>
<expression name="expression" type="javascript">dataSetRow["totalDiscountAmount"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">sequence</property>
<text-property name="displayName">sequence</text-property>
<expression name="expression" type="javascript">dataSetRow["sequence"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">sale_order_type_select</property>
<text-property name="displayName">sale_order_type_select</text-property>
<expression name="expression" type="javascript">dataSetRow["sale_order_type_select"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">in_ati</property>
<text-property name="displayName">in_ati</text-property>
<expression name="expression" type="javascript">dataSetRow["in_ati"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">product_type_select</property>
<text-property name="displayName">product_type_select</text-property>
<expression name="expression" type="javascript">dataSetRow["product_type_select"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CustomerProductCode</property>
<text-property name="displayName">CustomerProductCode</text-property>
<expression name="expression" type="javascript">dataSetRow["CustomerProductCode"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CustomerProductName</property>
<text-property name="displayName">CustomerProductName</text-property>
<expression name="expression" type="javascript">dataSetRow["CustomerProductName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Aggregation</property>
<text-property name="displayName">is_pro_pic_avilable</text-property>
<property name="dataType">integer</property>
<property name="aggregateFunction">COUNT</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
</structure>
</list-property>
<expression name="filterExpr" type="javascript">row["productPicture"]!=null</expression>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">aum_negative_ex_total</property>
<expression name="expression" type="javascript">row["ex_tax_total"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">total_discount</property>
<expression name="expression" type="javascript">row["aum_negative_ex_total"]+row["sum_discount_line"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">showTotal</property>
<text-property name="displayName">showTotal</text-property>
<expression name="expression" type="javascript">dataSetRow["showTotal"]</expression>
<property name="dataType">boolean</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">hideUnitAmounts</property>
<text-property name="displayName">hideUnitAmounts</text-property>
<expression name="expression" type="javascript">dataSetRow["hideUnitAmounts"]</expression>
<property name="dataType">boolean</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">totalAggre</property>
<property name="dataType">float</property>
<simple-property-list name="aggregateOn">
<value>SaleOrderLine</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value" type="javascript">row["ex_tax_total"]</expression>
</structure>
</list-property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">totalLine</property>
<property name="dataType">decimal</property>
<property name="aggregateFunction">SUM</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value" type="javascript">row["ex_tax_total"]</expression>
</structure>
</list-property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">price_discounted</property>
<text-property name="displayName">price_discounted</text-property>
<expression name="expression" type="javascript">dataSetRow["price_discounted"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">sum_discount_line</property>
<property name="dataType">float</property>
<property name="aggregateFunction">SUM</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value" type="javascript">row["totalDiscountAmount"]</expression>
</structure>
</list-property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">total_ex_tax_total_before_discount</property>
<property name="dataType">float</property>
<property name="aggregateFunction">SUM</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value" type="javascript">if(row["typeSelect"] == 0) {
row["ex_tax_total"] - row["totalDiscountAmount"]
}</expression>
</structure>
</list-property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">enablePackMangement</property>
<text-property name="displayName">enablePackMangement</text-property>
<expression name="expression" type="javascript">row._outer["enablePackMangement"]</expression>
<property name="dataType">boolean</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">typeSelect</property>
<text-property name="displayName">typeSelect</text-property>
<expression name="expression" type="javascript">dataSetRow["typeSelect"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">packHideUnitAmounts</property>
<text-property name="displayName">packHideUnitAmounts</text-property>
<expression name="expression" type="javascript">dataSetRow["packHideUnitAmounts"]</expression>
<property name="dataType">boolean</property>
</structure>
<structure>
<property name="name">EstimatedShippingDate</property>
<text-property name="displayName">EstimatedShippingDate</text-property>
<expression name="expression" type="javascript">dataSetRow["EstimatedShippingDate"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<column id="4611">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["displayProductPictureOnPrinting"] != 1 || (row._outer["displayProductPictureOnPrinting"] == 1 &amp;&amp; row["is_product_picture_available"] == 0)</expression>
</structure>
</list-property>
<property name="width">4%</property>
</column>
<column id="4612">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["displayProductCodeOnPrinting"] != 1</expression>
</structure>
</list-property>
<property name="width">8%</property>
</column>
<column id="4613">
<property name="width">24%</property>
</column>
<column id="4614">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["nb_diff_tax_line"] &lt;= 1 || row._outer["displayTaxDetailOnPrinting"] != 1</expression>
</structure>
</list-property>
<property name="width">10%</property>
</column>
<column id="4615">
<property name="width">10%</property>
</column>
<column id="4616">
<property name="width">7%</property>
</column>
<column id="4617">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["hideDiscount"] == 1 || row["sum_discount_line"] == 0.00</expression>
</structure>
</list-property>
<property name="width">10%</property>
</column>
<column id="4618">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["in_ati"]</expression>
</structure>
</list-property>
<property name="width">7%</property>
</column>
<column id="4619">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["in_ati"]</expression>
</structure>
</list-property>
<property name="width">3%</property>
</column>
<column id="4620">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["in_ati"]</expression>
</structure>
</list-property>
<property name="width">7%</property>
</column>
<column id="4621">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["in_ati"]</expression>
</structure>
</list-property>
<property name="width">3%</property>
</column>
<column id="4622">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row._outer["displayEstimShipDateOnPrinting"] || row._outer["status_select"] == 1 || row._outer["status_select"] == 2</expression>
</structure>
</list-property>
<property name="width">8%</property>
</column>
<header>
<row id="4531">
<cell id="4532">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="4624">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">true</expression>
</structure>
</list-property>
<property name="resultSetColumn">Aggregation</property>
</data>
</cell>
<cell id="4534">
<property name="colSpan">1</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4535">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.productCode'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4536">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4537">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.productDescription'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4538">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4539">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.tax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4540">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4541">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.qtyUnit'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4542">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4543">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.unitPrice'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4544">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4545">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.discountAmount'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4546">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4547">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.priceExclTax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4548">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4549">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.priceInclTax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4550">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="4551">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.estimatedDeliveryDate'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
</header>
<group id="4552">
<property name="groupName">SaleOrderLine</property>
<expression name="keyExpr" type="javascript">row["id"]</expression>
<structure name="toc">
<expression name="expressionValue" type="javascript">row["description"]</expression>
</structure>
<property name="hideDetail">false</property>
<list-property name="sort">
<structure>
<expression name="key" type="javascript">row["sequence"]</expression>
<property name="direction">asc</property>
<property name="strength">-1</property>
</structure>
</list-property>
<header>
<row id="4553">
<cell id="4554">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<image id="5497">
<property name="width">100%</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["productPicture"]</expression>
</structure>
</list-property>
<property name="source">file</property>
<expression name="uri" type="javascript">params["AttachmentPath"].value + row["productPicture"]</expression>
</image>
</cell>
<cell id="4556">
<property name="colSpan">1</property>
<property name="rowSpan">1</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4557">
<property name="fontSize">8pt</property>
<property name="display">inline</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] != 0</expression>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["productCode"]</VALUE-OF>]]></text-property>
</text>
<data id="4558">
<property name="fontSize">8pt</property>
<property name="fontStyle">italic</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["CustomerProductCode"]</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="resultSetColumn">CustomerProductCode</property>
</data>
</cell>
<cell id="4559">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4560">
<property name="fontSize">8pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["typeSelect"] != 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["ProductName"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null) {row["translation"]} else {row._outer["ProductName"]}</VALUE-OF>]]></text-property>
</text>
<data id="4561">
<property name="fontSize">8pt</property>
<property name="fontStyle">italic</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["CustomerProductName"] || row["typeSelect"] != 0</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="resultSetColumn">CustomerProductName</property>
</data>
<text id="4562">
<property name="fontSize">8pt</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] != 0</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<I><VALUE-OF format="HTML">if(row["description"] != null ) row["description"].replace(/\<p|\<P/g, '<p style="margin-top: 0; margin-bottom:0.1em;" ').replace(/<!--\w+-->/gi,"")</VALUE-OF></I>]]></text-property>
</text>
<text id="5375">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["typeSelect"] == 0 || (row._outer["enablePackMangement"] &amp;&amp; row._outer["typeSelect"] == 3 &amp;&amp; !row._outer["showTotal"])</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">row["typeSelect"] == 3 ? (row["enablePackMangement"] ? 'SaleOrderLine.total' : 'SaleOrderLine.endOfPack' ) : 'value:'+row["ProductName"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"] != null ? row["translation"] : row._outer["ProductName"]</VALUE-OF>]]></text-property>
</text>
<data id="5376">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="fontStyle">italic</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["CustomerProductName"] || row["typeSelect"] == 0 || ( row["enablePackMangement"] &amp;&amp; row["typeSelect"] == 3 &amp;&amp; !row["showTotal"])</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="resultSetColumn">CustomerProductName</property>
</data>
<text id="5377">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] == 0 || (row["enablePackMangement"] &amp;&amp; row["typeSelect"] == 3 &amp;&amp; !row["showTotal"])</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<I><VALUE-OF format="HTML">if(row["description"] != null ) row["description"].replace(/\<p|\<P/g, '<p style="margin-top: 0; margin-bottom:0.1em;" ').replace(/<!--\w+-->/gi,"")</VALUE-OF></I>]]></text-property>
</text>
</cell>
<cell id="4563">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4564">
<property name="fontSize">8pt</property>
<property name="textAlign">center</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] != 0</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="###0.00' %'{RoundingMode=HALF_UP}">row["tax_line"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4565">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<grid id="4623">
<property name="fontSize">8pt</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["typeSelect"] != 0</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["UnitCode"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="5400"/>
<row id="4626">
<cell id="4627">
<text id="4566">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<property name="dataSet">AppBaseDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">nb_decimal_digit_for_qty</property>
<text-property name="displayName">nb_decimal_digit_for_qty</text-property>
<expression name="expression" type="javascript">dataSetRow["nb_decimal_digit_for_qty"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>Formatter.format(row._outer._outer["quantity"],"#,##0."+Array((row["nb_decimal_digit_for_qty"] || 2)+1).join("0"))</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>if(row._outer["translation"] != null) {row._outer["translation"]} else {row._outer._outer["UnitCode"]}</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
</grid>
<grid id="5401">
<property name="fontSize">8pt</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["quantity"] == 0 || row["typeSelect"] != 2</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'value:'+row["UnitCode"]</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">message_key</property>
<text-property name="displayName">message_key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<column id="5402"/>
<column id="5403"/>
<row id="5404">
<cell id="5405">
<text id="5378">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
<property name="dataSet">AppBaseDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">nb_decimal_digit_for_qty</property>
<text-property name="displayName">nb_decimal_digit_for_qty</text-property>
<expression name="expression" type="javascript">dataSetRow["nb_decimal_digit_for_qty"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>Formatter.format(row._outer._outer["quantity"],"#,##0."+Array((row["nb_decimal_digit_for_qty"] || 2)+1).join("0"))</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>if(row._outer["translation"] != null) {row._outer["translation"]} else {row._outer._outer["UnitCode"]}</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5407">
<text id="5408">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row["translation"] || row._outer["UnitCode"]</VALUE-OF>
]]></text-property>
</text>
</cell>
</row>
</grid>
</cell>
<cell id="4567">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4568">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<property name="dataSet">AppBaseDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["typeSelect"] != 0 || (row._outer["enablePackMangement"] &amp;&amp; row._outer["packHideUnitAmounts"])</expression>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">nb_decimal_digit_for_unit_price</property>
<text-property name="displayName">nb_decimal_digit_for_unit_price</text-property>
<expression name="expression" type="javascript">dataSetRow["nb_decimal_digit_for_unit_price"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">tableFontSize</property>
<text-property name="displayName">tableFontSize</text-property>
<expression name="expression" type="javascript">row._outer["tableFontSize"]</expression>
<property name="dataType">decimal</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>
if(row._outer._outer["hideDiscount"] == 0){
Formatter.format(row._outer["unit_price"], "#,##0." + "0".repeat(row["nb_decimal_digit_for_unit_price"] || 2))
}
if(row._outer._outer["hideDiscount"] == 1){
Formatter.format(row._outer["price_discounted"], "#,##0." + "0".repeat(row["nb_decimal_digit_for_unit_price"] || 2))
}
</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4569">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4570">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] != 0 || (row["enablePackMangement"] &amp;&amp; row["packHideUnitAmounts"])</expression>
</structure>
</list-property>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["totalDiscountAmount"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4571">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4572">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] != 0 || (row["enablePackMangement"] &amp;&amp; row["packHideUnitAmounts"])</expression>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["ex_tax_total"]</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
<text id="5413">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["enablePackMangement"] || row["typeSelect"] != 3 || !row["showTotal"] || row["ex_tax_total"] == 0</expression>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["ex_tax_total"]</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4577">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<text id="4578">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["typeSelect"] != 0 || (row["enablePackMangement"] &amp;&amp; row["packHideUnitAmounts"])</expression>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["in_tax_total"]</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
<text id="5414">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["enablePackMangement"] || row["typeSelect"] != 3 || !row["showTotal"] || row["in_tax_total"] == 0</expression>
</structure>
</list-property>
<structure name="toc"/>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["in_tax_total"]</VALUE-OF><VALUE-OF format="^">" "</VALUE-OF><VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4583">
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="textAlign">center</property>
<data id="5494">
<property name="fontSize">8pt</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<method name="onRender"><![CDATA[this.getStyle().fontSize = this.getRowData().getColumnValue("tableFontSize")]]></method>
<property name="resultSetColumn">EstimatedShippingDate</property>
</data>
</cell>
</row>
<row id="4585">
<cell id="4586">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4587">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4588">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4589">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4590">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4591">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4592">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4593">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
</cell>
<cell id="4594">
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4595">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
</cell>
<cell id="4596">
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4597">
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
</row>
</header>
</group>
<footer>
<row id="4598">
<cell id="4599">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
</cell>
<cell id="4600">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
</cell>
<cell id="4601">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4602">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4603">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4604">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4605">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4606">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
</cell>
<cell id="4607">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4608">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
</cell>
<cell id="4609">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
<cell id="4610">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</cell>
</row>
</footer>
</table>
</cell>
</row>
<row id="3970">
<property name="height">0.6085416666666666cm</property>
<cell id="3971"/>
<cell id="3972"/>
<cell id="3973"/>
<cell id="3974"/>
<cell id="4075"/>
<cell id="3975"/>
<cell id="4132"/>
<cell id="3976"/>
</row>
<row id="3977">
<cell id="3978">
<property name="colSpan">3</property>
<property name="rowSpan">5</property>
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<table id="3493">
<property name="width">3in</property>
<property name="dataSet">SaleOrderLineTaxDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["displayTaxDetailOnPrinting"] != 1</expression>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">value</property>
<text-property name="displayName">value</text-property>
<expression name="expression" type="javascript">dataSetRow["value"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">ex_tax_base</property>
<text-property name="displayName">ex_tax_base</text-property>
<expression name="expression" type="javascript">dataSetRow["ex_tax_base"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">tax_total</property>
<text-property name="displayName">tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">sale_order_type_select</property>
<text-property name="displayName">sale_order_type_select</text-property>
<expression name="expression" type="javascript">dataSetRow["sale_order_type_select"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<column id="3506">
<property name="width">1in</property>
</column>
<column id="3507">
<property name="width">1in</property>
</column>
<column id="3508">
<property name="width">1in</property>
</column>
<header>
<row id="3494">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<cell id="3495">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3801">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.tax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="3496">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3510">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.base'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="3497">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3511">
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.taxAmount'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
</header>
<detail>
<row id="3498">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<cell id="3499">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3539">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="###0.00' %'{RoundingMode=HALF_UP}">row["value"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="3500">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3540">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["ex_tax_base"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="3501">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="3541">
<property name="fontSize">8pt</property>
<property name="textAlign">right</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["tax_total"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
</detail>
<footer>
<row id="3502">
<cell id="3503"/>
<cell id="3504"/>
<cell id="3505"/>
</row>
</footer>
</table>
</cell>
<cell id="3981">
<property name="borderBottomStyle">none</property>
<property name="borderLeftStyle">none</property>
<property name="borderRightStyle">none</property>
<property name="borderTopStyle">none</property>
</cell>
<cell id="4076">
<property name="colSpan">4</property>
<property name="rowSpan">6</property>
<grid id="5498">
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="height">7.593541666666667cm</property>
<property name="dataBindingRef">SaleOrderLines1</property>
<column id="5499">
<property name="width">4.048125cm</property>
</column>
<column id="5500">
<property name="width">3.5983333333333336cm</property>
</column>
<row id="5502">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sum_discount_line"] == 0.00 || row._outer["hideDiscount"] == 1 || row["in_ati"]</expression>
</structure>
</list-property>
<cell id="5503">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<text id="4484">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.totalExclTaxWithoutDiscount'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5504">
<property name="fontSize">10pt</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="paddingRight">1pt</property>
<property name="textAlign">right</property>
<text id="5528">
<property name="fontSize">9pt</property>
<property name="display">inline</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["total_ex_tax_total_before_discount"]</VALUE-OF>]]></text-property>
</text>
<text id="3532">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">right</property>
<property name="display">inline</property>
<structure name="toc"/>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[&amp;nbsp;<VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5506">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sum_discount_line"] == 0.00 || row._outer["hideDiscount"] == 1 || row["in_ati"]</expression>
</structure>
</list-property>
<cell id="5507">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<text id="4175">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.totalDiscount'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5508">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="textAlign">right</property>
<text id="5529">
<property name="fontSize">9pt</property>
<property name="display">inline</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["sum_discount_line"]</VALUE-OF>]]></text-property>
</text>
<text id="4177">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="display">inline</property>
<structure name="toc"/>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[&amp;nbsp;<VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5510">
<cell id="5511">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<text id="4176">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.totalExclTax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5512">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="textAlign">right</property>
<text id="3531">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">right</property>
<property name="display">inline</property>
<property name="dataSet">SaleOrderDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ex_tax_total</property>
<text-property name="displayName">ex_tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["ex_tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["ex_tax_total"]</VALUE-OF>]]></text-property>
</text>
<text id="4178">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="display">inline</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[&amp;nbsp;<VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5514">
<cell id="5515">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<text id="3529">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.totalTax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5516">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="textAlign">right</property>
<text id="3535">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">right</property>
<property name="display">inline</property>
<property name="dataSet">SaleOrderDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">tax_total</property>
<text-property name="displayName">tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["tax_total"]</VALUE-OF>]]></text-property>
</text>
<text id="3533">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="display">inline</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[&amp;nbsp;<VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5518">
<cell id="5519">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<text id="3530">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">left</property>
<property name="dataSet">TranslateDS</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.totalInclTax'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5520">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="textAlign">right</property>
<text id="3536">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
<property name="display">inline</property>
<property name="dataSet">SaleOrderDS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">in_tax_total</property>
<text-property name="displayName">in_tax_total</text-property>
<expression name="expression" type="javascript">dataSetRow["in_tax_total"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["in_tax_total"]</VALUE-OF>]]></text-property>
</text>
<text id="3534">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">left</property>
<property name="display">inline</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[&amp;nbsp;<VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="5522">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<cell id="5523">
<text id="4472">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["sum_discount_line"] == 0.00 || row._outer._outer["hideDiscount"] == 1 || !row._outer._outer["in_ati"]</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.afterDiscount'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="5524">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="textAlign">right</property>
<text id="5530">
<property name="fontSize">9pt</property>
<property name="display">inline</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sum_discount_line"] == 0.00 || row._outer["hideDiscount"]== 1 || !row["in_ati"]</expression>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="#,##0.00">row["sum_discount_line"]</VALUE-OF>&amp;nbsp;]]></text-property>
</text>
<text id="4468">
<property name="fontSize">9pt</property>
<property name="fontWeight">normal</property>
<property name="textAlign">left</property>
<property name="display">inline</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["sum_discount_line"] == 0.00 || row._outer._outer["hideDiscount"] == 1 || !row["in_ati"]</expression>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[&amp;nbsp;<VALUE-OF>row["CurrencyCode"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
</grid>
</cell>
</row>
<row id="4157">
<cell id="4161"/>
</row>
<row id="4166">
<cell id="4170"/>
</row>
<row id="3984">
<cell id="3988"/>
</row>
<row id="3991">
<property name="height">0.25in</property>
<cell id="3995"/>
</row>
<row id="4457">
<property name="height">1.7991666666666668cm</property>
<cell id="4458">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
</cell>
<cell id="4459">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
</cell>
<cell id="4460">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
</cell>
<cell id="4461"/>
</row>
<row id="3998">
<property name="height">0.23958333333333334in</property>
<cell id="3999"/>
<cell id="4000"/>
<cell id="4001"/>
<cell id="4002"/>
<cell id="4079">
<property name="verticalAlign">bottom</property>
</cell>
<cell id="4003"/>
<cell id="4136"/>
<cell id="4004"/>
</row>
<row id="4243">
<property name="height">0.23958333333333334in</property>
<cell id="4244"/>
<cell id="4245"/>
<cell id="4246"/>
<cell id="4247"/>
<cell id="4248"/>
<cell id="4249"/>
<cell id="4250"/>
<cell id="4251"/>
</row>
<row id="4005">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["bank_address"] == null || row["bank_address"]==""</expression>
</structure>
</list-property>
<cell id="4006"/>
<cell id="4007"/>
<cell id="4008"/>
<cell id="4009"/>
<cell id="4080">
<text id="3594">
<property name="fontSize">8pt</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row._outer["bank_address"] == null</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.bank'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
</text>
</cell>
<cell id="4010">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<text id="3598">
<property name="fontSize">8pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["bank_address"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4012">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["iban"] == null || row["iban"] == ""</expression>
</structure>
</list-property>
<cell id="4013"/>
<cell id="4014"/>
<cell id="4015"/>
<cell id="4016"/>
<cell id="4081">
<text id="3582">
<property name="fontSize">8pt</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["iban"] == null</expression>
</structure>
</list-property>
<property name="contentType">auto</property>
<text-property name="content"><![CDATA[IBAN :]]></text-property>
</text>
</cell>
<cell id="4017">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<text id="3596">
<property name="fontSize">8pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["iban"] ? row["iban"].match(/(.{1,4})/g).join(" ") : ""</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4019">
<property name="height">0.6085416666666666cm</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["bic"] == null || row["bic"] == ""</expression>
</structure>
</list-property>
<cell id="4020"/>
<cell id="4021"/>
<cell id="4022"/>
<cell id="4023"/>
<cell id="4082">
<text id="3593">
<property name="fontSize">8pt</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["bic"] == null</expression>
</structure>
</list-property>
<property name="contentType">auto</property>
<text-property name="content"><![CDATA[BIC :]]></text-property>
</text>
</cell>
<cell id="4024">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<text id="3597">
<property name="fontSize">8pt</property>
<structure name="toc"/>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["bic"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4026">
<cell id="4027">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<text id="4380">
<property name="fontSize">8pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["LegalNote"]</VALUE-OF>]]></text-property>
</text>
</cell>
</row>
<row id="4033">
<cell id="4034"/>
<cell id="4035"/>
<cell id="4036"/>
<cell id="4037"/>
<cell id="4084"/>
<cell id="4038"/>
<cell id="4141"/>
<cell id="4039"/>
</row>
<row id="4089">
<cell id="4090">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<text id="3542">
<property name="fontSize">11pt</property>
<property name="fontWeight">bold</property>
<property name="color">#606062</property>
<property name="dataSet">TranslateDS</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">(row._outer["description"] == null || row._outer["description"] == "") &amp;&amp;
(row._outer["ProformaComments"] == null || row._outer["ProformaComments"] == "" || !params["ProformaInvoice"].value)</expression>
</structure>
</list-property>
<list-property name="paramBindings">
<structure>
<property name="paramName">param_1</property>
<simple-property-list name="expression">
<value type="javascript">'SaleOrder.note'</value>
</simple-property-list>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">key</property>
<text-property name="displayName">key</text-property>
<expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">translation</property>
<text-property name="displayName">translation</text-property>
<expression name="expression" type="javascript">dataSetRow["translation"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell id="4092"/>
<cell id="4093"/>
<cell id="4094"/>
<cell id="4095"/>
<cell id="4142"/>
<cell id="4096"/>
</row>
<row id="4105">
<cell id="4106">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<text id="3548">
<property name="fontSize">9pt</property>
<property name="fontStyle">italic</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<I><VALUE-OF format="HTML">
if(row["description"] != null) row["description"].replace(/\<p|\<P/g, '<p style="margin-top: 0; margin-bottom:0.1em;" ').replace(/<!--\w+-->/gi,"") + "<br>"
</VALUE-OF>
<VALUE-OF format="HTML">
if(row["ProformaComments"] != null &amp;&amp; params["ProformaInvoice"].value) row["ProformaComments"].replace(/\<p|\<P/g, '<p style="margin-top: 0; margin-bottom:0.1em;" ').replace(/<!--\w+-->/gi,"")
</VALUE-OF></I>]]></text-property>
</text>
</cell>
</row>
<row id="4113">
<cell id="4114"/>
<cell id="4115"/>
<cell id="4116"/>
<cell id="4117"/>
<cell id="4118"/>
<cell id="4119"/>
<cell id="4144"/>
<cell id="4120"/>
</row>
<row id="4097">
<cell id="4098">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<text id="3878">
<property name="fontSize">10pt</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["ClientBox"] == null</expression>
</structure>
</list-property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF format="HTML">row["ClientBox"]</VALUE-OF>
]]></text-property>
</text>
</cell>
<cell id="4101"/>
<cell id="4102"/>
<cell id="4103"/>
<cell id="4145"/>
<cell id="4104"/>
</row>
<row id="4319">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">row["salesperson_signature_path"] == null</expression>
</structure>
</list-property>
<cell id="4320">
<property name="colSpan">8</property>
<property name="rowSpan">1</property>
<property name="paddingTop">1pt</property>
<property name="paddingRight">20pt</property>
<property name="textAlign">right</property>
<image id="4328">
<property name="height">50px</property>
<expression name="altText">""</expression>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr" type="javascript">!row["useSignature"]</expression>
</structure>
</list-property>
<property name="source">file</property>
<expression name="uri" type="javascript">params["AttachmentPath"].value+row["salesperson_signature_path"]</expression>
</image>
<text-data id="4329">
<expression name="valueExpr">row["SalemanName"]</expression>
<property name="contentType">html</property>
</text-data>
</cell>
</row>
</grid>
</body>
</report>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment