biuan SAP® BUSINESS ONE SDK
SQL Finance / Withholding Tax Definition
API AWTD
AWTD - Withholding Tax Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntryInternal NumberInt
11
WTCode KEY UNIQUEWTax CodenVarChar
4
PRIMARYYes
WTNameWTax NamenVarChar
50
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 AWTD.AbsEntry AS 'Internal Number', AWTD.WTCode AS 'WTax Code', AWTD.WTName AS 'WTax Name', AWTD.Rate AS 'Rate', AWTD.EffecDate AS 'Effective From', AWTD.Inactive AS 'Inactive', AWTD.OffclCode AS 'Official Code', AWTD.Category AS 'Category', AWTD.BaseType AS 'Base Type', AWTD.WTTypeId AS 'Type', AWTD.BaseMin AS 'Min. Amount', AWTD.PrctBsAmnt AS '% Base Amount', AWTD.FmlId AS 'Formula ID', AWTD.Account AS 'Account', AWTD.SlScProgr AS 'Sliding Scale Progressive Tax', AWTD.LogInstanc AS 'Log Instance', AWTD.UpdateDate AS 'Date of Update', AWTD.UserSign AS 'User Signature', AWTD.UserSign2 AS 'Updating User' FROM AWTD AS AWTD

Related information


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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates