| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBPC_ACP_CATGORY | Categories for the Analysis Cockpit | 1 | CATEGORYID | Category ID | nvarchar | 2 | 0 | | |
2 | BBPC_ACP_CAT_DES | Text Table for the Analysis Cockpit | 1 | CATEGORYID | Category ID | nvarchar | 2 | 0 | | |
3 | BBPC_ACP_TOOLS | Tools for the Analysis Cockpit | 4 | CATEGORYID | Category ID | nvarchar | 2 | 0 | | |
4 | T7PIQEOCATEGORY | External Organization Categories | 2 | CATEGORYID | External Organization Category | nvarchar | 4 | 0 | | |
5 | T7PIQEOCATEGORYT | External Organization Categories (Text Table) | 3 | CATEGORYID | External Organization Category | nvarchar | 4 | 0 | | |
TOPCollateral Management System |
6 | TCMS_BPF | Business Partner Functions ( Customizing) | 3 | CATEGORYID | Business Partner Function Category | nvarchar | 6 | 0 | | |
7 | TCMS_BPF_CAT | Business Partner Function Category | 1 | CATEGORYID | Business Partner Function Category | nvarchar | 6 | 0 | | |
8 | TCMS_BPF_CAT_T | Business Partner Function Category (Text table) | 1 | CATEGORYID | Business Partner Function Category | nvarchar | 6 | 0 | | |
9 | TCMS_CD_BUSINFO | Classification of a change to a business object - internal | 2 | CATEGORYID | Change Category | nvarchar | 2 | 0 | | |
10 | TCMS_PCN_ACTVT | Business activity definition | 7 | CATEGORYID | Activity Category | nvarchar | 2 | 0 | | |
11 | TCMS_PCN_A_CAT | Activity category | 1 | CATEGORYID | Activity Category | nvarchar | 2 | 0 | | |
12 | TCMS_PCN_A_CAT_T | Activity Category texts | 1 | CATEGORYID | Activity Category | nvarchar | 2 | 0 | | |
13 | TCMS_PCN_A_CTM | Activity Categories for Process Mode | 1 | CATEGORYID | Activity Category | nvarchar | 2 | 0 | | |
14 | TCMS_PCN_SSTTR | Activity categories for a Process object | 2 | CATEGORYID | Activity Category | nvarchar | 2 | 0 | | |
15 | TCMS_REL_CAT | Relationship category details | 1 | CATEGORYID | Relationship category | nvarchar | 6 | 0 | | |
16 | TCMS_REL_CAT_T | Relationship Category (Text table) | 1 | CATEGORYID | Relationship category | nvarchar | 6 | 0 | | |
17 | TCMS_REL_TYP | Relationship type description | 3 | CATEGORYID | Relationship category | nvarchar | 6 | 0 | | |
TOPMaster Data |
18 | TCMS_AST_CAT | Asset Category Details | 1 | CATEGORYID | Asset Category Identification No | nvarchar | 6 | 0 | | |
19 | TCMS_AST_CAT_T | Asset Category (Text Table) | 1 | CATEGORYID | Asset Category Identification No | nvarchar | 6 | 0 | | |
20 | TCMS_AST_TYP | Asset Type Details | 3 | CATEGORYID | Asset Category Identification No | nvarchar | 6 | 0 | | |
21 | TCMS_CAG_CAT | Collateral Agreement Category Details | 1 | CATEGORYID | Collateral Agreement Category ID | nvarchar | 6 | 0 | | |
22 | TCMS_CAG_CAT_T | Collateral Agreement Category Text Elements | 1 | CATEGORYID | Collateral Agreement Category ID | nvarchar | 6 | 0 | | |
23 | TCMS_CAG_SA_CT | Special Arrangement Categories | 1 | CATEGORYID | Special Arrangement Category | nvarchar | 6 | 0 | | |
24 | TCMS_CAG_SA_CT_T | Special Arrangement Category Text | 1 | CATEGORYID | Special Arrangement Category | nvarchar | 6 | 0 | | |
25 | TCMS_CAG_SA_TY | Special Arrangement Types | 3 | CATEGORYID | Special Arrangement Category | nvarchar | 6 | 0 | | |
26 | TCMS_CAG_TYP | Collateral Agreement type Description | 3 | CATEGORYID | Collateral Agreement Category ID | nvarchar | 6 | 0 | | |
27 | TCMS_OMS_CAT | Object Categories | 1 | CATEGORYID | Object Category | nvarchar | 6 | 0 | | |
28 | TCMS_OMS_CAT_T | Object Category - Text Table | 1 | CATEGORYID | Object Category | nvarchar | 6 | 0 | | |
29 | TCMS_OMS_FEAT | Object Classification | 2 | CATEGORYID | Object Category | nvarchar | 6 | 0 | | |
30 | TCMS_OMS_FEAT_T | Object Classification - Text | 2 | CATEGORYID | Object Category | nvarchar | 6 | 0 | | |
31 | TCMS_PRD | Product description | 3 | CATEGORYID | Product Category Identification No | nvarchar | 6 | 0 | | |
32 | TCMS_PRD_CAT | Product Category Details | 1 | CATEGORYID | Product Category Identification No | nvarchar | 6 | 0 | | |
33 | TCMS_PRD_CAT_T | Product Category (Text Table) | 1 | CATEGORYID | Product Category Identification No | nvarchar | 6 | 0 | | |
34 | TCMS_SAS_TYP | Sub-asset type details | 6 | CATEGORYID | Asset Category Identification No | nvarchar | 6 | 0 | | |
TOPScripting |
35 | CRMD_IC_ISECAT | Categories (Interactive Script Editor) | 3 | CATEGORYID | Category ID (Interactive Script Editor Repository) | nvarchar | 32 | 0 | | |
36 | CRMD_IC_ISECATDS | Categories (Interactive Script Editor) | 3 | CATEGORYID | Category ID (Interactive Script Editor Repository) | nvarchar | 32 | 0 | | |