Edit

Share via

Quote table/entity reference (Microsoft Dynamics 365 Field Service)

Formal offer for products and/or services, proposed at specific prices and related payment terms, which is sent to a prospective customer.

Note

The Microsoft Dynamics 365 Field Service Quote table extends the Microsoft Dynamics 365 Quote table.

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

msdyn_Account

Property Value
Description Customer Account associated with this Quote
DisplayName Potential Customer
IsValidForForm True
IsValidForRead True
LogicalName msdyn_account
RequiredLevel None
Type Lookup
Targets account

msdyn_EstimatedCost

Property Value
Description The estimated cost of this quote
DisplayName Estimated Cost
IsValidForForm True
IsValidForRead True
LogicalName msdyn_estimatedcost
RequiredLevel None
Type Money
ImeMode Auto
IsBaseCurrency False
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2 (TransactionCurrency.CurrencyPrecision)

msdyn_InvoiceSetupTotals

Property Value
Description The totals of all assigned Invoice Setups
DisplayName Invoice Setup Totals
IsValidForForm True
IsValidForRead True
LogicalName msdyn_invoicesetuptotals
RequiredLevel None
Type Money
ImeMode Auto
IsBaseCurrency False
MaxValue 922337203685477
MinValue 0
Precision 4
PrecisionSource 2 (TransactionCurrency.CurrencyPrecision)

msdyn_OrderType

Property Value
Description Internal use only.
DisplayName Order Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_ordertype
RequiredLevel Recommended
Type Picklist
DefaultFormValue 192350000
GlobalChoiceName msdyn_quote_msdyn_ordertype

msdyn_OrderType Choices/Options

Value Label
192350000 Item based
690970002 Service-Maintenance Based

msdyn_QuoteLineEndDate

Property Value
Description The latest end date of all associated quote lines
DisplayName Latest Quote Line End Date
IsValidForForm True
IsValidForRead True
LogicalName msdyn_quotelineenddate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Auto
SourceTypeMask 0

msdyn_QuoteLineStartDate

Property Value
Description The earliest Start Date of all Quote Lines that are associated to this quote
DisplayName Earliest Quote Line Start Date
IsValidForForm True
IsValidForRead True
LogicalName msdyn_quotelinestartdate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Auto
SourceTypeMask 0

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

msdyn_estimatedcost_Base

Property Value
Description Value of the Estimated Cost in base currency.
DisplayName Estimated Cost (Base)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_estimatedcost_base
RequiredLevel None
Type Money
ImeMode Disabled
IsBaseCurrency True
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2 (TransactionCurrency.CurrencyPrecision)

msdyn_EstimatedQuoteMargin

Property Value
Description Estimated Margin of this quote
DisplayName Estimated Margin
IsValidForForm True
IsValidForRead True
LogicalName msdyn_estimatedquotemargin
RequiredLevel None
Type Decimal
ImeMode Auto
MaxValue 100000000000
MinValue -100000000000
Precision 2
SourceTypeMask 8

msdyn_invoicesetuptotals_Base

Property Value
Description Value of the Invoice Setup Totals in base currency.
DisplayName Invoice Setup Totals (Base)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_invoicesetuptotals_base
RequiredLevel None
Type Money
ImeMode Disabled
IsBaseCurrency True
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2 (TransactionCurrency.CurrencyPrecision)

msdyn_TotalAmount

Property Value
Description
DisplayName TotalAmount
IsValidForForm True
IsValidForRead True
LogicalName msdyn_totalamount
RequiredLevel None
Type Money
ImeMode Auto
IsBaseCurrency False
MaxValue 922337203685477
MinValue -922337203685477
Precision 2
PrecisionSource 2 (TransactionCurrency.CurrencyPrecision)

msdyn_totalamount_Base

Property Value
Description Value of the TotalAmount in base currency.
DisplayName TotalAmount (Base)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_totalamount_base
RequiredLevel None
Type Money
ImeMode Disabled
IsBaseCurrency True
MaxValue 922337203685477
MinValue -922337203685477
Precision 2
PrecisionSource 2 (TransactionCurrency.CurrencyPrecision)

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

msdyn_account_quote_Account

One-To-Many Relationship: account msdyn_account_quote_Account

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute msdyn_account
ReferencingEntityNavigationPropertyName msdyn_account
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

quote_msdyn_bookingalerts

Many-To-One Relationship: msdyn_bookingalert quote_msdyn_bookingalerts

Property Value
ReferencingEntity msdyn_bookingalert
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName quote_msdyn_bookingalerts
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference