| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | UNTER | Accommodation code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | ZULAG | Code for bonus | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ALTUNT | HR-CH: Minimum age for family-related bonus | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ALTOBER | HR-CH: Maximum age for family-related bonus | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | ANZKI | HR-CH: Maximum number of entitled children | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | KINR | HR-CH: Maximum child number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | GEHALT | HR-CH: Maximum income of child | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | FAMZU | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | BETRAG | HR-CH: Amount of bonus (month) | decimal | 7 | 2 | | | | |
| 14 | BETRGSTD | HR-CH: Amount of bonus (hours) | decimal | 7 | 2 | | | | |
| 15 | CDALTBER | HR-CH: Scope of validity of child benefit/training bonus | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | CDALTBERU | HR-CH: Scope of validity of child benefit/training bonus | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | KUREGSTD | HR-CH: Reduction rule for working hours | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | KUREGEA | HR-CH: Reduction rule for partial period | nvarchar | 3 | 0 | | | | Allow NULL? |