CRM Connection Setup


# Name Type
1 Primary Key Code20
2 Server Address Text250
3 User Name Text250
4 User Password Key GUID
5 Last Update Invoice Entry No. Integer Editable: No
60 Is Enabled Boolean
61 Is User Mapping Required Boolean
62 Is User Mapped To CRM User Boolean
63 CRM Version Text30
66 Is S.Order Integration Enabled Boolean
67 Is CRM Solution Installed Boolean
68 Is Enabled For User Boolean
69 Dynamics NAV URL Text250
70 Dynamics NAV OData URL Text250
71 Dynamics NAV OData Username Text250
72 Dynamics NAV OData Accesskey Text250
75 Default CRM Price List ID GUID
80 Auto Create Sales Orders Boolean
118 CurrencyDecimalPrecision Integer
124 BaseCurrencyId GUID
133 BaseCurrencyPrecision Integer
134 BaseCurrencySymbol Text5
135 Authentication Type Option
136 Connection String Text250
137 Domain Text250 Editable: No
138 Server Connection String BLOB


# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
BaseCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field