biuan SAP® BUSINESS ONE SDK
SQL Finance / Tax Definition
API AVT1
AVT1 - 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 AVT1.Code AS 'Group Code', AVT1.EffecDate AS 'Effective from', AVT1.Rate AS 'Rate', AVT1.EquVatPr AS 'Equalization Tax %', AVT1.MinAmount AS 'Minimum Stamp Tax Amount', AVT1.FixedAmout AS 'Fixed Stamp Tax Amount', AVT1.TaxType AS 'Tax Type (VAT or Stamp)', AVT1.LogInstanc AS 'Log Instance', AVT1.DatevCode AS 'DATEV Code' FROM AVT1 AS AVT1

Related information
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