biuan SAP® BUSINESS ONE SDK
API AWH2
AWH2 - WTax 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 AWH2.AbsEntry AS 'Numerator', AWH2.Code AS 'Tax Code', AWH2.EffectDate AS 'Date Effective', AWH2.Rate AS 'Tax Rate', AWH2.MinAmount AS 'Min. Amount', AWH2.MaxAmount AS 'Max. Amount', AWH2.WTCUR AS 'Progressive Tax Currency', AWH2.LogInstanc AS 'Log Instance', AWH2.LineNum AS 'Row Number', AWH2.SeqNum AS 'Sequence Number' FROM AWH2 AS AWH2

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