Table 5353 CRM Salesorder

Base Application, Microsoft.Integration.D365Sales

105 fields

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