| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollateral Management System |
1 | CMS_PCN_CR | Change Requests | 7 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
2 | TCMS_PCN_ACTVT | Business activity definition | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
3 | TCMS_PCN_ACTVT_T | Business activity definition texts | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
4 | TCMS_PCN_A_GRP_T | Business activity group text definition | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
5 | TCMS_PCN_A_MSG | Message sverity change for business activity | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
6 | TCMS_PCN_A_SSTTR | System Status Transition for an Activity | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
7 | TCMS_PCN_CKY | Process control key | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
8 | TCMS_PCN_CKY_B | Process control key Behavior | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
9 | TCMS_PCN_CKY_T | Process control key texts | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
10 | TCMS_PCN_CR_ST | Change Request Type: Status Transition | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
11 | TCMS_PCN_CR_TY | Change Request Type | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
12 | TCMS_PCN_CR_TY_T | Texts for Change Request Type | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
13 | TCMS_PCN_FCODE | FCODE exclusion set definition for activity | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
14 | TCMS_PCN_USTTR | User status transition definition | 3 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
TOPMaster Data |
15 | TCMS_AST_TYP | Asset Type Details | 12 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
16 | TCMS_CAG_TYP | Collateral Agreement type Description | 10 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
TOPMovables |
17 | TCMS_MOV_TYP | Customizing table for Movable Type | 6 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
TOPReal Estate |
18 | TCMS_RE_TYP | Customizing table for real estate types | 6 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
TOPRights |
19 | TCMS_INS_TYP | Customizing table for Insurance Type | 5 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
20 | TCMS_RIG_TYP | Right Types (Patents & Claims) | 5 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
TOPSecurities |
21 | TCMS_SEC_AST | Asset type for securities accounts | 9 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |
TOPShip |
22 | TCMS_SHP_TYP | Customizing table for Ship type | 4 | PROC_CKY | Process Control Key | nvarchar | 10 | 0 | | |