| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | NC301P | IS-H EDI Data Collection Points | 17 | ANSPR | IS-H: Contact person (name) | nvarchar | 30 | 0 | | |
TOPCompany Pension Scheme Germany |
2 | P01CBE | Active CPS Contributions | 5 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
3 | P01CBF | Notional CPS Contributions | 5 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
4 | T5DCA | Entitlements / Benefit Types | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
5 | T5DCC | Texts for Benefit Types | 4 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
6 | T5DCD | Control Information: Entitlements | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
7 | T5DCM | Calculation Method for Calculated/Actual Contributions | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
8 | T5DCN | Calculation Method Employment Period/Income | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
9 | T5DCQ | Working Time Calculation Method | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
10 | T5DCR | ONE-TIME PAYMENT Calculation Method | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
11 | T5DCZ | Imputation Rules for Company Pension Scheme | 2 | ANSPR | Identifier for Imputation Group | nvarchar | 4 | 0 | | |
12 | T5DW6 | Wage Type Filter for Calculation of Basis Amount | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
13 | T5DWE | Calculation Variants per Entitlement | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
14 | T5DWET | Texts for Calculation Variants per Entitlement/Benefit Type | 4 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |
15 | T5DWZ | Bonus for Company Pension Scheme | 3 | ANSPR | Entitlement to Company Retirement Pension Plan | nvarchar | 4 | 0 | | |