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

include: "/views/royalty_accounting_prod_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"
include: "/views/royalty_accounting_qa_vw_dim_abacus_account.view.lkml"
include: "/views/orch_app_qa_royalty_accounting_contract_reserve.view.lkml"
include: "/views/royalty_accounting_qa_vw_dim_abacus_contract.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_prod.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_qa.view.lkml"
include: "/views/orch_app_qa_royalty_accounting_worksheet_payment_custom.view.lkml"
include: "/views/orch_app_prod_royalty_accounting_worksheet_payment_custom.view.lkml"


fiscal_month_offset: -9



explore: orch_app_prod_royalty_accounting_worksheet_payment_custom {
  label: "TAP Custom Payments [PROD]"
  view_label: "TAP Custom Payments [PROD]"
  case_sensitive: no
  hidden: yes
  sql_always_where: ${orch_app_prod_royalty_accounting_worksheet_payment_custom.deleted_at} is NULL and ${orch_app_prod_royalty_accounting_worksheet_payment_custom.deleted_by} is NULL ;;

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

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

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${orch_app_prod_royalty_accounting_worksheet_payment_custom.account_id}= ${royalty_accounting_prod_vw_dim_abacus_account.account_id};;
  }

}


explore: orch_app_qa_royalty_accounting_worksheet_payment_custom {
  label: "TAP Custom Payments [QA]"
  view_label: "TAP Custom Payments [QA]"
  case_sensitive: no
  hidden: yes
  sql_always_where: ${orch_app_qa_royalty_accounting_worksheet_payment_custom.deleted_at} is NULL and ${orch_app_qa_royalty_accounting_worksheet_payment_custom.deleted_by} is NULL ;;

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

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

  join: orch_app_qa_royalty_accounting_contract_reserve {
    view_label: "ABACUS Contract Reserve"
    relationship: many_to_one
    sql_on: ${orch_app_qa_royalty_accounting_contract_reserve.contract_id}= ${orch_app_qa_royalty_accounting_worksheet_payment_custom.contract_id};;
  }


  join: royalty_accounting_qa_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${orch_app_qa_royalty_accounting_worksheet_payment_custom.account_id}= ${royalty_accounting_qa_vw_dim_abacus_account.account_id};;
  }

}