| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | ZPHTRIALTAB | IBS Pharma: Randomization table for clinical trials | 3 | TRIALID | Pharma CTSM: Study Protocol | nvarchar | 35 | 0 | | |
| TOPQuality Inspection |
| 2 | QALS | Inspection lot record | 226 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| TOPQuality Notifications |
| 3 | QMEL_EXT | Extension Table for Notification | 8 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| TOPResourcen Management |
| 4 | RMXTT_CHD_PP_CL | Table of Change Docs for Process Parameters - Always Empty | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 5 | RMXTT_TRIAL_AEGR | Reasons for Change for Trial Results | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 6 | RMXTT_TRIAL_DEST | Trial: Control Recipe Destination | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 7 | RMXTT_TRIAL_FRML | Trial: Material Consumption (Formula) | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 8 | RMXTT_TRIAL_HD | Trial: Header Data | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 9 | RMXTT_TRIAL_MR | Trial: Assigned Master Recipes | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 10 | RMXTT_TRIAL_PP | Trial: Process Parameter Result | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 11 | RMXTT_TRIAL_QMPL | Trial: Assigned Inspection Plans for Post-Process Control | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
| 12 | RMXTT_TRIAL_RES | Trial: Resource Assignment | 2 | TRIALID | Trial Number | nvarchar | 12 | 0 | | |
