view: int_dbt_prod_ifpi_country_label_level_accounting {
  sql_table_name: INTELLIGENCE.DBT_PROD.IFPI_COUNTRY_LABEL_LEVEL_ACCOUNTING ;;

  dimension_group: accounting_month {
    view_label: "Date"
    label: "Accounting"
    description: "Month & Year based on Accounting Date - when the transaction was processed by Finance. Use this when doing financial reporting"
    #alias: [accounting_month]
    timeframes: [
      date,
      year,
      month,
      month_num,
      quarter,
      month_name,
      quarter_of_year,
      week_of_year,
      fiscal_year,
      fiscal_quarter,
      fiscal_month_num,
      fiscal_quarter_of_year
    ]
    sql: ${TABLE}.accounting_month_month ;;
    type: time
  }

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

  dimension: main_portuguese_labels_or_other_sort {
    view_label: "Main Portuguse Labels or Other"
    label: "Main Portuguse Labels or Other sort"
    type: string
    sql: ${TABLE}.MAIN_PORTUGUESE_LABELS_OR_OTHER__SORT ;;
  }

  dimension: main_portuguese_labels_or_other {
    view_label: "Main Portuguse Labels or Other"
    label: "Main Portuguse Labels or Other"
    type: string
    sql: ${TABLE}.MAIN_PORTUGUESE_LABELS_OR_OTHER ;;
  }

  dimension: label_is_som_livre_sort {
    view_label: "Label is Som Livre"
    label: "Label is Som Livre sort"
    type: string
    sql: ${TABLE}.LABEL_IS_SOM_LIVRE__SORT ;;
  }

  dimension: label_is_som_livre {
    view_label: "Label is Som Livre"
    label: "Label is Som Livre"
    type: string
    sql: ${TABLE}.LABEL_IS_SOM_LIVRE ;;
  }

  dimension: store_id {
    view_label: "Store"
    label: "Store ID"
    type: number
    sql: ${TABLE}.store_id ;;
  }

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

  measure: gross_revenue_usd {
    view_label: "Sales USD"
    label: "Gross Revenue USD"
    description: ""
    #alias: [gross]
    sql: ${TABLE}.gross_revenue_usd ;;
    type: sum
    #value_format_name: decimal_4
    value_format: "$#,##0.00"
  }


  }