biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Withholding Tax Definition
API Witholding Tax Definition Service / WTD Code
OWTD - Withholding Tax Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
WTCode KEY UNIQUEWTax CodenVarChar
4
WT_CODEYes
WTName KEYWTax Code NamenVarChar
50
WT_NAMENo
RateRateNum
20
EffecDateEffective FromDate
8
InactiveInactiveVarChar
Y)
N)
1
N
OffclCodeOfficial CodenVarChar
15
CategoryCategoryVarChar
I) Invoice
P) Payment
1
P
BaseTypeBase TypeVarChar
G) Gross
N) Net
V) VAT
1
N
WTTypeIdTypeInt
11OWTT
Withholding Tax Type
BaseMinMin. AmountNum
20
PrctBsAmnt% Base AmountNum
20
FmlIdFormula IDInt
11OFML
Tax Formula Master Table
AccountAccountnVarChar
15OACT
G/L Accounts
SlScProgrSliding Scale Progressive TaxVarChar
Y)
N)
1
N
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OWTD.AbsEntry AS 'Internal Number', OWTD.WTCode AS 'WTax Code', OWTD.WTName AS 'WTax Code Name', OWTD.Rate AS 'Rate', OWTD.EffecDate AS 'Effective From', OWTD.Inactive AS 'Inactive', OWTD.OffclCode AS 'Official Code', OWTD.Category AS 'Category', OWTD.BaseType AS 'Base Type', OWTD.WTTypeId AS 'Type', OWTD.BaseMin AS 'Min. Amount', OWTD.PrctBsAmnt AS '% Base Amount', OWTD.FmlId AS 'Formula ID', OWTD.Account AS 'Account', OWTD.SlScProgr AS 'Sliding Scale Progressive Tax', OWTD.LogInstanc AS 'Log Instance', OWTD.UpdateDate AS 'Date of Update', OWTD.UserSign AS 'User Signature', OWTD.UserSign2 AS 'Updating User' FROM OWTD AS OWTD

Related information


WTD Code WTDCode Object· Table: OWTD
WTDCode Class
   Parent: Witholding Tax Definition Service WitholdingTaxDefinitionService Service
G/L Accounts OACT SQL Table

Tax Formula Master Table OFML SQL Table

Users OUSR SQL Table

Withholding Tax Type OWTT SQL Table



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