label: "ABACUS"
connection: "abacus-looker"

include: "/views/int_dbt_prod_monthly_comparison_report.view.lkml"
include: "/views/int_dbt_prod_monthly_comparison_report_prod.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_prod.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_payment_hold.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"



explore: int_dbt_prod_monthly_comparison_report {
  label: "Monthly Comparison Report"
  case_sensitive: no
  hidden: yes

  join: dt_abacus_contract_lifecycle_prod {
    view_label: "ABACUS Contract Lifecycle"
    relationship: many_to_one
    sql_on: ${dt_abacus_contract_lifecycle_prod.contract_id}= ${int_dbt_prod_monthly_comparison_report.contract_id};;
  }
}

explore: int_dbt_prod_monthly_comparison_report_prod {
  label: "Monthly Comparison Report (Closing balance)"
  case_sensitive: no
  hidden: yes

  join: dt_abacus_contract_lifecycle_prod {
    view_label: "ABACUS Contract Lifecycle"
    relationship: many_to_one
    sql_on: ${dt_abacus_contract_lifecycle_prod.contract_id}= ${int_dbt_prod_monthly_comparison_report_prod.contract_id};;
  }

  join: orch_app_ar_royalty_accounting_payment_hold {
    view_label: "Payment Hold"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_monthly_comparison_report_prod.account_id}= ${orch_app_ar_royalty_accounting_payment_hold.account_id};;
  }

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_monthly_comparison_report_prod.account_id}= ${royalty_accounting_prod_vw_dim_abacus_account.account_id};;
    fields: [payment_schedule,paid_by]
  }
}