Table 5353 "CRM Salesorder"

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

Properties

Property	Value
Caption	CRM Salesorder
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	SalesOrderId	Guid	Order caption
2	OpportunityId	Guid	Opportunity caption	TableRelation Table 5343 “CRM Opportunity” (“CRM Opportunity”.OpportunityId)
3	QuoteId	Guid	Quote caption	TableRelation Table 5351 “CRM Quote” (“CRM Quote”.QuoteId)
4	PriorityCode	Option	Priority caption	OptionCaption: Default Value
5	SubmitStatus	Integer	Submitted Status caption
6	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	SubmitDate	Date	Date Submitted caption
8	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
9	SubmitStatusDescription	BLOB	Submitted Status Description caption
10	PriceLevelId	Guid	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
11	LastBackofficeSubmit	Date	Last Submitted to Back Office caption
12	AccountId	Guid	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
13	ContactId	Guid	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
14	OrderNumber Δ BC28	Text[100]	Specifies information related to the Dynamics 365 Sales connection.
15	Name Δ BC28	Text[2048]	Specifies the name of the record.
16	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…
17	Description	BLOB	—
18	DiscountAmount Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
19	FreightAmount Δ BC28	Decimal	Freight Amount caption
20	TotalAmount Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
21	TotalLineItemAmount Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
22	TotalLineItemDiscountAmount Δ BC28	Decimal	Total Line Item Discount Amount caption
23	TotalAmountLessFreight Δ BC28	Decimal	Specifies data from a corresponding field in a Dynamics 365 Sales entity.
24	TotalDiscountAmount Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
25	RequestDeliveryBy Δ BC28	Date	Specifies information related to the Dynamics 365 Sales connection.
26	TotalTax Δ BC28	Decimal	Specifies the sum of TAX amounts on all lines in the document.
30	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
31	CreatedOn	DateTime	Created On caption
32	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
33	ModifiedOn	DateTime	Modified On caption
34	StateCode Δ BC28	Option	Specifies information related to the Dynamics 365 Sales connection.	OptionCaption: Active,Submitted,Canceled,Fulfilled,Invoiced
35	StatusCode Δ BC28	Option	Specifies information related to the Dynamics 365 Sales connection.	OptionCaption: ,In Progress,No Money,New,Pending,Complete,Partial,Invoiced
36	ShipTo_Name Δ BC28	Text[200]	Specifies information related to the Dynamics 365 Sales connection.
37	VersionNumber	BigInteger	Version Number caption
38	ShipTo_Line1 Δ BC28	Text[250]	Specifies information related to the Dynamics 365 Sales connection.
39	ShipTo_Line2 Δ BC28	Text[250]	Specifies information related to the Dynamics 365 Sales connection.
40	ShipTo_Line3 Δ BC28	Text[250]	Specifies information related to the Dynamics 365 Sales connection.
41	ShipTo_City Δ BC28	Text[80]	Specifies information related to the Dynamics 365 Sales connection.
42	ShipTo_StateOrProvince Δ BC28	Text[50]	Specifies information related to the Dynamics 365 Sales connection.
43	ShipTo_Country Δ BC28	Text[80]	Specifies the country/region of the address.
44	ShipTo_PostalCode Δ BC28	Text[20]	Specifies information related to the Dynamics 365 Sales connection.
45	WillCall Δ BC28	Boolean	Specifies information related to the Dynamics 365 Sales connection.
46	ShipTo_Telephone Δ BC28	Text[50]	Specifies information related to the Dynamics 365 Sales connection.
47	BillTo_Name Δ BC28	Text[200]	Specifies the name at the address that the invoice will be sent to.
48	ShipTo_FreightTermsCode Δ BC28	Option	Specifies information related to the Dynamics 365 Sales connection.	OptionCaption: Default Value
49	ShipTo_Fax Δ BC28	Text[50]	Specifies information related to the Dynamics 365 Sales connection.
50	BillTo_Line1 Δ BC28	Text[250]	Specifies the street of the address that the invoice will be sent to.
51	BillTo_Line2 Δ BC28	Text[250]	Specifies the additional street information of the address that the invoice will be sent to.
52	BillTo_Line3 Δ BC28	Text[250]	Specifies the additional street information of the address that the invoice will be sent to.
53	BillTo_City Δ BC28	Text[80]	Specifies the city of the address that the invoice will be sent to.
54	BillTo_StateOrProvince Δ BC28	Text[50]	Specifies the state/province of the address that the invoice will be sent to.
55	BillTo_Country Δ BC28	Text[80]	Specifies the country/region of the address that the invoice will be sent to.
56	BillTo_PostalCode Δ BC28	Text[20]	Specifies the ZIP/postal code of the address that the invoice will be sent to.
57	BillTo_Telephone Δ BC28	Text[50]	Specifies the phone number at the address that the invoice will be sent to.
58	BillTo_Fax Δ BC28	Text[50]	Specifies the fax number at the address that the invoice will be sent to.
59	DiscountPercentage Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
60	ContactIdName Δ BC24 Δ BC28	Text[160]	Specifies the contact person at the customer.	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ContactId)))
61	AccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
62	OpportunityIdName Δ BC24 Δ BC28	Text[2048]	Specifies the sales opportunity that is coupled to this Dynamics 365 Sales opportunity.	FlowField: lookup(“CRM Opportunity”.Name where(OpportunityId = field(OpportunityId)))
63	QuoteIdName Δ BC24 Δ BC28	Text[2048]	Specifies information related to the Dynamics 365 Sales connection.	FlowField: lookup(“CRM Quote”.Name where(QuoteId = field(QuoteId)))
64	PriceLevelIdName Δ BC24 Δ BC28	Text[100]	Specifies a list of your items and their prices, for example, to send to customers. You can create the list for specific customers, campaigns, currencies, or other criteria.	FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(PriceLevelId)))
65	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
66	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
67	CustomerId	Guid	Customer caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (CustomerIdType = const(account)) “CRM Account”.AccountId else if (CustomerIdType = const(contact)) “CRM Contact”.ContactId)
68	CustomerIdType	Option	Customer Type caption	OptionCaption: ,account,contact
69	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)
70	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
71	BillTo_ContactName Δ BC28	Text[150]	Specifies the contact person at the address that the invoice will be sent to.
72	BillTo_AddressId	Guid	Bill To Address ID caption
73	ShipTo_AddressId	Guid	Ship To Address ID caption
74	IsPriceLocked Δ BC28	Boolean	Specifies information related to the Dynamics 365 Sales connection.
75	DateFulfilled Δ BC28	Date	Specifies when the sales order was delivered.
76	ShipTo_ContactName	Text[150]	Ship To Contact Name caption
77	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
78	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
79	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
80	ImportSequenceNumber	Integer	Import Sequence Number caption
81	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
82	OverriddenCreatedOn	Date	Record Created On caption
83	TotalLineItemAmount_Base Δ BC28	Decimal	Total Detail Amount (Base) caption
84	TotalDiscountAmount_Base Δ BC28	Decimal	Total Discount Amount (Base) caption
85	TotalAmountLessFreight_Base Δ BC28	Decimal	Total Pre-Freight Amount (Base) caption
86	TotalAmount_Base Δ BC28	Decimal	Total Amount (Base) caption
87	TransactionCurrencyIdName Δ BC24 Δ BC28	Text[100]	Specifies the currency that amounts are shown in.	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
88	DiscountAmount_Base Δ BC28	Decimal	Order Discount Amount (Base) caption
89	FreightAmount_Base Δ BC28	Decimal	Freight Amount (Base) caption
90	TotalLineItemDiscountAmount_Ba Δ BC28	Decimal	Total Line Item Discount Amount (Base) caption
91	TotalTax_Base Δ BC28	Decimal	Total Tax (Base) caption
92	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
93	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
94	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
95	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
96	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
97	BillTo_Composite Δ BC28	BLOB	Specifies the address that the invoice will be sent to.
98	ShipTo_Composite Δ BC28	BLOB	Specifies information related to the Dynamics 365 Sales connection.
99	ProcessId	Guid	Process caption
100	StageId	Guid	Process Stage caption
101	EntityImageId	Guid	Entity Image Id caption
102	TraversedPath	Text[250]	Traversed Path caption
103	CompanyId	Guid	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
104	PaymentTermsCodeEnum Δ BC28	Enum “CDS Payment Terms Code”	Specifies the payment terms that you select from on customer cards to define when the customer must pay, such as within 14 days.	enum Enum 5334 “CDS Payment Terms Code”
105	ShippingMethodCodeEnum Δ BC28	Enum “CDS Shipping Agent Code”	Specifies information related to the Dynamics 365 Sales connection.	enum Enum 5336 “CDS Shipping Agent Code”
106	FreightTermsCodeEnum Δ BC28	Enum “CDS Shipment Method Code”	Specifies the shipment method.	enum Enum 5335 “CDS Shipment Method Code”
107	BusinessCentralOrderNumber	Text[20]	Business Central Order Number caption
108	BusinessCentralDocumentOccurrenceNumber	Integer	Business Central Document Occurrence Number caption

Keys

Key1: SalesOrderId (clustered)
Key2: Name

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”
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)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
AccountIdName: CalcFormula Table 5341 “CRM Account”
AccountId: TableRelation Table 5341 “CRM Account”
CustomerId: TableRelation Table 5341 “CRM Account” (conditional)
ContactIdName: CalcFormula Table 5342 “CRM Contact”
ContactId: TableRelation Table 5342 “CRM Contact”
CustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
OpportunityIdName: CalcFormula Table 5343 “CRM Opportunity”
OpportunityId: TableRelation Table 5343 “CRM Opportunity”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
PriceLevelIdName: CalcFormula Table 5346 “CRM Pricelevel”
PriceLevelId: TableRelation Table 5346 “CRM Pricelevel”
QuoteIdName: CalcFormula Table 5351 “CRM Quote”
QuoteId: TableRelation Table 5351 “CRM Quote”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

3 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5355 “CRM Invoice”: SalesOrderIdName, SalesOrderId
Table 5354 “CRM Salesorderdetail”: SalesOrderId

Pages and codeunits on this table

Page 5353 “CRM Sales Order List” (source table)
Page 5380 “CRM Sales Order” (source table)
Codeunit 5343 “CRM Sales Order to Sales Order” (codeunit runs on it)

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 Salesorder"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.