| 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 | PRCTY | Procedure Type for Off-Cycle Batch Processing | char | 1 | 0 | CHAR | (N' ') | No | | PRCTY | Allow NULL? |
| 3 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 4 | LFDNR | Sequential number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PAY_SEQNR | Allow NULL? |
| 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 6 | SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | CDSEQ | Allow NULL? |
| 7 | PAYTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 8 | PAYID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 9 | BONDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BONDT | Allow NULL? |
| 10 | OCRSN | Reason for Off-Cycle Payroll | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PAY_OCRSN | Allow NULL? |
| 11 | PABRJ | Payroll Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PABRJ | Allow NULL? |
| 12 | PABRP | Payroll Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PABRP | Allow NULL? |
| 13 | LAUFD | Date on Which the Program Is to Be Run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAUFD | Allow NULL? |
| 14 | LAUFI | Additional Identification | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LAUFI | Allow NULL? |
| 15 | INDAT | Processing Date for OC Workbench | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | INPDT | Allow NULL? |
| 16 | INTIM | Processing Time OC Workbench | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | INTIM | Allow NULL? |
| 17 | INUSR | Off-Cycle Workbench Processor | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | INUSR | Allow NULL? |
| 18 | PRDAT | Processing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PROCD | Allow NULL? |
| 19 | PRTIM | Performance Time of Batch Report | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PRTIM | Allow NULL? |
| 20 | PRUSR | Batch Report User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PRUSR | Allow NULL? |
| 21 | PROCID | Process number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PAY_PROCESSID | Allow NULL? |
| 22 | POSTI | Indicator for off-cycle cancellation - already posted? | char | 1 | 0 | CHAR | (N' ') | Yes | | PAY_POSTI | Allow NULL? |
| 23 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T500L | MOLGA | Allow NULL? |
