| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_DOWNUPACTMAP | Mapping from activity to postproc. function (downl/upload) | 1 | ACT_ID | Unique ID for all activities to be executed | nvarchar | 40 | 0 | | |
2 | ZSRMPROTOCOL | SRM protocol entries | 6 | ACT_ID | Activity - ID | nvarchar | 32 | 0 | | |
TOPBusiness Configuration Sets |
3 | SCPRACPM | BC Sets: Activation Logs (Messages) | 1 | ACT_ID | BC Sets: Container for 32-character GUID | nvarchar | 32 | 0 | | |
4 | SCPRACPP | BC Sets: Activation Logs (BC Set Names) | 1 | ACT_ID | BC Sets: Container for 32-character GUID | nvarchar | 32 | 0 | | |
5 | SCPRACPR | BC Sets: Activation Logs (Activated Data Records) | 1 | ACT_ID | BC Sets: Container for 32-character GUID | nvarchar | 32 | 0 | | |
6 | SCPRSACTBC | BC Sets: Assignment of Switch BC Sets to Activation Process | 1 | ACT_ID | BC Sets: GUID, 32 places | nvarchar | 32 | 0 | | |
7 | SCPRSACTID | BC Sets: Activation Processes Switch BC Sets | 1 | ACT_ID | BC Sets: GUID, 32 places | nvarchar | 32 | 0 | | |
8 | SCPRSALD | BC Sets: Client-Dependent Switch Activation Links | 10 | ACT_ID | BC Sets: GUID, 32 places | nvarchar | 32 | 0 | | |
9 | SCPRSALI | BC Sets: Client-Independent Switch Activation Links | 9 | ACT_ID | BC Sets: GUID, 32 places | nvarchar | 32 | 0 | | |
TOPClinical System |
10 | N2DWSWL_ACT | Activity | 2 | ACT_ID | Key of Activity | nvarchar | 33 | 0 | | |
11 | N2GL_ACT | pathways Activity | 2 | ACT_ID | pathways Activity Key | nvarchar | 32 | 0 | | |
12 | N2GL_ACT_NOTE | Pathways: Comment on Activity | 2 | ACT_ID | pathways Activity Key | nvarchar | 32 | 0 | | |
TOPCustomizing Project Management IMG |
13 | TPR_XREF_D | Index for Where-Used List | 3 | ACT_ID | Customizing activity | nvarchar | 20 | 0 | | |
TOPDSD Connector |
14 | /DSD/ME_ORD_HD | DSD CN: Order Header Data | 5 | ACT_ID | DSD connector : Activity ID | nvarchar | 6 | 0 | | |
TOPImplementation Guide |
15 | CUS_ACTEXT | Customizing Activity - Assigned Enhancement Object | 1 | ACT_ID | Customizing activity | nvarchar | 20 | 0 | | |
16 | CUS_ACTH | Customizing Activity - Header Data | 1 | ACT_ID | Customizing activity | nvarchar | 20 | 0 | | |
17 | CUS_ACTOBJ | Customizing Activity - Object List | 1 | ACT_ID | Customizing activity | nvarchar | 20 | 0 | | |
18 | CUS_ACTOBT | Customizing Activity - Object List | 2 | ACT_ID | Customizing activity | nvarchar | 20 | 0 | | |
19 | CUS_ACTT | Customizing Activity Text Table | 2 | ACT_ID | Customizing activity | nvarchar | 20 | 0 | | |
TOPPurchasing |
20 | WGRC_ACT | Current Capacity Data for Doors or Staging Areas | 9 | ACT_ID | GUID in 'RAW' format | varbinary | 16 | 0 | | |
21 | WGRC_ACT_PO | Assignment of Times to Door/Area Capacities | 2 | ACT_ID | GUID in 'RAW' format | varbinary | 16 | 0 | | |
22 | WGRC_ASS_ACT_PO | Assignment of Times to Door/Area Capacities | 2 | ACT_ID | GUID in 'RAW' format | varbinary | 16 | 0 | | |
TOPRecords and Case Management |
23 | RMPS_AUDIT_CUST | Audit: Output Control | 3 | ACT_ID | Activity - ID | nvarchar | 32 | 0 | | |
TOPSAP Records Management |
24 | SRMPROTOCOL | SRM protocol entries | 6 | ACT_ID | Activity - ID | nvarchar | 32 | 0 | | |