| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RB_PK | Pension Fund, Payroll Belgium | 7 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
2 | P2RC_PK | HR-CH: Pension fund payroll values | 7 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
3 | P2RN_PK | Payroll Result: Pension Module | 7 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
4 | P2UN_PK | Pension Fund, Payroll United Nations | 7 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
5 | T5C1E | Transaction Types | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
6 | T5C1F | Total Transaction Types | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
7 | T5C1G | Percentages | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
8 | T5C1H | Pension Types | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
9 | T5C1I | Texts for Pension Types | 3 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
10 | T5C1J | Pension Rates (CH) | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
11 | T5C1K | HR-CH: insurance contributions | 2 | KASSE | Insurance companies | nvarchar | 2 | 0 | | |
12 | T5C1Z | Company Pension Fund Factors | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
TOPPension fund General Parts |
13 | PA0278 | HR Master Record: Infotype 0278 (Basic Data PF [CH]) | 24 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
14 | PA0279 | HR Master Record: Infotype 0279 (Individual Values PF [CH]) | 24 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
15 | T5CP0 | HR-CH: Pension funds | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
16 | T5CP1 | HR-CH: Texts for pension funds | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
17 | T5CP2 | HR-CH: Control of pension funds | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
18 | T5CP3 | HR-CH: Field assignment for infotype 279 | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
19 | T5CP4 | HR-CH: Value assignment for fields (BI) | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
20 | T5CP5 | HR-CH: Infotypes for BI | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
21 | T5CP8 | HR-PF: Frame Texts for Infotype 0279 | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
22 | T5CPA | HR-CH: Determination of Wage Types for PF Value Types | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
23 | T5CPE | Control of PF Calculations | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
24 | T5CPF | Fund Function View | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
25 | T5CPFT | Fund Function Names | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
26 | T5CPJ | Fund Function View Categories | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
27 | T5CPJT | Fund Function View Category Names | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
28 | T5CPK | HR-CH: PF account index | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
29 | T5CPM | Infotype 0279 Fund and Employee Grouping Data | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
30 | T5CPN | PF Functions in Fund Function View Category | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
31 | T5CPR | Additional PF Re-Calculation Infotypes | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
32 | T5CPS | Additional Infotype Field Values for PF Calculation | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
33 | T5CPV | Control of PF Functions | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
34 | T5CPW | Ad Hoc Query Field Assignment | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
35 | T5NF3 | PA-PF-NL: Feldzuordnung für Infotyp 279 | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
36 | T72A1 | HR-PF: Account Types per Fund | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
37 | T72A5 | HR-IB: History PF recalculation | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
38 | T72A6 | HR-IB: Parameters for a PF recalculation | 3 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
39 | T72A9 | HR-PF: Total Compensation Statement Integration | 4 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
40 | T72AA | HR-IB: Relevance of PF Recalculations | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
41 | T72AB | HR-IB: Eligibility of PF recalculations | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
42 | T72AC | Varainats for the Wage Maintenance Debugger | 6 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
43 | T72P0 | HR-PF: Determination of Payroll Values for PF Value Types | 5 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
44 | T72T5 | HR-PF: TS Account Data | 6 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
45 | T72T6 | HR-PF: TS Account Data Totals Formation | 6 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
46 | T72T9 | HR-PF: TS Payroll Data | 6 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
47 | T72TA | HR-PF: TS Payroll Data Totals Formation | 6 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
48 | T72TB | HR-PF: TS Parameter Values | 6 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
TOPPension fund Netherlands |
49 | PA0665 | Personal-Stammsatz Infotyp 0665 | 45 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
50 | T5ND2 | HR-CH: Pension fund postings | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
51 | T5ND5 | Action per Event for retroactive Accounting for NL Pension | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
52 | T5NDC | Log tabel voor euroconversie van tabel T5NE3 VK Reporting | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
53 | T5NDD | Log tabel voor euroconversie van tabel T5NEA VK Reporting | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
54 | T5NDG | HR-NL: Output-sequentie voor output-groepering | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
55 | T5NDH | HR-NL: Output-groepering voor gebeurtenis | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
56 | T5NDI | HR-NL: Eigenschappen van gebeurtenissen | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
57 | T5NDK | HR-NL: Gebeurtenissentabel SAP HR Pension Funds Netherlands | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
58 | T5NE3 | Standentabel (VK-rapport) | 4 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
59 | T5NE6 | Berekeningsmethode (VK-rapport) | 4 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
60 | T5NE9 | Account (VK rapport) | 4 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
61 | T5NEA | Account (VK rapport) | 4 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
62 | T5NF1 | PA-PF-NL: Pensionsprodukte | 2 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
63 | T5NF2 | PA-PF-NL: Pensionsprodukttexte | 3 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
64 | T5NF4 | HR-PF: Kaderteksten voor infotype 0279 | 3 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
65 | T5NH4 | Bepaling van het parametergebied voor de werkgever | 5 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
66 | T5NP0 | Vastleggen van de relatie tussen werkgever en het fonds | 5 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
67 | T5NP1 | Vastleggen van de relatie tussen werkgever en het product | 5 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
68 | T5NP2 | Vastleggen van relatie tussen wg, fonds en parameter gebied | 5 | KASSE | Pensioenfonds | nvarchar | 4 | 0 | | |
TOPPension Fund Switzerland |
69 | PA3230 | Personnel Master Record for Infotype 3230 | 24 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
70 | T5CD2 | Mapping Infotype 3230 Value Type by DTA Update Value Type | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
71 | T5CD3 | House Bank Pension Fund for Non-Recurring Payments | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
72 | T5CD4 | Pension Fund Data for WEF File | 2 | KASSE | Pension fund | nvarchar | 4 | 0 | | |
TOPSwitzerland |
73 | T5C17 | Texts for Pension Funds | 3 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
74 | T5C18 | Pension Funds - Insurance Types | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
75 | T5C1C | Pension funds | 2 | KASSE | Pension fund | nvarchar | 2 | 0 | | |
76 | T5C1D | Texts for Pension Funds | 3 | KASSE | Pension fund | nvarchar | 2 | 0 | | |