| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TPCOM | Family member type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | WTGEN | Wage-type deduction amount | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | CDVAL | Value type indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | TPERO | Disburs. type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | WTDET | Wage type: days of absence for deductions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | WTRDI | Wage type: tax return | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | WTRED | Wage type: income | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | WTCCF | Wage type: settlement for family members | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | WTRCO | Taxable income for deduction settlement | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | TCFAM | Family member type sorting | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | WTFMATEORMENS | WT for fam. allow. planned monthly ded. per fam. member | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | WTFMAEFFMENS | WT family allowance actual monthly deduction for fam. memb. | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | WTFMAEFFCONG | WT actual deduction for fam. all. settl. per family member | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | WTDSC | Wage-type for deduction in case of spouse replacement | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | TXTCO | Family member type description | nvarchar | 25 | 0 | | | | Allow NULL? |