view: fact_sales {

  sql_table_name: royalty_accounting.prod.workstation_fact_sales_unified_dbt ;;

#   ACCOUNTINGMONTH
#   ACCOUNTINGPERIODID
#   ACCOUNTINGQUARTER
#   ACCOUNTINGYEAR
#   ACTIVITY_FX_RATE
#   ACTIVITYMONTH
#   ACTIVITYPERIODID
#   ACTIVITYQUARTER
#   ACTIVITYYEAR
#   ACTUAL_NET
#   ADJUSTED_GROSS
#   ARTISTID

  dimension: ACCOUNTINGMONTH {
    sql: ${TABLE}.accountingmonth ;;
  }

  dimension: accountingperiodid {
    sql: ${TABLE}.ACCOUNTINGPERIODID ;;
  }

  dimension: accountingquarter {
    sql: ${TABLE}.ACCOUNTINGQUARTER ;;
  }

  dimension: accountingyear {
    sql: ${TABLE}.ACCOUNTINGYEAR ;;
  }

  dimension: activity_fx_rate {
    sql: ${TABLE}.ACTIVITY_FX_RATE ;;
  }

  dimension: activitymonth {
    sql: ${TABLE}.ACTIVITYMONTH ;;
  }

  dimension: activityperiodid {
    sql: ${TABLE}.ACTIVITYPERIODID ;;
  }

  dimension: activityquarter {
    sql: ${TABLE}.ACTIVITYQUARTER ;;
  }

  dimension: activityyear {
    sql: ${TABLE}.ACTIVITYYEAR ;;
  }

  dimension: actual_net {
    sql: ${TABLE}.ACTUAL_NET ;;
  }


  dimension: adjusted_gross {
    sql: ${TABLE}.ADJUSTED_GROSS ;;
  }

  dimension: artistid {
    sql: ${TABLE}.ARTISTID ;;
  }

  #   CATALOGID
  #   Butt_PUBLISHING
  #   COUNTRYID
  #   DATECREATED
  #   DISCOUNT
  #   DISTRIBUTION_FEES
  #   DPD_PUBLISHING


  dimension: catalogid {
    sql: ${TABLE}.CATALOGID ;;
  }

  dimension: cloud_publishing {
    sql: ${TABLE}.CLOUD_PUBLISHING ;;
  }

  dimension: countryid {
    sql: ${TABLE}.COUNTRYID ;;
  }

  dimension: datecreated {
    sql: ${TABLE}.DATECREATED ;;
  }

  dimension: discount {
    sql: ${TABLE}.DISCOUNT ;;
  }

  dimension: distribution_fees {
    sql: ${TABLE}.DISTRIBUTION_FEES ;;
  }

  dimension: dpd_publishing {
    sql: ${TABLE}.DPD_PUBLISHING ;;
  }

  #   FX_ACTUAL_NET
  #   FX_ADJUSTED_EXCHANGE_RATE
  #   FX_ADJUSTED_GROSS
  #   FX_Butt_PUBLISHING
  #   FX_DISTRIBUTION_FEES
  #   FX_DPD_PUBLISHING
  #   FX_GROSS
  #   FX_NET_RECEIPT
  #   FX_OMS_FEES
  #   FX_RINGTONE_PUBLISHING
  #   FX_SPREAD_FEE
  #   GENREID
  #   GROSS
  #   IMPRINTID


  dimension: fx_actual_net {
    sql: ${TABLE}.FX_ACTUAL_NET ;;
  }

  dimension: fx_adjusted_exchange_rate {
    sql: ${TABLE}.FX_ADJUSTED_EXCHANGE_RATE ;;
  }

  dimension: fx_adjusted_gross {
    sql: ${TABLE}.FX_ADJUSTED_GROSS ;;
  }

  dimension: fx_cloud_publishing {
    sql: ${TABLE}.FX_CLOUD_PUBLISHING ;;
  }

  dimension: fx_distribution_fees {
    sql: ${TABLE}.FX_DISTRIBUTION_FEES ;;
  }

  dimension: fx_dpd_publishing {
    sql: ${TABLE}.FX_DPD_PUBLISHING ;;
  }

  dimension: fx_gross {
    sql: ${TABLE}.FX_GROSS ;;
  }

  dimension: fx_net_receipt {
    sql: ${TABLE}.FX_NET_RECEIPT ;;
  }

  dimension: fx_oms_fees {
    sql: ${TABLE}.FX_OMS_FEES ;;
  }

  dimension: fx_ringtone_publishing {
    sql: ${TABLE}.FX_RINGTONE_PUBLISHING ;;
  }

  dimension: fx_spread_fee {
    sql: ${TABLE}.FX_SPREAD_FEE ;;
  }

  dimension: genreid {
    sql: ${TABLE}.GENREID ;;
  }

  dimension: version {
    sql: ${TABLE}.GROSS ;;
  }

  dimension: imprintid {
    sql: ${TABLE}.IMPRINTID ;;
  }

   #   ISRCID
  #   LABELID
  #   NET_RECEIPT
  #   OMS_FEES
  #   ORIGINAL_CURRENCY_ID
  #   ORIGINAL_PRICE
  #   PARTNER_SHARE
  #   PAYOUT_CURRENCY_ID
  #   RELEASEID
  #   RETAIL_PRICE
  #   RINGTONE_PUBLISHING
  #   SALES
  #   STATEMENT_DETAIL_ID
  #   STOREID
  #   SUBACCOUNTID
  #   TRACKID
  #   TRANSACTIONTYPEID

  dimension: isrcid {
    sql: ${TABLE}.ISRCID ;;
  }

  dimension: labelid {
    sql: ${TABLE}.LABELID ;;
  }

  dimension: net_receipt {
    sql: ${TABLE}.NET_RECEIPT ;;
  }

  dimension: upc {
    sql: ${TABLE}.OMS_FEES ;;
  }

  dimension: vendor_track_identifier {
    sql: ${TABLE}.ORIGINAL_CURRENCY_ID ;;
  }

  dimension: original_price {
    sql: ${TABLE}.ORIGINAL_PRICE ;;
  }

  dimension: partner_share {
    sql: ${TABLE}.PARTNER_SHARE ;;
  }

  dimension: payout_currency_id {
    sql: ${TABLE}.PAYOUT_CURRENCY_ID ;;
  }

  dimension: releaseid {
    sql: ${TABLE}.RELEASEID ;;
  }

  dimension: retail_price {
    sql: ${TABLE}.RETAIL_PRICE ;;
  }

  dimension: ringtone_publishing {
    sql: ${TABLE}.RINGTONE_PUBLISHING ;;
  }

  dimension: sales {
    sql: ${TABLE}.SALES ;;
  }

  dimension: statement_detail_id {
    primary_key: yes
    sql: ${TABLE}.STATEMENT_DETAIL_ID ;;
  }

  dimension: storeid {
    sql: ${TABLE}.STOREID ;;
  }

  dimension: subaccountid {
    sql: ${TABLE}.SUBACCOUNTID ;;
  }

  dimension: trackid {
    sql: ${TABLE}.TRACKID ;;
  }

  dimension: transactiontypeid {
    sql: ${TABLE}.TRANSACTIONTYPEID ;;
  }

  measure: track_count {
    type: count
    drill_fields: []
  }

  measure: statement_count {
    type: count_distinct
    sql: ${statement_detail_id} ;;
  }
}

  # # You can specify the table name if it's different from the view name:
  # sql_table_name: my_schema_name.tester ;;
  #
  # # Define your dimensions and measures here, like this:
  # dimension: user_id {
  #   description: "Unique ID for each user that has ordered"
  #   type: number
  #   sql: ${TABLE}.user_id ;;
  # }
  #
  # dimension: lifetime_orders {
  #   description: "The total number of orders for each user"
  #   type: number
  #   sql: ${TABLE}.lifetime_orders ;;
  # }
  #
  # dimension_group: most_recent_purchase {
  #   description: "The date when each user last ordered"
  #   type: time
  #   timeframes: [date, week, month, year]
  #   sql: ${TABLE}.most_recent_purchase_at ;;
  # }
  #
  # measure: total_lifetime_orders {
  #   description: "Use this for counting lifetime orders across many users"
  #   type: sum
  #   sql: ${lifetime_orders} ;;
  # }
#}

# view: fact_sales {
#   # Or, you could make this view a derived table, like this:
#   derived_table: {
#     sql: SELECT
#         user_id as user_id
#         , COUNT(*) as lifetime_orders
#         , MAX(orders.created_at) as most_recent_purchase_at
#       FROM orders
#       GROUP BY user_id
#       ;;
#   }
#
#   # Define your dimensions and measures here, like this:
#   dimension: user_id {
#     description: "Unique ID for each user that has ordered"
#     type: number
#     sql: ${TABLE}.user_id ;;
#   }
#
#   dimension: lifetime_orders {
#     description: "The total number of orders for each user"
#     type: number
#     sql: ${TABLE}.lifetime_orders ;;
#   }
#
#   dimension_group: most_recent_purchase {
#     description: "The date when each user last ordered"
#     type: time
#     timeframes: [date, week, month, year]
#     sql: ${TABLE}.most_recent_purchase_at ;;
#   }
#
#   measure: total_lifetime_orders {
#     description: "Use this for counting lifetime orders across many users"
#     type: sum
#     sql: ${lifetime_orders} ;;
#   }
# }