# View: historic_generated_income_abacus_format

**View Name:** historic_generated_income_abacus_format
**Table Source:** `Derived from: Dbt_Prod_Knr.Historic_Generated_Income_Summary_Account_Currency, Intelligence.Dbt_Prod_Knr`
**File Path:** `views/historic_generated_income_abacus_format.view.lkml`

## Overview

- **File Size:** 5823 bytes
- **Lines of Code:** 282
- **Dimensions:** 42
- **Measures:** 5
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `AGR_ID` | string |
| `AGR_Assignor_ID` | string |
| `AGR_Assignor` | string |
| `Rights_Description` | string |
| `AGR_Outgoing_Type` | string |
| `NR_Agreement_Type` | string |
| `Contributor_ID` | string |
| `Contributor_Name` | string |
| `Source_CMO` | string |
| `WRC_ID` | string |
| `WRC_Title` | string |
| `WRC_Version` | string |
| `WRC_ISRC` | string |
| `WRC_Artist` | string |
| `Right_Type` | string |
| `Territory_Name` | string |
| `Reconciliation_Date` | date |
| `Usage_Start_Date` | date |
| `Usage_End_Date` | date |
| `Acc_Currency` | string |
| `Commission_rate` | number |
| `statement_period_id` | string |
| `original_statement_period_id` | string |
| `original_statement_period_name` | string |
| `sh_batch_id` | string |
| `abacus_sale_type` | string |
| `accounting_run_id` | string |
| `contract_name` | string |
| `contract_term_id` | string |
| `contract_term_name` | string |
| `contribution_id` | string |
| `transaction_subtype` | string |
| `txn_id` | string |
| `contributor_only` | string |
| `activity_rate` | string |
| `payee_currency` | string |
| `total_usd` | string |
| `wht_usd` | string |
| `gross_revenue_sales_currency` | string |
| `wht_sales_currency` | string |
| `gross_revenue_after_WHT_sales_currency` | string |
| `net_share_sales_currency` | string |

## Measures

| Name | Type |
|------|------|
| `Source_Amount_ACC_CCY` | sum |
| `WHT_Amount_ACC_CCY` | sum |
| `WHT_Adjusted_Received_Amount_ACC_CCY` | sum |
| `Commission_ACC_CCY` | sum |
| `Distributed_Amount_ACC_CCY` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `Payment_Date` | time |

## Derived Table

```sql
sql:
    select
AGR_ID, AGR_ASSIGNOR_ID, AGR_ASSIGNOR, RIGHTS_DESCRIPTION, AGR_OUTGOING_TYPE, NR_AGREEMENT_TYPE, CONTRIBUTOR_ID, CONTRIBUTOR_NAME, SOURCE_CMO, WRC_ID, WRC_TITLE, WRC_VERSION, WRC_ISRC, WRC_ARTIST, RIGHT_TYPE, TERRITORY_NAME, PAYMENT_DATE, RECONCILIATION_DATE, USAGE_START_DATE, USAGE_END_DATE, ACC_CURRENCY, COMMISSION_RATE, SOURCE_AMOUNT_ACC_CCY, WHT_AMOUNT_ACC_CCY, WHT_ADJUSTED_RECEIVED_AMOUNT_ACC_CCY, COMMISSION_ACC_CCY, DISTRIBUTED_AMOUNT_ACC_CCY,
'' as statement_period_id,
'' as original_statement_period_id,
'' as original_statement_period_name,
'' as sh_batch_id,
'' as abacus_sale_type,
'' as accounting_run_id,
'' as contract_name,
'' as contract_term_id,
'' as contract_term_name,
'' as contribution_id,
'' as transaction_subtype,
'' as txn_id,
'' as contributor_only,
'' as activity_rate,
'' as payee_currency,
'' as total_usd,
'' as wht_usd,
'' as gross_revenue_sales_currency,
'' as wht_sales_currency,
'' as gross_revenue_after_WHT_sales_currency,
'' as net_share_sales_currency

from INTELLIGENCE.DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_ACCOUNT_CURRENCY
;;
```