|
|
SQL Finance / Tax Definition
API AWH1
AWH1 - Tax Definition Table
Payment Terms OCTG SQL Table
Withholding Tax OWHT SQL Table
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
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
