view: int_dbt_prod_abacus_adjustments {
  sql_table_name: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_ADJUSTMENTS_v2 ;;

  dimension: batch_id{
    type: number
    value_format: "0"
    sql: ${TABLE}.batch_id ;;
  }

  dimension: adjustment_item_id{
    type: number
    value_format: "0"
    sql: ${TABLE}.adjustment_item_id ;;
  }

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

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

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

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

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

  measure: adjustment_amount{
    type: sum
    value_format: "0.00"
    sql: ${TABLE}.adjustment_amount ;;
  }

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

  dimension: adjustment_type_id{
    type: number
    value_format: "0"
    sql: ${TABLE}.adjustment_type_id ;;
  }

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

  dimension: type_name{
    type: string
    sql: ${TABLE}.type_name ;;
    link: {
      label: "Expense Detail"
      url:"

      {% if _explore._name == 'int_dbt_prod_abacus_adjustments' %}

      https://theorchard.looker.com/dashboards/2219?Adjustment+Item+ID={{int_dbt_prod_abacus_adjustments.adjustment_item_id._value }}

      {% endif %}

      "

    }
  }

  dimension: activity_period{
    type: number
    value_format: "0"
    sql: ${TABLE}.activity_period ;;
  }

  dimension: statement_period{
    type: number
    value_format: "0"
    sql: ${TABLE}.statement_period ;;
  }

  dimension: note{
    type: string
    sql: ${TABLE}.adjustment_comment ;;
  }

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

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

  measure: adjustment_amount_payee_currency{
    type: sum
    value_format: "0.00"
    sql: ${TABLE}.adjustment_amount_payee_currency ;;
  }

  dimension: adjustment_created_at{
    type: date_time
    sql: ${TABLE}.adjustment_created_at ;;
  }

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

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

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

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

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

  dimension: date_approved{
    view_label: "Adjustments"
    type: string
    sql: ${TABLE}.date_approved ;;
  }

  dimension: date_applied{
    view_label: "Adjustments"
    type: string
    sql: ${TABLE}.date_applied ;;
  }

}