| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T500L | MOLGA | Allow NULL? |
| 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 6 | JUPER | Legal Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JUPER | Allow NULL? |
| 7 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 8 | GROSS | Payroll performed for gross part | char | 1 | 0 | CHAR | (N' ') | Yes | | BRUTTO | Allow NULL? |
| 9 | GDATE | Retro.acct.for gross part as of | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BRDAT | Allow NULL? |
| 10 | NET | Payroll performed for net part | char | 1 | 0 | CHAR | (N' ') | Yes | | NETTO | Allow NULL? |
| 11 | NDATE | Retro.acct.for net part as of | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NDATE | Allow NULL? |
| 12 | FPBEG | Start date of payroll period (FOR period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FPBEG | Allow NULL? |
| 13 | FPEND | End of payroll period (for-period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FPEND | Allow NULL? |
| 14 | IPERM | Period modifier | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | IPERM | Allow NULL? |
| 15 | INPER | In-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | IPERI | Allow NULL? |
| 16 | BONDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BONDT | Allow NULL? |
| 17 | PAYTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 18 | PAYID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 19 | VOID | Reversal Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VOID | Allow NULL? |
| 20 | VOIDD | Void date for payroll results | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VOID_DATE | Allow NULL? |
| 21 | VOIDT | Void time for payroll results | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | VOID_TIME | Allow NULL? |
| 22 | VOIDR | Cancellation reason for payroll results | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VOID_CODE | Allow NULL? |
| 23 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PAY_DATE | Allow NULL? |
| 24 | FPPER | For-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | FAPER | Allow NULL? |
| 25 | PERMO | Period Parameters | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | PERMO | Allow NULL? |
| 26 | INPTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 27 | INPID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 28 | IPEND | End of payroll period (IN period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IPEND | Allow NULL? |
| 29 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RUNDT | Allow NULL? |
| 30 | RUNTM | Time of payroll run | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RUNTM | Allow NULL? |
| 31 | IABKRS | Payroll subunit IP | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | IABKR | Allow NULL? |
| 32 | OCRSN | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PAY_OCRSN | Allow NULL? |
| 33 | INOCR | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PAY_OCRSN | Allow NULL? |
| 34 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PAY_OCCAT | Allow NULL? |
| 35 | INOCC | Category for off-cycle reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PAY_OCCAT | Allow NULL? |
| 36 | REVERSAL | Reversal Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VOID | Allow NULL? |
| 37 | OUTOFSEQ | Out-Of-Sequence-Check Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PAY_OUTOFSEQ | Allow NULL? |
| 38 | OOSDATE | Create Out-Of-Sequence Check (acc. to Payroll Control Rec.) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PAY_OOSDATE | Allow NULL? |
| 39 | PERSON | Technical Person Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERSONID | Allow NULL? |
| 40 | PERSDATA | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 41 | BRACKET | Bracket for a Period and its Supplementals | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PAY_BRACKET | Allow NULL? |
