# Abacus Looker Documentation

Generated on: 2026-07-02 19:41:56

## Project Overview

This repository contains 66 Looker models and 209 views for the Abacus system.

## Quick Navigation

- [Models Documentation](models/model-inventory.md) - Complete list of all Looker models
- [Views Documentation](views/view-inventory.md) - Complete list of all Looker views  
- [Explores Catalog](explores/explore-catalog.md) - All available explores
- [Data Lineage](data-lineage/dependency-map.md) - View and model dependencies
- [Usage Reports](reports/usage-analysis.md) - Analysis and statistics

## Models Summary

| Model | Label | Connection | Explores | Views Used |
|-------|-------|------------|----------|------------|
| [Abacus_Replace_Double_book_transact](models/Abacus_Replace_Double_book_transact.model.md) | ABACUS | abacus-looker | 1 | 1 |
| [abacus-looker](models/abacus-looker.model.md) | ABACUS | abacus-looker | 1 | 9 |
| [abacus_adjustments](models/abacus_adjustments.model.md) | ABACUS | abacus-looker | 2 | 14 |
| [abacus_balance_report](models/abacus_balance_report.model.md) | ABACUS | abacus-looker | 2 | 22 |
| [abacus_balances](models/abacus_balances.model.md) | ABACUS | abacus-looker | 1 | 17 |
| [abacus_balances_staging](models/abacus_balances_staging.model.md) | ABACUS | abacus-looker | 1 | 9 |
| [abacus_balances_staging_qa](models/abacus_balances_staging_qa.model.md) | ABACUS | abacus-looker | 1 | 9 |
| [abacus_batch_adjustments](models/abacus_batch_adjustments.model.md) | ABACUS | abacus-looker | 4 | 14 |
| [abacus_contract](models/abacus_contract.model.md) | ABACUS | abacus-looker | 1 | 13 |
| [abacus_contract_advance](models/abacus_contract_advance.model.md) | ABACUS | abacus-looker | 1 | 9 |
| [abacus_contract_denormalized](models/abacus_contract_denormalized.model.md) | ABACUS | abacus-looker | 1 | 14 |
| [abacus_contract_history](models/abacus_contract_history.model.md) | ABACUS | abacus-looker | 2 | 11 |
| [abacus_contract_history_qa](models/abacus_contract_history_qa.model.md) | ABACUS | abacus-looker | 1 | 1 |
| [abacus_contract_lifecycle_prod](models/abacus_contract_lifecycle_prod.model.md) | ABACUS | abacus-looker | 1 | 6 |
| [abacus_contract_lifecycle_qa](models/abacus_contract_lifecycle_qa.model.md) | ABACUS | abacus-looker | 2 | 5 |
| [abacus_contract_mech_deduction_history](models/abacus_contract_mech_deduction_history.model.md) | ABACUS | abacus-looker | 1 | 4 |
| [abacus_contract_qa](models/abacus_contract_qa.model.md) | ABACUS | abacus-looker | 1 | 8 |
| [abacus_distro_sales](models/abacus_distro_sales.model.md) | ABACUS | abacus-looker | 1 | 1 |
| [abacus_double_booked_transactions](models/abacus_double_booked_transactions.model.md) | ABACUS | abacus-looker | 2 | 2 |
| [abacus_expenses](models/abacus_expenses.model.md) | ABACUS | abacus-looker | 2 | 8 |
| [abacus_fact_contract_history](models/abacus_fact_contract_history.model.md) | ABACUS | abacus-looker | 1 | 11 |
| [abacus_fact_sales](models/abacus_fact_sales.model.md) | ABACUS | abacus-looker | 1 | 85 |
| [abacus_fact_sales_nr](models/abacus_fact_sales_nr.model.md) | ABACUS | abacus-looker | 1 | 14 |
| [abacus_fact_sales_qa](models/abacus_fact_sales_qa.model.md) | ABACUS | abacus-looker | 1 | 34 |
| [abacus_fact_sales_staging](models/abacus_fact_sales_staging.model.md) | ABACUS | abacus-looker | 1 | 30 |
| [abacus_fact_sales_staging_qa](models/abacus_fact_sales_staging_qa.model.md) | ABACUS | abacus-looker | 1 | 29 |
| [abacus_fact_sales_unified_monitoring](models/abacus_fact_sales_unified_monitoring.model.md) | ABACUS | abacus-looker | 1 | 8 |
| [abacus_flowthrough_manual_adjustments](models/abacus_flowthrough_manual_adjustments.model.md) | ABACUS | abacus-looker | 4 | 10 |
| [abacus_ledger_account_contract_integrity](models/abacus_ledger_account_contract_integrity.model.md) | ABACUS | abacus-looker | 1 | 1 |
| [abacus_looker](models/abacus_looker.model.md) | ABACUS | abacus-looker | 4 | 13 |
| [abacus_mech_deduction_by_contract](models/abacus_mech_deduction_by_contract.model.md) | ABACUS | abacus-looker | 2 | 10 |
| [abacus_monthly_comparison](models/abacus_monthly_comparison.model.md) | ABACUS | abacus-looker | 2 | 5 |
| [abacus_nr_sales](models/abacus_nr_sales.model.md) | ABACUS | abacus-looker | 1 | 1 |
| [abacus_oa_contract_monitoring](models/abacus_oa_contract_monitoring.model.md) | ABACUS | abacus-looker | 1 | 8 |
| [abacus_oa_contract_monitoring_dev](models/abacus_oa_contract_monitoring_dev.model.md) | ABACUS | abacus-looker | 1 | 8 |
| [abacus_orphaned_products](models/abacus_orphaned_products.model.md) | ABACUS | abacus-looker | 4 | 12 |
| [abacus_payment_approval_file](models/abacus_payment_approval_file.model.md) | ABACUS | abacus-looker | 1 | 7 |
| [abacus_potential_double_booked_transactions](models/abacus_potential_double_booked_transactions.model.md) | ABACUS | abacus-looker | 2 | 3 |
| [abacus_product_exceptions](models/abacus_product_exceptions.model.md) | ABACUS | abacus-looker | 1 | 14 |
| [abacus_profiles](models/abacus_profiles.model.md) | ABACUS | abacus-looker | 1 | 2 |
| [abacus_remaps_report](models/abacus_remaps_report.model.md) | ABACUS | abacus-looker | 1 | 3 |
| [abacus_reserves](models/abacus_reserves.model.md) | ABACUS | abacus-looker | 1 | 2 |
| [abacus_royaltyshare_mechanicals](models/abacus_royaltyshare_mechanicals.model.md) | ABACUS | abacus-looker | 1 | 34 |
| [abacus_sax_agreement_denormalized](models/abacus_sax_agreement_denormalized.model.md) | ABACUS | abacus-looker | 1 | 5 |
| [abacus_settlement_feed](models/abacus_settlement_feed.model.md) | ABACUS Settlement Feed | abacus-looker | 1 | 9 |
| [abacus_sync_account_lambda](models/abacus_sync_account_lambda.model.md) | ABACUS | abacus-looker | 1 | 1 |
| [abacus_tap_account_payee_kyc_notification](models/abacus_tap_account_payee_kyc_notification.model.md) | ABACUS | abacus-looker | 2 | 9 |
| [abacus_tap_advances](models/abacus_tap_advances.model.md) | ABACUS | abacus-looker | 1 | 13 |
| [abacus_tap_closing_bal_tax_rev](models/abacus_tap_closing_bal_tax_rev.model.md) | ABACUS | abacus-looker | 2 | 11 |
| [abacus_tap_payable_balances_export_qa](models/abacus_tap_payable_balances_export_qa.model.md) | ABACUS | abacus-looker | 1 | 4 |
| [abacus_tap_payment_custom](models/abacus_tap_payment_custom.model.md) | ABACUS | abacus-looker | 2 | 9 |
| [abacus_tap_tax_correction](models/abacus_tap_tax_correction.model.md) | ABACUS | abacus-looker | 2 | 2 |
| [abacus_tap_tax_correction_qa](models/abacus_tap_tax_correction_qa.model.md) | ABACUS | abacus-looker | 2 | 2 |
| [abacus_terms_of_product_exceptions](models/abacus_terms_of_product_exceptions.model.md) | ABACUS | abacus-looker | 1 | 14 |
| [abacus_terms_of_track_exceptions](models/abacus_terms_of_track_exceptions.model.md) | ABACUS | abacus-looker | 1 | 14 |
| [abacus_unallocated_sales_distro_accounting_period](models/abacus_unallocated_sales_distro_accounting_period.model.md) | ABACUS | abacus-looker | 1 | 17 |
| [abacus_unallocated_sales_distro_statement_period](models/abacus_unallocated_sales_distro_statement_period.model.md) | ABACUS | abacus-looker | 1 | 16 |
| [abacus_unallocated_sales_distro_unique_details](models/abacus_unallocated_sales_distro_unique_details.model.md) | ABACUS | abacus-looker | 1 | 17 |
| [abacus_unallocated_sales_nr_statement_period](models/abacus_unallocated_sales_nr_statement_period.model.md) | ABACUS | abacus-looker | 1 | 10 |
| [abacus_upc_to_contract_mapping](models/abacus_upc_to_contract_mapping.model.md) | ABACUS | abacus-looker | 1 | 16 |
| [abacus_upc_to_contract_mapping_uat](models/abacus_upc_to_contract_mapping_uat.model.md) | ABACUS | abacus-looker | 1 | 16 |
| [abacus_upc_to_contract_qa](models/abacus_upc_to_contract_qa.model.md) | ABACUS | abacus-looker | 1 | 16 |
| [dt_revenue_by_contract](models/dt_revenue_by_contract.model.md) | ABACUS | abacus-looker | 1 | 19 |
| [oa_banking_migration](models/oa_banking_migration.model.md) | Banking Migration Status | abacus-looker | 1 | 1 |
| [periscope_report](models/periscope_report.model.md) | Periscope Report | abacus-looker | 2 | 3 |
| [raw_abacus_sales_file](models/raw_abacus_sales_file.model.md) | ABACUS | abacus-looker | 1 | 9 |


## Views Summary

Total views: 209

| View | Table Source | Dimensions | Measures |
|------|-------------|------------|----------|
| [REFERENCE_FLOWTHROUGH_CALCULATION](views/REFERENCE_FLOWTHROUGH_CALCULATION.md) | ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_R... | 2 | 0 |
| [dt_abacus_sync_account_lambda](views/dt_abacus_sync_account_lambda.md) | Derived from: Prod.Vw_Dim_Abacus_Account, Prod.Vw_... | 6 | 0 |
| [dt_abacus_tap_payable_balances_export_qa](views/dt_abacus_tap_payable_balances_export_qa.md) | Derived from: Qa_Royalty_Accounting_Royalty_Accoun... | 8 | 0 |
| [dt_contract_term_condition_denormalized](views/dt_contract_term_condition_denormalized.md) | Derived from: Orchard_App_Reporting_V2, Orchard_Ap... | 16 | 0 |
| [dt_oa_banking_migration](views/dt_oa_banking_migration.md) | Derived from: Art_Relations_Prod_Art_Relations.Orc... | 13 | 0 |
| [dt_periscope_report](views/dt_periscope_report.md) | Derived from: Art_Relations_Prod_Art_Relations.Art... | 12 | 0 |
| [dt_periscope_report2](views/dt_periscope_report2.md) | Derived from: Art_Relations_Prod_Art_Relations.Rel... | 14 | 0 |
| [dt_potential_double_booked_transactions_distro](views/dt_potential_double_booked_transactions_distro.md) | Derived from: Orchard_App_Reporting_V2, Orchard_Ap... | 53 | 0 |
| [facts_prod_identity](views/facts_prod_identity.md) | facts.prod.identity | 8 | 0 |
| [int_dbt_prod_restrictions_subaccount_substore](views/int_dbt_prod_restrictions_subaccount_substore.md) | restrictions_subaccount_substore | 2 | 0 |
| [int_dbt_prod_spatial_audio_delivery_history_search](views/int_dbt_prod_spatial_audio_delivery_history_search.md) | INTELLIGENCE.DBT_PROD.SPATIAL_AUDIO_DELIVERY_HISTO... | 10 | 0 |
| [orch_app_ar_country](views/orch_app_ar_country.md) | orchard_app_reporting_v2.art_relations_prod_art_re... | 6 | 1 |
| [orch_app_ar_distribution_format_media](views/orch_app_ar_distribution_format_media.md) | orchard_app_reporting_v2.art_relations_prod_art_re... | 2 | 0 |
| [orch_app_ar_royalty_accounting_contract_term_condition](views/orch_app_ar_royalty_accounting_contract_term_condition.md) | ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_R... | 12 | 0 |
| [orch_app_ar_royalty_accounting_payment_hold](views/orch_app_ar_royalty_accounting_payment_hold.md) | ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_R... | 7 | 0 |
| [orch_app_ar_track](views/orch_app_ar_track.md) | orch_app_ar_track_track_physical_joined | 35 | 2 |
| [orch_app_prod_royalty_accounting_worksheet_tax_correction_vat](views/orch_app_prod_royalty_accounting_worksheet_tax_correction_vat.md) | Derived from: Orchard_App_Reporting_V2, Orchard_Ap... | 20 | 0 |
| [royalty_accounting_prod_abacus_adjustments](views/royalty_accounting_prod_abacus_adjustments.md) | VW_ABACUS_ADJUSTMENTS_v2 | 28 | 0 |
| [royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period](views/royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period.md) | ROYALTY_ACCOUNTING_REPORTING.PROD.VW_ABACUS_UNALLO... | 20 | 3 |
| [stmt_db_prod_remaps_physical_duplicate](views/stmt_db_prod_remaps_physical_duplicate.md) | STMT_DB.PROD.REMAPS_PHYSICAL | 6 | 0 |

*Showing first 20 views. See [complete views inventory](views/view-inventory.md) for all 209 views.*