Table "CRM Quote"
ID 5351
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | CRM Quote |
| Description | Formal offer for products and/or services, proposed at specific prices and related payment terms, which is sent to a prospective customer. |
| ExternalName | quote |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| QuoteId | Guid | |
| OwningBusinessUnit | Guid | |
| OwningUser | Guid | |
| PriceLevelId | Guid | |
| OpportunityId | Guid | |
| AccountId | Guid | |
| ContactId | Guid | |
| QuoteNumber | Text[100] | |
| RevisionNumber | Integer | |
| Name | Text[2048] | |
| PricingErrorCode | Option | |
| Description | Blob | |
| DiscountAmount | Decimal | |
| FreightAmount | Decimal | |
| TotalAmount | Decimal | |
| TotalLineItemAmount | Decimal | |
| TotalLineItemDiscountAmount | Decimal | |
| TotalAmountLessFreight | Decimal | |
| EffectiveFrom | Date | |
| TotalTax | Decimal | |
| TotalDiscountAmount | Decimal | |
| EffectiveTo | Date | |
| ExpiresOn | Date | |
| ClosedOn | Date | |
| RequestDeliveryBy | Date | |
| CreatedBy | Guid | |
| CreatedOn | DateTime | |
| ModifiedBy | Guid | |
| ModifiedOn | DateTime | |
| StateCode | Option | |
| StatusCode | Option | |
| ShipTo_Name | Text[200] | |
| VersionNumber | BigInteger | |
| ShipTo_Line1 | Text[250] | |
| ShipTo_Line2 | Text[250] | |
| ShipTo_Line3 | Text[250] | |
| ShipTo_City | Text[80] | |
| ShipTo_StateOrProvince | Text[50] | |
| ShipTo_Country | Text[80] | |
| ShipTo_PostalCode | Text[20] | |
| WillCall | Boolean | |
| ShipTo_Telephone | Text[50] | |
| BillTo_Name | Text[200] | |
| ShipTo_FreightTermsCode | Option | |
| ShipTo_Fax | Text[50] | |
| BillTo_Line1 | Text[250] | |
| BillTo_Line2 | Text[250] | |
| BillTo_Line3 | Text[250] | |
| BillTo_City | Text[80] | |
| BillTo_StateOrProvince | Text[50] | |
| BillTo_Country | Text[80] | |
| BillTo_PostalCode | Text[20] | |
| BillTo_Telephone | Text[50] | |
| BillTo_Fax | Text[50] | |
| DiscountPercentage | Decimal | |
| ContactIdName | Text[160] | |
| AccountIdName | Text[160] | |
| OpportunityIdName | Text[2048] | |
| PriceLevelIdName | Text[100] | |
| CreatedByName | Text[200] | |
| ModifiedByName | Text[200] | |
| CustomerId | Guid | |
| CustomerIdType | Option | |
| OwnerId | Guid | |
| OwnerIdType | Option | |
| ShipTo_AddressId | Guid | |
| ShipTo_ContactName | Text[150] | |
| BillTo_AddressId | Guid | |
| BillTo_ContactName | Text[150] | |
| TimeZoneRuleVersionNumber | Integer | |
| ImportSequenceNumber | Integer | |
| ExchangeRate | Decimal | |
| OverriddenCreatedOn | Date | |
| UTCConversionTimeZoneCode | Integer | |
| TransactionCurrencyId | Guid | |
| TotalLineItemDiscountAmount_Ba | Decimal | |
| TransactionCurrencyIdName | Text[100] | |
| TotalAmountLessFreight_Base | Decimal | |
| DiscountAmount_Base | Decimal | |
| FreightAmount_Base | Decimal | |
| TotalAmount_Base | Decimal | |
| TotalDiscountAmount_Base | Decimal | |
| TotalTax_Base | Decimal | |
| TotalLineItemAmount_Base | Decimal | |
| CreatedOnBehalfBy | Guid | |
| CreatedOnBehalfByName | Text[200] | |
| ModifiedOnBehalfBy | Guid | |
| ModifiedOnBehalfByName | Text[200] | |
| OwningTeam | Guid | |
| BillTo_Composite | Blob | |
| ShipTo_Composite | Blob | |
| ProcessId | Guid | |
| StageId | Guid | |
| TraversedPath | Text[250] | |
| CompanyId | Guid | |
| PaymentTermsCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Payment Terms Code" | |
| ShippingMethodCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Shipping Agent Code" | |
| FreightTermsCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Shipment Method Code" | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |