biuan SAP® BUSINESS ONE SDK
SQL Finance / Withholding Tax / Withholding Tax Definition
DTW Administration / Setup / Financials / Tax / Withholding Tax / Withholding Tax Definition
API Withholding Tax Codes / Withholding Tax Codes Lines
WHT1 - Withholding Tax Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WTCode KEY UNIQUEWTax CodenVarChar
4OWHT
Withholding Tax		PRIMARYYes
EffecDateEffective FromDate
8
RateRateNum
20
LogInstancLog InstanceInt
11
0
TdsRateTDS RateNum
20
SurRateSurcharge RateNum
20
CessRateCess RateNum
20
HscRateHSC RateNum
20
PmntTermsPayment TermsInt
6OCTG
Payment Terms
LineNumRow NumberInt
11

Table relationship map

SELECT statement

SELECT WHT1.WTCode AS 'WTax Code', WHT1.EffecDate AS 'Effective From', WHT1.Rate AS 'Rate', WHT1.LogInstanc AS 'Log Instance', WHT1.TdsRate AS 'TDS Rate', WHT1.SurRate AS 'Surcharge Rate', WHT1.CessRate AS 'Cess Rate', WHT1.HscRate AS 'HSC Rate', WHT1.PmntTerms AS 'Payment Terms', WHT1.LineNum AS 'Row Number' FROM WHT1 AS WHT1

Related information


Withholding Tax Codes Lines WithholdingTaxCodes_Lines Object· Table: WHT1
WithholdingTaxCodes_Lines is a child object of the WithholdingTaxCodes object. It enables to define the tax percentage and the effective from date for the withholding tax code. Source table: WHT1.
   Parent: Withholding Tax Codes WithholdingTaxCodes Object· Table: OWHT
Payment Terms OCTG SQL Table

Withholding Tax OWHT 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