<?xml version="1.0" encoding="UTF-8"?><definition xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../xsd/reports.xsd">
<name>key_accountsreward_receivable_balance<participants</name>
<description>key_rewards_participants_balance<_a_financial_report_that_displays_all_the_financial_transactions_that_were_posted_within_a_specific_period_of_time.</description>
<entityTable>ACCOUNTSRECEIVABLE<<dataset/entityTable>>
<entityField>ACCRECID<<entityTable>REWARDPARTICIPANTS</entityField>entityTable>
<dataset<entityField>REWPARTID</>entityField>
<orderBy>ACCRECNUM<orderBy>REWPARTSIGNUPDATE ASC</orderBy>
<joins>
INNER JOIN ACCCLASSIFICATIONSACCOUNTSRECEIVABLE ON ACCCLASSIFICATIONSACCOUNTSRECEIVABLE.ACCCLASSIDACCRECID = ACCOUNTSRECEIVABLEREWARDPARTICIPANTS.ACCCLASSIDACCRECID
INNER JOIN CONTACTINFORMATIONACCCLASSIFICATIONS ON ACCCLASSIFICATIONS.ACCCLASSID = ACCOUNTSRECEIVABLE.ACCCLASSID
INNER JOIN CONTACTINFORMATION ON CONTACTINFORMATION.CIID = ACCOUNTSRECEIVABLE.CIID
INNER JOIN CONTACTINFODEFINITIONS ON CONTACTINFODEFINITIONS.CIDEFACTIVE = 1 AND CONTACTINFODEFINITIONS.CIDEFDELETED = 0
INNERLEFT JOIN OUGROUPSWALLETS ON OUGROUPSWALLETS.OUGIDACCRECID = ACCOUNTSRECEIVABLE.OWNEROUGID
.ACCRECID AND WALLETS.WALLETDELETED = 0 AND WALLETS.LIFECYCLESTATE = 'EFFECTIVE'
INNER JOIN CREDITLIMITSTATUSOUUNITS ON CREDITLIMITSTATUS.CREDITLIMITSTATUS_ID=ACCOUNTSRECEIVABLE.ACCRECID
OUUNITS.OUUID = REWARDPARTICIPANTS.REWPARTSIGNUPBYOUUID
LEFT JOIN OUTSTANDINGAMOUNTCURRENCIES ON OUTSTANDINGAMOUNT.OUTSTANDINGAMOUNT_ID=ACCOUNTSRECEIVABLE.ACCRECID
INNER JOIN BALANCE ON BALANCE.BALANCE_ID=ACCOUNTSRECEIVABLE.ACCRECID
INNER JOIN CURRENCIES ON CURRENCIESCURRENCIES.CURRENCYID = ACCOUNTSRECEIVABLEREWARDPARTICIPANTS.CURRENCYID
LEFT JOIN CURRENCYRATEPERIODS ON CURRENCYRATEPERIODS.CURRENCYID = CURRENCIES.CURRENCYID AND CURRENCYRATEPERIODS.CURRATEPERIODTODATE IS NULL
LEFT JOIN SYSTEMSETTINGS ON SYSTEMSETTINGS.SYSTEMSETTINGNAME= 'DEFAULT_CURRENCY' AND SYSTEMSETTINGS.SYSTEMSETTINGDELETED=0
LEFT JOIN CURRENCIES DEFAULTCURRENCIES ON DEFAULTCURRENCIES.CURRENCYID = SQL_CLOBTOCHAR(SYSTEMSETTINGS.SYSTEMSETTINGSTRINGVALUE)SQL_CLOBTOCHAR
</joins>
<conditions>
ACCOUNTSRECEIVABLEREWARDPARTICIPANTS.ACCRECDELETEDREWPARTDELETED = 0
</conditions>
<with><template>Rewards/Reward_Participants_List</template>
<subReports>
OUTSTANDINGAMOUNT (OUTSTANDINGAMOUNT_ID, OUTSTANDINGAMOUNT_VALUE) AS
(
SELECT ACCOUNTSRECEIVABLE.ACCRECID, SUM(INVOICES.INVOICETOTALAMT - COALESCE((SELECT SUM(ALLOCATEDAMT)
FROM INVOICEALLOCATIONS
WHERE
...
</with>
<template>A00_A4_Landscape</template>
<criteria>
<criterion>
<criteriatype>0</criteriatype>
<label>key_owned_by_group</label>
<extralabel>key_owned_by_group</extralabel>
<tooltip/>
<hibernatefield/>
<entitytablename>OUGROUPS</entitytablename>
<entityfieldname>OUGID</entityfieldname>
<displaytable>OUGROUPS</displaytable>
<displaylabel>key_name</displaylabel>
<displayfield>OUGNAME</displayfield>
<fieldtype>ftXString</fieldtype>
<fieldsize>32</fieldsize>
<sourcealias>OUGID</sourcealias>
<displayalias>OUGNAME</displayalias>
<datasetname>networkmanagement.loadgroups</datasetname>
<lookupname/>
<treename/>
<multiselect>1</multiselect>
<isMandatory>1</isMandatory>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_life_cycle_state</label>
<extralabel>key_life_cycle_state</extralabel>
<tooltip/>
<hibernatefield/>
<entitytablename>ACCOUNTSRECEIVABLE</entitytablename>
<entityfieldname>LIFECYCLESTATE</entityfieldname>
<displaytable/>
<displaylabel>key_life_cycle_state</displaylabel>
<displayfield>LIFECYCLESTATE</displayfield>
<fieldtype>ftXString</fieldtype>
<fieldsize>32</fieldsize>
<sourcealias>LIFECYCLESTATE</sourcealias>
<displayalias/>
<datasetname/>
<lookupname>ejb/CRMUIAccountReceivable.getLifeCycleStateOptions:</lookupname>
<isMandatory>1</isMandatory><subReport>
<name>walletSubReport</name>
<folder>Rewards</folder>
</subReport>
<subReport>
<name>participatingSchemesSubReport</name>
<folder>Rewards</folder>
</subReport>
<subReport>
<name>signedOffSchemesSubReport</name>
<folder>Rewards</folder>
</subReport>
<subReport>
<name>accessTokensSubReport</name>
<folder>Rewards</folder>
</subReport>
</subReports>
<criteria>
<criterion>
<criteriatype>0</criteriatype>
<label>key_rewards_participant_schemes</label>
<extralabel>key_rewards_participant_schemes</extralabel>
<entitytablename>REWARDSCHEMES</entitytablename>
<entityfieldname>REWSCHID</entityfieldname>
<existclause>
SELECT 'x'
FROM REWARDPARTICIPATINGSCHEMES
INNER JOIN REWARDSCHEMES ON REWARDSCHEMES.REWSCHID = REWARDPARTICIPATINGSCHEMES.REWSCHID
WHERE REWARDPARTICIPATINGSCHEMES.REWPARTID =REWARDPARTICIPANTS.REWPARTID
AND REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMEDELETED = 0
</existclause>
<isMandatory>0</isMandatory>
<managedbeanname>rewardParticipantsView</managedbeanname>
<method>searchRewardSchemes</method>
<componentType>selectcheckboxmenu</componentType>
<className>com.crm.dataobject.rewards.CRMDORewardScheme</className>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_life_cycle_state</label>
<extralabel>key_life_cycle_state</extralabel>
<entitytablename>REWARDPARTICIPANTS</entitytablename>
<entityfieldname>LIFECYCLESTATE</entityfieldname>
<isMandatory>0</isMandatory>
<managedbeanname>rewardParticipantsView</managedbeanname>
<method>getParticipantLifeCycleStateOptions</method>
<componentType>selectcheckboxmenu</componentType>
<className>com.crm.dataobject.rewards.RewardsParticipantLifeCycleState</className>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_datesign_up_created<date</label>
<extralabel>key_datesign_up_created<date</extralabel>
<tooltip<entitytablename>REWARDPARTICIPANTS</>entitytablename>
<hibernatefield<entityfieldname>REWPARTSIGNUPDATE</>entityfieldname>
<entitytablename>ACCOUNTSRECEIVABLE<<componentType>calendar</entitytablename>componentType>
<entityfieldname>ACCRECCREATEDDATE</entityfieldname><isMandatory>0</isMandatory>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<displaytable/><label>key_sign_up_unit</label>
<displaylabel/><extralabel>key_sign_up_unit</extralabel>
<displayfield<entitytablename>OUUNITS</>entitytablename>
<fieldtype>ftXDate<<entityfieldname>OUUID</fieldtype>entityfieldname>
<fieldsize>-1<<componentType>autocomplete</fieldsize>componentType>
<sourcealias<managedbeanname>genericReportView</>managedbeanname>
<displayalias<method>searchUnits</>method>
<datasetname/>
<lookupname/>
<treename/>
<multiselect>0</multiselect>
<isMandatory>0</isMandatory>
</criterion>
...
</criteria>
<columns>
<column>
<fieldname>ACCRECNUM</fieldname>
<width>10</width><isMandatory>0</isMandatory>
<className>com.crm.dataobject.networkmanagement.CRMDOUnit</className>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_scheme_sign_up_date</label>
<extralabel>key_scheme_sign_up_date</extralabel>
<entitytablename>REWARDPARTICIPATINGSCHEMES</entitytablename>
<entityfieldname>REWPARTSCHEMESIGNUPDATE</entityfieldname>
<componentType>calendar</componentType>
<existclause>
SELECT 'x'
FROM REWARDPARTICIPATINGSCHEMES
WHERE REWARDPARTICIPATINGSCHEMES.REWPARTID =REWARDPARTICIPANTS.REWPARTID
AND REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMEDELETED = 0
</existclause>
<isMandatory>0</isMandatory>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_scheme_sign_off_date</label>
<extralabel>key_scheme_sign_off_date</extralabel>
<entitytablename>REWARDPARTICIPATINGSCHEMES</entitytablename>
<entityfieldname>REWPARTSCHEMESIGNOFFDATE</entityfieldname>
<componentType>calendar</componentType>
<existclause>
SELECT 'x'
FROM REWARDPARTICIPATINGSCHEMES
WHERE REWARDPARTICIPATINGSCHEMES.REWPARTID =REWARDPARTICIPANTS.REWPARTID
AND REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMEDELETED = 0
</existclause>
<isMandatory>0</isMandatory>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_scheme_sign_up_unit</label>
<extralabel>key_scheme_sign_up_unit</extralabel>
<entitytablename>OUUNITS</entitytablename>
<entityfieldname>OUUID</entityfieldname>
<existclause>
SELECT 'x'
FROM REWARDPARTICIPATINGSCHEMES
INNER JOIN OUUNITS ON OUUNITS.OUUID = REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMESIGNUPBYOUUID
WHERE REWARDPARTICIPATINGSCHEMES.REWPARTID =REWARDPARTICIPANTS.REWPARTID
AND REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMEDELETED = 0
</existclause>
<componentType>autocomplete</componentType>
<managedbeanname>genericReportView</managedbeanname>
<method>searchUnits</method>
<isMandatory>0</isMandatory>
<className>com.crm.dataobject.networkmanagement.CRMDOUnit</className>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_accounts_receivable_classification</label>
<extralabel>key_accounts_receivable_classification</extralabel>
<entitytablename>ACCCLASSIFICATIONS</entitytablename>
<entityfieldname>ACCCLASSID</entityfieldname>
<isMandatory>0</isMandatory>
<managedbeanname>accountsReceivableSummaryView</managedbeanname>
<method>searchClassifications</method>
<componentType>selectcheckboxmenu</componentType>
<className>com.crm.dataobject.accounts.CRMDOAccountClassification</className>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_termination_date</label>
<extralabel>key_termination_date</extralabel>
<entitytablename>REWARDPARTICIPANTS</entitytablename>
<entityfieldname>REWPARTTERMINATIONDATE</entityfieldname>
<componentType>calendar</componentType>
<isMandatory>0</isMandatory>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_rewards_participant_gender</label>
<extralabel>key_rewards_participant_gender</extralabel>
<entitytablename>CONTACTINFORMATION</entitytablename>
<entityfieldname>CIGENDER</entityfieldname>
<isMandatory>0</isMandatory>
<managedbeanname>subscriptionChangeAccountView</managedbeanname>
<method>getGenderOptions</method>
<componentType>selectcheckboxmenu</componentType>
<className>com.crm.dataobject.contactinfo.Gender</className>
</criterion>
<criterion>
<criteriatype>0</criteriatype>
<label>key_rewards_participant_age_range</label>
<extralabel>key_rewards_participant_age_range</extralabel>
<entitytablename>EXTRACT(YEAR FROM CURRENT_DATE) - COALESCE(CONTACTINFORMATION</entitytablename>
<entityfieldname>CIYEAROFBIRTH,EXTRACT(YEAR FROM CURRENT_DATE))</entityfieldname>
<fieldtype>ftXInteger</fieldtype>
<componentType>inputText</componentType>
<multiselect>0</multiselect>
<isMandatory>0</isMandatory>
</criterion>
</criteria>
<columns>
<column>
<fieldname>REWARDPARTICIPANTS.REWPARTID</fieldname>
<alias>PRIMARY_KEY</alias>
<hidden>1</hidden>
</column>
<column>
<fieldname>REWPARTNUM</fieldname>
<width>10</width>
<widthType>PERCENTAGE</widthType>
<header>key_number</header>
</column>
<column>
<fieldname>ACCOUNTSRECEIVABLE.ACCRECNAME</fieldname>
<alias>ACCOUNTSRECEIVABLE</alias>
<width>20</width>
<widthType>PERCENTAGE</widthType>
<header>key_accounts_receivable</header>
</column>
<column>
<fieldname>
CASE WHEN REWARDPARTICIPANTS.LIFECYCLESTATE='TERMINATED' then 'Terminated'
WHEN REWARDPARTICIPANTS.LIFECYCLESTATE='EFFECTIVE' then 'Effective'
END
</fieldname>
<alias>LIFECYCLESTATE</alias>
<width>6</width>
<header>key_life_cycle_state</header>
<widthType>PERCENTAGE</widthType>
</column>
<column>
<fieldname>ACCCLASSNAME</fieldname>
<width>10</width>
<widthType>PERCENTAGE</widthType>
<header>key_accounts_receivable_classification</header>
</column>
<column>
<fieldname>REWPARTTERMINATIONDATE</fieldname>
<fieldtype>FTXDATE</fieldtype>
<width>10</width>
<widthType>PERCENTAGE</widthType>
<header>key_termination_date</header>
</column>
<column>
<fieldname>
CASE WHEN REWARDPARTICIPANTS.rewpartterminationreason='CUSTOMER_REQUEST' then 'Customer Request'
WHEN REWARDPARTICIPANTS.rewpartterminationreason='FRAUD' then 'Fraud'
WHEN REWARDPARTICIPANTS.rewpartterminationreason='DUPLICATION' then 'Duplication'
END
</fieldname>
<alias>REWPARTTERMINATIONREASON</alias>
<width>10</width>
<widthType>PERCENTAGE</widthType>
<header>key_termination_reason</header>
</column>
<column>
<fieldname>REWPARTSIGNUPDATE</fieldname>
<fieldtype>FTXDATE</fieldtype>
<width>10</width>
<widthType>PERCENTAGE</widthType>
<header>key_sign_up_date</header>
</column>
<column>
<fieldname>OUUNAME</fieldname>
<width>10</width>
<widthType>PERCENTAGE</widthType>
<header>key_sign_up_by_unit</header>
</column>
<column>
<fieldname>
(
select count(1) from rewardparticipatingschemes rps where
rps.rewpartid=REWARDPARTICIPANTS.rewpartid
and
(rewpartschemesignupdate > SQL_FIRST_DAY[[SQL_CURRENT_DATE]]SQL_FIRST_DAY
or
rewpartschemesignupdate = SQL_FIRST_DAY[[SQL_CURRENT_DATE]]SQL_FIRST_DAY)
and
rewpartschemesignupdate < [SQL_CURRENT_DATE]
and rps.rewpartschemedeleted=0 and rewpartschemesignoffdate is null
)
</fieldname>
<alias>THIS_MONTH_SCHEME_SIGN_UPS</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_sign_ups</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>
(
select count(1) from rewardparticipatingschemes rps where
rps.rewpartid=REWARDPARTICIPANTS.rewpartid
and rewpartschemesignoffdate is not null and
(rewpartschemesignoffdate > SQL_FIRST_DAY[[SQL_CURRENT_DATE]]SQL_FIRST_DAY
or
rewpartschemesignoffdate = SQL_FIRST_DAY[[SQL_CURRENT_DATE]]SQL_FIRST_DAY)
and rewpartschemesignoffdate < [SQL_CURRENT_DATE]
and rps.rewpartschemedeleted=0
)
</fieldname>
<alias>THIS_MONTH_SCHEME_SIGN_OFFS</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_sign_offs</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>
(
select 1 from rewardparticipants RP
where LIFECYCLESTATE='EFFECTIVE' and RP.rewpartid =REWARDPARTICIPANTS.rewpartid
)
</fieldname>
<alias>EFFECTIVE_PARTICIPANTS</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_effective_participants</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>
(
select 1 from rewardparticipants RP
where LIFECYCLESTATE='TERMINATED' and RP.rewpartid =REWARDPARTICIPANTS.rewpartid
)
</fieldname>
<alias>TERMINATED_PARTICIPANTS</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_terminated_participants</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>
(
select 1 from rewardparticipants RP where
REWPARTTERMINATIONDATE is not null and
(RP.REWPARTTERMINATIONDATE > SQL_FIRST_DAY[[SQL_CURRENT_DATE]]SQL_FIRST_DAY
or
RP.REWPARTTERMINATIONDATE = SQL_FIRST_DAY[[SQL_CURRENT_DATE]]SQL_FIRST_DAY)
and REWPARTTERMINATIONDATE < [SQL_CURRENT_DATE]
and RP.rewpartid =REWARDPARTICIPANTS.rewpartid
)
</fieldname>
<alias>THIS_MONTH_TERMINATIONS</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_balance</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>
(
select COALESCE(sum(COALESCE(rewawardtrxnamt,0)),0) from rewardawardtransactions where
rewardawardtransactions.rewpartid=REWARDPARTICIPANTS.rewpartid
and rewawardtrxndeleted=0
)
</fieldname>
<alias>THIS_MONTH_AWARDED_AMOUNT</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_balance</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>
(
select COALESCE(sum(COALESCE(rewspendtrxntotalamt,0)),0) from rewardspendtransactions where
rewardspendtransactions.rewpartid=REWARDPARTICIPANTS.rewpartid
and rewspendtrxndeleted=0
)
</fieldname>
<alias>THIS_MONTH_SPEND_AMOUNT</alias>
<width>1</width>
<hidden>1</hidden>
<widthType>PERCENTAGE</widthType>
<header>key_balance</header>
<fieldtype>FTXINTEGER</fieldtype>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>(SELECT COUNT(WALLETID) FROM WALLETS WHERE WALLETS.ACCRECID = ACCOUNTSRECEIVABLE.ACCRECID AND WALLETS.WALLETDELETED = 0)</fieldname>
<alias>NUMOFWALLETS</alias>
<hidden>1</hidden>
<fieldtype>FTXINTEGER</fieldtype>
</column>
<column>
<fieldname>(SELECT COUNT(REWPARTSCHEMEID) FROM REWARDPARTICIPATINGSCHEMES WHERE REWARDPARTICIPATINGSCHEMES.REWPARTID = REWARDPARTICIPANTS.REWPARTID AND REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMEDELETED = 0 AND REWPARTSCHEMESIGNOFFDATE IS NULL)</fieldname>
<alias>NUMOFSIGNUPSCHEMES</alias>
<hidden>1</hidden>
<fieldtype>FTXINTEGER</fieldtype>
</column>
<column>
<fieldname>(SELECT COUNT(REWPARTSCHEMEID) FROM REWARDPARTICIPATINGSCHEMES WHERE REWARDPARTICIPATINGSCHEMES.REWPARTID = REWARDPARTICIPANTS.REWPARTID AND REWARDPARTICIPATINGSCHEMES.REWPARTSCHEMEDELETED = 0 AND REWPARTSCHEMESIGNOFFDATE IS NOT NULL)</fieldname>
<alias>NUMOFSIGNOFFSCHEMES</alias>
<hidden>1</hidden>
<fieldtype>FTXINTEGER</fieldtype>
</column>
<column>
<widthType>PERCENTAGE</widthType>
<header>key_number</header>
</column><fieldname>(SELECT COUNT(ACCESSTOKENID) FROM ACCESSTOKENS WHERE ACCESSTOKENS.REWPARTID = REWARDPARTICIPANTS.REWPARTID AND ACCESSTOKENS.ACCESSTOKENDELETED = 0 AND ACCESSTOKENS.LIFECYCLESTATE= 'EFFECTIVE')</fieldname>
<alias>NUMOFACCESSTOKNES</alias>
<column> <fieldname>ACCOUNTSRECEIVABLE.ACCRECNAME</fieldname>
<hidden>1</hidden>
<alias>ACCOUNTSOWNER<<fieldtype>FTXINTEGER</alias>fieldtype>
</column>
<width>10<</width>columns>
<groups>
<group>
<groupid>ACCOUNT_RECEIVABLE_CLASSIFICATION</groupid>
<widthType>PERCENTAGE</widthType>
<sortorder>ACCOUNTSRECEIVABLE.ACCCLASSID</sortorder>
<header>key<groupbyheader>key_accounts_accountreceivable_information<classification</header>groupbyheader>
<header>
</column> <column>
<column> <fieldname><fieldname>ACCCLASSNAME</fieldname>
CASE<width>25</width>
WHEN ACCOUNTSRECEIVABLE.LIFECYCLESTATE='ACTIVE' then 'Active' <widthType>PERCENTAGE</widthType>
WHEN ACCOUNTSRECEIVABLE.LIFECYCLESTATE='SUSPENDED' then 'Suspended'
<header>key_accounts_receivable_classification:</header>
WHEN ACCOUNTSRECEIVABLE.LIFECYCLESTATE='TERMINATED' then 'Terminated'
</column>
</header>
<footer>
END <column>
</fieldname> <fieldname>=COUNT({EFFECTIVE_PARTICIPANTS})</fieldname>
<alias>ACCOUNT_LIFECYCLESTATE</alias>
<header>key_effective_reward_participants:</header>
<width>25</width>
<width>10<<widthType>PERCENTAGE</width>widthType>
</column>
<column>
<widthType>PERCENTAGE</widthType>
<fieldname>=COUNT({TERMINATED_PARTICIPANTS})</fieldname>
<header>key_lifeterminated_cyclereward_state<participants:</header>
<<width>25</column>width>
<column><widthType>PERCENTAGE</widthType>
<fieldname>ACCRECCREATEDDATE<</fieldname>column>
<width>10</width></footer>
<header>key_date_created</header>
</group>
<group>
<widthType>PERCENTAGE</widthType>
<groupid>SIGN_UP_UNIT</groupid>
<sortorder>OUUNITS.OUUID</sortorder>
<fieldtype>FTXDATE</fieldtype>
</column>
<groupbyheader>key_sign_up_unit</groupbyheader>
<header>
<column>
<fieldname>COALESCE(COALESCE(CURRENCYRATEPERIODS.CURRENCYPERIODINVERSERATE,1) * OUTSTANDINGAMOUNT_VALUE,0)</fieldname> <alias>OUTSTANDINGAMOUNT_VALUE<<fieldname>OUUNAME</alias>fieldname>
<width>10< <width>25</width>
<widthType>PERCENTAGE</widthType>
<header>key_sign_outstandingup_amount<unit:</header>
<fieldtype>FTXFLOAT<</fieldtype>column>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol></header>
<footer>
<column>
</column> ...<fieldname>=COUNT({EFFECTIVE_PARTICIPANTS})</fieldname>
<header>key_effective_reward_participants:</columns>header>
<groups> <group>
<width>25</width>
<groupid>OUGNAME<<widthType>PERCENTAGE</groupid>
widthType>
<sortorder>OUGNAME<</sortorder>column>
<column>
<groupbyheader>key_owned_by_group</groupbyheader>
<header>
<fieldname>=COUNT({TERMINATED_PARTICIPANTS})</fieldname>
<header>key_terminated_reward_participants:</header>
<column><width>25</width>
<widthType>PERCENTAGE</widthType>
</column>
<fieldname>OUGNAME<</fieldname>footer>
</group>
<width>25<</width>groups>
<footers>
<widthType>PERCENTAGE</widthType> <column>
<fieldname>=COUNT({REWPARTNUM})</fieldname>
<header>key_number_ownedof_byreward_groupparticipants:</header>
<<width>15</column>width>
<widthType>PERCENTAGE</widthType>
</header>
column>
<footer> <column>
<fieldname>=COUNTSUM({ACCRECNUMTHIS_MONTH_SCHEME_SIGN_UPS})</fieldname>
<header>key_scheme_sign_numberups_ofduring_accountsthis_receivablemonth:</header>
<width>33<<width>15</width>
<widthType>PERCENTAGE</widthType>
<fieldtype>FTXINTEGER</fieldtype>
</column>
<column>
<fieldname>=SUM({OUTSTANDINGAMOUNT_VALUETHIS_MONTH_SCHEME_SIGN_OFFS})</fieldname>
<header>key_outstanding_amountscheme_sign_offs_during_this_month:</header>
<width>33<<width>15</width>
<widthType>PERCENTAGE</widthType>
<displaydefaultcurrencysymbol>true<<fieldtype>FTXINTEGER</displaydefaultcurrencysymbol>fieldtype>
</column>
<column>
<fieldname>=SUMCOUNT({BALANCEEFFECTIVE_VALUEPARTICIPANTS})</fieldname>
<header>key_effective_accountreward_balanceparticipants:</header>
<width>33<<width>15</width>
<widthType>PERCENTAGE</widthType>
</column>
<column>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol> <fieldname>=COUNT({TERMINATED_PARTICIPANTS})</column>
fieldname>
<header>key_terminated_reward_participants:</footer>header>
<<width>15</group>width>
...<widthType>PERCENTAGE</widthType>
</groups>column>
<footers>
<column>
<fieldname>=COUNT({ACCRECNUMTHIS_MONTH_TERMINATIONS})</fieldname>
<header>key_numberterminations_ofduring_accountsthis_receivablemonth:</header>
<width>33<<width>15</width>
<widthType>PERCENTAGE</widthType>
</column>
<column>
<fieldname>=SUM({OUTSTANDINGAMOUNT_VALUETHIS_MONTH_AWARDED_AMOUNT})</fieldname>
<header>key_outstanding_amount<header>key_awarded_amount_during_this_month:</header>
<width>33<<width>15</width>
<widthType>PERCENTAGE<<displaydefaultcurrencysymbol>true</widthType>displaydefaultcurrencysymbol>
<alias>OUTSTANDINGAMOUNT_VALUE<<widthType>PERCENTAGE</alias>widthType>
<displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
</column>
<column>
<fieldname>=SUM({BALANCE_VALUETHIS_MONTH_SPEND_AMOUNT})</fieldname>
<header>key_account_balance_spent_amount_during_this_month:</header>
<width>33<<width>15</width>
<widthType>PERCENTAGE</widthType><displaydefaultcurrencysymbol>true</displaydefaultcurrencysymbol>
<displaydefaultcurrencysymbol>true<<widthType>PERCENTAGE</displaydefaultcurrencysymbol>widthType>
</column>
</footers>
</definition>
|