"""royalty_accounting/prod Models.""" import datetime import decimal from typing import Any, Optional from snowflake.sqlalchemy.custom_types import TIMESTAMP_NTZ, TIMESTAMP_TZ, VARIANT from sqlalchemy import ( DECIMAL, Boolean, Column, Float, Identity, PrimaryKeyConstraint, String, Table, text, ) from sqlalchemy.orm import DeclarativeBase, Mapped, MappedAsDataclass, mapped_column from abacus_models.core.mixins import BaseMixin from abacus_models.core.types import NormalizedDate class Base(MappedAsDataclass, DeclarativeBase, BaseMixin): pass class AbacusAccountExclusions(Base): __tablename__ = 'abacus_account_exclusions' __table_args__ = ( PrimaryKeyConstraint( 'abacus_account_exclusion_id', name='SYS_CONSTRAINT_1ffc4db9-53a4-4d08-8fa1-dd626575655c', ), ) abacus_account_exclusion_id: Mapped[decimal.Decimal] = mapped_column( DECIMAL(18, 0), Identity(start=1, increment=1, cycle=False, order=False), primary_key=True, autoincrement=True, init=False, ) account_id: Mapped[decimal.Decimal] = mapped_column(DECIMAL(12, 0), nullable=False) account_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) reason: Mapped[Optional[str]] = mapped_column(String(16777216), default=None) date_added: Mapped[Optional[datetime.date]] = mapped_column( NormalizedDate, default=None ) added_by: Mapped[Optional[str]] = mapped_column(String(255), default=None) t_abacus_fact_sales_unified_dbt = Table( 'abacus_fact_sales_unified_dbt', Base.metadata, Column('statement_period_id', DECIMAL(38, 0), default=None), Column('account_id', DECIMAL(32, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('sale_currency_code', String(30), default=None), Column('sale_activity_rate', DECIMAL(18, 6), default=None), Column('accounting_period_id', DECIMAL(38, 0), default=None), Column('country_id', DECIMAL(16, 0), default=None), Column('isrc', String(16777216), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('cd_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('video_id', String(16777216), default=None), Column('upc', DECIMAL(38, 0), default=None), Column('statement_id', DECIMAL(32, 0), default=None), Column('start_date', NormalizedDate, default=None), Column('transaction_type', String(4), default=None), Column('transaction_subtype', String(255), default=None), Column('label_id', DECIMAL(32, 0), default=None), Column('quantity', DECIMAL(24, 6), default=None), Column('phys_ppd_usd', DECIMAL(18, 6), default=None), Column('unique_detail_id', DECIMAL(38, 0), default=None), Column('txn_id', DECIMAL(38, 0), default=None), Column('accounting_run_id', DECIMAL(18, 0), default=None), Column('accounting_run_name', String(255), default=None), Column('unit_price_payee_currency', DECIMAL(24, 12), default=None), Column('withholding_tax_sale_currency', DECIMAL(24, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), default=None, ), Column('net_share_payee_currency', DECIMAL(24, 12), default=None), Column('distribution_fee_payee_currency', DECIMAL(24, 12), default=None), Column('withholding_tax_payee_currency', DECIMAL(24, 12), default=None), Column('batch_id', String(255), default=None), Column('sales_file_id', DECIMAL(18, 0), default=None), Column('run_controller_id', DECIMAL(38, 0), default=None), Column('contract_term_id', DECIMAL(12, 0), default=None), Column('contract_term_condition_id', DECIMAL(12, 0), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('subdistributor', String(16777216), default=None), Column('current_batch_id', String(255), default=None), Column('new_allocation', Boolean, default=None), Column('abacus_sale_type', String(20), default=None), Column('original_statement_period_id', DECIMAL(38, 0), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('dpd_publishing_payee_currency', DECIMAL(18, 6), default=None), Column('cloud_publishing_payee_currency', DECIMAL(18, 6), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('record_type', String(11), default=None), Column('unit_price_usd', DECIMAL(38, 12), default=None), Column('transaction_date', NormalizedDate, default=None), Column('royalty_rate', DECIMAL(31, 12), default=None), Column('unit_price_sale_currency', DECIMAL(38, 12), default=None), Column('gross_revenue_sale_currency', DECIMAL(38, 12), default=None), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(38, 12), default=None, ), Column('net_share_sale_currency', DECIMAL(38, 12), default=None), Column('distribution_fee_sale_currency', DECIMAL(38, 12), default=None), Column('is_excluded_from_sap', Boolean, default=None), Column('actual_statement_number', String(128), default=None), Column('mechanical_deduction_admin_type', String(16777216), default=None), Column('mechanical_royalty_amount_sale_currency', DECIMAL(38, 12), default=None), Column('mechanical_royalty_amount_payee_currency', DECIMAL(26, 12), default=None), Column('mechanical_deduction_amount_sale_currency', DECIMAL(38, 12), default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(26, 12), default=None), Column('publisher_admin_fee_sale_currency', DECIMAL(38, 12), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(24, 12), default=None), Column('net_revenue_after_mechanical_sale_currency', DECIMAL(38, 12), default=None), Column( 'net_revenue_after_mechanical_payee_currency', DECIMAL(24, 12), default=None ), ) t_account_statement_periods_dbt = Table( 'account_statement_periods_dbt', Base.metadata, Column('statement_period_id', DECIMAL(38, 0), default=None), Column('statement_period_name', String(180), default=None), Column('statement_period_status', String(7), default=None), Column('statement_year', DECIMAL(38, 0), default=None), Column('statement_month', DECIMAL(38, 0), default=None), Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('currency_code', String(12), default=None), ) t_accounting_run_results_distro = Table( 'accounting_run_results_distro', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), comment='Unique identifier of a contract_transaction (CONTRACT_TRANSACTION_STAGING.CONTRACT_TXN_ID)', default=None, ), Column( 'txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a transaction (STMT_DB_SALES_DISTRO_STAGING.STMT_DB_SALES_DISTRO_TXN_ID).', default=None, ), Column( 'accounting_run_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='ID of the accounting_run these results belong to (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'accounting_run_name', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Name of the accounting_run these results belong to (RDS royalty_accounting.run_controller.run_controller_name).', default=None, ), Column( 'term_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The term_rate on the contract applied to royalties (RDS royalty_accounting.contract_term_condition.term_rate / 100).', default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), nullable=False, comment='The sale unit price converted from USD to the sale currency (STMT_DB_SALES_DISTRO.UNIT_PRICE_USD / STMT_DB_SALES_DISTRO.ACTIVITY_RATE_USD).', ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), nullable=False, comment='The gross revenue of sales in the original sale currency (STMT_DB_SALES_DISTRO.QUANTITY * UNIT_PRICE_SALE_CURRENCY).', ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale withholding tax (WHT) converted from USD to the sale currency (STMT_DB_SALES_DISTRO.WITHHOLDING_TAX_USD / STMT_DB_SALES_DISTRO.ACTIVITY_RATE_USD).', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales minus WHT in the original sale currency (GROSS_REVENUE_SALE_CURRENCY - WITHHOLDING_TAX_SALE_CURRENCY).', default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue after applying the contract term rate in the original sale currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * TERM_RATE).', default=None, ), Column( 'distribution_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The distribution fee in the original sale currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY - NET_REVENUE_SALE_CURRENCY * -1).', default=None, ), Column( 'unit_price_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale unit price converted from the original sale currency to the account preferred currency (UNIT_PRICE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'gross_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales convered from the original sale currency to the account preferred currency (GROSS_REVENUE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale withholding tax (WHT) converted from the original sale currency to the account preferred currency (WITHHOLDING_TAX_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales minus WHT converted from the original sale currency to the account preferred currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The net revenue converted from the original sale currency to the account preferred currency (NET_REVENUE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'distribution_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The distribution fee converted from the original sale currency to the account preferred currency (DISTRIBUTION_FEE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), ) t_accounting_run_results_distro_mech = Table( 'accounting_run_results_distro_mech', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a contract/transaction pairing (CONTRACT_TRANSACTION_STAGING.CONTRACT_TXN_ID).', default=None, ), Column( 'mechanical_transaction_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a mechanical/transaction pairing (SNAPSHOT_MECHANICAL_TRANSACTION.MECHANICAL_TRANSACTION_ID).', default=None, ), Column( 'contract_mechanical_deduction_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of the contract mechanical rules used (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.CONTRACT_MECHANICAL_DEDUCTION_ID).', default=None, ), Column( 'territory', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='One of: USA, CAN, or ROW (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.TERRITORY).', default=None, ), Column( 'mechanical_deduction_admin_type', String(8), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='One of: both, business, or customer; used to determine who pays for the deduction (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.ADMIN_TYPE).', default=None, ), Column( 'mechanical_deduction_rate', DECIMAL(10, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='This is based on the MECHANICAL_DEDUCTION_ADMIN_TYPE and reflects what percentage of the deduction the customer pays to HFA.', default=None, ), Column( 'publisher_admin_fee_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='A decimal representation of the percentage the company takes, if specified (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.ADMIN_FEE / 100).', default=None, ), Column( 'mechanical_royalty_amount_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated total mech royalty amount for the transaction (SNAPSHOT_MECHANICAL_TRANSACTION.ROYALTY_AMOUNT).', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated gross revenue for the contract_transaction in the original sale currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY).', default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated net revenue for the contract_transaction in the original sale currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.NET_REVENUE_SALE_CURRENCY).', default=None, ), Column( 'mechanical_deduction_amount_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated amount the customer will pay in the original sale currency ((MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY / MECHANICAL_DEDUCTION_RATE) * -1).', default=None, ), Column( 'publisher_admin_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated admin fee deducted from the customer in the original sale currency ((MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY / PUBLISHER_ADMIN_FEE_RATE) * -1).', default=None, ), Column( 'net_revenue_after_mechanical_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The total royalty amount after deducting mech and admin fees in the original sale currency (NET_REVENUE_SALE_CURRENCY + MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY + PUBLISHER_ADMIN_FEE_SALE_CURRENCY).', default=None, ), Column( 'mechanical_royalty_amount_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated total mech royalty amount converted into the payee currency (MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated gross revenue for the contract_transaction in the payee currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_PAYEE_CURRENCY).', default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated net revenue for the contract_transaction in the payee currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.NET_REVENUE_PAYEE_CURRENCY).', default=None, ), Column( 'mechanical_deduction_amount_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated amount the customer will pay converted into the payee currency (MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'publisher_admin_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated admin fee deducted from the customer converted into the payee currency (PUBLISHER_ADMIN_FEE_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'net_revenue_after_mechanical_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated total royalty amount after deducting mech and admin fees converted into the payee currency (NET_REVENUE_AFTER_MECHANICAL_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), ) t_accounting_run_results_distro_mech_staging = Table( 'accounting_run_results_distro_mech_staging', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a contract/transaction pairing (CONTRACT_TRANSACTION_STAGING.CONTRACT_TXN_ID).', default=None, ), Column( 'mechanical_transaction_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a mechanical/transaction pairing (SNAPSHOT_MECHANICAL_TRANSACTION.MECHANICAL_TRANSACTION_ID).', default=None, ), Column( 'contract_mechanical_deduction_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of the contract mechanical rules used (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.CONTRACT_MECHANICAL_DEDUCTION_ID).', default=None, ), Column( 'territory', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='One of: USA, CAN, or ROW (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.TERRITORY).', default=None, ), Column( 'mechanical_deduction_admin_type', String(8), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='One of: both, business, or customer; used to determine who pays for the deduction (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.ADMIN_TYPE).', default=None, ), Column( 'mechanical_deduction_rate', DECIMAL(10, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='This is based on the MECHANICAL_DEDUCTION_ADMIN_TYPE and reflects what percentage of the deduction the customer pays to HFA.', default=None, ), Column( 'publisher_admin_fee_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='A decimal representation of the percentage the company takes, if specified (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.ADMIN_FEE / 100).', default=None, ), Column( 'mechanical_royalty_amount_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated total mech royalty amount for the transaction (SNAPSHOT_MECHANICAL_TRANSACTION.ROYALTY_AMOUNT).', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated gross revenue for the contract_transaction in the original sale currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY).', default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated net revenue for the contract_transaction in the original sale currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.NET_REVENUE_SALE_CURRENCY).', default=None, ), Column( 'mechanical_deduction_amount_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated amount the customer will pay in the original sale currency ((MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY / MECHANICAL_DEDUCTION_RATE) * -1).', default=None, ), Column( 'publisher_admin_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated admin fee deducted from the customer in the original sale currency ((MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY / PUBLISHER_ADMIN_FEE_RATE) * -1).', default=None, ), Column( 'net_revenue_after_mechanical_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The total royalty amount after deducting mech and admin fees in the original sale currency (NET_REVENUE_SALE_CURRENCY + MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY + PUBLISHER_ADMIN_FEE_SALE_CURRENCY).', default=None, ), Column( 'mechanical_royalty_amount_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated total mech royalty amount converted into the payee currency (MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated gross revenue for the contract_transaction in the payee currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_PAYEE_CURRENCY).', default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The previously calculated net revenue for the contract_transaction in the payee currency (ACCOUNTING_RUN_RESULTS_DISTRO_STAGING.NET_REVENUE_PAYEE_CURRENCY).', default=None, ), Column( 'mechanical_deduction_amount_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated amount the customer will pay converted into the payee currency (MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'publisher_admin_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated admin fee deducted from the customer converted into the payee currency (PUBLISHER_ADMIN_FEE_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'net_revenue_after_mechanical_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The calculated total royalty amount after deducting mech and admin fees converted into the payee currency (NET_REVENUE_AFTER_MECHANICAL_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), ) t_accounting_run_results_distro_staging = Table( 'accounting_run_results_distro_staging', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), comment='Unique identifier of a contract_transaction (CONTRACT_TRANSACTION_STAGING.CONTRACT_TXN_ID)', default=None, ), Column( 'txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a transaction (STMT_DB_SALES_DISTRO_STAGING.STMT_DB_SALES_DISTRO_TXN_ID).', default=None, ), Column( 'accounting_run_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='ID of the accounting_run these results belong to (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'accounting_run_name', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Name of the accounting_run these results belong to (RDS royalty_accounting.run_controller.run_controller_name).', default=None, ), Column( 'term_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The term_rate on the contract applied to royalties (RDS royalty_accounting.contract_term_condition.term_rate / 100).', default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), nullable=False, comment='The sale unit price converted from USD to the sale currency (STMT_DB_SALES_DISTRO.UNIT_PRICE_USD / STMT_DB_SALES_DISTRO.ACTIVITY_RATE_USD).', ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), nullable=False, comment='The gross revenue of sales in the original sale currency (STMT_DB_SALES_DISTRO.QUANTITY * UNIT_PRICE_SALE_CURRENCY).', ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale withholding tax (WHT) converted from USD to the sale currency (STMT_DB_SALES_DISTRO.WITHHOLDING_TAX_USD / STMT_DB_SALES_DISTRO.ACTIVITY_RATE_USD).', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales minus WHT in the original sale currency (GROSS_REVENUE_SALE_CURRENCY - WITHHOLDING_TAX_SALE_CURRENCY).', default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue after applying the contract term rate in the original sale currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * TERM_RATE).', default=None, ), Column( 'distribution_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The distribution fee in the original sale currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY - NET_REVENUE_SALE_CURRENCY * -1).', default=None, ), Column( 'unit_price_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale unit price converted from the original sale currency to the account preferred currency (UNIT_PRICE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'gross_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales convered from the original sale currency to the account preferred currency (GROSS_REVENUE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale withholding tax (WHT) converted from the original sale currency to the account preferred currency (WITHHOLDING_TAX_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales minus WHT converted from the original sale currency to the account preferred currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The net revenue converted from the original sale currency to the account preferred currency (NET_REVENUE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'distribution_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The distribution fee converted from the original sale currency to the account preferred currency (DISTRIBUTION_FEE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), ) t_accounting_run_results_nr = Table( 'accounting_run_results_nr', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), comment='Unique identifier of a contract_transaction (CONTRACT_TRANSACTION_NR_STAGING.CONTRACT_TXN_ID)', default=None, ), Column( 'txn_id', DECIMAL(38, 0), nullable=False, comment='This is the sequence from stmt_db_sales_nr_staging', ), Column( 'accounting_run_id', DECIMAL(18, 0), comment='This comes from the royalty_accounting.accounting_run table', default=None, ), Column( 'accounting_run_name', String(255), comment='This comes from the royalty_accounting.accounting_run table', default=None, ), Column( 'royalty_rate', DECIMAL(5, 4), comment='The term rate that is in the contract_term_condition', default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), comment='Unit price in the sale currency unit_price_usd/activity_rate', default=None, ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), comment='Unit price * quantity in sale currency', default=None, ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), comment='WHT is pass thru from CMO - tax amount they take', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), comment='in sale currency: unit*quantity+wht', default=None, ), Column( 'net_share_sale_currency', DECIMAL(24, 12), comment='sale currency: gross_after_wht*royalty_rate', default=None, ), Column('unit_price_payee_currency', DECIMAL(24, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column('withholding_tax_payee_currency', DECIMAL(24, 12), default=None), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), default=None, ), Column('net_share_payee_currency', DECIMAL(24, 12), default=None), ) t_accounting_run_results_nr_staging = Table( 'accounting_run_results_nr_staging', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), comment='Unique identifier of a contract_transaction (CONTRACT_TRANSACTION_NR_STAGING.CONTRACT_TXN_ID)', default=None, ), Column( 'txn_id', DECIMAL(38, 0), nullable=False, comment='This is the sequence from stmt_db_sales_nr_staging', ), Column( 'accounting_run_id', DECIMAL(18, 0), comment='This comes from the royalty_accounting.accounting_run table', default=None, ), Column( 'accounting_run_name', String(255), comment='This comes from the royalty_accounting.accounting_run table', default=None, ), Column( 'royalty_rate', DECIMAL(5, 4), comment='The term rate that is in the contract_term_condition', default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), comment='Unit price in the sale currency unit_price_usd/activity_rate', default=None, ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), comment='Unit price * quantity in sale currency', default=None, ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), comment='WHT is pass thru from CMO - tax amount they take', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), comment='in sale currency: unit*quantity+wht', default=None, ), Column( 'net_share_sale_currency', DECIMAL(24, 12), comment='sale currency: gross_after_wht*royalty_rate', default=None, ), Column('unit_price_payee_currency', DECIMAL(24, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column('withholding_tax_payee_currency', DECIMAL(24, 12), default=None), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), default=None, ), Column('net_share_payee_currency', DECIMAL(24, 12), default=None), ) t_accounting_run_results_publishing = Table( 'accounting_run_results_publishing', Base.metadata, Column('contract_txn_id', DECIMAL(38, 0), default=None), Column('txn_id', DECIMAL(38, 0), nullable=False), Column('period_id', DECIMAL(38, 0), default=None), Column('base_fee', DECIMAL(24, 12), default=None), Column('orchard_fee', DECIMAL(24, 12), default=None), Column('gross_revenue_sale_currency', DECIMAL(24, 12), default=None), Column('adjusted_gross_revenue_sale_currency', DECIMAL(24, 12), default=None), Column('net_share_sale_currency', DECIMAL(24, 12), default=None), Column('payout_currency', String(4), default=None), Column('exchange_rate', DECIMAL(24, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column('adjusted_gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column('net_share_payee_currency', DECIMAL(24, 12), default=None), ) t_adjustments_by_type_dbt = Table( 'adjustments_by_type_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(3), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('adjustment_amount_payee_currency', DECIMAL(32, 2), default=None), ) class BookedAccountContractSnapshot(Base): __tablename__ = 'booked_account_contract_snapshot' __table_args__ = ( PrimaryKeyConstraint( 'contract_snapshot_id', name='SYS_CONSTRAINT_7853982f-6128-4898-a75d-bc7c765fc15b', ), ) contract_snapshot_id: Mapped[decimal.Decimal] = mapped_column( DECIMAL(38, 0), Identity(start=1, increment=1, cycle=False, order=False), primary_key=True, comment='PRIMARY key.', autoincrement=True, init=False, ) insert_date: Mapped[Any] = mapped_column( TIMESTAMP_TZ, nullable=False, server_default=text('CURRENT_TIMESTAMP()') ) period_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) contract_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) account_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='FOREIGN KEY TO royalty_accounting.account table.', default=None, ) cont_start: Mapped[Optional[datetime.date]] = mapped_column( NormalizedDate, comment='ContractLifecycle Term Start Date.', default=None ) cont_end: Mapped[Optional[datetime.date]] = mapped_column( NormalizedDate, comment='ContractLifecycle Term End Date.', default=None ) cont_version: Mapped[Optional[str]] = mapped_column(String(50), default=None) exclusive_entry: Mapped[Optional[str]] = mapped_column( String(16777216), comment='VALUE can be "yes_digital","yes_physical","yes_both","no_both","y" or "n". Yes OR NO indicates whether theres exclusivity ON the contract.', default=None, ) orchrep_name: Mapped[Optional[str]] = mapped_column( String(55), comment='NAME of the Orchard rep.', default=None ) carve_out: Mapped[Optional[str]] = mapped_column( String(255), comment='Deprecated', default=None ) qualification_level: Mapped[Optional[str]] = mapped_column( String(44), comment='Qualification LEVEL of the contract.', default=None ) territory_carve_out: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Countries that are restricted FROM the contract.', default=None, ) dms_carve_out: Mapped[Optional[str]] = mapped_column( String(16777216), comment='DMS customers that are restricted FROM the contract.', default=None, ) dms_master_carve_out: Mapped[Optional[str]] = mapped_column( String(16777216), comment='DMS MASTER MASTER that are restricted FROM the contract.', default=None, ) encoding_fees_cap_back_ctlg: Mapped[Optional[float]] = mapped_column( Float, comment='Encoding fees cap for back catalogue.', default=None ) encoding_fees_cap_new_release: Mapped[Optional[float]] = mapped_column( Float, comment='Encoding fees cap for NEW releases.', default=None ) digital_split: Mapped[Optional[float]] = mapped_column( Float, comment='Digital split BETWEEN label AND Orchard.', default=None ) physical_split: Mapped[Optional[float]] = mapped_column( Float, comment='Physical split BETWEEN label AND Orchard.', default=None ) contract_type: Mapped[Optional[str]] = mapped_column( String(16), comment='TYPE of contract. VALUE can be "account_term" OR "per_release_term".', default=None, ) release_term: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='Number of years for the contract IF the contract TYPE IS per_release_term.', default=None, ) advance_payment: Mapped[Optional[float]] = mapped_column( Float, comment='Advanced payment amount.', default=None ) advance_recoupable_percentage: Mapped[Optional[float]] = mapped_column( Float, comment='Advanced recoupable percentage.', default=None ) dig_distribution_type: Mapped[Optional[str]] = mapped_column( String(14), comment='Digital distribution TYPE of the track. VALUE can be "digital_mobile", "digital_only", OR "mobile_only".', default=None, ) possible_track_restrictions: Mapped[Optional[str]] = mapped_column( String(1), comment='Yes OR NO indicates whether there"s possible restrictions ON tracks.', default=None, ) oms_type: Mapped[Optional[str]] = mapped_column( String(10), comment='Mechanical Deduction Admin Type. VALUE can be "both", "business", OR "customer".', default=None, ) oms_fee_percentage: Mapped[Optional[float]] = mapped_column( Float, comment='Mechanical Deduction Admin Fee.', default=None ) negotiated_changes: Mapped[Optional[str]] = mapped_column( String(1), comment='Yes OR NO indicates whether there"s negotiated changes.', default=None, ) negotiated_change_comments: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Negotiated CHANGE COMMENT text.', default=None ) contract_complete: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates IF the contract has been reviewed BY Legal AND marked AS completed.', default=None, ) signature_date: Mapped[Optional[datetime.date]] = mapped_column( NormalizedDate, comment='Contracts Execution Date.', default=None ) marketing_restrictions: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates whether the agreement has marketing restrictions.', default=None, ) orchard_assignment_right_restriction: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates whether the agreement has orchard assignment right.', default=None, ) currency_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), server_default=text('1'), comment='FOREIGN KEY TO art_relations.currency table.', default=None, ) third_party_responsibility: Mapped[Optional[str]] = mapped_column( String(8), comment='VALUE can be "standard" or "other".Indicates whether the agreement has third party responsibility.', default=None, ) third_party_responsibility_detail: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Detail of third party responsibility.', default=None ) possible_track_restriction_detail: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Detail of possible track_restrictions.', default=None ) is_amendment: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates whether the agreement IS an amendment.', default=None, ) extend_until_recouped: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates whether the agreement should extend UNTIL recoupment.', default=None, ) sync_admin_territory: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Syncronization Admin Territory multi-SELECT dropdown of countries', default=None, ) sync_admin_commission: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Sync Admin Split textbox. Enter 0.75 for 75%', default=None, ) sync_admin_type_of_deal: Mapped[Optional[str]] = mapped_column( String(28), comment='Sync Admin TYPE of Deal dropdown. VALUE can be "master_admin","master_or_publishing_admin","publishing_admin_only"', default=None, ) royalty_collection_territory: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Royalty Collection Territory Multi-SELECT dropdown of countries. ', default=None, ) royalty_collection_commission: Mapped[Optional[float]] = mapped_column( Float, comment='Royalty Collection Split textbox. Enter 0.75 for 75%', default=None, ) publishing_admin_commission: Mapped[Optional[float]] = mapped_column( Float, comment='Publishing Administration Split textbox. Enter 0.75 for 75%', default=None, ) publishing_admin_territory: Mapped[Optional[str]] = mapped_column( String(16777216), comment='Publishing Admin Territory multi-SELECT dropdown of countries', default=None, ) publishing_admin_limit_grant_of_rights: Mapped[Optional[str]] = mapped_column( String(50), comment='Publishing Administration LIMIT GRANT of Rights FIELD', default=None, ) publishing_admin_misc_provisions: Mapped[Optional[str]] = mapped_column( String(50), comment='Publishing Administration Misc Previsions FIELD', default=None, ) parent_account_contract_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='Contract id of the previous VERSION of this contract', default=None, ) account_type: Mapped[Optional[str]] = mapped_column( String(10), server_default=text("'vendor'"), comment='VALUE can be "vendor" or "oms_client". indicate whether this contract IS for Label OR OMS CLIENT', default=None, ) vendor_proposed_term_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='FOREIGN KEY referencing account proposed term TABLE', default=None, ) sync_admin_response_time: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='Sync Admin Response TIME textbox', default=None ) ringtone_publishing_type: Mapped[Optional[str]] = mapped_column( String(7), comment='VALUE can be "both", "business", OR "customer". Take Ringtone Publishing dropdown', default=None, ) physical_track_publishing_type: Mapped[Optional[str]] = mapped_column( String(7), comment='VALUE can be "both", "business", OR "customer". Field to store physical track publishing ', default=None, ) unlimited_roll: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Unlimited Roll dropdown', default=None, ) rollover_length_in_months: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='Rollover LENGTH IN Months textfield', default=None ) can_terminate: Mapped[Optional[str]] = mapped_column( String(1), server_default=text("'Y'"), comment='VALUE can be "Y" or "N". Can Terminate BEFORE Rollover ENDS dropdown', default=None, ) youtube_composition_clause: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N".', default=None ) sx_royalty_collection_commission: Mapped[Optional[float]] = mapped_column( Float, default=None ) topspin_rate: Mapped[Optional[float]] = mapped_column(Float, default=None) topspin_rate_territory: Mapped[Optional[str]] = mapped_column( String(16777216), default=None ) notice_required_in_days: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), comment='Notice Required IN Days textbox', default=None ) term_continues_until_recouped: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Term Continues UNTIL Recouped dropdown', default=None, ) brand_split: Mapped[Optional[float]] = mapped_column( Float, comment='Label"s Split - BRAND textfield IN edit account contract page', default=None, ) other_rights_option: Mapped[Optional[str]] = mapped_column( String(10), comment='VALUE can be "any_and_all","other","none" .Other rights', default=None, ) other_rights_text: Mapped[Optional[str]] = mapped_column( String(50), comment='Other rights TEXT for "other" OPTION', default=None ) special_product_split: Mapped[Optional[float]] = mapped_column(Float, default=None) special_product_carve_out: Mapped[Optional[str]] = mapped_column( String(16777216), default=None ) payment_interval: Mapped[Optional[str]] = mapped_column( String(50), comment='"30_days_after_month_end","45_days_after_month_end","60_days_after_month_end","90_days_after_month_end","30_days_after_quarter_end","45_days_after_quarter_end","60_days_after_quarter_end","90_days_after_quarter_end","30_days_after_half_year_end","45_days_after_half_year_end","60_days_after_half_year_end","90_days_after_half_year_end","TEMPORARY". How often the payment IS due', default=None, ) pay_after: Mapped[Optional[str]] = mapped_column( String(50), comment='"30_days_after_month_end","45_days_after_month_end","60_days_after_month_end","90_days_after_month_end","30_days_after_quarter_end","45_days_after_quarter_end","60_days_after_quarter_end","90_days_after_quarter_end","30_days_after_half_year_end","45_days_after_half_year_end","60_days_after_half_year_end","90_days_after_half_year_end","TEMPORARY". Days BEFORE payment IS due', default=None, ) show_credit_card: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N".', default=None ) opt_out: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Yes OR NO indicates whether OR NOT deliver content TO stores. DEFAULT N indicates, opt OUT IS FALSE AND content can be delivered', default=None, ) apply_fx_spread: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Yes OR NO indicates whether OR NOT TO apply FX Spread calculations during the monthly accounting PROCESS', default=None, ) orchard_compilation_agreement: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates the agreement for Orchard Compilation.', default=None, ) orchard_compilation_split: Mapped[Optional[float]] = mapped_column( Float, comment='Orchard Compilation Split(Label SHARE).', default=None ) orchard_compilation_authorization_required: Mapped[Optional[str]] = mapped_column( String(1), comment='VALUE can be "Y" or "N". Indicates whether Authorization Required for Orchard Compilation.', default=None, ) reserve_rate: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(10, 2), default=None ) number_of_months_before_payout: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) number_of_installments: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) contract_terms: Mapped[Optional[str]] = mapped_column( String(16777216), default=None ) service_type_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) t_cdc_sales_file_delivery_dig_sales_testfile_abacus = Table( 'cdc_sales_file_delivery_dig_sales_testfile_abacus', Base.metadata, Column('record_metadata', VARIANT, default=None), Column('record_content', VARIANT, default=None), ) t_cdc_sales_file_delivery_nr_sales_testfile_abacus = Table( 'cdc_sales_file_delivery_nr_sales_testfile_abacus', Base.metadata, Column('record_metadata', VARIANT, default=None), Column('record_content', VARIANT, default=None), ) t_combined_adjustments_by_type_dbt = Table( 'combined_adjustments_by_type_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('ledger_adjustment_applied_id', DECIMAL(38, 0), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), ) t_combined_adjustments_dbt = Table( 'combined_adjustments_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('note', String(16777215), default=None), Column('worksheet_adjustment_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), Column('ledger_adjustment_applied_id', DECIMAL(38, 0), default=None), Column('unique_identifier', String(16777216), default=None), ) t_combined_advances_dbt = Table( 'combined_advances_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('advance_amount', DECIMAL(32, 2), default=None), Column('advance_currency_code', String(12), default=None), Column('advance_amount_payee_currency', DECIMAL(32, 2), default=None), Column('advance_payee_currency_code', String(12), default=None), Column('advance_description', String(180), default=None), Column('unique_key', String(35), default=None), ) t_combined_expenses_by_artist_dbt = Table( 'combined_expenses_by_artist_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(38, 0), default=None), Column('artist_name', String(2000), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('upc', String(255), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), ) t_combined_expenses_by_imprint_dbt = Table( 'combined_expenses_by_imprint_dbt', Base.metadata, Column('imprint_id', DECIMAL(38, 0), default=None), Column('imprint', String(16777216), default=None), Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(38, 0), default=None), Column('artist_name', String(2000), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('upc', String(255), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), ) t_combined_expenses_by_subaccount_dbt = Table( 'combined_expenses_by_subaccount_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('subaccount_name', String(255), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('upc', String(255), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), ) t_combined_expenses_dbt = Table( 'combined_expenses_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('note', String(16777215), default=None), Column('upc', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('worksheet_adjustment_id', DECIMAL(38, 0), default=None), Column('distribution_type', String(8), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('artist_id', DECIMAL(38, 0), default=None), Column('artist_name', String(2000), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('subaccount_name', String(255), default=None), Column('unique_identifier', String(16777216), default=None), ) t_combined_payments_dbt = Table( 'combined_payments_dbt', Base.metadata, Column('unique_key', String(16777216), default=None), Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('currency_code', String(12), default=None), Column('currency_amount', DECIMAL(38, 2), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('event_name', String(32), default=None), Column('action_status', String(8), default=None), Column('withholding_tax_ledger_account_id', DECIMAL(38, 0), default=None), Column('withholding_tax_currency_code', String(3), default=None), Column('withholding_tax_currency_amount', DECIMAL(20, 2), default=None), Column('withholding_tax_created_at', TIMESTAMP_NTZ, default=None), Column('created_at', TIMESTAMP_NTZ, default=None), ) t_contract_dbt = Table( 'contract_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('contract_name', String(16777216), default=None), Column('term_start', NormalizedDate, default=None), ) t_contract_denormalized = Table( 'contract_denormalized', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('currency_code', String(3), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('contract_term_id', DECIMAL(38, 0), default=None), Column('contract_term_condition_id', DECIMAL(38, 0), default=None), Column('contract_term_start', NormalizedDate, default=None), Column('contract_term_end', NormalizedDate, default=None), Column('term_type', String(21), default=None), Column('term_rate', DECIMAL(5, 2), default=None), Column('term_label_id', DECIMAL(38, 0), default=None), Column('term_upc', DECIMAL(20, 0), default=None), Column('term_isrc', String(16), default=None), Column('country_id', DECIMAL(38, 0), default=None), Column('store_id', VARIANT, default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('priority', DECIMAL(38, 0), default=None), Column('run_controller_id', DECIMAL(38, 0), default=None), Column('track_rank', DECIMAL(13, 0), default=None), Column('product_rank', DECIMAL(13, 0), default=None), Column('label_rank', DECIMAL(13, 0), default=None), ) t_contract_denormalized_distro = Table( 'contract_denormalized_distro', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the parent account of the contract (RDS royalty_accounting.account.account_id).', default=None, ), Column( 'account_currency_code', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The account payment currency (RDS royalty_accounting.account_payment_term.currency_code).', default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the contract (RDS royalty_accounting.contract.contract_id).', default=None, ), Column( 'contract_term_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the terms on the contract (RDS royalty_accounting.contract_term.contract_term_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'contract_term_start', NormalizedDate, nullable=False, server_default=text("CAST('1970-02-01' AS DATE)"), comment='The contract term_start date (RDS royalty_accounting.contract.term_start).', ), Column( 'contract_term_end', NormalizedDate, nullable=False, server_default=text("CAST('2100-01-01' AS DATE)"), comment='The contract term_end date (RDS royalty_accounting.contract.term_end).', ), Column( 'term_type', String(12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The type of contract term (i.e. "label", "product", "track", etc) (RDS royalty_accounting.contract_term.term_type).', default=None, ), Column( 'term_rate', DECIMAL(5, 2), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The rate of the contract term to be applied to sales (RDS royalty_accounting.contract_term_condition.term_rate).', default=None, ), Column( 'label_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Label to which contract terms apply (RDS royalty_accounting.contract_term.attachments OR RDS royalty_accounting.contract_term.attachments_relations).', default=None, ), Column( 'priority', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Priority of the contract term condition (RDS royalty_accounting.contract_term_condition.priority).', default=None, ), Column( 'upc', DECIMAL(38, 0), comment='Optional: Product UPC to which contract terms apply (RDS royalty_accounting.contract_term.attachment when term_type is "product").', default=None, ), Column( 'isrc', String(255), comment='Optional: Track ISRC to which contract terms apply (RDS royalty_accounting.contract_term.attachment when term_type is "track").', default=None, ), Column( 'country_id', DECIMAL(38, 0), comment='Optional: ID of a country to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'store_id', DECIMAL(38, 0), comment='Optional: ID of a store/service to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'transaction_type_id', DECIMAL(38, 0), comment='Optional: ID of a transaction type to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), ) t_contract_denormalized_nr = Table( 'contract_denormalized_nr', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the parent account of the contract (RDS royalty_accounting.account.account_id).', default=None, ), Column( 'account_currency_code', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The account payment currency (RDS royalty_accounting.account_payment_term.currency_code).', default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the contract (RDS royalty_accounting.contract.contract_id).', default=None, ), Column( 'contract_term_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the terms on the contract (RDS royalty_accounting.contract_term.contract_term_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'contract_term_start', NormalizedDate, nullable=False, server_default=text("CAST('1970-02-01' AS DATE)"), comment='The contract term_start date (RDS royalty_accounting.contract.term_start).', ), Column( 'contract_term_end', NormalizedDate, nullable=False, server_default=text("CAST('2100-01-01' AS DATE)"), comment='The contract term_end date (RDS royalty_accounting.contract.term_end).', ), Column( 'term_type', String(50), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The type of contract term (i.e. "contributor_schedule", "contribution_schedule", etc) (RDS royalty_accounting.contract_term.term_type).', default=None, ), Column( 'term_rate', DECIMAL(5, 2), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The rate of the contract term to be applied to sales (RDS royalty_accounting.contract_term_condition.term_rate).', default=None, ), Column( 'schedule_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the schedule on the contract_term to which contributor/contributions belong (RDS royalty_accounting.contract_term_schedule.schedule_id).', default=None, ), Column( 'contributor_id', String(36), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Contributor to which contract terms apply (RDS royalty_accounting.contract_term.attachments_relations).', default=None, ), Column( 'contribution_id', String(36), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Contribution to which contract terms apply (RDS royalty_accounting.contract_term.attachments)', default=None, ), Column( 'country_id', DECIMAL(38, 0), comment='Optional: ID of a country to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'store_id', DECIMAL(38, 0), comment='Optional: ID of a store/service to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'transaction_type_id', DECIMAL(38, 0), comment='Optional: ID of a transaction type to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'priority', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Priority of the contract term condition (RDS royalty_accounting.contract_term_condition.priority).', default=None, ), ) t_contract_denormalized_nr_contrib_only = Table( 'contract_denormalized_nr_contrib_only', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the parent account of the contract (RDS royalty_accounting.account.account_id).', default=None, ), Column( 'account_currency_code', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The account payment currency (RDS royalty_accounting.account_payment_term.currency_code).', default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the contract (RDS royalty_accounting.contract.contract_id).', default=None, ), Column( 'contract_term_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the terms on the contract (RDS royalty_accounting.contract_term.contract_term_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'contract_term_start', NormalizedDate, nullable=False, server_default=text("CAST('1970-02-01' AS DATE)"), comment='The contract term_start date (RDS royalty_accounting.contract.term_start).', ), Column( 'contract_term_end', NormalizedDate, nullable=False, server_default=text("CAST('2100-01-01' AS DATE)"), comment='The contract term_end date (RDS royalty_accounting.contract.term_end).', ), Column( 'term_type', String(50), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The type of contract term (i.e. "contributor_schedule", "contribution_schedule", etc) (RDS royalty_accounting.contract_term.term_type).', default=None, ), Column( 'term_rate', DECIMAL(5, 2), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The rate of the contract term to be applied to sales (RDS royalty_accounting.contract_term_condition.term_rate).', default=None, ), Column( 'schedule_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the schedule on the contract_term to which contributor/contributions belong (RDS royalty_accounting.contract_term_schedule.schedule_id).', default=None, ), Column( 'contributor_id', String(36), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Contributor to which contract terms apply (RDS royalty_accounting.contract_term.attachments_relations).', default=None, ), Column( 'country_id', DECIMAL(38, 0), comment='Optional: ID of a country to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'store_id', DECIMAL(38, 0), comment='Optional: ID of a store/service to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'transaction_type_id', DECIMAL(38, 0), comment='Optional: ID of a transaction type to which contract terms apply (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'priority', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Priority of the contract term condition (RDS royalty_accounting.contract_term_condition.priority).', default=None, ), Column( 'rate_rank', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Used to determine which contract to use for matching when all other values are equal.', default=None, ), ) t_contract_transaction_distro = Table( 'contract_transaction_distro', Base.metadata, Column('contract_txn_id', DECIMAL(38, 0), default=None), Column('txn_id', DECIMAL(18, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('account_id', DECIMAL(12, 0), default=None), Column('payee_currency_id', DECIMAL(12, 0), default=None), Column('accounting_run_id', DECIMAL(18, 0), default=None), Column('contract_term_id', DECIMAL(12, 0), default=None), Column('contract_term_condition_id', DECIMAL(12, 0), default=None), ) t_contract_transaction_nr = Table( 'contract_transaction_nr', Base.metadata, Column('contract_txn_id', DECIMAL(38, 0), default=None), Column('txn_id', DECIMAL(18, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('account_id', DECIMAL(12, 0), default=None), Column('payee_currency_id', DECIMAL(12, 0), default=None), Column('accounting_run_id', DECIMAL(18, 0), default=None), Column('contract_term_id', DECIMAL(12, 0), default=None), Column('contract_term_condition_id', DECIMAL(12, 0), default=None), Column('schedule_id', DECIMAL(18, 0), default=None), Column('term_rate', DECIMAL(5, 4), default=None), ) t_contract_transaction_nr_staging = Table( 'contract_transaction_nr_staging', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_CONTRACT_TXN_NR_STAGING.NEXTVAL' ), default=None, ), Column('txn_id', DECIMAL(18, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('account_id', DECIMAL(12, 0), default=None), Column('payee_currency_id', DECIMAL(12, 0), default=None), Column('accounting_run_id', DECIMAL(18, 0), default=None), Column('contract_term_id', DECIMAL(12, 0), default=None), Column('contract_term_condition_id', DECIMAL(12, 0), default=None), Column('schedule_id', DECIMAL(18, 0), default=None), Column('term_rate', DECIMAL(5, 4), default=None), ) t_contract_transaction_publishing = Table( 'contract_transaction_publishing', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_CONTRACT_TXN_PUBLISHING.NEXTVAL' ), default=None, ), Column('txn_id', DECIMAL(18, 0), default=None), Column('period_id', DECIMAL(18, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('payee_currency', String(4), default=None), Column('base_fee', DECIMAL(24, 12), default=None), ) t_contract_transaction_staging = Table( 'contract_transaction_staging', Base.metadata, Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_CONTRACT_TXN_DISTRO_STAGING.NEXTVAL' ), default=None, ), Column('txn_id', DECIMAL(18, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('account_id', DECIMAL(12, 0), default=None), Column('payee_currency_id', DECIMAL(12, 0), default=None), Column('accounting_run_id', DECIMAL(18, 0), default=None), Column('contract_term_id', DECIMAL(12, 0), default=None), Column('contract_term_condition_id', DECIMAL(12, 0), default=None), ) class CurrencyMap(Base): __tablename__ = 'currency_map' __table_args__ = (PrimaryKeyConstraint('orchard_id', name='currency_id_pk'),) orchard_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(18, 0), primary_key=True ) iso_code: Mapped[Optional[str]] = mapped_column(String(50), default=None) iso_number: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(18, 0), default=None ) t_denorm_contract_term_condition_countries = Table( 'denorm_contract_term_condition_countries', Base.metadata, Column('contract_term_condition_id', DECIMAL(38, 0), default=None), Column('country_code', String(16777216), default=None), Column('country_id', DECIMAL(38, 0), default=None), ) t_denorm_contract_term_condition_products = Table( 'denorm_contract_term_condition_products', Base.metadata, Column('contract_term_condition_id', DECIMAL(38, 0), default=None), Column('term_type', String(21), default=None), Column('label_id', DECIMAL(38, 0), default=None), Column('upc', DECIMAL(20, 0), default=None), Column('isrc', String(16), default=None), ) t_denorm_contract_term_condition_stores = Table( 'denorm_contract_term_condition_stores', Base.metadata, Column('contract_term_condition_id', DECIMAL(38, 0), default=None), Column('store_id', VARIANT, default=None), ) t_denorm_contract_term_condition_transaction_types = Table( 'denorm_contract_term_condition_transaction_types', Base.metadata, Column('contract_term_condition_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), ) t_dim_transaction_subtype = Table( 'dim_transaction_subtype', Base.metadata, Column('transaction_subtype_id', DECIMAL(18, 0), nullable=False), Column('transaction_subtype_description', String(255), nullable=False), ) t_eligible_legacy_contract_migration_snapshot_before_migration = Table( 'eligible_legacy_contract_migration_snapshot_before_migration', Base.metadata, Column('name', String(256), default=None), Column('company', String(256), default=None), Column('vendor_id', DECIMAL(38, 0), default=None), Column('owner', String(25), default=None), Column('status', String(20), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('cont_start', NormalizedDate, default=None), Column('cont_end', NormalizedDate, default=None), Column('digital_split', DECIMAL(6, 4), default=None), Column('is_migrated', Boolean, default=None), ) t_expenses_by_artist_dbt = Table( 'expenses_by_artist_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(3), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('artist_name', String(2000), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('upc', String(255), default=None), Column('adjustment_amount_payee_currency', DECIMAL(32, 2), default=None), ) t_expenses_by_imprint_dbt = Table( 'expenses_by_imprint_dbt', Base.metadata, Column('imprint_id', DECIMAL(38, 0), default=None), Column('imprint', String(16777216), default=None), Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(3), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('artist_name', String(2000), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('upc', String(255), default=None), Column('adjustment_amount_payee_currency', DECIMAL(32, 2), default=None), ) t_expenses_by_subaccount_dbt = Table( 'expenses_by_subaccount_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('adjustment_payee_currency_code', String(12), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(38, 0), default=None), Column('artist_name', String(2000), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('subaccount_name', String(255), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('upc', String(255), default=None), Column('adjustment_amount_payee_currency', DECIMAL(38, 12), default=None), ) t_expenses_dbt = Table( 'expenses_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('activity_statement_period_id', DECIMAL(38, 0), default=None), Column('amount', DECIMAL(20, 2), default=None), Column('apply_to_statement_period_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('currency_code', String(3), default=None), Column('distribution_type', String(8), default=None), Column('internal_note', String(180), default=None), Column('note', String(256), default=None), Column('reference_adjustment_type_id', DECIMAL(38, 0), default=None), Column('worksheet_adjustment_detail_id', DECIMAL(38, 0), default=None), Column('worksheet_adjustment_id', DECIMAL(38, 0), default=None), Column('reference_adjustment_type_name', String(255), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('artist_name', String(2000), default=None), Column('adjustment_payee_currency_code', String(3), default=None), Column('adjustment_amount_payee_currency', DECIMAL(20, 2), default=None), Column('upc', String(255), default=None), Column('created_at', TIMESTAMP_NTZ, default=None), Column('created_by', String(180), default=None), Column('last_modified', TIMESTAMP_NTZ, default=None), Column('last_modified_by', String(180), default=None), ) class FactSalePublishing(Base): __tablename__ = 'fact_sale_publishing' __table_args__ = ( PrimaryKeyConstraint( 'statment_detail_id', name='SYS_CONSTRAINT_daa6690e-320f-4c86-a5f4-07a002f6c60c', ), ) statment_detail_id: Mapped[decimal.Decimal] = mapped_column( DECIMAL(38, 0), primary_key=True, server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_FACT_SALE_PUBLISHING_TXN.NEXTVAL' ), ) song_no: Mapped[decimal.Decimal] = mapped_column(DECIMAL(38, 0), nullable=False) period_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(12, 0), default=None ) song: Mapped[Optional[str]] = mapped_column(String(255), default=None) writer: Mapped[Optional[str]] = mapped_column(String(255), default=None) source_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) source2_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source2_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) source3_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source3_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) source4_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source4_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) income_type: Mapped[Optional[str]] = mapped_column(String(255), default=None) sh_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) rptg_pd: Mapped[Optional[str]] = mapped_column(String(255), default=None) sales_pd: Mapped[Optional[str]] = mapped_column(String(255), default=None) product_number: Mapped[Optional[str]] = mapped_column(String(255), default=None) artist_product_number: Mapped[Optional[str]] = mapped_column( String(255), default=None ) units: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) song_share_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) control_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) amount: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) royalty_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) royalty_amount: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) df: Mapped[Optional[str]] = mapped_column(String(16), default=None) source_product: Mapped[Optional[str]] = mapped_column(String(255), default=None) iswc: Mapped[Optional[str]] = mapped_column(String(255), default=None) external_song_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) artist: Mapped[Optional[str]] = mapped_column(String(255), default=None) source_song: Mapped[Optional[str]] = mapped_column(String(255), default=None) isrc: Mapped[Optional[str]] = mapped_column(String(255), default=None) transaction_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) account_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) has_multiple_owners: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(1, 0), default=None ) vendor_controlled_share: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) adjusted_share: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) adjusted_gross: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) fee_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) orchard_fee: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) net_revenue: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) t_ledger_summary_dbt = Table( 'ledger_summary_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('currency_code', String(12), default=None), Column('total_gross_revenue_amount', DECIMAL(32, 2), default=None), Column('total_net_revenue_amount', DECIMAL(32, 2), default=None), Column('distribution_fee', DECIMAL(32, 2), default=None), Column('mechanical_deduction_total', DECIMAL(32, 2), default=None), Column('mechanical_deduction_admin_fee_total', DECIMAL(32, 2), default=None), ) t_manufactured_upcs = Table( 'manufactured_upcs', Base.metadata, Column( 'upc', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('deleted_at', TIMESTAMP_NTZ, default=None), Column('deleted_by', String(255), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column( 'created_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('created_by', String(255), server_default=text("'fivetran'"), default=None), ) t_meta_track_dbt = Table( 'meta_track_dbt', Base.metadata, Column('track_unique_id', DECIMAL(32, 0), default=None), Column('track_name', String(2000), default=None), Column('product_name', String(1400), default=None), Column('format', String(100), default=None), Column('upc', DECIMAL(38, 0), default=None), Column('isrc', String(200), default=None), Column('release_date', TIMESTAMP_NTZ, default=None), Column('primary_artist', String(16777216), default=None), Column('featuring_artist', String(16777216), default=None), ) class OaMigratedAbacusContracts(Base): __tablename__ = 'oa_migrated_abacus_contracts' __table_args__ = ( PrimaryKeyConstraint( 'oa_migrated_abacus_contract_id', name='SYS_CONSTRAINT_90fe0d09-5535-4194-a4d5-887f760b99e6', ), ) oa_migrated_abacus_contract_id: Mapped[decimal.Decimal] = mapped_column( DECIMAL(18, 0), Identity(start=1, increment=1, cycle=False, order=False), primary_key=True, autoincrement=True, init=False, ) vendor_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(12, 0), default=None ) account_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) contract_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(12, 0), default=None ) summary: Mapped[Optional[str]] = mapped_column(String(16777216), default=None) t_payments_dbt = Table( 'payments_dbt', Base.metadata, Column('ledger_account_id', DECIMAL(38, 0), default=None), Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('currency_code', String(3), default=None), Column('currency_amount', DECIMAL(20, 2), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('event_name', String(32), default=None), Column('action_status', String(8), default=None), Column('withholding_tax_ledger_account_id', DECIMAL(38, 0), default=None), Column('withholding_tax_currency_code', String(3), default=None), Column('withholding_tax_currency_amount', DECIMAL(20, 2), default=None), Column('withholding_tax_created_at', TIMESTAMP_NTZ, default=None), Column('created_at', TIMESTAMP_NTZ, default=None), ) t_revenue_by_activity_month_dbt = Table( 'revenue_by_activity_month_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('activity_month_name', String(180), default=None), Column('account_payee_currency', String(50), default=None), Column('net_share_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_artist_dbt = Table( 'revenue_by_artist_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('artist_name', String(2000), default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(38, 12), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(36, 12), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_country_dbt = Table( 'revenue_by_country_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('country_code', String(2), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_imprint_dbt = Table( 'revenue_by_imprint_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('imprintid', DECIMAL(38, 0), default=None), Column('imprint', String(16777216), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('account_payee_currency', String(50), default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(38, 12), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(36, 12), default=None), Column('net_share_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_product_distro_dbt = Table( 'revenue_by_product_distro_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('product_name', String(1024), default=None), Column('release_date', NormalizedDate, default=None), Column('display_upc', String(20), default=None), Column('product_code', String(256), default=None), Column('project_id', DECIMAL(20, 0), default=None), Column('project_code', String(256), default=None), Column('project_name', String(512), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('artist_name', String(2000), default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(38, 12), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(36, 12), default=None), Column('net_share_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_project_dbt = Table( 'revenue_by_project_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('project_code', String(16777216), default=None), Column('project_name', String(16777216), default=None), Column('project_artist', String(512), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('account_payee_currency', String(50), default=None), Column('product_count', DECIMAL(18, 0), default=None), Column('net_share_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_recording_distro_dbt = Table( 'revenue_by_recording_distro_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('recording_id', DECIMAL(32, 0), default=None), Column('recording_title', String(2000), default=None), Column('artist', String(2000), default=None), Column('isrc', String(200), default=None), Column('version', String(2550), default=None), Column('net_share_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_recording_nr_dbt = Table( 'revenue_by_recording_nr_dbt', Base.metadata, Column('account_id', DECIMAL(12, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('recording_id', String(16777216), default=None), Column('recording_title', String(16777216), default=None), Column('artist', String(16777216), default=None), Column('isrc', String(16777216), default=None), Column('version', String(16777216), default=None), Column('net_share_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_statement_period_dbt = Table( 'revenue_by_statement_period_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('statement_period_name', String(180), default=None), Column('statement_period_status', String(7), default=None), Column('primary_key', String(32), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_store_dbt = Table( 'revenue_by_store_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('store_name', String(50), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_subaccount_dbt = Table( 'revenue_by_subaccount_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('subaccount_name', String(255), default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(38, 12), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(36, 12), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_track_dbt = Table( 'revenue_by_track_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('primary_artist_id', DECIMAL(32, 0), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('track_name', String(2000), default=None), Column('isrc', String(200), default=None), Column('artist_name', String(2000), default=None), Column('project_name', String(512), default=None), Column('product_name', String(1024), default=None), Column('release_date', NormalizedDate, default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(38, 12), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(36, 12), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_by_transaction_type_dbt = Table( 'revenue_by_transaction_type_dbt', Base.metadata, Column('account_id', DECIMAL(32, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('transaction_type_desc', String(180), default=None), Column('transaction_type_code', String(4), default=None), Column('transaction_type_group_id', DECIMAL(38, 0), default=None), Column('transaction_type_group_name', String(180), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('quantity', DECIMAL(38, 0), default=None), Column('net_revenue_payee_currency', DECIMAL(36, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(36, 12), default=None), ) t_revenue_distro_dbt = Table( 'revenue_distro_dbt', Base.metadata, Column('abacus_sale_type', String(20), default=None), Column('account_id', DECIMAL(32, 0), default=None), Column('activity_period_id', DECIMAL(32, 0), default=None), Column('artist_id', DECIMAL(32, 0), default=None), Column('country_id', DECIMAL(16, 0), default=None), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(38, 12), default=None, ), Column('gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column('isrc', String(16777216), default=None), Column('label_id', DECIMAL(32, 0), default=None), Column('mechanical_deduction_amount_payee_currency', DECIMAL(26, 12), default=None), Column('net_share_payee_currency', DECIMAL(24, 12), default=None), Column('original_statement_period_id', DECIMAL(38, 0), default=None), Column('phys_ppd_usd', DECIMAL(18, 6), default=None), Column('publisher_admin_fee_payee_currency', DECIMAL(24, 12), default=None), Column('project_id', DECIMAL(38, 0), default=None), Column('royalty_rate', DECIMAL(31, 12), default=None), Column('sale_currency_code', String(30), default=None), Column('start_date', NormalizedDate, default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('subdistributor', String(16777216), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('track_unique_id', DECIMAL(32, 0), default=None), Column('transaction_date', NormalizedDate, default=None), Column('transaction_subtype', String(255), default=None), Column('transaction_type', String(4), default=None), Column('transaction_type_id', DECIMAL(38, 0), default=None), Column('txn_id', DECIMAL(38, 0), default=None), Column('unit_price_sale_currency', DECIMAL(38, 12), default=None), Column('upc', DECIMAL(38, 0), default=None), Column('imprint_id', DECIMAL(38, 0), default=None), Column('country_code', String(2), default=None), Column('product_id', DECIMAL(38, 0), default=None), Column('product_code', String(256), default=None), Column('video_id', String(16777216), default=None), Column('withholding_tax_payee_currency', DECIMAL(24, 12), default=None), Column('quantity', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('subaccount_id', DECIMAL(38, 0), default=None), ) t_revenue_nr_dbt = Table( 'revenue_nr_dbt', Base.metadata, Column('statement_period_id', DECIMAL(38, 0), default=None), Column('account_id', DECIMAL(12, 0), default=None), Column('contract_id', DECIMAL(12, 0), default=None), Column('contract_term_condition_id', DECIMAL(12, 0), default=None), Column('schedule_id', DECIMAL(18, 0), default=None), Column('account_payee_currency', String(50), default=None), Column('sale_currency_code', String(30), default=None), Column('accounting_period_id', DECIMAL(38, 0), default=None), Column('isrc', String(255), default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column('transaction_type', String(2), default=None), Column('transaction_subtype_description', String(255), default=None), Column('quantity', DECIMAL(18, 0), default=None), Column('start_date', NormalizedDate, default=None), Column('end_date', NormalizedDate, default=None), Column('contributor_id', String(255), default=None), Column('contributor_name', String(16777216), default=None), Column('sound_recording_id', String(255), default=None), Column('sound_recording_name', String(255), default=None), Column('txn_id', DECIMAL(38, 0), default=None), Column('accounting_run_id', DECIMAL(18, 0), default=None), Column('royalty_rate', DECIMAL(5, 4), default=None), Column('unit_price_sale_currency', DECIMAL(24, 12), default=None), Column('gross_revenue_sale_currency', DECIMAL(24, 12), default=None), Column('withholding_tax_sale_currency', DECIMAL(24, 12), default=None), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), default=None, ), Column('net_share_sale_currency', DECIMAL(24, 12), default=None), Column('unit_price_payee_currency', DECIMAL(24, 12), default=None), Column('gross_revenue_payee_currency', DECIMAL(24, 12), default=None), Column('withholding_tax_payee_currency', DECIMAL(24, 12), default=None), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), default=None, ), Column('net_share_payee_currency', DECIMAL(24, 12), default=None), Column('abacus_sale_type', String(20), default=None), Column('original_statement_period_id', DECIMAL(38, 0), default=None), Column('contract_transaction_nr_contract_txn_id', DECIMAL(38, 0), default=None), Column('transaction_nr_contract_txn_id', DECIMAL(38, 0), default=None), Column('txn_correction_nr_id', DECIMAL(38, 0), default=None), ) t_sax_agreement_denorm = Table( 'sax_agreement_denorm', Base.metadata, Column('interested_party_id', String(80), default=None), Column('outgoing_agreement_type', String(120), default=None), Column('agreement_id', String(80), default=None), Column('salesforce_opportunity_id', String(80), default=None), Column('agr_currency', String(20), default=None), Column('description_of_rights', String(400), default=None), Column('artist_name', String(4000), default=None), Column('client', String(400), default=None), Column('assignor_id', String(80), default=None), Column('agreement_acquirer', String(400), default=None), Column('agreement_type', String(40), default=None), Column('accounting_period', String(92), default=None), Column('abacus_start_date', TIMESTAMP_NTZ, default=None), Column('agr_signed_date', NormalizedDate, default=None), Column('agr_start_date', NormalizedDate, default=None), Column('agr_created_date', TIMESTAMP_NTZ, default=None), Column('is_terminated', String(4), default=None), Column('terminated_date', NormalizedDate, default=None), Column('takedown_date', NormalizedDate, default=None), Column('review_date', NormalizedDate, default=None), Column('agr_notes', String(4000), default=None), Column('novation_flag', String(4000), default=None), Column('rights_summary', String(4000), default=None), Column('territory_summary', String(4000), default=None), Column('mech_admin_right_type', String(16777216), default=None), Column('mech_admin_territory', String(16777216), default=None), Column('right_description', String(800), default=None), Column('territory_description', String(800), default=None), Column('sax_territories', String(16777216), default=None), Column('right_dates_description', String(800), default=None), Column('physical_dist_top_up_fee', DECIMAL(5, 2), default=None), Column('reserve_frequency', String(36), default=None), Column('reserve_percentage', DECIMAL(5, 2), default=None), Column('release_periods', DECIMAL(2, 0), default=None), Column('right_status', String(32), default=None), Column('awal_commission', DECIMAL(5, 2), default=None), Column('abacus_contract_name', String(5372), default=None), Column('abacus_rate', DECIMAL(6, 2), default=None), Column('calculated_on_source_amnt', String(4), default=None), Column('awal_shared_cost_percentage', DECIMAL(5, 2), default=None), Column('manual_adj_type', String(16777216), default=None), Column('num_schedules', DECIMAL(18, 0), default=None), Column('recording_schedule_id', String(80), default=None), Column('recording_schedule_description', String(2000), default=None), Column('bank_account_id', String(80), default=None), Column('rights_id', String(80), default=None), Column('right_dates_id', String(80), default=None), Column('currency_code', String(20), default=None), Column('label_service_agreement_type', String(40), default=None), Column('awal_terms_and_conditions_id', String(80), default=None), Column('sax_right_type_ids', String(16777216), default=None), Column('abacus_transaction_type_ids', String(16777216), default=None), Column('sax_upcs', String(16777216), default=None), Column('sax_isrcs', String(16777216), default=None), Column('sax_terr_id', String(16777216), default=None), Column('abacus_iso_countries', String(16777216), default=None), Column('abacus_country_names', String(16777216), default=None), ) t_sax_agreement_denorm_base = Table( 'sax_agreement_denorm_base', Base.metadata, Column('interested_party_id', String(80), default=None), Column('outgoing_agreement_type', String(120), default=None), Column('agreement_id', String(80), default=None), Column('salesforce_opportunity_id', String(80), default=None), Column('agr_currency', String(20), default=None), Column('description_of_rights', String(400), default=None), Column('artist_name', String(4000), default=None), Column('client', String(400), default=None), Column('assignor_id', String(80), default=None), Column('agreement_acquirer', String(400), default=None), Column('agreement_type', String(40), default=None), Column('accounting_period', String(92), default=None), Column('abacus_start_date', TIMESTAMP_NTZ, default=None), Column('agr_signed_date', NormalizedDate, default=None), Column('agr_start_date', NormalizedDate, default=None), Column('agr_created_date', TIMESTAMP_NTZ, default=None), Column('is_terminated', String(4), default=None), Column('terminated_date', NormalizedDate, default=None), Column('takedown_date', NormalizedDate, default=None), Column('review_date', NormalizedDate, default=None), Column('agr_notes', String(4000), default=None), Column('novation_flag', String(4000), default=None), Column('rights_summary', String(4000), default=None), Column('territory_summary', String(4000), default=None), Column('mech_admin_right_type', String(16777216), default=None), Column('mech_admin_territory', String(16777216), default=None), Column('right_description', String(800), default=None), Column('territory_description', String(800), default=None), Column('sax_territories', String(16777216), default=None), Column('right_dates_description', String(800), default=None), Column('physical_dist_top_up_fee', DECIMAL(5, 2), default=None), Column('reserve_frequency', String(36), default=None), Column('reserve_percentage', DECIMAL(5, 2), default=None), Column('release_periods', DECIMAL(2, 0), default=None), Column('right_status', String(32), default=None), Column('awal_commission', DECIMAL(5, 2), default=None), Column('abacus_contract_name', String(5372), default=None), Column('abacus_rate', DECIMAL(6, 2), default=None), Column('calculated_on_source_amnt', String(4), default=None), Column('awal_shared_cost_percentage', DECIMAL(5, 2), default=None), Column('manual_adj_type', String(16777216), default=None), Column('num_schedules', DECIMAL(18, 0), default=None), Column('recording_schedule_id', String(80), default=None), Column('recording_schedule_description', String(2000), default=None), Column('bank_account_id', String(80), default=None), Column('rights_id', String(80), default=None), Column('right_dates_id', String(80), default=None), Column('currency_code', String(20), default=None), Column('label_service_agreement_type', String(40), default=None), Column('awal_terms_and_conditions_id', String(80), default=None), Column('sax_right_type_ids', String(16777216), default=None), Column('abacus_transaction_type_ids', String(16777216), default=None), Column('sax_terr_id', String(16777216), default=None), Column('abacus_iso_countries', String(16777216), default=None), Column('abacus_country_names', String(16777216), default=None), ) t_sax_right_type_to_orchard_transaction_type = Table( 'sax_right_type_to_orchard_transaction_type', Base.metadata, Column('sax_right_type_id', String(50), default=None), Column('orchard_transaction_type_id', DECIMAL(38, 0), default=None), ) t_sax_territory_to_orchard_iso = Table( 'sax_territory_to_orchard_iso', Base.metadata, Column('id', String(16777216), default=None), Column('iso', String(16777216), default=None), ) t_sequestered_sales_distro = Table( 'sequestered_sales_distro', Base.metadata, Column( 'stmt_db_sales_distro_txn_id', DECIMAL(38, 0), server_default=text('NOT(SYSTEM$NULL_TO_BOOLEAN(null))'), default=None, ), Column('reason', String(16777216), default=None), Column('jira_ticket', String(255), default=None), Column('created_at', TIMESTAMP_NTZ, default=None), Column('created_by', String(255), default=None), ) t_snapshot_contract_mechanical_deduction = Table( 'snapshot_contract_mechanical_deduction', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'contract_mechanical_deduction_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'territory', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='3 character territory code', default=None, ), Column( 'mechanical_type', String(32), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='List of mechanical deduction types. Any of "digital" or "physical"', default=None, ), Column( 'admin_type', String(32), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The entity responsible for paying the mechanical deduction can be one of "business", "customer", or "both"', default=None, ), Column( 'admin_fee', DECIMAL(5, 2), comment='The amount, if any, The Orchard deducts for distribution', default=None, ), ) t_snapshot_contract_nr = Table( 'snapshot_contract_nr', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the parent account of the contract (RDS royalty_accounting.account.account_id).', default=None, ), Column( 'account_currency_code', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The account payment currency (RDS royalty_accounting.account_payment_term.currency_code).', default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the contract (RDS royalty_accounting.contract.contract_id).', default=None, ), Column( 'contract_term_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the terms on the contract (RDS royalty_accounting.contract_term.contract_term_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'contract_term_start', NormalizedDate, nullable=False, server_default=text("CAST('1970-02-01' AS DATE)"), comment='The contract term_start date (RDS royalty_accounting.contract.term_start).', ), Column( 'contract_term_end', NormalizedDate, nullable=False, server_default=text("CAST('2100-01-01' AS DATE)"), comment='The contract term_end date (RDS royalty_accounting.contract.term_end).', ), Column( 'term_type', String(50), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The type of contract term (i.e. "contributor_schedule", "contribution_schedule", etc) (RDS royalty_accounting.contract_term.term_type).', default=None, ), Column( 'term_rate', DECIMAL(5, 2), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The rate of the contract term to be applied to sales (RDS royalty_accounting.contract_term_condition.term_rate).', default=None, ), Column( 'conditions', VARIANT, server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The contract term conditions saved as JSON (RDS royalty_accounting.contract_term_condition.conditions).', default=None, ), Column( 'priority', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Priority of the contract term condition (RDS royalty_accounting.contract_term_condition.priority).', default=None, ), Column( 'contract_name', String(180), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The name of the contract (RDS royalty_accounting.contract.contract_name).', default=None, ), Column( 'contract_term_name', String(180), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The name of the contract_term (RDS royalty_accounting.contract_term.contract_term_name).', default=None, ), Column( 'contract_term_condition_name', String(180), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The name of the contract_term_condition (RDS royalty_accounting.contract_term_condition.contract_term_condition_name).', default=None, ), ) t_snapshot_contract_publishing = Table( 'snapshot_contract_publishing', Base.metadata, Column( 'contract_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_SNAPSHOT_CONTRACT_PUBLISHING.NEXTVAL' ), default=None, ), Column('period_id', DECIMAL(12, 0), default=None), Column('account_id', DECIMAL(38, 0), default=None), Column('account_name', String(255), default=None), Column('base_fee', DECIMAL(24, 12), default=None), Column('orchard_owned', String(255), default=None), Column('payout_currency', String(255), default=None), Column('comments', String(255), default=None), ) t_snapshot_contract_term_condition_country = Table( 'snapshot_contract_term_condition_country', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'country_code', String(64), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ISO-3 country code on the contract_term_condition (RDS royalty_accounting.contract_term_condition.conditions.countries)', default=None, ), Column( 'country_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The orchard country_id for specified country_code (RDS art_relations.country.id).', default=None, ), ) t_snapshot_contract_term_condition_store = Table( 'snapshot_contract_term_condition_store', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'store_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the store on the contract_term_conditions (RDS royalty_accounting.contract_term_condition.conditions.stores).', default=None, ), ) t_snapshot_contract_term_condition_transaction_type = Table( 'snapshot_contract_term_condition_transaction_type', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'transaction_type_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the transaction_type on the contract_term_conditions (RDS royalty_accounting.contract_term_condition.conditions.transaction_types).', default=None, ), ) t_snapshot_contract_term_schedule_nr = Table( 'snapshot_contract_term_schedule_nr', Base.metadata, Column( 'accounting_run_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of an abacus accounting_run for which contract sales are being calculated (RDS royalty_accounting.accounting_run.accounting_run_id).', default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the contract (RDS royalty_accounting.contract.contract_id).', default=None, ), Column( 'contract_term_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the terms on the contract (RDS royalty_accounting.contract_term.contract_term_id).', default=None, ), Column( 'contract_term_condition_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the term exceptions/conditions (RDS royalty_accounting.contract_term_condition.contract_term_condition_id).', default=None, ), Column( 'contributor_id', String(36), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Contributor to which contract terms apply (RDS royalty_accounting.schedule_attachment.target_id).', default=None, ), Column( 'contribution_id', String(36), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Contribution to which contract terms apply (RDS royalty_accounting.schedule_attachment.target_id).', default=None, ), Column( 'schedule_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ID of the schedule on the contract_term to which contributor/contributions belong (RDS royalty_accounting.contract_term_schedule.schedule_id).', default=None, ), Column( 'schedule_name', String(180), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The name of the schedule (RDS royalty_accounting.schedule.schedule_name).', default=None, ), Column( 'term_type', String(50), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The type of contract term (i.e. "contributor_schedule", "contribution_schedule", etc) (RDS royalty_accounting.contract_term.term_type).', default=None, ), ) t_snapshot_mechanical_transaction = Table( 'snapshot_mechanical_transaction', Base.metadata, Column( 'mechanical_transaction_id', DECIMAL(18, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_MECHANICAL_TRANSACTION.NEXTVAL' ), comment='Unique ID for table; used instead of legacy STATEMENT_DETAIL_ID for HFA export', default=None, ), Column( 'statement_period_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='ID of the statement_period (RDS royalty_accounting.statement_period).', default=None, ), Column( 'accounting_period_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='ID of the accounting_period (RDS royalty_accounting.accounting_period).', default=None, ), Column( 'txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='ID of the parent sale transaction (FK to STMT_DB_SALES_DISTRO.STMT_DB_SALES_DISTRO_TXN_ID).', default=None, ), Column( 'transaction_type_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Transaction type of the sale transaction.', default=None, ), Column( 'mechanical_type', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='One of "digital", "physical", or "ringtone" based on the TRANSACTION_TYPE_ID.', default=None, ), Column( 'country_code', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Country of the sale transaction.', default=None, ), Column( 'currency_code', String(3), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Currency of the sale transaction.', default=None, ), Column( 'royalty_amount', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sum of child records in SNAPSHOT_MECHANICAL_TRANSACTION_DETAIL where IS_LICENSED is true.', default=None, ), ) t_snapshot_mechanical_transaction_detail = Table( 'snapshot_mechanical_transaction_detail', Base.metadata, Column( 'mechanical_transaction_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a mechanical/transaction pairing (SNAPSHOT_MECHANICAL_TRANSACTION.MECHANICAL_TRANSACTION_ID)', default=None, ), Column( 'upc', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The UPC of the sale transaction (STMT_DB_SALES_DISTRO.UPC)', default=None, ), Column( 'isrc', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The ISRC of the sale transaction, if present (STMT_DB_SALES_DISTRO.ISRC)', default=None, ), Column( 'track_unique_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The unique track id (art_relations.track.id)', default=None, ), Column( 'track_seconds', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Length of the track in seconds (art_relations.track.length_minute * 60)', default=None, ), Column( 'is_licensed', Boolean, server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Whether the track is licensed (art_relations.track.third_party_publisher)', default=None, ), Column( 'quantity', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Quantity of the sale transaction (STMT_DB_SALES_DISTRO.QUANTITY)', default=None, ), Column( 'royalty_rate', DECIMAL(10, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Comes from royalty_accounting.reference_mechanical_deduction using the COUNTRY_CODE and TRACK_SECONDS. This value is simply the base_rate unless the track is longer than 5 minutes. If TRACK_SECONDS > 300 determine this value by rounding track length up to nearest minute and multiplying by the minute_rate: CEIL(TRACK_SECONDS/60) * minute_rate', default=None, ), Column( 'royalty_amount', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The mechanical royalty amount calculated by multiplying the ROYALTY_RATE and QUANTITY', default=None, ), ) t_snapshot_transaction_publishing_exclude = Table( 'snapshot_transaction_publishing_exclude', Base.metadata, Column('period_id', DECIMAL(12, 0), default=None), Column('statement_detail_id', DECIMAL(38, 0), default=None), Column('transaction_id', DECIMAL(38, 0), default=None), Column('base_fee', DECIMAL(24, 12), default=None), ) class StmtDbPublishing(Base): __tablename__ = 'stmt_db_publishing' __table_args__ = ( PrimaryKeyConstraint( 'statement_detail_id', name='SYS_CONSTRAINT_845031e4-f92a-4474-acf0-0e81b532e6a7', ), ) statement_detail_id: Mapped[decimal.Decimal] = mapped_column( DECIMAL(38, 0), primary_key=True, server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_STMT_DB_PUBLISHING_TXN_ID.NEXTVAL' ), ) song_no: Mapped[decimal.Decimal] = mapped_column(DECIMAL(38, 0), nullable=False) period_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(12, 0), default=None ) song: Mapped[Optional[str]] = mapped_column(String(255), default=None) writer: Mapped[Optional[str]] = mapped_column(String(255), default=None) source_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) source2_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source2_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) source3_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source3_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) source4_name: Mapped[Optional[str]] = mapped_column(String(255), default=None) source4_country: Mapped[Optional[str]] = mapped_column(String(255), default=None) income_type: Mapped[Optional[str]] = mapped_column(String(255), default=None) sh_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) rptg_pd: Mapped[Optional[str]] = mapped_column(String(255), default=None) sales_pd: Mapped[Optional[str]] = mapped_column(String(255), default=None) product_number: Mapped[Optional[str]] = mapped_column(String(255), default=None) artist_product_number: Mapped[Optional[str]] = mapped_column( String(255), default=None ) units: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) song_share_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) control_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) amount: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) royalty_percent: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) royalty_amount: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(24, 12), default=None ) df: Mapped[Optional[str]] = mapped_column(String(16), default=None) source_product: Mapped[Optional[str]] = mapped_column(String(255), default=None) iswc: Mapped[Optional[str]] = mapped_column(String(255), default=None) external_song_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) artist: Mapped[Optional[str]] = mapped_column(String(255), default=None) source_song: Mapped[Optional[str]] = mapped_column(String(255), default=None) isrc: Mapped[Optional[str]] = mapped_column(String(255), default=None) transaction_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) account_id: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(38, 0), default=None ) has_multiple_owners: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(1, 0), default=None ) vendor_controlled_share: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) adjusted_share: Mapped[Optional[decimal.Decimal]] = mapped_column( DECIMAL(8, 4), default=None ) t_stmt_db_sales_distro = Table( 'stmt_db_sales_distro', Base.metadata, Column( 'stmt_db_sales_distro_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'sales_file_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('batch_id', String(255), default=None), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('start_date', NormalizedDate, default=None), Column('transaction_date', NormalizedDate, default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('subdistributor', String(255), default=None), Column('sale_currency_code', String(30), default=None), Column('sale_currency_code_id', DECIMAL(18, 0), default=None), Column('activity_rate', DECIMAL(18, 6), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column('configuration', String(255), default=None), Column('transaction_type', String(2), default=None), Column('transaction_type_id', DECIMAL(18, 0), default=None), Column('transaction_subtype_id', DECIMAL(18, 0), default=None), Column('label_id', DECIMAL(32, 0), default=None), Column('upc', DECIMAL(38, 0), default=None), Column('cd', DECIMAL(32, 0), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('isrc', String(255), default=None), Column('track_name', String(255), default=None), Column('video_id', String(255), default=None), Column('quantity', DECIMAL(18, 0), default=None), Column('unit_price_usd', DECIMAL(24, 12), default=None), Column('total_usd', DECIMAL(24, 12), default=None), Column('withholding_tax_usd', DECIMAL(18, 6), default=None), Column('retail_price_usd', DECIMAL(18, 6), default=None), Column('original_price_usd', DECIMAL(18, 6), default=None), Column('discount_usd', DECIMAL(18, 6), default=None), Column('phys_ppd_usd', DECIMAL(18, 6), default=None), Column('is_excluded_from_sap', Boolean, default=None), Column('actual_statement_number', String(128), default=None), ) t_stmt_db_sales_distro_old = Table( 'stmt_db_sales_distro_old', Base.metadata, Column( 'stmt_db_sales_distro_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'sales_file_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('batch_id', String(255), default=None), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('start_date', NormalizedDate, default=None), Column('transaction_date', NormalizedDate, default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('subdistributor', String(255), default=None), Column('sale_currency_code', String(30), default=None), Column('sale_currency_code_id', DECIMAL(18, 0), default=None), Column('activity_rate', DECIMAL(18, 6), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column('configuration', String(255), default=None), Column('transaction_type', String(2), default=None), Column('transaction_type_id', DECIMAL(18, 0), default=None), Column('transaction_subtype_id', DECIMAL(18, 0), default=None), Column('label_id', DECIMAL(32, 0), default=None), Column('upc', DECIMAL(38, 0), default=None), Column('cd', DECIMAL(32, 0), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('isrc', String(255), default=None), Column('track_name', String(255), default=None), Column('video_id', String(255), default=None), Column('quantity', DECIMAL(18, 0), default=None), Column('unit_price_usd', DECIMAL(18, 6), default=None), Column('total_usd', DECIMAL(18, 6), default=None), Column('withholding_tax_usd', DECIMAL(18, 6), default=None), Column('retail_price_usd', DECIMAL(18, 6), default=None), Column('original_price_usd', DECIMAL(18, 6), default=None), Column('discount_usd', DECIMAL(18, 6), default=None), Column('phys_ppd_usd', DECIMAL(18, 6), default=None), Column('is_excluded_from_sap', Boolean, default=None), Column('actual_statement_number', String(128), default=None), ) t_stmt_db_sales_distro_staging = Table( 'stmt_db_sales_distro_staging', Base.metadata, Column( 'stmt_db_sales_distro_txn_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_STMT_DB_SALES_DISTRO_STAGING.NEXTVAL' ), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'batch_id', String(255), comment='Internal-only, containing additional identifier for the statement file', default=None, ), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'start_date', NormalizedDate, comment='Shows the starting month for the revenue included', default=None, ), Column( 'transaction_date', NormalizedDate, comment='Fka DATE. Shows the activity date for the revenue included', default=None, ), Column( 'store_id', DECIMAL(32, 0), comment='Fka CUSTOMER_MASTER_MASTER_ID', default=None, ), Column( 'subdistributor', String(255), comment='Original retailer source of the transaction', default=None, ), Column( 'sale_currency_code', String(30), comment='Fka ORIGINAL_CURRENCY_ISO', default=None, ), Column( 'sale_currency_code_id', DECIMAL(18, 0), comment='Derived from SALE_CURRENCY_CODE', default=None, ), Column('activity_rate', DECIMAL(18, 6), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column( 'configuration', String(255), comment='Internal-only, containing tier codes and descriptions as provided by the DSPs', default=None, ), Column('transaction_type', String(2), comment='Fka TRANS_TYPE', default=None), Column( 'transaction_type_id', DECIMAL(18, 0), comment='Derived from TRANSACTION_TYPE', default=None, ), Column( 'transaction_subtype_id', DECIMAL(18, 0), comment='Fka TRANS_SUBTYPE', default=None, ), Column('label_id', DECIMAL(32, 0), comment='Fka VENDOR_ID', default=None), Column('upc', DECIMAL(38, 0), default=None), Column('cd', DECIMAL(32, 0), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('isrc', String(255), default=None), Column('track_name', String(255), default=None), Column( 'video_id', String(255), comment='Client-facing YouTube video ID (only populated for YT revenue)', default=None, ), Column('quantity', DECIMAL(18, 0), comment='Fka QTY', default=None), Column('unit_price_usd', DECIMAL(24, 12), comment='Fka UNIT_PRICE', default=None), Column('total_usd', DECIMAL(24, 12), comment='Fka TOTAL', default=None), Column( 'withholding_tax_usd', DECIMAL(18, 6), comment='Fka WHT. Negative value represents a deduction; sometimes there will be a positive value representing a reversal/adjustment. DSPs / Societies withhold tax from The Orchard to ultimately send to local tax authorities.', default=None, ), Column( 'retail_price_usd', DECIMAL(18, 6), comment='Fka RETAIL_PRICE', default=None ), Column( 'original_price_usd', DECIMAL(18, 6), comment='Fka ORIGINAL_PRICE', default=None ), Column('discount_usd', DECIMAL(18, 6), comment='Fka DISCOUNT', default=None), Column( 'phys_ppd_usd', DECIMAL(18, 6), comment='Fka PHYS_PPD. [Physical] Published Price to Dealer (PPD)', default=None, ), Column('is_excluded_from_sap', Boolean, comment='Fka SAP_EXCLUDE', default=None), Column( 'actual_statement_number', String(128), comment='Fka ACTUAL_STATEMENT_NO. Used to determine the T_CODE sent to the settlement feed.', default=None, ), ) t_stmt_db_sales_distro_staging_old = Table( 'stmt_db_sales_distro_staging_old', Base.metadata, Column( 'stmt_db_sales_distro_txn_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_STMT_DB_SALES_DISTRO_STAGING.NEXTVAL' ), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'batch_id', String(255), comment='Internal-only, containing additional identifier for the statement file', default=None, ), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'start_date', NormalizedDate, comment='Shows the starting month for the revenue included', default=None, ), Column( 'transaction_date', NormalizedDate, comment='Fka DATE. Shows the activity date for the revenue included', default=None, ), Column( 'store_id', DECIMAL(32, 0), comment='Fka CUSTOMER_MASTER_MASTER_ID', default=None, ), Column( 'subdistributor', String(255), comment='Original retailer source of the transaction', default=None, ), Column( 'sale_currency_code', String(30), comment='Fka ORIGINAL_CURRENCY_ISO', default=None, ), Column( 'sale_currency_code_id', DECIMAL(18, 0), comment='Derived from SALE_CURRENCY_CODE', default=None, ), Column('activity_rate', DECIMAL(18, 6), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column( 'configuration', String(255), comment='Internal-only, containing tier codes and descriptions as provided by the DSPs', default=None, ), Column('transaction_type', String(2), comment='Fka TRANS_TYPE', default=None), Column( 'transaction_type_id', DECIMAL(18, 0), comment='Derived from TRANSACTION_TYPE', default=None, ), Column( 'transaction_subtype_id', DECIMAL(18, 0), comment='Fka TRANS_SUBTYPE', default=None, ), Column('label_id', DECIMAL(32, 0), comment='Fka VENDOR_ID', default=None), Column('upc', DECIMAL(38, 0), default=None), Column('cd', DECIMAL(32, 0), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('isrc', String(255), default=None), Column('track_name', String(255), default=None), Column( 'video_id', String(255), comment='Client-facing YouTube video ID (only populated for YT revenue)', default=None, ), Column('quantity', DECIMAL(18, 0), comment='Fka QTY', default=None), Column('unit_price_usd', DECIMAL(18, 6), comment='Fka UNIT_PRICE', default=None), Column('total_usd', DECIMAL(18, 6), comment='Fka TOTAL', default=None), Column( 'withholding_tax_usd', DECIMAL(18, 6), comment='Fka WHT. Negative value represents a deduction; sometimes there will be a positive value representing a reversal/adjustment. DSPs / Societies withhold tax from The Orchard to ultimately send to local tax authorities.', default=None, ), Column( 'retail_price_usd', DECIMAL(18, 6), comment='Fka RETAIL_PRICE', default=None ), Column( 'original_price_usd', DECIMAL(18, 6), comment='Fka ORIGINAL_PRICE', default=None ), Column('discount_usd', DECIMAL(18, 6), comment='Fka DISCOUNT', default=None), Column( 'phys_ppd_usd', DECIMAL(18, 6), comment='Fka PHYS_PPD. [Physical] Published Price to Dealer (PPD)', default=None, ), Column('is_excluded_from_sap', Boolean, comment='Fka SAP_EXCLUDE', default=None), Column( 'actual_statement_number', String(128), comment='Fka ACTUAL_STATEMENT_NO. Used to determine the T_CODE sent to the settlement feed.', default=None, ), ) t_stmt_db_sales_distro_temp_old = Table( 'stmt_db_sales_distro_temp_old', Base.metadata, Column( 'stmt_db_sales_distro_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'sales_file_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('batch_id', String(255), default=None), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('start_date', NormalizedDate, default=None), Column('transaction_date', NormalizedDate, default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('subdistributor', String(255), default=None), Column('sale_currency_code', String(30), default=None), Column('sale_currency_code_id', DECIMAL(18, 0), default=None), Column('activity_rate', DECIMAL(18, 6), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column('configuration', String(255), default=None), Column('transaction_type', String(2), default=None), Column('transaction_type_id', DECIMAL(18, 0), default=None), Column('transaction_subtype_id', DECIMAL(18, 0), default=None), Column('label_id', DECIMAL(32, 0), default=None), Column('upc', DECIMAL(38, 0), default=None), Column('cd', DECIMAL(32, 0), default=None), Column('track_id', DECIMAL(32, 0), default=None), Column('isrc', String(255), default=None), Column('track_name', String(255), default=None), Column('video_id', String(255), default=None), Column('quantity', DECIMAL(18, 0), default=None), Column('unit_price_usd', DECIMAL(18, 6), default=None), Column('total_usd', DECIMAL(18, 6), default=None), Column('withholding_tax_usd', DECIMAL(18, 6), default=None), Column('retail_price_usd', DECIMAL(18, 6), default=None), Column('original_price_usd', DECIMAL(18, 6), default=None), Column('discount_usd', DECIMAL(18, 6), default=None), Column('phys_ppd_usd', DECIMAL(18, 6), default=None), Column('is_excluded_from_sap', Boolean, default=None), Column('actual_statement_number', String(128), default=None), ) t_stmt_db_sales_nr = Table( 'stmt_db_sales_nr', Base.metadata, Column( 'stmt_db_sales_nr_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'sales_file_id', DECIMAL(18, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('batch_id', String(255), default=None), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column('start_date', NormalizedDate, default=None), Column('end_date', NormalizedDate, default=None), Column('store_id', DECIMAL(32, 0), default=None), Column('subdistributor', String(255), default=None), Column('sale_currency_code', String(30), default=None), Column('sale_currency_code_id', DECIMAL(18, 0), default=None), Column('activity_rate', DECIMAL(18, 6), default=None), Column('country_id', DECIMAL(12, 0), default=None), Column('configuration', String(255), default=None), Column('transaction_type', String(2), default=None), Column('transaction_type_id', DECIMAL(18, 0), default=None), Column('transaction_subtype_id', DECIMAL(18, 0), default=None), Column('contributor_only', Boolean, default=None), Column('contributor_id', String(255), default=None), Column('contributor_name', String(255), default=None), Column('contribution_id', String(255), default=None), Column('isrc', String(255), default=None), Column('sound_recording_id', String(255), default=None), Column('sound_recording_name', String(255), default=None), Column('quantity', DECIMAL(18, 0), default=None), Column('withholding_tax_usd', DECIMAL(18, 6), default=None), Column('total_usd', DECIMAL(24, 12), comment='Fka TOTAL', default=None), Column('unit_price_usd', DECIMAL(24, 12), comment='Fka UNIT_PRICE', default=None), ) t_stmt_db_sales_nr_staging = Table( 'stmt_db_sales_nr_staging', Base.metadata, Column( 'stmt_db_sales_nr_txn_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_STMT_DB_SALES_NR_STAGING.NEXTVAL' ), default=None, ), Column( 'unique_detail_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'batch_id', String(255), comment='Internal-only, containing additional identifier for the statement file', default=None, ), Column( 'statement_id', DECIMAL(32, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'start_date', NormalizedDate, comment='Shows the starting month date for the revenue included', default=None, ), Column( 'end_date', NormalizedDate, comment='Fka DATE. Shows the ending month date for the revenue included', default=None, ), Column( 'store_id', DECIMAL(32, 0), comment='Fka CUSTOMER_MASTER_MASTER_ID', default=None, ), Column( 'subdistributor', String(255), comment='Original retailer source of the transaction', default=None, ), Column( 'sale_currency_code', String(30), comment='Fka ORIGINAL_CURRENCY_ISO', default=None, ), Column( 'sale_currency_code_id', DECIMAL(18, 0), comment='Derived from SALE_CURRENCY_CODE', default=None, ), Column( 'activity_rate', DECIMAL(18, 6), comment='Conversion rate between the sale currency and USD. E.g. total_usd / activity_rate = total_sale_currency', default=None, ), Column( 'country_id', DECIMAL(12, 0), comment='Foreign-key reference to DIM_COUNTRY.COUNTRYID', default=None, ), Column( 'configuration', String(255), comment='Internal-only, containing tier codes and descriptions as provided by the DSPs', default=None, ), Column('transaction_type', String(2), comment='Fka TRANS_TYPE', default=None), Column( 'transaction_type_id', DECIMAL(18, 0), comment='Derived from TRANSACTION_TYPE', default=None, ), Column( 'transaction_subtype_id', DECIMAL(18, 0), comment='Fka TRANS_SUBTYPE', default=None, ), Column( 'contributor_only', Boolean, comment='True indicates reporting was on the contributor-level only; in this case, only CONTRIBUTOR_ID, CONTRIBUTOR_NAME will be populated', default=None, ), Column( 'contributor_id', String(255), comment='UUID identifier for the contributor, foreign-key reference to NR_CONTRIBUTOR', default=None, ), Column('contributor_name', String(255), default=None), Column( 'contribution_id', String(255), comment='UUID identifier for the contribution, foreign-key reference to NR_CONTRIBUTION, may be empty if reporting was CONTRIBUTOR_ONLY', default=None, ), Column( 'isrc', String(255), comment='May be empty if reporting was CONTRIBUTOR_ONLY', default=None, ), Column( 'sound_recording_id', String(255), comment='UUID identifier for the sound recording, foreign-key reference to NR_SOUND_RECORDING, may be empty if reporting was CONTRIBUTOR_ONLY', default=None, ), Column( 'sound_recording_name', String(255), comment='UUID identifier for the sound recording, foreign-key reference to NR_SOUND_RECORDING, may be empty if reporting was CONTRIBUTOR_ONLY', default=None, ), Column('quantity', DECIMAL(18, 0), comment='Fka QTY', default=None), Column( 'withholding_tax_usd', DECIMAL(18, 6), comment='Fka WHT. Negative value represents a deduction; sometimes there will be a positive value representing a reversal/adjustment. DSPs / Societies withhold tax from The Orchard to ultimately send to local tax authorities.', default=None, ), Column('total_usd', DECIMAL(24, 12), comment='Fka TOTAL', default=None), Column('unit_price_usd', DECIMAL(24, 12), comment='Fka UNIT_PRICE', default=None), ) t_tap_payoneer_sync_snapshot = Table( 'tap_payoneer_sync_snapshot', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('account_payee_id', DECIMAL(38, 0), default=None), Column('account_payment_term_id', DECIMAL(38, 0), default=None), Column('payoneer_program_id', DECIMAL(38, 0), default=None), Column('currency_code', String(3), default=None), Column('signing_entity_id', DECIMAL(38, 0), default=None), Column('agreement_type_id', DECIMAL(38, 0), default=None), Column( 'inserted_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'account_payment_term_modified_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'account_payee_modified_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_transaction_correction_distro = Table( 'transaction_correction_distro', Base.metadata, Column( 'txn_correction_distro_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_TXN_CORRECTION_DISTRO.NEXTVAL' ), default=None, ), Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'corrected_statement_period_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'correction_type', String(20), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'term_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'distribution_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unit_price_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'distribution_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'created_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'created_by', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_transaction_correction_distro_mech = Table( 'transaction_correction_distro_mech', Base.metadata, Column( 'txn_correction_distro_mech_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_TXN_CORRECTION_DISTRO_MECH.NEXTVAL' ), default=None, ), Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a contract_transaction (CONTRACT_TRANSACTION_STAGING.CONTRACT_TXN_ID)', default=None, ), Column( 'txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Unique identifier of a transaction (STMT_DB_SALES_DISTRO_STAGING.STMT_DB_SALES_DISTRO_TXN_ID).', default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Id of the account', default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Id of the contract', default=None, ), Column( 'corrected_statement_period_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='Statement period id during which the correction is made.', default=None, ), Column( 'correction_type', String(20), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='One of royalty_reversal or royalty_correction', default=None, ), Column( 'term_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The term_rate on the contract applied to royalties (RDS royalty_accounting.contract_term_condition.term_rate / 100).', default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale unit price converted from USD to the sale currency (STMT_DB_SALES_DISTRO.UNIT_PRICE_USD / STMT_DB_SALES_DISTRO.ACTIVITY_RATE_USD).', default=None, ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales in the original sale currency (STMT_DB_SALES_DISTRO.QUANTITY * UNIT_PRICE_SALE_CURRENCY).', default=None, ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale withholding tax (WHT) converted from USD to the sale currency (STMT_DB_SALES_DISTRO.WITHHOLDING_TAX_USD / STMT_DB_SALES_DISTRO.ACTIVITY_RATE_USD).', default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales minus WHT in the original sale currency (GROSS_REVENUE_SALE_CURRENCY - WITHHOLDING_TAX_SALE_CURRENCY).', default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue after applying the contract term rate in the original sale currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * TERM_RATE).', default=None, ), Column( 'distribution_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The distribution fee in the original sale currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY - NET_REVENUE_SALE_CURRENCY * -1).', default=None, ), Column( 'unit_price_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale unit price converted from the original sale currency to the account preferred currency (UNIT_PRICE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'gross_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales convered from the original sale currency to the account preferred currency (GROSS_REVENUE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The sale withholding tax (WHT) converted from the original sale currency to the account preferred currency (WITHHOLDING_TAX_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The gross revenue of sales minus WHT converted from the original sale currency to the account preferred currency (GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The net revenue converted from the original sale currency to the account preferred currency (NET_REVENUE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'distribution_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), comment='The distribution fee converted from the original sale currency to the account preferred currency (DISTRIBUTION_FEE_SALE_CURRENCY * royalty_accounting.exchange_rate.rate).', default=None, ), Column( 'mechanical_deduction_admin_type', String(8), comment='One of: both, business, or customer; used to determine who pays for the deduction (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.ADMIN_TYPE).', default=None, ), Column( 'mechanical_deduction_amount_payee_currency', DECIMAL(24, 12), comment='The calculated amount the customer will pay converted into the payee currency (MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'mechanical_deduction_amount_sale_currency', DECIMAL(24, 12), comment='The calculated amount the customer will pay in the original sale currency ((MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY / MECHANICAL_DEDUCTION_RATE) * -1).', default=None, ), Column( 'mechanical_deduction_rate', DECIMAL(10, 4), comment='This is based on the MECHANICAL_DEDUCTION_ADMIN_TYPE and reflects what percentage of the deduction the customer pays to HFA.', default=None, ), Column( 'mechanical_royalty_amount_payee_currency', DECIMAL(24, 12), comment='The previously calculated total mech royalty amount converted into the payee currency (MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'mechanical_royalty_amount_sale_currency', DECIMAL(24, 12), comment='The previously calculated total mech royalty amount for the transaction (SNAPSHOT_MECHANICAL_TRANSACTION.ROYALTY_AMOUNT).', default=None, ), Column('mechanical_deduction_id', DECIMAL(18, 0), default=None), Column( 'net_revenue_after_mechanical_payee_currency', DECIMAL(24, 12), comment='The calculated total royalty amount after deducting mech and admin fees converted into the payee currency (NET_REVENUE_AFTER_MECHANICAL_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'net_revenue_after_mechanical_sale_currency', DECIMAL(24, 12), comment='The total royalty amount after deducting mech and admin fees in the original sale currency (NET_REVENUE_SALE_CURRENCY + MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY + PUBLISHER_ADMIN_FEE_SALE_CURRENCY).', default=None, ), Column( 'publisher_admin_fee_payee_currency', DECIMAL(24, 12), comment='The calculated admin fee deducted from the customer converted into the payee currency (PUBLISHER_ADMIN_FEE_SALE_CURRENCY * ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.EXCHANGE_RATE.RATE).', default=None, ), Column( 'publisher_admin_fee_rate', DECIMAL(5, 4), comment='A decimal representation of the percentage the company takes, if specified (ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_MECHANICAL_DEDUCTION.ADMIN_FEE / 100).', default=None, ), Column( 'publisher_admin_fee_sale_currency', DECIMAL(24, 12), comment='The calculated admin fee deducted from the customer in the original sale currency ((MECHANICAL_ROYALTY_AMOUNT_SALE_CURRENCY / PUBLISHER_ADMIN_FEE_RATE) * -1).', default=None, ), Column('territory', String(3), comment='One of: USA, CAN or ROW', default=None), Column( 'created_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'created_by', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_transaction_correction_nr = Table( 'transaction_correction_nr', Base.metadata, Column( 'txn_correction_nr_id', DECIMAL(38, 0), server_default=text( 'ROYALTY_ACCOUNTING.PROD.SEQUENCE_TXN_CORRECTION_NR.NEXTVAL' ), default=None, ), Column( 'contract_txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'txn_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'account_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'contract_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'corrected_statement_period_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'correction_type', String(20), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'term_rate', DECIMAL(5, 4), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unit_price_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_after_withholding_tax_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'net_revenue_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'distribution_fee_sale_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'unit_price_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'gross_revenue_after_withholding_tax_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'net_revenue_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'distribution_fee_payee_currency', DECIMAL(24, 12), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'created_at', TIMESTAMP_NTZ, server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'created_by', String(255), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_worksheet_correction_transaction_distro = Table( 'worksheet_correction_transaction_distro', Base.metadata, Column( 'worksheet_correction_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'txn_correction_distro_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_worksheet_correction_transaction_distro_mech = Table( 'worksheet_correction_transaction_distro_mech', Base.metadata, Column( 'worksheet_correction_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'txn_correction_distro_mech_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_worksheet_correction_transaction_nr = Table( 'worksheet_correction_transaction_nr', Base.metadata, Column( 'worksheet_correction_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), Column( 'txn_correction_nr_id', DECIMAL(38, 0), server_default=text('NOT(CAST(null AS BOOLEAN))'), default=None, ), ) t_workstation_fact_sales_unified_dbt = Table( 'workstation_fact_sales_unified_dbt', Base.metadata, Column('txn_id', DECIMAL(38, 0), default=None), Column('artistid', DECIMAL(32, 0), default=None), Column('statement_detail_id', DECIMAL(38, 0), default=None), Column('accountingperiodid', DECIMAL(38, 0), default=None), Column('accountingyear', DECIMAL(38, 0), default=None), Column('accountingmonth', DECIMAL(38, 0), default=None), Column('activityperiodid', DECIMAL(32, 0), default=None), Column('activityyear', DECIMAL(38, 0), default=None), Column('activitymonth', DECIMAL(38, 0), default=None), Column('labelid', DECIMAL(32, 0), default=None), Column('storeid', DECIMAL(32, 0), default=None), Column('genreid', DECIMAL(32, 0), default=None), Column('releaseid', DECIMAL(38, 0), default=None), Column('trackid', DECIMAL(38, 0), default=None), Column('countryid', DECIMAL(16, 0), default=None), Column('transactiontypeid', DECIMAL(16, 0), default=None), Column('catalogid', DECIMAL(38, 0), default=None), Column('isrcid', DECIMAL(38, 0), default=None), Column('imprintid', DECIMAL(38, 0), default=None), Column('sales', DECIMAL(24, 6), default=None), Column('fx_spread_fee', DECIMAL(18, 6), default=None), Column('cloud_publishing', DECIMAL(18, 6), default=None), Column('partner_share', DECIMAL(18, 6), default=None), Column('subaccountid', DECIMAL(32, 0), default=None), Column('datecreated', TIMESTAMP_NTZ, default=None), Column('original_currency_id', DECIMAL(32, 0), default=None), Column('payout_currency_id', DECIMAL(32, 0), default=None), Column('activity_fx_rate', DECIMAL(18, 6), default=None), Column('fx_gross', DECIMAL(24, 12), default=None), Column('fx_adjusted_gross', DECIMAL(25, 12), default=None), Column('fx_actual_net', DECIMAL(24, 12), default=None), Column('fx_distribution_fees', DECIMAL(24, 12), default=None), Column('fx_dpd_publishing', DECIMAL(24, 12), default=None), Column('fx_oms_fees', DECIMAL(24, 12), default=None), Column('fx_ringtone_publishing', DECIMAL(24, 12), default=None), Column('fx_cloud_publishing', DECIMAL(24, 12), default=None), Column('retail_price', DECIMAL(18, 6), default=None), Column('original_price', DECIMAL(18, 6), default=None), Column('discount', DECIMAL(18, 6), default=None), Column('record_type', String(11), default=None), Column('accountingquarter', DECIMAL(16, 0), default=None), Column('activityquarter', DECIMAL(16, 0), default=None), Column('gross', DECIMAL(38, 19), default=None), Column('adjusted_gross', DECIMAL(38, 19), default=None), Column('net_receipt', DECIMAL(38, 19), default=None), Column('actual_net', DECIMAL(38, 19), default=None), Column('distribution_fees', DECIMAL(38, 19), default=None), Column('oms_fees', DECIMAL(38, 19), default=None), Column('dpd_publishing', DECIMAL(38, 19), default=None), Column('ringtone_publishing', DECIMAL(38, 19), default=None), Column('fx_adjusted_exchange_rate', DECIMAL(26, 6), default=None), Column('fx_net_receipt', DECIMAL(26, 12), default=None), ) t_workstation_summary_dbt = Table( 'workstation_summary_dbt', Base.metadata, Column('account_id', DECIMAL(38, 0), default=None), Column('contract_id', DECIMAL(38, 0), default=None), Column('account_name', String(256), default=None), Column('statement_period_id', DECIMAL(38, 0), default=None), Column('currency', String(12), default=None), Column('opening_balance', DECIMAL(31, 2), default=None), Column('payments', DECIMAL(38, 2), default=None), Column('net_revenue', DECIMAL(38, 2), default=None), Column('gross_revenue', DECIMAL(31, 2), default=None), Column('fee', DECIMAL(31, 2), default=None), Column('expenses', DECIMAL(38, 2), default=None), Column('adjustments', DECIMAL(38, 2), default=None), Column('advanced_paid', DECIMAL(32, 2), default=None), Column('closing_balance', DECIMAL(38, 2), default=None), Column('mechanicals', DECIMAL(32, 2), default=None), Column('mechanical_fees', DECIMAL(31, 2), default=None), )