| 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 | VAGRP | Vacation allowance grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ALLTY | Type of vacation allowance | char | 1 | 0 | | | | Allow NULL? |
| 7 | REGTY | Type of regime (normal/alternative) | char | 1 | 0 | | | | Allow NULL? |
| 8 | TERMX | Special processing for termination | char | 1 | 0 | | | | Allow NULL? |
| 9 | FIXCO | Fixed component of VA reference remuneration | decimal | 15 | 2 | | | | |
| 10 | VARCO | Variable component of VA reference remuneration | decimal | 15 | 2 | | | | |
| 11 | PAMNT | VA amount paid in period | decimal | 15 | 2 | | | | |
| 12 | CPAMT | Paid VA amount cumulated until period | decimal | 15 | 2 | | | | |
| 13 | PDAYS | No.of leave days covered by VA payment in period | decimal | 10 | 5 | | | | |
| 14 | CPDAY | No.of cumulated leave days covered by VA payment | decimal | 10 | 5 | | | | |
| 15 | EAMNT | VA amount earned in period | decimal | 15 | 2 | | | | |
| 16 | CEAMT | Cumulated amount of earned VA | decimal | 15 | 2 | | | | |
| 17 | VDAYS | Number of leave days taken | decimal | 10 | 5 | | | | |
| 18 | CVDAY | No.of cumulated leave days taken | decimal | 10 | 5 | | | | |
| 19 | ESTAM | Estimated annual VA amount | decimal | 15 | 2 | | | | |
| 20 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | NQUOT | Absence quota type for annual leave entitlement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | NLDAY | Annual leave entitlement days | decimal | 10 | 5 | | | | |
| 23 | TQUOT | Absence quota type for termination entitlement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | TLDAY | Entitlement days for contract termination | decimal | 10 | 5 | | | | |
| 25 | TUNIT | Time unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | PAYFL | Type of payment frequency (A - annual; P - periodic) | char | 1 | 0 | | | | Allow NULL? |
| 27 | CPAYF | Type of payment frequency at least occuring once in year | char | 1 | 0 | | | | Allow NULL? |
| 28 | ADJFL | Flag for adjustment payment in period | char | 1 | 0 | | | | Allow NULL? |
| 29 | TERFL | Flag for contract termination adjustment | char | 1 | 0 | | | | Allow NULL? |
| 30 | AWART | Absence type of leave period triggering allowance payment | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | OBEGD | Old start date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | OENDD | Old end date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | GWTYP | Wage type generated for allowance payment | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | GAPZN | PC205 assignment | varbinary | 1 | 0 | | | | |
| 35 | GLDAY | No.of leave days for which a payment was generated | decimal | 10 | 5 | | | | |
| 36 | GZEIN | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | CLAMT | Amount to be cleared (due to as-earned principle) | decimal | 15 | 2 | | | | |
| 38 | CLDAY | Taken leave days to be cleared (due to as-earned principle) | decimal | 10 | 5 | | | | |
| 39 | CDURP | No.of months in same processing variant (in year) | decimal | 4 | 2 | | | | |
| 40 | EDIFF | Difference between estimated VA amount and reference remun. | decimal | 15 | 2 | | | | |
| 41 | GENER | Indicator for automatic generation of allowance payment | char | 1 | 0 | | | | Allow NULL? |
