Sales Order Entity Buffer #5495

Other table in Microsoft Dynamics 365 Business Central. 67 fields, 9 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (67)

Sales Order Entity Buffer — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
2	Sell-to Customer No.	Code	Normal	→ Customer #18
3	No. PK	Code	Normal
4	Bill-to Customer No.	Code	Normal	→ Customer #18
5	Bill-to Name	Text	Normal	→ Customer #18
7	Bill-to Address	Text	Normal
8	Bill-to Address 2	Text	Normal
9	Bill-to City	Text	Normal
10	Bill-to Contact	Text	Normal
12	Ship-to Code	Code	Normal
13	Ship-to Name	Text	Normal
15	Ship-to Address	Text	Normal
16	Ship-to Address 2	Text	Normal
17	Ship-to City	Text	Normal
18	Ship-to Contact	Text	Normal
20	Posting Date	Date	Normal
23	Payment Terms Code	Code	Normal	→ Payment Terms #3
27	Shipment Method Code	Code	Normal	→ Shipment Method #10
29	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
30	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
31	Customer Posting Group	Code	Normal	→ Customer Posting Group #92
32	Currency Code	Code	Normal	→ Currency #4
35	Prices Including VAT	Boolean	Normal
43	Salesperson Code	Code	Normal	→ Salesperson/Purchaser #13
56	Recalculate Invoice Disc. ⚡ FLOW	Boolean	FlowField
60	Amount	Decimal	Normal
61	Amount Including VAT	Decimal	Normal
79	Sell-to Customer Name	Text	Normal	→ Customer #18
81	Sell-to Address	Text	Normal
82	Sell-to Address 2	Text	Normal
83	Sell-to City	Text	Normal
84	Sell-to Contact	Text	Normal
85	Bill-to Post Code	Code	Normal	→ Post Code #225
86	Bill-to County	Text	Normal
87	Bill-to Country/Region Code	Code	Normal	→ Country/Region #9
88	Sell-to Post Code	Code	Normal
89	Sell-to County	Text	Normal
90	Sell-to Country/Region Code	Code	Normal	→ Country/Region #9
91	Ship-to Post Code	Code	Normal
92	Ship-to County	Text	Normal
93	Ship-to Country/Region Code	Code	Normal	→ Country/Region #9
99	Document Date	Date	Normal
100	External Document No.	Code	Normal
171	Sell-to Phone No.	Text	Normal
172	Email	Text	Normal
210	Ship-to Phone No.	Text	Normal
1304	Cust. Ledger Entry No.	Integer	Normal	→ Cust. Ledger Entry #21
1305	Invoice Discount Amount	Decimal	Normal
5052	Sell-To Contact No.	Code	Normal	→ Contact #5050
5750	Shipping Advice	Option	Normal
5752	Completely Shipped	Boolean	Normal
5790	Requested Delivery Date	Date	Normal
8000	Id	GUID	Normal
9600	Total Tax Amount	Decimal	Normal
9601	Status	Option	Normal
9624	Discount Applied Before Tax	Boolean	Normal
9630	Last Modified Date Time	DateTime	Normal
9631	Customer Id	GUID	Normal	→ Customer #18
9633	Contact Graph Id	Text	Normal
9634	Currency Id	GUID	Normal	→ Currency #4
9635	Payment Terms Id	GUID	Normal	→ Payment Terms #3
9636	Shipment Method Id	GUID	Normal	→ Shipment Method #10
9638	Bill-to Customer Id	GUID	Normal	→ Customer #18
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal