Establishing a Connection

Adding a Connection to Microsoft Dynamics CRM

To add a connection to Microsoft Dynamics CRM:

In the application console, navigate to the Connections page.
At the Add Connections panel, select the icon for the connection you want to add.
If the Microsoft Dynamics CRM icon is not available, click the Add More icon to download and install the Microsoft Dynamics CRM connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to Microsoft Dynamics CRM

To connect, set Url to the root URL of your organization and set User, Password, and CRMVersion.

Authenticating to Microsoft Dynamics CRM

CRM On-Premises

For CRM on-premises, select an authentication method. By default, the Sync App uses Windows (NTLM) authentication. To use another authentication type, such as Kerberos delegation, set AuthScheme. The following is an example connection string:

AuthScheme=Auto;Url=https://myOrg.crm.dynamics.com/;User=username;Password=password;CRM Version='CRM2011+'"

Internet-Facing Deployments

For Dynamics CRM with IFD, set InternetFacingDeployment to true. The following is an example connection string:

AuthScheme=Auto;Url=https://myOrg.crm.dynamics.com/;User=username;Password=password;InternetFacingDeployment=True;CRM Version='CRM2011+'"

Azure AD

Microsoft Dynamics CRM supports Azure AD. To authenticate using Azure AD, you must create a custom application to obtain the OAuthClientId, OAuthClientSecret to use custom Azure AD credentials.

Set your AuthScheme to AzureAD. The rest of the Azure AD flows assume that you have done so.

When you connect, the Sync App opens the Azure AD endpoint in your default browser. Log in and grant permissions to the application. The Sync App then completes the following Azure AD process:

Gets the callback URL and sets the access token and ADFSServer to authenticate requests.
Saves OAuth values in your connection settings. These values persist across connections.
Exchanges the returned refresh token for a new, valid access token.

The following is an example connection string for Internet-Facing Deployments:

AuthScheme=OAuth;Url=https://myOrg.crm.dynamics.com/;CRM Version=CRM2011+;InitiateOAuth=GETANDREFRESH;CallbackUrl=http://localhost:33333;OAuthClientId=ClientID;ADFSServer=https://auth.adfs.com/;"

The following is an example connection string for Online Instance:

AuthScheme=OAuth;Url=https://myOrg.crm.dynamics.com/;CRM Version=CRMOnline;InitiateOAuth=GETANDREFRESH;CallbackUrl=http://localhost:33333;OAuthClientId=ClientID;AzureTenant=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;"

Headless Machines

To configure the driver, use OAuth with a user account on a headless machine. You need to authenticate on another device that has an internet browser.

Choose one of these two options:
- Option 1: Obtain the OAuthVerifier value as described in "Obtain and Exchange a Verifier Code" below.
- Option 2: Install the Sync App on another machine and transfer the OAuth authentication values after you authenticate through the usual browser-based flow.
Then configure the Sync App to automatically refresh the access token from the headless machine.

Option 1: Obtain and Exchange a Verifier Code

To obtain a verifier code, you must authenticate at the OAuth authorization URL.

Follow the steps below to authenticate from the machine with an internet browser and obtain the OAuthVerifier connection property.

Choose one of these options:
- If you are using the Embedded OAuth Application click Microsoft Dynamics CRM OAuth endpoint to open the endpoint in your browser.
- If you are using a custom OAuth application, create the Authorization URL by setting the following properties:
  - InitiateOAuth: OFF.
  - OAuthClientId: The client Id assigned when you registered your application.
  - OAuthClientSecret: The client secret assigned when you registered your application.
  Then call the GetOAuthAuthorizationUrl stored procedure with the appropriate CallbackURL. Open the URL returned by the stored procedure in a browser.
Log in and grant permissions to the Sync App. You are then redirected to the callback URL, which contains the verifier code.
Save the value of the verifier code. Later you need this for the OAuthVerifier connection property.

Next, you need to exchange the OAuth verifier code for OAuth refresh and access tokens. Set the following properties:

On the headless machine, set the following connection properties to obtain the OAuth authentication values:

InitiateOAuth: REFRESH.
OAuthVerifier: The verifier code.
OAuthClientId: (custom applications only) The client Id in your custom OAuth application settings.
OAuthClientSecret: (custom applications only) The client secret in the custom OAuth application settings.
OAuthSettingsLocation: The location of the file where the driver saves the OAuth token values that persist across connections.

After the OAuth settings file is generated, you need to re-set the following properties to connect:

InitiateOAuth: REFRESH.
OAuthClientId: (custom applications only) The client Id assigned when you registered your application.
OAuthClientSecret: (custom applications only) The client secret assigned when you registered your application.
OAuthSettingsLocation: The location containing the encrypted OAuth authentication values. Make sure this location grants read and write permissions to the Sync App to enable the automatic refreshing of the access token.

Option 2: Transfer OAuth Settings

Prior to connecting on a headless machine, you need to create and install a connection with the driver on a device that supports an internet browser. Set the connection properties as described in "Desktop Applications" above.

After completing the instructions in "Desktop Applications", the resulting authentication values are encrypted and written to the location specified by OAuthSettingsLocation. The default filename is OAuthSettings.txt.

Once you have successfully tested the connection, copy the OAuth settings file to your headless machine.

On the headless machine, set the following connection properties to connect to data:

InitiateOAuth: REFRESH.
OAuthClientId: (custom applications only) The client Id assigned when you registered your application.
OAuthClientSecret: (custom applications only) The client secret assigned when you registered your application.
OAuthSettingsLocation: The location of your OAuth settings file. Make sure this location gives read and write permissions to the Sync App to enable the automatic refreshing of the access token.

Client Credentials

Client credentials refers to a flow in OAuth where there is no direct user authentication taking place. Instead, credentials are created for just the application itself. All tasks taken by the application are done without a default user context. This makes the authentication flow a bit different from standard.

Client OAuth Flow

All permissions related to the client oauth flow require admin consent. This means the application embedded with the CData Sync App cannot be used in the client oauth flow. You must create your own OAuth application to use client credentials. See Creating a Custom OAuth Application for more details.

In your App Registration in portal.azure.com, navigate to API Permissions and select the Microsoft Graph permissions. There are two distinct sets of permissions - Delegated and Application permissions. The permissions used during client credential authentication are under Application Permissions. Select the applicable permissions you require for your integration.

You are ready to connect after setting one of the below connection properties groups depending on the authentication type.

Client Secret
- InitiateOAuth: GETANDREFRESH. Use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
- AzureTenant: The tenant you wish to connect to.
- OAuthGrantType: CLIENT.
- OAuthClientId: The Client Id in your application settings.
- OAuthClientSecret: The Client Secret in your application settings.
Certificate
- InitiateOAuth: GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
- AzureTenant: The tenant you wish to connect to.
- OAuthGrantType: CLIENT.
- OAuthClientId: The Client Id in your application settings.
- OAuthJWTCert: The JWT Certificate store.
- OAuthJWTCertType: The type of the certificate store specified by OAuthJWTCert.

Authentication with client credentials takes place automatically like any other connection, except there is no window opened prompting the user. Because there is no user context, there is no need for a browser popup. Connections take place and are handled internally.

Azure Service Principal

Authentication as an Azure Service Principal is handled via the OAuth Client Credentials flow, and it does not involve direct user authentication. Instead, credentials are created for just the application itself. All tasks taken by the application are done without a default user context but based on the assigned roles. The application access to the resources is controlled through the assigned roles' permissions.

Create an Azure AD App and an Azure Service Principal

When authenticating using an Azure Service Principal, you must register an application with an Azure AD tenant. Assign a role to the application To access resources in your subscription, you must assign a role to the application.

Open the Subscriptions page by searching and selecting the Subscriptions service from the search bar.
Select the subscription to assign the application to.
Open the Access control (IAM) and select Add > Add role assignment to open the Add role assignment page.
Select Owner as the role to assign to your created Azure AD app.

Complete the Authentication You are ready to connect after

setting the properties described "In Both Methods" below.
setting group properties. Choosing the group depends on the configured application authentication (client secret or certificate).

In Both Methods

Before choosing client secret or certificate authentication, follow these steps then continue to the relevant section below:

AuthScheme: The AzureServicePrincipal in your application settings.
InitiateOAuth: GETANDREFRESH. Use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
AzureTenant: The tenant you wish to connect to.
OAuthClientId: The client Id in your application settings.

Authenticating using a Client Secret

Continue with the following:

OAuthClientId: The client Id in your application settings.
OAuthClientSecret: The client secret in your application settings.

Authenticating using a Certificate

Continue with the following:

OAuthJWTCert: The JWT Certificate store.
OAuthJWTCertType: The type of the certificate store specified by OAuthJWTCert.

Kerberos

See Using Kerberos for details on how to authenticate with Kerberos.

Client Secret
- InitiateOAuth: GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
- AzureTenant: The tenant you wish to connect to.
- OAuthGrantType: CLIENT.
- OAuthClientId: The client Id in your application settings.
- OAuthClientSecret: The client secret in your application settings.
Certificate
- InitiateOAuth: GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
- AzureTenant: The tenant you wish to connect to.
- OAuthGrantType: CLIENT.
- OAuthClientId: The client Id in your application settings.
- OAuthJWTCert: The JWT Certificate store.
- OAuthJWTCertType: The type of the certificate store specified by OAuthJWTCert.

Creating a Custom Azure SP App

Creating a custom AzureAD application and a service principal that can access the necessary resources is required when authenticating using an Azure Service Principal.

Steps to Create an AzureAD SP App

Follow the steps below to create a custom AzureAD application and obtain the connection properties for the Azure Service Principal authentication.

Log in to https://portal.azure.com.
In the left-hand navigation pane, select Azure Active Directory > App Registrations and click New registration.
Enter an application name and select Any Azure AD Directory - Multi Tenant. Then set the redirect URL to http://localhost:33333, the Sync App's default, or a URL of your choosing.
After creating the app, copy the Application (client) Id value displayed in the "Overview" section, since this value is used as the OAuthClientId
Define the application authentication type by navigating to the "Certificates & Secrets" section. There are two types of authentication available: client secret and certificate. The recommended authentication method is via a certificate.
- Option 1 - Upload a certificate: In "Certificates & Secrets", select Upload certificate and the certificate to upload from your local machine.
- Option 2 - Create a new application secret: In "Certificates & Secrets", select New Client Secret for the application and specify its duration. After saving the client secret, the key value is displayed. Copy this value since it is displayed only once. You will use it as the OAuthClientSecret.
On the Authentication tab, make sure to select the option Access tokens (used for implicit flows).

Using Kerberos

Kerberos

To authenticate to Microsoft Dynamics CRM with Kerberos, set AuthScheme to KERBEROS.

Authenticating to Microsoft Dynamics CRM via Kerberos requires you to define authentication properties and to choose how Kerberos should retrieve authentication tickets.

Retrieve Kerberos Tickets

Kerberos tickets are used to authenticate the requester's identity. The use of tickets instead of formal logins/passwords eliminates the need to store passwords locally or send them over a network. Users are reauthenticated (tickets are refreshed) whenever they log in at their local computer or enter kinit USER at the command prompt.

The Sync App provides three ways to retrieve the required Kerberos ticket, depending on whether or not the KRB5CCNAME and/or KerberosKeytabFile variables exist in your environment.

MIT Kerberos Credential Cache File

This option enables you to use the MIT Kerberos Ticket Manager or kinit command to get tickets. With this option there is no need to set the User or Password connection properties.

This option requires that KRB5CCNAME has been created in your system.

To enable ticket retrieval via MIT Cerberos Credential Cache Files:

Ensure that the KRB5CCNAME variable is present in your environment.
Set KRB5CCNAME to a path that points to your credential cache file. (For example, C:\krb_cache\krb5cc_0 or /tmp/krb5cc_0.) The credential cache file is created when you use the MIT Kerberos Ticket Manager to generate your ticket.
To obtain a ticket:
1. Open the MIT Kerberos Ticket Manager application.
2. Click Get Ticket.
3. Enter your principal name and password.
4. Click OK.
If the ticket is successfully obtained, the ticket information appears in Kerberos Ticket Manager and is stored in the credential cache file.

The Sync App uses the cache file to obtain the Kerberos ticket to connect to Microsoft Dynamics CRM.

Note: If you would prefer not to edit KRB5CCNAME, you can use the KerberosTicketCache property to set the file path manually. After this is set, the Sync App uses the specified cache file to obtain the Kerberos ticket to connect to Microsoft Dynamics CRM.

Keytab File

If your environment lacks the KRB5CCNAME environment variable, you can retrieve a Kerberos ticket using a Keytab File.

To use this method, set the User property to the desired username, and set the KerberosKeytabFile property to a file path pointing to the keytab file associated with the user.

User and Password

If your environment lacks the KRB5CCNAME environment variable and the KerberosKeytabFile property has not been set, you can retrieve a ticket using a user and password combination.

To use this method, set the User and Password properties to the user/password combination that you use to authenticate with Microsoft Dynamics CRM.

Enabling Cross-Realm Authentication

More complex Kerberos environments can require cross-realm authentication where multiple realms and KDC servers are used. For example, they might use one realm/KDC for user authentication, and another realm/KDC for obtaining the service ticket.

To enable this kind of cross-realm authentication, set the KerberosRealm and KerberosKDC properties to the values required for user authentication. Also, set the KerberosServiceRealm and KerberosServiceKDC properties to the values required to obtain the service ticket.

Fine-Tuning Data Access

Fine Tuning Data Access

Use the following connection properties to control column name identifiers and other aspects of data access useful in more advanced integrations:

IncludeCalculatedColumns: This option controls whether the driver returns the Calculated Columns defined on a table. Only applicable for CRM 2015+.
UseNameForPicklistValue: Whether the string value should be used for picklist field values instead of integers.
UseDisplayNames: Whether the display names for the columns should be used instead of the API names
UseSimpleNames: Simplify the names of tables and columns returned. It will enforce a naming scheme such that only alphanumeric characters and the underscore are valid for the displayed table and column names.
DefaultPrecision: The currency precision that is used for pricing throughout the system. Valid values are 0-4 and Auto.
CallerId: The Id of a user to impersonate when inserting or updating new records.

Advanced Features

This section details a selection of advanced features of the Microsoft Dynamics CRM Sync App.

User Defined Views

The Sync App allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to Microsoft Dynamics CRM and then processes the rest of the query in memory (client-side).

See Query Processing for more information.

Logging

See Logging for an overview of configuration settings that can be used to refine CData logging. For basic logging, you only need to set two connection properties, but there are numerous features that support more refined logging, where you can select subsets of information to be logged using the LogModules connection property.

SSL Configuration

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
To tunnel the connection, set FirewallType to TUNNEL.
To authenticate, specify FirewallUser and FirewallPassword.
To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

Data Model

The CData Sync App models Microsoft Dynamics CRM entities in relational tables and stored procedures. The table definitions are dynamically obtained based on your Dynamics CRM organization settings.

Tables

Tables describes the available tables. Table definitions are dynamically retrieved. This section shows the sample table definitions that are included by the default Dynamics CRM organization.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Tables

The Sync App models the data in Microsoft Dynamics CRM as a list of tables in a relational database that can be queried using standard SQL statements.

Microsoft Dynamics CRM Connector for CData Sync Tables


Name	Description
Account	Create, update, delete, and query Account entities in Dynamics CRM.
ActivityMimeAttachment	Create, update, delete, and query ActivityMimeAttachment entities in Dynamics CRM.
ActivityParty	Create, update, delete, and query ActivityParty entities in Dynamics CRM.
ActivityPointer	Create, update, delete, and query ActivityPointer entities in Dynamics CRM.
Annotation	Create, update, delete, and query Annotation entities in Dynamics CRM.
AnnualFiscalCalendar	Create, update, delete, and query annual fiscal calendar entities in Dynamics CRM.
ApplicationFile	Create, update, delete, and query ApplicationFile entities in Dynamics CRM.
Appointment	Create, update, delete, and query Appointment entities in Dynamics CRM.
AsyncOperation	Create, update, delete, and query AsyncOperation entities in Dynamics CRM.
Attachment	Create, update, delete, and query Attachment entities in Dynamics CRM.
AttributeMap	Create, update, delete, and query AttributeMap entities in Dynamics CRM.
Audit	Create, update, delete, and query Audit entities in Dynamics CRM.
BulkDeleteFailure	Create, update, delete, and query BulkDeleteFailure entities in Dynamics CRM.
BulkDeleteOperation	Create, update, delete, and query BulkDeleteOperation entities in Dynamics CRM.
BulkOperation	Create, update, delete, and query BulkOperation entities in Dynamics CRM.
BulkOperationLog	This is a table representing the BulkOperationLog entities in Dynamics CRM.
BusinessUnit	This is a table representing the BusinessUnit entities in Dynamics CRM.
BusinessUnitMap	This is a table representing the BusinessUnitMap entities in Dynamics CRM.
BusinessUnitNewsArticle	This is a table representing the BusinessUnitNewsArticle entities in Dynamics CRM.
Calendar	This is a table representing the Calendar entities in Dynamics CRM.
Campaign	This is a table representing the Campaign entities in Dynamics CRM.
CampaignActivity	This is a table representing the CampaignActivity entities in Dynamics CRM.
CampaignActivityItem	This is a table representing the CampaignActivityItem entities in Dynamics CRM.
CampaignItem	This is a table representing the CampaignItem entities in Dynamics CRM.
CampaignResponse	This is a table representing the CampaignResponse entities in Dynamics CRM.
ClientUpdate	This is a table representing the ClientUpdate entities in Dynamics CRM.
ColumnMapping	This is a table representing the ColumnMapping entities in Dynamics CRM.
Commitment	This is a table representing the Commitment entities in Dynamics CRM.
Competitor	This is a table representing the Competitor entities in Dynamics CRM.
CompetitorAddress	This is a table representing the CompetitorAddress entities in Dynamics CRM.
CompetitorProduct	This is a table representing the CompetitorProduct entities in Dynamics CRM.
CompetitorSalesLiterature	This is a table representing the CompetitorSalesLiterature entities in Dynamics CRM.
Connection	This is a table representing the Connection entities in Dynamics CRM.
ConnectionRole	This is a table representing the ConnectionRole entities in Dynamics CRM.
ConnectionRoleAssociation	This is a table representing the ConnectionRoleAssociation entities in Dynamics CRM.
ConnectionRoleObjectTypeCode	This is a table representing the ConnectionRoleObjectTypeCode entities in Dynamics CRM.
ConstraintBasedGroup	This is a table representing the ConstraintBasedGroup entities in Dynamics CRM.
Contact	This is a table representing the Contact entities in Dynamics CRM.
ContactInvoices	This is a table representing the ContactInvoices entities in Dynamics CRM.
ContactLeads	This is a table representing the ContactLeads entities in Dynamics CRM.
ContactOrders	This is a table representing the ContactOrders entities in Dynamics CRM.
ContactQuotes	This is a table representing the ContactQuotes entities in Dynamics CRM.
Contract	This is a table representing the Contract entities in Dynamics CRM.
ContractDetail	This is a table representing the ContractDetail entities in Dynamics CRM.
ContractTemplate	This is a table representing the ContractTemplate entities in Dynamics CRM.
CustomerAddress	This is a table representing the CustomerAddress entities in Dynamics CRM.
CustomerOpportunityRole	This is a table representing the CustomerOpportunityRole entities in Dynamics CRM.
CustomerRelationship	This is a table representing the CustomerRelationship entities in Dynamics CRM.
Dependency	This is a table representing the Dependency entities in Dynamics CRM.
DependencyNode	This is a table representing the DependencyNode entities in Dynamics CRM.
Discount	This is a table representing the Discount entities in Dynamics CRM.
DiscountType	This is a table representing the DiscountType entities in Dynamics CRM.
DisplayString	This is a table representing the DisplayString entities in Dynamics CRM.
DisplayStringMap	This is a table representing the DisplayStringMap entities in Dynamics CRM.
DocumentIndex	This is a table representing the DocumentIndex entities in Dynamics CRM.
DuplicateRecord	This is a table representing the DuplicateRecord entities in Dynamics CRM.
DuplicateRule	This is a table representing the DuplicateRule entities in Dynamics CRM.
DuplicateRuleCondition	This is a table representing the DuplicateRuleCondition entities in Dynamics CRM.
Email	This is a table representing the Email entities in Dynamics CRM.
EmailHash	This is a table representing the EmailHash entities in Dynamics CRM.
EmailSearch	This is a table representing the EmailSearch entities in Dynamics CRM.
EntityMap	This is a table representing the EntityMap entities in Dynamics CRM.
Equipment	This is a table representing the Equipment entities in Dynamics CRM.
Fax	This is a table representing the Fax entities in Dynamics CRM.
FieldPermission	This is a table representing the FieldPermission entities in Dynamics CRM.
FieldSecurityProfile	This is a table representing the FieldSecurityProfile entities in Dynamics CRM.
FilterTemplate	This is a table representing the FilterTemplate entities in Dynamics CRM.
FixedMonthlyFiscalCalendar	This is a table representing the FixedMonthlyFiscalCalendar entities in Dynamics CRM.
Goal	This is a table representing the Goal entities in Dynamics CRM.
GoalRollupQuery	This is a table representing the GoalRollupQuery entities in Dynamics CRM.
Import	This is a table representing the Import entities in Dynamics CRM.
ImportData	This is a table representing the ImportData entities in Dynamics CRM.
ImportEntityMapping	This is a table representing the ImportEntityMapping entities in Dynamics CRM.
ImportFile	This is a table representing the ImportFile entities in Dynamics CRM.
ImportJob	This is a table representing the ImportJob entities in Dynamics CRM.
ImportLog	This is a table representing the ImportLog entities in Dynamics CRM.
ImportMap	This is a table representing the ImportMap entities in Dynamics CRM.
Incident	This is a table representing the Incident entities in Dynamics CRM.
IncidentResolution	This is a table representing the IncidentResolution entities in Dynamics CRM.
IntegrationStatus	This is a table representing the IntegrationStatus entities in Dynamics CRM.
InternalAddress	This is a table representing the InternalAddress entities in Dynamics CRM.
InterProcessLock	This is a table representing the InterProcessLock entities in Dynamics CRM.
InvalidDependency	This is a table representing the InvalidDependency entities in Dynamics CRM.
Invoice	This is a table representing the Invoice entities in Dynamics CRM.
InvoiceDetail	This is a table representing the InvoiceDetail entities in Dynamics CRM.
IsvConfig	This is a table representing the IsvConfig entities in Dynamics CRM.
KbArticle	This is a table representing the KbArticle entities in Dynamics CRM.
KbArticleComment	This is a table representing the KbArticleComment entities in Dynamics CRM.
KbArticleTemplate	This is a table representing the KbArticleTemplate entities in Dynamics CRM.
Lead	This is a table representing the Lead entities in Dynamics CRM.
LeadAddress	This is a table representing the LeadAddress entities in Dynamics CRM.
LeadCompetitors	This is a table representing the LeadCompetitors entities in Dynamics CRM.
LeadProduct	This is a table representing the LeadProduct entities in Dynamics CRM.
Letter	This is a table representing the Letter entities in Dynamics CRM.
License	This is a table representing the License entities in Dynamics CRM.
List	This is a table representing the List entities in Dynamics CRM.
ListMember	This is a table representing the ListMember entities in Dynamics CRM.
LookUpMapping	This is a table representing the LookUpMapping entities in Dynamics CRM.
MailMergeTemplate	This is a table representing the MailMergeTemplate entities in Dynamics CRM.
Metric	This is a table representing the Metric entities in Dynamics CRM.
MonthlyFiscalCalendar	This is a table representing the MonthlyFiscalCalendar entities in Dynamics CRM.
Notification	This is a table representing the Notification entities in Dynamics CRM.
Opportunity	This is a table representing the Opportunity entities in Dynamics CRM.
OpportunityClose	This is a table representing the OpportunityClose entities in Dynamics CRM.
OpportunityCompetitors	This is a table representing the OpportunityCompetitors entities in Dynamics CRM.
OpportunityProduct	This is a table representing the OpportunityProduct entities in Dynamics CRM.
OptionSetInfo	Gets basic information about the OptionSet values available for a given table and displays the mapping of OptionSet string values to OptionSet int values.
OrderClose	This is a table representing the OrderClose entities in Dynamics CRM.
Organization	This is a table representing the Organization entities in Dynamics CRM.
OrganizationStatistic	This is a table representing the OrganizationStatistic entities in Dynamics CRM.
OrganizationUI	This is a table representing the OrganizationUI entities in Dynamics CRM.
Owner	This is a table representing the Owner entities in Dynamics CRM.
OwnerMapping	This is a table representing the OwnerMapping entities in Dynamics CRM.
PhoneCall	This is a table representing the PhoneCall entities in Dynamics CRM.
PickListMapping	This is a table representing the PickListMapping entities in Dynamics CRM.
PluginAssembly	This is a table representing the PluginAssembly entities in Dynamics CRM.
plug-intype	This is a table representing the plug-in type entities in Dynamics CRM.
PluginTypeStatistic	This is a table representing the PluginTypeStatistic entities in Dynamics CRM.
PriceLevel	This is a table representing the PriceLevel entities in Dynamics CRM.
PrincipalAttributeAccessMap	This is a table representing the PrincipalAttributeAccessMap entities in Dynamics CRM.
PrincipalEntityMap	This is a table representing the PrincipalEntityMap entities in Dynamics CRM.
PrincipalObjectAccess	This is a table representing the PrincipalObjectAccess entities in Dynamics CRM.
PrincipalObjectAttributeAccess	This is a table representing the PrincipalObjectAttributeAccess entities in Dynamics CRM.
Privilege	This is a table representing the Privilege entities in Dynamics CRM.
PrivilegeObjectTypeCodes	This is a table representing the PrivilegeObjectTypeCodes entities in Dynamics CRM.
ProcessSession	This is a table representing the ProcessSession entities in Dynamics CRM.
Product	This is a table representing the Product entities in Dynamics CRM.
ProductAssociation	This is a table representing the ProductAssociation entities in Dynamics CRM.
ProductPriceLevel	This is a table representing the ProductPriceLevel entities in Dynamics CRM.
ProductSalesLiterature	This is a table representing the ProductSalesLiterature entities in Dynamics CRM.
ProductSubstitute	This is a table representing the ProductSubstitute entities in Dynamics CRM.
Publisher	This is a table representing the Publisher entities in Dynamics CRM.
PublisherAddress	This is a table representing the PublisherAddress entities in Dynamics CRM.
QuarterlyFiscalCalendar	This is a table representing the QuarterlyFiscalCalendar entities in Dynamics CRM.
Queue	This is a table representing the Queue entities in Dynamics CRM.
QueueItem	This is a table representing the QueueItem entities in Dynamics CRM.
Quote	This is a table representing the Quote entities in Dynamics CRM.
QuoteClose	This is a table representing the QuoteClose entities in Dynamics CRM.
QuoteDetail	This is a table representing the QuoteDetail entities in Dynamics CRM.
RecurrenceRule	This is a table representing the RecurrenceRule entities in Dynamics CRM.
RecurringAppointmentMaster	This is a table representing the RecurringAppointmentMaster entities in Dynamics CRM.
RelationshipRole	This is a table representing the RelationshipRole entities in Dynamics CRM.
RelationshipRoleMap	This is a table representing the RelationshipRoleMap entities in Dynamics CRM.
Report	This is a table representing the Report entities in Dynamics CRM.
ReportCategory	This is a table representing the ReportCategory entities in Dynamics CRM.
ReportEntity	This is a table representing the ReportEntity entities in Dynamics CRM.
ReportLink	This is a table representing the ReportLink entities in Dynamics CRM.
ReportVisibility	This is a table representing the ReportVisibility entities in Dynamics CRM.
Resource	This is a table representing the Resource entities in Dynamics CRM.
ResourceGroup	This is a table representing the ResourceGroup entities in Dynamics CRM.
ResourceGroupExpansion	This is a table representing the ResourceGroupExpansion entities in Dynamics CRM.
ResourceSpec	This is a table representing the ResourceSpec entities in Dynamics CRM.
RibbonCommand	This is a table representing the RibbonCommand entities in Dynamics CRM.
RibbonContextGroup	This is a table representing the RibbonContextGroup entities in Dynamics CRM.
RibbonCustomization	This is a table representing the RibbonCustomization entities in Dynamics CRM.
RibbonDiff	This is a table representing the RibbonDiff entities in Dynamics CRM.
RibbonRule	This is a table representing the RibbonRule entities in Dynamics CRM.
RibbonTabToCommandMap	This is a table representing the RibbonTabToCommandMap entities in Dynamics CRM.
Role	This is a table representing the Role entities in Dynamics CRM.
RolePrivileges	This is a table representing the RolePrivileges entities in Dynamics CRM.
RoleTemplate	This is a table representing the RoleTemplate entities in Dynamics CRM.
RoleTemplatePrivileges	This is a table representing the RoleTemplatePrivileges entities in Dynamics CRM.
RollupField	This is a table representing the RollupField entities in Dynamics CRM.
SalesLiterature	This is a table representing the SalesLiterature entities in Dynamics CRM.
SalesLiteratureItem	This is a table representing the SalesLiteratureItem entities in Dynamics CRM.
SalesOrder	This is a table representing the SalesOrder entities in Dynamics CRM.
SalesOrderDetail	This is a table representing the SalesOrderDetail entities in Dynamics CRM.
SalesProcessInstance	This is a table representing the SalesProcessInstance entities in Dynamics CRM.
SavedQuery	This is a table representing the SavedQuery entities in Dynamics CRM.
SavedQueryVisualization	This is a table representing the SavedQueryVisualization entities in Dynamics CRM.
SdkMessage	This is a table representing the SdkMessage entities in Dynamics CRM.
SdkMessageFilter	This is a table representing the SdkMessageFilter entities in Dynamics CRM.
SdkMessagePair	This is a table representing the SdkMessagePair entities in Dynamics CRM.
SdkMessageProcessingStep	This is a table representing the SdkMessageProcessingStep entities in Dynamics CRM.
SdkMessageProcessingStepImage	This is a table representing the SdkMessageProcessingStepImage entities in Dynamics CRM.
SdkMessageProcessingStepSecureConfig	This is a table representing the SdkMessageProcessingStepSecureConfig entities in Dynamics CRM.
SdkMessageRequest	This is a table representing the SdkMessageRequest entities in Dynamics CRM.
SdkMessageRequestField	This is a table representing the SdkMessageRequestField entities in Dynamics CRM.
SdkMessageResponse	This is a table representing the SdkMessageResponse entities in Dynamics CRM.
SdkMessageResponseField	This is a table representing the SdkMessageResponseField entities in Dynamics CRM.
SemiAnnualFiscalCalendar	This is a table representing the SemiAnnualFiscalCalendar entities in Dynamics CRM.
Service	This is a table representing the Service entities in Dynamics CRM.
ServiceAppointment	This is a table representing the ServiceAppointment entities in Dynamics CRM.
ServiceContractContacts	This is a table representing the ServiceContractContacts entities in Dynamics CRM.
ServiceEndpoint	This is a table representing the ServiceEndpoint entities in Dynamics CRM.
SharePointDocumentLocation	This is a table representing the SharePointDocumentLocation entities in Dynamics CRM.
SharePointSite	This is a table representing the SharePointSite entities in Dynamics CRM.
Site	This is a table representing the Site entities in Dynamics CRM.
SiteMap	This is a table representing the SiteMap entities in Dynamics CRM.
Solution	This is a table representing the Solution entities in Dynamics CRM.
SolutionComponent	This is a table representing the SolutionComponent entities in Dynamics CRM.
StatusMap	This is a table representing the StatusMap entities in Dynamics CRM.
StringMap	This is a table representing the StringMap entities in Dynamics CRM.
Subject	This is a table representing the Subject entities in Dynamics CRM.
Subscription	This is a table representing the Subscription entities in Dynamics CRM.
SubscriptionClients	This is a table representing the SubscriptionClients entities in Dynamics CRM.
SubscriptionManuallyTrackedObject	This is a table representing the SubscriptionManuallyTrackedObject entities in Dynamics CRM.
SubscriptionSyncInfo	This is a table representing the SubscriptionSyncInfo entities in Dynamics CRM.
SubscriptionTrackingDeletedObject	This is a table representing the SubscriptionTrackingDeletedObject entities in Dynamics CRM.
SystemForm	This is a table representing the SystemForm entities in Dynamics CRM.
SystemUser	This is a table representing the SystemUser entities in Dynamics CRM.
SystemUserBusinessUnitEntityMap	This is a table representing the SystemUserBusinessUnitEntityMap entities in Dynamics CRM.
SystemUserLicenses	This is a table representing the SystemUserLicenses entities in Dynamics CRM.
SystemUserPrincipals	This is a table representing the SystemUserPrincipals entities in Dynamics CRM.
SystemUserProfiles	This is a table representing the SystemUserProfiles entities in Dynamics CRM.
SystemUserRoles	This is a table representing the SystemUserRoles entities in Dynamics CRM.
Task	This is a table representing the Task entities in Dynamics CRM.
Team	This is a table representing the Team entities in Dynamics CRM.
TeamMembership	This is a table representing the TeamMembership entities in Dynamics CRM.
TeamProfiles	This is a table representing the TeamProfiles entities in Dynamics CRM.
TeamRoles	This is a table representing the TeamRoles entities in Dynamics CRM.
Template	This is a table representing the Template entities in Dynamics CRM.
Territory	This is a table representing the Territory entities in Dynamics CRM.
TimeZoneDefinition	This is a table representing the TimeZoneDefinition entities in Dynamics CRM.
TimeZoneLocalizedName	This is a table representing the TimeZoneLocalizedName entities in Dynamics CRM.
TimeZoneRule	This is a table representing the TimeZoneRule entities in Dynamics CRM.
TransactionCurrency	This is a table representing the TransactionCurrency entities in Dynamics CRM.
TransformationMapping	This is a table representing the TransformationMapping entities in Dynamics CRM.
TransformationParameterMapping	This is a table representing the TransformationParameterMapping entities in Dynamics CRM.
UnresolvedAddress	This is a table representing the UnresolvedAddress entities in Dynamics CRM.
UoM	This is a table representing the UoM entities in Dynamics CRM.
UoMSchedule	This is a table representing the UoMSchedule entities in Dynamics CRM.
UserEntityInstanceData	This is a table representing the UserEntityInstanceData entities in Dynamics CRM.
UserEntityUISettings	This is a table representing the UserEntityUISettings entities in Dynamics CRM.
UserFiscalCalendar	This is a table representing the UserFiscalCalendar entities in Dynamics CRM.
UserForm	This is a table representing the UserForm entities in Dynamics CRM.
UserQuery	This is a table representing the UserQuery entities in Dynamics CRM.
UserQueryVisualization	This is a table representing the UserQueryVisualization entities in Dynamics CRM.
UserSettings	This is a table representing the UserSettings entities in Dynamics CRM.
WebResource	This is a table representing the WebResource entities in Dynamics CRM.
WebWizard	This is a table representing the WebWizard entities in Dynamics CRM.
WizardAccessPrivilege	This is a table representing the WizardAccessPrivilege entities in Dynamics CRM.
WizardPage	This is a table representing the WizardPage entities in Dynamics CRM.
Workflow	This is a table representing the Workflow entities in Dynamics CRM.
WorkflowDependency	This is a table representing the WorkflowDependency entities in Dynamics CRM.
WorkflowLog	This is a table representing the WorkflowLog entities in Dynamics CRM.
WorkflowWaitSubscription	This is a table representing the WorkflowWaitSubscription entities in Dynamics CRM.

The CData Sync App can also expose custom entities from Dynamics CRM that are not mentioned in the Tables. You can query against these custom entities as you would any other table. Additionally, you can query against custom fields of standard entities.

There is a naming limitation that applies to the lists and to the custom fields. Empty spaces in list names are converted to underscores for the table names. Also, all custom fields and custom entities will be signified by Dynamics CRM with a new_ that precedes the name.

Account

Create, update, delete, and query Account entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the account.
AccountCategoryCode	String	False	Drop-down list for selecting the category of the account.
AccountClassificationCode	String	False	Drop-down list for classifying an account.
AccountId	String	False	Unique identifier of the account.
AccountNumber	String	False	User-provided account number used in correspondence about the account.
AccountRatingCode	String	False	Drop-down list for selecting account ratings.
Address1_AddressId	String	False	Unique identifier for address 1.
Address1_AddressTypeCode	String	False	Type of address for address 1, such as billing, shipping, or primary address.
Address1_City	String	False	City name for address 1.
Address1_Country	String	False	Country/region name for address 1.
Address1_County	String	False	County name for address 1.
Address1_Fax	String	False	Fax number for address 1.
Address1_FreightTermsCode	String	False	Freight terms for address 1.
Address1_Latitude	Double	False	Latitude for address 1.
Address1_Line1	String	False	First line for entering address 1 information.
Address1_Line2	String	False	Second line for entering address 1 information.
Address1_Line3	String	False	Third line for entering address 1 information.
Address1_Longitude	Double	False	Longitude for address 1.
Address1_Name	String	False	Name to enter for address 1.
Address1_PostalCode	String	False	ZIP code or postal code for address 1.
Address1_PostOfficeBox	String	False	Post office box number for address 1.
Address1_PrimaryContactName	String	False	Name of primary contact for address 1.
Address1_ShippingMethodCode	String	False	Method of shipment for address 1.
Address1_StateOrProvince	String	False	State or province for address 1.
Address1_Telephone1	String	False	First telephone number associated with address 1.
Address1_Telephone2	String	False	Second telephone number associated with address 1.
Address1_Telephone3	String	False	Third telephone number associated with address 1.
Address1_UPSZone	String	False	United Parcel Service (UPS) zone for address 1.
Address1_UTCOffset	Integer	False	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
Address2_AddressId	String	False	Unique identifier for address 2.
Address2_AddressTypeCode	String	False	Type of address for address 2, such as billing, shipping, or primary address.
Address2_City	String	False	City name for address 2.
Address2_Country	String	False	Country/region name for address 2.
Address2_County	String	False	County name for address 2.
Address2_Fax	String	False	Fax number for address 2.
Address2_FreightTermsCode	String	False	Freight terms for address 2.
Address2_Latitude	Double	False	Latitude for address 2.
Address2_Line1	String	False	First line for entering address 2 information.
Address2_Line2	String	False	Second line for entering address 2 information.
Address2_Line3	String	False	Third line for entering address 2 information.
Address2_Longitude	Double	False	Longitude for address 2.
Address2_Name	String	False	Name to enter for address 2.
Address2_PostalCode	String	False	ZIP code or postal code for address 2.
Address2_PostOfficeBox	String	False	Post office box number for address 2.
Address2_PrimaryContactName	String	False	Name of the primary contact located at address 2.
Address2_ShippingMethodCode	String	False	Method of shipment for address 2.
Address2_StateOrProvince	String	False	State or province for address 2.
Address2_Telephone1	String	False	First telephone number associated with address 2.
Address2_Telephone2	String	False	Second telephone number associated with address 2.
Address2_Telephone3	String	False	Third telephone number associated with address 2.
Address2_UPSZone	String	False	United Parcel Service (UPS) zone for address 2.
Address2_UTCOffset	Integer	False	UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
Aging30	Double	True	For internal use only.
Aging30_Base	Double	True	Base currency equivalent of the aging 30 for the account.
Aging60	Double	True	For internal use only.
Aging60_Base	Double	True	Base currency equivalent of the aging 60 for the account.
Aging90	Double	True	For internal use only.
Aging90_Base	Double	True	Base currency equivalent of the aging 90 for the account.
BusinessTypeCode	String	False	Type of business associated with the account.
CreatedBy_Id	String	True	Unique identifier of the user who created the account.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the account was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the account.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CreditLimit	Double	False	Credit limit for the account.
CreditLimit_Base	Double	True	Base currency equivalent of the credit limit for the account.
CreditOnHold	Boolean	False	Information about whether credit for the account is on hold.
CustomerSizeCode	String	False	Size of the account.
CustomerTypeCode	String	False	Type of the account.
DefaultPriceLevelId_Id	String	False	Unique identifier of the default price list associated with the account.
DefaultPriceLevelId_LogicalName	String	False
DefaultPriceLevelId_Name	String	False
Description	String	False	Description of the account.
DoNotBulkEMail	Boolean	False	Information about whether to allow sending direct email to the account.
DoNotBulkPostalMail	Boolean	False	Information about whether to allow sending bulk-rate postal mail to the account.
DoNotEMail	Boolean	False	Information about whether to allow sending email to the account.
DoNotFax	Boolean	False	Information about whether to allow sending faxes to the account.
DoNotPhone	Boolean	False	Information about whether to allow phone calls to the account.
DoNotPostalMail	Boolean	False	Information about whether to allow sending postal mail to the account.
DoNotSendMM	Boolean	False	Information on whether to allow sending marketing mail to the account.
EMailAddress1	String	False	First email address for the account.
EMailAddress2	String	False	Second email address for the account.
EMailAddress3	String	False	Third email address for the account.
ExchangeRate	Double	True	Exchange rate for the currency associated with the account with respect to the base currency.
Fax	String	False	Fax telephone number for the account.
FtpSiteURL	String	False	FTP site URL for the account.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IndustryCode	String	False	Type of industry with which the account is associated.
LastUsedInCampaign	Datetime	False	Date and time when the account was last contacted as a part of a marketing campaign.
MarketCap	Double	False	Market capitalization of the account.
MarketCap_Base	Double	True	Base currency equivalent of the market capitalization of the account.
MasterId_Id	String	True	Unique identifier of the master account for merge.
MasterId_LogicalName	String	True
MasterId_Name	String	True
Merged	Boolean	True	Information regarding whether the account has been merged with a master account.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the account.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the account was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the account.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the account.
NumberOfEmployees	Integer	False	Number of employees at the account.
OriginatingLeadId_Id	String	False	Unique identifier of the lead from which the account was created.
OriginatingLeadId_LogicalName	String	False
OriginatingLeadId_Name	String	False
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the account.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwnershipCode	String	False	Type of company ownership, such as public or private.
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the account.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the account.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the account.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ParentAccountId_Id	String	False	Unique identifier of the parent account.
ParentAccountId_LogicalName	String	False
ParentAccountId_Name	String	False
ParticipatesInWorkflow	Boolean	False	Information that specifies whether the account participates in workflow rules.
PaymentTermsCode	String	False	Payment terms for the account.
PreferredAppointmentDayCode	String	False	Day of the week preferred by the account for scheduling service activities.
PreferredAppointmentTimeCode	String	False	Time of day preferred by the account for scheduling service activities.
PreferredContactMethodCode	String	False	Preferred contact method for the account.
PreferredEquipmentId_Id	String	False	Unique identifier of the facility/equipment preferred by the account for scheduling service activities.
PreferredEquipmentId_LogicalName	String	False
PreferredEquipmentId_Name	String	False
PreferredServiceId_Id	String	False	Unique identifier of the service preferred by the account for scheduling service activities.
PreferredServiceId_LogicalName	String	False
PreferredServiceId_Name	String	False
PreferredSystemUserId_Id	String	False	Unique identifier of the system user preferred by the account for scheduling service activities.
PreferredSystemUserId_LogicalName	String	False
PreferredSystemUserId_Name	String	False
PrimaryContactId_Id	String	False	Unique identifier of the primary contact for the account.
PrimaryContactId_LogicalName	String	False
PrimaryContactId_Name	String	False
Revenue	Double	False	Revenue amount for the account.
Revenue_Base	Double	True	Base currency equivalent of the revenue amount for the account.
SharesOutstanding	Integer	False	Outstanding shares for the account.
ShippingMethodCode	String	False	Method of shipment for the account.
SIC	String	False	Standard Industrial Classification (SIC) code for the account.
StateCode	String	True	Reason for the status of the account.
StatusCode	String	False	Status of the account.
StockExchange	String	False	Stock exchange on which the business associated with the account is listed.
Telephone1	String	False	First telephone number for the account.
Telephone2	String	False	Second telephone number for the account.
Telephone3	String	False	Third telephone number for the account.
TerritoryCode	String	False	Territory to which the account belongs.
TerritoryId_Id	String	False	Unique identifier of the territory to which the account belongs.
TerritoryId_LogicalName	String	False
TerritoryId_Name	String	False
TickerSymbol	String	False	Stock Exchange symbol for the account.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the account.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
WebSiteURL	String	False	Web site URL for the account.
YomiName	String	False	Pronunciation of the account name, written in phonetic hiragana or katakana characters.

ActivityMimeAttachment

Create, update, delete, and query ActivityMimeAttachment entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the activity MIME attachment.
ActivityId_Id	String	False	Unique identifier of the activity with which the email attachment is associated.
ActivityId_LogicalName	String	False
ActivityId_Name	String	False
ActivityMimeAttachmentId	String	False	Unique identifier of the email attachment.
ActivityMimeAttachmentIdUnique	String	False	For internal use only.
AttachmentId_Id	String	False	Unique identifier of the attachment with which this activity MIME attachment is associated.
AttachmentId_LogicalName	String	False
AttachmentId_Name	String	False
AttachmentNumber	Integer	False	Number of the email attachment.
Body	String	False	Contents of the email attachment.
ComponentState	String	True	For internal use only.
FileName	String	False	File name of the attachment.
FileSize	Integer	True	File size of the email attachment.
IsManaged	Boolean	True	Indicates whether the solution component is part of a managed solution.
MimeType	String	False	MIME type of the email attachment.
ObjectId_Id	String	False	Unique identifier of the record with which the attachment is associated.
ObjectId_LogicalName	String	False
ObjectId_Name	String	False
ObjectTypeCode	String	False	Object type code of the entity that is associated with the attachment.
OverwriteTime	Datetime	True	For internal use only.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the activity_mime_attachment.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the activity MIME attachment.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the activity MIME attachment.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
SolutionId	String	True	Unique identifier of the associated solution.
Subject	String	False	Descriptive subject for the email attachment.

ActivityParty

Create, update, delete, and query ActivityParty entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the activity party.
ActivityId_Id	String	False	Unique identifier of the activity associated with the activity party, any person who is associated with an activity.
ActivityId_LogicalName	String	False
ActivityId_Name	String	False
ActivityPartyId	String	False	Unique identifier of the activity party.
AddressUsed	String	False	Email address to which an email is delivered, and which is associated with the target entity.
DoNotEmail	Boolean	True	Information about whether to allow sending email to the activity party.
DoNotFax	Boolean	True	Information about whether to allow sending faxes to the activity party.
DoNotPhone	Boolean	True	Information about whether to allow phone calls to the lead.
DoNotPostalMail	Boolean	True	Information about whether to allow sending postal mail to the lead.
Effort	Double	False	Amount of effort used by the resource in a service appointment activity.
ExchangeEntryId	String	False	For internal use only.
InstanceTypeCode	String	True	Type of instance of a recurring series.
IsPartyDeleted	Boolean	True	Information about whether the underlying entity record is deleted.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the activity party.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
ParticipationTypeMask	String	False	Role of the person in the activity, such as sender, to, cc, bcc, required, optional, organizer, regarding, or owner.
PartyId_Id	String	False	Unique identifier of the party associated with the activity.
PartyId_LogicalName	String	False
PartyId_Name	String	False
ResourceSpecId_Id	String	False	Unique identifier of the resource specification for the activity party.
ResourceSpecId_LogicalName	String	False
ResourceSpecId_Name	String	False
ScheduledEnd	Datetime	True	Scheduled end time of the activity.
ScheduledStart	Datetime	True	Scheduled start time of the activity.

ActivityPointer

Create, update, delete, and query ActivityPointer entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the activity pointer.
ActivityId	String	False	Unique identifier of the activity.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Actual duration of the activity in minutes.
ActualEnd	Datetime	False	Actual end time of the activity.
ActualStart	Datetime	False	Actual start time of the activity.
CreatedBy_Id	String	True	Unique identifier of the user who created the activity.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the activity was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the activity pointer.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the activity.
ExchangeRate	Double	True	Exchange rate for the currency associated with the activity pointer with respect to the base currency.
InstanceTypeCode	String	True	Type of instance of a recurring series.
IsBilled	Boolean	False	Information regarding whether the activity was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Information regarding whether the activity was created from a workflow rule.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the activity.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the activity was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the activitypointer.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OwnerId_Id	String	False	Unique identifier of the user or team who owns the activity.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the activity.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team that owns the activity.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user that owns the activity.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriorityCode	String	False	Priority of the activity.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the activity is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ScheduledDurationMinutes	Integer	False	Scheduled duration of the activity, specified in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the activity.
ScheduledStart	Datetime	False	Scheduled start time of the activity.
SeriesId	String	True	Unique identifier specifying the Id of a recurring series of an instance.
ServiceId_Id	String	False	Unique identifier of an associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the activity.
StatusCode	String	False	Reason for the status of the activity.
Subject	String	False	Subject associated with the activity.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the activity pointer.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

Annotation

Create, update, delete, and query Annotation entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the note.
AnnotationId	String	False	Unique identifier of the note.
CreatedBy_Id	String	True	Unique identifier of the user who created the note.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the note was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the annotation.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DocumentBody	String	False	Contents of the note's attachment.
FileName	String	False	File name of the note.
FileSize	Integer	True	File size of the note.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsDocument	Boolean	False	Specifies whether the note is an attachment.
LangId	String	False	Language identifier for the note.
MimeType	String	False	MIME type of the note's attachment.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the note.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the note was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the annotation.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
NoteText	String	False	Text of the note.
ObjectId_Id	String	False	Unique identifier of the object with which the note is associated.
ObjectId_LogicalName	String	False
ObjectId_Name	String	False
ObjectTypeCode	String	False	Type of entity with which the note is associated.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the note.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the note.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the note.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the note.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
StepId	String	False	Workflow step Id associated with the note.
Subject	String	False	Subject associated with the note.

AnnualFiscalCalendar

Create, update, delete, and query annual fiscal calendar entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the annual fiscal calendar.
annual	Double	False	Sales quota for the first period in the fiscal year.
annual_base	Double	True	Base currency equivalent of the sales quota for the first period in the fiscal year.
BusinessUnitId_Id	String	True
BusinessUnitId_LogicalName	String	True
BusinessUnitId_Name	String	True
CreatedBy_Id	String	True	Unique identifier of the user who created the quota for the annual fiscal calendar.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the quota for the annual fiscal calendar was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the annual fiscal calendar.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
EffectiveOn	Datetime	False	Date and time when the fiscal calendar sales quota takes effect.
ExchangeRate	Double	True	Exchange rate for the currency associated with the annual fiscal calendar with respect to the base currency.
FiscalPeriodType	Integer	True	Type of fiscal period used in the sales quota.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the quota for the annual fiscal calendar.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the annual fiscal calendar was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the annual fiscal calendar.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
SalesPersonId_Id	String	False	Unique identifier of the salesperson associated with the sales quota.
SalesPersonId_LogicalName	String	False
SalesPersonId_Name	String	False
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the annual fiscal calendar.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UserFiscalCalendarId	String	False	Unique identifier of the user associated with the annual fiscal calendar.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

ApplicationFile

Create, update, delete, and query ApplicationFile entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the application file.
Body	String	False	Body of the application file.
CreatedBy_Id	String	True	Unique identifier of the user who created the application file.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the application file was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the application file.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
FileId	String	False	Unique identifier for application file instances.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the application file.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the application file was modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the application file.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	File name
OrganizationId_Id	String	True	Unique identifier for the organization.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True

Appointment

Create, update, delete, and query Appointment entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the appointment.
ActivityId	String	False	Unique identifier of the appointment.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Actual duration of the appointment in minutes.
ActualEnd	Datetime	False	Actual end time of the appointment.
ActualStart	Datetime	False	Actual start time of the appointment.
Category	String	False	Category of the appointment.
CreatedBy_Id	String	True	Unique identifier of the user who created the appointment.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the appointment was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the appointment.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	A description of the appointment.
ExchangeRate	Double	True	Exchange rate for the currency associated with the appointment with respect to the base currency.
GlobalObjectId	String	False	Unique Outlook identifier to correlate appointments across Exchange mailboxes.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
InstanceTypeCode	String	True	Type of instance of a recurring series.
IsAllDayEvent	Boolean	False	Information on whether the appointment is an all day event.
IsBilled	Boolean	False	Information regarding whether the appointment was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Information regarding whether the appointment was created from a workflow rule.
Location	String	False	Location where the appointment is to occur.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the appointment.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedFieldsMask	String	True	For internal use only.
ModifiedOn	Datetime	True	Date and time when the appointment was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the appointment.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OptionalAttendees_Ids	String	False	List of optional attendees for the appointment.
OptionalAttendees_LogicalNames	String	False
OptionalAttendees_Names	String	False
Organizer_Ids	String	False	Person who organized the appointment.
Organizer_LogicalNames	String	False
Organizer_Names	String	False
OriginalStartDate	Datetime	True	The original start date of the appointment.
OutlookOwnerApptId	Integer	False	Unique identifier of the Microsoft Office Outlook appointment owner that correlates to the PR_OWNER_APPT_ID MAPI property.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the appointment.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the appointment.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the appointment.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the appointment.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriorityCode	String	False	Priority of the appointment.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the appointment is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
requiredattendees_Ids	String	False	List of required attendees for the appointment.
requiredattendees_LogicalNames	String	False
requiredattendees_Names	String	False
ScheduledDurationMinutes	Integer	False	Scheduled duration of the appointment, specified in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the appointment.
ScheduledStart	Datetime	False	Scheduled start time of the appointment.
SeriesId	String	True	Unique identifier specifying the Id of a recurring series of an instance.
ServiceId_Id	String	False	Unique identifier for an associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the appointment.
StatusCode	String	False	Reason for the status of the appointment.
Subcategory	String	False	Subcategory of the appointment.
Subject	String	False	Subject associated with the appointment.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the appointment.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

AsyncOperation

Create, update, delete, and query AsyncOperation entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the system job.
AsyncOperationId	String	False	Unique identifier of the system job.
CompletedOn	Datetime	True	Date and time when the system job was completed.
CorrelationId	String	False	Unique identifier used to correlate between multiple SDK requests and system jobs.
CorrelationUpdatedTime	Datetime	False	Last time the correlation depth was updated.
CreatedBy_Id	String	True	Unique identifier of the user who created the system job.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the system job was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the async operation.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Data	String	False	Unstructured data associated with the system job.
DependencyToken	String	False	Execution of all operations with the same dependency token is serialized.
Depth	Integer	False	Number of SDK calls made since the first call.
ErrorCode	Integer	True	Error code returned from a canceled system job.
ExecutionTimeSpan	Double	True	Time that the system job has taken to execute.
FriendlyMessage	String	False	Message provided by the system job.
HostId	String	False	Unique identifier of the host that owns this system job.
IsWaitingForEvent	Boolean	True	Indicates that the system job is waiting for an event.
Message	String	True	Message related to the system job.
MessageName	String	False	Name of the message that started this system job.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the system job.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the system job was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the async operation.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the system job.
OperationType	String	False	Type of the system job.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the system job.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the system job.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningExtensionId_Id	String	False	Unique identifier of the owning extension with which the system job is associated.
OwningExtensionId_LogicalName	String	False
OwningExtensionId_Name	String	False
OwningTeam_Id	String	True	Unique identifier of the team who owns the record.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the record.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PostponeUntil	Datetime	False	Indicates whether the system job should run only after the specified date and time.
PrimaryEntityType	String	False	Type of entity with which the system job is primarily associated.
RecurrencePattern	String	False	Pattern of the system job's recurrence.
RecurrenceStartTime	Datetime	False	Starting time in UTC for the recurrence pattern.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the system job is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
RequestId	String	False	Unique identifier of the request that generated the system job.
RetryCount	Integer	True	Number of times to retry the system job.
StartedOn	Datetime	True	Date and time when the system job was started.
StateCode	String	False	Status of the system job.
StatusCode	String	False	Reason for the status of the system job.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
WorkflowActivationId_Id	String	False	Unique identifier of the workflow activation related to the system job.
WorkflowActivationId_LogicalName	String	False
WorkflowActivationId_Name	String	False
WorkflowStageName	String	True	Name of a workflow stage.

Attachment

Create, update, delete, and query Attachment entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the attachment.
AttachmentId	String	False	Unique identifier of the attachment.
Body	String	False	Contents of the attachment.
FileName	String	False	File name of the attachment.
FileSize	Integer	True	File size of the attachment.
MimeType	String	False	MIME type of the attachment.
Subject	String	False	Subject associated with the attachment.

AttributeMap

Create, update, delete, and query AttributeMap entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the attribute map.
AttributeMapId	String	False	Unique identifier of the attribute map.
AttributeMapIdUnique	String	True	For internal use only.
ComponentState	String	True	For internal use only.
CreatedBy_Id	String	True	Unique identifier of the user who created the attribute map.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the attribute map was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the attribute map.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
EntityMapId_Id	String	False	Unique identifier of the entity map with which the attribute map is associated.
EntityMapId_LogicalName	String	False
EntityMapId_Name	String	False
IsManaged	Boolean	True
IsSystem	Boolean	False	Information about whether this attribute map is user-defined or system-defined.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the attribute map.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the attribute map was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the attribute map.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId_Id	String	True	Unique identifier of the organization with which the attribute map is associated.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverwriteTime	Datetime	True	For internal use only.
ParentAttributeMapId_Id	String	False	Unique identifier of the parent attribute map.
ParentAttributeMapId_LogicalName	String	False
ParentAttributeMapId_Name	String	False
SolutionId	String	True	Unique identifier of the associated solution.
SourceAttributeName	String	False	Name of the source attribute for the mapping.
TargetAttributeName	String	False	Name of the target attribute for the mapping.

Audit

Create, update, delete, and query Audit entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the audit.
Action	String	True	Actions the user can perform that cause a change.
AttributeMask	String	True	Contains a CSV of the ColumnNumber metadata property of attributes.
AuditId	String	True	Unique identifier of the auditing instance.
CallingUserId_Id	String	True	Unique identifier of the calling user in case of an impersonated call.
CallingUserId_LogicalName	String	True
CallingUserId_Name	String	True
CreatedOn	Datetime	True	Date and time when the audit record was created.
ObjectId_Id	String	True	Unique identifier of the record that is being audited.
ObjectId_LogicalName	String	True
ObjectId_Name	String	True
Operation	String	True	The action that causes the audit. This value will be create, delete, or update.
TransactionId	String	True	Unique identifier for multiple changes that are part of a single operation; this field contains the same GUID for all the audit rows generated in a single transaction.
UserId_Id	String	True	Unique identifier of the user who caused a change.
UserId_LogicalName	String	True
UserId_Name	String	True

BulkDeleteFailure

Create, update, delete, and query BulkDeleteFailure entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the bulk deletion failure record.
AsyncOperationId_Id	String	True	Unique identifier of the system job that created this record.
AsyncOperationId_LogicalName	String	True
AsyncOperationId_Name	String	True
BulkDeleteFailureId	String	True	Unique identifier of the bulk deletion failure record.
BulkDeleteOperationId_Id	String	True	Unique identifier of the bulk operation job that created this record.
BulkDeleteOperationId_LogicalName	String	True
BulkDeleteOperationId_Name	String	True
ErrorDescription	String	True	Description of the error.
ErrorNumber	Integer	True	Error code for the failed bulk deletion.
OrderedQueryIndex	Integer	True	Index of the ordered query expression that retrieved this record.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the bulk operation log.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the bulk deletion failure record.
OwningUser	String	True	Unique identifier of the user who owns the bulk deletion failure record.
RegardingObjectId_Id	String	True	Unique identifier of the record. This value cannot be deleted.
RegardingObjectId_LogicalName	String	True
RegardingObjectId_Name	String	True

BulkDeleteOperation

Create, update, delete, and query BulkDeleteOperation entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the bulk deletion job.
AsyncOperationId_Id	String	True	Unique identifier of the system job that created this record.
AsyncOperationId_LogicalName	String	True
AsyncOperationId_Name	String	True
BulkDeleteOperationId	String	True	Unique identifier of the bulk deletion job.
CreatedBy_Id	String	True	Unique identifier of the user who created the bulk deletion job.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the bulk deletion job was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the bulk delete operation.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
FailureCount	Integer	True	Number of records that could not be deleted by the bulk deletion job.
IsRecurring	Boolean	True	Information about if recurrence is defined for the bulk deletion job.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the bulk deletion job.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the bulk deletion job record was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the bulk delete operation.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	True	Name of the bulk deletion job.
NextRun	Datetime	True	Next scheduled time for the bulk deletion job to run.
OrderedQuerySetXml	String	True	Fetch XML of the ordered query set.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the bulk delete operation.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit_Id	String	True	Business unit that owns the bulk deletion job.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningUser_Id	String	True	Business user who owns the bulk delete operation.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ProcessingQEIndex	Integer	True	Index of the ordered query expression that defines the deletion set.
StateCode	String	True	Status of the bulk deletion job.
StatusCode	String	True	Reason for the status of the bulk deletion job.
SuccessCount	Integer	True	Number of records deleted by the bulk deletion job.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

BulkOperation

Create, update, delete, and query BulkOperation entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the bulk operation.
ActivityId	String	False	Unique identifier of the bulk operation.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	True	Actual duration of the bulk operation in minutes.
ActualEnd	Datetime	True	Actual end time of the bulk operation.
ActualStart	Datetime	True	Actual start time of the bulk operation.
BulkOperationNumber	String	True	Unique number that identifies the bulk operation.
CreatedBy_Id	String	True	Unique identifier of the user who created the bulk operation.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the bulk operation was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the bulk operation.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CreatedRecordTypeCode	String	True	Type code of the objects created in the bulk operation.
Description	String	True	Description of the bulk operation.
ErrorNumber	Integer	True	Error code for a failed bulk operation.
FailureCount	Integer	True	Number of records which failed in the bulk operation.
IsBilled	Boolean	True	For internal use only.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	True	Specifies if the bulk operation was created from a workflow rule.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the bulk operation.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the bulk operation was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the bulk operation.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OperationTypeCode	String	True	Type of bulk operation to be performed.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the bulk operation.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the bulk operation.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the bulk operation.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the bulk operation.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Parameters	String	True	XML string that contains the parameters to the bulk operation.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the bulk operation is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ScheduledDurationMinutes	Integer	True	Scheduled duration of the bulk operation, specified in minutes.
ScheduledEnd	Datetime	True	Scheduled end date and time of the bulk operation.
ScheduledStart	Datetime	True	Scheduled start date and time of the bulk operation.
ServiceId_Id	String	False	Unique identifier for an associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the bulk operation.
StatusCode	String	False	Reason for the status of the bulk operation.
Subject	String	True	Subject associated with the bulk operation.
SuccessCount	Integer	True	Number of records which succeeded in the bulk operation.
TargetedRecordTypeCode	String	True	Type code of the objects targeted in the bulk operation.
TargetMembersCount	Integer	True	Number of members to target.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

BulkOperationLog

This is a table representing the BulkOperationLog entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the bulk operation log.
AdditionalInfo	String	False	Additional information for the log.
BulkOperationId_Id	String	False	Unique identifier of the bulk operation that this log relates to.
BulkOperationId_LogicalName	String	False
BulkOperationId_Name	String	False
BulkOperationLogId	String	False	Unique identifier of the bulk operation log.
CreatedObjectId_Id	String	False	Unique identifier of the object created by the bulk operation.
CreatedObjectId_LogicalName	String	False
CreatedObjectId_Name	String	False
ErrorNumber	Integer	True	Error code for a failed bulk operation.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the bulk operation log.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the bulk operation log.
OwningUser	String	True	Unique identifier of the user who owns the bulk operation log.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the bulk operation is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False

BusinessUnit

This is a table representing the BusinessUnit entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the business unit.
Address1_AddressId	String	False	Unique identifier for address 1.
Address1_AddressTypeCode	String	False	Type of address for address 1, such as billing, shipping, or primary address.
Address1_City	String	False	City name for address 1.
Address1_Country	String	False	Country/region name for address 1.
Address1_County	String	False	County name for address 1.
Address1_Fax	String	False	Fax number for address 1.
Address1_Latitude	Double	False	Latitude for address 1.
Address1_Line1	String	False	First line for entering address 1 information.
Address1_Line2	String	False	Second line for entering address 1 information.
Address1_Line3	String	False	Third line for entering address 1 information.
Address1_Longitude	Double	False	Longitude for address 1.
Address1_Name	String	False	Name to enter for address 1.
Address1_PostalCode	String	False	ZIP Code or postal code for address 1.
Address1_PostOfficeBox	String	False	Post office box number for address 1.
Address1_ShippingMethodCode	String	False	Method of shipment for address 1.
Address1_StateOrProvince	String	False	State or province for address 1.
Address1_Telephone1	String	False	First telephone number associated with address 1.
Address1_Telephone2	String	False	Second telephone number associated with address 1.
Address1_Telephone3	String	False	Third telephone number associated with address 1.
Address1_UPSZone	String	False	United Parcel Service (UPS) zone for address 1.
Address1_UTCOffset	Integer	False	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
Address2_AddressId	String	False	Unique identifier for address 2.
Address2_AddressTypeCode	String	False	Type of address for address 2, such as billing, shipping, or primary address.
Address2_City	String	False	City name for address 2.
Address2_Country	String	False	Country/region name for address 2.
Address2_County	String	False	County name for address 2.
Address2_Fax	String	False	Fax number for address 2.
Address2_Latitude	Double	False	Latitude for address 2.
Address2_Line1	String	False	First line for entering address 2 information.
Address2_Line2	String	False	Second line for entering address 2 information.
Address2_Line3	String	False	Third line for entering address 2 information.
Address2_Longitude	Double	False	Longitude for address 2.
Address2_Name	String	False	Name to enter for address 2.
Address2_PostalCode	String	False	ZIP Code or postal code for address 2.
Address2_PostOfficeBox	String	False	Post office box number for address 2.
Address2_ShippingMethodCode	String	False	Method of shipment for address 2.
Address2_StateOrProvince	String	False	State or province for address 2.
Address2_Telephone1	String	False	First telephone number associated with address 2.
Address2_Telephone2	String	False	Second telephone number associated with address 2.
Address2_Telephone3	String	False	Third telephone number associated with address 2.
Address2_UPSZone	String	False	United Parcel Service (UPS) zone for address 2.
Address2_UTCOffset	Integer	False	UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
BusinessUnitId	String	False	Unique identifier of the business unit.
CalendarId_Id	String	False	Fiscal calendar associated with the business unit.
CalendarId_LogicalName	String	False
CalendarId_Name	String	False
CostCenter	String	False	Name of the business unit cost center.
CreatedBy_Id	String	True	Unique identifier of the user who created the business unit.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the business unit was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the businessunit.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CreditLimit	Double	False	Credit limit for the business unit.
Description	String	False	Description of the business unit.
DisabledReason	String	True	Reason for disabling the business unit.
DivisionName	String	False	Name of the division to which the business unit belongs.
EMailAddress	String	False	email address for the business unit.
ExchangeRate	Double	True	Exchange rate for the currency associated with the businessunit with respect to the base currency.
FileAsName	String	False	Alternative name under which the business unit can be filed.
FtpSiteUrl	String	False	FTP site URL for the business unit.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
InheritanceMask	Integer	False	Inheritance mask for the business unit.
IsDisabled	Boolean	True	Information about whether the business unit is enabled or disabled.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the business unit.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the business unit was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the businessunit.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the business unit.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the business unit.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
ParentBusinessUnitId_Id	String	False	Unique identifier for the parent business unit.
ParentBusinessUnitId_LogicalName	String	False
ParentBusinessUnitId_Name	String	False
Picture	String	False	Picture or diagram of the business unit.
StockExchange	String	False	Stock exchange on which the business is listed.
TickerSymbol	String	False	Stock exchange ticker symbol for the business unit.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the businessunit.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCOffset	Integer	False	UTC offset for the business unit. This is the difference between local time and standard Coordinated Universal Time.
WebSiteUrl	String	False	Web site URL for the business unit.
WorkflowSuspended	Boolean	False	Information about whether workflow or sales process rules have been suspended.

BusinessUnitMap

This is a table representing the BusinessUnitMap entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the business unit map.
BusinessId	String	False
BusinessUnitMapId	String	False	Unique identifier of the business unit map.
SubBusinessId	String	False

BusinessUnitNewsArticle

This is a table representing the BusinessUnitNewsArticle entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the announcement.
ActiveOn	Datetime	False	Date and time for the announcement to become active.
ActiveUntil	Datetime	False	Date and time of the last day the announcement is active.
ArticleTitle	String	False	Title of the announcement.
ArticleTypeCode	String	False	Type of announcement.
ArticleUrl	String	False	URL for the Web site on which the announcement is located.
BusinessUnitNewsArticleId	String	False	Unique identifier of the announcement.
CreatedBy_Id	String	True	Unique identifier of the user who created the announcement.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the announcement was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the businessunitnewsarticle.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the announcement.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the announcement was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the businessunitnewsarticle.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
NewsArticle	String	False	Text for the announcement.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the announcement.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
ShowOnHomepage	Boolean	False	Information about whether to show the announcement on the Web site home page.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

Calendar

This is a table representing the Calendar entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the calendar.
BusinessUnitId_Id	String	False	Unique identifier of the business unit with which the calendar is associated.
BusinessUnitId_LogicalName	String	False
BusinessUnitId_Name	String	False
CalendarId	String	False	Unique identifier of the calendar.
CreatedBy_Id	String	True	Unique identifier of the user who created the calendar.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the calendar was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the calendar.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Calendar used by the scheduling system to define when an appointment or activity is to occur.
IsShared	Boolean	False	Calendar is shared by other calendars, such as the organization calendar.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the calendar.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the calendar was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the calendar.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the calendar.
OrganizationId_Id	String	True	Unique identifier of the organization with which the calendar is associated.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
PrimaryUserId	String	False	Unique identifier of the primary user of this calendar.

Campaign

This is a table representing the Campaign entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign.
ActualEnd	Datetime	False	Actual end date for the campaign.
ActualStart	Datetime	False	Actual start date for the campaign.
BudgetedCost	Double	False	Budgeted cost for the campaign.
BudgetedCost_Base	Double	True	Base currency equivalent of the budgeted cost for the campaign.
CampaignId	String	False	Unique identifier of the campaign.
CodeName	String	False	Unique code name that identifies the campaign.
CreatedBy_Id	String	True	Unique identifier of the user who created the campaign.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the campaign was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the campaign.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the campaign.
ExchangeRate	Double	True	Exchange rate for the currency associated with the campaign with respect to the base currency.
ExpectedResponse	Integer	False	Percent expected response for the campaign.
ExpectedRevenue	Double	False	Expected revenue from the campaign.
ExpectedRevenue_Base	Double	True	Base currency equivalent of the expected revenue from the campaign.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsTemplate	Boolean	False	Indication of whether the campaign is a template.
Message	String	False	Promotional message for the campaign.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the campaign.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the campaign was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the campaign.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the campaign.
Objective	String	False	Objective of the campaign.
OtherCost	Double	False	Other miscellaneous costs of the campaign.
OtherCost_Base	Double	True	Base currency equivalent of the other miscellaneous costs of the campaign.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the campaign.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the campaign.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the campaign.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the campaign.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriceListId_Id	String	False	Unique identifier of the price list for the campaign.
PriceListId_LogicalName	String	False
PriceListId_Name	String	False
PromotionCodeName	String	False	Promotion code for the campaign.
ProposedEnd	Datetime	False	Proposed end date for the campaign.
ProposedStart	Datetime	False	Proposed start date for the campaign.
StateCode	String	True	Status of the campaign.
StatusCode	String	False	Reason for the status of the campaign.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TotalActualCost	Double	True	Total actual cost of the campaign.
TotalActualCost_Base	Double	True	Base currency equivalent of the total actual cost of the campaign.
TotalCampaignActivityActualCost	Double	True	Sum of all the actual costs of the campaign activities for this campaign.
TotalCampaignActivityActualCost_Base	Double	True	Base currency equivalent of the sum of all the actual costs of the campaign activities for this campaign.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the campaign.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
TypeCode	String	False	Type of the campaign.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

CampaignActivity

This is a table representing the CampaignActivity entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign activity.
ActivityId	String	False	Unique identifier of the campaign activity.
ActivityTypeCode	String	True	Type of activity.
ActualCost	Double	False	Actual cost of the campaign activity.
ActualCost_Base	Double	True	Base currency equivalent of the actual cost of the campaign activity.
ActualDurationMinutes	Integer	False	Actual duration of the activity in minutes.
ActualEnd	Datetime	False	Actual end time of the campaign activity.
ActualStart	Datetime	False	Actual start time of the campaign activity.
BudgetedCost	Double	False	Budgeted cost for the campaign activity.
BudgetedCost_Base	Double	True	Base currency equivalent of the budgeted cost for the campaign activity.
Category	String	False	Category of the campaign activity.
ChannelTypeCode	String	False	Channel type code for the campaign activity.
CreatedBy_Id	String	True	Unique identifier of the user who created the campaign activity.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the campaign activity was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the campaignactivity.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the campaign activity.
DoNotSendOnOptOut	Boolean	False	Information about whether to send marketing material to list members that prohibit sending of marketing material.
ExchangeRate	Double	True	Exchange rate for the currency associated with the campaign activity with respect to the base currency.
ExcludeIfContactedInXDays	Integer	False	Ignore if the campaign ran in the last X days.
from_Ids	String	False	For internal use only.
from_LogicalNames	String	False
from_Names	String	False
IgnoreInactiveListMembers	Boolean	False	Information regarding whether to ignore inactive lists during propagation/execution.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsBilled	Boolean	False	Information regarding whether the campaign activity was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Information about whether the campaign activity is created by a workflow rule.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the campaign activity.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the campaign activity was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the campaignactivity.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the campaign activity.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the campaign activity.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the campaign activity.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the campaign activity.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Partners_Ids	String	False	Unique identifier of the partner of the campaign activity.
Partners_LogicalNames	String	False
Partners_Names	String	False
PriorityCode	String	False	Priority code for the campaign activity.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the campaign activity is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ScheduledDurationMinutes	Integer	True	Scheduled duration, specified in minutes, of the campaign activity.
ScheduledEnd	Datetime	False	Scheduled end time of the campaign activity.
ScheduledStart	Datetime	False	Scheduled start time of the campaign activity.
ServiceId_Id	String	False	Unique identifier of the associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the campaign activity.
StatusCode	String	False	Reason for the status reason for the campaign activity.
Subcategory	String	False	Subcategory of the campaign activity.
Subject	String	False	Subject associated with the campaign activity.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	True	Unique identifier of the currency associated with the campaign activity.
TransactionCurrencyId_LogicalName	String	True
TransactionCurrencyId_Name	String	True
TypeCode	String	False	Type of the campaign activity.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

CampaignActivityItem

This is a table representing the CampaignActivityItem entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign activity item.
CampaignActivityId_Id	String	False	Unique identifier of the campaign activity for the item.
CampaignActivityId_LogicalName	String	False
CampaignActivityId_Name	String	False
CampaignActivityItemId	String	False	Unique identifier of the campaign activity item.
ItemId	String	False	Unique identifier of the item.
ItemObjectTypeCode	String	False	Identification of the type of the campaign activity item.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the campaign activity item.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the campaign activity item.
OwningUser	String	True	Unique identifier of the user that owns the campaign activity item.

CampaignItem

This is a table representing the CampaignItem entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign item.
CampaignId_Id	String	False	Unique identifier of the campaign that is associated with the individual item.
CampaignId_LogicalName	String	False
CampaignId_Name	String	False
CampaignItemId	String	False	Unique identifier of the campaign item.
EntityId	String	False	Unique identifier of the entity for the campaign item.
EntityType	Integer	False	Object type of entity for the campaign item.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the campaign item.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the campaign item.
OwningUser	String	True	Unique identifier of the user that owns the campaign item.

CampaignResponse

This is a table representing the CampaignResponse entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the campaign response.
ActivityId	String	False	Unique identifier of the campaign response.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Actual duration of the campaign response in minutes.
ActualEnd	Datetime	False	Actual end time of the campaign response.
ActualStart	Datetime	False	Actual start time of the campaign response.
Category	String	False	Category of the campaign response.
ChannelTypeCode	String	False	Channel type code of the campaign response.
CompanyName	String	False	Name of the company with which the campaign response is associated.
CreatedBy_Id	String	True	Unique identifier of the user who created the campaign response.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the campaign response was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the campaignresponse.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Customer_Ids	String	False	Customer with which the campaign response is associated.
Customer_LogicalNames	String	False
Customer_Names	String	False
Description	String	False	Description of the campaign response.
EMailAddress	String	False	email address of the customer from whom this response is received.
ExchangeRate	Double	True	Exchange rate for the currency associated with the campaignresponse with respect to the base currency.
Fax	String	False	Fax number of the customer from whom this response is received.
FirstName	String	False	First name of the customer from whom this response is collected.
from_Ids	String	False	For internal use only.
from_LogicalNames	String	False
from_Names	String	False
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsBilled	Boolean	False	Specifies whether the campaign response was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Specifies whether the campaign response is created by a workflow rule.
LastName	String	False	Last name of the customer from whom this response is collected.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the campaign response.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the campaign response was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the campaignresponse.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OriginatingActivityId_Id	String	False	Unique identifier of the originating activity for the campaign response.
OriginatingActivityId_LogicalName	String	False
OriginatingActivityId_Name	String	False
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the campaign response.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier for the business unit that owns the campaign response.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the campaign response.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the campaign response.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Partner_Ids	String	False	Unique identifier of the partner for the campaign response.
Partner_LogicalNames	String	False
Partner_Names	String	False
PriorityCode	String	False	Priority of the campaign response.
PromotionCodeName	String	False	Promote code name associated with this response.
ReceivedOn	Datetime	False	Date on which this campaign response was received.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the campaign response is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ResponseCode	String	False	Code of the campaign response.
ScheduledDurationMinutes	Integer	True	Scheduled duration of the campaign response in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the campaign response.
ScheduledStart	Datetime	False	Scheduled start time of the campaign response.
ServiceId_Id	String	False	Unique identifier for the associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the campaign response.
StatusCode	String	False	Reason for the status for the campaign response.
Subcategory	String	False	Subcategory of the campaign response.
Subject	String	False	Subject associated with the campaign response.
Telephone	String	False	Telephone number of customer from whom this response is received.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the campaignresponse.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
YomiCompanyName	String	False	Pronunciation of the company name, written in phonetic hiragana or katakana characters, with which the campaign response activity is associated.
YomiFirstName	String	False	Pronunciation of the first name of the customer, written in phonetic hiragana or katakana characters, from whom this response is collected.
YomiLastName	String	False	Pronunciation of the last name of the customer, written in phonetic hiragana or katakana characters, from whom this response is collected.

ClientUpdate

This is a table representing the ClientUpdate entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the client update.
ClientUpdateId	String	False	Unique identifier of the client update.
CreatedOn	Datetime	True	For internal use only. Date and time when the ClientUpdate script was created on server.
Description	String	False	Description of the client update.
SqlScript	String	False	Contents of the client update.
WasExecuted	Boolean	False	For internal use only. Should be set by client to 1 after action was executed.
WhenExecute	String	False	For internal use only. Values are: 1 - Before SchemaChanges; 2 - After SchemaChanges but before Download data; 3 - After download data.

ColumnMapping

This is a table representing the ColumnMapping entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the column mapping.
ColumnMappingId	String	False	Unique identifier of the column mapping.
CreatedBy_Id	String	True	Unique identifier of the user who created the column mapping.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the column mapping was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the columnmapping.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
ImportMapId_Id	String	False	Unique identifier of the associated data map.
ImportMapId_LogicalName	String	False
ImportMapId_Name	String	False
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the column mapping.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the column mapping was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the columnmapping.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
ProcessCode	String	False	Information about whether the column mapping needs to be processed.
SourceAttributeName	String	False	Name of the source attribute.
SourceEntityName	String	False	Name of the source entity.
StateCode	String	True	Status of the column mapping.
StatusCode	String	False	Reason for the status of the column mapping.
TargetAttributeName	String	False	Name of the Microsoft Dynamics CRM attribute.
TargetEntityName	String	False	Name of the Microsoft Dynamics CRM entity.

Commitment

This is a table representing the Commitment entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the commitment.
ActivityId	String	True
ActivityTypeCode	Integer	True
CommitmentId	String	True
Effort	Double	True
ParticipationTypeMask	Integer	True
PartyId	String	True
ResourceSpecId	String	True
ScheduledEnd	Datetime	True
ScheduledStart	Datetime	True
ServiceId_Id	String	True
ServiceId_LogicalName	String	True
ServiceId_Name	String	True
StateCode	String	True
StatusCode	String	True
Subject	String	True

Competitor

This is a table representing the Competitor entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the competitor.
Address1_AddressId	String	False	Unique identifier for address 1.
Address1_AddressTypeCode	String	False	Type of address for address 1, such as billing, shipping, or primary address.
Address1_City	String	False	City name for address 1.
Address1_Country	String	False	Country/region name for address 1.
Address1_County	String	False	County name for address 1.
Address1_Fax	String	False	Fax number for address 1.
Address1_Latitude	Double	False	Latitude for address 1.
Address1_Line1	String	False	First line for entering address 1 information.
Address1_Line2	String	False	Second line for entering address 1 information.
Address1_Line3	String	False	Third line for entering address 1 information.
Address1_Longitude	Double	False	Longitude for address 1.
Address1_Name	String	False	Name to enter for address 1.
Address1_PostalCode	String	False	ZIP Code or postal code for address 1.
Address1_PostOfficeBox	String	False	Post office box number for address 1.
Address1_ShippingMethodCode	String	False	Method of shipment for address 1.
Address1_StateOrProvince	String	False	State or province for address 1.
Address1_Telephone1	String	False	First telephone number associated with address 1.
Address1_Telephone2	String	False	Second telephone number associated with address 1.
Address1_Telephone3	String	False	Third telephone number associated with address 1.
Address1_UPSZone	String	False	United Parcel Service (UPS) zone for address 1.
Address1_UTCOffset	Integer	False	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
Address2_AddressId	String	False	Unique identifier for address 2.
Address2_AddressTypeCode	String	False	Type of address for address 2. such as billing, shipping, or primary address.
Address2_City	String	False	City name for address 2.
Address2_Country	String	False	Country/region name for address 2.
Address2_County	String	False	County name for address 2.
Address2_Fax	String	False	Fax number for address 2.
Address2_Latitude	Double	False	Latitude for address 2.
Address2_Line1	String	False	First line for entering address 2 information.
Address2_Line2	String	False	Second line for entering address 2 information.
Address2_Line3	String	False	Third line for entering address 2 information.
Address2_Longitude	Double	False	Longitude for address 2.
Address2_Name	String	False	Name to enter for address 2.
Address2_PostalCode	String	False	ZIP Code or postal code for address 2.
Address2_PostOfficeBox	String	False	Post office box number for address 2.
Address2_ShippingMethodCode	String	False	Method of shipment for address 2.
Address2_StateOrProvince	String	False	State or province for address 2.
Address2_Telephone1	String	False	First telephone number associated with address 2.
Address2_Telephone2	String	False	Second telephone number associated with address 2.
Address2_Telephone3	String	False	Third telephone number associated with address 2.
Address2_UPSZone	String	False	United Parcel Service (UPS) zone for address 2.
Address2_UTCOffset	Integer	False	UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
CompetitorId	String	False	Unique identifier of the competitor.
CreatedBy_Id	String	True	Unique identifier of the user who created the competitor.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the competitor was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the competitor.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
ExchangeRate	Double	True	Exchange rate for the currency associated with the competitor with respect to the base currency.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
KeyProduct	String	False	Key products of the competitor.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the competitor.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the competitor was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the competitor.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the competitor.
Opportunities	String	False	Competitive opportunities against the competitor.
OrganizationId_Id	String	True	Unique identifier of the associated organization.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
Overview	String	False	Summary description of the competitor.
ReferenceInfoUrl	String	False	URL for the Web site where reference information about the competitor is located.
ReportedRevenue	Double	False	Reported revenue for the competitor.
ReportedRevenue_Base	Double	True	Base currency equivalent of the reported revenue for the competitor.
ReportingQuarter	Integer	False	Fiscal year quarter for the competitor's business.
ReportingYear	Integer	False	Fiscal year for the competitor's business.
StockExchange	String	False	Stock exchange on which the competitor is listed.
Strengths	String	False	Strengths of the competitor.
Threats	String	False	Competitive threats posed by the competitor.
TickerSymbol	String	False	Stock exchange ticker symbol for the competitor.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the competitor.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
Weaknesses	String	False	Competitive weaknesses of the competitor.
WebSiteUrl	String	False	Web site URL for the competitor.
WinPercentage	Double	False	Percentage of opportunities that the competitor wins.
YomiName	String	False	Pronunciation of the competitor name, written in phonetic hiragana or katakana characters.

CompetitorAddress

This is a table representing the CompetitorAddress entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the competitor address.
AddressNumber	Integer	False	Information about which competitor address is applicable.
AddressTypeCode	String	False	Type of address for the competitor, such as primary address.
City	String	False	City name in the competitor address.
CompetitorAddressId	String	False	Unique identifier of the competitor address.
Country	String	False	Country/region name in the competitor address.
County	String	False	County name in the competitor address.
CreatedBy_Id	String	True	Unique identifier of the user who created the competitor address.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the competitor address was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the competitor address.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Fax	String	False	Fax number for the competitor address.
Latitude	Double	False	Latitude for the competitor address.
Line1	String	False	First line for entering address information.
Line2	String	False	Second line for entering address information.
Line3	String	False	Third line for entering address information.
Longitude	Double	False	Longitude for the address for the competitor.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the competitor address.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the competitor address was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the competitor address.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name used to identify the competitor address.
ParentId_Id	String	False	Unique identifier of the parent object with which the competitor address is associated.
ParentId_LogicalName	String	False
ParentId_Name	String	False
PostalCode	String	False	ZIP Code or postal code in the competitor address.
PostOfficeBox	String	False	Post office box number in the competitor address.
ShippingMethodCode	String	False	Method of shipment for the competitor.
StateOrProvince	String	False	State or province in the competitor address.
Telephone1	String	False	First telephone number for the competitor address.
Telephone2	String	False	Second telephone number for the competitor address.
Telephone3	String	False	Third telephone number for the competitor address.
UPSZone	String	False	United Parcel Service (UPS) zone for the address of the competitor.
UTCOffset	Integer	False	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.

CompetitorProduct

This is a table representing the CompetitorProduct entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the competitor product.
CompetitorId	String	True
CompetitorProductId	String	False	Unique identifier of the competitor product.
ProductId	String	True

CompetitorSalesLiterature

This is a table representing the CompetitorSalesLiterature entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the sales literature for the competitor product.
CompetitorId	String	True
CompetitorSalesLiteratureId	String	False	Unique identifier of the sales literature for the competitor product.
SalesLiteratureId	String	True

Connection

This is a table representing the Connection entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the connection.
ConnectionId	String	False	Unique identifier of the connection.
CreatedBy_Id	String	True	Unique identifier of the user who created the connection.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the connection was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the connection.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the connection.
EffectiveEnd	Datetime	False	Effective end date for this connection.
EffectiveStart	Datetime	False	Effective start date for this connection.
ExchangeRate	Double	True	Exchange rate between the currency associated with the connection and the base currency.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsMaster	Boolean	True	Indicates that this is the master record.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the connection.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the connection was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who modified the connection.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	True	Name of the connection.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the connection.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the connection.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the connection.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the connection.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Record1Id_Id	String	False	Unique identifier of the source record.
Record1Id_LogicalName	String	False
Record1Id_Name	String	False
Record1ObjectTypeCode	String	True	Record type of the source record.
Record1RoleId_Id	String	False	Unique identifier of the role for the source record.
Record1RoleId_LogicalName	String	False
Record1RoleId_Name	String	False
Record2Id_Id	String	False	Unique identifier of the target record.
Record2Id_LogicalName	String	False
Record2Id_Name	String	False
Record2ObjectTypeCode	String	True	Record type of the target record.
Record2RoleId_Id	String	False	Unique identifier of the role for the target record.
Record2RoleId_LogicalName	String	False
Record2RoleId_Name	String	False
RelatedConnectionId_Id	String	True	Unique identifier for the reciprocal connection record.
RelatedConnectionId_LogicalName	String	True
RelatedConnectionId_Name	String	True
StateCode	String	True	Status of the connection.
StatusCode	String	False	Reason for the status of the connection.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the connection.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False

ConnectionRole

This is a table representing the ConnectionRole entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the connection role.
Category	String	False	Categories for connection roles.
ComponentState	String	True	State of the component.
ConnectionRoleId	String	False	Unique identifier of the connection role.
ConnectionRoleIdUnique	String	True	Unique identifier of the published or unpublished connection role record.
CreatedBy_Id	String	True	Unique identifier of the user who created the relationship role.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the connection role was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the relationship role.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the connection role.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsManaged	Boolean	True	Indicates whether the solution component is part of a managed solution.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the connection role.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the connection role was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who modified the relationship role.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the connection role.
OrganizationId_Id	String	True	Unique identifier of the organization that this connection role belongs to.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverwriteTime	Datetime	True	Date and time when the record was last overwritten.
SolutionId	String	True	Unique identifier of the associated solution.
StateCode	String	True	Status of the connection role.
StatusCode	String	False	Reason for the status of the connection role.

ConnectionRoleAssociation

This is a table representing the ConnectionRoleAssociation entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the connection role association.
AssociatedConnectionRoleId	String	False
ConnectionRoleAssociationId	String	False	Unique identifier of the connection role association.
ConnectionRoleId	String	False

ConnectionRoleObjectTypeCode

This is a table representing the ConnectionRoleObjectTypeCode entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the connection role object type association.
AssociatedObjectTypeCode	Integer	False
ConnectionRoleId_Id	String	False	Unique identifier of the connection role associated with the connection role object type code.
ConnectionRoleId_LogicalName	String	False
ConnectionRoleId_Name	String	False
ConnectionRoleObjectTypeCodeId	String	False	Unique identifier of the connection role object type association.
OrganizationId	String	True	Unique identifier of the organization associated with the connection role object type code.

ConstraintBasedGroup

This is a table representing the ConstraintBasedGroup entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the constraint-based resource group.
BusinessUnitId_Id	String	False	Unique identifier of the associated business unit.
BusinessUnitId_LogicalName	String	False
BusinessUnitId_Name	String	False
ConstraintBasedGroupId	String	False	Unique identifier of the resource group.
Constraints	String	False	Constraints defined for the resource group, such as availability and location.
CreatedBy_Id	String	True	Unique identifier of the user who created the resource group.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the resource group was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the constraint-based group.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the resource group.
GroupTypeCode	String	False	Resource type, such as user/facility or equipment.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the resource group.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the resource group was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the constraint-based group.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name for the resource group.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the resource group.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True

Contact

This is a table representing the Contact entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the contact.
AccountId_Id	String	True	Unique identifier of the account with which the contact is associated.
AccountId_LogicalName	String	True
AccountId_Name	String	True
AccountRoleCode	String	False	Account role of the contact.
Address1_AddressId	String	False	Unique identifier for address 1.
Address1_AddressTypeCode	String	False	Type of address for address 1, such as billing, shipping, or primary address.
Address1_City	String	False	City name for address 1.
Address1_Country	String	False	Country/region name for address 1.
Address1_County	String	False	County name for address 1.
Address1_Fax	String	False	Fax number for address 1.
Address1_FreightTermsCode	String	False	Freight terms for address 1.
Address1_Latitude	Double	False	Latitude for address 1.
Address1_Line1	String	False	First line for entering address 1 information.
Address1_Line2	String	False	Second line for entering address 1 information.
Address1_Line3	String	False	Third line for entering address 1 information.
Address1_Longitude	Double	False	Longitude for address 1.
Address1_Name	String	False	Name to enter for address 1.
Address1_PostalCode	String	False	ZIP Code or postal code for address 1.
Address1_PostOfficeBox	String	False	Post office box number for address 1.
Address1_PrimaryContactName	String	False	Name to enter for address 1 for the primary contact.
Address1_ShippingMethodCode	String	False	Method of shipment for address 1.
Address1_StateOrProvince	String	False	State or province for address 1.
Address1_Telephone1	String	False	First telephone number associated with address 1.
Address1_Telephone2	String	False	Second telephone number associated with address 1.
Address1_Telephone3	String	False	Third telephone number associated with address 1.
Address1_UPSZone	String	False	United Parcel Service (UPS) zone for address 1.
Address1_UTCOffset	Integer	False	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
Address2_AddressId	String	False	Unique identifier for address 2.
Address2_AddressTypeCode	String	False	Type of address for address 2, such as billing, shipping, or primary address.
Address2_City	String	False	City name for address 2.
Address2_Country	String	False	Country/region name for address 2.
Address2_County	String	False	County name for address 2.
Address2_Fax	String	False	Fax number for address 2.
Address2_FreightTermsCode	String	False	Freight terms for address 2.
Address2_Latitude	Double	False	Latitude for address 2.
Address2_Line1	String	False	First line for entering address 2 information.
Address2_Line2	String	False	Second line for entering address 2 information.
Address2_Line3	String	False	Third line for entering address 2 information.
Address2_Longitude	Double	False	Longitude for address 2.
Address2_Name	String	False	Name to enter for address 2.
Address2_PostalCode	String	False	ZIP Code or postal code for address 2.
Address2_PostOfficeBox	String	False	Post office box number for address 2.
Address2_PrimaryContactName	String	False	Name to enter for address 2 for the primary contact.
Address2_ShippingMethodCode	String	False	Method of shipment for address 2.
Address2_StateOrProvince	String	False	State or province for address 2.
Address2_Telephone1	String	False	First telephone number associated with address 2.
Address2_Telephone2	String	False	Second telephone number associated with address 2.
Address2_Telephone3	String	False	Third telephone number associated with address 2.
Address2_UPSZone	String	False	United Parcel Service (UPS) zone for address 2.
Address2_UTCOffset	Integer	False	UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
Aging30	Double	True	For internal use only.
Aging30_Base	Double	True	Base currency equivalent of the aging 30 for the contact.
Aging60	Double	True	For internal use only.
Aging60_Base	Double	True	Base currency equivalent of the aging 60 for the contact.
Aging90	Double	True	For internal use only.
Aging90_Base	Double	True	Base currency equivalent of the aging 90 for the contact.
Anniversary	Datetime	False	Wedding anniversary of the contact.
AnnualIncome	Double	False	Annual income of the contact.
AnnualIncome_Base	Double	True	Base currency equivalent of the annual income of the contact.
AssistantName	String	False	Name of the contact's assistant contact.
AssistantPhone	String	False	Phone number for the contact's assistant.
BirthDate	Datetime	False	Birth date of the contact.
ChildrensNames	String	False	Names of the contact's children.
ContactId	String	False	Unique identifier of the contact.
CreatedBy_Id	String	True	Unique identifier of the user who created the contact.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the contact was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the contact.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CreditLimit	Double	False	Credit limit for the contact.
CreditLimit_Base	Double	True	Base currency equivalent of the credit limit for the contact.
CreditOnHold	Boolean	False	Information about whether credit for the contact is on hold.
CustomerSizeCode	String	False	Size of the contact's business.
CustomerTypeCode	String	False	Type of business associated with the contact.
DefaultPriceLevelId_Id	String	False	Unique identifier of the default price list for the contact.
DefaultPriceLevelId_LogicalName	String	False
DefaultPriceLevelId_Name	String	False
Department	String	False	Department in the business unit or organization associated with the contact.
Description	String	False	Description of the contact.
DoNotBulkEMail	Boolean	False	Information about whether to allow sending direct email to the contact.
DoNotBulkPostalMail	Boolean	False	Information about whether to allow sending bulk-rate postal mail to the contact.
DoNotEMail	Boolean	False	Information about whether to allow sending email to the contact.
DoNotFax	Boolean	False	Information about whether to allow sending fax transmittals to the contact.
DoNotPhone	Boolean	False	Information about whether to allow phone calls to the contact.
DoNotPostalMail	Boolean	False	Information about whether to allow sending postal mail to the contact.
DoNotSendMM	Boolean	False	Information regarding whether to allow sending marketing mail to the contact.
EducationCode	String	False	Formal education level that the contact has attained.
EMailAddress1	String	False	First email address for the contact.
EMailAddress2	String	False	Second email address for the contact.
EMailAddress3	String	False	Third email address for the contact.
EmployeeId	String	False	Employee ID for the contact.
ExchangeRate	Double	True	Exchange rate for the currency associated with the contact with respect to the base currency.
ExternalUserIdentifier	String	False	Identifier for an external user.
FamilyStatusCode	String	False	Marital status of the contact.
Fax	String	False	Fax number for the contact.
FirstName	String	False	First name of the contact.
FtpSiteUrl	String	False	FTP site URL for the contact.
FullName	String	True	Full name of the contact.
GenderCode	String	False	Gender of the contact.
GovernmentId	String	False	Government ID for the contact.
HasChildrenCode	String	False	Information about whether the contact has children.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsBackofficeCustomer	Boolean	False	Information about whether the contact is in an associated Microsoft Great Plains database.
JobTitle	String	False	Job title of the contact.
LastName	String	False	Last name of the contact.
LastUsedInCampaign	Datetime	False	Date and time when the contact was last contacted as a part of a marketing campaign.
LeadSourceCode	String	False	Source of the lead of the contact.
ManagerName	String	False	Name of the contact's manager.
ManagerPhone	String	False	Phone number for the contact's manager.
MasterId_Id	String	True	Unique identifier of the master contact for merge.
MasterId_LogicalName	String	True
MasterId_Name	String	True
Merged	Boolean	True	Information regarding whether the account has been merged with a master contact.
MiddleName	String	False	Middle name of the contact.
MobilePhone	String	False	Mobile phone number for the contact.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the contact.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the contact was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the contact.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
NickName	String	False	Nickname of the contact.
NumberOfChildren	Integer	False	How many children the contact has.
OriginatingLeadId_Id	String	False	Unique identifier of the lead from which the contact was created.
OriginatingLeadId_LogicalName	String	False
OriginatingLeadId_Name	String	False
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the contact.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the contact.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the contact.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the contact.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Pager	String	False	Pager number for the contact.
ParentContactId_Id	String	True	Unique identifier of the parent contact.
ParentContactId_LogicalName	String	True
ParentContactId_Name	String	True
ParentCustomerId_Id	String	False	Unique identifier of the account or contact associated with the contact.
ParentCustomerId_LogicalName	String	False
ParentCustomerId_Name	String	False
ParticipatesInWorkflow	Boolean	False	Information about whether the contact participates in workflow rules.
PaymentTermsCode	String	False	Payment terms for the contact.
PreferredAppointmentDayCode	String	False	Day of the week that the contact prefers for scheduling service activities.
PreferredAppointmentTimeCode	String	False	Time of day that the contact prefers for scheduling service activities.
PreferredContactMethodCode	String	False	Preferred contact method for the contact.
PreferredEquipmentId_Id	String	False	Unique identifier of the facility/equipment preferred by the contact for scheduling service activities.
PreferredEquipmentId_LogicalName	String	False
PreferredEquipmentId_Name	String	False
PreferredServiceId_Id	String	False	Unique identifier of the service preferred by the contact for scheduling service activities.
PreferredServiceId_LogicalName	String	False
PreferredServiceId_Name	String	False
PreferredSystemUserId_Id	String	False	Unique identifier of the system user preferred by the contact for scheduling service activities.
PreferredSystemUserId_LogicalName	String	False
PreferredSystemUserId_Name	String	False
Salutation	String	False	Salutation for correspondence with the contact.
ShippingMethodCode	String	False	Method of shipping for the contact.
SpousesName	String	False	Name of the contact's spouse/partner.
StateCode	String	True	Status of the contact.
StatusCode	String	False	Reason for the status of the contact.
Suffix	String	False	Suffix for the contact name, such as Jr., Sr., or III.
Telephone1	String	False	First telephone number for the contact.
Telephone2	String	False	Second telephone number for the contact.
Telephone3	String	False	Third telephone number for the contact.
TerritoryCode	String	False	Unique identifier of the territory to which the contact is assigned.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the contact.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
WebSiteUrl	String	False	Web site URL for the contact.
YomiFirstName	String	False	Hiragana or Katakana phonetic guide for the contact first name, used for Yomi sorting.
YomiFullName	String	True	Hiragana or Katakana phonetic guide for the contact full name, used for Yomi sorting.
YomiLastName	String	False	Hiragana or Katakana phonetic guide for the contact last name, used for Yomi sorting.
YomiMiddleName	String	False	Hiragana or Katakana phonetic guide for the contact middle name, used for Yomi sorting.

ContactInvoices

This is a table representing the ContactInvoices entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the invoices for the contact.
ContactId	String	True
ContactInvoiceId	String	False	Unique identifier of the invoices for the contact.
InvoiceId	String	True

ContactLeads

This is a table representing the ContactLeads entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the leads for the contact.
ContactId	String	True
ContactLeadId	String	False	Unique identifier of the leads for the contact.
LeadId	String	True

ContactOrders

This is a table representing the ContactOrders entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the orders for the contact.
ContactId	String	True
ContactOrderId	String	False	Unique identifier of the orders for the contact.
SalesOrderId	String	True

ContactQuotes

This is a table representing the ContactQuotes entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the quotes for the contact.
ContactId	String	True
ContactQuoteId	String	False	Unique identifier of the quotes for the contact.
QuoteId	String	True

Contract

This is a table representing the Contract entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the contract.
AccountId_Id	String	True	Unique identifier of the account with which the contract is associated.
AccountId_LogicalName	String	True
AccountId_Name	String	True
ActiveOn	Datetime	False	Date and time when the contract becomes active.
AllotmentTypeCode	String	False	Type of allotment that the contract supports.
BillingAccountId_Id	String	True	Unique identifier of the account to which the contract is to be billed.
BillingAccountId_LogicalName	String	True
BillingAccountId_Name	String	True
BillingContactId_Id	String	True	Unique identifier of the contact to whom the contract is to be billed.
BillingContactId_LogicalName	String	True
BillingContactId_Name	String	True
BillingCustomerId_Id	String	False	Unique identifier of the account or contact to which the contract is to be billed.
BillingCustomerId_LogicalName	String	False
BillingCustomerId_Name	String	False
BillingEndOn	Datetime	False	Date and time when the billing period ends.
BillingFrequencyCode	String	False	How often the customer or account is to be billed.
BillingStartOn	Datetime	False	Date and time when the billing period begins.
BillToAddress_Id	String	False	Address to bill for contract charges.
BillToAddress_LogicalName	String	False
BillToAddress_Name	String	False
CancelOn	Datetime	True	Date when the contract was canceled.
ContactId_Id	String	True	Unique identifier of the contact specified for the contract.
ContactId_LogicalName	String	True
ContactId_Name	String	True
ContractId	String	False	Unique identifier of the contract.
ContractLanguage	String	False	Description of the contract.
ContractNumber	String	False	System-generated contract identification number.
ContractServiceLevelCode	String	False	Response level or level of service specified for the contract.
ContractTemplateAbbreviation	String	True	Abbreviation of the contract template name.
ContractTemplateId_Id	String	False	Unique identifier of the template associated with the contract.
ContractTemplateId_LogicalName	String	False
ContractTemplateId_Name	String	False
CreatedBy_Id	String	True	Unique identifier of the user who created the contract.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the contract was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the contract.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier of the account or contact associated with the contract.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
Duration	Integer	True	Calculated duration of time that the contract spans.
EffectivityCalendar	String	False	Days of the week and times during which customer service support is available for the duration of the contract.
ExchangeRate	Double	True	Exchange rate for the currency associated with the contract with respect to the base currency.
ExpiresOn	Datetime	False	Date when the contract expires.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the contract.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the contract was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the contract.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
NetPrice	Double	True	Sum of all net values calculated on the contract lines.
NetPrice_Base	Double	True	Base currency equivalent of the sum of all net values calculated on the contract lines.
OriginatingContract_Id	String	False	Unique identifier of the original contract from which this current contract was derived.
OriginatingContract_LogicalName	String	False
OriginatingContract_Name	String	False
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the contract.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the contract.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the contract.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the contract.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ServiceAddress_Id	String	False	Unique identifier of the address at which service is to be provided.
ServiceAddress_LogicalName	String	False
ServiceAddress_Name	String	False
StateCode	String	True	Status of the contract.
StatusCode	String	False	Reason for the status of the contract.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
Title	String	False	Title of the contract.
TotalDiscount	Double	True	Total of all discounts specified on the contract lines.
TotalDiscount_Base	Double	True	Base currency equivalent of the total of all discounts specified on the contract lines.
TotalPrice	Double	True	Total price of the contract.
TotalPrice_Base	Double	True	Base currency equivalent of the total price of the contract.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the contract.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UseDiscountAsPercentage	Boolean	False	Information about whether the discount is a percentage or a monetary amount.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

ContractDetail

This is a table representing the ContractDetail entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the contract line.
AccountId_Id	String	True	Unique identifier of the account with which the contract is associated.
AccountId_LogicalName	String	True
AccountId_Name	String	True
ActiveOn	Datetime	False	Date and time when the contract line becomes active.
AllotmentsOverage	Integer	True	Number of overage allotments for the contract line.
AllotmentsRemaining	Integer	True	Number of allotments remaining for the contract line.
AllotmentsUsed	Integer	True	Number of allotments that have been used for the contract line.
ContactId_Id	String	True	Unique identifier for the contact associated with the contract line.
ContactId_LogicalName	String	True
ContactId_Name	String	True
ContractDetailId	String	False	Unique identifier of the contract line.
ContractId_Id	String	False	Unique identifier of the contract associated with the contract line.
ContractId_LogicalName	String	False
ContractId_Name	String	False
ContractStateCode	String	True	Status of the contract.
CreatedBy_Id	String	True	Unique identifier of the user who created the contract line.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the contract line was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the contractdetail.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier for the account or contact associated with the contract line.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
Discount	Double	False	Discount for the contract line. Specified as a monetary amount.
Discount_Base	Double	True	Base currency equivalent of the discount for the contract line.
DiscountPercentage	Double	False	Discount for the contract line. Specified as a percentage.
EffectivityCalendar	String	False	Days of the week and times for which the contract line item is effective.
ExchangeRate	Double	True	Exchange rate for the currency associated with the contract detail with respect to the base currency.
ExpiresOn	Datetime	False	Date when the contract line item expires.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
InitialQuantity	Integer	False	Initial quantity of units allocated in the contract line item.
LineItemOrder	Integer	False	Position of item in the list of contract line items.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the contract line.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the contract line was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the contractdetail.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Net	Double	True	Net price for the contract line. Net price is the total price minus any applicable discount.
Net_Base	Double	True	Base currency equivalent of the net price for the contract line.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the contract detail.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the contract line.
OwningUser	String	True	Unique identifier of the user who owns the contract line.
Price	Double	False	Price of the contract line.
Price_Base	Double	True	Base currency equivalent of the price of the contract line.
ProductId_Id	String	False	Unique identifier of the product associated with the contract line.
ProductId_LogicalName	String	False
ProductId_Name	String	False
ProductSerialNumber	String	False	Serial number of the product referenced in the contract line.
Rate	Double	True	Billing rate for the contract line.
Rate_Base	Double	True	Base currency equivalent of the billing rate for the contract line.
ServiceAddress_Id	String	False	Address at which service is to be provided.
ServiceAddress_LogicalName	String	False
ServiceAddress_Name	String	False
ServiceContractUnitsCode	String	False	Unique identifier of the product units specified on the contract line.
StateCode	String	True	Status of the contract line item.
StatusCode	String	False	Reason for the status of the contract line item.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
Title	String	False	Title of the contract line.
TotalAllotments	Integer	False	Total allotments for the contract line.
TransactionCurrencyId_Id	String	True	Unique identifier of the currency associated with the contract detail.
TransactionCurrencyId_LogicalName	String	True
TransactionCurrencyId_Name	String	True
UoMId_Id	String	False	Unique identifier of the unit associated with the contract line.
UoMId_LogicalName	String	False
UoMId_Name	String	False
UoMScheduleId_Id	String	False	Unique identifier of the unit group associated with the contract line.
UoMScheduleId_LogicalName	String	False
UoMScheduleId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

ContractTemplate

This is a table representing the ContractTemplate entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the contract template.
Abbreviation	String	False	Abbreviation of the contract template name.
AllotmentTypeCode	String	False	Criteria for the contracts based on the template, such as number of cases, time, or coverage dates.
BillingFrequencyCode	String	False	How often the customer or account is to be billed in contracts that are based on the template.
ComponentState	String	True	For internal use only.
ContractServiceLevelCode	String	False	Unique identifier of the level of service specified in contracts that are based on the template.
ContractTemplateId	String	False	Unique identifier of the contract template.
ContractTemplateIdUnique	String	True	For internal use only.
CreatedBy_Id	String	True	Unique identifier of the user who created the contract template.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the contract template was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the contracttemplate.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the contract template.
EffectivityCalendar	String	False	Days of the week and times for which contracts based on the template are effective.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsManaged	Boolean	True	Indicates whether the solution component is part of a managed solution.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the contract template.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the contract template was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the contracttemplate.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the contract template.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the contract template.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OverwriteTime	Datetime	True	For internal use only.
SolutionId	String	True	Unique identifier of the associated solution.
UseDiscountAsPercentage	Boolean	False	Specifies whether the discount is a percentage or a monetary amount in contracts based on the template.

CustomerAddress

This is a table representing the CustomerAddress entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the customer address.
AddressNumber	Integer	False	Specifies which customer address is applicable.
AddressTypeCode	String	False	Type of address for the customer, such as billing, shipping, or primary address.
City	String	False	City name in the customer address.
Country	String	False	Country/region name in the customer address.
County	String	False	County name in the customer address.
CreatedBy_Id	String	True	Unique identifier of the user who created the customer address.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the customer address was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the customeraddress.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerAddressId	String	False	Unique identifier of the customer address.
ExchangeRate	Double	True	Exchange rate for the currency associated with the customeraddress with respect to the base currency.
Fax	String	False	Fax number for the customer address.
FreightTermsCode	String	False	Freight terms for the customer address.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
Latitude	Double	False	Latitude for the customer address.
Line1	String	False	First line for entering address information.
Line2	String	False	Second line for entering address information.
Line3	String	False	Third line for entering address information.
Longitude	Double	False	Longitude for the customer address.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the customer address.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the customer address was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the customeraddress.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name used to identify the customer address.
ObjectTypeCode	String	False	Type of entity with which the customer address is associated.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the customer address.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the customer address.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the customer address.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ParentId_Id	String	False	Unique identifier of the parent object with which the customer address is associated.
ParentId_LogicalName	String	False
ParentId_Name	String	False
PostalCode	String	False	ZIP Code or postal code in the customer address.
PostOfficeBox	String	False	Post office box number in the customer address.
PrimaryContactName	String	False	Name of the primary contact at the customer address.
ShippingMethodCode	String	False	Method of shipment for the customer address.
StateOrProvince	String	False	State or province in the customer address.
Telephone1	String	False	First telephone number for the customer address.
Telephone2	String	False	Second telephone number for the customer address.
Telephone3	String	False	Third telephone number for the customer address.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the customeraddress.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UPSZone	String	False	United Parcel Service (UPS) zone for the address of the customer.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
UTCOffset	Integer	False	UTC offset for the address. This is the difference between local time and standard Coordinated Universal Time.

CustomerOpportunityRole

This is a table representing the CustomerOpportunityRole entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the opportunity relationship.
CreatedBy_Id	String	True	Unique Identifier of the user who created the opportunity relationship.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the opportunity relationship was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the customer opportunity role.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier of the customer for the opportunity relationship.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
CustomerOpportunityRoleId	String	False	Unique identifier of the opportunity relationship.
Description	String	False	Description of the opportunity relationship.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the opportunity relationship.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the opportunity relationship was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the customeropportunityrole.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OpportunityId_Id	String	False	Unique identifier of the opportunity for the opportunity relationship.
OpportunityId_LogicalName	String	False
OpportunityId_Name	String	False
OpportunityRoleId_Id	String	False	Unique identifier for role the customer plays with the opportunity.
OpportunityRoleId_LogicalName	String	False
OpportunityRoleId_Name	String	False
OpportunityStateCode	Integer	True	Status of the opportunity.
OpportunityStatusCode	Integer	True	Reason for the status of the opportunity.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the customer opportunity role.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier for the business unit that owns the customer opportunity role.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the customer opportunity role.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the customer opportunity role.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True

CustomerRelationship

This is a table representing the CustomerRelationship entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the customer relationship.
ConverseRelationshipId_Id	String	False	Unique identifier of the converse relationship of the customer relationship.
ConverseRelationshipId_LogicalName	String	False
ConverseRelationshipId_Name	String	False
CreatedBy_Id	String	True	Unique Identifier of the user who created the customer relationship.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the customer relationship was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the customerrelationship.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier of the primary customer in the relationship.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
CustomerRelationshipId	String	False	Unique identifier of the customer relationship.
CustomerRoleDescription	String	False	Description of the customer and the customer's role in this relationship.
CustomerRoleId_Id	String	False	Unique identifier of the customer role.
CustomerRoleId_LogicalName	String	False
CustomerRoleId_Name	String	False
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the customer relationship.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the customer relationship was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the customerrelationship.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the customer relationship.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the customer relationship.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the customer relationship.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the customer relationship.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PartnerId_Id	String	False	Unique identifier of the secondary customer in the relationship.
PartnerId_LogicalName	String	False
PartnerId_Name	String	False
PartnerRoleDescription	String	False	Description of the customer and the customer's role in this relationship.
PartnerRoleId_Id	String	False	Unique identifier of the relationship role of the secondary customer.
PartnerRoleId_LogicalName	String	False
PartnerRoleId_Name	String	False

Dependency

This is a table representing the Dependency entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the dependency.
DependencyId	String	True	Unique identifier of a dependency.
DependencyType	String	True	The dependency type of the dependency.
DependentComponentBaseSolutionId	String	True
DependentComponentNodeId_Id	String	True	Unique identifier of the dependent component's node.
DependentComponentNodeId_LogicalName	String	True
DependentComponentNodeId_Name	String	True
DependentComponentObjectId	String	True
DependentComponentParentId	String	True
DependentComponentType	String	True
RequiredComponentBaseSolutionId	String	True
RequiredComponentNodeId_Id	String	True	Unique identifier of the required component's node
RequiredComponentNodeId_LogicalName	String	True
RequiredComponentNodeId_Name	String	True
RequiredComponentObjectId	String	True
RequiredComponentParentId	String	True
RequiredComponentType	String	True

DependencyNode

This is a table representing the DependencyNode entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the node.
BaseSolutionId_Id	String	True	Unique identifier of the user who created the solution
BaseSolutionId_LogicalName	String	True
BaseSolutionId_Name	String	True
ComponentType	String	True	The type code of the component.
DependencyNodeId	String	True	Unique identifier of the dependency node.
IsSharedComponent	Boolean	True	Whether this component is shared by two solutions with the same publisher.
ObjectId	String	False	Unique identifier of the object with which the node is associated.
ParentId	String	True	Unique identifier of the parent entity.
TopSolutionId_Id	String	True	Unique identifier of the top solution.
TopSolutionId_LogicalName	String	True
TopSolutionId_Name	String	True

Discount

This is a table representing the Discount entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the discount.
Amount	Double	False	Amount of the discount, specified either as a percentage or as a monetary amount.
Amount_Base	Double	True	Base currency equivalent of the amount of the discount.
CreatedBy_Id	String	True	Unique identifier of the user who created the discount.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the discount was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the discount.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DiscountId	String	False	Unique identifier of the discount.
DiscountTypeId_Id	String	False	Unique identifier of the discount list associated with the discount.
DiscountTypeId_LogicalName	String	False
DiscountTypeId_Name	String	False
ExchangeRate	Double	True	Exchange rate for the currency associated with the discount with respect to the base currency.
HighQuantity	Double	False	Upper boundary for the quantity range to which a particular discount can be applied.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsAmountType	Boolean	True	Specifies whether the discount is specified as a monetary amount or a percentage.
LowQuantity	Double	False	Lower boundary for the quantity range to which a particular discount is applied.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the discount.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the discount was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the discount.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId	String	True	Unique identifier of the organization associated with the discount.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
Percentage	Double	False	Percentage discount value.
StatusCode	String	False	Reason for the status of the discount.
TransactionCurrencyId_Id	String	True	Unique identifier of the currency associated with the discount.
TransactionCurrencyId_LogicalName	String	True
TransactionCurrencyId_Name	String	True

DiscountType

This is a table representing the DiscountType entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the discount list.
CreatedBy_Id	String	True	Unique identifier of the user who created the discount list.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the discount list was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the discounttype.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the discount list.
DiscountTypeId	String	False	Unique identifier of the discount list.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsAmountType	Boolean	False	Information about whether the discount list amounts are specified as monetary amounts or percentages.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the discount list.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the discount list was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the discounttype.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the discount list.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the discount list.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
StateCode	String	True	Status of the discount list.
StatusCode	String	False	Reason for the status of the discount list.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the discount type.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False

DisplayString

This is a table representing the DisplayString entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the display string.
ComponentState	String	True	For internal use only.
CreatedBy_Id	String	True	Unique identifier of the user who created the display string.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the display string was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the display string.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomComment	String	False	Comment for a customized display string.
CustomDisplayString	String	False	Customized display string.
DisplayStringId	String	False	Unique identifier of the display string.
DisplayStringIdUnique	String	True	For internal use only.
DisplayStringKey	String	True	For internal use only.
FormatParameters	Integer	True	Parameters used for formatting the display string.
IsManaged	Boolean	True
LanguageCode	Integer	False	Language code of the display string.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the display string.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the display string was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the displaystring.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId_Id	String	True	Unique identifier of the organization associated with the display string.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverwriteTime	Datetime	True	For internal use only.
PublishedDisplayString	String	True	Published display string.
SolutionId	String	True	Unique identifier of the associated solution.

DisplayStringMap

This is a table representing the DisplayStringMap entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the display string map.
ComponentState	String	True	For internal use only.
DisplayStringId	String	False	Unique identifier of the display string.
DisplayStringMapId	String	False	Unique identifier of the display string map.
DisplayStringMapIdUnique	String	True	For internal use only.
IsManaged	Boolean	True
ObjectTypeCode	Integer	False	Type of entity with which the note is associated.
OverwriteTime	Datetime	True	For internal use only.
SolutionId	String	True	Unique identifier of the associated solution.

DocumentIndex

This is a table representing the DocumentIndex entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the indexed article.
CreatedBy_Id	String	True	Unique identifier of the user who created the indexed article.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the indexed article was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the documentindex.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DocumentId_Id	String	False	Unique identifier of the document.
DocumentId_LogicalName	String	False
DocumentId_Name	String	False
DocumentIndexId	String	False	Unique identifier of the indexed article.
DocumentTypeCode	String	False	For internal use only.
IsPublished	Boolean	False	Flag indicating that the document is published.
KeyWords	String	False	Keywords for the document.
Location	String	False	Location of the document.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the indexed article.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the indexed article was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the documentindex.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Number	String	False	For internal use only.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the indexed article.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
SearchText	String	False	For internal use only.
SubjectId_Id	String	False	Unique identifier of the subject associated with the indexed article.
SubjectId_LogicalName	String	False
SubjectId_Name	String	False
Title	String	False	Title of the indexed article.

DuplicateRecord

This is a table representing the DuplicateRecord entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the duplicate record.
AsyncOperationId_Id	String	True	Unique identifier of the system job that created this record.
AsyncOperationId_LogicalName	String	True
AsyncOperationId_Name	String	True
BaseRecordId_Id	String	True	Unique identifier of the base record.
BaseRecordId_LogicalName	String	True
BaseRecordId_Name	String	True
CreatedOn	Datetime	True	Date and time when the duplicate record was created.
DuplicateId	String	False	Unique identifier of the duplicate record.
DuplicateRecordId_Id	String	True	Unique identifier of the potential duplicate record.
DuplicateRecordId_LogicalName	String	True
DuplicateRecordId_Name	String	True
DuplicateRuleId_Id	String	True	Unique identifier of the duplicate rule against which this duplicate was found.
DuplicateRuleId_LogicalName	String	True
DuplicateRuleId_Name	String	True
OwnerId_Id	String	True	Unique identifier of the user or team who owns the duplicate record.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the duplicate record.
OwningUser	String	True	Unique identifier of the user who owns the duplicate record.

DuplicateRule

This is a table representing the DuplicateRule entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the duplicate detection rule.
BaseEntityMatchCodeTable	String	True	Database table that stores match codes for the record type being evaluated for potential duplicates.
BaseEntityName	String	False	Record type of the record being evaluated for potential duplicates.
BaseEntityTypeCode	String	True	Record type of the record being evaluated for potential duplicates.
CreatedBy_Id	String	True	Unique identifier of the user who created the duplicate detection rule.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the duplicate detection rule was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the duplicaterule.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the duplicate detection rule.
DuplicateRuleId	String	False	Unique identifier of the duplicate detection rule.
IsCaseSensitive	Boolean	False	Indicates if the operator is case-sensitive.
MatchingEntityMatchCodeTable	String	True	Database table that stores match codes for potential duplicate records.
MatchingEntityName	String	False	Record type of the records being evaluated as potential duplicates.
MatchingEntityTypeCode	String	True	Record type of the records being evaluated as potential duplicates.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the duplicate detection rule.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the duplicate detection rule was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the duplicaterule.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the duplicate detection rule.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the duplicate detection rule.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns duplicate detection rule.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the duplicate detection rule.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the duplicate detection rule.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
StateCode	String	True	Status of the duplicate detection rule.
StatusCode	String	False	Reason for the status of the duplicate detection rule.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

DuplicateRuleCondition

This is a table representing the DuplicateRuleCondition entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the condition.
BaseAttributeName	String	False	Field that is being compared.
CreatedBy_Id	String	True	Unique identifier of the user who created the condition.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the condition was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the duplicate rule condition.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DuplicateRuleConditionId	String	False	Unique identifier of the condition.
MatchingAttributeName	String	False	Field that is being compared with the base field.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the condition.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the condition was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the duplicate rule condition.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OperatorCode	String	False	Operator for this rule condition.
OperatorParam	Integer	False	Parameter value of N if the operator is Same First Characters or Same Last Characters.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the duplicate rule condition.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the condition.
OwningUser	String	True	Unique identifier of the user who owns the condition.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the condition is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False

Email

This is a table representing the Email entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the email.
ActivityId	String	False	Unique identifier of the email activity.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Duration of the email activity specified in minutes.
ActualEnd	Datetime	False	Time when the email activity ends.
ActualStart	Datetime	False	Time when the email activity begins.
bcc_Ids	String	False	Blind carbon copy (BCC) recipients.
bcc_LogicalNames	String	False
bcc_Names	String	False
Category	String	False	Category of the activity.
cc_Ids	String	False	Carbon copy (CC) recipients.
cc_LogicalNames	String	False
cc_Names	String	False
Compressed	Boolean	True	Indicates if the body is compressed.
CreatedBy_Id	String	True	Unique identifier of the user who created the email activity.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the email activity was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the email.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DeliveryAttempts	Integer	False	Number of attempts made to deliver the email.
DeliveryReceiptRequested	Boolean	False	Delivery receipt requested.
Description	String	False	Main body text of the email.
DirectionCode	Boolean	False	Direction code for the email: incoming or outgoing.
ExchangeRate	Double	True	Exchange rate for the currency associated with the email with respect to the base currency.
from_Ids	String	False	Who the email is from.
from_LogicalNames	String	False
from_Names	String	False
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsBilled	Boolean	False	Information regarding whether the email activity was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Indication if the email was created by a workflow rule.
MessageId	String	False	Unique identifier of the email message. Used only for email that is received.
MimeType	String	False	MIME type of the email message data.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the email activity.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the email activity was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the email.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Notifications	String	False	Notifications for detail form.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the email activity.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the email activity.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the email activity.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the email activity.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriorityCode	String	False	Priority code of the email.
ReadReceiptRequested	Boolean	False	Indicates that a read receipt is requested.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the email is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ScheduledDurationMinutes	Integer	True	Scheduled duration of the email activity, specified in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the email activity.
ScheduledStart	Datetime	False	Scheduled start time of the email activity.
Sender	String	False	Sender of the email.
ServiceId_Id	String	False	Unique identifier for the associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the email activity.
StatusCode	String	False	Reason for the status of the email activity.
Subcategory	String	False	Subcategory of the email activity.
Subject	String	False	Subject associated with the email activity.
SubmittedBy	String	False	email delivery source.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
to_Ids	String	False	Recipient party list for the email, and references recipient records such as users and queues.
to_LogicalNames	String	False
to_Names	String	False
ToRecipients	String	False	String that lists email addresses corresponding to the recipients.
TrackingToken	String	False	Tracking token number.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the email.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

EmailHash

This is a table representing the EmailHash entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the email hash.
ActivityId_Id	String	False	Unique identifier of the activity with which the hash is associated.
ActivityId_LogicalName	String	False
ActivityId_Name	String	False
EmailHashId	String	False	Unique identifier of the email hash.
Hash	Integer	False	Hash value.
HashType	Integer	False	Hash type.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the email hash.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the email hash.
OwningUser	String	True	Unique identifier of the user who owns the email hash.

EmailSearch

This is a table representing the EmailSearch entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the email search entry.
EmailAddress	String	False	The email address.
EmailSearchId	String	False	Unique identifier of the email search entry.
ParentObjectId_Id	String	False	Unique identifier of the parent object with which the email address is associated.
ParentObjectId_LogicalName	String	False
ParentObjectId_Name	String	False

EntityMap

This is a table representing the EntityMap entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the entity map.
ComponentState	String	True	For internal use only.
CreatedBy_Id	String	True	Unique identifier of the user who created the entity map.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the entity map was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the entitymap.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
EntityMapId	String	False	Unique identifier of the entity map.
EntityMapIdUnique	String	True	For internal use only.
IsManaged	Boolean	True
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the entity map.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the entity map was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the entitymap.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId_Id	String	True	Unique identifier of the organization with which the entity map is associated.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverwriteTime	Datetime	True	For internal use only.
SolutionId	String	True	Unique identifier of the associated solution.
SourceEntityName	String	False	Name of the source entity for the entity mapping.
TargetEntityName	String	False	Name of the Microsoft Dynamics CRM entity.

Equipment

This is a table representing the Equipment entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the facility/equipment.
BusinessUnitId_Id	String	False	Unique identifier of the associated business unit.
BusinessUnitId_LogicalName	String	False
BusinessUnitId_Name	String	False
CalendarId_Id	String	False	Fiscal calendar associated with the facility/equipment.
CalendarId_LogicalName	String	False
CalendarId_Name	String	False
CreatedBy_Id	String	True	Unique identifier of the user who created the facility/equipment entry.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the facility/equipment entry was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the equipment.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the facility/equipment.
DisplayInServiceViews	Boolean	False	For internal use only.
EMailAddress	String	False	Email address of person to contact about the use of the facility/equipment.
EquipmentId	String	False	Unique identifier of the facility/equipment.
ExchangeRate	Double	True	Exchange rate for the currency associated with the equipment with respect to the base currency.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsDisabled	Boolean	False	Whether the facility/equipment is disabled or operational.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the facility/equipment.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the facility/equipment entry was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the equipment.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the facility/equipment.
OrganizationId_Id	String	True	Unique identifier of the parent business unit.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
SiteId_Id	String	False	Site where the facility/equipment is located.
SiteId_LogicalName	String	False
SiteId_Name	String	False
Skills	String	False	Skills needed to operate the facility/equipment.
TimeZoneCode	Integer	False	Local time zone where the facility/equipment is located.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the equipment.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

Fax

This is a table representing the Fax entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the fax activity.
ActivityId	String	False	Unique identifier of the fax activity.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Actual duration of the fax activity in minutes.
ActualEnd	Datetime	False	Actual end time of the fax activity.
ActualStart	Datetime	False	Actual start time of the fax activity.
BillingCode	String	False	Billing code associated with the sender.
Category	String	False	Category of the fax activity.
CoverPageName	String	False	Name of a cover page to use when sending a fax.
CreatedBy_Id	String	True	Unique identifier of the user who created the fax activity.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the fax activity was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the fax.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the fax activity.
DirectionCode	Boolean	False	Direction code for the fax; incoming or outgoing.
ExchangeRate	Double	True	Exchange rate for the currency associated with the fax with respect to the base currency.
FaxNumber	String	False	Telephone number of the receiving fax equipment.
from_Ids	String	False	Who the fax is from.
from_LogicalNames	String	False
from_Names	String	False
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsBilled	Boolean	False	Information regarding whether the fax activity was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Indication of whether the fax activity was created by a workflow rule.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the fax activity.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the fax activity was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the fax.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
NumberOfPages	Integer	False	Number of pages in the fax.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the fax activity.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the fax activity.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team that owns the fax activity.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user that owns the fax activity.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriorityCode	String	False	Priority code of the fax activity.
RegardingObjectId_Id	String	False	Unique identifier of the object with which the fax activity is associated.
RegardingObjectId_LogicalName	String	False
RegardingObjectId_Name	String	False
ScheduledDurationMinutes	Integer	True	Scheduled duration of the fax activity, specified in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the fax activity.
ScheduledStart	Datetime	False	Scheduled start time of the fax activity.
ServiceId_Id	String	False	Unique identifier for an associated service.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the fax activity.
StatusCode	String	False	Reason for the status of the fax activity.
Subcategory	String	False	Subcategory of the fax activity.
Subject	String	False	Subject associated with the fax activity.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
to_Ids	String	False	Person who is the receiver of the fax.
to_LogicalNames	String	False
to_Names	String	False
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the fax.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
Tsid	String	False	Transmitting station identifier (TSID) associated with a send action.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

FieldPermission

This is a table representing the FieldPermission entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the attribute.
AttributeLogicalName	String	False	Attribute name.
CanCreate	String	False	Can this Profile create the attribute
CanRead	String	False	Can this Profile read the attribute
CanUpdate	String	False	Can this Profile update the attribute
ComponentState	String	True	For internal use only.
EntityName	Integer	False	Entity name.
FieldPermissionId	String	False	Unique identifier of the Field Permission.
FieldPermissionIdUnique	String	True	For internal use only.
FieldSecurityProfileId_Id	String	False	Unique identifier of profile to which this privilege belongs.
FieldSecurityProfileId_LogicalName	String	False
FieldSecurityProfileId_Name	String	False
IsManaged	Boolean	True	Indicates whether the solution component is part of a managed solution.
OrganizationId_Id	String	True	Unique identifier for the organization
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverwriteTime	Datetime	True	For internal use only.
SolutionId	String	True	Unique identifier of the associated solution.

FieldSecurityProfile

This is a table representing the FieldSecurityProfile entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the profile.
ComponentState	String	True	For internal use only.
CreatedBy_Id	String	True	Unique identifier of the user who created the profile.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the profile was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the role.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the Profile
FieldSecurityProfileId	String	False	Unique identifier of the profile.
FieldSecurityProfileIdUnique	String	True	For internal use only.
IsManaged	Boolean	True	Indicates whether the solution component is part of a managed solution.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the profile.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the profile was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the profile.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the profile.
OrganizationId_Id	String	True	Unique identifier of the associated organization.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverwriteTime	Datetime	True	For internal use only.
SolutionId	String	True	Unique identifier of the associated solution.

FilterTemplate

This is a table representing the FilterTemplate entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the filter template.
Description	String	False	For internal use only.
FetchXml	String	False	String that specifies the filter template in Fetch XML language.
FilterTemplateId	String	False	Unique identifier of the filter template.
Name	String	False	Name of the filter template.
QueryType	Integer	False	For internal use only.
ReturnedTypeCode	Integer	False	For internal use only.

FixedMonthlyFiscalCalendar

This is a table representing the FixedMonthlyFiscalCalendar entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the fixed monthly fiscal calendar.
BusinessUnitId_Id	String	True	Business unit responsible for the quota associated with this calendar.
BusinessUnitId_LogicalName	String	True
BusinessUnitId_Name	String	True
CreatedBy_Id	String	True	Unique identifier of the user who created the fiscal calendar.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the quota for the fixed monthly fiscal calendar was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the FixedMonthlyFiscalCalendar.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
EffectiveOn	Datetime	False	Date and time when the fixed monthly fiscal calendar sales quota takes effect.
ExchangeRate	Double	True	Exchange rate for the currency associated with the fixed monthly fiscal calendar with respect to the base currency.
FiscalPeriodType	Integer	True	Type of fiscal period used in the fixed monthly fiscal calendar sales quota.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the fixed monthly fiscal calendar.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the fixed monthly fiscal calendar was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the FixedMonthlyFiscalCalendar.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Period1	Double	False	Sales quota for the first period in the fiscal year.
Period1_Base	Double	True	Base currency equivalent of the sales quota for the first period in the fiscal year.
Period10	Double	False	Sales quota for the tenth period in the fiscal year.
Period10_Base	Double	True	Base currency equivalent of the sales quota for the tenth period in the fiscal year.
Period11	Double	False	Sales quota for the eleventh period in the fiscal year.
Period11_Base	Double	True	Base currency equivalent of the sales quota for the eleventh period in the fiscal year.
Period12	Double	False	Sales quota for the twelfth period in the fiscal year.
Period12_Base	Double	True	Base currency equivalent of the sales quota for the twelfth period in the fiscal year.
Period13	Double	False	Sales quota for the thirteenth period in the fiscal year.
Period13_Base	Double	True	Base currency equivalent of the sales quota for the thirteenth period in the fiscal year.
Period2	Double	False	Sales quota for the second period in the fiscal year.
Period2_Base	Double	True	Base currency equivalent of the sales quota for the second period in the fiscal year.
Period3	Double	False	Sales quota for the third period in the fiscal year.
Period3_Base	Double	True	Base currency equivalent of the sales quota for the third period in the fiscal year.
Period4	Double	False	Sales quota for the fourth period in the fiscal year.
Period4_Base	Double	True	Base currency equivalent of the sales quota for the fourth period in the fiscal year.
Period5	Double	False	Sales quota for the fifth period in the fiscal year.
Period5_Base	Double	True	Base currency equivalent of the sales quota for the fifth period in the fiscal year.
Period6	Double	False	Sales quota for the sixth period in the fiscal year.
Period6_Base	Double	True	Base currency equivalent of the sales quota for the sixth period in the fiscal year.
Period7	Double	False	Sales quota for the seventh period in the fiscal year.
Period7_Base	Double	True	Base currency equivalent of the sales quota for the seventh period in the fiscal year.
Period8	Double	False	Sales quota for the eighth period in the fiscal year.
Period8_Base	Double	True	Base currency equivalent of the sales quota for the eighth period in the fiscal year.
Period9	Double	False	Sales quota for the ninth period in the fiscal year.
Period9_Base	Double	True	Base currency equivalent of the sales quota for the ninth period in the fiscal year.
SalesPersonId_Id	String	False	Unique identifier of the associated salesperson.
SalesPersonId_LogicalName	String	False
SalesPersonId_Name	String	False
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the fixed monthly fiscal calendar.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UserFiscalCalendarId	String	False	Unique identifier of the user of the fiscal calendar.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

Goal

This is a table representing the Goal entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the goal.
ActualDecimal	Double	False	Actual value (decimal type) against the target.
ActualInteger	Integer	False	Actual value (integer type) against the target.
ActualMoney	Double	False	Actual value (money type) against the target.
ActualMoney_Base	Double	True	Actual value (money type) in base currency against the target.
ActualString	String	True	Actual Value of the goal.
AmountDataType	String	False	Data type of the amount.
ComputedTargetAsOfTodayDecimal	Double	True	A system-generated expected amount for Actual (decimal) against the target goal.
ComputedTargetAsOfTodayInteger	Integer	True	A system-generated expected amount for Actual (integer) against the target goal.
ComputedTargetAsOfTodayMoney	Double	True	A system-generated expected amount for Actual (money) against the target goal.
ComputedTargetAsOfTodayMoney_Base	Double	True	A system-generated expected amount in base currency for Actual (money) against the target goal.
ComputedTargetAsOfTodayPercentageAchieved	Double	True	A system-generated expected value for percentage achieved against the target goal.
ConsiderOnlyGoalOwnersRecords	Boolean	False	Indicates whether only the goal owner's records, or all records, will be rolled up.
CreatedBy_Id	String	True	Unique identifier of the user who created the record.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the record was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the record.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomRollupFieldDecimal	Double	False	Placeholder rollup field for value (decimal) against the target.
CustomRollupFieldInteger	Integer	False	Placeholder rollup field for value (integer) against the target.
CustomRollupFieldMoney	Double	False	Placeholder rollup field for value (money) against the target.
CustomRollupFieldMoney_Base	Double	True	Placeholder rollup field for value (money) in base currency against the target.
CustomRollupFieldString	String	True	Placeholder rollup field for the goal.
Depth	Integer	True	Depth of the goal in the tree.
ExchangeRate	Double	True	Exchange rate between the currency associated with the entity and the base currency.
FiscalPeriod	String	False	Fiscal period for the goal.
FiscalYear	String	False	Fiscal year for the goal.
GoalEndDate	Datetime	False	End date for the goal period.
GoalId	String	False	Unique identifier of the goal.
GoalOwnerId_Id	String	False	Unique identifier of the user or team who needs to meet the goal.
GoalOwnerId_LogicalName	String	False
GoalOwnerId_Name	String	False
GoalStartDate	Datetime	False	Start date for the goal period.
GoalWithErrorId_Id	String	False	Unique identifier of the goal that caused an error in the rollup of the goal hierarchy.
GoalWithErrorId_LogicalName	String	False
GoalWithErrorId_Name	String	False
ImportSequenceNumber	Integer	False	Sequence number of the import that created this record.
InProgressDecimal	Double	False	In-progress value (decimal) against the target.
InProgressInteger	Integer	False	In-progress value (integer) against the target.
InProgressMoney	Double	False	In-progress value (money) against the target.
InProgressMoney_Base	Double	True	In-progress value (money) in base currency against the goal.
InProgressString	String	True	In-progress value of the goal.
IsAmount	Boolean	False	Indicates whether the metric type is Count or Amount.
IsFiscalPeriodGoal	Boolean	False	Indicates whether the goal period is a fiscal period or a custom period.
IsOverridden	Boolean	False	Indicates whether the system rollup fields are updated. If set to Yes, system rollup will not update the values of the rollup fields.
IsOverride	Boolean	False	Indicates whether the values of system rollup fields can be updated.
LastRolledupDate	Datetime	False	Date and time when the data for this goal was last rolled up.
MetricId_Id	String	False	Unique identifier of the metric associated with the goal.
MetricId_LogicalName	String	False
MetricId_Name	String	False
ModifiedBy_Id	String	True	Unique identifier of the user who modified the record.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the record was modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who modified the record.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the manager of the goal.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier for the business unit that owns the record.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the goal.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier for the user who owns the record.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ParentGoalId_Id	String	False	Unique identifier of the parent goal to which the goal is connected.
ParentGoalId_LogicalName	String	False
ParentGoalId_Name	String	False
Percentage	Double	False	Percentage achieved against the target goal.
RollupErrorCode	Integer	False	Error code associated with rollup.
RollupOnlyFromChildGoals	Boolean	False	Indicates whether the data should be rolled up only from the child goals.
RollUpQueryActualDecimalId_Id	String	False	Unique identifier of the rollup query for the actual (decimal) rollup field.
RollUpQueryActualDecimalId_LogicalName	String	False
RollUpQueryActualDecimalId_Name	String	False
RollupQueryActualIntegerId_Id	String	False	Unique identifier of the rollup query for the actual (integer) rollup field.
RollupQueryActualIntegerId_LogicalName	String	False
RollupQueryActualIntegerId_Name	String	False
RollUpQueryActualMoneyId_Id	String	False	Unique identifier of the rollup query for the actual (money) rollup field.
RollUpQueryActualMoneyId_LogicalName	String	False
RollUpQueryActualMoneyId_Name	String	False
RollUpQueryCustomDecimalId_Id	String	False	Unique identifier of the rollup query for the custom rollup field (decimal).
RollUpQueryCustomDecimalId_LogicalName	String	False
RollUpQueryCustomDecimalId_Name	String	False
RollUpQueryCustomIntegerId_Id	String	False	Unique identifier of the rollup query for the custom rollup field (integer).
RollUpQueryCustomIntegerId_LogicalName	String	False
RollUpQueryCustomIntegerId_Name	String	False
RollUpQueryCustomMoneyId_Id	String	False	Unique identifier of the rollup query for the custom rollup field (money).
RollUpQueryCustomMoneyId_LogicalName	String	False
RollUpQueryCustomMoneyId_Name	String	False
RollUpQueryInprogressDecimalId_Id	String	False	Unique identifier of the rollup query for the in-progress (decimal) rollup field.
RollUpQueryInprogressDecimalId_LogicalName	String	False
RollUpQueryInprogressDecimalId_Name	String	False
RollUpQueryInprogressIntegerId_Id	String	False	Unique identifier of the rollup query for the in-progress (integer) rollup field.
RollUpQueryInprogressIntegerId_LogicalName	String	False
RollUpQueryInprogressIntegerId_Name	String	False
RollUpQueryInprogressMoneyId_Id	String	False	Unique identifier of the rollup query for the in-progress (money) rollup field.
RollUpQueryInprogressMoneyId_LogicalName	String	False
RollUpQueryInprogressMoneyId_Name	String	False
StateCode	String	True	Status of the goal.
StatusCode	String	False	Reason for the status of the goal.
StretchTargetDecimal	Double	False	Stretch target (decimal) of the goal.
StretchTargetInteger	Integer	False	Stretch target (integer) of the goal.
StretchTargetMoney	Double	False	Stretch target (money) of the goal.
StretchTargetMoney_Base	Double	True	Value of the stretch target (money) in base currency.
StretchTargetString	String	True	Stretch target value for all data types.
TargetDecimal	Double	False	Goal target of the decimal type.
TargetInteger	Integer	False	Goal target of the integer type.
TargetMoney	Double	False	Goal target of the money type.
TargetMoney_Base	Double	True	Goal target of the money type in base currency.
TargetString	String	True	Target value of the goal.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
Title	String	False	Title of the goal.
TransactionCurrencyId_Id	String	True	Unique identifier of the currency associated with the entity.
TransactionCurrencyId_LogicalName	String	True
TransactionCurrencyId_Name	String	True
TreeId	String	True	Unique identifier of the goal tree.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

GoalRollupQuery

This is a table representing the GoalRollupQuery entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the goal rollup query.
CreatedBy_Id	String	True	Unique identifier of the user who created the record.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the record was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the record.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
FetchXml	String	False	String that specifies the condition criteria in FetchXML.
GoalRollupQueryId	String	False	Unique identifier of the rollup query.
ImportSequenceNumber	Integer	False	Sequence number of the import that created this record.
ModifiedBy_Id	String	True	Unique identifier of the user who modified the record.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the record was modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who modified the record.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the rollup query.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the goal rollup query.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the record.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the record.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the record.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
QueryEntityType	String	False	Entity type of the rollup query.
StateCode	String	True	Status of the goal rollup query.
StatusCode	String	False	Reason for the status of the goal rollup query.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

Import

This is a table representing the Import entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the import job.
CreatedBy_Id	String	True	Unique identifier of the user who created the import job.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the import job was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the import.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
EMailAddress	String	False	email address to send notification to.
ImportId	String	False	Unique identifier of the import job.
IsImport	Boolean	False	Information about whether the source of this import job is data import or data migration.
ModeCode	String	False	Information about whether to create or update records.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the import job.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the import job was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the import.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the import job.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the import job.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Business unit that owns the import job.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the import.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the import.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
SendNotification	Boolean	False	Information about whether to send notification.
Sequence	Integer	True	Order in which the import was created.
StateCode	String	True	Status of the import job.
StatusCode	String	False	Reason for the status of the import job.

ImportData

This is a table representing the ImportData entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the import data.
CreatedBy_Id	String	True	Unique identifier of the user who created the import data.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the import data was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the import data.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Data	String	False	Data row of the import file.
ErrorType	String	False	Type of the import error.
HasError	Boolean	False	Information about whether this import data has an error.
ImportDataId	String	False	Unique identifier of the import data.
ImportFileId_Id	String	False	Unique identifier of the import file for this import data.
ImportFileId_LogicalName	String	False
ImportFileId_Name	String	False
LineNumber	Integer	False	Original line number of the data present in the file.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the import data.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the import data was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the import data.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OwnerId_Id	String	False	Unique identifier of the user or team who owns the import data.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Business unit that owns the import data.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the import data.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the import data.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
RecordId	String	False	Unique identifier of the record.
StateCode	String	True	Status of the import data.
StatusCode	String	False	Reason for the status of the import data.

ImportEntityMapping

This is a table representing the ImportEntityMapping entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the import entity mapping.
CreatedBy_Id	String	True	Unique identifier of the user who created the import entity mapping.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the import entity mapping was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the importentitymapping.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DeDupe	String	False	Information about whether the entity needs to be processed to find and delete duplicate records.
ImportEntityMappingId	String	False	Unique identifier of the import entity mapping.
ImportMapId_Id	String	False	Unique identifier of the associated data map.
ImportMapId_LogicalName	String	False
ImportMapId_Name	String	False
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the import entity mapping.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the import entity mapping was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the importentitymapping.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
ProcessCode	String	False	Information about whether the import entity mapping needs to be processed.
SourceEntityName	String	False	Name of the source entity.
StateCode	String	True	Status of the import entity mapping.
StatusCode	String	False	Reason for the status of the import entity mapping.
TargetEntityName	String	False	Name of the Microsoft Dynamics CRM entity.

ImportFile

This is a table representing the ImportFile entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the import file.
AdditionalHeaderRow	String	True	System generated heading row used for processing transformations.
CompletedOn	Datetime	True	Date and time when the import was completed for this import file.
Content	String	False	Content of the import file.
CreatedBy_Id	String	True	Unique identifier of the user who created the import file record.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the import file was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the import file.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
DataDelimiterCode	String	False	Single character data delimiter used in the import file.
EnableDuplicateDetection	Boolean	False	Information about whether duplicate detection is enabled.
FailureCount	Integer	True	Number of records in this file that could not be imported.
FieldDelimiterCode	String	False	Single character field delimiter used in the import file.
FileTypeCode	String	False	File type of the uploaded source file
HeaderRow	String	True	Header row of the import file.
ImportFileId	String	False	Unique identifier of the import file.
ImportId_Id	String	False	Unique identifier of the import job for this import file.
ImportId_LogicalName	String	False
ImportId_Name	String	False
ImportMapId_Id	String	False	Unique identifier of the associated data map.
ImportMapId_LogicalName	String	False
ImportMapId_Name	String	False
IsFirstRowHeader	Boolean	False	Information about whether the first row contains column headings.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the import file.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the import file was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the importfile.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the import file.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the import file.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Business unit that owns the import file.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the import file.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the import file.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ParsedTableColumnPrefix	String	True	Prefix of the column in the parsed table.
ParsedTableColumnsNumber	Integer	True	Total number of columns present in the parsed table.
ParsedTableName	String	True	Name of the table that contains the parsed data of the import file.
PartialFailureCount	Integer	True	Number of records in this file that had failures in updating.
ProcessCode	String	False	Information about whether the import file needs to be processed.
ProcessingStatus	String	True	Detailed status showing how much the import file has been processed.
ProgressCounter	Integer	True	Indicates how much of a particular operation has been completed. Used when resuming a paused import job.
RecordsOwnerId_Id	String	False	Unique identifier of the owner to whom records imported from this file are assigned.
RecordsOwnerId_LogicalName	String	False
RecordsOwnerId_Name	String	False
RelatedEntityColumns	String	False	Related Entity Columns
Size	String	False	Size of the import file.
Source	String	False	Source of the import file.
SourceEntityName	String	False	Name of the source entity.
StateCode	String	True	Status of the import file.
StatusCode	String	False	Reason for the status of the import file.
SuccessCount	Integer	True	Number of records in this file that were imported successfully.
TargetEntityName	String	False	Name of the Microsoft Dynamics CRM entity.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TotalCount	Integer	True	Number of records processed in this file.
UseSystemMap	Boolean	False	Information about whether to use the system map.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

ImportJob

This is a table representing the ImportJob entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the import job.
CompletedOn	Datetime	True	Date and time when the import job was completed.
CreatedBy_Id	String	True	Unique identifier of the user who created the importJob.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the import job record was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the import job record.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Data	String	False	Unstructured data associated with the import job.
ImportJobId	String	False	Unique identifier of the import job.
ModifiedBy_Id	String	True	Unique identifier of the user who modified the importJob.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the import job was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who modified the import job record.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the import job.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the importjob.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
Progress	Double	False	Import Progress Percentage.
SolutionName	String	False	Unique identifier of the solution.
StartedOn	Datetime	True	Date and time when the import job was started.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

ImportLog

This is a table representing the ImportLog entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the import log.
AdditionalInfo	String	False	Additional information related to the error.
ColumnValue	String	False	Value in the column.
CreatedBy_Id	String	True	Unique identifier of the user who created the import log.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the import log was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the import log.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
ErrorDescription	String	False	Description of an error.
ErrorNumber	Integer	False	Error code of an error.
HeaderColumn	String	False	Name of the column heading.
ImportDataId_Id	String	False	Unique identifier of the import data for this import log.
ImportDataId_LogicalName	String	False
ImportDataId_Name	String	False
ImportFileId_Id	String	False	Unique identifier of the import file for this import log.
ImportFileId_LogicalName	String	False
ImportFileId_Name	String	False
ImportLogId	String	False	Unique identifier of the import log.
LineNumber	Integer	False	Original line number of the data used in this log.
LogPhaseCode	String	False	Phase for which the log is recorded.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the import log.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the import log was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the importlog.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OwnerId_Id	String	False	Unique identifier of the user or team who owns the import log.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Business unit that owns the import log.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the import log.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the import log.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
SequenceNumber	Integer	True	Sequence number of the error in this log.
StateCode	String	True	Status of the import log.
StatusCode	String	False	Reason for the status of the import log.

ImportMap

This is a table representing the ImportMap entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the data map.
CreatedBy_Id	String	True	Unique identifier of the user who created the data map.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the data map was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the data map.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the data map.
EntitiesPerFile	String	False	Denotes if a data file can have data for one or more entity
ImportMapId	String	False	Unique identifier of the data map.
ImportMapType	String	False	Type of data map.
IsValidForImport	Boolean	True	Information about whether the data map is valid for use with data import.
IsWizardCreated	Boolean	False	Information about whether this data map was created by the Data Migration Manager.
MapCustomizations	String	False	Customizations XML
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the data map.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the data map was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the data map.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the data map.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the data map.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Business unit that owns the data map.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the data map.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the data map.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
Source	String	False	Name of the migration source for which this data map is used.
SourceType	String	False	Type of the migration source for which this data map is used.
SourceUserIdentifierForSourceCRMUserLink	String	False	Source user value for source Microsoft Dynamics CRM user link.
SourceUserIdentifierForSourceDataSourceUserLink	String	False	Column in the source file that uniquely identifies a user.
StateCode	String	True	Status of the data map.
StatusCode	String	False	Reason for the status of the data map.
TargetEntity	String	True	Name of the Microsoft Dynamics CRM record type for which this data map is defined.
TargetUserIdentifierForSourceCRMUserLink	String	False	Microsoft Dynamics CRM user.

Incident

This is a table representing the Incident entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the case.
AccountId_Id	String	True	Unique identifier of the account with which the case is associated.
AccountId_LogicalName	String	True
AccountId_Name	String	True
ActualServiceUnits	Integer	False	Actual number of service units provided for the case.
BilledServiceUnits	Integer	False	Number of service units billed for the case.
CaseOriginCode	String	False	Information that specifies the source of the case information, such as Web, telephone, or email.
CaseTypeCode	String	False	Information that specifies the type of case.
ContactId_Id	String	True	Unique identifier of the contact associated with the case.
ContactId_LogicalName	String	True
ContactId_Name	String	True
ContractDetailId_Id	String	False	Unique identifier of the specific contract line item that is referenced in the case.
ContractDetailId_LogicalName	String	False
ContractDetailId_Name	String	False
ContractId_Id	String	False	Unique identifier of the contract referenced in the case.
ContractId_LogicalName	String	False
ContractId_Name	String	False
ContractServiceLevelCode	String	False	Response level for the case. The response level corresponds to the level of service specified in the contract.
CreatedBy_Id	String	True	Unique identifier of the user who created the case.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the case was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the incident.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier of the account or contact associated with the case.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
CustomerSatisfactionCode	String	False	Customer's level of satisfaction with the resolution of the case.
Description	String	False	Description of the case.
ExchangeRate	Double	True	Exchange rate for the currency associated with the incident with respect to the base currency.
FollowupBy	Datetime	False	Date by which the customer support representative needs to follow up the case.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IncidentId	String	False	Unique identifier of the case.
IncidentStageCode	String	False	Stage of the resolution process for the case.
IsDecrementing	Boolean	False	Information that specifies whether the case is decrementing.
KbArticleId_Id	String	False	Unique identifier of the knowledge base article associated with the case.
KbArticleId_LogicalName	String	False
KbArticleId_Name	String	False
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the case.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the case was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the incident.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the case.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the case.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the case.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the case.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PriorityCode	String	False	Priority of the case.
ProductId_Id	String	False	Unique identifier of the product associated with the case.
ProductId_LogicalName	String	False
ProductId_Name	String	False
ProductSerialNumber	String	False	Serial number of the product that is referenced in the case.
ResponsibleContactId_Id	String	False	Unique identifier of the contact responsible for resolving the case.
ResponsibleContactId_LogicalName	String	False
ResponsibleContactId_Name	String	False
SeverityCode	String	False	Severity of the case.
StateCode	String	True	Status of the case.
StatusCode	String	False	Reason for the status of the case.
SubjectId_Id	String	False	Unique identifier of the subject associated with the case.
SubjectId_LogicalName	String	False
SubjectId_Name	String	False
TicketNumber	String	False	Auto-generated case number.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
Title	String	False	Title of the case.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the incident.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

IncidentResolution

This is a table representing the IncidentResolution entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the case resolution activity.
ActivityId	String	False	Unique identifier of the case resolution activity.
ActivityTypeCode	String	True	Type of activity.
ActualDurationMinutes	Integer	False	Actual duration of the case resolution activity in minutes.
ActualEnd	Datetime	False	Actual end time of the case resolution activity.
ActualStart	Datetime	False	Actual start time of the case resolution activity.
Category	String	False	Category for the case resolution activity.
CreatedBy_Id	String	True	Unique identifier of the user who created the case resolution activity.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the case resolution activity was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the incidentresolution.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Special type of activity that includes such information as the description of the resolution, billing status, and the duration of a case.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IncidentId_Id	String	False	Unique identifier of the case.
IncidentId_LogicalName	String	False
IncidentId_Name	String	False
IsBilled	Boolean	False	Information about whether the case resolution activity was billed as part of resolving a case.
IsRegularActivity	Boolean	True	Information regarding whether the activity is a regular activity type or event type.
IsWorkflowCreated	Boolean	False	Information that specifies if the case resolution activity was created from a workflow rule.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the case resolution activity.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the case resolution activity was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the incidentresolution.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the case resolution activity.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the case resolution activity.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the case resolution.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the case resolution.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
ScheduledDurationMinutes	Integer	True	Scheduled duration of the case resolution activity, specified in minutes.
ScheduledEnd	Datetime	False	Scheduled end time of the case resolution activity.
ScheduledStart	Datetime	False	Scheduled start time of the case resolution activity.
ServiceId_Id	String	False	Unique identifier of the service with which the case resolution activity is associated.
ServiceId_LogicalName	String	False
ServiceId_Name	String	False
StateCode	String	True	Status of the case resolution activity.
StatusCode	String	False	Reason for the status of the case resolution activity.
Subcategory	String	False	Subcategory of the case resolution activity.
Subject	String	False	Subject associated with the case resolution activity.
TimeSpent	Integer	False	Time spent on the case resolution activity.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.

IntegrationStatus

This is a table representing the IntegrationStatus entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the integration status.
CreatedBy_Id	String	True	Unique identifier of the user who created the integration status.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the integration status was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the integrationstatus.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
IntegrationEntryId	String	False	For internal use only.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the integration status.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the integration status was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the integrationstatus.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
ObjectId	String	True	For internal use only.
ObjectTypeCode	String	True	Type of entity with which the integration status is associated.
OrganizationId	String	True	Unique identifier of the organization associated with the integration status.
StateCode	String	False	Status of the integration.
StateDescription	String	False	For internal use only.
StatusCode	String	False	Reason for the status of the integration.
StatusDescription	String	False	For internal use only.
SystemName	String	True	For internal use only.

InternalAddress

This is a table representing the InternalAddress entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the internal address.
AddressNumber	Integer	False	Information about which internal address is applicable.
AddressTypeCode	String	False	Type of address for the internal address.
City	String	False	City name in the internal address.
Country	String	False	Country/region name in the internal address.
County	String	False	County name in the internal address.
CreatedBy_Id	String	True	Unique identifier of the user who created the internal address record.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the internal address was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the internal address.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Fax	String	False	Fax number for the internal address.
InternalAddressId	String	False	Unique identifier of the internal address.
Latitude	Double	False	Latitude for the internal address.
Line1	String	False	First line for entering address information.
Line2	String	False	Second line for entering address information.
Line3	String	False	Third line for entering address information.
Longitude	Double	False	Longitude for the internal address.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the internal address.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the internal address record was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the internaladdress.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name used to identify the internal address.
ObjectTypeCode	String	False	Type of entity with which the internal address is associated.
ParentId	String	False	Unique identifier of the parent object with which the internal address is associated.
PostalCode	String	False	ZIP Code or postal code in the internal address.
PostOfficeBox	String	False	Post office box number in the internal address.
ShippingMethodCode	String	False	Method of shipment for the internal address.
StateOrProvince	String	False	State or province in the internal address.
Telephone1	String	False	First telephone number for the internal address.
Telephone2	String	False	Second telephone number for an internal address.
Telephone3	String	False	Third telephone number for an internal address.
UPSZone	String	False	United Parcel Service (UPS) zone for the internal address.
UTCOffset	Integer	False	UTC offset for the internal address. The difference between local time and standard Coordinated Universal Time.

InterProcessLock

This is a table representing the InterProcessLock entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the interprocess lock record.
InterProcessLockId	String	False	Unique identifier of the interprocess lock record.
ModifiedOn	Datetime	False	Date and time when the record was last modified.
Token	String	False	Lock token.

InvalidDependency

This is a table representing the InvalidDependency entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the invalid dependency.
ExistingComponentId	String	True	Unique identifier of the object that has an invalid dependency
ExistingComponentType	String	True	Component type of the object that has an invalid dependency
ExistingDependencyType	String	True	The dependency type of the invalid dependency.
InvalidDependencyId	String	True	Unique identifier of the invalid dependency.
IsExistingNodeRequiredComponent	Boolean	True	Indicates whether the existing node is the required component in the dependency
MissingComponentId	String	False	Unique identifier of the missing component.
MissingComponentInfo	String	True
MissingComponentLookupType	Integer	True	The lookup type of the missing component.
MissingComponentType	String	True	The object type code of the missing component.

Invoice

This is a table representing the Invoice entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the invoice.
AccountId_Id	String	True	Unique identifier of the account with which the invoice is associated.
AccountId_LogicalName	String	True
AccountId_Name	String	True
BillTo_City	String	False	City name in the billing address.
BillTo_Country	String	False	Country/region name in the billing address.
BillTo_Fax	String	False	Fax number for the billing address.
BillTo_Line1	String	False	First line for entering billing address information.
BillTo_Line2	String	False	Second line for entering billing address information.
BillTo_Line3	String	False	Third line for entering billing address information.
BillTo_Name	String	False	Name to enter for the billing address.
BillTo_PostalCode	String	False	ZIP Code or postal code in the billing address.
BillTo_StateOrProvince	String	False	State or province in the billing address.
BillTo_Telephone	String	False	Telephone number associated with the billing address.
ContactId_Id	String	True	Unique identifier of the contact associated with the invoice.
ContactId_LogicalName	String	True
ContactId_Name	String	True
CreatedBy_Id	String	True	Unique identifier of the user who created the invoice.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the invoice was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the invoice.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier of the account or contact associated with the invoice.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
DateDelivered	Datetime	False	Date all products in the invoice were delivered.
Description	String	False	Description of the invoice.
DiscountAmount	Double	False	Discount specified as a monetary amount for the invoice.
DiscountAmount_Base	Double	True	Base currency equivalent of the discount specified as a monetary amount for the invoice.
DiscountPercentage	Double	False	Discount specified as a percentage for the invoice.
DueDate	Datetime	False	Date by which the invoice needs to be paid.
ExchangeRate	Double	True	Exchange rate for the currency associated with the invoice with respect to the base currency.
FreightAmount	Double	False	Cost of freight for the invoice.
FreightAmount_Base	Double	True	Base currency equivalent of the cost of freight for the invoice.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
InvoiceId	String	False	Unique identifier of the invoice.
InvoiceNumber	String	False	Invoice number.
IsPriceLocked	Boolean	True	Information about whether invoice pricing is locked.
LastBackofficeSubmit	Datetime	False	Date and time when the invoice was last submitted to Microsoft Great Plains.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the invoice.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the invoice was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the invoice.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Name	String	False	Name of the invoice.
OpportunityId_Id	String	False	Unique identifier of the opportunity with which the invoice is associated.
OpportunityId_LogicalName	String	False
OpportunityId_Name	String	False
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	False	Unique identifier of the user or team who owns the invoice.
OwnerId_LogicalName	String	False
OwnerId_Name	String	False
OwningBusinessUnit_Id	String	True	Unique identifier of the business unit that owns the invoice.
OwningBusinessUnit_LogicalName	String	True
OwningBusinessUnit_Name	String	True
OwningTeam_Id	String	True	Unique identifier of the team who owns the invoice.
OwningTeam_LogicalName	String	True
OwningTeam_Name	String	True
OwningUser_Id	String	True	Unique identifier of the user who owns the invoice.
OwningUser_LogicalName	String	True
OwningUser_Name	String	True
PaymentTermsCode	String	False	Payment terms for the invoice.
PriceLevelId_Id	String	False	Unique identifier of the price list associated with the invoice.
PriceLevelId_LogicalName	String	False
PriceLevelId_Name	String	False
PricingErrorCode	String	False	Type of pricing error for the invoice.
PriorityCode	String	False	Priority of the invoice.
SalesOrderId_Id	String	False	Unique identifier of the order that is associated with the invoice.
SalesOrderId_LogicalName	String	False
SalesOrderId_Name	String	False
ShippingMethodCode	String	False	Method of shipment for the invoice.
ShipTo_City	String	False	City name in the shipping address.
ShipTo_Country	String	False	Country/region name in the shipping address.
ShipTo_Fax	String	False	Fax number for the shipping address.
ShipTo_FreightTermsCode	String	False	Freight terms for the shipping address.
ShipTo_Line1	String	False	First line for entering shipping address information.
ShipTo_Line2	String	False	Second line for entering shipping address information.
ShipTo_Line3	String	False	Third line for entering shipping address information.
ShipTo_Name	String	False	Name to enter for the shipping address.
ShipTo_PostalCode	String	False	ZIP Code or postal code in the shipping address.
ShipTo_StateOrProvince	String	False	State or province in the shipping address.
ShipTo_Telephone	String	False	Telephone number associated with the shipping address.
StateCode	String	True	Status of the invoice.
StatusCode	String	False	Reason for the status of the invoice.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TotalAmount	Double	True	Total price for the invoice.
TotalAmount_Base	Double	True	Base currency equivalent of the total price for the invoice.
TotalAmountLessFreight	Double	True	Total price minus the freight charges for the invoice.
TotalAmountLessFreight_Base	Double	True	Base currency equivalent of the total price minus the freight charges for the invoice.
TotalDiscountAmount	Double	True	Total discount for the invoice.
TotalDiscountAmount_Base	Double	True	Base currency equivalent of the total discount for the invoice.
TotalLineItemAmount	Double	True	Total line item amount for the invoice.
TotalLineItemAmount_Base	Double	True	Base currency equivalent of the total line item amount for the invoice
TotalLineItemDiscountAmount	Double	True	Total line item discount for the invoice.
TotalLineItemDiscountAmount_Base	Double	True	Base currency equivalent of the total line item discount for the invoice.
TotalTax	Double	True	Total tax for the invoice.
TotalTax_Base	Double	True	Base currency equivalent of the total tax for the invoice.
TransactionCurrencyId_Id	String	False	Unique identifier of the currency associated with the invoice.
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
WillCall	Boolean	False	Information about whether the customer will call for the invoiced products or the products are to be shipped.

InvoiceDetail

This is a table representing the InvoiceDetail entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the invoice product line item.
ActualDeliveryOn	Datetime	False	Date on which the product on the invoice is delivered.
BaseAmount	Double	True	Subtotal for the invoice product before discounts are applied and taxes are added.
BaseAmount_Base	Double	True	Base currency equivalent of the subtotal for the invoice product before discounts are applied and taxes are added.
CreatedBy_Id	String	True	Unique identifier of the user who created the invoice product line item.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the invoice product line item was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the invoice detail.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the invoice product line item.
ExchangeRate	Double	True	Exchange rate for the currency associated with the invoice detail with respect to the base currency.
ExtendedAmount	Double	True	Subtotal of the invoice product after discounts are applied and taxes are added.
ExtendedAmount_Base	Double	True	Base currency equivalent of the subtotal of the invoice product after discounts are applied and taxes are added.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
InvoiceDetailId	String	False	Unique identifier of the invoice product line item.
InvoiceId_Id	String	False	Unique identifier of the invoice associated with the invoice product line item.
InvoiceId_LogicalName	String	False
InvoiceId_Name	String	False
InvoiceIsPriceLocked	Boolean	True	Information about whether invoice product pricing is locked.
InvoiceStateCode	String	True	Status of the invoice product.
IsCopied	Boolean	False	Information about whether the invoice line item is copied.
IsPriceOverridden	Boolean	False	Information about whether to override product catalog pricing.
IsProductOverridden	Boolean	False	Information about whether the product is a write-in product or an existing product.
LineItemNumber	Integer	False	Line item number of the invoice product.
ManualDiscountAmount	Double	False	Customized discount amount for the invoice product line item.
ManualDiscountAmount_Base	Double	True	Base currency equivalent of the customized discount amount for the invoice product line item.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the invoice product line item.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the invoice product line item was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the invoicedetail.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the invoice detail.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the invoice product line item.
OwningUser	String	True	Unique identifier of the user who owns the invoice product line item.
PricePerUnit	Double	False	Price per unit for the invoice product line item.
PricePerUnit_Base	Double	True	Base currency equivalent of the price per unit for the invoice product line item.
PricingErrorCode	String	False	Pricing error for the invoice product line item.
ProductDescription	String	False	Product description for the invoice product line item.
ProductId_Id	String	False	Product identifier for the invoice product line item.
ProductId_LogicalName	String	False
ProductId_Name	String	False
Quantity	Double	False	Product quantity specified for the invoice product line item.
QuantityBackordered	Double	False	Product quantity that has been backordered for the invoice product line item.
QuantityCancelled	Double	False	Product quantity that was canceled for the invoice product line item.
QuantityShipped	Double	False	Product quantity shipped for the product line item specified on the invoice.
SalesRepId_Id	String	False	Unique identifier of the sales person associated with the invoice product line item.
SalesRepId_LogicalName	String	False
SalesRepId_Name	String	False
ShippingTrackingNumber	String	False	Tracking number for shipping the invoiced product line item.
ShipTo_City	String	False	City name in the shipping address.
ShipTo_Country	String	False	Country/region name in the shipping address.
ShipTo_Fax	String	False	Fax number for the shipping address.
ShipTo_FreightTermsCode	String	False	Freight terms for the shipping address.
ShipTo_Line1	String	False	First line for entering shipping address information.
ShipTo_Line2	String	False	Second line for entering shipping address information.
ShipTo_Line3	String	False	Third line for entering shipping address information.
ShipTo_Name	String	False	Name to enter for the shipping address.
ShipTo_PostalCode	String	False	ZIP Code or postal code in the shipping address.
ShipTo_StateOrProvince	String	False	State or province in the shipping address.
ShipTo_Telephone	String	False	Telephone number associated with the shipping address.
Tax	Double	False	Tax amount for the invoice product line item.
Tax_Base	Double	True	Base currency equivalent of the tax amount for the invoice product line item.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	True	Unique identifier of the currency associated with the invoice detail.
TransactionCurrencyId_LogicalName	String	True
TransactionCurrencyId_Name	String	True
UoMId_Id	String	False	Unique identifier for unit that is associated with the invoice product line item.
UoMId_LogicalName	String	False
UoMId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
VolumeDiscountAmount	Double	True	Volume discount amount for the invoice product line item.
VolumeDiscountAmount_Base	Double	True	Base currency equivalent of the volume discount amount for the invoice product line item.
WillCall	Boolean	False	Information about whether the customer will call for the invoiced products or the products are to be shipped.

IsvConfig

This is a table representing the IsvConfig entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the ISV configuration.
ConfigXML	String	False	Structured XML data representing the customizations.
CreatedBy_Id	String	True	Unique identifier of the user who created the ISV configuration.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the ISV configuration was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the isvconfig.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
IsvConfigId	String	False	Unique identifier of the ISV configuration.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the ISV configuration.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the ISV configuration was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the ISV configuration.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId	String	True	Unique identifier of the organization associated with the ISV configuration XML.

KbArticle

This is a table representing the KbArticle entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the knowledge base article.
ArticleXml	String	False	XML data for the knowledge base article.
Comments	String	False	Comments regarding the knowledge base article.
Content	String	True	Description of the content of the knowledge base article.
CreatedBy_Id	String	True	Unique identifier of the user who created the knowledge base article.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the knowledge base article was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the article.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the knowledge base article.
ExchangeRate	Double	True
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
KbArticleId	String	False	Unique identifier of the knowledge base article.
KbArticleTemplateId_Id	String	False	Unique identifier of the template associated with the knowledge base article.
KbArticleTemplateId_LogicalName	String	False
KbArticleTemplateId_Name	String	False
KeyWords	String	False	Keywords to be used for searches in knowledge base articles.
LanguageCode	Integer	False	Language of the Article Template
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the knowledge base article.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the knowledge base article was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the kbarticle.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
Number	String	True	Knowledge base article number.
OrganizationId_Id	String	True	Unique identifier of the organization associated with the article.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
StateCode	String	True	Status of the knowledge base article.
StatusCode	String	False	Reason for the status of the knowledge base article.
SubjectId_Id	String	False	Unique identifier of the subject associated with the knowledge base article.
SubjectId_LogicalName	String	False
SubjectId_Name	String	False
Title	String	False	Title of the knowledge base article.
TransactionCurrencyId_Id	String	False
TransactionCurrencyId_LogicalName	String	False
TransactionCurrencyId_Name	String	False

KbArticleComment

This is a table representing the KbArticleComment entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the knowledge base article.
CommentText	String	False	Comment text for the knowledge base article.
CreatedBy_Id	String	True	Unique identifier of the user who created the knowledge base article comment.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the knowledge base article comment was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the KB article comment.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
KbArticleCommentId	String	False	Unique identifier of the knowledge base article comment.
KbArticleId_Id	String	False	Unique identifier of the knowledge base article to which the comment applies.
KbArticleId_LogicalName	String	False
KbArticleId_Name	String	False
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the knowledge base article comment.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the knowledge base article comment was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the kbarticlecomment.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId	String	True	Unique identifier of the organization with which the article comment is associated.
Title	String	False	Title of the knowledge base article comment.

KbArticleTemplate

This is a table representing the KbArticleTemplate entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the knowledge base article template.
ComponentState	String	True	For internal use only.
CreatedBy_Id	String	True	Unique identifier of the user who created the knowledge base article template.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the knowledge base article template was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the kbarticletemplate.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the knowledge base article template.
FormatXml	String	False	XML format of the knowledge base article template.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsActive	Boolean	False	Information about whether the knowledge base article is active.
IsManaged	Boolean	True
KbArticleTemplateId	String	False	Unique identifier of the knowledge base article template.
KbArticleTemplateIdUnique	String	True	For internal use only.
LanguageCode	Integer	False	Language of the Article Template
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the knowledge base article template.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the knowledge base article template was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the kbarticletemplate.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OrganizationId_Id	String	True	Unique identifier of the organization associated with the template.
OrganizationId_LogicalName	String	True
OrganizationId_Name	String	True
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OverwriteTime	Datetime	True	For internal use only.
SolutionId	String	True	Unique identifier of the associated solution.
StructureXml	String	False	XML structure of the knowledge base article.
Title	String	False	Title of the knowledge base article template.

Lead

This is a table representing the Lead entities in Dynamics CRM.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the lead.
AccountId_Id	String	True	Unique identifier of the account with which the lead is associated.
AccountId_LogicalName	String	True
AccountId_Name	String	True
Address1_AddressId	String	False	Unique identifier for address 1.
Address1_AddressTypeCode	String	False	Type of address for address 1, such as billing, shipping, or primary address.
Address1_City	String	False	City name for address 1.
Address1_Country	String	False	Country/region name for address 1.
Address1_County	String	False	County name for address 1.
Address1_Fax	String	False	Fax number for address 1.
Address1_Latitude	Double	False	Latitude for address 1.
Address1_Line1	String	False	First line for entering address 1 information.
Address1_Line2	String	False	Second line for entering address 1 information.
Address1_Line3	String	False	Third line for entering address 1 information.
Address1_Longitude	Double	False	Longitude for address 1.
Address1_Name	String	False	Name to enter for address 1.
Address1_PostalCode	String	False	ZIP Code or postal code for address 1.
Address1_PostOfficeBox	String	False	Post office box number for address 1.
Address1_ShippingMethodCode	String	False	Method of shipment for address 1.
Address1_StateOrProvince	String	False	State or province for address 1.
Address1_Telephone1	String	False	First telephone number associated with address 1.
Address1_Telephone2	String	False	Second telephone number associated with address 1.
Address1_Telephone3	String	False	Third telephone number associated with address 1.
Address1_UPSZone	String	False	United Parcel Service (UPS) zone for address 1.
Address1_UTCOffset	Integer	False	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
Address2_AddressId	String	False	Unique identifier for address 2.
Address2_AddressTypeCode	String	False	Type of address for address 2, such as billing, shipping, or primary address.
Address2_City	String	False	City name for address 2.
Address2_Country	String	False	Country/region name for address 2.
Address2_County	String	False	County name for address 2.
Address2_Fax	String	False	Fax number for address 2.
Address2_Latitude	Double	False	Latitude for address 2.
Address2_Line1	String	False	First line for entering address 2 information.
Address2_Line2	String	False	Second line for entering address 2 information.
Address2_Line3	String	False	Third line for entering address 2 information.
Address2_Longitude	Double	False	Longitude for address 2.
Address2_Name	String	False	Name to enter for address 2.
Address2_PostalCode	String	False	ZIP Code or postal code for address 2.
Address2_PostOfficeBox	String	False	Post office box number for address 2.
Address2_ShippingMethodCode	String	False	Method of shipment for address 2.
Address2_StateOrProvince	String	False	State or province for address 2.
Address2_Telephone1	String	False	First telephone number associated with address 2.
Address2_Telephone2	String	False	Second telephone number associated with address 2.
Address2_Telephone3	String	False	Third telephone number associated with address 2.
Address2_UPSZone	String	False	United Parcel Service (UPS) zone for address 2.
Address2_UTCOffset	Integer	False	UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
CampaignId_Id	String	False	Unique identifier of the source campaign associated with the lead.
CampaignId_LogicalName	String	False
CampaignId_Name	String	False
CompanyName	String	False	Name of the company with which the lead is associated.
ContactId_Id	String	True	Unique identifier of the contact with which the lead is associated.
ContactId_LogicalName	String	True
ContactId_Name	String	True
CreatedBy_Id	String	True	Unique identifier of the user who created the lead.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the lead was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the lead.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
CustomerId_Id	String	False	Unique identifier for the account or contact associated with the lead.
CustomerId_LogicalName	String	False
CustomerId_Name	String	False
Description	String	False	Description of the lead.
DoNotBulkEMail	Boolean	False	Information about whether to allow sending direct email to the lead.
DoNotEMail	Boolean	False	Information about whether to allow sending email to the lead.
DoNotFax	Boolean	False	Information about whether to allow sending fax transmittals to the lead.
DoNotPhone	Boolean	False	Information about whether to allow phone calls to the lead.
DoNotPostalMail	Boolean	False	Information about whether to allow sending postal mail to the lead.
DoNotSendMM	Boolean	False	Information regarding whether to allow sending marketing mail to the lead.
EMailAddress1	String	False	First email address for the lead.
EMailAddress2	String	False	Second email address for the lead.
EMailAddress3	String	False	Third email address for the lead.
EstimatedAmount	Double	False	Estimated value of the opportunity that was generated from the lead.
EstimatedAmount_Base	Double	True	Base currency equivalent of the estimated value of the opportunity that was generated from the lead.
EstimatedCloseDate	Datetime	False	Estimated date on which the opportunity that was generated from the lead is expected to close.
EstimatedValue	Double	False	Estimated value of the opportunity that was generated from the lead.
ExchangeRate	Double	True	Exchange rate for the currency associated with the lead with respect to the base currency.
Fax	String	False	Fax number for the lead.
FirstName	String	False	First name for the lead.
FullName	String	True	Full name for the lead.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IndustryCode	String	False	Type of industry with which the company or organization of the lead is associated.
JobTitle	String	False	Job title of the lead.
LastName	String	False	Last name for the lead.
LastUsedInCampaign	Datetime	False	Date and time when the lead was last contacted as a part of a marketing campaign.
LeadId	String	False	Unique identifier of the lead.
LeadQualityCode	String	False	Quality of the lead, such as hot, warm, or cold.
LeadSourceCode	String	False	Source of the lead.
MasterId_Id	String	True	Unique identifier of the master lead for merge.
MasterId_LogicalName	String	True
MasterId_Name	String	True
Merged

Microsoft Dynamics CRM Connector for CData Sync

Microsoft Dynamics CRM Connector for CData Sync

Overview

Microsoft Dynamics CRM Version Support

Establishing a Connection

Adding a Connection to Microsoft Dynamics CRM

Connecting to Microsoft Dynamics CRM

Authenticating to Microsoft Dynamics CRM

CRM On-Premises

Internet-Facing Deployments

Azure AD

Headless Machines

Client Credentials

Azure Service Principal

Create an Azure AD App and an Azure Service Principal

Kerberos

Creating a Custom Azure SP App

Steps to Create an AzureAD SP App

Using Kerberos

Kerberos

Retrieve Kerberos Tickets

Enabling Cross-Realm Authentication

Fine-Tuning Data Access

Fine Tuning Data Access

Advanced Features

User Defined Views

SSL Configuration

Firewall and Proxy

Query Processing

Logging

SSL Configuration

Customizing the SSL Configuration

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

Other Proxies

Data Model

Tables

Stored Procedures

Tables

Microsoft Dynamics CRM Connector for CData Sync Tables

Account

Columns

ActivityMimeAttachment

Columns

ActivityParty

Columns

ActivityPointer

Columns

Annotation

Columns

AnnualFiscalCalendar

Columns

ApplicationFile

Columns

Appointment

Columns

AsyncOperation

Columns

Attachment

Columns

AttributeMap

Columns

Audit

Columns

BulkDeleteFailure

Columns

BulkDeleteOperation

Columns

BulkOperation

Columns

BulkOperationLog

Columns

BusinessUnit

Columns

BusinessUnitMap

Columns

BusinessUnitNewsArticle

Columns

Calendar