biuan SAP® BUSINESS ONE SDK
SQL Finance / Tax Groups / Tax Groups
DTW Tax Groups
API Tax Report Groups / Tax Report Group
VTR1 - Tax Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbs Entry (Numerator)Int
11
PRIMARYYes
ObjectCodeObject CodenVarChar
30
SumSumVarChar
Y) Yes
N) No
1
N
DispOrderDisplay OrderInt
11
ObjectTypeObject TypeVarChar
1
SelectedSelected ObjectVarChar
Y) Yes
N) No
1
FromObjectFrom ObjectnVarChar
20
ToObjectTo ObjectnVarChar
20
Adtnl_KeyAdditional KeyVarChar
1
AmountAmountNum
20

SELECT statement

SELECT VTR1.AbsEntry AS 'Abs Entry (Numerator)', VTR1.ObjectCode AS 'Object Code', VTR1.Sum AS 'Sum', VTR1.DispOrder AS 'Display Order', VTR1.ObjectType AS 'Object Type', VTR1.Selected AS 'Selected Object', VTR1.FromObject AS 'From Object', VTR1.ToObject AS 'To Object', VTR1.Adtnl_Key AS 'Additional Key', VTR1.Amount AS 'Amount' FROM VTR1 AS VTR1

Related information


Tax Report Group TaxReportGroup Object· Table: VTR1
TaxReportGroup is a data structure related to the TaxReportsService. Source table: VTR1.
   Parent: Tax Report Groups TaxReportGroups Collection· Table: VTR1

Tax Report Groups TaxReportGroups Collection· Table: VTR1
TaxReportGroups is a Data Collection of TaxReportGroupss. Source table: VTR1.
   Parent: Tax Report Filter TaxReportFilter Object· Table: OVTR


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