view: royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period{
  sql_table_name:ROYALTY_ACCOUNTING_REPORTING.PROD.VW_ABACUS_UNALLOCATED_SALES_NR_STATEMENT_PERIOD;;


  dimension: STATEMENT_PERIOD_ID{
    view_label: "Unallocated Sales"
    label:"STATEMENT PERIOD ID"
    type: number
    hidden: yes
    sql:${TABLE}.STATEMENT_PERIOD_ID;;
  }
  dimension: UNIQUE_DETAIL_ID{
    view_label: "Stmt DB (SH)"
    label:"UNIQUE DETAIL ID"
    type: number
    sql:${TABLE}.UNIQUE_DETAIL_ID;;
  }
  dimension: SALES_FILES_BATCH_ID_LIST{
    view_label: "Unallocated Sales Files / Batch Ids"
    label:"SALES FILES BATCH ID (List)"
    type: string
    sql:${TABLE}.SALES_FILES_BATCH_ID_LIST;;
  }
  dimension: ACCOUNTING_PERIOD_LIST{
    view_label: "Unallocated Sales Periods"
    label:"ACCOUNTING PERIOD Ids (List)"
    type: string
    sql:${TABLE}.ACCOUNTING_PERIOD_LIST;;
  }
  dimension: NEW_UNALLOCATION{
    view_label: "Unallocated Sales"
    label:"NEW UNALLOCATION"
    type: yesno
    sql:${TABLE}.NEW_UNALLOCATION;;
  }
  dimension: EARLIEST_STMT_DB_SALES_NR_TXN_ID{
    view_label: "Stmt DB (SH)"
    label:"EARLIEST STMT DB SALES NR TXN ID"
    type: number
    sql:${TABLE}.EARLIEST_STMT_DB_SALES_NR_TXN_ID;;
  }
  dimension: EARLIEST_SALES_FILE_ID{
    view_label: "Earliest Sales File"
    label:"EARLIEST SALES FILE ID"
    type: number
    sql:${TABLE}.EARLIEST_SALES_FILE_ID;;
  }
  dimension: EARLIEST_BATCH_ID{
    view_label: "Stmt DB (SH)"
    label:"EARLIEST BATCH ID"
    type: string
    sql:${TABLE}.EARLIEST_BATCH_ID;;
  }
  dimension: STATEMENT_ID{
    view_label: "Stmt DB (SH)"
    label:"STATEMENT ID"
    type: number
    sql:${TABLE}.STATEMENT_ID;;
  }
  dimension_group: START_DATE{
    hidden:  yes
    view_label: "Unallocated Sales"
    label:"Start"
    type: time
    sql:${TABLE}.START_DATE;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: TRANSACTION_DATE{
    view_label: "Transaction Date"
    label:"Transaction"
    type: time
    sql:${TABLE}.TRANSACTION_DATE;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: STORE_ID{
    view_label: "Store"
    label:"STORE ID"
    type: number
    sql:${TABLE}.STORE_ID;;
  }
  dimension: SUBDISTRIBUTOR{
    view_label: "Stmt DB (SH)"
    label:"SUBDISTRIBUTOR"
    type: string
    sql:${TABLE}.SUBDISTRIBUTOR;;
  }
  dimension: SALE_CURRENCY_CODE{
    view_label: "Unallocated Sales"
    label:"SALE CURRENCY CODE"
    type: string
    sql:${TABLE}.SALE_CURRENCY_CODE;;
  }
  dimension: SALE_CURRENCY_CODE_ID{
    view_label: "Unallocated Sales"
    label:"SALE CURRENCY CODE ID"
    type: number
    sql:${TABLE}.SALE_CURRENCY_CODE_ID;;
  }
  dimension: SALE_ACTIVITY_RATE{
    view_label: "Stmt DB (SH)"
    label:"SH Exchange Rate"
    type: number
    sql:${TABLE}.SALE_ACTIVITY_RATE;;
  }
  dimension: COUNTRY_ID{
    view_label: "Country"
    label:"COUNTRY ID"
    type: number
    sql:${TABLE}.COUNTRY_ID;;
  }
  dimension: TRANSACTION_TYPE{
    view_label: "Transaction Type"
    label:"TRANSACTION TYPE"
    type: string
    sql:${TABLE}.TRANSACTION_TYPE;;
  }
  dimension: TRANSACTION_TYPE_ID{
    view_label: "Transaction Type"
    label:"TRANSACTION TYPE ID"
    type: number
    sql:${TABLE}.TRANSACTION_TYPE_ID;;
  }
  dimension: TRANSACTION_SUBTYPE_ID{
    view_label: "Transaction Type"
    label:"TRANSACTION SUBTYPE ID"
    type: number
    sql:${TABLE}.TRANSACTION_SUBTYPE_ID;;
  }

  dimension: ISRC{
    view_label: "Track"
    label:"ISRC"
    type: string
    hidden: yes
    sql:${TABLE}.ISRC;;
  }
  measure: QUANTITY{
    view_label: "Unallocated Sales"
    label:"QUANTITY"
    type: sum
    sql:${TABLE}.QUANTITY;;
  }
  dimension: UNIT_PRICE_USD{
    view_label: "Stmt DB (SH)"
    label:"SH Unit Price USD"
    type: number
    sql:${TABLE}.UNIT_PRICE_USD;;
  }

  measure: GROSS_REVENUE_USD{
    view_label: "Unallocated Sales"
    label:"GROSS REVENUE(USD)"
    type: sum
    sql:${TABLE}.GROSS_REVENUE_USD;;
  }

  measure: WITHHOLDING_TAX_USD{
    view_label: "Unallocated Sales"
    label:"WITHHOLDING TAX(USD)"
    type: sum
    sql:${TABLE}.WITHHOLDING_TAX_USD;;
  }
}