Invoiced

Explore the interactive ERD

Table & Field Reference

payment

Column	Type	Keys
`id`	Unknown	PK
`charge_customer_id`	Unknown	FK
`charge_payment_source_customer_id`	Unknown	FK
`customer_id`	Unknown	FK
`ach_sender_id`	Unknown
`amount`	Unknown
`applied_to`	Json
`balance`	Unknown
`charge_amount`	Unknown
`charge_amount_refunded`	Unknown
`charge_created_at`	Unknown
`charge_currency`	Unknown
`charge_disputed`	Unknown
`charge_failure_message`	Unknown
`charge_gateway`	Unknown
`charge_gateway_id`	Unknown
`charge_id`	Unknown
`charge_payment_source_account_holder_name`	Unknown
`charge_payment_source_account_holder_type`	Unknown
`charge_payment_source_bank_name`	Unknown
`charge_payment_source_chargeable`	Unknown
`charge_payment_source_country`	Unknown
`charge_payment_source_created_at`	Unknown
`charge_payment_source_currency`	Unknown
`charge_payment_source_failure_reason`	Unknown
`charge_payment_source_gateway`	Unknown
`charge_payment_source_gateway_customer`	Unknown
`charge_payment_source_gateway_id`	Unknown
`charge_payment_source_id`	Unknown
`charge_payment_source_last_4_card_digits`	Unknown
`charge_payment_source_merchant_account`	Unknown
`charge_payment_source_receipt_email`	Unknown
`charge_payment_source_routing_number`	Unknown
`charge_payment_source_type`	Unknown
`charge_payment_source_updated_at`	Unknown
`charge_payment_source_verified`	Unknown
`charge_receipt_email`	Unknown
`charge_refund`	Json
`charge_refunded`	Unknown
`charge_status`	Unknown
`charge_updated_at`	Unknown
`created_at`	Unknown
`currency`	Unknown
`date`	Unknown
`matched`	Unknown
`method`	Unknown
`note`	Unknown
`pdf_url`	Unknown
`reference`	Unknown
`source`	Unknown
`updated_at`	Unknown
`voided`	Unknown
`custom_`

contact

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`address_1`	Unknown
`address_2`	Unknown
`city`	Unknown
`country`	Unknown
`created_at`	Unknown
`department`	Unknown
`email`	Unknown
`is_primary`	Unknown
`name`	Unknown
`phone`	Unknown
`postal_code`	Unknown
`role`	Unknown
`send_new_invoice`	Unknown
`sms_enabled`	Unknown
`state`	Unknown
`title`	Unknown
`updated_at`	Unknown

credit_note_attachment

Column	Type	Keys
`id`	Unknown	PK
`credit_note_id`	Unknown	FK
`created_at`	Unknown
`file_created_at`	Unknown
`file_id`	Unknown
`file_name`	Unknown
`file_size`	Unknown
`file_type`	Unknown
`file_updated_at`	Unknown
`file_url`	Unknown
`updated_at`	Unknown

plan_tier

Column	Type	Keys
`index`	Unknown	PK
`plan_id`	Unknown	PKFK
`max_qty`	Unknown
`min_qty`	Unknown
`unit_cost`	Unknown

plan

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`catalog_item`	Unknown
`created_at`	Unknown
`currency`	Unknown
`interval`	Unknown
`interval_count`	Unknown
`name`	Unknown
`pricing_mode`	Unknown
`quantity_type`	Unknown
`updated_at`	Unknown
`custom_`

credit_balance_adjustment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`currency`	Unknown
`date`	Unknown
`note`	Unknown
`updated_at`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`timestamps`	Unknown
`type`	Unknown
`custom_`
`previous_`
`user_`

note

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`created_at`	Unknown
`note`	Unknown
`updated_at`	Instant
`user_created_at`	Unknown
`user_email`	Unknown
`user_first_name`	Unknown
`user_id`	Unknown
`user_last_name`	Unknown
`user_registered`	Unknown
`user_two_factor_enabled`	Unknown
`user_updated_at`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`parent_customer`	Unknown	FK
`payment_source_id`	Unknown	FK
`ach_gateway`	Unknown
`ach_gateway_id`	Unknown
`active`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`attention_to`	Unknown
`autopay`	Unknown
`autopay_delay_days`	Unknown
`avalara_entity_use_code`	Unknown
`avalara_exemption_number`	Unknown
`bill_to_parent`	Unknown
`cc_gateway`	Unknown
`cc_gateway_id`	Unknown
`chase`	Unknown
`chasing_cadence`	Unknown
`city`	Unknown
`consolidated`	Unknown
`convenience_fee`	Unknown
`country`	Unknown
`created_at`	Unknown
`credit_hold`	Unknown
`credit_limit`	Unknown
`currency`	Unknown
`email`	Unknown
`languages`	Unknown
`late_fee_schedule`	Unknown
`late_fee_schedule_id`	Unknown
`name`	Unknown
`network_connection`	Unknown
`network_connection_id`	Unknown
`next_chase_step`	Unknown
`note`	Unknown
`number`	Unknown
`owner`	Unknown
`payment_term`	Unknown
`phone`	Unknown
`postal_code`	Unknown
`sign_up_page`	Unknown
`sign_up_url`	Unknown
`state`	Unknown
`statement_pdf_url`	Unknown
`statement_url`	Unknown
`tax`	Json
`tax_id`	Unknown
`taxable`	Unknown
`type`	Unknown
`updated_at`	Unknown
`custom_`

current_balance_history

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`balance`	Unknown
`currency`	Unknown
`timestamps`	Unknown

current_balance

Column	Type	Keys
`_fivetran_id`	String	PK
`customer_id`	Unknown	FK
`available_credit`	Unknown
`currency`	Unknown
`due_now`	Unknown
`open_credit_note`	Unknown
`past_due`	Unknown
`total_outstanding`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`action`	Unknown
`chase_step_id`	Unknown
`complete`	Unknown
`completed_by_user_id`	Unknown
`completed_date`	Unknown
`created_at`	Unknown
`due_date`	Unknown
`name`	Unknown
`updated_at`	Instant
`user_id`	Unknown

payment_plan_installment

Column	Type	Keys
`id`	Unknown	PK
`payment_plan_id`	Unknown	PKFK
`amount`	Unknown
`balance`	Unknown
`date`	Unknown

payment_plan

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	FK
`approval_id`	Unknown
`approval_ip`	Unknown
`approval_timestamps`	Unknown
`approval_user_agent`	Unknown
`created_at`	Unknown
`status`	Unknown
`updated_at`	Unknown

estimate_attachment

Column	Type	Keys
`id`	Unknown	PK
`estimate_id`	Unknown	FK
`created_at`	Unknown
`file_created_at`	Unknown
`file_id`	Unknown
`file_name`	Unknown
`file_size`	Unknown
`file_type`	Unknown
`file_updated_at`	Unknown
`file_url`	Unknown
`updated_at`	Unknown

subscription_addon

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`created_at`	Unknown
`description`	Unknown
`plan`	Unknown
`quantity`	Unknown
`updated_at`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`plan_id`	Unknown	FK
`bill_in`	Unknown
`bill_in_advance_day`	Unknown
`cancel_at_period_end`	Unknown
`canceled_at`	Unknown
`contract_period_end`	Unknown
`contract_period_start`	Unknown
`contract_renewal_cycle`	Unknown
`contract_renewal_mode`	Unknown
`created_at`	Unknown
`cycle`	Unknown
`discount`	Json
`mrr`	Unknown
`paused`	Unknown
`period_end`	Unknown
`period_start`	Unknown
`quantity`	Unknown
`recurring_total`	Unknown
`ship_to`	Json
`start_date`	Unknown
`status`	Unknown
`taxes`	Json
`updated_at`	Unknown
`url`	Unknown
`custom_`

pending_line_item

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`amount`	Unknown
`catalog_item`	Unknown
`description`	Unknown
`discount`	Json
`discountable`	Unknown
`metadata`	Json
`name`	Unknown
`quantity`	Unknown
`taxable`	Unknown
`taxes`	Json
`type`	Unknown
`unit_cost`	Unknown
`updated_at`	Unknown

invoice_item

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`amount`	Unknown
`catalog_item`	Unknown
`created_at`	Unknown
`description`	Unknown
`discount`	Json
`discountable`	Unknown
`plan_id`	Unknown
`quantity`	Unknown
`taxable`	Unknown
`taxes`	Json
`type`	Unknown
`unit_cost`	Unknown
`updated_at`	Unknown
`custom_`

invoice_tax

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`amount`	Unknown
`tax_rate`	Json
`updated_at`	Unknown

invoice_discount

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`amount`	Unknown
`coupon`	Json
`expire`	Unknown
`from_payment_term`	Unknown
`updated_at`	Unknown

invoice_shipping

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`address_1`	Unknown
`address_2`	Unknown
`attention_to`	Unknown
`city`	Unknown
`country`	Unknown
`created_at`	Unknown
`name`	Unknown
`postal_code`	Unknown
`state`	Unknown
`updated_at`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`payment_plan_id`	Unknown	FK
`subscription_id`	Unknown	FK
`attempt_count`	Unknown
`autopay`	Unknown
`balance`	Unknown
`chase`	Unknown
`closed`	Unknown
`created_at`	Unknown
`csv_url`	Unknown
`currency`	Unknown
`date`	Unknown
`draft`	Unknown
`due_date`	Unknown
`late_fees`	Unknown
`name`	Unknown
`needs_attention`	Unknown
`network_document`	Unknown
`network_document_id`	Unknown
`next_chase_on`	Unknown
`next_payment_attempt`	Unknown
`note`	Unknown
`number`	Unknown
`paid`	Unknown
`payment_source`	Unknown
`payment_term`	Unknown
`payment_url`	Unknown
`pdf_url`	Unknown
`purchase_order`	Unknown
`ship_to_address_1`	Unknown
`ship_to_address_2`	Unknown
`ship_to_attention_to`	Unknown
`ship_to_city`	Unknown
`ship_to_country`	Unknown
`ship_to_created_at`	Unknown
`ship_to_name`	Unknown
`ship_to_postal_code`	Unknown
`ship_to_state`	Unknown
`ship_to_updated_at`	Unknown
`status`	Unknown
`subscription`	Unknown
`subtotal`	Unknown
`total`	Unknown
`updated_at`	Unknown
`url`	Unknown
`custom_`

invoice_attachment

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	FK
`created_at`	Unknown
`file_created_at`	Unknown
`file_id`	Unknown
`file_name`	Unknown
`file_size`	Unknown
`file_type`	Unknown
`file_updated_at`	Unknown
`file_url`	Unknown
`updated_at`	Unknown

payment_source

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`bank_name`	Unknown
`brand`	Unknown
`currency`	Unknown
`expiry_month`	Unknown
`expiry_year`	Unknown
`funding`	Unknown
`last_4_card_digits`	Unknown
`object`	Unknown
`routing_number`	Unknown
`updated_at`	Unknown
`verified`	Unknown

item

Column	Type	Keys
`id`	Unknown	PK
`avalara_location_code`	Unknown
`avalara_tax_code`	Unknown
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`discountable`	Unknown
`gl_account`	Unknown
`name`	Unknown
`taxable`	Unknown
`type`	Unknown
`unit_cost`	Unknown
`updated_at`	Unknown
`custom_`

coupon

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`currency`	Unknown
`duration`	Unknown
`exclusive`	Unknown
`expiration_date`	Unknown
`is_percent`	Unknown
`max_redemption`	Unknown
`name`	Unknown
`updated_at`	Unknown
`value`	Unknown
`custom_`

tax_rate

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`currency`	Unknown
`inclusive`	Unknown
`is_percent`	Unknown
`name`	Unknown
`updated_at`	Unknown
`value`	Unknown
`custom_`

credit_note_item

Column	Type	Keys
`id`	Unknown	PK
`credit_note_id`	Unknown	PKFK
`amount`	Unknown
`catalog_item`	Unknown
`created_at`	Unknown
`description`	Unknown
`discount`	Json
`discountable`	Unknown
`name`	Unknown
`quantity`	Unknown
`taxable`	Unknown
`taxes`	Json
`type`	Unknown
`unit_cost`	Unknown
`updated_at`	Unknown
`custom_`

credit_note_tax

Column	Type	Keys
`id`	Unknown	PK
`credit_note_id`	Unknown	PKFK
`amount`	Unknown
`tax_rate`	Json

credit_note

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`balance`	Unknown
`closed`	Unknown
`created_at`	Unknown
`currency`	Unknown
`date`	Unknown
`discount`	Json
`draft`	Unknown
`name`	Unknown
`network_document`	Unknown
`network_document_id`	Unknown
`note`	Unknown
`number`	Unknown
`paid`	Unknown
`pdf_url`	Unknown
`purchase_order`	Unknown
`shipping`	Json
`status`	Unknown
`subtotal`	Unknown
`total`	Unknown
`updated_at`	Unknown
`url`	Unknown
`custom_`

estimate_item

Column	Type	Keys
`id`	Unknown	PK
`estimate_id`	Unknown	PKFK
`amount`	Unknown
`catalog_item`	Unknown
`created_at`	Unknown
`description`	Unknown
`discount`	Json
`discountable`	Unknown
`name`	Unknown
`quantity`	Unknown
`taxable`	Unknown
`type`	Unknown
`unit_cost`	Unknown
`updated_at`	Unknown
`custom_`

estimate_tax

Column	Type	Keys
`id`	Unknown	PK
`estimate_id`	Unknown	PKFK
`amount`	Unknown
`tax_rate`	Json

estimate

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`approval`	Unknown
`approved`	Unknown
`closed`	Unknown
`created_at`	Unknown
`currency`	Unknown
`date`	Unknown
`deposit`	Unknown
`deposit_paid`	Unknown
`discount`	Json
`draft`	Unknown
`expiration_date`	Unknown
`name`	Unknown
`network_document`	Unknown
`network_document_id`	Unknown
`note`	Unknown
`number`	Unknown
`payment_terms`	Unknown
`pdf_url`	Unknown
`purchase_order`	Unknown
`ship_to`	Json
`shipping`	Json
`status`	Unknown
`subtotal`	Unknown
`total`	Unknown
`updated_at`	Unknown
`url`	Unknown
`custom_`