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

include: "/views/dt_terms_of_track_exceptions.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_run_controller.view.lkml"
include: "/views/facts_prod_dim_release.view.lkml"
include: "/views/facts_prod_dim_country.view.lkml"
include: "/views/facts_prod_dim_store.view.lkml"
include: "/views/facts_prod_dim_transactiontype.view.lkml"
include: "/views/facts_prod_dim_track_clean_mv.view.lkml"
include: "/views/facts_prod_dim_label.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_contract_term.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_contract_term_condition.view.lkml"
include: "/views/facts_prod_identity.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_prod.view.lkml"

fiscal_month_offset: -9

explore: dt_terms_of_track_exceptions {
  label: "Terms of Track Exceptions"
  view_label: "Terms of Track Exceptions"
  case_sensitive: no
  hidden: yes

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

  join: royalty_accounting_prod_vw_dim_abacus_contract {
    view_label: "Abacus Contract"
    relationship: many_to_one
    sql_on: ${dt_terms_of_track_exceptions.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}= ${royalty_accounting_prod_vw_dim_abacus_contract.contract_id};;
  }

  join: orch_app_ar_royalty_accounting_contract_term {
    view_label: "Contract Term"
    relationship: many_to_one
    sql_on: ${dt_terms_of_track_exceptions.contract_term_id}= ${orch_app_ar_royalty_accounting_contract_term.contract_term_id};;
    fields: [is_base_term ]
  }

}