| 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 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | MMAPD | Method for Maximum Payroll Days(MPD) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | MAXPD | Maximum Payroll Days (MPD) | decimal | 6 | 2 | | | | |
| 9 | FACPD | Factor for Payroll Days | decimal | 9 | 2 | | | | |
| 10 | ROUPD | Rounding Payroll Days | char | 1 | 0 | | | | Allow NULL? |
| 11 | ROUPF | Factor for Rounding Payroll Days | decimal | 4 | 2 | | | | |
| 12 | MMAID | Method for Maximum Insurance Days(MID) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | MAXID | Maximum Insurance Days(MID) | decimal | 6 | 2 | | | | |
| 14 | FACID | Factor for Insurance Days | decimal | 9 | 2 | | | | |
| 15 | ROUID | Rounding Insurance Days | char | 1 | 0 | | | | Allow NULL? |
| 16 | ROUIF | Factor for Rounding Insurance Days | decimal | 4 | 2 | | | | |
| 17 | METPD | Method for Payroll Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | METID | Method for Insurance Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | METNP | Method for Normal Payroll | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | MILPD | Method for Illness Payroll Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | MILID | Method for Illness Insurance Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | METIL | Method for Illness | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | MDAIH | Method for Daily - Hourly EEs | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | MBASI | Method for Basic Pay per Hour | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | MDISM | Maximum Salary for Dismissal | decimal | 13 | 2 | | | | |
| 26 | ENTEB | Entitle Easter Bonus | char | 1 | 0 | | | | Allow NULL? |
| 27 | MPDEB | Maximum Payroll Days Easter Bonus(EB) | decimal | 5 | 2 | | | | |
| 28 | MCDED | Maximum Calculations Days Easter Bonus(EB) | decimal | 5 | 2 | | | | |
| 29 | FCTEB | Factor of Vacation Bonus Increment for EB | decimal | 9 | 2 | | | | |
| 30 | CLDEB | Calculation Method for Easter Bonus(EB) Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | MXDEB | Maximum Insurance Days of Easter Bonus (EB) | decimal | 6 | 2 | | | | |
| 32 | WTBEB | Wage Type for Basic Pay Easter Bonus | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | WTIEB | Wage Type for Averages Easter Bonus | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | WTLEB | Wage Type for Increment of Vacation Bonus to EB | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | ENTCB | Entitle Christmas Bonus | char | 1 | 0 | | | | Allow NULL? |
| 36 | MPDCB | Maximum Payroll Days Christmas Bonus (CB) | decimal | 5 | 2 | | | | |
| 37 | MCDCB | Maximum Calculations Days Christmas Bonus(CB) | decimal | 5 | 2 | | | | |
| 38 | FCTCB | Factor of Vacation Bonus Increment for CB | decimal | 9 | 2 | | | | |
| 39 | CLDCB | Calculation Method for Christmas Bonus(CB) Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | MXDCB | Maximum Insurance Days of Christmas Bonus(CB) | decimal | 6 | 2 | | | | |
| 41 | WTBCB | Wage Type for Basic Pay Christmas Bonus | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | WTICB | Wage Type for Averages Christmas Bonus | nvarchar | 4 | 0 | | | | Allow NULL? |
| 43 | WTLCB | Wage Type for Increment of Vacation Bonus to CB | nvarchar | 4 | 0 | | | | Allow NULL? |
| 44 | ENTVB | Entitle Vacation bonus | char | 1 | 0 | | | | Allow NULL? |
| 45 | MDMVB | Days per Month for Vacation(VB) | decimal | 6 | 2 | | | | |
| 46 | MCDVB | Maximum Calculations Days Vacation Bonus(VB) | decimal | 5 | 2 | | | | |
| 47 | MLMVB | Minimum Limit For Vacation Bonus(VB) | decimal | 5 | 2 | | | | |
| 48 | MLXVB | Maximum Limit For Vacation Bonus(VB) per year | decimal | 5 | 2 | | | | |
| 49 | WTBVB | Wage Type for Basic Pay Vacation Bonus | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | WTIVB | Wage Type for Averages Vacation Bonus | nvarchar | 4 | 0 | | | | Allow NULL? |
