# View: KNR_Performer_Run_Prod_PostApproval_Summary

**View Name:** KNR_Performer_Run_Prod_PostApproval_Summary
**Table Source:** `Derived from: Prod.Accounting_Run_Results_Nr, Prod.Contract_Transaction_Nr, Prod.Stmt_Db_Sales_Nr, Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_Accounting_Royalty_Accounting.Account_Payment_Term + 3 more`
**File Path:** `views/KNR_Performer_Run_Prod_PostApproval_Summary.view.lkml`

## Overview

- **File Size:** 2765 bytes
- **Lines of Code:** 100
- **Dimensions:** 8
- **Measures:** 4
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Run_Controller_ID` | string |
| `Accounting_Run_ID` | string |
| `Accounting_Run_Name` | string |
| `Account_ID` | string |
| `Account_Name` | string |
| `Contract_ID` | string |
| `Contract_Name` | string |
| `Payee_Currency` | string |

## Measures

| Name | Type |
|------|------|
| `Gross_Revenue_Payee_Currency` | sum |
| `Withholding_Tax_Payee_Currency` | sum |
| `Gross_Revenue_After_Withholding_Tax_Payee_Currency` | sum |
| `Net_Share_Payee_Currency` | sum |

## SQL Comments

- Payee Currency
- contract
- account
- predicates

## Derived Table

```sql
sql:

    select
    rcc.run_controller_id,
    arr.accounting_run_id,
    arr.accounting_run_name,
    cts.account_id,
    a.account_name,
    cts.contract_id,
    c.contract_name,
-- Payee Currency
    apt.currency_code,
    sum(nvl(arr.gross_revenue_payee_currency,0)) as gross_revenue_payee_currency,
    sum(nvl(arr.withholding_tax_payee_currency,0)) as withholding_tax_payee_currency,
    sum(nvl(arr.gross_revenue_after_withholding_tax_payee_currency,0)) as gross_revenue_after_withholding_tax_payee_currency,
    sum(nvl(arr.net_share_payee_currency,0)) as net_share_payee_currency
-- sales
from royalty_accounting.prod.accounting_run_results_nr as arr
join royalty_accounting.prod.stmt_db_sales_nr as txn on arr.txn_id = txn.stmt_db_sales_nr_txn_id
-- contract
join royalty_accounting.prod.contract_transaction_nr as cts on arr.txn_id = cts.txn_id and cts.accounting_run_id=arr.accounting_run_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract as c on cts.contract_id = c.contract_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.run_controller_contract rcc
    on rcc.contract_id=c.contract_id
-- account
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.account as a on cts.account_id = a.account_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.account_payment_term as apt on a.account_id = apt.account_id
-- predicates
where true
group by 1,2,3,4,5,6,7,8
;;
```