| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000105000 | PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj. | 6 | POST1 | | nvarchar | 40 | 0 | | |
2 | /BIC/B0000105001 | PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj. | 6 | POST1 | | nvarchar | 40 | 0 | | |
3 | /BIC/B0000108000 | PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS | 6 | POST1 | | nvarchar | 40 | 0 | | |
4 | /BIC/B0000108001 | PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS | 6 | POST1 | | nvarchar | 40 | 0 | | |
5 | /BIC/B0000109000 | PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS | 6 | POST1 | | nvarchar | 40 | 0 | | |
6 | /BIC/B0000109001 | PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS | 6 | POST1 | | nvarchar | 40 | 0 | | |
7 | /BIC/B0000115000 | Error Stack DTP_00O2TFWN1YKGA5W5VZK10DZSG 0001 | 4 | POST1 | | nvarchar | 40 | 0 | | |
8 | /BIC/B0000120000 | Error Stack DTP_00O2TFWN1YKGA5W5VZK10F1PS 0001 | 4 | POST1 | | nvarchar | 40 | 0 | | |
9 | /BIC/B0000121000 | Error Stack DTP_00O2TFWN1YKGA5W5VZK10F81C 0001 | 4 | POST1 | | nvarchar | 40 | 0 | | |
TOPContract Accounts Receivable and Payable |
10 | FKKMAKO | Dunning History Header | 46 | POST1 | Posting Key for Charges | nvarchar | 1 | 0 | | |
TOPInvestment Programs |
11 | IMPU | Texts for cap. inv. program positions | 5 | POST1 | Short description | nvarchar | 40 | 0 | | |
12 | IMTT | Capital Investment Program Texts | 5 | POST1 | Short description | nvarchar | 40 | 0 | | |
13 | TAI06 | CI Program Type Texts | 4 | POST1 | Short description | nvarchar | 40 | 0 | | |
14 | TAI09 | Texts for IM budget categories | 5 | POST1 | Short description | nvarchar | 40 | 0 | | |
TOPOperative Structures |
15 | PROJ | Project definition | 4 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
16 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 4 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
17 | PRTP | Subprojects | 3 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
TOPProject System |
18 | LOGHANDLER | Table for the log handler | 8 | POST1 | General Name | nvarchar | 20 | 0 | | |
19 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 35 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
20 | PSHLP_DRAFT_DB | Table holds Draft Workbench Information | 7 | POST1 | Project Description for Draft Workbench | nvarchar | 40 | 0 | | |
21 | PSHLP_DRAFT_DB_N | Table holds Draft Workbench Information | 7 | POST1 | Project Description for Draft Workbench | nvarchar | 40 | 0 | | |
22 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 30 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
TOPSimulation |
23 | VSPROJ_CN | Version: Project definition | 5 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
24 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 5 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
TOPStructures |
25 | PSHLP_PROJWL_DB | Project Definition ACL Worklist | 4 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
26 | PSHLP_WBSWL_DB | WBS Elements ACL Worklist | 4 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
TOPTemplates |
27 | PROJS | Standard project definition | 4 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |
28 | PRPSS | Standard WBS Element (WBS element) - Master Data | 4 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | | |