Other table in Microsoft Dynamics 365 Business Central. 66 fields, 0 records in Cronus demo.
The VAT Entry Posting Preview table (ID 1571) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 66 fields, with a primary key of Entry No.. 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: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Entry No. PK | Integer | Normal | |
| 2 | Gen. Bus. Posting Group | Code | Normal | → Gen. Business Posting Group #250 |
| 3 | Gen. Prod. Posting Group | Code | Normal | → Gen. Product Posting Group #251 |
| 4 | Posting Date | Date | Normal | |
| 5 | Document No. | Code | Normal | |
| 6 | Document Type | Option | Normal | |
| 7 | Type | Option | Normal | |
| 8 | Base | Decimal | Normal | |
| 9 | Amount | Decimal | Normal | |
| 10 | VAT Calculation Type | Option | Normal | |
| 12 | Bill-to/Pay-to No. | Code | Normal | |
| 13 | EU 3-Party Trade | Boolean | Normal | |
| 14 | User ID | Code | Normal | |
| 15 | Source Code | Code | Normal | → Source Code #230 |
| 16 | Reason Code | Code | Normal | → Reason Code #231 |
| 17 | Closed by Entry No. | Integer | Normal | → VAT Entry #254 |
| 18 | Closed | Boolean | Normal | |
| 19 | Country/Region Code | Code | Normal | → Country/Region #9 |
| 20 | Internal Ref. No. | Text | Normal | |
| 21 | Transaction No. | Integer | Normal | |
| 22 | Unrealized Amount | Decimal | Normal | |
| 23 | Unrealized Base | Decimal | Normal | |
| 24 | Remaining Unrealized Amount | Decimal | Normal | |
| 25 | Remaining Unrealized Base | Decimal | Normal | |
| 26 | External Document No. | Code | Normal | |
| 28 | No. Series | Code | Normal | → No. Series #308 |
| 29 | Tax Area Code | Code | Normal | → Tax Area #318 |
| 30 | Tax Liable | Boolean | Normal | |
| 31 | Tax Group Code | Code | Normal | → Tax Group #321 |
| 32 | Use Tax | Boolean | Normal | |
| 33 | Tax Jurisdiction Code | Code | Normal | → Tax Jurisdiction #320 |
| 34 | Tax Group Used | Code | Normal | → Tax Group #321 |
| 35 | Tax Type | Option | Normal | |
| 36 | Tax on Tax | Boolean | Normal | |
| 37 | Sales Tax Connection No. | Integer | Normal | |
| 38 | Unrealized VAT Entry No. | Integer | Normal | → VAT Entry #254 |
| 39 | VAT Bus. Posting Group | Code | Normal | → VAT Business Posting Group #323 |
| 40 | VAT Prod. Posting Group | Code | Normal | → VAT Product Posting Group #324 |
| 43 | Additional-Currency Amount | Decimal | Normal | |
| 44 | Additional-Currency Base | Decimal | Normal | |
| 45 | Add.-Currency Unrealized Amt. | Decimal | Normal | |
| 46 | Add.-Currency Unrealized Base | Decimal | Normal | |
| 48 | VAT Base Discount % | Decimal | Normal | |
| 49 | Add.-Curr. Rem. Unreal. Amount | Decimal | Normal | |
| 50 | Add.-Curr. Rem. Unreal. Base | Decimal | Normal | |
| 51 | VAT Difference | Decimal | Normal | |
| 52 | Add.-Curr. VAT Difference | Decimal | Normal | |
| 53 | Ship-to/Order Address Code | Code | Normal | |
| 54 | Document Date | Date | Normal | |
| 55 | VAT Registration No. | Text | Normal | |
| 56 | Reversed | Boolean | Normal | |
| 57 | Reversed by Entry No. | Integer | Normal | → VAT Entry #254 |
| 58 | Reversed Entry No. | Integer | Normal | → VAT Entry #254 |
| 59 | EU Service | Boolean | Normal | |
| 60 | Base Before Pmt. Disc. | Decimal | Normal | |
| 81 | Realized Amount | Decimal | Normal | |
| 82 | Realized Base | Decimal | Normal | |
| 83 | Add.-Curr. Realized Amount | Decimal | Normal | |
| 84 | Add.-Curr. Realized Base | Decimal | Normal | |
| 1570 | Indentation | Integer | Normal | |
| 1571 | VAT Entry No. | Integer | Normal | |
| 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 VAT Entry Posting Preview table through TableRelation properties.