| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | ACCST_YEAR | Bank Statement Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | ACCSTATNO | Sequential Bank Statement Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | ACCSTATDAT | Bank Statement Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ACCSTTIME | Time of Bank Statement | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | FDATEPOST | Posting Date of Oldest Posted Document on Statement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | FTIMEPOST | Posting Time of Oldest Document on Statment | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | LDATEPOST | Posting Date of Last Posted Document on Statement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | LTIMEPOST | Posting Time of Last Document on Statement | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | CDATEPOST | Posting Date of Last Posted Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | CTIMEPOST | Posting Time of Last Posted Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | SDATEPOSTL | Posting Date From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | SDATEPOSTH | Posting Date To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | XACCNTCLOS | Indicator: Account Balancing Executed | char | 1 | 0 | | | | Allow NULL? |
| 17 | SBALANCE | Beginning Balance (Acct Currency) | decimal | 23 | 2 | | | | |
| 18 | EBALANCE | End Balance (in Account Currency) | decimal | 23 | 2 | | | | |
| 19 | CURRENCY | Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | BKSTSTATUS | Processing Status of Bank Statement | char | 1 | 0 | | | | Allow NULL? |
| 21 | PROGN | Name of the Program/Report on an Application Process | nvarchar | 40 | 0 | | | | Allow NULL? |
| 22 | PROGDATE | Run Date of Program | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | PROGNO | Sequential Number of the Program Run | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | CURRSTARTNO | Number of Repeated Starts of a Mass Run | nvarchar | 3 | 0 | | | | Allow NULL? |