| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting |
1 | RPSCO | Project info database: Costs, revenues, finances | 7 | ACPOS | Value category | nvarchar | 14 | 0 | | |
2 | RPSQT | Project info database: quantities | 6 | ACPOS | Value category | nvarchar | 14 | 0 | | |
3 | TPIF2 | Commitment Items: Value Category | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
4 | TPIF3 | Assignments: Commitment Item -> Value Category | 5 | ACPOS | Value category | nvarchar | 14 | 0 | | |
5 | TPIK2 | Cost Elements: Value Categories | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
6 | TPIK3 | Assignment Table: Cost Elements -> Value Categories | 4 | ACPOS | Value category | nvarchar | 14 | 0 | | |
7 | TPIR1 | Value Categories | 2 | ACPOS | Value category | nvarchar | 14 | 0 | | |
8 | TPIR1T | Texts for Value Categories | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
9 | TPIR2 | Value Categories | 4 | ACPOS | Value category | nvarchar | 14 | 0 | | |
10 | TPIR2T | Texts for Value Categories | 5 | ACPOS | Value category | nvarchar | 14 | 0 | | |
11 | TPIS3 | Assignmnt Table: Statistical Key Figures -> Value Categories | 4 | ACPOS | Value category | nvarchar | 14 | 0 | | |
TOPConstruction Equipment Management |
12 | J_3GPMCO2 | Cost Structure: Job Key Figures (PMIS) | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
TOPFinancial Accounting |
13 | /BGLOCS/FICFACT | Cash Flow Statement: Activities | 3 | ACPOS | | nvarchar | 2 | 0 | | |
TOPInterest |
14 | TPI04 | Interest Relevance of Cost Element/Commitment Item Groups | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
TOPMaintenance History |
15 | /OLC/PMCO_OP | OLC: PMCO for operations | 7 | ACPOS | Value category | nvarchar | 14 | 0 | | |
16 | PMCO | Cost structure of maintenance order | 7 | ACPOS | Value category | nvarchar | 14 | 0 | | |
17 | PMCO1 | Cost profile: Value category proposal | 2 | ACPOS | Value category | nvarchar | 14 | 0 | | |
18 | PMCO_OP | Cost structure of maintenance order | 7 | ACPOS | Value category | nvarchar | 14 | 0 | | |
TOPMaintenance Orders |
19 | /CUM/ACPOS | CU: Value Categories for Distrib. Costs in CATS | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
20 | PMCOQT | Quantity structure for the maintenance order | 7 | ACPOS | Value category | nvarchar | 14 | 0 | | |
21 | PMCOQT_OP | Quantity structure for the maintenance order | 7 | ACPOS | Value category | nvarchar | 14 | 0 | | |
TOPReporting |
22 | PMCO2 | Cost structure: Job key figures (PMIS) | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
23 | PMCOCKF | Cost/Quantity structure: Customer-specific key figs (PMIS) | 3 | ACPOS | Value category | nvarchar | 14 | 0 | | |
TOPSimulation |
24 | VSRPSCO_CN | Version: Cumulation table for project reporting | 8 | ACPOS | Value category | nvarchar | 14 | 0 | | |