|
|
SQL Administration / Data Migration
DTW Banking
API ODMW
ODMW - Data Migration Table
ODMW SQL Table
Query Catagories OQCN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Package Code | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Package Name | nVarChar | 20 | NAME | Yes | |||
| CategoryId | Category ID | Int | 11 | OQCN Query Catagories | ||||
| DestPath | Dest. Path | Text | 16 | |||||
| Extantion | Exported | nVarChar | 5 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Delim | Include Title | nVarChar | T) Tab K) , D) ; S) Space | 10 | T | |||
| InclTitle | Set to Exported | VarChar | Y) Yes N) No | 1 | N | |||
| SetExp | New Records | VarChar | Y) Yes N) No | 1 | N | |||
| NewRecs | Save | VarChar | Y) Yes N) No | 1 | N | |||
| Summary | Summary | Text | 16 |
Table relationship map
SELECT statement
SELECT
ODMW.Code AS 'Package Code',
ODMW.Name AS 'Package Name',
ODMW.CategoryId AS 'Category ID',
ODMW.DestPath AS 'Dest. Path',
ODMW.Extantion AS 'Exported',
ODMW.UserSign AS 'User Signature',
ODMW.Delim AS 'Include Title',
ODMW.InclTitle AS 'Set to Exported',
ODMW.SetExp AS 'New Records',
ODMW.NewRecs AS 'Save',
ODMW.Summary AS 'Summary'
FROM ODMW AS ODMW
Related information
ODMW SQL Table
Query Catagories OQCN 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
