| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 42 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| 2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 42 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| 3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 42 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| 4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 42 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| 5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 42 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| 6 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 42 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| TOPChina |
| 7 | T7CN20 | Contribution base | 37 | EXMTH | PHF exemption calculation method | nvarchar | 1 | 0 | | |
| TOPCompensation Management |
| 8 | PA0382 | HR Master Data Record Infotype 0382 (Award) | 40 | EXMTH | Exercise method | nvarchar | 4 | 0 | | |
| 9 | T71LE1 | Exercise methods | 2 | EXMTH | Exercise method | nvarchar | 4 | 0 | | |
| 10 | T71LE1T | Text tables for exercise methods | 3 | EXMTH | Exercise method | nvarchar | 4 | 0 | | |
| 11 | T71LE2 | Exercise methods allowed | 3 | EXMTH | Exercise method | nvarchar | 4 | 0 | | |
| 12 | T71LY2 | Wage Types for Awards Payroll | 4 | EXMTH | Exercise method | nvarchar | 4 | 0 | | |
