Zoho CRM

Explore the interactive ERD

Table & Field Reference

sales_order

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`contact_id`	String	FK
`created_by_id`	String	FK
`deal_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`quote_id`	String	FK
`account_name`	String
`adjustment`	Double
`approved`	Boolean
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`carrier`	String
`contact_name`	String
`converted`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`customer_no`	String
`deal_name`	String
`description`	String
`discount`	Double
`due_date`	LocalDate
`editable`	Boolean
`exchange_rate`	Double
`excise_duty`	Int
`grand_total`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`purchase_order`	String
`quote_name`	String
`sales_commission`	Double
`shipping_city`	String
`shipping_code`	String
`shipping_country`	String
`shipping_state`	String
`shipping_street`	String
`so_number`	String
`state`	String
`status`	String
`sub_total`	Double
`subject`	String
`tax`	Double
`terms_and_conditions`	String
`approval_`
`review_process_`

stage

Column	Type	Keys
`id`	String	PK
`display_label`	String
`forecast_category_id`	String
`forecast_category_name`	String
`forecast_type`	String
`name`	String
`probability`	String

task

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`approved`	Boolean
`closed_time`	Instant
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`due_date`	LocalDate
`editable`	Boolean
`exchange_rate`	Double
`expected_revenue`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`priority`	String
`process_flow`	Boolean
`se_module`	String
`send_notification_email`	Boolean
`status`	String
`subject`	String
`u_id`	String
`what_id`	String
`what_name`	String
`who_id`	String
`who_name`	String
`approval_`
`review_process_`

purchase_order_product

Column	Type	Keys
`id`	String	PK
`purchase_order_id`	String	PKFK
`product_id`	String	FK
`discount`	Double
`list_price`	Double
`net_total`	Double
`product_currency`	String
`product_description`	String
`product_name`	String
`quantity`	Int
`quantity_in_stock`	Int
`tax`	Double
`total`	Double
`total_after_discount`	Double
`unit_price`	Double

event_participant

Column	Type	Keys
`id`	String	PK
`event_id`	String	PKFK
`email`	String
`invited`	Boolean
`name`	String
`participant`	String
`status`	String
`type`	String

users

Column	Type	Keys
`id`	String	PK
`role_id`	String	FK
`alias`	String
`city`	String
`confirm`	Boolean
`country`	String
`country_locale`	String
`created_time`	Instant
`currency`	String
`date_format`	String
`dob`	Instant
`email`	String
`fax`	String
`first_name`	String
`full_name`	String
`isonline`	Boolean
`language`	String
`last_name`	String
`locale`	String
`microsoft`	Boolean
`mobile`	String
`modified_time`	Instant
`name_format`	String
`personal_account`	Boolean
`phone`	String
`role_name`	String
`signature`	String
`state`	String
`status`	String
`street`	String
`time_format`	String
`time_zone`	String
`website`	String
`zip`	String
`zuid`	String
`customize_info_`
`theme_`

contact

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`approved`	Boolean
`assistant`	String
`asst_phone`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`date_of_birth`	String
`department`	String
`description`	String
`editable`	Boolean
`email`	String
`email_opt_out`	Boolean
`exchange_rate`	Double
`fax`	String
`first_name`	String
`full_name`	String
`home_phone`	String
`in_merge`	Boolean
`last_activity_time`	Instant
`last_contacted_on`	Instant
`last_name`	String
`mailing_country`	String
`mailing_state`	String
`mailing_street`	String
`mailing_zip`	String
`mobile`	String
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`negative_score`	Int
`negative_touch_point_score`	Int
`number_of_chats`	Int
`orchestration`	Boolean
`other_city`	String
`other_country`	String
`other_phone`	String
`other_state`	String
`other_street`	String
`other_zip`	String
`owner_email`	String
`owner_name`	String
`phone`	String
`positive_score`	Int
`positive_touch_point_score`	Int
`process_flow`	Boolean
`salutation`	String
`score`	Int
`secondary_email`	String
`skype_id`	String
`title`	String
`touch_point_score`	Int
`twitter`	String
`approval_`
`review_process_`

product

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`vendorid`	String	FK
`approved`	Boolean
`commission_rate`	Int
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`editable`	Boolean
`exchange_rate`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`manufacturer`	String
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`product_active`	Boolean
`product_category`	String
`product_code`	String
`product_name`	String
`qty_in_demand`	Double
`qty_in_stock`	Double
`qty_ordered`	Double
`reorder_level`	Double
`sales_end_date`	Instant
`sales_start_date`	Instant
`support_expiry_date`	String
`support_start_date`	String
`taxable`	Boolean
`unit_price`	Double
`usage_unit`	String
`vendorname`	String
`approval_`
`review_process_`

role

Column	Type	Keys
`id`	String	PK
`forecast_manager_id`	String	FK
`reporting_to_id`	String	FK
`admin_user`	Boolean
`description`	String
`display_label`	String
`forecast_manager_email`	String
`forecast_manager_name`	String
`name`	String
`reporting_to_email`	String
`reporting_to_name`	String
`share_with_peers`	Boolean

currency

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`exchange_rate`	Double
`format_decimal_places`	String
`format_decimal_separator`	String
`format_thousand_separator`	String
`is_active`	Boolean
`is_base`	Boolean
`iso_code`	String
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`name`	String
`prefix_symbol`	Boolean
`symbol`	String

account

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`account_name`	String
`account_number`	String
`account_site`	String
`account_type`	String
`annual_revenue`	Double
`approved`	Boolean
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`editable`	Boolean
`employees`	Int
`exchange_rate`	Double
`fax`	String
`in_merge`	Boolean
`industry`	String
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`ownership`	String
`phone`	String
`process_flow`	Boolean
`rating`	String
`shipping_city`	String
`shipping_code`	String
`shipping_country`	String
`shipping_state`	String
`shipping_street`	String
`sic_code`	Int
`ticker_symbol`	String
`website`	String
`approval_`
`review_process_`

invoice

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`contact_id`	String	FK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`account_name`	String
`adjustment`	Double
`approved`	Boolean
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`contact_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`discount`	Double
`due_date`	LocalDate
`editable`	Boolean
`exchange_rate`	Double
`excise_duty`	String
`grand_total`	Double
`in_merge`	Boolean
`invoice_date`	String
`invoice_number`	String
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`sales_commission`	Double
`shipping_city`	String
`shipping_code`	String
`shipping_country`	String
`shipping_state`	String
`shipping_street`	String
`status`	String
`sub_total`	Double
`subject`	String
`tax`	Double
`terms_and_conditions`	String
`approval_`
`review_process_`

invoice_product

Column	Type	Keys
`id`	String	PK
`invoice_id`	String	PKFK
`product_id`	String	FK
`discount`	Double
`list_price`	Double
`net_total`	Double
`product_code`	String
`quantity`	Int
`quantity_in_stock`	Int
`tax`	Double
`total`	Double
`total_after_discount`	Double
`unit_price`	Double

vendor

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`approved`	Boolean
`category`	String
`city`	String
`country`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`data_source`	String
`description`	String
`editable`	Boolean
`email`	String
`exchange_rate`	Double
`gl_account`	String
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`phone`	String
`process_flow`	Boolean
`state`	String
`street`	String
`vendor_name`	String
`website`	String
`zip_code`	String
`approval_`
`review_process_`

call

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`contact_id`	String	FK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`account_name`	String
`approved`	Boolean
`calendar_booking_call`	Boolean
`call_agenda`	String
`call_duration`	String
`call_purpose`	String
`call_result`	String
`call_start_time`	Instant
`call_status`	String
`call_type`	String
`contact_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`dialled_number`	String
`editable`	Boolean
`exchange_rate`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`se_module`	String
`subject`	String
`approval_`
`review_process_`

contact_role

Column	Type	Keys
`id`	String	PK
`name`	String
`sequence_number`	Int

deal_stage_history

Column	Type	Keys
`id`	String	PK
`deal_id`	String	FK
`modified_by_id`	String	FK
`stage_id`	String	FK
`amount`	Double
`close_date`	String
`duration_days`	Int
`expected_revenue`	Double
`last_modified_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`probability`	String

event

Column	Type	Keys
`id`	String	PK
`contact_id`	String	FK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`all_day`	Boolean
`approved`	Boolean
`calendar_booking_event`	String
`check_in_address`	String
`check_in_city`	String
`check_in_comment`	String
`check_in_country`	String
`check_in_status`	String
`check_in_time`	Instant
`contact_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`editable`	Boolean
`end_date_time`	Instant
`event_title`	String
`exchange_rate`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`latitude`	Double
`longitude`	Double
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`recurrence_id`	String
`recurring_activity_rrule`	String
`remind_at`	Instant
`se_module`	String
`send_notification`	Boolean
`start_date_time`	Instant
`u_id`	String
`venue`	String
`zip_code`	String
`approval_`
`review_process_`

lead

Column	Type	Keys
`id`	String	PK
`converted_detail_account`	String	FK
`converted_detail_contact`	String	FK
`converted_detail_deal`	String	FK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`approved`	Boolean
`company`	String
`converted`	Boolean
`converted_detail_convert_date`	Instant
`converted_detail_converted_by`	String
`country`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`designation`	String
`editable`	Boolean
`email`	String
`email_opt_out`	Boolean
`exchange_rate`	Double
`fax`	String
`first_name`	String
`first_visited_time`	Instant
`full_name`	String
`in_merge`	Boolean
`industry`	String
`industry_type`	String
`last_activity_time`	Instant
`last_name`	String
`lead_source`	String
`lead_status`	String
`mobile`	String
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`no_of_employees`	Int
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`phone`	String
`positive_score`	Int
`process_flow`	Boolean
`salutation`	String
`skype_id`	String
`state`	String
`street`	String
`touch_point_score`	Int
`twitter`	String
`website`	String
`zip_code`	String
`approval_`
`review_process_`

organization

Column	Type	Keys
`id`	String	PK
`alias`	String
`city`	String
`company_name`	String
`country`	String
`country_code`	String
`currency`	String
`currency_locale`	String
`currency_symbol`	String
`description`	String
`domain_name`	String
`employee_count`	String
`fax`	String
`gapps_enabled`	Boolean
`iso_code`	String
`mc_status`	Boolean
`mobile`	String
`phone`	String
`photo_id`	String
`primary_email`	String
`primary_zuid`	String
`privacy_settings`	Boolean
`state`	String
`street`	String
`time_zone`	String
`translation_enabled`	Boolean
`website`	String
`zgid`	String
`zia_portal_id`	String
`zip`	String
`license_details_`

profile

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`category`	Boolean
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`description`	String
`display_label`	String
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`name`	String

quote_product

Column	Type	Keys
`id`	String	PK
`quote_id`	String	PKFK
`product_id`	String	FK
`discount`	Double
`list_price`	Double
`net_total`	Double
`product_currency`	String
`product_description`	String
`quantity`	Double
`quantity_in_stock`	Int
`tax`	Double
`total`	Double
`total_after_discount`	Double
`unit_price`	Double

solution

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`product_id`	String	FK
`answer`	String
`approved`	Boolean
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`editable`	Boolean
`exchange_rate`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`no_of_comments`	Int
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`product_name`	String
`published`	String
`question`	String
`solution_number`	String
`solution_title`	String
`status`	String
`approval_`
`review_process_`

purchase_order

Column	Type	Keys
`id`	String	PK
`contact_id`	String	FK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`vendor_id`	String	FK
`adjustment`	Double
`approved`	Boolean
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`carrier`	String
`contact_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`customer_no`	String
`description`	String
`discount`	Double
`due_date`	LocalDate
`editable`	Boolean
`exchange_rate`	Double
`excise_duty`	Double
`grand_total`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`po_date`	LocalDate
`po_number`	String
`process_flow`	Boolean
`requisition_no`	String
`sales_commission`	Double
`shipping_city`	String
`shipping_code`	String
`shipping_country`	String
`shipping_state`	String
`shipping_street`	String
`state`	String
`status`	String
`sub_total`	Double
`subject`	String
`tax`	Double
`terms_and_conditions`	String
`tracking_number`	String
`vendor_name`	String
`approval_`
`review_process_`

territory

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`manager_id`	String	FK
`modified_by_id`	String	FK
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`criteria`	Json
`description`	String
`manager_email`	String
`manager_name`	String
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`name`	String
`parent_id`	String

note

Column	Type	Keys
`id`	String	PK
`created_byid`	String	FK
`modified_byid`	String	FK
`owner_id`	String	FK
`created_byemail`	String
`created_byname`	String
`created_time`	Instant
`editable`	Boolean
`is_shared_to_client`	Boolean
`modified_byemail`	String
`modified_byname`	String
`modified_time`	Instant
`note_content`	String
`note_title`	String
`owner_email`	String
`owner_name`	String
`parent_id`	String
`se_module`	String
`size`	Int
`state`	String
`voice_note`	Boolean

user_territory

Column	Type	Keys
`territory_id`	String	PKFK
`user_id`	String	PKFK

deal

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`campaign_source_id`	String	FK
`contact_id`	String	FK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`account_name`	String
`amount`	Double
`approved`	Boolean
`campaign_source_name`	String
`closing_date`	String
`contact_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`deal_name`	String
`description`	String
`editable`	Boolean
`exchange_rate`	Double
`expected_revenue`	Double
`followed`	Boolean
`in_merge`	Boolean
`last_activity_time`	Instant
`lead_conversion_time`	Int
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`next_step`	String
`orchestration`	Boolean
`overall_sales_duration`	Int
`owner_email`	String
`owner_name`	String
`probability`	String
`process_flow`	Boolean
`sales_cycle_duration`	Int
`stage`	String
`type`	String
`approval_`
`review_process_`

case_module

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`contact_id`	String	FK
`created_by_id`	String	FK
`deal_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`product_id`	String	FK
`account_name`	String
`approved`	Boolean
`case_number`	String
`case_origin`	String
`case_reason`	String
`contact_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`deal_name`	String
`description`	String
`editable`	Boolean
`email`	String
`exchange_rate`	Double
`in_merge`	Boolean
`internal_comments`	String
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`no_of_comments`	Int
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`phone`	String
`priority`	String
`process_flow`	Boolean
`product_name`	String
`solution`	String
`status`	String
`subject`	String
`type`	String
`approval_`
`review_process_`

campaign

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`actual_cost`	Double
`approved`	Boolean
`budgeted_cost`	Double
`campaign_name`	String
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`description`	String
`editable`	Boolean
`end_date`	String
`exchange_rate`	Double
`expected_revenue`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`num_sent`	Int
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`start_date`	String
`status`	String
`type`	String
`approval_`
`review_process_`

quote

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`contact_id`	String	FK
`created_by_id`	String	FK
`deal_id`	String	FK
`modified_by_id`	String	FK
`owner_id`	String	FK
`account_name`	String
`adjustment`	Double
`approved`	Boolean
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`carrier`	String
`contact_name`	String
`converted`	Boolean
`created_by_email`	String
`created_by_name`	String
`created_time`	Instant
`currency`	String
`currency_symbol`	String
`deal_name`	String
`description`	String
`discount`	Double
`editable`	Boolean
`exchange_rate`	Double
`grand_total`	Double
`in_merge`	Boolean
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_name`	String
`modified_time`	Instant
`orchestration`	Boolean
`owner_email`	String
`owner_name`	String
`process_flow`	Boolean
`quote_number`	String
`quote_stage`	String
`shipping_city`	String
`shipping_code`	String
`shipping_country`	String
`shipping_state`	String
`shipping_street`	String
`sub_total`	Double
`subject`	String
`tax`	Double
`team`	String
`valid_till`	Instant
`approval_`
`review_process_`

sales_order_product

Column	Type	Keys
`id`	String	PK
`sales_order_id`	String	PKFK
`product_id`	String	FK
`discount`	Double
`list_price`	Double
`net_total`	Double
`product_currency`	String
`product_description`	String
`product_name`	String
`quantity`	Int
`quantity_in_stock`	Int
`tax`	Double
`total`	Double
`total_after_discount`	Double
`unit_price`	Double

Zoho CRM

Explore the interactive ERD

Table & Field Reference

sales_order

stage

task

purchase_order_product

event_participant

tags

users

contact

product

role

currency

account

invoice

invoice_product

vendor

call

contact_role

deal_stage_history

event

lead

organization

profile

quote_product

solution

purchase_order

territory

note

user_territory

deal

case_module

campaign

quote

sales_order_product