version: 2 sources: - name: prod_royalty_accounting_royalty_accounting database: orchard_app_reporting_v2 tables: - name: abacus_event - name: abacus_state - name: abacus_state_history - name: account - name: account_contract - name: account_contract_distribution - name: account_contract_vat_detail - name: account_payee - name: account_payee_history - name: account_payee_kyc_notification - name: account_payee_kyc_notification_history - name: account_payee_payoneer_status - name: account_payee_payoneer_status_history - name: account_payee_tax_form_info - name: account_payee_tax_form_info_history - name: account_payment_term - name: account_payment_term_contract - name: account_payment_term_history - name: account_payment_term_template - name: account_tax_info - name: account_tax_info_history - name: accounting_period - name: accounting_period_report - name: accounting_run - name: adjustment - name: contract - name: contract_advance - name: contract_advance_history - name: contract_exception - name: contract_exclusion - name: contract_flowthrough - name: contract_flowthrough_history - name: contract_history - name: contract_lifecycle - name: contract_lifecycle_history - name: contract_lifecycle_schedule - name: contract_lifecycle_schedule_detail - name: contract_mechanical_deduction - name: contract_mechanical_deduction_history - name: contract_party - name: contract_party_history - name: contract_payee - name: contract_physical_reserve - name: contract_reserve - name: contract_template - name: contract_term - name: contract_term_condition - name: contract_term_condition_history - name: contract_term_history - name: contract_term_schedule - name: contract_term_schedule_history - name: contract_territory_exclusion - name: country - name: databasechangelog - name: databasechangeloglock - name: exchange_rate - name: fivetran_audit - name: json_contract_file_import_status - name: ledger_account - name: ledger_account_contract - name: ledger_account_contract_current_balance - name: ledger_account_current_balance - name: ledger_accounting_run_balance - name: ledger_accounting_run_vat - name: ledger_adjustment - name: ledger_adjustment_adjustment_detail - name: ledger_adjustment_adjustment_detail_applied - name: ledger_adjustment_applied - name: ledger_adjustment_detail - name: ledger_adjustment_detail_applied - name: ledger_contract_advance_applied - name: ledger_correction - name: ledger_deposit - name: ledger_general - name: ledger_payee - name: ledger_payee_current_balance - name: ledger_reserve_release - name: ledger_reserve_release_schedule - name: ledger_reserve_taken - name: ledger_vat_summary - name: legacy_contract - name: legacy_payee - name: mechanical_deduction - name: payee - name: payee_collaborator - name: payee_contact - name: payee_history - name: payee_kyc_notification - name: payee_kyc_notification_history - name: payment_entity_payoneer_program - name: payment_group - name: payment_group_payment - name: payment_group_payment_account - name: payment_group_payment_account_batch - name: payment_group_payment_account_detail - name: payment_group_payment_account_detail_split - name: payment_group_payment_batch - name: payment_group_payment_batch_account - name: payment_group_payment_payee - name: payment_hold - name: payment_hold_history - name: payment_minimum - name: reference_adjustment_type - name: reference_advance_payment_method - name: reference_agreement_type - name: reference_external_source - name: reference_flowthrough_calculation - name: reference_mechanical_rate - name: reference_payable_detail_type - name: reference_payment_entity - name: reference_payment_type - name: reference_payoneer_program - name: reference_sap_profit_center - name: reference_signing_entity - name: reference_tax_withholding - name: reference_transaction_type - name: reference_transaction_type_group - name: reference_transaction_type_group_transaction_type - name: reference_vat_rate - name: report_custom - name: report_payment_group_payment - name: rollback_abacus_event_6811 - name: rollback_abacus_state_6811 - name: rollback_acc_1175_statement_attachment - name: rollback_acc_5010_keep_double_vat_ledger_account - name: rollback_acc_5010_keep_double_vat_ledger_account_contract - name: rollback_acc_5010_ledger_account_contract_current_balance - name: rollback_acc_5010_ledger_account_current_balance - name: rollback_acc_5010_remove_double_vat_ledger_account - name: rollback_acc_5010_remove_double_vat_ledger_account_contract - name: rollback_acc_5010_remove_double_vat_ledger_deposit - name: rollback_acc_5027_contract - name: rollback_acc_5027_contract_state - name: rollback_acc_5027_contract_statement_attachment - name: rollback_acc_5027_contract_term - name: rollback_acc_5027_reference_external_source - name: rollback_acc_5065_apt - name: rollback_acc_5080_in_fix - name: rollback_acc_5080_on_hold - name: rollback_acc_5097_remove_on_hold - name: rollback_acc_5100_5101_remove_ct - name: rollback_acc_5100_5101_remove_ctc - name: rollback_acc_5321_rcc - name: rollback_acc_5507 - name: rollback_acc_6164_ledger_account - name: rollback_acc_6164_ledger_account_contract - name: rollback_acc_6164_ledger_account_contract_current_balance - name: rollback_acc_6164_ledger_account_current_balance - name: rollback_acc_7193_adj_applied - name: rollback_acc_7193_adj_detail_applied - name: rollback_acc_7476_account_current_balance - name: rollback_acc_7476_adj_applied - name: rollback_acc_7476_contract_current_balance - name: rollback_acc_7476_ledger_account - name: rollback_acc_7476_ledger_account_contract - name: rollback_acc_8099 - name: rollback_acc_8168_2_update_lifecycle_schedule_altafonte - name: rollback_acc_8168_update_lifecycle_schedule_altafonte - name: rollback_acc_8299_reference_external_source - name: rollback_acc_8300_delete_inactive_altafonte_accounts - name: rollback_acc_8300_delete_inactive_altafonte_contracts - name: rollback_acc_8307_incorrect_agreement_type - name: rollback_acc_8308_incorrect_sap_profit_center_for_altafonte - name: rollback_acc_8355_contract_backup - name: rollback_acc_8355_contract_lifecycle_backup - name: rollback_acc_8355_contract_lifecycle_schedule_backup - name: rollback_acc_8355_update_contract_lifecycle_contract_ids - name: rollback_acc_8453_1_existing_ks_ka_transaction_types - name: rollback_acc_8453_2_existing_priorities_above_one - name: rollback_acc_8453_3_backup_contract_term_conditions - name: rollback_acc_8471_backup_contract_term_conditions - name: rollback_data_acc_4841_1 - name: rollback_data_acc_4862_account_contract - name: rollback_data_acc_4862_contract - name: rollback_data_acc_4862_contract_term - name: rollback_data_acc_4862_contract_term_condition - name: rollback_data_acc_4862_reference_external_source - name: rollback_data_acc_4967_product - name: rollback_data_acc_4967_track - name: rollback_data_acc_4967_track_ctc - name: rollback_data_acc_4967_track_ctc_ref - name: rollback_data_acc_4967_track_ref - name: rollback_data_acc_4982 - name: rollback_data_acc_4985 - name: rollback_data_acc_4996 - name: rollback_data_acc_5014_account - name: rollback_data_acc_5014_account_more - name: rollback_data_acc_5014_account_payee - name: rollback_data_acc_5014_account_payee_more - name: rollback_data_acc_5014_account_payment_term - name: rollback_data_acc_5014_account_payment_term_more - name: rollback_data_acc_5014_account_tax_info - name: rollback_data_acc_5014_account_tax_info_more - name: rollback_data_acc_5014_delete_account_contract - name: rollback_data_acc_5014_delete_contract - name: rollback_data_acc_5014_delete_contract_term - name: rollback_data_acc_5014_delete_contract_term_condition - name: rollback_data_acc_5014_delete_reference_external_source - name: rollback_data_acc_5014_delete_run_controller_contract - name: rollback_data_acc_5022_term_to_demote - name: rollback_data_acc_5022_track_term_to_promote - name: rollback_data_acc_5054_1 - name: rollback_data_acc_5054_2 - name: rollback_data_acc_5093_1 - name: rollback_data_acc_5093_2 - name: rollback_data_acc_5104_1 - name: rollback_data_acc_5104_2 - name: rollback_data_acc_5127_1 - name: rollback_data_acc_5128_1 - name: rollback_data_acc_5143_1 - name: rollback_data_acc_5143_2 - name: rollback_data_acc_5143_3 - name: rollback_data_acc_5143_4 - name: rollback_data_acc_5143_5 - name: rollback_data_acc_5252_1 - name: rollback_data_acc_5252_4 - name: rollback_data_acc_5252_5 - name: rollback_data_acc_5252_8 - name: rollback_data_acc_5252_9 - name: rollback_data_acc_5300 - name: rollback_data_acc_5316 - name: rollback_data_acc_5373_1 - name: rollback_data_acc_5373_2 - name: rollback_data_acc_5373_3 - name: rollback_data_acc_5373_4 - name: rollback_data_acc_5373_5 - name: rollback_data_acc_5378_contract_sap - name: rollback_data_acc_5393_3 - name: rollback_data_acc_5393_4 - name: rollback_data_acc_5393_6 - name: rollback_data_acc_5393_7 - name: rollback_data_acc_5393_8 - name: rollback_data_acc_5393_9 - name: rollback_data_acc_5482 - name: rollback_data_acc_5500_1 - name: rollback_data_acc_5500_10 - name: rollback_data_acc_5500_12 - name: rollback_data_acc_5500_13 - name: rollback_data_acc_5500_2 - name: rollback_data_acc_5500_3 - name: rollback_data_acc_5500_6 - name: rollback_data_acc_5500_7 - name: rollback_data_acc_5500_8 - name: rollback_data_acc_5522_contract_sap - name: rollback_data_acc_5641_12 - name: rollback_data_acc_5641_3 - name: rollback_data_acc_5641_4 - name: rollback_data_acc_5641_5 - name: rollback_data_acc_5641_6 - name: rollback_data_acc_5641_7 - name: rollback_data_acc_5641_8 - name: rollback_data_acc_5645 - name: rollback_data_acc_5668_contract_code - name: rollback_data_acc_5725_2 - name: rollback_data_acc_5725_8 - name: rollback_data_acc_5767_2 - name: rollback_data_acc_5767_3 - name: rollback_data_acc_5767_4 - name: rollback_data_acc_5767_5 - name: rollback_data_acc_5767_7 - name: rollback_data_acc_5767_8 - name: rollback_data_acc_5806_2 - name: rollback_data_acc_5824_contract_code - name: rollback_data_acc_5839_10 - name: rollback_data_acc_5839_2 - name: rollback_data_acc_5839_3 - name: rollback_data_acc_5839_5 - name: rollback_data_acc_5839_6 - name: rollback_data_acc_5839_7 - name: rollback_data_acc_5839_9 - name: rollback_data_acc_5916_contract_code - name: rollback_data_acc_5945_contract_code - name: rollback_data_acc_5949_10 - name: rollback_data_acc_5949_13 - name: rollback_data_acc_5949_3 - name: rollback_data_acc_5949_5 - name: rollback_data_acc_5949_6 - name: rollback_data_acc_5949_8 - name: rollback_data_acc_5949_9 - name: rollback_data_acc_6023 - name: rollback_data_acc_6081_10 - name: rollback_data_acc_6081_11 - name: rollback_data_acc_6081_12 - name: rollback_data_acc_6081_13 - name: rollback_data_acc_6081_14 - name: rollback_data_acc_6081_15 - name: rollback_data_acc_6081_2 - name: rollback_data_acc_6081_3_1 - name: rollback_data_acc_6081_3_2 - name: rollback_data_acc_6081_5 - name: rollback_data_acc_6081_6 - name: rollback_data_acc_6081_8 - name: rollback_data_acc_6155_11 - name: rollback_data_acc_6155_2 - name: rollback_data_acc_6155_3 - name: rollback_data_acc_6155_5 - name: rollback_data_acc_6155_7 - name: rollback_data_acc_6155_8 - name: rollback_data_acc_6252_4 - name: rollback_data_acc_6252_5 - name: rollback_data_acc_6252_7 - name: rollback_data_acc_6284_5 - name: rollback_data_acc_6284_6_1 - name: rollback_data_acc_6284_6_2 - name: rollback_data_acc_6284_7_1 - name: rollback_data_acc_6284_8 - name: rollback_data_acc_6358_2 - name: rollback_data_acc_6358_3 - name: rollback_data_acc_6358_7 - name: rollback_data_acc_6358_8 - name: rollback_data_acc_6358_9 - name: rollback_data_acc_6415_1 - name: rollback_data_acc_6452_1 - name: rollback_data_acc_6712 - name: rollback_data_acc_6736_1 - name: rollback_data_acc_6811_2_1 - name: rollback_data_acc_6811_2_2 - name: rollback_data_acc_6811_2_3 - name: rollback_data_acc_6836_1 - name: rollback_data_acc_6897_1 - name: rollback_data_acc_6898_1 - name: rollback_data_acc_6903_1 - name: rollback_data_acc_6919_1 - name: rollback_data_acc_7058_1 - name: rollback_data_acc_7058_2 - name: rollback_data_acc_7058_3 - name: rollback_data_acc_7058_4 - name: rollback_data_acc_7133 - name: rollback_data_acc_7193_2_1 - name: rollback_data_acc_7193_2_2 - name: rollback_data_acc_7193_2_3 - name: rollback_data_acc_7193_3_1 - name: rollback_data_acc_7193_3_2 - name: rollback_data_acc_7193_4_1 - name: rollback_data_acc_7193_4_2 - name: rollback_data_acc_7193_4_3 - name: rollback_data_acc_7193_5_1 - name: rollback_data_acc_7193_5_2 - name: rollback_data_acc_7193_5_3 - name: rollback_data_acc_7214_1 - name: rollback_data_acc_7214_2 - name: rollback_data_acc_7252_7 - name: rollback_data_acc_7344_1 - name: rollback_data_acc_7354_1 - name: rollback_data_acc_7426_1 - name: rollback_data_acc_7508_2 - name: rollback_data_acc_7508_3 - name: rollback_data_acc_7520_1 - name: rollback_data_acc_7704_1_keep - name: rollback_data_acc_7704_2_keep - name: rollback_data_acc_7733_1 - name: rollback_data_acc_7837_1 - name: rollback_data_acc_7837_2 - name: rollback_data_acc_7837_3 - name: rollback_data_acc_7837_4 - name: rollback_data_acc_8107 - name: rollback_data_acc_8141_1 - name: rollback_data_acc_8141_2 - name: rollback_data_acc_8141_3 - name: rollback_data_acc_8141_4 - name: rollback_data_acc_8380_altafonte_data - name: rollback_data_acc_8380_orchard_data - name: rollback_data_acc_8381_altafonte_data - name: rollback_data_acc_8381_awal_data - name: rollback_data_acc_8532_data - name: rollback_data_acc_8539 - name: rollback_data_acc_8596 - name: rollback_data_acc_8597 - name: rollback_data_acc_8608 - name: rollback_tap_2239_ledger_vat_summary - name: rollback_tap_934_account_payee - name: rollback_tap_934_account_payee_history - name: rollback_war_2010_statement_attachment - name: rollback_war_2134_statement_attachment - name: run_controller - name: run_controller_contract - name: sales_file - name: schedule - name: schedule_attachment - name: schedule_attachment_history - name: schedule_history - name: signing_entity - name: statement_attachment - name: statement_attachment_archive_war_1131 - name: statement_period - name: statement_period_adjustment_file - name: statement_period_payment_entity - name: store - name: transaction_type - name: vat_summary_file - name: worksheet_account_contract_closing_balance - name: worksheet_account_contract_payable_after_tax - name: worksheet_account_contract_payable_details - name: worksheet_account_contract_taxable_revenue - name: worksheet_adjustment - name: worksheet_adjustment_detail - name: worksheet_correction - name: worksheet_payment_contract_advance - name: worksheet_tax_correction - name: worksheet_tax_correction_vat