|
|
SQL Finance / Withholding Tax
DTW Administration / Setup / Financials / Tax / Withholding Tax
API OWHT / Withholding Tax Codes
OWHT - Withholding Tax Table
Withholding Tax Codes WithholdingTaxCodes Object· Table: OWHT
OWHT SQL Table
G/L Accounts OACT SQL Table
Nature of Assessee ONOA SQL Table
Brazil String Indexer OBSI SQL Table
CST Code for Nota Fiscal OTSC SQL Table
Location OLCT SQL Table
Specific Withholding Amounts OSWA SQL Table
Sections OSEC SQL Table
Users OUSR SQL Table
Currency Codes OCRN SQL Table
Withholding Tax Type OWTT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WTCode KEY UNIQUE | WTax Code | nVarChar | 4 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| WTName KEY | WTax Name | nVarChar | 50 | WT_NAME | No | |||
| Rate | Rate | Num | 20 | |||||
| EffecDate | Effective From | Date | 8 | |||||
| Category | Category | VarChar | I) Invoice P) Payment | 1 | P | |||
| BaseType | Base Type | VarChar | G) Gross N) Net V) VAT | 1 | N | |||
| PrctBsAmnt | % Base Amount | Num | 20 | |||||
| OffclCode | Official Code | nVarChar | 15 | |||||
| Account | Account | nVarChar | 15 | OACT G/L Accounts | ||||
| MinTaxAmt | Minimum Taxable Amount | Num | 20 | |||||
| IsPrgrss | Progressive Tax | VarChar | Y) Progressive Tax N) Not Progressive Tax | 1 | N | |||
| Type | Withholding Type | VarChar | V) VAT Withholding I) Income Tax Withholding | 1 | V | |||
| RoundType | Rounding Type | VarChar | T) Truncated AU C) Commercial Values N) No Rounding | 1 | C | |||
| WTTypeId | Type | Int | 11 | OWTT Withholding Tax Type | ||||
| WTCurrency | Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Section | Section | Int | 11 | OSEC Sections | ||||
| Threshold | Threshold | Num | 20 | |||||
| Surcharge | Surcharge | Num | 20 | |||||
| Concess | Concessional | VarChar | Y) Yes N) No | 1 | N | |||
| Assessee | Assessee | Int | 11 | ONOA Nature of Assessee | ||||
| ApTdsAcc | A/P TDS Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ApSurAcc | A/P Surcharge Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ApCessAcc | A/P Cess Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ApHscAcc | A/P HSC Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ArTdsAcc | A/R TDS Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ArSurAcc | A/R Surcharge Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ArCessAcc | A/R Cess Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ArHscAcc | A/R HSC Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Location | Location | Int | 11 | OLCT Location | ||||
| ReturnType | Return Type | VarChar | A) 26 B) 27 | 1 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| Inactive | Inactive | VarChar | Y) Yes N) No | 1 | N | |||
| InCSTCode | CST Code Incoming | Int | 11 | OTSC CST Code for Nota Fiscal | -1 | |||
| OutCSTCode | CST Code Outgoing | Int | 11 | OTSC CST Code for Nota Fiscal | -1 | |||
| CalBaseN | Nature of Calculation Base | nVarChar | 2 | OBSI Brazil String Indexer | ||||
| PymntRsnCd | Payment Reason Code | nVarChar | 2 | OSWA Specific Withholding Amounts |
Table relationship map
SELECT statement
SELECT
OWHT.WTCode AS 'WTax Code',
OWHT.WTName AS 'WTax Name',
OWHT.Rate AS 'Rate',
OWHT.EffecDate AS 'Effective From',
OWHT.Category AS 'Category',
OWHT.BaseType AS 'Base Type',
OWHT.PrctBsAmnt AS '% Base Amount',
OWHT.OffclCode AS 'Official Code',
OWHT.Account AS 'Account',
OWHT.MinTaxAmt AS 'Minimum Taxable Amount',
OWHT.IsPrgrss AS 'Progressive Tax',
OWHT.Type AS 'Withholding Type',
OWHT.RoundType AS 'Rounding Type',
OWHT.WTTypeId AS 'Type',
OWHT.WTCurrency AS 'Currency',
OWHT.LogInstanc AS 'Log Instance',
OWHT.UpdateDate AS 'Date of Update',
OWHT.UserSign AS 'User Signature',
OWHT.Section AS 'Section',
OWHT.Threshold AS 'Threshold',
OWHT.Surcharge AS 'Surcharge',
OWHT.Concess AS 'Concessional',
OWHT.Assessee AS 'Assessee',
OWHT.ApTdsAcc AS 'A/P TDS Account',
OWHT.ApSurAcc AS 'A/P Surcharge Account',
OWHT.ApCessAcc AS 'A/P Cess Account',
OWHT.ApHscAcc AS 'A/P HSC Account',
OWHT.ArTdsAcc AS 'A/R TDS Account',
OWHT.ArSurAcc AS 'A/R Surcharge Account',
OWHT.ArCessAcc AS 'A/R Cess Account',
OWHT.ArHscAcc AS 'A/R HSC Account',
OWHT.Location AS 'Location',
OWHT.ReturnType AS 'Return Type',
OWHT.UserSign2 AS 'Updating User',
OWHT.Inactive AS 'Inactive',
OWHT.InCSTCode AS 'CST Code Incoming',
OWHT.OutCSTCode AS 'CST Code Outgoing',
OWHT.CalBaseN AS 'Nature of Calculation Base',
OWHT.PymntRsnCd AS 'Payment Reason Code'
FROM OWHT AS OWHT
Related information
Withholding Tax Codes WithholdingTaxCodes Object· Table: OWHT
The WithholdingTaxCodes object enables to define the system withholding tax codes that can be applied to business partners, payments, and documents.
Source table: OWHT.
OWHT SQL Table
G/L Accounts OACT SQL Table
Nature of Assessee ONOA SQL Table
Brazil String Indexer OBSI SQL Table
CST Code for Nota Fiscal OTSC SQL Table
Location OLCT SQL Table
Specific Withholding Amounts OSWA SQL Table
Sections OSEC SQL Table
Users OUSR SQL Table
Currency Codes OCRN SQL Table
Withholding Tax Type OWTT SQL Table
WithholdingTaxCodes
Enumeration
Method
Object
Property
Account
DTW DB
APCessAccount
DTW DB
APHSCAccount
DTW DB
APSurchargeAccount
DTW DB
APTDSAccount
DTW DB
ARCessAccount
DTW DB
ARHSCAccount
DTW DB
ARSurchargeAccount
DTW DB
ARTDSAccount
DTW DB
Assessee
DTW DB
BaseAmount
DTW DB
BaseType
DTW DB
Category
DTW DB
Concessional
DTW DB
Location
DTW DB
OfficialCode
DTW DB
ReturnType
DTW DB
RoundingType
DTW DB
Section
DTW DB
Surcharge
DTW DB
Threshold
DTW DB
WithholdingType
DTW DB
WTCode
DTW DB
WTName
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
