Objects/Tables/Table 5354 CRM Salesorderdetail

Table 5354 CRM Salesorderdetail 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, 75

Id	Name	Type	Obsolete
1	SalesOrderDetailId	Guid	-
2	SalesOrderId	Guid	-
3	SalesRepId	Guid	-
4	IsProductOverridden	Boolean	-
5	IsCopied	Boolean	-
6	QuantityShipped	Decimal	-
7	LineItemNumber	Integer	-
8	QuantityBackordered	Decimal	-
9	UoMId	Guid	-
10	QuantityCancelled	Decimal	-
11	ProductId	Guid	-
12	RequestDeliveryBy	Date	-
13	Quantity	Decimal	-
14	PricingErrorCode	Option	-
15	ManualDiscountAmount	Decimal	-
16	ProductDescription	Text[250]	-
17	VolumeDiscountAmount	Decimal	-
18	PricePerUnit	Decimal	-
19	BaseAmount	Decimal	-
20	ExtendedAmount	Decimal	-
21	Description	Blob	-
22	IsPriceOverridden	Boolean	-
23	ShipTo_Name	Text[200]	-
24	Tax	Decimal	-
25	CreatedOn	DateTime	-
26	ShipTo_Line1	Text[250]	-
27	CreatedBy	Guid	-
28	ModifiedBy	Guid	-
29	ShipTo_Line2	Text[250]	-
30	ShipTo_Line3	Text[250]	-
31	ModifiedOn	DateTime	-
32	ShipTo_City	Text[80]	-
33	ShipTo_StateOrProvince	Text[50]	-
34	ShipTo_Country	Text[80]	-
35	ShipTo_PostalCode	Text[20]	-
36	WillCall	Boolean	-
37	ShipTo_Telephone	Text[50]	-
38	ShipTo_Fax	Text[50]	-
39	ShipTo_FreightTermsCode	Option	-
40	ProductIdName	Text[100]	-
41	UoMIdName	Text[100]	-
42	SalesRepIdName	Text[200]	-
43	SalesOrderStateCode	Option	-
44	CreatedByName	Text[200]	-
45	ModifiedByName	Text[200]	-
46	ShipTo_ContactName	Text[150]	-
47	VersionNumber	BigInteger	-
48	OwningBusinessUnit	Guid	-
49	OwningUser	Guid	-
50	SalesOrderIsPriceLocked	Boolean	-
51	ShipTo_AddressId	Guid	-
52	TimeZoneRuleVersionNumber	Integer	-
53	ImportSequenceNumber	Integer	-
54	UTCConversionTimeZoneCode	Integer	-
55	ExchangeRate	Decimal	-
56	OverriddenCreatedOn	Date	-
57	TransactionCurrencyId	Guid	-
58	BaseAmount_Base	Decimal	-
59	PricePerUnit_Base	Decimal	-
60	TransactionCurrencyIdName	Text[100]	-
61	VolumeDiscountAmount_Base	Decimal	-
62	ExtendedAmount_Base	Decimal	-
63	Tax_Base	Decimal	-
64	ManualDiscountAmount_Base	Decimal	-
65	OwnerId	Guid	-
66	OwnerIdType	Option	-
67	CreatedOnBehalfBy	Guid	-
68	CreatedOnBehalfByName	Text[200]	-
69	ModifiedOnBehalfBy	Guid	-
70	ModifiedOnBehalfByName	Text[200]	-
71	SequenceNumber	Integer	-
72	ParentBundleId	Guid	-
73	ProductTypeCode	Option	-
74	PropertyConfigurationStatus	Option	-
75	ProductAssociationId	Guid	-

Keys, 1

Name	Fields	Obsolete
Key1, clustered	SalesOrderDetailId	-