# View: manual_adjustment_usd_and_ccur_reserves_released

**View Name:** manual_adjustment_usd_and_ccur_reserves_released
**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_reserves_released.view.lkml`

## Overview

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

## Dimensions

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

## Measures

| Name | Type |
|------|------|
| `reserves_usd` | sum |
| `reserves_ccur` | sum |
| `reserves_released_ccur` | sum |

## Filters

- `periodid_filter`

## Derived Table

```sql
sql:
SELECT
    released.category_id,
    released.apply_to_period_id,
    released.parent_id,
    c.iso_4217_code AS payout_currency_code,
    SUM(released.amount) AS usd_adjustment,
    SUM(
        CASE
            WHEN released.apply_to_period_id <= 235 THEN released.amount * cr.exchange_rate
            WHEN released.apply_to_period_id  > 235 THEN released.amount / cr.exchange_rate
        END
    ) AS payout_currency_adjustment
FROM
    ROYALTY_ACCOUNTING.PROD.VW_ABACUS_MANUAL_ADJUSTMENT released
LEFT JOIN
    ROYALTY_ACCOUNTING_REPORTING.PROD.VW_DIM_ABACUS_AR_BOOKED_VENDOR_CONTRACT_SNAPSHOT vcc ON released.parent_id = vcc.vendor_id
    AND released.apply_to_period_id = vcc.period_id
LEFT JOIN
    orchard_app_reporting_v2.art_relations_prod_art_relations.currency_exchange_rates cr ON
    CASE
        WHEN released.apply_to_period_id <= 235 THEN
            cr.currency_to_id = vcc.currency_id
            AND cr.currency_from_id = 1
            AND cr.period_id = released.apply_to_period_id
        WHEN released.apply_to_period_id > 235 THEN
            cr.currency_from_id = vcc.currency_id
            AND cr.currency_to_id = 1
            AND cr.period_id = released.adjust_for_period_id
        END
LEFT JOIN
    orchard_app_reporting_v2.art_relations_prod_art_relations.currencies c ON
    CASE
        WHEN released.apply_to_period_id <= 235 THEN c.id = cr.currency_to_id
        WHEN released.apply_to_period_id  > 235 THEN c.id = cr.currency_from_id
    END
WHERE 1
    AND released.parent_type = 'vendor'
    AND released.category_id = 69
    AND {% condition periodid_filter %
```