Diagrams


Table

CRM Contract

DynamicsDocs.comCRM Contract«Table 5357»CRM ContractContractId [PK]OwningBusinessUnitContractServiceLevelCode; [Gold,Silver...ServiceAddressBillToAddressOwningUserContactIdAccountIdBillingAccountIdContractNumberBillingContactIdActiveOnExpiresOnCancelOnTitleContractLanguageBillingStartOnEffectivityCalendarBillingEndOnBillingFrequencyCode; [Monthly,Bimonth...CreatedByCreatedOnModifiedByAllotmentTypeCode; [,NumberofCases,Tim...UseDiscountAsPercentageModifiedOnTotalPriceVersionNumberTotalDiscountStateCode; [Draft,Invoiced,Active,OnHo...NetPrice...«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 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5360»CRM CustomeraddressParentIdCustomerAddressId [PK]AddressNumberAddressTypeCode; [,BillTo,ShipTo,Prima...NamePrimaryContactNameLine1Line2Line3CityStateOrProvinceCountyCountryPostOfficeBoxPostalCodeUTCOffsetFreightTermsCode; [,FOB,NoCharge]UPSZoneLatitudeTelephone1LongitudeShippingMethodCode; [,Airborne,DHL,Fed...Telephone2Telephone3FaxVersionNumberCreatedByCreatedOnModifiedByModifiedOnCreatedByName...«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«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 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OwningBusinessUnit><ServiceAddress><BillToAddress><ContactId><BillingContactId><CustomerId><BillingCustomerId><AccountId><BillingAccountId><CustomerId><BillingCustomerId><OriginatingContract><OwnerId><OwningTeam><TransactionCurrencyId><RegardingObjectId><ContractId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectOwningBusinessU><OwningBusinessUnit><AccountId><CustomerId><ContactId><ResponsibleContactId><CustomerId><PrimaryContactId><OwnerId><OwningTeam><TransactionCurrencyId><ExistingCase><MasterId><ParentCaseId><ParentBusinessUnitId><TransactionCurrencyId><BusinessUnitId><OwningBusinessUnit><OwningBusinessUnit><BusinessUnitId><OwningBusinessUnit><ParentId><ParentId><OwnerId><TransactionCurrencyId><TransactionCurrencyId><AdministratorId><AccountId><ParentCustomerId><PrimaryContactId><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId>

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

Fields

# Name Type
1 ContractId GUID
2 OwningBusinessUnit GUID
3 ContractServiceLevelCode Option
4 ServiceAddress GUID
5 BillToAddress GUID
6 OwningUser GUID
7 ContactId GUID
8 AccountId GUID
9 BillingAccountId GUID
10 ContractNumber Text100
11 BillingContactId GUID
12 ActiveOn Date
13 ExpiresOn Date
14 CancelOn Date
15 Title Text100
16 ContractLanguage BLOB [Memo]
17 BillingStartOn Date
18 EffectivityCalendar Text168
19 BillingEndOn Date
20 BillingFrequencyCode Option
21 CreatedBy GUID
22 CreatedOn DateTime
23 ModifiedBy GUID
24 AllotmentTypeCode Option
25 UseDiscountAsPercentage Boolean
26 ModifiedOn DateTime
27 TotalPrice Decimal
28 VersionNumber BigInteger
29 TotalDiscount Decimal
30 StateCode Option
31 NetPrice Decimal
32 StatusCode Option
33 OriginatingContract GUID
34 Duration Integer
35 ContactIdName Text160 FlowField
36 AccountIdName Text160 FlowField
37 BillingContactIdName Text160 FlowField
38 BillingAccountIdName Text160 FlowField
39 OriginatingContractName Text100 FlowField
40 BillToAddressName Text200 FlowField
41 ServiceAddressName Text200 FlowField
42 ContractTemplateAbbreviation Text20
43 CreatedByName Text200 FlowField
44 ModifiedByName Text200 FlowField
45 CustomerId GUID
46 CustomerIdType Option
47 BillingCustomerId GUID
48 BillingCustomerIdType Option
49 OwnerId GUID
50 OwnerIdType Option
51 TimeZoneRuleVersionNumber Integer
52 OverriddenCreatedOn Date
53 ImportSequenceNumber Integer
54 UTCConversionTimeZoneCode Integer
55 TransactionCurrencyId GUID
56 ExchangeRate Decimal
57 TotalDiscount_Base Decimal
58 NetPrice_Base Decimal
59 TransactionCurrencyIdName Text100 FlowField
60 TotalPrice_Base Decimal
61 CreatedOnBehalfBy GUID
62 CreatedOnBehalfByName Text200 FlowField
63 ModifiedOnBehalfBy GUID
64 ModifiedOnBehalfByName Text200 FlowField
65 OwningTeam GUID
66 EntityImageId GUID

Keys

# Fields
0 ContractId Clustered: Yes
1 Title

Table Relations To Other Tables

Field Related Table Related Field
BillingCustomerId CRM Account AccountId 1..n
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
BillingCustomerId CRM Contact ContactId 1..n
OriginatingContract CRM Contract ContractId 1..n
BillToAddress CRM Customeraddress CustomerAddressId 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 Contract OriginatingContract 1..n
CRM Incident ContractId 1..n
CRM Post RegardingObjectId 1..n