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
0
glFiscalTypeId
string
1
acctgTransTypeId
string
2
transactionDate
date-time
3
postedDate
date-time
4
transDescription
string
5
glJournalId
string
6
invoiceId
string
7
paymentId
string
8
glAccountId
string
9
debitCreditFlag
string
10
amount
decimal
11
currencyUomId
string
12
origAmount
decimal
13
origCurrencyUomId
string
14
glAccountTypeId
string
15
accountCode
string
16
accountName
string
17
glAccountClassId
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
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
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");
countOfRow ++;
return true;]]>
1
paymentId
string
2
comments
string
3
paymentTypeDescription
string
4
statusDescription
string
5
effectiveDate
date-time
6
partyId
string
7
partyName
string
paymentId
paymentId
comments
comments
paymentTypeDescription
paymentTypeDescription
statusDescription
statusDescription
effectiveDate
effectiveDate
partyId
partyId
partyName
partyName
1
paymentId
string
2
comments
string
3
paymentTypeDescription
string
4
statusDescription
string
5
effectiveDate
date-time
6
partyId
string
7
partyName
string
OFBiz
= 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;]]>
landscape
3in
10.363636363636363in
1.494949494949495in
bold
right
3.696969696969697in
2.585858585858586in
10pt
bold
right
2.585858585858586in
2
1
left
url
false
|
|
if (userLogin != null ) {userLoginNameView.getString("firstName") + " " + userLoginNameView.getString("lastName")}
html
|
|
Payment
invoiceId
paymentId
dataSetRow["paymentId"]
string
invoiceId
|
|
nowrap
Payment
effectiveDate
effectiveDate
dataSetRow["effectiveDate"]
date-time
effectiveDate
|
|
nowrap
Payment
paymentTypeDescription
paymentTypeDescription
dataSetRow["paymentTypeDescription"]
string
paymentTypeDescription
|
|
Payment
partyId
partyId
dataSetRow["partyId"]
string
partyId
|
|
Payment
statusDescription
statusDescription
dataSetRow["statusDescription"]
string
statusDescription
|
|
Payment
partyName
partyName
dataSetRow["partyName"]
string
partyName
|
|
|
|
|
|
nowrap
Payment
comments
comments
dataSetRow["comments"]
string
comments
|
|
|
4
1
" + uiLabelMap.get("AccountingPayment") + "";]]>
html
|
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
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
10.505050505050505in
AcctgTransAndEntries
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
1.4895833333333333in
4.090909090909091in
1.3232323232323233in
center
1.3232323232323233in
center
1.1111111111111112in
center
1.1515151515151516in
center
#BFBFBF
bold
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
center
#000000
solid
thin
#000000
solid
thin
|
#000000
solid
thin
#000000
solid
thin
|
#000000
solid
thin
#000000
solid
thin
|
#000000
solid
thin
#000000
solid
thin
|
#000000
solid
thin
#000000
solid
thin
|
#000000
solid
thin
#000000
solid
thin
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
accountCode
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
accountName
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
origCurrencyUomId
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
cursive
all
row["origCurrencyUomId"].equals(row["currencyUomId"])
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
Currency
#,##0.00{RoundingMode=HALF_UP}
|
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
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
|