# View: New_Income_Summary

**View Name:** new_income_summary
**Table Source:** `Derived from: Prod.Stmt_Db_Sales_Nr, Prod.Vw_Abacus_Fact_Sales_Nr_V3, Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_Accounting_Royalty_Accounting.Contract, Prod_Royalty_Accounting_Royalty_Accounting.Contract_Term + 3 more`
**File Path:** `views/New_Income_Summary.view.lkml`

## Overview

- **File Size:** 9477 bytes
- **Lines of Code:** 179
- **Dimensions:** 1
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- #############################
- ##  ALL DIMENSIONS BELOW  ###
- #############################

## Dimensions

| Name | Type |
|------|------|
| `Statement_Period_ID` | string |

## Measures

| Name | Type |
|------|------|
| `Unit_Price_USD` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `Usage_Start_Date` | time |

## SQL Comments

- NEW FIELD ADDED HERE

## Derived Table

```sql
sql:
    select
        corx.STATEMENT_PERIOD_ID,
        asp.statement_period_name,
        asp.statement_year YEAR,
        asp.statement_month MONTH,
        corx.ORIGINAL_STATEMENT_PERIOD_ID,
        aspo.statement_period_name ORIGINAL_STATEMENT_PERIOD_NAME,
        aspo.statement_year ORIGINAL_YEAR,
        aspo.statement_month ORIGINAL_MONTH,
        txn.batch_id SH_BATCH_ID,
        corx.ABACUS_SALE_TYPE,
        corx.accounting_run_id,
        corx.account_id,
        a.account_name,
        corx.contract_id,
        c.contract_name,
        ct.contract_term_id,
        ct.contract_term_name,
        corx.contributor_id,
        corx.CONTRIBUTOR_NAME,
        corx.schedule_id,
        case when sh.schedule_name is null then ct.contract_term_name else sh.schedule_name end as schedule_name,
        txn.contributor_name reported_contributor_name,
        corx.sound_recording_id,
        sr.main_artist,
        sr.recording_title,
        sr.version recording_version,
        corx.isrc,
        txn.contribution_id,
        txn.contributor_only,
        corx.STORE_ID Society_ID,
        cmm.customer_name Society_Name,
        corx.country_id,
        cn.name country_name,
        cn.ISO3166A3 as iso_3,
        corx.transaction_type txn_type_abbrev,
        t.transactiontypedesc trans_type,
        corx.TRANSACTION_SUBTYPE_DESCRIPTION trans_sub_type,
        corx.start_date Usage_Start_Date,
        corx.end_date Usage_End_Date,
        corx.txn_id,
        txn.quantity,
        txn.UNIT_PRICE_USD,
        txn.TOTAL_USD,
        txn.WITHHOLDING_TAX_USD,
        txn.activity_rate,
        corx.royalty_rate,

      -- NEW FIELD ADDED HERE
      (corx.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * txn.activity_rate)
      AS GROSS_REVENUE_AFTER_WITHHOLDING_TAX_USD,

      corx.sale_currency_code as sale_currency,
      corx.UNIT_PRICE_SALE_CURRENCY,
      corx.GROSS_REVENUE_SALE_CURRENCY,
      corx.WITHHOLDING_TAX_SALE_CURRENCY,
      corx.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY,
      corx.NET_SHARE_SALE_CURRENCY,
      corx.ACCOUNT_PAYEE_CURRENCY as payee_currency,
      corx.unit_price_payee_currency,
      corx.GROSS_REVENUE_PAYEE_CURRENCY,
      corx.withholding_tax_payee_currency,
      corx.gross_revenue_after_withholding_tax_payee_currency,
      corx.NET_SHARE_PAYEE_CURRENCY

      from royalty_accounting.prod.vw_abacus_fact_sales_nr_v3 corx
      join royalty_accounting.prod.stmt_db_sales_nr txn
      on corx.txn_id = txn.stmt_db_sales_nr_txn_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract c
      on corx.contract_id = c.contract_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_term_condition ctc
      on corx.contract_term_condition_id = ctc.contract_term_condition_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_term ct
      on ctc.contract_term_id = ct.contract_term_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.run_controller_contract rcc
      on rcc.contract_id=c.contract_id and rcc.run_controller_id=6
      left join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.schedule sh
      on corx.schedule_id = sh.schedule_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.account a
      on corx.account_id = a.account_id
      join facts.prod.dim_transactiontype t
      on corx.transaction_type = t.transactiontypeabbr
      left join orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master cmm
      on cmm.customer_master_master_id=corx.store_id
      left join orchard_app_reporting_v2.art_relations_prod_art_relations.country cn
      on cn.id=corx.country_id
      left join facts.prod.performance_nr_sound_recording sr
      on sr.id=txn.sound_recording_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.statement_period asp
      on corx.statement_period_id = asp.statement_period_id
      join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.statement_period aspo
      on corx.ORIGINAL_STATEMENT_PERIOD_ID = aspo.statement_period_id

      order by corx.txn_id, account_id, contract_id
      ;;
```