| 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 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | LDTYP | Calculation and Payment method | char | 1 | 0 | | | | Allow NULL? |
| 9 | LLDYR | HR AU PS:Leave Loading Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | LLDBD | HR AU PS:Leave Loading Year Begin Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | LLDED | HR AU PS:Leave Loading Year End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | MINDC | HR AU PS:Mini no. of leave taken to be eligible for LLD | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | LLDOP | Option for unpaid leave loading | char | 1 | 0 | | | | Allow NULL? |
| 14 | LLPER | Leave Loading Percentage | decimal | 5 | 2 | | | | |
| 15 | LLWTY | Leave loading payment wage type. | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | DEKTA | Dependent Quota for varying percentage link | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | AWA01 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | AWA02 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | AWA03 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | AWA04 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | AWA05 | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | MINAB | Mini no of multi absences taken within the leave loading yr | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | ABSDY | Include absence days for minimum number of days | char | 1 | 0 | | | | Allow NULL? |
| 24 | CALDY | Include calendar days within the absence period | char | 1 | 0 | | | | Allow NULL? |
| 25 | PYDAT | Payment made on a fixed date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | VALBA | Valuation basis for Leave Loading | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | PAIDE | Leave Loading based on previous or current entitlement | char | 1 | 0 | | | | Allow NULL? |
| 28 | ABSGR | Absence type grouping | nvarchar | 4 | 0 | | | | Allow NULL? |
