Diagrams


Table

CRM Quote

DynamicsDocs.comCRM Quote«Table 5351»CRM QuoteQuoteId [PK]OwningBusinessUnitOwningUserPriceLevelIdOpportunityIdAccountIdContactIdQuoteNumberRevisionNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightEffectiveFromTotalTaxTotalDiscountAmountEffectiveToExpiresOnClosedOnRequestDeliveryByShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOnModifiedBy...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5352»CRM QuotedetailQuoteDetailId [PK]QuoteIdSalesRepIdLineItemNumberUoMIdProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionShipTo_NameIsPriceOverriddenTaxShipTo_Line1CreatedOnShipTo_Line2CreatedByModifiedByShipTo_Line3ShipTo_CityModifiedOnShipTo_StateOrProvinceShipTo_CountryShipTo_PostalCodeWillCall...«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 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 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«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 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 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OwningBusinessUnit><PriceLevelId><OpportunityId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><RegardingObjectId><QuoteId><QuoteId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectOwningBusinessU><SalesRepId><TransactionCurrencyId><OwnerId><OpportunityId><OwningBusinessUnit><PriceLevelId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><ParentBusinessUnitId><TransactionCurrencyId><BusinessUnitId><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><BusinessUnitId><TransactionCurrencyId><AdministratorId><TransactionCurrencyId><DefaultPriceLevelId><DefaultPriceLevelId><PriceLevelId><ContactId><CustomerId><ParentContactId><AccountId><CustomerId><ParentAccountId><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><ParentContactId><MasterId><ParentCustomerId><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 QuoteId GUID
2 OwningBusinessUnit GUID
3 OwningUser GUID
4 PriceLevelId GUID
5 OpportunityId GUID
6 AccountId GUID
7 ContactId GUID
8 QuoteNumber Text100
9 RevisionNumber Integer
10 Name Text250
11 PricingErrorCode Option
12 Description BLOB [Memo]
13 DiscountAmount Decimal
14 FreightAmount Decimal
15 TotalAmount Decimal
16 TotalLineItemAmount Decimal
17 TotalLineItemDiscountAmount Decimal
18 TotalAmountLessFreight Decimal
19 EffectiveFrom Date
20 TotalTax Decimal
21 TotalDiscountAmount Decimal
22 EffectiveTo Date
23 ExpiresOn Date
24 ClosedOn Date
25 RequestDeliveryBy Date
26 ShippingMethodCode Option
27 PaymentTermsCode Option
28 FreightTermsCode Option
29 CreatedBy GUID
30 CreatedOn DateTime
31 ModifiedBy GUID
32 ModifiedOn DateTime
33 StateCode Option
34 StatusCode Option
35 ShipTo_Name Text200
36 VersionNumber BigInteger
37 ShipTo_Line1 Text250
38 ShipTo_Line2 Text250
39 ShipTo_Line3 Text250
40 ShipTo_City Text80
41 ShipTo_StateOrProvince Text50
42 ShipTo_Country Text80
43 ShipTo_PostalCode Text20
44 WillCall Boolean
45 ShipTo_Telephone Text50
46 BillTo_Name Text200
47 ShipTo_FreightTermsCode Option
48 ShipTo_Fax Text50
49 BillTo_Line1 Text250
50 BillTo_Line2 Text250
51 BillTo_Line3 Text250
52 BillTo_City Text80
53 BillTo_StateOrProvince Text50
54 BillTo_Country Text80
55 BillTo_PostalCode Text20
56 BillTo_Telephone Text50
57 BillTo_Fax Text50
58 DiscountPercentage Decimal
59 ContactIdName Text160 FlowField
60 AccountIdName Text160 FlowField
61 OpportunityIdName Text250 FlowField
62 PriceLevelIdName Text100 FlowField
63 CreatedByName Text200 FlowField
64 ModifiedByName Text200 FlowField
65 CustomerId GUID
66 CustomerIdType Option
67 OwnerId GUID
68 OwnerIdType Option
69 ShipTo_AddressId GUID
70 ShipTo_ContactName Text150
71 BillTo_AddressId GUID
72 BillTo_ContactName Text150
73 TimeZoneRuleVersionNumber Integer
74 ImportSequenceNumber Integer
75 ExchangeRate Decimal
76 OverriddenCreatedOn Date
77 UTCConversionTimeZoneCode Integer
78 TransactionCurrencyId GUID
79 TotalLineItemDiscountAmount_Ba Decimal
80 TransactionCurrencyIdName Text100 FlowField
81 TotalAmountLessFreight_Base Decimal
82 DiscountAmount_Base Decimal
83 FreightAmount_Base Decimal
84 TotalAmount_Base Decimal
85 TotalDiscountAmount_Base Decimal
86 TotalTax_Base Decimal
87 TotalLineItemAmount_Base Decimal
88 CreatedOnBehalfBy GUID
89 CreatedOnBehalfByName Text200 FlowField
90 ModifiedOnBehalfBy GUID
91 ModifiedOnBehalfByName Text200 FlowField
92 OwningTeam GUID
93 BillTo_Composite BLOB [Memo]
94 ShipTo_Composite BLOB [Memo]
95 ProcessId GUID
96 StageId GUID
97 TraversedPath Text250

Keys

# Fields
0 QuoteId Clustered: Yes
1 Name

Table Relations To Other Tables

Field Related Table Related Field
CustomerId CRM Account AccountId 1..n
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
CustomerId CRM Contact ContactId 1..n
OpportunityId CRM Opportunity OpportunityId 1..n
PriceLevelId 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 Post RegardingObjectId 1..n
CRM Quotedetail QuoteId 1..n
CRM Salesorder QuoteId 1..n