| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RJ_MST | Payroll result: Monthly socail insurance table | 5 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
TOPJapan |
2 | T5J0P | Personnel Area / Personnel Subarea JP | 4 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
3 | T5J1D | HR Nursing Insurance cost JP | 2 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
4 | T5JSI | HR Branch Office Information for Social Insurance JP | 2 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
5 | T5JSR | HR Rate of Premium for Social Insurance JPN | 2 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
6 | T7JPBP_CALGRPA | Assign Allocation Calculation Group to SI Modifier | 4 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
7 | T7JPCP_APPOFFI | Define Applied Office Data | 4 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
8 | T7JPCP_BENMODA | Assign Benefit Modifier to Pension Plan | 3 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
9 | T7JPCP_CALGRPA | Contribution Amount Calculation Group Assignment | 5 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
10 | T7JPCP_DCDTRMD | Distribution Method of Amount Exceeding Maximum Contribution | 3 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
11 | T7JPCP_PAYMTHD | Define Pre-paid Retirement Allowance Contribution Method | 3 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
12 | T7JPCP_PAYPER | Define Pre-paid Retirement Allowance Calculatuion period | 3 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |
13 | T7JPSI_INR_ASN | Assign Health Insurance Insurer to Social Insurance Modifier | 2 | SCIMF | Social Insurance Modifier | nvarchar | 2 | 0 | | |