| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | INFTY | Infotype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | CONBR | Industry | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | CONAR | Contribution area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | CONGR | Contribution group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | CONLV | Contribution level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | PASSR | Pass rule ER to EE | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | EEIND | Employee contribution base indicator | char | 1 | 0 | | | | Allow NULL? |
| 12 | EERAT | Employee contribution rate | decimal | 8 | 3 | | | | |
| 13 | EECON | Employee contribution constant | decimal | 13 | 2 | | | | |
| 14 | ECCUR | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | EELOW | Employee contribution base low limit | decimal | 13 | 2 | | | | |
| 16 | EELCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | EEHIG | Employee contribution base high limit | decimal | 13 | 2 | | | | |
| 18 | EEHCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | ERIND | Employer contribution base indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | ERRAT | Employer contribution rate | decimal | 8 | 3 | | | | |
| 21 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | | | |
| 22 | RCCUR | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | ERLOW | Employer contribution base low limit | decimal | 13 | 2 | | | | |
| 24 | ERLCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | ERHIG | Employer contribution base high limit | decimal | 13 | 2 | | | | |
| 26 | ERHCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | EEBSR | Employee contribution base rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 28 | EECOR | Employee contribution amount rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 29 | EEWGE | Wage type of employee base for indicator U or N | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | ERBSR | Employer contribution base rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 31 | ERCOR | Employer contribution amount rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 32 | ERWGE | Wage type of employer base for indicator U or N | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | ERDIF | Insufficient Amount Covered by Employer | char | 1 | 0 | | | | Allow NULL? |
| 34 | EMRAT | Exempted contribution rate | decimal | 7 | 2 | | | | |
| 35 | EMMTP | multiplier of exempted maximum salary | decimal | 7 | 2 | | | | |
| 36 | EMAVG | Employee average monthly salary in the previous year | char | 1 | 0 | | | | Allow NULL? |
| 37 | EXMTH | PHF exemption calculation method | char | 1 | 0 | | | | Allow NULL? |
| 38 | EEAHI | Employee contribution base annual high limit | decimal | 15 | 2 | | | | |
| 39 | EEAHC | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | ERAHI | Employer contribution base annual high limit | decimal | 15 | 2 | | | | |
| 41 | ERAHC | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | EEALO | Employee contribution base annual low limit | decimal | 13 | 2 | | | | |
| 43 | EEALC | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 44 | ERALO | Employee contribution base annual low limit | decimal | 13 | 2 | | | | |
| 45 | ERALC | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 46 | CFRQC | Contribution Frequency | char | 1 | 0 | | | | Allow NULL? |
| 47 | FCMTH | First Contribution Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | PRORU | Proration Rule | char | 1 | 0 | | | | Allow NULL? |
| 49 | EXBSR | Rounding Method for PHF Exemption Calculation Base Amount | char | 1 | 0 | | | | Allow NULL? |
| 50 | EXCOR | Rounding Method for PHF Exemption Amount | char | 1 | 0 | | | | Allow NULL? |
| 51 | MOSEL | Month Selection | nvarchar | 12 | 0 | | | | Allow NULL? |
| 52 | EEEMP | Tax Exempted Amount (Employee) | decimal | 13 | 2 | | | | |
| 53 | EEECU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 54 | EREMP | Tax Exempted Amount (Employer) | decimal | 13 | 2 | | | | |
| 55 | ERECU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 56 | EXMPT_RATE_EE | PHF Exempted Contribution Rate for Employee | decimal | 7 | 2 | | | | |
| 57 | EXMPT_RATE_ER | PHF Exempted Contribution Rate for Employer | decimal | 7 | 2 | | | | |
| 58 | DIFF_EXMPT_EE_ER | Different PHF Exempted Contribution Rates for EE and for ER | char | 1 | 0 | | | | Allow NULL? |
