| 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 | T000 | MANDT | Allow NULL? |
| 2 | PROGN | Name of the Program/Report on an Application Process | nvarchar | 40 | 0 | CHAR | (N' ') | No | BKKMPARUNHD | BKK_PROGN | Allow NULL? |
| 3 | PROGDATE | Run Date of Program | nvarchar | 8 | 0 | DATS | (N'00000000') | No | BKKMPARUNHD | BKK_PRGDAT | Allow NULL? |
| 4 | PROGNO | Sequential Number of the Program Run | nvarchar | 3 | 0 | NUMC | (N'000') | No | BKKMPARUNHD | BKK_PRGNO | Allow NULL? |
| 5 | RUNSTARTNO | Number of Repeated Starts of a Mass Run | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BKK_RUNSTARTNO | Allow NULL? |
| 6 | RUNCATG | Category of a Program Run (Parallel Processing) | char | 1 | 0 | CHAR | (N' ') | No | | BKK_RUNCATG | Allow NULL? |
| 7 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK01 | BKK_BKKRS | Allow NULL? |
| 8 | CLOS_TYP | Consolidation Frequency | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKG2 | BKK_CLSTYP | Allow NULL? |
| 9 | CLOSETIME | Balancing time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_CLSTIM | Allow NULL? |
| 10 | RUNDATE | Date of Mass Run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_RUNDAT | Allow NULL? |
| 11 | RUNTIME | Time of Program Run | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_RUNTIM | Allow NULL? |
| 12 | RUNUSER | User Who Started Program Run | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_RUNUSR | Allow NULL? |
| 13 | ACCOUNTGE | Account Number Bigger/Equal | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXGE | Allow NULL? |
| 14 | ACCOUNTLE | Account Number Smaller/Equal | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXLE | Allow NULL? |
| 15 | ACURRENCY | Currency of Current Account | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_ACCUR | Allow NULL? |
| 16 | CLOSEDATE | Balancing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CLSDAT | Allow NULL? |
| 17 | XACCRUAL | Indicator: Execute Interest Acc./Def. | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XACCRU | Allow NULL? |
| 18 | XFEEACCR | Indicator: Execute Accrual/Deferral for Charges | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XACCRF | Allow NULL? |
| 19 | TRACE | Account Balancing Log | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_TRCL | Allow NULL? |
| 20 | SIM_RUN | Simulation | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_SIM | Allow NULL? |
| 21 | TOLERANCE | Tolerance Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_TOLAMT | |
| 22 | CURR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_TCUR | Allow NULL? |
| 23 | CLOSEDATE_CC | Balancing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CLSDAT | Allow NULL? |
| 24 | VAL_DAT_TO | Cash Concentration: Value Date to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_VAL_TO | Allow NULL? |
| 25 | ROUND_POS | Cash Concentration: Rounding Off from Point | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BKK_RND_PS | Allow NULL? |
| 26 | X_SIM_RUN | Cash Concentration: X-Simulation Run | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CLSIMU | Allow NULL? |
| 27 | BANKSTATDATE | Bank Statement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_ACSTDT | Allow NULL? |
| 28 | FDATEPOST | Posting Date of Oldest Posted Document on Statement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_FPSTDT | Allow NULL? |
| 29 | FTIMEPOST | Posting Time of Oldest Document on Statment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_FPSTTI | Allow NULL? |
| 30 | XSIMULBKST | Indicator: Simulation of Statement Output | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XSIMBS | Allow NULL? |
| 31 | XSCREENOUT | Indicator: Bank Statement Standard Output | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XSCR | Allow NULL? |
| 32 | XBKSTNOITEM | Indicator: Bank Statement Without Turnovers | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XNOITEM | Allow NULL? |
| 33 | XDUPLICATE | Indicator Duplicate Creation for Bank Statement | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XDUPLICATE | Allow NULL? |
| 34 | DUPLDATEFROM | From Date for Bank Statement Duplicate Output | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_DUPLDATEFROM | Allow NULL? |
| 35 | DUPLDATETO | To Date for Bank Statement Duplicate Output | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_DUPLDATETO | Allow NULL? |
| 36 | TRACELOG | Log Category for Bank Statement | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_BKSTTRACE | Allow NULL? |
| 37 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | BKK_PRODINT | Allow NULL? |
