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