Index of /database/snowflake/ROYALTY_ACCOUNTING/build/changelog/dml

Name ↓SizeModified
⬆..📁view-2026-09-14 06:27📄WIZ-2802-check-connection.sql383 B2026-07-13 03:27📄WAR-1046-truncate_revenue_analysis_tables_QA.sql727 B2026-07-13 03:27📄TAP-548-snapshot-out-of-sync-payoneer-data.sql1.5 KB2026-07-13 03:27📄MAINT_backfill_nr_sales_outage.sql6.2 KB2026-07-13 03:27📄MAINT_backfill_dig_sales_outage.sql6.7 KB2026-07-13 03:27📄MAINT-truncate-prod-stmt_db_sales_nr_staging.sql233 B2026-07-13 03:27📄MAINT-truncate-prod-stmt_db_sales_distro_staging.sql273 B2026-07-13 03:27📄MAINT-roll-unprocessed-sales-from-accounting-period-1-back-into-distro-staging.sql2.1 KB2026-07-13 03:27📄MAINT-populate-currency-map.sql3.4 KB2026-07-13 03:27📄INT-2121-Update-IS_EXCLUDE_FROM_SAP-in-STMT_DB_SALES_DISTRO-for-313-rollover.sql1.9 KB2026-07-13 03:27📄INT-2121-Update-IS_EXCLUDE_FROM_SAP-in-STMT_DB_SALES_DISTRO-for-312-rollover.sql1.9 KB2026-07-13 03:27📄INT-2121-Update-IS_EXCLUDE_FROM_SAP-in-STMT_DB_SALES_DISTRO-for-311-rollover-and-310-rollover.sql2.1 KB2026-07-13 03:27📄INT-2097-Update-ACTUAL_STATMENT_NOs-in-STMT_DB_SALES_DISTRO-for-P313-rollover.sql1.4 KB2026-07-13 03:27📄INT-2097-Update-ACTUAL_STATMENT_NOs-in-STMT_DB_SALES_DISTRO-for-P312-rollover-V2.sql1.3 KB2026-07-13 03:27📄INT-2097-Update-ACTUAL_STATMENT_NOs-in-STMT_DB_SALES_DISTRO-for-P311-rollover.sql1.5 KB2026-07-13 03:27📄INT-2097-Update-ACTUAL_STATMENT_NOs-in-STMT_DB_SALES_DISTRO-for-P310-rollover.sql1.4 KB2026-07-13 03:27📄FR-98-update-sax_agreement_denormalised-table.sql9.8 KB2026-07-13 03:27📄FR-80-create-table-sax_agreement_denorm.sql5.1 KB2026-07-13 03:27📄FR-79-create-table-sax_agreement_denorm_base.sql9.9 KB2026-07-13 03:27📄FR-66-update-view-unallocated-sales-by-statement-period.sql5.0 KB2026-07-13 03:27📄FR-65-update-view-vw_dim_abacus_account.sql3.1 KB2026-07-13 03:27📄FR-64-create-view-for-adjustments.sql3.7 KB2026-07-13 03:27📄FR-64-create-table-denorm_transaction_types.sql1.0 KB2026-07-13 03:27📄FR-64-create-table-denorm_stores-and-denorm_countries.sql2.2 KB2026-07-13 03:27📄FR-64-create-table-denorm_products.sql3.1 KB2026-07-13 03:27📄FR-64-create-table-contract_denormalized.sql3.7 KB2026-07-13 03:27📄FR-63-create-table-sax_territory_to_orchard_iso.sql684 B2026-07-13 03:27📄FR-63-create-table-sax_right_type_to_orchard_transaction_type.sql819 B2026-07-13 03:27📄FR-63-create-table-sax_migration_active_rights_2022_10_18.sql2.0 KB2026-07-13 03:27📄FR-59-create-view-vw_denorm_stores-and-vw_denorm_countries.sql3.0 KB2026-07-13 03:27📄FR-58-create-view-vw_denorm_transaction_types.sql1.4 KB2026-07-13 03:27📄FR-57-create-view-vw_denorm_products.sql3.4 KB2026-07-13 03:27📄FR-56-add-subdistributor-vw_abacus_fact_sales_distro.sql8.9 KB2026-07-13 03:27📄FR-56-add-grants-vw_abacus_fact_sales_distro.sql409 B2026-07-13 03:27📄FR-55-add-subdistributor-vw_abacus_fact_sales_distro_v2_staging.sql10.4 KB2026-07-13 03:27📄FR-54-add-subdistributor-vw_abacus_fact_sales_distro_v2.sql10.4 KB2026-07-13 03:27📄FR-53-add_sap_business_group_to_vw_dim_abacus_contract.sql3.9 KB2026-07-13 03:27📄FR-52-create-view-vw_abacus_balances_staging.sql6.3 KB2026-07-13 03:27📄FR-48-adding-current-bal-to-vw-dim-abacus-contract.sql3.8 KB2026-07-13 03:27📄FR-47-update-view-condition-vw_contract_term_sax_schedule_v2.sql994 B2026-07-13 03:27📄FR-47-update-condition-to-vw_contract_term_schedule.sql1.6 KB2026-07-13 03:27📄FR-46-create-view-vw_contract_denormalized.sql4.0 KB2026-07-13 03:27📄FR-44-update-vw_abacus_balances_looker-to-not-filter-run_controller.sql9.8 KB2026-07-13 03:27📄FR-43-fix-tuid-fanout-vw_abacus_fact_sales_distro_v2_staging.sql10.4 KB2026-07-13 03:27📄FR-42-fix-tuid-vw_abacus_fact_sales_distro_v2.sql10.4 KB2026-07-13 03:27📄FR-41-add-account_id-to-vw_dim_abacus_contract.sql3.3 KB2026-07-13 03:27📄FR-39-add-tuid-to-vw_abacus_fact_sales_distro_v2_2.sql10.0 KB2026-07-13 03:27📄FR-39-add-tuid-to-vw_abacus_fact_sales_distro_staging_2.sql10.0 KB2026-07-13 03:27📄FR-38-create-view-vw_abacus_fact_sales_distro_staging.sql9.9 KB2026-07-13 03:27📄FR-37-add_artistid_vw_abacus_fact_sales_distro_v2.sql9.9 KB2026-07-13 03:27📄FR-32-update-view-vw_contract_term_schedule.sql1.4 KB2026-07-13 03:27📄FR-32-create-view-vw_contract_term_schedule-v2.sql1.3 KB2026-07-13 03:27📄FR-31-update-view-vw_contract_term_right_block.sql1.5 KB2026-07-13 03:27📄FR-31-create-view-vw_contract_term_right_block-v2.sql1.4 KB2026-07-13 03:27📄FR-28-grant-access-vw_dim_abacus_contract.sql751 B2026-07-13 03:27📄FR-28-create-view-vw_dim_abacus_contract.sql2.7 KB2026-07-13 03:27📄FR-27-create_view_dim_abacus_account.sql2.8 KB2026-07-13 03:27📄FR-21-create-view-vw_abacus_balances_staging.sql3.9 KB2026-07-13 03:27📄FR-155-rollover-NR-sales-into-297.sql2.5 KB2026-07-13 03:27📄FR-154-distribution-rollover-sales-from-296-to-297.sql2.6 KB2026-07-13 03:27📄FR-14_update_vw_abacus_unallocated_sales_distro_unique_details.sql5.1 KB2026-07-13 03:27📄FR-14_create_view_vw_abacus_unallocated_sales_distro_unique_details.sql4.5 KB2026-07-13 03:27📄FR-138-rollover-NR-sales-into-296.sql2.5 KB2026-07-13 03:27📄FR-137-rollover-distro-sales-from-295-to-296.sql2.6 KB2026-07-13 03:27📄FR-115-rollover-distro-sales-from-294-to-295.sql2.6 KB2026-07-13 03:27📄FR-114-rollover-NR-sales-into295.sql2.5 KB2026-07-13 03:27📄FR-11-update_vw_abacus_unallocated_sales_distro_statement_period.sql4.9 KB2026-07-13 03:27📄FR-11-create_view_vw_abacus_unallocated_sales_distro_statement_period.sql4.6 KB2026-07-13 03:27📄FR-106-add-columns-to-vw_abacus_fact_sales_distro_v2.sql10.6 KB2026-07-13 03:27📄FR-10-update-vw-abacus-unallocated-sales-distro-accounting.sql4.7 KB2026-07-13 03:27📄FR-10-create-view-vw-abacus-unallocated-sales-distro-accounting.sql4.5 KB2026-07-13 03:27📄FR-1-add_projectid_vw_abacus_fact_sales_distro_v2.sql9.8 KB2026-07-13 03:27📄ACC-9917_sequester-sales-account-22449.sql845 B2026-07-13 03:27📄ACC-9803-rollover-324-unallocated-distro-sales.sql2.8 KB2026-07-13 03:27📄ACC-9803-delete-324-rollover-distro-sales.sql1.3 KB2026-07-13 03:27📄ACC-9188_sequester-sales-account-72559.sql12.7 KB2026-07-13 03:27📄ACC-8949_update_unique_detail_id_in_sales_data.sql237 B2026-07-13 03:27📄ACC-8900-populate-snapshot-table-with-terminated-contracts.sql9.8 KB2026-07-13 03:27📄ACC-8900-2_populate_snapshot_table.sql8.8 KB2026-07-13 03:27📄ACC-8798_delete_bad_sales_data.sql1.3 KB2026-07-13 03:27📄ACC-8644_delete_above_accounting_run_426.sql672 B2026-07-13 03:27📄ACC-8642_reset_sales_distro_batch_id_317_2.sql1.3 KB2026-07-13 03:27📄ACC-8642_reset_sales_distro_batch_id_317.sql1.2 KB2026-07-13 03:27📄ACC-8633-delete-sequestered-sales-from-STMT_DB_SALES_DISTRO-and-STMT_DB_SALES_DISTRO_STAGING.sql15.6 KB2026-07-13 03:27📄ACC-8615-sequest-sales-period-317.sql5.8 KB2026-07-13 03:27📄ACC-8403-delete-spotify-and-test-sales-records.sql753 B2026-07-13 03:27📄ACC-8328-fix-p313-rollover-batch.sql803 B2026-07-13 03:27📄ACC-8111-distribution-rollover-sales-from-312-to-313.sql2.8 KB2026-07-13 03:27📄ACC-8110-rollover-NR-sales-from-312-to-313.sql2.5 KB2026-07-13 03:27📄ACC-8089-contract-534573-549174-period-312.sql2.6 KB2026-07-13 03:27📄ACC-8043-delete-sales-ingest-test.sql276 B2026-07-13 03:27📄ACC-7976-sequester-sales-acct-71137.sql1.1 KB2026-07-13 03:27📄ACC-7965-rollover-NR-sales-from-311-to-312.sql2.5 KB2026-07-13 03:27📄ACC-7964-distribution-rollover-sales-from-311-to-312.sql2.8 KB2026-07-13 03:27📄ACC-7876-DELETE-test-stmt-db-rollover310.sql360 B2026-07-13 03:27📄ACC-7853-rollover-NR-sales-from-310-to-311.sql2.5 KB2026-07-13 03:27📄ACC-7852-distribution-rollover-sales-from-310-to-311.sql2.8 KB2026-07-13 03:27📄ACC-7725-rollover-NR-sales-from-309-to-310.sql2.5 KB2026-07-13 03:27📄ACC-7724-distribution-rollover-sales-from-309-to-310.sql2.6 KB2026-07-13 03:27📄ACC-7612-rollover-NR-sales-from-308-to-309.sql2.5 KB2026-07-13 03:27📄ACC-7611-distribution-rollover-sales-from-308-to-309.sql2.6 KB2026-07-13 03:27📄ACC-7535-distribution-rollover-sales-from-3067-to-308.sql2.6 KB2026-07-13 03:27📄ACC-7534-rollover-NR-sales-from-307-to-308.sql2.5 KB2026-07-13 03:27📄ACC-7477-DELETE-test-stmt-db-307.sql999 B2026-07-13 03:27📄ACC-7444-rollover-NR-sales-from-306-to-307.sql2.5 KB2026-07-13 03:27📄ACC-7443-distribution-rollover-sales-from-306-to-307.sql2.6 KB2026-07-13 03:27📄ACC-7438-sequester-sales-acct-54324.sql2.0 KB2026-07-13 03:27📄ACC-7361-distribution-rollover-sales-from-305-to-306.sql2.6 KB2026-07-13 03:27📄ACC-7360-rollover-NR-sales-from-305-to-306.sql2.5 KB2026-07-13 03:27📄ACC-7283-5_kosovo_corrections.sql3.7 KB2026-07-13 03:27📄ACC-7249-2_reversal_for_533665_p302.sql2.0 KB2026-07-13 03:27📄ACC-7211-rollover-NR-sales-from-304-to-305.sql2.5 KB2026-07-13 03:27📄ACC-7210-distribution-rollover-sales-from-304-to-305.sql2.6 KB2026-07-13 03:27📄ACC-7200-reverse-henrycastle_mau5trap.sql3.2 KB2026-07-13 03:27📄ACC-7151-rollover-NR-sales-from-303-to-304.sql2.5 KB2026-07-13 03:27📄ACC-7150-distribution-rollover-sales-from-303-to-304.sql2.6 KB2026-07-13 03:27📄ACC-7104_add_transaction_subtype.sql342 B2026-07-13 03:27📄ACC-7039-distribution-rollover-sales-from-302-to-303.sql2.6 KB2026-07-13 03:27📄ACC-6923-rollover-NR-sales-from-301-to-302.sql2.5 KB2026-07-13 03:27📄ACC-6922-distribution-rollover-sales-from-301-to-302.sql2.6 KB2026-07-13 03:27📄ACC-6795-make-sales-reeligible.sql182 B2026-07-13 03:27📄ACC-6759-rollover-NR-sales-from-300-to-301.sql2.5 KB2026-07-13 03:27📄ACC-6758-distribution-rollover-sales-from-300-to-301.sql2.6 KB2026-07-13 03:27📄ACC-6694-contract-535720-536572-reversal-contrib-only-dup-288.sql2.3 KB2026-07-13 03:27📄ACC-6694-contract-535720-536572-correction-contrib-only-dup-288.sql2.4 KB2026-07-13 03:27📄ACC-6631-distribution-rollover-sales-from-299-to-300.sql2.6 KB2026-07-13 03:27📄ACC-6630-rollover-NR-sales-from-299-to-300.sql2.5 KB2026-07-13 03:27📄ACC-6550-rollover-NR-sales-from-298-to-299.sql2.5 KB2026-07-13 03:27📄ACC-6540-distribution-rollover-sales-from-298-to-299.sql2.6 KB2026-07-13 03:27📄ACC-6438-rollover-NR-sales-from-297-to-298.sql2.5 KB2026-07-13 03:27📄ACC-6421-cleanup-contract-txn-nr-staging.sql1.0 KB2026-07-13 03:27📄ACC-6421-backfill-contract-txn-term-rate.sql754 B2026-07-13 03:27📄ACC-6351-contracts-534587-534593-correction-fx-math-dups-286.sql4.7 KB2026-07-13 03:27📄ACC-6351-contracts-534484-535491-correction-fx-math-dups-286.sql4.7 KB2026-07-13 03:27📄ACC-6347-reverse-fx-math-285.sql1.8 KB2026-07-13 03:27📄ACC-6347-correction-fx-math-285.sql1.8 KB2026-07-13 03:27📄ACC-6337-add-transaction-subtype.sql344 B2026-07-13 03:27📄ACC-6236-reverse-contributor-only-286.sql1.7 KB2026-07-13 03:27📄ACC-6236-correct-contributor-only-286.sql1.5 KB2026-07-13 03:27📄ACC-6236-4-correct-contributor-only-286.sql1.5 KB2026-07-13 03:27📄ACC-6236-3-reverse-contributor-only-286.sql1.7 KB2026-07-13 03:27📄ACC-6087-backfill-nr-contract-txn-id-dupes-2.sql2.8 KB2026-07-13 03:27📄ACC-6087-backfill-nr-contract-txn-id-dupes-1.sql3.6 KB2026-07-13 03:27📄ACC-6086-4-correct-fx-math-286.sql1.5 KB2026-07-13 03:27📄ACC-6086-3-reverse-fx-math-286.sql1.6 KB2026-07-13 03:27📄ACC-6086-2-correct-fx-math-285.sql1.5 KB2026-07-13 03:27📄ACC-6086-1-reverse-fx-math-285.sql1.5 KB2026-07-13 03:27📄ACC-5927-rollover-292-distro-unallocated-sales.sql2.6 KB2026-07-13 03:27📄ACC-5828-rollover-291-nr-unallocated-sales.sql2.5 KB2026-07-13 03:27📄ACC-5827-rollover-291-distro-unallocated-sales.sql2.6 KB2026-07-13 03:27📄ACC-5814-rollover-291-distro-unallocated-sales.sql2.7 KB2026-07-13 03:27📄ACC-5751-fix-contract-txn-backfill.sql3.0 KB2026-07-13 03:27📄ACC-5744-backfill-nr-contract-txn-id.sql4.4 KB2026-07-13 03:27📄ACC-5744-backfill-distro-contract-txn-id.sql1.3 KB2026-07-13 03:27📄ACC-5740-rollover-290-nr-unallocated-sales.sql2.5 KB2026-07-13 03:27📄ACC-5739-rollover-290-distro-unallocated-sales.sql2.6 KB2026-07-13 03:27📄ACC-5629-rollover-distro-unallocated-sales-from-289-to-290.sql2.6 KB2026-07-13 03:27📄ACC-5628-rollover-NR-unallocated-sales-from-289-to-290.sql2.5 KB2026-07-13 03:27📄ACC-5502-carry-unallocated-288-nr-sales-into-289.sql2.4 KB2026-07-13 03:27📄ACC-5501-carry-unallocated-288-distro-sales-into-289.sql5.4 KB2026-07-13 03:27📄ACC-5452-rollover-sales-for-AWAL-jungle-only.sql5.4 KB2026-07-13 03:27📄ACC-5439-distribution-rollover-sales-from-297-to-298.sql2.6 KB2026-07-13 03:27📄ACC-5385-approve-288-NR-accounting-run.sql359 B2026-07-13 03:27📄ACC-5384-snapshot-nr-sales-288.sql1.8 KB2026-07-13 03:27📄ACC-5370-carry-unallocated-287-distro-sales-into-288.sql10.3 KB2026-07-13 03:27📄ACC-5346-backfill-contract_transaction-final_tables.sql1.6 KB2026-07-13 03:27📄ACC-5306-backfill-arr-distro-tables.sql3.2 KB2026-07-13 03:27📄ACC-5283-approve-287-NR-accounting-run.sql361 B2026-07-13 03:27📄ACC-5256-snapshot-nr-sales-287.sql1.8 KB2026-07-13 03:27📄ACC-5245-carry-unallocated-287-nr-sales-into-288.sql2.4 KB2026-07-13 03:27📄ACC-5245-carry-unallocated-287-distro-sales-into-287.sql15.7 KB2026-07-13 03:27📄ACC-5245-carry-unallocated-286-nr-sales-into-287.sql2.3 KB2026-07-13 03:27📄ACC-5158-stage-286-manual-acct-run-results.sql9.0 KB2026-07-13 03:27📄ACC-5138-rollover-sales-from-sales-file-id-8.sql2.7 KB2026-07-13 03:27📄ACC-5137-rollover-sales-from-sales-file-id-7.sql2.6 KB2026-07-13 03:27📄ACC-5136-rollover-sales-from-sales-file-id-4.sql3.7 KB2026-07-13 03:27📄ACC-5121-stage-run-75-results.sql2.3 KB2026-07-13 03:27📄ACC-5121-remove-approved-run-results.sql374 B2026-07-13 03:27📄ACC-5120-approve-NR-accounting-run.sql359 B2026-07-13 03:27📄ACC-5102-snapshot-nr-sales-286.sql1.8 KB2026-07-13 03:27📄ACC-5092-carry-unallocated-285-nr-sales-into-286.sql2.3 KB2026-07-13 03:27📄ACC-5056-fix-285-sales-txns.sql15.2 KB2026-07-13 03:27📄ACC-5049-snapshot-nr-sales.sql959 B2026-07-13 03:27📄ACC-5015-fix-batch-1-sales-txns-awal-products-in-wrong-vendor.sql4.3 KB2026-07-13 03:27📄ACC-4994-approve-NR-accounting-run.sql359 B2026-07-13 03:27📄ACC-4978-update-taylor-sales-from-67155-to-67046.sql5.1 KB2026-07-13 03:27📄ACC-4611-clear-prod-for-gda-launch.sql494 B2026-07-13 03:27📄ACC-10350-sequester-rollover-sales-for-account-22449.sql1.5 KB2026-07-13 03:27