Quote Product (QuoteDetail) entity reference
Product line item in a quote. The details include such information as product ID, description, quantity, and cost.
Added by: Sales Solution
Messages
Message | SDK class or method |
---|---|
CalculatePrice | CalculatePriceRequest |
Create | CreateRequest or Create |
Delete | DeleteRequest or Delete |
Retrieve | RetrieveRequest or Retrieve |
RetrieveMultiple | RetrieveMultipleRequest or RetrieveMultiple |
Update | UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | QuoteDetails |
DisplayCollectionName | Quote Products |
DisplayName | Quote Product |
EntitySetName | quotedetails |
IsBPFEntity | False |
LogicalCollectionName | quotedetails |
LogicalName | quotedetail |
OwnershipType | UserOwned |
PrimaryIdAttribute | quotedetailid |
PrimaryNameAttribute | quotedetailname |
SchemaName | QuoteDetail |
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BaseAmount
- Description
- ExtendedAmount
- ImportSequenceNumber
- IsPriceOverridden
- IsProductOverridden
- LineItemNumber
- ManualDiscountAmount
- OverriddenCreatedOn
- ParentBundleId
- ParentBundleIdRef
- PricePerUnit
- PricingErrorCode
- ProductAssociationId
- ProductDescription
- ProductId
- ProductName
- ProductTypeCode
- PropertyConfigurationStatus
- Quantity
- QuoteDetailId
- QuoteDetailName
- QuoteId
- RequestDeliveryBy
- SalesRepId
- SequenceNumber
- ShipTo_AddressId
- ShipTo_City
- ShipTo_ContactName
- ShipTo_Country
- ShipTo_Fax
- ShipTo_FreightTermsCode
- ShipTo_Line1
- ShipTo_Line2
- ShipTo_Line3
- ShipTo_Name
- ShipTo_PostalCode
- ShipTo_StateOrProvince
- ShipTo_Telephone
- Tax
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UoMId
- UTCConversionTimeZoneCode
- WillCall
BaseAmount
Property | Value |
---|---|
Description | Shows the total price of the quote product, based on the price per unit, volume discount, and quantity. |
DisplayName | Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | baseamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
Description
Property | Value |
---|---|
Description | Type additional information to describe the quote product, such as manufacturing details or acceptable substitutions. |
DisplayName | Description |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
ExtendedAmount
Property | Value |
---|---|
Description | Shows the total amount due for the quote product, based on the sum of the unit price, quantity, discounts ,and tax. |
DisplayName | Extended Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | extendedamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ImportSequenceNumber
Property | Value |
---|---|
Description | Sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importsequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
IsPriceOverridden
Property | Value |
---|---|
Description | Select whether the price per unit is fixed at the value in the specified price list or can be overridden by users who have edit rights to the quote product. |
DisplayName | Price Overridden |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ispriceoverridden |
RequiredLevel | None |
Type | Boolean |
IsPriceOverridden Choices/Options
Value | Label | Description |
---|---|---|
1 | Override Price | |
0 | Use Default |
DefaultValue: 0
IsProductOverridden
Property | Value |
---|---|
Description | Select whether the product exists in the Microsoft Dynamics 365 product catalog or is a write-in product specific to the quote. |
DisplayName | Select Product |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | isproductoverridden |
RequiredLevel | None |
Type | Boolean |
IsProductOverridden Choices/Options
Value | Label | Description |
---|---|---|
1 | Write In | |
0 | Existing |
DefaultValue: 0
LineItemNumber
Property | Value |
---|---|
Description | Type the line item number for the quote product to easily identify the product in the quote and make sure it's listed in the correct order. |
DisplayName | Line Item Number |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | lineitemnumber |
MaxValue | 1000000000 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
ManualDiscountAmount
Property | Value |
---|---|
Description | Type the manual discount amount for the quote product to deduct any negotiated or other savings from the product total on the quote. |
DisplayName | Manual Discount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | manualdiscountamount |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
OverriddenCreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
ParentBundleId
Property | Value |
---|---|
Description | Choose the parent bundle associated with this product |
DisplayName | Parent Bundle |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | parentbundleid |
RequiredLevel | None |
Type | Uniqueidentifier |
ParentBundleIdRef
Added by: Sales Patch Solution
Property | Value |
---|---|
Description | Choose the parent bundle associated with this product |
DisplayName | Parent bundle product |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | parentbundleidref |
RequiredLevel | None |
Targets | quotedetail |
Type | Lookup |
PricePerUnit
Property | Value |
---|---|
Description | Type the price per unit of the quote product. The default is to the value in the price list specified on the quote for existing products. |
DisplayName | Price Per Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | priceperunit |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 1 |
RequiredLevel | None |
Type | Money |
PricingErrorCode
Property | Value |
---|---|
Description | Select the type of pricing error, such as a missing or invalid product, or missing quantity. |
DisplayName | Pricing Error |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pricingerrorcode |
RequiredLevel | None |
Type | Picklist |
PricingErrorCode Choices/Options
Value | Label | Description |
---|---|---|
0 | None | |
1 | Detail Error | |
2 | Missing Price Level | |
3 | Inactive Price Level | |
4 | Missing Quantity | |
5 | Missing Unit Price | |
6 | Missing Product | |
7 | Invalid Product | |
8 | Missing Pricing Code | |
9 | Invalid Pricing Code | |
10 | Missing UOM | |
11 | Product Not In Price Level | |
12 | Missing Price Level Amount | |
13 | Missing Price Level Percentage | |
14 | Missing Price | |
15 | Missing Current Cost | |
16 | Missing Standard Cost | |
17 | Invalid Price Level Amount | |
18 | Invalid Price Level Percentage | |
19 | Invalid Price | |
20 | Invalid Current Cost | |
21 | Invalid Standard Cost | |
22 | Invalid Rounding Policy | |
23 | Invalid Rounding Option | |
24 | Invalid Rounding Amount | |
25 | Price Calculation Error | |
26 | Invalid Discount Type | |
27 | Discount Type Invalid State | |
28 | Invalid Discount | |
29 | Invalid Quantity | |
30 | Invalid Pricing Precision | |
31 | Missing Product Default UOM | |
32 | Missing Product UOM Schedule | |
33 | Inactive Discount Type | |
34 | Invalid Price Level Currency | |
35 | Price Attribute Out Of Range | |
36 | Base Currency Attribute Overflow | |
37 | Base Currency Attribute Underflow |
ProductAssociationId
Property | Value |
---|---|
Description | Unique identifier of the product line item association with bundle in the quote |
DisplayName | Bundle Item Association |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | productassociationid |
RequiredLevel | None |
Type | Uniqueidentifier |
ProductDescription
Property | Value |
---|---|
Description | Type a name or description to identify the type of write-in product included in the quote. |
DisplayName | Write-In Product |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | productdescription |
MaxLength | 500 |
RequiredLevel | None |
Type | String |
ProductId
Property | Value |
---|---|
Description | Choose the product to include on the quote to link the product's pricing and other information to the quote. |
DisplayName | Existing Product |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | productid |
RequiredLevel | None |
Targets | product |
Type | Lookup |
ProductName
Property | Value |
---|---|
Description | Calculated field that will be populated by name and description of the product. |
DisplayName | Product Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | productname |
MaxLength | 500 |
RequiredLevel | None |
Type | String |
ProductTypeCode
Property | Value |
---|---|
Description | Product Type |
DisplayName | Product type |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | producttypecode |
RequiredLevel | SystemRequired |
Type | Picklist |
ProductTypeCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Product | |
2 | Bundle | |
3 | Required Bundle Product | |
4 | Optional Bundle Product | |
5 | Project-based Service |
PropertyConfigurationStatus
Property | Value |
---|---|
Description | Status of the property configuration. |
DisplayName | Property Configuration |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | propertyconfigurationstatus |
RequiredLevel | SystemRequired |
Type | Picklist |
PropertyConfigurationStatus Choices/Options
Value | Label | Description |
---|---|---|
0 | Edit | |
1 | Rectify | |
2 | Not Configured |
Quantity
Property | Value |
---|---|
Description | Type the amount or quantity of the product requested by the customer. |
DisplayName | Quantity |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quantity |
MaxValue | 100000000000 |
MinValue | -100000000000 |
Precision | 5 |
RequiredLevel | ApplicationRequired |
Type | Decimal |
QuoteDetailId
Property | Value |
---|---|
Description | Unique identifier of the product line item in the quote. |
DisplayName | Quote Product |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | quotedetailid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
QuoteDetailName
Added by: Sales Patch Solution
Property | Value |
---|---|
Description | Quote Detail Name. Added for 1:n Referential relationship |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quotedetailname |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
QuoteId
Property | Value |
---|---|
Description | Unique identifier of the quote for the quote product. |
DisplayName | Quote |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quoteid |
RequiredLevel | SystemRequired |
Targets | quote |
Type | Lookup |
RequestDeliveryBy
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the delivery date requested by the customer for the quote product. |
DisplayName | Requested Delivery Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | requestdeliveryby |
RequiredLevel | None |
Type | DateTime |
SalesRepId
Property | Value |
---|---|
Description | Choose the user responsible for the sale of the quote product. |
DisplayName | Salesperson |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | salesrepid |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
SequenceNumber
Property | Value |
---|---|
Description | Unique identifier of the data that maintains the sequence. |
DisplayName | Sequence Number |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
ShipTo_AddressId
Property | Value |
---|---|
Description | Unique identifier of the shipping address. |
DisplayName | Ship To Address ID |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | shipto_addressid |
RequiredLevel | None |
Type | Uniqueidentifier |
ShipTo_City
Property | Value |
---|---|
Description | Type the city for the customer's shipping address. |
DisplayName | Ship To City |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_city |
MaxLength | 80 |
RequiredLevel | None |
Type | String |
ShipTo_ContactName
Property | Value |
---|---|
Description | Type the primary contact name at the customer's shipping address. |
DisplayName | Ship To Contact Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_contactname |
MaxLength | 150 |
RequiredLevel | None |
Type | String |
ShipTo_Country
Property | Value |
---|---|
Description | Type the country or region for the customer's shipping address. |
DisplayName | Ship To Country/Region |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_country |
MaxLength | 80 |
RequiredLevel | None |
Type | String |
ShipTo_Fax
Property | Value |
---|---|
Description | Type the fax number for the customer's shipping address. |
DisplayName | Ship To Fax |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_fax |
MaxLength | 50 |
RequiredLevel | None |
Type | String |
ShipTo_FreightTermsCode
Property | Value |
---|---|
Description | Select the freight terms to make sure shipping orders are processed correctly. |
DisplayName | Freight Terms |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_freighttermscode |
RequiredLevel | None |
Type | Picklist |
ShipTo_FreightTermsCode Choices/Options
Value | Label | Description |
---|---|---|
1 | FOB | |
2 | No Charge |
ShipTo_Line1
Property | Value |
---|---|
Description | Type the first line of the customer's shipping address. |
DisplayName | Ship To Street 1 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_line1 |
MaxLength | 250 |
RequiredLevel | None |
Type | String |
ShipTo_Line2
Property | Value |
---|---|
Description | Type the second line of the customer's shipping address. |
DisplayName | Ship To Street 2 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_line2 |
MaxLength | 250 |
RequiredLevel | None |
Type | String |
ShipTo_Line3
Property | Value |
---|---|
Description | Type the third line of the shipping address. |
DisplayName | Ship To Street 3 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_line3 |
MaxLength | 250 |
RequiredLevel | None |
Type | String |
ShipTo_Name
Property | Value |
---|---|
Description | Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address. |
DisplayName | Ship To Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_name |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
ShipTo_PostalCode
Property | Value |
---|---|
Description | Type the ZIP Code or postal code for the shipping address. |
DisplayName | Ship To ZIP/Postal Code |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_postalcode |
MaxLength | 20 |
RequiredLevel | None |
Type | String |
ShipTo_StateOrProvince
Property | Value |
---|---|
Description | Type the state or province for the shipping address. |
DisplayName | Ship To State/Province |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_stateorprovince |
MaxLength | 50 |
RequiredLevel | None |
Type | String |
ShipTo_Telephone
Property | Value |
---|---|
Description | Type the phone number for the customer's shipping address. |
DisplayName | Ship To Phone |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_telephone |
MaxLength | 50 |
RequiredLevel | None |
Type | String |
Tax
Property | Value |
---|---|
Description | Type the tax amount for the quote product. |
DisplayName | Tax |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | tax |
MaxValue | 1000000000000 |
MinValue | -1000000000000 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
TransactionCurrencyId
Property | Value |
---|---|
Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | transactioncurrencyid |
RequiredLevel | None |
Targets | transactioncurrency |
Type | Lookup |
UoMId
Property | Value |
---|---|
Description | Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. |
DisplayName | Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | uomid |
RequiredLevel | None |
Targets | uom |
Type | Lookup |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
WillCall
Property | Value |
---|---|
Description | Select whether the quote product should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions. |
DisplayName | Ship To |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | willcall |
RequiredLevel | None |
Type | Boolean |
WillCall Choices/Options
Value | Label | Description |
---|---|---|
1 | Will Call | |
0 | Address |
DefaultValue: 0
Read-only attributes
These attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- BaseAmount_Base
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- ExtendedAmount_Base
- ManualDiscountAmount_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerId
- OwnerIdName
- OwnerIdType
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PricePerUnit_Base
- ProductIdName
- QuoteIdName
- QuoteStateCode
- SalesRepIdName
- SalesRepIdYomiName
- Tax_Base
- TransactionCurrencyIdName
- UoMIdName
- VersionNumber
- VolumeDiscountAmount
- VolumeDiscountAmount_Base
BaseAmount_Base
Property | Value |
---|---|
Description | Value of the Amount in base currency. |
DisplayName | Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | baseamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ExchangeRate
Added by: Active Solution Solution
Property | Value |
---|---|
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. |
DisplayName | Exchange Rate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
MaxValue | 100000000000 |
MinValue | 0.0000000001 |
Precision | 10 |
RequiredLevel | None |
Type | Decimal |
ExtendedAmount_Base
Property | Value |
---|---|
Description | Value of the Extended Amount in base currency. |
DisplayName | Extended Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | extendedamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ManualDiscountAmount_Base
Property | Value |
---|---|
Description | Value of the Manual Discount in base currency. |
DisplayName | Manual Discount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | manualdiscountamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Shows who last updated the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OwnerId
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | ApplicationRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdType
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningBusinessUnit
Property | Value |
---|---|
Description | Unique identifier for the business unit that owns the record |
DisplayName | Owning Business Unit |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | ApplicationRequired |
Targets | |
Type | Lookup |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier for the team that owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier for the user that owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | ApplicationRequired |
Targets | |
Type | Lookup |
PricePerUnit_Base
Property | Value |
---|---|
Description | Value of the Price Per Unit in base currency. |
DisplayName | Price Per Unit (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | priceperunit_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 1 |
RequiredLevel | None |
Type | Money |
ProductIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | productidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
QuoteIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quoteidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
QuoteStateCode
Property | Value |
---|---|
Description | Status of the quote product. |
DisplayName | Quote Status |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quotestatecode |
RequiredLevel | SystemRequired |
Type | Picklist |
QuoteStateCode Choices/Options
Value | Label | Description |
---|
SalesRepIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | salesrepidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
SalesRepIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | salesrepidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Tax_Base
Property | Value |
---|---|
Description | Value of the Tax in base currency. |
DisplayName | Tax (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | tax_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
UoMIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | uomidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
VersionNumber
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
VolumeDiscountAmount
Property | Value |
---|---|
Description | Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. |
DisplayName | Volume Discount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | volumediscountamount |
MaxValue | 922337203685477 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
VolumeDiscountAmount_Base
Property | Value |
---|---|
Description | Value of the Volume Discount in base currency. |
DisplayName | Volume Discount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | volumediscountamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
One-To-Many Relationships
Listed by SchemaName.
- QuoteDetail_SyncErrors
- QuoteDetail_AsyncOperations
- quotedetail_MailboxTrackingFolders
- QuoteDetail_ProcessSessions
- QuoteDetail_BulkDeleteFailures
- quotedetail_principalobjectattributeaccess
- QuoteDetail_Dynamicpropertyinstance
- quotedetail_parent_quotedetail
- msdyn_quotedetail_salesorderdetail
- quotedetail_parentref_quotedetail
QuoteDetail_SyncErrors
Added by: System Solution Solution
Same as the QuoteDetail_SyncErrors many-to-one relationship for the syncerror entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | QuoteDetail_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
QuoteDetail_AsyncOperations
Added by: System Solution Solution
Same as the QuoteDetail_AsyncOperations many-to-one relationship for the asyncoperation entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | QuoteDetail_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
quotedetail_MailboxTrackingFolders
Added by: System Solution Solution
Same as the quotedetail_MailboxTrackingFolders many-to-one relationship for the mailboxtrackingfolder entity.
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | quotedetail_MailboxTrackingFolders |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
QuoteDetail_ProcessSessions
Added by: System Solution Solution
Same as the QuoteDetail_ProcessSessions many-to-one relationship for the processsession entity.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | QuoteDetail_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
QuoteDetail_BulkDeleteFailures
Added by: System Solution Solution
Same as the QuoteDetail_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | QuoteDetail_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
quotedetail_principalobjectattributeaccess
Added by: System Solution Solution
Same as the quotedetail_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess entity.
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | quotedetail_principalobjectattributeaccess |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
QuoteDetail_Dynamicpropertyinstance
Same as the QuoteDetail_Dynamicpropertyinstance many-to-one relationship for the dynamicpropertyinstance entity.
Property | Value |
---|---|
ReferencingEntity | dynamicpropertyinstance |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | QuoteDetail_Dynamicpropertyinstance |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: Cascade Unshare: NoCascade |
quotedetail_parent_quotedetail
Same as the quotedetail_parent_quotedetail many-to-one relationship for the quotedetail entity.
Property | Value |
---|---|
ReferencingEntity | quotedetail |
ReferencingAttribute | parentbundleid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | quotedetail_parent_quotedetail |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_quotedetail_salesorderdetail
Added by: Sales Patch Solution
Same as the msdyn_quotedetail_salesorderdetail many-to-one relationship for the salesorderdetail entity.
Property | Value |
---|---|
ReferencingEntity | salesorderdetail |
ReferencingAttribute | quotedetailid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | msdyn_quotedetail_salesorderdetail |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
quotedetail_parentref_quotedetail
Added by: Sales Patch Solution
Same as the quotedetail_parentref_quotedetail many-to-one relationship for the quotedetail entity.
Property | Value |
---|---|
ReferencingEntity | quotedetail |
ReferencingAttribute | parentbundleidref |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | quotedetail_parentref_quotedetail |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName.
- lk_quotedetailbase_createdby
- lk_quotedetail_createdonbehalfby
- lk_quotedetailbase_modifiedby
- lk_quotedetail_modifiedonbehalfby
- user_quotedetail
- team_quotedetail
- transactioncurrency_quotedetail
- product_quote_details
- productAssociation_quote_details
- quote_details
- quotedetail_parent_quotedetail
- system_user_quotedetail
- unit_of_measurement_quote_details
- quotedetail_parentref_quotedetail
lk_quotedetailbase_createdby
Added by: System Solution Solution
See the lk_quotedetailbase_createdby one-to-many relationship for the systemuser entity.
lk_quotedetail_createdonbehalfby
Added by: System Solution Solution
See the lk_quotedetail_createdonbehalfby one-to-many relationship for the systemuser entity.
lk_quotedetailbase_modifiedby
Added by: System Solution Solution
See the lk_quotedetailbase_modifiedby one-to-many relationship for the systemuser entity.
lk_quotedetail_modifiedonbehalfby
Added by: System Solution Solution
See the lk_quotedetail_modifiedonbehalfby one-to-many relationship for the systemuser entity.
user_quotedetail
Added by: System Solution Solution
See the user_quotedetail one-to-many relationship for the systemuser entity.
team_quotedetail
Added by: System Solution Solution
See the team_quotedetail one-to-many relationship for the team entity.
transactioncurrency_quotedetail
Added by: System Solution Solution
See the transactioncurrency_quotedetail one-to-many relationship for the transactioncurrency entity.
product_quote_details
Added by: Product Management Solution
See the product_quote_details one-to-many relationship for the product entity.
productAssociation_quote_details
Added by: Product Management Solution
See the productAssociation_quote_details one-to-many relationship for the productassociation entity.
quote_details
See the quote_details one-to-many relationship for the quote entity.
quotedetail_parent_quotedetail
See the quotedetail_parent_quotedetail one-to-many relationship for the quotedetail entity.
system_user_quotedetail
Added by: System Solution Solution
See the system_user_quotedetail one-to-many relationship for the systemuser entity.
unit_of_measurement_quote_details
Added by: Product Management Solution
See the unit_of_measurement_quote_details one-to-many relationship for the uom entity.
quotedetail_parentref_quotedetail
See the quotedetail_parentref_quotedetail one-to-many relationship for the quotedetail entity.