Sales Quote Entity Buffer #5505

Other table in Microsoft Dynamics 365 Business Central. 80 fields, 18 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 (80)

Sales Quote Entity Buffer — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Document Type	Option	Normal
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
11	Your Reference	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
24	Due Date	Date	Normal
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
70	VAT Registration No.	Text	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
114	Tax Area Code	Code	Normal	→ Tax Area #318
115	Tax Liable	Boolean	Normal
116	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
121	Invoice Discount Calculation	Option	Normal
122	Invoice Discount Value	Decimal	Normal
152	Quote Valid Until Date	Date	Normal
153	Quote Sent to Customer	DateTime	Normal
154	Quote Accepted	Boolean	Normal
155	Quote Accepted Date	Date	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
8000	Id	GUID	Normal
9600	Total Tax Amount	Decimal	Normal
9601	Status	Option	Normal
9602	Posted	Boolean	Normal
9603	Subtotal Amount	Decimal	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
9637	Tax Area ID	GUID	Normal
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