Mastercard · Schema
Mastercard Transaction
A financial transaction record processed through the Mastercard network, capturing the full lifecycle from authorization through settlement. Used across fraud detection, analytics, and reconciliation services.
Credit CardsDigital IdentityFinancial ServicesFraud DetectionOpen BankingPayments
Properties
| Name | Type | Description |
|---|---|---|
| transactionId | string | Unique identifier for the transaction, generated using UUID logic. |
| transactionIdentifiers | array | One or more identifiers used to locate the transaction in the Mastercard Data Warehouse. |
| cardNumber | string | Primary Account Number (PAN) used in the transaction. Must pass Luhn algorithm validation. |
| cardProductCode | string | Three-character code identifying the type of card used in the transaction (e.g., MSI for Mastercard Standard, MWE for World Elite). |
| transactionAmount | string | Transaction amount at the merchant location without decimal separators. Implied decimals depend on the currency. |
| transactionCurrencyCode | string | ISO 4217 numeric currency code for the transaction amount. |
| billingAmount | string | Amount appearing on the cardholder statement in the cardholder billing currency, without decimals. |
| billingCurrencyCode | string | ISO 4217 numeric currency code for the billing amount. |
| transactionDate | string | Local date at the merchant location when the transaction occurred, in YYYYMMDD format. |
| transactionTime | string | Local time at the merchant location when the transaction occurred, in HHmmss format. |
| settlementDate | string | Date the transaction was settled, in YYYYMMDD format. |
| timestamp | string | Timestamp of the request initiation in ISO 8601 format with CST timezone offset. |
| icaNumber | string | Interbank Card Association (ICA) number of the issuer or acquirer initiating the request. |
| acquirerId | string | ICA number of the acquiring institution for the transaction. |
| merchantId | string | Card acceptor or merchant unique identification number assigned by the acquirer. |
| merchantName | string | Name of the card acceptor. |
| merchantCity | string | City in which the merchant is located. |
| merchantStateProvinceCode | string | State or province code where the merchant is located. |
| merchantCountryCode | string | ISO 3166-1 alpha-3 country code where the merchant is located. |
| merchantPostalCode | string | Postal code at the merchant location. |
| merchantCategoryCode | string | Four-digit ISO 18245 Merchant Category Code (MCC) classifying the merchant business type. |
| terminalId | string | Unique code identifying a terminal at the card acceptor location. |
| terminalAttendanceIndicator | string | Indicates if the card acceptor was attending the terminal at the time of the transaction. |
| terminalOperatingEnvironment | string | Indicates whether the terminal is attended and its location environment. |
| terminalCapabilityIndicator | string | Indicates the capability of the terminal to read card data. |
| posEntryMode | string | Point of service entry mode indicating how the card number and expiration date were captured. |
| accountDeviceType | string | Indicates if the account uses magnetic stripe, chip, PIN, contactless, or combinations thereof. |
| cardholderPresenceIndicator | string | Indicates whether the cardholder was present at the point of transaction. |
| cardPresenceIndicator | string | Indicates whether the card was present at the point of transaction. |
| catLevelIndicator | string | Cardholder Activated Terminal (CAT) level indicator showing the type of automated terminal. |
| cvcInvalidIndicator | string | Indicates whether the Card Verification Code (CVC) was invalid. |
| avsResponseCode | string | Address Verification Service (AVS) response code from the authorization request. |
| authResponseCode | string | Authorization response code indicating the result of the authorization request. |
| network | string | Payment network through which the transaction was processed. |
| refId | string | Reference identifier generated by the originator to link request and response messages. |
| memo | string | Brief description by the originator providing context for the transaction. |