| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCapacity and Resource Planning |
| 1 | /MRSS/C_RM_ASG_S | Map Booking Types to MRS Assignment Status | 2 | BOOKING_TYPE | Booking Type | nvarchar | 10 | 0 | | |
| 2 | /MRSS/C_RM_ASSGC | Maintain Colors for Assignments display | 3 | BOOKING_TYPE | Booking Type | nvarchar | 10 | 0 | | |
| 3 | /MRSS/C_RM_PSTA2 | Partner Statuses | 16 | BOOKING_TYPE | Booking Type | nvarchar | 10 | 0 | | |
| TOPMaintenance Processing |
| 4 | /MRSS/D_BAS_ASG | MRS Basis Assignments | 12 | BOOKING_TYPE | Single-Character Indicator | nvarchar | 1 | 0 | | |
| TOPPortfolio Management |
| 5 | RPM_FES_PRJ_ASGN | Assignments for Project Manager | 18 | BOOKING_TYPE | FES Booking Type | nvarchar | 1 | 0 | | |
| 6 | RPM_FES_PRJ_ROLE | Assignments for Project Manager | 18 | BOOKING_TYPE | FES Booking Type | nvarchar | 1 | 0 | | |
| 7 | RPM_FES_RES_ASGN | To be deleted | 18 | BOOKING_TYPE | FES Booking Type | nvarchar | 1 | 0 | | |
| 8 | RPM_FES_RES_ROLE | To be deleted | 18 | BOOKING_TYPE | FES Booking Type | nvarchar | 1 | 0 | | |
| TOPResources |
| 9 | DPR_BUPA_LINK | Role-Business Partner Links | 14 | BOOKING_TYPE | Booking Type | nvarchar | 1 | 0 | | |
| TOPSAP Multiresource Scheduling |
| 10 | /MRSS/C_APPT_TYP | Appointment booking type for PM/CS/CRM Order Types | 4 | BOOKING_TYPE | Appointment Booking Type | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Core |
| 11 | /SAPAPO/LRPASGLC | Table of Dispatching Details for Assignment | 11 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
| 12 | /SAPAPO/LRPASSAR | Table of Dispatching Details for Assignment | 12 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
| 13 | /SAPAPO/LRPASSGN | Obsolete: Table of Dispatching Details for Assignment | 11 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
| 14 | /SAPAPO/LRPASSIG | Table of Dispatching Details for Assignment | 11 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
| 15 | /SAPAPO/LRPGWWOP | Proxy for Workforce Management Objects | 19 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
| 16 | /SAPAPO/TSTASGLC | Table of Dispatching Details for Assignment | 11 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
| 17 | /SAPAPO/TSTASSIG | Table of Dispatching Details for Assignment | 11 | BOOKING_TYPE | Assignment Booking Type | nvarchar | 1 | 0 | | |
