| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 8 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 8 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 8 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 8 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 8 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 9 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 8 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
8 | T7CN27 | Social average salary switch period | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
TOPChina |
9 | PA0530 | HR Master Record: Infotype 0530 (Public Housing Fund) | 27 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
10 | PA0532 | HR Master Record: Infotype 0532 (Insurance) | 31 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
11 | PA3532 | HR Master Record: Infotype 3532 | 31 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
12 | T7CN13 | Salary information (CN) | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
13 | T7CN14 | Contribution change reason | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
14 | T7CN15 | Social insurance authority institution information | 5 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
15 | T7CN16 | Public Housing Fund authority institution information | 3 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
16 | T7CN18 | Extended insurance authority institution information | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
17 | T7CN1A | Contribution change reason text | 5 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
18 | T7CN20 | Contribution base | 5 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
19 | T7CN24 | Contribution Type | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
20 | T7CN25 | Contribution Area | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
21 | T7CN26 | Contribution switch period | 4 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
22 | T7CN2A | Contribution Area Text | 5 | CONAR | Contribution area | nvarchar | 2 | 0 | | |
23 | T7CN2Y | Contribution Type Text | 5 | CONAR | Contribution area | nvarchar | 2 | 0 | | |