Table 5351 CRM Quote in 28

Jonas Paprotka, Base Application 28.5.54151.54365, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Integration.D365Sales

Versions17 18 19 20 21 22 23 24 25 26 2728latest

Source29

Fields, 98

Id	Name	Type	Obsolete
1	QuoteId	Guid	-
2	OwningBusinessUnit	Guid	-
3	OwningUser	Guid	-
4	PriceLevelId	Guid	-
5	OpportunityId	Guid	-
6	AccountId	Guid	-
7	ContactId	Guid	-
8	QuoteNumber	Text[100]	-
9	RevisionNumber	Integer	-
10	Name	Text[2048]	-
11	PricingErrorCode	Option	-
12	Description	Blob	-
13	DiscountAmount	Decimal	-
14	FreightAmount	Decimal	-
15	TotalAmount	Decimal	-
16	TotalLineItemAmount	Decimal	-
17	TotalLineItemDiscountAmount	Decimal	-
18	TotalAmountLessFreight	Decimal	-
19	EffectiveFrom	Date	-
20	TotalTax	Decimal	-
21	TotalDiscountAmount	Decimal	-
22	EffectiveTo	Date	-
23	ExpiresOn	Date	-
24	ClosedOn	Date	-
25	RequestDeliveryBy	Date	-
29	CreatedBy	Guid	-
30	CreatedOn	DateTime	-
31	ModifiedBy	Guid	-
32	ModifiedOn	DateTime	-
33	StateCode	Option	-
34	StatusCode	Option	-
35	ShipTo_Name	Text[200]	-
36	VersionNumber	BigInteger	-
37	ShipTo_Line1	Text[250]	-
38	ShipTo_Line2	Text[250]	-
39	ShipTo_Line3	Text[250]	-
40	ShipTo_City	Text[80]	-
41	ShipTo_StateOrProvince	Text[50]	-
42	ShipTo_Country	Text[80]	-
43	ShipTo_PostalCode	Text[20]	-
44	WillCall	Boolean	-
45	ShipTo_Telephone	Text[50]	-
46	BillTo_Name	Text[200]	-
47	ShipTo_FreightTermsCode	Option	-
48	ShipTo_Fax	Text[50]	-
49	BillTo_Line1	Text[250]	-
50	BillTo_Line2	Text[250]	-
51	BillTo_Line3	Text[250]	-
52	BillTo_City	Text[80]	-
53	BillTo_StateOrProvince	Text[50]	-
54	BillTo_Country	Text[80]	-
55	BillTo_PostalCode	Text[20]	-
56	BillTo_Telephone	Text[50]	-
57	BillTo_Fax	Text[50]	-
58	DiscountPercentage	Decimal	-
59	ContactIdName	Text[160]	-
60	AccountIdName	Text[160]	-
61	OpportunityIdName	Text[2048]	-
62	PriceLevelIdName	Text[100]	-
63	CreatedByName	Text[200]	-
64	ModifiedByName	Text[200]	-
65	CustomerId	Guid	-
66	CustomerIdType	Option	-
67	OwnerId	Guid	-
68	OwnerIdType	Option	-
69	ShipTo_AddressId	Guid	-
70	ShipTo_ContactName	Text[150]	-
71	BillTo_AddressId	Guid	-
72	BillTo_ContactName	Text[150]	-
73	TimeZoneRuleVersionNumber	Integer	-
74	ImportSequenceNumber	Integer	-
75	ExchangeRate	Decimal	-
76	OverriddenCreatedOn	Date	-
77	UTCConversionTimeZoneCode	Integer	-
78	TransactionCurrencyId	Guid	-
79	TotalLineItemDiscountAmount_Ba	Decimal	-
80	TransactionCurrencyIdName	Text[100]	-
81	TotalAmountLessFreight_Base	Decimal	-
82	DiscountAmount_Base	Decimal	-
83	FreightAmount_Base	Decimal	-
84	TotalAmount_Base	Decimal	-
85	TotalDiscountAmount_Base	Decimal	-
86	TotalTax_Base	Decimal	-
87	TotalLineItemAmount_Base	Decimal	-
88	CreatedOnBehalfBy	Guid	-
89	CreatedOnBehalfByName	Text[200]	-
90	ModifiedOnBehalfBy	Guid	-
91	ModifiedOnBehalfByName	Text[200]	-
92	OwningTeam	Guid	-
93	BillTo_Composite	Blob	-
94	ShipTo_Composite	Blob	-
95	ProcessId	Guid	-
96	StageId	Guid	-
97	TraversedPath	Text[250]	-
98	CompanyId	Guid	-
99	PaymentTermsCodeEnum	Enum CDS Payment Terms Code	-
100	ShippingMethodCodeEnum	Enum CDS Shipping Agent Code	-
101	FreightTermsCodeEnum	Enum CDS Shipment Method Code	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	QuoteId	-
Key2	Name	-