Table 5351 "CRM Quote"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Quote
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	QuoteId	Guid	Quote caption
2	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
3	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	PriceLevelId	Guid	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
5	OpportunityId	Guid	Opportunity caption	TableRelation Table 5343 “CRM Opportunity” (“CRM Opportunity”.OpportunityId)
6	AccountId	Guid	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
7	ContactId	Guid	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
8	QuoteNumber	Text[100]	Quote ID caption
9	RevisionNumber	Integer	Revision ID caption
10	Name Δ BC28	Text[2048]	Specifies the name of the record.
11	PricingErrorCode	Option	Pricing Error caption	OptionCaption: None,Detail Error,Missing Price Level,Inactive Price Level,Missing Quantity,Missing Unit Price,Missing Product,Invalid Product,Missing Pricing Code,Invalid Pricing Code,Missing UOM,Product Not In Price Level,Missing Price Level Amount,Missing Price Level Percentage,Missing Price,Missing Current Cost…
12	Description	BLOB	—
13	DiscountAmount Δ BC28	Decimal	Quote Discount Amount caption
14	FreightAmount Δ BC28	Decimal	Freight Amount caption
15	TotalAmount Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
16	TotalLineItemAmount Δ BC28	Decimal	Total Detail Amount caption
17	TotalLineItemDiscountAmount Δ BC28	Decimal	Total Line Item Discount Amount caption
18	TotalAmountLessFreight Δ BC28	Decimal	Total Pre-Freight Amount caption
19	EffectiveFrom Δ BC28	Date	Specifies which date the sales quote is valid from.
20	TotalTax Δ BC28	Decimal	Total Tax caption
21	TotalDiscountAmount Δ BC28	Decimal	Total Discount Amount caption
22	EffectiveTo Δ BC28	Date	Specifies which date the sales quote is valid to.
23	ExpiresOn	Date	Due By caption
24	ClosedOn Δ BC28	Date	Specifies the date when quote was closed.
25	RequestDeliveryBy	Date	Requested Delivery Date caption
29	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
30	CreatedOn	DateTime	Created On caption
31	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
32	ModifiedOn	DateTime	Modified On caption
33	StateCode Δ BC28	Option	Specifies information related to the Dynamics 365 Sales connection.	OptionCaption: Draft,Active,Won,Closed
34	StatusCode	Option	Status Reason caption	OptionCaption: ,In Progress,Open,Won,Lost,Canceled,Revised,In Progress1
35	ShipTo_Name	Text[200]	Ship To Name caption
36	VersionNumber	BigInteger	Version Number caption
37	ShipTo_Line1	Text[250]	Ship To Street 1 caption
38	ShipTo_Line2	Text[250]	Ship To Street 2 caption
39	ShipTo_Line3	Text[250]	Ship To Street 3 caption
40	ShipTo_City	Text[80]	Ship To City caption
41	ShipTo_StateOrProvince	Text[50]	Ship To State/Province caption
42	ShipTo_Country	Text[80]	Ship To Country/Region caption
43	ShipTo_PostalCode	Text[20]	Ship To ZIP/Postal Code caption
44	WillCall	Boolean	Ship To caption
45	ShipTo_Telephone	Text[50]	Ship To Phone caption
46	BillTo_Name	Text[200]	Bill To Name caption
47	ShipTo_FreightTermsCode	Option	Ship To Freight Terms caption	OptionCaption: ,Default Value
48	ShipTo_Fax	Text[50]	Ship To Fax caption
49	BillTo_Line1	Text[250]	Bill To Street 1 caption
50	BillTo_Line2	Text[250]	Bill To Street 2 caption
51	BillTo_Line3	Text[250]	Bill To Street 3 caption
52	BillTo_City	Text[80]	Bill To City caption
53	BillTo_StateOrProvince	Text[50]	Bill To State/Province caption
54	BillTo_Country	Text[80]	Bill To Country/Region caption
55	BillTo_PostalCode	Text[20]	Bill To ZIP/Postal Code caption
56	BillTo_Telephone	Text[50]	Bill To Phone caption
57	BillTo_Fax	Text[50]	Bill To Fax caption
58	DiscountPercentage Δ BC28	Decimal	Quote Discount (%) caption
59	ContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ContactId)))
60	AccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
61	OpportunityIdName Δ BC24	Text[2048]	—	FlowField: lookup(“CRM Opportunity”.Name where(OpportunityId = field(OpportunityId)))
62	PriceLevelIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(PriceLevelId)))
63	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
64	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
65	CustomerId	Guid	Potential Customer caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (CustomerIdType = const(account)) “CRM Account”.AccountId else if (CustomerIdType = const(contact)) “CRM Contact”.ContactId)
66	CustomerIdType	Option	Potential Customer Type caption	OptionCaption: ,account,contact
67	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
68	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
69	ShipTo_AddressId	Guid	Ship To Address ID caption
70	ShipTo_ContactName	Text[150]	Ship To Contact Name caption
71	BillTo_AddressId	Guid	Bill To Address ID caption
72	BillTo_ContactName	Text[150]	Bill To Contact Name caption
73	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
74	ImportSequenceNumber	Integer	Import Sequence Number caption
75	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
76	OverriddenCreatedOn	Date	Record Created On caption
77	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
78	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
79	TotalLineItemDiscountAmount_Ba Δ BC28	Decimal	Total Line Item Discount Amount (Base) caption
80	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
81	TotalAmountLessFreight_Base Δ BC28	Decimal	Total Pre-Freight Amount (Base) caption
82	DiscountAmount_Base Δ BC28	Decimal	Quote Discount Amount (Base) caption
83	FreightAmount_Base Δ BC28	Decimal	Freight Amount (Base) caption
84	TotalAmount_Base Δ BC28	Decimal	Total Amount (Base) caption
85	TotalDiscountAmount_Base Δ BC28	Decimal	Total Discount Amount (Base) caption
86	TotalTax_Base Δ BC28	Decimal	Total Tax (Base) caption
87	TotalLineItemAmount_Base Δ BC28	Decimal	Total Detail Amount (Base) caption
88	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
89	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
90	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
91	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
92	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
93	BillTo_Composite	BLOB	Bill To Address caption
94	ShipTo_Composite	BLOB	Ship To Address caption
95	ProcessId	Guid	Process caption
96	StageId	Guid	Process Stage caption
97	TraversedPath	Text[250]	Traversed Path caption
98	CompanyId	Guid	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
99	PaymentTermsCodeEnum	Enum “CDS Payment Terms Code”	Payment Terms caption	enum Enum 5334 “CDS Payment Terms Code”
100	ShippingMethodCodeEnum	Enum “CDS Shipping Agent Code”	Shipping Method caption	enum Enum 5336 “CDS Shipping Agent Code”
101	FreightTermsCodeEnum	Enum “CDS Shipment Method Code”	Freight Terms caption	enum Enum 5335 “CDS Shipment Method Code”

Keys

Key1: QuoteId (clustered)
Key2: Name

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
AccountIdName: CalcFormula Table 5341 “CRM Account”
AccountId: TableRelation Table 5341 “CRM Account”
CustomerId: TableRelation Table 5341 “CRM Account” (conditional)
ContactIdName: CalcFormula Table 5342 “CRM Contact”
ContactId: TableRelation Table 5342 “CRM Contact”
CustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
OpportunityIdName: CalcFormula Table 5343 “CRM Opportunity”
OpportunityId: TableRelation Table 5343 “CRM Opportunity”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
PriceLevelIdName: CalcFormula Table 5346 “CRM Pricelevel”
PriceLevelId: TableRelation Table 5346 “CRM Pricelevel”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

4 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Table 5353 “CRM Salesorder”: QuoteIdName, QuoteId
Table 5352 “CRM Quotedetail”: QuoteId
Table 5385 “CRM Annotation”: ObjectId

Pages and codeunits on this table

Page 5351 “CRM Sales Quote List” (source table)
Codeunit 5348 “CRM Quote to Sales Quote” (codeunit runs on it)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Quote"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 14 connected objects and pages