|
|
DTW Administration / Setup / Financials / Tax / Withholding Tax / Withholding Tax Definition
API Withholding Tax Codes / Withholding Tax Codes Lines
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WTCode KEY UNIQUE | WTax Code | nVarChar | 4 | OWHT Withholding Tax | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| EffecDate | Effective From | Date | 8 | |||||
| Rate | Rate | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| TdsRate | TDS Rate | Num | 20 | |||||
| SurRate | Surcharge Rate | Num | 20 | |||||
| CessRate | Cess Rate | Num | 20 | |||||
| HscRate | HSC Rate | Num | 20 | |||||
| PmntTerms | Payment Terms | Int | 6 | OCTG Payment Terms | ||||
| LineNum | Row Number | Int | 11 |
Table relationship map
SELECT statement
SELECT
WHT1.WTCode AS 'WTax Code',
WHT1.EffecDate AS 'Effective From',
WHT1.Rate AS 'Rate',
WHT1.LogInstanc AS 'Log Instance',
WHT1.TdsRate AS 'TDS Rate',
WHT1.SurRate AS 'Surcharge Rate',
WHT1.CessRate AS 'Cess Rate',
WHT1.HscRate AS 'HSC Rate',
WHT1.PmntTerms AS 'Payment Terms',
WHT1.LineNum AS 'Row Number'
FROM WHT1 AS WHT1
Related information
Withholding Tax Codes Lines WithholdingTaxCodes_Lines Object· Table: WHT1
WithholdingTaxCodes_Lines is a child object of the WithholdingTaxCodes object. It enables to define the tax percentage and the effective from date for the withholding tax code.
Source table: WHT1.
Parent: Withholding Tax Codes WithholdingTaxCodes Object· Table: OWHT Payment Terms OCTG SQL Table
Withholding Tax OWHT SQL Table
WithholdingTaxCodes
Object
WithholdingTaxCodes_Lines
Method
Object
Property
CessRate
DTW DB
Effectivefrom
DTW DB
HSCRate
DTW DB
LineNum
DTW DB
Rate
DTW DB
SurchargeRate
DTW DB
TDSRate
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates