view: int_dbt_prod_qa_abacus_expenses {
  sql_table_name: intelligence.dbt_prod.qa_abacus_expenses ;;

  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: expense_item_id {
    type: number
    value_format: "0"
    sql: ${TABLE}.expense_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 ;;
  }

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

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

  dimension: adjustment_amount{
    type: number
    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 ;;
  }

  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}.note ;;
  }

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

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

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

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

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

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