view: int_dbt_prod_label_lookback {
  # You can specify the table name if it's different from the view name:
  sql_table_name: intelligence.dbt_prod_strategy.label_lookback ;;

  # Define your dimensions and measures here, like this:
  dimension: vendor_id {
    description: "Unique Vendor ID"
    type: number
    sql: ${TABLE}.vendor_id ;;
  }

  dimension: vendor {
    description: "Vendor Name"
    type: string
    sql: ${TABLE}.vendor ;;
  }

  dimension: brand_name {
    description: "Orchard brand"
    type: string
    sql:  ${TABLE}.brand_name ;;
  }

  dimension: owner {
    description: "Orchard owner"
    type: string
    sql:  ${TABLE}.owner ;;
  }

  dimension: service_tier_name {
    description: "Assigned service tier for the label"
    type: string
    sql: ${TABLE}.service_tier_name ;;
  }

  dimension: closer {
    description: "List of assigned Closers"
    type: string
    sql: ${TABLE}.closer ;;
  }

  dimension: label_start_date {
    description: "Date of first label contract"
    type: date
    sql: ${TABLE}.label_start_date ;;
  }

  dimension: contract_end_date {
    description: "Maximum label contract end date"
    type: date
    sql: ${TABLE}.contract_end_date ;;
  }

  measure: gross_revenue {
    description: "Gross revenue"
    type: number
    sql: sum(${TABLE}.gross_revenue) ;;
  }

  measure: distro_fee {
    description: "Distrobution Fee"
    type: number
    sql: sum(${TABLE}.distro_fee) ;;
  }

  measure: advance_paid {
    description: "Advances paid in USD"
    type: number
    sql: sum(${TABLE}.advance_paid) ;;
  }

  measure: payment {
    description: "Payments made to the label"
    type: number
    sql: sum(${TABLE}.payment) ;;
  }

  measure: net_revenue {
    description: "Net revenue"
    type: number
    sql: sum(${TABLE}.net_revenue) ;;
  }

  measure: expenses {
    description: "Label Expenses"
    type: number
    sql: sum(${TABLE}.expenses) ;;
  }

  measure: adjustments {
    description: "Label Adjustments"
    type: number
    sql: sum(${TABLE}.adjustments) ;;
  }

  measure: current_oustanding_balance {
    description: "Current Outstanding Balance"
    type: number
    sql: sum(${TABLE}.current_outstanding_balance) ;;
  }

  measure: net_cash_position {
    description: "Net Cash Position"
    type: number
    sql: sum(${TABLE}.net_cash_position) ;;
  }

  measure: tax_adjusted_net_cash_position {
    description: "Net Cash Position with a 24% estimated tax applied"
    type: number
    sql: sum(${TABLE}.tax_adjusted_net_cash_position) ;;
  }

  measure: moic {
    description: "MOIC"
    type: number
    sql:  sum(${TABLE}.moic) ;;
  }

  measure: tax_adjusted_moic {
    description: "MOIC with a 24% estimated tax applied"
    type: number
    sql:  sum(${TABLE}.tax_adjusted_moic) ;;
  }
}