Diagrams


Table

CRM Connection Setup

Fields

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

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field