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