| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 41 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |
2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 41 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |
3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 41 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |
4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 41 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |
5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 41 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |
6 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 41 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |
TOPChina |
7 | T7CN20 | Contribution base | 36 | EMAVG | Employee average monthly salary in the previous year | nvarchar | 1 | 0 | | |