| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7RU0016EXT | IT-0016 expansion | 5 | CANUM | Contract Number | nvarchar | 20 | 0 | | |
TOPCapacity Leveling |
2 | ISTBED | Actual requirements records | 4 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPConfirmations |
3 | AFRU | Order Confirmations | 106 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPConstruction Equipment Management |
4 | J_3GBELP | Document Data - Item Data | 202 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
5 | ONRO2 | Refer KBED internal object number back to KBED | 5 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPData Collection |
6 | S092 | Resource Requirements: Material | 11 | CANUM | Counter | nvarchar | 4 | 0 | | |
7 | S092E | S092 - Structural Information | 6 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPScheduling |
8 | KBED | Capacity Requirements Records | 4 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
9 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 4 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPSimulation |
10 | VSKBED_CN | Version: Capacity requirement records | 5 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
11 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 5 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
12 | VSKPER_CN | Version: Workforce Planning | 5 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |
TOPWork Center |
13 | CRCA | Work Center Capacity Allocation | 4 | CANUM | Capacity allocation number | nvarchar | 4 | 0 | | |
TOPWorkforce Planning |
14 | KPER | Period Values for Workforce Planning | 4 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | |