| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPNew Zealand |
| 1 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 84 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 2 | PT2006 | HR Time Record: Infotype 2006 (Absence Quotas) | 36 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| TOPPersonnel Time Management |
| 3 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 84 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 4 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 58 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 5 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 61 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 6 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 49 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 7 | PA2005 | HR Time Record: Infotype 2005 (Overtime) | 59 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 8 | PA2006 | HR Time Record: Infotype 2006 (Absence Quotas) | 36 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 9 | PA2007 | HR Time Record: Infotype 2007 (Attendance Quotas) | 40 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 10 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 55 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 11 | PA2012 | HR Time Record: Infotype 2012 (Time Transfer Specifications) | 32 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| TOPTime Data Recording and Administration |
| 12 | TMW_TDTYPE | Time Data ID | 3 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 13 | TMW_TDTYPETXT | Text Table for Time Data ID | 4 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 14 | TMW_TD_ATTRIB | Color Attributes for Short IDs in the TMW | 3 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 15 | TMW_TD_SUBLA | Subset | 4 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
| 16 | TMW_TD_TYPE | IDs | 3 | TDTYPE | Time Data ID Type | nvarchar | 4 | 0 | | |
