view: dt_outstanding_bal_opening_bal {
  derived_table: {
    sql: with opening_bal as(
select vendor_id,
opening_balance,
period_id,
from ROYALTY_ACCOUNTING.PROD.VW_WORKSTATION_SUMMARY_UNIFIED where period_id= {% parameter filter_lower_period_id %}
),

outstanding_bal as(
select vendor_id,
outstanding_balance,
period_id,
from ROYALTY_ACCOUNTING.PROD.VW_WORKSTATION_SUMMARY_UNIFIED where period_id= {% parameter filter_upper_period_id %}
),

final as(
select
opening_bal.vendor_id,
opening_bal.opening_balance,
outstanding_bal.outstanding_balance
from opening_bal left join outstanding_bal on outstanding_bal.vendor_id=opening_bal.vendor_id
)
select * from final;;
}

  parameter: filter_lower_period_id {
    type: string
    label: "From Period ID"
    view_label: "Filter Fields (Use only with fields from Balances section)"
  }

  parameter: filter_upper_period_id {
    type: string
    label: "To Period ID"
    view_label: "Filter Fields (Use only with fields from Balances section)"
  }

  dimension: labelid {
    label: "Label ID"
    type: string
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  dimension: period_id {
    label: "Period ID"
    type: string
    sql: ${TABLE}.period_id ;;
    hidden: yes
  }

  dimension: outstanding_balance {
    label: "Outstanding Balance"
    type: number
    sql: ${TABLE}.outstanding_balance ;;
    view_label: "Balances (Use only with filter fields)"
  }

  dimension: opening_balance {
    label: "Opening Balance"
    type: number
    sql: ${TABLE}.opening_balance ;;
    view_label: "Balances (Use only with filter fields)"
  }
}