Other table in Microsoft Dynamics 365 Business Central. 80 fields, 18 records in Cronus demo.
The Sales Quote Entity Buffer table (ID 5505) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 80 fields, with a primary key of No., and includes 1 calculated FlowField. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: No..
| 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 | 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 |
Tables referenced by fields on the Sales Quote Entity Buffer table through TableRelation properties.