| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ORG_UNIT | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | AWEEK1 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ADAYS1 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 6 | AWART1 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | AWEEK2 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | ADAYS2 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 9 | AWART2 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | AWEEK3 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | ADAYS3 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 12 | AWART3 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | AWEEK4 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | ADAYS4 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 15 | AWART4 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | AWEEK5 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | ADAYS5 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 18 | AWART5 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | AWEEK6 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | ADAYS6 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 21 | AWART6 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | AWEEK7 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | ADAYS7 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 24 | AWART7 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | AWEEK8 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | ADAYS8 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 27 | AWART8 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | AWEEK9 | Week number in two-digit format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | ADAYS9 | Number of Days Counter | decimal | 2 | 0 | | | | |
| 30 | AWART9 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
