| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MOLGA | Country Grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | KLBEW | Absence valuation rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | OCABS | Indicator for absence valuation in offcycle payroll | char | 1 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | KLS01 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | REF01 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 10 | PRC01 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 11 | DRC01 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | KLS02 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | REF02 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 14 | PRC02 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 15 | DRC02 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | KLS03 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | REF03 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 18 | PRC03 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 19 | DRC03 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | KLS04 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | REF04 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 22 | PRC04 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 23 | DRC04 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | KLS05 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | REF05 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 26 | PRC05 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 27 | DRC05 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | KLS06 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | REF06 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 30 | PRC06 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 31 | DRC06 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | KLS07 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | REF07 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 34 | PRC07 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 35 | DRC07 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | KLS08 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | REF08 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 38 | PRC08 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 39 | DRC08 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | KLS09 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | REF09 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 42 | PRC09 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 43 | DRC09 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | KLS10 | Counting class for absences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | REF10 | Paid/unpaid | char | 1 | 0 | | | | Allow NULL? |
| 46 | PRC10 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 47 | DRC10 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | TIM01 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 49 | TPR01 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 50 | UNT01 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 51 | SPL01 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 52 | LGA01 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | DRW01 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | TIM02 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 55 | TPR02 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 56 | UNT02 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | SPL02 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 58 | LGA02 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 59 | DRW02 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 60 | TIM03 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 61 | TPR03 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 62 | UNT03 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 63 | SPL03 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 64 | LGA03 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 65 | DRW03 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 66 | TIM04 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 67 | TPR04 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 68 | UNT04 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 69 | SPL04 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 70 | LGA04 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 71 | DRW04 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 72 | TIM05 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 73 | TPR05 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 74 | UNT05 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 75 | SPL05 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 76 | LGA05 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 77 | DRW05 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 78 | TIM06 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 79 | TPR06 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 80 | UNT06 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 81 | SPL06 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 82 | LGA06 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 83 | DRW06 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 84 | TIM07 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 85 | TPR07 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 86 | UNT07 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 87 | SPL07 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 88 | LGA07 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 89 | DRW07 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 90 | TIM08 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 91 | TPR08 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 92 | UNT08 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 93 | SPL08 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 94 | LGA08 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 95 | DRW08 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 96 | TIM09 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 97 | TPR09 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 98 | UNT09 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 99 | SPL09 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 100 | LGA09 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 101 | DRW09 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 102 | TIM10 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 103 | TPR10 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 104 | UNT10 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 105 | SPL10 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 106 | LGA10 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 107 | DRW10 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 108 | TIM11 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 109 | TPR11 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 110 | UNT11 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 111 | SPL11 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 112 | LGA11 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 113 | DRW11 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 114 | TIM12 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 115 | TPR12 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 116 | UNT12 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 117 | SPL12 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 118 | LGA12 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 119 | DRW12 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 120 | TIM13 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 121 | TPR13 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 122 | UNT13 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 123 | SPL13 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 124 | LGA13 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 125 | DRW13 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 126 | TIM14 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 127 | TPR14 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 128 | UNT14 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 129 | SPL14 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 130 | LGA14 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 131 | DRW14 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 132 | TIM15 | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 133 | TPR15 | Percentage of Absences | decimal | 5 | 2 | | | | |
| 134 | UNT15 | Time unit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 135 | SPL15 | Basic pay split | char | 1 | 0 | | | | Allow NULL? |
| 136 | LGA15 | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 137 | DRW15 | Day rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 138 | CYCLS | Personnel Calculation Rule | nvarchar | 4 | 0 | | | | Allow NULL? |
| 139 | TIMES | Indicator for valuation | char | 1 | 0 | | | | Allow NULL? |
| 140 | OPERA | Operation ID | char | 1 | 0 | | | | Allow NULL? |
| 141 | GENER | Time wage type selection | char | 1 | 0 | | | | Allow NULL? |