CRM Quote

Table

CRM Quote

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

Fields

#	Name	Type
1	QuoteId (QuoteId)	GUID	ExternalName: quoteid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the quote.
2	OwningBusinessUnit (OwningBusinessUnit)	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the business unit that owns the quote. TableRelation: "CRM Businessunit".BusinessUnitId
3	OwningUser (OwningUser)	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the quote. TableRelation: "CRM Systemuser".SystemUserId
4	PriceLevelId (PriceLevelId)	GUID	ExternalName: pricelevelid ExternalType: Lookup Description: Choose the price list associated with this record to make sure the products associated with the campaign are offered at the correct prices. TableRelation: "CRM Pricelevel".PriceLevelId
5	OpportunityId (OpportunityId)	GUID	ExternalName: opportunityid ExternalType: Lookup Description: Choose the opportunity that the quote is related to for reporting and analytics. TableRelation: "CRM Opportunity".OpportunityId
6	AccountId (AccountId)	GUID	ExternalName: accountid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the account with which the quote is associated. TableRelation: "CRM Account".AccountId
7	ContactId (ContactId)	GUID	ExternalName: contactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the contact associated with the quote. TableRelation: "CRM Contact".ContactId
8	QuoteNumber (QuoteNumber)	Text100	ExternalName: quotenumber ExternalType: String ExternalAccess: Insert Description: Shows the quote number for customer reference and searching capabilities. The number cannot be modified.
9	RevisionNumber (RevisionNumber)	Integer	ExternalName: revisionnumber ExternalType: Integer ExternalAccess: Read Description: Shows the version number of the quote for revision history tracking.
10	Name (Name)	Text250	ExternalName: name ExternalType: String Description: Type a descriptive name for the quote.
11	PricingErrorCode (PricingErrorCode)	Option	[None,DetailError,MissingPriceLevel,InactivePriceLevel,MissingQuantity,MissingUnitPrice,MissingProduct,InvalidProduct,MissingPricingCode,InvalidPricingCode,MissingUOM,ProductNotInPriceLevel,MissingPriceLevelAmount,MissingPriceLevelPercentage,MissingPrice,MissingCurrentCost,MissingStandardCost,InvalidPriceLevelAmount,InvalidPriceLevelPercentage,InvalidPrice,InvalidCurrentCost,InvalidStandardCost,InvalidRoundingPolicy,InvalidRoundingOption,InvalidRoundingAmount,PriceCalculationError,InvalidDiscountType,DiscountTypeInvalidState,InvalidDiscount,InvalidQuantity,InvalidPricingPrecision,MissingProductDefaultUOM,MissingProductUOMSchedule,InactiveDiscountType,InvalidPriceLevelCurrency,PriceAttributeOutOfRange,BaseCurrencyAttributeOverflow,BaseCurrencyAttributeUnderflow] OptionOrdinalValues: [0;1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37] InitValue: None ExternalName: pricingerrorcode ExternalType: Picklist Description: Pricing error for the quote.
12	Description (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information to describe the quote, such as the products or services offered or details about the customer's product preferences.
13	DiscountAmount (DiscountAmount)	Decimal	ExternalName: discountamount ExternalType: Money Description: Type the discount amount for the quote if the customer is eligible for special savings.
14	FreightAmount (FreightAmount)	Decimal	ExternalName: freightamount ExternalType: Money Description: Type the cost of freight or shipping for the products included in the quote for use in calculating the Total Amount field.
15	TotalAmount (TotalAmount)	Decimal	ExternalName: totalamount ExternalType: Money ExternalAccess: Modify Description: Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the quote.
16	TotalLineItemAmount (TotalLineItemAmount)	Decimal	ExternalName: totallineitemamount ExternalType: Money ExternalAccess: Modify Description: Shows the sum of all existing and write-in products included on the quote, based on the specified price list and quantities.
17	TotalLineItemDiscountAmount (TotalLineItemDiscountAmount)	Decimal	ExternalName: totallineitemdiscountamount ExternalType: Money ExternalAccess: Modify Description: Shows the total of the Manual Discount amounts specified on all products included in the quote. This value is reflected in the Detail Amount field on the quote and is added to any discount amount or rate specified on the quote
18	TotalAmountLessFreight (TotalAmountLessFreight)	Decimal	ExternalName: totalamountlessfreight ExternalType: Money ExternalAccess: Modify Description: Shows the total product amount for the quote, minus any discounts. This value is added to freight and tax amounts in the calculation for the total amount due for the quote.
19	EffectiveFrom (EffectiveFrom)	Date	ExternalName: effectivefrom ExternalType: DateTime Description: Enter the date when the quote pricing is effective or was first communicated to the customer.
20	TotalTax (TotalTax)	Decimal	ExternalName: totaltax ExternalType: Money ExternalAccess: Modify Description: Shows the total of the Tax amounts specified on all products included in the quote, included in the Total Amount due calculation for the quote.
21	TotalDiscountAmount (TotalDiscountAmount)	Decimal	ExternalName: totaldiscountamount ExternalType: Money ExternalAccess: Modify Description: Shows the total discount amount, based on the discount price and rate entered on the quote.
22	EffectiveTo (EffectiveTo)	Date	ExternalName: effectiveto ExternalType: DateTime Description: Enter the expiration date or last day the quote pricing is effective for the customer.
23	ExpiresOn (ExpiresOn)	Date	ExternalName: expireson ExternalType: DateTime Description: Enter the date a decision or order is due from the customer to indicate the expiration date of the quote.
24	ClosedOn (ClosedOn)	Date	ExternalName: closedon ExternalType: DateTime Description: Enter the date when the quote was closed to indicate the expiration, revision, or cancellation date.
25	RequestDeliveryBy (RequestDeliveryBy)	Date	ExternalName: requestdeliveryby ExternalType: DateTime Description: Enter the delivery date requested by the customer for all products in the quote.
26	ShippingMethodCode (ShippingMethodCode)	Option	[ ,Airborne,DHL,FedEx,UPS,PostalMail,FullLoad,WillCall] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
27	PaymentTermsCode (PaymentTermsCode)	Option	[ ,Net30,2%10Net30,Net45,Net60] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: paymenttermscode ExternalType: Picklist Description: Select the payment terms to indicate when the customer needs to pay the total amount.
28	FreightTermsCode (FreightTermsCode)	Option	[ ,FOB,NoCharge] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: freighttermscode ExternalType: Picklist Description: Select the freight terms to make sure shipping charges are processed correctly.
29	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
30	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
31	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
32	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
33	StateCode (StateCode)	Option	[Draft,Active,Won,Closed] OptionOrdinalValues: [0;1;2;3] InitValue: Draft ExternalName: statecode ExternalType: State ExternalAccess: Modify Description: Shows whether the quote is draft, active, won, or closed. Only draft quotes can be edited.
34	StatusCode (StatusCode)	Option	[ ,InProgress,Open,Won,Lost,Canceled,Revised,InProgress1] OptionOrdinalValues: [-1;2;3;4;5;6;7;1] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Select the quote's status.
35	ShipTo_Name (ShipTo_Name)	Text200	ExternalName: shipto_name ExternalType: String Description: Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address.
36	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the quote.
37	ShipTo_Line1 (ShipTo_Line1)	Text250	ExternalName: shipto_line1 ExternalType: String Description: Type the first line of the customer's shipping address.
38	ShipTo_Line2 (ShipTo_Line2)	Text250	ExternalName: shipto_line2 ExternalType: String Description: Type the second line of the customer's shipping address.
39	ShipTo_Line3 (ShipTo_Line3)	Text250	ExternalName: shipto_line3 ExternalType: String Description: Type the third line of the shipping address.
40	ShipTo_City (ShipTo_City)	Text80	ExternalName: shipto_city ExternalType: String Description: Type the city for the customer's shipping address.
41	ShipTo_StateOrProvince (ShipTo_StateOrProvince)	Text50	ExternalName: shipto_stateorprovince ExternalType: String Description: Type the state or province for the shipping address.
42	ShipTo_Country (ShipTo_Country)	Text80	ExternalName: shipto_country ExternalType: String Description: Type the country or region for the customer's shipping address.
43	ShipTo_PostalCode (ShipTo_PostalCode)	Text20	ExternalName: shipto_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the shipping address.
44	WillCall (WillCall)	Boolean	ExternalName: willcall ExternalType: Boolean Description: Select whether the products included in the quote should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions.
45	ShipTo_Telephone (ShipTo_Telephone)	Text50	ExternalName: shipto_telephone ExternalType: String Description: Type the phone number for the customer's shipping address.
46	BillTo_Name (BillTo_Name)	Text200	ExternalName: billto_name ExternalType: String Description: Type a name for the customer's billing address, such as "Headquarters" or "Field office", to identify the address.
47	ShipTo_FreightTermsCode (ShipTo_FreightTermsCode)	Option	[ ,DefaultValue] OptionOrdinalValues: [-1;1] InitValue: [ ] ExternalName: shipto_freighttermscode ExternalType: Picklist Description: Select the freight terms to make sure shipping orders are processed correctly.
48	ShipTo_Fax (ShipTo_Fax)	Text50	ExternalName: shipto_fax ExternalType: String Description: Type the fax number for the customer's shipping address.
49	BillTo_Line1 (BillTo_Line1)	Text250	ExternalName: billto_line1 ExternalType: String Description: Type the first line of the customer's billing address.
50	BillTo_Line2 (BillTo_Line2)	Text250	ExternalName: billto_line2 ExternalType: String Description: Type the second line of the customer's billing address.
51	BillTo_Line3 (BillTo_Line3)	Text250	ExternalName: billto_line3 ExternalType: String Description: Type the third line of the billing address.
52	BillTo_City (BillTo_City)	Text80	ExternalName: billto_city ExternalType: String Description: Type the city for the customer's billing address.
53	BillTo_StateOrProvince (BillTo_StateOrProvince)	Text50	ExternalName: billto_stateorprovince ExternalType: String Description: Type the state or province for the billing address.
54	BillTo_Country (BillTo_Country)	Text80	ExternalName: billto_country ExternalType: String Description: Type the country or region for the customer's billing address.
55	BillTo_PostalCode (BillTo_PostalCode)	Text20	ExternalName: billto_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the billing address.
56	BillTo_Telephone (BillTo_Telephone)	Text50	ExternalName: billto_telephone ExternalType: String Description: Type the phone number for the customer's billing address.
57	BillTo_Fax (BillTo_Fax)	Text50	ExternalName: billto_fax ExternalType: String Description: Type the fax number for the customer's billing address.
58	DiscountPercentage (DiscountPercentage)	Decimal	ExternalName: discountpercentage ExternalType: Decimal Description: Type the discount rate that should be applied to the Detail Amount field to include additional savings for the customer in the quote.
59	ContactIdName (ContactIdName)	Text160	ExternalName: contactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ContactId)))	FlowField
60	AccountIdName (AccountIdName)	Text160	ExternalName: accountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(AccountId)))	FlowField
61	OpportunityIdName (OpportunityIdName)	Text250	ExternalName: opportunityidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Opportunity".Name WHERE (OpportunityId=FIELD(OpportunityId)))	FlowField
62	PriceLevelIdName (PriceLevelIdName)	Text100	ExternalName: pricelevelidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Pricelevel".Name WHERE (PriceLevelId=FIELD(PriceLevelId)))	FlowField
63	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
64	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
65	CustomerId (CustomerId)	GUID	ExternalName: customerid ExternalType: Customer Description: Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities. TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;
66	CustomerIdType (CustomerIdType)	Option	[ ,account,contact] ExternalName: customeridtype ExternalType: EntityName
67	OwnerId (OwnerId)	GUID	ExternalName: ownerid ExternalType: Owner Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
68	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
69	ShipTo_AddressId (ShipTo_AddressId)	GUID	ExternalName: shipto_addressid ExternalType: Uniqueidentifier Description: Unique identifier of the shipping address.
70	ShipTo_ContactName (ShipTo_ContactName)	Text150	ExternalName: shipto_contactname ExternalType: String Description: Type the primary contact name at the customer's shipping address.
71	BillTo_AddressId (BillTo_AddressId)	GUID	ExternalName: billto_addressid ExternalType: Uniqueidentifier Description: Unique identifier of the billing address.
72	BillTo_ContactName (BillTo_ContactName)	Text150	ExternalName: billto_contactname ExternalType: String Description: Type the primary contact name at the customer's billing address.
73	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
74	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
75	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
76	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
77	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
78	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
79	TotalLineItemDiscountAmount_Ba (TotalLineItemDiscountAmount_Ba)	Decimal	ExternalName: totallineitemdiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Line Item Discount Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
80	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
81	TotalAmountLessFreight_Base (TotalAmountLessFreight_Base)	Decimal	ExternalName: totalamountlessfreight_base ExternalType: Money ExternalAccess: Read Description: Shows the Pre-Freight Amount converted field to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
82	DiscountAmount_Base (DiscountAmount_Base)	Decimal	ExternalName: discountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Discount Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
83	FreightAmount_Base (FreightAmount_Base)	Decimal	ExternalName: freightamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Freight Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
84	TotalAmount_Base (TotalAmount_Base)	Decimal	ExternalName: totalamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
85	TotalDiscountAmount_Base (TotalDiscountAmount_Base)	Decimal	ExternalName: totaldiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Discount Amount converted field to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
86	TotalTax_Base (TotalTax_Base)	Decimal	ExternalName: totaltax_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
87	TotalLineItemAmount_Base (TotalLineItemAmount_Base)	Decimal	ExternalName: totallineitemamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Detail Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area.
88	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
89	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
90	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
91	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
92	OwningTeam (OwningTeam)	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the quote. TableRelation: "CRM Team".TeamId
93	BillTo_Composite (BillTo_Composite)	BLOB [Memo]	ExternalName: billto_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete Bill To address.
94	ShipTo_Composite (ShipTo_Composite)	BLOB [Memo]	ExternalName: shipto_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete Ship To address.
95	ProcessId (ProcessId)	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Shows the ID of the process.
96	StageId (StageId)	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
97	TraversedPath (TraversedPath)	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.

Keys

#	Fields
0	QuoteId (QuoteId)		Clustered: Yes
1	Name (Name)

Table Relations To Other Tables

Field	Related Table	Related Field
CustomerId (CustomerId)	CRM Account	AccountId (AccountId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OwningBusinessUnit (OwningBusinessUnit)	CRM Businessunit	BusinessUnitId (BusinessUnitId)	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CustomerId (CustomerId)	CRM Contact	ContactId (ContactId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OpportunityId (OpportunityId)	CRM Opportunity	OpportunityId (OpportunityId)	TableRelation: "CRM Opportunity".OpportunityId	1..n
PriceLevelId (PriceLevelId)	CRM Pricelevel	PriceLevelId (PriceLevelId)	TableRelation: "CRM Pricelevel".PriceLevelId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwningTeam (OwningTeam)	CRM Team	TeamId (TeamId)	TableRelation: "CRM Team".TeamId	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n
CRM Quotedetail	QuoteId (QuoteId)	TableRelation: "CRM Quote".QuoteId	1..n
CRM Salesorder	QuoteId (QuoteId)	TableRelation: "CRM Quote".QuoteId	1..n

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

CRM Quote

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables