biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Withholding Tax
API OWHT / / Withholding Tax Codes
OWHT - Withholding Tax Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WTCode KEY UNIQUEWTax CodenVarChar
4
PRIMARYYes
WTName KEYWTax NamenVarChar
50
WT_NAMENo
RateRateNum
20
EffecDateEffective FromDate
8
CategoryCategoryVarChar
I) Invoice
P) Payment
1
P
BaseTypeBase TypeVarChar
G) Gross
N) Net
V) VAT
1
N
PrctBsAmnt% Base AmountNum
20
OffclCodeOfficial CodenVarChar
15
AccountAccountnVarChar
15OACT
G/L Accounts
MinTaxAmtMinimum Taxable AmountNum
20
IsPrgrssProgressive TaxVarChar
Y) Progressive Tax
N) Not Progressive Tax
1
N
TypeWithholding TypeVarChar
V) VAT Withholding
I) Income Tax Withholding
1
V
RoundTypeRounding TypeVarChar
T) Truncated AU
C) Commercial Values
N) No Rounding
1
C
WTTypeIdTypeInt
11OWTT
Withholding Tax Type
WTCurrencyCurrencynVarChar
3OCRN
Currency Codes
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6OUSR
Users
SectionSectionInt
11OSEC
Sections
ThresholdThresholdNum
20
SurchargeSurchargeNum
20
ConcessConcessionalVarChar
Y) Yes
N) No
1
N
AssesseeAssesseeInt
11ONOA
Nature of Assessee
ApTdsAccA/P TDS AccountnVarChar
15OACT
G/L Accounts
ApSurAccA/P Surcharge AccountnVarChar
15OACT
G/L Accounts
ApCessAccA/P Cess AccountnVarChar
15OACT
G/L Accounts
ApHscAccA/P HSC AccountnVarChar
15OACT
G/L Accounts
ArTdsAccA/R TDS AccountnVarChar
15OACT
G/L Accounts
ArSurAccA/R Surcharge AccountnVarChar
15OACT
G/L Accounts
ArCessAccA/R Cess AccountnVarChar
15OACT
G/L Accounts
ArHscAccA/R HSC AccountnVarChar
15OACT
G/L Accounts
LocationLocationInt
11OLCT
Location
ReturnTypeReturn TypeVarChar
A) 26
B) 27
1
UserSign2Updating UserInt
6OUSR
Users
InactiveInactiveVarChar
Y) Yes
N) No
1
N
InCSTCodeCST Code IncomingInt
11OTSC
CST Code for Nota Fiscal
-1
OutCSTCodeCST Code OutgoingInt
11OTSC
CST Code for Nota Fiscal
-1
CalBaseNNature of Calculation BasenVarChar
2OBSI
Brazil String Indexer
PymntRsnCdPayment Reason CodenVarChar
2OSWA
Specific Withholding Amounts

Table relationship map

SELECT statement

SELECT OWHT.WTCode AS 'WTax Code', OWHT.WTName AS 'WTax Name', OWHT.Rate AS 'Rate', OWHT.EffecDate AS 'Effective From', OWHT.Category AS 'Category', OWHT.BaseType AS 'Base Type', OWHT.PrctBsAmnt AS '% Base Amount', OWHT.OffclCode AS 'Official Code', OWHT.Account AS 'Account', OWHT.MinTaxAmt AS 'Minimum Taxable Amount', OWHT.IsPrgrss AS 'Progressive Tax', OWHT.Type AS 'Withholding Type', OWHT.RoundType AS 'Rounding Type', OWHT.WTTypeId AS 'Type', OWHT.WTCurrency AS 'Currency', OWHT.LogInstanc AS 'Log Instance', OWHT.UpdateDate AS 'Date of Update', OWHT.UserSign AS 'User Signature', OWHT.Section AS 'Section', OWHT.Threshold AS 'Threshold', OWHT.Surcharge AS 'Surcharge', OWHT.Concess AS 'Concessional', OWHT.Assessee AS 'Assessee', OWHT.ApTdsAcc AS 'A/P TDS Account', OWHT.ApSurAcc AS 'A/P Surcharge Account', OWHT.ApCessAcc AS 'A/P Cess Account', OWHT.ApHscAcc AS 'A/P HSC Account', OWHT.ArTdsAcc AS 'A/R TDS Account', OWHT.ArSurAcc AS 'A/R Surcharge Account', OWHT.ArCessAcc AS 'A/R Cess Account', OWHT.ArHscAcc AS 'A/R HSC Account', OWHT.Location AS 'Location', OWHT.ReturnType AS 'Return Type', OWHT.UserSign2 AS 'Updating User', OWHT.Inactive AS 'Inactive', OWHT.InCSTCode AS 'CST Code Incoming', OWHT.OutCSTCode AS 'CST Code Outgoing', OWHT.CalBaseN AS 'Nature of Calculation Base', OWHT.PymntRsnCd AS 'Payment Reason Code' FROM OWHT AS OWHT

Related information


Withholding Tax Codes WithholdingTaxCodes Object· Table: OWHT
The WithholdingTaxCodes object enables to define the system withholding tax codes that can be applied to business partners, payments, and documents. Source table: OWHT.

OWHT SQL Table

G/L Accounts OACT SQL Table

Nature of Assessee ONOA SQL Table

Brazil String Indexer OBSI SQL Table

CST Code for Nota Fiscal OTSC SQL Table

Location OLCT SQL Table

Specific Withholding Amounts OSWA SQL Table

Sections OSEC SQL Table

Users OUSR SQL Table

Currency Codes OCRN 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