Eclipse BIRT Designer Version 2.6.0.v20100531 Build <2.6.0.v20100609-1613> in /templates/blank_report.gif ltr static string true simple text-box Unformatted static string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false dateTime true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false dateTime true simple text-box Unformatted static false string true simple text-box Unformatted 1 glFiscalTypeId string 2 acctgTransTypeId string 3 transactionDate date-time 4 postedDate date-time 5 transDescription string 6 glJournalId string 7 invoiceId string 8 paymentId string 9 glAccountId string 10 debitCreditFlag string 11 amount decimal 12 currencyUomId string 13 origAmount decimal 14 origCurrencyUomId string 15 glAccountTypeId string 16 accountCode string 17 accountName string 18 glAccountClassId string 19 partyId string glFiscalTypeId glFiscalTypeId acctgTransTypeId acctgTransTypeId transactionDate transactionDate postedDate postedDate transDescription transDescription glJournalId glJournalId invoiceId invoiceId paymentId paymentId glAccountId glAccountId debitCreditFlag debitCreditFlag amount amount currencyUomId currencyUomId origAmount origAmount origCurrencyUomId origCurrencyUomId glAccountTypeId glAccountTypeId accountCode accountCode accountName accountName glAccountClassId glAccountClassId partyId partyId 1 glFiscalTypeId string 2 acctgTransTypeId string 3 transactionDate date-time 4 postedDate date-time 5 transDescription string 6 glJournalId string 7 invoiceId string 8 paymentId string 9 glAccountId string 10 debitCreditFlag string 11 amount decimal 12 currencyUomId string 13 origAmount decimal 14 origCurrencyUomId string 15 glAccountTypeId string 16 accountCode string 17 accountName string 18 glAccountClassId string 19 partyId string OFBiz = 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;]]> 1 partyId string 2 partyName string 3 address1 string 4 address2 string 5 city string 6 stateProvinceAbbr string 7 postalCode string 8 countryName string 9 sendingPartyTaxId string 10 phoneCountryCode string 11 phoneAreaCode string 12 phoneContactNumber string 13 emailAddress string 14 webSiteAddress string 15 eftAccountBankName string 16 eftAccountRoutingNumber string 17 eftAccountAccountNumber string partyId partyId partyName partyName address1 address1 address2 address2 city city stateProvinceAbbr stateProvinceAbbr postalCode postalCode countryName countryName sendingPartyTaxId sendingPartyTaxId phoneCountryCode phoneCountryCode phoneAreaCode phoneAreaCode phoneContactNumber phoneContactNumber emailAddress emailAddress webSiteAddress webSiteAddress eftAccountBankName eftAccountBankName eftAccountRoutingNumber eftAccountRoutingNumber eftAccountAccountNumber eftAccountAccountNumber 1 partyId string 2 partyName string 3 address1 string 4 address2 string 5 city string 6 stateProvinceAbbr string 7 postalCode string 8 countryName string 9 sendingPartyTaxId string 10 phoneCountryCode string 11 phoneAreaCode string 12 phoneContactNumber string 13 emailAddress string 14 webSiteAddress string 15 eftAccountBankName string 16 eftAccountRoutingNumber string 17 eftAccountAccountNumber string OFBiz = 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", false); 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; ]]> landscape 2.9in 10.363636363636363in 0.797979797979798in normal left 4.393939393939394in 2.585858585858586in 10pt bold right 2.585858585858586in 2 1 left url false 2 1 nowrap Organization partyName partyName dataSetRow["partyName"] string partyName nowrap Organization address1 address1 dataSetRow["address1"] string address1 nowrap Organization address2 address2 dataSetRow["address2"] string address2 2 1 Organization partyId dataSetRow["partyId"] string partyName dataSetRow["partyName"] string address1 dataSetRow["address1"] string address2 dataSetRow["address2"] string city dataSetRow["city"] string stateProvinceAbbr dataSetRow["stateProvinceAbbr"] string postalCode dataSetRow["postalCode"] string countryName dataSetRow["countryName"] string sendingPartyTaxId dataSetRow["sendingPartyTaxId"] string phoneCountryCode dataSetRow["phoneCountryCode"] string phoneAreaCode dataSetRow["phoneAreaCode"] string phoneContactNumber dataSetRow["phoneContactNumber"] string emailAddress dataSetRow["emailAddress"] string webSiteAddress dataSetRow["webSiteAddress"] string eftAccountBankName dataSetRow["eftAccountBankName"] string eftAccountRoutingNumber dataSetRow["eftAccountRoutingNumber"] string eftAccountAccountNumber dataSetRow["eftAccountAccountNumber"] string Party Tax: left nowrap Organization sendingPartyTaxId sendingPartyTaxId dataSetRow["sendingPartyTaxId"] string sendingPartyTaxId E-mail: left nowrap Organization emailAddress emailAddress dataSetRow["emailAddress"] string emailAddress 4 1 16pt bold center Accounting Transactioin Entries 0.4583333333333333in 10.354166666666666in 4.041666666666667in 0.71875in 0.3541666666666667in 0.6875in 4.552083333333333in 0.4583333333333333in right page-number center plain right left total-page right #000000solidthin#000000solidthin#000000solidthin#000000solidthin10.464646464646465inAcctgTransAndEntries glFiscalTypeId dataSetRow["glFiscalTypeId"] string acctgTransTypeId dataSetRow["acctgTransTypeId"] string transactionDate dataSetRow["transactionDate"] date-time postedDate dataSetRow["postedDate"] date-time transDescription dataSetRow["transDescription"] string glJournalId dataSetRow["glJournalId"] string invoiceId dataSetRow["invoiceId"] string paymentId dataSetRow["paymentId"] string glAccountId dataSetRow["glAccountId"] string debitCreditFlag dataSetRow["debitCreditFlag"] string amount dataSetRow["amount"] decimal currencyUomId dataSetRow["currencyUomId"] string origAmount dataSetRow["origAmount"] decimal origCurrencyUomId dataSetRow["origCurrencyUomId"] string glAccountTypeId dataSetRow["glAccountTypeId"] string accountCode dataSetRow["accountCode"] string accountName dataSetRow["accountName"] string glAccountClassId dataSetRow["glAccountClassId"] string partyId partyId dataSetRow["partyId"] string 0.8181818181818182in 0.7272727272727273in 2.7676767676767677in 0.6262626262626263in center 0.5959595959595959in center 1.7575757575757576in center 0.8181818181818182in center 0.9393939393939394in center 0.696969696969697in center 0.696969696969697in center

#BFBFBF bold #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin center #000000 solid thin #000000 solid thin 6pt Date #000000 solid thin #000000 solid thin 6pt Account Code #000000 solid thin #000000 solid thin 6pt Account Name #000000 solid thin #000000 solid thin 6pt Invoice ID #000000 solid thin #000000 solid thin 6pt Payment ID #000000 solid thin #000000 solid thin 6pt Party #000000 solid thin #000000 solid thin 6pt Original Currency #000000 solid thin #000000 solid thin 6pt Exchange Rate #000000 solid thin #000000 solid thin 6pt Debit #000000 solid thin #000000 solid thin 6pt Credit

glAccountClassId none asc row["glAccountClassId"] row["glAccountClassId"] true false auto auto auto

3 1 8pt bold glAccountClassId

#000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt Custom d MMMM yyyy en center nowrap transactionDate #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt accountCode #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt accountName #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt nowrap invoiceId #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt nowrap paymentId #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt nowrap partyId #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt origCurrencyUomId #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin cursive 6pt all row["origCurrencyUomId"].equals(row["currencyUomId"]) #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt Currency #,##0.00{RoundingMode=HALF_UP} #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 6pt Currency #,##0.00{RoundingMode=HALF_UP} 9.727272727272727in 1.2323232323232323in 1.4747474747474747in 1.7777777777777777in 1.5555555555555556in 1.9191919191919191in 1.7676767676767677in 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto