View: AMS_DM_PARTY_PROFIT_V

View Text

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

Columns