AWH3 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Finance /

Value Range

API AWH3

AWH3 - Value Range Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
AbsId	Internal Number	Int	11
WTCode ^KEY ^UNIQUE	WTax Code	nVarChar	4	OWHT Withholding Tax		PRIMARY	Yes
EfctFrom	Effective from	Date	8
ValueFrom	Value From	Num	20
Deduct	WTax to Be Deductible	Num	20
Rate	Rate	Num	20
WTCur	Currency	nVarChar	3
LogInstanc	Log Instance	Int	11		0
LineNum	Row Number	Int	11
SeqNum	Sequence Number	Int	11

SELECT statement

SELECT
   AWH3.AbsId AS 'Internal Number', 
   AWH3.WTCode AS 'WTax Code', 
   AWH3.EfctFrom AS 'Effective from', 
   AWH3.ValueFrom AS 'Value From', 
   AWH3.Deduct AS 'WTax to Be Deductible', 
   AWH3.Rate AS 'Rate', 
   AWH3.WTCur AS 'Currency', 
   AWH3.LogInstanc AS 'Log Instance', 
   AWH3.LineNum AS 'Row Number', 
   AWH3.SeqNum AS 'Sequence Number'
FROM AWH3 AS AWH3

Related information

OWHT SQL Table

biuan SAP® BUSINESS ONE

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