You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by ha...@apache.org on 2010/10/01 12:40:39 UTC
svn commit: r1003469 [2/7] - in /ofbiz/trunk/applications/accounting:
config/ webapp/accounting/WEB-INF/
webapp/accounting/WEB-INF/actions/reports/ webapp/accounting/reports/ widget/
Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign?rev=1003469&view=auto
==============================================================================
--- ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign (added)
+++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign Fri Oct 1 10:40:38 2010
@@ -0,0 +1,2033 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
+ <property name="createdBy">Eclipse BIRT Designer Version 2.6.0.v20100531 Build <2.6.0.v20100609-1613></property>
+ <property name="units">in</property>
+ <method name="initialize"><![CDATA[importPackage(Packages.javolution.util)
+importPackage(Packages.org.ofbiz.base.util)
+importPackage(Packages.org.ofbiz.base.util.collections)
+importPackage(Packages.org.ofbiz.entity.util)
+importPackage(Packages.org.ofbiz.entity.condition)
+
+module = "AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign";
+
+organizationPartyId = params["organizationPartyId"].value;
+userLoginId = params["userLoginId"].value;
+
+dateFormatter = new java.text.SimpleDateFormat("dd MMMMM yyyy");
+
+// prepare uiLabelMap
+uiLabelMap = FastMap.newInstance();
+uiLabelMap.putAll(UtilProperties.getResourceBundleMap("CommonUiLabels", reportContext.getLocale()));
+uiLabelMap.putAll(UtilProperties.getResourceBundleMap("AccountingUiLabels", reportContext.getLocale()));
+
+// create debit/credit total variable
+debitTotal = 0;
+creditTotal = 0;]]></method>
+ <property name="iconFile">/templates/blank_report.gif</property>
+ <property name="bidiLayoutOrientation">ltr</property>
+ <parameters>
+ <scalar-parameter name="userLoginId" id="294">
+ <property name="valueType">static</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="organizationPartyId" id="346">
+ <property name="valueType">static</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="productId" id="347">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="isPosted" id="348">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="invoiceId" id="349">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="acctgTransId" id="350">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="glFiscalTypeId" id="351">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="glAccountId" id="352">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="shipmentId" id="353">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="acctgTransTypeId" id="354">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="fromDate" id="355">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">dateTime</property>
+ <property name="distinct">true</property>
+ <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="workEffortId" id="356">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="glJournalId" id="357">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="partyId" id="358">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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="thruDate" id="359">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">dateTime</property>
+ <property name="distinct">true</property>
+ <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="paymentId" id="360">
+ <property name="valueType">static</property>
+ <property name="isRequired">false</property>
+ <property name="dataType">string</property>
+ <property name="distinct">true</property>
+ <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>
+ <script-data-source name="OFBiz" id="110"/>
+ </data-sources>
+ <data-sets>
+ <script-data-set name="AcctgTransAndEntries" id="260">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glFiscalTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">acctgTransTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">transactionDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">postedDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">transDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">glJournalId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">invoiceId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">paymentId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">debitCreditFlag</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">amount</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">currencyUomId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">13</property>
+ <property name="name">origAmount</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="position">14</property>
+ <property name="name">origCurrencyUomId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">15</property>
+ <property name="name">glAccountTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">16</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">17</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">18</property>
+ <property name="name">glAccountClassId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">19</property>
+ <property name="name">partyId</property>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">glFiscalTypeId</property>
+ <text-property name="displayName">glFiscalTypeId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">acctgTransTypeId</property>
+ <text-property name="displayName">acctgTransTypeId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">transactionDate</property>
+ <text-property name="displayName">transactionDate</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">postedDate</property>
+ <text-property name="displayName">postedDate</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">transDescription</property>
+ <text-property name="displayName">transDescription</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">glJournalId</property>
+ <text-property name="displayName">glJournalId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">invoiceId</property>
+ <text-property name="displayName">invoiceId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">paymentId</property>
+ <text-property name="displayName">paymentId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">glAccountId</property>
+ <text-property name="displayName">glAccountId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">debitCreditFlag</property>
+ <text-property name="displayName">debitCreditFlag</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">amount</property>
+ <text-property name="displayName">amount</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">currencyUomId</property>
+ <text-property name="displayName">currencyUomId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">origAmount</property>
+ <text-property name="displayName">origAmount</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">origCurrencyUomId</property>
+ <text-property name="displayName">origCurrencyUomId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">glAccountTypeId</property>
+ <text-property name="displayName">glAccountTypeId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountCode</property>
+ <text-property name="displayName">accountCode</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountName</property>
+ <text-property name="displayName">accountName</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">glAccountClassId</property>
+ <text-property name="displayName">glAccountClassId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">partyId</property>
+ <text-property name="displayName">partyId</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glFiscalTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">acctgTransTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">transactionDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">postedDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">transDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">glJournalId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">invoiceId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">paymentId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">debitCreditFlag</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">amount</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">currencyUomId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">13</property>
+ <property name="name">origAmount</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="position">14</property>
+ <property name="name">origCurrencyUomId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">15</property>
+ <property name="name">glAccountTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">16</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">17</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">18</property>
+ <property name="name">glAccountClassId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">19</property>
+ <property name="name">partyId</property>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[var glAccountId = params["glAccountId"].value;
+var acctgTransTypeId = params["acctgTransTypeId"].value;
+var glFiscalTypeId = params["glFiscalTypeId"].value;
+var glJournalId = params["glJournalId"].value;
+var isPosted = params["isPosted"].value;
+var partyId = params["partyId"].value;
+var invoiceId = params["invoiceId"].value;
+var paymentId = params["paymentId"].value;
+var productId = params["productId"].value;
+var workEffortId = params["workEffortId"].value;
+var shipmentId = params["shipmentId"].value;
+var acctgTransId = params["acctgTransId"].value;
+var fromDate = params["fromDate"].value;
+var thruDate = params["thruDate"].value;
+
+acctgTransAndEntries = null;
+
+try {
+ var conds = FastList.newInstance();
+ if (glAccountId) conds.add(EntityCondition.makeCondition("glAccountId", EntityOperator.EQUALS, glAccountId));
+ if (acctgTransTypeId) conds.add(EntityCondition.makeCondition("acctgTransTypeId", EntityOperator.EQUALS, acctgTransTypeId));
+ if (glFiscalTypeId) conds.add(EntityCondition.makeCondition("glFiscalTypeId", EntityOperator.EQUALS, glFiscalTypeId));
+ if (glJournalId) conds.add(EntityCondition.makeCondition("glJournalId", EntityOperator.EQUALS, glJournalId));
+ if (isPosted) conds.add(EntityCondition.makeCondition("isPosted", EntityOperator.EQUALS, isPosted));
+ if (partyId) conds.add(EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, partyId));
+ if (invoiceId) conds.add(EntityCondition.makeCondition("invoiceId", EntityOperator.EQUALS, invoiceId));
+ if (paymentId) conds.add(EntityCondition.makeCondition("paymentId", EntityOperator.EQUALS, paymentId));
+ if (productId) conds.add(EntityCondition.makeCondition("productId", EntityOperator.EQUALS, productId));
+ if (workEffortId) conds.add(EntityCondition.makeCondition("workEffortId", EntityOperator.EQUALS, workEffortId));
+ if (shipmentId) conds.add(EntityCondition.makeCondition("shipmentId", EntityOperator.EQUALS, shipmentId));
+ if (acctgTransId) conds.add(EntityCondition.makeCondition("acctgTransId", EntityOperator.EQUALS, acctgTransId));
+ if (fromDate) conds.add(EntityCondition.makeCondition("transactionDate", EntityOperator.GREATER_THAN_EQUAL_TO, fromDate));
+ if (thruDate) conds.add(EntityCondition.makeCondition("transactionDate", EntityOperator.LESS_THAN, thruDate));
+ var orderBy = UtilMisc.toList("glAccountId", "-transactionDate");
+ acctgTransAndEntries = delegator.findList("AcctgTransAndEntries", EntityCondition.makeCondition(conds), null, orderBy, null, false);
+} catch (e) {
+ Debug.logInfo(e, module);
+}
+
+totalRow = 0;
+countOfRow = 0;
+
+if (acctgTransAndEntries) {
+ totalRow = acctgTransAndEntries.size();
+}
+]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false;
+
+var acctgTransAndEntry = acctgTransAndEntries.get(countOfRow);
+row["glFiscalTypeId"] = acctgTransAndEntry.get("glFiscalTypeId");
+row["acctgTransTypeId"] = acctgTransAndEntry.get("acctgTransTypeId");
+row["transactionDate"] = acctgTransAndEntry.get("transactionDate");
+row["postedDate"] = acctgTransAndEntry.get("postedDate");
+row["transDescription"] = acctgTransAndEntry.get("transDescription");
+row["glJournalId"] = acctgTransAndEntry.get("glJournalId");
+row["invoiceId"] = acctgTransAndEntry.get("invoiceId");
+row["paymentId"] = acctgTransAndEntry.get("paymentId");
+row["glAccountId"] = acctgTransAndEntry.get("glAccountId");
+row["debitCreditFlag"] = acctgTransAndEntry.get("debitCreditFlag");
+row["amount"] = acctgTransAndEntry.get("amount");
+row["currencyUomId"] = acctgTransAndEntry.get("currencyUomId");
+row["origAmount"] = acctgTransAndEntry.get("origAmount");
+row["origCurrencyUomId"] = acctgTransAndEntry.get("origCurrencyUomId");
+row["glAccountTypeId"] = acctgTransAndEntry.get("glAccountTypeId");
+row["accountCode"] = acctgTransAndEntry.get("accountCode");
+row["accountName"] = acctgTransAndEntry.get("accountName");
+row["glAccountClassId"] = acctgTransAndEntry.get("glAccountClassId");
+row["partyId"] = acctgTransAndEntry.get("partyId");
+
+countOfRow ++;
+return true;]]></method>
+ </script-data-set>
+ <script-data-set name="Organization" id="361">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">partyId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">partyName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">address1</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">address2</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">city</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">stateProvinceAbbr</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">postalCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">countryName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">sendingPartyTaxId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">phoneCountryCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">phoneAreaCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">phoneContactNumber</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">13</property>
+ <property name="name">emailAddress</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">14</property>
+ <property name="name">webSiteAddress</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">15</property>
+ <property name="name">eftAccountBankName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">16</property>
+ <property name="name">eftAccountRoutingNumber</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">17</property>
+ <property name="name">eftAccountAccountNumber</property>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">partyId</property>
+ <text-property name="displayName">partyId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">partyName</property>
+ <text-property name="displayName">partyName</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">address1</property>
+ <text-property name="displayName">address1</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">address2</property>
+ <text-property name="displayName">address2</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">city</property>
+ <text-property name="displayName">city</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">stateProvinceAbbr</property>
+ <text-property name="displayName">stateProvinceAbbr</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">postalCode</property>
+ <text-property name="displayName">postalCode</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">countryName</property>
+ <text-property name="displayName">countryName</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">sendingPartyTaxId</property>
+ <text-property name="displayName">sendingPartyTaxId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">phoneCountryCode</property>
+ <text-property name="displayName">phoneCountryCode</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">phoneAreaCode</property>
+ <text-property name="displayName">phoneAreaCode</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">phoneContactNumber</property>
+ <text-property name="displayName">phoneContactNumber</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">emailAddress</property>
+ <text-property name="displayName">emailAddress</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">webSiteAddress</property>
+ <text-property name="displayName">webSiteAddress</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">eftAccountBankName</property>
+ <text-property name="displayName">eftAccountBankName</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">eftAccountRoutingNumber</property>
+ <text-property name="displayName">eftAccountRoutingNumber</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">eftAccountAccountNumber</property>
+ <text-property name="displayName">eftAccountAccountNumber</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">partyId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">partyName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">address1</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">address2</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">city</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">stateProvinceAbbr</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">postalCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">countryName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">sendingPartyTaxId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">phoneCountryCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">phoneAreaCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">phoneContactNumber</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">13</property>
+ <property name="name">emailAddress</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">14</property>
+ <property name="name">webSiteAddress</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">15</property>
+ <property name="name">eftAccountBankName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">16</property>
+ <property name="name">eftAccountRoutingNumber</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">17</property>
+ <property name="name">eftAccountAccountNumber</property>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[totalRows = 1;
+countOfRow = 0;]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRows) return false;
+
+var context = FastMap.newInstance();
+var parameters = FastMap.newInstance();
+context.put("partyId", organizationPartyId);
+context.put("nowTimestamp", UtilDateTime.nowTimestamp());
+context.put("locale", reportContext.getLocale());
+context.put("parameters", parameters);
+context.put("delegator", delegator);
+context.put("dispatcher", dispatcher);
+GroovyUtil.runScriptAtLocation("component://order/webapp/ordermgr/WEB-INF/actions/order/CompanyHeader.groovy", context);
+var postalAddress = context.get("postalAddress");
+var country = postalAddress.getRelatedOne("CountryGeo");
+var phone = context.get("phone");
+var email = context.get("email");
+var webSite = context.get("website");
+var eftAccount = context.get("eftAccount");
+
+row["partyId"] = organizationPartyId;
+row["partyName"] = context.get("companyName");
+row["sendingPartyTaxId"] = context.get("sendingPartyTaxId");
+row["stateProvinceAbbr"] = context.get("stateProvinceAbbr");
+
+if (postalAddress) {
+ row["address1"] = postalAddress.get("address1");
+ row["address2"] = postalAddress.get("address2");
+ row["city"] = postalAddress.get("city");
+ row["postalCode"] = postalAddress.get("postalCode");
+}
+
+if (country) {
+ row["countryName"] = country.get("geoName");
+}
+
+if (phone) {
+ row["phoneCountryCode"] = phone.get("countryCode");
+ row["phoneAreaCode"] = phone.get("areaCode");
+ row["phoneContactNumber"] = phone.get("contactNumber");
+}
+
+if (email) {
+ row["emailAddress"] = email.get("infoString");
+}
+
+if (webSite) {
+ row["webSiteAddress"] = webSite.get("infoString");
+ row["eftAccountBankName"] = webSite.get("bankName");
+ row["eftAccountRoutingNumber"] = webSite.get("routingNumber");
+ row["eftAccountAccountName"] = webSite.get("accountName");
+}
+
+countOfRow ++;
+return true;
+]]></method>
+ </script-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="orientation">landscape</property>
+ <property name="headerHeight">2in</property>
+ <page-header>
+ <grid id="7">
+ <property name="width">10.363636363636363in</property>
+ <column id="8">
+ <property name="width">0.797979797979798in</property>
+ <property name="fontWeight">normal</property>
+ <property name="textAlign">left</property>
+ </column>
+ <column id="9">
+ <property name="width">4.393939393939394in</property>
+ </column>
+ <column id="46">
+ <property name="width">2.585858585858586in</property>
+ <property name="fontSize">10pt</property>
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ </column>
+ <column id="56">
+ <property name="width">2.585858585858586in</property>
+ </column>
+ <row id="10">
+ <cell id="11">
+ <property name="colSpan">2</property>
+ <property name="rowSpan">1</property>
+ <property name="textAlign">left</property>
+ <image id="28">
+ <property name="height">43px</property>
+ <property name="width">238px</property>
+ <method name="onCreate"><![CDATA[// get organization logo
+partyContents = delegator.findByAnd("PartyContent", UtilMisc.toMap("partyId", organizationPartyId, "partyContentTypeId", "LGOIMGURL"));
+partyContents = EntityUtil.filterByDate(partyContents);
+if (partyContents != null && partyContents.size() > 0) {
+ var dataResource = partyContents.get(0).getRelatedOne("Content").getRelatedOne("DataResource");
+ var dataResourceTypeId = dataResource.getString("dataResourceTypeId");
+ if ("LOCAL_FILE".equals(dataResourceTypeId)) {
+ this.file = dataResource.get("objectInfo");
+ } else {
+ this.URL = dataResource.get("objectInfo");
+ }
+} else {
+ this.URL = "http://localhost:8080/images/ofbiz_logo.gif";
+}]]></method>
+ <property name="source">url</property>
+ <property name="fitToContainer">false</property>
+ </image>
+ </cell>
+ <cell id="37"/>
+ <cell id="47"/>
+ </row>
+ <row id="13">
+ <cell id="14">
+ <property name="colSpan">2</property>
+ <property name="rowSpan">1</property>
+ <data id="386">
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Organization</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">partyName</property>
+ <text-property name="displayName">partyName</text-property>
+ <expression name="expression" type="javascript">dataSetRow["partyName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">partyName</property>
+ </data>
+ </cell>
+ <cell id="38"/>
+ <cell id="48"/>
+ </row>
+ <row id="16">
+ <cell id="17">
+ <data id="387">
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Organization</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">address1</property>
+ <text-property name="displayName">address1</text-property>
+ <expression name="expression" type="javascript">dataSetRow["address1"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">address1</property>
+ </data>
+ </cell>
+ <cell id="18">
+ <data id="388">
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Organization</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">address2</property>
+ <text-property name="displayName">address2</text-property>
+ <expression name="expression" type="javascript">dataSetRow["address2"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">address2</property>
+ </data>
+ </cell>
+ <cell id="39"/>
+ <cell id="49"/>
+ </row>
+ <row id="19">
+ <cell id="20">
+ <property name="colSpan">2</property>
+ <property name="rowSpan">1</property>
+ <data id="400">
+ <property name="dataSet">Organization</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">partyId</property>
+ <expression name="expression" type="javascript">dataSetRow["partyId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">partyName</property>
+ <expression name="expression" type="javascript">dataSetRow["partyName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">address1</property>
+ <expression name="expression" type="javascript">dataSetRow["address1"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">address2</property>
+ <expression name="expression" type="javascript">dataSetRow["address2"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">city</property>
+ <expression name="expression" type="javascript">dataSetRow["city"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">stateProvinceAbbr</property>
+ <expression name="expression" type="javascript">dataSetRow["stateProvinceAbbr"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">postalCode</property>
+ <expression name="expression" type="javascript">dataSetRow["postalCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">countryName</property>
+ <expression name="expression" type="javascript">dataSetRow["countryName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">sendingPartyTaxId</property>
+ <expression name="expression" type="javascript">dataSetRow["sendingPartyTaxId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">phoneCountryCode</property>
+ <expression name="expression" type="javascript">dataSetRow["phoneCountryCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">phoneAreaCode</property>
+ <expression name="expression" type="javascript">dataSetRow["phoneAreaCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">phoneContactNumber</property>
+ <expression name="expression" type="javascript">dataSetRow["phoneContactNumber"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">emailAddress</property>
+ <expression name="expression" type="javascript">dataSetRow["emailAddress"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">webSiteAddress</property>
+ <expression name="expression" type="javascript">dataSetRow["webSiteAddress"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">eftAccountBankName</property>
+ <expression name="expression" type="javascript">dataSetRow["eftAccountBankName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">eftAccountRoutingNumber</property>
+ <expression name="expression" type="javascript">dataSetRow["eftAccountRoutingNumber"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">eftAccountAccountNumber</property>
+ <expression name="expression" type="javascript">dataSetRow["eftAccountAccountNumber"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <method name="onCreate"><![CDATA[var address = "";
+
+if (row["city"]) {
+ address += row["city"] + ", ";
+}
+
+if (row["stateProvinceAbbr"]) {
+ address += row["stateProvinceAbbr"] + " ";
+}
+
+if (row["postalCode"]) {
+ address += row["postalCode"] + " ";
+}
+
+if (row["countryName"]) {
+ address += row["countryName"];
+}
+
+this.setDisplayValue(address);]]></method>
+ </data>
+ </cell>
+ <cell id="40"/>
+ <cell id="50"/>
+ </row>
+ <row id="279">
+ <cell id="280">
+ <label id="391">
+ <text-property name="text">Party Tax: </text-property>
+ </label>
+ </cell>
+ <cell id="281">
+ <data id="398">
+ <property name="textAlign">left</property>
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Organization</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">sendingPartyTaxId</property>
+ <text-property name="displayName">sendingPartyTaxId</text-property>
+ <expression name="expression" type="javascript">dataSetRow["sendingPartyTaxId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">sendingPartyTaxId</property>
+ </data>
+ </cell>
+ <cell id="282"/>
+ <cell id="283"/>
+ </row>
+ <row id="392">
+ <cell id="393">
+ <label id="397">
+ <text-property name="text">E-mail: </text-property>
+ </label>
+ </cell>
+ <cell id="394">
+ <data id="399">
+ <property name="textAlign">left</property>
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Organization</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">emailAddress</property>
+ <text-property name="displayName">emailAddress</text-property>
+ <expression name="expression" type="javascript">dataSetRow["emailAddress"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">emailAddress</property>
+ </data>
+ </cell>
+ <cell id="395"/>
+ <cell id="396"/>
+ </row>
+ <row id="273">
+ <cell id="274">
+ <property name="colSpan">4</property>
+ <property name="rowSpan">1</property>
+ <label id="430">
+ <property name="fontSize">16pt</property>
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">center</property>
+ <text-property name="text">Accounting Transactioin Entries</text-property>
+ </label>
+ </cell>
+ </row>
+ </grid>
+ </page-header>
+ <page-footer>
+ <grid id="138">
+ <property name="height">0.4583333333333333in</property>
+ <property name="width">10.354166666666666in</property>
+ <column id="256">
+ <property name="width">4.041666666666667in</property>
+ </column>
+ <column id="139">
+ <property name="width">0.71875in</property>
+ </column>
+ <column id="140">
+ <property name="width">0.3541666666666667in</property>
+ </column>
+ <column id="141">
+ <property name="width">0.6875in</property>
+ </column>
+ <column id="257">
+ <property name="width">4.552083333333333in</property>
+ </column>
+ <row id="142">
+ <property name="height">0.4583333333333333in</property>
+ <cell id="258"/>
+ <cell id="143">
+ <auto-text id="144">
+ <property name="textAlign">right</property>
+ <property name="type">page-number</property>
+ </auto-text>
+ </cell>
+ <cell id="145">
+ <text id="146">
+ <property name="textAlign">center</property>
+ <property name="contentType">plain</property>
+ <text-property name="content"><![CDATA[of]]></text-property>
+ </text>
+ </cell>
+ <cell id="147">
+ <property name="textAlign">right</property>
+ <auto-text id="148">
+ <property name="textAlign">left</property>
+ <property name="type">total-page</property>
+ </auto-text>
+ </cell>
+ <cell id="259">
+ <property name="textAlign">right</property>
+ </cell>
+ </row>
+ </grid>
+ </page-footer>
+ </simple-master-page>
+ </page-setup>
+ <body>
+ <table id="73">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="width">10.464646464646465in</property>
+ <property name="dataSet">AcctgTransAndEntries</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">glFiscalTypeId</property>
+ <expression name="expression">dataSetRow["glFiscalTypeId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">acctgTransTypeId</property>
+ <expression name="expression">dataSetRow["acctgTransTypeId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">transactionDate</property>
+ <expression name="expression">dataSetRow["transactionDate"]</expression>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="name">postedDate</property>
+ <expression name="expression">dataSetRow["postedDate"]</expression>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="name">transDescription</property>
+ <expression name="expression">dataSetRow["transDescription"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">glJournalId</property>
+ <expression name="expression">dataSetRow["glJournalId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">invoiceId</property>
+ <expression name="expression">dataSetRow["invoiceId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">paymentId</property>
+ <expression name="expression">dataSetRow["paymentId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">glAccountId</property>
+ <expression name="expression">dataSetRow["glAccountId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">debitCreditFlag</property>
+ <expression name="expression">dataSetRow["debitCreditFlag"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">amount</property>
+ <expression name="expression">dataSetRow["amount"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="name">currencyUomId</property>
+ <expression name="expression">dataSetRow["currencyUomId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">origAmount</property>
+ <expression name="expression">dataSetRow["origAmount"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="name">origCurrencyUomId</property>
+ <expression name="expression">dataSetRow["origCurrencyUomId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">glAccountTypeId</property>
+ <expression name="expression">dataSetRow["glAccountTypeId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountCode</property>
+ <expression name="expression">dataSetRow["accountCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountName</property>
+ <expression name="expression">dataSetRow["accountName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">glAccountClassId</property>
+ <expression name="expression">dataSetRow["glAccountClassId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">partyId</property>
+ <text-property name="displayName">partyId</text-property>
+ <expression name="expression" type="javascript">dataSetRow["partyId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <column id="435">
+ <property name="width">0.8181818181818182in</property>
+ </column>
+ <column id="86">
+ <property name="width">0.7272727272727273in</property>
+ </column>
+ <column id="87">
+ <property name="width">2.7676767676767677in</property>
+ </column>
+ <column id="365">
+ <property name="width">0.6262626262626263in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="369">
+ <property name="width">0.5959595959595959in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="375">
+ <property name="width">1.7575757575757576in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="88">
+ <property name="width">0.8181818181818182in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="307">
+ <property name="width">0.9393939393939394in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="105">
+ <property name="width">0.696969696969697in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="101">
+ <property name="width">0.696969696969697in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <header>
+ <row id="74">
+ <property name="backgroundColor">#BFBFBF</property>
+ <property name="fontWeight">bold</property>
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="textAlign">center</property>
+ <cell id="431">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="436">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_transactionDate");]]></method>
+ <text-property name="text">Date</text-property>
+ </label>
+ </cell>
+ <cell id="75">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="92">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method>
+ <text-property name="text">Account Code</text-property>
+ </label>
+ </cell>
+ <cell id="76">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="93">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method>
+ <text-property name="text">Account Name</text-property>
+ </label>
+ </cell>
+ <cell id="362">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="370">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_invoiceId");]]></method>
+ <text-property name="text">Invoice ID</text-property>
+ </label>
+ </cell>
+ <cell id="366">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="371">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_paymentId");]]></method>
+ <text-property name="text">Payment ID</text-property>
+ </label>
+ </cell>
+ <cell id="372">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="376">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonPartyId");]]></method>
+ <text-property name="text">Party</text-property>
+ </label>
+ </cell>
+ <cell id="77">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="106">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingOriginalCurrency");]]></method>
+ <text-property name="text">Original Currency</text-property>
+ </label>
+ </cell>
+ <cell id="304">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="308">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_exchangeRate");]]></method>
+ <text-property name="text">Exchange Rate</text-property>
+ </label>
+ </cell>
+ <cell id="102">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="108">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_debit");]]></method>
+ <text-property name="text">Debit</text-property>
+ </label>
+ </cell>
+ <cell id="98">
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <label id="109">
+ <property name="fontSize">6pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_credit");]]></method>
+ <text-property name="text">Credit</text-property>
+ </label>
+ </cell>
+ </row>
+ </header>
+ <group id="401">
+ <property name="groupName">glAccountClassId</property>
+ <property name="interval">none</property>
+ <property name="sortDirection">asc</property>
+ <expression name="keyExpr" type="javascript">row["glAccountClassId"]</expression>
+ <structure name="toc">
+ <expression name="expressionValue" type="javascript">row["glAccountClassId"]</expression>
+ </structure>
+ <property name="repeatHeader">true</property>
+ <property name="hideDetail">false</property>
+ <property name="pageBreakAfter">auto</property>
+ <property name="pageBreakBefore">auto</property>
+ <property name="pageBreakInside">auto</property>
+ <header>
+ <row id="402">
+ <cell id="432">
+ <property name="colSpan">3</property>
+ <property name="rowSpan">1</property>
+ <data id="424">
+ <property name="fontSize">8pt</property>
+ <property name="fontWeight">bold</property>
+ <method name="onCreate"><![CDATA[var glAccountClass = delegator.findOne("GlAccountClass", UtilMisc.toMap("glAccountClassId", row["glAccountClassId"]), false);
+if (glAccountClass) {
+ this.setDisplayValue(glAccountClass.get("description"));
+}]]></method>
+ <property name="resultSetColumn">glAccountClassId</property>
+ </data>
+ </cell>
+ <cell id="406"/>
+ <cell id="407"/>
+ <cell id="408"/>
+ <cell id="409"/>
+ <cell id="410"/>
+ <cell id="411"/>
+ <cell id="412"/>
+ </row>
+ </header>
+ </group>
+ <detail>
+ <row id="78">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <cell id="433">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="437">
+ <property name="fontSize">6pt</property>
+ <structure name="dateTimeFormat">
+ <property name="category">Custom</property>
+ <property name="pattern">d MMMM yyyy</property>
+ <property name="locale">en</property>
+ </structure>
+ <property name="textAlign">center</property>
+ <property name="whiteSpace">nowrap</property>
[... 426 lines stripped ...]