biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Tax Groups
API OVTG / Vat Groups
OVTG - Tax Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
8
PRIMARYYes
Name KEYNamenVarChar
50
GROUP_NAMENo
RateRate %Num
20
EffecDateEffective fromDate
8
CategoryCategoryVarChar
O) Output Tax
I) Input Tax
1
O
AccountTax AccountnVarChar
15OACT
G/L Accounts
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
IsECEUVarChar
Y) Yes
N) No
1
N
IndicatorTriangular DealVarChar
1OIND
Triangular Deal
AcqstnRvrsAcquisition/ReverseVarChar
Y) Yes
N) No
1
N
NonDedctNon Deduct. %Num
20
AcqsTaxAcquisition Tax AccountnVarChar
15OACT
G/L Accounts
GoddsShipGoods ShipmentVarChar
1OGSP
Goods Shipment
NonDedAccNon Deduct. AcctnVarChar
15OACT
G/L Accounts
DeferrAccDeferred Tax AccountnVarChar
15OACT
G/L Accounts
EquVatPrEqualization Tax %Num
20
ReportCodeGroup DescriptionnVarChar
100
FixdAsstsFixed Assets FlagVarChar
Y) Yes
N) No
1
N
CalcMethodCalculation MethodVarChar
R) Rate
F) Fixed
1
R
TaxTypeTax Type (VAT or Stamp)VarChar
V) VAT
S) Stamp
1
V
FixedAmntFixed Amount (LC)Num
20
ExtCodeExternal CodenVarChar
10
CorrectionCorrectionVarChar
Y) Yes
N) No
1
N
VatCrctnVAT CorrectionnVarChar
8OVTG
Tax Definition
RetVatCodeReturning VAT CodenVarChar
8
RepTypeReport TypeInt
11OKRT
Tax Report Type
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
TaxCtgrTax Type (Annual List)VarChar
E) Excluded
T) Taxable
X) Exempt
N) Not Taxable
G) Gross Profit
R) Reverse Charge
U) Tourism
A) Taxable - Article 162
B) Taxable - Article 173 point 5
C) Taxable - Construction
D) Taxable - Expected Confirmation
F) Taxable - Gross
I) Taxable - Import
Y) Taxable - Import from BY
L) Taxable - Late Export
O) Taxable - Not Confirmed
S) Taxable - Real Estate
W) Taxable - Sale of Company
1
E
EquAccountEqualization Tax AccountnVarChar
15OACT
G/L Accounts
UserSign2Updating UserInt
6OUSR
Users
IsIGICIGICVarChar
Y) Yes
N) No
1
N
ServSupplyService SupplyVarChar
1OSSP
Service Supply
InactiveInactiveVarChar
Y) Yes
N) No
1
N
TaxCtgrBLTax Type (Black List)VarChar
E) Excluded
T) Taxable
X) Exempt
N) Not Taxable
S) Non-Subject
1
E
R349CodeReport 349 CodeInt
0
1) E
2) A
3) T
4) S
5) I
6) M
7) H
11
0
VatRevAccVAT in Revenue AccountnVarChar
15OACT
G/L Accounts
CashDisAccCash Discount AccountnVarChar
15OACT
G/L Accounts
DpmTaxOAccDown Paymnt Tax Offset AccountnVarChar
15OACT
G/L Accounts
VatDedAccVAT Deductible AccountnVarChar
15OACT
G/L Accounts
CstmExpAccCustoms VAT Expense AccountnVarChar
15
CstmAlcAccCustoms VAT Allocation AccountnVarChar
15
TaxRegionTax Country RegionnVarChar
PT) Continental Portugal
PT-AC) Azores Islands
PT-MA) Madeira Islands
5
PT
ExemReasonTax Exemption ReasonnVarChar
M01) Article 16th No. 6 of CIVA
M02) Article 6th Law 198/90 June 19th
M03) Cash Liabilities
M04) Exempt Article 13th of CIVA
M05) Exempt Article 14th of CIVA
M06) Exempt Article 15th of CIVA
M07) Exempt Article 9th of CIVA
M08) VAT - Self-Liquidation
M09) VAT - Non-Deductible
M10) VAT - Exempted Company
M11) VAT - Exempted (Tobacco)
M12) VAT - Exempted (Travel Agencies)
M13) VAT - Exempt (Second Hand Goods)
M14) VAT - Exempted (Objects of Art)
M15) VAT - Exempted (Collectibles and Antiques)
M16) VAT - Exempted (Article 14th of RITI)
M99) Not Subject to VAT
3
AgentAgentVarChar
Y) Yes
N) No
1
N
OpCodeTax Operation CodenVarChar
7
ExportExportVarChar
Y) Yes
N) No
1
N
SectionVAT SectionnVarChar
2
SplitPaymtSplit PaymentVarChar
Y) Yes
N) No
1
N
SplitPayAcSplit Payment AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT OVTG.Code AS 'Code', OVTG.Name AS 'Name', OVTG.Rate AS 'Rate %', OVTG.EffecDate AS 'Effective from', OVTG.Category AS 'Category', OVTG.Account AS 'Tax Account', OVTG.Locked AS 'Locked', OVTG.DataSource AS 'Data Source', OVTG.UserSign AS 'User Signature', OVTG.IsEC AS 'EU', OVTG.Indicator AS 'Triangular Deal', OVTG.AcqstnRvrs AS 'Acquisition/Reverse', OVTG.NonDedct AS 'Non Deduct. %', OVTG.AcqsTax AS 'Acquisition Tax Account', OVTG.GoddsShip AS 'Goods Shipment', OVTG.NonDedAcc AS 'Non Deduct. Acct', OVTG.DeferrAcc AS 'Deferred Tax Account', OVTG.EquVatPr AS 'Equalization Tax %', OVTG.ReportCode AS 'Group Description', OVTG.FixdAssts AS 'Fixed Assets Flag', OVTG.CalcMethod AS 'Calculation Method', OVTG.TaxType AS 'Tax Type (VAT or Stamp)', OVTG.FixedAmnt AS 'Fixed Amount (LC)', OVTG.ExtCode AS 'External Code', OVTG.Correction AS 'Correction', OVTG.VatCrctn AS 'VAT Correction', OVTG.RetVatCode AS 'Returning VAT Code', OVTG.RepType AS 'Report Type', OVTG.LogInstanc AS 'Log Instance', OVTG.UpdateDate AS 'Date of Update', OVTG.TaxCtgr AS 'Tax Type (Annual List)', OVTG.EquAccount AS 'Equalization Tax Account', OVTG.UserSign2 AS 'Updating User', OVTG.IsIGIC AS 'IGIC', OVTG.ServSupply AS 'Service Supply', OVTG.Inactive AS 'Inactive', OVTG.TaxCtgrBL AS 'Tax Type (Black List)', OVTG.R349Code AS 'Report 349 Code', OVTG.VatRevAcc AS 'VAT in Revenue Account', OVTG.CashDisAcc AS 'Cash Discount Account', OVTG.DpmTaxOAcc AS 'Down Paymnt Tax Offset Account', OVTG.VatDedAcc AS 'VAT Deductible Account', OVTG.CstmExpAcc AS 'Customs VAT Expense Account', OVTG.CstmAlcAcc AS 'Customs VAT Allocation Account', OVTG.TaxRegion AS 'Tax Country Region', OVTG.ExemReason AS 'Tax Exemption Reason', OVTG.Agent AS 'Agent', OVTG.OpCode AS 'Tax Operation Code', OVTG.Export AS 'Export', OVTG.Section AS 'VAT Section', OVTG.SplitPaymt AS 'Split Payment', OVTG.SplitPayAc AS 'Split Payment Account' FROM OVTG AS OVTG

Related information


Vat Groups VatGroups Object· Table: OVTG
The VatGroups object enables to define tax groups that can be assigned to business partners and items in sales and purchase documents. Source table: OVTG.

Tax Definition OVTG SQL Table

Goods Shipment OGSP SQL Table

Triangular Deal OIND SQL Table

Tax Report Type OKRT SQL Table

Service Supply OSSP SQL Table

Users OUSR SQL Table



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