Table 5354 "CRM Salesorderdetail"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Salesorderdetail
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	SalesOrderDetailId	Guid	Order Product caption
2	SalesOrderId	Guid	Order caption	TableRelation Table 5353 “CRM Salesorder” (“CRM Salesorder”.SalesOrderId)
3	SalesRepId	Guid	Salesperson caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	IsProductOverridden	Boolean	Select Product caption
5	IsCopied	Boolean	Copied caption
6	QuantityShipped Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
7	LineItemNumber	Integer	Line Item Number caption
8	QuantityBackordered Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
9	UoMId	Guid	Unit caption	TableRelation Table 5361 “CRM Uom” (“CRM Uom”.UoMId)
10	QuantityCancelled Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
11	ProductId	Guid	Existing Product caption	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
12	RequestDeliveryBy	Date	Requested Delivery Date caption
13	Quantity Δ BC28	Decimal	Specifies the quantity of the item on the sales line.
14	PricingErrorCode	Option	Pricing Error caption	OptionCaption: None,Detail Error,Missing Price Level,Inactive Price Level,Missing Quantity,Missing Unit Price,Missing Product,Invalid Product,Missing Pricing Code,Invalid Pricing Code,Missing UOM,Product Not In Price Level,Missing Price Level Amount,Missing Price Level Percentage,Missing Price,Missing Current Cost…
15	ManualDiscountAmount Δ BC28	Decimal	Specifies that the sales order is subject to manual discount.
16	ProductDescription Δ BC28	Text[250]	Specifies if the item is a write-in product.
17	VolumeDiscountAmount Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
18	PricePerUnit Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
19	BaseAmount Δ BC28	Decimal	Specifies the net amount of all the lines.
20	ExtendedAmount Δ BC28	Decimal	Specifies the sales amount without rounding.
21	Description	BLOB	—
22	IsPriceOverridden	Boolean	Pricing caption
23	ShipTo_Name Δ BC28	Text[200]	Specifies information related to the Dynamics 365 Sales connection.
24	Tax Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
25	CreatedOn Δ BC28	DateTime	Specifies when the sales order was created.
26	ShipTo_Line1 Δ BC28	Text[250]	Specifies information related to the Dynamics 365 Sales connection.
27	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
28	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
29	ShipTo_Line2 Δ BC28	Text[250]	Specifies information related to the Dynamics 365 Sales connection.
30	ShipTo_Line3 Δ BC28	Text[250]	Specifies information related to the Dynamics 365 Sales connection.
31	ModifiedOn Δ BC28	DateTime	Specifies when the sales order was last modified.
32	ShipTo_City Δ BC28	Text[80]	Specifies information related to the Dynamics 365 Sales connection.
33	ShipTo_StateOrProvince Δ BC28	Text[50]	Specifies information related to the Dynamics 365 Sales connection.
34	ShipTo_Country Δ BC28	Text[80]	Specifies the country/region of the address.
35	ShipTo_PostalCode Δ BC28	Text[20]	Specifies information related to the Dynamics 365 Sales connection.
36	WillCall Δ BC28	Boolean	Specifies information related to the Dynamics 365 Sales connection.
37	ShipTo_Telephone Δ BC28	Text[50]	Specifies information related to the Dynamics 365 Sales connection.
38	ShipTo_Fax Δ BC28	Text[50]	Specifies information related to the Dynamics 365 Sales connection.
39	ShipTo_FreightTermsCode Δ BC28	Option	Specifies the shipment method.	OptionCaption: ,FOB,No Charge
40	ProductIdName Δ BC24 Δ BC28	Text[100]	Specifies information related to the Dynamics 365 Sales connection.	FlowField: lookup(“CRM Product”.Name where(ProductId = field(ProductId)))
41	UoMIdName Δ BC24 Δ BC28	Text[100]	Specifies the unit in which the item is held in inventory.	FlowField: lookup(“CRM Uom”.Name where(UoMId = field(UoMId)))
42	SalesRepIdName Δ BC24 Δ BC28	Text[200]	Specifies information related to the Dynamics 365 Sales connection.	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(SalesRepId)))
43	SalesOrderStateCode	Option	Order Status caption	OptionCaption:
44	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
45	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
46	ShipTo_ContactName Δ BC28	Text[150]	Specifies information related to the Dynamics 365 Sales connection.
47	VersionNumber	BigInteger	Version Number caption
48	OwningBusinessUnit	Guid	Owning Business Unit caption
49	OwningUser	Guid	Owning User caption
50	SalesOrderIsPriceLocked	Boolean	Order Is Price Locked caption
51	ShipTo_AddressId	Guid	Ship To Address ID caption
52	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
53	ImportSequenceNumber	Integer	Import Sequence Number caption
54	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
55	ExchangeRate Δ BC28	Decimal	Specifies the currency exchange rate.
56	OverriddenCreatedOn	Date	Record Created On caption
57	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
58	BaseAmount_Base Δ BC28	Decimal	Amount (Base) caption
59	PricePerUnit_Base Δ BC28	Decimal	Price Per Unit (Base) caption
60	TransactionCurrencyIdName Δ BC24 Δ BC28	Text[100]	Specifies the currency that amounts are shown in.	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
61	VolumeDiscountAmount_Base Δ BC28	Decimal	Volume Discount (Base) caption
62	ExtendedAmount_Base Δ BC28	Decimal	Extended Amount (Base) caption
63	Tax_Base Δ BC28	Decimal	Tax (Base) caption
64	ManualDiscountAmount_Base Δ BC28	Decimal	Manual Discount (Base) caption
65	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
66	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
67	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
68	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
69	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
70	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
71	SequenceNumber	Integer	Sequence Number caption
72	ParentBundleId	Guid	Parent Bundle caption
73	ProductTypeCode	Option	Product type caption	OptionCaption: Product,Bundle,Required Bundle Product,Optional Bundle Product
74	PropertyConfigurationStatus	Option	Property Configuration caption	OptionCaption: Edit,Rectify,NotConfigured
75	ProductAssociationId	Guid	Bundle Item Association caption
76	BusinessCentralLineNumber	Integer	BC Line Number caption

Keys

Key1: SalesOrderDetailId (clustered)

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
SalesRepIdName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
SalesRepId: TableRelation Table 5340 “CRM Systemuser”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
ProductIdName: CalcFormula Table 5348 “CRM Product”
ProductId: TableRelation Table 5348 “CRM Product”
SalesOrderId: TableRelation Table 5353 “CRM Salesorder”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
UoMIdName: CalcFormula Table 5361 “CRM Uom”
UoMId: TableRelation Table 5361 “CRM Uom”

Pages and codeunits on this table

Page 5381 “CRM Sales Order Subform” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Salesorderdetail"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.