view: sony_internal_abacus_settlement_feed_history {
  sql_table_name: SONY_INTERNAL.PROD.ABACUS_SETTLEMENT_FEED_HISTORY ;;

  dimension: group_name {
    type: string
    sql: ${TABLE}.group_name ;;
  }

  dimension: group_indicator {
    type: string
    sql: ${TABLE}.group_indicator ;;
  }

  dimension: flow_type {
    type: string
    sql: ${TABLE}.flow_type ;;
  }

  dimension: trading_partner {
    type: string
    sql: ${TABLE}.trading_partner ;;
  }

  dimension: settlement_feed_include {
    type: string
    sql: ${TABLE}.settlement_feed_include ;;
  }

  dimension: settlement_transaction_type {
    type: string
    sql: ${TABLE}.settlement_transaction_type ;;
  }

  dimension: transaction_currency_key {
    type: string
    sql: ${TABLE}.transaction_currency_key ;;
  }

  dimension: transaction_quantity {
    type: number
    sql: ${TABLE}.transaction_quantity ;;
  }

  dimension: transaction_row_count {
    type: string
    sql: ${TABLE}.transaction_row_count ;;
  }

  dimension: batch_no {
    type: number
    sql: ${TABLE}.batch_no ;;
  }

  dimension: amount {
    type: number
    sql: ${TABLE}.amount ;;
  }

  dimension: gras_prod_no {
    type: string
    sql: ${TABLE}.gras_prod_no ;;
  }

  dimension: gras_project {
    type: string
    sql: ${TABLE}.gras_project ;;
  }

  dimension: contract_id {
    type: number
    sql: ${TABLE}.contract_id ;;
  }

  dimension: file_name {
    type: string
    sql: ${TABLE}.file_name ;;
  }

  dimension: body_content {
    type: string
    sql: ${TABLE}.body_content ;;
  }

  dimension: business_group {
    type: string
    sql: ${TABLE}.business_group ;;
  }

  dimension: company_code {
    type: string
    sql: ${TABLE}.company_code ;;
  }

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

  dimension: accounting_perod_id {
    type: number
    sql: ${TABLE}.accountingperiodid ;;
  }

  dimension: statement_period_id {
    type: number
    sql: ${TABLE}.statement_period_id ;;
  }

  dimension: tax_amount {
    type: number
    sql: ${TABLE}.tax_amount ;;
  }

  dimension: tax_base_amount {
    type: number
    sql: ${TABLE}.tax_base_amount ;;
  }

  dimension: tax_code {
    type: string
    sql: ${TABLE}.tax_code ;;
  }

  dimension: record_type {
    type: string
    sql: ${TABLE}.record_type ;;
  }

  dimension: list_abacus_sale_type {
    type: string
    sql: ${TABLE}.list_abacus_sale_type ;;
  }

  dimension: actual_statement_number {
    type: string
    sql: ${TABLE}.actual_statement_number ;;
  }

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

  dimension: list_batch_id {
    type: string
    sql: ${TABLE}.list_batch_id ;;
  }

  dimension: list_current_batch_id {
    type: string
    sql: ${TABLE}.list_current_batch_id ;;
  }

  dimension: list_input_country_code {
    type: string
    sql: ${TABLE}.list_input_country_code ;;
  }

  dimension: list_input_transaction_type {
    type: string
    sql: ${TABLE}.list_input_transaction_type ;;
  }

  dimension: list_is_excluded_from_sap {
    type: string
    sql: ${TABLE}.list_is_excluded_from_sap ;;
  }

  dimension: list_label_id {
    type: string
    sql: ${TABLE}.list_label_id ;;
  }

  dimension: list_new_indicator {
    type: string
    sql: ${TABLE}.list_new_indicator ;;
  }

  dimension: list_label_owner {
    type: string
    sql: ${TABLE}.list_label_owner ;;
  }

  dimension: record_source {
    type: string
    sql: ${TABLE}.record_source ;;
  }

  dimension: list_reference_sap_profit_center_id {
    type: string
    sql: ${TABLE}.list_reference_sap_profit_center_id ;;
  }

  dimension: reference_detailed_text {
    type: string
    sql: ${TABLE}.reference_detailed_text ;;
  }

  dimension: profit_center {
    type: string
    sql: ${TABLE}.profit_center ;;
  }

  dimension: list_settlement_sap_exclude_indicator {
    type: number
    sql: ${TABLE}.list_settlement_sap_exclude_indicator ;;
  }

  dimension: list_signing_entity_legal_name {
    type: string
    sql: ${TABLE}.list_signing_entity_legal_name ;;
  }

  dimension: list_store_id {
    type: string
    sql: ${TABLE}.list_store_id ;;
  }

  dimension: list_transaction_no_id {
    type: string
    sql: ${TABLE}.list_transaction_no_id ;;
  }

  dimension: list_unique_detail_id {
    type: string
    sql: ${TABLE}.list_unique_detail_id ;;
  }

  dimension: unique_detail_count {
    type: number
    sql: ${TABLE}.unique_detail_count ;;
  }

  dimension: local_currency_code {
    type: string
    sql: ${TABLE}.local_currency_code ;;
  }

  dimension: country_key {
    type: string
    sql: ${TABLE}.country_key ;;
  }

  dimension: country_of_sales {
    type: string
    sql: ${TABLE}.country_of_sales ;;
  }

  dimension: posting_type {
    type: string
    sql: ${TABLE}.posting_type ;;
  }

  dimension: distribution_fee_calculated_local_currency_amount {
    type: number
    sql: ${TABLE}.distribution_fee_calculated_local_currency_amount ;;
  }

  dimension: gross_revenue_calculated_local_currency_amount {
    type: number
    sql: ${TABLE}.gross_revenue_calculated_local_currency_amount ;;
  }

  dimension: gross_revenue_calculated_usd_amount {
    type: number
    sql: ${TABLE}.gross_revenue_calculated_usd_amount ;;
  }

  dimension: gross_revenue_payee_currency_amount {
    type: number
    sql: ${TABLE}.gross_revenue_payee_currency_amount ;;
  }

  dimension: gross_revenue_sale_currency_amount {
    type: number
    sql: ${TABLE}.gross_revenue_sale_currency_amount ;;
  }

  dimension: gross_revenue_slaughter_house_usd_amount {
    type: number
    sql: ${TABLE}.gross_revenue_slaughter_house_usd_amount ;;
  }

  dimension: distribution_fee_calculated_usd_amount {
    type: number
    sql: ${TABLE}.distribution_fee_calculated_usd_amount ;;
  }

  dimension: distribution_fee_payee_currency_amount {
    type: number
    sql: ${TABLE}.distribution_fee_payee_currency_amount ;;
  }

  dimension: distribution_fee_sale_currency_amount {
    type: number
    sql: ${TABLE}.distribution_fee_sale_currency_amount ;;
  }

  dimension_group: sales_reporting_from {
    type: time
    timeframes: [time, date, week, month, month_name, day_of_week, day_of_year, week_of_year, year]
    sql: ${TABLE}.sales_reporting_from ;;
    convert_tz: no
  }

  dimension_group: sales_reporting_to {
    type: time
    timeframes: [time, date, week, month, month_name, day_of_week, day_of_year, week_of_year, year]
    sql: ${TABLE}.sales_reporting_to ;;
    convert_tz: no
  }

  dimension: owner_share_calculated_local_currency_amount {
    type: number
    sql: ${TABLE}.owner_share_calculated_local_currency_amount ;;
  }

  dimension: owner_share_calculated_usd_amount {
    type: number
    sql: ${TABLE}.owner_share_calculated_usd_amount ;;
  }

  dimension: owner_share_payee_currency_amount {
    type: number
    sql: ${TABLE}.owner_share_payee_currency_amount ;;
  }

  dimension: owner_share_sale_currency_amount {
    type: number
    sql: ${TABLE}.owner_share_sale_currency_amount ;;
  }

  dimension: exchange_rate {
    type: number
    sql: ${TABLE}.exchange_rate ;;
  }

  dimension: t_code {
    type: string
    sql: ${TABLE}.t_code ;;
  }

  dimension: account_owner {
    type: string
    sql: ${TABLE}.account_owner ;;
  }

  dimension: ownership {
    type: string
    sql: ${TABLE}.ownership ;;
  }

  dimension: gross_net {
    type: string
    label: "Gross vs Net"
    sql: ${TABLE}.gross_net ;;
  }

  }