| 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 | CNTR2 | Tax split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | STKRT | Certification period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | STPFL | Tax Liability | char | 1 | 0 | | | | Allow NULL? |
| 11 | STRKL | Tax Class (D) | char | 1 | 0 | | | | Allow NULL? |
| 12 | STTAB | Tax Table (D) | char | 1 | 0 | | | | Allow NULL? |
| 13 | KDFBT | Number of Tax Exemptions for Children (D) | decimal | 3 | 1 | | | | |
| 14 | STRKD | Number of Children for Berlin Supplement | decimal | 3 | 0 | | | | |
| 15 | KISTA | Church tax deduction - employee | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | KISTE | Church Tax Deduction - Spouse | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | KISTG | Church Tax Area (D) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | PRMNZ | Tax procedure | char | 1 | 0 | | | | Allow NULL? |
| 19 | MODEL | Tax Procedure Used | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | LZZRM | Payroll Period | char | 1 | 0 | | | | Allow NULL? |
| 21 | STAGE | Tax days | decimal | 2 | 0 | | | | |
| 22 | VFREI | Pension Tax Exemption Granted | char | 1 | 0 | | | | Allow NULL? |
| 23 | ALTKZ | Identifier: Old-Age Exemption | char | 1 | 0 | | | | Allow NULL? |
| 24 | FRB1M | Monthly Personal Exemption According to Tax Card | decimal | 9 | 2 | | | | |
| 25 | FRB1J | Annual Personal Exemption According to Tax Card | decimal | 9 | 2 | | | | |
| 26 | FRB2M | Monthly Exemption for Specific Occupational Groups | decimal | 9 | 2 | | | | |
| 27 | FRB2J | Annual Exemption for Specific Occupational Groups | decimal | 9 | 2 | | | | |
| 28 | STFRG | Flat-Rate Tax Procedure | char | 1 | 0 | | | | Allow NULL? |
| 29 | STBFG | Tax Exemption Reason | char | 1 | 0 | | | | Allow NULL? |
| 30 | STRSO | Special Rule for Taxation (D) | char | 1 | 0 | | | | Allow NULL? |
| 31 | STRS2 | Special Rule for Taxation (D) | char | 1 | 0 | | | | Allow NULL? |
| 32 | SPER1 | Lock Tax Procedure | char | 1 | 0 | | | | Allow NULL? |
| 33 | SPER2 | Lock Tax Procedure | char | 1 | 0 | | | | Allow NULL? |
| 34 | SPER3 | Lock Tax Procedure | char | 1 | 0 | | | | Allow NULL? |
| 35 | SPER4 | Lock Tax Procedure | char | 1 | 0 | | | | Allow NULL? |
| 36 | SPER5 | Lock Tax Procedure | char | 1 | 0 | | | | Allow NULL? |
| 37 | SPERK | Lock for Annual Church Tax Declaration | char | 1 | 0 | | | | Allow NULL? |
| 38 | BEGBZ | Beginning of statement period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | DSTLB | Output Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | T5D2M | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 41 | GMDNR | Municipality Number (D) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | FZAMT | Tax Office Number (D) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 43 | STBEL | Elster Special Processing | char | 1 | 0 | | | | Allow NULL? |
| 44 | AUSN1 | Change on First Day of Subsequent Period | char | 1 | 0 | | | | Allow NULL? |
| 45 | SIDNR | Tax Identification Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 46 | WERKS | Personnel Area Reporting | nvarchar | 4 | 0 | | | | Allow NULL? |
| 47 | BTRTL | Personnel Subarea Reporting | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | AGSNR | Tax Number in Electronic Tax Return Format | nvarchar | 15 | 0 | | | | Allow NULL? |
| 49 | FAKTOR | Factor for Factor Procedure | decimal | 4 | 3 | | | | |
| 50 | PKPV | Contribution Base Rate Private HI/CI | decimal | 15 | 2 | | | | |
| 51 | ELSTAM | Change by ELStAM | char | 1 | 0 | | | | Allow NULL? |
| 52 | KVZ | Additional Contribution Rate to HI and CI | decimal | 3 | 2 | | | | |
| 53 | KRV | SI Contribution Deduction Indicator | char | 1 | 0 | | | | Allow NULL? |
| 54 | PKV | Indicator HI | char | 1 | 0 | | | | Allow NULL? |
| 55 | PVZ | Indicator CI Allowance | char | 1 | 0 | | | | Allow NULL? |
| 56 | PVS | Indicator CI Saxony | char | 1 | 0 | | | | Allow NULL? |
