Zuora

Share on facebook
Share on twitter
Share on linkedin

Snowflake Cost Saving

We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now

Data Connector Description:

Data Connector Type: Application

Data Connector Documentation:

[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]

Share on facebook
Share on twitter
Share on linkedin

Join The Club

Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!