| 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 | SDATE | CLASS CPX INTERFACE Control File Snapshot Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P08_CNT01 | Allow NULL? |
| 3 | RUNNO | CLASS CPX INTERFACE Control File Run Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | P08_CNT02 | Allow NULL? |
| 4 | YREND | CLASS CPX INTERFACE Control File Year End Run | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT03 | Allow NULL? |
| 5 | CHKSN | CLASS CPX INTERFACE Control File Test Snapshot Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT04 | Allow NULL? |
| 6 | RERUN | CLASS CPX INTERFACE Control File Re-Run | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT05 | Allow NULL? |
| 7 | RRNNO | CLASS CPX INTERFACE Control File Re-Run Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | P08_CNT06 | Allow NULL? |
| 8 | RDATE | CLASS CPX INTERFACE Control File Run Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P08_CNT07 | Allow NULL? |
| 9 | RTIME | CLASS CPX INTERFACE Control File Run Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P08_CNT08 | Allow NULL? |
| 10 | RNAME | CLASS CPX INTERFACE Control File Run User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P08_CNT09 | Allow NULL? |
| 11 | EMPCT | CLASS CPX INTERFACE Control File Number Of Employees Ran | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | P08_CNT10 | Allow NULL? |
| 12 | EMPOK | CLASS CPX INTERFACE Control File Number Of Employees Okay | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | P08_CNT11 | Allow NULL? |
| 13 | DAR01 | CLASS CPX INTERFACE Control File IT0041 Date Fields | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | P08_CNT13 | Allow NULL? |
| 14 | DAR02 | CLASS CPX INTERFACE Control File IT0041 Date Fields | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | P08_CNT13 | Allow NULL? |
| 15 | DAR03 | CLASS CPX INTERFACE Control File IT0041 Date Fields | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | P08_CNT13 | Allow NULL? |
| 16 | DAR04 | CLASS CPX INTERFACE Control File IT0041 Date Fields | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | P08_CNT13 | Allow NULL? |
| 17 | MEMCT | CLASS CPX INTERFACE Control File Member's Cont. Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT14 | Allow NULL? |
| 18 | STRCT | CLASS CPX INTERFACE Control File Striker's Cont. Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT15 | Allow NULL? |
| 19 | NICCT | CLASS CPX INTERFACE Control File NI Earnings Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT16 | Allow NULL? |
| 20 | ACTCT | CLASS CPX INTERFACE Control File Actual Rem Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT17 | Allow NULL? |
| 21 | PENCT | CLASS CPX INTERFACE Control File Pensionable Rem Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT18 | Allow NULL? |
| 22 | SIXCT | CLASS CPX INTERFACE Control File Amount Six Check Box | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_CNT19 | Allow NULL? |
| 23 | TMSID | CLASS CPX INTERFACE Control File TemSe File Id | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P08_CNT20 | Allow NULL? |
| 24 | FILID | CLASS CPX INTERFACE Control File Output File Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P08_CNT21 | Allow NULL? |
