The clearing report can be used to review all card purchase clearings for a given period.
| Field | Description |
|---|---|
| cardToken | Unique identifier of the card. |
| transactionId | Unique identifier of the associated card transaction. |
| authorizationId | Unique identifier of the original authorization request received via the card scheme network. |
| transactionType | ISO 8583 message class. This is a messaging standard for payments initiated with a card. |
| merchantCurrency | Local currency of the country where the transaction was processed. |
| merchantAmount | Amount of the transaction, in minor units of the local currency. |
| billingCurrency | Currency of the card holder's account balance. |
| billingAmount | Amount of the transaction, in minor units of the billing currency. |
| settlementCurrency | Currency the card issuer selects to be paid in. |
| settlementAmount | Amount to be settled, in minor units of the settlement currency. This amount may include fees. |
| exchangeRate | Exchange rate applied between the merchant amount and the billing amount. |
| accountId | Unique identifier of the account which the card belongs to. |
| merchantId | Unique identifier of the merchant. |
| merchantName | Name of the merchant. |
| merchantCity | City of the merchant. |
| merchantCountry | Country of the merchant. |
| createdAt | When the transaction was created, expressed in UNIX epoch time. |
| approvedAt | When the transaction was approved, expressed in UNIX epoch time. |
| mcc | Four-digit number listed in ISO 18245. Used to classify a business by the types of goods or services it provides. |
| channel | Channel used to initialize the transaction. Examples include ATM, and Online. |
Example
169286b_clearing_2023-04-18T00:00:00.000Z_2023-04-18T00:00:00.000Z.csv
card_token,transaction_id,authorization_id,transaction_type,merchant_currency,merchant_amount,billing_currency,billing_amount,settlement_currency,settlement_amount,exchange_rate,account_id,merchant_id,merchant_name,merchant_city,merchant_country,creation_at,approved_at,mcc,channel
789f7719eab12100789653487c136165,1000000324137,1000000324138,1200,USD,500,USD,500,USDC,6000000,1.0000000000,e64aa69f0a9af2d664e5989bd7f22562,000000000000000,Family Clothing Store,Auckland,NZL,2023-04-18T01:08:06.435Z,2023-04-18T01:08:09.144Z,5651,Online