##To be deprecated as this has been moved to abacus_looker project space

view: int_dbt_prod_abacus_fact_sales {
  sql_table_name:  INTELLIGENCE.DBT_PROD.ABACUS_FACT_SALES;;

  dimension: txn_id {
    view_label: "Accounting"
    type: number
    sql: ${TABLE}.txn_id ;;
    primary_key: yes
  }

  dimension: statement_id {
    view_label: "Accounting"
    type: number
    sql: ${TABLE}.statement_id ;;
  }

  dimension: account_id {
    view_label: "Accounting"
    type: number
    sql: ${TABLE}.account_id ;;
  }

  dimension: account_payee_currency {
    view_label: "Accounting"
    label: "Account Payee Currency Code"
    type: string
    sql: ${TABLE}.account_payee_currency ;;
  }

  dimension: sale_currency_code {
    view_label: "Accounting"
    label: "Sale Currency Code"
    type: string
    sql: ${TABLE}.sale_currency_Code ;;
  }

  dimension: accounting_period_id {
    view_label: "Date"
    type: number
    sql: ${TABLE}.accounting_period_id ;;
  }

  dimension: country_id {
    type: number
    sql: ${TABLE}.country_id ;;
    hidden: yes
  }

  dimension: store_id {
    type: number
    sql: ${TABLE}.store_id ;;
    hidden: yes
  }


  dimension: isrc {
    type: string
    sql: ${TABLE}.isrc;;
    hidden: yes
  }

  dimension: upc {
    type: number
    sql: ${TABLE}.upc ;;
    hidden: yes
  }

  dimension: transaction_date {
    view_label: "Date"
    type: date
    sql: ${TABLE}.transaction_date ;;
  }

  dimension: accounting_run_id {
    view_label: "Accounting"
    type: number
    sql: ${TABLE}.accounting_run_id ;;
  }

  dimension: accounting_run_name {
    view_label: "Accounting"
    type: string
    sql: ${TABLE}.accounting_run_name ;;
  }

  dimension: royalty_rate {
    view_label: "Accounting"
    type: number
    sql: ${TABLE}.royalty_rate ;;
    value_format: "#,##0.00"
  }

  measure: mechanical_fee_sale_currency {
    type: sum
    sql: ${TABLE}.mechanical_fee_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: ringtone_fee_sale_currency {
    type: sum
    sql: ${TABLE}.ringtone_fee_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: publishing_fee_sale_currency {
    type: sum
    sql: ${TABLE}.publishing_fee_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: publishing_fee_payee_currency {
    type: sum
    sql: ${TABLE}.publishing_fee_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: unit_price_sale_currency {
    type: sum
    sql: ${TABLE}.unit_price_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: gross_revenue_sale_currency {
    type: sum
    sql: ${TABLE}.gross_revenue_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: admin_fee_sale_currency {
    type: sum
    sql: ${TABLE}.admin_fee_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: adjusted_gross_sale_currency {
    type: sum
    sql: ${TABLE}.adjusted_gross_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: net_share_sale_currency {
    type: sum
    sql: ${TABLE}.net_share_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: adjusted_net_sale_currency {
    type: sum
    sql: ${TABLE}.adjusted_net_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: readjusted_net_sale_currency {
    type: sum
    sql: ${TABLE}.readjusted_net_sale_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: unit_price_payee_currency {
    type: sum
    sql: ${TABLE}.unit_price_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: gross_revenue_payee_currency {
    type: sum
    sql: ${TABLE}.gross_revenue_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: adjusted_gross_payee_currency {
    type: sum
    sql: ${TABLE}.adjusted_gross_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: net_share_payee_currency {
    type: sum
    sql: ${TABLE}.net_share_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: adjusted_net_payee_currency {
    type: sum
    sql: ${TABLE}.adjusted_net_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

  measure: readjusted_net_payee_currency {
    type: sum
    sql: ${TABLE}.readjusted_net_payee_currency ;;
    view_label: "Accounting"
    value_format: "#,##0.00"
  }

}