| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PYD_D_AL | Payroll Data Source Framework: Action Log | 23 | DATUM1 | System Date | nvarchar | 8 | 0 | | |
2 | PYD_D_ALI | Payroll Data Source Framework: Action Log Item | 15 | DATUM1 | System Date | nvarchar | 8 | 0 | | |
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD |
3 | CD0F4TEST | Tabelle mit Feldern mit verschiedenen Eingabehilfen | 8 | DATUM1 | Datum der letzten Änderung | nvarchar | 8 | 0 | | |
TOPAttendancesAbsences |
4 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 7 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
TOPConsolidation |
5 | TF250 | Periods, Opened/Closed | 9 | DATUM1 | Date of Last Change | nvarchar | 8 | 0 | | |
TOPContract Billing |
6 | DBERCHZ | Individual Line Items | 108 | DATUM1 | Date | nvarchar | 8 | 0 | | |
7 | DBERCHZ1 | Individual line items | 60 | DATUM1 | Date | nvarchar | 8 | 0 | | |
8 | DBERCHZ5 | Individual line items (unimportant rows) | 60 | DATUM1 | Date | nvarchar | 8 | 0 | | |
TOPInvoicing |
9 | DBERDZ | DB Table: Individ. Lines - Print Document | 134 | DATUM1 | Date | nvarchar | 8 | 0 | | |
TOPMigration |
10 | TEMACTGRP | IS-U migration: Activity groups for question catalog | 3 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
11 | TEMCAT | IS-U migration: Question catalog | 7 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
12 | TEMCATEGORY | IS-U migration | 2 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
13 | TEMCNV | IS-U Mig: Conversion objects | 13 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
14 | TEMDB | IS-U Mig.: Structure of Automation Data | 20 | DATUM1 | Date | nvarchar | 8 | 0 | | |
15 | TEMFE | IS-U Mig.: Fxd Vals | 5 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
16 | TEMOB | IS-U Mig.: Migration Objs | 18 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
17 | TEMRUN | Mass import: Header data | 20 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
18 | TEMRUNDEFDIST | Mass Import Data for Distribution of Run (Defaults) | 5 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
19 | TEMRUNGROUP | Mass Import Group | 4 | DATUM1 | Date of entry | nvarchar | 8 | 0 | | |
TOPPersonnel Time Management |
20 | AFRUHR | Order Confirmations for HR | 10 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
21 | CC1ERH | Incorrect Time Events from CC1, Header Information | 5 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
22 | HRAAHDR | HR Interface Table: Document Header for Activity Allocation | 13 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
23 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 12 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
24 | PTEX2003GEN | Interface Table for IT 2003: General Information | 11 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
25 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 11 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
26 | TEXLGA | Employee Expenditures | 16 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
27 | VZWDVL | Buffer for sends within Financial Assets Management | 15 | DATUM1 | Text (10 Characters) | nvarchar | 10 | 0 | | |
TOPTime Tickets |
28 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 102 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | | |