# View: outstanding_balance_usd_and_ccur

**View Name:** outstanding_balance_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_Vendor_Accounting, Prod.Vw_Dim_Abacus_Ar_Booked_Vendor_Contract_Snapshot + 3 more`
**File Path:** `outstanding_balance_usd_and_ccur.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `period_id` | number |
| `id` | number |
| `vendor_id` | number |
| `iso_4217_code` | string |
| `entry_type` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `balance_fwd_usd` | sum |
| `balance_fwd_ccur` | sum |

## Filters

- `periodid_filter`

## Derived Table

```sql
sql: SELECT va.id, va.period_id, va.vendor_id, c.ISO_4217_code, va.entry_type,  va.amount AS USD_Balance_Fwd, va.amount* (1/cr.exchange_rate) AS Payout_currency_Balance_Fwd

      FROM ROYALTY_ACCOUNTING.PROD.VW_ABACUS_VENDOR_ACCOUNTING va

      left join ROYALTY_ACCOUNTING_REPORTING.PROD.VW_DIM_ABACUS_AR_BOOKED_VENDOR_CONTRACT_SNAPSHOT vcc on vcc.vendor_id=va.vendor_id and va.period_id=vcc.period_id

      left join orchard_app_reporting_v2.art_relations_prod_art_relations.currency_exchange_rates cr on cr.currency_from_id=vcc.currency_id and cr.period_id=va.period_id

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

      WHERE va.entry_type = 'balance_forward'  and cr.currency_to_id = 1

      AND {% condition periodid_filter %
```