| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | SUBTY | Subtype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | HISTO | Historical Record Flag | char | 1 | 0 | | | | Allow NULL? |
| 12 | ITXEX | Text Exists for Infotype | char | 1 | 0 | | | | Allow NULL? |
| 13 | REFEX | Reference Fields Exist (Primary/Secondary Costs) | char | 1 | 0 | | | | Allow NULL? |
| 14 | ORDEX | Confirmation Fields Exist | char | 1 | 0 | | | | Allow NULL? |
| 15 | ITBLD | Infotype Screen Control | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | PREAS | Reason for Changing Master Data | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | FLAG1 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 18 | FLAG2 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 19 | FLAG3 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 20 | FLAG4 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 21 | RESE1 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | RESE2 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | GRPVL | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | FEORD | Leave provision - Denmark | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | FGPCT | Vacation Bonus Savings Percentage Rate - Denmark | decimal | 5 | 2 | | | | |
| 26 | FTPCT | Percentage of Vacation Bonus (Denmark) | decimal | 5 | 2 | | | | |
| 27 | FPFRE | Vacation Bonus / Transfer / Payment Frequency | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | SHORD | SH agreement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | SHPCT | Percentage for holiday pay allowance (Denmark) | decimal | 5 | 2 | | | | |
| 30 | SHBEU | SH-Money net pay per day (upto 18 years old) | decimal | 7 | 2 | | | | |
| 31 | SHBEO | SH-Money net pay per day (over 18) | decimal | 7 | 2 | | | | |
| 32 | SHFRE | SH-Money/frequency of transfer/payments | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | SHNEG | Negative SH balance allowed | char | 1 | 0 | | | | Allow NULL? |
| 34 | OFKOD | Leave schema Denmark | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | FZTAG | Number of additional leave days Denmark | decimal | 5 | 2 | | | | |
| 36 | FETAG | Number of additional leave days Denmark | decimal | 5 | 2 | | | | |
| 37 | F6TAG | Number of leave days guaranteed in ยง6A (DK) | decimal | 5 | 2 | | | | |
| 38 | CALJ0 | Processing leave account, year 0 | char | 1 | 0 | | | | Allow NULL? |
| 39 | DELJ0 | Reset leave, year 0 | char | 1 | 0 | | | | Allow NULL? |
| 40 | ABMET | Payroll method - PBS field (DK) | char | 1 | 0 | | | | Allow NULL? |
| 41 | CALZU | Indicator: Payroll accounting savings percentage rate (DK) | char | 1 | 0 | | | | Allow NULL? |
| 42 | CALEX | Indicator: Payroll accounting bonus percentage rate (DK) | char | 1 | 0 | | | | Allow NULL? |
| 43 | SHCLR | Indicator: Closing SH balance (DK) | char | 1 | 0 | | | | Allow NULL? |
| 44 | SHTCO | Leave account transaction key (DK) | char | 1 | 0 | | | | Allow NULL? |
| 45 | FKNUM | Leave account, daily exception factor, FORM40 col.40 | decimal | 4 | 2 | | | | |
| 46 | FKSIC | Indicator: calculate sick/leave hours (DK) | char | 1 | 0 | | | | Allow NULL? |
| 47 | FKFRE | Indicator: Leave account, exemption card (DK) | char | 1 | 0 | | | | Allow NULL? |
| 48 | CALDAT | Action date, for one-off payroll actions (DK) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | SHIND | Action date, for one-off payroll actions (DK) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 50 | SHPOR | SH individual payment percentage rate (DK) | decimal | 6 | 0 | | | | |
| 51 | SHDKK | SH individual payment amount (DK) | decimal | 9 | 2 | | | | |
| 52 | SHCUR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 53 | SHCSA | Indicator: SH individual closing (DK) | char | 1 | 0 | | | | Allow NULL? |
| 54 | SHOR2 | SH regulations (DK) | char | 1 | 0 | | | | Allow NULL? |
| 55 | TPROM | Days per period of the leave basis (DK) | decimal | 4 | 2 | | | | |
| 56 | FERIE | Indicator: Pay into FerieKonto for each period (DK) | char | 1 | 0 | | | | Allow NULL? |
| 57 | UKBRP | Payroll period for determining time period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 58 | UKBRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 59 | CALJ1 | Processing leave account, year 1 | char | 1 | 0 | | | | Allow NULL? |
| 60 | CALJ2 | Processing leave account, year 2 | char | 1 | 0 | | | | Allow NULL? |
| 61 | DELJ1 | Reset leave, year-1 | char | 1 | 0 | | | | Allow NULL? |
| 62 | DELJ2 | Reset leave, year-2 | char | 1 | 0 | | | | Allow NULL? |
| 63 | UTYPE | Leave type, duplicate of SUPTYPE DK | nvarchar | 4 | 0 | | | | Allow NULL? |
| 64 | ASME0 | Payment method year 0 | char | 1 | 0 | | | | Allow NULL? |
| 65 | ARWT0 | Garnishment Wage Type for Vacation Bonus Deduction, Year 0 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 66 | CVM1 | Code for Vacation Bonus Taxation and Payment, Base Value 1 | char | 1 | 0 | | | | Allow NULL? |
| 67 | CVM2 | Code for Vacation Bonus Taxation and Payment, Bse Val. 2 | char | 1 | 0 | | | | Allow NULL? |
| 68 | CVM3 | Code for Vacation Bonus Taxation and Pymnt, Bse Val. 3 | char | 1 | 0 | | | | Allow NULL? |
| 69 | VMTXD | Code for Vacation Bonus Payment that is already Taxed | char | 1 | 0 | | | | Allow NULL? |
| 70 | TXSH | Code for SH balance taxation and payment | char | 1 | 0 | | | | Allow NULL? |
| 71 | TXRT0 | Percentage for Taxing Vacation Bonus, Year 0 | decimal | 2 | 0 | | | | |
| 72 | BPA0 | Basic tax exemption, year 0 | decimal | 7 | 2 | | | | |
| 73 | FRIK0 | EE taxation with exemption card, year 0 | char | 1 | 0 | | | | Allow NULL? |
| 74 | VM1 | Vacation Bonus to be Calculated, Base Value 1 | decimal | 8 | 2 | | | | |
| 75 | VM2 | Vacation Bonus to be Calculated, Base Value 2 | decimal | 8 | 2 | | | | |
| 76 | VM3 | Vacation Bonus to be Calculated, Base Value 3 | decimal | 8 | 2 | | | | |
| 77 | CVADA | Code for payment of leave days | char | 1 | 0 | | | | Allow NULL? |
| 78 | SMTDT | Payroll Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 79 | VADA0 | No. of leave days, year 0 | decimal | 4 | 2 | | | | |
| 80 | CXVS0 | Code for performing payroll for extra leave bonus, year 0 | char | 1 | 0 | | | | Allow NULL? |
| 81 | XVS0 | Extra leave bonus to be calculated, year 0 | decimal | 8 | 2 | | | | |
| 82 | CCARE | Code for payment of support days not used | char | 1 | 0 | | | | Allow NULL? |
| 83 | ASME1 | Payment method year 1 | char | 1 | 0 | | | | Allow NULL? |
| 84 | ARWT1 | Garnishment Wage Types for Deducting Vac.Bonus Year 1 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 85 | TXRT1 | Percentage for Vacation Bonus Taxation, Year-1 | decimal | 2 | 0 | | | | |
| 86 | BPA1 | Basic tax exemption, year-1 | decimal | 7 | 2 | | | | |
| 87 | FRIK1 | EE taxation with exemption card, year-1 | char | 1 | 0 | | | | Allow NULL? |
| 88 | VACSU | Leave bonus to be calculated | decimal | 8 | 2 | | | | |
| 89 | VADA1 | No. of leave days, year-1 | decimal | 4 | 2 | | | | |
| 90 | VARE1 | Leave remuneration, year-1 | decimal | 8 | 2 | | | | |
| 91 | CXVS1 | Code for calculating extra leave bonus, year-1 | char | 1 | 0 | | | | Allow NULL? |
| 92 | XVS1 | Extra leave bonus to be calculated, year-1 | decimal | 8 | 2 | | | | |
| 93 | FERK1 | Number of leave days on leave card, year-1 | decimal | 4 | 2 | | | | |
| 94 | ASME2 | Payment method year-2 | char | 1 | 0 | | | | Allow NULL? |
| 95 | ARWT2 | Garn. Wage Type for Deducting Vac. Bonus, Year 2 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 96 | TXRT2 | Percentage for Vacation Bonus Taxation, Year-2 | decimal | 2 | 0 | | | | |
| 97 | BPA2 | Basic tax exemption, year-2 | decimal | 7 | 2 | | | | |
| 98 | FRIK2 | EE taxation with exemption card (Frikort), year-2 | char | 1 | 0 | | | | Allow NULL? |
| 99 | VADA2 | No. of leave days, year-2 | decimal | 4 | 2 | | | | |
| 100 | VARE2 | Leave remuneration, year-2 | decimal | 8 | 2 | | | | |
| 101 | CXVS2 | Code for calculating extra leave bonus, year-2 | char | 1 | 0 | | | | Allow NULL? |
| 102 | XVS2 | Extra leave bonus to be calculated, year-2 | decimal | 8 | 2 | | | | |
| 103 | FERK2 | Number of leave days on leave card, year-2 | decimal | 4 | 2 | | | | |
| 104 | IGNJ0 | No processing of leave, year 0 | char | 1 | 0 | | | | Allow NULL? |
| 105 | IGNJ1 | No processing of leave, year 1 | char | 1 | 0 | | | | Allow NULL? |
| 106 | IGNJ2 | No processing of leave, year 2 | char | 1 | 0 | | | | Allow NULL? |
| 107 | SVM1 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 108 | SVM2 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 109 | SVM3 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 110 | STAX0 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 111 | SVD0 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 112 | SXVS0 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 113 | SSD | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 114 | STAX1 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 115 | SVD1 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 116 | SVS | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 117 | SXVS1 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 118 | SVR1 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 119 | SFK1 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 120 | STAX2 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 121 | SVD2 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 122 | SXVS2 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 123 | SVR2 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 124 | SFK2 | Default identifier for leave handling | char | 1 | 0 | | | | Allow NULL? |
| 125 | FWV0N | No Payment 1/2 % Leave Accumulation for Year - 0 | char | 1 | 0 | | | | Allow NULL? |
| 126 | FWV0F | Payment 1/2 % Leave Accumulation Year - 0 for Holiday Acct | char | 1 | 0 | | | | Allow NULL? |
| 127 | FWV0K | Payment 1/2 % Leave Accumulation for Leave Card Y-0 | char | 1 | 0 | | | | Allow NULL? |
| 128 | FWV0C | Payment for 1/2 % Leave Accumulation in Cash Y-0 | char | 1 | 0 | | | | Allow NULL? |
| 129 | FWV0S | Standard Amount for Payment 1/2 % Leave Accumulation Y-0 | char | 1 | 0 | | | | Allow NULL? |
| 130 | FWV0A | Special Payment Amount for 1/2 % Leave Accumulation Y-0 | char | 1 | 0 | | | | Allow NULL? |
| 131 | FWV0B | Special Payment Amount for 1/2 % Leave Accumulation Year-0 | decimal | 8 | 2 | | | | |
| 132 | FWV1N | No Payment 1/2 % Leave Accumulation for Year - 1 | char | 1 | 0 | | | | Allow NULL? |
| 133 | FWV1F | Payment 1/2 % Leave Accumulation Year - 1 for Holiday Acct. | char | 1 | 0 | | | | Allow NULL? |
| 134 | FWV1K | Payment 1/2 % Leave Accumulation for Leave Card Y-1 | char | 1 | 0 | | | | Allow NULL? |
| 135 | FWV1C | Payment 1/2 % Leave Accumulation in Cash Year-1 | char | 1 | 0 | | | | Allow NULL? |
| 136 | FWV1S | Standard Amount for Payment 1/2 % Leave Accumulation Y-1 | char | 1 | 0 | | | | Allow NULL? |
| 137 | FWV1A | Special Payment Amount 1/2 % Leave Accumulation Y-1 | char | 1 | 0 | | | | Allow NULL? |
| 138 | FWV1B | Special Payment Amount 1/2 % Leave Accumulation Year-1 | decimal | 8 | 2 | | | | |
| 139 | FWV2N | No Payment 1/2 % Leave Accumulation Year - 2 | char | 1 | 0 | | | | Allow NULL? |
| 140 | FWV2F | Payment 1/2 % Leave Accumulation Year - 2 for Holiday Acct. | char | 1 | 0 | | | | Allow NULL? |
| 141 | FWV2K | Payment 1/2 % Leave Accumulation for Leave Card Y-2 | char | 1 | 0 | | | | Allow NULL? |
| 142 | FWV2C | Payment 1/2 % Leave Accumulation in Cash Year-2 | char | 1 | 0 | | | | Allow NULL? |
| 143 | FWV2S | Standard Amount for Payment 1/2 % Leave Accum. Y-2 | char | 1 | 0 | | | | Allow NULL? |
| 144 | FWV2A | Special Payment Amount 1/2 % Leave Accumulation Y-2 | char | 1 | 0 | | | | Allow NULL? |
| 145 | FWV2B | Special Payment Amount 1/2 % Leave Accumulation Year-2 | decimal | 8 | 2 | | | | |
| 146 | PAYTY | Payroll type | char | 1 | 0 | | | | Allow NULL? |
| 147 | PAYID | Payroll Identifier | char | 1 | 0 | | | | Allow NULL? |
| 148 | FTUBT | Payment of Leave Bonus | char | 1 | 0 | | | | Allow NULL? |
| 149 | NODIF | No Calculation of Leave Difference | char | 1 | 0 | | | | Allow NULL? |
| 150 | URLJJ | Leave year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 151 | OBJP0 | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 152 | UAR00 | Leave type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 153 | UAR01 | Leave type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 154 | UAN00 | Leave entitlement | decimal | 10 | 5 | | | | |