| ACCOUNT_REF |
VARCHAR |
8 |
8 |
Bank Account Reference |
|
| STATEMENT_REF |
VARCHAR |
30 |
30 |
Statement Reference |
|
| CLOSING_BALANCE |
DOUBLE |
8 |
15 |
Closing Balance |
|
| OPENING_BALANCE |
DOUBLE |
8 |
15 |
Opening Balance |
|
| AMOUNT_IN |
DOUBLE |
8 |
15 |
Total paid in during this statement |
|
| AMOUNT_OUT |
DOUBLE |
8 |
15 |
Total paid out during this statement |
|
| INTEREST |
DOUBLE |
8 |
15 |
Interest Amount |
|
| INTEREST_ID |
INTEGER |
4 |
10 |
Interest Row ID |
|
| INTEREST_NOM_CODE |
VARCHAR |
8 |
8 |
Nominal Code for Interest |
|
| CHARGES |
DOUBLE |
8 |
15 |
Charges Amount |
|
| CHARGES_ID |
INTEGER |
4 |
10 |
Charges Row ID |
|
| CHARGES_NOM_CODE |
VARCHAR |
8 |
8 |
Nominal Code for Charges |
|
| STATEMENT_DATE |
DATE |
2 |
10 |
Statement Date |
|
| INTEREST_DATE |
DATE |
2 |
10 |
Interest Date |
|
| CHARGES_DATE |
DATE |
2 |
10 |
Charges Date |
|
| RECONCILIATION_DATE |
DATE |
2 |
10 |
Reconciliation Date |
|
| RECORD_CREATE_DATE |
|
16 |
0 |
Date and time when the record was created. |
|
| RECORD_MODIFY_DATE |
|
16 |
0 |
Date and time when the record was modified. |
|
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
|