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

Keys

# Fields
0 NAVConnectionId Clustered: Yes
1 Name

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field