Objects/Tables/Table 290 VAT Amount Line

Table 290 VAT Amount Line in 27

Jonas Paprotka, Base Application 27.5.46862.47359, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Finance.VAT.Calculation
Obsolete: Pending 25.0. Table will be made Temporary.

Fields, 27 Keys, 1 Procedures, 31 Events, 31

Versions17 18 19 20 21 22 23 24 25 262728 latest

Source29

Fields, 27

Id	Name	Type	Obsolete
1	VAT %	Decimal	-
2	VAT Base	Decimal	-
3	VAT Amount	Decimal	-
4	Amount Including VAT	Decimal	-
5	VAT Identifier	Code[20]	-
6	Line Amount	Decimal	-
7	Inv. Disc. Base Amount	Decimal	-
8	Invoice Discount Amount	Decimal	-
9	VAT Calculation Type	Enum Tax Calculation Type	-
10	Tax Group Code	Code[20]	-
11	Quantity	Decimal	-
12	Modified	Boolean	-
13	Use Tax	Boolean	-
14	Calculated VAT Amount	Decimal	-
15	VAT Difference	Decimal	-
16	Positive	Boolean	-
17	Includes Prepayment	Boolean	-
18	VAT Clause Code	Code[20]	-
19	Tax Category	Code[10]	-
20	Pmt. Discount Amount	Decimal	-
6200	Non-Deductible VAT %	Decimal	-
6201	Non-Deductible VAT Base	Decimal	-
6202	Non-Deductible VAT Amount	Decimal	-
6203	Calc. Non-Ded. VAT Amount	Decimal	-
6204	Deductible VAT Base	Decimal	-
6205	Deductible VAT Amount	Decimal	-
6206	Non-Deductible VAT Diff.	Decimal	-

Keys, 1

Name	Fields	Obsolete
Key1, clustered	VAT Identifier, VAT Calculation Type, Tax Group Code, Use Tax, Positive	-

Procedures, 31

Name	Parameters	Returns	Access	Obsolete
CheckVATDifference	(Code[10], Boolean)		public	-
InsertLine	()	Boolean	public	-
GetLine	(Integer)		public	-
VATAmountText	()	Text[30]	public	-
GetTotalLineAmount	(Boolean, Code[10])	Decimal	public	-
GetTotalVATAmount	()	Decimal	public	-
GetTotalInvDiscAmount	()	Decimal	public	-
GetTotalInvDiscBaseAmount	(Boolean, Code[10])	Decimal	public	-
GetTotalVATBase	()	Decimal	public	-
GetTotalAmountInclVAT	()	Decimal	public	-
GetTotalVATDiscount	(Code[10], Boolean)	Decimal	public	-
GetAnyLineModified	()	Boolean	public	-
SetInvoiceDiscountAmount	(Decimal, Code[10], Boolean, Decimal)		public	-
SetInvoiceDiscountPercent	(Decimal, Code[10], Boolean, Boolean, Decimal)		public	-
CalcLineAmount	()	Decimal	public	-
CalcVATFields	(Code[10], Boolean, Decimal)		public	-
GetBaseLCY	(Date, Code[10], Decimal)	Decimal	public	-
GetAmountLCY	(Date, Code[10], Decimal)	Decimal	public	-
DeductVATAmountLine	(var Record VAT Amount Line)		public	-
SumLine	(Decimal, Decimal, Decimal, Boolean, Boolean)		public	Pending 25.0
Replaced by procedures using Source Record.
UpdateLines	(var Decimal, Record Currency, Decimal, Boolean, Decimal, Code[20], Boolean, Date)		public	-
CopyFromPurchInvLine	(Record Purch. Inv. Line)		public	-
CopyFromPurchCrMemoLine	(Record Purch. Cr. Memo Line)		public	-
CopyFromSalesInvLine	(Record Sales Invoice Line)		public	-
CopyFromSalesCrMemoLine	(Record Sales Cr.Memo Line)		public	-
CopyFromServInvLine	(Record Service Invoice Line)		public	Pending 25.0
Replaced by procedure CopyToVATAmountLine in table Service Invoice Line
CopyFromServCrMemoLine	(Record Service Cr.Memo Line)		public	Pending 25.0
Replaced by procedure CopyToVATAmountLine in table Service Cr.Memo Line
InsertNewLine	(Code[20], Enum Tax Calculation Type, Code[20], Boolean, Decimal, Boolean, Boolean, Decimal)		public	Pending 26.0
Replaced by procedures using Source Record.
RunOnAfterCopyFromServInvLine	(var Record VAT Amount Line, Record Service Invoice Line)		internal	-
RunOnAfterCopyFromServCrMemoLine	(var Record VAT Amount Line, Record Service Cr.Memo Line)		internal	-
ApplyNonDeductibleVAT	(Decimal)		internal	-

Events, 31

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCalcLineAmount	(var Record VAT Amount Line, var Decimal)	-
Integration event	OnAfterCopyFromPurchInvLine	(var Record VAT Amount Line, Record Purch. Inv. Line)	-
Integration event	OnAfterCopyFromPurchCrMemoLine	(var Record VAT Amount Line, Record Purch. Cr. Memo Line)	-
Integration event	OnAfterCopyFromSalesInvLine	(var Record VAT Amount Line, Record Sales Invoice Line)	-
Integration event	OnAfterCopyFromSalesCrMemoLine	(var Record VAT Amount Line, Record Sales Cr.Memo Line)	-
Integration event	OnAfterCopyFromServInvLine	(var Record VAT Amount Line, Record Service Invoice Line)	Pending 25.0
Replaced by event OnAfterCopyToVATAmountLine in table Service Invoice Line
Integration event	OnAfterCopyFromServCrMemoLine	(var Record VAT Amount Line, Record Service Cr.Memo Line)	Pending 25.0
Replaced by event OnAfterCopyToVATAmountLine in table Service Cr.Memo Line
Integration event	OnAfterSalesTaxCalculateCalculateTax	(var Record VAT Amount Line, Record Currency, Code[20], Boolean, Date, Decimal)	-
Integration event	OnAfterSalesTaxCalculateReverseCalculateTax	(var Record VAT Amount Line, Record Currency, Code[20], Boolean, Date, Decimal)	-
Integration event	OnAfterVATAmountText	(Decimal, Integer, var Text[30])	-
Integration event	OnInsertLineOnBeforeInsert	(var Record VAT Amount Line, var Record VAT Amount Line)	-
Integration event	OnInsertLineOnBeforeModify	(var Record VAT Amount Line, Record VAT Amount Line)	-
Integration event	OnUpdateLinesOnAfterCalcVATAmount	(var Record VAT Amount Line, Record VAT Amount Line, var Record Currency, Decimal, Boolean)	-
Integration event	OnUpdateLinesOnBeforeCalcSalesTaxVatBase	(var Record VAT Amount Line)	-
Integration event	OnBeforeGetTotalVATAmount	(var Record VAT Amount Line, var Decimal, var Boolean)	-
Integration event	OnAfterCheckVATDifference	(Record VAT Amount Line, Code[10], Boolean)	-
Integration event	OnInsertLineOnAfterValidatePositive	(var Record VAT Amount Line)	-
Integration event	OnUpdateLinesOnAfterCalcVATBase	(var Record VAT Amount Line, Record Currency, Boolean)	-
Integration event	OnUpdateLinesOnAfterCalcVATBaseSalesTax	(var Record VAT Amount Line, Record Currency, Boolean)	-
Integration event	OnAfterCalcVATFields	(var Record VAT Amount Line, Boolean, Decimal, Record Currency)	-
Integration event	OnUpdateLinesOnAfterCalcAmountIncludingVATNormalVAT	(var Record VAT Amount Line, Record VAT Amount Line, var Record Currency, Decimal, Boolean)	-
Integration event	OnBeforeCalcVATFields	(var Record VAT Amount Line, var Decimal)	-
Integration event	OnDeductVATAmountLineOnBeforeModify	(var Record VAT Amount Line, Record VAT Amount Line)	-
Integration event	OnBeforeGetVATBaseDiscountPerc	(var Record VAT Amount Line, Decimal, var Decimal, var Boolean)	-
Integration event	OnUpdateLinesOnAfterInitPrevVATAmountLine	(var Record VAT Amount Line, Record Currency, Boolean, var Decimal, var Record VAT Amount Line)	-
Integration event	OnBeforeUpdateLines	(var Record VAT Amount Line, var Decimal, Record Currency, Decimal, Boolean, Decimal, Code[20], Boolean, Date, var Boolean)	-
Integration event	OnApplyNonDeductibleVATOnBeforeModify	(var Record VAT Amount Line, Decimal)	-
Integration event	OnCopyFromPurchInvLineOnAfterSetLineAmount	(var Record VAT Amount Line, var Record Purch. Inv. Line)	-
Integration event	OnCopyFromPurchCrMemoLineOnAfterSetLineAmount	(var Record VAT Amount Line, var Record Purch. Cr. Memo Line)	-
Integration event	OnInsertLine	(var Record VAT Amount Line, var Boolean, var Boolean, var Boolean)	-
Integration event	OnUpdateLinesOnAfterCalcPreVATAmountline	(var Record VAT Amount Line, var Record VAT Amount Line, var Record Currency, Decimal)	-