Mark-off File Format (Standard Bank)
This document defines the specification requirements for the mark-off files received from Standard Bank. The data is recorded in the Online Payments Application for the purpose of reconciling CNP and MasterPass transactions processed by the Standard Bank. On a daily basis, a record of all transactions received (excluding online declines) at a detail level, is sent. These are processed by their batch processing system. The mark-off file is only for successful transactions.
Merchants who hold their receiving account with Standard Bank will have their transactions split into their own file and placed in their SFTP folder in the OUT directory
| Name | Type (Length) | Offset | Description |
|---|---|---|---|
| Header | |||
| recordType | ANS(1) | 1-1 | Identifies the record type. |
| Date | N(6) | 2-7 | File creation date. |
| fileNumber | ANS(10) | 8-17 | Sequential file number. |
| Detail | |||
| recordType | ANS(1) | 1-1 | Identifies the record type. |
| MerchantNumber | N(12) | 2-13 | Merchant identifier. |
| PAN | ANS(23) | 14-36 | Primary Account Number (masked where applicable). |
| TranType | ANS(2) | 37-38 | Transaction type. |
| rejectReasonCode | ANS(3) | 39-41 | Reason code for a rejected transaction. |
| TransactionDate | N(6) | 42-47 | Transaction processing date. |
| TransactionTime | N(6) | 48-53 | Transaction processing time. |
| SettlementDate | N(6) | 54-59 | Settlement date. |
| TransactionAmount | N(13) | 60-72 | Transaction amount. |
| Cashback | N(13) | 73-85 | Cashback amount. |
| TransactionAuthCode | ANS(10) | 86-95 | Authorisation code returned by the issuer. |
| CardType | ANS(2) | 96-97 | Card scheme or type. |
| POSEntryMode | ANS(3) | 98-100 | Method used to capture the card details. |
| cashierNumber | N(6) | 101-106 | Identifier of the cashier processing the transaction. |
| RRN | ANS(12) | 107-118 | Retrieval reference number. |
| STAN | ANS(6) | 119-124 | System Trace Audit Number. |
| GUID | ANS(36) | 125-160 | Globally unique transaction identifier. |
| terminalID | ANS(8) | 161-168 | Identifier of the payment terminal. |
| StatementBatchID | N(6) | 169-174 | Identifier of the statement batch. |
| Trailer | |||
| recordType | ANS(1) | 1-1 | Identifies the record type. |
| totalRecords | N(9) | 2-10 | Total number of records in the file. |
| totalTransactionAmount | N(17) | 11-27 | Total value of all transactions in the file. |
Updated about 10 hours ago
Did this page help you?