Zuora

Explore the interactive ERD

Table & Field Reference

journal_entry_detail_invoice_payment_application

Column	Type	Keys
`id`	String	PK

rate_plan_charge_tier

Column	Type	Keys
`id`	String	PK
`rate_plan_charge_id`	String	FK
`amendment_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`discount_amount`	Double
`discount_percentage`	Double
`ending_unit`	Double
`included_units`	Double
`overage_price`	Double
`price`	Double
`price_format`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_id`	String
`starting_unit`	Double
`subscription_id`	String
`tier`	Long
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_refund_invoice_payment

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_invoice_payment_application_item

Column	Type	Keys
`id`	String	PK

payment_method

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`ach_account_type`	String
`ach_city`	String
`ach_country`	String
`ach_postal_code`	String
`ach_state`	String
`active`	Boolean
`bank_city`	String
`bank_code`	String
`bank_transfer_account_type`	String
`bank_transfer_type`	String
`business_identification_code`	String
`company_name`	String
`created_by_id`	String
`created_date`	Instant
`credit_card_type`	String
`device_session_id`	String
`existing_mandate`	String
`iban`	String
`identity_number`	String
`is_company`	Boolean
`last_failed_sale_transaction_date`	Instant
`last_transaction_date_time`	Instant
`last_transaction_status`	String
`mandate_creation_date`	LocalDate
`mandate_reason`	String
`mandate_received`	String
`mandate_status`	String
`mandate_update_date`	LocalDate
`max_consecutive_payment_failures`	Long
`name`	String
`num_consecutive_failures`	Long
`payment_method_status`	String
`payment_retry_window`	Long
`paypal_type`	String
`total_number_of_error_payments`	Long
`total_number_of_processed_payments`	Long
`type`	String
`updated_by_id`	String
`updated_date`	Instant
`use_default_retry_rule`	Boolean

revenue_event

Column	Type	Keys
`id`	String	PK
`revenue_schedule_id`	String	FK
`account_id`	String
`amendment_id`	String
`amount`	Double
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`description`	String
`number`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_charge_id`	String
`rate_plan_id`	String
`recognition_end`	LocalDate
`recognition_start`	LocalDate
`revenue_charge_summary_id`	String
`revenue_event_type_id`	String
`sold_to_contact_id`	String
`subscription_id`	String
`updated_by_id`	String
`updated_date`	Instant

payment_method_snapshot

Column	Type	Keys
`id`	String	PK
`payment_method_id`	String	FK
`account_id`	String
`ach_aba_code`	String
`ach_account_name`	String
`ach_account_number_mask`	String
`company_name`	String
`country`	String
`created_date`	Instant
`credit_card_expiration_month`	Long
`credit_card_expiration_year`	Long
`credit_card_mask_number`	String
`credit_card_type`	String
`device_session_id`	String
`existing_mandate`	String
`is_company`	Boolean
`last_failed_sale_transaction_date`	Instant
`last_transaction_date_time`	Instant
`last_transaction_status`	String
`mandate_creation_date`	LocalDate
`mandate_id`	String
`mandate_reason`	String
`mandate_received`	String
`mandate_status`	String
`mandate_update_date`	LocalDate
`max_consecutive_payment_failures`	Long
`method_reference_id`	String
`method_specific_data`	String
`name`	String
`num_consecutive_failures`	Long
`payment_method_status`	String
`payment_retry_window`	Long
`paypal_type`	String
`state`	String
`sub_type`	String
`token_id`	String
`total_number_of_error_payments`	Long
`total_number_of_processed_payments`	Long
`type`	String
`updated_date`	Instant
`use_default_retry_rule`	Boolean
`user_reference_id`	String

journal_entry_detail_credit_memo_application_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

revenue_charge_summary

Column	Type	Keys
`id`	String	PK
`rate_plan_charge_id`	String	FK
`account_id`	String
`amendment_id`	String
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`description`	String
`number`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_id`	String
`sold_to_contact_id`	String
`subscription_id`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_credit_balance_adjustment

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

refund_invoice_payment

Column	Type	Keys
`id`	String	PK
`refund_id`	String	FK
`account_id`	String
`account_receivable_accounting_code_id`	String
`accounting_period_id`	String
`bill_to_contact_id`	String
`cash_accounting_code_id`	String
`created_by_id`	String
`created_date`	Instant
`default_payment_method_id`	String
`invoice_id`	String
`invoice_payment_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`parent_account_id`	String
`payment_id`	String
`payment_method_id`	String
`payment_method_snapshot_id`	String
`refund_amount`	Double
`ship_to_contact_id`	String
`sold_to_contact_id`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_invoice_item_adjustment

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

taxation_item

Column	Type	Keys
`id`	String	PK
`invoice_item_id`	String	FK
`account_id`	String
`account_receivable_accounting_code_id`	String
`accounting_code`	String
`amendment_id`	String
`balance`	Double
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_amount`	Double
`customer_code`	String
`default_payment_method_id`	String
`exempt_amount`	Double
`exempt_certificate`	String
`invoice_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`jurisdiction`	String
`location_code`	String
`name`	String
`parent_account_id`	String
`payment_amount`	Double
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_charge_id`	String
`rate_plan_id`	String
`sales_tax_payable_accounting_code_id`	String
`seller_registration`	String
`sold_to_contact_id`	String
`subscription_id`	String
`tax_amount`	Double
`tax_code`	String
`tax_code_description`	String
`tax_date`	LocalDate
`tax_mode`	String
`tax_rate`	Double
`tax_rate_description`	String
`tax_rate_type`	String
`updated_by_id`	String
`updated_date`	Instant

refund

Column	Type	Keys
`id`	String	PK
`payment_method_id`	String	FK
`account_id`	String
`accounting_code`	String
`amount`	String
`bill_to_contact_id`	String
`cancelled_on`	Instant
`comment`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`gateway`	String
`gateway_reconciliation_reason`	String
`gateway_reconciliation_status`	String
`gateway_response`	String
`gateway_response_code`	String
`gateway_state`	String
`marked_for_submission_on`	Instant
`method_type`	String
`parent_account_id`	String
`payment_method_snapshot_id`	String
`payout_id`	String
`reason_code`	String
`reference_id`	String
`refund_date`	LocalDate
`refund_number`	String
`refund_transaction_time`	String
`second_refund_reference_id`	String
`settled_on`	Instant
`soft_descriptor`	String
`soft_descriptor_phone`	String
`sold_to_contact_id`	String
`source_type`	String
`status`	String
`submitted_on`	Instant
`transferred_to_accounting`	String
`type`	String
`updated_by_id`	String
`updated_date`	Instant

product_rate_plan_charge

Column	Type	Keys
`id`	String	PK
`product_rate_plan_id`	String	FK
`accounting_code`	String
`apply_discount_to`	String
`bill_cycle_day`	Long
`bill_cycle_type`	String
`billing_period`	String
`billing_period_alignment`	String
`charge_model`	String
`charge_type`	String
`created_by_id`	String
`created_date`	Instant
`default_quantity`	Double
`deferred_revenue_account`	String
`description`	String
`discount_level`	String
`end_date_condition`	String
`included_units`	Double
`legacy_revenue_reporting`	Boolean
`list_price_base`	String
`max_quantity`	Double
`min_quantity`	Double
`name`	String
`number_of_period`	Long
`overage_calculation_option`	String
`overage_unused_units_credit_option`	String
`price_change_option`	String
`price_increase_percentage`	Double
`recognized_revenue_account`	String
`rev_rec_code`	String
`rev_rec_trigger_condition`	String
`revenue_recognition_rule_name`	String
`smoothing_model`	String
`specific_billing_period`	Long
`tax_code`	String
`tax_mode`	String
`taxable`	Boolean
`trigger_event`	String
`uom`	String
`up_to_periods`	Long
`updated_by_id`	String
`updated_date`	Instant

revenue_schedule_item

Column	Type	Keys
`id`	String	PK
`accounting_period_id`	String	FK
`revenue_schedule_id`	String	FK
`account_id`	String
`amendment_id`	String
`amount`	Double
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`deferred_revenue_accounting_code_id`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_charge_id`	String
`rate_plan_id`	String
`recognized_revenue_accounting_code_id`	String
`revenue_charge_summary_id`	String
`sold_to_contact_id`	String
`subscription_id`	String
`updated_by_id`	String
`updated_date`	Instant

payment

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`payment_method_id`	String	FK
`accounting_code`	String
`amount`	Double
`applied_amount`	Double
`applied_credit_balance_amount`	Double
`auth_transaction_id`	String
`bill_to_contact_id`	String
`cancelled_on`	Instant
`comment`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`effective_date`	LocalDate
`gateway`	String
`gateway_order_id`	String
`gateway_reconciliation_reason`	String
`gateway_reconciliation_status`	String
`gateway_response`	String
`gateway_response_code`	String
`gateway_state`	String
`marked_for_submission_on`	Instant
`payment_method_snapshot_id`	String
`payment_number`	String
`payout_id`	String
`reference_id`	String
`referenced_payment_id`	String
`refund_amount`	Double
`second_payment_reference_id`	String
`settled_on`	Instant
`soft_descriptor`	String
`source`	String
`source_name`	String
`status`	String
`submitted_on`	Instant
`transferred_to_accounting`	String
`type`	String
`unapplied_amount`	Double
`updated_by_id`	String
`updated_date`	Instant

order_action

Column	Type	Keys
`id`	String	PK
`order_id`	String	FK
`account_id`	String
`auto_generated`	Boolean
`auto_renew`	Boolean
`bill_to_contact_id`	String
`cancellation_effective_date`	LocalDate
`cancellation_policy`	String
`change_reason`	String
`clearing_existing_bill_to_contact`	Boolean
`clearing_existing_payment_term`	Boolean
`contract_effective_date`	LocalDate
`created_by_id`	String
`created_date`	Instant
`current_term`	Long
`current_term_period_type`	String
`customer_acceptance_date`	LocalDate
`default_payment_method_id`	String
`effective_policy`	String
`order_action_bill_to_id`	String
`parent_account_id`	String
`payment_term`	String
`renew_setting`	String
`renewal_term`	Long
`renewal_term_period_type`	String
`resume_date`	LocalDate
`sequence`	Long
`service_activation_date`	LocalDate
`sold_to_contact_id`	String
`sub_type`	String
`subscription_bill_to_id`	String
`subscription_id`	String
`subscription_owner_account_bill_to_id`	String
`subscription_owner_account_id`	String
`subscription_owner_account_sold_to_id`	String
`subscription_version_amendment_id`	String
`suspend_date`	Instant
`term_start_date`	LocalDate
`term_type`	String
`type`	String
`updated_by_id`	String
`updated_date`	Instant

revenue_schedule

Column	Type	Keys
`id`	String	PK
`revenue_charge_summary_id`	String	FK
`account_id`	String
`amendment_id`	String
`amount`	Double
`bill_to_contact_id`	String
`billing_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`description`	String
`finance_transaction_type`	String
`number`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_charge_id`	String
`rate_plan_id`	String
`recognition_period_end`	LocalDate
`recognition_period_start`	LocalDate
`reference_id`	String
`revenue_schedule_date`	LocalDate
`rule`	String
`sold_to_contact_id`	String
`subscription_id`	String
`transaction_date`	LocalDate
`transaction_number`	String
`undistributed_amount`	Double
`updated_by_id`	String
`updated_date`	Instant

product_rate_plan

Column	Type	Keys
`id`	String	PK
`product_id`	String	FK
`created_by_id`	String
`created_date`	Instant
`description`	String
`effective_end_date`	LocalDate
`effective_start_date`	LocalDate
`external_id_source_system`	String
`name`	String
`product_rate_plan_number`	String
`updated_by_id`	String
`updated_date`	Instant

subscription_metrics_summary

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	FK
`account_id`	String
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`end_date`	LocalDate
`ending_mrr_discount_amount`	Double
`ending_mrr_gross_amount`	Double
`ending_mrr_net_amount`	Double
`invoice_owner_account_id`	String
`invoice_owner_account_number`	String
`invoice_owner_id`	String
`org_tag_id`	String
`original_subscription_id`	String
`parent_account_id`	String
`ship_to_contact_id`	String
`sold_to_contact_id`	String
`start_date`	LocalDate
`subscription_name`	String
`subscription_owner_account_id`	String
`subscription_owner_account_number`	String
`tcb_discount_amount`	Double
`tcb_gross_amount`	Double
`tcb_net_amount`	Double
`tcv_discount_amount`	Double
`tcv_gross_amount`	Double
`tcv_net_amount`	Double
`updated_by_id`	String
`updated_date`	Instant

ramp

Column	Type	Keys
`id`	String	PK
`order_id`	String	FK
`charge_numbers`	String
`created_by_id`	String
`created_date`	Instant
`description`	String
`discount_tcb`	Double
`discount_tcv`	Double
`gross_tcb`	Double
`gross_tcv`	Double
`metrics_processing_status`	String
`name`	String
`net_tcb`	Double
`net_tcv`	Double
`number`	String
`subscription_numbers`	String
`updated_by_id`	String
`updated_date`	Instant

rate_plan_charge

Column	Type	Keys
`id`	String	PK
`product_rate_plan_charge_id`	String	FK
`rate_plan_id`	String	FK
`account_id`	String
`accounting_code`	String
`apply_discount_to`	String
`bill_cycle_day`	Long
`bill_cycle_type`	String
`billing_period`	String
`billing_period_alignment`	String
`billing_timing`	String
`charge_model`	String
`charge_number`	String
`charge_type`	String
`charged_through_date`	LocalDate
`created_by_id`	String
`created_date`	Instant
`description`	String
`discount_level`	String
`dmrc`	Double
`dtcv`	Double
`effective_end_date`	LocalDate
`effective_start_date`	LocalDate
`end_date_condition`	String
`is_last_segment`	Boolean
`list_price_base`	String
`mrr`	Double
`name`	String
`number_of_periods`	Long
`original_id`	String
`overage_calculation_option`	String
`overage_unused_units_credit_option`	String
`processed_through_date`	LocalDate
`product_id`	String
`quantity`	Double
`rev_rec_code`	String
`rev_rec_trigger_condition`	String
`segment`	Long
`specific_billing_period`	Long
`uom`	String
`updated_date`	Instant
`version`	Long

rate_plan

Column	Type	Keys
`id`	String	PK
`product_rate_plan_id`	String	FK
`subscription_id`	String	FK
`account_id`	String
`amendment_id`	String
`amendment_type`	String
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`default_payment_method_id`	String
`externally_managed_plan_id`	String
`invoice_owner_id`	String
`is_from_external_catalog`	Boolean
`name`	String
`original_rate_plan_id`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_number`	String
`reverted`	Boolean
`sold_to_contact_id`	String
`subscription_owner_id`	String
`subscription_rate_plan_number`	String
`subscription_version_amendment_id`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_invoice_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

contact

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`address_1`	String
`address_2`	String
`city`	String
`country`	String
`county`	String
`created_by_id`	String
`created_date`	Instant
`description`	String
`fax`	String
`first_name`	String
`home_phone`	String
`last_name`	String
`mobile_phone`	String
`nick_name`	String
`other_phone`	String
`other_phone_type`	String
`personal_email`	String
`postal_code`	String
`state`	String
`tax_region`	String
`updated_by_id`	String
`updated_date`	Instant
`work_email`	String
`work_phone`	String

journal_entry_detail_taxation_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry

Column	Type	Keys
`id`	String	PK
`accounting_period_id`	String	FK
`journal_run_id`	String	FK
`created_by_id`	String
`created_date`	Instant
`currency`	String
`journal_entry_date`	LocalDate
`notes`	String
`number`	String
`status`	String
`transaction_count`	Long
`transaction_type`	String
`transfer_date`	Instant
`transferred_by`	String
`transferred_to_accounting`	String
`updated_by_id`	String
`updated_date`	Instant

usage

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`rate_plan_charge_id`	String	FK
`subscription_id`	String	FK
`account_number`	String
`amendment_id`	String
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`default_payment_method_id`	String
`description`	String
`end_date_time`	Instant
`file_name`	String
`import_id`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`quantity`	Double
`rate_plan_id`	String
`rbe_status`	String
`sold_to_contact_id`	String
`source_type`	String
`start_date_time`	Instant
`submission_date_time`	Instant
`uom`	String
`updated_by_id`	String
`updated_date`	Instant

email_notification_history

Column	Type	Keys
`_fivetran_id`	String	PK
`bcc`	String
`cc`	String
`error_message`	String
`event_category`	Int
`from_email`	String
`notification`	String
`reply_to`	String
`result`	String
`send_time`	String
`subject`	String
`to_email`	String

order_item

Column	Type	Keys
`id`	String	PK
`order_id`	String	FK
`amendment_id`	String
`created_by_id`	String
`created_date`	Instant
`end_date`	LocalDate
`order_action_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`quantity`	Double
`rate_plan_charge_id`	String
`rate_plan_id`	String
`start_date`	LocalDate
`subscription_id`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_revenue_event_item

Column	Type	Keys
`id`	String	PK
`journal_entry_id`	String	FK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	String

journal_entry_item

Column	Type	Keys
`id`	String	PK
`journal_entry_id`	String	FK
`accounting_code_id`	String
`accounting_period_id`	String
`amount`	Double
`created_by_id`	String
`created_date`	Instant
`currency`	String
`journal_run_id`	String
`type`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_debit_taxation_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

order

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`bill_to_contact_id`	String
`category`	String
`created_by_id`	String
`created_by_migration`	Boolean
`created_date`	Instant
`default_payment_method_id`	String
`description`	String
`error_code`	String
`error_message`	String
`is_scheduled`	Boolean
`order_date`	LocalDate
`order_number`	String
`parent_account_id`	String
`response`	String
`reversion_order`	Boolean
`reverted_by_order_id`	String
`reverted_date`	LocalDate
`reverted_order_id`	String
`reverted_order_number`	String
`scheduled_date`	LocalDate
`scheduled_date_policy`	String
`sold_to_contact_id`	String
`state`	String
`status`	String
`updated_by_id`	String
`updated_date`	Instant

subscription

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`auto_renew`	Boolean
`bill_to_contact_id`	String
`cancelled_date`	LocalDate
`contract_acceptance_date`	LocalDate
`contract_effective_date`	LocalDate
`created_by_id`	String
`created_date`	String
`creator_account_id`	String
`creator_invoice_owner_id`	String
`current_term`	Long
`current_term_period_type`	String
`default_payment_method_id`	String
`externally_managed_by`	String
`initial_term`	Long
`initial_term_period_type`	String
`invoice_owner_id`	String
`is_invoice_separate`	Boolean
`name`	String
`notes`	String
`opportunity_name_qt`	String
`original_created_date`	Instant
`original_id`	String
`payment_term`	String
`previous_subscription_id`	String
`quote_business_type_qt`	String
`quote_number_qt`	String
`renewal_setting`	String
`renewal_term`	Long
`renewal_term_period_type`	String
`revision`	String
`service_activation_date`	LocalDate
`status`	String
`subscription_end_date`	LocalDate
`subscription_start_date`	LocalDate
`term_end_date`	LocalDate
`term_start_date`	LocalDate
`term_type`	String
`updated_by_id`	String
`updated_date`	Instant
`version`	Long

accounting_period

Column	Type	Keys
`id`	String	PK
`created_by_id`	String
`created_date`	Instant
`end_date`	String
`fiscal_quarter`	Long
`fiscal_year`	Long
`name`	String
`notes`	String
`start_date`	LocalDate
`status`	String
`updated_by_id`	String
`updated_date`	Instant

credit_balance_adjustment

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`payment_id`	String	FK
`account_receivable_accounting_code_id`	String
`accounting_code`	String
`accounting_period_id`	String
`adjustment_date`	LocalDate
`amount`	Double
`bill_to_contact_id`	String
`cancelled_on`	Instant
`cash_accounting_code_id`	String
`comment`	String
`created_by_id`	String
`created_date`	Instant
`customer_cash_on_account_accounting_code_id`	String
`default_payment_method_id`	String
`invoice_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`number`	String
`parent_account_id`	String
`payment_method_id`	String
`payment_method_snapshot_id`	String
`reason_code`	String
`reference_id`	String
`refund_id`	String
`sold_to_contact_id`	String
`source_transaction_id`	String
`source_transaction_number`	String
`source_transaction_type`	String
`status`	String
`transferred_to_accounting`	String
`type`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_credit_memo_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

invoice_adjustment

Column	Type	Keys
`id`	String	PK
`invoice_id`	String	FK
`account_id`	String
`account_receivable_accounting_code_id`	String
`accounting_code`	String
`accounting_period_id`	String
`adjustment_date`	LocalDate
`adjustment_number`	String
`amount`	Double
`bill_to_contact_id`	String
`cancelled_by_id`	String
`cancelled_on`	Instant
`comments`	String
`created_by_id`	String
`created_date`	Instant
`default_payment_method_id`	String
`deferred_revenue_accounting_code_id`	String
`impact_amount`	Double
`invoice_number`	String
`journal_entry_id`	String
`journal_run_id`	String
`parent_account_id`	String
`reason_code`	String
`reference_id`	String
`ship_to_contact_id`	String
`sold_to_contact_id`	String
`status`	String
`transferred_to_accounting`	String
`type`	String
`updated_by_id`	String
`updated_date`	Instant

account

Column	Type	Keys
`id`	String	PK
`bill_to_contact_id`	String	FK
`sold_to_contact_id`	String	FK
`account_number`	String
`allow_invoice_edit`	Boolean
`auto_pay`	Boolean
`balance`	Double
`batch`	String
`bcd_setting_option`	String
`bill_cycle_day`	Long
`communication_profile_id`	String
`created_by_id`	String
`created_date`	String
`credit_balance`	Double
`crm_id`	String
`currency`	String
`customer_service_rep_name`	String
`default_payment_method_id`	String
`invoice_delivery_prefs_email`	Boolean
`invoice_delivery_prefs_print`	Boolean
`invoice_template_id`	String
`last_invoice_date`	LocalDate
`mrr`	Double
`parent_id`	String
`payment_gateway`	String
`payment_term`	String
`purchase_order_number`	String
`sales_rep_name`	String
`sequence_set_id`	String
`status`	String
`tax_exempt_certificate_type`	String
`tax_exempt_description`	String
`tax_exempt_effective_date`	LocalDate
`tax_exempt_expiration_date`	LocalDate
`tax_exempt_issuing_jurisdiction`	String
`tax_exempt_status`	String
`total_debit_memo_balance`	Double
`total_invoice_balance`	Double
`unapplied_balance`	Double
`unapplied_credit_memo_amount`	Double
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_invoice_payment

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

product_rate_plan_charge_tier

Column	Type	Keys
`id`	String	PK
`product_rate_plan_charge_id`	String	FK
`active`	Boolean
`created_by_id`	String
`created_date`	Instant
`currency`	String
`discount_amount`	Double
`discount_percentage`	Double
`ending_unit`	Double
`included_units`	Double
`overage_price`	Double
`price`	Double
`price_format`	String
`product_id`	String
`product_rate_plan_id`	String
`starting_unit`	Double
`tier`	Long
`updated_by_id`	String
`updated_date`	Instant

revenue_charge_summary_item

Column	Type	Keys
`id`	String	PK
`revenue_charge_summary_id`	String	FK
`account_id`	String
`accounting_period_id`	String
`amendment_id`	String
`amount`	Double
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_charge_id`	String
`rate_plan_id`	String
`sold_to_contact_id`	String
`subscription_id`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_debit_memo_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	String
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

ramp_interval

Column	Type	Keys
`id`	String	PK
`ramp_id`	String	FK
`created_by_id`	String
`created_date`	Instant
`description`	String
`discount_tcb`	Double
`discount_tcv`	Double
`end_date`	LocalDate
`gross_tcb`	Double
`gross_tcv`	Double
`name`	String
`net_tcb`	Double
`net_tcv`	Double
`start_date`	LocalDate
`updated_by_id`	String
`updated_date`	Instant

journal_run

Column	Type	Keys
`id`	String	PK
`created_by_id`	String
`created_date`	Instant
`number`	String
`process_end_date_time`	Instant
`process_start_date_time`	Instant
`status`	String
`target_date_type`	String
`target_end_date`	LocalDate
`target_start_date`	LocalDate
`total_journal_entry_count`	Long
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_invoice_adjustment

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	String
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_refund_application_item

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	String
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_credit_memo_taxation_item

Column	Type	Keys
`id`	String	PK

invoice_item

Column	Type	Keys
`id`	String	PK
`invoice_id`	String	FK
`rate_plan_charge_id`	String	FK
`account_id`	String
`account_receivable_accounting_code_id`	String
`accounting_code`	String
`amendment_id`	String
`applied_to_invoice_item_id`	String
`balance`	Double
`bill_to_contact_id`	String
`bill_to_contact_snapshot_id`	String
`booking_reference`	String
`charge_amount`	Double
`charge_date`	String
`charge_name`	String
`created_by_id`	String
`created_date`	Instant
`default_payment_method_id`	String
`deferred_revenue_accounting_code_id`	String
`exclude_item_billing_from_revenue_accounting`	Boolean
`journal_entry_id`	String
`processing_type`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`quantity`	Double
`rate_plan_id`	String
`recognized_revenue_accounting_code_id`	String
`rev_rec_start_date`	LocalDate
`service_end_date`	LocalDate
`service_start_date`	LocalDate
`sku`	String
`sold_to_contact_id`	String
`subscription_id`	String
`tax_amount`	Double
`tax_code`	String
`tax_exempt_amount`	Double
`tax_mode`	String
`unit_price`	Double
`uom`	String
`updated_by_id`	String
`updated_date`	Instant

invoice

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`adjustment_amount`	Double
`amount`	Double
`amount_without_tax`	Double
`auto_pay`	Boolean
`balance`	Double
`bill_to_contact_id`	String
`bill_to_contact_snapshot_id`	String
`comments`	String
`created_by_id`	String
`created_date`	Instant
`credit_balance_adjustment_amount`	Double
`default_payment_method_id`	String
`due_date`	LocalDate
`includes_one_time`	Boolean
`includes_recurring`	Boolean
`includes_usage`	Boolean
`invoice_date`	LocalDate
`invoice_number`	String
`last_email_sent_date`	Instant
`parent_account_id`	String
`payment_amount`	Double
`payment_term`	String
`posted_by`	String
`posted_date`	Instant
`refund_amount`	Double
`reversed`	Boolean
`sold_to_contact_id`	String
`sold_to_contact_snapshot_id`	String
`source`	String
`source_id`	String
`source_type`	String
`status`	String
`target_date`	LocalDate
`tax_amount`	Double
`tax_exempt_amount`	Double
`tax_message`	String
`tax_status`	String
`transferred_to_accounting`	String
`updated_by_id`	String
`updated_date`	Instant

amendment

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	FK
`auto_renew`	Boolean
`booking_date`	LocalDate
`code`	String
`contract_effective_date`	LocalDate
`created_by_id`	String
`created_date`	Instant
`current_term`	Long
`current_term_period_type`	String
`customer_acceptance_date`	LocalDate
`description`	String
`effective_date`	LocalDate
`effective_policy`	String
`name`	String
`new_rate_plan_id`	String
`removed_rate_plan_id`	String
`renewal_setting`	String
`renewal_term`	Long
`renewal_term_period_type`	String
`resume_date`	LocalDate
`service_activation_date`	LocalDate
`specific_update_date`	LocalDate
`status`	String
`sub_type`	String
`suspend_date`	LocalDate
`term_start_date`	LocalDate
`term_type`	String
`type`	String
`updated_by_id`	String
`updated_date`	Instant

revenue_event_item

Column	Type	Keys
`id`	String	PK
`revenue_event_id`	String	FK
`account_id`	String
`accounting_period_id`	String
`amendment_id`	String
`amount`	Double
`bill_to_contact_id`	String
`created_by_id`	String
`created_date`	Instant
`currency`	String
`default_payment_method_id`	String
`deferred_revenue_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`parent_account_id`	String
`product_id`	String
`product_rate_plan_charge_id`	String
`product_rate_plan_id`	String
`rate_plan_charge_id`	String
`rate_plan_id`	String
`recognized_revenue_accounting_code_id`	String
`revenue_charge_summary_id`	String
`revenue_event_type_id`	String
`revenue_schedule_id`	String
`sold_to_contact_id`	String
`subscription_id`	String
`updated_by_id`	String
`updated_date`	Instant

product

Column	Type	Keys
`id`	String	PK
`allow_feature_changes`	Boolean
`category`	String
`created_by_id`	String
`created_date`	Instant
`description`	String
`effective_end_date`	LocalDate
`effective_start_date`	LocalDate
`name`	String
`product_number`	String
`sku`	String
`updated_by_id`	String
`updated_date`	Instant

journal_entry_detail_refund_application

Column	Type	Keys
`id`	String	PK
`account_id`	String
`amount`	Double
`container_transaction_id`	String
`created_by_id`	String
`created_date`	Instant
`credit_accounting_code_id`	String
`currency`	String
`debit_accounting_code_id`	String
`journal_entry_id`	String
`journal_run_id`	String
`transaction_date`	LocalDate
`transaction_id`	String
`transaction_subtype`	String
`transaction_type`	String
`updated_by_id`	String
`updated_date`	Instant