|
|
DTW Banking / Bank Statements and External Reconciliations
API ODOX
ODOX - Data Ownership - Exceptions Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | QueryId KEY UNIQUE | Query ID | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Object | The Object Number | nVarChar | 20 | |||||
| SubObject | Array Offset | Int | 6 | 0 | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UpdateUser | Updating User | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Auto Summary D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| AC | Cache Access Counter | Int | 11 | 0 |
SELECT statement
SELECT
ODOX.QueryId AS 'Query ID',
ODOX.Object AS 'The Object Number',
ODOX.SubObject AS 'Array Offset',
ODOX.UserSign AS 'User Signature',
ODOX.UpdateUser AS 'Updating User',
ODOX.CreateDate AS 'Creation Date',
ODOX.UpdateDate AS 'Date of Update',
ODOX.DataSource AS 'Data Source',
ODOX.AC AS 'Cache Access Counter'
FROM ODOX AS ODOX
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
