| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RX_LS | Payroll Results: Subsequent Time Tickets | 9 | ORIGF | Origin indicator | nvarchar | 1 | 0 | | |
TOPConfirmations |
2 | AFRU | Order Confirmations | 105 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
3 | AFRV | Confirmation pool | 60 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
4 | AFRV_DEL | Backup Copy for Confirmation Pool | 60 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
TOPPersonnel Time Events |
5 | TPTCOR_CORE | Core Information (Correction Scenario) | 13 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
6 | CC1ERP | Incorrect Time Events from CC1, Postings | 13 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
7 | CC1TEV | Temporary Buffer for Time Events from CC1 | 12 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
8 | TEVEN | Time Events | 15 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
9 | TEVEN_MORE | Additional Data for Time Events | 12 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
TOPPlant Data Collection |
10 | RUECK | Temp. storage for subsystem confirmations | 55 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
TOPTime Tickets |
11 | EVHR | HR Order Confirmations (Times/Time Events) | 12 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |
12 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 12 | ORIGF | Origin Indicator of PDC Message | nvarchar | 1 | 0 | | |