| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MOPGK | Employee Subgroup Grouping for Time Quota Types | char | 1 | 0 | | | | Allow NULL? |
| 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SEQNR | Sequence number -NUM03- | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | LGA01 | Provision wage type: current year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | LGA02 | Provision difference wage type: current year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | LGA03 | Provision correction wage type: current year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | LGA04 | Vacation provision wage type: previous years | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | LGA05 | Wage type for provision difference: previous years | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | LGA06 | Wage type for provision correction: previous years | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | NOHAB | Indicator: Wage type not considered part of regular pay | char | 1 | 0 | | | | Allow NULL? |