# Zoho Inventory schema ERD

Table and field reference for the Fivetran Zoho Inventory connector.

## Table & Field Reference

### payment_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| amount_applied | Unknown |  |
| balance_amount | Unknown |  |
| date | Unknown |  |
| invoice_amount | Unknown |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| customer_id | Unknown | FK |
| organization_id | String | FK |
| account_id | Unknown |  |
| account_name | Unknown |  |
| amount | Unknown |  |
| amount_refunded | Unknown |  |
| bank_charges | Unknown |  |
| bcy_amount | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| email | Unknown |  |
| exchange_rate | Unknown |  |
| invoice_number | Unknown |  |
| last_four_digits | Unknown |  |
| number | Unknown |  |
| payment_mode | Unknown |  |
| reference_number | Unknown |  |
| 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 |  |
| first_name | Unknown |  |
| is_primary_contact | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| phone | Unknown |  |
| salutation | Unknown |  |
| skype | Unknown |  |

### contact_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| address | Unknown |  |
| attention | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| fax | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| street_2 | Unknown |  |
| zip | Unknown |  |

### contact_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| address | Unknown |  |
| attention | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| fax | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| street_2 | Unknown |  |
| zip | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| organization_id | String | FK |
| pricebook_id | Unknown | FK |
| ach_supported | Unknown |  |
| allow_parent_for_payment_and_view | Unknown |  |
| associated_with_square | Unknown |  |
| can_show_customer_ob | Unknown |  |
| can_show_vendor_ob | Unknown |  |
| category | Unknown |  |
| company_name | Unknown |  |
| consent_date | Unknown |  |
| created_by_name | Unknown |  |
| created_date | Unknown |  |
| created_time | Unknown |  |
| credit_limit_exceeded_amount | Unknown |  |
| crm_owner_id | Unknown |  |
| customer_sub_type | Unknown |  |
| department | Unknown |  |
| designation | Unknown |  |
| email | Unknown |  |
| entity_address_id | Unknown |  |
| exchange_rate | Unknown |  |
| facebook | Unknown |  |
| first_name | Unknown |  |
| has_transaction | Unknown |  |
| invited_by | 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 |  |
| language_code | Unknown |  |
| language_code_formatted | Unknown |  |
| last_modified_time | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| 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 |  |
| portal_receipt_count | Unknown |  |
| portal_status | Unknown |  |
| price_precision | Unknown |  |
| primary_contact_id | Unknown |  |
| sales_channel | Unknown |  |
| sales_region_id | Unknown |  |
| sales_region_name | Unknown |  |
| salutation | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| twitter | Unknown |  |
| type | 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 |  |
| website | Unknown |  |
| zcrm_account_id | Unknown |  |
| zcrm_contact_id | Unknown |  |
| zohopeople_client_id | Unknown |  |
| unknown_** |  |  |

### tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | String | FK |
| account_id | Unknown |  |
| authority_id | Unknown |  |
| authority_name | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| factor | Unknown |  |
| is_default_tax | Unknown |  |
| is_editable | Unknown |  |
| is_value_added | Unknown |  |
| name | Unknown |  |
| output_tax_account_name | Unknown |  |
| percentage | Unknown |  |
| purchase_tax_account_name | Unknown |  |
| purchase_tax_expense_account_id | Unknown |  |
| specific_type | Unknown |  |
| tds_payable_account_id | Unknown |  |
| type | Unknown |  |

### sales_order_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| index | Unknown |  |
| label | Unknown |  |
| value | Unknown |  |

### sales_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| location_id | Unknown | FK |
| tax_id | Unknown | FK |
| bcy_rate | Unknown |  |
| hsn_or_sac | Unknown |  |
| is_invoiced | Unknown |  |
| item_order | Unknown |  |
| item_total | Unknown |  |
| quantity | Unknown |  |
| quantity_invoiced | Unknown |  |
| quantity_packed | Unknown |  |
| quantity_shipped | Unknown |  |
| sat_item_key_code | Unknown |  |
| unitkey_code | Unknown |  |

### sales_order_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |

### sales_order_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### sales_order_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### sales_order_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| attachment_order | Unknown |  |
| can_send_in_mail | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_size_formatted | Unknown |  |
| file_type | Unknown |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| customer_id | Unknown | FK |
| location_id | Unknown | FK |
| organization_id | String | FK |
| pricebook_id | Unknown | FK |
| adjustment | Unknown |  |
| adjustment_description | Unknown |  |
| balance | Unknown |  |
| bcy_total | Unknown |  |
| color_code | Unknown |  |
| company_name | Unknown |  |
| created_time | Unknown |  |
| current_sub_status | Unknown |  |
| current_sub_status_id | Unknown |  |
| date | Unknown |  |
| delivery_date | Unknown |  |
| delivery_method | Unknown |  |
| delivery_method_id | Unknown |  |
| discount | Unknown |  |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |
| due_by_days | Unknown |  |
| due_in_days | Unknown |  |
| email | Unknown |  |
| estimate_id | Unknown |  |
| exchange_rate | Unknown |  |
| gst_no | Unknown |  |
| gst_treatment | Unknown |  |
| has_attachment | Unknown |  |
| invoice_status | Unknown |  |
| is_backorder | Unknown |  |
| is_discount_before_tax | Unknown |  |
| is_drop_shipment | Unknown |  |
| is_emailed | Unknown |  |
| is_manually_fulfilled | Unknown |  |
| is_pre_gst | Unknown |  |
| last_modified_time | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| order_status | Unknown |  |
| paid_status | Unknown |  |
| pickup_location_id | Unknown |  |
| place_of_supply | Unknown |  |
| price_precision | Unknown |  |
| quantity | Unknown |  |
| quantity_invoiced | Unknown |  |
| quantity_packed | Unknown |  |
| quantity_shipped | Unknown |  |
| reference_number | Unknown |  |
| sales_channel | Unknown |  |
| sales_channel_formatted | Unknown |  |
| salesperson_id | Unknown |  |
| salesperson_name | Unknown |  |
| shipment_date | Unknown |  |
| shipment_days | Unknown |  |
| shipped_status | Unknown |  |
| shipping_charge | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| tax_total | Unknown |  |
| template_id | Unknown |  |
| template_name | Unknown |  |
| template_type | Unknown |  |
| terms | Unknown |  |
| total | Unknown |  |
| total_invoiced_amount | Unknown |  |
| zcrm_potential_id | Unknown |  |
| zcrm_potential_name | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| organization_id | String | FK |
| salesorder_id | Unknown | FK |
| created_time | Unknown |  |
| date | Unknown |  |
| email | Unknown |  |
| is_emailed | Unknown |  |
| last_modified_time | Instant |  |
| mobile | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| phone | Unknown |  |
| template_id | Unknown |  |
| template_name | Unknown |  |
| template_type | Unknown |  |
| total_quantity | Unknown |  |

### bill_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bill_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### bill_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | PK, FK |
| value | Unknown |  |

### bill_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| tax_exemption_id | Unknown | FK |
| tax_id | Unknown | FK |
| account_id | Unknown |  |
| account_name | Unknown |  |
| bcy_rate | Unknown |  |
| description | Unknown |  |
| hsn_or_sac | Unknown |  |
| image_id | Unknown |  |
| image_name | Unknown |  |
| image_type | Unknown |  |
| item_order | Unknown |  |
| item_total | Unknown |  |
| name | Unknown |  |
| purchaseorder_item_id | Unknown |  |
| quantity | Unknown |  |
| rate | Unknown |  |
| receive_item_id | Unknown |  |
| reverse_charge_tax_amount | Unknown |  |
| reverse_charge_tax_id | Unknown |  |
| reverse_charge_tax_name | Unknown |  |
| reverse_charge_tax_percentage | Unknown |  |
| tax_exemption_code | Unknown |  |
| tds_tax_id | Unknown |  |
| unit | Unknown |  |

### bill_payment

| Column | Type | Keys |
| --- | --- | --- |
| bill_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### bill_vendor_credit

| Column | Type | Keys |
| --- | --- | --- |
| bill_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| amount | Unknown |  |
| vendor_credit_bill_id | Unknown |  |

### bill_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bill_id | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |

### bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| location_id | Unknown | FK |
| organization_id | String | FK |
| purchaseorder_id | Unknown | FK |
| vendor_id | Unknown | FK |
| attachment_name | Unknown |  |
| balance | Unknown |  |
| client_viewed_time | Unknown |  |
| color_code | Unknown |  |
| created_time | Unknown |  |
| current_sub_status | Unknown |  |
| current_sub_status_id | Unknown |  |
| date | Unknown |  |
| documents | Unknown |  |
| due_date | Unknown |  |
| due_days | Unknown |  |
| entity_type | Unknown |  |
| exchange_rate | Unknown |  |
| has_attachment | Unknown |  |
| is_item_level_tax_calc | Unknown |  |
| is_tally_bill | Unknown |  |
| is_uber_bill | Unknown |  |
| is_viewed_by_client | Unknown |  |
| is_violated | Unknown |  |
| last_modified_time | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| open_purchaseorders_count | Unknown |  |
| price_precision | Unknown |  |
| reference_id | Unknown |  |
| reference_number | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| tax_total | Unknown |  |
| tds_total | Unknown |  |
| terms | Unknown |  |
| total | Unknown |  |
| unprocessed_payment_amount | Unknown |  |
| unused_credits_payable_amount | Unknown |  |
| vendor_credits_applied | Unknown |  |

### tax_exemption

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| description | Unknown |  |
| organization_id | String |  |
| type | Unknown |  |

### invoice_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| label | Unknown |  |
| show_on_pdf | Unknown |  |
| value | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| location_id | Unknown | FK |
| tax_id | Unknown | FK |
| bcy_rate | Unknown |  |
| discount | Unknown |  |
| discount_amount | Unknown |  |
| expense_id | Unknown |  |
| expense_receipt_name | Unknown |  |
| hsn_or_sac | Unknown |  |
| is_invoiced | Unknown |  |
| item_order | Unknown |  |
| item_total | Unknown |  |
| project_id | Unknown |  |
| quantity | Unknown |  |
| quantity_invoiced | Unknown |  |
| quantity_packed | Unknown |  |
| quantity_shipped | Unknown |  |
| sat_item_key_code | Unknown |  |
| time_entry_ids | Unknown |  |
| unitkey_code | Unknown |  |

### invoice_payment_gateway

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| additional_field_1 | Unknown |  |
| configured | Unknown |  |
| gateway_name | Unknown |  |

### invoice_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### invoice_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| customer_id | Unknown | FK |
| location_id | Unknown | FK |
| ach_payment_initiated | Unknown |  |
| adjustment | Unknown |  |
| adjustment_description | Unknown |  |
| allow_partial_payments | Unknown |  |
| attachment_name | Unknown |  |
| balance | Unknown |  |
| can_send_in_mail | Unknown |  |
| cfdi_usage | Unknown |  |
| client_viewed_time | Unknown |  |
| created_time | Unknown |  |
| credits_applied | Unknown |  |
| date | Unknown |  |
| discount | Unknown |  |
| discount_type | Unknown |  |
| documents | Unknown |  |
| due_date | Unknown |  |
| due_days | Unknown |  |
| exchange_rate | Unknown |  |
| gst_no | Unknown |  |
| gst_treatment | Unknown |  |
| has_attachment | Unknown |  |
| invoice_url | Unknown |  |
| is_discount_before_tax | Unknown |  |
| is_emailed | Unknown |  |
| is_inclusive_tax | Unknown |  |
| is_pre_gst | Unknown |  |
| is_viewed_by_client | Unknown |  |
| last_modified_time | Unknown |  |
| last_payment_date | Unknown |  |
| last_reminder_sent_date | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| organization_id | String |  |
| 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 |  |
| recurring_invoice_id | Unknown |  |
| reference_number | Unknown |  |
| reminders_sent | Unknown |  |
| salesperson_id | Unknown |  |
| salesperson_name | Unknown |  |
| schedule_time | Unknown |  |
| shipping_charge | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| tax_amount_withheld | Unknown |  |
| tax_total | Unknown |  |
| tax_treatment | Unknown |  |
| template_id | Unknown |  |
| template_name | Unknown |  |
| terms | Unknown |  |
| total | Unknown |  |
| write_off_amount | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | String | FK |
| tax_id | Unknown | FK |
| account_id | Unknown |  |
| account_name | Unknown |  |
| actual_available_stock | Unknown |  |
| available_stock | Unknown |  |
| brand | Unknown |  |
| created_time | Unknown |  |
| description | Unknown |  |
| dimension_unit | Unknown |  |
| ean | Unknown |  |
| group_id | Unknown |  |
| group_name | Unknown |  |
| has_attachment | Unknown |  |
| height | Unknown |  |
| hsn_or_sac | Unknown |  |
| image_document_id | Unknown |  |
| image_id | Unknown |  |
| image_name | Unknown |  |
| image_type | Unknown |  |
| is_combo_product | Unknown |  |
| is_linked_with_zohocrm | Unknown |  |
| is_returnable | Unknown |  |
| is_taxable | Unknown |  |
| isbn | Unknown |  |
| last_modified_time | Unknown |  |
| length | Unknown |  |
| manufacturer | Unknown |  |
| name | Unknown |  |
| part_number | Unknown |  |
| product_type | Unknown |  |
| purchase_account_id | Unknown |  |
| purchase_account_name | Unknown |  |
| purchase_description | Unknown |  |
| purchase_rate | Unknown |  |
| rate | Unknown |  |
| reorder_level | Unknown |  |
| sat_item_key_code | Unknown |  |
| sku | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| stock_on_hand | Unknown |  |
| type | Unknown |  |
| unit | Unknown |  |
| unitkey_code | Unknown |  |
| upc | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |
| zcrm_product_id | Unknown |  |
| unknown_** |  |  |

### purchase_order_receive

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| number | Unknown |  |

### purchase_order_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| value | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| organization_id | String | FK |
| vendor_id | Unknown | FK |
| billed_status | Unknown |  |
| client_viewed_time | Unknown |  |
| color_code | Unknown |  |
| company_name | Unknown |  |
| created_time | Unknown |  |
| current_sub_status | Unknown |  |
| current_sub_status_id | Unknown |  |
| date | Unknown |  |
| delivery_date | Unknown |  |
| delivery_days | Unknown |  |
| due_by_days | Unknown |  |
| due_in_days | Unknown |  |
| has_attachment | Unknown |  |
| is_backorder | Unknown |  |
| is_drop_shipment | Unknown |  |
| is_po_marked_as_received | Unknown |  |
| is_viewed_by_client | Unknown |  |
| last_modified_time | Unknown |  |
| number | Unknown |  |
| order_status | Unknown |  |
| price_precision | Unknown |  |
| quantity_marked_as_received | Unknown |  |
| quantity_yet_to_receive | Unknown |  |
| received_status | Unknown |  |
| reference_number | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |
| total_ordered_quantity | Unknown |  |
| unknown_** |  |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | String | FK |
| email | Unknown |  |
| is_current_user | Unknown |  |
| is_customer_segmented | Unknown |  |
| is_employee | Unknown |  |
| is_super_admin | Unknown |  |
| is_vendor_segmented | Unknown |  |
| name | Unknown |  |
| photo_url | Unknown |  |
| role | Unknown |  |
| role_id | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### location_associated_series

| Column | Type | Keys |
| --- | --- | --- |
| associated_series_id | Unknown | PK |
| location_id | Unknown | PK, FK |

### location_associated_user

| Column | Type | Keys |
| --- | --- | --- |
| location_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | String | FK |
| parent_location_id | Unknown | FK |
| attention | Unknown |  |
| auto_number_generation_group_id | Unknown |  |
| auto_number_generation_group_name | Unknown |  |
| auto_number_generation_id | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| is_all_users_selected | Unknown |  |
| is_fba_location | Unknown |  |
| is_location_active | Unknown |  |
| is_primary_location | Unknown |  |
| is_storage_location_enabled | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| sales_channels | Json |  |
| shipping_zones | Json |  |
| state | Unknown |  |
| state_code | Unknown |  |
| street_address_1 | Unknown |  |
| street_address_2 | Unknown |  |
| tax_settings_id | Unknown |  |
| total_zones | Unknown |  |
| type | Unknown |  |
| website | Unknown |  |

### transfer_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transfer_order_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| quantity_transfer | Unknown |  |

### transfer_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| from_location_id | Unknown | FK |
| last_modified_by_id | Unknown | FK |
| organization_id | String | FK |
| to_location_id | Unknown | FK |
| created_time | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| from_location_name | Unknown |  |
| last_modified_time | Unknown |  |
| number | Unknown |  |
| quantity_transfer | Unknown |  |
| status | Unknown |  |
| to_location_name | Unknown |  |
| unknown_** |  |  |

### inventory_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| item_id | Unknown | FK |
| last_modified_by_id | Unknown | FK |
| location_id | Unknown | FK |
| organization_id | String | FK |
| created_time | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| last_modified_time | Unknown |  |
| name | Unknown |  |
| quantity_adjusted | Unknown |  |
| reason | Unknown |  |
| reason_id | Unknown |  |
| reference_number | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |
| type | Unknown |  |
| value_adjusted | Unknown |  |
| custom_** |  |  |

### organization_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### organization_org_joined_app_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| org_joined_app_list | Unknown |  |

### organization_app_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| app_list | Unknown |  |

### organization_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| state | Unknown |  |
| street_address_1 | Unknown |  |
| street_address_2 | Unknown |  |
| zip | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| account_created_date | Unknown |  |
| account_created_date_formatted | Unknown |  |
| can_change_timezone | Unknown |  |
| can_sign_invoice | Unknown |  |
| contact_name | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| custom_field_type | Unknown |  |
| digital_signature_mode | Unknown |  |
| email | Unknown |  |
| field_separator | Unknown |  |
| fiscal_year_start_month | Unknown |  |
| is_default_org | Unknown |  |
| is_designated_zone | Unknown |  |
| is_dsign_required | Unknown |  |
| is_free_zone | Unknown |  |
| is_gst_india_version | Unknown |  |
| is_hsn_or_sac_enabled | Unknown |  |
| is_international_trade_enabled | Unknown |  |
| is_invoice_pmt_tds_allowed | Unknown |  |
| is_org_active | Unknown |  |
| is_org_not_supported | Unknown |  |
| is_quick_setup_completed | Unknown |  |
| is_registered_for_gst | Unknown |  |
| is_registered_for_tax | Unknown |  |
| is_sales_inclusive_tax_enabled | Unknown |  |
| is_search_360_enabled | Unknown |  |
| is_sku_enabled | Unknown |  |
| is_solo_org | Unknown |  |
| is_tax_registered | Unknown |  |
| is_trial_period_extended | Unknown |  |
| is_user_dsign_mandatory | Unknown |  |
| is_ziedition | Unknown |  |
| is_zpayroll_grid | Unknown |  |
| language_code | Unknown |  |
| mode | Unknown |  |
| name | Unknown |  |
| org_action | Unknown |  |
| org_created_app_source | Unknown |  |
| org_created_by | Unknown |  |
| org_settings | Unknown |  |
| org_type | Unknown |  |
| partners_domain | Unknown |  |
| phone | Unknown |  |
| plan_name | Unknown |  |
| plan_period | Unknown |  |
| plan_type | Unknown |  |
| price_precision | Unknown |  |
| sales_tax_type | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| tax_group_enabled | Unknown |  |
| time_zone | Unknown |  |
| time_zone_formatted | Unknown |  |
| user_status | Unknown |  |
| user_status_formatted | Unknown |  |
| version | Unknown |  |
| version_formatted | Unknown |  |
| zi_migration_status | Unknown |  |
| zi_zb_client | Unknown |  |
| zi_zb_edition | Unknown |  |
| zoho_one_org | Unknown |  |

### price_book_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| price_book_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| pricebook_rate | Unknown |  |

### price_book

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| organization_id | String | FK |
| decimal_place | Unknown |  |
| description | Unknown |  |
| is_default | Unknown |  |
| is_increase | Unknown |  |
| name | Unknown |  |
| percentage | Unknown |  |
| rounding_type | Unknown |  |
| sales_or_purchase_type | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### sales_return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | String | FK |
| salesorder_id | Unknown | FK |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| date | Unknown |  |
| number | Unknown |  |
| quantity | Unknown |  |
| reason | Unknown |  |
| receive_status | Unknown |  |
| refund_status | Unknown |  |
| refunded_amount | Unknown |  |
| status | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| auto_exchange_rate | Unknown |  |
| code | Unknown |  |
| effective_date | Unknown |  |
| exchange_rate | Unknown |  |
| format | Unknown |  |
| is_base_currency | Unknown |  |
| name | Unknown |  |
| name_formatted | Unknown |  |
| price_precision | Unknown |  |
| show_in_storefront | Unknown |  |
| symbol | Unknown |  |

### purchase_receive_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_receive_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| item_order | Unknown |  |
| quantity | Unknown |  |

### purchase_receive_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_receive_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### purchase_receive_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_receive_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### purchase_receive

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | String | FK |
| purchaseorder_id | Unknown | FK |
| vendor_id | Unknown | FK |
| contact_person | Unknown |  |
| created_time | Unknown |  |
| date | Unknown |  |
| is_sales_return | Unknown |  |
| last_modified_time | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| quantity_received | Unknown |  |
| status | Unknown |  |

### tax_authority

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |
| organization_id | String |  |
| registration_number | Unknown |  |
| registration_number_label | Unknown |  |

### vendor_credit_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| acquisition_vat_amount | Unknown |  |
| acquisition_vat_id | Unknown |  |
| acquisition_vat_name | Unknown |  |
| acquisition_vat_percentage | Unknown |  |
| item_total_inclusive_of_tax | Unknown |  |
| reverse_charge_vat_amount | Unknown |  |
| reverse_charge_vat_id | Unknown |  |
| reverse_charge_vat_name | Unknown |  |
| reverse_charge_vat_percentage | Unknown |  |
| tax_exemption_code | Unknown |  |
| tax_exemption_id | Unknown |  |
| tax_treatment_code | Unknown |  |

### vendor_credit_line_item_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | PK, FK |
| option_id | Unknown |  |

### vendor_credit_line_item_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | PK, FK |
| index | Unknown |  |
| label | Unknown |  |
| value | Unknown |  |

### vendor_credit_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | PK, FK |
| file_name | Unknown |  |

### vendor_credit_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | FK |
| commented_by | Unknown |  |
| commented_by_id | Unknown |  |
| date | Unknown |  |
| date_description | Unknown |  |
| description | Unknown |  |
| operation_type | Unknown |  |
| time | Unknown |  |
| transaction_id | Unknown |  |
| transaction_type | Unknown |  |
| type | Unknown |  |

### vendor_credit_refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | FK |
| amount_bcy | Unknown |  |
| amount_fcy | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| filed_in_vat_return_id | Unknown |  |
| filed_in_vat_return_name | Unknown |  |
| filed_in_vat_return_type | Unknown |  |
| mode | Unknown |  |
| reference_number | Unknown |  |

### vendor_credit_bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vendor_credit_id | Unknown | PK, FK |

### vendor_credit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| organization_id | String | FK |
| pricebook_id | Unknown | FK |
| tax_id | Unknown | FK |
| vendor_id | Unknown | FK |
| acquisition_vat_total | Unknown |  |
| balance | Unknown |  |
| created_time | Unknown |  |
| date | Unknown |  |
| destination_of_supply | Unknown |  |
| exchange_rate | Unknown |  |
| filed_in_vat_return_id | Unknown |  |
| filed_in_vat_return_name | Unknown |  |
| filed_in_vat_return_type | Unknown |  |
| gst_no | Unknown |  |
| gst_treatment | Unknown |  |
| has_attachment | Unknown |  |
| is_inclusive_tax | Unknown |  |
| is_reverse_charge_applied | Unknown |  |
| last_modified_time | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| place_of_supply | Unknown |  |
| price_precision | Unknown |  |
| reference_number | Unknown |  |
| reverse_charge_vat_total | Unknown |  |
| source_of_supply | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| tax_treatment | Unknown |  |
| total | Unknown |  |
| total_credits_used | Unknown |  |
| total_refunded_amount | Unknown |  |
| vat_treatment | Unknown |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| customer_id | Unknown | FK |
| organization_id | String | FK |
| balance | Unknown |  |
| created_time | Instant |  |
| date | Unknown |  |
| is_emailed | Unknown |  |
| last_modified_time | Unknown |  |
| number | Unknown |  |
| reference_number | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |

## Relationships

- payment_invoice(payment_id) → payment(id)
- payment(currency_id) → currency(id)
- payment(organization_id) → organization(id)
- payment(customer_id) → contact(id)
- contact_person(contact_id) → contact(id)
- contact_billing_address(contact_id) → contact(id)
- contact_shipping_address(contact_id) → contact(id)
- contact(currency_id) → currency(id)
- contact(pricebook_id) → price_book(id)
- contact(organization_id) → organization(id)
- tax(organization_id) → organization(id)
- sales_order_custom_field(sales_order_id) → sales_order(id)
- sales_order_line_item(tax_id) → tax(id)
- sales_order_line_item(item_id) → item(id)
- sales_order_line_item(location_id) → location(id)
- sales_order_line_item(sales_order_id) → sales_order(id)
- sales_order_tax(sales_order_id) → sales_order(id)
- sales_order_shipping_address(sales_order_id) → sales_order(id)
- sales_order_billing_address(sales_order_id) → sales_order(id)
- sales_order_document(sales_order_id) → sales_order(id)
- sales_order(currency_id) → currency(id)
- sales_order(pricebook_id) → price_book(id)
- sales_order(organization_id) → organization(id)
- sales_order(customer_id) → contact(id)
- sales_order(location_id) → location(id)
- package(salesorder_id) → sales_order(id)
- package(organization_id) → organization(id)
- package(customer_id) → contact(id)
- bill_address(bill_id) → bill(id)
- bill_custom_field(bill_id) → bill(id)
- bill_line_item(tax_id) → tax(id)
- bill_line_item(tax_exemption_id) → tax_exemption(id)
- bill_line_item(location_id) → location(id)
- bill_line_item(bill_id) → bill(id)
- bill_payment(id) → payment(id)
- bill_payment(bill_id) → bill(id)
- bill_vendor_credit(id) → vendor_credit(id)
- bill_vendor_credit(bill_id) → bill(id)
- bill_tax(bill_id) → bill(id)
- bill(currency_id) → currency(id)
- bill(vendor_id) → contact(id)
- bill(organization_id) → organization(id)
- bill(location_id) → location(id)
- bill(purchaseorder_id) → purchase_order(id)
- invoice_custom_field(invoice_id) → invoice(id)
- invoice_line_item(tax_id) → tax(id)
- invoice_line_item(item_id) → item(id)
- invoice_line_item(location_id) → location(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_payment_gateway(invoice_id) → invoice(id)
- invoice_billing_address(invoice_id) → invoice(id)
- invoice_shipping_address(invoice_id) → invoice(id)
- invoice(currency_id) → currency(id)
- invoice(customer_id) → contact(id)
- invoice(location_id) → location(id)
- item(tax_id) → tax(id)
- item(organization_id) → organization(id)
- purchase_order_receive(purchase_order_id) → purchase_order(id)
- purchase_order_custom_field(purchase_order_id) → purchase_order(id)
- purchase_order(currency_id) → currency(id)
- purchase_order(vendor_id) → contact(id)
- purchase_order(organization_id) → organization(id)
- users(organization_id) → organization(id)
- location_associated_series(location_id) → location(id)
- location_associated_user(user_id) → users(id)
- location_associated_user(location_id) → location(id)
- location(organization_id) → organization(id)
- location(parent_location_id) → location(id)
- transfer_order_line_item(item_id) → item(id)
- transfer_order_line_item(transfer_order_id) → transfer_order(id)
- transfer_order(last_modified_by_id) → users(id)
- transfer_order(from_location_id) → location(id)
- transfer_order(organization_id) → organization(id)
- transfer_order(created_by_id) → users(id)
- transfer_order(to_location_id) → location(id)
- inventory_adjustment(last_modified_by_id) → users(id)
- inventory_adjustment(organization_id) → organization(id)
- inventory_adjustment(created_by_id) → users(id)
- inventory_adjustment(item_id) → item(id)
- inventory_adjustment(location_id) → location(id)
- organization_custom_field(organization_id) → organization(id)
- organization_org_joined_app_list(organization_id) → organization(id)
- organization_app_list(organization_id) → organization(id)
- organization_address(organization_id) → organization(id)
- organization(currency_id) → currency(id)
- price_book_item(item_id) → item(id)
- price_book_item(price_book_id) → price_book(id)
- price_book(currency_id) → currency(id)
- price_book(organization_id) → organization(id)
- sales_return(salesorder_id) → sales_order(id)
- sales_return(organization_id) → organization(id)
- purchase_receive_line_item(item_id) → item(id)
- purchase_receive_line_item(purchase_receive_id) → purchase_receive(id)
- purchase_receive_billing_address(purchase_receive_id) → purchase_receive(id)
- purchase_receive_shipping_address(purchase_receive_id) → purchase_receive(id)
- purchase_receive(vendor_id) → contact(id)
- purchase_receive(organization_id) → organization(id)
- purchase_receive(purchaseorder_id) → purchase_order(id)
- vendor_credit_line_item(item_id) → item(id)
- vendor_credit_line_item(vendor_credit_id) → vendor_credit(id)
- vendor_credit_line_item_tag(vendor_credit_id) → vendor_credit(id)
- vendor_credit_line_item_custom_field(vendor_credit_id) → vendor_credit(id)
- vendor_credit_document(vendor_credit_id) → vendor_credit(id)
- vendor_credit_comment(vendor_credit_id) → vendor_credit(id)
- vendor_credit_refund(vendor_credit_id) → vendor_credit(id)
- vendor_credit_bill(id) → bill(id)
- vendor_credit_bill(vendor_credit_id) → vendor_credit(id)
- vendor_credit(currency_id) → currency(id)
- vendor_credit(vendor_id) → contact(id)
- vendor_credit(pricebook_id) → price_book(id)
- vendor_credit(organization_id) → organization(id)
- vendor_credit(tax_id) → tax(id)
- credit_note(currency_id) → currency(id)
- credit_note(organization_id) → organization(id)
- credit_note(customer_id) → contact(id)