| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 29 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| 2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 29 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| 3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 29 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| 4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 29 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| 5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 29 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| 6 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 29 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| TOPChina |
| 7 | T7CN26 | Contribution switch period | 5 | MOCON | Switch period | nvarchar | 2 | 0 | | |
| TOPSpain |
| 8 | PA0062 | HR master record Infotype 0062 (Tax Spain)) | 54 | MOCON | Contract type for tax according to the tax office | nvarchar | 1 | 0 | | |
