| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollateral Management System |
1 | CMS_PCN_CR | Change Requests | 3 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
2 | TCMS_BDT_FC_PL | Plausibility checks on FCODE | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
3 | TCMS_BDT_V_PL | Plausibility checks for view | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
4 | TCMS_PCN_ACTVT | Business activity definition | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
5 | TCMS_PCN_ACTVT_T | Business activity definition texts | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
6 | TCMS_PCN_A_GRP_T | Business activity group text definition | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
7 | TCMS_PCN_A_MSG | Message sverity change for business activity | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
8 | TCMS_PCN_A_SSTTR | System Status Transition for an Activity | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
9 | TCMS_PCN_CKY | Process control key | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
10 | TCMS_PCN_CKY_B | Process control key Behavior | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
11 | TCMS_PCN_CKY_T | Process control key texts | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
12 | TCMS_PCN_CR_CT | Change Request Category | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
13 | TCMS_PCN_CR_CT_T | Texts for Change Request Category | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
14 | TCMS_PCN_CR_ST | Change Request Type: Status Transition | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
15 | TCMS_PCN_CR_TY | Change Request Type | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
16 | TCMS_PCN_CR_TY_T | Texts for Change Request Type | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
17 | TCMS_PCN_FCODE | FCODE exclusion set definition for activity | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
18 | TCMS_PCN_OBJ | Process Object | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
19 | TCMS_PCN_OBJ_M | Process Control Object: Mode Attributes | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
20 | TCMS_PCN_OBJ_S | Process Control Object: Mode Attributes | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
21 | TCMS_PCN_OBJ_T | Process object category texts | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
22 | TCMS_PCN_PL | Plausibility Check | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
23 | TCMS_PCN_PLMSG | Messages associated to Plausibility | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
24 | TCMS_PCN_PLPRC | Process Object and Plausibility Processor relation | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
25 | TCMS_PCN_PLPRC_T | Plausibility processor texts | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
26 | TCMS_PCN_PLSET | Plauisbility set definition | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
27 | TCMS_PCN_PLSET_T | Plausibility Set definition texts | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
28 | TCMS_PCN_PLSPL | Plausibility set- Plausibility relation | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
29 | TCMS_PCN_PL_T | Plausibility definition texts | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
30 | TCMS_PCN_SSTTR | Activity categories for a Process object | 1 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
31 | TCMS_PCN_USTTR | User status transition definition | 2 | PROC_OBJ | Process Object | nvarchar | 6 | 0 | | |
TOPIncentive and Commission Management ICM |
32 | TCACS_PROC | Commission System Processes | 1 | PROC_OBJ | Identification of a Process Object | nvarchar | 2 | 0 | | |
33 | TCACS_PROCP | Parts in the Commission Process | 1 | PROC_OBJ | Identification of a Process Object | nvarchar | 2 | 0 | | |
34 | TCACS_PROCP_T | Parts in the Commission Process | 2 | PROC_OBJ | Identification of a Process Object | nvarchar | 2 | 0 | | |
35 | TCACS_PROCS | Steps in the Commission Process Parts | 1 | PROC_OBJ | Identification of a Process Object | nvarchar | 2 | 0 | | |
36 | TCACS_PROC_T | Commission System Processes | 2 | PROC_OBJ | Identification of a Process Object | nvarchar | 2 | 0 | | |