Diagrams


Table

CRM Businessunit

DynamicsDocs.comCRM Businessunit«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 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 5342»CRM ContactContactId [PK]DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]CustomerTypeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...LeadSourceCode; [DefaultValue]OwningBusinessUnitOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]AccountIdParticipatesInWorkflowIsBackofficeCustomerSalutationJobTitleFirstNameDepartmentNickNameMiddleNameLastNameSuffixYomiFirstNameFullNameYomiMiddleNameYomiLastNameAnniversaryBirthDateGovernmentIdYomiFullNameDescriptionEmployeeId...«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 5350»CRM IncidentresolutionModifiedOnActualStartCreatedByActualDurationMinutesIsWorkflowCreatedScheduledEndCategoryIsBilledActivityId [PK]StateCode; [Open,Completed,Canceled]DescriptionStatusCode; [,Open,Closed,Canceled]OwnerIdTimeSpentSubjectCreatedOnModifiedByScheduledStartScheduledDurationMinutesVersionNumberActualEndOwningBusinessUnitIncidentIdSubcategoryOwningUserCreatedByNameIncidentIdNameModifiedByNameOwnerIdType; [,systemuser,team]ImportSequenceNumberTimeZoneRuleVersionNumber...«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 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5360»CRM CustomeraddressParentIdCustomerAddressId [PK]AddressNumberAddressTypeCode; [,BillTo,ShipTo,Prima...NamePrimaryContactNameLine1Line2Line3CityStateOrProvinceCountyCountryPostOfficeBoxPostalCodeUTCOffsetFreightTermsCode; [,FOB,NoCharge]UPSZoneLatitudeTelephone1LongitudeShippingMethodCode; [,Airborne,DHL,Fed...Telephone2Telephone3FaxVersionNumberCreatedByCreatedOnModifiedByModifiedOnCreatedByName...«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OrganizationId><ParentBusinessUnitId><TransactionCurrencyId><BusinessUnitId><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><RegardingObjectId><RegardingObjectOwningBusinessU><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><BusinessUnitId><OwningBusinessUnit><TransactionCurrencyId><RegardingObjectId><RegardingObjectOwnerId><AdministratorId><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><AccountId><CustomerId><ParentAccountId><RegardingObjectId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><BillingAccountId><CustomerId><BillingCustomerId><ParentId><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><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><RegardingObjectId><OpportunityId><OpportunityId><OpportunityId><OrganizationId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><ContractId><OwnerId><OwningTeam><TransactionCurrencyId><ExistingCase><MasterId><ParentCaseId><IncidentId><OwnerId><OwningTeam><OwnerId><OwningTeam><TransactionCurrencyId><QuoteId><OwnerId><OwningTeam><TransactionCurrencyId><SalesOrderId><OwnerId><OwningTeam><TransactionCurrencyId><ServiceAddress><BillToAddress><OriginatingContract><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId><OwnerId><TransactionCurrencyId><BaseCurrencyId><OrganizationId>

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

Fields

# Name Type
1 BusinessUnitId GUID
2 OrganizationId GUID
3 Name Text160
4 Description BLOB [Memo]
5 DivisionName Text100
6 FileAsName Text100
7 TickerSymbol Text10
8 StockExchange Text20
9 UTCOffset Integer
10 CreatedOn DateTime
11 ModifiedOn DateTime
12 CreditLimit Decimal
13 CostCenter Text100
14 WebSiteUrl Text200 [URL]
15 FtpSiteUrl Text200 [URL]
16 EMailAddress Text100 [E-Mail]
17 InheritanceMask Integer
18 CreatedBy GUID
19 ModifiedBy GUID
20 WorkflowSuspended Boolean
21 ParentBusinessUnitId GUID
22 IsDisabled Boolean
23 DisabledReason Text250
24 VersionNumber BigInteger
25 ParentBusinessUnitIdName Text160 FlowField
26 Address1_AddressId GUID
27 Address1_AddressTypeCode Option
28 Address1_Name Text100
29 Address1_Line1 Text250
30 Address1_Line2 Text250
31 Address1_Line3 Text250
32 Address1_City Text80
33 Address1_StateOrProvince Text50
34 Address1_County Text50
35 Address1_Country Text80
36 Address1_PostOfficeBox Text20
37 Address1_PostalCode Text20
38 Address1_UTCOffset Integer
39 Address1_UPSZone Text4
40 Address1_Latitude Decimal
41 Address1_Telephone1 Text50
42 Address1_Longitude Decimal
43 Address1_ShippingMethodCode Option
44 Address1_Telephone2 Text50
45 Address1_Telephone3 Text50
46 Address1_Fax Text50
47 Address2_AddressId GUID
48 Address2_AddressTypeCode Option
49 Address2_Name Text100
50 Address2_Line1 Text250
51 Address2_Line2 Text250
52 Address2_Line3 Text250
53 Address2_City Text80
54 Address2_StateOrProvince Text50
55 Address2_County Text50
56 Address2_Country Text80
57 Address2_PostOfficeBox Text20
58 Address2_PostalCode Text20
59 Address2_UTCOffset Integer
60 Address2_UPSZone Text4
61 Address2_Latitude Decimal
62 Address2_Telephone1 Text50
63 Address2_Longitude Decimal
64 Address2_ShippingMethodCode Option
65 Address2_Telephone2 Text50
66 Address2_Telephone3 Text50
67 Address2_Fax Text50
68 CreatedByName Text200 FlowField
69 ModifiedByName Text200 FlowField
70 OrganizationIdName Text160 FlowField
71 OverriddenCreatedOn Date
72 ImportSequenceNumber Integer
73 CreatedOnBehalfBy GUID
74 CreatedOnBehalfByName Text200 FlowField
75 ModifiedOnBehalfBy GUID
76 ModifiedOnBehalfByName Text200 FlowField
77 TransactionCurrencyId GUID
78 TransactionCurrencyIdName Text100 FlowField
79 ExchangeRate Decimal

Keys

# Fields
0 BusinessUnitId Clustered: Yes
1 Name

Table Relations To Other Tables

Field Related Table Related Field
ParentBusinessUnitId CRM Businessunit BusinessUnitId 1..n
OrganizationId CRM Organization OrganizationId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field
CRM Account OwningBusinessUnit 1..n
CRM Businessunit ParentBusinessUnitId 1..n
CRM Contact OwningBusinessUnit 1..n
CRM Contract OwningBusinessUnit 1..n
CRM Customeraddress OwningBusinessUnit 1..n
CRM Incident OwningBusinessUnit 1..n
CRM Incidentresolution OwningBusinessUnit 1..n
CRM Invoice OwningBusinessUnit 1..n
CRM Opportunity OwningBusinessUnit 1..n
CRM Post RegardingObjectOwningBusinessU 1..n
CRM Quote OwningBusinessUnit 1..n
CRM Salesorder OwningBusinessUnit 1..n
CRM Systemuser BusinessUnitId 1..n
CRM Team BusinessUnitId 1..n