Chargebee Product Catalog 1.0
Explore the interactive ERD
Table & Field Reference
gift_timeline
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
gift_id | Unknown | PKFK |
occurred_at | Unknown | |
status | Unknown |
gift
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
gift_receiver_customer_id | Unknown | FK |
gift_receiver_subscription_id | Unknown | FK |
gifter_customer_id | Unknown | FK |
gifter_invoice_id | Unknown | FK |
auto_claim | Unknown | |
claim_expiry_date | Unknown | |
gift_receiver_email | Unknown | |
gift_receiver_first_name | Unknown | |
gift_receiver_last_name | Unknown | |
gift_timelines | Unknown | |
gifter_object | Unknown | |
gifter_signature | Unknown | |
no_expiry | Unknown | |
object | Unknown | |
resource_version | Unknown | |
scheduled_at | Unknown | |
status | Unknown | |
updated_at | Unknown |
credit_note_invoice_allocation
| Column | Type | Keys |
|---|---|---|
credit_note_id | Unknown | PKFK |
invoice_id | Unknown | PKFK |
allocated_amount | Unknown | |
allocated_at | Unknown | |
invoice_date | Unknown | |
invoice_status | Unknown |
credit_note_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
credit_note_id | Unknown | PKFK |
customer_id | Unknown | FK |
reference_line_item_id | Unknown | FK |
subscription_id | Unknown | FK |
amount | Unknown | |
amount_in_decimal | Unknown | |
date_from | Unknown | |
date_to | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
entity_description | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
is_taxed | Unknown | |
item_level_discount_amount | Unknown | |
object | Unknown | |
pricing_model | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
tax_amount | Unknown | |
tax_exempt_reason | Unknown | |
tax_rate | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
credit_note_line_item_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
credit_note_id | Unknown | PKFK |
line_item_id | Unknown | FK |
is_non_compliance_tax | Unknown | |
is_partial_tax_applied | Unknown | |
local_currency_code | Unknown | |
tax_amount | Unknown | |
tax_amount_in_local_currency | Unknown | |
tax_juris_code | Unknown | |
tax_juris_name | Unknown | |
tax_juris_type | Unknown | |
tax_name | Unknown | |
tax_rate | Unknown | |
taxable_amount | Unknown |
credit_note_line_item_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
credit_note_id | Unknown | PKFK |
coupon_id | Unknown | FK |
line_item_id | Unknown | FK |
discount_amount | Unknown | |
discount_type | Unknown |
credit_note_line_item_tier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
credit_note_id | Unknown | PKFK |
line_item_id | Unknown | FK |
ending_unit | Unknown | |
ending_unit_in_decimal | Unknown | |
quantity_used | Unknown | |
quantity_used_in_decimal | Unknown | |
starting_unit | Unknown | |
starting_unit_in_decimal | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
credit_note_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
credit_note_id | Unknown | PKFK |
line_item_id | Unknown | FK |
amount | Unknown | |
coupon_set_code | Unknown | |
description | Unknown | |
discount_percentage | Unknown | |
discount_type | Unknown | |
entity_id | Unknown | |
entity_type | Unknown |
credit_note_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
credit_note_id | Unknown | PKFK |
amount | Unknown | |
description | Unknown | |
name | Unknown |
credit_note_linked_refund
| Column | Type | Keys |
|---|---|---|
txn_id | Unknown | PK |
credit_note_id | Unknown | PKFK |
applied_amount | Unknown | |
applied_at | Unknown | |
refund_reason_code | Unknown | |
txn_amount | Unknown | |
txn_date | Unknown | |
txn_status | Unknown |
credit_note_linked_tax_withheld_refund
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
credit_note_id | Unknown | PKFK |
amount | Unknown | |
date | Unknown | |
description | Unknown | |
reference_number | Unknown |
credit_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
reference_invoice_id | Unknown | FK |
subscription_id | Unknown | FK |
amount_allocated | Unknown | |
amount_available | Unknown | |
amount_refunded | Unknown | |
base_currency_code | Unknown | |
business_entity_id | Unknown | |
channel | Unknown | |
create_reason_code | Unknown | |
credit_note_billing_address_city | Unknown | |
credit_note_billing_address_company | Unknown | |
credit_note_billing_address_country | Unknown | |
credit_note_billing_address_email | Unknown | |
credit_note_billing_address_first_name | Unknown | |
credit_note_billing_address_last_name | Unknown | |
credit_note_billing_address_line_1 | Unknown | |
credit_note_billing_address_line_2 | Unknown | |
credit_note_billing_address_line_3 | Unknown | |
credit_note_billing_address_object | Unknown | |
credit_note_billing_address_phone | Unknown | |
credit_note_billing_address_state | Unknown | |
credit_note_billing_address_state_code | Unknown | |
credit_note_billing_address_validation_status | Unknown | |
credit_note_billing_address_zip | Unknown | |
credit_note_shipping_address_city | Unknown | |
credit_note_shipping_address_company | Unknown | |
credit_note_shipping_address_country | Unknown | |
credit_note_shipping_address_email | Unknown | |
credit_note_shipping_address_first_name | Unknown | |
credit_note_shipping_address_index | Unknown | |
credit_note_shipping_address_last_name | Unknown | |
credit_note_shipping_address_line_1 | Unknown | |
credit_note_shipping_address_line_2 | Unknown | |
credit_note_shipping_address_line_3 | Unknown | |
credit_note_shipping_address_object | Unknown | |
credit_note_shipping_address_phone | Unknown | |
credit_note_shipping_address_state | Unknown | |
credit_note_shipping_address_state_code | Unknown | |
credit_note_shipping_address_validation_status | Unknown | |
credit_note_shipping_address_zip | Unknown | |
currency_code | Unknown | |
date | Unknown | |
deleted | Unknown | |
discounts | Unknown | |
e_invoice_id | Unknown | |
e_invoice_message | Unknown | |
e_invoice_status | Unknown | |
exchange_rate | Unknown | |
fractional_correction | Unknown | |
generated_at | Unknown | |
local_currency_code | Unknown | |
object | Unknown | |
price_type | Unknown | |
reason_code | Unknown | |
refunded_at | Unknown | |
resource_version | Unknown | |
round_off_amount | Unknown | |
status | Unknown | |
sub_total | Unknown | |
sub_total_in_local_currency | Unknown | |
taxes | Unknown | |
total | Unknown | |
total_in_local_currency | Unknown | |
type | Unknown | |
updated_at | Unknown | |
vat_number | Unknown | |
vat_number_prefix | Unknown | |
voided_at | Unknown |
coupon_set_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
coupon_set_id | Unknown | PKFK |
value | Unknown |
coupon_set
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
coupon_id | Unknown | FK |
archived_count | Unknown | |
name | Unknown | |
redeemed_count | Unknown | |
total_count | Unknown |
quote_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
quote_id | Unknown | PKFK |
customer_id | Unknown | FK |
reference_line_item_id | Unknown | FK |
subscription_id | Unknown | FK |
amount | Unknown | |
amount_in_decimal | Unknown | |
date_from | Unknown | |
date_to | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
entity_description | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
is_taxed | Unknown | |
item_level_discount_amount | Unknown | |
object | Unknown | |
pricing_model | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
tax_amount | Unknown | |
tax_exempt_reason | Unknown | |
tax_rate | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
quote_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
quote_id | Unknown | PKFK |
line_item_id | Unknown | FK |
amount | Unknown | |
coupon_set_code | Unknown | |
description | Unknown | |
entity_id | Unknown | |
entity_type | Unknown |
quote_line_item_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
quote_id | Unknown | PKFK |
line_item_id | Unknown | FK |
is_non_compliance_tax | Unknown | |
is_partial_tax_applied | Unknown | |
local_currency_code | Unknown | |
tax_amount | Unknown | |
tax_amount_in_local_currency | Unknown | |
tax_juris_code | Unknown | |
tax_juris_name | Unknown | |
tax_juris_type | Unknown | |
tax_name | Unknown | |
tax_rate | Unknown | |
taxable_amount | Unknown |
quote_line_item_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
quote_id | Unknown | PKFK |
coupon_id | Unknown | FK |
line_item_id | Unknown | FK |
discount_amount | Unknown | |
discount_type | Unknown |
quote_line_item_tier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
quote_id | Unknown | PKFK |
line_item_id | Unknown | FK |
ending_unit | Unknown | |
ending_unit_in_decimal | Unknown | |
quantity_used | Unknown | |
quantity_used_in_decimal | Unknown | |
starting_unit | Unknown | |
starting_unit_in_decimal | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
quote_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
quote_id | Unknown | PKFK |
amount | Unknown | |
description | Unknown | |
name | Unknown |
quote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
invoice_id | Unknown | FK |
subscription_id | Unknown | FK |
amount_due | Unknown | |
amount_paid | Unknown | |
billing_address_city | Unknown | |
billing_address_company | Unknown | |
billing_address_country | Unknown | |
billing_address_email | Unknown | |
billing_address_first_name | Unknown | |
billing_address_last_name | Unknown | |
billing_address_line_1 | Unknown | |
billing_address_line_2 | Unknown | |
billing_address_line_3 | Unknown | |
billing_address_object | Unknown | |
billing_address_phone | Unknown | |
billing_address_state | Unknown | |
billing_address_state_code | Unknown | |
billing_address_validation_status | Unknown | |
billing_address_zip | Unknown | |
charge_on_acceptance | Unknown | |
contract_term_end | Unknown | |
contract_term_start | Unknown | |
contract_term_termination_fee | Unknown | |
credits_applied | Unknown | |
currency_code | Unknown | |
date | Unknown | |
deleted | Unknown | |
discounts | Unknown | |
name | Unknown | |
notes | Unknown | |
object | Unknown | |
operation_type | Unknown | |
po_number | Unknown | |
price_type | Unknown | |
resource_version | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company | Unknown | |
shipping_address_country | Unknown | |
shipping_address_email | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_index | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_line_1 | Unknown | |
shipping_address_line_2 | Unknown | |
shipping_address_line_3 | Unknown | |
shipping_address_phone | Unknown | |
shipping_address_state | Unknown | |
shipping_address_state_code | Unknown | |
shipping_address_validation_status | Unknown | |
shipping_address_zip | Unknown | |
status | Unknown | |
sub_total | Unknown | |
taxes | Unknown | |
total | Unknown | |
total_payable | Unknown | |
updated_at | Unknown | |
valid_till | Unknown | |
vat_number | Unknown | |
vat_number_prefix | Unknown | |
version | Unknown |
subscription_renewal_invoice_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
subscription_estimate_id | Unknown | FK |
subscription_id | Unknown | FK |
amount | Unknown | |
date_from | Unknown | |
date_to | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
is_taxed | Unknown | |
item_level_discount_amount | Unknown | |
object | Unknown | |
pricing_model | Unknown | |
quantity | Unknown | |
tax_amount | Unknown | |
unit_amount | Unknown |
subscription_estimate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
subscription_estimate_id | Unknown | PKFK |
subscription_renewal_invoice_estimate
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
subscription_estimate_id | Unknown | PKFK |
subscription_renewal_credit_note_estimate
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
subscription_estimate_id | Unknown | PKFK |
subscription_renewal_unbilled_charge_estimate
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
subscription_estimate_id | Unknown | PKFK |
subscription_renewal_estimate
| Column | Type | Keys |
|---|---|---|
subscription_estimate_id | Unknown | PKFK |
customer_id | Unknown | FK |
created_at | Unknown | |
invoice_estimate_amount_due | Unknown | |
invoice_estimate_amount_paid | Unknown | |
invoice_estimate_credits_applied | Unknown | |
invoice_estimate_currency_code | Unknown | |
invoice_estimate_line_item_discounts | Json | |
invoice_estimate_line_item_taxes | Json | |
invoice_estimate_object | Unknown | |
invoice_estimate_price_type | Unknown | |
invoice_estimate_recurring | Unknown | |
invoice_estimate_round_off_amount | Unknown | |
invoice_estimate_sub_total | Unknown | |
invoice_estimate_taxes | Json | |
invoice_estimate_total | Unknown | |
object | Unknown | |
subscription_estimate_currency_code | Unknown | |
subscription_estimate_next_billing_at | Unknown | |
subscription_estimate_object | Unknown | |
subscription_estimate_pause_date | Unknown | |
subscription_estimate_resume_date | Unknown | |
subscription_estimate_status | Unknown | |
subscription_estimate_trial_end_action | Unknown |
payment_source_mandate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_source_id | Unknown | PKFK |
subscription_id | Unknown | FK |
created_at | Unknown |
payment_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
amazon_payment_agreement_id | Unknown | |
amazon_payment_email | Unknown | |
bank_account_bank_name | Unknown | |
bank_account_direct_debit_scheme | Unknown | |
bank_account_echeck_type | Unknown | |
bank_account_email | Unknown | |
bank_account_first_name | Unknown | |
bank_account_holder_type | Unknown | |
bank_account_last_4 | Unknown | |
bank_account_last_name | Unknown | |
bank_account_mandate_id | Unknown | |
bank_account_name_on_account | Unknown | |
bank_account_type | Unknown | |
boleto_email | Unknown | |
boleto_first_name | Unknown | |
boleto_last_4 | Unknown | |
boleto_last_name | Unknown | |
business_entity_id | Unknown | |
card_billing_addr_1 | Unknown | |
card_billing_addr_2 | Unknown | |
card_billing_city | Unknown | |
card_billing_country | Unknown | |
card_billing_state | Unknown | |
card_billing_state_code | Unknown | |
card_billing_zip | Unknown | |
card_brand | Unknown | |
card_expiry_month | Unknown | |
card_expiry_year | Unknown | |
card_first_name | Unknown | |
card_funding_type | Unknown | |
card_iin | Unknown | |
card_last_4 | Unknown | |
card_last_name | Unknown | |
card_masked_number | Unknown | |
card_object | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
gateway | Unknown | |
gateway_account_id | Unknown | |
ip_address | Unknown | |
issuing_country | Unknown | |
klarna_pay_now_email | Unknown | |
object | Unknown | |
paypal_agreement_id | Unknown | |
paypal_email | Unknown | |
reference_id | Unknown | |
resource_version | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Unknown | |
upi_vpa | Unknown | |
venmo_user_name | Unknown |
plan_applicable_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
plan_id | Unknown | PKFK |
plan_event_based_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
plan_id | Unknown | PKFK |
charge_once | Unknown | |
on_event | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown |
plan_attached_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
plan_id | Unknown | PKFK |
billing_cycles | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
type | Unknown |
plan_tax_provider_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
plan_id | Unknown | PKFK |
field_id | Unknown | |
field_value | Unknown | |
provider_name | Unknown |
plan_tier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
plan_id | Unknown | PKFK |
ending_unit | Unknown | |
ending_unit_in_decimal | Unknown | |
price | Unknown | |
price_in_decimal | Unknown | |
starting_unit | Unknown | |
starting_unit_in_decimal | Unknown |
plan_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
plan_id | Unknown | PKFK |
value | Unknown |
plan
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accounting_category_1 | Unknown | |
accounting_category_2 | Unknown | |
accounting_category_3 | Unknown | |
accounting_category_4 | Unknown | |
accounting_code | Unknown | |
addon_applicability | Unknown | |
archived_at | Unknown | |
avalara_sale_type | Unknown | |
avalara_service_type | Unknown | |
avalara_transaction_type | Unknown | |
billing_cycles | Unknown | |
channel | Unknown | |
charge_model | Unknown | |
claim_url | Unknown | |
currency_code | Unknown | |
description | Unknown | |
enabled_in_hosted_pages | Unknown | |
enabled_in_portal | Unknown | |
ending_unit | Unknown | |
free_quantity | Unknown | |
free_quantity_in_decimal | Unknown | |
giftable | Unknown | |
hsn_code | Unknown | |
invoice_name | Unknown | |
invoice_notes | Unknown | |
is_shippable | Unknown | |
name | Unknown | |
object | Unknown | |
period | Unknown | |
period_unit | Unknown | |
price | Unknown | |
price_in_decimal | Unknown | |
pricing_model | Unknown | |
quantity | Unknown | |
redirect_url | Unknown | |
resource_version | Unknown | |
setup_cost | Unknown | |
shipping_frequency_period | Unknown | |
shipping_frequency_period_unit | Unknown | |
show_description_in_invoices | Unknown | |
show_description_in_quotes | Unknown | |
sku | Unknown | |
starting_unit | Unknown | |
status | Unknown | |
tax_code | Unknown | |
tax_profile_id | Unknown | |
taxable | Unknown | |
taxjar_product_code | Unknown | |
trial_end_action | Unknown | |
trial_period | Unknown | |
trial_period_unit | Unknown | |
updated_at | Unknown |
site_migration_detail
| Column | Type | Keys |
|---|---|---|
entity_id | Unknown | PK |
entity_id_at_other_site | Unknown | |
entity_type | Unknown | |
migrated_at | Unknown | |
other_site_name | Unknown | |
status | Unknown |
resent_order
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
resent_order_id | Unknown | PKFK |
amount | Unknown | |
reason | Unknown |
order_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | PKFK |
invoice_id | Unknown | FK |
invoice_line_item_id | Unknown | FK |
amount | Unknown | |
amount_adjusted | Unknown | |
amount_paid | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
fulfillment_amount | Unknown | |
fulfillment_quantity | Unknown | |
is_shippable | Unknown | |
item_level_discount_amount | Unknown | |
refundable_credits | Unknown | |
refundable_credits_issued | Unknown | |
sku | Unknown | |
status | Unknown | |
tax_amount | Unknown | |
unit_price | Unknown |
order_line_item_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
line_item_id | Unknown | FK |
is_non_compliance_tax | Unknown | |
is_partial_tax_applied | Unknown | |
local_currency_code | Unknown | |
prorated_taxable_amount | Unknown | |
tax_amount | Unknown | |
tax_amount_in_local_currency | Unknown | |
tax_juris_code | Unknown | |
tax_juris_name | Unknown | |
tax_juris_type | Unknown | |
tax_name | Unknown | |
tax_rate | Unknown | |
taxable_amount | Unknown |
order_line_item_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
line_item_id | Unknown | FK |
discount_amount | Unknown | |
discount_type | Unknown |
order_linked_credit_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
order_id | Unknown | PKFK |
amount | Unknown |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
gift_id | Unknown | FK |
invoice_id | Unknown | FK |
original_order_id | Unknown | FK |
subscription_id | Unknown | FK |
amount_adjusted | Unknown | |
amount_paid | Unknown | |
batch_id | Unknown | |
billing_address_city | Unknown | |
billing_address_company | Unknown | |
billing_address_country | Unknown | |
billing_address_email | Unknown | |
billing_address_first_name | Unknown | |
billing_address_last_name | Unknown | |
billing_address_line_1 | Unknown | |
billing_address_line_2 | Unknown | |
billing_address_line_3 | Unknown | |
billing_address_phone | Unknown | |
billing_address_state | Unknown | |
billing_address_state_code | Unknown | |
billing_address_validation_status | Unknown | |
billing_address_zip | Unknown | |
cancellation_reason | Unknown | |
cancelled_at | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
currency_code | Unknown | |
deleted | Unknown | |
delivered_at | Unknown | |
discount | Unknown | |
document_number | Unknown | |
fulfillment_status | Unknown | |
gift_note | Unknown | |
invoice_round_off_amount | Unknown | |
is_gifted | Unknown | |
is_resent | Unknown | |
note | Unknown | |
order_date | Unknown | |
order_type | Unknown | |
paid_on | Unknown | |
payment_status | Unknown | |
price_type | Unknown | |
reference_id | Unknown | |
refundable_credits | Unknown | |
refundable_credits_issued | Unknown | |
resend_reason | Unknown | |
resent_status | Unknown | |
resource_version | Unknown | |
rounding_adjustement | Unknown | |
shipment_carrier | Unknown | |
shipped_at | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company | Unknown | |
shipping_address_country | Unknown | |
shipping_address_email | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_index | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_line_1 | Unknown | |
shipping_address_line_2 | Unknown | |
shipping_address_line_3 | Unknown | |
shipping_address_phone | Unknown | |
shipping_address_state | Unknown | |
shipping_address_state_code | Unknown | |
shipping_address_validation_status | Unknown | |
shipping_address_zip | Unknown | |
shipping_cut_off_date | Unknown | |
shipping_date | Unknown | |
status | Unknown | |
status_update_at | Unknown | |
sub_total | Unknown | |
tax | Unknown | |
total | Unknown | |
tracking_id | Unknown | |
tracking_url | Unknown | |
updated_at | Unknown |
virtual_bank_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
account_number | Unknown | |
bank_name | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
email | Unknown | |
gateway | Unknown | |
gateway_account_id | Unknown | |
object | Unknown | |
reference_id | Unknown | |
resource_version | Unknown | |
routing_number | Unknown | |
scheme | Unknown | |
swift_code | Unknown | |
updated_at | Unknown |
addon_tier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
addon_id | Unknown | PKFK |
ending_unit | Unknown | |
ending_unit_in_decimal | Unknown | |
price | Unknown | |
price_in_decimal | Unknown | |
starting_unit | Unknown | |
starting_unit_in_decimal | Unknown |
addon_tax_provider_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
addon_id | Unknown | PKFK |
field_id | Unknown | |
field_value | Unknown | |
provider_name | Unknown |
addon_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
addon_id | Unknown | PKFK |
value | Unknown |
addon
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accounting_category_1 | Unknown | |
accounting_category_2 | Unknown | |
accounting_category_3 | Unknown | |
accounting_category_4 | Unknown | |
accounting_code | Unknown | |
archived_at | Unknown | |
avalara_sale_type | Unknown | |
avalara_service_type | Unknown | |
avalara_transaction_type | Unknown | |
channel | Unknown | |
charge_type | Unknown | |
currency_code | Unknown | |
description | Unknown | |
enabled_in_portal | Unknown | |
ending_unit | Unknown | |
hsn_code | Unknown | |
included_in_mrr | Unknown | |
invoice_name | Unknown | |
invoice_notes | Unknown | |
is_shippable | Unknown | |
name | Unknown | |
object | Unknown | |
period | Unknown | |
period_unit | Unknown | |
price | Unknown | |
price_in_decimal | Unknown | |
pricing_model | Unknown | |
proration_type | Unknown | |
resource_version | Unknown | |
shipping_frequency_period | Unknown | |
shipping_frequency_period_unit | Unknown | |
show_description_in_invoices | Unknown | |
show_description_in_quotes | Unknown | |
sku | Unknown | |
starting_unit | Unknown | |
status | Unknown | |
tax_code | Unknown | |
tax_profile_id | Unknown | |
taxable | Unknown | |
taxjar_product_code | Unknown | |
unit | Unknown | |
updated_at | Unknown |
subscription_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
subscription_id | Unknown | PKFK |
subscription_updated_at | Unknown | FK |
amount | Unknown | |
amount_in_decimal | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
remaining_billing_cycles | Unknown | |
trial_end | Unknown | |
unit_price | Unknown | |
unit_price_in_decimal | Unknown |
subscription_event_based_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
subscription_id | Unknown | PKFK |
subscription_updated_at | Unknown | FK |
charge_once | Unknown | |
on_event | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
unit_price | Unknown | |
unit_price_in_decimal | Unknown |
subscription_charged_event_based_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
subscription_id | Unknown | PKFK |
subscription_updated_at | Unknown | FK |
last_charged_at | Unknown |
subscription_coupon
| Column | Type | Keys |
|---|---|---|
coupon_id | Unknown | PKFK |
subscription_id | Unknown | PKFK |
subscription_updated_at | Unknown | FK |
applied_count | Unknown | |
apply_till | Unknown | |
coupon_code | Unknown |
subscription_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
subscription_id | Unknown | PKFK |
subscription_updated_at | Unknown | PKFK |
value | Unknown |
subscription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
updated_at | Unknown | PK |
customer_id | Unknown | FK |
gift_id | Unknown | FK |
payment_source_id | Unknown | FK |
plan_id | Unknown | FK |
activated_at | Unknown | |
affiliate_token | Unknown | |
auto_close_invoices | Unknown | |
auto_collection | Unknown | |
base_currency_code | Unknown | |
billing_period | Unknown | |
billing_period_unit | Unknown | |
business_entity_id | Unknown | |
cancel_reason | Unknown | |
cancel_reason_code | Unknown | |
cancel_schedule_created_at | Unknown | |
cancelled_at | Unknown | |
changes_scheduled_at | Unknown | |
channel | Unknown | |
contract_term_action_at_term_end | Unknown | |
contract_term_billing_cycle | Unknown | |
contract_term_billing_cycle_on_renewal | Unknown | |
contract_term_cancellation_cutoff_period | Unknown | |
contract_term_contract_end | Unknown | |
contract_term_contract_start | Unknown | |
contract_term_created_at | Unknown | |
contract_term_id | Unknown | |
contract_term_remaining_billing_cycles | Unknown | |
contract_term_status | Unknown | |
contract_term_total_contract_value | Unknown | |
contract_term_total_contract_value_before_tax | Unknown | |
create_pending_invoices | Unknown | |
created_at | Unknown | |
created_from_ip | Unknown | |
currency_code | Unknown | |
current_term_end | Unknown | |
current_term_start | Unknown | |
deleted | Unknown | |
due_invoices_count | Unknown | |
due_since | Unknown | |
exchange_rate | Unknown | |
free_period | Unknown | |
free_period_unit | Unknown | |
has_scheduled_advance_invoices | Unknown | |
has_scheduled_changes | Unknown | |
invoice_notes | Unknown | |
mrr | Unknown | |
next_billing_at | Unknown | |
offline_payment_method | Unknown | |
override_relationship | Unknown | |
pause_date | Unknown | |
plan_amount | Unknown | |
plan_amount_in_decimal | Unknown | |
plan_free_quantity | Unknown | |
plan_free_quantity_in_decimal | Unknown | |
plan_quantity | Unknown | |
plan_quantity_in_decimal | Unknown | |
plan_unit_price | Unknown | |
plan_unit_price_in_decimal | Unknown | |
po_number | Unknown | |
referral_info_account_id | Unknown | |
referral_info_campaign_id | Unknown | |
referral_info_coupon_code | Unknown | |
referral_info_destination_url | Unknown | |
referral_info_external_campaign_id | Unknown | |
referral_info_external_reference_id | Unknown | |
referral_info_friend_offer_type | Unknown | |
referral_info_notify_referral_system | Unknown | |
referral_info_post_purchase_widget_enabled | Unknown | |
referral_info_referral_code | Unknown | |
referral_info_referral_system | Unknown | |
referral_info_referrer_id | Unknown | |
referral_info_referrer_reward_type | Unknown | |
referral_info_reward_status | Unknown | |
remaining_billing_cycles | Unknown | |
resource_version | Unknown | |
resume_date | Unknown | |
setup_fee | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company | Unknown | |
shipping_address_country | Unknown | |
shipping_address_email | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_line_1 | Unknown | |
shipping_address_line_2 | Unknown | |
shipping_address_line_3 | Unknown | |
shipping_address_phone | Unknown | |
shipping_address_state | Unknown | |
shipping_address_state_code | Unknown | |
shipping_address_validation_status | Unknown | |
shipping_address_zip | Unknown | |
start_date | Unknown | |
started_at | Unknown | |
status | Unknown | |
total_dues | Unknown | |
trial_end | Unknown | |
trial_end_action | Unknown | |
trial_start | Unknown | |
meta_data_** |
promotional_credit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
amount | Unknown | |
amount_in_decimal | Unknown | |
closing_balance | Unknown | |
created_at | Unknown | |
credit_type | Unknown | |
currency_code | Unknown | |
description | Unknown | |
done_by | Unknown | |
object | Unknown | |
reference | Unknown | |
type | Unknown |
event_webhook
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
status | Unknown |
event_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
event_id | Unknown | PKFK |
value | Unknown |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_version | Unknown | |
event_type | Unknown | |
occurred_at | Unknown | |
origin_user | Unknown | |
source | Unknown | |
users | Unknown | |
webhook_status | Unknown |
coupon_code
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
coupon_id | Unknown | FK |
coupon_set_id | Unknown | FK |
coupon_set_name | Unknown | |
status | Unknown |
coupon_plan
| Column | Type | Keys |
|---|---|---|
coupon_id | Unknown | PKFK |
plan_id | Unknown | PKFK |
coupon_addon
| Column | Type | Keys |
|---|---|---|
addon_id | Unknown | PKFK |
coupon_id | Unknown | PKFK |
coupon_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
coupon_id | Unknown | PKFK |
value | Unknown |
coupon
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
addon_constraint | Unknown | |
apply_on | Unknown | |
archived_at | Unknown | |
created_at | Unknown | |
currency_code | Unknown | |
discount_amount | Unknown | |
discount_percentage | Unknown | |
discount_type | Unknown | |
duration_type | Unknown | |
included_in_mrr | Unknown | |
invoice_name | Unknown | |
invoice_notes | Unknown | |
max_redemptions | Unknown | |
name | Unknown | |
period | Unknown | |
period_unit | Unknown | |
plan_constraint | Unknown | |
redemptions | Unknown | |
resource_version | Unknown | |
status | Unknown | |
updated_at | Unknown | |
valid_till | Unknown |
hosted_page
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_entity_id | Unknown | |
checkout_info | Unknown | |
content | Unknown | |
created_at | Unknown | |
embed | Unknown | |
expires_at | Unknown | |
object | Unknown | |
pass_thru_content | Unknown | |
resource_version | Unknown | |
state | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url | Unknown |
unbilled_charge_tier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
unbilled_charge_id | Unknown | PKFK |
ending_unit | Unknown | |
ending_unit_in_decimal | Unknown | |
quantity_used | Unknown | |
quantity_used_in_decimal | Unknown | |
starting_unit | Unknown | |
starting_unit_in_decimal | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
unbilled_charge
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
subscription_id | Unknown | FK |
amount | Unknown | |
amount_in_decimal | Unknown | |
currency_code | Unknown | |
date_from | Unknown | |
date_to | Unknown | |
deleted | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
is_advance_charge | Unknown | |
is_voided | Unknown | |
object | Unknown | |
pricing_model | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown | |
updated_at | Unknown | |
voided_at | Unknown |
comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
added_by | Unknown | |
created_at | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
notes | Unknown | |
type | Unknown |
invoice_issued_credit_note
| Column | Type | Keys |
|---|---|---|
cn_id | Unknown | PKFK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
invoice_adjustment_credit_note
| Column | Type | Keys |
|---|---|---|
cn_id | Unknown | PKFK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
invoice_dunning_attempt
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
transaction_id | Unknown | FK |
attempt | Unknown | |
created_at | Unknown | |
dunning_type | Unknown | |
txn_amount | Unknown | |
txn_status | Unknown |
invoice_applied_credit
| Column | Type | Keys |
|---|---|---|
cn_id | Unknown | PKFK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
applied_amount | Unknown | |
applied_at | Unknown | |
cn_create_reason_code | Unknown | |
cn_date | Unknown | |
cn_reason_code | Unknown | |
cn_status | Unknown |
invoice_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
customer_id | Unknown | FK |
subscription_id | Unknown | FK |
amount | Unknown | |
amount_in_decimal | Unknown | |
date_from | Unknown | |
date_to | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
entity_description | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
is_taxed | Unknown | |
item_level_discount_amount | Unknown | |
object | Unknown | |
pricing_model | Unknown | |
quantity | Unknown | |
quantity_in_decimal | Unknown | |
tax_amount | Unknown | |
tax_exempt_reason | Unknown | |
tax_rate | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
invoice_line_item_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
line_item_id | Unknown | FK |
is_non_compliance_tax | Unknown | |
is_partial_tax_applied | Unknown | |
local_currency_code | Unknown | |
prorated_taxable_amount | Unknown | |
tax_amount | Unknown | |
tax_amount_in_local_currency | Unknown | |
tax_juris_code | Unknown | |
tax_juris_name | Unknown | |
tax_juris_type | Unknown | |
tax_name | Unknown | |
tax_rate | Unknown | |
taxable_amount | Unknown |
invoice_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
amount | Unknown | |
description | Unknown | |
name | Unknown |
invoice_line_item_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
coupon_id | Unknown | FK |
line_item_id | Unknown | FK |
discount_amount | Unknown | |
discount_type | Unknown |
invoice_line_item_tier
| Column | Type | Keys |
|---|---|---|
line_item_id | Unknown | PKFK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
ending_unit | Unknown | |
ending_unit_in_decimal | Unknown | |
quantity_used | Unknown | |
quantity_used_in_decimal | Unknown | |
starting_unit | Unknown | |
starting_unit_in_decimal | Unknown | |
unit_amount | Unknown | |
unit_amount_in_decimal | Unknown |
invoice_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
line_item_id | Unknown | FK |
amount | Unknown | |
coupon_set_code | Unknown | |
description | Unknown | |
entity_id | Unknown | |
entity_type | Unknown |
invoice_linked_payment
| Column | Type | Keys |
|---|---|---|
txn_id | Unknown | PK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
applied_amount | Unknown | |
applied_at | Unknown | |
txn_amount | Unknown | |
txn_date | Unknown | |
txn_status | Unknown |
invoice_linked_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
batch_id | Unknown | |
created_at | Unknown | |
document_number | Unknown | |
fulfillment_status | Unknown | |
order_type | Unknown | |
reference_id | Unknown | |
status | Unknown |
invoice_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_updated_at | Unknown | PKFK |
entity_id | Unknown | |
entity_type | Unknown | |
note | Unknown |
invoice_linked_taxes_withheld
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | FK |
invoice_updated_at | Unknown | FK |
amount | Unknown | |
date | Unknown | |
description | Unknown | |
reference_number | Unknown |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
updated_at | Unknown | PK |
customer_id | Unknown | FK |
subscription_id | Unknown | FK |
amount_adjusted | Unknown | |
amount_due | Unknown | |
amount_paid | Unknown | |
amount_to_collect | Unknown | |
billing_address_city | Unknown | |
billing_address_company | Unknown | |
billing_address_country | Unknown | |
billing_address_email | Unknown | |
billing_address_first_name | Unknown | |
billing_address_last_name | Unknown | |
billing_address_line_1 | Unknown | |
billing_address_line_2 | Unknown | |
billing_address_line_3 | Unknown | |
billing_address_object | Unknown | |
billing_address_phone | Unknown | |
billing_address_state | Unknown | |
billing_address_state_code | Unknown | |
billing_address_validation_status | Unknown | |
billing_address_zip | Unknown | |
channel | Unknown | |
credits_applied | Unknown | |
currency_code | Unknown | |
date | Unknown | |
deleted | Unknown | |
due_date | Unknown | |
dunning_status | Unknown | |
einvoice_id | Unknown | |
einvoice_message | Unknown | |
einvoice_reference_number | Unknown | |
einvoice_status | Unknown | |
exchange_rate | Unknown | |
expected_payment_date | Unknown | |
first_invoice | Unknown | |
generated_at | Unknown | |
has_advance_charges | Unknown | |
is_gifted | Unknown | |
is_written_off | Unknown | |
local_currency_code | Unknown | |
local_currency_exchange_rate | Unknown | |
net_term_days | Unknown | |
new_sales_amount | Unknown | |
next_retry_at | Unknown | |
notes | Unknown | |
paid_at | Unknown | |
payment_owner | Unknown | |
po_number | Unknown | |
price_type | Unknown | |
recurring | Unknown | |
resource_version | Unknown | |
round_off_amount | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company | Unknown | |
shipping_address_country | Unknown | |
shipping_address_email | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_index | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_line_1 | Unknown | |
shipping_address_line_2 | Unknown | |
shipping_address_line_3 | Unknown | |
shipping_address_object | Unknown | |
shipping_address_phone | Unknown | |
shipping_address_state | Unknown | |
shipping_address_state_code | Unknown | |
shipping_address_validation_status | Unknown | |
shipping_address_zip | Unknown | |
site_details_at_creation_organization_address_city | Unknown | |
site_details_at_creation_organization_address_country_code | Unknown | |
site_details_at_creation_organization_address_line_1 | Unknown | |
site_details_at_creation_organization_address_state | Unknown | |
site_details_at_creation_organization_address_zip | Unknown | |
site_details_at_creation_organization_email | Unknown | |
site_details_at_creation_organization_name | Unknown | |
site_details_at_creation_organization_phone | Unknown | |
site_details_at_creation_organization_website | Unknown | |
site_details_at_creation_timezone | Unknown | |
statement_descriptor | Unknown | |
statement_descriptor_id | Unknown | |
status | Unknown | |
sub_total | Unknown | |
sub_total_in_local_currency | Unknown | |
tax | Unknown | |
tax_category | Unknown | |
tax_origin_country | Unknown | |
tax_origin_registration_number | Unknown | |
tax_override_reason | Unknown | |
term_finalized | Unknown | |
total | Unknown | |
total_in_local_currency | Unknown | |
use_for_proration | Unknown | |
vat_number | Unknown | |
vat_number_prefix | Unknown | |
void_reason_code | Unknown | |
voided_at | Unknown | |
write_off_amount | Unknown | |
write_off_date | Unknown |
transaction_refund
| Column | Type | Keys |
|---|---|---|
refund_transaction_id | Unknown | PKFK |
transaction_id | Unknown | PKFK |
transaction_linked_payment
| Column | Type | Keys |
|---|---|---|
linked_payments_id | Unknown | PKFK |
transaction_id | Unknown | PKFK |
transaction_invoice
| Column | Type | Keys |
|---|---|---|
invoice_id | Unknown | PKFK |
transaction_id | Unknown | PKFK |
applied_amount | Unknown | |
applied_at | Unknown |
transaction_linked_credit_note
| Column | Type | Keys |
|---|---|---|
cn_id | Unknown | PKFK |
transaction_id | Unknown | PKFK |
applied_amount | Unknown | |
applied_at | Unknown | |
cn_reason_code | Unknown |
transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
payment_source_id | Unknown | FK |
reference_authorization_id | Unknown | FK |
reference_transaction_id | Unknown | FK |
refunded_txn_id | Unknown | FK |
reversal_transaction_id | Unknown | FK |
subscription_id | Unknown | FK |
amount | Unknown | |
amount_capturable | Unknown | |
amount_unused | Unknown | |
authorization_reason | Unknown | |
currency_code | Unknown | |
custom_payment_method_id | Unknown | |
custom_payment_method_name | Unknown | |
date | Unknown | |
deleted | Unknown | |
error_cause_customer_message | Unknown | |
error_cause_id | Unknown | |
error_cause_merchant_message | Unknown | |
error_code | Unknown | |
error_detail_decline_code | Unknown | |
error_detail_decline_message | Unknown | |
error_detail_error_category | Unknown | |
error_detail_error_code | Unknown | |
error_detail_error_field | Unknown | |
error_detail_error_message | Unknown | |
error_detail_network_error_code | Unknown | |
error_detail_network_error_message | Unknown | |
error_detail_processor_error_code | Unknown | |
error_detail_processor_error_message | Unknown | |
error_detail_recommendation_code | Unknown | |
error_detail_recommendation_message | Unknown | |
error_detail_request_id | Unknown | |
error_text | Unknown | |
exchange_rate | Unknown | |
fraud_flag | Unknown | |
fraud_reason | Unknown | |
gateway | Unknown | |
gateway_account_id | Unknown | |
id_at_gateway | Unknown | |
iin | Unknown | |
initiator_type | Unknown | |
last_4 | Unknown | |
masked_card_number | Unknown | |
merchant_reference_id | Unknown | |
payment_method | Unknown | |
payment_method_details | Unknown | |
reference_number | Unknown | |
resource_version | Unknown | |
settled_at | Unknown | |
status | Unknown | |
three_d_secure | Unknown | |
type | Unknown | |
updated_at | Unknown | |
voided_at | Unknown |
customer_referral_url
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
created_at | Unknown | |
referral_account_id | Unknown | |
referral_campaign_id | Unknown | |
referral_external_campaign_id | Unknown | |
referral_sharing_url | Unknown | |
referral_system | Unknown | |
updated_at | Unknown |
customer_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
email | Unknown | |
enabled | Unknown | |
first_name | Unknown | |
label | Unknown | |
last_name | Unknown | |
phone | Unknown | |
send_account_email | Unknown | |
send_billing_email | Unknown |
customer_balance
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
customer_id | Unknown | PKFK |
currency_code | Unknown | |
excess_payments | Unknown | |
promotional_credits | Unknown | |
refundable_credits | Unknown | |
unbilled_charges | Unknown |
customer_tax_provider_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
customer_id | Unknown | PKFK |
field_id | Unknown | |
field_value | Unknown | |
provider_name | Unknown |
customer_entity_identifier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
scheme | Unknown | |
standard | Unknown | |
value | Unknown |
customer_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
customer_id | Unknown | PKFK |
value | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
backup_payment_source_id | Unknown | FK |
primary_payment_source_id | Unknown | FK |
allow_direct_debit | Unknown | |
auto_close_invoices | Unknown | |
auto_collection | Unknown | |
billing_address_city | Unknown | |
billing_address_company | Unknown | |
billing_address_country | Unknown | |
billing_address_email | Unknown | |
billing_address_first_name | Unknown | |
billing_address_last_name | Unknown | |
billing_address_line_1 | Unknown | |
billing_address_line_2 | Unknown | |
billing_address_line_3 | Unknown | |
billing_address_object | Unknown | |
billing_address_phone | Unknown | |
billing_address_state | Unknown | |
billing_address_state_code | Unknown | |
billing_address_validation_status | Unknown | |
billing_address_zip | Unknown | |
billing_date | Unknown | |
billing_date_mode | Unknown | |
billing_day_of_week | Unknown | |
billing_day_of_week_mode | Unknown | |
billing_month | Unknown | |
business_customer_without_vat_number | Unknown | |
business_entity_id | Unknown | |
channel | Unknown | |
child_account_access_portal_download_invoices | Unknown | |
child_account_access_portal_edit_subscriptions | Unknown | |
child_account_access_send_invoice_emails | Unknown | |
child_account_access_send_payment_emails | Unknown | |
child_account_access_send_subscription_emails | Unknown | |
client_profile_id | Unknown | |
company | Unknown | |
consolidated_invoicing | Unknown | |
created_at | Unknown | |
created_from_ip | Unknown | |
customer_type | Unknown | |
deleted | Unknown | |
einvoicing_method | Unknown | |
email | Unknown | |
entity_code | Unknown | |
entity_identifier_scheme | Unknown | |
entity_identifier_standard | Unknown | |
excess_payments | Unknown | |
exempt_number | Unknown | |
exemption_details | Unknown | |
first_name | Unknown | |
fraud_flag | Unknown | |
invoice_notes | Unknown | |
is_einvoice_enabled | Unknown | |
is_location_valid | Unknown | |
last_name | Unknown | |
locale | Unknown | |
net_term_days | Unknown | |
offline_payment_method | Unknown | |
parent_account_access_portal_download_child_invoices | Unknown | |
parent_account_access_portal_edit_child_subscriptions | Unknown | |
parent_account_access_send_invoice_emails | Unknown | |
parent_account_access_send_payment_emails | Unknown | |
parent_account_access_send_subscription_emails | Unknown | |
phone | Unknown | |
pii_cleared | Unknown | |
preferred_currency_code | Unknown | |
promotional_credits | Unknown | |
refundable_credits | Unknown | |
registered_for_gst | Unknown | |
relationship_invoice_owner_id | Unknown | |
relationship_parent_id | Unknown | |
relationship_payment_owner_id | Unknown | |
resource_version | Unknown | |
taxability | Unknown | |
unbilled_charges | Unknown | |
updated_at | Unknown | |
use_default_hierarchy_settings | Unknown | |
vat_number | Unknown | |
vat_number_prefix | Unknown | |
vat_number_status | Unknown | |
vat_number_validated_time | Unknown | |
meta_data_** |