| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000139000 | PSA for 0DPR_PROJECT_DATE T90CLNT090 Proj. Def. Dates | 20 | CALENDAR_ID | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000140000 | PSA for 0DPR_PHASE_DATE T90CLNT090 Phase Dates | 20 | CALENDAR_ID | | nvarchar | 2 | 0 | | |
3 | /BIC/B0000141000 | PSA for 0DPR_TASK_DATE T90CLNT090 Task Dates | 22 | CALENDAR_ID | | nvarchar | 2 | 0 | | |
TOPGeneric Project Planning |
4 | CGPL_PROJECT | Project Planning: Attribute Table for Project Headers | 28 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
5 | CGPL_RELATION | Project Planning: Relationships | 9 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
6 | CGPL_TASK | Project Planning: Attribute Table for Activities | 28 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
TOPPortfolio Management |
7 | RPM_DEPENDENCY | Table for Project and Task Dependencies | 9 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
8 | RPM_PROJ_LOCAT | Project Location | 4 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
9 | RPM_RESOURCE | Project Resource | 5 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
TOPProject Management |
10 | DPR_LOCATION | Location | 4 | CALENDAR_ID | Calendar | nvarchar | 2 | 0 | | |
TOPResources |
11 | RPM_BUPA_AVL | Resource Availability | 8 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |
TOPWorkforce Planning |
12 | TCYMPP | Customizing Settings for Workforce Planning | 15 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | | |