Index of /database/royalty_accounting/build/changelog/ddl

Name ↑SizeModified
⬆..📄ACC-10177_rename_band_transfer_to_nr_transfer.sql365 B2026-07-13 03:27📄ACC-10177_update_earnings_transfer_table.sql1021 B2026-07-13 03:27📄ACC-10243_add_comment_column_to_contract_flowthrough.sql250 B2026-07-13 03:27📄ACC-10293-grant-access-to-earnings-transfer-table.sql229 B2026-07-13 03:27📄ACC-10301_ToE-add-active-col.sql212 B2026-07-13 03:27📄ACC-10316_ToE-history.sql5.2 KB2026-07-13 03:27📄ACC-10392_create_signing_entity_sap_profit_center_table.sql1.7 KB2026-07-13 03:27📄ACC-10393_alter_reference_sap_profit_center_add_display_name.sql799 B2026-07-13 03:27📄ACC-10394_alter_contract_add_reference_sap_profit_center_id.sql727 B2026-07-13 03:27📄ACC-10395_alter_contract_history_add_reference_sap_profit_center_id.sql768 B2026-07-13 03:27📄ACC-10396_alter_after_contract_update.sql1.3 KB2026-07-13 03:27📄ACC-10397-grant-access-to-signing-entity-sap-profit-center-table.sql439 B2026-07-13 03:27📄ACC-10405_alter_reference_sap_profit_center_display_name_not_null.sql412 B2026-07-13 03:27📄ACC-10409_alter_contract_reference_sap_profit_center_id_not_null.sql426 B2026-07-13 03:27📄ACC-10454_add_composite_index_contract_se_pc.sql844 B2026-07-13 03:27📄ACC-10454_enforce_contract_se_pc_live_junction_triggers.sql4.7 KB2026-07-13 03:27📄ACC-10493-add-new-toe-config-column-process-static.sql245 B2026-07-13 03:27📄ACC-10551_migrate_recoupment_cap_to_decimal.sql516 B2026-07-13 03:27📄ACC-10559_add_unique_constraint_contract_flowthrough.sql1.0 KB2026-07-13 03:27📄ACC-10564-add-reference-sap-profit-center-id-to-contract-template.sql1.1 KB2026-07-13 03:27📄ACC-10595_reject_soft_delete_of_applied_worksheet_adjustment.sql1.6 KB2026-07-13 03:27📄ACC-10650-add-created-and-last-modified-fields.sql1.3 KB2026-07-13 03:27📄ACC-10652_reject_applying_soft_deleted_worksheet_adjustment.sql3.5 KB2026-07-13 03:27📄ACC-10668-alter-after-update-sap-profit-center.sql3.3 KB2026-07-13 03:27📄ACC-10701-drop-abacus-contract-users.sql3.0 KB2026-07-13 03:27📄ACC-2395_migrate_postgres_schema_to_mysql.sql9.8 KB2026-07-13 03:27📄ACC-2427_alter_table_to_add_column_in_payee_table.sql296 B2026-07-13 03:27📄ACC-2433_create_payment_minimum.sql613 B2026-07-13 03:27📄ACC-2433_payment_minimum_permissions.sql217 B2026-07-13 03:27📄ACC-2449_create_payment_hold.sql867 B2026-07-13 03:27📄ACC-2449_create_payment_hold_history.sql1.1 KB2026-07-13 03:27📄ACC-2496_create_ows_royalties_workflows_user.sql276 B2026-07-13 03:27📄ACC-2516_create_payee_contact.sql1019 B2026-07-13 03:27📄ACC-2516_grant_permissions_to_payee_contact.sql249 B2026-07-13 03:27📄ACC-2581_alter_table_to_add_columns_in_payee_table.sql555 B2026-07-13 03:27📄ACC-2612_drop_unused_tables.sql289 B2026-07-13 03:27📄ACC-2668-grant_permissions_to_ledger_tables.sql159 B2026-07-13 03:27📄ACC-2668_create_ledger_tables.sql1.4 KB2026-07-13 03:27📄ACC-2670-general-ledger-table.sql1.0 KB2026-07-13 03:27📄ACC-2673_alter_ledger_decimals.sql455 B2026-07-13 03:27📄ACC-2673_alter_ledger_tables.sql2.4 KB2026-07-13 03:27📄ACC-2673_grant_ledger_permissions.sql597 B2026-07-13 03:27📄ACC-2675_alter_ledger_event_date.sql209 B2026-07-13 03:27📄ACC-2676-alter_ledger_general_precision.sql219 B2026-07-13 03:27📄ACC-2676-alter_ledger_general_scale.sql415 B2026-07-13 03:27📄ACC-2676-create_ledger_deposit.sql1.4 KB2026-07-13 03:27📄ACC-2719_payment_eligibility_tables.sql1.9 KB2026-07-13 03:27📄ACC-2730_add_committing_run_status.sql765 B2026-07-13 03:27📄ACC-2767_payee_cleanup.sql673 B2026-07-13 03:27📄ACC-2798_drop_ledger_event.sql121 B2026-07-13 03:27📄ACC-2802_alter_group_name_key.sql229 B2026-07-13 03:27📄ACC-2802_drop_group_name_index.sql201 B2026-07-13 03:27📄ACC-2802_payment_group_permissions.sql591 B2026-07-13 03:27📄ACC-2802_payment_group_tables.sql2.8 KB2026-07-13 03:27📄ACC-2802_payment_group_unique.sql196 B2026-07-13 03:27📄ACC-2809_generating_payments_status.sql522 B2026-07-13 03:27📄ACC-2828_payee_payment_method.sql262 B2026-07-13 03:27📄ACC-2852_alter_fks_to_ledger_event.sql2.2 KB2026-07-13 03:27📄ACC-2852_create_abacus_event.sql623 B2026-07-13 03:27📄ACC-2905_add_event_type_enums.sql337 B2026-07-13 03:27📄ACC-2907_payment_group_payment_error_status.sql578 B2026-07-13 03:27📄ACC-2948_contract_tables.sql5.1 KB2026-07-13 03:27📄ACC-2999_remove_legacy_models.sql636 B2026-07-13 03:27📄ACC-3011_run_controller_contract_table.sql1.0 KB2026-07-13 03:27📄ACC-3057_mech_deduction_table.sql1.0 KB2026-07-13 03:27📄ACC-3066_add_mechanical_statuses_for_period.sql549 B2026-07-13 03:27📄ACC-3233_mechanical_run_table.sql796 B2026-07-13 03:27📄ACC-3363-prod_db_init_ows_services_schema.sql28.3 KB2026-07-13 03:27📄ACC-3379_legacy_contract_table.sql836 B2026-07-13 03:27📄ACC-3380_create_legacy_payee_table.sql710 B2026-07-13 03:27📄ACC-3381_accounting_period_changes.sql947 B2026-07-13 03:27📄ACC-3384_drop_contract_terms_history_tables.sql186 B2026-07-13 03:27📄ACC-3422_create_abacus_state_table.sql996 B2026-07-13 03:27📄ACC-3422_grant_permissions_to_abacus_state_table.sql224 B2026-07-13 03:27📄ACC-3477_drop_unused_column_from_accounting_period_table.sql534 B2026-07-13 03:27📄ACC-3479_add_approved_status_for_sales_files.sql408 B2026-07-13 03:27📄ACC-3495-create_ledger_payee_current_balance_tabel.sql1.8 KB2026-07-13 03:27📄ACC-3496_create_contract_exception_table.sql850 B2026-07-13 03:27📄ACC-3556_create_ledger_accounting_run_balance_table.sql1.6 KB2026-07-13 03:27📄ACC-3671_modify_payment_minimum_precision.sql209 B2026-07-13 03:27📄ACC-3672_add_columns_to_runcontroller_table.sql347 B2026-07-13 03:27📄ACC-3677-drop_name_column.sql224 B2026-07-13 03:27📄ACC-3678_drop_sales_file_status_column.sql286 B2026-07-13 03:27📄ACC-3678_modify_action_status_column.sql322 B2026-07-13 03:27📄ACC-3691-drop-payment-status-column.sql443 B2026-07-13 03:27📄ACC-3713_create_contract_template_table.sql1.1 KB2026-07-13 03:27📄ACC-3715_create_ows-abacus-account_user.sql356 B2026-07-13 03:27📄ACC-3716_add_account_id_to_ledger_deposit.sql439 B2026-07-13 03:27📄ACC-3716_create_account_tables.sql6.7 KB2026-07-13 03:27📄ACC-3724_modify_ledger_tables.sql613 B2026-07-13 03:27📄ACC-3725-drop-payee-centric-tables.sql4.4 KB2026-07-13 03:27📄ACC-3738_create_contract_territory_exclusion.sql948 B2026-07-13 03:27📄ACC-3774_add_contract_exclusion_table.sql760 B2026-07-13 03:27📄ACC-3774_add_unique_constraint_contract_id.sql177 B2026-07-13 03:27📄ACC-3774_drop_contract_territory_exclusion_table.sql972 B2026-07-13 03:27📄ACC-3774_rename_contract_exclusions_column.sql262 B2026-07-13 03:27📄ACC-3785-create-account-payment-term-table.sql1.5 KB2026-07-13 03:27📄ACC-3786-create-account-payment-term-contract-table.sql1.5 KB2026-07-13 03:27📄ACC-3792_grant_permissions_on_payment_minimum_to_ows-payment.sql222 B2026-07-13 03:27📄ACC-3793_drop_payment_columns_from_payee_table.sql1008 B2026-07-13 03:27📄ACC-3799_add_account_name_column_to_account.sql212 B2026-07-13 03:27📄ACC-3801_create_common_data_tables.sql830 B2026-07-13 03:27📄ACC-3801_fix_tables_constraints.sql1.3 KB2026-07-13 03:27📄ACC-3812-drop-ledger-general.sql1.3 KB2026-07-13 03:27📄ACC-3836_alter_payment_group_group_criteria_json_format.sql228 B2026-07-13 03:27📄ACC-3841_create_payment_term_template_table.sql702 B2026-07-13 03:27📄ACC-3842-add_new_payment_agreement.sql498 B2026-07-13 03:27📄ACC-3848_create_account_contract_distribution_table.sql1.4 KB2026-07-13 03:27📄ACC-3851_drop_account_contract_table.sql1.3 KB2026-07-13 03:27📄ACC-3851_drop_account_payment_term_contract_table.sql1.7 KB2026-07-13 03:27📄ACC-3872_rename_payment_agreement_column.sql549 B2026-07-13 03:27📄ACC-3891_drop_label_id_column.sql239 B2026-07-13 03:27📄ACC-3892_add_attachments_relations_to_contract_term.sql203 B2026-07-13 03:27📄ACC-3892_alter_contract_term_attachments_relations.sql177 B2026-07-13 03:27📄ACC-3921_create_account_tax_info_table.sql1.0 KB2026-07-13 03:27📄ACC-3923_create_reference_vat_rate_table.sql998 B2026-07-13 03:27📄ACC-3930_create_ledger_accounting_run_vat.sql1.8 KB2026-07-13 03:27📄ACC-3931_alter_accounting_period_report_type_column.sql265 B2026-07-13 03:27📄ACC-3931_create_accounting_period_report.sql1.1 KB2026-07-13 03:27📄ACC-3938_create_tax_withholding_table.sql846 B2026-07-13 03:27📄ACC-3939_alter_payment_group_payment_account.sql398 B2026-07-13 03:27📄ACC-3942-drop-payment-group-payment-payee.sql1.5 KB2026-07-13 03:27📄ACC-3942_create_payment_group_payment_account.sql1.4 KB2026-07-13 03:27📄ACC-3974_make_oa_owner_nullable.sql218 B2026-07-13 03:27📄ACC-4000_alter_table_to_change_contract_type_enums.sql566 B2026-07-13 03:27📄ACC-4001_add_contract_type_to_run_controller.sql416 B2026-07-13 03:27📄ACC-4003_alter_accounting_period_table.sql1.3 KB2026-07-13 03:27📄ACC-4004_create_statement_period_table.sql722 B2026-07-13 03:27📄ACC-4006-abacus-event-statement-period-id.sql2.4 KB2026-07-13 03:27📄ACC-4006-abacus-event-trigger-before-insert.sql601 B2026-07-13 03:27📄ACC-4025-alter-vw-account-statement-period.sql3.1 KB2026-07-13 03:27📄ACC-4025-view-account-statement-period.sql1.6 KB2026-07-13 03:27📄ACC-4036_add_distribution_fee_column.sql289 B2026-07-13 03:27📄ACC-4044_add_signing_entity_id_to_account_payment_term.sql527 B2026-07-13 03:27📄ACC-4044_create_signing_entity_table.sql687 B2026-07-13 03:27📄ACC-4046-statement-attachment-status.sql308 B2026-07-13 03:27📄ACC-4046_create_statement_attachment_table.sql876 B2026-07-13 03:27📄ACC-4046_statement_attachment_constraints.sql874 B2026-07-13 03:27📄ACC-4046_statement_attachment_moneyhub_access.sql493 B2026-07-13 03:27📄ACC-4064-alter-vw-account-statement-period.sql3.3 KB2026-07-13 03:27📄ACC-4064_add_vat_rate_to_ledger_accounting_run_vat.sql398 B2026-07-13 03:27📄ACC-4078-alter-vw-account-statement-period.sql3.5 KB2026-07-13 03:27📄ACC-4084-grant_permissions_on_account_payment_term_template_table.sql447 B2026-07-13 03:27📄ACC-4085_create_account_payment_term_history_table.sql2.8 KB2026-07-13 03:27📄ACC-4086-payment-hold-account-id.sql3.4 KB2026-07-13 03:27📄ACC-4087-grant_permissions_on_account_payee_table.sql385 B2026-07-13 03:27📄ACC-4088-create_account_tax_info_history_table.sql2.1 KB2026-07-13 03:27📄ACC-4093-create_account_payee_payoneer_status_and_history_tables.sql2.7 KB2026-07-13 03:27📄ACC-4141-drop-payee-contact.sql1.2 KB2026-07-13 03:27📄ACC-4142-abacus-state-history.sql1.9 KB2026-07-13 03:27📄ACC-4142-abacus-state-rejected.sql366 B2026-07-13 03:27📄ACC-4142-drop-account-payee-payoneer-status.sql2.3 KB2026-07-13 03:27📄ACC-4147_create_ows_abacus_legacy_sync_user.sql368 B2026-07-13 03:27📄ACC-4184-add-adjusted-net-revenue.sql808 B2026-07-13 03:27📄ACC-4231-adds_timestamps_to_account_payee_history.sql1.4 KB2026-07-13 03:27📄ACC-4231-alter_account_payee_and_create_account_payee_history.sql2.9 KB2026-07-13 03:27📄ACC-4232-drop-payee-table.sql2.3 KB2026-07-13 03:27📄ACC-4274-create-payment-group-payment-account-batch-table.sql1.1 KB2026-07-13 03:27📄ACC-4274-create-payment-group-payment-batch-table.sql2.4 KB2026-07-13 03:27📄ACC-4295-add-payoneer-program-id-to-account-payee.sql1.6 KB2026-07-13 03:27📄ACC-4296-add-program-id-to-payment-group-payment-batch.sql280 B2026-07-13 03:27📄ACC-4296-modify-program-id-for-payment-group-payment-batch.sql529 B2026-07-13 03:27📄ACC-4357-add-program-id-to-payment-group-payment-account.sql1.0 KB2026-07-13 03:27📄ACC-4370-remove-is_vat-from-account-tax-info.sql1.2 KB2026-07-13 03:27📄ACC-4370-remove-is_vat-from-reference-vat-rate.sql165 B2026-07-13 03:27📄ACC-4375-create-report-payment-group-payment.sql1.1 KB2026-07-13 03:27📄ACC-4413_add_created_by_column_to_abacus_event_table.sql224 B2026-07-13 03:27📄ACC-4428-payment-group-payment-statement-period-id.sql3.2 KB2026-07-13 03:27📄ACC-4435-alter-vw-account-statement-period.sql3.8 KB2026-07-13 03:27📄ACC-4449-add-reference-sap-profit-center-table.sql3.0 KB2026-07-13 03:27📄ACC-4450-create-contract-history.sql1.8 KB2026-07-13 03:27📄ACC-4451-uniq-account-contract-distribution.sql377 B2026-07-13 03:27📄ACC-4468_add_sap_created_at_column_to_account_table.sql215 B2026-07-13 03:27📄ACC-4481-set-start-auto-increment-abacus-contract.sql130 B2026-07-13 03:27📄ACC-4487-create-account-contract.sql1.1 KB2026-07-13 03:27📄ACC-4487-drop-contract-tables.sql2.4 KB2026-07-13 03:27📄ACC-4525-exchange-rate-statement-period-id.sql1.1 KB2026-07-13 03:27📄ACC-4547_create_ows-abacus-adjustment_user.sql365 B2026-07-13 03:27📄ACC-4548_create_reference_adjustment_type_table.sql5.9 KB2026-07-13 03:27📄ACC-4549_create_ledger_adjustment_table.sql2.2 KB2026-07-13 03:27📄ACC-4550_create_ledger_adjustment_detail_tables.sql3.0 KB2026-07-13 03:27📄ACC-4551-add-month-year-to-statement-period.sql1.9 KB2026-07-13 03:27📄ACC-4555_create_contract_physical_reserve_table.sql1.2 KB2026-07-13 03:27📄ACC-4555_create_contract_reserve_table.sql1.2 KB2026-07-13 03:27📄ACC-4574_create_ledger_reserve_taken_table.sql1.8 KB2026-07-13 03:27📄ACC-4575_create_ledger_reserve_release_schedule_table.sql2.1 KB2026-07-13 03:27📄ACC-4576_create_ledger_reserve_release_table.sql1.5 KB2026-07-13 03:27📄acc-4590_alter_contract_advance_history_milestone.sql415 B2026-07-13 03:27📄ACC-4597_create_ledger_adjustment_applied_table.sql2.0 KB2026-07-13 03:27📄ACC-4598_create_statement_period_adjustment_file_table.sql1.0 KB2026-07-13 03:27📄ACC-4599_make_ledger_deposit_contract_id_nullable.sql219 B2026-07-13 03:27📄ACC-4600_drop_adjustment_table.sql1.4 KB2026-07-13 03:27📄ACC-4601_drop_ows-abacus-adjustment_user.sql317 B2026-07-13 03:27📄ACC-4602-drop-total-adjustment-amount.sql4.0 KB2026-07-13 03:27📄ACC-4608-ows-abacus-account-privileges.sql222 B2026-07-13 03:27📄ACC-4628-drop-country-and-store-tables.sql775 B2026-07-13 03:27📄ACC-4634-rename-mechanical-admin-types.sql646 B2026-07-13 03:27📄ACC-4656_add_distribution_type_column.sql282 B2026-07-13 03:27📄ACC-4683-create-contract-advance-tables.sql3.4 KB2026-07-13 03:27📄ACC-4684-add-unique-constraint-to-ledger-contract-advance-applied.sql270 B2026-07-13 03:27📄ACC-4686-create-ledger-contract-advance-applied.sql2.0 KB2026-07-13 03:27📄ACC-4696-update-royalty_accounting.contract-table-add-sax_agreement_id.sql199 B2026-07-13 03:27📄ACC-4697-alter-account-table-add-index-on-sax_interested_party_id.sql212 B2026-07-13 03:27📄ACC-4697-update-royalty_accounting.account-table-add-sax_currency_abbreviation-sax_bank_account_id.sql364 B2026-07-13 03:27📄ACC-4697-update-royalty_accounting.account-table-add-sax_interested_party_id.sql211 B2026-07-13 03:27📄ACC-4701-create-reference-external-source.sql880 B2026-07-13 03:27📄ACC-4701-remove-sax-columns.sql555 B2026-07-13 03:27📄ACC-4714-add-nr-contract-type-to-contract_history.sql364 B2026-07-13 03:27📄ACC-4717-add-neighbouring-rights-contract-type.sql983 B2026-07-13 03:27📄ACC-4717-add-nr-contract-type-to-template.sql369 B2026-07-13 03:27📄ACC-4736-create-index-on-reference_external_source-to-speed-up-selects.sql297 B2026-07-13 03:27📄ACC-4739-add-contribution-term-type.sql355 B2026-07-13 03:27📄ACC-4758-drop-staging-url-from-sales-file.sql193 B2026-07-13 03:27📄ACC-4772_payoneer_program_name_column.sql1.2 KB2026-07-13 03:27📄ACC-4773_add_not_null_constraint_to_agreement_type_id_column.sql293 B2026-07-13 03:27📄ACC-4773_add_reference_agreement_type.sql1.8 KB2026-07-13 03:27📄ACC-4804_create_statement_period_payment_entity.sql1.1 KB2026-07-13 03:27📄ACC-4835_add_select_grant_for_adjustments_service_user.sql831 B2026-07-13 03:27📄ACC-4835_add_select_to_contract_terms_for_service_user.sql243 B2026-07-13 03:27📄ACC-4835_create_adjustments_service_user_and_perms.sql309 B2026-07-13 03:27📄ACC-4835_create_prod_adjustments_service_user_and_perms.sql810 B2026-07-13 03:27📄ACC-4842-add-missing-unique-keys.sql1.6 KB2026-07-13 03:27📄ACC-4850-add-adjustment-type-to-adjustment-detail.sql598 B2026-07-13 03:27📄ACC-4883_alter_account_contract_is_primary_for_calc.sql230 B2026-07-13 03:27📄ACC-4884-update-exchange-rate-decimal.sql220 B2026-07-13 03:27📄ACC-4889-alter_contract_term_name_contract_term_condition_name.sql863 B2026-07-13 03:27📄ACC-4889-contract_term_name_contract_term_condition_name.sql434 B2026-07-13 03:27📄ACC-4902-add-unique-constraint-to-legacy-contract.sql240 B2026-07-13 03:27📄ACC-4960-add-end-date-column-to-accounting-run-table.sql219 B2026-07-13 03:27📄ACC-4968-create-ledger-account-contract.sql3.9 KB2026-07-13 03:27📄ACC-5025-add-contracts_payable-for-payment-account.sql250 B2026-07-13 03:27📄ACC-5057-5078-5079-fix-currency-codes.sql2.1 KB2026-07-13 03:27📄ACC-5061-add-is-vat-exempt-column-to-account-tax-info.sql1.3 KB2026-07-13 03:27📄ACC-5227-add-soft-deletion-to-contract-term.sql262 B2026-07-13 03:27📄ACC-5240-create-contract-term-and-contract-term-conditions-history-tables.sql4.2 KB2026-07-13 03:27📄ACC-5298-drop-rollback-tables.sql3.8 KB2026-07-13 03:27📄ACC-5362-update-contract-reserve-table.sql599 B2026-07-13 03:27📄ACC-5439-uniq-ledger-account-contract.sql501 B2026-07-13 03:27📄ACC-5445-drop-oa-owner-column.sql210 B2026-07-13 03:27📄ACC-5474_update_payment_schedule_options.sql1.8 KB2026-07-13 03:27📄ACC-5489-create-ows-abacus-schedule-user.sql358 B2026-07-13 03:27📄ACC-5490_create_schedule_tables.sql2.1 KB2026-07-13 03:27📄ACC-5490_schedule_conditions_nullable.sql331 B2026-07-13 03:27📄ACC-5491-create-schedule-attachment-and-schedule-attachment-history.sql2.4 KB2026-07-13 03:27📄ACC-5491-grant-schedule-attachment.sql481 B2026-07-13 03:27📄ACC-5573-alter-upc-column-data-type.sql224 B2026-07-13 03:27📄ACC-5697_create_worksheet_correction_table.sql1.7 KB2026-07-13 03:27📄ACC-5703-create-ows-abacus-worksheet-user.sql362 B2026-07-13 03:27📄ACC-5704-create-ledger-correction-table.sql1.9 KB2026-07-13 03:27📄ACC-5710_add_ledger_adjustment_detail_applied_tables.sql2.5 KB2026-07-13 03:27📄ACC-5725_3_convert_tinyint_to_smallint.sql280 B2026-07-13 03:27📄ACC-5725_add_unique_key_to_laad.sql291 B2026-07-13 03:27📄ACC-5749_add_notes_to_contract.sql1.2 KB2026-07-13 03:27📄ACC-5753-add-early-release-date.sql280 B2026-07-13 03:27📄ACC-5774_alter_account_tax_info_and_history.sql706 B2026-07-13 03:27📄ACC-5821-drop-rollback-tables.sql2.1 KB2026-07-13 03:27📄ACC-5928-alter-worksheet-correction.sql643 B2026-07-13 03:27📄ACC-5929-alter-ledger-correction.sql614 B2026-07-13 03:27📄ACC-6023-null-term-duration-year.sql584 B2026-07-13 03:27📄ACC-6031-create-reference-payment-entity.sql634 B2026-07-13 03:27📄ACC-6031-reference-payment-entity-permissions.sql458 B2026-07-13 03:27📄ACC-6031-run-controller-soft-delete-columns.sql269 B2026-07-13 03:27📄ACC-6031_add_payment_entity_id_column.sql2.1 KB2026-07-13 03:27📄ACC-6031_add_reference_payment_entity_id_column-fix.sql1.2 KB2026-07-13 03:27📄ACC-6067-create-contract-party-and-history-tables.sql2.7 KB2026-07-13 03:27📄ACC-6067-grant-privileges-to-contract-party-table.sql461 B2026-07-13 03:27📄ACC-6091-add-contributor-to-schedule-attachment-enum.sql2.1 KB2026-07-13 03:27📄ACC-6137-add-commission-column-to-contract-term-condition.sql1.6 KB2026-07-13 03:27📄ACC-6137-modify-commission-column.sql246 B2026-07-13 03:27📄ACC-6161-add-contract-term-schedule-tables.sql3.0 KB2026-07-13 03:27📄ACC-6161-alter-table-add-contract-term-type.sql778 B2026-07-13 03:27📄ACC-6161-grant-privileges-to-contract-term-schedule.sql493 B2026-07-13 03:27📄ACC-6281-alter-contract-term-type-enum-remove-values.sql974 B2026-07-13 03:27📄ACC-6281-alter-contract-term-type-enum.sql930 B2026-07-13 03:27📄ACC-6309_add_columns_statement_period_adjustment_file.sql989 B2026-07-13 03:27📄ACC-6310-create-worksheet-adjustment-table-fix.sql2.5 KB2026-07-13 03:27📄ACC-6310-create-worksheet-adjustment-table.sql2.5 KB2026-07-13 03:27📄ACC-6310-grant-privileges-to-worksheet-adjustment.sql249 B2026-07-13 03:27📄ACC-6311-worksheet-adjustment-detail-table-creation.sql2.7 KB2026-07-13 03:27📄ACC-6311-worksheet-adjustment-detail-table-permissions.sql265 B2026-07-13 03:27📄ACC-6371-modify-adjustment-file-table.sql762 B2026-07-13 03:27📄ACC-6454-add-reference-signing-entity-id-to-contract-template.sql1.1 KB2026-07-13 03:27📄ACC-6456-alter-reference-payment-entity-id-and-signing-entity-id-columns.sql823 B2026-07-13 03:27📄ACC-6459-add-foreign-key-to-reference-signing-entity-and-sap-profile-center.sql2.0 KB2026-07-13 03:27📄ACC-6459-update-contract-history-trigger.sql1.0 KB2026-07-13 03:27📄ACC-6485-grant-ledger-vat-summary-perms.sql226 B2026-07-13 03:27📄ACC-6644-add-index-on-deleted-by-and-deleted-at-columns.sql312 B2026-07-13 03:27📄ACC-6644-alter-statement-period-adjustment-file.sql376 B2026-07-13 03:27📄ACC-6670_create_reference_transaction_type.sql658 B2026-07-13 03:27📄ACC-6697-add-worksheet-adjustment-and-detail-id-columnt-to-ledger-adjustment-tabel.sql1.7 KB2026-07-13 03:27📄ACC-6697-add-worksheet-adjustment-id-column-to-ledger-adjustment-detail-applied.sql589 B2026-07-13 03:27📄ACC-6951_drop_transaction_type_table.sql122 B2026-07-13 03:27📄ACC-7003-3_create_ref_transtype_groups.sql1.5 KB2026-07-13 03:27📄ACC-7156-alter-contract-and-history.sql2.2 KB2026-07-13 03:27📄ACC-7158_create_contract_lifecycle_schedule.sql1.9 KB2026-07-13 03:27📄ACC-7158_create_contract_lifecycle_schedule_detail.sql730 B2026-07-13 03:27📄ACC-7159-create-contract-lifecycle.sql4.2 KB2026-07-13 03:27📄ACC-7159-grant-privileges-to-contract-lifecycle-table.sql453 B2026-07-13 03:27📄ACC-7296_create_reference_flowthrough_calculation_table.sql877 B2026-07-13 03:27📄ACC-7297_create_contract_flowthrough_table.sql4.3 KB2026-07-13 03:27📄ACC-7297_fix_create_contract_flowthrough_table.sql4.4 KB2026-07-13 03:27📄ACC-7301_contract_flowthrough_automatic_shutoff_fix.sql4.4 KB2026-07-13 03:27📄ACC-7433-create-contract-mechanical-deduction-and-history-tables-fix.sql3.8 KB2026-07-13 03:27📄ACC-7433-create-contract-mechanical-deduction-and-history-tables.sql3.1 KB2026-07-13 03:27📄ACC-7433-grant-privileges-to-contract-mechanical-deduction-table.sql497 B2026-07-13 03:27📄ACC-7434-create-reference-mechanical-rate-table.sql751 B2026-07-13 03:27📄ACC-7434-grant-permissions-to-reference-mechanical-rate-table.sql214 B2026-07-13 03:27📄ACC-7480-add_unique_constraints_to_adjustments_applied_tables.sql447 B2026-07-13 03:27📄ACC-7498-create-lambda-abacus-user.sql419 B2026-07-13 03:27📄ACC-7735_update_grants_drop_user.sql346 B2026-07-13 03:27📄ACC-7773-add-mech-txn-type-group-admin.sql540 B2026-07-13 03:27📄ACC-7823_add_last_renewed_to_contract_lifecycle.sql249 B2026-07-13 03:27📄ACC-7956_alter_contract_mechanical_deduction_table.sql4.3 KB2026-07-13 03:27📄ACC-7956_update_unique_constraint_contract_mechanical_deduction.sql1.4 KB2026-07-13 03:27📄ACC-8180_update_statement_period_adjustment_file_error_types.sql322 B2026-07-13 03:27📄ACC-8228_create_abacust_contract_import_status.sql1.4 KB2026-07-13 03:27📄ACC-8228_grant_abacus_contract_import_status_to_lambda.sql249 B2026-07-13 03:27📄ACC-8264-drop-mechanical-deduction.sql1.2 KB2026-07-13 03:27📄ACC-8288_add_jira_ticket_and_user_to_json_import_status_table.sql398 B2026-07-13 03:27📄ACC-8315_allow_contract_id_to_be_null.sql235 B2026-07-13 03:27📄ACC-8379-add-paythrough-contract-id-to-contract.sql423 B2026-07-13 03:27📄ACC-8379_is_paythrough_contract.sql639 B2026-07-13 03:27📄ACC-8431_update_reference_profit_center_to_null_in_contract_history_table.sql262 B2026-07-13 03:27📄ACC-8431_update_reference_profit_center_to_null_in_contract_table.sql264 B2026-07-13 03:27📄ACC-8431_update_reference_profit_center_to_null_in_contract_template_table.sql282 B2026-07-13 03:27📄ACC-8511-alter-attachments-column-to-null.sql339 B2026-07-13 03:27📄ACC-8557_add_orchard_run_controller.sql406 B2026-07-13 03:27📄ACC-8664_add_account_id_and_imported_entities_to_json_import_status_table.sql400 B2026-07-13 03:27📄ACC-8708-add-mech-deduction-columns-to-worksheet-correction.sql440 B2026-07-13 03:27📄ACC-8709-add-mech-deduction-columns-to-ledger-correction.sql432 B2026-07-13 03:27📄ACC-8716-3_update_column_type.sql667 B2026-07-13 03:27📄ACC-8716-modify-reference-signing-entity-and-sap-profit-center-updated.sql1.0 KB2026-07-13 03:27📄ACC-8716-modify-reference-signing-entity-and-sap-profit-center.sql931 B2026-07-13 03:27📄ACC-8716-modify-sap-profit-center-updated.sql298 B2026-07-13 03:27📄ACC-8716_modify_signing_entity_profit_center.sql938 B2026-07-13 03:27📄ACC-8777-alter-contract-advance-milestone-description.sql251 B2026-07-13 03:27📄ACC-8814_add_accounting_period_is_visible_column.sql414 B2026-07-13 03:27📄ACC-8908_alter_run_controller_contract_table_with_audit_fields_make_history_table.sql1.6 KB2026-07-13 03:27📄ACC-8908_create_trigger_for_run_controller_contract_update.sql908 B2026-07-13 03:27📄ACC-8933_update_account_currency.sql403 B2026-07-13 03:27📄ACC-8992_grant_contract_access_to_ows_royalties.sql5.1 KB2026-07-13 03:27📄ACC-9059_create_deleted_contract_table.sql879 B2026-07-13 03:27📄ACC-9099_grant_permissions_to_contract_advance_table.sql470 B2026-07-13 03:27📄ACC-9107-create-oa-territory-backfilled-accounts-table.sql471 B2026-07-13 03:27📄ACC-9107-grant-oa-territory-backfilled-accounts-table-access.sql265 B2026-07-13 03:27📄ACC-9197-drop-signing-entity-id-and-sap-profit-center-id-columns.sql10.2 KB2026-07-13 03:27📄ACC-9199_alter_contract_reserve_table_drop_conditions.sql648 B2026-07-13 03:27📄ACC-9199_alter_contract_reserve_table_drop_conditions_column.sql648 B2026-07-13 03:27📄ACC-9199_b_alter_contract_reserve_table_add_conditions.sql344 B2026-07-13 03:27📄ACC-9284_create_historical_advances_table.sql1.4 KB2026-07-13 03:27📄ACC-9290-add-is-primary-contract-column-to-contract-and-contract-history-and-update-trigger-1.sql1.6 KB2026-07-13 03:27📄ACC-9290-add-is-primary-contract-column-to-contract-and-contract-history.sql1.6 KB2026-07-13 03:27📄ACC-9371_create_file_upload_config_table.sql2.2 KB2026-07-13 03:27📄ACC-9372_create_file_upload_table.sql3.0 KB2026-07-13 03:27📄ACC-9375_create_worksheet_flowthrough_batch_table.sql3.4 KB2026-07-13 03:27📄ACC-9376-2_alter_reference_worksheet_flowthrough_error_use_error_code_as_pk.sql1.3 KB2026-07-13 03:27📄ACC-9376_create_reference_worksheet_flowthrough_error_table.sql1.5 KB2026-07-13 03:27📄ACC-9377_create_worksheet_flowthrough_table.sql3.8 KB2026-07-13 03:27📄ACC-9378_create_worksheet_flowthrough_file_table.sql2.2 KB2026-07-13 03:27📄ACC-9386-file-upload-key-to-adjustment-file.sql366 B2026-07-13 03:27📄ACC-9404-create-earnings-transfer-table.sql1.1 KB2026-07-13 03:27📄ACC-9416_alter_ledger_adjustment_tables_add_unique_keys.sql638 B2026-07-13 03:27📄ACC-9424-add-event-name-column-to-file-upload-config.sql245 B2026-07-13 03:27📄ACC-9436_create_abacus_outbox_table.sql2.4 KB2026-07-13 03:27📄ACC-9438-update-file-upload-table-with-quarantine-status.sql659 B2026-07-13 03:27📄ACC-9451_update_abacus_outbox_table.sql555 B2026-07-13 03:27📄ACC-9485-update-file-upload-and-batch-status.sql1.7 KB2026-07-13 03:27📄ACC-9528_create_payment_allocation_ledger_adjustment_table.sql1.6 KB2026-07-13 03:27📄ACC-9528_create_payment_allocation_table.sql2.8 KB2026-07-13 03:27📄ACC-9529-create-flowthrough-tables.sql4.4 KB2026-07-13 03:27📄ACC-9530-add-apply-to-flowthrough-payment-column-to-adjustment-tables.sql1.1 KB2026-07-13 03:27📄ACC-9532-create-ledger-contract-flowthrough-trigger.sql843 B2026-07-13 03:27📄ACC-9532-grant-access-to-ledger-flowthrough-tables.sql465 B2026-07-13 03:27📄ACC-9533_grant_access_abacus_outbox.sql200 B2026-07-13 03:27📄ACC-9533_grant_access_to_payment_allocation.sql434 B2026-07-13 03:27📄ACC-9696-alter-contract-advance-milestone-column.sql952 B2026-07-13 03:27📄ACC-9696-alter-contract-advance-option-milestone.sql1.1 KB2026-07-13 03:27📄ACC-9734-grant-access-to-ows-ledger.sql492 B2026-07-13 03:27📄ACC-9751-grant-access-to-ledger-flowthrough-tables.sql465 B2026-07-13 03:27📄ACC-9821-alter-batch-type-column-to-statement-period-adjustment-file.sql387 B2026-07-13 03:27📄ACC-9861-create-statement-period-adjustment-batch-criteria-table.sql1.4 KB2026-07-13 03:27📄ACC-9861-grant-access-to-statement-period-adjustment-batch-criteria-table.sql279 B2026-07-13 03:27📄ACC-9888_alter_tables_ledger_adjustment_applied.sql593 B2026-07-13 03:27📄ACC-9892_alter_payment_allocation_ledger_adjustment_table.sql2.1 KB2026-07-13 03:27📄ACC-9916_add_soft_delete_to_reference_signing_entity.sql548 B2026-07-13 03:27📄ACC_3726_drop_payee_count_column.sql238 B2026-07-13 03:27📄ACC_4044_drop_signing_entity_column.sql409 B2026-07-13 03:27📄ACC_4324_create_payment_entity_payoneer_program.sql1.1 KB2026-07-13 03:27📄ACC_4324_create_reference_payoneer_program.sql552 B2026-07-13 03:27📄ACC_5735_contract_general_note.sql1.3 KB2026-07-13 03:27📄ACC_5735_update_notes_column.sql1.3 KB2026-07-13 03:27📄ACC_7127_alter_total_file_amount_multicurrency_column.sql827 B2026-07-13 03:27📄AS-3318-create_payee_tables.sql3.9 KB2026-07-13 03:27📄AS-3373-create_lambda_collaborator_user.sql296 B2026-07-13 03:27📄AS-3455-payoneer_client_reference_id_index.sql254 B2026-07-13 03:27📄AS-3456_create_payee_kyc_notification.sql2.9 KB2026-07-13 03:27📄AS-3564_deactivate_collaborator_for_dp.sql1.3 KB2026-07-13 03:27📄DOC-306-alter-payoneer-payee-id-column.sql247 B2026-07-13 03:27📄DOC-306-alter-payoneer-payee-id-history.sql258 B2026-07-13 03:27📄DOC-408-add-sap-id-to-payee.sql1.4 KB2026-07-13 03:27📄DOC-450-create-account-contract-vat-detail.sql999 B2026-07-13 03:27📄DOC-450_grant_user_privileges.sql257 B2026-07-13 03:27📄DOC-462-add-uniq-constraint-to-account-payee-sap-vendor-id.sql226 B2026-07-13 03:27📄DOC-535-allow-paid-by-to-be-null.sql270 B2026-07-13 03:27📄DOC-537-update-account-payment-term-history.sql2.6 KB2026-07-13 03:27📄MAINT-abacus-event.sql551 B2026-07-13 03:27📄MAINT-abacus_state-update.sql236 B2026-07-13 03:27📄MAINT-alter-vw-account-statement-period.sql3.6 KB2026-07-13 03:27📄MAINT-charsets.sql1.9 KB2026-07-13 03:27📄MAINT-drop-event-type.sql247 B2026-07-13 03:27📄MAINT-grant-create-perms-2.sql269 B2026-07-13 03:27📄MAINT-grant-create-perms.sql248 B2026-07-13 03:27📄MAINT-grant-drop-perms.sql234 B2026-07-13 03:27📄MAINT-grant-show-trigger-perms.sql295 B2026-07-13 03:27📄MAINT-setup-cronning-db-grants.sql288 B2026-07-13 03:27📄MAINT_alter_payee_name.sql225 B2026-07-13 03:27📄MAINT_contract_payee_table.sql692 B2026-07-13 03:27📄MAINT_drop_payee_id_from_contract.sql234 B2026-07-13 03:27📄MAINT_rename_sales_file_cols.sql551 B2026-07-13 03:27📄NOTICKET_create_menger_user.sql187 B2026-07-13 03:27📄NOTICKET_create_ratoui_user.sql187 B2026-07-13 03:27📄NOTICKET_grant_abacus_state.sql179 B2026-07-13 03:27📄NOTICKET_grant_contract_reserve.sql187 B2026-07-13 03:27📄NOTICKET_grant_contract_select_to_moneyhub.sql165 B2026-07-13 03:27📄NOTICKET_grant_payment_group.sql358 B2026-07-13 03:27📄NOTICKET_grant_reference_sap_profit_center.sql203 B2026-07-13 03:27📄NOTICKET_moneyhub_user_ledger_adjustment_access.sql186 B2026-07-13 03:27📄PORT-183_add_destination_term_ids.sql1.2 KB2026-07-13 03:27📄PORT-65_create_accounting_process_lock.sql1.9 KB2026-07-13 03:27📄PORT-65_lock_constraints_and_permissions.sql844 B2026-07-13 03:27📄PORT-66_extend_term_type_enum.sql582 B2026-07-13 03:27📄PORT-create-project-transfer-term-tables.sql3.0 KB2026-07-13 03:27📄PORT-mirror-contract-term-fields.sql1.5 KB2026-07-13 03:27📄SYS-13827_create_ows-payee_user.sql264 B2026-07-13 03:27📄SYS-15072_create_ows-abacus-event_user.sql338 B2026-07-13 03:27📄SYS-15579_create_ows-abacus-contract_user.sql347 B2026-07-13 03:27📄SYS-16861_create_ows-abacus-state_user.sql350 B2026-07-13 03:27📄SYS-18577_create_automation_test_user.sql299 B2026-07-13 03:27📄SYS-29065_create_ydimitrov_user.sql196 B2026-07-13 03:27📄TAP-1000-create_payment_group_payment_account_detail.sql1.8 KB2026-07-13 03:27📄TAP-1011-create_worksheet_account_contract_payable_after_tax.sql2.0 KB2026-07-13 03:27📄TAP-1062-update_worksheet_account_contract_closing_balance.sql604 B2026-07-13 03:27📄TAP-1074-add_unique_constraint_to_worksheet_account_contract_closing_balance.sql363 B2026-07-13 03:27📄TAP-1140_grant_ows_payment_user_access_to_table.sql266 B2026-07-13 03:27📄TAP-1141_grant_privileges.sql491 B2026-07-13 03:27📄TAP-1210-add_country_of_tax_reporting_col_to_ref_payment_entity_table.sql632 B2026-07-13 03:27📄TAP-1210-reorder-country-of-tax-reporting.sql635 B2026-07-13 03:27📄TAP-1216-create_reference_payable_detail_type_table.sql806 B2026-07-13 03:27📄TAP-1216-create_worksheet_account_contract_payable_details.sql2.1 KB2026-07-13 03:27📄TAP-1217-grant_permissions_on_table.sql276 B2026-07-13 03:27📄TAP-1251-create_worksheet_tax_correction_table.sql1.6 KB2026-07-13 03:27📄TAP-1251-grant_permissions_on_table.sql242 B2026-07-13 03:27📄TAP-1259_add_vat_column.sql648 B2026-07-13 03:27📄TAP-1383_update_reference_tax_withholding.sql248 B2026-07-13 03:27📄TAP-1387_update_account_tax_info_table.sql2.3 KB2026-07-13 03:27📄TAP-1396_add_new_transaction_admin.sql436 B2026-07-13 03:27📄TAP-1401-create_worksheet_account_contract_taxable_revenue_table.sql2.4 KB2026-07-13 03:27📄TAP-1408_add_base_wht_rate.sql806 B2026-07-13 03:27📄TAP-1411-rename-column-account-contract-payable-details-table.sql355 B2026-07-13 03:27📄TAP-1428_add_columns_to_reverence_vat.sql453 B2026-07-13 03:27📄TAP-1460_add_account_name_index_to_account_table.sql160 B2026-07-13 03:27📄TAP-1463_add_constraint_to_hold_tables.sql201 B2026-07-13 03:27📄TAP-1466_tax_correction_vat_add_permissions.sql248 B2026-07-13 03:27📄TAP-1466_tax_correction_vat_table.sql1.9 KB2026-07-13 03:27📄TAP-1537_create_account_payee_tax_form_info.sql3.0 KB2026-07-13 03:27📄TAP-1582_create_account_payee_kyc_notification.sql3.1 KB2026-07-13 03:27📄TAP-1595_new_columns_account_payee_kyc_notification.sql2.7 KB2026-07-13 03:27📄TAP-1689_account_payee_new_column_reference_payment_type_id.sql1.8 KB2026-07-13 03:27📄TAP-1800_make_columns_nullable.sql472 B2026-07-13 03:27📄TAP-1838-rm-tax-correction-constraint.sql3.1 KB2026-07-13 03:27📄TAP-1846_tax_form_info_move_revision_id.sql586 B2026-07-13 03:27📄TAP-1846_tax_form_info_new_revision_id.sql1.9 KB2026-07-13 03:27📄TAP-2143_add_temporary_schedule.sql2.2 KB2026-07-13 03:27📄TAP-2153_update_account_tax_info.sql2.7 KB2026-07-13 03:27📄TAP-2241_add_category_column_vat_corrections.sql326 B2026-07-13 03:27📄TAP-2258-drop-payment_group_payment_account_detail_split-table.sql150 B2026-07-13 03:27📄TAP-2345_german_tax_fields.sql2.7 KB2026-07-13 03:27📄TAP-2504-alter-contract-advance-history-milestone-description.sql269 B2026-07-13 03:27📄TAP-2546_payee_kyc_notification_missing_fields.sql2.4 KB2026-07-13 03:27📄TAP-2566_create_tax_withholding_override.sql2.6 KB2026-07-13 03:27📄TAP-2590_update_vat_corrections_table.sql576 B2026-07-13 03:27📄TAP-2671_reference_payment_type_id_no_default.sql630 B2026-07-13 03:27📄TAP-2671_reference_payoneer_program_reference_payment_type_id.sql2.3 KB2026-07-13 03:27📄TAP-2787_create_worksheet_payment_custom.sql1.8 KB2026-07-13 03:27📄TAP-2787_make_amount_after_withholding_and_vat_required.sql294 B2026-07-13 03:27📄TAP-2840_add_description_to_account_payee.sql1.6 KB2026-07-13 03:27📄TAP-2840_rename_description_in_account_payee.sql2.4 KB2026-07-13 03:27📄TAP-2873_add_report_payment_table.sql692 B2026-07-13 03:27📄TAP-2936-test-add-index-to-worksheet-tax-correction.sql283 B2026-07-13 03:27📄TAP-2940_add_index_worksheet_tax_correction_vat.sql296 B2026-07-13 03:27📄TAP-2990_add_custom_payment_rates.sql399 B2026-07-13 03:27📄TAP-2991_add_custom_payment_to_enum.sql389 B2026-07-13 03:27📄TAP-3113_non_nullable_tax_fields.sql1.5 KB2026-07-13 03:27📄TAP-3143_create_payment_allocation_history_and_trigger.sql2.9 KB2026-07-13 03:27📄TAP-3143_grant_permission_to_ows_payment.sql472 B2026-07-13 03:27📄TAP-3170_add_new_status_options.sql666 B2026-07-13 03:27📄TAP-3188_create_table_reports_tax_info.sql854 B2026-07-13 03:27📄TAP-3188_reports_tax_info_permissions.sql220 B2026-07-13 03:27📄TAP-3192_add_permissions_for_ows_payee.sql379 B2026-07-13 03:27📄TAP-3207_update_payment_allocation.payment_status_enum.sql2.1 KB2026-07-13 03:27📄TAP-3552_add_index_for_abacus_event.sql279 B2026-07-13 03:27📄TAP-595-make-account-payment-term-default-null.sql517 B2026-07-13 03:27📄TAP-648-add-column-payment-method.sql2.2 KB2026-07-13 03:27📄TAP-648-create_reference_advance_payment_method.sql446 B2026-07-13 03:27📄TAP-648-grant-privileges-reference_advance_payment_method.sql273 B2026-07-13 03:27📄TAP-657_contract_advance_reference_payment_type_id.sql2.4 KB2026-07-13 03:27📄TAP-657_insert_into_reference_payment_type_table.sql697 B2026-07-13 03:27📄TAP-657_reference_payment_type_table.sql469 B2026-07-13 03:27📄TAP-657_reference_payment_type_table_privileges.sql253 B2026-07-13 03:27📄TAP-729-add-contract-advance-fields.sql2.2 KB2026-07-13 03:27📄TAP-733-add-contract-advance-ledger-fields.sql1.2 KB2026-07-13 03:27📄TAP-753-US-source-income-rate-to-contract-advance.sql1.8 KB2026-07-13 03:27📄TAP-767_create_worksheet_payment_contract_advance_table.sql2.2 KB2026-07-13 03:27📄TAP-767_grant_privileges_worksheet_advance.sql260 B2026-07-13 03:27📄TAP-771-update-advance-status-enum.sql1.1 KB2026-07-13 03:27📄TAP-795-abacus_state-increase-column-length.sql449 B2026-07-13 03:27📄TAP-825_update_worksheet_payment_contract_advance_table.sql1.6 KB2026-07-13 03:27📄TAP-839-abacus_event_increase_column_size.sql218 B2026-07-13 03:27📄TAP-901-alter_ledger_contract_advance_applied.sql975 B2026-07-13 03:27📄TAP-974-create_worksheet_account_contract_closing_balance.sql1.8 KB2026-07-13 03:27📄TAP-974-update_worksheet_account_contract_closing_balance.sql352 B2026-07-13 03:27📄TAP-990-update-advance-status-enum.sql1.2 KB2026-07-13 03:27📄TAP-PAYMENT-1313_add_indexes_for_tax_correction_status_query.sql542 B2026-07-13 03:27📄TECH-WEEK-drop-rollback-tables.sql3.2 KB2026-07-13 03:27📄WAR-1102_add_column_error_details_to_statement_attachment.sql301 B2026-07-13 03:27📄WAR-1163_update_status_enum_in_the_statement_attachment_database_table.sql384 B2026-07-13 03:27📄WAR-1189_add_new_row_dimension_to_custom_reports.sql521 B2026-07-13 03:27📄WAR-1195_add_new_statement_attachments_type.sql850 B2026-07-13 03:27📄WAR-1281_add_column_file_type_to_statement_attachment.sql255 B2026-07-13 03:27📄WAR-1286_make_statement_attachemnt_file_type_not_nullable.sql274 B2026-07-13 03:27📄WAR-1299_ows_moneyhub_select_account.sql167 B2026-07-13 03:27📄WAR-1436_create_vat_summary_file_table.sql737 B2026-07-13 03:27📄WAR-1436_grant_select_insert_vat_summary_file.sql195 B2026-07-13 03:27📄WAR-1437_grant_select_insert_abacus_event.sql179 B2026-07-13 03:27📄WAR-154_statement_attachment_revenue_report.sql499 B2026-07-13 03:27📄WAR-1553_add_is_reporting_only_column_to_ledger_vat_summary.sql353 B2026-07-13 03:27📄WAR-1575_grant_permissions_worksheet_tables.sql352 B2026-07-13 03:27📄WAR-1776_add_description_column_to_ledger_vat_summary.sql247 B2026-07-13 03:27📄WAR-181_moneyhub_user_select_access.sql869 B2026-07-13 03:27📄WAR-1824_update_statement_attachemnt_table.sql1.2 KB2026-07-13 03:27📄WAR-1948_permissions_worksheet_closing_balance.sql778 B2026-07-13 03:27📄WAR-195_create_report_custom.sql757 B2026-07-13 03:27📄WAR-195_grant_access_report_custom.sql216 B2026-07-13 03:27📄WAR-195_multiple_dimension_reports.sql613 B2026-07-13 03:27📄WAR-2022_update_statement_attachemnt_table_file_type_enum.sql278 B2026-07-13 03:27📄WAR-2103_update_statement_attachments_file_type_enum.sql383 B2026-07-13 03:27📄WAR-2205_update_statement_attachment_for_legacy_reports.sql1.4 KB2026-07-13 03:27📄WAR-2228_add_number_format_column_to_statement_attachment_table.sql241 B2026-07-13 03:27📄WAR-2288_add_activity_statement_period_to_vat_summary.sql702 B2026-07-13 03:27📄WAR-2325_add_subaccount_id_statement_attachment.sql243 B2026-07-13 03:27📄WAR-2376_add_wht_columns_to_ledger_vat_summary.sql537 B2026-07-13 03:27📄WAR-2376_add_wht_rate_to_ledger_vat_summary.sql247 B2026-07-13 03:27📄WAR-2568_tax_entity_company_code.sql727 B2026-07-13 03:27📄WAR-2620_add_failure_reason_to_statement_attachment.sql398 B2026-07-13 03:27📄WAR-2675_add_new_row_dimension_to_custom_reports.sql558 B2026-07-13 03:27📄WAR-2693_add_imprint_to_report_custom_dimension_row_enum.sql545 B2026-07-13 03:27📄WAR-2699_add_subaccount_id_to_report_custom.sql222 B2026-07-13 03:27📄WAR-2727_add_subaccount_to_dimension_row.sql618 B2026-07-13 03:27📄WAR-2781_add_column_statement_period_ids_to_statement_attachment.sql271 B2026-07-13 03:27📄WAR-2851_permissions_flowthrough.sql523 B2026-07-13 03:27📄WAR-2947-fix_modify_file_type_enum_in_report_custom_table.sql286 B2026-07-13 03:27📄WAR-2947_add_number_format_and_file_type__columns_to_report_custom_table.sql479 B2026-07-13 03:27📄WAR-2989_add_filters_column_to_report_custom.sql213 B2026-07-13 03:27📄WAR-3025_add_filters_column_to_statement_attachment.sql224 B2026-07-13 03:27📄WAR-305_alter_statement_attachment_add_contract_id.sql578 B2026-07-13 03:27📄WAR-320_moneyhub_user_ledger_account_access.sql1018 B2026-07-13 03:27📄WAR-335_statement_attachment_type_neighbouring_rights.sql468 B2026-07-13 03:27📄WAR-3411_add_project_report_custom_dimension.sql602 B2026-07-13 03:27📄WAR-345_adding_contract_id_to_report_custom_table.sql225 B2026-07-13 03:27📄WAR-3462_add_report_custom_revenue_display_type.sql270 B2026-07-13 03:27📄WAR-3518_add_new_royalty_statement_attachment_type.sql1.1 KB2026-07-13 03:27📄WAR-364_grant_privileges.sql217 B2026-07-13 03:27📄WAR-381_grant_additional_priveleges.sql1.7 KB2026-07-13 03:27📄WAR-414_create_reference_signing_entity_table.sql1.8 KB2026-07-13 03:27📄WAR-414_grant_reference_signing_entity_access.sql200 B2026-07-13 03:27📄WAR-440_add_revenue_type_to_custom_report.sql291 B2026-07-13 03:27📄WAR-442_add_statement_attachment_type_to_statement_attachment_table.sql517 B2026-07-13 03:27📄WAR-448_grant_select_ledger_account_contract.sql382 B2026-07-13 03:27📄WAR-487_remove_vw_account_statement_period_table.sql2.2 KB2026-07-13 03:27📄WAR-497_add_secondary_dimensions.sql386 B2026-07-13 03:27📄WAR-590_add_new_primary_dimension.sql344 B2026-07-13 03:27📄WAR-615_access_contract_advance.sql187 B2026-07-13 03:27📄WAR-630_add_new_types_to_the_statement_attachment_table.sql621 B2026-07-13 03:27📄WAR-677_ledger_adjustment_detail_applied_moneyhub_permissions.sql216 B2026-07-13 03:27📄WAR-693_add_new_secondary_dimension_to_custom_reports.sql437 B2026-07-13 03:27📄WAR-703_add_new_secondary_dimension_to_custom_reports.sql484 B2026-07-13 03:27📄WAR-714_add_new_types_to_the_statement_attachment_table.sql761 B2026-07-13 03:27📄WAR-740-primary-secondary-nullable.sql827 B2026-07-13 03:27📄WAR-740_add_row_column_dimension_columns.sql642 B2026-07-13 03:27📄WAR-740_fill_row_column_dimensions.sql1.0 KB2026-07-13 03:27📄WAR-740_remove_primary_secondary_dimensions.sql661 B2026-07-13 03:27📄WAR-754_create_ledger_vat_summary_table.sql2.0 KB2026-07-13 03:27📄WAR-754_grant_select_vat_summary.sql191 B2026-07-13 03:27📄WAR-754_rename_statement_period.sql1.0 KB2026-07-13 03:27📄WAR-839_abacus_event_insert_access_moneyhub.sql177 B2026-07-13 03:27📄WAR-839_abacus_event_insert_access_moneyhub_for_real.sql177 B2026-07-13 03:27📄WAR-839_ledger_vat_summary_access_moneyhub.sql189 B2026-07-13 03:27📄WAR-954_ledger_correction_moneyhub_permissions.sql186 B2026-07-13 03:27