= $P{startDate}
AND (participations.arch_short_name = "participation.customer")
AND ($P{IncUnFinalised} OR (acts.status = 'POSTED') )
AND ((acts.arch_short_name = "act.customerAccountBadDebt")
OR (acts.arch_short_name = "act.customerAccountChargesCounter")
OR (acts.arch_short_name = "act.customerAccountChargesCredit")
OR (acts.arch_short_name = "act.customerAccountChargesInvoice")
OR (acts.arch_short_name = "act.customerAccountBadDebt")
OR (acts.arch_short_name = "act.customerAccountCreditAdjust")
OR (acts.arch_short_name = "act.customerAccountDebitAdjust")
OR (acts.arch_short_name = "act.customerAccountInitialBalance")
OR (acts.arch_short_name = "act.customerAccountPayment")
OR (acts.arch_short_name = "act.customerAccountRefund")
)
ORDER BY
acts.activity_start_time ASC]]>
0)?$F{archetype}.substring(26):$F{archetype}.substring(19)]]>
0)?((($F{reversedBy}!=null)||($F{reverses}!=null))?
"":"!!"):
(($F{reversedBy}!=null)||($F{reverses}!=null))?"!!":""]]>