| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | CNTR3 | SI split | varbinary | 1 | 0 | | | | |
| 6 | LGART | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | ANWSCHLCH | Application key Switzerland | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | ANWSCHL | Application key for Social insurance Switzerland | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | BEREICH | Contibution level for insurance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | LIMITE | Insurance limits | decimal | 9 | 2 | | | | |
| 14 | PR_AG | HR-CH: Insurance rate premiums 4 decimal points | decimal | 9 | 4 | | | | |
| 15 | PR_AN | HR-CH: Insurance rate premiums 4 decimal points | decimal | 9 | 4 | | | | |
| 16 | DIFF | Indicator for contribution levying differential | char | 1 | 0 | | | | Allow NULL? |
| 17 | EINHEIT | HR-CH: unit for contribution rates | char | 1 | 0 | | | | Allow NULL? |
| 18 | BETAN | HR-CH: Insurance contributions | decimal | 9 | 2 | | | | |
| 19 | BETAG | HR-CH: Insurance contributions | decimal | 9 | 2 | | | | |
| 20 | BASIS | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 21 | DIFF_BASIS | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 22 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | PR_AG1 | HR-CH: Insurance rate premium | decimal | 8 | 3 | | | | |
| 24 | PR_AN1 | HR-CH: Insurance rate premium | decimal | 8 | 3 | | | | |
| 25 | KZFIX | Fixed insurance total for premium calculation | char | 1 | 0 | | | | Allow NULL? |
| 26 | BASIS_KUM | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 27 | DIFFBASIS_KUM | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 28 | ANWSCHLCH2 | Secondary Application Key Switzerland | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | ANWSCHL2 | Secondary Application Key SI Switzerland | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | BTRT1 | Personnel subarea | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | UVGBTRTL | HR-CH: Personnel subarea UVG/SUVA | char | 1 | 0 | | | | Allow NULL? |
| 32 | ACATG | Insurance Category Code of Insurer | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | SW_NPFL | Indicator for Exempt Wage | char | 1 | 0 | | | | Allow NULL? |
| 34 | CNTR2 | C2 Split | varbinary | 1 | 0 | | | | |
| 35 | PR_BU_AG | Value of payroll constants | decimal | 9 | 2 | | | | |
| 36 | PR_NBU_AG | Value of payroll constants | decimal | 9 | 2 | | | | |
| 37 | PR_NBU_AN | Value of payroll constants | decimal | 9 | 2 | | | | |
| 38 | PR_NBUZ_AG | Value of payroll constants | decimal | 9 | 2 | | | | |
| 39 | PR_NBUZ_AN | Value of payroll constants | decimal | 9 | 2 | | | | |
| 40 | PFL_PER | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 41 | PFL_JAHR | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 42 | GES_JAHR | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 43 | HLOHN_JAHR | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 44 | HLOHN_LUFT | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 45 | HLOHN_SVTG | HR-CH: SI days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | BAS_JAHR | HR-ch: Basis for charging insurance contributions | decimal | 9 | 2 | | | | |
| 47 | LGART2 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
