`

Matillion ETL Data Model for DynamicsCRM
Version - 19.0.7156

Note: Data models are true for the latest version of Matillion ETL. If you are on an older version or using a component from an old job, your experience may differ.




Connection String OptionsBack To Top

  1. Auth Scheme
  2. Auto Cache
  3. Batch Size
  4. Cache Connection
  5. Cache Driver
  6. Cache Location
  7. Cache Metadata
  8. Cache Tolerance
  9. Caller Id
  10. Connection Life Time
  11. Connect On Open
  12. CRM Version
  13. Default Precision
  14. Device Credential Location
  15. Device Credential Password
  16. Device Name
  17. Device Password
  18. Firewall Password
  19. Firewall Port
  20. Firewall Server
  21. Firewall Type
  22. Firewall User
  23. Include Calculated Columns
  24. Internet Facing Deployment
  25. Location
  26. Logfile
  27. Max Log File Size
  28. Max Rows
  29. Offline
  30. Organization Name
  31. Other
  32. Pagesize
  33. Password
  34. Pool Idle Timeout
  35. Pool Max Size
  36. Pool Min Size
  37. Pool Wait Time
  38. Proxy Auth Scheme
  39. Proxy Auto Detect
  40. Proxy Exceptions
  41. Proxy Password
  42. Proxy Port
  43. Proxy Server
  44. Proxy SSL Type
  45. Proxy User
  46. Pseudo Columns
  47. Query Method
  48. Query Passthrough
  49. Readonly
  50. RTK
  51. Saved Query Filter
  52. SSL Cert
  53. SSL Server Cert
  54. STSURL
  55. Support Enhanced SQL
  56. Tables
  57. Timeout
  58. URL
  59. Use Connection Pooling
  60. Use Display Names
  61. Use Name For Picklist Value
  62. User
  63. Use Simple Names
  64. Verbosity
  65. Views



Auth Scheme

The authentication scheme used. Accepted entries are NTLM, BASIC, DIGEST, NONE, and KERBEROSDELEGATION.
Data Type

string

Default Value

"NTLM"

Remarks

Together with Password and User, this field is used to authenticate against an on-premises Dynamics CRM 4.0 server. This property will not be used for other versions of CRM. NTLM is the default option. Use the following options to select your authentication scheme:





Auto Cache

Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider .
Data Type

bool

Default Value

false

Remarks

When AutoCache = true, the driver automatically maintains a cache of your table's data in the database of your choice. By default, the driver incrementally updates the cache, retrieving only changes since the last SELECT query was run if the length of time since the last run has exceeded the CacheTolerance. After the cache is updated, the query is executed against the cached data.

Setting the Caching Database

When AutoCache = true, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

See Also





Batch Size

The maximum size of each batch operation to submit.
Data Type

int

Default Value

0

Remarks

When BatchSize is set to a value greater than 0, the batch operation will split the entire batch into separate batches of size BatchSize. The split batches will then be submitted to the server individually. This is useful when the server has limitations on the size of the request that can be submitted.

Setting BatchSize to 0 will submit the entire batch as specified.





Cache Connection

The connection string for the cache database. This property is always used in conjunction with CacheProvider . Setting both properties will override the value set for CacheLocation for caching data.
Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. Both properties are required to use the cache database. Examples of common cache database settings can be found below. For more information on setting the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. Consult the documentation for the specific JDBC driver for more information on the available properties. Make sure to include the JDBC driver in your application's classpath.

Derby and Java DB

The driver simplifies caching to Derby, only requiring you to set the CacheLocation property to make a basic connection.

Alternatively, you can configure the connection to Derby manually using CacheProvider and CacheConnection. The following is the Derby JDBC URL syntax:

jdbc:derby:[subsubprotocol:][databaseName][;attribute=value[;attribute=value] ... ]
For example, to cache to an in-memory database, use the following:
jdbc:derby:memory

SQLite

To cache to SQLite, you can use the SQLite JDBC driver. The following is the syntax of the JDBC URL:

jdbc:sqlite:dataSource

MySQL

The installation includes the CData JDBC Driver for MySQL. The following is an example JDBC URL:

jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache
The following are typical connection properties:

SQL Server

The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:

jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]
For example:
jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true
The following are typical SQL Server connection properties:
Oracle

The following is the conventional JDBC URL syntax for the Oracle JDBC Thin driver:

jdbc:oracle:thin:[userId/password]@[//]host[[:port][:sid]]
For example:
jdbc:oracle:thin:scott/tiger@myhost:1521:orcl
The following are typical connection properties:
PostgreSQL

The following is the JDBC URL syntax for the official PostgreSQL JDBC driver:

jdbc:postgresql:[//[host[:port]]/]database[[?option=value][[&option=value][&option=value] ... ]]
For example, the following connection string connects to a database on the default host (localhost) and port (5432):
jdbc:postgresql:postgres
The following are typical connection properties:





Cache Driver

The database driver to be used to cache data.
Data Type

string

Default Value

""

Remarks

You can cache to any database for which you have a JDBC driver, including CData JDBC drivers.

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you want to use to cache data.

Note that you must also add the CacheDriver JAR file to the classpath.

The following examples show how to cache to several major databases. Refer to CacheConnection for more information on the JDBC URL syntax and typical connection properties.

Derby and Java DB

The driver simplifies Derby configuration. Java DB is the Oracle distribution of Derby. The JAR file is shipped in the JDK. You can find the JAR file, derby.jar, in the db subfolder of the JDK installation. In most caching scenarios, you need to specify only the following, after adding derby.jar to the classpath:

jdbc:dynamicscrm:CacheLocation='c:/Temp/cachedir';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;
To customize the Derby JDBC URL, use CacheDriver and CacheConnection. For example, to cache to an in-memory database, use a JDBC URL like the following:
jdbc:dynamicscrm:CacheDriver=org.apache.derby.jdbc.EmbeddedDriver;CacheConnection='jdbc:derby:memory';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;
SQLite

The following is a JDBC URL for the SQLite JDBC driver:

jdbc:dynamicscrm:CacheDriver=org.sqlite.JDBC;CacheConnection='jdbc:sqlite:C:/Temp/sqlite.db';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;
MySQL

The following is a JDBC URL for the included CData JDBC Driver for MySQL:

  jdbc:dynamicscrm:Cache Driver=cdata.jdbc.mysql.MySQLDriver;Cache Connection='jdbc:mysql:Server=localhost;Port=3306;Database=cache;User=root;Password=123456';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;

  
The CData JDBC Driver for MySQL is located in the lib subfolder of the CData JDBC Driver for Dynamics CRM 2019 installation directory.
SQL Server

The following JDBC URL uses the Microsoft JDBC Driver for SQL Server:

jdbc:dynamicscrm:Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost\sqlexpress:7437;user=sa;password=123456;databaseName=Cache';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;
Oracle

The following is a JDBC URL for the Oracle Thin Client:

jdbc:dynamicscrm:Cache Driver=oracle.jdbc.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;
NOTE: If using a version of Oracle older than 9i, the cache driver will instead be oracle.jdbc.driver.OracleDriver .
PostgreSQL

The following JDBC URL uses the official PostgreSQL JDBC driver:

jdbc:dynamicscrm:CacheDriver=org.postgresql.Driver;CacheConnection='jdbc:postgresql://localhost:5433/postgres?user=postgres&password=admin';User=myuseraccount;Password=mypassword;URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;





Cache Location

Specifies the path to the cache when caching to a file.
Data Type

string

Default Value

"%APPDATA%\\CData\\DynamicsCRM Data Provider"

Remarks

The CacheLocation is a simple, file-based cache. The driver uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR file to the classpath. The JAR file, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.

If left unspecified, the default location is "%APPDATA%\\CData\\DynamicsCRM Data Provider" with %APPDATA% being set to the user's configuration directory:

Platform %APPDATA%
Windows The value of the APPDATA environment variable
Mac ~/Library/Application Support
Linux ~/.config

See Also





Cache Metadata

This property determines whether or not to cache the table metadata to a file store.
Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, table metadata in the Dynamics CRM catalog are cached to the file store specified by CacheLocation if set or the user's home directory otherwise. A table's metadata will be retrieved only once, when the table is queried for the first time.

When to Use CacheMetadata

The driver automatically persists metadata in memory for up to two hours when you first discover the metadata for a table or view and therefore, CacheMetadata is generally not required. CacheMetadata becomes useful when metadata operations are expensive such as when you are working with large amounts of metadata or when you have many short-lived connections.

When Not to Use CacheMetadata





Cache Tolerance

The tolerance for stale data in the cache specified in seconds when using AutoCache .
Data Type

string

Default Value

"600"

Remarks

The tolerance for stale data in the cache specified in seconds. This only applies when AutoCache is used. The driver checks with the data source for newer records after the tolerance interval has expired. Otherwise, it returns the data directly from the cache.





Caller Id

The Id of a user to impersonate when inserting or updating new records.
Data Type

string

Default Value

""

Remarks

The Id of a user to impersonate when inserting or updating new records. All records modified with this set appear as if they were edited by the impersonated user.





Connection Life Time

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
Data Type

string

Default Value

"0"

Remarks

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. The default is 0 which indicates there is no limit to the connection lifetime.





Connect On Open

This property species whether to connect to the Dynamics CRM when the connection is opened.
Data Type

bool

Default Value

false

Remarks

When set to true, a connection will be made to Dynamics CRM when the connection is opened. This property enables the Test Connection feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to Dynamics CRM and nothing from this initial connection is maintained.

Setting this property to false may provide performance improvements (depending upon the number of times a connection is opened).





CRM Version

The type of Dynamics CRM server to which you are connecting. Accepted entries are CRM2011+, CRMOnline.
Data Type

string

Default Value

"CRM2011+"

Remarks

The type of Dynamics CRM server to which you are connecting. Accepted entries are CRM2011+ or CRMOnline. A value of CRMOnline is required to connect using the Office 365 STS.

Set InternetFacingDeployment to connect to an IFD instance of CRM.





Default Precision

The currency precision that is used for pricing throughout the system. Valid values are 0-4 and Auto. If the value is Auto, the default value will be retrieved from the Dynamics CRM server.
Data Type

string

Default Value

"2"

Remarks

The decimal precision that is used for currencies throughout the system. Valid values are 0-4 and Auto. If the value is Auto, the default value will be retrieved from the Dynamics CRM server.





Device Credential Location

The path to a file where device credentials are stored. If the file does not exist or is empty a new set of credentials will be generated and stored in that file.
Data Type

string

Default Value

""

Remarks

Dynamics CRM uses claims-based authentication when authenticating using a Windows Live Id. This requires device credentials, which consist of a DeviceName and a DevicePassword. The device credentials need to be generated only once and can be reused. It is customary for each application to have its own set of device credentials.

The credentials in the DeviceCredentialLocation may be protected using the DeviceCredentialPassword. If the DeviceCredentialPassword is specified, then it will be used to encrypt and decrypt the device credentials. If it is not specified, then the credentials are stored in plaintext.

If the DeviceCredentialLocation is not specified and neither are DeviceName and DevicePassword, then the driver will generate the credentials for onetime use. This can be inefficient for repeated use.





Device Credential Password

The password used to encrypt or decrypt the credentials stored in the credentials file.
Data Type

string

Default Value

""

Remarks

Dynamics CRM uses claims-based authentication when authenticating using a Windows Live Id. This requires device credentials, which consist of a DeviceName and a DevicePassword. The device credentials need to be generated only once and can be reused. It is customary for each application to have its own set of device credentials.

The credentials in the DeviceCredentialLocation may be protected using the DeviceCredentialPassword. If the DeviceCredentialPassword is specified, then it will be used to encrypt and decrypt the device credentials. If it is not specified, then the credentials are stored in plaintext.





Device Name

The device name used to authenticate along with a Windows Live Id.
Data Type

string

Default Value

""

Remarks

Dynamics CRM uses claims-based authentication when authenticating using a Windows Live Id. This requires device credentials, which consist of a DeviceName and a DevicePassword. The device credentials need to be generated only once and can be reused. It is customary for each application to have its own set of device credentials.

You may specify device credentials using the DeviceName and DevicePassword properties or using DeviceCredentialLocation. If DeviceName and DevicePassword are specified, the contents of the DeviceCredentialLocation are ignored.





Device Password

The device password used to authenticate along with a Windows Live Id.
Data Type

string

Default Value

""

Remarks

Dynamics CRM uses claims-based authentication when authenticating using a Windows Live Id. This requires device credentials, which consist of a DeviceName and a DevicePassword. The device credentials need to be generated only once and can be reused. It is customary for each application to have its own set of device credentials.

You may specify device credentials using the DeviceName and DevicePassword properties or using DeviceCredentialLocation. If DeviceName and DevicePassword are specified, the contents of the DeviceCredentialLocation are ignored.





Firewall Password

A password used to authenticate to a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.





Firewall Port

The TCP port for a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.





Firewall Server

The name or IP address of a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the driver uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.





Firewall Type

The protocol used by a proxy-based firewall.
Data Type

string

Default Value

"NONE"

Remarks

This property specifies the protocol that the driver will use to tunnel traffic through the FirewallServer proxy. Note that by default, the driver connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.

Type Default Port Description
TUNNEL 80 When this is set, the driver opens a connection to Dynamics CRM and traffic flows back and forth through the proxy.
SOCKS4 1080 When this is set, the driver sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5 1080 When this is set, the driver sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.





Firewall User

The user name to use to authenticate with a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.





Include Calculated Columns

This option controls whether the driver returns the Calculated Columns defined on a table. Only applicable for CRM 2015+.
Data Type

bool

Default Value

true

Remarks

This option controls whether the driver returns the Calculated Columns defined on a table. Only applicable for CRM 2015+.





Internet Facing Deployment

Whether you are connecting to an Internet Facing Deployment (IFD) for CRM.
Data Type

bool

Default Value

false

Remarks

Set this to true if you are connecting to an Internet Facing Deployment (IFD) for CRM.





Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.
Data Type

string

Default Value

"%APPDATA%\\CData\\DynamicsCRM Data Provider\\Schema"

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\\CData\\DynamicsCRM Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:

Platform %APPDATA%
Windows The value of the APPDATA environment variable
Mac ~/Library/Application Support
Linux ~/.config





Logfile

A path to the log file.
Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, you can adjust its Verbosity.





Max Log File Size

A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.
Data Type

string

Default Value

"100MB"

Remarks

A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. The default limit is 100 MB. Values lower than 100 kB will use 100 kB as the value instead.





Max Rows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Data Type

string

Default Value

"-1"

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.





Offline

Use offline mode to get the data from the cache instead of the live source.
Data Type

bool

Default Value

false

Remarks

When Offline = true, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.





Organization Name

The name of the organization. In Dynamics CRM 4.0 without IFD, the organization is specified in the URL; for example, http://website/organizationname. In Dynamics CRM 4.0 with IFD, this property must be set. In other versions of CRM, this property is optional.
Data Type

string

Default Value

""

Remarks

The following table is a description for setting this property in each Dynamics CRM version.

Dynamics CRM 4.0 without IFDOptional. If this property is not set, the organization name can be retrieved from the URL.
CRM 4.0 with IFDRequired. This property must be set.
Dynamics CRM 2011 on-premisesOptional. If this property is not set, the organization name can be retrieved from the URL.
Dynamics CRM 2011 with IFDOptional.
Dynamics CRM 2011 without IFDOptional.





Other

These hidden properties are used only in specific use cases.
Data Type

string

Default Value

""

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Caching Configuration

CachePartial=TrueCaches only a subset of columns, which you can specify in your query.
QueryPassthrough=TruePasses the specified query to the cache database instead of using the SQL parser of the driver.

Integration and Formatting

DefaultColumnSizeSets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMTDetermines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.





Pagesize

The number of rows to return per page from the data source.
Data Type

string

Default Value

"500"

Remarks

The number of rows to return per page from the data source.





Password

The password used to authenticate to the Dynamics CRM site.
Data Type

string

Default Value

""

Remarks

The password used to authenticate to the Dynamics CRM site.





Pool Idle Timeout

The allowed idle time for a connection before it is closed.
Data Type

string

Default Value

""

Remarks

The allowed idle time a connection can remain in the pool until the connection is closed. The default is 60 seconds.





Pool Max Size

The maximum connections in the pool.
Data Type

string

Default Value

"100"

Remarks

The maximum connections in the pool. The default is 100. To disable this property, set the property value to 0 or less.





Pool Min Size

The minimum number of connections in the pool.
Data Type

string

Default Value

"1"

Remarks

The minimum number of connections in the pool. The default is 1.





Pool Wait Time

The max seconds to wait for an available connection.
Data Type

string

Default Value

""

Remarks

The max seconds to wait for a connection to become available. If a new connection request is waiting for an available connection and exceeds this time, an error is thrown. By default, new requests wait forever for an available connection.





Proxy Auth Scheme

The authentication type to use to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

"BASIC"

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.





Proxy Auto Detect

This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
Data Type

bool

Default Value

false

Remarks

This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

NOTE: When this property is set to True, the proxy used is determined as follows:

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.





Proxy Exceptions

A semicolon separated list of hosts or IPs that are exempt from connecting through the ProxyServer .
Data Type

string

Default Value

""

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the driver uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.





Proxy Password

A password to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the driver uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.





Proxy Port

The TCP port the ProxyServer proxy is running on.
Data Type

string

Default Value

"80"

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.





Proxy Server

The hostname or IP address of a proxy to route HTTP traffic through.
Data Type

string

Default Value

""

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the driver uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.





Proxy SSL Type

The SSL type to use when connecting to the ProxyServer proxy.
Data Type

string

Default Value

"AUTO"

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:

AUTODefault setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYSThe connection is always SSL enabled.
NEVERThe connection is not SSL enabled.
TUNNELThe connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.





Proxy User

A user name to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:

user@domain

domain\user





Pseudo Columns

This property indicates whether or not to include pseudo columns as columns to the table.
Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".





Query Method

The method to use when querying data from Dynamics CRM. In most cases FetchXML will work with all tables.
Data Type

string

Default Value

"FetchXML"

Remarks

The method to use when querying data from Dynamics CRM. In most cases FetchXML will work with all tables. However, QueryExpression may be specified as an alternative.





Query Passthrough

This option passes the Fetch XML query to Dynamics CRM as-is.
Data Type

bool

Default Value

false

Remarks

Set this option to write your own Fetch XML queries instead of SQL statements.





Readonly

You can use this property to enforce read-only access to Dynamics CRM from the provider.
Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.





RTK

The runtime key used for licensing.
Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. See the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.





Saved Query Filter

A comma-separated list of filters to use for displaying Saved Queries as views (ex: Accounts%,Contacts%).
Data Type

string

Default Value

""

Remarks

A comma-separated list of filters to use for displaying Saved Queries as views. The names can be found by querying the SavedQuery table with a percent sign representing a wildcard (ex: Accounts%,Contacts%). An empty value (the default) will not return any of these as views. A value of just % will return all Saved Queries for the instance.





SSL Cert

The certificate used for client authentication.
Data Type

string

Default Value

""

Remarks

If using an SSL connection, this property can be used to specify the SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected. This can take the form of a full PEM certificate, the path to a file containing the certificate, the public key, the MD5 thumbprint, or the SHA1 thumbprint. If not specified, any valid certificate will be accepted. Use '*' to signify to accept all certificates.

SSLCert is used for specifying a private key certificate for HTTP client authentication.





SSL Server Cert

The certificate to be accepted from the server when connecting using TLS/SSL.
Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:

Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Certificates are validated as trusted by the machine based on the System's trust store. The trust store used is the 'javax.net.ssl.trustStore' value specified for the system. If no value is specified for this property, Java's default trust store is used (for example, JAVA_HOME\lib\security\cacerts).

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.





STSURL

The URL of the security token service (STS). This value is detected automatically.
Data Type

string

Default Value

""

Remarks

The driver will automatically select the correct STSURL. However, if you need to conserve network resources, you can define this value in STSURL to avoid retrieving the URL on every connection. To retrieve this value, call the GetSTSUrl stored procedure.





Support Enhanced SQL

This property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
Data Type

bool

Default Value

true

Remarks

When SupportEnhancedSQL = true, the driver offloads as much of the SELECT statement processing as possible to Dynamics CRM and then processes the rest of the query in memory. In this way, the driver can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL = false, the driver limits SQL execution to what is supported by the Dynamics CRM API.

Execution of Predicates

The driver determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the driver to filter effectively for even very large datasets.

Execution of Joins

The driver uses various techniques to join in memory. The driver trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The driver retrieves all rows necessary to process the aggregation in memory.





Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. For example, Tables=TableA,TableB,TableC.





Timeout

The value in seconds until the timeout error is thrown, canceling the operation.
Data Type

string

Default Value

"60"

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.





URL

The root URL of the organization. For example, a CRM 4.0 or CRM 2011 URL will resemble http://MySite/MyOrganization. For CRM Online, the URL will resemble https://myOrg.crm.dynamics.com/.
Data Type

string

Default Value

""

Remarks

The root URL of the organization. For example, a CRM 4.0 or CRM 2011 URL will resemble http://MySite/MyOrganization. For CRM Online, the URL will resemble https://myOrg.crm.dynamics.com/.





Use Connection Pooling

This property enables connection pooling.
Data Type

bool

Default Value

false

Remarks

This property enables connection pooling. The default is false. See Connection Pooling for information on using connection pools.





Use Display Names

Boolean determining if the display names for the columns should be used instead of the API names.
Data Type

bool

Default Value

false

Remarks

Boolean determining if the display names for the columns should be used instead of the API names.





Use Name For Picklist Value

Boolean determining if the string value should be used for picklist field values instead of integers.
Data Type

bool

Default Value

true

Remarks

Boolean determining if the string value should be used for picklist field values instead of integers.





User

The user who is authenticating to the Dynamics CRM site.
Data Type

string

Default Value

""

Remarks

The user who is authenticating to the Dynamics CRM site.





Use Simple Names

Boolean determining if simple names should be used for tables and columns.
Data Type

bool

Default Value

false

Remarks

If true, tables and columns returned will be renamed to make them easier to read and to specify in a query. Requirements for using [] or '' are removed. If false, the tables and columns will appear as they do in Dynamics CRM.





Verbosity

The verbosity level that determines the amount of detail included in the log file.
Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described in the following list:

1Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and additional information about the request, if applicable, such as HTTP headers.
3Setting Verbosity to 3 will additionally log the body of the request and the response.
4Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.





Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.
Data Type

string

Default Value

""

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. For example, Views=ViewA,ViewB,ViewC.





TablesBack To Top

  1. Account
  2. ActivityMimeAttachment
  3. ActivityParty
  4. ActivityPointer
  5. Annotation
  6. AnnualFiscalCalendar
  7. ApplicationFile
  8. Appointment
  9. AsyncOperation
  10. Attachment
  11. AttributeMap
  12. Audit
  13. BulkDeleteFailure
  14. BulkDeleteOperation
  15. BulkOperation
  16. BulkOperationLog
  17. BusinessUnit
  18. BusinessUnitMap
  19. BusinessUnitNewsArticle
  20. Calendar
  21. CalendarRule
  22. Campaign
  23. CampaignActivity
  24. CampaignActivityItem
  25. CampaignItem
  26. CampaignResponse
  27. ClientUpdate
  28. ColumnMapping
  29. Commitment
  30. Competitor
  31. CompetitorAddress
  32. CompetitorProduct
  33. CompetitorSalesLiterature
  34. Connection
  35. ConnectionRole
  36. ConnectionRoleAssociation
  37. ConnectionRoleObjectTypeCode
  38. ConstraintBasedGroup
  39. Contact
  40. ContactInvoices
  41. ContactLeads
  42. ContactOrders
  43. ContactQuotes
  44. Contract
  45. ContractDetail
  46. ContractTemplate
  47. CustomerAddress
  48. CustomerOpportunityRole
  49. CustomerRelationship
  50. Dependency
  51. DependencyNode
  52. Discount
  53. DiscountType
  54. DisplayString
  55. DisplayStringMap
  56. DocumentIndex
  57. DuplicateRecord
  58. DuplicateRule
  59. DuplicateRuleCondition
  60. Email
  61. EmailHash
  62. EmailSearch
  63. EntityMap
  64. Equipment
  65. Fax
  66. FieldPermission
  67. FieldSecurityProfile
  68. FilterTemplate
  69. FixedMonthlyFiscalCalendar
  70. Goal
  71. GoalRollupQuery
  72. Import
  73. ImportData
  74. ImportEntityMapping
  75. ImportFile
  76. ImportJob
  77. ImportLog
  78. ImportMap
  79. Incident
  80. IncidentResolution
  81. IntegrationStatus
  82. InternalAddress
  83. InterProcessLock
  84. InvalidDependency
  85. Invoice
  86. InvoiceDetail
  87. IsvConfig
  88. KbArticle
  89. KbArticleComment
  90. KbArticleTemplate
  91. Lead
  92. LeadAddress
  93. LeadCompetitors
  94. LeadProduct
  95. Letter
  96. License
  97. List
  98. ListMember
  99. LookUpMapping
  100. MailMergeTemplate
  101. Metric
  102. MonthlyFiscalCalendar
  103. Notification
  104. Opportunity
  105. OpportunityClose
  106. OpportunityCompetitors
  107. OpportunityProduct
  108. OptionSetInfo
  109. OrderClose
  110. Organization
  111. OrganizationStatistic
  112. OrganizationUI
  113. Owner
  114. OwnerMapping
  115. PhoneCall
  116. PickListMapping
  117. PluginAssembly
  118. plug-intype
  119. PluginTypeStatistic
  120. PriceLevel
  121. PrincipalAttributeAccessMap
  122. PrincipalEntityMap
  123. PrincipalObjectAccess
  124. PrincipalObjectAttributeAccess
  125. Privilege
  126. PrivilegeObjectTypeCodes
  127. ProcessSession
  128. Product
  129. ProductAssociation
  130. ProductPriceLevel
  131. ProductSalesLiterature
  132. ProductSubstitute
  133. Publisher
  134. PublisherAddress
  135. QuarterlyFiscalCalendar
  136. Queue
  137. QueueItem
  138. Quote
  139. QuoteClose
  140. QuoteDetail
  141. RecurrenceRule
  142. RecurringAppointmentMaster
  143. RelationshipRole
  144. RelationshipRoleMap
  145. Report
  146. ReportCategory
  147. ReportEntity
  148. ReportLink
  149. ReportVisibility
  150. Resource
  151. ResourceGroup
  152. ResourceGroupExpansion
  153. ResourceSpec
  154. RibbonCommand
  155. RibbonContextGroup
  156. RibbonCustomization
  157. RibbonDiff
  158. RibbonRule
  159. RibbonTabToCommandMap
  160. Role
  161. RolePrivileges
  162. RoleTemplate
  163. RoleTemplatePrivileges
  164. RollupField
  165. SalesLiterature
  166. SalesLiteratureItem
  167. SalesOrder
  168. SalesOrderDetail
  169. SalesProcessInstance
  170. SavedQuery
  171. SavedQueryVisualization
  172. SdkMessage
  173. SdkMessageFilter
  174. SdkMessagePair
  175. SdkMessageProcessingStep
  176. SdkMessageProcessingStepImage
  177. SdkMessageProcessingStepSecureConfig
  178. SdkMessageRequest
  179. SdkMessageRequestField
  180. SdkMessageResponse
  181. SdkMessageResponseField
  182. SemiAnnualFiscalCalendar
  183. Service
  184. ServiceAppointment
  185. ServiceContractContacts
  186. ServiceEndpoint
  187. SharePointDocumentLocation
  188. SharePointSite
  189. Site
  190. SiteMap
  191. Solution
  192. SolutionComponent
  193. StatusMap
  194. StringMap
  195. Subject
  196. Subscription
  197. SubscriptionClients
  198. SubscriptionManuallyTrackedObject
  199. SubscriptionSyncInfo
  200. SubscriptionTrackingDeletedObject
  201. SystemForm
  202. SystemUser
  203. SystemUserBusinessUnitEntityMap
  204. SystemUserLicenses
  205. SystemUserPrincipals
  206. SystemUserProfiles
  207. SystemUserRoles
  208. Task
  209. Team
  210. TeamMembership
  211. TeamProfiles
  212. TeamRoles
  213. Template
  214. Territory
  215. TimeZoneDefinition
  216. TimeZoneLocalizedName
  217. TimeZoneRule
  218. TransactionCurrency
  219. TransformationMapping
  220. TransformationParameterMapping
  221. UnresolvedAddress
  222. UoM
  223. UoMSchedule
  224. UserEntityInstanceData
  225. UserEntityUISettings
  226. UserFiscalCalendar
  227. UserForm
  228. UserQuery
  229. UserQueryVisualization
  230. UserSettings
  231. WebResource
  232. WebWizard
  233. WizardAccessPrivilege
  234. WizardPage
  235. Workflow
  236. WorkflowDependency
  237. WorkflowLog
  238. WorkflowWaitSubscription



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.





CalendarRule

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the calendar rule.

BusinessUnitId String True

Unique identifier of the business unit with which the calendar rule is associated.

CalendarId_Id String False

Unique identifier of the calendar with which the calendar rule is associated.

CalendarId_LogicalName String False

CalendarId_Name String False

CalendarRuleId String False

Unique identifier of the calendar rule.

CreatedBy_Id String True

Unique identifier of the user who created the calendar rule.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the calendar rule was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the calendarrule.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Defines free/busy times for a service and for resources or resource groups, such as working, non-working, vacation, and blocked.

Duration Integer False

Duration of the calendar rule in minutes.

EffectiveIntervalEnd Datetime False

Effective interval end of the calendar rule.

EffectiveIntervalStart Datetime False

Effective interval start of the calendar rule.

Effort Double False

Effort available for a resource during the time described by the calendar rule.

EndTime Datetime False

For internal use only.

ExtentCode Integer False

Extent of the calendar rule.

GroupDesignator String False

Unique identifier of the group.

InnerCalendarId_Id String False

Unique identifier of the inner calendar for non-leaf calendar rules.

InnerCalendarId_LogicalName String False

InnerCalendarId_Name String False

IsModified Boolean False

For internal use only.

IsSelected Boolean False

Flag used in vary-by-day calendar rules.

IsSimple Boolean False

Flag used in vary-by-day calendar rules.

IsVaried Boolean False

Flag used in leaf nonrecurring rules.

ModifiedBy_Id String True

Unique identifier of the user who last modified the calendar rule.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the calendar rule was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the calendarrule.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the calendar rule.

Offset Integer False

Start offset for leaf nonrecurring rules.

OrganizationId String True

Unique identifier of the organization with which the calendar rule is associated.

Pattern String False

Pattern of the rule recurrence.

Rank Integer False

Rank of the calendar rule.

ServiceId_Id String False

Unique identifier of the service with which the calendar rule is associated.

ServiceId_LogicalName String False

ServiceId_Name String False

StartTime Datetime False

Start time for the rule.

SubCode Integer False

Sub-type of calendar rule.

TimeCode Integer False

Type of calendar rule such as working hours, break, holiday, or time off.

TimeZoneCode Integer False

Local time zone for the calendar rule.





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

Information regarding whether the account has been merged with a master lead.

MiddleName String False

Middle name for the lead.

MobilePhone String False

Mobile phone number for the lead.

ModifiedBy_Id String True

Unique identifier of the user who last modified the lead.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the lead was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the lead.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

NumberOfEmployees Integer False

Number of employees at the lead's company.

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 lead record.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the lead.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the lead.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the lead.

OwningUser_LogicalName String True

OwningUser_Name String True

Pager String False

Pager number for the lead.

ParticipatesInWorkflow Boolean False

Information about whether the lead participates in workflow rules.

PreferredContactMethodCode String False

Preferred contact method for the lead.

PriorityCode String False

Priority of the lead.

Revenue Double False

Revenue amount for the lead.

Revenue_Base Double True

Base currency equivalent of the revenue amount for the lead.

SalesStageCode String False

Current stage of the sales process for the lead.

Salutation String False

Salutation for correspondence with the lead.

SIC String False

Standard Industrial Classification (SIC) code for the lead.

StateCode String True

Status of the lead.

StatusCode String False

Reason for the status of the lead.

Subject String False

Subject associated with the lead.

Telephone1 String False

First telephone number for the lead.

Telephone2 String False

Second telephone number for the lead.

Telephone3 String False

Third telephone number for the lead.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the lead.

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

YomiCompanyName String False

Name of the company with which the lead is associated.

YomiFirstName String False

Hiragana or Katakana phonetic guide for the lead first name, used for Yomi sorting.

YomiFullName String True

Hiragana or Katakana phonetic guide for the lead full name, used for Yomi sorting.

YomiLastName String False

Hiragana or Katakana phonetic guide for the lead last name, used for Yomi sorting.

YomiMiddleName String False

Hiragana or Katakana phonetic guide for the lead middle name, used for Yomi sorting.





LeadAddress

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the lead address.

AddressNumber Integer False

Information about the address for the lead.

AddressTypeCode String False

Type of address for the lead address.

City String False

City name in the address for the lead.

Country String False

Country/region name in the address for the lead.

County String False

County name in the address for the lead.

CreatedBy_Id String True

Unique identifier of the user who created the lead address.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the lead address was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the leadaddress.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

ExchangeRate Double True

Exchange rate for the currency associated with the leadaddress with respect to the base currency.

Fax String False

Fax number for the address for the lead.

Latitude Double False

Latitude for the address for the lead.

LeadAddressId String False

Unique identifier of the lead 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 lead.

ModifiedBy_Id String True

Unique identifier of the user who last modified the lead address.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the lead address was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the leadaddress.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name used to identify the lead address.

ParentId_Id String False

Unique identifier of the parent object with which the lead address is associated.

ParentId_LogicalName String False

ParentId_Name String False

PostalCode String False

ZIP Code or postal code in the address for the lead.

PostOfficeBox String False

Post office box number in the address for the lead.

ShippingMethodCode String False

Method of shipment for the lead.

StateOrProvince String False

State or province in the address for the lead.

Telephone1 String False

First telephone number for the lead address.

Telephone2 String False

Second telephone number for the lead address.

Telephone3 String False

Third telephone number for the lead address.

TransactionCurrencyId_Id