Zoho Books

Explore the interactive ERD

Table & Field Reference

project

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`billable_hour`	Unknown
`billing_type`	Unknown
`created_time`	Unknown
`customer_name`	Unknown
`description`	Unknown
`has_attachment`	Unknown
`project_name`	Unknown
`rate`	Unknown
`status`	Unknown
`total_hour`	Unknown

chart_of_account_document

Column	Type	Keys
`document`	Unknown	PK
`chart_of_account_id`	Unknown	PKFK

chart_of_account

Column	Type	Keys
`id`	Unknown	PK
`parent_account_id`	Unknown	FK
`account_code`	Unknown
`account_name`	Unknown
`account_type`	Unknown
`can_show_in_ze`	Unknown
`child_count`	Unknown
`created_time`	Unknown
`current_balance`	Unknown
`depth`	Unknown
`has_attachment`	Unknown
`is_active`	Unknown
`is_child_present`	Unknown
`is_involved_in_transaction`	Unknown
`is_standalone_account`	Unknown
`is_system_account`	Unknown
`is_user_created`	Unknown
`last_modified_time`	Unknown
`parent_account_name`	Unknown

credit_note_line_item_tax

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`credit_note_line_item_id`	Unknown	PKFK
`tax_id`	Unknown	PKFK
`tax_amount`	Unknown

credit_note_line_item

Column	Type	Keys
`id`	Unknown	PK
`credit_note_id`	Unknown	PKFK
`account_id`	Unknown	FK
`invoice_id`	Unknown	FK
`project_id`	Unknown	FK
`tax_id`	Unknown	FK
`account_name`	Unknown
`bcy_rate`	Unknown
`code`	Unknown
`description`	Unknown
`discount`	Unknown
`discount_amount`	Unknown
`image_document_id`	Unknown
`invoice_item_id`	Unknown
`item_id`	Unknown
`item_order`	Unknown
`item_total`	Unknown
`item_type`	Unknown
`name`	Unknown
`pricebook_id`	Unknown
`product_type`	Unknown
`project_name`	Unknown
`quantity`	Unknown
`rate`	Unknown
`serial_number`	Unknown
`sku`	Unknown
`tags`	Json
`tax_name`	Unknown
`tax_percentage`	Unknown
`tax_treatment_code`	Unknown
`tax_type`	Unknown
`type`	Unknown
`unit`	Unknown
`warehouse_id`	Unknown
`warehouse_name`	Unknown

credit_note_invoice

Column	Type	Keys
`credit_note_invoice_id`	Unknown	PK
`credit_note_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK
`credit_note_invoice_credited_amount`	Unknown
`credit_note_invoice_date`	Unknown

credit_note

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`adjustment`	Unknown
`adjustment_description`	Unknown
`approver_id`	Unknown
`approvers_list`	Json
`balance`	Unknown
`bcy_shipping_charge_tax`	Unknown
`branch_id`	Unknown
`branch_name`	Unknown
`cfdi_reference_type`	Unknown
`cfdi_usage`	Unknown
`client_viewed_time`	Unknown
`color_code`	Unknown
`created_by_id`	Unknown
`created_time`	Unknown
`credit_note_number`	Unknown
`current_sub_status`	Unknown
`current_sub_status_id`	Unknown
`date`	Unknown
`discount`	Unknown
`discount_applied_on_amount`	Unknown
`discount_type`	Unknown
`document`	Json
`email`	Unknown
`exchange_rate`	Unknown
`gst_no`	Unknown
`gst_treatment`	Unknown
`is_child_present`	Unknown
`is_discount_before_tax`	Unknown
`is_emailed`	Unknown
`is_inclusive_tax`	Unknown
`is_pre_gst`	Unknown
`is_viewed_by_client`	Unknown
`last_modified_by_id`	Unknown
`last_modified_time`	Unknown
`lock_detail`	Json
`note`	Unknown
`orientation`	Unknown
`page_height`	Unknown
`page_width`	Unknown
`place_of_supply`	Unknown
`price_precision`	Unknown
`reference_number`	Unknown
`roundoff_value`	Unknown
`salesperson_id`	Unknown
`salesperson_name`	Unknown
`shipping_charge`	Unknown
`shipping_charge_exclusive_of_tax`	Unknown
`shipping_charge_exclusive_of_tax_formatted`	Unknown
`shipping_charge_inclusive_of_tax`	Unknown
`shipping_charge_inclusive_of_tax_formatted`	Unknown
`shipping_charge_tax`	Unknown
`shipping_charge_tax_formatted`	Unknown
`shipping_charge_tax_id`	Unknown
`shipping_charge_tax_name`	Unknown
`shipping_charge_tax_percentage`	Unknown
`shipping_charge_tax_type`	Unknown
`status`	Unknown
`sub_status`	Unknown
`sub_total`	Unknown
`sub_total_inclusive_of_tax`	Unknown
`subject_content`	Unknown
`submitted_by`	Unknown
`submitted_by_email`	Unknown
`submitted_by_name`	Unknown
`submitted_by_photo_url`	Unknown
`submitted_date`	Unknown
`submitter_id`	Unknown
`tax_override_preference`	Unknown
`tax_rounding`	Unknown
`tax_total`	Unknown
`tax_treatment`	Unknown
`template_id`	Unknown
`template_name`	Unknown
`template_type`	Unknown
`term`	Unknown
`total`	Unknown
`total_credits_used`	Unknown
`total_refunded_amount`	Unknown
`transaction_rounding_type`	Unknown
`updated_time`	Unknown
`vat_reg_no`	Unknown
`vat_treatment`	Unknown
`custom_`

credit_note_address

Column	Type	Keys
`_fivetran_id`	String	PK
`credit_note_id`	Unknown	FK
`address`	Unknown
`address_type`	Unknown
`attention`	Unknown
`city`	Unknown
`country`	Unknown
`fax`	Unknown
`state`	Unknown
`street_2`	Unknown
`zip`	Unknown

customer_payment_invoice

Column	Type	Keys
`customer_payment_id`	Unknown	PKFK
`invoice_number`	Unknown	PKFK

customer_payment

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`customer_id`	Unknown	FK
`account_name`	Unknown
`amount`	Unknown
`applied_invoices`	Json
`bcy_amount`	Unknown
`bcy_refunded_amount`	Unknown
`bcy_unused_amount`	Unknown
`branch_id`	Unknown
`branch_name`	Unknown
`created_time`	Unknown
`custom_fields_list`	Unknown
`customer_name`	Unknown
`date`	Unknown
`description`	Unknown
`documents`	Unknown
`gateway_transaction_id`	Unknown
`has_attachment`	Unknown
`last_four_digits`	Unknown
`last_modified_time`	Instant
`payment_gateway`	Unknown
`payment_mode`	Unknown
`payment_mode_formatted`	Unknown
`payment_number`	Unknown
`payment_type`	Unknown
`reference_number`	Unknown
`settlement_status`	Unknown
`tax_account_id`	Unknown
`tax_account_name`	Unknown
`tax_amount_withheld`	Unknown
`unused_amount`	Unknown

contact_person

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`department`	Unknown
`designation`	Unknown
`email`	Unknown
`enable_portal`	Unknown
`first_name`	Unknown
`is_primary_contact`	Unknown
`last_name`	Unknown
`mobile`	Unknown
`phone`	Unknown
`salutation`	Unknown
`skype`	Unknown

default_template

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`bill_template_id`	Unknown
`bill_template_name`	Unknown
`creditnote_email_template_id`	Unknown
`creditnote_email_template_name`	Unknown
`creditnote_template_id`	Unknown
`creditnote_template_name`	Unknown
`estimate_email_template_id`	Unknown
`estimate_email_template_name`	Unknown
`estimate_template_id`	Unknown
`estimate_template_name`	Unknown
`invoice_email_template_id`	Unknown
`invoice_email_template_name`	Unknown
`invoice_template_id`	Unknown
`invoice_template_name`	Unknown
`payment_remittance_email_template_id`	Unknown
`payment_remittance_email_template_name`	Unknown
`paymentthankyou_email_template_id`	Unknown
`paymentthankyou_email_template_name`	Unknown
`paymentthankyou_template_id`	Unknown
`paymentthankyou_template_name`	Unknown
`purchaseorder_email_template_id`	Unknown
`purchaseorder_template_id`	Unknown
`retainer_invoice_email_template_id`	Unknown
`retainer_invoice_paymentthankyou_email_template_id`	Unknown
`retainer_invoice_paymentthankyou_template_id`	Unknown
`retainer_invoice_template_id`	Unknown
`salesorder_email_template_id`	Unknown
`salesorder_template_id`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`tax_id`	Unknown	FK
`ach_supported`	Unknown
`address`	Json
`allow_parent_for_payment_and_view`	Unknown
`associated_with_square`	Unknown
`bank_account`	Json
`branch_id`	Unknown
`branch_name`	Unknown
`can_show_customer_ob`	Unknown
`can_show_vendor_ob`	Unknown
`card`	Json
`checks`	Json
`company_name`	Unknown
`consent_date`	Unknown
`contact_category`	Unknown
`contact_name`	Unknown
`contact_salutation`	Unknown
`contact_type`	Unknown
`contact_type_formatted`	Unknown
`created_by_name`	Unknown
`created_date`	Unknown
`created_time`	Unknown
`created_time_formatted`	Unknown
`credit_limit`	Unknown
`credit_limit_exceeded_amount`	Unknown
`crm_owner_id`	Unknown
`currency_code`	Unknown
`currency_symbol`	Unknown
`customer_sub_type`	Unknown
`department`	Unknown
`designation`	Unknown
`document`	Json
`email`	Unknown
`entity_address_id`	Unknown
`exchange_rate`	Unknown
`facebook`	Unknown
`first_name`	Unknown
`gst_no`	Unknown
`gst_treatment`	Unknown
`has_attachment`	Unknown
`has_transaction`	Unknown
`is_bcy_only_contact`	Unknown
`is_client_review_asked`	Unknown
`is_client_review_settings_enabled`	Unknown
`is_consent_agreed`	Unknown
`is_credit_limit_migration_completed`	Unknown
`is_crm_customer`	Unknown
`is_linked_with_zohocrm`	Unknown
`is_sms_enabled`	Unknown
`is_taxable`	Unknown
`is_tds_registered`	Unknown
`is_whatsapp_enabled`	Unknown
`language_code`	Unknown
`language_code_formatted`	Unknown
`last_modified_time`	Unknown
`last_modified_time_formatted`	Unknown
`last_name`	Unknown
`mobile`	Unknown
`notes`	Unknown
`opening_balance`	Json
`opening_balance_amount`	Unknown
`opening_balance_amount_bcy`	Unknown
`outstanding_ob_payable_amount`	Unknown
`outstanding_ob_receivable_amount`	Unknown
`outstanding_payable_amount`	Unknown
`outstanding_payable_amount_bcy`	Unknown
`outstanding_receivable_amount`	Unknown
`outstanding_receivable_amount_bcy`	Unknown
`owner_id`	Unknown
`owner_name`	Unknown
`payment_reminder_enabled`	Unknown
`payment_terms`	Unknown
`payment_terms_label`	Unknown
`phone`	Unknown
`place_of_contact`	Unknown
`portal_receipt_count`	Unknown
`portal_status`	Unknown
`price_precision`	Unknown
`pricebook_id`	Unknown
`pricebook_name`	Unknown
`primary_contact_id`	Unknown
`sales_channel`	Unknown
`source`	Unknown
`status`	Unknown
`tags`	Json
`tax_authority_id`	Unknown
`tax_authority_name`	Unknown
`tax_exemption_code`	Unknown
`tax_exemption_id`	Unknown
`tax_name`	Unknown
`tax_percentage`	Unknown
`tax_regime`	Unknown
`tax_treatment`	Unknown
`twitter`	Unknown
`unused_credits_payable_amount`	Unknown
`unused_credits_payable_amount_bcy`	Unknown
`unused_credits_receivable_amount`	Unknown
`unused_credits_receivable_amount_bcy`	Unknown
`unused_retainer_payments`	Unknown
`vat_treatment`	Unknown
`vendor_name`	Unknown
`vpa_list`	Json
`website`	Unknown
`zcrm_account_id`	Unknown
`zohopeople_client_id`	Unknown
`custom_`

contact_address

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`address`	Unknown
`address_type`	Unknown
`attention`	Unknown
`city`	Unknown
`country`	Unknown
`country_code`	Unknown
`fax`	Unknown
`phone`	Unknown
`state`	Unknown
`state_code`	Unknown
`street_2`	Unknown
`zip`	Unknown

estimate

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`customer_id`	Unknown	FK
`accepted_date`	Unknown
`client_viewed_time`	Unknown
`created_time`	Unknown
`currency_code`	Unknown
`customer_name`	Unknown
`date`	Unknown
`declined_date`	Unknown
`estimate_number`	Unknown
`expiry_date`	Unknown
`has_attachment`	Unknown
`is_viewed_by_client`	Unknown
`last_modified_time`	Unknown
`reference_number`	Unknown
`status`	Unknown
`total`	Unknown

currency

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`effective_date`	Unknown
`exchange_rate`	Unknown
`format`	Unknown
`is_base_currency`	Unknown
`name`	Unknown
`name_formatted`	Unknown
`price_precision`	Unknown
`symbol`	Unknown

credit_note_refund

Column	Type	Keys
`id`	Unknown	PK
`credit_note_id`	Unknown	FK
`amount_bcy`	Unknown
`amount_fcy`	Unknown
`creditnote_number`	Unknown
`customer_name`	Unknown
`date`	Unknown
`description`	Unknown
`reference_number`	Unknown
`refund_mode`	Unknown

journal_list

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`bcy_total`	Unknown
`custom_field`	Unknown
`entity_type`	Unknown
`entry_number`	Unknown
`journal_date`	Unknown
`journal_type`	Unknown
`notes`	Unknown
`reference_number`	Unknown
`total`	Unknown

item

Column	Type	Keys
`id`	Unknown	PK
`tax_id`	Unknown	FK
`description`	Unknown
`name`	Unknown
`product_type`	Unknown
`purchase_tax_rule_id`	Unknown
`rate`	Unknown
`sales_tax_rule_id`	Unknown
`sat_item_key_code`	Unknown
`sku`	Unknown
`status`	Unknown
`unit`	Unknown
`unitkey_code`	Unknown

bill

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`attachment_name`	Unknown
`balance`	Unknown
`bill_number`	Unknown
`created_time`	Unknown
`currency_code`	Unknown
`date`	Unknown
`due_date`	Unknown
`due_day`	Unknown
`exchange_rate`	Unknown
`has_attachment`	Unknown
`is_abn_quoted`	Unknown
`is_tds_applied`	Unknown
`last_modified_time`	Unknown
`price_precision`	Unknown
`reference_number`	Unknown
`status`	Unknown
`total`	Unknown
`vendor_id`	Unknown
`vendor_name`	Unknown

tax

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`authority_id`	Unknown
`authority_name`	Unknown
`factor`	Unknown
`is_default_tax`	Unknown
`is_editable`	Unknown
`is_inactive`	Unknown
`is_value_added`	Unknown
`last_modified_time`	Unknown
`name`	Unknown
`output_tax_account_name`	Unknown
`percentage`	Unknown
`purchase_tax_account_id`	Unknown
`purchase_tax_account_name`	Unknown
`specific_type`	Unknown
`type`	Unknown

expense

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`customer_id`	Unknown	FK
`account_name`	Unknown
`bcy_total`	Unknown
`bcy_total_without_tax`	Unknown
`created_time`	Unknown
`currency_code`	Unknown
`customer_name`	Unknown
`date`	Unknown
`description`	Unknown
`end_reading`	Unknown
`expense_receipt_name`	Unknown
`expense_type`	Unknown
`is_billable`	Unknown
`last_modified_time`	Unknown
`mileage_rate`	Unknown
`mileage_unit`	Unknown
`reference_number`	Unknown
`start_reading`	Unknown
`status`	Unknown
`total`	Unknown
`total_without_tax`	Unknown

time_entry

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`project_id`	Unknown	FK
`user_id`	Unknown	FK
`begin_time`	Unknown
`billed_status`	Unknown
`cost_amount`	Unknown
`cost_rate`	Unknown
`created_time`	Unknown
`customer_name`	Unknown
`end_time`	Unknown
`is_billable`	Unknown
`is_current_user`	Unknown
`log_date`	Unknown
`log_time`	Unknown
`notes`	Unknown
`project_name`	Unknown
`task_id`	Unknown
`task_name`	Unknown
`timer_duration_in_minutes`	Unknown
`timer_started_at`	Unknown
`user_name`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`is_current_user`	Unknown
`is_customer_segmented`	Unknown
`is_vendor_segmented`	Unknown
`name`	Unknown
`photo_url`	Unknown
`role_id`	Unknown
`status`	Unknown
`user_role`	Unknown
`user_type`	Unknown

purchase_order

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`created_time`	Unknown
`currency_code`	Unknown
`date`	Unknown
`delivery_date`	Unknown
`has_attachment`	Unknown
`last_modified_time`	Unknown
`price_precision`	Unknown
`purchaseorder_number`	Unknown
`reference_number`	Unknown
`status`	Unknown
`total`	Unknown
`vendor_id`	Unknown
`vendor_name`	Unknown
`custom_`

invoice_contact_person

Column	Type	Keys
`contact_person_id`	Unknown	PK
`invoice_id`	Unknown	PKFK

invoice_line_item_tax

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`invoice_line_item_id`	Unknown	PKFK
`tax_id`	Unknown	PKFK
`tax_amount`	Unknown

invoice_line_item_warehouse

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`invoice_line_item_id`	Unknown	PKFK
`warehouse_name`	Unknown
`warehouse_stock_on_hand`	Unknown

invoice_line_item_tag

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`invoice_line_item_id`	Unknown	PKFK
`is_tag_mandatory`	Unknown
`tag_name`	Unknown
`tag_option_id`	Unknown
`tag_option_name`	Unknown

invoice_line_item

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`account_id`	Unknown	FK
`project_id`	Unknown	FK
`tax_id`	Unknown	FK
`account_name`	Unknown
`bcy_rate`	Unknown
`bill_id`	Unknown
`bill_item_id`	Unknown
`cost_amount`	Unknown
`description`	Unknown
`discount`	Unknown
`discount_amount`	Unknown
`documents`	Json
`expense_id`	Unknown
`expense_receipt_name`	Unknown
`header_id`	Unknown
`header_name`	Unknown
`image_document_id`	Unknown
`item_custom_field`	Json
`item_id`	Unknown
`item_order`	Unknown
`item_total`	Unknown
`item_type`	Unknown
`name`	Unknown
`pricebook_id`	Unknown
`product_type`	Unknown
`project_name`	Unknown
`purchase_rate`	Unknown
`quantity`	Unknown
`rate`	Unknown
`salesorder_item_id`	Unknown
`sku`	Unknown
`tax_treatment_code`	Unknown
`time_entry_id`	Json
`time_entry_ids`	Json
`unit`	Unknown

invoice_payment_gateway

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`additional_field_1`	Unknown
`configured`	Unknown
`gateway_name`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`customer_id`	Unknown	FK
`estimate_id`	Unknown	FK
`sales_order_id`	Unknown	FK
`ach_payment_initiated`	Unknown
`ach_supported`	Unknown
`adjustment`	Unknown
`adjustment_description`	Unknown
`allow_partial_payments`	Unknown
`approver_id`	Unknown
`approvers_list`	Json
`attachment_name`	Unknown
`balance`	Unknown
`bcy_adjustment`	Unknown
`bcy_discount_total`	Unknown
`bcy_shipping_charge`	Unknown
`bcy_shipping_charge_tax`	Unknown
`bcy_sub_total`	Unknown
`bcy_tax_total`	Unknown
`bcy_total`	Unknown
`branch_id`	Unknown
`branch_name`	Unknown
`can_send_in_mail`	Unknown
`can_send_invoice_sms`	Unknown
`can_send_invoice_whatsapp_notification`	Unknown
`cfdi_usage`	Unknown
`client_viewed_time`	Unknown
`color_code`	Unknown
`computation_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`created_time`	Unknown
`credits_applied`	Unknown
`current_sub_status`	Unknown
`current_sub_status_id`	Unknown
`customer_name`	Unknown
`date`	Unknown
`deliverychallan`	Json
`discount`	Unknown
`discount_applied_on_amount`	Unknown
`discount_percent`	Unknown
`discount_total`	Unknown
`discount_type`	Unknown
`document`	Json
`due_date`	Unknown
`due_day`	Unknown
`ecomm_operator_id`	Unknown
`ecomm_operator_name`	Unknown
`email`	Unknown
`exchange_rate`	Unknown
`gst_no`	Unknown
`gst_treatment`	Unknown
`has_attachment`	Unknown
`includes_package_tracking_info`	Unknown
`inprocess_transaction_present`	Unknown
`invoice_number`	Unknown
`invoice_source`	Unknown
`invoice_url`	Unknown
`is_autobill_enabled`	Unknown
`is_backorder`	Unknown
`is_client_review_settings_enabled`	Unknown
`is_discount_before_tax`	Unknown
`is_emailed`	Unknown
`is_inclusive_tax`	Unknown
`is_pre_gst`	Unknown
`is_viewed_by_client`	Unknown
`last_modified_by_id`	Unknown
`last_modified_time`	Unknown
`last_payment_date`	Unknown
`last_reminder_sent_date`	Unknown
`lock_detail`	Json
`merchant_id`	Unknown
`merchant_name`	Unknown
`next_reminder_date_formatted`	Unknown
`no_of_copies`	Unknown
`notes`	Unknown
`offline_created_date_with_time`	Unknown
`orientation`	Unknown
`page_height`	Unknown
`page_width`	Unknown
`payment_discount`	Unknown
`payment_expected_date`	Unknown
`payment_made`	Unknown
`payment_reminder_enabled`	Unknown
`payment_terms`	Unknown
`payment_terms_label`	Unknown
`place_of_supply`	Unknown
`price_precision`	Unknown
`reader_offline_payment_initiated`	Unknown
`recurring_invoice_id`	Unknown
`reference_number`	Unknown
`reminders_sent`	Unknown
`roundoff_value`	Unknown
`sales_channel`	Unknown
`salesorder`	Json
`salesperson_id`	Unknown
`salesperson_name`	Unknown
`schedule_time`	Unknown
`shipping_bills`	Unknown
`shipping_charge`	Unknown
`shipping_charge_exclusive_of_tax`	Unknown
`shipping_charge_exclusive_of_tax_formatted`	Unknown
`shipping_charge_inclusive_of_tax`	Unknown
`shipping_charge_inclusive_of_tax_formatted`	Unknown
`shipping_charge_tax`	Unknown
`shipping_charge_tax_formatted`	Unknown
`shipping_charge_tax_id`	Unknown
`shipping_charge_tax_name`	Unknown
`shipping_charge_tax_percentage`	Unknown
`shipping_charge_tax_type`	Unknown
`show_no_of_copies`	Unknown
`status`	Unknown
`stop_reminder_until_payment_expected_date`	Unknown
`sub_statuse`	Json
`sub_total`	Unknown
`sub_total_inclusive_of_tax`	Unknown
`subject_content`	Unknown
`submitted_by`	Unknown
`submitted_by_email`	Unknown
`submitted_by_name`	Unknown
`submitted_by_photo_url`	Unknown
`submitted_date`	Unknown
`submitter_id`	Unknown
`tax_amount_withheld`	Unknown
`tax_override_preference`	Unknown
`tax_rounding`	Unknown
`tax_total`	Unknown
`tax_treatment`	Unknown
`template_id`	Unknown
`template_name`	Unknown
`template_type`	Unknown
`terms`	Unknown
`total`	Unknown
`transaction_rounding_type`	Unknown
`unused_retainer_payment`	Json
`vat_reg_no`	Unknown
`vat_treatment`	Unknown
`write_off_amount`	Unknown
`zcrm_potential_id`	Unknown
`zcrm_potential_name`	Unknown
`custom_`

invoice_address

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`address`	Unknown
`address_type`	Unknown
`attention`	Unknown
`city`	Unknown
`country`	Unknown
`fax`	Unknown
`phone`	Unknown
`state`	Unknown
`street`	Unknown
`street_2`	Unknown
`zip`	Unknown

sales_order

Column	Type	Keys
`id`	Unknown	PK
`currency_id`	Unknown	FK
`customer_id`	Unknown	FK
`bcy_total`	Unknown
`created_time`	Unknown
`currency_code`	Unknown
`customer_name`	Unknown
`date`	Unknown
`has_attachment`	Unknown
`is_emailed`	Unknown
`last_modified_time`	Unknown
`reference_number`	Unknown
`salesorder_number`	Unknown
`shipment_date`	Unknown
`shipment_day`	Unknown
`status`	Unknown
`sub_total`	Unknown
`total`	Unknown
`zcrm_potential_id`	Unknown
`zcrm_potential_name`	Unknown
`custom_`