| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPPerishables Procurement |
| 1 | FIP_D_BUFFER_OOQ | Table containing the Open Order Quantities buffered data | 4 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| 2 | FIP_D_STAT_DQ | Table containing the Past Delivery Quantity statistical data | 4 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| 3 | FIP_D_STAT_PER | Table containing default Statistical Data Periods | 7 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| 4 | FIP_D_STAT_POQ | Table containing the Past Purchase Order Quantity stat. data | 4 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| 5 | FIP_D_STAT_REL | Statistical Data Relationship Table between Data and Periods | 3 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| 6 | FIP_D_STAT_ROQ | Table containing the Recipient Order Quantity stat. data | 4 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| 7 | FIP_D_STAT_SQ | Table containing the Past Sales Quantity statistical data | 4 | PERIOD_ID | Unique ID | varbinary | 16 | 0 | | |
| TOPSAP Multiresource Scheduling |
| 8 | /MRSS/D_SRVA_PRD | Period ID assigned to Weekdays | 3 | PERIOD_ID | GUID | varbinary | 16 | 0 | | |
| 9 | /MRSS/D_SRVA_RES | Resources assigned to Service Area | 3 | PERIOD_ID | GUID | varbinary | 16 | 0 | | |
| TOPTalent Management |
| 10 | T77TMCPPPERIOD | Analysis Period for Performance and Potential | 3 | PERIOD_ID | Analysis Period | nvarchar | 10 | 0 | | |
| 11 | T77TMCPPPERIODT | Analysis Period for Performance and Potential | 4 | PERIOD_ID | Analysis Period | nvarchar | 10 | 0 | | |
| 12 | T77TMCPPTARGET | Analysis Period for Performance and Potential | 3 | PERIOD_ID | Analysis Period | nvarchar | 10 | 0 | | |
| 13 | T77TMCRECPRD | Recurring Periods | 4 | PERIOD_ID | Recurring Period | nvarchar | 10 | 0 | | |
| 14 | T77TMCRECPRDT | Descriptions of Recurring Periods | 5 | PERIOD_ID | Recurring Period | nvarchar | 10 | 0 | | |
