VAT Amount Line #290

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

The VAT Amount Line table (ID 290) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 34 fields, with a primary key of VAT Identifier, VAT Calculation Type, Tax Group Code, Use Tax, Positive. Use the reference below to explore every field, data type, and table relation.

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: VAT Identifier, VAT Calculation Type, Tax Group Code, Use Tax, Positive.

All fields (34)

VAT Amount Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	VAT %	Decimal	Normal
2	VAT Base	Decimal	Normal
3	VAT Amount	Decimal	Normal
4	Amount Including VAT	Decimal	Normal
5	VAT Identifier PK	Code	Normal
6	Line Amount	Decimal	Normal
7	Inv. Disc. Base Amount	Decimal	Normal
8	Invoice Discount Amount	Decimal	Normal
9	VAT Calculation Type PK	Option	Normal
10	Tax Group Code PK	Code	Normal	→ Tax Group #321
11	Quantity	Decimal	Normal
12	Modified	Boolean	Normal
13	Use Tax PK	Boolean	Normal
14	Calculated VAT Amount	Decimal	Normal
15	VAT Difference	Decimal	Normal
16	Positive PK	Boolean	Normal
17	Includes Prepayment	Boolean	Normal
18	VAT Clause Code	Code	Normal	→ VAT Clause #560
19	Tax Category	Code	Normal
20	Pmt. Discount Amount	Decimal	Normal
6200	Non-Deductible VAT %	Decimal	Normal
6201	Non-Deductible VAT Base	Decimal	Normal
6202	Non-Deductible VAT Amount	Decimal	Normal
6203	Calculated Non-Deductible VAT Amount	Decimal	Normal
6204	Deductible VAT Base	Decimal	Normal
6205	Deductible VAT Amount	Decimal	Normal
6206	Non-Deductible VAT Difference	Decimal	Normal
10500	Reverse Charge	Decimal	Normal
10507	Reverse Charge	Decimal	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 (3)

Tables referenced by fields on the VAT Amount Line table through TableRelation properties.

Tax Group

#321 · Other · via Tax Group Code

VAT Clause

#560 · Other · via VAT Clause Code