| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_20000_CCLED | Company code and Ledger Combination Particiaption in New G/L | 10 | PLEVEL | Participation Level of a c.code and Ledger in FY convesion | nvarchar | 1 | 0 | | |
2 | PATTPIMPLOG | tp Importprotokollzeilen | 4 | PLEVEL | Protokollebene | nvarchar | 1 | 0 | | |
TOPBalanced Scorecard |
3 | UMB_SC116 | Scorecard and BPS Web Interface | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
4 | UMB_SC167 | Scorecard: Measures: BPS Link | 6 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
5 | UMB_SC191 | Scorecard: Initiatives: BPS Links | 6 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
TOPBusiness Planning |
6 | UPB_CCP_CUST | SEM Cost Center Planning: Customizing Table | 7 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
7 | UPB_CMI_100 | Capital Market Interpreter: Versions + Data Source | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
8 | UPB_CMI_105 | CMI: Entry Layouts | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
9 | UPB_CW_EP | Cost Center Wizard: Planning Environment | 6 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
10 | UPB_SY_BPSCONN | Level and Area for which Classes Were Generated | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
11 | UPB_SY_CLINFO | Attributes of Generated Class for Connection of Survey | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
TOPBusiness Planning and Simulation |
12 | UPB_PS_PROP | Attributes of Planning Objects | 6 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
13 | UPC_FIXED_METHOD | Planning Functions | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
14 | UPC_PACKAGE | Planning Packages | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
15 | UPC_PACKAGET | Planning Packages - Text Table | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
16 | UPC_PLEVEL | Planning Levels | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
17 | UPC_PLEVELT | Planning Levels - Text Table | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
18 | UPC_PROFILE_ME | Planning Profiles - Functions | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
19 | UPC_PROFILE_PA | Planning Profiles - Packages | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
20 | UPC_PROFILE_PL | Planning Profiles - Planning Levels | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
21 | UPC_PROFILE_PS | Planning Profiles - Parameter Settings | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
22 | UPC_STATISTIC3 | Statistic for Executing Planning Functions | 9 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
23 | UPE_PARAM | Planning: Parameterization (SD files) | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
24 | UPE_PARAMT | Planning: Parameter Group Texts | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
25 | UPE_PARAMT_ABC | Planning: Parameter Group Texts | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
26 | UPE_PARAMT_DOC | Planning: Parameter Group Texts | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
27 | UPE_PARAM_ABC | Planning: Parameterization (ABC files) | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
28 | UPE_PARAM_DOC | Planning: Parameter Group (Documents) | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
29 | UPF_BSTEPS | Bundle Steps: Parameter Groups | 5 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
30 | UPF_BUNDLE | Bundle of Planning Functions | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
31 | UPF_BUNDLET | Bundle of Parameter Groups - Text Table | 5 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
32 | UPF_EXITP | Planning: Data Elements - Exits | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
33 | UPF_PARAM | Planning Functions: Parameterization | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
34 | UPF_PARAMT | Planning Functions: Parameterizations | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
35 | UPF_PARGD | Parameterization - GUIDs | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
36 | UPF_PFLDS | Planning: Planning Functions - Fields | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
37 | UPF_PLANF | Planning Functions | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
38 | UPF_PLANFT | Planning Functions: Significance | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
39 | UPP_ATR | Planning: Attributes in Lead Columns | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
40 | UPP_CHAR | Planning: Characteristics | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
41 | UPP_DOC | Planning: Layout Builder Info about Document | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
42 | UPP_ELEM | Planning: Column Elements | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
43 | UPP_ELEMT | Planning: Column Elements Texts | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
44 | UPP_PARAM | Planning: Parameterization (Layouts) | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
45 | UPP_PARAMT | Planning: Parameter Group Texts | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
46 | UPP_SPREADS | Planning: Spreadsheet Customizing | 3 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
47 | UPX_EVAL_BPS | KPI Valuation for Alert | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
48 | UPX_LAYOUT | Enhanced Planning Layouts: Main Table | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
TOPCorporate Performance Monitor |
49 | UMV_TR100 | Value Driver Tree: Header Table | 15 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
TOPDefault Risk and Limit System |
50 | KLSDCPROT1 | Log Gen. for Single Transaction Check: Header Information | 3 | PLEVEL | Log Level | nvarchar | 1 | 0 | | |
TOPEnd User Technology |
51 | RSZELTPROP | Element properties (settings) | 36 | PLEVEL | Dim: Standardizing type | nvarchar | 1 | 0 | | |
TOPGreat Britain |
52 | T5G33 | Pension Contribution Calculation Rule Bands | 4 | PLEVEL | Band level for pension contribution calculation rule | decimal | 9 | 2 | | |
TOPOnline Correction Support Support Package and Add-On Tools |
53 | PATLOG | Logging Table for Transaction SPAM/SAINT | 4 | PLEVEL | Log Level | nvarchar | 1 | 0 | | |
54 | PATLOG3 | New Logging Table for TA SPAM/SAINT | 7 | PLEVEL | Log Level | nvarchar | 1 | 0 | | |
TOPPerformance Assessment Workbench |
55 | SLS_RCTRL | PAW - Results Release Control | 2 | PLEVEL | PAW - Transfer Level | nvarchar | 10 | 0 | | |
TOPPlanning Applications |
56 | UPA_EXP_AFUNC | Assignments of Layouts to Web-CCP Application | 4 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |
57 | UPA_EXP_LAYOUT | Assignments of Layouts to Web-CCP Application | 5 | PLEVEL | Planning level | nvarchar | 8 | 0 | | |