Index of /database/royalty_accounting/build/changelog/dml

Name ↓SizeModified
⬆..📄WAR-3490_update_self_bill_activity_period.sql311 B2026-07-13 03:27📄WAR-3420_update_self_bill_activity_period.sql291 B2026-07-13 03:27📄WAR-3414_attach_contract_id_to_pub_statements_supplemental.sql9.0 KB2026-07-13 03:27📄WAR-3414_attach_contract_id_to_pub_statements_p327.sql7.1 KB2026-07-13 03:27📄WAR-3414_attach_contract_id_to_pub_statements_p315_p318_p321.sql34.7 KB2026-07-13 03:27📄WAR-3414_attach_contract_id_to_pub_statements_p306_p309_p312.sql29.8 KB2026-07-13 03:27📄WAR-3414_attach_contract_id_to_pub_statements_p297_p300_p303.sql23.5 KB2026-07-13 03:27📄WAR-3414_attach_contract_id_to_pub_statements_p285_p288_p291_p294.sql22.1 KB2026-07-13 03:27📄WAR-3321_update_ledger_vat_summary.sql362 B2026-07-13 03:27📄WAR-3301_remove_ledger_vat_summary_entries.sql449 B2026-07-13 03:27📄WAR-3300_update_publishing_statements_to_publishing_detail.sql363 B2026-07-13 03:27📄WAR-3265_remove_ledger_vat_summary_entries.sql515 B2026-07-13 03:27📄WAR-3216_remove_ledger_vat_summary_entries.sql449 B2026-07-13 03:27📄WAR-3189_set_attachments_in_progress.sql17.0 KB2026-07-13 03:27📄WAR-3182_remove_ledger_vat_summary_entries.sql515 B2026-07-13 03:27📄WAR-3074_remove_ledger_vat_summary_entries.sql411 B2026-07-13 03:27📄WAR-3045_remove_ledger_vat_summary_entries.sql515 B2026-07-13 03:27📄WAR-2974_remove_ledger_vat_summary_entries.sql449 B2026-07-13 03:27📄WAR-2938_remove_string_nulls.sql324 B2026-07-13 03:27📄WAR-2860_backfill_statement_period_ids_for_legacy_types.sql529 B2026-07-13 03:27📄WAR-2801_update_uk_ledger_vat_summary_entries.sql2.1 KB2026-07-13 03:27📄WAR-2801_update_incorrect_ledger_vat_summary.sql41.9 KB2026-07-13 03:27📄WAR-2801_remove_ledger_vat_summary_collaborator_allocations.sql1.5 KB2026-07-13 03:27📄WAR-2801_remove_incorrect_ledger_vat_summary.sql567 B2026-07-13 03:27📄WAR-2688-delete_incorrect_invoices.sql661 B2026-07-13 03:27📄WAR-2667_delete_errored_documents.sql422 B2026-07-13 03:27📄WAR-2615_delete_incorrect_reports.sql670 B2026-07-13 03:27📄WAR-2613_undo_internal_attachment_regen.sql359 B2026-07-13 03:27📄WAR-2590_remove_ingested_vat.sql400 B2026-07-13 03:27📄WAR-2553_delete_stuck_attachments.sql436 B2026-07-13 03:27📄WAR-2512_change_report_number_format.sql404 B2026-07-13 03:27📄WAR-2288_set_activity_statement_period.sql488 B2026-07-13 03:27📄WAR-2198-update_reference_signing_entity_altafonte.sql1.1 KB2026-07-13 03:27📄WAR-2134_delete_stuck_statement_attachments.sql651 B2026-07-13 03:27📄WAR-2124_add_ledger_vat_summary.sql750 B2026-07-13 03:27📄WAR-2124_add_backfill_event.sql392 B2026-07-13 03:27📄WAR-2081_delete_backfilled_internal_attachments.sql253 B2026-07-13 03:27📄WAR-2010_delete_broken_nr_reports.sql645 B2026-07-13 03:27📄WAR-1553_set_is_reporting_only_for_backfill_vat.sql351 B2026-07-13 03:27📄WAR-1282_add_file_type_to_statement_attachmets.sql581 B2026-07-13 03:27📄WAR-1209_backfill_payoneer_program_id.sql21.9 KB2026-07-13 03:27📄WAR-1209_backfill_account_payment_term.sql643.0 KB2026-07-13 03:27📄WAR-1175-remove-incorrect-performer-revenue-attachments.sql531 B2026-07-13 03:27📄WAR-1131_remove_revenue_detail_reports.sql3.1 KB2026-07-13 03:27📄update-accounts-currencies_ACC-9806.sql2.0 KB2026-07-13 03:27📄TAP-NO-TICKET_rollback_errored_close_balance.sql501 B2026-07-13 03:27📄TAP-NO-TICKET_roll_back_close_balance.sql745 B2026-07-13 03:27📄TAP-975_insert_close_balance_states.sql533 B2026-07-13 03:27📄TAP-972_update_agreement_type.sql855 B2026-07-13 03:27📄TAP-971_update_payment_entity.sql1.0 KB2026-07-13 03:27📄TAP-969_update_payoneer_program.sql6.6 KB2026-07-13 03:27📄TAP-962_update_payoneer_program.sql8.0 KB2026-07-13 03:27📄TAP-958-update-payees.sql1.2 KB2026-07-13 03:27📄TAP-957_update_payment_entity.sql977 B2026-07-13 03:27📄TAP-956_update_payoneer_program.sql58.8 KB2026-07-13 03:27📄TAP-948-update-payees.sql2.6 KB2026-07-13 03:27📄TAP-947-update-payees.sql1.7 KB2026-07-13 03:27📄TAP-935-update-payee.sql1.4 KB2026-07-13 03:27📄TAP-934-fix-payoneer-program-ids.sql1.5 KB2026-07-13 03:27📄TAP-931-update-payment-currency.sql531 B2026-07-13 03:27📄TAP-914-update-paid-by.sql2.0 KB2026-07-13 03:27📄TAP-912-update-paid-by.sql731 B2026-07-13 03:27📄TAP-813_backfill_knr_last_payment_data.sql1.1 KB2026-07-13 03:27📄TAP-776_update_paid_by_values.sql542 B2026-07-13 03:27📄TAP-775_update_knr_last_payment_data.sql670 B2026-07-13 03:27📄TAP-774-update-payoneer-program-and-paid-by.sql1010 B2026-07-13 03:27📄TAP-759-update-paid-by.sql963 B2026-07-13 03:27📄TAP-730_add_contract_advance_test_cases.sql4.9 KB2026-07-13 03:27📄TAP-724_complete_knr_payments.sql3.8 KB2026-07-13 03:27📄TAP-723_insert_vat_reversal.sql2.2 KB2026-07-13 03:27📄TAP-722-change-payoneer-program.sql1.3 KB2026-07-13 03:27📄TAP-648-insert-advance-payment-methods.sql558 B2026-07-13 03:27📄TAP-622-update-payoneer-program.sql458 B2026-07-13 03:27📄TAP-3571_add_banking_details_review_for_awal_migration.sql3.9 KB2026-07-13 03:27📄TAP-3556-update_paid_by_orchard_de.sql410 B2026-07-13 03:27📄TAP-3555-update-account-payment-entity.sql378 B2026-07-13 03:27📄TAP-3540-tax-reset.sql1.1 KB2026-07-13 03:27📄TAP-3536_rollback_send_payment_event.sql776 B2026-07-13 03:27📄TAP-3419_backfill_payment_info.sql30.9 KB2026-07-13 03:27📄TAP-3408_undelete_accidentally_deleted_unapplied_adjustments.sql2.0 KB2026-07-13 03:27📄TAP-3403_add_altafonte_to_orchard_payoneer_programs.sql2.8 KB2026-07-13 03:27📄TAP-3401_rollback_send_payment_event.sql407 B2026-07-13 03:27📄TAP-3397-update-send-payment-states.sql719 B2026-07-13 03:27📄TAP-3394_rollback_close_balance_batch_5405.sql1.9 KB2026-07-13 03:27📄TAP-3385_soft_delete_stuck_advance_payment.sql1.0 KB2026-07-13 03:27📄TAP-3332-update-failed-advance-for-retry.sql964 B2026-07-13 03:27📄TAP-3299-migrate-awal-to-whitelabel-payment-type.sql1.5 KB2026-07-13 03:27📄TAP-3295_add_banking_details_review_for_awal_migration_diff.sql733 B2026-07-13 03:27📄TAP-3295_add_banking_details_review_for_awal_migration.sql855.0 KB2026-07-13 03:27📄TAP-3291_hide_reverted_advance.sql1.2 KB2026-07-13 03:27📄TAP-3291_fix_event_statement_period.sql662 B2026-07-13 03:27📄TAP-3291_create_advance_return_events.sql501 B2026-07-13 03:27📄TAP-3257-update-account-payment-eligibility.sql892 B2026-07-13 03:27📄TAP-3233-update-payment-minimums.sql21.5 KB2026-07-13 03:27📄TAP-3227-update-accounts-payment-type.sql6.0 KB2026-07-13 03:27📄TAP-3226-move-payee-program.sql1.4 KB2026-07-13 03:27📄TAP-3211_create_orchard_check_payments_group.sql542 B2026-07-13 03:27📄TAP-3208_correct_tax_treaty_claim_2.sql411 B2026-07-13 03:27📄TAP-3208_correct_tax_treaty_claim.sql825 B2026-07-13 03:27📄TAP-3199-update-90-days-schedules.sql22.1 KB2026-07-13 03:27📄TAP-3199-update-60-days-schedules.sql4.0 KB2026-07-13 03:27📄TAP-3199-update-45-days-schedules.sql17.8 KB2026-07-13 03:27📄TAP-3185_update_tax_eligibility.sql621 B2026-07-13 03:27📄TAP-3182_update_tax_eligibility_state.sql697 B2026-07-13 03:27📄TAP-3153_update_tax_eligibility.sql621 B2026-07-13 03:27📄TAP-3153_update_account_payment_method.sql386 B2026-07-13 03:27📄TAP-3152-reset-tax-eligibility.sql635 B2026-07-13 03:27📄TAP-3151_backfill_agreement_types.sql45.9 KB2026-07-13 03:27📄TAP-3151_add_agreement_types.sql348 B2026-07-13 03:27📄TAP-3151_add_agreement_type_program_mappings.sql613 B2026-07-13 03:27📄TAP-3150-update-ledger-entries.sql3.2 KB2026-07-13 03:27📄TAP-3148_backfill_payees_data.sql90.7 KB2026-07-13 03:27📄TAP-3147-soft-delete-advance-payment.sql373 B2026-07-13 03:27📄TAP-3145-move-payee-program.sql1.4 KB2026-07-13 03:27📄TAP-3144-reset-tax-eligibility.sql1.4 KB2026-07-13 03:27📄TAP-3132-update-tax-eligibility.sql623 B2026-07-13 03:27📄TAP-3128-move-payee-to-orchard-payoneer-eur-account-program.sql1.4 KB2026-07-13 03:27📄TAP-3126-add-reference-payable-detail-type.sql335 B2026-07-13 03:27📄TAP-3097-update-tax-eligibility.sql715 B2026-07-13 03:27📄TAP-3072_add_payment_entity_program_mapping.sql631 B2026-07-13 03:27📄TAP-3072_add_new_payoneer_program.sql349 B2026-07-13 03:27📄TAP-3066_update_period_and_date_for_reversals.sql1.4 KB2026-07-13 03:27📄TAP-3058_change_payoneer_program.sql439 B2026-07-13 03:27📄TAP-3055-delete-out-of-sync-advance.sql397 B2026-07-13 03:27📄TAP-3053_soft_delete_advance_payments.sql412 B2026-07-13 03:27📄TAP-3046_update_event_date_and_period.sql357 B2026-07-13 03:27📄TAP-3046_backfill_payment_details.sql6.1 KB2026-07-13 03:27📄TAP-3045-move-payee-to-orchard-payoneer-account-program.sql441 B2026-07-13 03:27📄TAP-3042-update-knr-vat-detail.sql274 B2026-07-13 03:27📄TAP-3011-soft-delete-advance-payment.sql373 B2026-07-13 03:27📄TAP-3001-move-payee-to-orchard-usd-wire-payoneer-program.sql441 B2026-07-13 03:27📄TAP-2979-move-payee-to-orchard-usd-payoneer-program.sql441 B2026-07-13 03:27📄TAP-2978-move-payee-to-orchard-payoneer-program.sql439 B2026-07-13 03:27📄TAP-2975_move_payee_back_to_whitelabel.sql437 B2026-07-13 03:27📄TAP-2969_hide_reversal_events_for_duplicated_payments.sql1.5 KB2026-07-13 03:27📄TAP-2960_fix_eligibility_states.sql1.4 KB2026-07-13 03:27📄TAP-2957_wire_accounts_migration.sql472 B2026-07-13 03:27📄TAP-2951-migrate-to-orchard-payoneer-account.sql441 B2026-07-13 03:27📄TAP-2924-move-account-payoneer-program.sql445 B2026-07-13 03:27📄TAP-2920-remove-err-payment-entries.sql1.1 KB2026-07-13 03:27📄TAP-2902-remove-err-payment-entries.sql1.1 KB2026-07-13 03:27📄TAP-2892-unhide-corrections-from-paid-accounts.sql430 B2026-07-13 03:27📄TAP-2892-create-reversal-payment-events.sql1.4 KB2026-07-13 03:27📄TAP-2873_add_permissions_for_report_payment.sql221 B2026-07-13 03:27📄TAP-2858-migrate-to-orchard-payoneer-account.sql476 B2026-07-13 03:27📄TAP-2857_wire_accounts_migration.sql612 B2026-07-13 03:27📄TAP-2838_stop_hiding_events.sql741 B2026-07-13 03:27📄TAP-2818-set-check-account-eligibility.sql511 B2026-07-13 03:27📄TAP-2791_create_reversal_events.sql990 B2026-07-13 03:27📄TAP-2788-adjust-banking-details-review-state.sql1.0 KB2026-07-13 03:27📄TAP-2787_grant_access_worksheet_payment_custom.sql241 B2026-07-13 03:27📄TAP-2770_add_payoneer_programs.sql823 B2026-07-13 03:27📄TAP-2755-simulate-rejection-of-kyc.sql879 B2026-07-13 03:27📄TAP-2751-simulate-rejection-of-kyc.sql879 B2026-07-13 03:27📄TAP-2740-rewind-broken-advance.sql395 B2026-07-13 03:27📄TAP-2740-fix-stuck-advance.sql391 B2026-07-13 03:27📄TAP-2736_grant_access_tax_withholding_override.sql466 B2026-07-13 03:27📄TAP-2735-new-balances.sql2.7 KB2026-07-13 03:27📄TAP-2735-create-reversal-events.sql1.7 KB2026-07-13 03:27📄TAP-2721-migrate-to-orchard-payoneer-account.sql957 B2026-07-13 03:27📄TAP-2720_add_payment_entity_program_mapping.sql1.4 KB2026-07-13 03:27📄TAP-2718-update-payment-terms.sql6.1 KB2026-07-13 03:27📄TAP-2717-update-contract-advances-status.sql391 B2026-07-13 03:27📄TAP-2714_soft_delete_payment.sql336 B2026-07-13 03:27📄TAP-2707-simulate-rejection-of-kyc.sql879 B2026-07-13 03:27📄TAP-2702-mark-check-payments-complete.sql975 B2026-07-13 03:27📄TAP-2694-post-to-ledger-account-contract.sql453 B2026-07-13 03:27📄TAP-2693-monthly-check-payments-group.sql614 B2026-07-13 03:27📄TAP-2691_remove_unneeded_calculation_state.sql1.1 KB2026-07-13 03:27📄TAP-2691-1_insert_abacus_event_for_period_320.sql1.0 KB2026-07-13 03:27📄TAP-2678_remove_test_vat_corrections.sql352 B2026-07-13 03:27📄TAP-2676-create-orchard-no-ledger-vat-entries.sql2.6 KB2026-07-13 03:27📄TAP-2675_reopen_orchard_closed_balances.sql2.4 KB2026-07-13 03:27📄TAP-2674-update-vat-number.sql285 B2026-07-13 03:27📄TAP-2653_update_payment_type.sql746 B2026-07-13 03:27📄TAP-2644_update_paid_by.sql459 B2026-07-13 03:27📄TAP-2643_add_payment_minimum_for_nzd.sql431 B2026-07-13 03:27📄TAP-2642_hide_duplicate_payments_from_customers.sql2.5 KB2026-07-13 03:27📄TAP-2626_reset_action_status_for_two_accounts.sql959 B2026-07-13 03:27📄TAP-2622_reset_sttes_for_684_685_batch_payments.sql377 B2026-07-13 03:27📄TAP-2609_insert_new_ledger_vat_summary.sql76.8 KB2026-07-13 03:27📄TAP-2607_update_ledger_vat_summary_to_match_worksheet_tax_correction_vat.sql1.0 KB2026-07-13 03:27📄TAP-2585-create-commit-knr-vat-event.sql591 B2026-07-13 03:27📄TAP-2574_soft_delete_quarterly_payments.sql3.0 KB2026-07-13 03:27📄TAP-2574-remove-errored-montly-payments.sql3.1 KB2026-07-13 03:27📄TAP-2568_update_reference_signing_entity_for_uk_no.sql906 B2026-07-13 03:27📄TAP-2552-update-orchard-us-schedules.sql2.5 MB2026-07-13 03:27📄TAP-2552-remaining-quarterly-payments.sql2.2 MB2026-07-13 03:27📄TAP-2552-full-orchard-us-rollback.sql2.7 MB2026-07-13 03:27📄TAP-2552-final-quarterly-update.sql430.3 KB2026-07-13 03:27📄TAP-2551-return-advances.sql1.4 KB2026-07-13 03:27📄TAP-2545_update_account_tax_info.is_tax_treaty_claimed_altafonte.sql1.1 KB2026-07-13 03:27📄TAP-2545_update_account_tax_info.is_tax_treaty_claimed.sql29.3 KB2026-07-13 03:27📄TAP-2540-update-orchard-payment-terms.sql551.2 KB2026-07-13 03:27📄TAP-2540-update-awal-payment-terms.sql1.2 KB2026-07-13 03:27📄TAP-2540-rollback-changes.sql361.6 KB2026-07-13 03:27📄TAP-2540-cleanup-duplicate-history.sql511.5 KB2026-07-13 03:27📄TAP-2533-update-cotr-for-check-accounts.sql412 B2026-07-13 03:27📄TAP-2531_set_schedule_to_temporary.sql19.5 KB2026-07-13 03:27📄TAP-2530_update_country_tax_residence.sql3.3 KB2026-07-13 03:27📄TAP-2529_update_paid_by_for_account_792453.sql487 B2026-07-13 03:27📄TAP-2519-update-payment-minimums.sql3.3 MB2026-07-13 03:27📄TAP-2518_simulate_rejection_of_kyc.sql551 B2026-07-13 03:27📄TAP-2518_simulate_rejection_of_kyc-1.sql552 B2026-07-13 03:27📄TAP-2512_set_tax_eligibility_to_complete.sql31.7 KB2026-07-13 03:27📄TAP-2511-mark-migrated-advances-approved.sql1.6 KB2026-07-13 03:27📄TAP-2507_migrate_payment_schedules.sql40.8 KB2026-07-13 03:27📄TAP-2507-migrate-remaining-ny-schedules.sql470 B2026-07-13 03:27📄TAP-2507-migrate-orchard-ny-payment-schedules.sql181.8 KB2026-07-13 03:27📄TAP-2505_orchard_de_tax_eligible.sql1.1 KB2026-07-13 03:27📄TAP-2494_make_account_not_payment_eligibile.sql1.1 KB2026-07-13 03:27📄TAP-2492_fix_kosovo_country_code.sql746 B2026-07-13 03:27📄TAP-2476_sync_banking_details_states.sql14.9 KB2026-07-13 03:27📄TAP-2475_update_check_payments_states.sql981 B2026-07-13 03:27📄TAP-2475_add_nzd_currency_to_all_mc_programs.sql644 B2026-07-13 03:27📄TAP-2470_update_payoneer_program_and_agreement.sql789 B2026-07-13 03:27📄TAP-2457_set_rejedted_state.sql1.7 KB2026-07-13 03:27📄TAP-2455_add_commit_vat_events.sql427 B2026-07-13 03:27📄TAP-2452_skip_generate_export_on_altafontes.sql506 B2026-07-13 03:27📄TAP-2449_update_currency_adn_program.sql780 B2026-07-13 03:27📄TAP-2442_reopen_balances.sql1.2 KB2026-07-13 03:27📄TAP-2430_backfill_with_altafonte_agreement_type.sql1.8 KB2026-07-13 03:27📄TAP-2429_altafonte_agreement_type.sql1.1 KB2026-07-13 03:27📄TAP-2428_reset_banking_details_review_state.sql1.0 KB2026-07-13 03:27📄TAP-2427_simulate_rejection_of_kyc.sql875 B2026-07-13 03:27📄TAP-2417_simulate_rejection_of_kyc.sql875 B2026-07-13 03:27📄TAP-2413_set_tax_eligibility_for_clients_paid_orchard_es.sql35.9 KB2026-07-13 03:27📄TAP-2405_backfill_payee_states.sql1.3 KB2026-07-13 03:27📄TAP-2401_backfill_temp_schedule.sql24.9 KB2026-07-13 03:27📄TAP-2397_simulate_rejection_of_kyc.sql872 B2026-07-13 03:27📄TAP-2393_change_orchard_us_uk_de_no_program_and_agreement_type.sql1.7 KB2026-07-13 03:27📄TAP-2388_backfill_closing_balance_data.sql5.3 KB2026-07-13 03:27📄TAP-2364_simulate_rejection_of_kyc.sql874 B2026-07-13 03:27📄TAP-2360_update_signing_entity.sql653 B2026-07-13 03:27📄TAP-2359_update_currency_info_on_altafonte_accounts.sql842 B2026-07-13 03:27📄TAP-2340_enable_close_balances_for_orchard_entities.sql1.3 KB2026-07-13 03:27📄TAP-2324_create_check_payment_payment_group.sql488 B2026-07-13 03:27📄TAP-2322-mark-remaining-check-account.sql375 B2026-07-13 03:27📄TAP-2322-mark-check-payment-accounts.sql79.9 KB2026-07-13 03:27📄TAP-2319_add_check_payment_method.sql332 B2026-07-13 03:27📄TAP-2290_update_state_for_failed_batch.sql649 B2026-07-13 03:27📄TAP-2290_update_missed_vat_categories.sql677 B2026-07-13 03:27📄TAP-2275_change_orchard_us_es_payees_programs.sql652 B2026-07-13 03:27📄TAP-2275_change_orchard_us_es_payees_programs-fix.sql965 B2026-07-13 03:27📄TAP-2256_update_us_tax_rates.sql104.6 KB2026-07-13 03:27📄TAP-2256_add_missed_tax_rates.sql560 B2026-07-13 03:27📄TAP-2253_revert_advance_to_qualified.sql484 B2026-07-13 03:27📄TAP-2248_backfill_states_for_migrated_accounts.sql2.3 KB2026-07-13 03:27📄TAP-2242-backfill-category-existing-vat-corrections-entries.sql4.4 KB2026-07-13 03:27📄TAP-2239-change-incorrect-vat-summary-rows.sql293.4 KB2026-07-13 03:27📄TAP-2172_remove_unneeded_state_from_knr_payment.sql1.1 KB2026-07-13 03:27📄TAP-2127_register_new_spain_programs.sql1.0 KB2026-07-13 03:27📄TAP-2091_knr_vat_314.sql429.4 KB2026-07-13 03:27📄TAP-2079_soft_delete_inconsistent_worksheet.sql442 B2026-07-13 03:27📄TAP-2059_revert_advance_to_qualified.sql265 B2026-07-13 03:27📄TAP-1922_knr_vat_313.sql406.7 KB2026-07-13 03:27📄TAP-1808_clean_up_banking_details_review_prod_only.sql159 B2026-07-13 03:27📄TAP-1807_knr_vat_312.sql479.9 KB2026-07-13 03:27📄TAP-1764_update_payment_hold_reason.sql1.4 KB2026-07-13 03:27📄TAP-1747_rollback_failed_send_events_on_advances.sql390 B2026-07-13 03:27📄TAP-1746-knr-vat-311.sql429.4 KB2026-07-13 03:27📄TAP-1742_backfill_payment_type.sql1.6 KB2026-07-13 03:27📄TAP-1707_update_payment_entity.sql973 B2026-07-13 03:27📄TAP-1693-knr-vat-310.sql451.2 KB2026-07-13 03:27📄TAP-1689_new_reference_payment_type_values.sql792 B2026-07-13 03:27📄TAP-1689_grant_reference_payment_type_access_to_abacus_account.sql251 B2026-07-13 03:27📄TAP-1640_update_advance_status.sql391 B2026-07-13 03:27📄TAP-1636_update_abacus_event.sql498 B2026-07-13 03:27📄TAP-1633_grant_permissions_for_micro_service.sql474 B2026-07-13 03:27📄TAP-1582_grant_access_account_payee_kyc_notification.sql488 B2026-07-13 03:27📄TAP-1563_register_new_programs.sql4.0 KB2026-07-13 03:27📄TAP-1551-update-contract-advance.sql280 B2026-07-13 03:27📄TAP-1551-update-contract-advance-state.sql433 B2026-07-13 03:27📄TAP-1549-remove_payment_holds.sql154.3 KB2026-07-13 03:27📄TAP-1548_add_payment_holds.sql13.0 KB2026-07-13 03:27📄TAP-1545-knr-vat-309.sql433.8 KB2026-07-13 03:27📄TAP-1532_update_vat_rates.sql382 B2026-07-13 03:27📄TAP-1531-change-account-currency.sql577 B2026-07-13 03:27📄TAP-1492_add_missing_payee_states.sql719 B2026-07-13 03:27📄TAP-1487_vat_corrections.sql2.7 KB2026-07-13 03:27📄TAP-1486_mass_payment_hold_fix_history.sql401 B2026-07-13 03:27📄TAP-1486_mass_payment_hold_fix.sql325 B2026-07-13 03:27📄TAP-1486_mass_payment_hold.sql9.6 KB2026-07-13 03:27📄TAP-1486_knr_vat_308.sql367.6 KB2026-07-13 03:27📄TAP-1482_update_payoneer_programs_mapping.sql636 B2026-07-13 03:27📄TAP-1472-knr-vat-307-update.sql588 B2026-07-13 03:27📄TAP-1463_clean_up_remaining_broken_queries.sql19.0 KB2026-07-13 03:27📄TAP-1463_clean_up_duplicate_holds.sql6.3 KB2026-07-13 03:27📄TAP-1443_add_payment_type.sql365 B2026-07-13 03:27📄TAP-1438_vat_corrections.sql2.7 KB2026-07-13 03:27📄TAP-1435-knr-vat-307.sql463.7 KB2026-07-13 03:27📄TAP-1428_update_vat_rates_data.sql1.3 KB2026-07-13 03:27📄TAP-1423_create_payee_states.sql747 B2026-07-13 03:27📄TAP-1422_update_payment_batch_states.sql708 B2026-07-13 03:27📄TAP-1415-account-cleanup-447.sql4.3 KB2026-07-13 03:27📄TAP-1409_update_payment_batch_states.sql516 B2026-07-13 03:27📄TAP-1409_delete_pgpa_knr_entries.sql161 B2026-07-13 03:27📄TAP-1396_create_new_transaction_groups.sql1.6 KB2026-07-13 03:27📄TAP-1383_add_us_tax_entries.sql35.2 KB2026-07-13 03:27📄TAP-1366_update_payment_names.sql633 B2026-07-13 03:27📄TAP-1361-knr-vat-306.sql456.5 KB2026-07-13 03:27📄TAP-1337_update_contract_advance.sql1.5 KB2026-07-13 03:27📄TAP-1326_update_contract_advance.sql1.5 KB2026-07-13 03:27📄TAP-1321_update_payment_entity.sql797 B2026-07-13 03:27📄TAP-1317-change-currency-for-account-781145-USD.sql437 B2026-07-13 03:27📄TAP-1276_mass_payment_hold.sql54.7 KB2026-07-13 03:27📄TAP-1236-knr-vat-305.sql404.3 KB2026-07-13 03:27📄TAP-1211_update_payment_entity.sql781 B2026-07-13 03:27📄TAP-1209_update_account_currency.sql319 B2026-07-13 03:27📄TAP-1191_production_knr_payment_holds.sql6.5 KB2026-07-13 03:27📄TAP-1189_rollback_failed_send_payments.sql2.2 KB2026-07-13 03:27📄TAP-1163_update_payoneer_program.sql955 B2026-07-13 03:27📄TAP-1163_update_payment_entity.sql999 B2026-07-13 03:27📄TAP-1146_knr_vat_304.sql354.2 KB2026-07-13 03:27📄TAP-1135_move_payoneer_programs.sql869 B2026-07-13 03:27📄TAP-1092_update_paid_by.sql977 B2026-07-13 03:27📄TAP-1083_change_payoneer_program.sql1.4 KB2026-07-13 03:27📄TAP-1073_update_payoneer_program.sql6.6 KB2026-07-13 03:27📄TAP-1070_reverse_and_correct_vat_for_single_account.sql2.3 KB2026-07-13 03:27📄TAP-1055-knr-vat-303.sql386.1 KB2026-07-13 03:27📄TAP-1052_update_payoneer_program.sql501 B2026-07-13 03:27📄TAP-1052_update_payment_entity.sql976 B2026-07-13 03:27📄TAP-1035_update_agreement_type.sql1001 B2026-07-13 03:27📄TAP-1034_update_payment_entity.sql976 B2026-07-13 03:27📄TAP-1027_update_payoneer_program.sql951 B2026-07-13 03:27📄TAP-1027_update_payment_entity.sql995 B2026-07-13 03:27📄TAP-1020_update_payoneer_program.sql2.2 KB2026-07-13 03:27📄TAP-1020_update_payment_entity.sql1.0 KB2026-07-13 03:27📄SYS-13999_user_drop_permissions.sql528 B2026-07-13 03:27📄PORT-183_backfill_destination_term_ids.sql2.5 KB2026-07-13 03:27📄PORT-183_backfill_destination_term_condition_ids.sql2.3 KB2026-07-13 03:27📄PLATFORM-4877_add_new_default_carveout_for_gda_accounts.sql537 B2026-07-13 03:27📄No-Ticket-update-signing-entity.sql479 B2026-07-13 03:27📄No-Ticket-rollback-abacus-event.sql242 B2026-07-13 03:27📄NO-TICKET-fix-ledger.sql9.4 KB2026-07-13 03:27📄No-Ticket-fix-currency-code.sql520 B2026-07-13 03:27📄No-Ticket-delete-approve-sale-abacus-event.sql356 B2026-07-13 03:27📄MAINT_backfill_contract_payee.sql281 B2026-07-13 03:27📄MAINT-update-publishing-contract-attachment.sql411 B2026-07-13 03:27📄MAINT-handhold-accounting-runs.sql1016 B2026-07-13 03:27📄FR-77-update-run-controller.sql342 B2026-07-13 03:27📄FR-75-make-knr-payments-294.sql8.4 KB2026-07-13 03:27📄FR-157-knr-vat-297.sql406.3 KB2026-07-13 03:27📄FR-152-update-run-controller.sql273 B2026-07-13 03:27📄FR-151-remove-product-and-track-exceptions.sql917 B2026-07-13 03:27📄FR-150_delete_base_terms.sql2.1 KB2026-07-13 03:27📄FR-143-knr-vat-296.sql429.6 KB2026-07-13 03:27📄FR-134_delete_base_terms.sql1.3 KB2026-07-13 03:27📄FR-132-fix-current-balance-pointers.sql18.2 KB2026-07-13 03:27📄FR-131-fix-inaccurate-ledgers.sql4.5 KB2026-07-13 03:27📄FR-126-knr-payments-296.sql8.4 KB2026-07-13 03:27📄FR-124-knr-vat-295.sql429.4 KB2026-07-13 03:27📄FR-119-update-run-controller.sql328 B2026-07-13 03:27📄FR-118_delete_base_terms.sql1.2 KB2026-07-13 03:27📄FR-118-1-remove_base_terms.sql778 B2026-07-13 03:27📄FR-110-knr-payments-295.sql8.4 KB2026-07-13 03:27📄FR-105-delete-base-term-contract-535893.sql973 B2026-07-13 03:27📄FR-103-knr-vat-294.sql467.9 KB2026-07-13 03:27📄FR-101-product-base-term-contract-531056.sql3.8 KB2026-07-13 03:27📄FR-100-move-moonbeam-contracts-run-controller.sql679 B2026-07-13 03:27📄FR-100-add-run-controller-to-accounting-period.sql639 B2026-07-13 03:27📄fix-contract-reference_sap_profit_center_id.sql991 B2026-07-13 03:27📄DOC-560-update-historical-knr-vat-data.sql153.8 KB2026-07-13 03:27📄DOC-556-update-payoneer-program.sql456 B2026-07-13 03:27📄DOC-536-change-payoneer-program.sql835 B2026-07-13 03:27📄DOC-527-change-payoneer-program-v2.sql438 B2026-07-13 03:27📄DOC-518-backfill-historical-knr-vat-data.sql321.0 KB2026-07-13 03:27📄DOC-513-backfill-sap-ids.sql2.5 KB2026-07-13 03:27📄DOC-486-backfill-sap-ids.sql44.7 KB2026-07-13 03:27📄DOC-462-delete-sap-vendor-id.sql369 B2026-07-13 03:27📄DOC-408-backfill-sap-vendor-ids.sql377.3 KB2026-07-13 03:27📄DOC-319-change-signing-entity.sql400 B2026-07-13 03:27📄DOC-298-update-payoneer-program-ids.sql23.5 KB2026-07-13 03:27📄DOC-290-backfill-3rd-party-payoneer-program-ids.sql761 B2026-07-13 03:27📄DOC-269-null-out-account-payee-payoneer-programs.sql424 B2026-07-13 03:27📄DOC-231-null-out-account-payee-payoneer-programs.sql727 B2026-07-13 03:27📄delete-bad-test-contract-data.sql580 B2026-07-13 03:27📄create-missing-accounts_ACC-10050.sql5.3 KB2026-07-13 03:27📄AS-3590-backfill_payees.sql1.3 KB2026-07-13 03:27📄AS-3541_create_additional_altafonte_collaborators_payees.sql5.2 KB2026-07-13 03:27📄AS-3537_grant_access_payee_kyc_notification.sql450 B2026-07-13 03:27📄AS-3537_backfill_payee_banking_eligibility_states.sql496 B2026-07-13 03:27📄AS-3500_insert_altafonte_collab_payees.sql67.9 KB2026-07-13 03:27📄AS-3500_FIX_insert_altafonte_collab_payees.sql71.5 KB2026-07-13 03:27📄ACC_9853_add_isrc.sql1.6 KB2026-07-13 03:27📄ACC_9807_add_isrcs.sql8.5 KB2026-07-13 03:27📄ACC_9796_correct_territory_backfills.sql1.3 MB2026-07-13 03:27📄ACC_9796_Backfill_incorrectly_migrated_performance_rights_territories.sql1.2 MB2026-07-13 03:27📄ACC_9725_new_adjustment_types.sql340 B2026-07-13 03:27📄ACC_9722-1_update_upcs.sql6.5 KB2026-07-13 03:27📄ACC_9715_update_signing_entites.sql2.9 KB2026-07-13 03:27📄ACC_9713_add_upcs.sql6.1 KB2026-07-13 03:27📄ACC_9712_add_isrcs.sql4.1 KB2026-07-13 03:27📄ACC_9711_update_account_currency.sql2.9 KB2026-07-13 03:27📄ACC_9259_fix_apply_event.sql275 B2026-07-13 03:27📄ACC_10356_update_accounting_run_calculate.sql696 B2026-07-13 03:27📄ACC-9980-create-abacus-account.sql2.6 KB2026-07-13 03:27📄ACC-9972-update-signing-entity.sql344 B2026-07-13 03:27📄ACC-9971_create_foundation_signing_entities.sql552 B2026-07-13 03:27📄ACC-9970_create_foundation_sap_profit_centers.sql415 B2026-07-13 03:27📄ACC-9961-bulk-add-upcs.sql16.4 KB2026-07-13 03:27📄ACC-9961-add-upcs.sql933 B2026-07-13 03:27📄ACC-9931-update-signing-entity.sql261 B2026-07-13 03:27📄ACC-9930-bulk-add-upcs.sql12.5 KB2026-07-13 03:27📄ACC-9929-update-contract-terms.sql1.6 KB2026-07-13 03:27📄ACC-9928_update_currencies.sql1.3 KB2026-07-13 03:27📄ACC-9927-update-contract-terms-upcs.sql4.4 KB2026-07-13 03:27📄ACC-9926-add-isrcs-to-contract-terms.sql6.6 KB2026-07-13 03:27📄ACC-9924_update_contract_advances.sql5.4 KB2026-07-13 03:27📄ACC-9923_update_contract_milestones.sql78.2 KB2026-07-13 03:27📄ACC-9916_update_signing_entity_for_contract.sql247 B2026-07-13 03:27📄ACC-9916_soft_delete_signing_entities.sql2.4 KB2026-07-13 03:27📄ACC-9916_modify_specific_signing_entities.sql4.7 KB2026-07-13 03:27📄ACC-9916_cleanup_signing_entities.sql6.5 KB2026-07-13 03:27📄ACC-9916-1_entities_updates.sql1.1 KB2026-07-13 03:27📄ACC-9912-add-run-controllers-to-awal-gda-contracts.sql620 B2026-07-13 03:27📄ACC-9867-delete-worksheet-adjustments-for-contract-552087.sql475 B2026-07-13 03:27📄ACC-9866-backfill-is-paythrough-contract-column.sql1.5 KB2026-07-13 03:27📄ACC-9850-add-new-adjustment-types.sql350 B2026-07-13 03:27📄ACC-9848_add_upcs.sql6.0 KB2026-07-13 03:27📄ACC-9823_add_upcs.sql2.0 KB2026-07-13 03:27📄ACC-9818_update_schedule_ids.sql735 B2026-07-13 03:27📄ACC-9818_link_contributions.sql378.3 KB2026-07-13 03:27📄ACC-9818_add-queen-recordings-to-schedules.sql3.4 KB2026-07-13 03:27📄ACC-9817-bulk-add-ad-sales-transaction-types.sql32.6 KB2026-07-13 03:27📄ACC-9812_update_term_condition_rates.sql55.9 KB2026-07-13 03:27📄ACC-9811_update_signing_entity.sql392 B2026-07-13 03:27📄ACC-9810_update_paid_by.sql790 B2026-07-13 03:27📄ACC-9809-delete-the-contract-physical-reserves.sql316 B2026-07-13 03:27📄ACC-9808_add_upcs.sql15.6 KB2026-07-13 03:27📄ACC-9803-delete-324-rollover-sales-file.sql1.2 KB2026-07-13 03:27📄ACC-9794_update_us_mechanical_rates_reference_table.sql354 B2026-07-13 03:27📄ACC-9787_update_contract_flowthrough_recoupment_cap.sql4.6 KB2026-07-13 03:27📄ACC-9787_update_contract_flowthrough_calculation.sql2.0 KB2026-07-13 03:27📄ACC-9786-insert-new-calculation-for-flowthrough.sql562 B2026-07-13 03:27📄ACC-9781_update_signing_entity.sql1.7 KB2026-07-13 03:27📄ACC-9754_update_adjustment_types.sql543 B2026-07-13 03:27📄ACC-9744_attach_contract_id_to_pub_statements_p324.sql6.7 KB2026-07-13 03:27📄ACC-9723_add_upcs.sql1.7 KB2026-07-13 03:27📄ACC-9722_update_upcs.sql2.0 KB2026-07-13 03:27📄ACC-9716-update-term-rates.sql2.3 KB2026-07-13 03:27📄ACC-9716-create-term-conditions-1.sql9.4 KB2026-07-13 03:27📄ACC-9714-release-reserves-early.sql2.9 KB2026-07-13 03:27📄ACC-9710_add_upcs.sql4.5 KB2026-07-13 03:27📄ACC-9707_add_isrcs.sql9.3 KB2026-07-13 03:27📄ACC-9706-update-gda-contract-template.sql1.6 KB2026-07-13 03:27📄ACC-9697-update-other-milestone-with-option-value.sql708 B2026-07-13 03:27📄ACC-9506_update_accounts.sql929 B2026-07-13 03:27📄ACC-9500-update-account-currency.sql759 B2026-07-13 03:27📄ACC-9495-bulk-add-upcs.sql46.7 KB2026-07-13 03:27📄ACC-9481_update_contract_paid_by.sql944 B2026-07-13 03:27📄ACC-9480_update_contract_signing_entity.sql2.0 KB2026-07-13 03:27📄ACC-9479-bulk-add-upcs.sql12.9 KB2026-07-13 03:27📄ACC-9478_add_isrc_to_track_terms.sql1.8 KB2026-07-13 03:27📄ACC-9477_update_account_currency_codes.sql1.5 KB2026-07-13 03:27📄ACC-9436_grant_access_abacus_outbox.sql346 B2026-07-13 03:27📄ACC-9433_update_signing_entity.sql1.6 KB2026-07-13 03:27📄ACC-9432_hard_delete_signing_entities.sql2.4 KB2026-07-13 03:27📄ACC-9431_update_contract_signing_entity.sql2.0 KB2026-07-13 03:27📄ACC-9418_add_file_upload_config.sql957 B2026-07-13 03:27📄ACC-9411-bulk-add-upcs.sql11.5 KB2026-07-13 03:27📄ACC-9409_add_upcs_to_contract_attachments.sql1.4 KB2026-07-13 03:27📄ACC-9409-add-upcs-to-attachments.sql880 B2026-07-13 03:27📄ACC-9388_reset_file_upload_configs.sql1.1 KB2026-07-13 03:27📄ACC-9383_add_reference_worksheet_flowthrough_errors.sql2.7 KB2026-07-13 03:27📄ACC-9364_update_paid_by_for_contract.sql455 B2026-07-13 03:27📄ACC-9363_add_upcs_to_contract_attachments.sql1.5 KB2026-07-13 03:27📄ACC-9362_add_isrcs_to_track_term.sql3.2 KB2026-07-13 03:27📄ACC-9361-update-run-controller.sql430 B2026-07-13 03:27📄ACC-9358-update-run-controllers.sql1.3 KB2026-07-13 03:27📄ACC-9342_add_garnishment_adjustment_type.sql286 B2026-07-13 03:27📄ACC-9341_add_upcs_to_contract_attachments.sql1.5 KB2026-07-13 03:27📄ACC-9339_add_isrc_to_track_terms.sql1.5 KB2026-07-13 03:27📄ACC-9329_update_signing_entities_for_contracts.sql2.7 KB2026-07-13 03:27📄ACC-9328-update-run-controllers.sql471 B2026-07-13 03:27📄ACC-9327_update_paid_by_for_contracts.sql1.7 KB2026-07-13 03:27📄ACC-9325_add_isrc_to_track_terms.sql4.1 KB2026-07-13 03:27📄ACC-9324_update_account_currencies.sql1.4 KB2026-07-13 03:27📄ACC-9323_add_upcs_to_contract_attachments.sql37.4 KB2026-07-13 03:27📄ACC-9322-3_add_tracks_to_contract_term_attachments.sql480.8 KB2026-07-13 03:27📄ACC-9322-2_update_track_terms.sql1.5 KB2026-07-13 03:27📄ACC-9322-1_update_track_terms.sql24.0 KB2026-07-13 03:27📄ACC-9320_hard_delete_accounts.sql19.8 KB2026-07-13 03:27📄ACC-9293_update_invalid_execution_data.sql191 B2026-07-13 03:27📄ACC-9287_backfill_historical_contract_advances.sql2.5 MB2026-07-13 03:27📄ACC-9276_hard_delete_accounts.sql19.8 KB2026-07-13 03:27📄ACC-9274_update_contract_signing_entity.sql2.3 KB2026-07-13 03:27📄ACC-9262_update_paid_by.sql1.6 KB2026-07-13 03:27📄ACC-9249_update_contract_signing_entity.sql2.2 KB2026-07-13 03:27📄ACC-9240-cleanup-contract-lifecycle.sql1001 B2026-07-13 03:27📄ACC-9220-updates-sales-metadata-for-sales-file-166.sql369 B2026-07-13 03:27📄ACC-9216_release_reserves_for_contract.sql4.7 KB2026-07-13 03:27📄ACC-9209_update_paid_by_for_account_44102.sql828 B2026-07-13 03:27📄ACC-9208_hard_delete_contracts.sql3.1 KB2026-07-13 03:27📄ACC-9206_orchard-contract-add-mech-deductions.sql8.8 KB2026-07-13 03:27📄ACC-9202_reset_event_and_state.sql863 B2026-07-13 03:27📄ACC-9191-update-gda-contract-template.sql1.3 KB2026-07-13 03:27📄ACC-9190_update_contract_run_controllers.sql1.4 KB2026-07-13 03:27📄ACC-9187_add_transaction_types_to_contract_term_conditions.sql1.9 KB2026-07-13 03:27📄ACC-9186_update_contract_term_transaction_types.sql3.5 KB2026-07-13 03:27📄ACC-9185_update_contract_terms.sql2.2 KB2026-07-13 03:27📄ACC-9184_update-termination-date-on-contracts.sql755 B2026-07-13 03:27📄ACC-9183_add_isrc_to_track_term.sql914 B2026-07-13 03:27📄ACC-9182_update_paid_by_for_accounts.sql1.2 KB2026-07-13 03:27📄ACC-9181_update_product_terms.sql724 B2026-07-13 03:27📄ACC-9181_bulk_update_contract_terms.sql11.5 KB2026-07-13 03:27📄ACC-9181-4_update_product_terms.sql531 B2026-07-13 03:27📄ACC-9181-2_update_track_terms.sql759 B2026-07-13 03:27📄ACC-9171_update-contracts-correct-ref-sap-profit-center.sql404 B2026-07-13 03:27📄ACC-9144_update_contract_run_controllers.sql1.8 KB2026-07-13 03:27📄ACC-9143_update_contract_signing_entity.sql2.3 KB2026-07-13 03:27📄ACC-9134_add_upcs_to_contract_terms.sql21.8 KB2026-07-13 03:27📄ACC-9114_set_is_paythrough_contract.sql795 B2026-07-13 03:27📄ACC-9089_set_run_status_469.sql391 B2026-07-13 03:27📄ACC-9089_move_contracts_to_new_run_controller.sql613 B2026-07-13 03:27📄ACC-9089_add_run_controller_to_accounting_run.sql384 B2026-07-13 03:27📄ACC-9089-update-accounting-run-status-467.sql389 B2026-07-13 03:27📄ACC-9089-update-accounting-run-status-458.sql389 B2026-07-13 03:27📄ACC-9089-change-run-controller-for-large-contracts.sql473 B2026-07-13 03:27📄ACC-9089-2_set_run_status_470.sql391 B2026-07-13 03:27📄ACC-9066_add_upc_to_contract_term_attachments.sql848 B2026-07-13 03:27📄ACC-9062-update-signing-entity.sql391 B2026-07-13 03:27📄ACC-9048_remove_reserves_from_contracts.sql413 B2026-07-13 03:27📄ACC-9046-update-run-controller-to-awal.sql482 B2026-07-13 03:27📄ACC-9045_update_paid_by_for_contracts.sql899 B2026-07-13 03:27📄ACC-9044_add_isrcs_to_contract_term_attachments.sql9.3 KB2026-07-13 03:27📄ACC-9044_3_add_isrcs_to_contract_term_attachments.sql547 B2026-07-13 03:27📄ACC-9044_2_add_isrcs_to_contract_term_attachments.sql1.7 KB2026-07-13 03:27📄ACC-9043-update-signing-entity.sql2.3 KB2026-07-13 03:27📄ACC-9042_release_reserves_for_account.sql25.4 KB2026-07-13 03:27📄ACC-9032_update_account_currencies.sql1.1 KB2026-07-13 03:27📄ACC-9031-udpate_sap_profit_center_for_accounts.sql549 B2026-07-13 03:27📄ACC-9000_change-reference-sap-profit-center-id-for-1-contract.sql241 B2026-07-13 03:27📄ACC-8974_hard_delete_contracts.sql3.3 KB2026-07-13 03:27📄ACC-8956_update_contract_data.sql3.6 KB2026-07-13 03:27📄ACC-8952_update_run_controller_for_large_contract.sql270 B2026-07-13 03:27📄ACC-8952_add_run_controller_to_accounting_run.sql384 B2026-07-13 03:27📄ACC-8952-update-accounting-run-status-446.sql217 B2026-07-13 03:27📄ACC-8952-3_add_contract_to_run_controller.sql270 B2026-07-13 03:27📄ACC-8943-assign-contributions-to-schedules.sql234.8 KB2026-07-13 03:27📄ACC-8942_bulk_update_attachments.sql62.7 KB2026-07-13 03:27📄ACC-8932_add_new_adjustment_types.sql421 B2026-07-13 03:27📄ACC-8929_update_contract_data.sql7.8 KB2026-07-13 03:27📄ACC-8928_update_contract_data.sql1.3 KB2026-07-13 03:27📄ACC-8927_update_contract_data.sql1.4 KB2026-07-13 03:27📄ACC-8926_update_contract_data.sql3.1 KB2026-07-13 03:27📄ACC-8925_update_contract_data.sql1.7 KB2026-07-13 03:27📄ACC-8924_update_contract_data.sql1.1 KB2026-07-13 03:27📄ACC-8923_update_contract_term_rates.sql98.5 KB2026-07-13 03:27📄ACC-8921-insert-reference-signing-entities.sql632 B2026-07-13 03:27📄ACC-8920-update-signing-entity-for-contracts.sql1.4 KB2026-07-13 03:27📄ACC-8919_update_attachments.sql24.1 KB2026-07-13 03:27📄ACC-8918_update_run_controller_contracts.sql1014 B2026-07-13 03:27📄ACC-8918_3_update_run_controller_contracts.sql269 B2026-07-13 03:27📄ACC-8918_2_update_run_controller_contracts.sql702 B2026-07-13 03:27📄ACC-8914_delete_duplicate_statement_attachments.sql747 B2026-07-13 03:27📄ACC-8908_backfill_run_controller_contract_audit_data.sql488 B2026-07-13 03:27📄ACC-8889_restore_contract_lifecycle.sql3.4 KB2026-07-13 03:27📄ACC-8880_remove_duplicate_contract.sql2.0 KB2026-07-13 03:27📄ACC-8858_update_ledger_reserve_taken_records.sql1.9 KB2026-07-13 03:27📄ACC-8858_remove_migrated_reserves_319_onwards.sql1.5 KB2026-07-13 03:27📄ACC-8851_remove_migrated_reserves_2.sql3.7 KB2026-07-13 03:27📄ACC-8851_remove_migrated_reserves.sql3.7 KB2026-07-13 03:27📄ACC-8843_update_ledger_reserve_release_schedule_records.sql838 B2026-07-13 03:27📄ACC-8843_insert_ledger_reserve_taken_records.sql1.1 KB2026-07-13 03:27📄ACC-8843_delete_ledger_reserve_release_records.sql878 B2026-07-13 03:27📄ACC-8843_delete_ledger_account_contract_record_fix.sql1.5 KB2026-07-13 03:27📄ACC-8842_remove_duplicate_flowthrough.sql299 B2026-07-13 03:27📄ACC-8842_create_flowthrough_configs.sql3.6 KB2026-07-13 03:27📄ACC-8841_create_paythrough_contracts.sql7.1 KB2026-07-13 03:27📄ACC-8830-update_altafonte_mech_deductions.sql2.2 KB2026-07-13 03:27📄ACC-8821-migrate-installments.sql677.5 KB2026-07-13 03:27📄ACC-8814_hide_accounting_period.sql1.5 KB2026-07-13 03:27📄ACC-8812_update_term_conditions.sql288.8 KB2026-07-13 03:27📄ACC-8811_update_sap_profit_center_part_2.sql292 B2026-07-13 03:27📄ACC-8811_update_sap_profit_center.sql289 B2026-07-13 03:27📄ACC-8809_update_paid_by.sql1.2 KB2026-07-13 03:27📄ACC-8804_update_product_attachments.sql30.7 KB2026-07-13 03:27📄ACC-8804-1_update_attachments.sql30.9 KB2026-07-13 03:27📄ACC-8796_update_run_controller_and_signing_entity.sql3.1 KB2026-07-13 03:27📄ACC-8794_remove_sales_file.sql1.0 KB2026-07-13 03:27📄ACC-8794-1_remove_bad_state.sql432 B2026-07-13 03:27📄ACC-8792_update_attachments_to_original.sql20.8 KB2026-07-13 03:27📄ACC-8792_update_attachments.sql2.0 KB2026-07-13 03:27📄ACC-8785_update_se_and_pb.sql1.1 KB2026-07-13 03:27📄ACC-8780_update_contract_lifecycles.sql11.4 KB2026-07-13 03:27📄ACC-8779_create_paythrough_orchared_contracts.sql31.5 KB2026-07-13 03:27📄ACC-8777-contract-advances-migration-from-oa.sql513.7 KB2026-07-13 03:27📄ACC-8768_update_contract_start_date.sql1.8 KB2026-07-13 03:27📄ACC-8765_update_contract_lifecycle.sql3.5 KB2026-07-13 03:27📄ACC-8764_configure_flowthrough_for_orchard.sql46.4 KB2026-07-13 03:27📄ACC-8764_add_flowthrough_configurations.sql46.4 KB2026-07-13 03:27📄ACC-8763-delete-contract-physical-reserves.sql358 B2026-07-13 03:27📄ACC-8762_update_transaction_types.sql1.7 KB2026-07-13 03:27📄ACC-8750-update-note-for-adjustment-batch-2218.sql267 B2026-07-13 03:27📄ACC-8744_add_upcs_to_contract_term.sql12.2 KB2026-07-13 03:27📄ACC-8743_update_contract_signing_entity.sql471 B2026-07-13 03:27📄ACC-8742_delete_abacus_accounts.sql1.5 KB2026-07-13 03:27📄ACC-8742-delete-contracts.sql5.8 KB2026-07-13 03:27📄ACC-8742-1_delete_abacus_accounts.sql1.5 KB2026-07-13 03:27📄ACC-8741-delete-contracts.sql6.2 KB2026-07-13 03:27📄ACC-8740_update_run_controller_for_contracts.sql1.4 KB2026-07-13 03:27📄ACC-8740_fix_run_controller_and_signing_entity.sql1.0 KB2026-07-13 03:27📄ACC-8739_add_isrcs_to_track_terms.sql4.5 KB2026-07-13 03:27📄ACC-8738_update_contract_reference_ids.sql2.4 KB2026-07-13 03:27📄ACC-8738_create_contract_owner_map_snowflake.sql1.3 KB2026-07-13 03:27📄ACC-8726_backfill_1335_contracts_sap_profit_center_and_signing_entity_id_fix.sql2.4 KB2026-07-13 03:27📄ACC-8723-delete-terminated-contracts.sql19.3 KB2026-07-13 03:27📄ACC-8718-fix-missing-lifecycle.sql743 B2026-07-13 03:27📄ACC-8717-insert-reference-signing-entities.sql3.5 KB2026-07-13 03:27📄ACC-8716_update_reference_signing_entity_id.sql586 B2026-07-13 03:27📄ACC-8716-insert-reference-profit-centers.sql727 B2026-07-13 03:27📄ACC-8716-backfill-sap-profit-center-ids-in-signing-entity-table.sql682 B2026-07-13 03:27📄ACC-8715_update_contract_reference_ids.sql2.5 KB2026-07-13 03:27📄ACC-8715_create_owner_signing_entity_map_google_sheet.sql5.7 KB2026-07-13 03:27📄ACC-8715_create_contract_owner_map_snowflake.sql780.3 KB2026-07-13 03:27📄ACC-8714_insert_missing_adjustments_ledger_account_contract.sql4.6 KB2026-07-13 03:27📄ACC-8680-update-paid-by-payment-method-for-2-accounts.sql923 B2026-07-13 03:27📄ACC-8673_correct_adjustments.sql8.7 KB2026-07-13 03:27📄ACC-8668-update-payment-entity-id-for-orchard-accounts.sql396.7 KB2026-07-13 03:27📄ACC-8665-update-run-controller-to-awal-contract-544822.sql293 B2026-07-13 03:27📄ACC-8664-backfill_account_id_for_json_imoport_report.sql293 B2026-07-13 03:27📄ACC-8646-update-run-controllers-to-awal.sql294 B2026-07-13 03:27📄ACC-8642_delete_bad_sales_file.sql490 B2026-07-13 03:27📄ACC-8633-update-sales-metadata-for-sales-file-144.sql409 B2026-07-13 03:27📄ACC-8627_create_contract_for_account.sql4.2 KB2026-07-13 03:27📄ACC-8612_set_reference_sap_profit_center_on_placeholder_contract.sql468 B2026-07-13 03:27📄ACC-8612_add_reserves_migration_placeholder_records.sql3.9 KB2026-07-13 03:27📄ACC-8610_delete_abacus_accounts.sql2.0 KB2026-07-13 03:27📄ACC-8609-delete-contract.sql5.5 KB2026-07-13 03:27📄ACC-8608_remove_KA_KS_Transaction_Types_from_KNR_Run_Controller.sql2.3 KB2026-07-13 03:27📄ACC-8601_update_contract_start_date.sql32.3 KB2026-07-13 03:27📄ACC-8599-update-run-controllers-to-awal.sql681 B2026-07-13 03:27📄ACC-8597_attach_upcs_to_product_term.sql43.4 KB2026-07-13 03:27📄ACC-8596_attach_upcs_to_product_term.sql31.9 KB2026-07-13 03:27📄ACC-8594_add_currency_support_nzd.sql432 B2026-07-13 03:27📄ACC-8592_create_missing_abacus_account.sql2.5 KB2026-07-13 03:27📄ACC-8561_undo_rollback_accounting_period_close.sql1.1 KB2026-07-13 03:27📄ACC-8556-update-profit-center-id-for-contract-548531.sql396 B2026-07-13 03:27📄ACC-8539-backfill-SC-transaction-types-altafonte-contracts.sql1.8 KB2026-07-13 03:27📄ACC-8532-create-orchard-test-accounts.sql7.3 KB2026-07-13 03:27📄ACC-8500-update-run-controllers-to-awal.sql1.0 KB2026-07-13 03:27📄ACC-8499-change-account-currency.sql500 B2026-07-13 03:27📄ACC-8498_update_contract_lifecycle_start_date.sql514 B2026-07-13 03:27📄ACC-8497-delete-contracts.sql9.6 KB2026-07-13 03:27📄ACC-8484-add-run-controller-contract.sql375 B2026-07-13 03:27📄ACC-8473_reorder_calculations_for_flowthrough.sql2.1 KB2026-07-13 03:27📄ACC-8471-backfill-abacus-contracts-with-new-youtube-transaction-types.sql10.0 KB2026-07-13 03:27📄ACC-8458-add-youtube-transaction-types.sql3.1 KB2026-07-13 03:27📄ACC-8453-update-distribution-contracts-with-ka-ks-transaction-types.sql4.2 KB2026-07-13 03:27📄ACC-8431-update-signing-entity-fields.sql952 B2026-07-13 03:27📄ACC-8431-remove-signing-entities-from-payment-group-criteria.sql607 B2026-07-13 03:27📄ACC-8431-alter-payment-entity-id-to-null.sql281 B2026-07-13 03:27📄ACC-8431-add-comment-to-deprecated-columns.sql2.2 KB2026-07-13 03:27📄ACC-8403-update-sales-metadata-for-sales-file-138.sql416 B2026-07-13 03:27📄ACC-8386_add_upcs_to_contract_in_new_contract_term.sql1.3 KB2026-07-13 03:27📄ACC-8381-update-awal-flowthrough-rates.sql611 B2026-07-13 03:27📄ACC-8381-update-altafonte-flowthrough-rates.sql621 B2026-07-13 03:27📄ACC-8381-backfill-orchard-flowthrough-contract-terms.sql18.3 KB2026-07-13 03:27📄ACC-8381-backfill-awal-flowthrough-contract-terms.sql2.6 KB2026-07-13 03:27📄ACC-8381-backfill-altafonte-flowthrough-contract-terms.sql2.1 KB2026-07-13 03:27📄ACC-8380_update_is_paythrough_contract_awal.sql1.2 KB2026-07-13 03:27📄ACC-8380_update_is_paythrough_contract.sql1.3 KB2026-07-13 03:27📄ACC-8380_sync_contracts_orchard.sql14.0 KB2026-07-13 03:27📄ACC-8380_sync_contract_account_run_controller.sql1010 B2026-07-13 03:27📄ACC-8380_seed_paythrough_orchard_contracts.sql26.9 KB2026-07-13 03:27📄ACC-8380_seed_paythrough_contracts_orchard.sql26.0 KB2026-07-13 03:27📄ACC-8380_seed_paythrough_contracts_altafonte.sql5.1 KB2026-07-13 03:27📄ACC-8380_rollback_orchard_contracts_prod.sql4.7 KB2026-07-13 03:27📄ACC-8380_errant_contracts_disposal.sql3.5 KB2026-07-13 03:27📄ACC-8372_add_upc_to_contract.sql961 B2026-07-13 03:27📄ACC-8371_update_contract_signing_entity.sql1.2 KB2026-07-13 03:27📄ACC-8371_update_account_payment_term_payment_entity.sql408 B2026-07-13 03:27📄ACC-8369-delete-contract.sql2.3 KB2026-07-13 03:27📄ACC-8368_update_contract_period_start_date.sql550 B2026-07-13 03:27📄ACC-8367-update-run-controllers-to-awal.sql374 B2026-07-13 03:27📄ACC-8355_new_intervals_lifecycle.sql281 B2026-07-13 03:27📄ACC-8355-upcate-contract-lifecycles-altafonte.sql13.8 KB2026-07-13 03:27📄ACC-8330-update-profit-center-and-signing-entity-for-altafonte-account.sql557 B2026-07-13 03:27📄ACC-8330-rollback-update-profit-center-and-signing-entity-for-altafonte-account.sql557 B2026-07-13 03:27📄ACC-8322_update_account_currency.sql467 B2026-07-13 03:27📄ACC-8308-udpate_sap_profict_center_for_migrated_contracts.sql1.1 KB2026-07-13 03:27📄ACC-8307_udpate_aggreement_type_for_altafonte.sql875 B2026-07-13 03:27📄ACC-8300-delete_inactive_altafonte_contracts.sql48.9 KB2026-07-13 03:27📄ACC-8299-delete-duplicates-from-reference_external_source.sql719 B2026-07-13 03:27📄ACC-8294-add-KS-KA-transaction-types-to-presentational-group.sql452 B2026-07-13 03:27📄ACC-8294-2-add-KS-KA-transaction-types.sql919 B2026-07-13 03:27📄ACC-8255_update_run_controllers.sql859 B2026-07-13 03:27📄ACC-8207_update_account_name_string.sql839 B2026-07-13 03:27📄ACC-8207_fix_aggreement_type_for_additional_accounts.sql1.1 KB2026-07-13 03:27📄ACC-8206_update_event_names.sql652 B2026-07-13 03:27📄ACC-8206_create_sync_events.sql428 B2026-07-13 03:27📄ACC-8205_delete_contracts_from_abacus.sql2.4 KB2026-07-13 03:27📄ACC-8202_add_run_controller_contract.sql218 B2026-07-13 03:27📄ACC-8199_change_current_and_previous_balance_in_ledger_account_contract.sql1.1 KB2026-07-13 03:27📄ACC-8199_change_accounting_run_id_for_ledger_accounting_run_vat_record.sql304 B2026-07-13 03:27📄ACC-8168_2_update_lifecycles.sql1.9 KB2026-07-13 03:27📄ACC-8168-backfill_altafonte_contract_lifecycles.sql75.7 KB2026-07-13 03:27📄ACC-8167_add_altafonte_signing_entities_to_abacus.sql710 B2026-07-13 03:27📄ACC-8141_remove_schedule_from_contract.sql1.6 KB2026-07-13 03:27📄ACC-8120_delete_orphaned_contract.sql2.1 KB2026-07-13 03:27📄ACC-8107-backfill-mech-deductions.sql820 B2026-07-13 03:27📄ACC-8105_link_upcs_to_new_product_terms.sql2.9 KB2026-07-13 03:27📄ACC-8099-contract-term-conditions-replace-ant.sql1009 B2026-07-13 03:27📄ACC-8098_remove_reserves.sql254 B2026-07-13 03:27📄ACC-8097-change-account-791624-currency.sql496 B2026-07-13 03:27📄ACC-8096-update-run-controllers-to-awal.sql425 B2026-07-13 03:27📄ACC-8094_link_isrcs_to_new_track_terms.sql7.4 KB2026-07-13 03:27📄ACC-8094-2_add_missing_attachment_relations_to_track_term.sql401 B2026-07-13 03:27📄ACC-8093_update_contract_start_date.sql1.5 KB2026-07-13 03:27📄ACC-8052-soft-delete-duplicate-contract-lifecycle-and-schedules.sql944 B2026-07-13 03:27📄ACC-8036_update_contract_type_and_run_controller_for_contract_549406.sql712 B2026-07-13 03:27📄ACC-8034_add_new_presentational_transaction_groups.sql3.8 KB2026-07-13 03:27📄ACC-8023-create-abacus-account.sql2.5 KB2026-07-13 03:27📄ACC-7987_updated_attatchements_relations.sql441 B2026-07-13 03:27📄ACC-7968-backfill-all-statement-periods.sql796 B2026-07-13 03:27📄ACC-7966-update-accounting-period-name.sql504 B2026-07-13 03:27📄ACC-7959_update_track_exceptions.sql4.9 KB2026-07-13 03:27📄ACC-7958-update-run-controllers-to-awal.sql487 B2026-07-13 03:27📄ACC-7951_INSERT_run_controller.sql218 B2026-07-13 03:27📄ACC-7945_delete_product_upcs.sql1.3 KB2026-07-13 03:27📄ACC-7934-2_create_missing_abacus_account_779875.sql2.5 KB2026-07-13 03:27📄ACC-7934-1_create_missing_abacus_account_73432.sql2.5 KB2026-07-13 03:27📄ACC-7933_insert_reference_mechanical_rate.sql419 B2026-07-13 03:27📄ACC-7926_update_schedule_attachment_incorrect_records.sql3.7 KB2026-07-13 03:27📄ACC-7880-update-run-controller.sql258 B2026-07-13 03:27📄ACC-7876-delete-sales-file.sql937 B2026-07-13 03:27📄ACC-7863-update-run-controller.sql258 B2026-07-13 03:27📄ACC-7861-delete-account-and-contract.sql6.2 KB2026-07-13 03:27📄ACC-7860_release_reserves.sql3.4 KB2026-07-13 03:27📄ACC-7859_update_contract_start_date.sql468 B2026-07-13 03:27📄ACC-7859-1_update_contract_initial_start_date.sql399 B2026-07-13 03:27📄ACC-7856-update-run-controller-contract-type.sql598 B2026-07-13 03:27📄ACC-7851-link-unallocated-contract-to-account.sql419 B2026-07-13 03:27📄ACC-7846_link_isrcs_to_track_term.sql543 B2026-07-13 03:27📄ACC-7841_update_contract_start_date.sql910 B2026-07-13 03:27📄ACC-7841-1_update_contract_initial_start_date.sql773 B2026-07-13 03:27📄ACC-7840_add_track_isrcs.sql1.2 KB2026-07-13 03:27📄ACC-7840-2_add_track_isrcs.sql655 B2026-07-13 03:27📄ACC-7839-update-run-controller.sql322 B2026-07-13 03:27📄ACC-7838_delete_abacus_account.sql1.5 KB2026-07-13 03:27📄ACC-7837-4_bulk_update_contributions_for_schedule.sql178.1 KB2026-07-13 03:27📄ACC-7837-3_bulk_update_contributions_for_schedule.sql72.8 KB2026-07-13 03:27📄ACC-7837-2_bulk_update_contributions_for_schedule.sql70.9 KB2026-07-13 03:27📄ACC-7837-1_bulk_update_contributions_for_schedule.sql66.2 KB2026-07-13 03:27📄ACC-7823_backfill_contract_lifecycle_last_renewed.sql1.1 KB2026-07-13 03:27📄ACC-7797-backfill-contract-mech-deductions.sql155.1 KB2026-07-13 03:27📄ACC-7773-group-mechanical-transaction-types.sql786 B2026-07-13 03:27📄ACC-7737-update-account-currency.sql909 B2026-07-13 03:27📄ACC-7735-4_grant_trigger_to_refresh_user.sql222 B2026-07-13 03:27📄ACC-7735-3_add_select_to_user.sql475 B2026-07-13 03:27📄ACC-7735-2_add_service_user_for_refresh.sql475 B2026-07-13 03:27📄ACC-7733-1_backfill_execution_date.sql2.3 KB2026-07-13 03:27📄ACC-7729_update_tract_exceptions.sql611 B2026-07-13 03:27📄ACC-7728-update-run-controller.sql580 B2026-07-13 03:27📄ACC-7727-delete-contracts.sql5.6 KB2026-07-13 03:27📄ACC-7726_delete_abacus_accounts.sql2.4 KB2026-07-13 03:27📄ACC-7714_update_track_exceptions.sql775 B2026-07-13 03:27📄ACC-7704-1_replay_ledger_36772.sql35.2 KB2026-07-13 03:27📄ACC-7695-update-apply_adj_rollback.sql436 B2026-07-13 03:27📄ACC-7646-delete-abacus-event-for-UR-contract.sql425 B2026-07-13 03:27📄ACC-7646-create-unallocated-revenue-contract.sql2.8 KB2026-07-13 03:27📄ACC-7646-create-abacus-state-and-event-for-UR-contract.sql967 B2026-07-13 03:27📄ACC-7613_update_run_controller.sql509 B2026-07-13 03:27📄ACC-7610-delete-contract.sql8.2 KB2026-07-13 03:27📄ACC-7600-1_new_contributions.sql214.6 KB2026-07-13 03:27📄ACC-7596_add_isrcs_to_track_exception.sql1.1 KB2026-07-13 03:27📄ACC-7594-update-run-controller.sql322 B2026-07-13 03:27📄ACC-7593_delete_abacus_accounts.sql2.1 KB2026-07-13 03:27📄ACC-7593-delete-account-and-contract.sql4.5 KB2026-07-13 03:27📄ACC-7589_update_reference_signing_entity_id.sql464 B2026-07-13 03:27📄ACC-7588_add_isrcs_to_track_exception.sql489 B2026-07-13 03:27📄ACC-7564_update_account_currency.sql466 B2026-07-13 03:27📄ACC-7549-update-account-currency.sql879 B2026-07-13 03:27📄ACC-7533-update-signing-entity.sql750 B2026-07-13 03:27📄ACC-7532-update-run-controller.sql479 B2026-07-13 03:27📄ACC-7531-delete-contracts.sql7.7 KB2026-07-13 03:27📄ACC-7530_delete_abacus_accounts.sql3.8 KB2026-07-13 03:27📄ACC-7530-delete-contract.sql2.6 KB2026-07-13 03:27📄ACC-7529_create_track_exceptions.sql1.1 KB2026-07-13 03:27📄ACC-7529_create_term_conditions.sql5.4 KB2026-07-13 03:27📄ACC-7528-add-products-to-contract.sql928 B2026-07-13 03:27📄ACC-7520-add-digital-txn-types.sql494.9 KB2026-07-13 03:27📄ACC-7508-3_add_FP_to_FS_conditions.sql1.0 KB2026-07-13 03:27📄ACC-7508-2_add_FP_to_template.sql1.2 KB2026-07-13 03:27📄ACC-7508-1_add_FP_transaction_type.sql658 B2026-07-13 03:27📄ACC-7493-remove-duplicate-rows-in-adjustments.sql1.7 KB2026-07-13 03:27📄ACC-7491-update-gda-sap-profit-center.sql352 B2026-07-13 03:27📄ACC-7476-update-current-balance-pointers.sql2.1 KB2026-07-13 03:27📄ACC-7476-reverse-duplicate-ledger-account-contract-entries.sql1.0 KB2026-07-13 03:27📄ACC-7476-reverse-duplicate-applied-adjustments.sql2.0 KB2026-07-13 03:27📄ACC-7437-update-run-controllers-to-awal.sql732 B2026-07-13 03:27📄ACC-7436-delete-contracts.sql3.8 KB2026-07-13 03:27📄ACC-7434-backfill-reference-mechanical-rates.sql791 B2026-07-13 03:27📄ACC-7434-backfill-reference-mechanical-rates-fix.sql833 B2026-07-13 03:27📄ACC-7432-remove-reserve-from-contract.sql323 B2026-07-13 03:27📄ACC-7426-1_backfill_lifecycle.sql5.5 KB2026-07-13 03:27📄ACC-7354-1_retitle_groups.sql1.3 KB2026-07-13 03:27📄ACC-7347-release-reserves-early.sql18.0 KB2026-07-13 03:27📄ACC-7346-update-run-controller-to-awal.sql306 B2026-07-13 03:27📄ACC-7346-1-update-run-controller-to-awal.sql258 B2026-07-13 03:27📄ACC-7345-delete-multiple-contract.sql10.4 KB2026-07-13 03:27📄ACC-7344-1_fix_nonseq_priorities.sql177.8 KB2026-07-13 03:27📄ACC-7296_insert_calculations_for_flowthrough.sql1.1 KB2026-07-13 03:27📄ACC-7296_2_insert_calculations_for_flowthrough.sql1.1 KB2026-07-13 03:27📄ACC-7294-soft-delete-worksheet-adjustments-and-details.sql1.1 KB2026-07-13 03:27📄ACC-7283-4_reverse_vat_546418_p305.sql1.7 KB2026-07-13 03:27📄ACC-7249-correction-reversal-abacus-events.sql435 B2026-07-13 03:27📄ACC-7238-correction-reversal-abacus-events.sql435 B2026-07-13 03:27📄ACC-7237-update-run-controller-to-knr.sql253 B2026-07-13 03:27📄ACC-7218-delete-base-terms-and-exceptions.sql2.5 KB2026-07-13 03:27📄ACC-7217-update-run-controller-to-awal.sql467 B2026-07-13 03:27📄ACC-7216-release-reserves-early.sql22.7 KB2026-07-13 03:27📄ACC-7214-2_cleanup_sort_quotes.sql3.9 KB2026-07-13 03:27📄ACC-7214-1_add_UQ_NQ_to_stream_conds.sql1.4 KB2026-07-13 03:27📄ACC-7209-fix-statement-period-states.sql1.7 KB2026-07-13 03:27📄ACC-7193-remove-extra-applied-adjustments.sql6.1 KB2026-07-13 03:27📄ACC-7193-5_fix_manual_adj_for_532363.sql2.8 KB2026-07-13 03:27📄ACC-7193-4_delete_general_ledger_2.sql2.7 KB2026-07-13 03:27📄ACC-7193-3_update_current_bals.sql1.9 KB2026-07-13 03:27📄ACC-7193-2_delete_general_ledger.sql10.6 KB2026-07-13 03:27📄ACC-7180-2_add_UQ_NQ_transaction_types.sql854 B2026-07-13 03:27📄ACC-7149-update-run-controller.sql253 B2026-07-13 03:27📄ACC-7135-release-reserves-early.sql28.3 KB2026-07-13 03:27📄ACC-7134_remove_base_terms_or_track_exceptions_from_contracts.sql1.5 KB2026-07-13 03:27📄ACC-7133_add_ISRCs_to_track_exceptions.sql1.1 KB2026-07-13 03:27📄ACC-7113-update-statement_period_adjustment_file.sql1.4 KB2026-07-13 03:27📄ACC-7058-4_add_FS_to_all_AWAL.sql2.0 KB2026-07-13 03:27📄ACC-7058-3_stringify_all_ttypes.sql857 B2026-07-13 03:27📄ACC-7058-2_update_contract_template.sql1.2 KB2026-07-13 03:27📄ACC-7058-1_add_FS_to_GDA_conds.sql1.5 KB2026-07-13 03:27📄ACC-7054-ACC-7132-update-run-controller-contract.sql947 B2026-07-13 03:27📄ACC-7020_delete_base_terms.sql920 B2026-07-13 03:27📄ACC-7019-delete_product_track_exceptions.sql1.3 KB2026-07-13 03:27📄ACC-7018-delete-contract-545744.sql2.8 KB2026-07-13 03:27📄ACC-7017-update-run-controller-to-awal.sql579 B2026-07-13 03:27📄ACC-7003-5_add_workstation_group_trans_types.sql3.8 KB2026-07-13 03:27📄ACC-7003-4_add_trans_group_trans_types.sql2.4 KB2026-07-13 03:27📄ACC-6958-backfill-missing-contract-sync-events.sql1.8 KB2026-07-13 03:27📄ACC-6950-cleanup-nr-contracts.sql981 B2026-07-13 03:27📄ACC-6941-drop-rollback-tables.sql299 B2026-07-13 03:27📄ACC-6930_Create_Track_Exceptions.sql1.4 KB2026-07-13 03:27📄ACC-6930-2_Copy_Term_Conditions_For_New_Track_Exceptions.sql4.8 KB2026-07-13 03:27📄ACC-6929-2_new_contributions.sql2.8 MB2026-07-13 03:27📄ACC-6929-1_new_schedules.sql18.0 KB2026-07-13 03:27📄ACC-6927-delete_term_id_on_contract.sql792 B2026-07-13 03:27📄ACC-6926-add-products-to-contract.sql8.7 KB2026-07-13 03:27📄ACC-6925-delete-product-base-and-revert-previous-product-base.sql1.1 KB2026-07-13 03:27📄ACC-6919_update_contract_term_exception.sql661 B2026-07-13 03:27📄ACC-6912_fix_11_digit_upcs.sql5.8 KB2026-07-13 03:27📄ACC-6910_delete_base_terms.sql920 B2026-07-13 03:27📄ACC-6909-delete_product_exceptions.sql918 B2026-07-13 03:27📄ACC-6908-update-run-controller-to-awal.sql402 B2026-07-13 03:27📄ACC-6903-1_backfill_missing_SA_types.sql2.2 KB2026-07-13 03:27📄ACC-6898-1_add_txn_types_to_GDA.sql1.1 KB2026-07-13 03:27📄ACC-6897-1_update_template_w_ttypes.sql1.0 KB2026-07-13 03:27📄ACC-6896_delete_contracts.sql4.4 KB2026-07-13 03:27📄ACC-6896_delete_base_terms.sql924 B2026-07-13 03:27📄ACC-6887-delete-account.sql330 B2026-07-13 03:27📄ACC-6836-1_invalid_contributions.sql7.1 KB2026-07-13 03:27📄ACC-6831-delete-track-exceptions.sql1.3 KB2026-07-13 03:27📄ACC-6822-2_change_ttype_TR_to_TRL.sql275 B2026-07-13 03:27📄ACC-6811-update-abacus_event-table.sql1.2 KB2026-07-13 03:27📄ACC-6811-backfill-ledger_adjustment_applied.sql1.0 KB2026-07-13 03:27📄ACC-6811-2_update_abacus_adjustment_backfill_dates.sql3.5 KB2026-07-13 03:27📄ACC-6811-2-backfill-abacus_state.sql2.3 KB2026-07-13 03:27📄ACC-6806-knr-vat-301.sql443.2 KB2026-07-13 03:27📄ACC-6796-rename-sales-file.sql476 B2026-07-13 03:27📄ACC-6795-delete-sales-file.sql437 B2026-07-13 03:27📄ACC-6783-update-run-controller-to-awal.sql275 B2026-07-13 03:27📄ACC-6782-delete_base_terms.sql914 B2026-07-13 03:27📄ACC-6755-delete-contract-544723.sql2.5 KB2026-07-13 03:27📄ACC-6755-delete-contract-544717.sql2.5 KB2026-07-13 03:27📄ACC-6755-delete-contract-544716.sql2.5 KB2026-07-13 03:27📄ACC-6754-delete-exceptions-for-contracts.sql1.1 KB2026-07-13 03:27📄ACC-6753-delete-base-terms-and-exceptions.sql5.7 KB2026-07-13 03:27📄ACC-6751-update-taken-statement-period-in-reserve-schedule.sql616 B2026-07-13 03:27📄ACC-6751-release-reserves-early.sql52.0 KB2026-07-13 03:27📄ACC-6750-update-run-controller-to-awal.sql546 B2026-07-13 03:27📄ACC-6736_insert_new_transaction_type_spatial_subscription_audio_streams.sql316 B2026-07-13 03:27📄ACC-6736-1_backfill_new_transaction_type.sql2.0 KB2026-07-13 03:27📄ACC-6733-account-47854-contract.sql4.0 KB2026-07-13 03:27📄ACC-6728-create-missing-account.sql3.0 KB2026-07-13 03:27📄ACC-6720-add-missing-payment-detail.sql1.8 KB2026-07-13 03:27📄ACC-6719-delete-orphan-contracts.sql8.4 KB2026-07-13 03:27📄ACC-6712-backfill-payment-entity-for-accounts.sql1.2 KB2026-07-13 03:27📄ACC-6672-knr-vat-300.sql507.5 KB2026-07-13 03:27📄ACC-6670_backfill_snowflake_transaction_type_data_to_reference_transaction_type_table.sql3.6 KB2026-07-13 03:27📄ACC-6651-update-accounting_run-status.sql380 B2026-07-13 03:27📄ACC-6636-delete_base_terms.sql800 B2026-07-13 03:27📄ACC-6627-update-run-controller-to-awal.sql274 B2026-07-13 03:27📄ACC-6626-delete_base_terms.sql1.6 KB2026-07-13 03:27📄ACC-6625-create-missing-account.sql2.6 KB2026-07-13 03:27📄ACC-6571-remove-contract-terms.sql645 B2026-07-13 03:27📄ACC-6539_group_criteria_add_reference_payment_entites_field.sql2.3 KB2026-07-13 03:27📄ACC-6539-update-group-criteria-reference-payment-entities-field.sql2.3 KB2026-07-13 03:27📄ACC-6535-delete_base_terms.sql1.6 KB2026-07-13 03:27📄ACC-6518-Delete-Contract-543780.sql2.5 KB2026-07-13 03:27📄ACC-6484-test-connector.sql431 B2026-07-13 03:27📄ACC-6484-fivetran-service-user.sql1.6 KB2026-07-13 03:27📄ACC-6463-update-contract-term.sql1.5 KB2026-07-13 03:27📄ACC-6459-backfill-reference-signing-entity-id-contract-544134.sql512 B2026-07-13 03:27📄ACC-6459-backfill-reference-signing-entity-and-contract-tables.sql2.0 KB2026-07-13 03:27📄ACC-6457-update-KNR-NL-signing-entity-names.sql640 B2026-07-13 03:27📄ACC-6452-1_update_SE_for_contracts.sql2.6 KB2026-07-13 03:27📄ACC-6446-update-run-controllers.sql295 B2026-07-13 03:27📄ACC-6445-delete_base_terms.sql4.5 KB2026-07-13 03:27📄ACC-6415-1_add_autoadd_to_contribution_schedules.sql878 B2026-07-13 03:27📄ACC-6397-change-account-77549-currency.sql959 B2026-07-13 03:27📄ACC-6394-Delete-Contract-543510.sql2.2 KB2026-07-13 03:27📄ACC-6394-Delete-Contract-543509.sql3.4 KB2026-07-13 03:27📄ACC-6358-9_remove_contributions.sql675 B2026-07-13 03:27📄ACC-6358-8_new_contributions.sql88.0 KB2026-07-13 03:27📄ACC-6358-7_more_condition_updates.sql3.5 KB2026-07-13 03:27📄ACC-6358-6_soft_delete_maneskin.sql1.2 KB2026-07-13 03:27📄ACC-6358-5_update_contracts.sql367 B2026-07-13 03:27📄ACC-6358-4_soft_deletes.sql805 B2026-07-13 03:27📄ACC-6358-3_move_contributions.sql1.0 MB2026-07-13 03:27📄ACC-6358-2_condition_updates.sql1.5 KB2026-07-13 03:27📄ACC-6358-1_contract_terms.sql167.1 KB2026-07-13 03:27📄ACC-6284-7_fix_condition_strings.sql1001 B2026-07-13 03:27📄ACC-6284-6_rm_duplicate_schedule.sql1.2 KB2026-07-13 03:27📄ACC-6284-5_unlink_duplicate_schedules.sql2.0 KB2026-07-13 03:27📄ACC-6284-4_add_is_primary_0_contracts.sql32.4 KB2026-07-13 03:27📄ACC-6284-2_migrate_contribution_terms.sql2.8 MB2026-07-13 03:27📄ACC-6284-1-2_schedules_from_attachments.sql53.8 MB2026-07-13 03:27📄ACC-6284-1-1_schedules_from_attachments.sql52.4 MB2026-07-13 03:27📄ACC-6283-2_migrate_contributor_only_terms.sql2.8 MB2026-07-13 03:27📄ACC-6283-1_add_missing_refs.sql1.8 KB2026-07-13 03:27📄ACC-6283-1_add_contract_party.sql336.9 KB2026-07-13 03:28📄ACC-6281-update-nr-contract-term-types.sql496 B2026-07-13 03:27📄ACC-6259-update-accounting-run-status.sql249 B2026-07-13 03:27📄ACC-6256-hide-from-customer-accounting.sql363 B2026-07-13 03:27📄ACC-6252_contract_terms_01.sql308.5 KB2026-07-13 03:27📄ACC-6252-8_contract_terms.sql32.0 KB2026-07-13 03:27📄ACC-6252-7_condition_updates.sql16.5 KB2026-07-13 03:27📄ACC-6252-6_soft_deletes.sql1001 B2026-07-13 03:27📄ACC-6252-5_new_contributions.sql72.6 KB2026-07-13 03:27📄ACC-6252-4_move_contributions.sql2.3 MB2026-07-13 03:27📄ACC-6252-3_contract_terms.sql349.1 KB2026-07-13 03:27📄ACC-6252-2_update_contracts.sql216 B2026-07-13 03:27📄ACC-6240-create-missing-accounts.sql4.1 KB2026-07-13 03:27📄ACC-6236-correction-abacus-events.sql918 B2026-07-13 03:27📄ACC-6178-delete-account-78420.sql314 B2026-07-13 03:27📄ACC-6164-fix-double-booked-royalties.sql2.9 KB2026-07-13 03:27📄ACC-6156_migrate_awal_accounts.sql9.4 KB2026-07-13 03:27📄ACC-6155_update_contracts_2.sql1.2 KB2026-07-13 03:27📄ACC-6155_update_contracts_1.sql1.1 KB2026-07-13 03:27📄ACC-6155_update_conditions_1.sql5.2 KB2026-07-13 03:27📄ACC-6155_soft_deletes_2.sql695 B2026-07-13 03:27📄ACC-6155_soft_deletes_1.sql693 B2026-07-13 03:27📄ACC-6155_new_contributions_11.sql79.0 KB2026-07-13 03:27📄ACC-6155_new_contributions_03.sql3.2 KB2026-07-13 03:27📄ACC-6155_new_conditions_1.sql927 B2026-07-13 03:27📄ACC-6155_move_contributions_02.sql93.3 KB2026-07-13 03:27📄ACC-6155_contract_terms_09.sql68.1 KB2026-07-13 03:27📄ACC-6155_contract_terms_01.sql24.3 KB2026-07-13 03:27📄ACC-6147_migrate_accounts.sql55.9 KB2026-07-13 03:27📄ACC-6146_migrate_accounts.sql3.6 KB2026-07-13 03:27📄ACC-6142_migrate_awal_accounts.sql1.9 KB2026-07-13 03:27📄ACC-6140_rename_accounts.sql2.1 KB2026-07-13 03:27📄ACC-6139_migrate_accounts.sql5.3 KB2026-07-13 03:27📄ACC-6137-backfilll-commission-column-1.sql327 B2026-07-13 03:27📄ACC-6137-backfill-commission-column.sql203 B2026-07-13 03:27📄ACC-6130_rename_contracts.sql916 B2026-07-13 03:27📄ACC-6130_migrate_awal_accounts.sql5.6 KB2026-07-13 03:27📄ACC-6122_migrate_knr_accounts.sql3.6 KB2026-07-13 03:27📄ACC-6121_migrate_awal_accounts.sql7.5 KB2026-07-13 03:27📄ACC-6112_migrate_awal_accounts.sql5.6 KB2026-07-13 03:27📄ACC-6086-correction-abacus-events.sql1.5 KB2026-07-13 03:27📄ACC-6081_update_contracts_2.sql1.6 KB2026-07-13 03:27📄ACC-6081_update_contracts_09.sql587 B2026-07-13 03:27📄ACC-6081_update_conditions_13.sql2.5 KB2026-07-13 03:27📄ACC-6081_update_conditions_08.sql6.5 KB2026-07-13 03:27📄ACC-6081_update_conditions_01.sql5.8 KB2026-07-13 03:27📄ACC-6081_soft_deletes_1.sql749 B2026-07-13 03:27📄ACC-6081_remove_contributions_10.sql2.8 KB2026-07-13 03:27📄ACC-6081_new_contributions_15.sql16.4 KB2026-07-13 03:27📄ACC-6081_new_contributions_14.sql17.9 KB2026-07-13 03:27📄ACC-6081_new_contributions_12.sql1.1 KB2026-07-13 03:27📄ACC-6081_new_contributions_06.sql220.7 KB2026-07-13 03:27📄ACC-6081_move_contributions_11.sql142.8 KB2026-07-13 03:27📄ACC-6081_move_contributions_05.sql594.5 KB2026-07-13 03:27📄ACC-6081_contract_terms_07.sql1.9 KB2026-07-13 03:27📄ACC-6081_contract_terms_01.sql137.4 KB2026-07-13 03:27📄ACC-6068-reset-payment-batch-statuses.sql1.1 KB2026-07-13 03:27📄ACC-6066_migrate_awal_accounts.sql1.9 KB2026-07-13 03:27📄ACC-6056_migrate_awal_accounts.sql11.4 KB2026-07-13 03:27📄ACC-6055-account-name-changes.sql2.0 KB2026-07-13 03:27📄ACC-6050_migrate_knr_accounts.sql1.8 KB2026-07-13 03:27📄ACC-6049-reset-payment-batch-status.sql450 B2026-07-13 03:27📄ACC-6036_rename_abacus_contracts.sql4.2 KB2026-07-13 03:27📄ACC-6035_migrate_knr_accounts.sql7.0 KB2026-07-13 03:27📄ACC-6034_migrate_awal_accounts.sql5.6 KB2026-07-13 03:27📄ACC-6031_update_payment_entity_id_using_signing_entity_id.sql328 B2026-07-13 03:27📄ACC-6031_backfill_reference_payment_entity_id_using_signing_entity_id.sql1.3 KB2026-07-13 03:27📄ACC-6031-insert-payment-entities.sql666 B2026-07-13 03:27📄ACC-6023-null-gda-contract-term-end-dates.sql848 B2026-07-13 03:27📄ACC-6021_migrate_awal_accounts_2.sql2.0 KB2026-07-13 03:27📄ACC-6021_migrate_awal_accounts.sql3.8 KB2026-07-13 03:27📄ACC-6016_add_service_user_select_grant.sql266 B2026-07-13 03:27📄ACC-5986_migrate_knr_accounts.sql3.6 KB2026-07-13 03:27📄ACC-5985_migrate_awal_accounts.sql7.5 KB2026-07-13 03:27📄ACC-5981-fix-double-released-reserves-acct-70140.sql2.6 KB2026-07-13 03:27📄ACC-5980-knr-vat-292-reversal-correction.sql5.6 KB2026-07-13 03:27📄ACC-5974_rename_accounts.sql1.7 KB2026-07-13 03:27📄ACC-5963-update-run-controller.sql266 B2026-07-13 03:27📄ACC-5960_migrate_awal_accounts.sql13.2 KB2026-07-13 03:27📄ACC-5959_update_contract_terms_8.sql733 B2026-07-13 03:27📄ACC-5955-early-release-reserves-acct-70140.sql6.9 KB2026-07-13 03:27📄ACC-5951_delete_base_terms.sql1.7 KB2026-07-13 03:27📄ACC-5949_update_primary_12.sql420 B2026-07-13 03:27📄ACC-5949_update_contract_terms_01.sql3.3 KB2026-07-13 03:27📄ACC-5949_update_conditions_09.sql876 B2026-07-13 03:27📄ACC-5949_update_conditions_06.sql2.9 KB2026-07-13 03:27📄ACC-5949_soft_deletes_11.sql723 B2026-07-13 03:27📄ACC-5949_soft_deletes_01.sql945 B2026-07-13 03:27📄ACC-5949_remove_contributions_10.sql2.2 KB2026-07-13 03:27📄ACC-5949_new_contributions_13.sql34.2 KB2026-07-13 03:27📄ACC-5949_move_contributions_05.sql223.5 KB2026-07-13 03:27📄ACC-5949_contract_terms_07.sql155.6 KB2026-07-13 03:27📄ACC-5949_contract_terms_04.sql4.7 KB2026-07-13 03:27📄ACC-5949_contract_terms_01.sql570.6 KB2026-07-13 03:27📄ACC-5945_update_contracts_company_code_293.sql1.3 KB2026-07-13 03:27📄ACC-5944_KNR_VAT_293_NR.sql409.2 KB2026-07-13 03:27📄ACC-5944_KNR_VAT_293_KNR_Label.sql3.1 KB2026-07-13 03:27📄ACC-5942_migrate_knr_accounts.sql3.6 KB2026-07-13 03:27📄ACC-5938-change-account-76317-currency.sql892 B2026-07-13 03:27📄ACC-5935_migrate_awal_accounts.sql5.6 KB2026-07-13 03:27📄ACC-5916_update_contracts_company_code.sql1.3 KB2026-07-13 03:27📄ACC-5915_rename_contracts.sql4.2 KB2026-07-13 03:27📄ACC-5914_migrate_knr_accounts.sql20.9 KB2026-07-13 03:27📄ACC-5910_migrate_awal_accounts.sql2.0 KB2026-07-13 03:27📄ACC-5907_migrate_awal_accounts.sql5.7 KB2026-07-13 03:27📄ACC-5893_soft_delete_track_exceptions.sql611 B2026-07-13 03:27📄ACC-5891_update_run_controller_extra_contract.sql232 B2026-07-13 03:27📄ACC-5891_update_run_controller.sql369 B2026-07-13 03:27📄ACC-5890_delete_base_terms.sql913 B2026-07-13 03:27📄ACC-5889_update_run_controller_for_contracts.sql369 B2026-07-13 03:27📄ACC-5888_update_contract_run_controller.sql241 B2026-07-13 03:27📄ACC-5887_migrate_awal_accounts.sql7.5 KB2026-07-13 03:27📄ACC-5886_restore_base_terms.sql855 B2026-07-13 03:27📄ACC-5885_rename_accounts.sql447 B2026-07-13 03:27📄ACC-5883-5884_migrate_knr_awal_accounts.sql11.2 KB2026-07-13 03:27📄ACC-5883-5884_migrate_awal_knr_accounts.sql11.2 KB2026-07-13 03:27📄ACC-5865-sync-contract-states.sql602 B2026-07-13 03:27📄ACC-5859_migrate_knr_accounts.sql10.5 KB2026-07-13 03:27📄ACC-5857_rename_abacus_accounts.sql1.3 KB2026-07-13 03:27📄ACC-5856-change-account-72801-currency.sql936 B2026-07-13 03:27📄ACC-5854_migrate_knr_accounts.sql3.6 KB2026-07-13 03:27📄ACC-5853_migrate_awal_accounts.sql18.8 KB2026-07-13 03:27📄ACC-5839_term_rate_change_3.sql1.4 KB2026-07-13 03:27📄ACC-5839_soft_deletes_4.sql693 B2026-07-13 03:27📄ACC-5839_new_contributions_10.sql1.7 KB2026-07-13 03:27📄ACC-5839_new_contributions_07.sql2.2 KB2026-07-13 03:27📄ACC-5839_new_contributions_05.sql42.6 KB2026-07-13 03:27📄ACC-5839_move_contributions_09.sql2.9 KB2026-07-13 03:27📄ACC-5839_more_term_rate_changes_6.sql654 B2026-07-13 03:27📄ACC-5839_2_new_contributions.sql10.7 KB2026-07-13 03:27📄ACC-5839_1_contract_terms.sql351.2 KB2026-07-13 03:27📄ACC-5837-remove-base-terms-on-contracts.sql699 B2026-07-13 03:27📄ACC-5835_delete_abacus_accounts.sql1.1 KB2026-07-13 03:27📄ACC-5834_delete_abacus_contracts.sql1.3 KB2026-07-13 03:27📄ACC-5826_add_knr_payments.sql8.4 KB2026-07-13 03:27📄ACC-5826-make-knr-payments-293.sql8.4 KB2026-07-13 03:27📄ACC-5824_update_contracts_company_code.sql1.4 KB2026-07-13 03:27📄ACC-5823_KNR_VAT_292.sql327.5 KB2026-07-13 03:27📄ACC-5813-move-contracts-to-AWAL-RC.sql259 B2026-07-13 03:27📄ACC-5812_update_invalid_currency_code.sql213 B2026-07-13 03:27📄ACC-5811-update-contract-531572-terms.sql2.3 KB2026-07-13 03:27📄ACC-5809_hard_delete_payment_group.sql1.0 KB2026-07-13 03:27📄ACC-5806_create_smp_contracts.sql785.6 KB2026-07-13 03:27📄ACC-5806_2_add_contribs.sql5.2 MB2026-07-13 03:27📄ACC-5797_migrate_awal_accounts_to_abacus.sql5.6 KB2026-07-13 03:27📄ACC-5786-update-contract-company-code-291.sql580 B2026-07-13 03:27📄ACC-5784-knr-vat-291.sql411.3 KB2026-07-13 03:27📄ACC-5782-make-knr-payments-291.sql8.4 KB2026-07-13 03:27📄ACC-5781_migrate_awal_accounts_to_abacus.sql7.6 KB2026-07-13 03:27📄ACC-5770_migrate_knr_to_abacus.sql533.4 KB2026-07-13 03:27📄ACC-5767_08_add_more_contribs_for_291.sql53.9 KB2026-07-13 03:27📄ACC-5767_07_update_contributions_for_291.sql760 B2026-07-13 03:27📄ACC-5767_07_is_primary_for_calc.sql1.4 KB2026-07-13 03:27📄ACC-5767_06_soft_deletes.sql777 B2026-07-13 03:27📄ACC-5767_05_contribs_to_rm.sql106.9 KB2026-07-13 03:27📄ACC-5767_04_contribs_to_add.sql14.3 KB2026-07-13 03:27📄ACC-5767_03_update_contributions_for_291.sql761 B2026-07-13 03:27📄ACC-5767_02_term_rate_changes.sql983 B2026-07-13 03:27📄ACC-5767_01_add_new_contracts.sql84.7 KB2026-07-13 03:27📄ACC-5765_migrate_awal_account_to_abacus.sql2.2 KB2026-07-13 03:27📄ACC-5758_migrate_awal_accounts_to_abacus.sql6.1 KB2026-07-13 03:27📄ACC-5757_delete_contract_terms.sql346 B2026-07-13 03:27📄ACC-5756-move-contracts-to-run-controller.sql281 B2026-07-13 03:27📄ACC-5753-early-release-reserves-acct-45068.sql17.5 KB2026-07-13 03:27📄ACC-5748_update_abacus_accounts_redux.sql1.6 KB2026-07-13 03:27📄ACC-5748_rename_accounts.sql1.6 KB2026-07-13 03:27📄ACC-5748_migrate_knr_accounts.sql8.8 KB2026-07-13 03:27📄ACC-5746_migrate_awal_accounts_to_abacus.sql6.0 KB2026-07-13 03:27📄ACC-5725_remove_truncated_detail_ids.sql1.0 KB2026-07-13 03:27📄ACC-5725_3_update_detail_counts.sql8.1 KB2026-07-13 03:27📄ACC-5725_2_add_details_to_adjustments.sql50.3 KB2026-07-13 03:27📄ACC-5725_1_add_details_to_adjustments.sql73.7 KB2026-07-13 03:27📄ACC-5712-backfill-adjustment-detail-applied.sql5.0 KB2026-07-13 03:27📄ACC-5707_update_abacus_account_names.sql2.3 KB2026-07-13 03:27📄ACC-5706_update_glassnote_payment_schedules.sql2.3 KB2026-07-13 03:27📄ACC-5669_update_contracts.sql2.7 KB2026-07-13 03:27📄ACC-5668_update_contract_company_codes.sql980 B2026-07-13 03:27📄ACC-5664_update_payment_schedule.sql189 B2026-07-13 03:27📄ACC-5662-knr-vat-290.sql206.2 KB2026-07-13 03:27📄ACC-5650_migrate_knr_accounts.sql3.6 KB2026-07-13 03:27📄ACC-5645_update_adjustment_type.sql5.9 KB2026-07-13 03:27📄ACC-5641_8_term_rate_changes.sql645 B2026-07-13 03:27📄ACC-5641_7_update_is_primary_for_calc_290.sql491 B2026-07-13 03:27📄ACC-5641_6_contributions_to_add_290.sql34.1 KB2026-07-13 03:27📄ACC-5641_5_update_is_primary_for_calc_290.sql484 B2026-07-13 03:27📄ACC-5641_4_add_UK_to_condition_290.sql822 B2026-07-13 03:27📄ACC-5641_3_term_rate_changes.sql1.1 KB2026-07-13 03:27📄ACC-5641_2_new_contract_290.sql1.5 KB2026-07-13 03:27📄ACC-5641_13_contributions_to_add_290.sql765 B2026-07-13 03:27📄ACC-5641_12_term_rate_changes.sql629 B2026-07-13 03:27📄ACC-5641_11_contributions_to_add_290.sql2.7 KB2026-07-13 03:27📄ACC-5641_10_contributions_to_add_290.sql564 B2026-07-13 03:27📄ACC-5641_01_soft_deletes_290.sql721 B2026-07-13 03:27📄ACC-5631-make-knr-payments-290.sql6.1 KB2026-07-13 03:27📄ACC-5630_migrate_knr_accounts.sql12.3 KB2026-07-13 03:27📄ACC-5627_migrate_awal_accounts_to_abacus.sql10.0 KB2026-07-13 03:27📄ACC-5626_abacus_account_name_changes.sql4.8 KB2026-07-13 03:27📄ACC-5617_migrate_awal_to_abacus.sql6.1 KB2026-07-13 03:27📄ACC-5616-delete-track-exceptions-for-contract-531813.sql1.1 KB2026-07-13 03:27📄ACC-5615-update-account-75096-currency-to-usd.sql481 B2026-07-13 03:27📄ACC-5595_migrate_awal_account_to_abacus.sql4.0 KB2026-07-13 03:27📄ACC-5593-delete-product-and-track-exceptions-for-contract-533171.sql1.3 KB2026-07-13 03:27📄ACC-5581_migrate_awal_account_to_abacus.sql2.1 KB2026-07-13 03:27📄ACC-5575_migrate_awal_account_to_abacus.sql2.1 KB2026-07-13 03:27📄ACC-5538_KNR_update_payment_schedules.sql293 B2026-07-13 03:27📄ACC-5535-knr-vat-289.sql353.6 KB2026-07-13 03:27📄ACC-5522-update-knr-contract.sql797 B2026-07-13 03:27📄ACC-5521-knr-289-vat-amendments.sql3.0 KB2026-07-13 03:27📄ACC-5507_import_sax_contracts_for_awal.sql289.0 KB2026-07-13 03:27📄ACC-5506-make-knr-payments-289.sql6.1 KB2026-07-13 03:27📄ACC-5505_rename_awal_account.sql559 B2026-07-13 03:27📄ACC-5503-contract-536087-remove-track-term.sql916 B2026-07-13 03:27📄ACC-5500_14_add_contract_terms_289.sql5.9 KB2026-07-13 03:27📄ACC-5500_13_add_contribs_289.sql194.6 KB2026-07-13 03:27📄ACC-5500_12_nr_fix_rate_changes_289.sql1.4 KB2026-07-13 03:27📄ACC-5500_11_add_contract_term_289.sql744 B2026-07-13 03:27📄ACC-5500_10_remove_more_countries_289.sql3.7 KB2026-07-13 03:27📄ACC-5500_09_remove_countries_289.sql400 B2026-07-13 03:27📄ACC-5500_08_nr_rate_changes_289.sql2.9 KB2026-07-13 03:27📄ACC-5500_07_replace_att_relations_289.sql1.4 KB2026-07-13 03:27📄ACC-5500_06_contribs_to_remove_289.sql9.0 KB2026-07-13 03:27📄ACC-5500_05_new_contracts_289.sql11.3 KB2026-07-13 03:27📄ACC-5500_04_new_split_schedules.sql27.0 KB2026-07-13 03:27📄ACC-5500_03_more_is_primary_updates.sql1.1 KB2026-07-13 03:27📄ACC-5500_02_update_is_primary_for_calc_289.sql634 B2026-07-13 03:27📄ACC-5500_01_update_split_schedule_289.sql1012 B2026-07-13 03:27📄ACC-5496_migrate_awal_account_to_abacus.sql2.0 KB2026-07-13 03:27📄ACC-5495_change_abacus_account_names.sql3.8 KB2026-07-13 03:27📄ACC-5489_delete_contract_advances.sql1.7 KB2026-07-13 03:27📄ACC-5487_create_knr_accounts.sql5.3 KB2026-07-13 03:27📄ACC-5486_switch_run_controller_for_contract.sql293 B2026-07-13 03:27📄ACC-5485_change_payment_schedule_for_account.sql477 B2026-07-13 03:27📄ACC-5482_update-awal-contracts-to-label-base-term-attempt-2.sql23.7 KB2026-07-13 03:27📄ACC-5477-update-account-name-for-account-id-66703.sql589 B2026-07-13 03:27📄ACC-5476-replace-curly-apostrophe-in-account-and-contract-names.sql2.6 KB2026-07-13 03:27📄ACC-5468_migrate_awal_customer_to_abacus.sql2.1 KB2026-07-13 03:27📄ACC-5454-update-label-base-term.sql719 B2026-07-13 03:27📄ACC-5453-update-label-base-term.sql752 B2026-07-13 03:27📄ACC-5452-update-jungle-contract-run_controller.sql567 B2026-07-13 03:27📄ACC-5446-remove-account-payment-holds.sql68.5 KB2026-07-13 03:27📄ACC-5442-update-run-controller-for-contract-537456.sql259 B2026-07-13 03:27📄ACC-5441_migrate_awal_account-01302023.sql2.1 KB2026-07-13 03:27📄ACC-5433_migrate_awal_accounts_to_abacus.sql39.8 KB2026-07-13 03:27📄ACC-5432-update-contract-base-term.sql2.0 KB2026-07-13 03:27📄ACC-5423_update_awal_accounts_payment_schedule.sql20.1 KB2026-07-13 03:27📄ACC-5422_soft_delete_terms_from_contract.sql836 B2026-07-13 03:27📄ACC-5420_Rename_contracts_and_accounts.sql11.9 KB2026-07-13 03:27📄ACC-5419-fix-null-attachments-relations.sql31.1 KB2026-07-13 03:27📄ACC-5417-update-contract-base-term.sql5.3 KB2026-07-13 03:27📄ACC-5416-delete-account.sql472 B2026-07-13 03:27📄ACC-5415-update-label-base-term.sql767 B2026-07-13 03:27📄ACC-5414_migrate_knr_accounts.sql1.8 KB2026-07-13 03:27📄ACC-5409-knr-vat-288.sql354.9 KB2026-07-13 03:27📄ACC-5407-knr-vat-fx-285.sql133.6 KB2026-07-13 03:27📄ACC-5401_update_payment_schedule_knr_client.sql193 B2026-07-13 03:27📄ACC-5393_9_set_primary_contracts_288.sql521 B2026-07-13 03:27📄ACC-5393_8_more_contribs_p_288.sql1.1 KB2026-07-13 03:27📄ACC-5393_7_NR_rm_contribs_288.sql5.4 KB2026-07-13 03:27📄ACC-5393_6_NR_more_repertoire_changes_288.sql16.3 KB2026-07-13 03:27📄ACC-5393_5_fix_NR_repertoire_changes_288.sql3.7 KB2026-07-13 03:27📄ACC-5393_4_NR_repertoire_changes_288.sql3.7 KB2026-07-13 03:27📄ACC-5393_3_nr_rates_changes_288.sql2.7 KB2026-07-13 03:27📄ACC-5393_2_soft_deletes.sql744 B2026-07-13 03:27📄ACC-5393_1_new_contracts.sql198.9 KB2026-07-13 03:27📄ACC-5393_10_remove_contrib_288.sql673 B2026-07-13 03:27📄ACC-5390-make-knr-payments-288.sql6.1 KB2026-07-13 03:27📄ACC-5389_update_abacus_account_name.sql3.2 KB2026-07-13 03:27📄ACC-5389_migrate_knr_accounts.sql3.6 KB2026-07-13 03:27📄ACC-5385-close-287-NR-acct-period.sql1.4 KB2026-07-13 03:27📄ACC-5384-create-288-nr-acct-period-data.sql7.5 KB2026-07-13 03:27📄ACC-5381-5382-set-contract-term-end.sql784 B2026-07-13 03:27📄ACC-5375_migrate_knr_accounts_to_abacus.sql7.1 KB2026-07-13 03:27📄ACC-5374-delete_abacus_accounts.sql448 B2026-07-13 03:27📄ACC-5373_5_fix_the_rest_of_ttypes.sql6.2 KB2026-07-13 03:27📄ACC-5373_4_fix_more_ttypes.sql38.7 KB2026-07-13 03:27📄ACC-5373_3_fix_more_ttypes.sql11.4 KB2026-07-13 03:27📄ACC-5373_2_fix_more_ttypes.sql22.3 KB2026-07-13 03:27📄ACC-5373_1_fix_majority_awal_ttypes.sql165.3 KB2026-07-13 03:27📄ACC-5341_awal_payment_holds.sql17.8 KB2026-07-13 03:27📄ACC-5338-update-contract-531843-532649-reserves.sql1.0 KB2026-07-13 03:27📄ACC-5321-consolidate-awal-contracts-into-one-rc.sql829 B2026-07-13 03:27📄ACC-5317_migrate_awal_accounts_to_abacus.sql4.1 KB2026-07-13 03:27📄ACC-5316-attach-newly-ingested-products-for-awal.sql484.6 KB2026-07-13 03:27📄ACC-5313_rename_vendors_and_contracts.sql17.4 KB2026-07-13 03:27📄ACC-5310_migrate_knr_vendors_to_abacus.sql5.3 KB2026-07-13 03:27📄ACC-5302-update-store-exclusions.sql551 B2026-07-13 03:27📄ACC-5302-backfill-legacy-contracts.sql436 B2026-07-13 03:27📄ACC-5300-backfill-missing-contract-exclusion-entries.sql646 B2026-07-13 03:27📄ACC-5290-backfill-remaining-oa-owners.sql446.7 KB2026-07-13 03:27📄ACC-5290-backfill-oa-owner.sql39.0 KB2026-07-13 03:27📄ACC-5284-knr-287-vat-backfill.sql244.4 KB2026-07-13 03:27📄ACC-5283-close-287-NR-acct-period.sql1.4 KB2026-07-13 03:27📄ACC-5282_update_knr_payment_frequency.sql1.5 KB2026-07-13 03:27📄ACC-5280_migrate_awal_accounts_12_15_2022.sql6.0 KB2026-07-13 03:27📄ACC-5274-modify-contract-531253-537283-terms.sql3.8 KB2026-07-13 03:27📄ACC-5263-fix-null-attachments-relations.sql392.9 KB2026-07-13 03:27📄ACC-5262-make-knr-payments-287.sql6.1 KB2026-07-13 03:27📄ACC-5256-create-nr-acct-period-data-287.sql6.0 KB2026-07-13 03:27📄ACC-5252_nr_transaction_types_all.sql960 B2026-07-13 03:27📄ACC-5252_nr_rate_changes_287.sql1.3 KB2026-07-13 03:27📄ACC-5252_novate_paul_williams.sql1.2 KB2026-07-13 03:27📄ACC-5252_mushroom_pillow_yall.sql1008 B2026-07-13 03:27📄ACC-5252_langmaid_special_themes.sql6.3 KB2026-07-13 03:27📄ACC-5252_change_base_terms.sql1.5 KB2026-07-13 03:27📄ACC-5252_add_contributions_to_terms.sql7.8 KB2026-07-13 03:27📄ACC-5230-fix-49229-paid-by.sql1.7 KB2026-07-13 03:27📄ACC-5229_migrate_knr_accounts_12_07_2022.sql3.5 KB2026-07-13 03:27📄ACC-5225_migrate_awal_accounts.sql6.1 KB2026-07-13 03:27📄ACC-5222_update_account_and_contract_names.sql1.1 KB2026-07-13 03:27📄ACC-5221-modify-contract-531777-terms.sql2.2 KB2026-07-13 03:27📄ACC-5219-clean-up-contract-name.sql340 B2026-07-13 03:27📄ACC-5201-delete-test-payment-group-from-prod.sql210 B2026-07-13 03:27📄ACC-5200_create_knr_accounts.sql5.3 KB2026-07-13 03:27📄ACC-5184-backill-reserves.sql521.0 KB2026-07-13 03:27📄ACC-5179_backfill_all_statement_periods_back_through_2013.sql16.0 KB2026-07-13 03:27📄ACC-5166-fix-awal-contract-add-upc.sql408 B2026-07-13 03:27📄ACC-5164_add_vat_to_ledger_knr_fx_fix.sql173.0 KB2026-07-13 03:27📄ACC-5164_add_vat_for_knr_fx_fix.sql84.4 KB2026-07-13 03:27📄ACC-5159_update_knr_payment_frequency_batch_2.sql2.2 KB2026-07-13 03:27📄ACC-5159_update_knr_payment_frequency.sql14.2 KB2026-07-13 03:27📄ACC-5158-manual-acct-run-stmt-286.sql2.3 KB2026-07-13 03:27📄ACC-5152_add_error_adjustment_type.sql210 B2026-07-13 03:27📄ACC-5151-contracts-in-fix-286.sql1.7 KB2026-07-13 03:27📄ACC-5149-change-currency-for-account-42543-EUR.sql482 B2026-07-13 03:27📄ACC-5144-update-contract-term-condition-priority-of-contract-term-66397.sql256 B2026-07-13 03:27📄ACC-5143_rm_repeated_track_term_on_product_terms_5.sql29.0 KB2026-07-13 03:27📄ACC-5143_rm_repeated_track_term_on_product_terms_4.sql19.1 KB2026-07-13 03:27📄ACC-5143_rm_repeated_track_term_on_product_terms_3.sql9.7 KB2026-07-13 03:27📄ACC-5143_rm_repeated_track_term_on_product_terms_2.sql615 B2026-07-13 03:27📄ACC-5143_rm_repeated_track_term_on_product_terms.sql26.6 KB2026-07-13 03:27📄ACC-5139-consolidate-run-controllers.sql16.5 KB2026-07-13 03:27📄ACC-5135-delete-acct-run-74-summary.sql10.2 KB2026-07-13 03:27📄ACC-5134-backfill-knr-286-vat.sql323.1 KB2026-07-13 03:27📄ACC-5133-remove-track-terms.sql10.0 KB2026-07-13 03:27📄ACC-5130-update-knr-contract-and-account-names.sql1.5 KB2026-07-13 03:27📄ACC-5129_create_accounts.sql20.8 KB2026-07-13 03:27📄ACC-5128_remove_repeated_track_terms_rcc_9.sql2.7 KB2026-07-13 03:27📄ACC-5127_rm_repeated_track_terms_51761.sql1.1 KB2026-07-13 03:27📄ACC-5126-update-contract-517144-countires.sql3.9 KB2026-07-13 03:27📄ACC-5123-clean-up-split-rev-contracts.sql477 B2026-07-13 03:27📄ACC-5121-new-rc-awal-c3.sql1.3 KB2026-07-13 03:27📄ACC-5121-invalidate-complicated-2-run.sql589 B2026-07-13 03:27📄ACC-5121-create-new-awal-complicated-rc.sql2.2 KB2026-07-13 03:27📄ACC-5121-complete-awal-complicated-run.sql7.0 KB2026-07-13 03:27📄ACC-5120-close-286-NR-acct-period.sql1.2 KB2026-07-13 03:27📄ACC-5116-make-knr-payments-286.sql6.1 KB2026-07-13 03:27📄ACC-5113-backfill-contract-state.sql1.3 KB2026-07-13 03:27📄ACC-5111-bulk-soft-delete-payments.sql1.5 KB2026-07-13 03:27📄ACC-5104_change_rate_for_acct_68900.sql716 B2026-07-13 03:27📄ACC-5104_change_rate_for_acct_67964.sql742 B2026-07-13 03:27📄ACC-5102-create-NR-acct-period-data-286.sql1.1 KB2026-07-13 03:27📄ACC-5100-remove-contract-terms.sql2.1 KB2026-07-13 03:27📄ACC-5097-move-contracts-out-of-hold-rc.sql1.7 KB2026-07-13 03:27📄ACC-5096-soft-delete-awal-payment-groups.sql374 B2026-07-13 03:27📄ACC-5093_add_ttypes_to_NR_conditions.sql1.7 KB2026-07-13 03:27📄ACC-5093_add_more_ttypes_to_NR_conditions.sql2.9 KB2026-07-13 03:27📄ACC-5089_add_awal_payment_holds.sql32.0 KB2026-07-13 03:27📄ACC-5088-backfill-reserves.sql200.9 KB2026-07-13 03:27📄ACC-5080-on-hold-run-controllers-285.sql8.6 KB2026-07-13 03:27📄ACC-5078-create-new-accounts.sql3.2 KB2026-07-13 03:27📄ACC-5074-update-account-currencies.sql4.6 KB2026-07-13 03:27📄ACC-5065-update-awal-migrated-payment-minimums.sql605 B2026-07-13 03:27📄ACC-5054_fix_terms_for_contract_530913.sql25.0 KB2026-07-13 03:27📄ACC-5054_fix_conditions_for_contract_530913.sql792 B2026-07-13 03:27📄ACC-5052_delete_duplicate_payment_holds.sql2.5 KB2026-07-13 03:27📄ACC-5045-change-account-54200-currency.sql582 B2026-07-13 03:27📄ACC-5040-split-product-groups-rc.sql4.9 KB2026-07-13 03:27📄ACC-5040-cleanup-run-controller-contract.sql12.3 KB2026-07-13 03:27📄ACC-5030-update_contract_names.sql1.2 KB2026-07-13 03:27📄ACC-5029-create-sap-vendor-payments-as-payoneer-program.sql307 B2026-07-13 03:27📄ACC-5028-update-concord-bicycle-contract_type.sql384 B2026-07-13 03:27📄ACC-5027-delete-contract-535876.sql2.8 KB2026-07-13 03:27📄ACC-5026-make-knr-payments-285.sql6.9 KB2026-07-13 03:27📄ACC-5023-Delete-contract-Abacus-bad-SAX-data.sql1.8 KB2026-07-13 03:27📄ACC-5022-cleanup-awal-base-terms.sql2.3 KB2026-07-13 03:27📄ACC-5021-backfill-legacy-contract.sql722.1 KB2026-07-13 03:27📄ACC-5020-Un-delete-AWAL-account-IDs-72796-72838-72765.sql3.3 KB2026-07-13 03:27📄ACC-5019-Simplify-AWAL-terminated-contracts-to-merge-contract_term_conditions-on-countries.sql276.3 KB2026-07-13 03:27📄ACC-5016-Rename-accounts-based-on-Hannah-analysis-for-account-distinguishers.sql20.5 KB2026-07-13 03:27📄ACC-5014-move-contracts-and-delete-account.sql2.4 KB2026-07-13 03:27📄ACC-5014-delete-not-needed-contract.sql3.5 KB2026-07-13 03:27📄ACC-5014-delete-more-not-needed-awal-accounts-some-more.sql2.7 KB2026-07-13 03:27📄ACC-5010_create_commit_vat_events_for_period_285.sql502 B2026-07-13 03:27📄ACC-5010-fix-double-booked-vat.sql11.4 KB2026-07-13 03:27📄ACC-5009-create-knr-ledger_accounting_run_vat-entries.sql321.5 KB2026-07-13 03:27📄ACC-5007-move-more-split-revenue-contracts.sql710 B2026-07-13 03:27📄ACC-5004-insert-new-contract_terms-for-manufacturer-and-display-upcs.sql56.5 KB2026-07-13 03:27📄ACC-5004-fix-contract_term_condition-for-manufacturer-and-display-upcs.sql444.4 KB2026-07-13 03:27📄ACC-5003-Delete-contract-with-ID-536224-from-QA-Abacus-bad-SAX-data.sql1015 B2026-07-13 03:27📄ACC-5002-backfill-2-awal-uk-core-apt.sql451 B2026-07-13 03:27📄ACC-5001-backfil-account-payee-states.sql1.6 KB2026-07-13 03:27📄ACC-4996-update-awal-track-terms-to-not-be-base-terms.sql1.0 KB2026-07-13 03:27📄ACC-4990-close-NR-acct-period.sql936 B2026-07-13 03:27📄ACC-4988-create-contract-states-for-knr-label-run-controller-contracts.sql903 B2026-07-13 03:27📄ACC-4987-move-awal-split-revenue-products-to-new-rc.sql1.0 KB2026-07-13 03:27📄ACC-4986-create-shell-contracts-and-related.sql9.8 KB2026-07-13 03:27📄ACC-4985-delete-more-not-needed-awal-accounts.sql434 B2026-07-13 03:27📄ACC-4984-Move-AWAL-products-Batch-1-to-correct-account-run_controller-update.sql5.0 KB2026-07-13 03:27📄ACC-4982-delete-not-needed-awal-accounts.sql510 B2026-07-13 03:27📄ACC-4979_add_may_2022_statement_period.sql376 B2026-07-13 03:27📄ACC-4977-create-NR-acct-period-data.sql2.4 KB2026-07-13 03:27📄ACC-4967-simplify-complicated-awal-contracts-by-using-label-base-term.sql14.3 KB2026-07-13 03:27📄ACC-4967-simplify-complicated-awal-contracts-by-using-label-base-term-round-2.sql13.0 KB2026-07-13 03:27📄ACC-4967-move-awal-label-base-term-to-new-rcs.sql2.5 KB2026-07-13 03:27📄ACC-4964-create-contract-states-for-knr-run-controller-contracts.sql883 B2026-07-13 03:27📄ACC-4963-create-run-controller-for-oct-27-addtions.sql381 B2026-07-13 03:27📄ACC-4959-fix-knr-paid-by-for-72469.sql452 B2026-07-13 03:27📄ACC-4957-update-currency-for-account-70852.sql957 B2026-07-13 03:27📄ACC-4956-fix-sales-file-states.sql1.0 KB2026-07-13 03:27📄ACC-4953-pull-contracts-for-67046-67155-out-of-knr-label-rc.sql616 B2026-07-13 03:27📄ACC-4951-add-upc-197187127108-to-contract-531125.sql684 B2026-07-13 03:27📄ACC-4950-convert-contract-532795-into-label-based.sql2.2 KB2026-07-13 03:27📄ACC-4949-move-knr-label-contracts-to-correct-account.sql391 B2026-07-13 03:27📄ACC-4948-move-wip-contracts-to-own-rcs.sql3.6 KB2026-07-13 03:27📄ACC-4946-split-product-group-run-controller.sql10.7 KB2026-07-13 03:27📄ACC-4945-delete-unused-run-controller.sql663 B2026-07-13 03:27📄ACC-4944-Insert-terminated-AWAL-TRACK-contract_terms-into-Abacus.sql64.5 KB2026-07-13 03:27📄ACC-4944-Insert-terminated-AWAL-PRODUCT-contract_terms-into-Abacus.sql38.8 KB2026-07-13 03:27📄ACC-4944-Insert-terminated-AWAL-contracts-into-Abacus.sql133.4 KB2026-07-13 03:27📄ACC-4944-Insert-terminated-AWAL-contract_term_conditions-into-Abacus.sql2.1 MB2026-07-13 03:27📄ACC-4944-insert-account_contract-terminated-awal-non-vanilla.sql92.9 KB2026-07-13 03:27📄ACC-4944-backfill-account_payment_term-awal-terminated-accounts.sql1.2 KB2026-07-13 03:27📄ACC-4943-rename-run-controllers.sql805 B2026-07-13 03:27📄ACC-4942-Simplify-AWAL-Product-Groups-contracts-to-merge-contract_term_conditions-on-countries.sql1.7 MB2026-07-13 03:27📄ACC-4941-update-currency-for-account-39547.sql1.3 KB2026-07-13 03:27📄ACC-4940-delete-contract-530820.sql2.8 KB2026-07-13 03:27📄ACC-4938-delete-novated-contract-533283-from-abacus.sql931 B2026-07-13 03:27📄ACC-4937-simplify-biggest-monster-contract-step-1.sql8.3 KB2026-07-13 03:27📄ACC-4928-move-awal-monsters-to-monster-run-controller.sql3.6 KB2026-07-13 03:27📄ACC-4926-insert-label-neighbouring-rights.sql300.2 KB2026-07-13 03:27📄ACC-4926-insert-label-neighbouring-rights-account-contracts-and-run-controllers.sql35.1 KB2026-07-13 03:27📄ACC-4926-insert-concord-contract.sql5.3 KB2026-07-13 03:27📄ACC-4926-add-concord-contract-to-run-controller.sql588 B2026-07-13 03:27📄ACC-4924-add-contracts-to-run-controller.sql295 B2026-07-13 03:27📄ACC-4923-move-now-non-vanilla-AWAL-contracts-to-correct-run-controller.sql6.4 KB2026-07-13 03:27📄ACC-4923-insert-missing-contract_term_condition-for-105-awal-vanilla-contracts.sql62.7 KB2026-07-13 03:27📄ACC-4921-insert-contract_term_condition-for-some-awal-vanilla-contracts.sql169.1 KB2026-07-13 03:27📄ACC-4921-add-missing-contract_terms-for-some-awal-vanilla-contracts.sql404.8 KB2026-07-13 03:27📄ACC-4916-Update-contract_name-in-existing-29K-AWAL-vanilla-contracts-to-contain-SAX-agreement_id-and-NULL-end_date.sql579 B2026-07-13 03:27📄ACC-4914-Import-all-AWAL-Contract-Physical-Reserve-Clauses-into-Abacus.sql260.0 KB2026-07-13 03:27📄ACC-4904-Clean-up-and-clarify-split-account-names-in-royalty_accounting.sql59.3 KB2026-07-13 03:27📄ACC-4898_rename_abacus_account.sql326 B2026-07-13 03:27📄ACC-4898_migrate_vendor_to_abacus.sql1.6 KB2026-07-13 03:27📄ACC-4898_add_oa_vendors_to_abacus_2.sql11.2 KB2026-07-13 03:27📄ACC-4895_production_knr_payment_holds.sql65.5 KB2026-07-13 03:27📄ACC-4886-Insert-remaining-AWAL-TRACK-contract_terms-into-Abacus.sql2.0 MB2026-07-13 03:27📄ACC-4886-Insert-remaining-AWAL-PRODUCT-contract_terms-into-Abacus.sql1.3 MB2026-07-13 03:27📄ACC-4886-Insert-remaining-AWAL-contracts-into-Abacus.sql807.0 KB2026-07-13 03:27📄ACC-4886-Insert-remaining-AWAL-contract_term_conditions-into-Abacus.sql10.2 MB2026-07-13 03:27📄ACC-4886-insert-account_contract-awal-non-vanilla.sql622.2 KB2026-07-13 03:27📄ACC-4878-Update-existing-29K-AWAL-vanilla-contracts-to-set-SAP-profit-center-ID.sql11.7 MB2026-07-13 03:27📄ACC-4873-insert-split-knr-accounts.sql64.0 KB2026-07-13 03:27📄ACC-4873-clean-more-knr-vendors.sql12.8 KB2026-07-13 03:27📄ACC-4870-add-awal-product-run-controller.sql436 B2026-07-13 03:27📄ACC-4867-create-AWAL-test-accounts.sql9.0 KB2026-07-13 03:27📄ACC-4862_delete_awal_contract_term_non-vanilla.sql599 B2026-07-13 03:27📄ACC-4862-delete-non-vanilla-awal-contracts_contracts.sql579 B2026-07-13 03:27📄ACC-4862-delete-non-vanilla-awal-contracts.sql6.0 KB2026-07-13 03:27📄ACC-4862-delete-non-vanilla-awal-contracts-reference_external_source.sql2.0 KB2026-07-13 03:27📄ACC-4862-delete-non-vanilla-awal-contracts-account_contract.sql767 B2026-07-13 03:27📄ACC-4860_create_account_for_awal_vendors.sql516 B2026-07-13 03:27📄ACC-4847-correct-payment_term_currency_code-using-Hannah-decision.sql1.9 KB2026-07-13 03:27📄ACC-4847-correct-payment_term_currency_code-using-external_identifier_2.sql727.8 KB2026-07-13 03:27📄ACC-4844-update-knr-signing-entity.sql1.2 MB2026-07-13 03:27📄ACC-4844-correct-signing_entity_id-based_on_payoneer_program_id.sql192.3 KB2026-07-13 03:27📄ACC-4841_insert_missing_accounts_to_account_payee.sql680 B2026-07-13 03:27📄ACC-4810_add_KNR_signing_entities.sql254 B2026-07-13 03:27📄ACC-4808_backfill_statement_period_program_entity_table.sql14.1 KB2026-07-13 03:27📄ACC-4801-insert-more-reference-sap-profit-centers.sql708 B2026-07-13 03:27📄ACC-4798-Insert-split-AWAL-and-KNR--accounts-into-royalty_accounting.account-table.sql70.8 KB2026-07-13 03:27📄ACC-4791_update_abacus_account_payment_schedule.sql191 B2026-07-13 03:27📄ACC-4781-prod-close-statement-periods.sql2.0 KB2026-07-13 03:27📄ACC-4778_update_account_payment_term_template.sql301 B2026-07-13 03:27📄ACC-4777-set-up-new-awal-account_payees.sql4.7 MB2026-07-13 03:27📄ACC-4777-insert-split-awal-accounts.sql47.4 KB2026-07-13 03:27📄ACC-4777-backfill-account-payee-states.sql773 B2026-07-13 03:27📄ACC-4777-add-missing-account-tax-info.sql443 B2026-07-13 03:27📄ACC-4776-update-agreement-type-id-for-gda-accounts.sql834 B2026-07-13 03:27📄ACC-4774_delete_signing_entites.sql345 B2026-07-13 03:27📄ACC-4773_add_data_to_payment_entity_payoneer_program.sql2.3 KB2026-07-13 03:27📄ACC-4771_remove_and_add_adjustment_types.sql2.6 KB2026-07-13 03:27📄ACC-4771_also_add_transfer_adjustment_type.sql226 B2026-07-13 03:27📄ACC-4771_add_transfer_adjustment_type.sql213 B2026-07-13 03:27📄ACC-4770-Insert-into-royalty_accounting.reference_external_source-for-bank-account-ID-and-currency-code-for-split-off-AWAL-and-KNR-accounts.sql4.9 MB2026-07-13 03:27📄ACC-4727-ingest-contract_term_conditions-for-AWAL-agreements-with-agreement_type-AWAL-for-label-attachments-for-non-worldwide-rights-blocks.sql7.4 KB2026-07-13 03:27📄ACC-4726-populate_reference_external_source-table-with-contract_term-mappings.sql917 B2026-07-13 03:27📄ACC-4726-ingest-contract_terms-for-AWAL-agreements-with-agreement_type-AWAL-for-label-attachment.sql11.7 MB2026-07-13 03:27📄ACC-4725-backfill-awal-distro-account-contracts.sql3.1 MB2026-07-13 03:27📄ACC-4725-backfill-awal-distro-account-contracts-prod.sql3.1 MB2026-07-13 03:27📄ACC-4724-backfill-additional-awal-contract-data.sql2.0 KB2026-07-13 03:27📄ACC-4715-ingest-contract_term_conditions-for-AWAL-agreements-with-agreement_type-AWAL-for-label-attachments-for-worldwide-rights-blocks.sql15.9 MB2026-07-13 03:27📄ACC-4704-knr-account-placeholders.sql3.3 KB2026-07-13 03:27📄ACC-4702-update-account_payment_term-into-royalty_accounting-database.sql6.4 MB2026-07-13 03:27📄ACC-4702-Insert-account_payment_term-into-royalty_accounting-database.sql62.4 KB2026-07-13 03:27📄ACC-4697-populate-lookup-table-with-account-to-sax_interested_party_id-mappings.sql3.3 MB2026-07-13 03:27📄ACC-4697-backfill-sax_interested_party_id-to-royalty_acconting.account.sql3.4 MB2026-07-13 03:27📄ACC-4696-ingest-AWAL-agreements-into-royalty_accounting.contract-table-and-populate-lookup-table.sql3.9 MB2026-07-13 03:27📄ACC-4683-update-account-currencies.sql1.9 KB2026-07-13 03:27📄ACC-4675-create-missing-contract-for-account-71532.sql4.5 KB2026-07-13 03:27📄ACC-4632_update_statement_periods.sql2.0 KB2026-07-13 03:27📄ACC-4624-fix-gbr-tax-withholding.sql1.4 KB2026-07-13 03:27📄ACC-4624-backfill-gbr-tax-withholding.sql34.2 KB2026-07-13 03:27📄ACC-4622-prod-use-test-run-controller.sql474 B2026-07-13 03:27📄ACC-4622-prod-remove-orphaned-run-controller-contracts.sql184 B2026-07-13 03:27📄ACC-4622-prod-delete-bad-test-account.sql1.2 KB2026-07-13 03:27📄ACC-4621-update-gda-contract-template-term-rate.sql616 B2026-07-13 03:27📄ACC-4611-clear-prod-for-gda-launch.sql3.1 KB2026-07-13 03:27📄ACC-4567_update_signing_entity_info_for_orchard_uk.sql634 B2026-07-13 03:27📄ACC-4489-backfill-gda-test-account-payoneer-programs.sql877 B2026-07-13 03:27📄ACC-4382-update-contract-template-exclude-russia.sql775 B2026-07-13 03:27📄ACC-4370-remove-redundant-reference-vat-rate.sql937 B2026-07-13 03:27📄ACC-4324-populate_reference_payoneer_program.sql930 B2026-07-13 03:27📄ACC-4321-prod-remove-test-data.sql811 B2026-07-13 03:27📄ACC-4321-prod-add-missing-data.sql1.7 KB2026-07-13 03:27📄ACC-4320_update_statement_period_january_2021_status_prod.sql324 B2026-07-13 03:27📄ACC-4320-update-contract-template-run-controller-id-prod.sql487 B2026-07-13 03:27📄ACC-4317-prod-accounts.sql6.8 KB2026-07-13 03:27📄ACC-4305_create_payment_terms_templates_for_available_currencies.sql2.0 KB2026-07-13 03:27📄ACC-4269_update_posted_payments.sql313 B2026-07-13 03:27📄ACC-4044_update_payment_term_template.sql524 B2026-07-13 03:27📄ACC-4044_update_payment_term_signing_entities.sql391 B2026-07-13 03:27📄ACC-4044_populate_signing_entity.sql605 B2026-07-13 03:27📄ACC-4004_create_statement_periods.sql15.7 KB2026-07-13 03:27📄ACC-4000_update_contract_type_prod.sql247 B2026-07-13 03:27📄ACC-4000_update_contract_type_distributon_to_legacy_distribution_add_distribution.sql264 B2026-07-13 03:27📄ACC-3938_create_tax_withholding_rates.sql3.2 KB2026-07-13 03:27📄ACC-3923_create_reference_vat_rates_fixed.sql1.2 KB2026-07-13 03:27📄ACC-3923_create_reference_vat_rates.sql1.2 KB2026-07-13 03:27📄ACC-3872_update_payment_term_template_1.sql1.1 KB2026-07-13 03:27📄ACC-3841_create_payment_term_template_1.sql464 B2026-07-13 03:27📄ACC-3836_truncate_payment_group_criteria.sql259 B2026-07-13 03:27📄ACC-3713_create_gda_contract_template_1.sql862 B2026-07-13 03:27📄ACC-3677_update_run_controller_data.sql454 B2026-07-13 03:27📄ACC-3363_db_initial_refresh_data.sql1.5 KB2026-07-13 03:27📄ACC-3011_migrate_run_controller_contract_data.sql334 B2026-07-13 03:27📄ACC-2948_migrate_contract_data.sql1.0 KB2026-07-13 03:27📄ACC-2828_update_payees_payment_method.sql485 B2026-07-13 03:27📄ACC-2719_populate_payment_eligibility_tables.sql5.3 KB2026-07-13 03:27📄ACC-2433_populate_payment_minimum.sql1.1 KB2026-07-13 03:27📄ACC-2421_migrate_postgres_data_to_mysql_populate_data_02.sql1.0 MB2026-07-13 03:27📄ACC-2421_migrate_postgres_data_to_mysql_populate_data.sql71.5 KB2026-07-13 03:27📄ACC-2417_nullify_run_start_date.sql350 B2026-07-13 03:27📄ACC-10557_soft_delete_contract_flowthrough.sql380 B2026-07-13 03:27📄ACC-10498-add-foudation-agreement-type.sql863 B2026-07-13 03:27📄ACC-10483_release_reserves.sql3.4 KB2026-07-13 03:27📄ACC-10466_update_transaction_types.sql2.3 KB2026-07-13 03:27📄ACC-10464_hard_delete_contracts.sql16.0 KB2026-07-13 03:27📄ACC-10463_hard_delete_contracts.sql16.0 KB2026-07-13 03:27📄ACC-10463_hard_delete_accounts.sql20.0 KB2026-07-13 03:27📄ACC-10406_backfill_contract_reference_sap_profit_center_id.sql793 B2026-07-13 03:27📄ACC-10404_backfill_reference_sap_profit_center_display_name_column.sql1.7 KB2026-07-13 03:27📄ACC-10403_backfill_signing_entity_sap_profit_center.sql864 B2026-07-13 03:27📄ACC-10382_remove_test_data_from_prod.sql186 B2026-07-13 03:27📄ACC-10375-add-royaltyshare-agreement-type.sql824 B2026-07-13 03:27📄ACC-10362_insert_reference_signing_entity.sql832 B2026-07-13 03:27📄ACC-10359-update-terms-and-conditions.sql9.2 KB2026-07-13 03:27📄ACC-10349-release-reserves-early.sql6.5 KB2026-07-13 03:27📄ACC-10349-delete-contract-reserve-224345.sql259 B2026-07-13 03:27📄ACC-10309_delete_signing_entity.sql378 B2026-07-13 03:27📄ACC-10250_backfill-uat-earnings-transfers.sql7.9 KB2026-07-13 03:27📄ACC-10243_insert_manual_flowthrough_calculation.sql385 B2026-07-13 03:27📄ACC-10176_add_run_controller_to_accounting_run.sql415 B2026-07-13 03:27📄ACC-10175_disable_paythrough_contracts.sql2.9 KB2026-07-13 03:27📄ACC-10173_update_reference_adjustment_type.sql402 B2026-07-13 03:27📄ACC-10107-add-account-to-the-product-term.sql274 B2026-07-13 03:27📄ACC-10099_delete_contract_reserves.sql339 B2026-07-13 03:27📄ACC-10097_update_reference_signing_entity.sql646 B2026-07-13 03:27📄ACC-10097_update_reference_sap_profit_center.sql546 B2026-07-13 03:27📄ACC-10079_update_paid_by.sql862 B2026-07-13 03:27📄ACC-10078-delete-the-contract-physical-reserves.sql320 B2026-07-13 03:27📄ACC-10077-release-reserves-early.sql2.8 KB2026-07-13 03:27📄ACC-10072_update_account_currency.sql1.8 KB2026-07-13 03:27📄ACC-10072_update_account_currency-2.sql1.2 KB2026-07-13 03:27📄ACC-10054-update-agreement-types.sql130.3 KB2026-07-13 03:27📄5864_migrate_awal_accounts_to_abacus.sql1.9 KB2026-07-13 03:27