Objects/Tables/Table 5330 CRM Connection Setup
Table 5330 CRM Connection Setup in 17
Jonas Paprotka, Base Application 17.5.22499.32099, checked
- App
- Base Application
Fields, 32Keys, 1Procedures, 44Events, 2
Versions171819202122232425262728latest
Source29
Fields, 32
| Id | Name | Type | Obsolete |
|---|
| 1 | Primary Key | Code[20] | - |
| 2 | Server Address | Text[250] | - |
| 3 | User Name | Text[250] | - |
| 4 | User Password Key | Guid | - |
| 5 | Last Update Invoice Entry No. | Integer | Removed 15.0 |
| Moved this field to Table 5328 - CRM Synch Status as this field is getting updated by job queue and it is blocking the record. |
| 59 | Restore Connection | Boolean | - |
| 60 | Is Enabled | Boolean | - |
| 61 | Is User Mapping Required | Boolean | - |
| 62 | Is User Mapped To CRM User | Boolean | - |
| 63 | CRM Version | Text[30] | - |
| 64 | Use Newest UI | Boolean | - |
| 65 | Newest UI AppModuleId | Text[50] | - |
| 66 | Is S.Order Integration Enabled | Boolean | - |
| 67 | Is CRM Solution Installed | Boolean | - |
| 68 | Is Enabled For User | Boolean | - |
| 69 | Dynamics NAV URL | Text[250] | - |
| 70 | Dynamics NAV OData URL | Text[250] | - |
| 71 | Dynamics NAV OData Username | Text[250] | - |
| 72 | Dynamics NAV OData Accesskey | Text[250] | - |
| 75 | Default CRM Price List ID | Guid | - |
| 76 | Proxy Version | Integer | - |
| 80 | Auto Create Sales Orders | Boolean | - |
| 81 | Auto Process Sales Quotes | Boolean | - |
| 118 | CurrencyDecimalPrecision | Integer | - |
| 124 | BaseCurrencyId | Guid | - |
| 133 | BaseCurrencyPrecision | Integer | - |
| 134 | BaseCurrencySymbol | Text[5] | - |
| 135 | Authentication Type | Option | - |
| 136 | Connection String | Text[250] | - |
| 137 | Domain | Text[250] | - |
| 138 | Server Connection String | Blob | - |
| 139 | Disable Reason | Text[250] | - |
Keys, 1
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Primary Key | - |
Procedures, 44
| Name | Parameters | Returns | Access | Obsolete |
|---|
| EnsureCDSConnectionIsEnabled | () | | public | - |
| LoadConnectionStringElementsFromCDSConnectionSetup | () | | public | - |
| DeployCRMSolution | (Boolean) | | public | - |
| CountCRMJobQueueEntries | (var Integer, var Integer) | | public | - |
| HasPassword | () | Boolean | public | - |
| SetPassword | (Text) | | public | - |
| DeletePassword | () | | public | - |
| UpdateAllConnectionRegistrations | () | | public | - |
| UpdateIsEnabledState | () | | public | - |
| RegisterConnection | () | | public | - |
| RegisterConnectionWithName | (Text) | | public | - |
| UnregisterConnection | () | Boolean | public | - |
| UnregisterConnectionWithName | (Text) | Boolean | public | - |
| GetConnectionStringWithCredentials | () | Text | public | - |
| RegisterUserConnection | () | Text | public | - |
| GetIntegrationUserID | () | Guid | public | - |
| GetPassword | () | Text | public | - |
| GetJobQueueEntriesObjectIDToRunFilter | () | Text | public | - |
| PerformTestConnection | () | | public | - |
| VerifyTestConnection | () | Boolean | public | - |
| TestConnection | () | Boolean | public | - |
| TestIntegrationUserRequirements | () | | public | - |
| TryReadSystemUsers | () | Boolean | public | - |
| IsVersionValid | () | Boolean | public | - |
| IsCurrentUserMappedToCrmSystemUser | () | Boolean | public | - |
| UpdateFromWizard | (var Record CRM Connection Setup, Text) | | public | - |
| EnableCRMConnectionFromWizard | () | | public | - |
| RestoreConnection | () | | public | - |
| SetCRMSOPEnabled | () | | public | - |
| SetCRMSOPDisabled | () | | public | - |
| SetCRMSOPEnabledWithCredentials | (Text[250], Text, Boolean) | | public | - |
| SetUserAsIntegrationUser | () | | public | - |
| RefreshDataFromCRM | () | | public | Pending 15.1 |
| Function scope will be changed to OnPrem |
| PerformWebClientUrlReset | () | | public | - |
| SynchronizeNow | (Boolean) | | public | - |
| PromptForCredentials | (var Text, var Text) | Boolean | public | - |
| DoReadCRMData | () | Boolean | public | - |
| GetDefaultCRMConnection | (Text) | Text | public | - |
| UpdateConnectionString | () | Text | public | - |
| UpdateCRMJobQueueEntriesStatus | () | | public | - |
| GetConnectionString | () | Text | public | - |
| SetConnectionString | (Text) | | public | - |
| IsEnabled | () | Boolean | public | - |
| SetUseNewestUI | () | | public | - |
Events, 2
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnReadingCRMData | (var Boolean) | - |
| Integration event | OnGetDefaultCRMConnection | (var Text) | - |