TableType Property
Specifies the table type.
Applies To
- Tables
Property Value
| Value | Description |
|---|---|
| Normal | Specifies the table as a normal table in the Dynamics NAV database. This is the default value. |
| CRM | Specifies the table as an integration table for integrating Dynamics NAV with Microsoft Dynamics 365 for Sales. The table is typically based on an entity in Microsoft Dynamics 365 for Sales, such as the Accounts entity. |
| ExternalSQL | Specifies the table as a table or view in SQL Server that is not in the Dynamics NAV database. |
| Exchange | This is for internal use only. |
| MicrosoftGraph | This is for internal use only. |
Remarks
Tables that are marked as CRM or ExternalSQL are considered to external tables that are not managed by Dynamics NAV. These tables use a different SQL Server connection than the normal tables in the 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 Introduction to Dynamics CRM Integration Customization in Dynamics NAV.