Diagrams


Table

CRM Contact

DynamicsDocs.comCRM Contact«Table 5342»CRM ContactContactId [PK]DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]CustomerTypeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...LeadSourceCode; [DefaultValue]OwningBusinessUnitOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]AccountIdParticipatesInWorkflowIsBackofficeCustomerSalutationJobTitleFirstNameDepartmentNickNameMiddleNameLastNameSuffixYomiFirstNameFullNameYomiMiddleNameYomiLastNameAnniversaryBirthDateGovernmentIdYomiFullNameDescriptionEmployeeId...«Table 5341»CRM AccountAccountId [PK]AccountCategoryCode; [,PreferredCustom...DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...CustomerTypeCode; [,Competitor,Consult...AccountRatingCode; [DefaultValue]IndustryCode; [,Accounting,Agriculture...TerritoryCode; [DefaultValue]AccountClassificationCode; [DefaultVal...BusinessTypeCode; [DefaultValue]OwningBusinessUnitTraversedPathOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]PrimaryContactIdParticipatesInWorkflowNameAccountNumberRevenueNumberOfEmployeesDescriptionSICOwnershipCode; [,Public,Private,Subsid...MarketCapSharesOutstandingTickerSymbolStockExchangeWebSiteURLFtpSiteURL...«Table 5343»CRM OpportunityOpportunityId [PK]PriceLevelIdOpportunityRatingCode; [Hot,Warm,Cold]PriorityCode; [DefaultValue]ContactIdAccountIdNameStepIdDescriptionEstimatedValueStepNameSalesStageCode; [DefaultValue]ParticipatesInWorkflowPricingErrorCode; [None,DetailError,Mi...EstimatedCloseDateCloseProbabilityActualValueActualCloseDateOwningUserOwningBusinessUnitCreatedOnCreatedByModifiedOnModifiedByVersionNumberStateCode; [Open,Won,Lost]StatusCode; [,InProgress,OnHold,Won,Ca...IsRevenueSystemCalculatedContactIdNameAccountIdNamePriceLevelIdName...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5349»CRM IncidentIncidentId [PK]OwningBusinessUnitContractIdOwningUserActualServiceUnitsCaseOriginCode; [,Phone,Email,Web,Face...BilledServiceUnitsCaseTypeCode; [,Question,Problem,Reque...ProductSerialNumberTitleProductIdContractServiceLevelCode; [,Gold,Silve...AccountIdDescriptionContactIdIsDecrementingCreatedOnTicketNumberPriorityCode; [High,Normal,Low]CustomerSatisfactionCode; [,VerySatisf...IncidentStageCode; [DefaultValue]ModifiedOnCreatedByFollowupByModifiedByVersionNumberStateCode; [Active,Resolved,Canceled]SeverityCode; [DefaultValue]StatusCode; [,ProblemSolved,Informatio...ResponsibleContactIdAccountIdName...«Table 5351»CRM QuoteQuoteId [PK]OwningBusinessUnitOwningUserPriceLevelIdOpportunityIdAccountIdContactIdQuoteNumberRevisionNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightEffectiveFromTotalTaxTotalDiscountAmountEffectiveToExpiresOnClosedOnRequestDeliveryByShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOnModifiedBy...«Table 5353»CRM SalesorderSalesOrderId [PK]OpportunityIdQuoteIdPriorityCode; [DefaultValue]SubmitStatusOwningUserSubmitDateOwningBusinessUnitSubmitStatusDescriptionPriceLevelIdLastBackofficeSubmitAccountIdContactIdOrderNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountRequestDeliveryByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOn...«Table 5355»CRM InvoiceInvoiceId [PK]OpportunityIdPriorityCode; [DefaultValue]SalesOrderIdOwningUserOwningBusinessUnitLastBackofficeSubmitPriceLevelIdAccountIdContactIdInvoiceNumberNameDescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountCreatedByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...CreatedOnModifiedByModifiedOnStateCode; [Active,Closed<deprecated>,...StatusCode; [,New,PartiallyShipped,Bil...ShipTo_NameVersionNumber...«Table 5357»CRM ContractContractId [PK]OwningBusinessUnitContractServiceLevelCode; [Gold,Silver...ServiceAddressBillToAddressOwningUserContactIdAccountIdBillingAccountIdContractNumberBillingContactIdActiveOnExpiresOnCancelOnTitleContractLanguageBillingStartOnEffectivityCalendarBillingEndOnBillingFrequencyCode; [Monthly,Bimonth...CreatedByCreatedOnModifiedByAllotmentTypeCode; [,NumberofCases,Tim...UseDiscountAsPercentageModifiedOnTotalPriceVersionNumberTotalDiscountStateCode; [Draft,Invoiced,Active,OnHo...NetPrice...«Table 5360»CRM CustomeraddressParentIdCustomerAddressId [PK]AddressNumberAddressTypeCode; [,BillTo,ShipTo,Prima...NamePrimaryContactNameLine1Line2Line3CityStateOrProvinceCountyCountryPostOfficeBoxPostalCodeUTCOffsetFreightTermsCode; [,FOB,NoCharge]UPSZoneLatitudeTelephone1LongitudeShippingMethodCode; [,Airborne,DHL,Fed...Telephone2Telephone3FaxVersionNumberCreatedByCreatedOnModifiedByModifiedOnCreatedByName...«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<DefaultPriceLevelId><OwningBusinessUnit><AccountId><ParentCustomerId><PrimaryContactId><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><ContactId><CustomerId><ParentContactId><RegardingObjectId><ContactId><ResponsibleContactId><CustomerId><PrimaryContactId><ContactId><CustomerId><ContactId><CustomerId><ContactId><CustomerId><ContactId><BillingContactId><CustomerId><BillingCustomerId><ParentId><DefaultPriceLevelId><OwningBusinessUnit><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><AccountId><CustomerId><ParentAccountId><RegardingObjectId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><BillingAccountId><CustomerId><BillingCustomerId><ParentId><PriceLevelId><OwningBusinessUnit><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><RegardingObjectId><OpportunityId><OpportunityId><OpportunityId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectOwningBusinessU><OwningBusinessUnit><ContractId><OwnerId><OwningTeam><TransactionCurrencyId><ExistingCase><MasterId><ParentCaseId><OwningBusinessUnit><PriceLevelId><OwnerId><OwningTeam><TransactionCurrencyId><QuoteId><OwningBusinessUnit><PriceLevelId><OwnerId><OwningTeam><TransactionCurrencyId><SalesOrderId><OwningBusinessUnit><PriceLevelId><OwnerId><OwningTeam><TransactionCurrencyId><OwningBusinessUnit><ServiceAddress><BillToAddress><OriginatingContract><OwnerId><OwningTeam><TransactionCurrencyId><OwningBusinessUnit><OwnerId><TransactionCurrencyId><TransactionCurrencyId><ParentBusinessUnitId><TransactionCurrencyId><BusinessUnitId><BusinessUnitId><TransactionCurrencyId><AdministratorId><TransactionCurrencyId>

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

Fields

# Name Type
1 ContactId GUID
2 DefaultPriceLevelId GUID
3 CustomerSizeCode Option
4 CustomerTypeCode Option
5 PreferredContactMethodCode Option
6 LeadSourceCode Option
7 OwningBusinessUnit GUID
8 OwningUser GUID
9 PaymentTermsCode Option
10 ShippingMethodCode Option
11 AccountId GUID
12 ParticipatesInWorkflow Boolean
13 IsBackofficeCustomer Boolean
14 Salutation Text100
15 JobTitle Text100
16 FirstName Text50
17 Department Text100
18 NickName Text50
19 MiddleName Text50
20 LastName Text50
21 Suffix Text10
22 YomiFirstName Text150
23 FullName Text160
24 YomiMiddleName Text150
25 YomiLastName Text150
26 Anniversary Date
27 BirthDate Date
28 GovernmentId Text50
29 YomiFullName Text250
30 Description BLOB [Memo]
31 EmployeeId Text50
32 GenderCode Option
33 AnnualIncome Decimal
34 HasChildrenCode Option
35 EducationCode Option
36 WebSiteUrl Text200 [URL]
37 FamilyStatusCode Option
38 FtpSiteUrl Text200 [URL]
39 EMailAddress1 Text100 [E-Mail]
40 SpousesName Text100
41 AssistantName Text100
42 EMailAddress2 Text100 [E-Mail]
43 AssistantPhone Text50
44 EMailAddress3 Text100 [E-Mail]
45 DoNotPhone Boolean
46 ManagerName Text100
47 ManagerPhone Text50
48 DoNotFax Boolean
49 DoNotEMail Boolean
50 DoNotPostalMail Boolean
51 DoNotBulkEMail Boolean
52 DoNotBulkPostalMail Boolean
53 AccountRoleCode Option
54 TerritoryCode Option
55 CreditLimit Decimal
56 CreatedOn DateTime
57 CreditOnHold Boolean
58 CreatedBy GUID
59 ModifiedOn DateTime
60 ModifiedBy GUID
61 NumberOfChildren Integer
62 ChildrensNames Text250
63 VersionNumber BigInteger
64 MobilePhone Text50
65 Pager Text50
66 Telephone1 Text50
67 Telephone2 Text50
68 Telephone3 Text50
69 Fax Text50
70 Aging30 Decimal
71 StateCode Option
72 Aging60 Decimal
73 StatusCode Option
74 Aging90 Decimal
75 ParentContactId GUID
76 ParentContactIdName Text160 FlowField
77 AccountIdName Text160 FlowField
78 DefaultPriceLevelIdName Text100 FlowField
79 Address1_AddressId GUID
80 Address1_AddressTypeCode Option
81 Address1_Name Text200
82 Address1_PrimaryContactName Text100
83 Address1_Line1 Text250
84 Address1_Line2 Text250
85 Address1_Line3 Text250
86 Address1_City Text80
87 Address1_StateOrProvince Text50
88 Address1_County Text50
89 Address1_Country Text80
90 Address1_PostOfficeBox Text20
91 Address1_PostalCode Text20
92 Address1_UTCOffset Integer
93 Address1_FreightTermsCode Option
94 Address1_UPSZone Text4
95 Address1_Latitude Decimal
96 Address1_Telephone1 Text50
97 Address1_Longitude Decimal
98 Address1_ShippingMethodCode Option
99 Address1_Telephone2 Text50
100 Address1_Telephone3 Text50
101 Address1_Fax Text50
102 Address2_AddressId GUID
103 Address2_AddressTypeCode Option
104 Address2_Name Text100
105 Address2_PrimaryContactName Text100
106 Address2_Line1 Text250
107 Address2_Line2 Text250
108 Address2_Line3 Text250
109 Address2_City Text80
110 Address2_StateOrProvince Text50
111 Address2_County Text50
112 Address2_Country Text80
113 Address2_PostOfficeBox Text20
114 Address2_PostalCode Text20
115 Address2_UTCOffset Integer
116 Address2_FreightTermsCode Option
117 Address2_UPSZone Text4
118 Address2_Latitude Decimal
119 Address2_Telephone1 Text50
120 Address2_Longitude Decimal
121 Address2_ShippingMethodCode Option
122 Address2_Telephone2 Text50
123 Address2_Telephone3 Text50
124 Address2_Fax Text50
125 CreatedByName Text200 FlowField
126 ModifiedByName Text200 FlowField
127 OwnerId GUID
128 OwnerIdType Option
129 PreferredSystemUserId GUID
130 MasterId GUID
131 PreferredAppointmentDayCode Option
132 PreferredAppointmentTimeCode Option
133 DoNotSendMM Boolean
134 ParentCustomerId GUID
135 Merged Boolean
136 ExternalUserIdentifier Text50
137 LastUsedInCampaign Date
138 MasterContactIdName Text160 FlowField
139 PreferredSystemUserIdName Text200 FlowField
140 ParentCustomerIdType Option
141 TransactionCurrencyId GUID
142 OverriddenCreatedOn Date
143 ExchangeRate Decimal
144 ImportSequenceNumber Integer
145 TimeZoneRuleVersionNumber Integer
146 UTCConversionTimeZoneCode Integer
147 AnnualIncome_Base Decimal
148 CreditLimit_Base Decimal
149 Aging60_Base Decimal
150 Aging90_Base Decimal
151 Aging30_Base Decimal
152 TransactionCurrencyIdName Text100 FlowField
153 CreatedOnBehalfBy GUID
154 CreatedOnBehalfByName Text200 FlowField
155 ModifiedOnBehalfBy GUID
156 ModifiedOnBehalfByName Text200 FlowField
157 OwningTeam GUID
158 StageId GUID
159 ProcessId GUID
160 Address2_Composite BLOB [Memo]
161 Address1_Composite BLOB [Memo]
162 EntityImageId GUID
163 TraversedPath Text250
164 Address3_Country Text80
165 Address3_Line1 Text250
166 Address3_Line2 Text250
167 Address3_Line3 Text250
168 Address3_PostalCode Text20
169 Address3_PostOfficeBox Text20
170 Address3_StateOrProvince Text50
171 Address3_City Text80
172 Business2 Text50
173 Callback Text50
174 Company Text50
175 Home2 Text50
176 Address3_AddressId GUID
177 Address3_Composite BLOB [Memo]
178 Address3_Fax Text50
179 Address3_FreightTermsCode Option
180 Address3_Latitude Decimal
181 Address3_Longitude Decimal
182 Address3_Name Text200
183 Address3_PrimaryContactName Text100
184 Address3_ShippingMethodCode Option
185 Address3_Telephone1 Text50
186 Address3_Telephone2 Text50
187 Address3_Telephone3 Text50
188 Address3_UPSZone Text4
189 Address3_UTCOffset Integer
190 Address3_County Text50
191 Address3_AddressTypeCode Option

Keys

# Fields
0 ContactId Clustered: Yes
1 FullName

Table Relations To Other Tables

Field Related Table Related Field
ParentCustomerId CRM Account AccountId 1..n
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
ParentCustomerId CRM Contact ContactId 1..n
DefaultPriceLevelId CRM Pricelevel PriceLevelId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwningTeam CRM Team TeamId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field
CRM Account PrimaryContactId 1..n
CRM Contact ParentCustomerId 1..n
CRM Contract BillingCustomerId 1..n
CRM Customeraddress ParentId 1..n
CRM Incident PrimaryContactId 1..n
CRM Invoice CustomerId 1..n
CRM Opportunity ParentContactId 1..n
CRM Post RegardingObjectId 1..n
CRM Quote CustomerId 1..n
CRM Salesorder CustomerId 1..n