| 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 | LANSP | Tax split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SPASA | Savings Scheme Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | AANS1 | External Rights for Life-Course Savings Scheme | decimal | 13 | 2 | | | | |
| 10 | VGAAN | No Rights Statement | char | 1 | 0 | | | | Allow NULL? |
| 11 | VGSPA | No Employee Savings Amount Statement | char | 1 | 0 | | | | Allow NULL? |
| 12 | BETRS | Savings Amount | decimal | 13 | 2 | | | | |
| 13 | BETRR | Interest Amount for Life-Course Savings Scheme | decimal | 13 | 2 | | | | |
| 14 | EMFSS | Payee key for bank transfers | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | EMFTS | Payee text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | BKPLS | Postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | BKORS | City | nvarchar | 25 | 0 | | | | Allow NULL? |
| 18 | BASKS | Bank country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | BASKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 20 | BASKN | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 21 | ZLSCS | Payment method | char | 1 | 0 | | | | Allow NULL? |
| 22 | ZWECK | Purpose of Bank Transfers | nvarchar | 40 | 0 | | | | Allow NULL? |
| 23 | DOELU | Reason for Withdrawal | char | 1 | 0 | | | | Allow NULL? |
| 24 | BETRU | Withdrawal Amount for Life-Course Savings Scheme | decimal | 13 | 2 | | | | |
| 25 | EMFSU | Payee key for bank transfers | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | EMFTU | Payee text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 27 | BKPLU | Postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | BKORU | City | nvarchar | 25 | 0 | | | | Allow NULL? |
| 29 | BAUKS | Bank country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | BAUKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 31 | BAUKN | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 32 | ZLSCU | Payment method | char | 1 | 0 | | | | Allow NULL? |
| 33 | AANTJ | External No. of Calendar Years f. Life-Course Savings Scheme | tinyint | 3 | 0 | | | | |
| 34 | LLVLK | Externally Cumulated Life-Course Leave Tax Credit | decimal | 13 | 2 | | | | |
| 35 | DEBIT | Automatic Debit Authorization Indicator | char | 1 | 0 | | | | Allow NULL? |
| 36 | IAAN1 | Internal Rights for Life-Course Savings Scheme | decimal | 13 | 2 | | | | |
| 37 | ZANZL | Number for determining further payment dates | decimal | 3 | 0 | | | | |
| 38 | ZFPER | First payment period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | LLRGR | Grouping for Employer Contrib. to Life-Course Savings Scheme | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | BDRWG | Employer Contribution to Life-Course Savings Scheme | decimal | 7 | 2 | | | | |
| 41 | WGBSU | Save or Pay Out Employer Contribution | char | 1 | 0 | | | | Allow NULL? |
| 42 | LLUBB | Savings Amount from Special Payments | char | 1 | 0 | | | | Allow NULL? |
| 43 | PCTWN | Employee Savings Percentage for Life-Course Savings Scheme | decimal | 7 | 2 | | | | |
| 44 | PCTWG | Employer Contribution Pct. to Life-Course Savings Scheme | decimal | 7 | 2 | | | | |
| 45 | BETRB | Savings Amount for Special Payments | decimal | 13 | 2 | | | | |
| 46 | PWNBB | EE Savings Percentage over SP for Life Course Savings Scheme | decimal | 7 | 2 | | | | |
| 47 | INTBB | Interval Between Savings Periods for Special Payments | decimal | 3 | 0 | | | | |
| 48 | ESPBB | First Savings Period for Special Payments | nvarchar | 2 | 0 | | | | Allow NULL? |
| 49 | FWGBB | Employer Contribution as Special Payment | char | 1 | 0 | | | | Allow NULL? |
| 50 | SRPER | Modification Period Correction TWK | nvarchar | 6 | 0 | | | | Allow NULL? |
| 51 | IBANS | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | | | Allow NULL? |
| 52 | IBANU | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | | | Allow NULL? |
| 53 | NOTAX | Life Course Savings Scheme: Non-Taxable Amount | decimal | 13 | 2 | | | | |
| 54 | DUMMY | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
