| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | No | | GUID | |
| 3 | CRDAT | Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /TDAG/RCSE_CRDAT | Allow NULL? |
| 4 | CRNAM | Creation User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_CRNAM | Allow NULL? |
| 5 | CRTSTMP | Creation Time Stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /TDAG/RCSE_CRTSTMP | |
| 6 | UPDDAT | Update Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /TDAG/RCSE_UPDDAT | Allow NULL? |
| 7 | UPDNAM | Update User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_UPDNAM | Allow NULL? |
| 8 | UPDTSTMP | Update Time Stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /TDAG/RCSE_UPDTSTMP | |
| 9 | DELFLG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEDELFLG | Allow NULL? |
| 10 | STDID | OBSOLETE: ID of the study | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYID | Allow NULL? |
| 11 | NAME | OBSOLETE: Study name | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYNAM | Allow NULL? |
| 12 | METHOD | OBSOLETE: Study method | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYMET | Allow NULL? |
| 13 | RESLT | OBSOLETE: Study result | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYRES | Allow NULL? |
| 14 | DATE_AVAIL | OBSOLETE: Date of the study | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /TDAG/RCSE_STUDYDAT | Allow NULL? |
| 15 | COST | OBSOLETE: Cost of the study | decimal | 11 | 2 | CURR | ((0)) | Yes | | /TDAG/RCSE_STUDYCOST | |
| 16 | COST_CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 17 | RELIABILITY | OBSOLETE: Reliability of the study | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYREL | Allow NULL? |
| 18 | FLG_RELEASED | OBSOLETE: Flag for released for sale | char | 1 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYSALE | Allow NULL? |
| 19 | DOKAR | Document Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DOKAR | Allow NULL? |
| 20 | DOKNR | Document number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | DOKNR | Allow NULL? |
| 21 | DOKVR | Document Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DOKVR | Allow NULL? |
| 22 | DOKTL | Document Part | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DOKTL_D | Allow NULL? |
| 23 | DOKTX | Document Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_DOCTXT | Allow NULL? |
| 24 | IUCLID_LINK | OBSOLETE: Link to IUCLID | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYIUCL | Allow NULL? |
| 25 | STATUS | OBSOLETE: Status of a study | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYSTAT | Allow NULL? |
| 26 | OWNER | OBSOLETE: Study owner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /TDAG/RCSE_STUDYOWN | Allow NULL? |
| 27 | GLP | OBSOLETE: GIP of the study | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_STUDYGLP | Allow NULL? |
| 28 | PRICE | OBSOLETE: Price of the study | decimal | 11 | 2 | CURR | ((0)) | Yes | | /TDAG/RCSE_STUDYPRICE | |
| 29 | PRICE_CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 30 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 31 | RECORDOWNER | Record Owner | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /TDAG/RCSE_RECOWN | Allow NULL? |
| 32 | DATACONF | Data Confidentiality | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_DATACONF | Allow NULL? |
| 33 | KEY_STUDY | Key Study | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_KEYSTUDY | Allow NULL? |
| 34 | COV_REL | Coverage-Relevant | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | /TDAG/RCSE_COV_REL | Allow NULL? |
