|
|
API AWTD
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry | Internal Number | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| WTCode KEY UNIQUE | WTax Code | nVarChar | 4 | PRIMARY | Yes | |||
| WTName | WTax Name | nVarChar | 50 | |||||
| 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
AWTD.AbsEntry AS 'Internal Number',
AWTD.WTCode AS 'WTax Code',
AWTD.WTName AS 'WTax Name',
AWTD.Rate AS 'Rate',
AWTD.EffecDate AS 'Effective From',
AWTD.Inactive AS 'Inactive',
AWTD.OffclCode AS 'Official Code',
AWTD.Category AS 'Category',
AWTD.BaseType AS 'Base Type',
AWTD.WTTypeId AS 'Type',
AWTD.BaseMin AS 'Min. Amount',
AWTD.PrctBsAmnt AS '% Base Amount',
AWTD.FmlId AS 'Formula ID',
AWTD.Account AS 'Account',
AWTD.SlScProgr AS 'Sliding Scale Progressive Tax',
AWTD.LogInstanc AS 'Log Instance',
AWTD.UpdateDate AS 'Date of Update',
AWTD.UserSign AS 'User Signature',
AWTD.UserSign2 AS 'Updating User'
FROM AWTD AS AWTD
Related information
G/L Accounts OACT SQL Table
Tax Formula Master Table OFML SQL Table
Users OUSR 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