|
|
DTW Administration / Setup / Financials / Tax / Withholding Tax Definition
API Witholding Tax Definition Service / WTD Code
OWTD - Withholding Tax Definition Table
WTD Code WTDCode Object· Table: OWTD
Parent: Witholding Tax Definition Service WitholdingTaxDefinitionService Service
G/L Accounts OACT SQL Table
Tax Formula Master Table OFML SQL Table
Users OUSR SQL Table
Withholding Tax Type OWTT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| WTCode KEY UNIQUE | WTax Code | nVarChar | 4 | WT_CODE | Yes | |||
| WTName KEY | WTax Code Name | nVarChar | 50 | WT_NAME | No | |||
| Rate | Rate | Num | 20 | |||||
| EffecDate | Effective From | Date | 8 | |||||
| Inactive | Inactive | VarChar | Y) N) | 1 | N | |||
| OffclCode | Official Code | nVarChar | 15 | |||||
| Category | Category | VarChar | I) Invoice P) Payment | 1 | P | |||
| BaseType | Base Type | VarChar | G) Gross N) Net V) VAT | 1 | N | |||
| WTTypeId | Type | Int | 11 | OWTT Withholding Tax Type | ||||
| BaseMin | Min. Amount | Num | 20 | |||||
| PrctBsAmnt | % Base Amount | Num | 20 | |||||
| FmlId | Formula ID | Int | 11 | OFML Tax Formula Master Table | ||||
| Account | Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SlScProgr | Sliding Scale Progressive Tax | VarChar | Y) N) | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OWTD.AbsEntry AS 'Internal Number',
OWTD.WTCode AS 'WTax Code',
OWTD.WTName AS 'WTax Code Name',
OWTD.Rate AS 'Rate',
OWTD.EffecDate AS 'Effective From',
OWTD.Inactive AS 'Inactive',
OWTD.OffclCode AS 'Official Code',
OWTD.Category AS 'Category',
OWTD.BaseType AS 'Base Type',
OWTD.WTTypeId AS 'Type',
OWTD.BaseMin AS 'Min. Amount',
OWTD.PrctBsAmnt AS '% Base Amount',
OWTD.FmlId AS 'Formula ID',
OWTD.Account AS 'Account',
OWTD.SlScProgr AS 'Sliding Scale Progressive Tax',
OWTD.LogInstanc AS 'Log Instance',
OWTD.UpdateDate AS 'Date of Update',
OWTD.UserSign AS 'User Signature',
OWTD.UserSign2 AS 'Updating User'
FROM OWTD AS OWTD
Related information
WTD Code WTDCode Object· Table: OWTD
WTDCode Class
Parent: Witholding Tax Definition Service WitholdingTaxDefinitionService ServiceG/L Accounts OACT SQL Table
Tax Formula Master Table OFML SQL Table
Users OUSR SQL Table
Withholding Tax Type OWTT SQL Table
WitholdingTaxDefinitionService
Object
WTDCode
Collection
Enumeration
Method
Property
AbsEntry
DTW DB
BaseAmountPrct
DTW DB
BaseType
DTW DB
Category
DTW DB
FormulaId
DTW DB
Inactive
DTW DB
MinAmount
DTW DB
OfficialCode
DTW DB
SlidingScaleProgressiveTax
DTW DB
Type
DTW DB
WTaxCode
DTW DB
WTaxName
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
