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

SQL

Finance /

Withholding Tax Definition - Rows2

API WHT2

WHT2 - Withholding Tax Definition - Rows2 Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
AbsEntry	Numerator	Int	11
Code ^KEY ^UNIQUE	Tax Code	nVarChar	4	OWHT Withholding Tax		PRIMARY	Yes
EffectDate	Date Effective	Date	8
Rate	Tax Rate	Num	20
MinAmount	Min. Amount	Num	20
MaxAmount	Max. Amount	Num	20
WTCUR	Progressive Tax Currency	nVarChar	3	OCRN Currency Codes
LogInstanc	Log Instance	Int	11		0
LineNum	Row Number	Int	11
SeqNum	Sequence Number	Int	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

OWHT SQL Table

OCRN 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