# View: dt_advances_2

**View Name:** dt_advances_2
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Owner, Art_Relations_Prod_Art_Relations.Period, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Vw_Abacus_Vendor_Accounting, Prod.Vw_Dim_Abacus_Ar_Vendor + 3 more`
**File Path:** `dt_advances_2.view.lkml`

## Overview

- **File Size:** 1035 bytes
- **Lines of Code:** 36
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `advance_payment` | number |
| `accounting_month` | string |
| `label_id` | number |

## Derived Table

```sql
sql: SELECT
    va.vendor_id AS label_id,
    p.year||'-'||RIGHT((0||p.month),2) AS accounting_month,
    va.amount AS advance_payment
FROM ROYALTY_ACCOUNTING.PROD.VW_ABACUS_VENDOR_ACCOUNTING va
    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.period p ON va.period_id = p.period_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 entry_type = 'advance_payment'
AND o.owner_id NOT IN (196,197)
ORDER BY 1,2 ASC
;;
```