| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | PABRP | Payroll Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | LGART | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | APZNR | PC205 assignment | varbinary | 1 | 0 | | | | |
| 9 | BETRG | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 10 | HDBEG | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | HDEND | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | SAIND | S17A indicator mentions allowance is part of Superannuation | char | 1 | 0 | | | | Allow NULL? |
| 13 | SSOLL | Planned working time in hours | decimal | 5 | 2 | | | | |
| 14 | FCODE | Superannuation Fund Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | CONTR | Contributor status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | CS551 | Partial contributor | char | 1 | 0 | | | | Allow NULL? |
| 17 | CS542 | Employee going for part-time for more than 12 months | char | 1 | 0 | | | | Allow NULL? |
| 18 | SFTID | Indicator shift work or Non-shift work | char | 1 | 0 | | | | Allow NULL? |
| 19 | LWOPB | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | LWOPE | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | COSUP | Computed Superable salary | decimal | 15 | 2 | | | | |
| 23 | ADSUP | Adjusted Superable salary | decimal | 15 | 2 | | | | |
| 24 | INSUP | Initial Superable salary | decimal | 15 | 2 | | | | |
| 25 | FISUP | Final Superable salary | decimal | 15 | 2 | | | | |
| 26 | PRZNT | Percentage of increase for wage type | decimal | 7 | 2 | | | | |
| 27 | RATDT | Ratification date of National Wage Case | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | SUBEG | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | SUEND | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | SCBAS | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 31 | SCALL | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 32 | SCPEN | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 33 | SCHDA | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 34 | JONID | Superannuation Fund Joined Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | NOTSL | APS Superannuation Notional Salary | decimal | 15 | 2 | | | | |
| 36 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | UNHDA | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 39 | TRHDA | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 40 | BENHR | APS Superannuation benefit hours | decimal | 5 | 2 | | | | |
