biuan SAP® BUSINESS ONE SDK
API AWH1
AWH1 - 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 AWH1.WTCode AS 'WTax Code', AWH1.EffecDate AS 'Effective from', AWH1.Rate AS 'Rate', AWH1.LogInstanc AS 'Log Instance', AWH1.TdsRate AS 'TDS Rate', AWH1.SurRate AS 'Surcharge Rate', AWH1.CessRate AS 'Cess Rate', AWH1.HscRate AS 'HSC Rate', AWH1.PmntTerms AS 'Payment Terms', AWH1.LineNum AS 'Row Number' FROM AWH1 AS AWH1

Related information


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