view: dt_vendor_outstanding_balance {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_VENDOR_OUTSTANDING_BALANCE ;;
  # derived_table: {
  #   sql:
  #   select vendor_id, amount, period_id
  #   from ROYALTY_ACCOUNTING.PROD.VW_ABACUS_VENDOR_ACCOUNTING
  #   where entry_type = 'balance_forward' ;;
  # }

  dimension: vendor_id {
    type: number
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  dimension: period_id {
    type: number
    sql: ${TABLE}.period_id ;;
    hidden: yes
  }

  dimension: amount {
    label: "Outstanding Balance"
    type: number
    sql: ${TABLE}.amount ;;
    value_format: "$#,##0.00"
  }
}