Diagrams


Table

CRM NAV Connection

DynamicsDocs.comCRM NAV Connection«Table 5368»CRM NAV ConnectionNAVConnectionId [PK]CreatedOnCreatedByModifiedOnModifiedByCreatedOnBehalfByModifiedOnBehalfByCreatedByNameCreatedOnBehalfByNameModifiedByNameModifiedOnBehalfByNameOrganizationIdOrganizationIdNamestatecode; [,Active,Inactive]statuscode; [,Active,Inactive]VersionNumberImportSequenceNumberOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeNameDynamics NAV URLDynamics NAV OData URLDynamics NAV OData UsernameDynamics NAV OData Accesskey«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...<OrganizationId>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 NAVConnectionId (NAVConnectionId) GUID
2 CreatedOn (CreatedOn) DateTime
3 CreatedBy (CreatedBy) GUID
4 ModifiedOn (ModifiedOn) DateTime
5 ModifiedBy (ModifiedBy) GUID
6 CreatedOnBehalfBy (CreatedOnBehalfBy) GUID
7 ModifiedOnBehalfBy (ModifiedOnBehalfBy) GUID
8 CreatedByName (CreatedByName) Text200 FlowField
9 CreatedOnBehalfByName (CreatedOnBehalfByName) Text200 FlowField
10 ModifiedByName (ModifiedByName) Text200 FlowField
11 ModifiedOnBehalfByName (ModifiedOnBehalfByName) Text200 FlowField
12 OrganizationId (OrganizationId) GUID
13 OrganizationIdName (OrganizationIdName) Text160 FlowField
14 statecode (statecode) Option
15 statuscode (statuscode) Option
16 VersionNumber (VersionNumber) BigInteger
17 ImportSequenceNumber (ImportSequenceNumber) Integer
18 OverriddenCreatedOn (OverriddenCreatedOn) Date
19 TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) Integer
20 UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) Integer
21 Name (Name) Text100
22 Dynamics NAV URL (Dynamics NAV URL) Text250
23 Dynamics NAV OData URL (Dynamics NAV OData URL) Text250
24 Dynamics NAV OData Username (Dynamics NAV OData Username) Text250
25 Dynamics NAV OData Accesskey (Dynamics NAV OData Accesskey) Text250

Keys

# Fields
0 NAVConnectionId (NAVConnectionId) Clustered: Yes
1 Name (Name)

Table Relations To Other Tables

Field Related Table Related Field
OrganizationId (OrganizationId) CRM Organization OrganizationId (OrganizationId) 1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy) CRM Systemuser SystemUserId (SystemUserId) 1..n

Table Relations From Other Tables

From Table From Field