出典: SugarForum.jp
Sugarにおけるデータベースのスキーマ(=構造)。
ER図
http://media.sugarcrm.com/developer/tutorials/Sugar_CE_5.1_Schema.zip (ZIP形式、1MB)
に公開されている。
※ZIPファイルをダウンロードして展開すると、PDF形式のドキュメントが入っている。
フィールド対応表
以下、各モジュールのテーブルごとに、フィールドの一覧表を作成した。他DBからのデータ移行の際などの参考まで。なお、表内の「タイプ」はMySQLのカラム型ではなく、Sugarのフィールドタイプを指す。
Accounts
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | |
|
| name
| name | LBL_NAME | Name: | 名前: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | Date Entered: | 入力日: |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | Date Modified: | 最終更新日: |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | Modified By Id | |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | Created By Id | 作成者ID |
|
| created_by_name
| relate | LBL_CREATED | | |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | | |
|
| assigned_user_id
| relate | LBL_ASSIGNED_TO_ID | Assigned User: | アサイン先ユーザ: |
|
| assigned_user_name
| relate | LBL_ASSIGNED_TO_NAME | Assigned to: | アサイン先: |
|
| account_type
| enum | LBL_TYPE | Type: | タイプ: | account_type_dom
|
| industry
| enum | LBL_INDUSTRY | Industry: | 業界: | industry_dom
|
| annual_revenue
| varchar | LBL_ANNUAL_REVENUE | Annual Revenue: | 年間売上: |
|
| phone_fax
| phone | LBL_FAX | Fax: | ファックス: |
|
| billing_address_street
| varchar | LBL_BILLING_ADDRESS_STREET | Billing Street: | 請求先住所: |
|
| billing_address_street_2
| varchar | LBL_BILLING_ADDRESS_STREET_2 | Billing Street 2 | 請求先住所2: |
|
| billing_address_street_3
| varchar | LBL_BILLING_ADDRESS_STREET_3 | Billing Street 3 | 請求先住所3: |
|
| billing_address_street_4
| varchar | LBL_BILLING_ADDRESS_STREET_4 | Billing Street 4 | 請求先住所4: |
|
| billing_address_city
| varchar | LBL_BILLING_ADDRESS_CITY | Billing City: | 請求先市区町村: |
|
| billing_address_state
| varchar | LBL_BILLING_ADDRESS_STATE | Billing State: | 請求先都道府県: |
|
| billing_address_postalcode
| varchar | LBL_BILLING_ADDRESS_POSTALCODE | Billing Postal Code: | 請求先郵便番号: |
|
| billing_address_country
| varchar | LBL_BILLING_ADDRESS_COUNTRY | Billing Country: | 請求先国: |
|
| rating
| varchar | LBL_RATING | Rating: | 格付: |
|
| phone_office
| phone | LBL_PHONE_OFFICE | Phone Office: | 会社電話: |
|
| phone_alternate
| phone | LBL_PHONE_ALT | Alternate Phone: | その他の電話: |
|
| website
| varchar | LBL_WEBSITE | Website: | Webサイト: |
|
| ownership
| varchar | LBL_OWNERSHIP | Ownership: | 所有者: |
|
| employees
| num | LBL_EMPLOYEES | Employees: | 従業員: |
|
| ticker_symbol
| varchar | LBL_TICKER_SYMBOL | Ticker Symbol: | 証券コード: |
|
| shipping_address_street
| varchar | LBL_SHIPPING_ADDRESS_STREET | Shipping Street: | 出荷先番地: |
|
| shipping_address_street_2
| varchar | LBL_SHIPPING_ADDRESS_STREET_2 | Shipping Street 2 | 出荷先住所 2 |
|
| shipping_address_street_3
| varchar | LBL_SHIPPING_ADDRESS_STREET_3 | Shipping Street 3 | 出荷先住所 3 |
|
| shipping_address_street_4
| varchar | LBL_SHIPPING_ADDRESS_STREET_4 | Shipping Street 4 | 出荷先住所 4 |
|
| shipping_address_city
| varchar | LBL_SHIPPING_ADDRESS_CITY | Shipping City: | 出荷先市区町村: |
|
| shipping_address_state
| varchar | LBL_SHIPPING_ADDRESS_STATE | Shipping State: | 出荷先都道府県: |
|
| shipping_address_postalcode
| varchar | LBL_SHIPPING_ADDRESS_POSTALCODE | Shipping Postal Code: | 出荷先郵便番号: |
|
| shipping_address_country
| varchar | LBL_SHIPPING_ADDRESS_COUNTRY | Shipping Country: | 出荷先国: |
|
| email1
| varchar | LBL_EMAIL | Email: | 電子メール: |
|
| parent_id
| id | LBL_PARENT_ACCOUNT_ID | Parent Account ID | 親取引先ID |
|
| sic_code
| varchar | LBL_SIC_CODE | SIC Code: | 業界コード: |
|
| account_name
| relate | LBL_MEMBER_OF | Member of: | 親会社: |
|
| parent_name
| relate | LBL_MEMBER_OF | Member of: | 親会社: |
|
| campaign_id
| id | LBL_CAMPAIGN_ID | Campaign ID | キャンペーンID |
|
Calls
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | |
|
| name
| name | LBL_SUBJECT | Subject: | 件名: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | | |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | | |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | | |
|
| created_by_name
| relate | LBL_CREATED | | |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | | |
|
| assigned_user_id
| relate | LBL_ASSIGNED_TO_ID | Assigned User | アサイン先ユーザ |
|
| assigned_user_name
| relate | LBL_ASSIGNED_TO_NAME | Assigned to | アサイン先 |
|
| duration_hours
| int | LBL_DURATION_HOURS | Duration Hours: | 時間: |
|
| duration_minutes
| int | LBL_DURATION_MINUTES | Duration Minutes: | 分: |
|
| date_start
| datetime | LBL_DATE | Start Date: | 開始日: |
|
| date_end
| date | LBL_DATE_END | Date End | 終了日 |
|
| parent_type
| varchar | LBL_LIST_RELATED_TO | Related to | 関連先 |
|
| parent_name
| parent | LBL_LIST_RELATED_TO | Related to | 関連先 | parent_type_display
|
| status
| enum | LBL_STATUS | Status: | ステータス: | call_status_dom
|
| direction
| enum | LBL_DIRECTION | Direction: | 方向: | call_direction_dom
|
| parent_id
| id | LBL_LIST_RELATED_TO | Related to | 関連先 |
|
| reminder_checked
| bool | LBL_REMINDER | Reminder: | リマインダー: |
|
| reminder_time
| int | LBL_REMINDER_TIME | Reminder Time | リマインダー時間 |
|
| outlook_id
| varchar | LBL_OUTLOOK_ID | Outlook ID | Outlook ID |
|
| accept_status
| varchar | LBL_SUBJECT | Subject: | 件名: |
|
| contact_name
| relate | LBL_CONTACT_NAME | Contact: | 取引先担当者: |
|
Cases
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | |
|
| name
| name | LBL_SUBJECT | Subject: | 件名: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | | |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | | |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | | |
|
| created_by_name
| relate | LBL_CREATED | | |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | | |
|
| assigned_user_id
| relate | LBL_ASSIGNED_TO_ID | | |
|
| assigned_user_name
| relate | LBL_ASSIGNED_TO_NAME | Assigned to | アサイン先 |
|
| case_number
| int | LBL_NUMBER | Number: | 番号: |
|
| type
| enum | LBL_TYPE | Type | タイプ | case_type_dom
|
| status
| enum | LBL_STATUS | Status: | ステータス: | case_status_dom
|
| priority
| enum | LBL_PRIORITY | Priority: | 優先度: | case_priority_dom
|
| resolution
| text | LBL_RESOLUTION | Resolution: | 解決: |
|
| work_log
| text | LBL_WORK_LOG | Work Log | 作業記録 |
|
| account_name
| relate | LBL_ACCOUNT_NAME | Account Name: | 取引先: |
|
| account_name1
| text | | | |
|
| account_id
| id | LBL_ACCOUNT_ID | Account ID | 取引先ID |
|
Contacts
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | ID: | ID: |
|
| name
| name | LBL_FULL_NAME | Full Name: | フルネーム: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | 入力日 |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | Date Modified: | 最終更新日: |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | | 更新者ID |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | 更新者ごと |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | | 作成者ID |
|
| created_by_name
| relate | LBL_CREATED | | 作成者 |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | | 削除済み |
|
| assigned_user_id
| relate | LBL_ASSIGNED_TO_ID | Assigned User | アサイン先ユーザ |
|
| assigned_user_name
| relate | LBL_ASSIGNED_TO_NAME | Assigned to: | アサイン先: |
|
| salutation
| enum | LBL_SALUTATION | Salutation: | 敬称: | salutation_dom
|
| first_name
| varchar | LBL_FIRST_NAME | First Name: | 名: |
|
| last_name
| varchar | LBL_LAST_NAME | Last Name: | 姓: |
|
| full_name
| name | LBL_FULL_NAME | Full Name: | フルネーム: |
|
| title
| varchar | LBL_TITLE | Title: | 職位: |
|
| department
| varchar | LBL_DEPARTMENT | Department: | 部署: |
|
| do_not_call
| bool | LBL_DO_NOT_CALL | Do Not Call: | 電話不可: |
|
| phone_home
| phone | LBL_HOME_PHONE | Home: | 自宅電話: |
|
| phone_mobile
| phone | LBL_MOBILE_PHONE | Mobile: | 携帯電話: |
|
| phone_work
| phone | LBL_OFFICE_PHONE | Office Phone: | 会社電話: |
|
| phone_other
| phone | LBL_OTHER_PHONE | Other Phone: | その他電話: |
|
| phone_fax
| phone | LBL_FAX_PHONE | Fax: | ファックス: |
|
| email1
| varchar | LBL_EMAIL_ADDRESS | Email: | 電子メール: |
|
| email2
| varchar | LBL_OTHER_EMAIL_ADDRESS | Other Email: | その他電子メール: |
|
| primary_address_street
| varchar | LBL_PRIMARY_ADDRESS_STREET | Primary Address Street: | 主な番地: |
|
| primary_address_street_2
| varchar | LBL_PRIMARY_ADDRESS_STREET_2 | Primary Address Street 2: | 主な住所 2: |
|
| primary_address_street_3
| varchar | LBL_PRIMARY_ADDRESS_STREET_3 | Primary Address Street 3: | 主な住所 3: |
|
| primary_address_city
| varchar | LBL_PRIMARY_ADDRESS_CITY | Primary Address City: | 主な市区町村: |
|
| primary_address_state
| varchar | LBL_PRIMARY_ADDRESS_STATE | Primary Address State: | 主な都道府県: |
|
| primary_address_postalcode
| varchar | LBL_PRIMARY_ADDRESS_POSTALCODE | Primary Address Postal Code: | 主な郵便番号: |
|
| primary_address_country
| varchar | LBL_PRIMARY_ADDRESS_COUNTRY | Primary Address Country: | 主な国: |
|
| alt_address_street
| varchar | LBL_ALT_ADDRESS_STREET | Alternate Address Street: | 別の番地: |
|
| alt_address_street_2
| varchar | LBL_ALT_ADDRESS_STREET_2 | Alternate Address Street 2: | 別の住所 2: |
|
| alt_address_street_3
| varchar | LBL_ALT_ADDRESS_STREET_3 | Alternate Address Street 3: | 別の住所 3: |
|
| alt_address_city
| varchar | LBL_ALT_ADDRESS_CITY | Alternate Address City: | 別の市区町村: |
|
| alt_address_state
| varchar | LBL_ALT_ADDRESS_STATE | Alternate Address State: | 別の都道府県: |
|
| alt_address_postalcode
| varchar | LBL_ALT_ADDRESS_POSTALCODE | Alternate Address Postal Code: | 別の郵便番号: |
|
| alt_address_country
| varchar | LBL_ALT_ADDRESS_COUNTRY | Alternate Address Country: | 別の国: |
|
| assistant
| varchar | LBL_ASSISTANT | Assistant: | アシスタント: |
|
| assistant_phone
| phone | LBL_ASSISTANT_PHONE | Assistant Phone: | アシスタント電話: |
|
| email_and_name1
| varchar | LBL_NAME | Name: | 名前: |
|
| lead_source
| enum | LBL_LEAD_SOURCE | Lead Source: | リードソース: | lead_source_dom
|
| account_name
| relate | LBL_ACCOUNT_NAME | Account Name: | 取引先: |
|
| account_id
| relate | LBL_ACCOUNT_ID | Account ID: | 取引先ID: |
|
| opportunity_role_fields
| relate | LBL_ACCOUNT_NAME | Account Name: | 取引先: |
|
| opportunity_role_id
| varchar | LBL_OPPORTUNITY_ROLE_ID | Opportunity Role ID: | 商談の役割ID: |
|
| opportunity_role
| enum | LBL_OPPORTUNITY_ROLE | Opportunity Role | 商談での役割 | opportunity_relationship_type_dom
|
| reports_to_id
| id | LBL_REPORTS_TO_ID | Reports to ID: | 上司ID: |
|
| report_to_name
| relate | LBL_REPORTS_TO | Reports To: | 上司: |
|
| birthdate
| date | LBL_BIRTHDATE | Birthdate: | 誕生日: |
|
| portal_name
| varchar | LBL_PORTAL_NAME | Portal Name: | ポータルユーザ名: |
|
| portal_active
| bool | LBL_PORTAL_ACTIVE | Portal Active: | ポータルアクティブ: |
|
| portal_app
| varchar | LBL_PORTAL_APP | Portal Application: | ポータルアプリケーション: |
|
| campaign_id
| id | LBL_CAMPAIGN_ID | Campaign ID | キャンペーンID |
|
| campaign_name
| relate | LBL_CAMPAIGN | Campaign: | キャンペーン: |
|
| c_accept_status_fields
| relate | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 |
|
| m_accept_status_fields
| relate | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 |
|
| accept_status_id
| varchar | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 |
|
| accept_status_name
| enum | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 | dom_meeting_accept_status
|
| sync_contact
| bool | LBL_SYNC_CONTACT | Sync to Outlook®: | Outlook®と同期: |
|
Documents
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | ID |
|
| name
| varchar | | | |
|
| date_entered
| datetime | LBL_DATE_ENTERED | Date Entered | 入力日 |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | Date Modified | 更新日 |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | | 更新者ID |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | 更新者ごと |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | | 作成者ID |
|
| created_by_name
| relate | LBL_CREATED | Created by | 作成者 |
|
| description
| text | LBL_DESCRIPTION | Description | 詳細 |
|
| deleted
| bool | LBL_DELETED | Deleted | 削除済み |
|
| document_name
| varchar | LBL_NAME | Document Name | ドキュメント名 |
|
| filename
| file | LBL_FILENAME | File Name: | ファイル名: |
|
| uploadfile
| file | LBL_FILENAME | File Name: | ファイル名: |
|
| active_date
| date | LBL_DOC_ACTIVE_DATE | Publish Date: | 発行日: |
|
| exp_date
| date | LBL_DOC_EXP_DATE | Expiration Date: | 有効期限: |
|
| category_id
| enum | LBL_SF_CATEGORY | Category: | カテゴリ: | document_category_dom
|
| subcategory_id
| enum | LBL_SF_SUBCATEGORY | Sub Category: | サブカテゴリ: | document_subcategory_dom
|
| status_id
| enum | LBL_DOC_STATUS | Status: | ステータス: | document_status_dom
|
| status
| varchar | LBL_DOC_STATUS | Status: | ステータス: |
|
| document_revision_id
| varchar | LBL_LATEST_REVISION | Latest Revision | 最新版数 |
|
| revision
| varchar | LBL_DOC_VERSION | Revision: | 版数: |
|
| last_rev_created_name
| varchar | LBL_LAST_REV_CREATOR | Revision Created By: | 版数作成者: |
|
| last_rev_mime_type
| varchar | LBL_LAST_REV_MIME_TYPE | | |
|
| latest_revision
| varchar | LBL_LATEST_REVISION | Latest Revision | 最新版数 |
|
| last_rev_create_date
| date | LBL_LAST_REV_CREATE_DATE | Last Revision Create Date | 最終リビジョンの作成日 |
|
| related_doc_id
| varchar | LBL_RELATED_DOCUMENT_ID | Related Dcocument Id | 関連ドキュメントID |
|
| related_doc_name
| relate | LBL_DET_RELATED_DOCUMENT | Related Document: | 関連ドキュメント: |
|
| related_doc_rev_id
| varchar | LBL_RELATED_DOCUMENT_REVISION_ID | Related Document Revision Id | 関連ドキュメント版数ID |
|
| related_doc_rev_number
| varchar | LBL_DET_RELATED_DOCUMENT_VERSION | Related Document Revision: | 関連ドキュメントのリビジョン: |
|
| is_template
| bool | LBL_IS_TEMPLATE | Is a Template | テンプレート |
|
| template_type
| enum | LBL_TEMPLATE_TYPE | Document Type | ドキュメントタイプ | document_template_type_dom
|
| latest_revision_name
| varchar | | | |
|
| selected_revision_name
| varchar | | | |
|
| contract_status
| varchar | | | |
|
| contract_name
| varchar | | | |
|
| linked_id
| varchar | | | |
|
| selected_revision_id
| varchar | | | |
|
| latest_revision_id
| varchar | | | |
|
| selected_revision_filename
| varchar | | | |
|
Leads
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | |
|
| name
| name | LBL_FULL_NAME | Full Name: | フルネーム: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | | |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | Modified By Id | 更新者ID |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | Created By Id | 作成者ID |
|
| created_by_name
| relate | LBL_CREATED | Created By | 作成者 |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | | |
|
| assigned_user_id
| relate | LBL_ASSIGNED_TO_ID | Assigned User: | アサイン先ユーザ: |
|
| assigned_user_name
| relate | LBL_ASSIGNED_TO_NAME | Assigned to | アサイン先 |
|
| salutation
| enum | LBL_SALUTATION | Salutation | 敬称 | salutation_dom
|
| first_name
| varchar | LBL_FIRST_NAME | First Name: | 名: |
|
| last_name
| varchar | LBL_LAST_NAME | Last Name: | 姓: |
|
| full_name
| name | LBL_FULL_NAME | Full Name: | フルネーム: |
|
| title
| varchar | LBL_TITLE | Title: | 職位: |
|
| department
| varchar | LBL_DEPARTMENT | Department: | 部署: |
|
| do_not_call
| bool | LBL_DO_NOT_CALL | Do Not Call: | 電話不可: |
|
| phone_home
| phone | LBL_HOME_PHONE | Home Phone: | 自宅電話: |
|
| phone_mobile
| phone | LBL_MOBILE_PHONE | Mobile: | 携帯電話: |
|
| phone_work
| phone | LBL_OFFICE_PHONE | Office Phone: | 会社電話: |
|
| phone_other
| phone | LBL_OTHER_PHONE | Other Phone: | その他電話: |
|
| phone_fax
| phone | LBL_FAX_PHONE | Fax: | ファックス: |
|
| email1
| varchar | LBL_EMAIL_ADDRESS | Email: | 電子メール: |
|
| email2
| varchar | LBL_OTHER_EMAIL_ADDRESS | Other Email: | その他電子メール: |
|
| primary_address_street
| varchar | LBL_PRIMARY_ADDRESS_STREET | Primary Address Street | 主な番地 |
|
| primary_address_street_2
| varchar | LBL_PRIMARY_ADDRESS_STREET_2 | Primary Address Street 2 | 主な住所 2 |
|
| primary_address_street_3
| varchar | LBL_PRIMARY_ADDRESS_STREET_3 | Primary Address Street 3 | 主な住所 3 |
|
| primary_address_city
| varchar | LBL_PRIMARY_ADDRESS_CITY | Primary Address City | 主な市区町村 |
|
| primary_address_state
| varchar | LBL_PRIMARY_ADDRESS_STATE | Primary Address State | 主な都道府県 |
|
| primary_address_postalcode
| varchar | LBL_PRIMARY_ADDRESS_POSTALCODE | Primary Address Postalcode | 主な郵便番号 |
|
| primary_address_country
| varchar | LBL_PRIMARY_ADDRESS_COUNTRY | Primary Address Country | 主な国 |
|
| alt_address_street
| varchar | LBL_ALT_ADDRESS_STREET | Alt Address Street | 別の住所 3 |
|
| alt_address_street_2
| varchar | LBL_ALT_ADDRESS_STREET_2 | Alt Address Street 2 | 別の番地 |
|
| alt_address_street_3
| varchar | LBL_ALT_ADDRESS_STREET_3 | Alt Address Street 3 | 別の住所 2 |
|
| alt_address_city
| varchar | LBL_ALT_ADDRESS_CITY | Alt Address City | 別の市区町村 |
|
| alt_address_state
| varchar | LBL_ALT_ADDRESS_STATE | Alt Address State | 別の都道府県 |
|
| alt_address_postalcode
| varchar | LBL_ALT_ADDRESS_POSTALCODE | Alt Address Postalcode | 別の郵便番号 |
|
| alt_address_country
| varchar | LBL_ALT_ADDRESS_COUNTRY | Alt Address Country | 別の国 |
|
| assistant
| varchar | LBL_ASSISTANT | Assistant | アシスタント |
|
| assistant_phone
| phone | LBL_ASSISTANT_PHONE | Assistant Phone | アシスタント電話番号 |
|
| converted
| bool | LBL_CONVERTED | Converted | コンバート済 |
|
| refered_by
| varchar | LBL_REFERED_BY | Referred By: | 紹介元: |
|
| lead_source
| enum | LBL_LEAD_SOURCE | Lead Source: | リードソース: | lead_source_dom
|
| lead_source_description
| text | LBL_LEAD_SOURCE_DESCRIPTION | Lead Source Description: | リードソース詳細: |
|
| status
| enum | LBL_STATUS | Status: | ステータス: | lead_status_dom
|
| status_description
| text | LBL_STATUS_DESCRIPTION | Status Description: | ステータス詳細: |
|
| reports_to_id
| id | LBL_REPORTS_TO_ID | Reports To ID | 上司ID |
|
| report_to_name
| relate | LBL_REPORTS_TO | Reports To: | 上司: |
|
| account_name
| varchar | LBL_ACCOUNT_NAME | Account Name: | 取引先: |
|
| account_description
| text | LBL_ACCOUNT_DESCRIPTION | Account Description | 取引先情報 |
|
| contact_id
| id | LBL_CONTACT_ID | Contact ID | 取引先担当者ID |
|
| account_id
| id | LBL_ACCOUNT_ID | Account ID | 取引先ID |
|
| opportunity_id
| id | LBL_OPPORTUNITY_ID | Opportunity ID | 商談ID |
|
| opportunity_name
| varchar | LBL_OPPORTUNITY_NAME | Opportunity Name: | 商談名: |
|
| opportunity_amount
| varchar | LBL_OPPORTUNITY_AMOUNT | Opportunity Amount: | 商談規模: |
|
| campaign_id
| id | LBL_CAMPAIGN_ID | Campaign Id | キャンペーンID |
|
| campaign_name
| relate | LBL_CAMPAIGN | Campaign: | キャンペーン: |
|
| webtolead_email1
| email | LBL_EMAIL_ADDRESS | Email: | 電子メール: |
|
| webtolead_email2
| email | LBL_OTHER_EMAIL_ADDRESS | Other Email: | その他電子メール: |
|
| webtolead_email_opt_out
| bool | LBL_EMAIL_OPT_OUT | Email Opt Out: | メール送信除外: |
|
| webtolead_invalid_email
| bool | LBL_INVALID_EMAIL | Invalid Email: | 無効な電子メール: |
|
| portal_name
| varchar | LBL_PORTAL_NAME | Portal Name: | ポータルユーザ名: |
|
| portal_app
| varchar | LBL_PORTAL_APP | Portal Application | ポータルアプリケーション |
|
Meetings
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | |
|
| name
| name | LBL_SUBJECT | Subject: | 件名: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | | |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_ID | | |
|
| modified_by_name
| relate | LBL_MODIFIED_NAME | | |
|
| created_by
| assigned_user_name | LBL_CREATED_ID | | |
|
| created_by_name
| relate | LBL_CREATED | | |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | | |
|
| assigned_user_id
| relate | LBL_ASSIGNED_TO_ID | | |
|
| assigned_user_name
| relate | LBL_ASSIGNED_TO_NAME | Assigned to: | アサイン先: |
|
| accept_status
| varchar | LBL_SUBJECT | Subject: | 件名: |
|
| location
| varchar | LBL_LOCATION | Location: | 場所: |
|
| duration_hours
| int | LBL_DURATION_HOURS | Duration Hours: | 時間: |
|
| duration_minutes
| int | LBL_DURATION_MINUTES | Duration Minutes: | 分: |
|
| date_start
| datetime | LBL_DATE | Start Date: | 開始日: |
|
| date_end
| date | LBL_DATE_END | Date End | 終了日 |
|
| parent_type
| varchar | LBL_LIST_RELATED_TO | Related to | 関連先 |
|
| status
| enum | LBL_STATUS | Status: | ステータス: | meeting_status_dom
|
| parent_id
| id | LBL_LIST_RELATED_TO | Related to | 関連先 |
|
| reminder_checked
| bool | LBL_REMINDER | Reminder: | リマインダー: |
|
| reminder_time
| int | LBL_REMINDER_TIME | Reminder Time | リマインダー時間 |
|
| outlook_id
| varchar | LBL_OUTLOOK_ID | Outlook ID | Outlook ID |
|
| contact_name
| relate | LBL_CONTACT_NAME | Contact: | 取引先担当者: |
|
| parent_name
| parent | LBL_LIST_RELATED_TO | Related to | 関連先 | parent_type_display
|
Notes
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_NAME | | |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | | |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED | | |
|
| modified_by_name
| relate | LBL_MODIFIED_BY | Modified By | 更新者 |
|
| created_by
| assigned_user_name | LBL_ASSIGNED_TO | | |
|
| created_by_name
| relate | LBL_CREATED_BY | Created By | 作成者 |
|
| name
| name | LBL_NOTE_SUBJECT | Note Subject: | ノート件名: |
|
| filename
| varchar | LBL_FILENAME | Attachment: | 添付ファイル: |
|
| file_mime_type
| varchar | LBL_FILE_MIME_TYPE | Mime Type | Mimeタイプ |
|
| file_url
| function | LBL_FILE_URL | File URL | ファイルURL |
|
| parent_type
| varchar | LBL_PARENT_TYPE | Parent Type | 親タイプ |
|
| parent_id
| id | LBL_PARENT_ID | Parent ID: | 親ID: |
|
| contact_id
| id | LBL_CONTACT_ID | Contact ID: | 取引先担当者ID: |
|
| portal_flag
| bool | LBL_PORTAL_FLAG | Display in Portal? | ポータルで表示？ |
|
| embed_flag
| bool | LBL_EMBED_FLAG | Embed in email? | 電子メールに埋め込み？ |
|
| description
| text | LBL_DESCRIPTION | Description | 詳細 |
|
| deleted
| bool | LBL_DELETED | | |
|
| parent_name
| parent | LBL_RELATED_TO | Related To: | 関係先: | record_type_display_notes
|
| contact_name
| relate | LBL_CONTACT_NAME | Contact: | 取引先担当者: |
|
| contact_phone
| phone | | | |
|
| contact_email
| varchar | LBL_EMAIL_ADDRESS | Email Address: | 電子メールアドレス: |
|
| account_id
| id | LBL_ACCOUNT_ID | Account ID: | 取引先ID: |
|
| opportunity_id
| id | LBL_OPPORTUNITY_ID | Opportunity ID: | 商談ID: |
|
| acase_id
| id | LBL_CASE_ID | Case ID: | ケースID |
|
| lead_id
| id | LBL_LEAD_ID | Lead ID: | リードID: |
|
Project
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | Id: | ID: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | Date Entered: | 入力日: |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | Date Modified: | 最終更新日: |
|
| assigned_user_id
| assigned_user_name | LBL_ASSIGNED_USER_ID | Assigned To: | アサイン先: |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_USER_ID | Modified User Id: | 更新ユーザID: |
|
| created_by
| assigned_user_name | LBL_CREATED_BY | Created By: | 作成者: |
|
| name
| name | LBL_NAME | Name: | 名前: |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| deleted
| bool | LBL_DELETED | Deleted: | 削除済み: |
|
| estimated_start_date
| date | LBL_DATE_START | Start Date: | 開始日: |
|
| estimated_end_date
| date | LBL_DATE_END | End Date: | 終了日: |
|
| status
| enum | LBL_STATUS | Status: | ステータス: | project_status_dom
|
| priority
| enum | LBL_PRIORITY | Priority: | 優先度: | projects_priority_options
|
| total_estimated_effort
| int | LBL_LIST_TOTAL_ESTIMATED_EFFORT | Total Estimated Effort (hrs) | 見積時間合計 |
|
| total_actual_effort
| int | LBL_LIST_TOTAL_ACTUAL_EFFORT | Total Actual Effort (hrs) | 実績時間合計 |
|
| assigned_user_name
| relate | LBL_ASSIGNED_USER_NAME | Assigned to: | アサイン先: |
|
ProjectTask
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | Id: | ID: |
|
| date_entered
| datetime | LBL_DATE_ENTERED | Date Entered: | 入力日: |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | Date Modified: | 最終更新日: |
|
| project_id
| id | LBL_PROJECT_ID | Project Id: | プロジェクトID: |
|
| project_task_id
| int | LBL_PROJECT_TASK_ID | Project Task Id: | プロジェクトタスクID: |
|
| name
| name | LBL_NAME | Name: | 名前: |
|
| description
| text | LBL_DESCRIPTION | Description: | 詳細: |
|
| predecessors
| text | LBL_PREDECESSORS | Predecessors: | 前提タスク: |
|
| date_start
| date | LBL_DATE_START | Start Date: | 開始日: |
|
| time_start
| int | LBL_TIME_START | Start Time: | 開始時間: |
|
| time_finish
| int | LBL_TIME_FINISH | Finish Time: | 完了時間: |
|
| date_finish
| date | LBL_DATE_FINISH | Finish Date: | 完了日: |
|
| duration
| int | LBL_DURATION | Duration: | 時間: |
|
| duration_unit
| text | LBL_DURATION_UNIT | Duration Unit: | 期間単位: |
|
| actual_duration
| int | LBL_DURATION | Duration: | 時間: |
|
| percent_complete
| int | LBL_PERCENT_COMPLETE | Percent Complete (%): | % 完了: : |
|
| parent_task_id
| int | LBL_PARENT_TASK_ID | Parent Task Id: | 親タスクID: |
|
| assigned_user_id
| assigned_user_name | LBL_ASSIGNED_USER_ID | Assigned To: | アサイン先: |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_USER_ID | Modified User Id: | 更新ユーザID: |
|
| priority
| enum | LBL_PRIORITY | Priority: | 優先度: | project_task_priority_options
|
| created_by
| assigned_user_name | LBL_CREATED_BY | Created By: | 作成者: |
|
| milestone_flag
| bool | LBL_MILESTONE_FLAG | Milestone: | マイルストーン: |
|
| actual_effort
| int | LBL_ACTUAL_EFFORT | Actual Effort (hrs): | 実績時間 (時間): |
|
| deleted
| bool | LBL_DELETED | Deleted: | 削除済み: |
|
| project_name
| relate | LBL_PARENT_NAME | Project Name | LBL_PARENT_NAME |
|
| assigned_user_name
| relate | LBL_ASSIGNED_USER_NAME | Assigned To | LBL_ASSIGNED_USER_NAME |
|
Users
| フィールド名 | タイプ | ラベル | 英語 | 日本語 | オプション
|
| id
| id | LBL_ID | | |
|
| user_name
| user_name | LBL_USER_NAME | User Name | ユーザ名 |
|
| user_hash
| varchar | LBL_USER_HASH | | |
|
| authenticate_id
| varchar | LBL_AUTHENTICATE_ID | | |
|
| sugar_login
| bool | LBL_SUGAR_LOGIN | Is Sugar User | Sugarユーザ |
|
| first_name
| name | LBL_FIRST_NAME | First Name | 名 |
|
| last_name
| name | LBL_LAST_NAME | Last Name | 姓 |
|
| full_name
| name | LBL_NAME | Full Name | 名前 |
|
| name
| varchar | LBL_NAME | Full Name | 名前 |
|
| reports_to_id
| id | LBL_REPORTS_ID | | |
|
| reports_to_name
| relate | LBL_LIST_REPORTS_TO_NAME | | |
|
| is_admin
| bool | LBL_IS_ADMIN | Is Administrator | 管理者 |
|
| receive_notifications
| bool | LBL_RECEIVE_NOTIFICATIONS | Notify on Assignment | アサインの通知 |
|
| description
| text | LBL_DESCRIPTION | Description | 詳細 |
|
| date_entered
| datetime | LBL_DATE_ENTERED | | |
|
| date_modified
| datetime | LBL_DATE_MODIFIED | | |
|
| modified_user_id
| assigned_user_name | LBL_MODIFIED_BY | | |
|
| modified_by_name
| varchar | LBL_MODIFIED_BY | | |
|
| created_by
| assigned_user_name | LBL_ASSIGNED_TO | | |
|
| created_by_name
| varchar | | | |
|
| title
| varchar | LBL_TITLE | Title | 職位 |
|
| department
| varchar | LBL_DEPARTMENT | Department | 部署 |
|
| phone_home
| varchar | LBL_HOME_PHONE | Home Phone | 自宅の電話番号 |
|
| phone_mobile
| varchar | LBL_MOBILE_PHONE | Mobile | 携帯電話 |
|
| phone_work
| varchar | LBL_WORK_PHONE | Work Phone | 勤務先電話番号 |
|
| phone_other
| varchar | LBL_OTHER_PHONE | Other Phone | 他の電話番号 |
|
| phone_fax
| varchar | LBL_FAX_PHONE | Fax | FAX |
|
| status
| enum | LBL_STATUS | Status | ステータス | user_status_dom
|
| address_street
| varchar | LBL_ADDRESS_STREET | Address Street | 住所 番地 |
|
| address_city
| varchar | LBL_ADDRESS_CITY | Address City | 住所 市区町村 |
|
| address_state
| varchar | LBL_ADDRESS_STATE | Address State | 住所 都道府県 |
|
| address_country
| varchar | LBL_ADDRESS_COUNTRY | Address Country | 住所 国 |
|
| address_postalcode
| varchar | LBL_ADDRESS_POSTALCODE | Address Postal Code | 住所 郵便番号 |
|
| user_preferences
| text | LBL_USER_PREFERENCES | | |
|
| deleted
| bool | LBL_DELETED | | |
|
| portal_only
| bool | LBL_PORTAL_ONLY | Portal Only User | ポータルのみのユーザ |
|
| employee_status
| varchar | LBL_EMPLOYEE_STATUS | Employee Status | 従業員のステータス |
|
| messenger_id
| varchar | LBL_MESSENGER_ID | IM Name | IM名 |
|
| messenger_type
| varchar | LBL_MESSENGER_TYPE | IM Type | IMタイプ |
|
| email1
| varchar | LBL_EMAIL_ADDRESS | | |
|
| is_group
| bool | LBL_GROUP | Group User | グループユーザ |
|
| c_accept_status_fields
| relate | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 |
|
| m_accept_status_fields
| relate | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 |
|
| accept_status_id
| varchar | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 |
|
| accept_status_name
| enum | LBL_LIST_ACCEPT_STATUS | Accept Status | 許可状況 | dom_meeting_accept_status
|
