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 [6/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/PaymentAcctgTransEntry.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/PaymentAcctgTransEntry.rptdesign?rev=1003469&view=auto
==============================================================================
--- ofbiz/trunk/applications/accounting/webapp/accounting/reports/PaymentAcctgTransEntry.rptdesign (added)
+++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/PaymentAcctgTransEntry.rptdesign Fri Oct 1 10:40:38 2010
@@ -0,0 +1,1425 @@
+<?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.entity.util)
+importPackage(Packages.org.ofbiz.entity.condition)
+
+module = "PaymentAcctgTransEntry.rptdesign";
+
+// prepare uiLabelMap
+uiLabelMap = FastMap.newInstance();
+uiLabelMap.putAll(UtilProperties.getResourceBundleMap("CommonUiLabels", reportContext.getLocale()));
+uiLabelMap.putAll(UtilProperties.getResourceBundleMap("AccountingUiLabels", reportContext.getLocale()));
+
+paymentId = params["paymentId"].value;
+userLoginId = params["userLoginId"].value;
+
+userLogin = delegator.findOne("UserLogin", UtilMisc.toMap("userLoginId", userLoginId), false);
+userLoginNameView = delegator.findOne("PartyNameView", UtilMisc.toMap("partyId", userLogin.get("partyId")), false);
+dateFormatter = new java.text.SimpleDateFormat("dd MMMMM yyyy");
+
+payment = delegator.findOne("Payment", UtilMisc.toMap("paymentId", paymentId), false);
+
+organizationPartyId = null;
+if ("DISBURSEMENT".equals(payment.get("paymentTypeId")) || "DISBURSEMENT".equals(payment.getRelatedOne("PaymentType").get("parentTypeId"))) {
+ organizationPartyId = payment.get("partyIdFrom");
+} else {
+ organizationPartyId = payment.get("partyIdTo");
+}
+
+// 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="paymentId" id="266">
+ <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="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>
+ </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">0</property>
+ <property name="name">glFiscalTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">1</property>
+ <property name="name">acctgTransTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">transactionDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">postedDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">transDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">glJournalId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">invoiceId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">paymentId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">8</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">9</property>
+ <property name="name">debitCreditFlag</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">10</property>
+ <property name="name">amount</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="position">11</property>
+ <property name="name">currencyUomId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">12</property>
+ <property name="name">origAmount</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="position">13</property>
+ <property name="name">origCurrencyUomId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">14</property>
+ <property name="name">glAccountTypeId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">15</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">16</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">17</property>
+ <property name="name">glAccountClassId</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>
+ </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>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[// get acctg trans entries of payment
+acctgTransAndEntries = FastList.newInstance();
+var orderBy = UtilMisc.toList("acctgTransId", "acctgTransEntrySeqId");
+try {
+ acctgTransAndEntries = delegator.findList("AcctgTransAndEntries", EntityCondition.makeCondition("paymentId", EntityOperator.EQUALS, paymentId), null, orderBy, null, false);
+} catch (e) {
+ Debug.logError(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");
+
+countOfRow ++;
+return true;]]></method>
+ </script-data-set>
+ <script-data-set name="Payment" id="286">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">paymentId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">comments</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">paymentTypeDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">statusDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">effectiveDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">partyId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">partyName</property>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">paymentId</property>
+ <text-property name="displayName">paymentId</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">comments</property>
+ <text-property name="displayName">comments</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">paymentTypeDescription</property>
+ <text-property name="displayName">paymentTypeDescription</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">statusDescription</property>
+ <text-property name="displayName">statusDescription</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">effectiveDate</property>
+ <text-property name="displayName">effectiveDate</text-property>
+ </structure>
+ <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>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">paymentId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">comments</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">paymentTypeDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">statusDescription</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">5</property>
+ <property name="name">effectiveDate</property>
+ <property name="dataType">date-time</property>
+ </structure>
+ <structure>
+ <property name="position">6</property>
+ <property name="name">partyId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">7</property>
+ <property name="name">partyName</property>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[countOfRow = 0;]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= 1) return false;
+row["paymentId"] = payment.get("paymentId");
+row["comments"] = payment.get("comments");
+row["paymentTypeDescription"] = payment.getRelatedOne("PaymentType").get("description");
+row["statusDescription"] = payment.getRelatedOne("StatusItem").get("description");
+row["effectiveDate"] = payment.get("effectiveDate");
+
+var partyId = null;
+if ("RECEIPT".equals(payment.get("paymentTypeId")) || "RECEIPT".equals(payment.getRelatedOne("PaymentType").get("parentTypeId"))) {
+ partyId = payment.get("partyIdFrom");
+} else {
+ partyId = payment.get("partyIdTo");
+}
+
+var partyName = "";
+partyNameView = delegator.findOne("PartyNameView", UtilMisc.toMap("partyId", partyId), false);
+if (partyNameView.get("firstName")) {
+ partyName += partyNameView.get("firstName") + " ";
+}
+if (partyNameView.get("lastName")) {
+ partyName += partyNameView.get("lastName") + " ";
+}
+if (partyNameView.get("groupName")) {
+ partyName += partyNameView.get("groupName") + " ";
+}
+
+row["partyId"] = partyId;
+row["partyName"] = partyName;
+
+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">2.25in</property>
+ <page-header>
+ <grid id="7">
+ <property name="width">10.363636363636363in</property>
+ <column id="8">
+ <property name="width">1.494949494949495in</property>
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ </column>
+ <column id="9">
+ <property name="width">3.696969696969697in</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">
+ <label id="57">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonUsername") + ":";]]></method>
+ <text-property name="text">Username: </text-property>
+ </label>
+ </cell>
+ <cell id="47">
+ <text-data id="151">
+ <expression name="valueExpr">if (userLogin != null ) {userLoginNameView.getString("firstName") + "&nbsp;&nbsp;&nbsp;&nbsp;" + userLoginNameView.getString("lastName")}</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ </row>
+ <row id="13">
+ <cell id="14">
+ <label id="91">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_paymentId") + ":";]]></method>
+ <text-property name="text">Payment ID: </text-property>
+ </label>
+ </cell>
+ <cell id="15">
+ <data id="287">
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">invoiceId</property>
+ <text-property name="displayName">paymentId</text-property>
+ <expression name="expression" type="javascript">dataSetRow["paymentId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">invoiceId</property>
+ </data>
+ </cell>
+ <cell id="38">
+ <label id="58">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonDate") + ":";]]></method>
+ <text-property name="text">Date: </text-property>
+ </label>
+ </cell>
+ <cell id="48">
+ <data id="346">
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">effectiveDate</property>
+ <text-property name="displayName">effectiveDate</text-property>
+ <expression name="expression" type="javascript">dataSetRow["effectiveDate"]</expression>
+ <property name="dataType">date-time</property>
+ </structure>
+ </list-property>
+ <method name="onCreate"><![CDATA[this.setDisplayValue(dateFormatter.format(row["effectiveDate"]));]]></method>
+ <property name="resultSetColumn">effectiveDate</property>
+ </data>
+ </cell>
+ </row>
+ <row id="16">
+ <cell id="17">
+ <label id="63">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_paymentType");]]></method>
+ <text-property name="text">Payment Type: </text-property>
+ </label>
+ </cell>
+ <cell id="18">
+ <data id="355">
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">paymentTypeDescription</property>
+ <text-property name="displayName">paymentTypeDescription</text-property>
+ <expression name="expression" type="javascript">dataSetRow["paymentTypeDescription"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">paymentTypeDescription</property>
+ </data>
+ </cell>
+ <cell id="39">
+ <label id="60">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_partyId");]]></method>
+ <text-property name="text">Party ID: </text-property>
+ </label>
+ </cell>
+ <cell id="49">
+ <data id="291">
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">partyId</property>
+ <text-property name="displayName">partyId</text-property>
+ <expression name="expression">dataSetRow["partyId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">partyId</property>
+ </data>
+ </cell>
+ </row>
+ <row id="19">
+ <cell id="20">
+ <label id="64">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_status");]]></method>
+ <text-property name="text">Status: </text-property>
+ </label>
+ </cell>
+ <cell id="21">
+ <data id="289">
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">statusDescription</property>
+ <text-property name="displayName">statusDescription</text-property>
+ <expression name="expression">dataSetRow["statusDescription"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">statusDescription</property>
+ </data>
+ </cell>
+ <cell id="40">
+ <label id="61">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_partyName");]]></method>
+ <text-property name="text">Party Name: </text-property>
+ </label>
+ </cell>
+ <cell id="50">
+ <data id="292">
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">partyName</property>
+ <text-property name="displayName">partyName</text-property>
+ <expression name="expression">dataSetRow["partyName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">partyName</property>
+ </data>
+ </cell>
+ </row>
+ <row id="279">
+ <cell id="280">
+ <label id="302">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_referenceNumber");]]></method>
+ <text-property name="text">Reference Number: </text-property>
+ </label>
+ </cell>
+ <cell id="281">
+ <data id="303">
+ <method name="onCreate"><![CDATA[this.setDisplayValue(payment.get("paymentRefNum"));]]></method>
+ </data>
+ </cell>
+ <cell id="282"/>
+ <cell id="283"/>
+ </row>
+ <row id="349">
+ <cell id="350">
+ <label id="354">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_comments") + ":";]]></method>
+ <text-property name="text">Comments: </text-property>
+ </label>
+ </cell>
+ <cell id="351">
+ <data id="347">
+ <property name="whiteSpace">nowrap</property>
+ <property name="dataSet">Payment</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">comments</property>
+ <text-property name="displayName">comments</text-property>
+ <expression name="expression" type="javascript">dataSetRow["comments"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ </list-property>
+ <property name="resultSetColumn">comments</property>
+ </data>
+ </cell>
+ <cell id="352"/>
+ <cell id="353"/>
+ </row>
+ <row id="273">
+ <cell id="274">
+ <property name="colSpan">4</property>
+ <property name="rowSpan">1</property>
+ <text id="348">
+ <method name="onPrepare"><![CDATA[this.content = "<CENTER><H2>" + uiLabelMap.get("AccountingPayment") + "</H2></CENTER>";]]></method>
+ <property name="contentType">html</property>
+ </text>
+ </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.505050505050505in</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>
+ </list-property>
+ <column id="86">
+ <property name="width">1.4895833333333333in</property>
+ </column>
+ <column id="87">
+ <property name="width">4.090909090909091in</property>
+ </column>
+ <column id="88">
+ <property name="width">1.3232323232323233in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="307">
+ <property name="width">1.3232323232323233in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="105">
+ <property name="width">1.1111111111111112in</property>
+ <property name="textAlign">center</property>
+ </column>
+ <column id="101">
+ <property name="width">1.1515151515151516in</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="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">
+ <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">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method>
+ <text-property name="text">Account Name</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">
+ <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">
+ <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">
+ <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">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_credit");]]></method>
+ <text-property name="text">Credit</text-property>
+ </label>
+ </cell>
+ </row>
+ </header>
+ <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="79">
+ <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="261">
+ <property name="resultSetColumn">accountCode</property>
+ </data>
+ </cell>
+ <cell id="80">
+ <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="262">
+ <property name="resultSetColumn">accountName</property>
+ </data>
+ </cell>
+ <cell id="81">
+ <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="265">
+ <property name="resultSetColumn">origCurrencyUomId</property>
+ </data>
+ </cell>
+ <cell id="305">
+ <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="309">
+ <property name="fontFamily">cursive</property>
+ <list-property name="visibility">
+ <structure>
+ <property name="format">all</property>
+ <expression name="valueExpr" type="javascript">row["origCurrencyUomId"].equals(row["currencyUomId"])</expression>
+ </structure>
+ </list-property>
+ <method name="onCreate"><![CDATA[var exchangeRate = row["origAmount"]/row["amount"] + " " + row["origCurrencyUomId"] + "/" + row["currencyUomId"];
+this.setDisplayValue(exchangeRate);]]></method>
+ </data>
+ </cell>
+ <cell id="103">
+ <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="310">
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
+ </structure>
+ <method name="onCreate"><![CDATA[if ("D".equals(row["debitCreditFlag"])) {
+ debitTotal += row["amount"];
+ this.setDisplayValue(row["amount"]);
+}]]></method>
+ </data>
+ </cell>
+ <cell id="99">
+ <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="311">
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
+ </structure>
+ <method name="onCreate"><![CDATA[if ("C".equals(row["debitCreditFlag"])) {
+ creditTotal += row["amount"];
+ this.setDisplayValue(row["amount"]);
+}]]></method>
+ </data>
+ </cell>
+ </row>
+ </detail>
+ <footer>
+ <row id="82">
+ <property name="verticalAlign">middle</property>
+ <cell id="83">
+ <label id="295">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonTotal") + ":";]]></method>
+ <text-property name="text">Total: </text-property>
+ </label>
+ </cell>
+ <cell id="84">
+ <data id="345">
+ <property name="fontFamily">"Bitstream Charter"</property>
+ <property name="fontSize">8pt</property>
+ <property name="fontWeight">bold</property>
+ <method name="onCreate"><![CDATA[if (debitTotal == creditTotal) {
+ var rule = null;
+ var amountLocale = null;
+ var baseCurrencyUomId = delegator.findOne("PartyAcctgPreference", UtilMisc.toMap("partyId", organizationPartyId), false).get("baseCurrencyUomId");
+ if ("THB".equals(baseCurrencyUomId)) {
+ rule = "%bahts-and-stangs";
+ amountLocale = new java.util.Locale("th");
+ } else {
+ rule = "%dollars-and-cents";
+ amountLocale = new java.util.Locale("us");
+ }
+ var formatRuleBaseAmount = UtilNumber.formatRuleBasedAmount(debitTotal, rule, amountLocale).toUpperCase();
+ this.setDisplayValue(formatRuleBaseAmount);
+} else {
+ this.setDisplayValue("Debit not equal to credit.");
+}]]></method>
+ </data>
+ </cell>
+ <cell id="85"/>
+ <cell id="306"/>
+ <cell id="104">
+ <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="300">
+ <property name="fontWeight">bold</property>
+ <property name="textUnderline">underline</property>
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
+ </structure>
+ <method name="onCreate"><![CDATA[this.setDisplayValue(debitTotal);]]></method>
+ </data>
+ </cell>
+ <cell id="100">
+ <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="301">
+ <property name="fontWeight">bold</property>
+ <property name="textUnderline">underline</property>
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
+ </structure>
+ <method name="onCreate"><![CDATA[this.setDisplayValue(creditTotal);]]></method>
+ </data>
+ </cell>
+ </row>
+ </footer>
+ </table>
+ <grid id="312">
+ <property name="width">9.727272727272727in</property>
+ <column id="313">
+ <property name="width">1.2323232323232323in</property>
+ </column>
+ <column id="328">
+ <property name="width">1.4747474747474747in</property>
+ </column>
+ <column id="314">
+ <property name="width">1.7777777777777777in</property>
+ </column>
+ <column id="331">
+ <property name="width">1.5555555555555556in</property>
+ </column>
+ <column id="315">
+ <property name="width">1.9191919191919191in</property>
+ </column>
+ <column id="334">
+ <property name="width">1.7676767676767677in</property>
+ </column>
+ <row id="316">
+ <cell id="317">
+ <property name="paddingTop">0.5in</property>
+ <text id="324">
+ <property name="textAlign">right</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[Prepared by]]></text-property>
+ </text>
+ </cell>
+ <cell id="326">
+ <property name="paddingTop">0.5in</property>
+ <text id="339">
+ <property name="textAlign">center</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[..........................................]]></text-property>
+ </text>
+ </cell>
+ <cell id="318">
+ <property name="paddingTop">0.5in</property>
+ <text id="335">
+ <property name="textAlign">right</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[Approved by]]></text-property>
+ </text>
+ </cell>
+ <cell id="329">
+ <property name="paddingTop">0.5in</property>
+ <text id="341">
+ <property name="textAlign">center</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[..........................................]]></text-property>
+ </text>
+ </cell>
+ <cell id="319">
+ <property name="paddingTop">0.5in</property>
+ <text id="337">
+ <property name="textAlign">right</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[Received by]]></text-property>
+ </text>
+ </cell>
+ <cell id="332">
+ <property name="paddingTop">0.5in</property>
+ <text id="343">
+ <property name="textAlign">center</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[..........................................]]></text-property>
+ </text>
+ </cell>
+ </row>
+ <row id="320">
+ <cell id="321">
+ <property name="paddingTop">0.5in</property>
+ <text id="325">
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonDate");]]></method>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[Date]]></text-property>
+ </text>
+ </cell>
+ <cell id="327">
+ <property name="paddingTop">0.5in</property>
+ <text id="340">
+ <property name="textAlign">center</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[..........................................]]></text-property>
+ </text>
+ </cell>
+ <cell id="322">
+ <property name="paddingTop">0.5in</property>
+ <text id="336">
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonDate");]]></method>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[Date]]></text-property>
+ </text>
+ </cell>
+ <cell id="330">
+ <property name="paddingTop">0.5in</property>
+ <text id="342">
+ <property name="textAlign">center</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[..........................................]]></text-property>
+ </text>
+ </cell>
+ <cell id="323">
+ <property name="paddingTop">0.5in</property>
+ <text id="338">
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonDate");]]></method>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[Date]]></text-property>
+ </text>
+ </cell>
+ <cell id="333">
+ <property name="paddingTop">0.5in</property>
+ <text id="344">
+ <property name="textAlign">center</property>
+ <property name="contentType">auto</property>
+ <text-property name="content"><![CDATA[..........................................]]></text-property>
+ </text>
+ </cell>
+ </row>
+ </grid>
+ </body>
+</report>