[Zuora, Zuora, is a SaaS application designed to automate billing, commerce and finance operations.nIt helps companies build and run subscription businesses., Features, Feature Name, Supported, Notes, Capture Deletes, check, We capture deletes for , most, tables, Custom Data, check, All tables and fields, Data Blocking, check, Column level and table level, Column Hashing, check, Re-sync, check, Table level, History, check, API Configurable, check, Priority-first sync, dbt Package, Supported Environments, Our two Zuora connectors, Zuora and Zuora Sandbox, support the following environments:, Connector Name, Environment, Zuora, Production, Zuora Sandbox, API Sandbox, Zuora Sandbox, Performance Test, Not Supported, Performance Copy, Setup guide, Follow our step-by-step , Zuora setup guide, to connect Zuora with your destination using Fivetran connectors., Sync Overview, Fivetran uses REST API (, REST, ) to fetch data from Zuora.nThe REST API accepts , ZOQL (Zuora Object Query Language) a SQL-like language, to export the data., Fivetran uses Zuora data model entity relationships to replicate the data into your destination. Some of the objects may not be available depending on the Zuora features enabled on your account., For details refer to the , Availability of Data Source Objects, section in the Zuora documentation., Similarly, Fivetran only syncs your , Home Currency, field if , Automatically include additional Currency Conversion information in data source exports, is selected.nFor details refer to Zuora documentation about , Foreign Currency Conversion for Data Source Exports, ., Objects that require special settings, Some Zuora objects require special permissions or settings before you can access them with Fivetran., Accounting Code, If you have Zuora Finance enabled on your tenant, you must have the Configure Accounting Codes permission., Accounting Period, You must have Zuora Finance enabled on your tenant. You must have the Manage Close Process and Run Trial Balance user permissions., Credit Balance Adjustment, This feature is not available by default. Submit a request at Zuora Global Support to enable this feature or service., “Once its enabled, you must assign the Z-Payments Create Credit Balance Adjustment permission and Cancel Credit Balance Adjustment permission to your user roles.”, If you have the Invoice Settlement feature enabled, this object is deprecated and only available for backward compatibility., Syncing empty tables and columns, Fivetran can sync empty tables and columns for your Zuora connector. For more information, see our , Features documentation, ., Schema information, This schema applies to all Zuora connections., To zoom, open ERD in new window, ., Fivetran will sync the following tables: , In the following section, COLUMN lists the title of every column in each table and REFERENCE tells you which table and column you can join the current table with., ACCOUNT, COLUMN, REFERENCE, id üîë, bill_to_contact_id, CONTACT, communication_profile_id, COMMUNICATION_PROFILE, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, sold_to_contact_id, CONTACT, account_number, additional_email_addresses, allow_invoice_edit, auto_pay, balance, batch, bcd_setting_option, bill_cycle_day, bill_to_id, created_by_id, created_date, credit_balance, crm_id, currency, customer_service_rep_name, gateway, invoice_delivery_prefs_email, invoice_delivery_prefs_print, invoice_template_id, last_invoice_date, mrr, name, notes, parent_id, payment_gateway, payment_term, purchase_order_number, sales_rep_name, sold_to_id, status, tax_company_code, tax_exempt_certificate_id, tax_exempt_certificate_type, tax_exempt_description, tax_exempt_effective_date, tax_exempt_entity_use_code, tax_exempt_expiration_date, tax_exempt_issuing_jurisdiction, tax_exempt_status, total_debit_memo_balance, total_invoice_balance, unapplied_balance, unapplied_credit_memo_amount, updated_by_id, updated_date, vat_id, ACCOUNTING_CODE, COLUMN, REFERENCE, id üîë, category, created_by_id, created_date, gla_account_name, gla_account_number, name, notes, status, type, updated_by_id, updated_date, ACCOUNTING_PERIOD, COLUMN, REFERENCE, id üîë, created_by_id, created_date, end_date, fiscal_quarter, fiscal_year, name, notes, start_date, status, updated_by_id, updated_date, AMENDMENT, COLUMN, REFERENCE, id üîë, subscription_id, SUBSCRIPTION, auto_renew, code, contract_effective_date, created_by_id, created_date, current_term, current_term_period_type, customer_acceptance_date, description, effective_date, name, renewal_setting, renewal_term, renewal_term_period_type, resume_date, service_activation_date, specific_update_date, status, suspend_date, term_start_date, term_type, type, updated_by_id, updated_date, BILLING_RUN, COLUMN, REFERENCE, id üîë, billing_run_number, created_by_id, created_date, end_date, error_message, executed_date, invoice_date, number_of_accounts, number_of_invoices, start_date, status, target_date, target_type, total_time, updated_by_id, updated_date, COMMUNICATION_PROFILE, COLUMN, REFERENCE, id üîë, created_by_id, created_date, description, profile_name, updated_by_id, updated_date, CONTACT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, address_1, address_2, city, country, county, created_by_id, created_date, description, fax, first_name, home_phone, last_name, mobile_phone, nick_name, other_phone, other_phone_type, personal_email, postal_code, state, tax_region, updated_by_id, updated_date, work_email, work_phone, CREDIT_BALANCE_ADJUSTMENT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, account_receivable_accounting_code_id, ACCOUNTING_CODE, bill_to_contact_id, CONTACT, cash_accounting_code_id, ACCOUNTING_CODE, default_payment_method_id, PAYMENT_METHOD, invoice_id, INVOICE, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, payment_id, PAYMENT, payment_method_id, PAYMENT_METHOD, payment_method_snapshot_id, PAYMENT_METHOD_SNAPSHOT, refund_id, REFUND, sold_to_contact_id, CONTACT, accounting_code, adjustment_date, amount, cancelled_on, comment, created_by_id, created_date, number, reason_code, reference_id, source_transaction_id, source_transaction_number, source_transaction_type, status, transferred_to_accounting, type, updated_by_id, updated_date, INVOICE, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, bill_run_id, BILLING_RUN, bill_to_contact_id, CONTACT, bill_to_contact_snapshot_id, CONTACT_SNAPSHOT, parent_account_id, ACCOUNT, default_payment_method_id, PAYMENT_METHOD, sold_to_contact_id, CONTACT, sold_to_contact_snapshot_id, CONTACT_SNAPSHOT, adjustment_amount, amount, amount_without_tax, auto_pay, balance, comments, created_by_id, created_date, credit_balance_adjustment_amount, due_date, includes_one_time, includes_recurring, includes_usage, invoice_date, invoice_number, last_email_sent_date, payment_amount, posted_by, posted_date, refund_amount, reversed, source, source_id, status, target_date, tax_amount, tax_exempt_amount, transferred_to_accounting, updated_by_id, updated_date, INVOICE_ITEM, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, account_receivable_accounting_code_id, ACCOUNTING_CODE, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, bill_to_contact_snapshot_id, CONTACT_SNAPSHOT, default_payment_method_id, PAYMENT_METHOD, deferred_revenue_accounting_code_id, ACCOUNTING_CODE, invoice_id, INVOICE, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, recognized_revenue_accounting_code_id, ACCOUNTING_CODE, sold_to_contact_id, CONTACT, sold_to_contact_snapshot_id, CONTACT_SNAPSHOT, subscription_id, SUBSCRIPTION, accounting_code, applied_to_invoice_item_id, charge_amount, charge_date, charge_name, created_by_id, created_date, processing_type, quantity, rev_rec_start_date, service_end_date, service_start_date, sku, tax_amount, tax_code, tax_exempt_amount, tax_mode, unit_price, uom, updated_by_id, updated_date, INVOICE_ITEM_ADJUSTMENT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, account_receivable_accounting_code_id, ACCOUNTING_CODE, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, deferred_revenue_accounting_code_id, ACCOUNTING_CODE, invoice_id, INVOICE, invoice_item_id, INVOICE_ITEM, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, recognized_revenue_accounting_code_id, ACCOUNTING_CODE, sales_tax_payable_accounting_code_id, ACCOUNTING_CODE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, taxation_item_id, TAXATION_ITEM, accounting_code, adjustment_date, adjustment_number, amount, cancelled_by_id, cancelled_date, comment, created_by_id, created_date, invoice_item_name, invoice_number, reason_code, reference_id, service_end_date, service_start_date, source_id, source_type, status, transferred_to_accounting, type, updated_by_id, updated_date, INVOICE_PAYMENT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, account_receivable_accounting_code_id, ACCOUNTING_CODE, bill_to_contact_id, CONTACT, cash_accounting_code_id, ACCOUNTING_CODE, default_payment_method_id, PAYMENT_METHOD, invoice_id, INVOICE, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, payment_id, PAYMENT, payment_method_id, PAYMENT_METHOD, payment_method_snapshot_id, PAYMENT_METHOD_SNAPSHOT, sold_to_contact_id, CONTACT, amount, created_by_id, created_date, refund_amount, updated_by_id, updated_date, JOURNAL_ENTRY, COLUMN, REFERENCE, id üîë, accounting_period_id, ACCOUNTING_PERIOD, journal_run_id, JOURNAL_RUN, created_by_id, created_date, currency, home_currency, journal_entry_date, notes, number, product__s, status, transaction_count, transaction_type, transfer_date, transferred_by, transferred_to_accounting, updated_by_id, updated_date, JOURNAL_ENTRY_ITEM, COLUMN, REFERENCE, id üîë, accounting_code_id, ACCOUNTING_CODE, accounting_period_id, ACCOUNTING_PERIOD, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, amount, amount_home_currency, created_by_id, created_date, currency, home_currency, type, updated_by_id, updated_date, PAYMENT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, payment_method_id, PAYMENT_METHOD, payment_method_snapshot_id, PAYMENT_METHOD_SNAPSHOT, sold_to_contact_id, CONTACT, accounting_code, amount, applied_amount, applied_credit_balance_amount, auth_transaction_id, bank_identification_number, cancelled_on, comment, created_by_id, created_date, currency, effective_date, gateway, gateway_order_id, gateway_response, gateway_response_code, gateway_state, marked_for_submission_on, payment_number, reference_id, reference_payment_id, refund_amount, second_payment_reference_id, settled_on, soft_descriptor, soft_descriptor_phone, source, source_name, status, submitted_on, transferred_to_accounting, type, unapplied_amount, updated_by_id, updated_date, PAYMENT_METHOD, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, ach_aba_code, ach_account_name, ach_account_number_mask, ach_account_type, ach_address_1, ach_address_2, ach_bank_name, ach_city, ach_country, ach_postal_code, ach_state, active, bank_branch_code, bank_check_digit, bank_city, bank_code, bank_identification_number, bank_name, bank_postal_code, bank_street_name, bank_street_number, bank_transfer_account_name, bank_transfer_account_number_mask, bank_transfer_account_type, bank_transfer_type, business_identification_code, city, country, created_by_id, created_date, credit_card_address_1, credit_card_address_2, credit_card_city, credit_card_country, credit_card_expiration_month, credit_card_expiration_year, credit_card_holder_name, credit_card_mask_number, credit_card_postal_code, credit_card_state, credit_card_type, device_session_id, email, existing_mandate, first_name, iban, ip_address, last_failed_sale_transaction_date, last_name, last_transaction_date_time, last_transaction_status, mandate_creation_date, mandate_id, mandate_received, mandate_update_date, max_consecutive_payment_failures, name, num_consecutive_failures, payment_method_status, payment_retry_window, paypal_baid, paypal_email, paypal_preapproval_key, paypal_type, phone, postal_code, second_token_id, state, street_name, street_number, token_id, total_number_of_error_payments, total_number_of_processed_payments, type, updated_by_id, updated_date, use_default_retry_rule, PAYMENT_METHOD_SNAPSHOT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, payment_method_id, PAYMENT_METHOD, ach_aba_code, ach_account_name, ach_account_number_mask, ach_account_type, ach_bank_name, bank_branch_code, bank_check_digit, bank_city, bank_code, bank_identification_number, bank_name, bank_postal_code, bank_street_name, bank_street_number, bank_transfer_account_name, bank_transfer_account_number_mask, bank_transfer_account_type, bank_transfer_type, business_identification_code, city, country, credit_card_address1, credit_card_address2, credit_card_city, credit_card_country, credit_card_expiration_month, credit_card_expiration_year, credit_card_holder_name, credit_card_mask_number, credit_card_postal_code, credit_card_state, credit_card_type, device_session_id, email, existing_mandate, first_name, iban, ip_address, last_failed_sale_transaction_date, last_name, last_transaction_date_time, last_transaction_status, mandate_creation_date, mandate_id, mandate_received, mandate_update_date, max_consecutive_payment_failures, name, num_consecutive_failures, payment_method_id, payment_method_status, payment_retry_window, paypal_baid, paypal_email, paypal_preapproval_key, paypal_type, phone, postal_code, second_token_id, state, street_name, street_number, token_id, total_number_of_error_payments, total_number_of_processed_payments, type, updated_date, use_default_retry_rule, PRODUCT, COLUMN, REFERENCE, id üîë, allow_feature_changes, category, created_by_id, created_date, description, effective_end_date, effective_start_date, name, sku, updated_by_id, updated_date, PRODUCT_RATE_PLAN, COLUMN, REFERENCE, id üîë, product_id, PRODUCT, created_by_id, created_date, description, effective_end_date, effective_start_date, name, promotion_code__c, updated_by_id, updated_date, PRODUCT_RATE_PLAN_CHARGE, COLUMN, REFERENCE, id üîë, account_receivable_accounting_code_id, ACCOUNTING_CODE, adjustment_liability_accounting_code_id, ACCOUNTING_CODE, adjustment_revenue_accounting_code_id, ACCOUNTING_CODE, contract_asset_accounting_code_id, ACCOUNTING_CODE, contract_liability_accounting_code_id, ACCOUNTING_CODE, contract_recognized_revenue_accounting_code_id, ACCOUNTING_CODE, deferred_revenue_accounting_code_id, ACCOUNTING_CODE, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, recognized_revenue_accounting_code_id, ACCOUNTING_CODE, unbilled_receivables_accounting_code, ACCOUNTING_CODE, accounting_code, apply_discount_to, bill_cycle_day, bill_cycle_type, billing_period, billing_period_alignment, billing_timing, charge_model, charge_type, created_by_id, created_date, default_quantity, deferred_revenue_account, description, discount_level, end_date_condition, included_units, legacy_revenue_reporting, list_price_base, max_quantity, min_quantity, name, number_of_period, overage_calculation_option, overage_unused_units_credit_option, price_change_option, price_increase_percentage, rating_group, recognized_revenue_account, revenue_recognition_rule_name, rev_rec_code, rev_rec_trigger_condition, smoothing_model, specific_billing_period, taxable, tax_code, tax_mode, trigger_event, type, uom, update_date, updated_by_id, up_to_periods, up_to_periods_type, usage_record_rating_option, use_discount_specific_accounting_code, use_tenant_default_for_price_change, weekly_bill_cycle_day, PRODUCT_RATE_PLAN_CHARGE_TIER, COLUMN, REFERENCE, id üîë, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, active, created_by_id, created_date, currency, discount_amount, discount_percentage, ending_unit, included_units, overage_price, price, price_format, starting_unit, tier, updated_by_id, updated_date, RATE_PLAN, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, subscription_version_amendment_id, AMENDMENT, amendment_subscription_rate_plan_id, amendment_type, created_by_id, created_date, name, updated_by_id, updated_date, RATE_PLAN_CHARGE, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, account_receivable_accounting_code_id, ACCOUNTING_CODE, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, deferred_revenue_accounting_code_id, ACCOUNTING_CODE, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, recognized_revenue_accounting_code_id, ACCOUNTING_CODE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, accounting_code, apply_discount_to, bill_cycle_day, bill_cycle_type, billing_period, billing_period_alignment, billing_timing, charged_through_date, charge_model, charge_number, charge_type, created_by_id, created_date, description, discount_level, dmrc, dtcv, effective_end_date, effective_start_date, end_date_condition, is_last_segment, list_price_base, mrr, name, number_of_periods, original_id, overage_calculation_option, overage_unused_units_credit_option, price_change_option, price_increase_percentage, processed_through_date, quantity, rating_group, revenue_recognition_rule_name, rev_rec_code, rev_rec_trigger_condition, segment, specific_billing_period, specific_end_date, tcv, trigger_date, trigger_event, unused_units_credit_rates, uom, updated_by_id, updated_date, up_to_periods, up_to_periods_type, version, weekly_bill_cycle_day, RATE_PLAN_CHARGE_TIER, COLUMN, REFERENCE, id üîë, amendment_id, AMENDMENT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, subscription_id, SUBSCRIPTION, created_by_id, created_date, currency, discount_amount, discount_percentage, ending_unit, included_units, overage_price, price, price_format, starting_unit, tier, updated_by_id, updated_date, REFUND, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, payment_method_snapshot_id, PAYMENT_METHOD_SNAPSHOT, sold_to_contact_id, CONTACT, accounting_code, amount, cancelled_on, comment, created_by_id, created_date, gateway, gateway_response, gateway_response_code, gateway_state, marked_for_submission_on, method_type, payment_method_id, reason_code, reference_id, refund_date, refund_number, refund_transaction_time, second_refund_reference_id, settled_on, soft_descriptor, soft_descriptor_phone, source_type, status, submitted_on, transferred_to_accounting, type, updated_by_id, updated_date, REFUND_INVOICE_PAYMENT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, account_receivable_accounting_code_id, ACCOUNTING_CODE, bill_to_contact_id, CONTACT, cash_accounting_code_id, ACCOUNTING_CODE, default_payment_method_id, PAYMENT_METHOD, invoice_id, INVOICE, invoice_payment_id, INVOICE_PAYMENT, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, payment_id, PAYMENT, payment_method_id, PAYMENT_METHOD, payment_method_snapshot_id, PAYMENT_METHOD_SNAPSHOT, refund_id, REFUND, sold_to_contact_id, CONTACT, created_by_id, created_date, refund_amount, updated_by_id, updated_date, REVENUE_CHARGE_SUMMARY, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, created_by_id, created_date, currency, description, number, updated_by_id, updated_date, REVENUE_CHARGE_SUMMARY_ITEM, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, revenue_charge_summary_id, REVENUE_CHARGE_SUMMARY, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, amount, created_by_id, created_date, currency, updated_by_id, updated_date, REVENUE_EVENT, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, revenue_charge_summary_id, REVENUE_CHARGE_SUMMARY, revenue_event_type_id, REVENUE_EVENT_TYPE, revenue_schedule_id, REVENUE_SCHEDULE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, created_by_id, created_date, description, number, recognition_end, recognition_start, updated_by_id, updated_date, REVENUE_EVENT_ITEM, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, deferred_revenue_accounting_code_id, ACCOUNTING_CODE, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, recognized_revenue_accounting_code_id, ACCOUNTING_CODE, revenue_charge_summary_id, REVENUE_CHARGE_SUMMARY, revenue_event_id, REVENUE_EVENT, revenue_event_type_id, REVENUE_EVENT_TYPE, revenue_schedule_id, REVENUE_SCHEDULE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, amount, created_by_id, created_date, currency, updated_by_id, updated_date, REVENUE_SCHEDULE, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, revenue_charge_summary_id, REVENUE_CHARGE_SUMMARY, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, amount, billing_transaction_id, created_by_id, created_date, currency, description, exchange_rate_date, finance_transaction_type, number, recognition_period_end, recognition_period_start, reference_id, revenue_schedule_date, rule, transaction_date, transaction_number, undistributed_amount, updated_by_id, updated_date, REVENUE_SCHEDULE_ITEM, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, deferred_revenue_accounting_code_id, ACCOUNTING_CODE, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, recognized_revenue_accounting_code_id, ACCOUNTING_CODE, revenue_charge_summary_id, REVENUE_CHARGE_SUMMARY, revenue_schedule_id, REVENUE_SCHEDULE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, amount, created_by_id, created_date, currency, updated_by_id, updated_date, SUBSCRIPTION, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, sold_to_contact_id, CONTACT, subscription_version_amendment_id, AMENDMENT, auto_renew, cancelled_date, contract_acceptance_date, contract_effective_date, cpq_bundle_jsonId_qt, created_by_id, created_date, creator_account_id, creator_invoice_owner_id, current_term, current_term_period_type, initial_term, initial_term_period_type, invoice_owner_id, is_invoice_separate, name, notes, opportunity_close_date_qt, opportunity_name_qt, original_created_date, original_id, original_subscription_id, previous_subscription_id, quote_business_type_qt, quote_number_qt, quote_type_qt, renewal_setting, renewal_term, renewal_term_period_type, service_activation_date, status, subscription_end_date, subscription_start_date, term_end_date, term_start_date, term_type, updated_by_id, updated_date, version, TAXATION_ITEM, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, accounting_period_id, ACCOUNTING_PERIOD, account_receivable_accounting_code_id, ACCOUNTING_CODE, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, invoice_id, INVOICE, invoice_item_id, INVOICE_ITEM, journal_entry_id, JOURNAL_ENTRY, journal_run_id, JOURNAL_RUN, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, sales_tax_payable_accounting_code_id, ACCOUNTING_CODE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, accounting_code, created_by_id, created_date, exempt_amount, jurisdiction, location_code, name, tax_amount, tax_code, tax_code_description, tax_date, tax_mode, tax_rate, tax_rate_description, tax_rate_type, updated_by_id, updated_date, USAGE, COLUMN, REFERENCE, id üîë, account_id, ACCOUNT, amendment_id, AMENDMENT, bill_to_contact_id, CONTACT, default_payment_method_id, PAYMENT_METHOD, parent_account_id, ACCOUNT, product_id, PRODUCT, product_rate_plan_id, PRODUCT_RATE_PLAN, product_rate_plan_charge_id, PRODUCT_RATE_PLAN_CHARGE, rate_plan_id, RATE_PLAN, rate_plan_charge_id, RATE_PLAN_CHARGE, sold_to_contact_id, CONTACT, subscription_id, SUBSCRIPTION, account_number, created_by_id, created_date, end_date_time, quantity, rbe_status, source_type, start_date_time, submission_date_time, uom, updated_by_id, updated_date, n]