9.2 - Early Reconciliation Report version 2.0.0
Each report contains detailed information about each approved transaction related to one partner. Files are generated and delivered to Rapyd SFTP server 2-4 hours after each file delivered to us from partner's processor.
The filename is constructed as follows: YMMDD + File ID + ".erf". For example: 40225001.erf
The generation of this file is only started upon request.
9.2.1 - Early Reconciliation
| Field name | Length/type | Nullable/Empty | Description |
|---|---|---|---|
| TransactionID | 12 | No | Transaction ID, Merchant Reference Number |
| TransactionLifecycleId | 15 | Yes | Identifier assigned by card schemes (not unique) |
| TerminalID | 8 | No | Rapyd terminal ID |
| AcquirerReferenceNumber | 23 | Yes | Acquirer Reference Number (ARN). Unique ID in Rapyd system |
| AgreementNumber | 6 | No | Rapyd agreement number |
| ReferenceData | 50 | Yes | Merchant assigned reference data. Also called merchantReferenceData |
| TransactionDate | 10 | No | Date of the businesss transaction, in general the date the authorization message was submitted, YYYY-MM-DD |
| ReconciliationAmount | decimal | Yes | Gross amount settled with the merchant in the merchants settlement currency (i.e. fees have not been netted) |
| ReconciliationCurrency | 3 | No | Agreement settlement currency |
| TransactionAmount | decimal | No | If dcc then dcc amount, if multicurrency then multicurrency amount else original amount |
| TransactionCurrency | 3 | No | Transaction currency in numeric ISO |
| CardScheme | 1 | No | V(isa), M(asterCard), A(MEX) etc |
| CardNumber6_4 | 19 | No | Masked Primary Account Number (PAN) |
| SettlementKey | 6 | Yes | SALE05, REFU06, CASHAD etc. indicates the sign of the transaction amount |
| TransactionType | 2 | No | Rapyd Transaction Type see list in section 9.2.3 - Transaction Types |
| BatchNumber | 10 | No | Batch number (i.e. BatchID ) as assigned by the Merchant or Processor |
| MerchantName | 25 | No | DBA name |
| MerchantCountry | 3 | No | Merchant country in numeric ISO |
| MerchantCategoryCode | 4 | No | Merchant Category Code (MCC) |
| ValitorProcessingTime | 19 | Yes | Time when transaction is created in Rapyd system (yyyy-MM-dd HH:mm:ss) |
| InterchangeFeeRegion | 50 | No | Domestic, intra-europe, interregional etc |
| InterchangeMarketName | 50 | No | Icelandic, German, European etc |
| InterchangeCardCategory | 50 | No | Corporate, consumer, business etc |
| InterchangeTransactionCategory | 50 | No | Card Present, 3D Secure etc |
| CardUsage | 1 | No | Card usage classification (0=Uncategorized, 1=Credit, 2=Debit) |
| CardIssuerCountry | 3 | Yes | Cardholder country / Issuer country |
| BaseCostFixed | decimal | Yes | Base cost fixed. Base cost is sum of fixed and percentage calculated fee. This is the fixed amount |
| BaseCostPercent | decimal | Yes | Base cost percent. Base cost is sum of fixed and percentage calculated fee. This is the percentage calculated amount |
| BaseCost | decimal | Yes | Interchange in merchant settlement currency |
| MerchantPriceFixed | decimal | Yes | Rapyd fixed fee, flat rate per transaction |
| MerchantPricePercentage | decimal | Yes | Rapyd percent fee, percentage of volume (reconciliation amount) |
| MerchantPrice | decimal | Yes | Rapyd total fee, this includes interchange and scheme fee for I++ |
| PartnerPriceFixed | decimal | Yes | Price to partner, fixed |
| PartnerPricePercentage | decimal | Yes | Price to partner, percent |
| PartnerPrice | decimal | Yes | Total price to partner |
| SchemeFeeCurrency | decimal | Yes | Scheme fee currency code |
| SchemeFeeFixed | decimal | Yes | Scheme fee fixed amount in scheme fee currency |
| SchemeFeePercentage | decimal | Yes | Scheme fee percentage |
| SchemeFee | decimal | Yes | Total scheme fee amount, fixed and percentage, in scheme fee currency |
| SchemeFeeBase | decimal | Yes | Total scheme fee amount in agreement currency |
| MulticurrencyFeePercent | decimal | Yes | Multicurrency fee percentage |
| MultiCurrencyFee | decimal | Yes | Total multicurrency fee |
| SponsoredMerchantID | 8 | Yes | Unique ID for submerchants |
| InterchangeCurrencyCode | 3 | Yes | Interchange currency code |
| TransactionFee | decimal | Yes | Required in ATM transactions if a surcharge is applied |
| DCCCommissionAmount | decimal | Yes | Merchant DCC commission. Only if transaction is a DCC |
| PartnerDCCCommissionAmount | decimal | Yes | Partner DCC commission. Only if transaction is a DCC |
| ErrorCode | 4 | Yes | Error code displayed if transaction could not be processed due to an error. If filled other fields, such as pricing fields, may be empty |
| ErrorMessage | 200 | Yes | Description of the error if transaction was not processed due to an error |
9.2.2 - Example
TransactionID|TransactionLifecycleId|TerminalID|AcquirerReferenceNumber|AgreementNumber|ReferenceData|TransactionDate|ReconciliationAmount|ReconciliationCurrency|TransactionAmount|TransactionCurrency|CardScheme|CardNumber6_4|SettlementKey|TransactionType|BatchNumber|MerchantName|MerchantCountry|MerchantCategoryCode|ValitorProcessingTime|InterchangeFeeRegion|InterchangeMarketName|InterchangeCardCategory|InterchangeTransactionCategory|CardUsage|CardIssuerCountry|BaseCostFixed|BaseCostPercent|BaseCost|MerchantPriceFixed|MerchantPricePercentage|MerchantPrice|PartnerPriceFixed|PartnerPricePercentage|PartnerPrice|SchemeFeeCurrency|SchemeFeeFixed|SchemeFeePercentage|SchemeFee|SchemeFeeBase|MulticurrencyFeePercent|MultiCurrencyFee|SponsoredMerchantID|InterchangeCurrencyCode|TransactionFee|DCCCommissionAmount|PartnerDCCCommissionAmount|ErrorCode|ErrorMessage|
426023180356|SURFJ62DS0816 |20000448|75282524261134926631763|230891|tx_L5FvKsy8g3 |2024-09-16|163.5700|978|163.5700|978|M|554498******3579|SALE05|1B|09173hkDIU|Rap*Irish Gas |528|1731|2024-09-17 10:30:03|MC Europe Intra-EEA|Europe Intra-EEA|Consumer Debit|3D Secure|0|380|0.0000|0.3271|0.3271|0.0000|0.0320|0.7126|0.0000|0.0000|0.3332|978|0.0066|0.1997|0.3332|0.3332||0.0000|03844014|978|0.0000|||||
426023180422|MSIFLYTDS0816 |20000449|75282524261134926631789|230891|tx_zcrcRzjj8S |2024-09-16|11.4700|978|11.4700|978|M|679107*********7119|SALE05|1B|0917kFmKTW|Rap*Paperlike |528|2741|2024-09-17 10:30:04|MC Domestic|Netherlands|Consumer Debit|3D Secure|0|528|0.0200|0.0000|0.0200|0.0000|0.0320|0.0612|0.0000|0.0000|0.0375|978|0.0289|0.0748|0.0375|0.0375||0.0000|06639991|978|0.0000|||||
426023180252|MCSFH68DS0816 |20000450|75282524261134926631805|230891|tx_6jEMkNVjYL |2024-09-16|15.9400|978|15.9400|978|M|525636******8144|SALE05|12|0917p16Jie|Rap*RentersX B.V. |528|4121|2024-09-17 10:31:11|MC Europe Intra-EEA|Europe Intra-EEA|Consumer Credit|Recurring|0|056|0.0000|0.0478|0.0478|0.0000|0.0320|0.0884|0.0000|0.0000|0.0355|978|0.0066|0.1812|0.0355|0.0355||0.0000|04264474|978|0.0000|||||
426023180234|MCCFHXXDS0816 |20000450|75282524261134926631813|230891|tx_4nzC56bhyZ |2024-09-16|16.0000|978|16.0000|978|M|523256******5249|SALE05|12|0917p16Jie|Rap*RentersX B.V. |528|4121|2024-09-17 10:31:11|MC Europe Intra-EEA|Europe Intra-EEA|Consumer Credit|Recurring|0|276|0.0000|0.0480|0.0480|0.0000|0.0320|0.0887|0.0000|0.0000|0.0356|978|0.0066|0.1812|0.0356|0.0356||0.0000|04264474|978|0.0000|||||
426023180249|MCBFH47DS0816 |20000450|75282524261134926631821|230891|tx_rdF7s7GaEb |2024-09-16|1.6900|978|1.6900|978|M|547835******6068|SALE05|12|0917p16Jie|Rap*RentersX B.V. |528|4121|2024-09-17 10:31:11|MC Europe Intra-EEA|Europe Intra-EEA|Business Credit|Recurring|0|056|0.0000|0.0279|0.0279|0.0000|0.0320|0.0381|0.0000|0.0000|0.0097|978|0.0066|0.1812|0.0097|0.0097||0.0000|04264474|978|0.0000|||||
426023180418|MCTRU23KO0298 |20000462|75282478227130000000084|230891|tx_HT4rd7Uic3 |2024-09-16|9620.0000|352|69.8500|978|M|520618******0200|SALE05|45|SS864401EG|Rap*Icebus Tours |352|4722|2024-09-17 13:45:53|MC Domestic|Netherlands|Consumer Debit|Card Present|0|352|0.0000|57.6000|57.6000|0.1400|0.0000|0.1400|1.0000|0.0000|0.0000|978|0.0047|0.0688|0.0577|7.2048||0.0000||978|0.0000|105.8200|153.9200|||
426023180688||20000450|75282524266484377544671|230891||2024-09-16|100.0000|978|100.0000|978|A|375348*****0100|SALE05|17|5286x2tY5H|Rap*RentersX B.V. |528|4121|2024-09-16 13:45:00|AMEX||||0|352|0.0000|0.0000|0.0000|0.0000|3.4000|3.4000|0.0000|0.0000|0.0000|978|0.0000|0.0000|0.0000|0.0000||0.0000||978|0.0000|||2100|Sale has already received a chargeback|
9.2.3 - Transaction Types
| Number | Description |
|---|---|
| 10 | Mail order |
| 11 | Telephone order, with CVV2/CVC2 |
| 12 | Subsequent transaction |
| 15 | E-commerce, Verified by Visa / MasterCard SecureCode / Amex SafeKey |
| 16 | E-commerce, Verified by Visa attempt / MasterCard SecureCode Attempt / Amex SafeKey Attempt |
| 17 | E-commerce, with CVV2/CVC2. Only for SCA Exemptions or "one-leg-out" transactions. |
| 1B | Tokenized transaction |
| 21 | Manual key entry (cardholder present) |
| 22 | Magnetic stripe read |
| 2A | Manual key entry (cardholder absent, e.g. telephone order) |
| 31 | Manual key entry (cardholder present) |
| 32 | Magnetic stripe read - POS error (e.g. PIN-pad down) |
| 33 | Magnetic stripe read - chip unreadable |
| 35 | Chip card read |
| 36 | Magnetic stripe read - no chip on card |
| 37 | Magnetic stripe read - forced fall-back |
| 3A | Manual key entry (cardholder absent, e.g. telephone order) |
| 41 | Manual key entry (cardholder present) |
| 42 | Magnetic stripe read - POS error (e.g. PIN-pad down) |
| 43 | Magnetic stripe read - chip unreadable |
| 44 | Contactless / proximity payment |
| 45 | Chip card read |
| 46 | Magnetic stripe read - no chip on card |
| 47 | Magnetic stripe read - forced fall-back |
| 49 | Contactless magnetic stripe - no chip on card |
| 4A | Manual key entry (cardholder absent, e.g. telephone order) |
| 4B | Device token (Iceland domestic only) |
| 62 | Magnetic stripe read |
| 64 | Contactless / proximity payment |
| 65 | Chip card read |
| 72 | Magnetic stripe read |
| 74 | Contactless / proximity payment |
| 75 | Chip card read |
9.2.4 - Interchange Card Categories
| List of Interchange Card Categories |
|---|
| Uncategorized |
| Consumer Card |
| Premium Card |
| Corporate Card |
| Consumer Debit |
| Premium Debit |
| Corporate Debit |
| Consumer Credit |
| Premium Credit |
| Corporate Credit |
| Business Card |
| Business Debit |
| Business Credit |
| Business-to-Business Card |
| Business-to-Business Debit |
| Business-to-Business Credit |
| Super-Premium Card |
| Super-Premium Debit |
| Super-Premium Credit |
Please note
This is not an exhaustive list and more may be added later.
9.2.5 - Error codes and error messages
| Error codes | Error messages |
|---|---|
| 1000 | Batch amount must be numeric |
| 1015 | Field Empty in Batch |
| 1020 | No fail free transactions in batch |
| 1030 | No transactions in batch |
| 1035 | Wrong number of Transactions in Batch |
| 1040 | Batch date is invalid |
| 1045 | Batch date later than current date |
| 1050 | Merchant agreement not found |
| 1051 | Merchant agreement is closed for transactions |
| 1052 | Merchant agreement is not active |
| 1053 | Terminal ID not found |
| 1054 | Terminal is closed for transactions |
| 1055 | Recurring transaction not allowed at this terminal |
| 1056 | Terminal ID is not active |
| 1057 | Terminal does not belong to Merchant |
| 1060 | Batch id not unique |
| 1061 | Duplicate batch in file. |
| 1070 | Wrong Processor ID |
| 1080 | Invalid Currency for Merchant Agreement |
| 1085 | Total batch amount above fraud threshold |
| 1086 | Batch net amount should be zero or higher |
| 1090 | File structure is wrong |
| 1094 | Unknown format code. |
| 1095 | Line is of incorrect length. |
| 2010 | Invalid transaction type |
| 2011 | Invalid transaction code |
| 2012 | Terminal setup incorrect |
| 2015 | Empty field |
| 2016 | Wrong Merchant City |
| 2017 | Wrong Merchant Country |
| 2020 | Transaction amount must be numeric |
| 2025 | Transaction amount must not equal zero |
| 2026 | Unauthorized amount |
| 2027 | Multiple Captures - Unauthorized amount |
| 2028 | Pre-authorization amount is lower than completion amount |
| 2029 | Total TransactionAmount exceeds Authorization amount |
| 2030 | Transaction date is invalid |
| 2040 | Transaction date is later than current date |
| 2049 | No authorization found for completion |
| 2050 | Authorization for transaction is not found |
| 2051 | Invalid Authorization Code |
| 2052 | Duplicate transaction |
| 2053 | Terminal Id different from Authorization |
| 2054 | Invalid Transaction Type |
| 2055 | Authorization has been reversed |
| 2056 | Wrong Terminal Id |
| 2057 | Wrong Name in Terminal |
| 2058 | Transaction type and Authorization are different |
| 2059 | ICC data related error |
| 2060 | TransactionID in additional data is different from parent transaction |
| 2061 | Information missing for Airline Data transaction |
| 2062 | Wrong format of Airline Data transaction |
| 2063 | Duplicate additional data |
| 2064 | Refund volume exceeds allowed limit |
| 2065 | Refunds not allowed for this terminal |
| 2066 | Refund above allowed percentage |
| 2067 | Original Credit exceeds allowed amount |
| 2068 | Original Credit not allowed for this terminal |
| 2069 | Original Credit exceeds merchant balance |
| 2070 | Original Credit prohibited, no valid sale found |
| 2071 | Transaction amount below allowed threshold |
| 2072 | DCC not allowed for this merchant agreement |
| 2073 | DCC markup rate is 0 |
| 2074 | DCC exchange rate is 0 |
| 2075 | Transaction rejected due to batch error |
| 2076 | Authorization code contains embedded spaces |
| 2077 | Authorization data does not match clearing data |
| 2080 | Invalid MCC Code |
| 2090 | Invalid Currency for Merchant Agreement |
| 2091 | Card type and card number don't match |
| 2093 | Invalid Card Type |
| 2094 | Invalid Currency code for Multicurrency Agreement |
| 2100 | Sale has already received a chargeback |
| 2101 | Refund volume exceeds sale volume for terminal |
| 2102 | Refund failed fraud check. Refund amount above limit |
| 2103 | Refund declined |
| 2200 | Fraud check failed |
| 2201 | Fraud check failed |
| 2210 | Fraud check failed |
| 2211 | Fraud check failed |
| 2212 | Fraud check failed |
| 2250 | Unsupported currency code in batch header |
| 2251 | Unsupported currency code in transaction |
| 2252 | Unsupported cardnumber in transaction |
| 9*** | Internal issue |
Please note
This is not an exhaustive list and more may be added later.