|
|
SQL Finance / Value Range
API WHT3
WHT3 - Value Range Table
Withholding Tax OWHT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | 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
WHT3.AbsId AS 'Internal Number',
WHT3.WTCode AS 'WTax Code',
WHT3.EfctFrom AS 'Effective From',
WHT3.ValueFrom AS 'Value From',
WHT3.Deduct AS 'WTax to Be Deductible',
WHT3.Rate AS 'Rate',
WHT3.WTCur AS 'Currency',
WHT3.LogInstanc AS 'Log Instance',
WHT3.LineNum AS 'Row Number',
WHT3.SeqNum AS 'Sequence Number'
FROM WHT3 AS WHT3
Related information
Withholding Tax OWHT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates