| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LSTYP | Time ticket type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | DYNL0 | Full screen for data entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | DYNL1 | List screen for data entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | DYNL2 | List screen for entering data on several persons | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | DYNL3 | List screen for entering data on several groups | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | DYNL4 | List screen for entering data on several groups/persons | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | LGART | Wage type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | NFPER | Personnel number required | char | 1 | 0 | | | | Allow NULL? |
| 10 | NFGRU | Group number required | char | 1 | 0 | | | | Allow NULL? |
| 11 | LKIST | Totaling of confirmed value for employee | char | 1 | 0 | | | | Allow NULL? |
| 12 | LKSOL | Totaling of target value for employee | char | 1 | 0 | | | | Allow NULL? |
| 13 | LKVAR | Totaling of values for employee using cumulation rule | char | 1 | 0 | | | | Allow NULL? |
| 14 | LKKUM | Totaling for employee | char | 1 | 0 | | | | Allow NULL? |
| 15 | GKIST | Totaling of confirmed value for group | char | 1 | 0 | | | | Allow NULL? |
| 16 | GKSOL | Totaling of target value for group | char | 1 | 0 | | | | Allow NULL? |
| 17 | GKVAR | Totaling of values for group using cumulation rule | char | 1 | 0 | | | | Allow NULL? |
| 18 | GKKUM | Totaling for group | char | 1 | 0 | | | | Allow NULL? |
| 19 | RFZGR | Time ticket has individual result | char | 1 | 0 | | | | Allow NULL? |
| 20 | RFERG | Time ticket is relevant to group result | char | 1 | 0 | | | | Allow NULL? |
| 21 | IFPPS | Integration with Logistics | char | 1 | 0 | | | | Allow NULL? |
| 22 | RFPAY | Indicator: payroll relevance | char | 1 | 0 | | | | Allow NULL? |