Table 5351 CRM Quote

Base Application, Microsoft.Integration.D365Sales

101 fields

IdNameTypeVersions
1QuoteIdGuid17-29
2OwningBusinessUnitGuid17-29
3OwningUserGuid17-29
4PriceLevelIdGuid17-29
5OpportunityIdGuid17-29
6AccountIdGuid17-29
7ContactIdGuid17-29
8QuoteNumberText[100]17-29
9RevisionNumberInteger17-29
10NameText[2048]17-29changed in 18
11PricingErrorCodeOption17-29
12DescriptionBlob17-29
13DiscountAmountDecimal17-29
14FreightAmountDecimal17-29
15TotalAmountDecimal17-29
16TotalLineItemAmountDecimal17-29
17TotalLineItemDiscountAmountDecimal17-29
18TotalAmountLessFreightDecimal17-29
19EffectiveFromDate17-29
20TotalTaxDecimal17-29
21TotalDiscountAmountDecimal17-29
22EffectiveToDate17-29
23ExpiresOnDate17-29
24ClosedOnDate17-29
25RequestDeliveryByDate17-29
26ShippingMethodCodeOptiongone after 25
Removed, tag 19.0, obsolete since 17: This field is replaced by field 100 ShippingMethodCodeEnum
27PaymentTermsCodeOptiongone after 25
Removed, tag 19.0, obsolete since 17: This field is replaced by field 99 PaymentTermsCodeEnum
28FreightTermsCodeOptiongone after 25
Removed, tag 19.0, obsolete since 17: This field is replaced by field 101 FreightTermsCodeEnum
29CreatedByGuid17-29
30CreatedOnDateTime17-29
31ModifiedByGuid17-29
32ModifiedOnDateTime17-29
33StateCodeOption17-29
34StatusCodeOption17-29
35ShipTo_NameText[200]17-29
36VersionNumberBigInteger17-29
37ShipTo_Line1Text[250]17-29
38ShipTo_Line2Text[250]17-29
39ShipTo_Line3Text[250]17-29
40ShipTo_CityText[80]17-29
41ShipTo_StateOrProvinceText[50]17-29
42ShipTo_CountryText[80]17-29
43ShipTo_PostalCodeText[20]17-29
44WillCallBoolean17-29
45ShipTo_TelephoneText[50]17-29
46BillTo_NameText[200]17-29
47ShipTo_FreightTermsCodeOption17-29
48ShipTo_FaxText[50]17-29
49BillTo_Line1Text[250]17-29
50BillTo_Line2Text[250]17-29
51BillTo_Line3Text[250]17-29
52BillTo_CityText[80]17-29
53BillTo_StateOrProvinceText[50]17-29
54BillTo_CountryText[80]17-29
55BillTo_PostalCodeText[20]17-29
56BillTo_TelephoneText[50]17-29
57BillTo_FaxText[50]17-29
58DiscountPercentageDecimal17-29
59ContactIdNameText[160]17-29
60AccountIdNameText[160]17-29
61OpportunityIdNameText[2048]17-29changed in 18
62PriceLevelIdNameText[100]17-29
63CreatedByNameText[200]17-29
64ModifiedByNameText[200]17-29
65CustomerIdGuid17-29
66CustomerIdTypeOption17-29
67OwnerIdGuid17-29
68OwnerIdTypeOption17-29
69ShipTo_AddressIdGuid17-29
70ShipTo_ContactNameText[150]17-29
71BillTo_AddressIdGuid17-29
72BillTo_ContactNameText[150]17-29
73TimeZoneRuleVersionNumberInteger17-29
74ImportSequenceNumberInteger17-29
75ExchangeRateDecimal17-29
76OverriddenCreatedOnDate17-29
77UTCConversionTimeZoneCodeInteger17-29
78TransactionCurrencyIdGuid17-29
79TotalLineItemDiscountAmount_BaDecimal17-29
80TransactionCurrencyIdNameText[100]17-29
81TotalAmountLessFreight_BaseDecimal17-29
82DiscountAmount_BaseDecimal17-29
83FreightAmount_BaseDecimal17-29
84TotalAmount_BaseDecimal17-29
85TotalDiscountAmount_BaseDecimal17-29
86TotalTax_BaseDecimal17-29
87TotalLineItemAmount_BaseDecimal17-29
88CreatedOnBehalfByGuid17-29
89CreatedOnBehalfByNameText[200]17-29
90ModifiedOnBehalfByGuid17-29
91ModifiedOnBehalfByNameText[200]17-29
92OwningTeamGuid17-29
93BillTo_CompositeBlob17-29
94ShipTo_CompositeBlob17-29
95ProcessIdGuid17-29
96StageIdGuid17-29
97TraversedPathText[250]17-29
98CompanyIdGuid17-29
99PaymentTermsCodeEnumEnum "CDS Payment Terms Code"17-29
100ShippingMethodCodeEnumEnum "CDS Shipping Agent Code"17-29
101FreightTermsCodeEnumEnum "CDS Shipment Method Code"17-29