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