# View: knr_vat_applied

**View Name:** knr_vat_applied
**Table Source:** `Derived from: Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accounting, Prod.Vw_Dim_Abacus_Account, Prod.Vw_Dim_Abacus_Contract, Prod_Royalty_Accounting_Royalty_Accounting.Abacus_Event, Prod_Royalty_Accounting_Royalty_Accounting.Accounting_Period + 3 more`
**File Path:** `views/knr_vat_applied.view.lkml`

## Overview

- **File Size:** 4452 bytes
- **Lines of Code:** 160
- **Dimensions:** 24
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Statement_Period_ID` | string |
| `Statement_Period_Name` | string |
| `Accounting_Period_ID` | string |
| `Accounting_Period_Name` | string |
| `Abacus_Event_ID` | string |
| `Created_By` | string |
| `Account_ID` | string |
| `Account_Name` | string |
| `Contract_ID` | string |
| `Contract_Name` | string |
| `Company_Code` | string |
| `Profit_Center` | string |
| `Legal_Name` | string |
| `VAT_Number` | string |
| `payee_currency_code` | string |
| `vat_currency_code` | string |
| `vat_commited_at` | string |
| `balance_before_commit_vat_payee_currency` | number |
| `committed_vat_payee_currency` | number |
| `net_balance_after_commit_vat_payee_currency` | number |
| `committed_vat_amount_vat_currency` | number |
| `vat_percentage` | string |
| `vat_category` | string |
| `account_paid_by` | string |

## Derived Table

```sql
sql:
      SELECT
          ae.statement_period_id Statement_Period_ID,
          asp.statement_period_name Statement_Period_Name,
          ap.accounting_period_id Accounting_Period_ID,
          ap.accounting_period_name Accounting_Period_Name,
          ae.abacus_event_id Abacus_Event_ID,
          ae.created_by,
          a.account_id,
          a.account_name,
          lvs.contract_id,
          dac.contract_name,
          dac.company_code,
          dac.profit_center,
          dac.signing_entity_legal_name as legal_name,
          dac.signing_entity_vat_number as vat_number,
          lvs.payee_currency_code as payee_currency_code,
          lvs.vat_currency_code as vat_currency_code,
          lvs.created_at as vat_commited_at,
          lvs.base_amount_payee_currency as balance_before_commit_vat_payee_currency,
          lvs.vat_amount_payee_currency as committed_vat_payee_currency,
          lvs.net_amount_payee_currency as net_balance_after_commit_vat_payee_currency,
          lvs.vat_amount_vat_currency as committed_vat_amount_vat_currency,
          lvs.vat_rate as vat_percentage,
          lvs.vat_category as vat_category,
          a.paid_by as account_paid_by
      FROM
          ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ABACUS_EVENT ae
          INNER JOIN ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ledger_vat_summary lvs ON lvs.abacus_event_id = ae.abacus_event_id
          INNER JOIN royalty_accounting.prod.vw_dim_abacus_contract dac ON dac.contract_id = lvs.contract_id
          INNER JOIN royalty_accounting.prod.vw_dim_abacus_account a ON a.account_id = lvs.account_id
          INNER JOIN ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ACCOUNTING_PERIOD ap ON ap.statement_period_id = lvs.statement_period_id
          and ap.contract_type = 'neighbouring_rights'
          join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.statement_period as asp on ae.target_id = asp.statement_period_id
          WHERE lvs.vat_category = 'commission';;
```