| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 7 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 7 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 7 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 7 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 7 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 8 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 7 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 8 | T459C | Default values for independent requirements | 9 | INNUM | Internal number assignment for requirements plan number | nvarchar | 1 | 0 | | |
| 9 | T7QA25 | Occupational Hazard(Work Injury) | 5 | INNUM | Number of Injured Persons | nvarchar | 4 | 0 | | |
| 10 | T7QA26 | Occupational Hazard(Serious Incident) | 6 | INNUM | Number of Injured Persons | nvarchar | 4 | 0 | | |
| TOPChina |
| 11 | PA0532 | HR Master Record: Infotype 0532 (Insurance) | 26 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 12 | PA3532 | HR Master Record: Infotype 3532 | 26 | INNUM | Insurance number | nvarchar | 20 | 0 | | |
| 13 | T7CN3F | Reported Tax Data | 10 | INNUM | Tax ID | nvarchar | 18 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 14 | TEK060A | Loan Categories | 5 | INNUM | Number of Installments - Specification for Creating Inst.Pln | nvarchar | 3 | 0 | | |
