# View: manual_adjustment_usd_and_ccur

**View Name:** manual_adjustment_usd_and_ccur
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Currencies, Art_Relations_Prod_Art_Relations.Currency_Exchange_Rates, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Vw_Abacus_Manual_Adjustment, Prod.Vw_Dim_Abacus_Ar_Booked_Vendor_Contract_Snapshot + 3 more`
**File Path:** `manual_adjustment_usd_and_ccur.view.lkml`

## Overview

- **File Size:** 2363 bytes
- **Lines of Code:** 100
- **Dimensions:** 5
- **Measures:** 3
- **Dimension Groups:** 0
- **Filters:** 1

## Comments & Notes

- accountingmonth,
- accountingyear,

## Dimensions

| Name | Type |
|------|------|
| `labelid` | number |
| `primary_key` | number |
| `category_code` | string |
| `apply_to_period_id` | number |
| `payout_currency_code` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `adjustment_usd` | sum |
| `adjustment_ccur` | sum |

## Filters

- `periodid_filter`

## Derived Table

```sql
sql: SELECT
    ma.apply_to_period_id, ma.parent_id,  c.iso_4217_code as payout_currency_code,
            sum(case when ma.currencies_id = c.id
            then ma.amount_in_original_currency
            else ma.amount * cr.exchange_rate
            end) as payout_currency_adjustment,

            sum(ma.amount) as usd_adjustment


      FROM ROYALTY_ACCOUNTING.PROD.VW_ABACUS_MANUAL_ADJUSTMENT ma

      left join ROYALTY_ACCOUNTING_REPORTING.PROD.VW_DIM_ABACUS_AR_BOOKED_VENDOR_CONTRACT_SNAPSHOT vcc on ma.parent_id=vcc.vendor_id and ma.apply_to_period_id=vcc.period_id

      left join orchard_app_reporting_v2.art_relations_prod_art_relations.currency_exchange_rates cr on cr.currency_to_id=vcc.currency_id

      and cr.period_id = ma.apply_to_period_id

      left join orchard_app_reporting_v2.art_relations_prod_art_relations.currencies c on c.id=cr.currency_to_id

      WHERE ma.parent_type = 'vendor' and cr.currency_from_id = 1

      AND {% condition periodid_filter %
```