|
|
SQL Finance / Withholding Tax
API AWHT
AWHT - Withholding Tax 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 | WTax Name | nVarChar | 50 | |||||
| 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 | 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
AWHT.WTCode AS 'WTax Code',
AWHT.WTName AS 'WTax Name',
AWHT.Rate AS 'Rate',
AWHT.EffecDate AS 'Effective From',
AWHT.Category AS 'Category',
AWHT.BaseType AS 'Base Type',
AWHT.PrctBsAmnt AS '% Base Amount',
AWHT.OffclCode AS 'Official Code',
AWHT.Account AS 'Account',
AWHT.MinTaxAmt AS 'Minimum Taxable Amount',
AWHT.IsPrgrss AS 'Progressive Tax',
AWHT.Type AS 'Withholding Type',
AWHT.RoundType AS 'Rounding Type',
AWHT.WTTypeId AS 'Type',
AWHT.WTCurrency AS 'Currency',
AWHT.LogInstanc AS 'Log Instance',
AWHT.UpdateDate AS 'Date of Update',
AWHT.UserSign AS 'User Signature',
AWHT.Section AS 'Section',
AWHT.Threshold AS 'Threshold',
AWHT.Surcharge AS 'Surcharge',
AWHT.Concess AS 'Concessional',
AWHT.Assessee AS 'Assessee',
AWHT.ApTdsAcc AS 'A/P TDS Account',
AWHT.ApSurAcc AS 'A/P Surcharge Account',
AWHT.ApCessAcc AS 'A/P Cess Account',
AWHT.ApHscAcc AS 'A/P HSC Account',
AWHT.ArTdsAcc AS 'A/R TDS Account',
AWHT.ArSurAcc AS 'A/R Surcharge Account',
AWHT.ArCessAcc AS 'A/R Cess Account',
AWHT.ArHscAcc AS 'A/R HSC Account',
AWHT.Location AS 'Location',
AWHT.ReturnType AS 'Return Type',
AWHT.UserSign2 AS 'Updating User',
AWHT.Inactive AS 'Inactive',
AWHT.InCSTCode AS 'CST Code Incoming',
AWHT.OutCSTCode AS 'CST Code Outgoing',
AWHT.CalBaseN AS 'Nature of Calculation Base',
AWHT.PymntRsnCd AS 'Payment Reason Code'
FROM AWHT AS AWHT
Related information
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
