| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 11 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 11 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 11 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 11 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 11 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 12 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 11 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
TOPChina |
8 | PA0530 | HR Master Record: Infotype 0530 (Public Housing Fund) | 29 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
9 | PA0532 | HR Master Record: Infotype 0532 (Insurance) | 29 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
10 | PA3532 | HR Master Record: Infotype 3532 | 29 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
11 | T7CN20 | Contribution base | 7 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
12 | T7CN23 | Contribution Level | 3 | CONLV | Contribution level | nvarchar | 2 | 0 | | |
13 | T7CN23T | Contribution Level Text | 4 | CONLV | Contribution level | nvarchar | 2 | 0 | | |