| 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_TPY_ID | HRDCT: id of Payroll test result | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_TPY_ID | Allow NULL? |
| 3 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 4 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | CDSEQ | Allow NULL? |
| 5 | DCT_IS_TPY | HRDCT: Is a Payroll Test result? | char | 1 | 0 | CHAR | (N' ') | No | | HRDCT_IS_TPY | Allow NULL? |
| 6 | ABKRS | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 7 | FPPER | For-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | FAPER | Allow NULL? |
| 8 | FPBEG | Start date of payroll period (FOR period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FPBEG | Allow NULL? |
| 9 | FPEND | End of payroll period (for-period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FPEND | Allow NULL? |
| 10 | IABKRS | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 11 | IPERM | Period Parameters | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | PERMO | Allow NULL? |
| 12 | INPER | In-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | IPERI | Allow NULL? |
| 13 | IPEND | End of payroll period (IN period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IPEND | Allow NULL? |
| 14 | JUPER | Legal Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JUPER | Allow NULL? |
| 15 | SRTZA | Indicator: Status of record | char | 1 | 0 | CHAR | (N' ') | Yes | | SRTZA | Allow NULL? |
| 16 | PAYTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 17 | PAYID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 18 | VOID | Reversal Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VOID | Allow NULL? |
| 19 | BONDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BONDT | Allow NULL? |
| 20 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RUNDT | Allow NULL? |
| 21 | RUNTM | Time of payroll run | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RUNTM | Allow NULL? |
| 22 | PERMO | Period Parameters | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T549R | PERMO | Allow NULL? |
| 23 | VOIDD | Void date for payroll results | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VOID_DATE | Allow NULL? |
| 24 | VOIDT | Void time for payroll results | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | VOID_TIME | Allow NULL? |
| 25 | VOIDR | Cancellation reason for payroll results | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VOID_CODE | Allow NULL? |
| 26 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PAY_DATE | Allow NULL? |
| 27 | INPTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 28 | INPID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 29 | OCRSN | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PAY_OCRSN | Allow NULL? |
| 30 | INOCR | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PAY_OCRSN | Allow NULL? |
| 31 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PAY_OCCAT | Allow NULL? |
| 32 | INOCC | Category for off-cycle reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PAY_OCCAT | Allow NULL? |
| 33 | REVERSAL | Reversal Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VOID | Allow NULL? |
| 34 | OUTOFSEQ | Out-Of-Sequence-Check Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PAY_OUTOFSEQ | Allow NULL? |
| 35 | OOSDATE | Create Out-Of-Sequence Check (acc. to Payroll Control Rec.) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PAY_OOSDATE | Allow NULL? |
| 36 | ARC_GROUP | Archiving Group | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ARC_GROUP | Allow NULL? |
| 37 | CALCD | Payroll Already Run for Indicator Period | char | 1 | 0 | CHAR | (N' ') | Yes | | CALCD | Allow NULL? |
| 38 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MOLGA | 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? |
