# Zoho CRM schema ERD

Table and field reference for the Fivetran Zoho CRM connector.

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

### tags

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

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

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

## Relationships

- territory(manager_id) → users(id)
- territory(parent_id) → territory(id)
- territory(modified_by_id) → users(id)
- territory(created_by_id) → users(id)
- invoice(owner_id) → users(id)
- invoice(created_by_id) → users(id)
- invoice(modified_by_id) → users(id)
- invoice(account_id) → account(id)
- invoice(contact_id) → contact(id)
- vendor(owner_id) → users(id)
- vendor(created_by_id) → users(id)
- vendor(modified_by_id) → users(id)
- task(owner_id) → users(id)
- task(created_by_id) → users(id)
- task(modified_by_id) → users(id)
- currency(created_by_id) → users(id)
- currency(modified_by_id) → users(id)
- tags(modified_by_id) → users(id)
- tags(created_by_id) → users(id)
- role(reporting_to_id) → users(id)
- role(forecast_manager_id) → users(id)
- role([NEW] created_by_id) → users(id)
- role([NEW] modified_by_id) → users(id)
- purchase_order(owner_id) → users(id)
- purchase_order(created_by_id) → users(id)
- purchase_order(modified_by_id) → users(id)
- purchase_order(vendor_id) → vendor(id)
- purchase_order(contact_id) → contact(id)
- sales_order(owner_id) → users(id)
- sales_order(created_by_id) → users(id)
- sales_order(modified_by_id) → users(id)
- sales_order(deal_id) → deal(id)
- sales_order(quote_id) → quote(id)
- sales_order(account_id) → account(id)
- sales_order(contact_id) → contact(id)
- event_participant(event_id) → event(id)
- quote_product(quote_id) → quote(id)
- quote_product(product_id) → product(id)
- solution(owner_id) → users(id)
- solution(created_by_id) → users(id)
- solution(modified_by_id) → users(id)
- solution(product_id) → product(id)
- purchase_order_product(purchase_order_id) → purchase_order(id)
- purchase_order_product(product_id) → product(id)
- workflow([NEW] created_by_id) → users(id)
- workflow([NEW] modified_by_id) → users(id)
- call(owner_id) → users(id)
- call(created_by_id) → users(id)
- call(modified_by_id) → users(id)
- call(contact_id) → contact(id)
- call(account_id) → account(id)
- deal(owner_id) → users(id)
- deal(created_by_id) → users(id)
- deal(modified_by_id) → users(id)
- deal(campaign_source_id) → campaign(id)
- deal(account_id) → account(id)
- deal(contact_id) → contact(id)
- product(owner_id) → users(id)
- product(created_by_id) → users(id)
- product(modified_by_id) → users(id)
- product(vendorid) → vendor(id)
- quote(owner_id) → users(id)
- quote(created_by_id) → users(id)
- quote(modified_by_id) → users(id)
- quote(deal_id) → deal(id)
- quote(account_id) → account(id)
- quote(contact_id) → contact(id)
- invoice_product(invoice_id) → invoice(id)
- invoice_product(product_id) → product(id)
- event(owner_id) → users(id)
- event(created_by_id) → users(id)
- event(modified_by_id) → users(id)
- event(contact_id) → contact(id)
- case_module(owner_id) → users(id)
- case_module(created_by_id) → users(id)
- case_module(modified_by_id) → users(id)
- case_module(deal_id) → deal(id)
- case_module(account_id) → account(id)
- case_module(product_id) → product(id)
- case_module(contact_id) → contact(id)
- note(owner_id) → users(id)
- note(modified_byid) → users(id)
- note(created_byid) → users(id)
- profile(modified_by_id) → users(id)
- profile(created_by_id) → users(id)
- deal_stage_history(deal_id) → deal(id)
- deal_stage_history(modified_by_id) → users(id)
- deal_stage_history(stage_id) → stage(id)
- user_territory(user_id) → users(id)
- user_territory(territory_id) → territory(id)
- account(owner_id) → users(id)
- account(created_by_id) → users(id)
- account(modified_by_id) → users(id)
- contact(owner_id) → users(id)
- contact(created_by_id) → users(id)
- contact(modified_by_id) → users(id)
- sales_order_product(sales_order_id) → sales_order(id)
- sales_order_product(product_id) → product(id)
- campaign(owner_id) → users(id)
- campaign(created_by_id) → users(id)
- campaign(modified_by_id) → users(id)
- users(role_id) → role(id)
- users([NEW] profile_id) → profile(id)
- lead(owner_id) → users(id)
- lead(created_by_id) → users(id)
- lead(modified_by_id) → users(id)
- lead(converted_detail_deal) → deal(id)
- lead(converted_detail_contact) → contact(id)
- lead(converted_detail_account) → account(id)
- workflow_field_update([NEW] created_by_id) → users(id)
- workflow_field_update([NEW] modified_by_id) → users(id)