| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GLPCA_CT | Profit Center Documents | 89 | OCLNT | Original client | nvarchar | 3 | 0 | | |
2 | GLPCA_T_CT | Profit Center Documents | 105 | OCLNT | Original client | nvarchar | 3 | 0 | | |
3 | YIT_EXAM | IDA: Examples | 7 | OCLNT | IDA: Client of owner in original system (mailing) | nvarchar | 3 | 0 | | |
4 | YIT_INFOBASE_R | IDES Infobase roles and persons | 6 | OCLNT | IDA: Client of owner in original system (mailing) | nvarchar | 3 | 0 | | |
5 | YIT_PROC | IDA: Processes in IDES | 11 | OCLNT | IDA: Client of owner in original system (mailing) | nvarchar | 3 | 0 | | |
6 | YIT_TRAI | IDA: Training Courses | 7 | OCLNT | IDA: Client of owner in original system (mailing) | nvarchar | 3 | 0 | | |
TOPBasic Functions |
7 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 25 | OCLNT | Original client | nvarchar | 3 | 0 | | |
8 | FILCC | FI-LC: Transaction-related fields for table FILCT | 9 | OCLNT | Original client | nvarchar | 3 | 0 | | |
9 | FILCP | FI-LC: Plan line items for object table | 25 | OCLNT | Original client | nvarchar | 3 | 0 | | |
10 | FILCT | FI-LC: Global totals table with 2 object tables | 24 | OCLNT | Original client | nvarchar | 3 | 0 | | |
11 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 18 | OCLNT | Original client | nvarchar | 3 | 0 | | |
12 | GLFUNCC | Object Table 2 for Cost of Sales Accounting | 3 | OCLNT | Original client | nvarchar | 3 | 0 | | |
13 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 18 | OCLNT | Original client | nvarchar | 3 | 0 | | |
14 | GLFUNCT | Totals Table for Cost of Sales Accounting | 17 | OCLNT | Original client | nvarchar | 3 | 0 | | |
15 | GLFUNCU | Rollup line item tables with function area for IDES | 18 | OCLNT | Original client | nvarchar | 3 | 0 | | |
16 | GLFUNCV | Rollup plan line items table with function area for IDES | 18 | OCLNT | Original client | nvarchar | 3 | 0 | | |
17 | GLPO1 | Plan Line Items for Object Table | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
18 | GLPO2 | Plan Line Items for Object Table Global | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
19 | GLPO3 | Plan Line Items for Object Table | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
20 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 19 | OCLNT | Original client | nvarchar | 3 | 0 | | |
21 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 19 | OCLNT | Original client | nvarchar | 3 | 0 | | |
22 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
23 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
24 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
25 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
26 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
27 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
TOPCost Element Accounting |
28 | COFIO2 | Transaction-dependent fields for reconciliation ledger | 5 | OCLNT | Original client | nvarchar | 3 | 0 | | |
29 | COFIP | Single plan items for reconciliation ledger | 36 | OCLNT | Original client | nvarchar | 3 | 0 | | |
30 | COFIS | Actual line items for reconciliation ledger | 36 | OCLNT | Original client | nvarchar | 3 | 0 | | |
31 | COFIT | Totals Records for Reconciliation Ledger | 35 | OCLNT | Original client | nvarchar | 3 | 0 | | |
TOPProfit Center Accounting |
32 | GLPCA | EC-PCA: Actual Line Items | 25 | OCLNT | Original client | nvarchar | 3 | 0 | | |
33 | GLPCC | EC-PCA: Transaction Attributes | 8 | OCLNT | Original client | nvarchar | 3 | 0 | | |
34 | GLPCP | EC-PCA: Plan Line Items | 25 | OCLNT | Original client | nvarchar | 3 | 0 | | |
35 | GLPCT | EC-PCA: Totals Table | 24 | OCLNT | Original client | nvarchar | 3 | 0 | | |
36 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 26 | OCLNT | Original client | nvarchar | 3 | 0 | | |
TOPProfitability Analysis |
37 | GLTPC | Profit Center Accounting | 10 | OCLNT | Original client | nvarchar | 3 | 0 | | |