| 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 | CNTR1 | SI split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SIGRP | Institution of soc. provident funds SG | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | SIOFC | Social insurance branch office | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | ADID1 | Fund type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | ADNA1 | Fund name | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | FULV1 | Wage level for contributing the additional Funds | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | PYAL1 | Pay alternative (wage-dependant) | char | 1 | 0 | | | | Allow NULL? |
| 14 | PYAL2 | Pay alternative (wage independant) | char | 1 | 0 | | | | Allow NULL? |
| 15 | BETR1 | Amount | decimal | 9 | 2 | | | | |
| 16 | WAER1 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | ADID2 | Fund type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | ADNA2 | Fund name | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | FULV2 | Wage level for contributing the additional Funds | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | PYAL3 | Pay alternative (wage-dependant) | char | 1 | 0 | | | | Allow NULL? |
| 21 | PYAL4 | Pay alternative (wage independant) | char | 1 | 0 | | | | Allow NULL? |
| 22 | BETR2 | Amount | decimal | 9 | 2 | | | | |
| 23 | WAER2 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 24 | ADID3 | Fund type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | ADNA3 | Fund name | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | FULV3 | Wage level for contributing the additional Funds | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | PYAL5 | Pay alternative (wage-dependant) | char | 1 | 0 | | | | Allow NULL? |
| 28 | PYAL6 | Pay alternative (wage independant) | char | 1 | 0 | | | | Allow NULL? |
| 29 | BETR3 | Amount | decimal | 9 | 2 | | | | |
| 30 | WAER3 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | ADID4 | Fund type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | ADNA4 | Fund name | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | FULV4 | Wage level for contributing the additional Funds | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | PYAL7 | Pay alternative (wage-dependant) | char | 1 | 0 | | | | Allow NULL? |
| 35 | PYAL8 | Pay alternative (wage independant) | char | 1 | 0 | | | | Allow NULL? |
| 36 | BETR4 | Amount | decimal | 9 | 2 | | | | |
| 37 | WAER4 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 38 | ADID5 | Fund type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | ADNA5 | Fund name | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | FULV5 | Wage level for contributing the additional Funds | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | PYAL9 | Pay alternative (wage-dependant) | char | 1 | 0 | | | | Allow NULL? |
| 42 | PYAL0 | Pay alternative (wage independant) | char | 1 | 0 | | | | Allow NULL? |
| 43 | BETR5 | Amount | decimal | 9 | 2 | | | | |
| 44 | WAER5 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 45 | BETR6 | Amount | decimal | 9 | 2 | | | | |
| 46 | WAER6 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 47 | BETR7 | Amount | decimal | 9 | 2 | | | | |
| 48 | WAER7 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
