| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConfirmations |
1 | AFRV | Confirmation pool | 62 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
2 | AFRV_DEL | Backup Copy for Confirmation Pool | 62 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
TOPPersonnel Time Events |
3 | TPTCOR_LOGISTIC | Logistics Orders (Correction Scenario) | 3 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
4 | CC1ERP | Incorrect Time Events from CC1, Postings | 15 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
5 | CC1TEV | Temporary Buffer for Time Events from CC1 | 14 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
6 | TEVEN | Time Events | 17 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
7 | TEVEN_MORE | Additional Data for Time Events | 14 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
TOPPlant Data Collection |
8 | RUECK | Temp. storage for subsystem confirmations | 57 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
TOPTime Tickets |
9 | EVHR | HR Order Confirmations (Times/Time Events) | 14 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |
10 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 14 | PDC_OTYPE | Object Type | nvarchar | 2 | 0 | | |