|
|
DTW Administration / Setup / Financials / Tax / Withholding Tax Definition
API WTD5
WTD5 - WTax Codes Details for Freight Table
Withholding Tax OWHT SQL Table
Freight Setup OEXD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OWHT Withholding Tax | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row Number | Int | 11 | |||||
| WTCode KEY UNIQUE | WTax Code | nVarChar | 4 | EXPNSCODE | Yes | |||
| ExpnsCode | Freight Code | Int | 11 | OEXD Freight Setup | ||||
| DateFrom | Effective Date From | Date | 8 | |||||
| DateTo | Effective Date To | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown M) Import O) DI API P) Partner Implementation | 1 | N | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
WTD5.AbsEntry AS 'Internal Number',
WTD5.LineId AS 'Row Number',
WTD5.WTCode AS 'WTax Code',
WTD5.ExpnsCode AS 'Freight Code',
WTD5.DateFrom AS 'Effective Date From',
WTD5.DateTo AS 'Effective Date To',
WTD5.DataSource AS 'Data Source',
WTD5.UpdateDate AS 'Date of Update',
WTD5.LogInstanc AS 'Log Instance'
FROM WTD5 AS WTD5
Related information
Withholding Tax OWHT SQL Table
Freight Setup OEXD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
