biuan SAP® BUSINESS ONE SDK
SQL Finance / Tax Definition / Tax Definition
DTW Administration / Setup / Financials / Tax / Tax Groups / Tax Definition
API Vat Groups / Vat Groups Lines
VTG1 - Tax Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEGroup CodenVarChar
8
PRIMARYYes
EffecDateEffective FromDate
8
RateRateNum
20
EquVatPrEqualization Tax %Num
20
MinAmountMinimum Stamp Tax AmountNum
20
FixedAmoutFixed Stamp Tax AmountNum
20
TaxTypeTax Type (VAT or Stamp)VarChar
V) VAT
S) Stamp
1
V
LogInstancLog InstanceInt
11
0
DatevCodeDATEV CodeInt
6

SELECT statement

SELECT VTG1.Code AS 'Group Code', VTG1.EffecDate AS 'Effective From', VTG1.Rate AS 'Rate', VTG1.EquVatPr AS 'Equalization Tax %', VTG1.MinAmount AS 'Minimum Stamp Tax Amount', VTG1.FixedAmout AS 'Fixed Stamp Tax Amount', VTG1.TaxType AS 'Tax Type (VAT or Stamp)', VTG1.LogInstanc AS 'Log Instance', VTG1.DatevCode AS 'DATEV Code' FROM VTG1 AS VTG1

Related information


Vat Groups Lines VatGroups_Lines Object· Table: VTG1
VatGroups_Lines is a child object of the VatGroups_Lines object. It enables to define the tax percentage and the effective from date for the tax group. Source table: VTG1.
   Parent: Vat Groups VatGroups Object· Table: OVTG


SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates