Table 5354 CRM Salesorderdetail

Base Application, Microsoft.Integration.D365Sales

76 fields

IdNameTypeVersions
1SalesOrderDetailIdGuid17-29
2SalesOrderIdGuid17-29
3SalesRepIdGuid17-29
4IsProductOverriddenBoolean17-29
5IsCopiedBoolean17-29
6QuantityShippedDecimal17-29
7LineItemNumberInteger17-29
8QuantityBackorderedDecimal17-29
9UoMIdGuid17-29
10QuantityCancelledDecimal17-29
11ProductIdGuid17-29
12RequestDeliveryByDate17-29
13QuantityDecimal17-29
14PricingErrorCodeOption17-29
15ManualDiscountAmountDecimal17-29
16ProductDescriptionText[250]17-29
17VolumeDiscountAmountDecimal17-29
18PricePerUnitDecimal17-29
19BaseAmountDecimal17-29
20ExtendedAmountDecimal17-29
21DescriptionBlob17-29
22IsPriceOverriddenBoolean17-29
23ShipTo_NameText[200]17-29
24TaxDecimal17-29
25CreatedOnDateTime17-29
26ShipTo_Line1Text[250]17-29
27CreatedByGuid17-29
28ModifiedByGuid17-29
29ShipTo_Line2Text[250]17-29
30ShipTo_Line3Text[250]17-29
31ModifiedOnDateTime17-29
32ShipTo_CityText[80]17-29
33ShipTo_StateOrProvinceText[50]17-29
34ShipTo_CountryText[80]17-29
35ShipTo_PostalCodeText[20]17-29
36WillCallBoolean17-29
37ShipTo_TelephoneText[50]17-29
38ShipTo_FaxText[50]17-29
39ShipTo_FreightTermsCodeOption17-29
40ProductIdNameText[100]17-29
41UoMIdNameText[100]17-29
42SalesRepIdNameText[200]17-29
43SalesOrderStateCodeOption17-29
44CreatedByNameText[200]17-29
45ModifiedByNameText[200]17-29
46ShipTo_ContactNameText[150]17-29
47VersionNumberBigInteger17-29
48OwningBusinessUnitGuid17-29
49OwningUserGuid17-29
50SalesOrderIsPriceLockedBoolean17-29
51ShipTo_AddressIdGuid17-29
52TimeZoneRuleVersionNumberInteger17-29
53ImportSequenceNumberInteger17-29
54UTCConversionTimeZoneCodeInteger17-29
55ExchangeRateDecimal17-29
56OverriddenCreatedOnDate17-29
57TransactionCurrencyIdGuid17-29
58BaseAmount_BaseDecimal17-29
59PricePerUnit_BaseDecimal17-29
60TransactionCurrencyIdNameText[100]17-29
61VolumeDiscountAmount_BaseDecimal17-29
62ExtendedAmount_BaseDecimal17-29
63Tax_BaseDecimal17-29
64ManualDiscountAmount_BaseDecimal17-29
65OwnerIdGuid17-29
66OwnerIdTypeOption17-29
67CreatedOnBehalfByGuid17-29
68CreatedOnBehalfByNameText[200]17-29
69ModifiedOnBehalfByGuid17-29
70ModifiedOnBehalfByNameText[200]17-29
71SequenceNumberInteger17-29
72ParentBundleIdGuid17-29
73ProductTypeCodeOption17-29
74PropertyConfigurationStatusOption17-29
75ProductAssociationIdGuid17-29
76BusinessCentralLineNumberIntegernew in 21