biuan SAP® BUSINESS ONE SDK
API WHT2
WHT2 - Withholding Tax Definition - Rows2 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntryNumeratorInt
11
Code KEY UNIQUETax CodenVarChar
4OWHT
Withholding Tax
PRIMARYYes
EffectDateDate EffectiveDate
8
RateTax RateNum
20
MinAmountMin. AmountNum
20
MaxAmountMax. AmountNum
20
WTCURProgressive Tax CurrencynVarChar
3OCRN
Currency Codes
LogInstancLog InstanceInt
11
0
LineNumRow NumberInt
11
SeqNumSequence NumberInt
11

Table relationship map

SELECT statement

SELECT WHT2.AbsEntry AS 'Numerator', WHT2.Code AS 'Tax Code', WHT2.EffectDate AS 'Date Effective', WHT2.Rate AS 'Tax Rate', WHT2.MinAmount AS 'Min. Amount', WHT2.MaxAmount AS 'Max. Amount', WHT2.WTCUR AS 'Progressive Tax Currency', WHT2.LogInstanc AS 'Log Instance', WHT2.LineNum AS 'Row Number', WHT2.SeqNum AS 'Sequence Number' FROM WHT2 AS WHT2

Related information


Withholding Tax OWHT SQL Table

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