VAT Entry Posting Preview #1571

Other table in Microsoft Dynamics 365 Business Central. 66 fields, 0 records in Cronus demo.

66
Fields
0
Records
1
Primary key
0
FlowFields
18
Relations
Open in Data Explorer →

Primary key

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

All fields (66)

VAT Entry Posting Preview — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (13)

Tables referenced by fields on the VAT Entry Posting Preview table through TableRelation properties.

Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
VAT Entry
#254 · Ledger Entries · via Closed by Entry No., Unrealized VAT Entry No., Reversed by Entry No., Reversed Entry No.
Country/Region
#9 · General Ledger · via Country/Region Code
No. Series
#308 · Other · via No. Series
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code, Tax Group Used
Tax Jurisdiction
#320 · Other · via Tax Jurisdiction Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group