# View: facts_prod_vw_workstation_summary

**View Name:** facts_prod_vw_workstation_summary
**Table Source:** `ROYALTY_ACCOUNTING.PROD.VW_WORKSTATION_SUMMARY_UNIFIED`
**File Path:** `facts_prod_vw_workstation_summary.view.lkml`

## Overview

- **File Size:** 4322 bytes
- **Lines of Code:** 226
- **Dimensions:** 23
- **Measures:** 13
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- #dimensions are duplicated as measures to answer Ignasi's question (Ticket: Request:Spain Labels - Accounting & Advances)

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |
| `vendor_period_id` | string |
| `vendor` | string |
| `currency` | string |
| `term` | string |
| `period_id` | number |
| `periods` | string |
| `gross` | number |
| `adjusted_gross` | number |
| `dist_fee` | number |
| `fee_perc` | number |
| `opening_balance` | number |
| `advanced_paid` | number |
| `revenue` | number |
| `publishing` | number |
| `expenses` | number |
| `adjustments` | number |
| `payment` | number |
| `recoup` | number |
| `outstanding_balance` | number |
| `workstationsum` | number |
| `delta` | number |
| `outstanding_balance_usd` | number |

## Measures

| Name | Type |
|------|------|
| `gross_measure` | sum |
| `dist_fee_measure` | sum |
| `opening_balance_measure` | sum |
| `advanced_paid_measure` | sum |
| `revenue_measure` | sum |
| `publishing_mesure` | sum |
| `expenses_measure` | sum |
| `adjustments_measure` | sum |
| `payment_measure` | sum |
| `recoup_measure` | sum |
| `outstanding_balance_measure` | sum |
| `delta_measure` | sum |
| `outstanding_balance_measure_usd` | sum |