| 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 | MOLGA | Country Grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | JUPER | Legal Person | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | GROSS | Payroll performed for gross part | char | 1 | 0 | | | | Allow NULL? |
| 9 | GDATE | Retro.acct.for gross part as of | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | NET | Payroll performed for net part | char | 1 | 0 | | | | Allow NULL? |
| 11 | NDATE | Retro.acct.for net part as of | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | FPBEG | Start date of payroll period (FOR period) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | FPEND | End of payroll period (for-period) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | IPERM | Period modifier | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | INPER | In-period for payroll | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | BONDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | PAYTY | Payroll type | char | 1 | 0 | | | | Allow NULL? |
| 18 | PAYID | Payroll Identifier | char | 1 | 0 | | | | Allow NULL? |
| 19 | VOID | Reversal Indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | VOIDD | Void date for payroll results | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | VOIDT | Void time for payroll results | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | VOIDR | Cancellation reason for payroll results | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | PERMO | Period Parameters | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | INPTY | Payroll type | char | 1 | 0 | | | | Allow NULL? |
| 27 | INPID | Payroll Identifier | char | 1 | 0 | | | | Allow NULL? |
| 28 | IPEND | End of payroll period (IN period) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | RUNTM | Time of payroll run | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | IABKRS | Payroll subunit IP | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | OCRSN | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | INOCR | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | INOCC | Category for off-cycle reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | REVERSAL | Reversal Indicator | char | 1 | 0 | | | | Allow NULL? |
| 37 | OUTOFSEQ | Out-Of-Sequence-Check Indicator | char | 1 | 0 | | | | Allow NULL? |
| 38 | OOSDATE | Create Out-Of-Sequence Check (acc. to Payroll Control Rec.) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | PERSON | Technical Person Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | PERSDATA | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | BRACKET | Bracket for a Period and its Supplementals | nvarchar | 5 | 0 | | | | Allow NULL? |
