1.26.1 Segment Identification Number
This topic provides detailed information on bank statement upload format of segment identification number.
Table 1-110 Segment Identification Number
| Field Name (as expected in the file) | Data type | Length | Mandatory /Optional | Characteristics/ rules | Values |
|---|---|---|---|---|---|
| KEYSTRING | VARCHAR2 | 50 | No | - | Keystring |
| STATEMENTTYPE | VARCHAR2 | 7 | Yes | - | Statement type |
| TRANSACTIONDATE | VARCHAR2 | 10 | Yes | - |
Transaction date field. If transaction type ref field is branch, this field should be valid branch number. If transaction ref type field is acc-no, then transaction date field should be a valid account number else transaction date should be a valid date. |
| TRANSACTIONTYPEREF | VARCHAR2 | 9 | Yes | - | Transaction type ref. This field should have BRANCH, ACCNO, OPEN, CLOSE as mandatory . Other transaction types also can be included. |
| CREDITORDEBIT | VARCHAR2 | 1 | Yes | - | Credit or debit. Credit is + and debit is - |
| TRANSACTIONAMOUNT | VARCHAR2 | 17 | Yes | - | Transaction amount |
| STATEMENTREFERENCE | VARCHAR2 | 41 | Yes | - | Statement reference |
| TRANSACTIONCODE | VARCHAR2 | 7 | Yes | - | Transaction code |
| SERVICEFEE | VARCHAR2 | 6 | Yes | - | Service fee |
Parent topic: Bank Statement Upload Format