| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P08P1CLS | CLASS CPX INTERFACE Snapshot Table | 11 | SCHEM | CLASS CPX INTERFACE Scheme Id | nvarchar | 3 | 0 | | |
2 | P2RX_VERSION | Information on Creation | 10 | SCHEM | Personnel calculation schema | nvarchar | 4 | 0 | | |
3 | PTRV_DELETE_LOG | Log Table for Deleted Trips | 9 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
4 | T5GPBS1 | CLASS CPX Pension Scheme Cross Reference | 2 | SCHEM | Pension scheme | nvarchar | 3 | 0 | | |
5 | T5GPBS42 | Declare vehicle types for private and business miles | 3 | SCHEM | Car scheme | nvarchar | 4 | 0 | | |
6 | T5GPBS_VEHTYPE | Derive vehicle types from car information | 2 | SCHEM | Vehicle Classification | nvarchar | 4 | 0 | | |
TOPGreat Britain |
7 | PA0222 | HR Master Record for Infotype 0222 (Company Cars GB) | 49 | SCHEM | Car scheme | nvarchar | 4 | 0 | | |
TOPNon Profit Organizations |
8 | T7UN_T52C0 | Abrechnungsschemen | 1 | SCHEM | Personalrechenschema | nvarchar | 4 | 0 | | |
9 | T7UN_T52C2 | Texte zu Abrechnungsschemen | 2 | SCHEM | Personalrechenschema | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
10 | T52C0 | Payroll Schemas | 1 | SCHEM | Personnel calculation schema | nvarchar | 4 | 0 | | |
11 | T52C1 | Payroll Schemas (Customer) | 2 | SCHEM | Personnel calculation schema | nvarchar | 4 | 0 | | |
12 | T52C2 | Texts for Personnel Calculation Schemas | 2 | SCHEM | Personnel calculation schema | nvarchar | 4 | 0 | | |
13 | T52C3 | Texts for Personnel Calculation Schemas | 3 | SCHEM | Personnel calculation schema | nvarchar | 4 | 0 | | |
TOPPension fund General Parts |
14 | T5CB4 | PC Schemas | 4 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
15 | T5CB5 | Texts for PC Schemas | 5 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
16 | T5CBA | PC Schema of PC Evaluation Type | 5 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
17 | T5CBC | Compatibility of PC Schemas and Output Sequences | 4 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
18 | T5CBF | Individual Processing of a PC Schema | 4 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
19 | T5CBO | Additional Selection Parameters for Reports | 4 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
20 | T5CBX | Settings for PC Schema | 4 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
21 | T5CP4 | HR-CH: Value assignment for fields (BI) | 3 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
22 | T5CP5 | HR-CH: Infotypes for BI | 3 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
23 | T5CPI | HR-CH: Settings for PC Schemata for PF | 2 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
24 | T72A7 | HR-PF: ESS Control for Universal Evaluations | 5 | SCHEM | PC schema | nvarchar | 2 | 0 | | |
TOPPublic Sector |
25 | PA0488 | HR-SG-PS: Leave scheme | 24 | SCHEM | Scheme code | nvarchar | 2 | 0 | | |
26 | PB0488 | HR-SG-PS: Leave scheme | 24 | SCHEM | Scheme code | nvarchar | 2 | 0 | | |
27 | T5PBSR3A | Leave scheme types | 2 | SCHEM | Scheme code | nvarchar | 2 | 0 | | |
28 | T5PBSR3AT | Text table for leave schemes | 3 | SCHEM | Scheme code | nvarchar | 2 | 0 | | |
TOPSingapore |
29 | PA0186 | HR Master Record: Infotype 0186 [Social Insurance] (SG) | 49 | SCHEM | Switch for the CPF voluntary | nvarchar | 1 | 0 | | |
TOPTravel Expenses |
30 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 7 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
31 | PTRV_HEAD | General Trip Data | 7 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
32 | PTRV_SBACKLOG | Trip Statistics - Batch/Backlog Processing | 5 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
33 | T706S | Trip Schema | 3 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
34 | T706S_RECEIPT | Trip Schemas: Assignment of Travel Expense Types | 3 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
35 | T706T | Names for trip schema | 4 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
36 | T706Z1 | Single Field Control for Dialog | 4 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
37 | T706Z1_TXT | Text table: Individual Field Control for Dialog | 5 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
TOPTravel Planning |
38 | FTPT_TM_MEMO | Memo table for Travel Management | 4 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |
39 | TA22B | Assignment trip schema - travel plan type | 5 | SCHEM | Trip schema | nvarchar | 2 | 0 | | |