TableType Property
Specifies the table type.
Applies To
- Tables
Property Value
| Value | Description |
|---|---|
Normal |
Specifies the table as a normal table in the Microsoft Dynamics NAV database. This is the default value. |
CRM |
Specifies the table as an integration table for integrating Microsoft Dynamics NAV with Microsoft Dynamics CRM. The table is typically based on an entity in Microsoft Dynamics CRM, such as the Accounts entity. |
ExternalSQL |
Specifies the table as a table or view in SQL Server that is not in the Microsoft Dynamics NAV database. |
Remarks
Tables that are marked as CRM or ExternalSQL are considered to external tables that are not managed by Microsoft Dynamics NAV. These tables use a different SQL Server connection than the normal tables in the Microsoft Dynamics NAV database. For more information, see External Tables.
Important
We advise against creating tables of type CRM manually. Instead, use the integration mapping functionality. For more information, see Integration Concepts and Terminology.