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