# Zoho Books schema ERD

Table and field reference for the Fivetran Zoho Books connector.

## 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 | PK, FK |

### 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 |  |

### journal_line_item_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | Unknown | PK |
| journal_id | Unknown | PK, FK |
| journal_line_item_id | Unknown | PK, FK |
| tag_option_id | Unknown |  |

### journal_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| customer_id | Unknown | FK |
| project_id | Unknown | FK |
| tax_id | Unknown | FK |
| account_name | Unknown |  |
| acquisition_vat_amount | Unknown |  |
| acquisition_vat_id | Unknown |  |
| acquisition_vat_name | Unknown |  |
| acquisition_vat_percentage | Unknown |  |
| amount | Unknown |  |
| bcy_amount | Unknown |  |
| customer_name | Unknown |  |
| debit_or_credit | Unknown |  |
| description | Unknown |  |
| location_id | Unknown |  |
| location_name | Unknown |  |
| reverse_charge_vat_amount | Unknown |  |
| reverse_charge_vat_id | Unknown |  |
| reverse_charge_vat_name | Unknown |  |
| reverse_charge_vat_percentage | Unknown |  |

### credit_note_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| credit_note_id | Unknown | PK, FK |
| credit_note_line_item_id | Unknown | PK, FK |
| tax_id | Unknown | PK, FK |
| tax_amount | Unknown |  |

### credit_note_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| 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 | PK, FK |
| invoice_id | Unknown | PK, FK |
| 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 | PK, FK |
| invoice_number | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |

### invoice_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | Unknown | PK, FK |
| invoice_line_item_id | Unknown | PK, FK |
| tax_id | Unknown | PK, FK |
| tax_amount | Unknown |  |

### invoice_line_item_warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_line_item_id | Unknown | PK, FK |
| warehouse_name | Unknown |  |
| warehouse_stock_on_hand | Unknown |  |

### invoice_line_item_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_line_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- project(customer_id) → contact(id)
- chart_of_account_document(chart_of_account_id) → chart_of_account(id)
- chart_of_account(parent_account_id) → chart_of_account(id)
- journal_line_item_tag(journal_id) → journal_line_item(journal_id)
- journal_line_item_tag(journal_line_item_id) → journal_line_item(id)
- journal_line_item(tax_id) → tax(id)
- journal_line_item(customer_id) → contact(id)
- journal_line_item(project_id) → project(id)
- journal_line_item(account_id) → chart_of_account(id)
- journal_line_item(journal_id) → journal_list(id)
- credit_note_line_item_tax(tax_id) → tax(id)
- credit_note_line_item_tax(credit_note_line_item_id) → credit_note_line_item(id)
- credit_note_line_item_tax(credit_note_id) → credit_note(id)
- credit_note_line_item(tax_id) → tax(id)
- credit_note_line_item(invoice_id) → invoice(id)
- credit_note_line_item(project_id) → project(id)
- credit_note_line_item(account_id) → chart_of_account(id)
- credit_note_line_item(credit_note_id) → credit_note(id)
- credit_note_invoice(invoice_id) → invoice(id)
- credit_note_invoice(credit_note_id) → credit_note(id)
- credit_note(currency_id) → currency(id)
- credit_note(invoice_id) → invoice(id)
- credit_note(customer_id) → contact(id)
- credit_note_address(credit_note_id) → credit_note(id)
- customer_payment_invoice(invoice_number) → invoice(invoice_number)
- customer_payment_invoice(customer_payment_id) → customer_payment(id)
- customer_payment(customer_id) → contact(id)
- customer_payment(account_id) → chart_of_account(id)
- contact_person(contact_id) → contact(id)
- default_template(contact_id) → contact(id)
- contact(currency_id) → currency(id)
- contact(tax_id) → tax(id)
- contact_address(contact_id) → contact(id)
- estimate(currency_id) → currency(id)
- estimate(customer_id) → contact(id)
- credit_note_refund(credit_note_id) → credit_note(id)
- journal_list(currency_id) → currency(id)
- item(tax_id) → tax(id)
- bill(currency_id) → currency(id)
- expense(currency_id) → currency(id)
- expense(customer_id) → contact(id)
- time_entry(user_id) → users(id)
- time_entry(invoice_id) → invoice(id)
- time_entry(customer_id) → contact(id)
- time_entry(project_id) → project(id)
- purchase_order(currency_id) → currency(id)
- invoice_contact_person(invoice_id) → invoice(id)
- invoice_line_item_tax(tax_id) → tax(id)
- invoice_line_item_tax(invoice_line_item_id) → invoice_line_item(id)
- invoice_line_item_tax(invoice_id) → invoice_line_item(invoice_id)
- invoice_line_item_warehouse(invoice_line_item_id) → invoice_line_item(id)
- invoice_line_item_warehouse(invoice_id) → invoice_line_item(invoice_id)
- invoice_line_item_tag(invoice_line_item_id) → invoice_line_item(id)
- invoice_line_item_tag(invoice_id) → invoice_line_item(invoice_id)
- invoice_line_item(tax_id) → tax(id)
- invoice_line_item(project_id) → project(id)
- invoice_line_item(account_id) → chart_of_account(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_payment_gateway(invoice_id) → invoice(id)
- invoice(currency_id) → currency(id)
- invoice(sales_order_id) → sales_order(id)
- invoice(customer_id) → contact(id)
- invoice(estimate_id) → estimate(id)
- invoice_address(invoice_id) → invoice(id)
- sales_order(currency_id) → currency(id)
- sales_order(customer_id) → contact(id)