[Home] [Help]
SELECT customer_id AS party_id, profit_contrib AS profit,profit_percentile AS profit_pct,relationship_exp AS relationship_expense, allocated_equity AS total_equity, numeric_measure01 AS total_gross_contrib, return_on_equity AS total_roe, contrib_after_capital_chg AS contrib_after_cptl_chg, value_index1 AS partner_value_index, currency_code AS iso_currency_cd, numeric_measure01 AS revenue1, numeric_measure02 AS revenue2, numeric_measure03 AS revenue3, numeric_measure04 AS revenue4, numeric_measure05 AS revenue5, total_revenue AS revenue_total, numeric_measure01 AS expense1, numeric_measure02 AS expense2, numeric_measure03 AS expense3, numeric_measure04 AS expense4, numeric_measure05 AS expense5, total_expense AS expense_total, numeric_measure01 AS profit1, numeric_measure02 AS profit2, numeric_measure03 AS profit3, numeric_measure04 AS profit4, numeric_measure05 AS profit5, profit_contrib AS profit_total, contrib_after_capital_chg AS cacc1, contrib_after_capital_chg AS cacc2, contrib_after_capital_chg AS cacc3, contrib_after_capital_chg AS cacc4, contrib_after_capital_chg AS cacc5, contrib_after_capital_chg AS cacc_total, cur_net_book_bal AS balance1, cur_net_book_bal AS balance2, cur_net_book_bal AS balance3, cur_net_book_bal AS balance4, cur_net_book_bal AS balance5, pri_accounts AS accounts1, pri_accounts AS accounts2, pri_accounts AS accounts3, pri_accounts AS accounts4, pri_accounts AS accounts5, 1 AS transaction1, 1 AS transaction2, 1 AS transaction3, 1 AS transaction4, 1 AS transaction5, 1 AS ratio1, 1 AS ratio2, 1 AS ratio3, 1 AS ratio4, 1 AS ratio5, 1 AS value1, 1 AS value2, 1 AS value3, 1 AS value4, 1 AS value5, ptd_balance AS ytd1, ptd_balance AS ytd2, ptd_balance AS ytd3, ptd_balance AS ytd4, ptd_balance AS ytd5, ltd_balance AS ltd1, ltd_balance AS ltd2, ltd_balance AS ltd3, ltd_balance AS ltd4, ltd_balance AS ltd5 FROM fem_customer_profit
SELECT CUSTOMER_ID AS PARTY_ID
, PROFIT_CONTRIB AS PROFIT
, PROFIT_PERCENTILE AS PROFIT_PCT
, RELATIONSHIP_EXP AS RELATIONSHIP_EXPENSE
, ALLOCATED_EQUITY AS TOTAL_EQUITY
, NUMERIC_MEASURE01 AS TOTAL_GROSS_CONTRIB
, RETURN_ON_EQUITY AS TOTAL_ROE
, CONTRIB_AFTER_CAPITAL_CHG AS CONTRIB_AFTER_CPTL_CHG
, VALUE_INDEX1 AS PARTNER_VALUE_INDEX
, CURRENCY_CODE AS ISO_CURRENCY_CD
, NUMERIC_MEASURE01 AS REVENUE1
, NUMERIC_MEASURE02 AS REVENUE2
, NUMERIC_MEASURE03 AS REVENUE3
, NUMERIC_MEASURE04 AS REVENUE4
, NUMERIC_MEASURE05 AS REVENUE5
, TOTAL_REVENUE AS REVENUE_TOTAL
, NUMERIC_MEASURE01 AS EXPENSE1
, NUMERIC_MEASURE02 AS EXPENSE2
, NUMERIC_MEASURE03 AS EXPENSE3
, NUMERIC_MEASURE04 AS EXPENSE4
, NUMERIC_MEASURE05 AS EXPENSE5
, TOTAL_EXPENSE AS EXPENSE_TOTAL
, NUMERIC_MEASURE01 AS PROFIT1
, NUMERIC_MEASURE02 AS PROFIT2
, NUMERIC_MEASURE03 AS PROFIT3
, NUMERIC_MEASURE04 AS PROFIT4
, NUMERIC_MEASURE05 AS PROFIT5
, PROFIT_CONTRIB AS PROFIT_TOTAL
, CONTRIB_AFTER_CAPITAL_CHG AS CACC1
, CONTRIB_AFTER_CAPITAL_CHG AS CACC2
, CONTRIB_AFTER_CAPITAL_CHG AS CACC3
, CONTRIB_AFTER_CAPITAL_CHG AS CACC4
, CONTRIB_AFTER_CAPITAL_CHG AS CACC5
, CONTRIB_AFTER_CAPITAL_CHG AS CACC_TOTAL
, CUR_NET_BOOK_BAL AS BALANCE1
, CUR_NET_BOOK_BAL AS BALANCE2
, CUR_NET_BOOK_BAL AS BALANCE3
, CUR_NET_BOOK_BAL AS BALANCE4
, CUR_NET_BOOK_BAL AS BALANCE5
, PRI_ACCOUNTS AS ACCOUNTS1
, PRI_ACCOUNTS AS ACCOUNTS2
, PRI_ACCOUNTS AS ACCOUNTS3
, PRI_ACCOUNTS AS ACCOUNTS4
, PRI_ACCOUNTS AS ACCOUNTS5
, 1 AS TRANSACTION1
, 1 AS TRANSACTION2
, 1 AS TRANSACTION3
, 1 AS TRANSACTION4
, 1 AS TRANSACTION5
, 1 AS RATIO1
, 1 AS RATIO2
, 1 AS RATIO3
, 1 AS RATIO4
, 1 AS RATIO5
, 1 AS VALUE1
, 1 AS VALUE2
, 1 AS VALUE3
, 1 AS VALUE4
, 1 AS VALUE5
, PTD_BALANCE AS YTD1
, PTD_BALANCE AS YTD2
, PTD_BALANCE AS YTD3
, PTD_BALANCE AS YTD4
, PTD_BALANCE AS YTD5
, LTD_BALANCE AS LTD1
, LTD_BALANCE AS LTD2
, LTD_BALANCE AS LTD3
, LTD_BALANCE AS LTD4
, LTD_BALANCE AS LTD5
FROM FEM_CUSTOMER_PROFIT
|
|
|
|