| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPNew Zealand |
1 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 82 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
2 | PT2006 | HR Time Record: Infotype 2006 (Absence Quotas) | 34 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
TOPPersonnel Time Management |
3 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 82 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
4 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 56 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
5 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 59 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
6 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 47 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
7 | PA2005 | HR Time Record: Infotype 2005 (Overtime) | 57 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
8 | PA2006 | HR Time Record: Infotype 2006 (Absence Quotas) | 34 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
9 | PA2007 | HR Time Record: Infotype 2007 (Attendance Quotas) | 38 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
10 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 53 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
11 | PA2012 | HR Time Record: Infotype 2012 (Time Transfer Specifications) | 30 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
12 | TMW_TDLANT | Definition Set | 3 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
TOPTime Data Recording and Administration |
13 | TMW_TDLAN | Definition Set for IDs | 2 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
14 | TMW_TDSLAN | Subset | 2 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
15 | TMW_TDSLANT | Texts for Subsets | 3 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
16 | TMW_TDTYPE | Time Data ID | 2 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
17 | TMW_TDTYPETXT | Text Table for Time Data ID | 3 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
18 | TMW_TD_ATTRIB | Color Attributes for Short IDs in the TMW | 2 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
19 | TMW_TD_SUBLA | Subset | 2 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |
20 | TMW_TD_TYPE | IDs | 2 | TDLANGU | Definition Set for IDs | nvarchar | 10 | 0 | | |