# Data Lineage & Dependencies Generated on: 2026-07-02 19:41:56 This document shows the relationships and dependencies between models, views, and data sources. ## Overview - **Total Models:** 66 - **Total Views:** 209 - **Derived Views:** 77 - **Direct Table Views:** 132 ## Model Dependencies ### Models and Their Views #### Abacus_Replace_Double_book_transact - **Includes:** 1 views - **Views:** - `dt_abacus_replace_double_book_transact` #### abacus-looker - **Includes:** 9 views - **Views:** - `royalty_accounting_uat_vw_dim_abacus_contract` - `royalty_accounting_uat_vw_dim_abacus_account` - `dt_abacus_transaction_level_uat_report` - `orch_app_ar_royalty_accounting_run_controller` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_prod` - `orch_app_prod_royalty_accounting_contract_reserve` - `facts_prod_dim_transactiontype` #### abacus_adjustments - **Includes:** 14 views - **Views:** - `int_dbt_prod_abacus_expenses` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_qa_abacus_expenses` - `royalty_accounting_qa_abacus_adjustments` - `royalty_accounting_prod_abacus_adjustments` - `int_dbt_prod_qa_abacus_adjustments` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_dim_abacus_contract` - `orch_app_ar_royalty_accounting_run_controller` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_vw_dim_abacus_account` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_balance_report - **Includes:** 22 views - **Views:** - `dt_abacus_balance_report` - `dt_abacus_balance_report_prod` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `orch_app_ar_artist_info` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` - `orch_app_ar_country` - `orch_app_ar_vendor_closer` - `orchard_app_ar_vendor` - `orch_app_ar_orchadmin_users` #### abacus_balances - **Includes:** 17 views - **Views:** - `royalty_accounting_qa_vw_abacus_balances_looker` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `orch_app_ar_artist_info` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_balances_staging - **Includes:** 9 views - **Views:** - `royalty_accounting_prod_vw_abacus_balances_staging` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_balances_staging_qa - **Includes:** 9 views - **Views:** - `royalty_accounting_qa_vw_abacus_balances_staging` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_qa_vw_dim_abacus_account` - `royalty_accounting_qa_vw_dim_abacus_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_qa` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_batch_adjustments - **Includes:** 14 views - **Views:** - `dt_abacus_batch_adjustments` - `dt_abacus_batch_adjustments_expenses_prod` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `facts_prod_identity` - `orch_app_ar_royalty_statement_period` - `dt_abacus_batch_adjustments_expenses_qa` - `orch_app_ar_royalty_accounting_run_controller` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` - `dt_abacus_batch_adjustments_expenses_uat` #### abacus_contract - **Includes:** 13 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `orch_app_ar_royalty_accounting_run_controller` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_prod` - `orch_app_prod_royalty_accounting_contract_reserve` - `facts_prod_dim_label` - `facts_prod_dim_country` - `orch_app_ar_vendor_closer` - `orch_app_ar_orchadmin_users` - `/REFERENCE_FLOWTHROUGH_CALCULATION` #### abacus_contract_advance - **Includes:** 9 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `orch_app_ar_royalty_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `orch_app_ar_royalty_accounting_prod_contract_advance` - `orch_app_ar_royalty_accounting_prod_ledger_contract_advance_applied` - `orch_app_ar_royalty_statement_period` - `dt_abacus_contract_lifecycle_prod` #### abacus_contract_denormalized - **Includes:** 14 views - **Views:** - `royalty_accounting_prod_vw_contract_denormalized` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_run_controller` - `facts_prod_dim_release` - `facts_prod_dim_country` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `facts_prod_dim_track_clean_mv` - `facts_prod_dim_label` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_contract_history - **Includes:** 11 views - **Views:** - `royalty_accounting_prod_vw_contract_history` - `royalty_accounting_prod_vw_contract_term_history` - `royalty_accounting_prod_vw_contract_term_condition_history` - `royalty_accounting_qa_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_dev_vw_fact_contract_history` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_qa` #### abacus_contract_history_qa - **Includes:** 1 views - **Views:** - `royalty_accounting_dev_vw_fact_contract_history_qa` #### abacus_contract_lifecycle_prod - **Includes:** 6 views - **Views:** - `dt_abacus_contract_lifecycle_prod` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_dim_abacus_contract` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_prod_vw_dim_abacus_account` #### abacus_contract_lifecycle_qa - **Includes:** 5 views - **Views:** - `dt_abacus_termination_renewal_contract_lifecycle_qa` - `int_dbt_prod_awal_tier_groups` - `royalty_accounting_qa_vw_dim_abacus_contract` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_qa_vw_dim_abacus_account` #### abacus_contract_mech_deduction_history - **Includes:** 4 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_contract_mech_deduction_history` - `dt_abacus_contract_lifecycle_prod` #### abacus_contract_qa - **Includes:** 8 views - **Views:** - `royalty_accounting_qa_vw_dim_abacus_contract` - `royalty_accounting_qa_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `orch_app_ar_royalty_accounting_run_controller` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_qa` - `orch_app_qa_royalty_accounting_contract_reserve` #### abacus_distro_sales - **Includes:** 1 views - **Views:** - `royalty_accounting_prod_stmt_db_sales_distro_staging` #### abacus_double_booked_transactions - **Includes:** 2 views - **Views:** - `dt_contracts_and_accounts_with_double_booking` - `dt_double_booked_transactions` #### abacus_expenses - **Includes:** 8 views - **Views:** - `dt_abacus_expenses_qa` - `int_dbt_prod_awal_tier_groups` - `dt_abacus_expenses_prod` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_dim_abacus_contract` - `orch_app_ar_royalty_accounting_run_controller` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_vw_dim_abacus_account` #### abacus_fact_contract_history - **Includes:** 11 views - **Views:** - `royalty_accounting_prod_vw_contract_history` - `royalty_accounting_prod_vw_contract_term_history` - `royalty_accounting_prod_vw_contract_term_condition_history` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_fact_contract_history` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_fact_sales - **Includes:** 85 views - **Views:** - `vw_abacus_fact_sales_distro` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `orch_app_ar_customer_master_master` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_sales_file` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_project` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `facts_prod_dim_artist` - `int_dbt_prod_track_writers` - `int_dbt_prod_track_artist_by_type` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_contract_term_sax_schedule` - `royalty_accounting_prod_vw_contract_term_sax_right_block` - `orch_app_ar_prod_royalty_accounting_exchange_rate` - `int_dbt_seed_right_type_groupings` - `dt_abacus_track_artists` - `orch_app_ar_royalty_accounting_accounting_run` - `dt_dim_track` - `orch_app_ar_distribution_format` - `orch_app_ar_distribution_format_media` - `orch_app_ar_product_physical` - `dt_abacus_contract_lifecycle_prod` - `orch_app_prod_royalty_accounting_contract_mechanical_deduction` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` - `orch_app_ar_vendor_closer` - `orch_app_ar_orchadmin_users` - `facts_prod_dim_subaccount` - `royalty_accounting_prod_vw_dim_abacus_ar_vendor` - `int_dbt_prod_restrictions_label_store` - `int_dbt_prod_restrictions_label_substore` - `int_dbt_prod_restrictions_label_territory` - `orch_app_ar_genre` - `int_dbt_prod_dt_mechanical_clients` - `int_dbt_prod_dt_label_is_physical` - `int_dbt_prod_dt_perf_rights_territory_label` - `int_dbt_prod_dt_vendor_icon` - `orch_app_ar_project` - `orch_app_ar_language` - `orch_app_ar_track` - `int_dbt_prod_bits_per_sample` - `dt_deleted_releases` - `int_prod_release_delivery_history` - `facts_prod_dim_genre` - `fact_prod_global_participant_represents_label_participant` - `fact_prod_label_participant_participated_in_orchard_product` - `facts_prod_dim_imprint` - `orch_app_ar_product_type` - `int_dbt_prod_restrictions_release_territory` - `int_dbt_prod_restrictions_release_store` - `int_dbt_prod_restrictions_release_substore` - `int_prod_vw_bits_per_sample` - `orch_app_ar_release_subgenre` - `orch_app_ar_subgenre` - `facts_prod_dim_store` - `int_dbt_prod_restrictions_subaccount_substore` - `int_dbt_prod_restrictions_subaccount_store` - `int_dbt_prod_restrictions_subaccount_territory` - `int_dbt_prod_dt_track_artist_by_type` - `int_dbt_prod_transaction_type_group` - `orch_app_sm_field_manager` - `int_dbt_prod_dt_flatten_marketing_info` - `orch_app_ar_mkt_priority` - `int_dbt_prod_dt_flatten_country_region` - `int_dbt_prod_youtube_partnered_channels` - `orch_app_ar_vend_contact` - `orch_app_ar_contact` - `orch_app_ar_owner` - `int_dbt_prod_product_manager_mapping_union` - `int_dbt_prod_spatial_audio_delivery_history_search` - `int_dbt_prod_apple_spatial_audio_deliveries` - `royalty_prod_stmt_db_sales_distro` - `orch_app_ar_concierge_product` - `label_offering` - `dt_album_cover_art` #### abacus_fact_sales_nr - **Includes:** 14 views - **Views:** - `vw_abacus_fact_sales_nr` - `facts_prod_dim_country` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_contract_term_condition` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` - `orch_app_ar_prod_royalty_accounting_exchange_rate` #### abacus_fact_sales_qa - **Includes:** 34 views - **Views:** - `royalty_accounting_qa_abacus_fact_sales_distro` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `orch_app_ar_customer_master_master` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_sales_file` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_project` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_qa_vw_dim_abacus_account` - `royalty_accounting_qa_vw_dim_abacus_contract` - `facts_prod_dim_artist` - `int_dbt_prod_track_writers` - `int_dbt_prod_track_artist_by_type` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_contract_term_sax_schedule` - `royalty_accounting_prod_vw_contract_term_sax_right_block` - `orch_app_ar_prod_royalty_accounting_exchange_rate` - `int_dbt_seed_right_type_groupings` - `dt_abacus_track_artists` - `orch_app_ar_royalty_accounting_accounting_run` - `dt_dim_track` - `orch_app_ar_distribution_format` - `orch_app_ar_distribution_format_media` - `orch_app_ar_product_physical` - `dt_abacus_contract_lifecycle_qa` - `orch_app_prod_royalty_accounting_contract_mechanical_deduction` #### abacus_fact_sales_staging - **Includes:** 30 views - **Views:** - `vw_abacus_fact_sales_distro_staging` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `orch_app_ar_customer_master_master` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_sales_file` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_project` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `facts_prod_dim_artist` - `int_dbt_prod_track_writers` - `int_dbt_prod_track_artist_by_type` - `orch_app_ar_prod_royalty_accounting_exchange_rate` - `royalty_accounting_prod_vw_contract_term_sax_schedule` - `royalty_accounting_prod_vw_contract_term_sax_right_block` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` - `orch_app_ar_royalty_accounting_accounting_run` - `dt_dim_track` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_fact_sales_staging_qa - **Includes:** 29 views - **Views:** - `royalty_accounting_qa_vw_abacus_fact_sales_distro_staging` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `orch_app_ar_customer_master_master` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_sales_file` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_project` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_qa_vw_dim_abacus_account` - `royalty_accounting_qa_vw_dim_abacus_contract` - `facts_prod_dim_artist` - `int_dbt_prod_track_writers` - `int_dbt_prod_track_artist_by_type` - `orch_app_ar_prod_royalty_accounting_exchange_rate` - `royalty_accounting_prod_vw_contract_term_sax_schedule` - `royalty_accounting_prod_vw_contract_term_sax_right_block` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` - `orch_app_ar_royalty_accounting_accounting_run` - `dt_dim_track` - `dt_abacus_contract_lifecycle_qa` #### abacus_fact_sales_unified_monitoring - **Includes:** 8 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_abacus_fact_sales_unified_ledger_comparison` - `orch_app_ar_royalty_accounting_run_controller` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_flowthrough_manual_adjustments - **Includes:** 10 views - **Views:** - `dt_abacus_flowthrough_manual_adjustment_uat` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_qa_vw_dim_abacus_contract` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_qa_vw_dim_abacus_account` - `dt_abacus_flowthrough_manual_adjustment_prod` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `abacus_flowthrough_manual_adjustment_qa` #### abacus_ledger_account_contract_integrity - **Includes:** 1 views - **Views:** - `dt_ledger_account_contract_integrity` #### abacus_looker - **Includes:** 13 views - **Views:** - `int_dbt_prod_abacus_expenses` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_qa_abacus_expenses` - `int_dbt_prod_abacus_adjustments` - `int_dbt_prod_qa_abacus_adjustments` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_dim_abacus_contract` - `orch_app_ar_royalty_accounting_run_controller` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_abacus_contract_lifecycle_prod` - `facts_prod_identity` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_mech_deduction_by_contract - **Includes:** 10 views - **Views:** - `royalty_accounting_qa_vw_dim_abacus_contract` - `royalty_accounting_qa_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_abacus_us_mech_deduction_by_contract_qa` - `dt_abacus_contract_lifecycle_qa` - `dt_abacus_contract_lifecycle_prod` - `orch_app_ar_royalty_accounting_run_controller` - `dt_abacus_us_mech_deduction_by_contract_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_monthly_comparison - **Includes:** 5 views - **Views:** - `int_dbt_prod_monthly_comparison_report` - `int_dbt_prod_monthly_comparison_report_prod` - `dt_abacus_contract_lifecycle_prod` - `orch_app_ar_royalty_accounting_payment_hold` - `royalty_accounting_prod_vw_dim_abacus_account` #### abacus_nr_sales - **Includes:** 1 views - **Views:** - `royalty_accounting_prod_stmt_db_sales_nr_staging` #### abacus_oa_contract_monitoring - **Includes:** 8 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_oa_contract_monitoring` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_oa_contract_monitoring_dev - **Includes:** 8 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_payment_hold` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dev_abacus_oa_contract_monitoring` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_orphaned_products - **Includes:** 12 views - **Views:** - `dt_abacus_orphaned_products_wo_contract_qa` - `royalty_accounting_qa_vw_dim_abacus_account` - `royalty_accounting_qa_vw_dim_abacus_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `facts_prod_dim_artist` - `dt_abacus_orphaned_products_existing_contracts_qa` - `orch_app_ar_royalty_accounting_contract_term` - `dt_abacus_orphaned_products_wo_contract_prod` - `dt_abacus_orphaned_products_existing_contracts_prod` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` #### abacus_payment_approval_file - **Includes:** 7 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_abacus_payment_approval_file` - `orch_app_ar_royalty_accounting_run_controller` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_prod` #### abacus_potential_double_booked_transactions - **Includes:** 3 views - **Views:** - `dt_potential_double_booked_transactions_distro` - `dt_potential_double_booked_transactions_nr` - `orch_app_ar_country` #### abacus_product_exceptions - **Includes:** 14 views - **Views:** - `dt_product_exceptions` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_run_controller` - `facts_prod_dim_release` - `facts_prod_dim_country` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `facts_prod_dim_track_clean_mv` - `facts_prod_dim_label` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_profiles - **Includes:** 2 views - **Views:** - `dt_abacus_profiles` - `facts_prod_identity` #### abacus_remaps_report - **Includes:** 3 views - **Views:** - `*` - `/*` - `my_dashboard.dashboard.lookml` #### abacus_reserves - **Includes:** 2 views - **Views:** - `dt_abacus_physical_reserves` - `royalty_accounting_prod_vw_dim_abacus_contract` #### abacus_royaltyshare_mechanicals - **Includes:** 34 views - **Views:** - `dt_abacus_royaltyshare_mechanical_deduction` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `orch_app_ar_customer_master_master` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_prod_royalty_accounting_contract_mechanical_deduction` - `int_dbt_prod_awal_tier_groups` - `facts_prod_dim_project` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_royalty_accounting_run_controller` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `facts_prod_dim_artist` - `int_dbt_prod_track_writers` - `int_dbt_prod_track_artist_by_type` - `int_dbt_prod_abacus_awal_client_segments` - `royalty_accounting_prod_vw_contract_term_sax_schedule` - `royalty_accounting_prod_vw_contract_term_sax_right_block` - `orch_app_ar_prod_royalty_accounting_exchange_rate` - `int_dbt_seed_right_type_groupings` - `dt_abacus_track_artists` - `orch_app_ar_royalty_accounting_accounting_run` - `dt_dim_track` - `orch_app_ar_distribution_format` - `orch_app_ar_distribution_format_media` - `orch_app_ar_product_physical` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_sax_agreement_denormalized - **Includes:** 5 views - **Views:** - `royalty_accounting_prod_sax_agreement_denorm` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `awal_sax_awal_terms_and_conditions` - `dt_abacus_contract_lifecycle_prod` #### abacus_settlement_feed - **Includes:** 9 views - **Views:** - `sony_internal_abacus_settlement_feed_history` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` - `grps_exp_gras_company` - `facts_prod_dim_label` - `facts_prod_dim_country` - `orch_app_ar_vendor_closer` - `orch_app_ar_orchadmin_users` #### abacus_sync_account_lambda - **Includes:** 1 views - **Views:** - `dt_abacus_sync_account_lambda` #### abacus_tap_account_payee_kyc_notification - **Includes:** 9 views - **Views:** - `orch_app_prod_royalty_accounting_account_payee_kyc_notification` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_run_controller` - `orch_app_qa_royalty_accounting_account_payee_kyc_notification` - `dt_abacus_contract_lifecycle_prod` - `dt_abacus_contract_lifecycle_qa` - `royalty_accounting_qa_vw_dim_abacus_contract` - `royalty_accounting_qa_vw_dim_abacus_account` #### abacus_tap_advances - **Includes:** 13 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_abacus_tap_advances` - `orch_app_ar_royalty_accounting_run_controller` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` - `facts_prod_identity` - `orch_app_ar_vendor_closer` - `orch_app_ar_orchadmin_users` - `facts_prod_dim_label` - `facts_prod_dim_country` #### abacus_tap_closing_bal_tax_rev - **Includes:** 11 views - **Views:** - `royalty_accounting_qa_vw_dim_abacus_contract` - `royalty_accounting_qa_vw_dim_abacus_account` - `dt_abacus_tap_closing_bal_taxable_rev_qa` - `dt_abacus_contract_lifecycle_qa` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `dt_abacus_tap_closing_bal_taxable_rev_prod` - `dt_abacus_contract_lifecycle_prod` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_tap_payable_balances_export_qa - **Includes:** 4 views - **Views:** - `royalty_accounting_qa_vw_dim_abacus_contract` - `royalty_accounting_qa_vw_dim_abacus_account` - `dt_abacus_tap_payable_balances_export_qa` - `dt_abacus_contract_lifecycle_qa` #### abacus_tap_payment_custom - **Includes:** 9 views - **Views:** - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_qa_vw_dim_abacus_account` - `orch_app_qa_royalty_accounting_contract_reserve` - `royalty_accounting_qa_vw_dim_abacus_contract` - `dt_abacus_contract_lifecycle_prod` - `dt_abacus_contract_lifecycle_qa` - `orch_app_qa_royalty_accounting_worksheet_payment_custom` - `orch_app_prod_royalty_accounting_worksheet_payment_custom` #### abacus_tap_tax_correction - **Includes:** 2 views - **Views:** - `orch_app_prod_royalty_accounting_worksheet_tax_correction` - `orch_app_prod_royalty_accounting_worksheet_tax_correction_vat` #### abacus_tap_tax_correction_qa - **Includes:** 2 views - **Views:** - `orch_app_qa_royalty_accounting_worksheet_tax_correction` - `orch_app_qa_royalty_accounting_worksheet_tax_correction_vat` #### abacus_terms_of_product_exceptions - **Includes:** 14 views - **Views:** - `dt_terms_of_product_exceptions` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_run_controller` - `facts_prod_dim_release` - `facts_prod_dim_country` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `facts_prod_dim_track_clean_mv` - `facts_prod_dim_label` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_terms_of_track_exceptions - **Includes:** 14 views - **Views:** - `dt_terms_of_track_exceptions` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `orch_app_ar_royalty_accounting_run_controller` - `facts_prod_dim_release` - `facts_prod_dim_country` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `facts_prod_dim_track_clean_mv` - `facts_prod_dim_label` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `facts_prod_identity` - `dt_abacus_contract_lifecycle_prod` #### abacus_unallocated_sales_distro_accounting_period - **Includes:** 17 views - **Views:** - `ROYALTY_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD` - `orch_app_ar_royalty_accounting_sales_file` - `facts_prod_dim_store` - `facts_prod_dim_country` - `facts_prod_dim_transactiontype` - `facts_prod_dim_label` - `orch_app_ar_artist_info` - `facts_prod_dim_track` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_stmt_db_sales_distro` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_releases` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` - `orch_app_ar_royalty_accounting_sales_file` - `dt_dim_track` #### abacus_unallocated_sales_distro_statement_period - **Includes:** 16 views - **Views:** - `ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD` - `orch_app_ar_royalty_accounting_sales_file` - `facts_prod_dim_store` - `facts_prod_dim_country` - `facts_prod_dim_transactiontype` - `facts_prod_dim_label` - `orch_app_ar_artist_info` - `facts_prod_dim_track` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_stmt_db_sales_distro` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_releases` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` - `dt_dim_track` #### abacus_unallocated_sales_distro_unique_details - **Includes:** 17 views - **Views:** - `ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS` - `orch_app_ar_royalty_accounting_sales_file` - `facts_prod_dim_store` - `facts_prod_dim_country` - `facts_prod_dim_transactiontype` - `facts_prod_dim_label` - `orch_app_ar_artist_info` - `facts_prod_dim_track` - `orch_app_ar_royalty_statement_period` - `royalty_accounting_prod_stmt_db_sales_distro` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_releases` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` - `dt_dim_track` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### abacus_unallocated_sales_nr_statement_period - **Includes:** 10 views - **Views:** - `royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period` - `orch_app_ar_royalty_accounting_sales_file` - `facts_prod_dim_store` - `facts_prod_dim_country` - `facts_prod_dim_transactiontype` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_accounting_period` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` #### abacus_upc_to_contract_mapping - **Includes:** 16 views - **Views:** - `royalty_accounting_prod_vw_upc_to_contract` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `facts_prod_dim_country` - `stmt_db_prod_remaps` - `facts_prod_dim_transactiontype` - `orch_app_ar_releases` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_product_physical` - `stmt_db_prod_remaps_physical` - `facts_prod_dim_artist` - `dt_contract_term_condition_denormalized` - `facts_prod_dim_store` - `orch_app_ar_royalty_accounting_run_controller` - `dt_abacus_contract_lifecycle_prod` #### abacus_upc_to_contract_mapping_uat - **Includes:** 16 views - **Views:** - `royalty_accounting_uat_vw_upc_to_contract` - `royalty_accounting_uat_vw_dim_abacus_contract` - `royalty_accounting_uat_vw_dim_abacus_account` - `facts_prod_dim_country` - `stmt_db_prod_remaps` - `facts_prod_dim_transactiontype` - `orch_app_ar_releases` - `orch_app_ar_royalty_accounting_contract_term_uat` - `orch_app_ar_royalty_accounting_contract_term_condition_uat` - `orch_app_ar_product_physical` - `stmt_db_prod_remaps_physical` - `facts_prod_dim_artist` - `dt_contract_term_condition_denormalized_uat` - `facts_prod_dim_store` - `orch_app_ar_royalty_accounting_run_controller` - `dt_abacus_contract_lifecycle_uat` #### abacus_upc_to_contract_qa - **Includes:** 16 views - **Views:** - `dev_hsingh_upc_to_contract` - `royalty_accounting_prod_vw_dim_abacus_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `facts_prod_dim_country` - `stmt_db_prod_remaps` - `facts_prod_dim_transactiontype` - `orch_app_ar_releases` - `orch_app_ar_royalty_accounting_contract_term` - `orch_app_ar_royalty_accounting_contract_term_condition` - `orch_app_ar_product_physical` - `stmt_db_prod_remaps_physical` - `facts_prod_dim_artist` - `dt_contract_term_condition_denormalized` - `facts_prod_dim_store` - `orch_app_ar_royalty_accounting_run_controller` - `dt_abacus_contract_lifecycle_prod` #### dt_revenue_by_contract - **Includes:** 19 views - **Views:** - `dt_revenue_by_contract` - `royalty_accounting_prod_vw_dim_abacus_account` - `royalty_accounting_prod_vw_dim_abacus_contract` - `orch_app_ar_releases` - `facts_prod_dim_track` - `facts_prod_dim_label` - `facts_prod_dim_country` - `facts_prod_dim_release` - `facts_prod_dim_store` - `facts_prod_dim_transactiontype` - `orch_app_ar_artist_info` - `orch_app_ar_royalty_accounting_period` - `orch_app_ar_royalty_statement_period` - `orch_app_ar_royalty_contract` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `orch_app_ar_royalty_accounting_run_controller` - `dt_abacus_contract_lifecycle_prod` - `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` #### oa_banking_migration - **Includes:** 1 views - **Views:** - `/dt_oa_banking_migration` #### periscope_report - **Includes:** 3 views - **Views:** - `*` - `/*` - `my_dashboard.dashboard.lookml` #### raw_abacus_sales_file - **Includes:** 9 views - **Views:** - `royalty_accounting_prod_stmt_db_sales_distro` - `orch_app_ar_royalty_accounting_sales_file` - `facts_prod_dim_store` - `facts_prod_dim_country` - `facts_prod_dim_label` - `facts_prod_dim_transactiontype` - `int_dbt_prod_awal_tier_groups` - `int_dbt_prod_abacus_awal_client_segments` - `int_dbt_seed_right_type_groupings` ## View Dependencies ### Views by Data Source #### Direct Database Tables Views that directly reference database tables: **"DBT_PROD"."LABEL_OFFERING"** - Used by 1 views: `label_offering` **ART_RELATIONS_PROD_ART_RELATIONS.CONCIERGE_PRODUCT** - Used by 1 views: `orch_app_ar_concierge_product` **ART_RELATIONS_PROD_ART_RELATIONS.VENDOR_CLOSERS** - Used by 1 views: `orch_app_ar_vendor_closer` **DBT_PROD.ABACUS_AWAL_CLIENT_SEGMENTS** - Used by 1 views: `int_dbt_prod_abacus_awal_client_segments` **DBT_PROD.AWAL_TIER_GROUPS** - Used by 1 views: `int_dbt_prod_awal_tier_groups` **DBT_PROD.DT_FLATTEN_COUNTRY_REGION** - Used by 1 views: `int_dbt_prod_dt_flatten_country_region` **DBT_PROD.DT_FLATTEN_MARKETING_INFO** - Used by 1 views: `int_dbt_prod_dt_flatten_marketing_info` **DBT_PROD.DT_LABEL_IS_PHYSICAL** - Used by 1 views: `int_dbt_prod_dt_label_is_physical` **DBT_PROD.DT_TRACK_ARTIST_BY_TYPE** - Used by 1 views: `int_dbt_prod_track_artist_by_type` **DBT_PROD.DT_TRACK_WRITERS** - Used by 1 views: `int_dbt_prod_track_writers` **DBT_PROD.SPATIAL_AUDIO_DELIVERY_HISTORY_SEARCH** - Used by 1 views: `int_dbt_prod_spatial_audio_delivery_history_search` **DBT_PROD_SEED_DATA.RIGHT_TYPE_GROUPINGS** - Used by 1 views: `int_dbt_seed_right_type_groupings` **GRPS_DRAS002.tras024** - Used by 1 views: `grps_exp_gras_company` **PROD.ABACUS_SETTLEMENT_FEED_HISTORY** - Used by 1 views: `sony_internal_abacus_settlement_feed_history` **PROD.ACCOUNTING_RUN_RESULTS_DISTRO** - Used by 1 views: `royalty_prod_accounting_run_results_distro` **PROD.GLOBAL_PARTICIPANT_REPRESENTS_LABEL_PARTICIPANT** - Used by 1 views: `fact_prod_global_participant_represents_label_participant` **PROD.LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT** - Used by 1 views: `fact_prod_label_participant_participated_in_orchard_product` **PROD.RELEASE_DELIVERY_HISTORY** - Used by 1 views: `int_prod_release_delivery_history` **PROD.REMAPS_PHYSICAL** - Used by 2 views: `stmt_db_prod_remaps_physical_duplicate`, `stmt_db_prod_remaps_physical` **PROD.SAX_AGREEMENT_DENORM** - Used by 1 views: `royalty_accounting_prod_sax_agreement_denorm` **PROD.STMT_DB_SALES_DISTRO** - Used by 1 views: `royalty_prod_stmt_db_sales_distro` **PROD.VW_ABACUS_ADJUSTMENTS_v2** - Used by 1 views: `int_dbt_prod_abacus_adjustments` **PROD.VW_ABACUS_AUTOMATED_FLOWTHROUGH** - Used by 1 views: `dt_abacus_flowthrough_manual_adjustment_prod` **PROD.VW_ABACUS_FACT_SALES_DISTRO_STAGING** - Used by 1 views: `vw_abacus_fact_sales_distro_staging` **PROD.VW_ABACUS_FACT_SALES_NR_V3** - Used by 1 views: `vw_abacus_fact_sales_nr` **PROD.VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD** - Used by 1 views: `ROYALTY_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD` **PROD.VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD** - Used by 1 views: `ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD` **PROD.VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS** - Used by 1 views: `ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS` **PROD.VW_ABACUS_UNALLOCATED_SALES_NR_STATEMENT_PERIOD** - Used by 1 views: `royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period` **PROD.VW_CONTRACT_DENORMALIZED** - Used by 1 views: `royalty_accounting_prod_vw_contract_denormalized` **PROD.VW_CONTRACT_TERM_SAX_RIGHT_BLOCK** - Used by 1 views: `royalty_accounting_prod_vw_contract_term_sax_right_block` **PROD.VW_CONTRACT_TERM_SAX_SCHEDULE** - Used by 1 views: `royalty_accounting_prod_vw_contract_term_sax_schedule` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ACCOUNTING_PERIOD** - Used by 1 views: `orch_app_ar_royalty_accounting_period` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT** - Used by 1 views: `orch_app_ar_royalty_contract` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_ADVANCE** - Used by 1 views: `orch_app_ar_royalty_accounting_prod_contract_advance` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_HISTORY** - Used by 1 views: `orch_app_prod_royalty_accounting_contract_history` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM** - Used by 1 views: `orch_app_ar_royalty_accounting_contract_term` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM_CONDITION** - Used by 1 views: `orch_app_ar_royalty_accounting_contract_term_condition` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM_CONDITION_HISTORY** - Used by 1 views: `orch_app_prod_royalty_accounting_contract_term_condition_history` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM_HISTORY** - Used by 1 views: `orch_app_prod_royalty_accounting_contract_term_history` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE** - Used by 2 views: `orch_app_ar_prod_royalty_accounting_exchange_rate`, `orch_app_prod_royalty_accounting_exchange_rate` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.LEDGER_ADJUSTMENT_APPLIED** - Used by 1 views: `orch_app_ar_royalty_accounting_ledger_adjustment_applied` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.LEDGER_CONTRACT_ADVANCE_APPLIED** - Used by 1 views: `orch_app_ar_royalty_accounting_prod_ledger_contract_advance_applied` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.REFERENCE_FLOWTHROUGH_CALCULATION** - Used by 1 views: `REFERENCE_FLOWTHROUGH_CALCULATION` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.RUN_CONTROLLER** - Used by 1 views: `orch_app_ar_royalty_accounting_run_controller` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.STATEMENT_PERIOD** - Used by 1 views: `orch_app_ar_royalty_statement_period` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.WORKSHEET_PAYMENT_CUSTOM** - Used by 1 views: `orch_app_prod_royalty_accounting_worksheet_payment_custom` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.accounting_run** - Used by 1 views: `orch_app_ar_royalty_accounting_accounting_run` **PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.payment_hold** - Used by 1 views: `orch_app_ar_royalty_accounting_payment_hold` **PROD_SONY_METADATA_SONY_METADATA.FIELD_MANAGER** - Used by 1 views: `orch_app_sm_field_manager` **QA.VW_ABACUS_ADJUSTMENTS** - Used by 1 views: `int_dbt_prod_qa_abacus_adjustments` **QA.VW_ABACUS_AUTOMATED_FLOWTHROUGH** - Used by 1 views: `abacus_flowthrough_manual_adjustment_qa` **QA.VW_ABACUS_FACT_SALES_DISTRO_STAGING** - Used by 1 views: `royalty_accounting_qa_vw_abacus_fact_sales_distro_staging` **QA.VW_DIM_ABACUS_CONTRACT** - Used by 1 views: `royalty_accounting_qa_vw_dim_abacus_contract` **QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.WORKSHEET_PAYMENT_CUSTOM** - Used by 1 views: `orch_app_qa_royalty_accounting_worksheet_payment_custom` **UAT.VW_ABACUS_AUTOMATED_FLOWTHROUGH** - Used by 1 views: `dt_abacus_flowthrough_manual_adjustment_uat` **UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM** - Used by 1 views: `orch_app_ar_royalty_accounting_contract_term_uat` **UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM_CONDITION** - Used by 1 views: `orch_app_ar_royalty_accounting_contract_term_condition_uat` **UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.RUN_CONTROLLER** - Used by 1 views: `orch_app_ar_royalty_accounting_uat_run_controller` **art_relations_prod_art_relations.artist_info** - Used by 1 views: `orch_app_ar_artist_info` **art_relations_prod_art_relations.contact** - Used by 1 views: `orch_app_ar_contact` **art_relations_prod_art_relations.country** - Used by 1 views: `orch_app_ar_country` **art_relations_prod_art_relations.customer_master_master** - Used by 1 views: `orch_app_ar_customer_master_master` **art_relations_prod_art_relations.distribution_format** - Used by 1 views: `orch_app_ar_distribution_format` **art_relations_prod_art_relations.distribution_format_media** - Used by 1 views: `orch_app_ar_distribution_format_media` **art_relations_prod_art_relations.genre** - Used by 1 views: `orch_app_ar_genre` **art_relations_prod_art_relations.language** - Used by 1 views: `orch_app_ar_language` **art_relations_prod_art_relations.mkt_priority** - Used by 1 views: `orch_app_ar_mkt_priority` **art_relations_prod_art_relations.orchadmin_users** - Used by 1 views: `orch_app_ar_orchadmin_users` **art_relations_prod_art_relations.owner** - Used by 1 views: `orch_app_ar_owner` **art_relations_prod_art_relations.product_physical** - Used by 1 views: `orch_app_ar_product_physical` **art_relations_prod_art_relations.product_type** - Used by 1 views: `orch_app_ar_product_type` **art_relations_prod_art_relations.project** - Used by 1 views: `orch_app_ar_project` **art_relations_prod_art_relations.release_subgenre** - Used by 1 views: `orch_app_ar_release_subgenre` **art_relations_prod_art_relations.releases** - Used by 1 views: `orch_app_ar_releases` **art_relations_prod_art_relations.subgenre** - Used by 1 views: `orch_app_ar_subgenre` **art_relations_prod_art_relations.vend_contact** - Used by 1 views: `orch_app_ar_vend_contact` **dbt_prod.abacus_expenses** - Used by 1 views: `int_dbt_prod_abacus_expenses` **dbt_prod.apple_spatial_audio_delivery_history** - Used by 1 views: `int_dbt_prod_apple_spatial_audio_deliveries` **dbt_prod.artist_services_pm_union** - Used by 1 views: `int_dbt_prod_product_manager_mapping_union` **dbt_prod.monthly_comparison_report** - Used by 1 views: `int_dbt_prod_monthly_comparison_report` **dbt_prod.monthly_comparison_report_prod** - Used by 1 views: `int_dbt_prod_monthly_comparison_report_prod` **dbt_prod.orch_app_ar_track_track_physical_joined** - Used by 1 views: `orch_app_ar_track` **dbt_prod.qa_abacus_expenses** - Used by 1 views: `int_dbt_prod_qa_abacus_expenses` **dbt_prod.restrictions_label_substore** - Used by 1 views: `int_dbt_prod_restrictions_label_substore` **dbt_prod.restrictions_label_territory** - Used by 1 views: `int_dbt_prod_restrictions_label_territory` **dbt_prod.restrictions_release_substore** - Used by 1 views: `int_dbt_prod_restrictions_release_substore` **dbt_prod.restrictions_release_territory** - Used by 1 views: `int_dbt_prod_restrictions_release_territory` **dbt_prod.restrictions_subaccount_substore** - Used by 1 views: `int_dbt_prod_restrictions_subaccount_substore` **dbt_prod.restrictions_subaccount_territory** - Used by 1 views: `int_dbt_prod_restrictions_subaccount_territory` **dbt_prod.youtube_partnered_channels** - Used by 1 views: `int_dbt_prod_youtube_partnered_channels` **dbt_prod_seed_data.transaction_type_group** - Used by 1 views: `int_dbt_prod_transaction_type_group` **hsingh.vw_abacus_oa_contract_monitoring** - Used by 1 views: `dev_abacus_oa_contract_monitoring` **hsingh.vw_contract_history** - Used by 1 views: `royalty_accounting_prod_vw_contract_history` **hsingh.vw_contract_term_condition_history** - Used by 1 views: `royalty_accounting_prod_vw_contract_term_condition_history` **hsingh.vw_contract_term_history** - Used by 1 views: `royalty_accounting_prod_vw_contract_term_history` **hsingh.vw_fact_contract_history_qa** - Used by 1 views: `royalty_accounting_dev_vw_fact_contract_history_qa` **hsingh.vw_fact_contract_history_qa_dev** - Used by 1 views: `royalty_accounting_dev_vw_fact_contract_history` **prod.VW_ABACUS_ADJUSTMENTS_v2** - Used by 1 views: `royalty_accounting_prod_abacus_adjustments` **prod.abacus_fact_sales_unified_dbt** - Used by 1 views: `vw_abacus_fact_sales_distro` **prod.bits_per_sample** - Used by 1 views: `int_prod_vw_bits_per_sample` **prod.dim_artist** - Used by 1 views: `facts_prod_dim_artist` **prod.dim_country** - Used by 1 views: `facts_prod_dim_country` **prod.dim_genre** - Used by 1 views: `facts_prod_dim_genre` **prod.dim_imprint** - Used by 1 views: `facts_prod_dim_imprint` **prod.dim_label** - Used by 1 views: `facts_prod_dim_label` **prod.dim_period** - Used by 1 views: `facts_prod_dim_period` **prod.dim_project** - Used by 1 views: `facts_prod_dim_project` **prod.dim_release** - Used by 1 views: `facts_prod_dim_release` **prod.dim_store** - Used by 1 views: `facts_prod_dim_store` **prod.dim_subaccount** - Used by 1 views: `facts_prod_dim_subaccount` **prod.dim_track** - Used by 1 views: `facts_prod_dim_track` **prod.dim_track_clean_mv** - Used by 1 views: `facts_prod_dim_track_clean_mv` **prod.dim_transactiontype** - Used by 1 views: `facts_prod_dim_transactiontype` **prod.identity** - Used by 1 views: `facts_prod_identity` **prod.stmt_db_sales_distro** - Used by 1 views: `royalty_accounting_prod_stmt_db_sales_distro` **prod.stmt_db_sales_distro_staging** - Used by 1 views: `royalty_accounting_prod_stmt_db_sales_distro_staging` **prod.stmt_db_sales_nr_staging** - Used by 1 views: `royalty_accounting_prod_stmt_db_sales_nr_staging` **prod.vw_abacus_balances_looker_v2** - Used by 2 views: `dt_revenue_by_contract`, `dt_abacus_balance_report_prod` **prod.vw_abacus_balances_staging** - Used by 1 views: `royalty_accounting_prod_vw_abacus_balances_staging` **prod.vw_dim_abacus_ar_vendor** - Used by 2 views: `orchard_app_ar_vendor`, `royalty_accounting_prod_vw_dim_abacus_ar_vendor` **prod.vw_fact_contract_history** - Used by 1 views: `royalty_accounting_prod_vw_fact_contract_history` **prod_royalty_accounting_royalty_accounting.sales_file** - Used by 1 views: `orch_app_ar_royalty_accounting_sales_file` **qa.VW_ABACUS_ADJUSTMENTS_v2** - Used by 1 views: `royalty_accounting_qa_abacus_adjustments` **qa.vw_abacus_balances_looker_v2** - Used by 2 views: `dt_abacus_balance_report`, `royalty_accounting_qa_vw_abacus_balances_looker` **qa.vw_abacus_balances_staging** - Used by 1 views: `royalty_accounting_qa_vw_abacus_balances_staging` **sax.awal_terms_and_conditions** - Used by 1 views: `awal_sax_awal_terms_and_conditions` #### Derived Tables Views with custom SQL (complex transformations): Total: 77 views | View | Lines of Code | Source Tables | |------|---------------|---------------| | `royalty_accounting_qa_abacus_fact_sales_distro` | 804 | Custom SQL | | `dt_abacus_tap_advances` | 437 | Prod.Currency_Exchange_Rates, Prod.Dim_Currenc... | | `dt_potential_double_booked_transactions_distro` | 414 | Orchard_App_Reporting_V2, Orchard_App_Reportin... | | `dt_potential_double_booked_transactions_nr` | 358 | Orchard_App_Reporting_V2, Orchard_App_Reportin... | | `dt_abacus_batch_adjustments_expenses_uat` | 352 | Prod.Dim_Label, Uat_Royalty_Accounting_Royalty... | | `dt_abacus_batch_adjustments_expenses_prod` | 352 | Prod.Dim_Label, Prod_Royalty_Accounting_Royalt... | | `dt_abacus_batch_adjustments_expenses_qa` | 351 | Qa.Dim_Label, Qa_Royalty_Accounting_Royalty_Ac... | | `dt_abacus_physical_reserves` | 343 | Prod_Royalty_Accounting_Royalty_Accounting.Aba... | | `royalty_accounting_prod_vw_dim_abacus_contract` | 341 | Orchard_App_Reporting_V2, Orchard_App_Reportin... | | `royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales` | 324 | Abacus_Contract, Contract_Lifecyle, Orchard_Ap... | | `orch_app_prod_royalty_accounting_account_payee_kyc_notification` | 308 | Custom SQL | | `orch_app_qa_royalty_accounting_account_payee_kyc_notification` | 305 | Custom SQL | | `dt_abacus_payment_approval_file` | 302 | Prod_Royalty_Accounting_Royalty_Accounting.Aba... | | `royalty_accounting_uat_vw_dim_abacus_contract` | 292 | Orchard_App_Reporting_V2, Orchard_App_Reportin... | | `dt_abacus_transaction_level_uat_report` | 289 | Art_Relations_Prod_Art_Relations.Currencies, P... | | `dt_abacus_expenses_qa` | 231 | Qa_Royalty_Accounting_Royalty_Accounting.Abacu... | | `dt_abacus_batch_adjustments` | 231 | Orchard_App_Reporting_V2, Orchard_App_Reportin... | | `dt_abacus_expenses_prod` | 218 | Prod_Royalty_Accounting_Royalty_Accounting.Aba... | | `dt_product_exceptions` | 218 | Prod.Dim_Country, Prod.Vw_Dim_Abacus_Account, ... | | `dt_abacus_remaps` | 212 | Art_Relations_Prod_Art_Relations.Releases, Pro... | *Showing top 20 most complex derived views. Total: 77* ## Explore Relationships ### Explores and Their Dependencies #### Model: Abacus_Replace_Double_book_transact **dt_abacus_replace_double_book_transact** (ABACUS Double Booked Transactions) - Base View: `dt_abacus_replace_double_book_transact` - View Type: Derived Table - Data Source: Derived from: Doubled_Booked_Transactions, Orchard_App_Reporting_V2, Orchard_App... #### Model: abacus-looker **dt_abacus_transaction_level_uat_report** (ABACUS Account) - Base View: `dt_abacus_transaction_level_uat_report` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Currencies, Prod.Dim_Currency, Pr... #### Model: abacus_adjustments **royalty_accounting_qa_abacus_adjustments** (Orchard/AWAL Tiers) - Base View: `royalty_accounting_qa_abacus_adjustments` - View Type: Direct Table - Data Source: royalty_accounting.qa.VW_ABACUS_ADJUSTMENTS_v2 **royalty_accounting_prod_abacus_adjustments** (Orchard/AWAL Tiers) - Base View: `royalty_accounting_prod_abacus_adjustments` - View Type: Direct Table - Data Source: royalty_accounting.prod.VW_ABACUS_ADJUSTMENTS_v2 #### Model: abacus_balance_report **dt_abacus_balance_report** (ABACUS Account) - Base View: `dt_abacus_balance_report` - View Type: Direct Table - Data Source: royalty_accounting_reporting.qa.vw_abacus_balances_looker_v2 **dt_abacus_balance_report_prod** (ABACUS Account) - Base View: `dt_abacus_balance_report_prod` - View Type: Direct Table - Data Source: royalty_accounting_reporting.prod.vw_abacus_balances_looker_v2 #### Model: abacus_balances **royalty_accounting_qa_vw_abacus_balances_looker** (ABACUS Account) - Base View: `royalty_accounting_qa_vw_abacus_balances_looker` - View Type: Direct Table - Data Source: royalty_accounting_reporting.qa.vw_abacus_balances_looker_v2 #### Model: abacus_balances_staging **royalty_accounting_prod_vw_abacus_balances_staging** (ABACUS Contract) - Base View: `royalty_accounting_prod_vw_abacus_balances_staging` - View Type: Direct Table - Data Source: royalty_accounting.prod.vw_abacus_balances_staging #### Model: abacus_balances_staging_qa **royalty_accounting_qa_vw_abacus_balances_staging** (ABACUS Contract) - Base View: `royalty_accounting_qa_vw_abacus_balances_staging` - View Type: Direct Table - Data Source: royalty_accounting.qa.vw_abacus_balances_staging #### Model: abacus_batch_adjustments **dt_abacus_batch_adjustments** (ABACUS Account) - Base View: `dt_abacus_batch_adjustments` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Qa_Royalty_Acco... **dt_abacus_batch_adjustments_expenses_qa** (ABACUS Account) - Base View: `dt_abacus_batch_adjustments_expenses_qa` - View Type: Derived Table - Data Source: Derived from: Qa.Dim_Label, Qa_Royalty_Accounting_Royalty_Accounting.Abacus_Even... **dt_abacus_batch_adjustments_expenses_prod** (ABACUS Account) - Base View: `dt_abacus_batch_adjustments_expenses_prod` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Label, Prod_Royalty_Accounting_Royalty_Accounting.Abacus_... **dt_abacus_batch_adjustments_expenses_uat** (ABACUS Account) - Base View: `dt_abacus_batch_adjustments_expenses_uat` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Label, Uat_Royalty_Accounting_Royalty_Accounting.Abacus_E... #### Model: abacus_contract **royalty_accounting_prod_vw_dim_abacus_contract** (ABACUS Contract Lifecycle) - Base View: `royalty_accounting_prod_vw_dim_abacus_contract` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... #### Model: abacus_contract_advance **orch_app_ar_royalty_accounting_prod_contract_advance** (ABACUS Contract) - Base View: `orch_app_ar_royalty_accounting_prod_contract_advance` - View Type: Direct Table - Data Source: ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_ADV... #### Model: abacus_contract_denormalized **royalty_accounting_prod_vw_contract_denormalized** (ABACUS Account) - Base View: `royalty_accounting_prod_vw_contract_denormalized` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_CONTRACT_DENORMALIZED #### Model: abacus_contract_history **royalty_accounting_dev_vw_fact_contract_history** (Last Modified By Name) - Base View: `royalty_accounting_dev_vw_fact_contract_history` - View Type: Direct Table - Data Source: dev.hsingh.vw_fact_contract_history_qa_dev **royalty_accounting_prod_vw_contract_history** (ABACUS Contract Term History) - Base View: `royalty_accounting_prod_vw_contract_history` - View Type: Direct Table - Data Source: dev.hsingh.vw_contract_history #### Model: abacus_contract_history_qa **royalty_accounting_dev_vw_fact_contract_history_qa** (ABACUS Fact Contract History QA) - Base View: `royalty_accounting_dev_vw_fact_contract_history_qa` - View Type: Direct Table - Data Source: dev.hsingh.vw_fact_contract_history_qa #### Model: abacus_contract_lifecycle_prod **dt_abacus_contract_lifecycle_prod** (ABACUS Account) - Base View: `dt_abacus_contract_lifecycle_prod` - View Type: Derived Table - Data Source: Derived from: Contract_Lifecycle, Orchard_App_Reporting_V2, Orchard_App_Reportin... #### Model: abacus_contract_lifecycle_qa **dt_abacus_termination_renewal_contract_lifecycle_qa** (ABACUS Account) - Base View: `dt_abacus_termination_renewal_contract_lifecycle_qa` - View Type: Derived Table - Data Source: Derived from: Contract_Lifecycle, Orchard_App_Reporting_V2, Orchard_App_Reportin... **dt_abacus_expenses_qa** (Orchard/AWAL Tiers) - Base View: `dt_abacus_expenses_qa` - View Type: Derived Table - Data Source: Derived from: Qa_Royalty_Accounting_Royalty_Accounting.Abacus_State, Qa_Royalty_... #### Model: abacus_contract_mech_deduction_history **dt_contract_mech_deduction_history** (ABACUS Contract Lifecycle) - Base View: `dt_contract_mech_deduction_history` - View Type: Derived Table - Data Source: Derived from: Mech_History_All_Records, Orchard_App_Reporting_V2, Orchard_App_Re... #### Model: abacus_contract_qa **royalty_accounting_qa_vw_dim_abacus_contract** (ABACUS Contract Lifecycle) - Base View: `royalty_accounting_qa_vw_dim_abacus_contract` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.QA.VW_DIM_ABACUS_CONTRACT #### Model: abacus_distro_sales **royalty_accounting_prod_stmt_db_sales_distro_staging** (ABACUS Distro Staging Sales) - Base View: `royalty_accounting_prod_stmt_db_sales_distro_staging` - View Type: Direct Table - Data Source: royalty_accounting.prod.stmt_db_sales_distro_staging #### Model: abacus_double_booked_transactions **dt_double_booked_transactions** (Double Booked Transactions) - Base View: `dt_double_booked_transactions` - View Type: Derived Table - Data Source: Derived from: Prod.Vw_Abacus_Fact_Sales_Distro_V2, Royalty_Accounting, Royalty_A... **dt_contracts_and_accounts_with_double_booking** (Contracts and Accounts with Double Bookings) - Base View: `dt_contracts_and_accounts_with_double_booking` - View Type: Derived Table - Data Source: Derived from: Prod.Vw_Abacus_Fact_Sales_Distro_V2, Royalty_Accounting, Royalty_A... #### Model: abacus_expenses **dt_abacus_expenses_prod** (Orchard/AWAL Tiers) - Base View: `dt_abacus_expenses_prod` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Abacus_State, Prod_Roya... **dt_abacus_expenses_qa** (Orchard/AWAL Tiers) - Base View: `dt_abacus_expenses_qa` - View Type: Derived Table - Data Source: Derived from: Qa_Royalty_Accounting_Royalty_Accounting.Abacus_State, Qa_Royalty_... #### Model: abacus_fact_contract_history **royalty_accounting_prod_vw_fact_contract_history** (Last Modified By Name) - Base View: `royalty_accounting_prod_vw_fact_contract_history` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.prod.vw_fact_contract_history #### Model: abacus_fact_sales **vw_abacus_fact_sales_distro** (Earliest Sales File) - Base View: `vw_abacus_fact_sales_distro` - View Type: Direct Table - Data Source: royalty_accounting.prod.abacus_fact_sales_unified_dbt #### Model: abacus_fact_sales_nr **vw_abacus_fact_sales_nr** (Transaction Country) - Base View: `vw_abacus_fact_sales_nr` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_FACT_SALES_NR_V3 #### Model: abacus_fact_sales_qa **royalty_accounting_qa_abacus_fact_sales_distro** (Earliest Sales File) - Base View: `royalty_accounting_qa_abacus_fact_sales_distro` - View Type: Derived Table - Data Source: ROYALTY_ACCOUNTING.QA.VW_ABACUS_FACT_SALES_DISTRO_V3 #### Model: abacus_fact_sales_staging **vw_abacus_fact_sales_distro_staging** (Fact Sales Staging) - Base View: `vw_abacus_fact_sales_distro_staging` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_FACT_SALES_DISTRO_STAGING #### Model: abacus_fact_sales_staging_qa **royalty_accounting_qa_vw_abacus_fact_sales_distro_staging** (Earliest Sales File) - Base View: `royalty_accounting_qa_vw_abacus_fact_sales_distro_staging` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.QA.VW_ABACUS_FACT_SALES_DISTRO_STAGING #### Model: abacus_fact_sales_unified_monitoring **dt_abacus_fact_sales_unified_ledger_comparison** (ABACUS Contract) - Base View: `dt_abacus_fact_sales_unified_ledger_comparison` - View Type: Derived Table - Data Source: Derived from: Abacus_Data, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Pr... #### Model: abacus_flowthrough_manual_adjustments **dt_abacus_flowthrough_manual_adjustment_uat** (ABACUS Account QA) - Base View: `dt_abacus_flowthrough_manual_adjustment_uat` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING_REPORTING.UAT.VW_ABACUS_AUTOMATED_FLOWTHROUGH **dt_abacus_flowthrough_manual_adjustment_prod** (ABACUS Account PROD) - Base View: `dt_abacus_flowthrough_manual_adjustment_prod` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING_REPORTING.PROD.VW_ABACUS_AUTOMATED_FLOWTHROUGH **abacus_flowthrough_manual_adjustment_qa** (ABACUS Account QA) - Base View: `abacus_flowthrough_manual_adjustment_qa` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING_REPORTING.QA.VW_ABACUS_AUTOMATED_FLOWTHROUGH **dt_abacus_expenses_qa** (Orchard/AWAL Tiers) - Base View: `dt_abacus_expenses_qa` - View Type: Derived Table - Data Source: Derived from: Qa_Royalty_Accounting_Royalty_Accounting.Abacus_State, Qa_Royalty_... #### Model: abacus_ledger_account_contract_integrity **dt_ledger_account_contract_integrity** (Ledger Account Contract Integrity) - Base View: `dt_ledger_account_contract_integrity` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... #### Model: abacus_looker **int_dbt_prod_abacus_adjustments** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_abacus_adjustments` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_ADJUSTMENTS_v2 **int_dbt_prod_qa_abacus_adjustments** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_qa_abacus_adjustments` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.QA.VW_ABACUS_ADJUSTMENTS **int_dbt_prod_abacus_expenses** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_abacus_expenses` - View Type: Direct Table - Data Source: intelligence.dbt_prod.abacus_expenses **int_dbt_prod_qa_abacus_expenses** (Orchard/AWAL Tiers) - Base View: `int_dbt_prod_qa_abacus_expenses` - View Type: Direct Table - Data Source: intelligence.dbt_prod.qa_abacus_expenses #### Model: abacus_mech_deduction_by_contract **dt_abacus_us_mech_deduction_by_contract_qa** (ABACUS Contract Lifecycle) - Base View: `dt_abacus_us_mech_deduction_by_contract_qa` - View Type: Derived Table - Data Source: Derived from: Qa.Accounting_Run_Results_Distro_Mech, Qa.Contract_Transaction_Dis... **dt_abacus_us_mech_deduction_by_contract_prod** (ABACUS Contract Lifecycle) - Base View: `dt_abacus_us_mech_deduction_by_contract_prod` - View Type: Derived Table - Data Source: Derived from: Prod.Accounting_Run_Results_Distro_Mech, Prod.Contract_Transaction... #### Model: abacus_monthly_comparison **int_dbt_prod_monthly_comparison_report** (ABACUS Contract Lifecycle) - Base View: `int_dbt_prod_monthly_comparison_report` - View Type: Direct Table - Data Source: intelligence.dbt_prod.monthly_comparison_report **int_dbt_prod_monthly_comparison_report_prod** (ABACUS Contract Lifecycle) - Base View: `int_dbt_prod_monthly_comparison_report_prod` - View Type: Direct Table - Data Source: intelligence.dbt_prod.monthly_comparison_report_prod #### Model: abacus_nr_sales **royalty_accounting_prod_stmt_db_sales_nr_staging** (ABACUS NR Staging Sales) - Base View: `royalty_accounting_prod_stmt_db_sales_nr_staging` - View Type: Direct Table - Data Source: royalty_accounting.prod.stmt_db_sales_nr_staging #### Model: abacus_oa_contract_monitoring **dt_abacus_oa_contract_monitoring** (ABACUS Account) - Base View: `dt_abacus_oa_contract_monitoring` - View Type: Derived Table - Data Source: Derived from: Prod.Vw_Dim_Abacus_Ar_Vendor, Prod.Vw_Dim_Abacus_Ar_Vendor_Contrac... #### Model: abacus_oa_contract_monitoring_dev **dev_abacus_oa_contract_monitoring** (ABACUS Account) - Base View: `dev_abacus_oa_contract_monitoring` - View Type: Direct Table - Data Source: dev.hsingh.vw_abacus_oa_contract_monitoring #### Model: abacus_orphaned_products **dt_abacus_orphaned_products_wo_contract_qa** (ABACUS Account) - Base View: `dt_abacus_orphaned_products_wo_contract_qa` - View Type: Derived Table - Data Source: Derived from: Qa.Dim_Release, Qa.Vw_Contract_Denormalized, Qa.Vw_Dim_Abacus_Acco... **dt_abacus_orphaned_products_existing_contracts_qa** (ABACUS Account) - Base View: `dt_abacus_orphaned_products_existing_contracts_qa` - View Type: Derived Table - Data Source: Derived from: Accounts_Wo_Label, Qa.Dim_Release, Qa.Vw_Contract_Denormalized, Qa... **dt_abacus_orphaned_products_wo_contract_prod** (ABACUS Account) - Base View: `dt_abacus_orphaned_products_wo_contract_prod` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Release, Prod.Vw_Contract_Denormalized, Prod.Vw_Dim_Abacu... **dt_abacus_orphaned_products_existing_contracts_prod** (ABACUS Account) - Base View: `dt_abacus_orphaned_products_existing_contracts_prod` - View Type: Derived Table - Data Source: Derived from: Accounts_Wo_Label, Prod.Dim_Release, Prod.Vw_Contract_Denormalized... #### Model: abacus_payment_approval_file **dt_abacus_payment_approval_file** (ABACUS Contract) - Base View: `dt_abacus_payment_approval_file` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Abacus_Event, Prod_Roya... #### Model: abacus_potential_double_booked_transactions **dt_potential_double_booked_transactions_distro** (Potential Double Booked Transactions) - Base View: `dt_potential_double_booked_transactions_distro` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... **dt_potential_double_booked_transactions_nr** (Potential Double Booked Transactions) - Base View: `dt_potential_double_booked_transactions_nr` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... #### Model: abacus_product_exceptions **dt_product_exceptions** (ABACUS Account) - Base View: `dt_product_exceptions` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country, Prod.Vw_Dim_Abacus_Account, Prod_Royalty_Account... #### Model: abacus_profiles **dt_abacus_profiles** (Identity) - Base View: `dt_abacus_profiles` - View Type: Derived Table - Data Source: Derived from: Prod.Has_Profile #### Model: abacus_remaps_report **dt_abacus_remaps** (Abacus Remaps Report) - Base View: `dt_abacus_remaps` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Releases, Prod.Dim_Artist, Prod.R... #### Model: abacus_reserves **dt_abacus_physical_reserves** (ABACUS Reserves) - Base View: `dt_abacus_physical_reserves` - View Type: Derived Table - Data Source: Derived from: Prod_Royalty_Accounting_Royalty_Accounting.Abacus_Event, Prod_Roya... #### Model: abacus_royaltyshare_mechanicals **dt_abacus_royaltyshare_mechanical_deduction** (Transaction Country) - Base View: `dt_abacus_royaltyshare_mechanical_deduction` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... #### Model: abacus_sax_agreement_denormalized **royalty_accounting_prod_sax_agreement_denorm** (ABACUS Contract) - Base View: `royalty_accounting_prod_sax_agreement_denorm` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.SAX_AGREEMENT_DENORM #### Model: abacus_settlement_feed **sony_internal_abacus_settlement_feed_history** (ABACUS Contract) - Base View: `sony_internal_abacus_settlement_feed_history` - View Type: Direct Table - Data Source: SONY_INTERNAL.PROD.ABACUS_SETTLEMENT_FEED_HISTORY #### Model: abacus_sync_account_lambda **dt_abacus_sync_account_lambda** (Vendor Details) - Base View: `dt_abacus_sync_account_lambda` - View Type: Derived Table - Data Source: Derived from: Prod.Vw_Dim_Abacus_Account, Prod.Vw_Dim_Abacus_Ar_Vendor, Royalty_... #### Model: abacus_tap_account_payee_kyc_notification **orch_app_prod_royalty_accounting_account_payee_kyc_notification** (ABACUS Account) - Base View: `orch_app_prod_royalty_accounting_account_payee_kyc_notification` - View Type: Derived Table - Data Source: ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ACCOUNT_PAYE... **orch_app_qa_royalty_accounting_account_payee_kyc_notification** (ABACUS Account) - Base View: `orch_app_qa_royalty_accounting_account_payee_kyc_notification` - View Type: Derived Table - Data Source: ORCHARD_APP_REPORTING_V2.QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ACCOUNT_PAYEE_... #### Model: abacus_tap_advances **dt_abacus_tap_advances** (ABACUS Contract) - Base View: `dt_abacus_tap_advances` - View Type: Derived Table - Data Source: Derived from: Prod.Currency_Exchange_Rates, Prod.Dim_Currency, Prod.Vw_Dim_Abacu... #### Model: abacus_tap_closing_bal_tax_rev **dt_abacus_tap_closing_bal_taxable_rev_prod** (ABACUS Contract Lifecycle) - Base View: `dt_abacus_tap_closing_bal_taxable_rev_prod` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... **dt_abacus_tap_closing_bal_taxable_rev_qa** (ABACUS Contract Lifecycle) - Base View: `dt_abacus_tap_closing_bal_taxable_rev_qa` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Qa_Royalty_Acco... #### Model: abacus_tap_payable_balances_export_qa **dt_abacus_tap_payable_balances_export_qa** (ABACUS Contract Lifecycle) - Base View: `dt_abacus_tap_payable_balances_export_qa` - View Type: Derived Table - Data Source: Derived from: Qa_Royalty_Accounting_Royalty_Accounting.Abacus_State, Qa_Royalty_... #### Model: abacus_tap_payment_custom **orch_app_prod_royalty_accounting_worksheet_payment_custom** (TAP Custom Payments [PROD]) - Base View: `orch_app_prod_royalty_accounting_worksheet_payment_custom` - View Type: Direct Table - Data Source: ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.WORKSHEET_PA... **orch_app_qa_royalty_accounting_worksheet_payment_custom** (TAP Custom Payments [QA]) - Base View: `orch_app_qa_royalty_accounting_worksheet_payment_custom` - View Type: Direct Table - Data Source: ORCHARD_APP_REPORTING_V2.QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.WORKSHEET_PAYM... #### Model: abacus_tap_tax_correction **orch_app_prod_royalty_accounting_worksheet_tax_correction** (Tax Correction) - Base View: `orch_app_prod_royalty_accounting_worksheet_tax_correction` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... **orch_app_prod_royalty_accounting_worksheet_tax_correction_vat** (Tax Correction VAT) - Base View: `orch_app_prod_royalty_accounting_worksheet_tax_correction_vat` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Ac... #### Model: abacus_tap_tax_correction_qa **orch_app_qa_royalty_accounting_worksheet_tax_correction** (Tax Correction) - Base View: `orch_app_qa_royalty_accounting_worksheet_tax_correction` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Qa_Royalty_Acco... **orch_app_qa_royalty_accounting_worksheet_tax_correction_vat** (Tax Correction VAT) - Base View: `orch_app_qa_royalty_accounting_worksheet_tax_correction_vat` - View Type: Derived Table - Data Source: Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Qa_Royalty_Acco... #### Model: abacus_terms_of_product_exceptions **dt_terms_of_product_exceptions** (ABACUS Account) - Base View: `dt_terms_of_product_exceptions` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country, Prod.Dim_Transactiontype, Prod.Vw_Denorm_Contrac... #### Model: abacus_terms_of_track_exceptions **dt_terms_of_track_exceptions** (ABACUS Account) - Base View: `dt_terms_of_track_exceptions` - View Type: Derived Table - Data Source: Derived from: Prod.Dim_Country, Prod.Dim_Transactiontype, Prod.Vw_Denorm_Contrac... #### Model: abacus_unallocated_sales_distro_accounting_period **ROYALTY_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD** (Unallocated Sales) - Base View: `ROYALTY_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_UNALLOCATED_SALES_DISTRO_ACCOUNTING_PERIOD #### Model: abacus_unallocated_sales_distro_statement_period **ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD** (Statement Period) - Base View: `ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD #### Model: abacus_unallocated_sales_distro_unique_details **ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS** (Earliest Accounting Period) - Base View: `ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_ABACUS_UNALLOCATED_SALES_DISTRO_UNIQUE_DETAILS #### Model: abacus_unallocated_sales_nr_statement_period **royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period** (Statement Period) - Base View: `royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period` - View Type: Direct Table - Data Source: ROYALTY_ACCOUNTING_REPORTING.PROD.VW_ABACUS_UNALLOCATED_SALES_NR_STATEMENT_PERIO... #### Model: abacus_upc_to_contract_mapping **royalty_accounting_prod_vw_upc_to_contract** (ABACUS Account) - Base View: `royalty_accounting_prod_vw_upc_to_contract` - View Type: Derived Table - Data Source: ROYALTY_ACCOUNTING.PROD.VW_UPC_TO_CONTRACT_MAPPING #### Model: abacus_upc_to_contract_mapping_uat **royalty_accounting_uat_vw_upc_to_contract** (ABACUS Account) - Base View: `royalty_accounting_uat_vw_upc_to_contract` - View Type: Derived Table - Data Source: ROYALTY_ACCOUNTING.UAT.VW_UPC_TO_CONTRACT_MAPPING #### Model: abacus_upc_to_contract_qa **dev_hsingh_upc_to_contract** (ABACUS Account) - Base View: `dev_hsingh_upc_to_contract` - View Type: Derived Table - Data Source: ROYALTY_ACCOUNTING.QA.VW_UPC_TO_CONTRACT_MAPPING #### Model: dt_revenue_by_contract **dt_revenue_by_contract** (ABACUS Account) - Base View: `dt_revenue_by_contract` - View Type: Direct Table - Data Source: royalty_accounting_reporting.prod.vw_abacus_balances_looker_v2 #### Model: oa_banking_migration **dt_oa_banking_migration** (Banking Migration Status) - Base View: `dt_oa_banking_migration` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Pr... #### Model: periscope_report **dt_periscope_report** (Periscope Report) - Base View: `dt_periscope_report` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_A... **dt_periscope_report2** (Periscope Report2) - Base View: `dt_periscope_report2` - View Type: Derived Table - Data Source: Derived from: Art_Relations_Prod_Art_Relations.Release_Status, Art_Relations_Pro... #### Model: raw_abacus_sales_file **royalty_accounting_prod_stmt_db_sales_distro** (Sales File) - Base View: `royalty_accounting_prod_stmt_db_sales_distro` - View Type: Direct Table - Data Source: royalty_accounting.prod.stmt_db_sales_distro ## Impact Analysis Guide ### Making Changes Safely 1. **Before changing a database table:** - Check "Views by Data Source" section above - Identify all views that use the table - Review explores that depend on those views 2. **Before modifying a view:** - Check which models include the view - Review explores that use the view as base - Consider downstream reporting impact 3. **Before changing a model:** - Review all explores in the model - Check business usage of those explores - Coordinate with report consumers ### Complexity Indicators - **High Line Count Views**: Complex business logic, may need optimization - **Many Source Tables**: Complex joins, potential performance impact - **Multiple Dependencies**: Changes have wide impact, need careful testing