| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAppropriation Requests |
1 | IMAK | Appropriation requests - general data | 39 | USR00 | User field 1 (20 characters) | nvarchar | 20 | 0 | | |
TOPConstruction Equipment Management |
2 | J_3GBELK | Document File - Header Data | 79 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
3 | J_3GBELP | Document Data - Item Data | 112 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
TOPCross-Application Components |
4 | PLLPO | Task list - operation/activity | 128 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
TOPInvestment Programs |
5 | IMPR | Investment Program Positions | 36 | USR00 | User field 1 (20 characters) | nvarchar | 20 | 0 | | |
TOPMaintenance History |
6 | HIVG | PM order history - operations | 54 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
TOPMaster Data Distribution |
7 | /ISDFPS/TL1 | Task List - Operation/Activity | 128 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
TOPOperative Structures |
8 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 45 | USR00 | 1st user field for 20 characters - WBS element- | nvarchar | 20 | 0 | | |
TOPProduction Orders |
9 | AFVU | DB structure of the user fields of the operation | 5 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
TOPProject Summarization |
10 | PSERB | Inheritance data, Project System | 23 | USR00 | 1st user field for 20 characters - WBS element- | nvarchar | 20 | 0 | | |
TOPReal Estate Management |
11 | S402 | Business entities | 28 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
12 | S404 | Properties | 27 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
13 | S405 | Building | 31 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
14 | S406 | Rental units | 36 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
15 | S407 | Rental agreements | 48 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
16 | VIRPS405 | Building | 31 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
17 | VIRPS406 | Rental units | 36 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
18 | VIRPS407 | Rental agreements | 48 | USR00 | User-defined field 1 for 20 characters | nvarchar | 20 | 0 | | |
TOPRouting |
19 | PLPO | Task list - operation/activity | 128 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
TOPSimulation |
20 | VSAFVU_CN | Version: User fields in operation in order | 6 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |
21 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 46 | USR00 | 1st user field for 20 characters - WBS element- | nvarchar | 20 | 0 | | |
TOPTemplates |
22 | PRPSS | Standard WBS Element (WBS element) - Master Data | 45 | USR00 | 1st user field for 20 characters - WBS element- | nvarchar | 20 | 0 | | |
TOPTreasury |
23 | VZSORT | Sort values for object | 5 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | |