view: int_dbt_prod_track_level_accounting {
  sql_table_name: INTELLIGENCE.DBT_PROD.TRACK_LEVEL_ACCOUNTING_V1 ;;


  dimension_group: accounting_date {
    view_label: "Date"
    label: "Accounting"
    type: time
    sql: ${TABLE}.accounting_date ;;
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

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

  dimension: upc {
    view_label: "Release"
    label: "UPC"
    type: string
    sql: ${TABLE}.upc ;;
  }

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

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

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

  dimension: label_id {
    view_label: "Label"
    label: "Label ID"
    type: number
    sql: ${TABLE}.label_id ;;
    value_format: "0"
  }

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

  dimension: track_artists {
    view_label: "Track"
    label: "Track Artists"
    type: string
    sql: ${TABLE}.track_artists ;;
  }

  dimension: track_language {
    view_label: "Track"
    label: "Track Language"
    type: string
    sql: ${TABLE}.track_language ;;
  }

  dimension: store_name {
    view_label: "Store"
    label: "Store Name"
    type: string
    sql: ${TABLE}.store_name ;;
  }

  dimension: country_name {
    view_label: "Transaction Country"
    label: "Country Name"
    type: string
    sql: ${TABLE}.country_name ;;
  }

  dimension: transaction_group {
    view_label: "Transaction Type"
    label: "Transaction Group"
    type: string
    sql: ${TABLE}.transaction_group ;;
  }

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

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

  measure: units {
    view_label: "Accounting"
    label: "Units"
    type: sum
    sql: ${TABLE}.units;;
    value_format: "#,##0"
  }

  }