# View: dt_label_balances

**View Name:** dt_label_balances
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Currencies, Art_Relations_Prod_Art_Relations.Currency_Exchange_Rates, Art_Relations_Prod_Art_Relations.Owner, Prod.Vw_Abacus_Vendor_Accounting, Prod.Vw_Dim_Abacus_Ar_Booked_Vendor_Contract_Snapshot + 3 more`
**File Path:** `dt_label_balances.view.lkml`

## Overview

- **File Size:** 12793 bytes
- **Lines of Code:** 290
- **Dimensions:** 18
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `filter_label_id` | string |
| `vendor_id` | number |
| `label_name` | string |
| `owner_name` | string |
| `currency_code` | string |
| `period_id` | number |
| `advance_payment_USD` | number |
| `advance_payment_original_currency` | number |
| `actual_net_USD` | number |
| `actual_net_original_currency` | number |
| `recoupable_costs_USD` | number |
| `recoupable_costs_original_currency` | number |
| `total_payments_USD` | number |
| `total_payments_original_currency` | number |
| `adjustment_amount_USD` | number |
| `adjustment_amount_original_currency` | number |
| `outstanding_balance_USD` | number |
| `outstanding_balance_original_currency` | number |

## Derived Table

```sql
sql: with advance_payment as (

SELECT
    v.vendor_id,
    c.ISO_4217_code,
    va.entry_type,
    sum(va.amount) AS advance_payment_USD,
    sum(va.amount * (1/cr.exchange_rate)) AS advance_payment_original_currency
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
    INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON va.vendor_id = v.vendor_id
    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.owner o ON o.owner_abbrivation = v.owner
WHERE {% condition filter_label_id %
```