テーブル
本製品 はSugarCRM のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData ODBC Driver for SugarCRM テーブル
| Name | Description |
| Accounts | The Accounts table. |
| ACLRoles | The ACLRoles table. |
| ArchiveRuns | The ArchiveRuns table. |
| Bugs | The Bugs table. |
| BusinessCenters | The BusinessCenters table. |
| Calendar | The Calendar table. |
| Calls | The Calls table. |
| CampaignLog | The CampaignLog table. |
| Campaigns | The Campaigns table. |
| CampaignTrackers | The CampaignTrackers table. |
| Cases | The Cases table. |
| Categories | The Categories table. |
| ChangeTimers | The ChangeTimers table. |
| CJ_Forms | The CJ_Forms table. |
| CJ_WebHooks | The CJ_WebHooks table. |
| CloudDrivePaths | The CloudDrivePaths table. |
| CommentLog | The CommentLog table. |
| Comments | The Comments table. |
| ConsoleConfiguration | The ConsoleConfiguration table. |
| Contacts | The Contacts table. |
| Contracts | The Contracts table. |
| ContractTypes | The ContractTypes table. |
| Currencies | The Currencies table. |
| CustomQueries | The CustomQueries table. |
| Dashboards | The Dashboards table. |
| DataArchiver | The DataArchiver table. |
| DataPrivacy | The DataPrivacy table. |
| DataSets | The DataSets table. |
| DocumentMerges | The DocumentMerges table. |
| DocumentRevisions | The DocumentRevisions table. |
| Documents | The Documents table. |
| DocumentTemplates | The DocumentTemplates table. |
| DocuSignEnvelopes | The DocuSignEnvelopes table. |
| DRI_SubWorkflows | The DRI_SubWorkflows table. |
| DRI_SubWorkflow_Templates | The DRI_SubWorkflow_Templates table. |
| DRI_Workflows | The DRI_Workflows table. |
| DRI_Workflow_Task_Templates | The DRI_Workflow_Task_Templates table. |
| DRI_Workflow_Templates | The DRI_Workflow_Templates table. |
| EAPM | The EAPM table. |
| EmailAddresses | The EmailAddresses table. |
| EmailMarketing | The EmailMarketing table. |
| EmailParticipants | The EmailParticipants table. |
| Emails | The Emails table. |
| EmailTemplates | The EmailTemplates table. |
| EmbeddedFiles | The EmbeddedFiles table. |
| Employees | The Employees table. |
| Escalations | The Escalations table. |
| ExternalUsers | The ExternalUsers table. |
| Filters | The Filters table. |
| ForecastManagerWorksheets | The ForecastManagerWorksheets table. |
| Forecasts | The Forecasts table. |
| ForecastWorksheets | The ForecastWorksheets table. |
| Geocode | The Geocode table. |
| HintAccountsets | The HintAccountsets table. |
| HintEnrichFieldConfigs | The HintEnrichFieldConfigs table. |
| HintNewsNotifications | The HintNewsNotifications table. |
| HintNotificationTargets | The HintNotificationTargets table. |
| Holidays | The Holidays table. |
| InboundEmail | The InboundEmail table. |
| KBArticles | The KBArticles table. |
| KBContents | The KBContents table. |
| KBContentTemplates | The KBContentTemplates table. |
| KBDocuments | The KBDocuments table. |
| Leads | The Leads table. |
| Manufacturers | The Manufacturers table. |
| Meetings | The Meetings table. |
| Messages | The Messages table. |
| Metrics | The Metrics table. |
| MobileDevices | The MobileDevices table. |
| Notes | The Notes table. |
| Notifications | The Notifications table. |
| OAuthKeys | The OAuthKeys table. |
| OAuthTokens | The OAuthTokens table. |
| Opportunities | The Opportunities table. |
| OutboundEmail | The OutboundEmail table. |
| PdfManager | The PdfManager table. |
| pmse_Business_Rules | The pmse_Business_Rules table. |
| pmse_Emails_Templates | The pmse_Emails_Templates table. |
| pmse_Inbox | The pmse_Inbox table. |
| pmse_Project | The pmse_Project table. |
| ProductBundleNotes | The ProductBundleNotes table. |
| ProductBundles | The ProductBundles table. |
| ProductCategories | The ProductCategories table. |
| Products | The Products table. |
| ProductTemplates | The ProductTemplates table. |
| ProductTypes | The ProductTypes table. |
| Project | The Project table. |
| ProjectTask | The ProjectTask table. |
| ProspectLists | The ProspectLists table. |
| PubSub_ModuleEvent_PushSubs | The PubSub_ModuleEvent_PushSubs table. |
| PurchasedLineItems | The PurchasedLineItems table. |
| Purchases | The Purchases table. |
| PushNotifications | The PushNotifications table. |
| Quotas | The Quotas table. |
| Quotes | The Quotes table. |
| Releases | The Releases table. |
| ReportMaker | The ReportMaker table. |
| Reports | The Reports table. |
| ReportSchedules | The ReportSchedules table. |
| RevenueLineItems | The RevenueLineItems table. |
| SavedSearch | The SavedSearch table. |
| Schedulers | The Schedulers table. |
| ShiftExceptions | The ShiftExceptions table. |
| Shifts | The Shifts table. |
| Shippers | The Shippers table. |
| Styleguide | The Styleguide table. |
| Subscriptions | The Subscriptions table. |
| SugarFavorites | The SugarFavorites table. |
| SugarLive | The SugarLive table. |
| Tags | The Tags table. |
| Tasks | The Tasks table. |
| TaxRates | The TaxRates table. |
| TeamNotices | The TeamNotices table. |
| Teams | The Teams table. |
| TimePeriods | The TimePeriods table. |
| TrackerPerfs | The TrackerPerfs table. |
| TrackerQueries | The TrackerQueries table. |
| Trackers | The Trackers table. |
| TrackerSessions | The TrackerSessions table. |
| Users | The Users table. The maximum page size for this table is 20. |
| UserSignatures | The UserSignatures table. |
| VisualPipeline | The VisualPipeline table. |
| WebLogicHooks | The WebLogicHooks table. |
| WorkFlow | The WorkFlow table. |
本製品 は、テーブル に記載されていないSugarCRM アカウントにもカスタムモジュールを公開できます。普通のテーブルと同様に、このカスタムモジュールに対してクエリを実行できます。さらに、標準モジュールのカスタムフィールドをクエリすることができます。