view: int_dbt_prod_revenue_apple_amazon_ex_spatial_deliveries {
    sql_table_name: intelligence.dbt_prod.revenue_apple_amazon_ex_spatial_deliveries ;;

    dimension: label_id{
      description: "Label ID"
      type: number
      view_label: "Label"
      sql: ${TABLE}.labelid ;;
    }

    dimension: label_name {
      description: "Label Name"
      type: string
      view_label: "Label"
      sql: ${TABLE}.labelname ;;
    }

    dimension_group: accounting {
      type: time
      view_label: "Accounting"
      timeframes: [date, day_of_week, week_of_year, week, month, year]
      sql: ${TABLE}.accounting_date ;;
      convert_tz: no
    }

    dimension: upc {
      type: number
      view_label: "Release"
      value_format: "#"
      sql: ${TABLE}.upc ;;
    }

    dimension: release_name {
      type: string
      view_label: "Release"
      sql: ${TABLE}.release_name ;;
    }

    dimension_group: release {
      type: time
      view_label: "Release"
      description: "Original date of release"
      timeframes: [date, day_of_week, week_of_year, week, month, year]
      sql: ${TABLE}.release_date ;;
      convert_tz: no
    }

    dimension: primary_relationship_manager {
      description: "Label Manager"
      type: string
      view_label: "Label"
      sql: ${TABLE}.primary_relationship_manager ;;
    }

    dimension: primary_relationship_manager_email {
      description: "Label Manager Email"
      type: string
      view_label: "Label"
      sql: ${TABLE}.email ;;
    }

    dimension: isrc {
      type: string
      view_label: "Track"
      sql: ${TABLE}.isrc ;;
    }

    dimension: track_name {
      type: string
      view_label: "Track"
      sql: ${TABLE}.trackname ;;
    }

    dimension: label_country {
      type: string
      view_label: "Label"
      sql: ${TABLE}.label_country ;;
    }

    dimension: service_tier_name {
      description: "Service Tier of the label"
      type: string
      view_label: "Orchard/ AWAL Tiers"
      sql: ${TABLE}.service_tier_name ;;
    }

    dimension: brand_name {
      description: "Brand Name"
      type: string
      view_label: "Orchard/ AWAL Tiers"
      sql: ${TABLE}.brand_name ;;
    }

    dimension: parent_company {
      description: "Parent Company"
      type: string
      view_label: "Orchard/ AWAL Tiers"
      sql: ${TABLE}.parent_company ;;
    }

    dimension: store{
      type: string
      view_label: "Store"
      sql: ${TABLE}.storename ;;
    }

    measure: units{
      description: "Total streams"
      type: sum
      view_label: "Accounting"
      sql: ${TABLE}.sales ;;
    }

    measure: gross_revenue {
      view_label: "Accounting"
      label: "Gross Revenue USD"
      type: sum
      sql: ${TABLE}.gross ;;
      value_format: "$#,##0.00"
    }

    measure: net_revenue {
      view_label: "Accounting"
      label: "Net Revenue USD"
      type: sum
      sql: ${TABLE}.net_receipt ;;
      value_format: "$#,##0.00"
    }

  }