Zoho CRM

Explore the interactive ERD

Table & Field Reference

account

Column	Type	Keys
`account_name`	String
`account_number`	String
`account_site`	String
`account_type`	String
`annual_revenue`	Double
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`employees`	Int
`exchange_rate`	Double
`fax`	String
`id`	String	PK
`industry`	String
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`ownership`	String
`phone`	String
`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
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

call

Column	Type	Keys
`account_id`	String	FK
`account_name`	String
`call_agenda`	String
`call_duration`	String
`call_purpose`	String
`call_result`	String
`call_start_time`	Instant
`call_status`	String
`call_type`	String
`contact_id`	String	FK
`contact_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`description`	String
`dialled_number`	String
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`se_module`	String
`subject`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] calendar_booking_call`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`currency`	String
`exchange_rate`	Double
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

campaign

Column	Type	Keys
`actual_cost`	Double
`budgeted_cost`	Double
`campaign_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`end_date`	String
`exchange_rate`	Double
`expected_revenue`	Double
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`num_sent`	Int
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`start_date`	String
`status`	String
`type`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

case_module

Column	Type	Keys
`account_id`	String	FK
`account_name`	String
`case_number`	String
`case_origin`	String
`case_reason`	String
`contact_id`	String	FK
`contact_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`deal_id`	String	FK
`deal_name`	String
`description`	String
`email`	String
`exchange_rate`	Double
`id`	String	PK
`internal_comments`	String
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`no_of_comments`	Int
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`phone`	String
`priority`	String
`product_id`	String	FK
`product_name`	String
`solution`	String
`status`	String
`subject`	String
`type`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

contact

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

contact_role

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

currency

Column	Type	Keys
`id`	String	PK
`created_by_email`	String
`created_by_id`	String	FK
`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_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`name`	String
`prefix_symbol`	Boolean
`symbol`	String

deal

Column	Type	Keys
`account_id`	String	FK
`account_name`	String
`amount`	Double
`campaign_source_id`	String	FK
`campaign_source_name`	String
`closing_date`	String
`contact_id`	String	FK
`contact_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`deal_name`	String
`description`	String
`exchange_rate`	Double
`expected_revenue`	Double
`id`	String	PK
`last_activity_time`	Instant
`lead_conversion_time`	Int
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`next_step`	String
`overall_sales_duration`	Int
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`probability`	String
`sales_cycle_duration`	Int
`stage`	String
`type`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] followed`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

deal_stage_history

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

event

Column	Type	Keys
`all_day`	Boolean
`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_id`	String	FK
`contact_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`end_date_time`	Instant
`event_title`	String
`exchange_rate`	Double
`id`	String	PK
`last_activity_time`	Instant
`latitude`	Double
`longitude`	Double
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`recurring_activity_rrule`	String
`remind_at`	Instant
`se_module`	String
`start_date_time`	Instant
`u_id`	String
`venue`	String
`zip_code`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] calendar_booking_event`	String
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] recurrence_id`	String
`[REMOVED] send_notification`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

event_participant

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

invoice

Column	Type	Keys
`account_id`	String	FK
`account_name`	String
`adjustment`	Double
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`contact_id`	String	FK
`contact_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`discount`	Double
`due_date`	LocalDate
`exchange_rate`	Double
`excise_duty`	String
`grand_total`	Double
`id`	String	PK
`invoice_date`	String
`invoice_number`	String
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`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
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

invoice_product

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

lead

Column	Type	Keys
`company`	String
`converted`	Boolean
`converted_detail_account`	String	FK
`converted_detail_contact`	String	FK
`converted_detail_convert_date`	Instant
`converted_detail_converted_by`	String
`converted_detail_deal`	String	FK
`country`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`designation`	String
`email`	String
`email_opt_out`	Boolean
`exchange_rate`	Double
`fax`	String
`first_name`	String
`first_visited_time`	Instant
`full_name`	String
`id`	String	PK
`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_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`no_of_employees`	Int
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`phone`	String
`salutation`	String
`skype_id`	String
`state`	String
`street`	String
`twitter`	String
`website`	String
`zip_code`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`positive_score`	Int
`touch_point_score`	Int
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

note

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

organization

Column	Type	Keys
`id`	String	PK
`alias`	String
`city`	String
`company_name`	String
`country`	String
`country_code`	String
`[NEW] created_time`	Instant
`currency`	String
`currency_locale`	String
`currency_symbol`	String
`[NEW] deletable_org_account`	Boolean
`description`	String
`domain_name`	String
`employee_count`	String
`fax`	String
`gapps_enabled`	Boolean
`[NEW] hierarchy_preferences_type`	String
`[NEW] hipaa_compliance_enabled`	Boolean
`iso_code`	String
`license_details_paid`*
`license_details_paid_expiry`*
`license_details_paid_type`*
`license_details_trial_expiry`*
`license_details_trial_type`*
`license_details_users_license_purchased`*
`[NEW] license_details_portal_users_license_purchased`*
`[NEW] lite_users_enabled`	Boolean
`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
`[NEW] type`	String
`website`	String
`zgid`	String
`zia_portal_id`	String
`zip`	String

product

Column	Type	Keys
`commission_rate`	Int
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`exchange_rate`	Double
`id`	String	PK
`last_activity_time`	Instant
`manufacturer`	String
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`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
`[REMOVED] taxable`	Boolean
`unit_price`	Double
`usage_unit`	String
`vendorid`	String	FK
`vendorname`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

profile

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

purchase_order

Column	Type	Keys
`adjustment`	Double
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`carrier`	String
`contact_id`	String	FK
`contact_name`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`discount`	Double
`due_date`	LocalDate
`exchange_rate`	Double
`excise_duty`	Double
`grand_total`	Double
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`po_date`	LocalDate
`po_number`	String
`requisition_no`	String
`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
`tracking_number`	String
`vendor_id`	String	FK
`vendor_name`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] state`	String
`customer_no`	String
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

purchase_order_product

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

quote

Column	Type	Keys
`account_id`	String	FK
`account_name`	String
`adjustment`	Double
`billing_city`	String
`billing_code`	String
`billing_country`	String
`billing_state`	String
`billing_street`	String
`carrier`	String
`contact_id`	String	FK
`contact_name`	String
`converted`	Boolean
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`deal_id`	String	FK
`deal_name`	String
`description`	String
`discount`	Double
`exchange_rate`	Double
`grand_total`	Double
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`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
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

quote_product

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

role

Column	Type	Keys
`id`	String	PK
`[NEW] api_name`	String
`description`	String
`display_label`	String
`forecast_manager_email`	String
`forecast_manager_id`	String	FK
`forecast_manager_name`	String
`name`	String
`reporting_to_email`	String
`reporting_to_id`	String	FK
`reporting_to_name`	String
`share_with_peers`	Boolean
`[REMOVED] admin_user`	Boolean
`[NEW] created_by_id`	String	FK
`[NEW] modified_by_id`	String	FK
`[NEW] created_by_email`	String
`[NEW] created_by_name`	String
`[NEW] created_time`	Instant
`[NEW] modified_by_email`	String
`[NEW] modified_by_name`	String
`[NEW] modified_time`	Instant

sales_order

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

sales_order_product

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

solution

Column	Type	Keys
`answer`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`exchange_rate`	Double
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`no_of_comments`	Int
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`product_id`	String	FK
`product_name`	String
`published`	String
`question`	String
`solution_number`	String
`solution_title`	String
`status`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

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
`closed_time`	Instant
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`due_date`	LocalDate
`exchange_rate`	Double
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`priority`	String
`se_module`	String
`send_notification_email`	Boolean
`status`	String
`subject`	String
`what_id`	String
`what_name`	String
`who_id`	String
`who_name`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`[REMOVED] u_id`	String
`expected_revenue`	Double
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

territory

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

user_territory

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

users

Column	Type	Keys
`alias`	String
`city`	String
`confirm`	Boolean
`country`	String
`country_locale`	String
`created_time`	Instant
`currency`	String
`customize_info_bc_view`*
`customize_info_notes_desc`*
`customize_info_show_detail_view`*
`customize_info_show_home`*
`customize_info_show_right_panel`*
`customize_info_unpin_recent_item`*
`date_format`	String
`dob`	Instant
`email`	String
`fax`	String
`first_name`	String
`full_name`	String
`id`	String	PK
`isonline`	Boolean
`language`	String
`last_name`	String
`locale`	String
`microsoft`	Boolean
`mobile`	String
`modified_time`	Instant
`personal_account`	Boolean
`phone`	String
`role_id`	String	FK
`role_name`	String
`signature`	String
`state`	String
`status`	String
`street`	String
`theme_background`*
`theme_screen`*
`theme_type`*
`theme_normal_tab_background`*
`theme_normal_tab_font_color`*
`theme_selected_tab_background`*
`theme_selected_tab_font_color`*
`time_format`	String
`time_zone`	String
`website`	String
`zip`	String
`zuid`	String
`[NEW] profile_id`	String	FK
`name_format`	String
`[NEW] profile_name`	String

vendor

Column	Type	Keys
`category`	String
`city`	String
`country`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`currency`	String
`description`	String
`email`	String
`exchange_rate`	Double
`gl_account`	String
`id`	String	PK
`last_activity_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`owner_email`	String
`owner_id`	String	FK
`owner_name`	String
`phone`	String
`state`	String
`street`	String
`vendor_name`	String
`website`	String
`zip_code`	String
`[REMOVED] approval_approve`*
`[REMOVED] approval_delegate`*
`[REMOVED] approval_reject`*
`[REMOVED] approval_resubmit`*
`[REMOVED] approval_state`*
`[REMOVED] approved`	Boolean
`[REMOVED] currency_symbol`	String
`[REMOVED] editable`	Boolean
`[REMOVED] in_merge`	Boolean
`[REMOVED] orchestration`	Boolean
`[REMOVED] process_flow`	Boolean
`data_source`	String
`[REMOVED] review_process_approve`*
`[REMOVED] review_process_delegate`*
`[REMOVED] review_process_reject`*
`[REMOVED] review_process_resubmit`*
`custom_*`	String

workflow

Column	Type	Keys
`[NEW] id`	String	PK
`[NEW] created_by_email`	String
`[NEW] created_by_id`	String	FK
`[NEW] created_by_name`	String
`[NEW] created_time`	Instant
`[NEW] deletable`	Boolean
`[NEW] description`	String
`[NEW] editable`	Boolean
`[NEW] execute_when`	Json
`[NEW] last_executed_time`	Instant
`[NEW] lock_locked_by`	String
`[NEW] lock_message`	String
`[NEW] lock_status`	Boolean
`[NEW] modified_by_email`	String
`[NEW] modified_by_id`	String	FK
`[NEW] modified_by_name`	String
`[NEW] modified_time`	Instant
`[NEW] module_api_name`	String
`[NEW] module_id`	String
`[NEW] name`	String
`[NEW] source`	String
`[NEW] status_active`	Boolean

workflow_field_update

Column	Type	Keys
`[NEW] id`	String	PK
`[NEW] apply_assignment_threshold`	Boolean
`[NEW] associated`	Boolean
`[NEW] created_by_email`	String
`[NEW] created_by_id`	String	FK
`[NEW] created_by_name`	String
`[NEW] created_time`	Instant
`[NEW] deletable`	Boolean
`[NEW] editable`	Boolean
`[NEW] feature_type`	String
`[NEW] field_api_name`	String
`[NEW] field_id`	String
`[NEW] lock_status_locked`	Boolean
`[NEW] modified_by_email`	String
`[NEW] modified_by_id`	String	FK
`[NEW] modified_by_name`	String
`[NEW] modified_time`	Instant
`[NEW] module_api_name`	String
`[NEW] module_id`	String
`[NEW] name`	String
`[NEW] notify`	Boolean
`[NEW] related_module_api_name`	String
`[NEW] related_module_id`	String
`[NEW] source`	String
`[NEW] type`	String
`[NEW] update_type`	String
`[NEW] value`	Json

Column	Type	Keys
`id`	String	PK
`[NEW] color_code`	String
`created_by_email`	String
`created_by_id`	String	FK
`created_by_name`	String
`created_time`	Instant
`modified_by_email`	String
`modified_by_id`	String	FK
`modified_by_name`	String
`modified_time`	Instant
`name`	String
`module`	String

Zoho CRM

Explore the interactive ERD

Table & Field Reference

account

call

campaign

case_module

contact

contact_role

currency

deal

deal_stage_history

event

event_participant

invoice

invoice_product

lead

note

organization

product

profile

purchase_order

purchase_order_product

quote

quote_product

role

sales_order

sales_order_product

solution

stage

tags

task

territory

user_territory

users

vendor

workflow

workflow_field_update