# View: bvcs_vendor_max_period_id

**View Name:** bvcs_vendor_max_period_id
**Table Source:** `Derived from: Prod.Vw_Dim_Abacus_Ar_Booked_Vendor_Contract_Snapshot, Royalty_Accounting_Reporting, Royalty_Accounting_Reporting.Prod`
**File Path:** `bvcs_vendor_max_period_id.view.lkml`

## Overview

- **File Size:** 408 bytes
- **Lines of Code:** 20
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |
| `max_period_id` | number |

## Derived Table

```sql
sql:
      SELECT vendor_id, MAX(period_id) AS max_period_id
      FROM ROYALTY_ACCOUNTING_REPORTING.PROD.VW_DIM_ABACUS_AR_BOOKED_VENDOR_CONTRACT_SNAPSHOT
      GROUP BY 1
      ;;
```