|
|
DTW Administration / Setup / Service / Queues
API ATSC
ATSC - CST Code for Nota Fiscal Table
Nota Fiscal Tax Category (Brazil) ONFT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ID KEY UNIQUE | CST Internal Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CODE KEY UNIQUE | CST Code Incoming | nVarChar | 20 | CST_CODE | Yes | |||
| Situation | Description Incoming | Text | 16 | |||||
| Locked | Locked | VarChar | Y) N) | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) OB Server A) Auto Incr. D) Data Doc. P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Category | Tax Category | Int | 6 | ONFT Nota Fiscal Tax Category (Brazil) | -6 | |||
| CodeOut | CST Code Outgoing | nVarChar | 20 | |||||
| OutDesc | Description Outgoing | Text | 16 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
ATSC.ID AS 'CST Internal Key',
ATSC.CODE AS 'CST Code Incoming',
ATSC.Situation AS 'Description Incoming',
ATSC.Locked AS 'Locked',
ATSC.DataSource AS 'Data Source',
ATSC.UserSign AS 'User Signature',
ATSC.Category AS 'Tax Category',
ATSC.CodeOut AS 'CST Code Outgoing',
ATSC.OutDesc AS 'Description Outgoing',
ATSC.LogInstanc AS 'Log Instance',
ATSC.UserSign2 AS 'Updating User',
ATSC.UpdateDate AS 'Update Date'
FROM ATSC AS ATSC
Related information
Nota Fiscal Tax Category (Brazil) ONFT 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
