|
|
DTW User Defined Data / Query Categories
API ASTT
ASTT - Sales Tax Authorities Type Table
Nota Fiscal Tax Category (Brazil) ONFT SQL Table
Tax Parameter OTPS SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Numerator | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Type Name | nVarChar | 40 | NAME | Yes | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| IsVat | VAT | VarChar | Y) Yes N) No | 1 | N | |||
| NfTaxId | ID of Nota Fiscal Tax Category | Int | 11 | ONFT Nota Fiscal Tax Category (Brazil) | ||||
| TpsId | ID of Tax Parameter Set | Int | 11 | OTPS Tax Parameter | ||||
| PLABalance | PLA Current Balance | Num | 20 | |||||
| Locked | Locked | VarChar | 1 | N | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| CreditCtrl | Tax Credit Control | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
ASTT.AbsId AS 'Numerator',
ASTT.Name AS 'Type Name',
ASTT.UserSign AS 'User Signature',
ASTT.IsVat AS 'VAT',
ASTT.NfTaxId AS 'ID of Nota Fiscal Tax Category',
ASTT.TpsId AS 'ID of Tax Parameter Set',
ASTT.PLABalance AS 'PLA Current Balance',
ASTT.Locked AS 'Locked',
ASTT.LogInstanc AS 'Log Instance',
ASTT.UserSign2 AS 'Updating User',
ASTT.UpdateDate AS 'Update Date',
ASTT.CreditCtrl AS 'Tax Credit Control'
FROM ASTT AS ASTT
Related information
Nota Fiscal Tax Category (Brazil) ONFT SQL Table
Tax Parameter OTPS SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
