| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | MSGID | HR: Notification Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | DATUM | Key Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | MNR | Message Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | KENNG | Identification | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | BRTAE | Gross Remuneration Was Paid For | char | 1 | 0 | | | | Allow NULL? |
| 8 | BRTTG | Number of Days for Which Gross Remuneration Is Paid | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | YBEG1 | Irregular Remuneration: Start of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | YEND1 | Irregular Remuneration: End of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | YTAG1 | Number of Working Days in Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | YBEG2 | Irregular Remuneration: Start of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | YEND2 | Irregular Remuneration: End of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | YTAG2 | Number of Working Days in Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | YBEG3 | Irregular Remuneration: Start of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | YEND3 | Irregular Remuneration: End of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | YTAG3 | Number of Working Days in Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | KRZAE | Reduction of Remuneration During Release form Work | char | 1 | 0 | | | | Allow NULL? |
| 19 | KRZTG | Number of Days By Which Remuneration Is Reduced | nvarchar | 2 | 0 | | | | Allow NULL? |