# View: int_dbt_prod_orca_a_and_lp_dataset

**View Name:** int_dbt_prod_orca_a_and_lp_dataset
**Table Source:** `INTELLIGENCE.DBT_PROD.ORCA_A_AND_LP_DATASET`
**File Path:** `views/orca_a_and_lp/int_dbt_prod_orca_a_and_lp_dataset.view.lkml`

## Overview

- **File Size:** 19274 bytes
- **Lines of Code:** 702
- **Dimensions:** 50
- **Measures:** 24
- **Dimension Groups:** 5
- **Filters:** 0

## Comments & Notes

- ,##0.00;($#,##0.00)"
- ,##0.00;($#,##0.00)"
- ,##0.00;($#,##0.00)"

## Dimensions

| Name | Type |
|------|------|
| `all_time_adjustments` | number |
| `all_time_advance_paid` | number |
| `all_time_advance_paid_airtable` | number |
| `all_time_distro_fee` | number |
| `all_time_expenses` | number |
| `all_time_gross_rev` | number |
| `all_time_net_cash_position` | number |
| `all_time_net_revenue` | number |
| `all_time_payment` | number |
| `latest_fy_projected_revenue` | number |
| `committed_advance` | number |
| `avg_net_rev_last_3_months` | number |
| `avg_rev_direction` | string |
| `bad_deal_risk` | string |
| `brand_name` | string |
| `closer` | string |
| `count_close_dates` | number |
| `total_advance_committed_salesforce_string` | string |
| `advance_payment_breakdown` | string |
| `advance_triggers` | string |
| `agreed_services` | string |
| `current_outstanding_balance` | number |
| `current_outstanding_balance_button` | string |
| `current_year_release_volume` | number |
| `est_months_to_recoup` | number |
| `new_deal_grouping` | string |
| `ltm_adjustments` | number |
| `ltm_advance_paid` | number |
| `ltm_distro_fee` | number |
| `ltm_expenses` | number |
| `ltm_gross_revenue` | number |
| `ltm_net_revenue` | number |
| `ltm_payment` | number |
| `moic` | number |
| `months_until_contract_end` | number |
| `owner` | string |
| `perc_recouped` | number |
| `qb_manager` | string |
| `vendor_country` | string |
| `relationship_manager` | string |
| `release_volume_yoy_change_perc` | number |
| `service_tier_name` | string |
| `termination_risk` | string |
| `total_releases` | number |
| `vendor_id` | number |
| `vendor_name` | string |
| `term_length` | number |
| `max_of_transaction_date_fiscal_month_num` | number |
| `gross_revenue_usd_current_fy` | number |
| `distribution_fee_usd_currrent_fy` | number |

## Measures

| Name | Type |
|------|------|
| `all_time_adjustments_sum` | sum |
| `all_time_advance_paid_sum` | sum |
| `all_time_advance_paid_airtable_sum` | sum |
| `all_time_distro_fee_sum` | sum |
| `all_time_expenses_sum` | sum |
| `all_time_gross_rev_sum` | sum |
| `all_time_net_cash_position_sum` | sum |
| `all_time_net_revenue_sum` | sum |
| `latest_fy_projected_revenue_sum` | sum |
| `committed_advance_sum` | sum |
| `all_time_payment_sum` | sum |
| `avg_net_rev_last_3_months_sum` | sum |
| `count_close_dates_sum` | sum |
| `current_outstanding_balance_sum` | sum |
| `ltm_adjustments_sum` | sum |
| `ltm_advance_paid_sum` | sum |
| `ltm_distro_fee_sum` | sum |
| `ltm_expenses_sum` | sum |
| `ltm_gross_revenue_sum` | sum |
| `ltm_net_revenue_sum` | sum |
| `ltm_payment_sum` | sum |
| `gross_revenue_usd_current_fy_sum` | sum |
| `distribution_fee_usd_currrent_fy_sum` | sum |
| `count` | count |

## Dimension Groups

| Name | Type |
|------|------|
| `contract_end` | time |
| `latest_close_date` | time |
| `latest_term_end_date` | time |
| `label_start` | time |
| `latest_contract_start` | time |