| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PYD_D_AL | Payroll Data Source Framework: Action Log | 28 | DATUM2 | System Date | nvarchar | 8 | 0 | | |
2 | PYD_D_ALI | Payroll Data Source Framework: Action Log Item | 20 | DATUM2 | System Date | nvarchar | 8 | 0 | | |
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD |
3 | CD0F4TEST | Tabelle mit Feldern mit verschiedenen Eingabehilfen | 10 | DATUM2 | | nvarchar | 8 | 0 | | |
TOPAttendancesAbsences |
4 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 11 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
TOPContract Billing |
5 | DBERCHZ | Individual Line Items | 109 | DATUM2 | Date | nvarchar | 8 | 0 | | |
6 | DBERCHZ1 | Individual line items | 61 | DATUM2 | Date | nvarchar | 8 | 0 | | |
7 | DBERCHZ5 | Individual line items (unimportant rows) | 61 | DATUM2 | Date | nvarchar | 8 | 0 | | |
TOPData Collection |
8 | S111 | Index: Subsequent Settlement | 19 | DATUM2 | Date for document index update (time-dependent documents) | nvarchar | 8 | 0 | | |
TOPDocumentation Tools |
9 | TLSYS | Language Versions in the System | 3 | DATUM2 | Date | nvarchar | 8 | 0 | | |
TOPInvoicing |
10 | DBERDZ | DB Table: Individ. Lines - Print Document | 135 | DATUM2 | Date | nvarchar | 8 | 0 | | |
TOPMigration |
11 | TEMACTGRP | IS-U migration: Activity groups for question catalog | 6 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
12 | TEMCAT | IS-U migration: Question catalog | 10 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
13 | TEMCATEGORY | IS-U migration | 5 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
14 | TEMCNV | IS-U Mig: Conversion objects | 15 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
15 | TEMDB | IS-U Mig.: Structure of Automation Data | 23 | DATUM2 | Date | nvarchar | 8 | 0 | | |
16 | TEMFE | IS-U Mig.: Fxd Vals | 7 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
17 | TEMOB | IS-U Mig.: Migration Objs | 20 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
18 | TEMRUN | Mass import: Header data | 23 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
19 | TEMRUNDEFDIST | Mass Import Data for Distribution of Run (Defaults) | 8 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
20 | TEMRUNGROUP | Mass Import Group | 7 | DATUM2 | Date of last change | nvarchar | 8 | 0 | | |
TOPPersonnel Time Management |
21 | AFRUHR | Order Confirmations for HR | 14 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
22 | CC1ERH | Incorrect Time Events from CC1, Header Information | 9 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
23 | COIFT | Interface to Activity Allocation | 18 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
24 | HRAAHDR | HR Interface Table: Document Header for Activity Allocation | 17 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
25 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 16 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
26 | PTEX2003GEN | Interface Table for IT 2003: General Information | 15 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
27 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 15 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
28 | TEXLGA | Employee Expenditures | 20 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
29 | VZWDVL | Buffer for sends within Financial Assets Management | 16 | DATUM2 | Text (10 Characters) | nvarchar | 10 | 0 | | |
TOPTime Tickets |
30 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 106 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | | |