Zoho Inventory

Explore the interactive ERD

Table & Field Reference

payment_invoice

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`index`	Unknown
`label`	Unknown
`value`	Unknown

sales_order_line_item

Column	Type	Keys
`id`	Unknown	PK
`sales_order_id`	Unknown	PKFK
`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	PKFK
`amount`	Unknown
`name`	Unknown

sales_order_shipping_address

Column	Type	Keys
`index`	Unknown	PK
`sales_order_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`address`	Unknown
`city`	Unknown
`country`	Unknown
`fax`	Unknown
`state`	Unknown
`zip`	Unknown

bill_custom_field

Column	Type	Keys
`id`	Unknown	PK
`bill_id`	Unknown	PKFK
`value`	Unknown

bill_line_item

Column	Type	Keys
`id`	Unknown	PK
`bill_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown	PKFK

bill_vendor_credit

Column	Type	Keys
`bill_id`	Unknown	PKFK
`id`	Unknown	PKFK
`amount`	Unknown
`vendor_credit_bill_id`	Unknown

bill_tax

Column	Type	Keys
`index`	Unknown	PK
`bill_id`	Unknown	PKFK
`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	PKFK
`label`	Unknown
`show_on_pdf`	Unknown
`value`	Unknown

invoice_line_item

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`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	PKFK
`additional_field_1`	Unknown
`configured`	Unknown
`gateway_name`	Unknown

invoice_billing_address

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`address`	Unknown
`city`	Unknown
`country`	Unknown
`fax`	Unknown
`state`	Unknown
`zip`	Unknown

invoice_shipping_address

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`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	PKFK
`number`	Unknown

purchase_order_custom_field

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`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	PKFK

location_associated_user

Column	Type	Keys
`location_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`label`	Unknown
`value`	Unknown

organization_org_joined_app_list

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`org_joined_app_list`	Unknown

organization_app_list

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`app_list`	Unknown

organization_address

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`item_id`	Unknown	FK
`item_order`	Unknown
`quantity`	Unknown

purchase_receive_billing_address

Column	Type	Keys
`index`	Unknown	PK
`purchase_receive_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`option_id`	Unknown

vendor_credit_line_item_custom_field

Column	Type	Keys
`id`	Unknown	PK
`vendor_credit_id`	Unknown	PKFK
`index`	Unknown
`label`	Unknown
`value`	Unknown

vendor_credit_document

Column	Type	Keys
`id`	Unknown	PK
`vendor_credit_id`	Unknown	PKFK
`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	PKFK
`vendor_credit_id`	Unknown	PKFK

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