# View: dt_outstanding_balances_2

**View Name:** dt_outstanding_balances_2
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_OUTSTANDING_BALANCES_2`
**File Path:** `dt_outstanding_balances_2.view.lkml`

## Overview

- **File Size:** 2154 bytes
- **Lines of Code:** 67
- **Dimensions:** 7
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: SELECT
- va.period_id,

## Dimensions

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

## 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
#     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 va.entry_type = 'balance_forward'  and cr.currency_to_id = 1 and va.period_id = (SELECT MAX(accountingperiodid)-1 FROM royalty_accounting.prod.workstation_fact_sales_unified_dbt )
# AND o.owner_id NOT IN (196,197)
# GROUP BY 1,2,3,4,5,6,7;;
#
```