VAT Posting Setup #325

Other table in Microsoft Dynamics 365 Business Central. 29 fields, 18 records in Cronus demo.

29
Fields
18
Records
2
Primary key
0
FlowFields
14
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: VAT Bus. Posting Group, VAT Prod. Posting Group.

All fields (29)

VAT Posting Setup — FIELDS
NO.FIELDTYPECLASSRELATION
1 VAT Bus. Posting Group PK Code Normal → VAT Business Posting Group #323
2 VAT Prod. Posting Group PK Code Normal → VAT Product Posting Group #324
3 VAT Calculation Type Option Normal
4 VAT % Decimal Normal
5 Unrealized VAT Type Option Normal
6 Adjust for Payment Discount Boolean Normal
7 Sales VAT Account Code Normal → G/L Account #15
8 Sales VAT Unreal. Account Code Normal → G/L Account #15
9 Purchase VAT Account Code Normal → G/L Account #15
10 Purch. VAT Unreal. Account Code Normal → G/L Account #15
11 Reverse Chrg. VAT Acc. Code Normal → G/L Account #15
12 Reverse Chrg. VAT Unreal. Acc. Code Normal → G/L Account #15
13 VAT Identifier Code Normal
14 EU Service Boolean Normal
15 VAT Clause Code Code Normal → VAT Clause #560
16 Certificate of Supply Required Boolean Normal
17 Tax Category Code Normal
20 Description Text Normal
21 Blocked Boolean Normal
25 Sale VAT Reporting Code Code Normal → VAT Reporting Code #344
26 Purchase VAT Reporting Code Code Normal → VAT Reporting Code #344
6200 Non-Deductible VAT % Decimal Normal
6202 Non-Deductible Purchase VAT Account Code Normal → G/L Account #15
6203 Allow Non-Deductible VAT Option 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 (6)

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

VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
G/L Account
#15 · General Ledger · via Sales VAT Account, Sales VAT Unreal. Account, Purchase VAT Account, Purch. VAT Unreal. Account, Reverse Chrg. VAT Acc., Reverse Chrg. VAT Unreal. Acc., Non-Deductible Purchase VAT Account
VAT Clause
#560 · Other · via VAT Clause Code
VAT Reporting Code
#344 · Other · via Sale VAT Reporting Code, Purchase VAT Reporting Code