Table 5351 CRM Quote in 17

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

App: Base Application

Versions1718 19 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 101

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[250]	-
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	-
26	ShippingMethodCode	Option	Pending 16.0
This field is replaced by field 100 ShippingMethodCodeEnum
27	PaymentTermsCode	Option	Pending 16.0
This field is replaced by field 99 PaymentTermsCodeEnum
28	FreightTermsCode	Option	Pending 16.0
This field is replaced by field 101 FreightTermsCodeEnum
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[250]	-
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	-