Presentments (Deprecated)
Deprecation NoticeThis page will be deprecated on September 1st, 2025. Please refer to the new documentation Presentments (Updated)
The Presentments report contains data received in presentment and clearing records correlating originating authorizations and matched transactions.
This page specifies the general data fields of a Presentments report and drills down further into the specific scheme versions and their data fields, including:
All versions use the same formatting and naming convention:
Format: CSV
File name: [ClientName_Presentments_YYYYMMDD].csv or [ClientName_Presentments_YYYYMMDD_to_YYYYMMDD].csv
Frequency: Daily
Stored in: Client-hosted SFTP folder
Product applicability: Local Store of Value: Prepaid/Debit, Credit Remote Store of Value: Prepaid/Debit, Credit
General data fields
The table below specifies the general data included in a presentment report and can be used to help you interpret the data in the report:
Field Name | Description | Example | Format |
|---|---|---|---|
PY__RID_Settlement | Unique ID for settlement transaction | 12345 | Numeric |
PY__RID_Authorization | Unique ID for authorisation transaction (this may have value 0 if no Authorisation involved in the transaction) | 4321 | Numeric |
PY__Account_ID | Account identifier | 21234 | Numeric |
PY__Token | Public token generated by Paymentology to replace PAN | 33344 | Numeric |
PY__Account_External_Reference | Unique file ID assigned by Paymentology | 389-12 | Numeric |
PY__File_ID | Unique file ID assigned by Paymentology | 12300 | Numeric |
PY__Transaction_ID | Transaction thread ID created and maintained by Paymentology. Large integer, incremental | 22001 | Numeric |
PY__Network | Indicates the Network provider. M = Mastercard | M | Alphabetic |
PY__MTID | MTID code (Message Transaction Identifier) | 1240 | Numeric |
PY__Created_Date | Indicates the time at which Paymentology processed the file | 2023/01/16 01:07 | Date: |
PY__Matched_Status | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have a value ranging from 1 to 9. 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform. | 1 | Numeric |
PY__Is_Debit | This field determines the direction of funds flow of the original transaction, -1 = debit, +1 = credit, 0 = record with no financial movement (balance enquiry, no fees). | -1 | Numeric |
PY__Product_ID | Product identifier | 234 | Numeric |
PY__Product_Name | Product name | Plastic Card | Alphabetic |
PY__Settlement_Note | Position for Paymentology to assign notes that may be of relevance to the client, relating to the presentment. Provisional field, reserved for future use | match (1) on tok+de38 | Alphanumeric |
DE3_1__Cardholder_Transaction_Type | Processing Code, describes the effect of a transaction on a customer account and the type of accounts affected. Position 1-2 = Cardholder transaction type (numeric), Example, code = XX. Note: the processing codes of MC and MADA do not coincide 100% and the lists of processing codes have some differences. | 0 | Numeric |
DE3_2__Cardholder_from_Account_Type_Code | Position 3-4 = Cardholder ‘from’ Account type | 0 | Numeric |
DE3_3__Cardholder_To_Account_Type_Code | Position 5-6 = Cardholder ‘to’ Account type | 0 | Numeric |
DE4__Transaction_Amount | Local amount with the sign, indicating the net direction of funds flow. Currency provided in DE49 | 711.23 | Numeric - decimal |
DE5__Reconciliation_Amount | Settlement amount with the sign, indicating the net direction of funds flow. Currency provided in DE50 | 711.23 | Numeric - decimal |
DE6__Billing_Amount | Cardholder Billing amount with the sign, indicating the net direction of funds flow. Currency provided in DE51 | 711.23 | Numeric - decimal |
DE9__Conversion_Rate_Reconciliation | if DE5 is present, else 0 | 0 | Numeric |
DE10__Conversion_Rate_Billing | Conversion rate to Cardholder billing currency. Digit 1 on the left indicates the position of the decimal place. | 1 | Numeric |
DE12__Transaction_Date_Time | Date/time of local original spend. MC frequently provide 00:00:00 as time element | 2023/01/15 | Datetime: |
DE17__Capture_Date | Date/time of capturing transaction from device/virtual device and including Clearing file. Note: The Authorization Platform currently does not use this data element. In IPM Clearing format this field is not defined | 2023/01/15 | Datetime: |
DE22_6__Card_Present_Data | Card Present data | 1 | Numeric |
DE22_7__Card_Data_Input_Mode | Card Present data | M | Alphabetic |
DE22_8__Cardholder_Authentication_Method | Cardholder Authentication Method | 0 | Numeric |
DE23__Card_Sequence_Number | Card Sequence Number. Note: this parameter is empty now | 1 | Numeric |
DE24__Function_Code | Function Code. Is present for some operation types. Is absent for DE3_1=10 + MCC6011 | 200 | Numeric |
DE25__Message_Reason_Code | Message Reason Code. Is present for some operation types. Is absent for DE3_1=10 + MCC6011 | 1401 | Numeric |
DE26__Merchant_Category_Code | MCC Merchant Category Codes | 1234 | Numeric |
DE30_1__Original_Amount_Transaction | DE 30 (Amounts, original) contains the “amount” data element values from the First Presentment or Fee Collection (DE4). Used for chargeback or retrieval requests. | 200.00 | Numeric - decimal |
DE30_2__Original_Amount_Reconciliation | DE 30 (Amounts, reconciliation) Mastercard populate this with all zeros. | 200.0000 | Numeric - decimal |
DE31__Acquirer_Reference_Data | Acquirer Reference Data (See MC IPM Clearing Formats document) | 5,444888 | Numeric |
DE32__Acquiring_Institution_ID_Code | Acquirer Member ID | 1234 | Numeric |
DE33__Forwarding_Institution_ID_Code | Forwarding Institution Code | 1122 | Numeric |
DE37__Retrieval_Reference_Number | Retrieval_Reference_Number | 100020 | Numeric |
DE38__Approval_Code | Approval Code (the code that goes on customer receipt, Paymentology generated) | 123456 | Numeric |
DE40__Service_Code | Service Code | 54321 | Numeric |
DE41__Card_Acceptor_Terminal_ID | Card Acceptor Terminal Identification | 6012 | Numeric |
DE42__Card_Acceptor_ID_Code | Card Acceptor ID Code | 58000 | Numeric |
DE43_1__Card_Acceptor_Name | Card acceptor name (22 long) | cosmetic store1 | Alphanumeric |
DE43_2__Card_Acceptor_Street_Address | Card Acceptor Street address (48 long) | 123 street address | Alphanumeric |
DE43_3__Card_Acceptor_City | Card Acceptor City (13 long) | Bangkok | Alphabetic |
DE43_4__Card_Acceptor_Zip_Code | Post/zip code (10 long) | 10110 | Alphanumeric |
DE43_5__Card_Acceptor_State_Code | State or province (3 long) | THA | Alphabetic |
DE43_6__Card_Acceptor_Country_Code | Country Code (3 long) | THA | Alphabetic |
DE48_0002__GCMS_Product_Identifier | GCMS Product Identifier, e.g. MRW is Prepaid Mastercard Business Card (Non-U.S.) | ABC | Alphabetic |
DE48_0003__Licensed_Product_Identifier | Licensed Product Identifier | ABC | Alphabetic |
DE48_0023__Terminal_Type | Terminal Type, identifies the type of terminal used at the point of interaction | XYZ | Alphabetic |
DE48_0025_1__Message_Reversal_Indicator | Reversal Indicator. | 1 | Numeric |
DE48_0105__Network_File_Reference | PDS 0105 value. Network File Reference | 1,2304 | Numeric |
DE48_0158_1__Card_Program_Identifier | Card Program Identifier | DMC | Alphabetic |
DE48_0158_2__Business_Service_Arrangement_Type_Code | Business Service Arrangement Type Code | 2 | Numeric |
DE48_0158_3__Business_Service_ID_Code | Business ServiceID Code | 10002 | Numeric |
DE48_0158_4__Interchange_Rate_Designaor | Interchange Rate Designator | YF | Alphanumeric |
DE48_0158_5__Central_Site_Business_Date | Central Site Business Date | 2023/01/16 | Date: |
DE48_0158_6__Business_Cycle | Business Cycle | 1 | Numeric |
DE48_0158_7__Card_Acceptor_Classification_Override_Indicator | Card Acceptor Classification Override Indicator, with appropriate values to indicate whether Card Acceptor Business Code (MCC) override rates, Card Acceptor Business (CAB) Type override rates, or neither, were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | 2 | Numeric |
DE48_0158_8__Product_Class_Override_Indicator | Product Class Override Indicator, indicate whether product class override interchange rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | ||
DE48_0158_9__Corporate_Incentive_Rates_Apply_Indicator | Corporate Incentive Rates Apply Indicator, with a value of 1, 2, N or V to indicate whether no (N), first-level (1), second-level (2), or V (VAT) corporate incentive rates were used in the interchange fee amount designated in PDS 0146 (Amounts, Transaction Fee). | N | Alphabetic |
DE48_0158_10__Special_Conditions_Indicator | Special Conditions Indicator, with a value to indicate whether an adjustment was included in the Fee amount | N | Alphabetic |
DE48_0158_11__MC_Assigned_ID_Override_Indicator | Mastercard Assigned ID Override Indicator, with a value of Y or N to indicate whether override rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | N | Alphabetic |
DE48_0158_12__Account_Level_Management_Account_Category_Code | Account Level Management Account Category Code, indicates whether the account associated with the transaction (stored on DE 2 is participating in one or several Account Level Management programs where an incremental interchange is included in the transaction’s interchange amount. N = default. | ||
DE48_0158_13__Rate_Indicator | Rate Indicator indicates the rate applied by GCMS to the transaction, e.g. N = Non-regulated | ||
DE48_0158_14__Masterpass_Incentive_Indicator | Masterpass Incentive Indicator populated by GCMS and identifies the transaction as having received the Masterpass-Enabled Merchant Incentive. Yes or No | ||
DE48_159_3__Settlement_Service_Level_Code | Settlement Service Level Code) is a one-digit code that identifies the settlement level of the settlement service, e.g. 1 = regional | 1 | Numeric |
DE48_159_6__Reconciliation_Date | PDS 0159_6 value, Reconciliation Date | 2023/01/16 | Date: |
DE48_159_7__Reconciliation_Cycle | PDS 0159_7 value, Reconciliation Cycle | 1 | Numeric |
DE48_159_8__Settlement_Date | Settlement Date | 2023/01/16 | Date: |
DE48_159_9__Settlement_Cycle | Settlement Cycle | 1 | Numeric |
DE48_0177_1__Cross_Border_Indicator | Cross-border Indicator, identifies whether the transaction qualified as a cross-border transaction and could be subject to Cross-border transaction pricing guidelines. Yes or No | Y | Alphabetic |
DE48_0177_2__Currency_Indicator | Currency Indicator identifies whether the transaction was submitted to Mastercard in the local currency of the merchant. Y= local currency, N = not submitted, blank = not relevant | ||
DE49__Currency_Code_Transaction | Currency of transaction (local currency) | ||
DE50__Currency_Code_Reconciliation | Currency of reconciliation/Settlement | 862 | Numeric |
DE51__Currency_Code_Billing | Currency of Cardholder Billing | 862 | Numeric |
DE54_2__Additional_Amount_Type | Additional Amount, Amount Type | 58 | Numeric |
DE54_3__Additional_Amount_Currency_Code | Currency | 764 | Numeric |
DE54_4__Additional_Amount_Sign | Sign | D | Alphabetic |
DE54_5__Additional_Amount | Additional Amount | 8120 | Numeric |
DE63__Transaction_Life_Cycle_ID | Transaction Life Cycle ID | ABCDEF | Alphanumeric |
DE71__Message_Number | Message Number – identifies the message within the T112 Mastercard file. | 50 | Numeric |
DE72__Data_Record | Used in Fee type messages to provide a description of the fee. | ||
DE73__Action_Date | In Fee Collection messages, this data element identifies a reference date related to the Fee | 2023/01/16 | Date: |
DE93__Transaction_Destination_Institution_ID | Transaction Destination Institution ID Code | 5678 | Numeric |
DE94__Transaction_Originator_Institution_ID | Transaction Originator Institution ID identifies the transaction originator institution. | 1234 | Numeric |
DE97__Net_Reconciliation_Amount | "Net Reconciliation Amount. The format is X+N 16. In the Extract File, the X portion is ""-"" if the calculated amount is negative, otherwise ""0""." | 234.56 | Numeric - decimal |
DE100__Receiving_Institution_ID | Receiving Member ID (Paymentology processor id) | 321 | Numeric |
DE111__Amount_Currency_Conversion_Assessment | The amount based on the result of Applying the multi-currency conversion rate (Currency Conversion Assessment) adjustment to the currency conversion rate used to convert DE 4 (Amount, Transaction) to DE 6 (Amount, Cardholder Billing) for qualified transactions. | ||
DE122__Card_Scheme_Sponser_ID | The Card Scheme Sponsor Identifier, assigned by MADA, is a unique identifier for the financial institution. It contains the identifier of the Card Scheme Acquirer Bank, which agrees to settle a Bank Card Scheme's transactions. | 456 | Numeric |
DE124__POS_Terminal_Reconcile_Total | The MADA POS Terminal Reconcile Total is used to carry terminal transaction activity. The transaction details are calculated by the terminal for each card scheme accepted at that terminal. | 600.00 | Numeric - decimal |
DE127__POS_Host_Reconcile_Total | The MADA POS Host Reconcile Total is used to carry terminal transaction activity. The transaction details are calculated by the MADA host for each card scheme accepted at that terminal. | 600.00 | Numeric - decimal |
Merchant_Reference_ID | Order Identifier: Merchant allocated unique Order Identifier used as a merchant reference for inquiry and tracking. | 1234 | Numeric |
Gateway_ID | Primary & Secondary Gateway Identifier | ||
COF_Data | Card On File (COF) Transaction Context. This sub-element is mandatory for all COF transactions and when present, it indicates the COF transaction use-case and relation type. | ||
Payment_Transaction_Number | "SADAD Payment Transaction Number - Unique transaction number identifier for each payment at SADAD, it is generated by SADAD System" | ||
Biller_ID | To be used to identify the specific biller in accordance with ongoing billers supported by SADAD. | 111 | Numeric |
Bill_ID | Unique bill identification number for the specified biller. | 222 | Numeric |
Payment_Status | "Payment Status. Valid values are: ‘Adviced’ – For transactions that are approved by the Issuer, ‘Validated’ – For transactions that are declined by the Issuer, “Reversed’ – For reversal transactions. Note: Issuers will only receive this Tag field for reversals." | Reversed | Alphabetic |
Bill_Payment_Amount_Due | Bill Payment Amount Due. Includes the decimal as the last 2 digits. | 231.00 | Numeric - decimal |
Alignment to other reports
PY\_\_RID_Authorizationis the same as therid_authorizationfield found in the Authorizations report and thePY\_\_RID_Authorizationfield found in the Interchange report. You can use these fields to match transaction message records.PY\_\_Tokenis the same as thecard_number_proxyfield found in the Authorizations report, thePY\_\_Tokenfield found in the Interchange and Fees reports, theCardfield found in the Chargebacks report and theTokenfield found in the Program fees report.PY\_\_Transaction_IDis the same as thetransaction\_idfield found in the Authorizations report, thePY\_\_Transaction\_IDfield found in the Interchange and Fees reports and theTransaction_IDfield found in the Program fees report. You can use these fields to match transaction threads.PY\_\_RID_Settlementis the same as thePY\_\_RID_Settlementfield found in the Interchange, Fees and Program fees reports.
Alignment to FAST messages
PY\_\_RID_Authorizationis the same as theRIDfield found in FAST authorization messages and theADD_REF_RIDfield found in FAST V3 clearing and settlement messages. You can use these fields to match transaction message records.PY\_\_Tokenis the same as the"DE2"field found in FAST authorization messages and the"2"(Mastercard) or"Account Number"(Visa) field found in both FAST authorization and FAST V3 clearing and settlement messages.PY\_\_Transaction_IDis the same as the"TID"field found in both FAST authorization messages and FAST V3 clearing and settlement messages. You can use these fields to match transaction threads.PY\_\_RID_Settlementis the sameRIDfield found in FAST V3 clearing and settlement messages.
Mastercard
This section specifies the format of a Presentment report when the scheme is Mastercard. The Mastercard Presentment report is currently running v1.0 and v2.0. If you're using Mastercard, check which version you're using.
All new clients should integrate with the latest report version
Mastercard v1.0
ImportantThis report version (Mastercard v1.0) will be discontinued by 1st November 2025.
You can refer to our Migration guidelines for helpful information on how you can upgrade from v1.0 to v2.0.
Official communication was sent to you on/around 1st November 2024.
Below are the data fields and format of the Mastercard v1.0 Presentments report.
Click to view the complete list of fields
Field Name | Description | Example | Format |
|---|---|---|---|
PY__RID_Settlement | Unique ID for settlement transaction | 13050 | Numeric |
PY__RID_Authorization | Unique ID for authorisation transaction (this may have value 0 if no Authorisation is involved in the transaction) | 10532 | Numeric |
PY__Account_ID | Account identifier | 272123 | Numeric |
PY__Token | Public token generated by Paymentology to replace PAN | 555444333 | Numeric |
PY__Account_External_Reference | Additional account external reference details | 9876543 | Numeric |
PY__File_ID | Unique file ID assigned by Paymentology | 987 | Numeric |
PY__Transaction_ID | Transaction thread ID created and maintained by Paymentology | 843210 | Numeric |
PY__Network | Indicates the Network provider. M = Mastercard | M | Alphabetic |
PY__MTID | MTID code | 1240 | Numeric |
PY__Created_Date | Indicates the time at which Paymentology processed the file. Format: YYYY-MM-DD HH:mm:ss | 2023-07-08 | Date: |
PY__Matched_Status | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have a value ranging from 1 to 9. 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform . | 1 | Numeric |
PY__Is_Debit | This field determines the direction of funds flow of the original transaction, -1 = debit, +1 = credit, 0 = record with no financial movement (balance enquiry, no fees). | 1 | Numeric |
PY__Product_ID | Product identifier | 123 | Numeric |
PY__Product_Name | Product name | CardOne | Alphabetic |
PY__Settlement_Note | Position for Paymentology to assign notes that may be of relevance to the client, relating to the presentment. Provisional field, reserved for future use | match on | Alphanumeric |
DE3_1__Cardholder_Transaction_Type | Processing Code, describes the effect of a transaction on a customer account and the type of accounts affected. | 20 | Numeric |
DE3_2__Cardholder_from_Account_Type_Code | Position 3-4 = Cardholder ‘from’ Account type | 10 | Numeric |
DE3_3__Cardholder_To_Account_Type_Code | Position 5-6 = Cardholder ‘to’ Account type | 0 | Numeric |
DE4__Transaction_Amount | Local amount with the sign, indicating the net direction of funds flow. Currency provided in DE49 | 301.8 | Numeric - |
DE5__Reconciliation_Amount | Settlement amount with the sign, indicating the net direction of funds flow. Currency provided in DE50 | 800.08 | Numeric - decimal |
DE6__Billing_Amount | Cardholder Billing amount with the sign, indicating the net direction of funds flow. Currency provided in DE51 | 301.8 | Numeric - decimal |
DE9__Conversion_Rate_Reconciliation | Conversion rate to Reconciliation/Settlement currency. Digit 1 on the left indicates the position of the decimal place. | 2.651027 | Numeric - decimal |
DE10__Conversion_Rate_Billing | Conversion rate to Cardholder billing currency. Digit 1 on the left indicates the position of the decimal place. | 1.1142 | Numeric - decimal |
DE12__Transaction_Date_Time | Date/time of local original spend. MC frequently provide 00:00:00 as time element. Format: YYYY-MM-DD HH:mm:ss | 2023-09-23 | Datetime: |
DE22_6__Card_Present_Data | Card Present data | 1 | Numeric |
DE22_7__Card_Data_Input_Mode | Card Data Input Mode | S,M,C | Alphabetic |
DE23__Card_Sequence_Number | Card Sequence Number | 0 | Numeric |
DE24__Function_Code | Function Code | 200 | Numeric |
DE25__Message_Reason_Code | Mastercard Message Reason code | 1401 | Numeric |
DE26__Merchant_Category_Code | MCC Merchant Category Codes | 3040 | Numeric |
DE30_1__Original_Amount_Transaction | DE 30 (Amounts, original) contains the “amount” data element values from the First Presentment or Fee Collection (DE4). Used for chargeback or retrieval request. | 0 | Numeric |
DE30_2__Original_Amount_Reconciliation | DE 30 (Amounts, reconciliation) Mastercard populate this with all zeros. | 0 | Numeric |
DE31__Acquirer_Reference_Data | Acquirer Reference Data (See MC IPM Clearing Formats document) | 54321222 | Numeric |
DE32__Acquiring_Institution_ID_Code | Acquirer Member ID | 4470 | Numeric |
DE33__Forwarding_Institution_ID_Code | Forwarding Institution Code | 4481 | Numeric |
DE37__Retrieval_Reference_Number | Retrieval Reference Number (RRN) | 901321 | Numeric |
DE38__Approval_Code | Approval Code (the code that goes on customer receipt, Paymentology generated) | 190654 | Numeric |
DE40__Service_Code | Service Code | 0 | Numeric |
DE41__Card_Acceptor_Terminal_ID | Card Acceptor Terminal Identification | 4055 | Numeric |
DE42__Card_Acceptor_ID_Code | Card Acceptor ID Code | 300-9876 | Numeric |
DE43_1__Card_Acceptor_Name | Card acceptor name (22 long) | GULF AIR | Alphanumeric |
DE43_2__Card_Acceptor_Street_Address | Card Acceptor Street address (48 long) | P.O. Box | Alphanumeric |
DE43_3__Card_Acceptor_City | Card Acceptor City (13 long) | Bahrain | Alphabetic |
DE43_4__Card_Acceptor_Zip_Code | Post/zip code (10 long) | W127GE | Alphanumeric |
DE43_5__Card_Acceptor_State_Code | State or province (3 long) | BHR | Alphabetic |
DE43_6__Card_Acceptor_Country_Code | Country Code (3 long) | BHR | Alphabetic |
DE48_0002__GCMS_Product_Identifier | GCMS Product Identifier, e.g. MRW is Prepaid Mastercard Business Card (Non-U.S.) | MRW | Alphabetic |
DE48_0003__Licensed_Product_Identifier | Licensed Product Identifier | MRW | Alphabetic |
DE48_0023__Terminal_Type | Terminal Type, identifies the type of terminal used at the point of interaction | MAN | Alphabetic |
DE48_0025_1__Message_Reversal_Indicator | Message Reversal Indicator. | 1 | Numeric |
DE48_0105__Network_File_Reference | Network_File_Reference | 1230321 | Numeric |
DE48_0158_1__Card_Program_Identifier | Card Program Identifier, e.g. MCC = Mastercard Credit | MCC | Alphabetic |
DE48_0158_2__Business_Service_Arrangement_Type_Code | Business Service Arrangement Type Code) is a one position numeric value that identifies the business relationship between the transaction’s participants. E.g. 2 = Intraregional | 2 | Numeric |
DE48_0158_3__Business_Service_ID_Code | Business Service ID Code) is a six-position value that identifies the business service to which the transaction is assigned for reconciliation and rules basis. | 60001 | Numeric |
DE48_0158_4__Interchange_Rate_Designaor | Interchange Rate Designator, is a two-position code that indicates the interchange rate and editing rules applied to the transaction. | 61 | Numeric |
DE48_0158_5__Central_Site_Business_Date | Central Site Business Date, identifies the official business processing date when the business service reconciles a transaction. | 24/09/2023 | Date: |
DE48_0158_6__Business_Cycle | Business Cycle, is a two-digit numeric subfield (such as 01, 02, or 03) that identifies a reconciliation period in a Business Date. | 2 | Numeric |
DE48_0158_7__Card_Acceptor_Classification_Override_Indicator | Card Acceptor Classification Override Indicator, with appropriate values to indicate whether Card Acceptor Business Code (MCC) override rates, Card Acceptor Business (CAB) Type override rates, or neither, were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | 0 | Numeric |
DE48_0158_8__Product_Class_Override_Indicator | Product Class Override Indicator, indicate whether product class override interchange rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | 0 | Numeric |
DE48_0158_9__Corporate_Incentive_Rates_Apply_Indicator | Corporate Incentive Rates Apply Indicator, with a value of 1, 2, N or V to indicate whether no (N), first-level (1), second-level (2), or V (VAT) corporate incentive rates were used in the interchange fee amount designated in PDS 0146 (Amounts, Transaction Fee). | N | Alphabetic |
DE48_0158_10__Special_Conditions_Indicator | Special Conditions Indicator, with a value to indicate whether an adjustment was included in the Fee amount | N | Alphabetic |
DE48_0158_11__MC_Assigned_ID_Override_Indicator | Mastercard Assigned ID Override Indicator, with a value of Y or N to indicate whether override rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | N | Alphabetic |
DE48_0158_12__Account_Level_Management_Account_Category_Code | Account Level Management Account Category Code, indicates whether the account associated with the transaction (stored on DE 2 is participating in one or several Account Level Management programs where an incremental interchange is included in the transaction’s interchange amount. N = default. | N | Alphabetic |
DE48_0158_13__Rate_Indicator | Rate Indicator indicates the rate applied by GCMS to the transaction, e.g. N = Non-regulated | N | Alphabetic |
DE48_0158_14__Masterpass_Incentive_Indicator | Masterpass Incentive Indicator, is populated by GCMS and identifies the transaction as having received the Masterpass-Enabled Merchant Incentive. Yes or No | N | Alphabetic |
DE48_159_3__Settlement_Service_Level_Code | Settlement Service Level Code) is a one-digit code that identifies the settlement level of the settlement service, e.g. 1 = regional | 1 | Numeric |
DE48_159_6__Reconciliation_Date | Reconciliation Date. Format: YYYY-MM-DD | 2023-09-23 | Date: |
DE48_159_7__Reconciliation_Cycle | Reconciliation Cycle | 2 | Numeric |
DE48_159_8__Settlement_Date | Settlement Date. Format: YYYY-MM-DD | 2023-09-23 | Date: |
DE48_159_9__Settlement_Cycle | Settlement Cycle | 2 | Numeric |
DE48_0177_1__Cross_Border_Indicator | Cross-border Indicator, identifies whether the transaction qualified as a Crossborder transaction and could be subject to Cross-border transaction pricing guidelines. Yes or No | N | Alphabetic |
DE48_0177_2__Currency_Indicator | Currency Indicator, identifies whether the transaction was submitted to Mastercard in the local currency of the merchant. Y= local currency, N = not submitted, blank = not relevant | 0 | Numeric |
DE49__Currency_Code_Transaction | Currency of transaction (local currency) | 48 | Numeric |
DE50__Currency_Code_Reconciliation | Currency of reconciliation/Settlement | 840 | Numeric |
DE51__Currency_Code_Billing | Currency of Cardholder Billing | 48 | Numeric |
DE54_2__Additional_Amount_Type | Other Amounts – e.g. cashback portions in cash back transactions. Surcharges also appear here. | 0 | Numeric |
DE54_3__Additional_Amount_Currency_Code | Indicates currency of the Surcharge amount | 48 | Numeric |
DE54_4__Additional_Amount_Sign | Additional Amount Sign (D for debit and C for Credit) | D | Alphabetic |
DE54_5__Additional_Amount | Other Amounts – e.g. cashback portions in cash back transactions. Surcharges also appear here. DE54_5 is amount, DE54_4 is amount sign | 0 | Numeric |
DE63__Transaction_Life_Cycle_ID | Transaction Life Cycle ID | MNO1P2QRS0123 | Alphanumeric |
DE71__Message_Number | Message Number – identifies the message within the T112 Mastercard file. | 54 | Numeric |
DE72__Data_Record | Used in Fee type messages to provide description of the fee. | Late Payment Penalty | Alphabetic |
DE73__Action_Date | In Fee Collection messages, this data element identifies a reference date related to the Fee. Format: YYYY-MM-DD | 2023-09-23 | Date: |
DE94__Transaction_Originator_Institution_ID | Transaction Originator Institution ID, identifies the transaction originator institution. | 10456 | Numeric |
DE100__Receiving_Institution_ID | Receiving Member ID (Paymentology processor id) | 12345 | Numeric |
DE111__Amount_Currency_Conversion_Assessment | The amount based on the result of Applying the multi-currency conversion rate (Currency Conversion Assessment) adjustment to the currency conversion rate used to convert DE 4 (Amount, Transaction) to DE 6 (Amount, Cardholder Billing) for qualified transactions. | 0 | Numeric |
Mastercard v2.0
Notable changesBelow are the notable differences between v1.0 and v2.0:
- Addition of a new field
PY__Transaction_Type
Below are the data fields and format of the Mastercard v2.0 Presentment report.
Field Name | Description | Example | Format |
|---|---|---|---|
PY__RID_Settlement | Unique ID for settlement transaction | 13050 | Numeric |
PY__RID_Authorization | Unique ID for authorisation transaction (this may have value 0 if no Authorisation is involved in the transaction) | 10532 | Numeric |
PY__Account_ID | Account identifier | 272123 | Numeric |
PY__Token | Public token generated by Paymentology to replace PAN | 555444333 | Numeric |
PY__Account_External_Reference | Additional account external reference details | 9876543 | Numeric |
PY__File_ID | Unique file ID assigned by Paymentology | 987 | Numeric |
PY__Transaction_ID | Transaction thread ID created and maintained by Paymentology | 843210 | Numeric |
PY__Transaction_Type | Identifies the type of transaction. | ECOM | Alphabetic |
PY__Network | Indicates the Network provider. M = Mastercard | M | Alphabetic |
PY__MTID | MTID code | 1240 | Numeric |
PY__Created_Date | Indicates the time at which Paymentology processed the file. Format: YYYY-MM-DD HH:mm:ss | 2023-07-08 | Date: |
PY__Matched_Status | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have a value ranging from 1 to 9. 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform . | 1 | Numeric |
PY__Is_Debit | This field determines the direction of funds flow of the original transaction, -1 = debit, +1 = credit, 0 = record with no financial movement (balance enquiry, no fees). | 1 | Numeric |
PY__Product_ID | Product identifier | 123 | Numeric |
PY__Product_Name | Product name | CardOne | Alphabetic |
PY__Settlement_Note | Position for Paymentology to assign notes that may be of relevance to the client, relating to the presentment. Provisional field, reserved for future use | match on | Alphanumeric |
DE3_1__Cardholder_Transaction_Type | Processing Code, describes the effect of a transaction on a customer account and the type of accounts affected. | 20 | Numeric |
DE3_2__Cardholder_from_Account_Type_Code | Position 3-4 = Cardholder ‘from’ Account type | 10 | Numeric |
DE3_3__Cardholder_To_Account_Type_Code | Position 5-6 = Cardholder ‘to’ Account type | 0 | Numeric |
DE4__Transaction_Amount | Local amount with the sign, indicating the net direction of funds flow. Currency provided in DE49 | 301.8 | Numeric - |
DE5__Reconciliation_Amount | Settlement amount with the sign, indicating the net direction of funds flow. Currency provided in DE50 | 800.08 | Numeric - decimal |
DE6__Billing_Amount | Cardholder Billing amount with the sign, indicating the net direction of funds flow. Currency provided in DE51 | 301.8 | Numeric - decimal |
DE9__Conversion_Rate_Reconciliation | Conversion rate to Reconciliation/Settlement currency. | 2.651027 | Numeric - decimal |
DE10__Conversion_Rate_Billing | Conversion rate to Cardholder billing currency. | 1.1142 | Numeric - decimal |
DE12__Transaction_Date_Time | Date/time of local original spend. MC frequently provide 00:00:00 as time element. Format: YYYY-MM-DD HH:mm:ss | 2023-09-23 | Datetime: |
DE22_6__Card_Present_Data | Card Present data | 1 | Numeric |
DE22_7__Card_Data_Input_Mode | Card Data Input Mode | S,M,C | Alphabetic |
DE22_8__Cardholder_Authentication_Method | Indicates the method by which the cardholder’s identity was verified at the point of service | 0,1,2,5,6,9,S | Alphanumeric |
DE23__Card_Sequence_Number | Card Sequence Number | 0 | Numeric |
DE24__Function_Code | Function Code | 200 | Numeric |
DE25__Message_Reason_Code | Mastercard Message Reason code | 1401 | Numeric |
DE26__Merchant_Category_Code | MCC Merchant Category Codes | 3040 | Numeric |
DE30_1__Original_Amount_Transaction | DE 30 (Amounts, original) contains the “amount” data element values from the First Presentment or Fee Collection (DE4). Used for chargeback or retrieval request. | 0 | Numeric |
DE30_2__Original_Amount_Reconciliation | DE 30 (Amounts, reconciliation) Mastercard populate this with all zeros. | 0 | Numeric |
DE31__Acquirer_Reference_Data | Acquirer Reference Data (See MC IPM Clearing Formats document) | 54321222 | Numeric |
DE32__Acquiring_Institution_ID_Code | Acquirer Member ID | 4470 | Numeric |
DE33__Forwarding_Institution_ID_Code | Forwarding Institution Code | 4481 | Numeric |
DE37__Retrieval_Reference_Number | Retrieval Reference Number (RRN) | 901321 | Numeric |
DE38__Approval_Code | Approval Code (the code that goes on customer receipt, Paymentology generated) | 190654 | Numeric |
DE40__Service_Code | Service Code | 0 | Numeric |
DE41__Card_Acceptor_Terminal_ID | Card Acceptor Terminal Identification | 4055 | Numeric |
DE42__Card_Acceptor_ID_Code | Card Acceptor ID Code | 300-9876 | Numeric |
DE43_1__Card_Acceptor_Name | Card acceptor name (22 long) | GULF AIR | Alphanumeric |
DE43_2__Card_Acceptor_Street_Address | Card Acceptor Street address (48 long) | P.O. Box | Alphanumeric |
DE43_3__Card_Acceptor_City | Card Acceptor City (13 long) | Bahrain | Alphabetic |
DE43_4__Card_Acceptor_Zip_Code | Post/zip code (10 long) | W127GE | Alphanumeric |
DE43_5__Card_Acceptor_State_Code | State or province (3 long) | BHR | Alphabetic |
DE43_6__Card_Acceptor_Country_Code | Country Code (3 long) | BHR | Alphabetic |
DE48_0002__GCMS_Product_Identifier | GCMS Product Identifier, e.g. MRW is Prepaid Mastercard Business Card (Non-U.S.) | MRW | Alphabetic |
DE48_0003__Licensed_Product_Identifier | Licensed Product Identifier | MRW | Alphabetic |
DE48_0023__Terminal_Type | Terminal Type, identifies the type of terminal used at the point of interaction | MAN | Alphabetic |
DE48_0025_1__Message_Reversal_Indicator | Message Reversal Indicator. | 1 | Numeric |
DE48_0105__Network_File_Reference | Network_File_Reference | 1230321 | Numeric |
DE48_0158_1__Card_Program_Identifier | Card Program Identifier, e.g. MCC = Mastercard Credit | MCC | Alphabetic |
DE48_0158_2__Business_Service_Arrangement_Type_Code | Business Service Arrangement Type Code) is a one position numeric value that identifies the business relationship between the transaction’s participants. E.g. 2 = Intraregional | 2 | Numeric |
DE48_0158_3__Business_Service_ID_Code | Business Service ID Code) is a six-position value that identifies the business service to which the transaction is assigned for reconciliation and rules basis. | 60001 | Numeric |
DE48_0158_4__Interchange_Rate_Designaor | Interchange Rate Designator, is a two-position code that indicates the interchange rate and editing rules applied to the transaction. | 61 | Numeric |
DE48_0158_5__Central_Site_Business_Date | Central Site Business Date, identifies the official business processing date when the business service reconciles a transaction. | 24/09/2023 | Date: |
DE48_0158_6__Business_Cycle | Business Cycle, is a two-digit numeric subfield (such as 01, 02, or 03) that identifies a reconciliation period in a Business Date. | 2 | Numeric |
DE48_0158_7__Card_Acceptor_Classification_Override_Indicator | Card Acceptor Classification Override Indicator, with appropriate values to indicate whether Card Acceptor Business Code (MCC) override rates, Card Acceptor Business (CAB) Type override rates, or neither, were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | 0 | Numeric |
DE48_0158_8__Product_Class_Override_Indicator | Product Class Override Indicator, indicate whether product class override interchange rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | 0 | Numeric |
DE48_0158_9__Corporate_Incentive_Rates_Apply_Indicator | Corporate Incentive Rates Apply Indicator, with a value of 1, 2, N or V to indicate whether no (N), first-level (1), second-level (2), or V (VAT) corporate incentive rates were used in the interchange fee amount designated in PDS 0146 (Amounts, Transaction Fee). | N | Alphabetic |
DE48_0158_10__Special_Conditions_Indicator | Special Conditions Indicator, with a value to indicate whether an adjustment was included in the Fee amount | N | Alphabetic |
DE48_0158_11__MC_Assigned_ID_Override_Indicator | Mastercard Assigned ID Override Indicator, with a value of Y or N to indicate whether override rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | N | Alphabetic |
DE48_0158_12__Account_Level_Management_Account_Category_Code | Account Level Management Account Category Code, indicates whether the account associated with the transaction (stored on DE 2 is participating in one or several Account Level Management programs where an incremental interchange is included in the transaction’s interchange amount. N = default. | N | Alphabetic |
DE48_0158_13__Rate_Indicator | Rate Indicator indicates the rate applied by GCMS to the transaction, e.g. N = Non-regulated | N | Alphabetic |
DE48_0158_14__Masterpass_Incentive_Indicator | Masterpass Incentive Indicator, is populated by GCMS and identifies the transaction as having received the Masterpass-Enabled Merchant Incentive. Yes or No | N | Alphabetic |
DE48_159_3__Settlement_Service_Level_Code | Settlement Service Level Code) is a one-digit code that identifies the settlement level of the settlement service, e.g. 1 = regional | 1 | Numeric |
DE48_159_6__Reconciliation_Date | Reconciliation Date. Format: YYYY-MM-DD | 2023-09-23 | Date: |
DE48_159_7__Reconciliation_Cycle | Reconciliation Cycle | 2 | Numeric |
DE48_159_8__Settlement_Date | Settlement Date. Format: YYYY-MM-DD | 2023-09-23 | Date: |
DE48_159_9__Settlement_Cycle | Settlement Cycle | 2 | Numeric |
DE48_0177_1__Cross_Border_Indicator | Cross-border Indicator, identifies whether the transaction qualified as a Crossborder transaction and could be subject to Cross-border transaction pricing guidelines. Yes or No | N | Alphabetic |
DE48_0177_2__Currency_Indicator | Currency Indicator, identifies whether the transaction was submitted to Mastercard in the local currency of the merchant. Y= local currency, N = not submitted, blank = not relevant | 0 | Numeric |
DE49__Currency_Code_Transaction | Currency of transaction (local currency) | 48 | Numeric |
DE50__Currency_Code_Reconciliation | Currency of reconciliation/Settlement | 840 | Numeric |
DE51__Currency_Code_Billing | Currency of Cardholder Billing | 48 | Numeric |
DE54_2__Additional_Amount_Type | Other Amounts – e.g. cashback portions in cash back transactions. Surcharges also appear here. | 0 | Numeric |
DE54_3__Additional_Amount_Currency_Code | Indicates currency of the Surcharge amount | 48 | Numeric |
DE54_4__Additional_Amount_Sign | Additional Amount Sign (D for debit and C for Credit) | D | Alphabetic |
DE54_5__Additional_Amount | Other Amounts – e.g. cashback portions in cash back transactions. Surcharges also appear here. DE54_5 is amount, DE54_4 is amount sign | 0 | Numeric |
DE63__Transaction_Life_Cycle_ID | Transaction Life Cycle ID | MNO1P2QRS0123 | Alphanumeric |
DE71__Message_Number | Message Number – identifies the message within the T112 Mastercard file. | 54 | Numeric |
DE72__Data_Record | Used in Fee type messages to provide description of the fee. | Late Payment Penalty | Alphabetic |
DE73__Action_Date | In Fee Collection messages, this data element identifies a reference date related to the Fee. Format: YYYY-MM-DD | 2023-09-23 | Date: |
DE94__Transaction_Originator_Institution_ID | Transaction Originator Institution ID, identifies the transaction originator institution. | 10456 | Numeric |
DE100__Receiving_Institution_ID | Receiving Member ID (Paymentology processor id) | 12345 | Numeric |
DE111__Amount_Currency_Conversion_Assessment | The amount based on the result of Applying the multi-currency conversion rate (Currency Conversion Assessment) adjustment to the currency conversion rate used to convert DE 4 (Amount, Transaction) to DE 6 (Amount, Cardholder Billing) for qualified transactions. | 0 | Numeric |
v2.0 sample file
PY__RID_Settlement,PY__RID_Authorization,PY__Account_ID,PY__Token,PY__Account_External_Reference,PY__File_ID,PY__Transaction_ID,PY__Network,PY__MTID,PY__Created_Date,PY__Matched_Status,PY__Is_Debit,PY__Product_ID,PY__Product_Name,PY__Settlement_Note,DE3_1__Cardholder_Transaction_Type,DE3_2__Cardholder_from_Account_Type_Code,DE3_3__Cardholder_To_Account_Type_Code,DE4__Transaction_Amount,DE5__Reconciliation_Amount,DE6__Billing_Amount,DE9__Conversion_Rate_Reconciliation,DE10__Conversion_Rate_Billing,DE12__Transaction_Date_Time,DE22_6__Card_Present_Data,DE22_7__Card_Data_Input_Mode,DE22_8__Cardholder_Authentication_Method,DE23__Card_Sequence_Number,DE24__Function_Code,DE25__Message_Reason_Code,DE26__Merchant_Category_Code,DE30_1__Original_Amount_Transaction,DE30_2__Original_Amount_Reconciliation,DE31__Acquirer_Reference_Data,DE32__Acquiring_Institution_ID_Code,DE33__Forwarding_Institution_ID_Code,DE37__Retrieval_Reference_Number,DE38__Approval_Code,DE40__Service_Code,DE41__Card_Acceptor_Terminal_ID,DE42__Card_Acceptor_ID_Code,DE43_1__Card_Acceptor_Name,DE43_2__Card_Acceptor_Street_Address,DE43_3__Card_Acceptor_City,DE43_4__Card_Acceptor_Zip_Code,DE43_5__Card_Acceptor_State_Code,DE43_6__Card_Acceptor_Country_Code,DE48_0002__GCMS_Product_Identifier,DE48_0003__Licensed_Product_Identifier,DE48_0023__Terminal_Type,DE48_0025_1__Message_Reversal_Indicator,DE48_0105__Network_File_Reference,DE48_0158_1__Card_Program_Identifier,DE48_0158_2__Business_Service_Arrangement_Type_Code,DE48_0158_3__Business_Service_ID_Code,DE48_0158_4__Interchange_Rate_Designaor,DE48_0158_5__Central_Site_Business_Date,DE48_0158_6__Business_Cycle,DE48_0158_7__Card_Acceptor_Classification_Override_Indicator,DE48_0158_8__Product_Class_Override_Indicator,DE48_0158_9__Corporate_Incentive_Rates_Apply_Indicator,DE48_0158_10__Special_Conditions_Indicator,DE48_0158_11__MC_Assigned_ID_Override_Indicator,DE48_0158_12__Account_Level_Management_Account_Category_Code,DE48_0158_13__Rate_Indicator,DE48_0158_14__Masterpass_Incentive_Indicator,DE48_159_3__Settlement_Service_Level_Code,DE48_159_6__Reconciliation_Date,DE48_159_7__Reconciliation_Cycle,DE48_159_8__Settlement_Date,DE48_159_9__Settlement_Cycle,DE48_0177_1__Cross_Border_Indicator,DE48_0177_2__Currency_Indicator,DE49__Currency_Code_Transaction,DE50__Currency_Code_Reconciliation,DE51__Currency_Code_Billing,DE54_2__Additional_Amount_Type,DE54_3__Additional_Amount_Currncy_Code,DE54_4__Additional_Amount_Sign,DE54_5__Additional_Amount,DE63__Transaction_Life_Cycle_ID,DE71__Message_Number,DE72__Data_Record,DE73__Action_Date,DE93__Transaction_Destination_Institution_ID,DE94__Transaction_Originator_Institution_ID,DE100__Receiving_Institution_ID,DE111__Amount_Currency_Conversion_Assessment
54321000123,0,987656789,878909890,40c8-abe2-17c0d09ecd98,6543,3065275831310918050,M,1240,2025-06-17 04:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,30,0,9.94,2.65,9.94,0.266599598,1,4/03/2024 17:39,0,1,9,,200,,7311,,,5.52E+22,,12345,4.12E+11,,,SABS4055,80001234,My Company.com,129-135 COMMERCIAL ROAD,HK ,,SAU,SAU,MPL,MPL,MAN,1,1.30E+22,MCC,4,826001,PZ,6/03/2024,4,,,N,N,N,,,,1,6/03/2024,4,6/03/2024,1,N,,682,826,840,,,,,,50,,,77445,12345,12345,
54321000124,765432,987656790,878909891,40c8-abe2-17c0d09ecd99,6543,3065275831310918051,M,1240,2025-06-17 04:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-1700,-1.1,-4.12,0.000647059,0.002423529,5/03/2024 0:00,0,7,9,,200,1401,7311,,,5.52E+22,1234,1234,,190654,,,2.57E+14,Lush living Auckland NZL,201-207 HIGH STREET,HK ,94043,CA,USA,MPL,MPL,NA,1,1.30E+22,MCC,1,12345,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,566,826,840,,,,,ABCD123RF0121,51,,,77445,1234,1234,
54321000125,765433,987656791,878909892,40c8-abe2-17c0d09ecd100,6543,3065275831310918052,M,1240,2025-06-17 04:00:41,1,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1b) on tok+de38,20,0,0,3.99,1.06,3.99,0.26566416,1,6/03/2024 0:00,0,1,9,,200,1401,7311,,,5.52E+22,4321,4321,,190655,,,2.57E+14,GOT MONEY CA AB Home Town GBR,32-34 ARNDALE CENTRE,LONDON,UNKNOWN,ESP,KWT,MDS,MDS,NA,1,1.30E+22,DMC,1,54321,EW,6/03/2024,5,,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,Y,,682,826,840,,,,,,175,,,77445,4321,4321,
54321000126,765434,987656792,878909893,40c8-abe2-17c0d09ecd101,6543,3065275831310918053,M,1240,2025-06-17 04:00:41,1,-1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-1700,-1.1,-4.12,0.000647059,0.002423529,5/03/2024 0:00,0,7,9,,200,1401,5734,,,5.55E+22,7654,7654,,190656,,,2.57E+14,Givememore Auckland NZL,40 HIGH STREET,HAMPSHIRE,94043,ESP,ITA,MDS,MDS,NA,1,1.30E+22,DMC,1,12345,YA,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,566,826,840,,,,,ABCD123RF0122,176,,,77445,7654,7654,
54321000127,765435,987656793,878909894,40c8-abe2-17c0d09ecd102,6543,3065275831310918054,M,1240,2025-06-17 04:00:41,1,-1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-5.94,-5.94,-22.28,1,3.750841751,5/03/2024 0:00,0,7,9,,200,1401,5734,,,5.55E+22,9876,7654,,190657,,,2.57E+14,Amazon Prime Amzn.com/bill USA,40 HIGH STREET,Riyadh,94043,ESP,BHR,MDS,MDS,NA,1,1.30E+22,DMC,1,12345,YA,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,ABCD123RF0123,177,,,77445,7654,7654,
54321000128,0,987656794,878909895,40c8-abe2-17c0d09ecd103,6543,3065275831310918055,M,1240,2025-06-17 06:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,0,0,16.53,4.41,16.53,0.266787659,1,5/03/2024 7:12,0,S,9,,200,,5945,,,6.55E+22,,87654,4.12E+11,,,40551234,2.57E+14,APPLE.COM/BILL ITUNES.COM IRL,48-56 CHURCH STREET,Dubai,,ESP,SAU,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,682,826,840,,,,,ABCD123RF0124,178,,,77445,87654,87654,
54321000129,765436,987656795,878909896,40c8-abe2-17c0d09ecd104,6543,3065275831310918056,M,1240,2025-06-17 06:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-36.03,-36.03,-135.14,1,3.750763253,5/03/2024 0:00,0,7,9,,200,1401,5734,,,8.54E+22,9876,9876,,898098,,,2.57E+14,Google YouTube River View CAL,48-56 CHURCH STREET,Westland,NR2 1QD,ESP,ARE,MPL,MPL,CT6,1,1.30E+22,MCC,1,12345,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,ABCD123RF0125,179,,,77445,9876,9876,
54321000130,765437,987656796,878909897,40c8-abe2-17c0d09ecd105,6543,3065275831310918057,M,1240,2025-06-17 06:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-5.94,-5.94,-22.28,1,3.750841751,5/03/2024 0:00,0,S,9,,200,1401,5734,,,8.26E+22,9080,8765,,909090,,,2.57E+14,Alloallo Melbourne AUS,48-56 CHURCH STREET,RIYADH,BS1 3BB,CA,KEN,MPL,MPL,CT6,1,1.30E+22,MCC,1,12345,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,ABCD123RF0126,180,,,77445,8765,8765,
54321000131,0,987656797,878909898,40c8-abe2-17c0d09ecd106,6543,3065275831310918058,M,1240,2025-06-17 06:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,0,0,79.84,79.84,299.46,1,3.750751503,5/03/2024 18:09,0,S,9,,200,,5818,,,8.26E+22,,12345,4.12E+11,,,40551235,2.57E+14,GOOGLE *YouTube ,499-517 OXFORD STREET,google.com,BS1 3BB,SAU,SAU,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,840,826,840,,,,,,181,,,77445,12345,12345,
54321000132,654321,987656798,878909899,40c8-abe2-17c0d09ecd107,6544,3065275831310918059,M,1240,2025-06-17 10:00:41,1,-1,11,MyProduct-Mastercard Credit,1400=Not previously authorized; match (1a) on tok+de38,0,0,0,-90,-24,-90,0.266666667,1,6/03/2024 14:44,1,M,9,0,200,1400,5818,,,7.27E+22,346765,1234,4.12E+11,667788,201,1656495,65613598L483,BRUNELLO CUCINELLI,499-517 OXFORD STREET,London,BS1 3BB,USA,ESP,MPL,MPL,POI,1,1.30E+22,MCC,4,826001,PZ,7/03/2024,1,,,N,N,N,,,,1,7/03/2024,1,7/03/2024,1,N,,682,826,840,,,,,EFGH123RF0126,182,,,77445,1234,65789,
54321000133,876543,987656799,878909900,40c8-abe2-17c0d09ecd108,6544,3065275831310918060,M,1240,2025-06-17 10:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-285.36,-9.15,-34.3,0.03206476,0.120199047,5/03/2024 14:38,0,S,2,0,200,,5661,-285.36,0,7.27E+22,7788,4321,4.12E+11,998877,,AVCD,6677567,ISTYLE,I-27 THE HORSEFAIR,MEDFORD,M17 8BN,NLD,ESP,MPL,MPL,CT6,1,1.30E+22,MCC,1,54321,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,949,826,840,,,,,IJKL123RF0126,183,,,77445,4321,65789,
54321000134,0,987656800,878909901,40c8-abe2-17c0d09ecd109,6544,3065275831310918061,M,1240,2025-06-17 10:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,0,0,16.53,4.41,16.53,0.266787659,1,5/03/2024 7:12,0,S,9,,200,,5311,,,5.13E+21,,7654,4.12E+11,,,12300009,2.57E+14,Alexander McQueen,I-27 THE HORSEFAIR,KUWAIT,W12 7SL,SAU,ESP,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,682,826,840,,,,,,184,,,77445,7654,65789,
54321000135,876544,987656801,878909902,40c8-abe2-17c0d09ecd110,6544,3065275831310918062,M,1240,2025-06-17 12:00:41,1,1,11,MyProduct-Mastercard Credit,; match (1b) on tok+de38,20,0,0,4,4,15,1,3.75,6/03/2024 6:52,0,S,9,,200,,5311,,,5.13E+21,87694,7654,4.12E+11,190658,,,5.27E+14,JUMBO\LIMITED LLC,I-27 THE HORSEFAIR,MADRID,W12 7SL,CA,ESP,MDW,MDW,CT6,1,1.30E+22,MCC,1,12345,YB,6/03/2024,5,,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,Y,,840,826,840,,,,,EFGH123RF0127,185,,,77445,7654,65789,
54321000136,876545,987656802,878909903,40c8-abe2-17c0d09ecd111,6544,3065275831310918063,M,1240,2025-06-17 12:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-0.01,0,-0.01,0,1,5/03/2024 19:11,0,1,9,,200,,5311,,,5.13E+21,,87654,4.12E+11,190659,,12300009,1000700331,Aimn official store,"UNIT B, BARTON SQUARE",BARCELONA,OX1 1PE,SAU,ESP,MDW,MDW,MAN,1,1.30E+22,MCC,4,826001,PZ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,682,826,840,,,,,EFGH123RF0128,186,,,77445,87654,65789,
54321000137,876546,987656803,878909904,40c8-abe2-17c0d09ecd112,6544,3065275831310918064,M,1240,2025-06-17 12:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-3.5,-0.93,-3.5,0.265714286,1,5/03/2024 7:06,1,M,0,0,200,,5311,,,5.13E+21,,9876,4.12E+11,190660,201,12300078,2.06E+11,Fifa.com,UNIT SU2231 & SU3231,TOLEDO,B24 9FP,SAU,ESP,MDW,MDW,POI,1,1.30E+22,MCC,4,826001,PP,6/03/2024,4,,,N,N,N,,,,1,6/03/2024,4,6/03/2024,1,N,,682,826,840,,,,,EFGH123RF0129,187,,,77445,9876,65789,
54321000138,876547,987656804,878909905,40c8-abe2-17c0d09ecd113,6955,3065275831310918065,M,1240,2025-06-17 12:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-15,-4,-15,0.266666667,1,3/03/2024 19:28,1,C,1,0,200,1401,5311,,,5.13E+21,873888,8765,4.12E+11,190661,,63512345,2.06E+11,Pradaamerlia,UNIT SU2231 & SU3231,VAUXHALL,M60 1TX,GBR,ESP,MPL,MPL,POI,1,1.30E+22,MCC,4,826001,PP,6/03/2024,6,0,,N,N,N,,,,1,6/03/2024,6,6/03/2024,1,N,,682,826,840,,,,,EFGH123RF0130,188,,,77445,8765,65789,
54321000139,876548,987656805,878909906,40c8-abe2-17c0d09ecd114,6955,3065275831310918066,M,1240,2025-06-17 14:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-1.7,-4.52,-16.95,2.658823529,9.970588235,5/03/2024 17:09,1,M,5,,200,1401,5967,,,7.53E+22,989789,12345,4.12E+11,190662,,,2.06E+11,honda.com/au,OXFORD WESTGATE,BRISTOL,M60 1TX,GBR,BHR,MPL,MPL,POI,1,1.30E+22,MCC,2,60001,YQ,6/03/2024,3,,,N,N,N,,,,1,6/03/2024,3,6/03/2024,1,Y,,48,826,840,,,,,EFGH123RF0131,189,,,77445,12345,65789,
54321000140,876549,987656806,878909907,40c8-abe2-17c0d09ecd115,6955,3065275831310918067,M,1240,2025-06-17 14:00:41,1,-1,11,MyProduct-Mastercard Credit,1400=Not previously authorized; match (1a) on tok+de38,0,30,0,-60,-16,-60,0.266666667,1,5/03/2024 14:39,0,S,6,1,200,1400,5967,,,7.53E+22,,87654,4.12E+11,190663,,7654567,2.06E+11,CHEWTON GLEN HOTELS LI,UNIT 1B - 3A,GLASGOW,M60 1TX,GBR,SAU,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,7/03/2024,1,,,N,N,N,,,,1,7/03/2024,1,7/03/2024,1,N,,682,826,840,,,,,EFGH123RF0132,190,,,77445,87654,65789,
54321000141,876550,987656807,878909908,40c8-abe2-17c0d09ecd116,6955,3065275831310918068,M,1240,2025-06-17 14:00:41,1,-1,7,MyProduct-Mastercard Debit,"1404=Previously approved auth—partial amt, final clear; match (1a) on tok+de38",0,0,0,-21.29,-5.8,-21.74,0.27242837,1.021136684,5/03/2024 17:27,0,S,9,,200,1404,5817,,,2.68E+21,,9876,4.12E+11,190664,,,2.06E+11,GAME KING LLC,,BOSTON,784,GBR,ARE,MDS,MDS,CT6,1,1.30E+22,DMC,2,60001,YA,6/03/2024,5,,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,Y,,784,826,840,,,,,EFGH123RF0133,191,,,77445,9876,65789,
54321000142,876551,987656808,878909909,40c8-abe2-17c0d09ecd117,6955,3065275831310918069,M,1240,2025-06-17 14:00:41,1,-1,7,MyProduct-Mastercard Debit,; match (1a) on tok+de38,0,0,0,-26.66,-26.66,-99.99,1,3.750562641,5/03/2024 16:25,0,S,9,,200,,5817,,,2.68E+21,16738,8765,4.12E+11,190665,0,ABCD12K2,DDFGSJKKTLR8909,JKL.EU,,ADOBE.LY/BILL,100,GBR,KEN,MDS,MDS,CT6,1,1.30E+22,DMC,2,60001,YA,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,EFGH123RF0134,192,,,77445,8765,65789,
54321000143,876552,987656809,878909910,40c8-abe2-17c0d09ecd118,6955,3065275831310918070,M,1240,2025-06-17 14:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-10,-2.67,-10,0.267,1,5/03/2024 10:13,1,M,9,0,200,,5817,,,2.68E+21,,7654,4.12E+11,190666,101,89098888,2.06E+11,SAMSUNG.com,,APPLE.COM/BIL,,SAU,SAU,MPL,MPL,POI,1,1.30E+22,MCC,4,826001,PP,6/03/2024,4,0,,N,N,N,,,,1,6/03/2024,4,6/03/2024,1,N,,682,826,840,,,,,,193,,,77445,7654,65789,
Mastercard and MADA
Below specifies the format of a Presentment report when the scheme is Mastercard and using MADA as well.
Field Name | Description | Internal MADA messages Example | Internal MADA messages Usage | Internal MADA messages Source Specification | External transactions messages Example | External transactions messages Usage | External transactions messages Source Specification |
|---|---|---|---|---|---|---|---|
PY__RID_Settlement | Unique ID for settlement transaction | 211000002 | M | P | 11000050 | M | P |
PY__RID_Authorization | Unique ID for authorisation transaction (this may have value 0 if no Authorisation involved in the transaction) | 122930 | M | P | 82935 | M | P |
PY__Account_ID | Account identifier | 432339614 | M | P | 534851632 | M | P |
PY__Token | Public token generated by Paymentology to replace PAN | 186913330 | M | P | 922178757 | M | P |
PY__Account_External_Reference | Unique file ID assigned by Paymentology | 8e981fca-8e68 | M | P | - | O | P |
PY__File_ID | Unique file ID assigned by Paymentology | 21 | M | P | 1 | M | P |
PY__Transaction_ID | Transaction thread ID created and maintained by Paymentology. Large integer, incremental | 181533588 | M | P | 1.76139E+18 | M | P |
PY__Network | Indicates the Network provider. M = Mastercard | MADA | M | P | M | M | P |
PY__MTID | MTID code (Message Transaction Identifier) | 0210 | M | M | 1240 | M | M |
PY__Created_Date | Indicates the time at which Paymentology processed the file | 05/01/2022 12:28 | M | P | 15/11/2021 10:00 | M | P |
PY__Matched_Status | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have value ranging from 1 to 9 . 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform . | 1 | M | P | 1 | M | P |
PY__Is_Debit | This field determines the direction of funds flow of the original transaction, -1 = debit, +1 = credit, 0 = record with no financial movement (balance enquiry, no fees). | -1 | M | P | - | O | P |
PY__Product_ID | Product identifier | 1 | M | P | - | O | P |
PY__Product_Name | Product name | Tweeq | M | P | - | O | P |
PY__Settlement_Note | Position for Paymentology to assign notes that may be of relevance to client, relating to the presentment. Provisional field, reserved for future use | match(1a) on tok+de38 | M | M | P | 1400=Not previously authorized; match (1a) on tok+de38 | M |
DE3_1__Cardholder_Transaction_Type | "Processing Code, describe the effect of a transaction on a customer account and the type of accounts affected. | 10 | M | M | 00 | M | M |
DE3_2__Cardholder_from_Account_Type_Code | Position 3-4 = Cardholder ‘from’ Account type | - | O | M | 0 | O | M |
DE3_3__Cardholder_To_Account_Type_Code | Position 5-6 = Cardholder ‘to’ Account type | - | O | M | 0 | O | M |
DE4__Transaction_Amount | Local amount with sign, indicating the net direction of funds flow. Currency provided in DE49 | -10 | M | M | -1100 | M | M |
DE5__Reconciliation_Amount | Settlement amount with sign, indicating the net direction of funds flow. Currency provided in DE50 | -10 | O | M | -0.31 | M | M |
DE6__Billing_Amount | Cardholder Billing amount with sign, indicating the net direction of funds flow. Currency provided in DE51 | - | O | M | -1.17 | M | M |
DE9__Conversion_Rate_Reconciliation | if DE5 is present, else 0 | -76.61 | C | M | 0.000281818 | M | M |
DE10__Conversion_Rate_Billing | Conversion rate to Cardholder billing currency. Digit 1 on left indicates position of decimal place. | 0.2724 | M | M | 0.001063636 | M | M |
DE12__Transaction_Date_Time | Date/time of local original spend. MC frequently provide 00:00:00 as time element | 19/12/2021 12:07 | M | M | 28/10/2021 05:46 | M | M |
DE17__Capture_Date | Date/time of capturing transaction from device/virtual device and including to Clearing file. Note: The Authorization Platform currently does not use this data element. In IPM Clearing format this field is not defined | 1219 | M | M | - | O | M |
DE22_6__Card_Present_Data | Card Present data | - | O | M | 1 | M | M |
DE22_7__Card_Data_Input_Mode | Card Present data | - | O | M | B | M | M |
DE22_8__Cardholder_Authentication_Method | Cardholder Authentication Method | O | M | 9 | M | M | |
DE23__Card_Sequence_Number | Card Sequence Number. Note: this parameter is empty now | 1 | O | M | - | O | M |
DE24__Function_Code | Function Code. Is present for some operation types. Is absent for DE3_1=10 + MCC6011 | - | C | M | 200 | M | M |
DE25__Message_Reason_Code | Message Reason Code. Is present for some operation types. Is absent for DE3_1=10 + MCC6011 | - | C | M | 1400 | M | M |
DE26__Merchant_Category_Code | MCC Merchant Category Codes | 6011 | M | M | 5411 | M | M |
DE30_1__Original_Amount_Transaction | DE 30 (Amounts, original) contains the “amount” data element values from the First Presentment or Fee Collection (DE4). Used for chargeback or retrieval request. | 0 | M | M | - | O | M |
DE30_2__Original_Amount_Reconciliation | DE 30 (Amounts, reconciliation) Mastercard populate this with all zeros. | 100 | M | M | - | O | M |
DE31__Acquirer_Reference_Data | Acquirer Reference Data (See MC IPM Clearing Formats document) | - | O | M | 25567681305000200000000 | M | M |
DE32__Acquiring_Institution_ID_Code | Acquirer Member ID | 588851 | M | M | 999080 | M | M |
DE33__Forwarding_Institution_ID_Code | Forwarding Institution Code | - | O | M | 999080 | M | M |
DE37__Retrieval_Reference_Number | Retrieval_Reference_Number | 206209540031 | M | M | 080000100004 | M | M |
DE38__Approval_Code | Approval Code (the code that goes on customer receipt, Paymentology generated) | 107986 | M | M | 100764 | M | M |
DE40__Service_Code | Service Code | 0 | O | M | - | O | M |
DE41__Card_Acceptor_Terminal_ID | Card Acceptor Terminal Identification | SDRBRA1L | M | M | - | O | M |
DE42__Card_Acceptor_ID_Code | Card Acceptor ID Code | 58885123456 | M | M | R-5411-USA | M | M |
DE43_1__Card_Acceptor_Name | Card acceptor name (22 long) | SABB | M | M | GROCERY STORES, SUPERM | M | M |
DE43_2__Card_Acceptor_Street_Address | Card Acceptor Street address (48 long) | - | O | M | 1234 Main Street | M | M |
DE43_3__Card_Acceptor_City | Card Acceptor City (13 long) | - | O | M | OFALLON | M | M |
DE43_4__Card_Acceptor_Zip_Code | Post/zip code (10 long) | - | O | M | B2200 | M | M |
DE43_5__Card_Acceptor_State_Code | State or province (3 long) | - | O | M | IA | M | M |
DE43_6__Card_Acceptor_Country_Code | Country Code (3 long) | - | O | M | USA | M | M |
DE48_0002__GCMS_Product_Identifier | GCMS Product Identifier, e.g. MRW is Prepaid Mastercard Business Card (Non-U.S.) | SPAN | M | M | MDS | M | M |
DE48_0003__Licensed_Product_Identifier | Licensed Product Identifier | - | O | M | MDS | M | M |
DE48_0023__Terminal_Type | Terminal Type, identifies the type of terminal used at the point of interaction | - | O | M | POI | M | M |
DE48_0025_1__Message_Reversal_Indicator | Reversal Indicator. | -1 | M | M | 1 | M | M |
DE48_0105__Network_File_Reference | PDS 0105 value. Network File Reference | TLF04.20211221. | M | M | 12111120000003100000000 | M | M |
DE48_0158_1__Card_Program_Identifier | Card Program Identifier | - | O | M | DMC | M | M |
DE48_0158_2__Business_Service_Arrangement_Type_Code | Business Service Arrangement Type Code | - | O | M | 1 | M | M |
DE48_0158_3__Business_Service_ID_Code | Business ServiceID Code | - | O | M | 10601 | M | M |
DE48_0158_4__Interchange_Rate_Designaor | Interchange Rate Designator | - | O | M | 73 | M | M |
DE48_0158_5__Central_Site_Business_Date | Central Site Business Date | - | O | M | 12/11/2021 | M | M |
DE48_0158_6__Business_Cycle | Business Cycle | - | O | M | 1 | M | M |
DE48_0158_7__Card_Acceptor_Classification_Override_Indicator | Card Acceptor Classification Override Indicator, with appropriate values to indicate whether Card Acceptor Business Code (MCC) override rates, Card Acceptor Business (CAB) Type override rates, or neither, were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | - | O | M | - | O | M |
DE48_0158_8__Product_Class_Override_Indicator | Product Class Override Indicator, indicate whether product class override interchange rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | - | O | M | - | O | M |
DE48_0158_9__Corporate_Incentive_Rates_Apply_Indicator | Corporate Incentive Rates Apply Indicator, with a value of 1, 2, N or V to indicate whether no (N), first-level (1), second-level (2), or V (VAT) corporate incentive rates were used in the interchange fee amount designated in PDS 0146 (Amounts, Transaction Fee). | - | O | M | N | M | M |
DE48_0158_10__Special_Conditions_Indicator | Special Conditions Indicator, with a value to indicate whether an adjustment was included in the Fee amount | - | O | M | N | M | M |
DE48_0158_11__MC_Assigned_ID_Override_Indicator | Mastercard Assigned ID Override Indicator, with a value of Y or N to indicate whether override rates were used in the interchange fee amount designated in PDS 0146 (Amount, Transaction Fees). | - | O | M | N | M | M |
DE48_0158_12__Account_Level_Management_Account_Category_Code | Account Level Management Account Category Code, indicates whether the account associated with the transaction (stored on DE 2 is participating in one or several Account Level Management programs where an incremental interchange is included in the transaction’s interchange amount. N = default. | - | O | M | - | O | M |
DE48_0158_13__Rate_Indicator | Rate Indicator indicates the rate applied by GCMS to the transaction, e.g. N = Non-regulated | - | O | M | - | O | M |
DE48_0158_14__Masterpass_Incentive_Indicator | Masterpass Incentive Indicator, is populated by GCMS and identifies the transaction as having received the Masterpass-Enabled Merchant Incentive. Yes or No | - | O | M | - | O | M |
DE48_159_3__Settlement_Service_Level_Code | Settlement Service Level Code) is a one-digit code that identifies the settlement level of the settlement service, e.g. 1 = regional | - | O | M | 1 | M | M |
DE48_159_6__Reconciliation_Date | PDS 0159_6 value, Reconciliation Date | 21/12/2021 | M | M | 12/11/2021 | M | M |
DE48_159_7__Reconciliation_Cycle | PDS 0159_7 value, Reconciliation Cycle | 0 | M | M | 1 | M | M |
DE48_159_8__Settlement_Date | Settlement Date | - | O | M | 12/11/2021 | M | M |
DE48_159_9__Settlement_Cycle | Settlement Cycle | 0 | M | M | 1 | M | M |
DE48_0177_1__Cross_Border_Indicator | Cross-border Indicator, identifies whether the transaction qualified as a Crossborder transaction and could be subject to Cross-border transaction pricing guidelines. Yes or No | - | O | M | Y | M | M |
DE48_0177_2__Currency_Indicator | Currency Indicator, identifies whether the transaction was submitted to Mastercard in the local currency of the merchant. Y= local currency, N = not submitted, blank = not relevant | - | O | M | - | O | M |
DE49__Currency_Code_Transaction | Currency of transaction (local currency) | 682 | M | M | 784 | M | M |
DE50__Currency_Code_Reconciliation | Currency of reconciliation/Settlement | 682 | M | M | 840 | M | M |
DE51__Currency_Code_Billing | Currency of Cardholder Billing | - | O | M | 682 | M | M |
DE54_2__Additional_Amount_Type | Additional Amount, Amount Type | 40 | M | M | - | O | M |
DE54_3__Additional_Amount_Currency_Code | Currency | 682 | M | M | - | O | M |
DE54_4__Additional_Amount_Sign | Sign | D | M | M | - | O | M |
DE54_5__Additional_Amount | Additional Amount | 000000000200 | M | M | - | O | M |
DE63__Transaction_Life_Cycle_ID | Transaction Life Cycle ID | 1052 | M | M | MDSIGO2SV1028 | M | M |
DE71__Message_Number | Message Number – identifies the message within the T112 Mastercard file. | 0 | M | M | 50 | M | M |
DE72__Data_Record | Used in Fee type messages to provide description of the fee. | 0 | M | M | - | O | M |
DE73__Action_Date | In Fee Collection messages, this data element identifies a reference date related to the Fee | - | O | M | - | O | M |
DE93__Transaction_Destination_Institution_ID | Transaction Destination Institution ID Code | 242030 | M | M | 31365 | M | M |
DE94__Transaction_Originator_Institution_ID | Transaction Originator Institution ID, identifies the transaction originator institution. | 636120 | M | M | 999080 | M | M |
DE97__Net_Reconciliation_Amount | "Net Reconciliation Amount. The format is X+N 16. In the Extract File, the X portion is ""-"" if the calculated amount is negative, otherwise ""0""." | - | O | M | - | O | M |
DE100__Receiving_Institution_ID | Receiving Member ID (Paymentology processor id) | 242030 | M | 31365 | M | ||
DE111__Amount_Currency_Conversion_Assessment | The amount based on the result of Applying the multi-currency conversion rate (Currency Conversion Assessment) adjustment to the currency conversion rate used to convert DE 4 (Amount, Transaction) to DE 6 (Amount, Cardholder Billing) for qualified transactions. | - | O | M | - | O | M |
DE122__Card_Scheme_Sponser_ID | The Card Scheme Sponsor Identifier, assigned by mada, is a unique identifier for the financial institution. It contains the identifier of the Card Scheme Acquirer Bank, which agrees to settle a Bank Card Scheme's transactions. | ALBIP1 | M | M | - | O | M |
DE124__POS_Terminal_Reconcile_Total | The mada POS Terminal Reconcile Total is used to carry terminal transaction activity. The transaction details are calculated by the terminal for each card scheme accepted at that terminal. | - | O | M | - | O | M |
DE127__POS_Host_Reconcile_Total | The mada POS Host Reconcile Total is used to carry terminal transaction activity. The transaction details are calculated by the mada host for each card scheme accepted at that terminal. | - | O | M | - | O | M |
Merchant_Reference_ID | Order Identifier: Merchant allocated unique Order Identifier used as a merchant reference for inquiry and tracking. | c3559d1d9b8abc | O | P | - | O | P |
Gateway_ID | Primary & Secondary Gateway Identifier | HPAY- | O | P | - | O | P |
COF_Data | Card On File (COF) Transaction Context. This sub-element is mandatory for all COF transactions and when present, it indicates the COF transaction use-case and relation type. | 03R | O | P | - | O | P |
Payment_Transaction_Number | "SADAD Payment Transaction Number Unique transaction number identifier for each payment at Sadad, it is generated by Sadad System" | 3000330681 | O | P | - | O | P |
Biller_ID | To be used to identify the specific biller in accordance with ongoing billers supported by Sadad. | 60 | O | P | - | O | P |
Bill_ID | Unique bill identification number for the specified biller. | 604390105 | O | P | - | O | P |
Payment_Status | "Payment Status. Valid values are: ‘Adviced’ – For transactions that are approved by the Issuer, ‘Validated’ – For transactions that are declined by the Issuer, “Reversed’ – For reversal transactions. Note: Issuers will only receive this Tag field for reversals." | Adviced | O | P | - | O | P |
Bill_Payment_Amount_Due | Bill Payment Amount Due. Includes the decimal as the last 2 digits. | 0 | O | P | - | O | P |
Sample file
PY__RID_Settlement,PY__RID_Authorization,PY__Account_ID,PY__Token,PY__Account_External_Reference,PY__File_ID,PY__Transaction_ID,PY__Network,PY__MTID,PY__Created_Date,PY__Matched_Status,PY__Is_Debit,PY__Product_ID,PY__Product_Name,PY__Settlement_Note,DE3_1__Cardholder_Transaction_Type,DE3_2__Cardholder_from_Account_Type_Code,DE3_3__Cardholder_To_Account_Type_Code,DE4__Transaction_Amount,DE5__Reconciliation_Amount,DE6__Billing_Amount,DE9__Conversion_Rate_Reconciliation,DE10__Conversion_Rate_Billing,DE12__Transaction_Date_Time,DE22_6__Card_Present_Data,DE22_7__Card_Data_Input_Mode,DE22_8__Cardholder_Authentication_Method,DE23__Card_Sequence_Number,DE24__Function_Code,DE25__Message_Reason_Code,DE26__Merchant_Category_Code,DE30_1__Original_Amount_Transaction,DE30_2__Original_Amount_Reconciliation,DE31__Acquirer_Reference_Data,DE32__Acquiring_Institution_ID_Code,DE33__Forwarding_Institution_ID_Code,DE37__Retrieval_Reference_Number,DE38__Approval_Code,DE40__Service_Code,DE41__Card_Acceptor_Terminal_ID,DE42__Card_Acceptor_ID_Code,DE43_1__Card_Acceptor_Name,DE43_2__Card_Acceptor_Street_Address,DE43_3__Card_Acceptor_City,DE43_4__Card_Acceptor_Zip_Code,DE43_5__Card_Acceptor_State_Code,DE43_6__Card_Acceptor_Country_Code,DE48_0002__GCMS_Product_Identifier,DE48_0003__Licensed_Product_Identifier,DE48_0023__Terminal_Type,DE48_0025_1__Message_Reversal_Indicator,DE48_0105__Network_File_Reference,DE48_0158_1__Card_Program_Identifier,DE48_0158_2__Business_Service_Arrangement_Type_Code,DE48_0158_3__Business_Service_ID_Code,DE48_0158_4__Interchange_Rate_Designaor,DE48_0158_5__Central_Site_Business_Date,DE48_0158_6__Business_Cycle,DE48_0158_7__Card_Acceptor_Classification_Override_Indicator,DE48_0158_8__Product_Class_Override_Indicator,DE48_0158_9__Corporate_Incentive_Rates_Apply_Indicator,DE48_0158_10__Special_Conditions_Indicator,DE48_0158_11__MC_Assigned_ID_Override_Indicator,DE48_0158_12__Account_Level_Management_Account_Category_Code,DE48_0158_13__Rate_Indicator,DE48_0158_14__Masterpass_Incentive_Indicator,DE48_159_3__Settlement_Service_Level_Code,DE48_159_6__Reconciliation_Date,DE48_159_7__Reconciliation_Cycle,DE48_159_8__Settlement_Date,DE48_159_9__Settlement_Cycle,DE48_0177_1__Cross_Border_Indicator,DE48_0177_2__Currency_Indicator,DE49__Currency_Code_Transaction,DE50__Currency_Code_Reconciliation,DE51__Currency_Code_Billing,DE54_2__Additional_Amount_Type,DE54_3__Additional_Amount_Currncy_Code,DE54_4__Additional_Amount_Sign,DE54_5__Additional_Amount,DE63__Transaction_Life_Cycle_ID,DE71__Message_Number,DE72__Data_Record,DE73__Action_Date,DE93__Transaction_Destination_Institution_ID,DE94__Transaction_Originator_Institution_ID,DE100__Receiving_Institution_ID,DE111__Amount_Currency_Conversion_Assessment
54321000123,0,987656789,878909890,40c8-abe2-17c0d09ecd98,6543,3065275831310918050,M,1240,2025-06-17 04:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,30,0,9.94,2.65,9.94,0.266599598,1,4/03/2024 17:39,0,1,9,,200,,7311,,,5.52E+22,,12345,4.12E+11,,,SABS4055,80001234,My Company.com,129-135 COMMERCIAL ROAD,HK ,,SAU,SAU,MPL,MPL,MAN,1,1.30E+22,MCC,4,826001,PZ,6/03/2024,4,,,N,N,N,,,,1,6/03/2024,4,6/03/2024,1,N,,682,826,840,,,,,,50,,,77445,12345,12345,
54321000124,765432,987656790,878909891,40c8-abe2-17c0d09ecd99,6543,3065275831310918051,M,1240,2025-06-17 04:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-1700,-1.1,-4.12,0.000647059,0.002423529,5/03/2024 0:00,0,7,9,,200,1401,7311,,,5.52E+22,1234,1234,,190654,,,2.57E+14,Lush living Auckland NZL,201-207 HIGH STREET,HK ,94043,CA,USA,MPL,MPL,NA,1,1.30E+22,MCC,1,12345,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,566,826,840,,,,,ABCD123RF0121,51,,,77445,1234,1234,
54321000125,765433,987656791,878909892,40c8-abe2-17c0d09ecd100,6543,3065275831310918052,M,1240,2025-06-17 04:00:41,1,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1b) on tok+de38,20,0,0,3.99,1.06,3.99,0.26566416,1,6/03/2024 0:00,0,1,9,,200,1401,7311,,,5.52E+22,4321,4321,,190655,,,2.57E+14,GOT MONEY CA AB Home Town GBR,32-34 ARNDALE CENTRE,LONDON,UNKNOWN,ESP,KWT,MDS,MDS,NA,1,1.30E+22,DMC,1,54321,EW,6/03/2024,5,,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,Y,,682,826,840,,,,,,175,,,77445,4321,4321,
54321000126,765434,987656792,878909893,40c8-abe2-17c0d09ecd101,6543,3065275831310918053,M,1240,2025-06-17 04:00:41,1,-1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-1700,-1.1,-4.12,0.000647059,0.002423529,5/03/2024 0:00,0,7,9,,200,1401,5734,,,5.55E+22,7654,7654,,190656,,,2.57E+14,Givememore Auckland NZL,40 HIGH STREET,HAMPSHIRE,94043,ESP,ITA,MDS,MDS,NA,1,1.30E+22,DMC,1,12345,YA,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,566,826,840,,,,,ABCD123RF0122,176,,,77445,7654,7654,
54321000127,765435,987656793,878909894,40c8-abe2-17c0d09ecd102,6543,3065275831310918054,M,1240,2025-06-17 04:00:41,1,-1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-5.94,-5.94,-22.28,1,3.750841751,5/03/2024 0:00,0,7,9,,200,1401,5734,,,5.55E+22,9876,7654,,190657,,,2.57E+14,Amazon Prime Amzn.com/bill USA,40 HIGH STREET,Riyadh,94043,ESP,BHR,MDS,MDS,NA,1,1.30E+22,DMC,1,12345,YA,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,ABCD123RF0123,177,,,77445,7654,7654,
54321000128,0,987656794,878909895,40c8-abe2-17c0d09ecd103,6543,3065275831310918055,M,1240,2025-06-17 06:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,0,0,16.53,4.41,16.53,0.266787659,1,5/03/2024 7:12,0,S,9,,200,,5945,,,6.55E+22,,87654,4.12E+11,,,40551234,2.57E+14,APPLE.COM/BILL ITUNES.COM IRL,48-56 CHURCH STREET,Dubai,,ESP,SAU,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,682,826,840,,,,,ABCD123RF0124,178,,,77445,87654,87654,
54321000129,765436,987656795,878909896,40c8-abe2-17c0d09ecd104,6543,3065275831310918056,M,1240,2025-06-17 06:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-36.03,-36.03,-135.14,1,3.750763253,5/03/2024 0:00,0,7,9,,200,1401,5734,,,8.54E+22,9876,9876,,898098,,,2.57E+14,Google YouTube River View CAL,48-56 CHURCH STREET,Westland,NR2 1QD,ESP,ARE,MPL,MPL,CT6,1,1.30E+22,MCC,1,12345,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,ABCD123RF0125,179,,,77445,9876,9876,
54321000130,765437,987656796,878909897,40c8-abe2-17c0d09ecd105,6543,3065275831310918057,M,1240,2025-06-17 06:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-5.94,-5.94,-22.28,1,3.750841751,5/03/2024 0:00,0,S,9,,200,1401,5734,,,8.26E+22,9080,8765,,909090,,,2.57E+14,Alloallo Melbourne AUS,48-56 CHURCH STREET,RIYADH,BS1 3BB,CA,KEN,MPL,MPL,CT6,1,1.30E+22,MCC,1,12345,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,ABCD123RF0126,180,,,77445,8765,8765,
54321000131,0,987656797,878909898,40c8-abe2-17c0d09ecd106,6543,3065275831310918058,M,1240,2025-06-17 06:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,0,0,79.84,79.84,299.46,1,3.750751503,5/03/2024 18:09,0,S,9,,200,,5818,,,8.26E+22,,12345,4.12E+11,,,40551235,2.57E+14,GOOGLE *YouTube ,499-517 OXFORD STREET,google.com,BS1 3BB,SAU,SAU,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,840,826,840,,,,,,181,,,77445,12345,12345,
54321000132,654321,987656798,878909899,40c8-abe2-17c0d09ecd107,6544,3065275831310918059,M,1240,2025-06-17 10:00:41,1,-1,11,MyProduct-Mastercard Credit,1400=Not previously authorized; match (1a) on tok+de38,0,0,0,-90,-24,-90,0.266666667,1,6/03/2024 14:44,1,M,9,0,200,1400,5818,,,7.27E+22,346765,1234,4.12E+11,667788,201,1656495,65613598L483,BRUNELLO CUCINELLI,499-517 OXFORD STREET,London,BS1 3BB,USA,ESP,MPL,MPL,POI,1,1.30E+22,MCC,4,826001,PZ,7/03/2024,1,,,N,N,N,,,,1,7/03/2024,1,7/03/2024,1,N,,682,826,840,,,,,EFGH123RF0126,182,,,77445,1234,65789,
54321000133,876543,987656799,878909900,40c8-abe2-17c0d09ecd108,6544,3065275831310918060,M,1240,2025-06-17 10:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-285.36,-9.15,-34.3,0.03206476,0.120199047,5/03/2024 14:38,0,S,2,0,200,,5661,-285.36,0,7.27E+22,7788,4321,4.12E+11,998877,,AVCD,6677567,ISTYLE,I-27 THE HORSEFAIR,MEDFORD,M17 8BN,NLD,ESP,MPL,MPL,CT6,1,1.30E+22,MCC,1,54321,YB,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,949,826,840,,,,,IJKL123RF0126,183,,,77445,4321,65789,
54321000134,0,987656800,878909901,40c8-abe2-17c0d09ecd109,6544,3065275831310918061,M,1240,2025-06-17 10:00:41,9,1,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),20,0,0,16.53,4.41,16.53,0.266787659,1,5/03/2024 7:12,0,S,9,,200,,5311,,,5.13E+21,,7654,4.12E+11,,,12300009,2.57E+14,Alexander McQueen,I-27 THE HORSEFAIR,KUWAIT,W12 7SL,SAU,ESP,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,682,826,840,,,,,,184,,,77445,7654,65789,
54321000135,876544,987656801,878909902,40c8-abe2-17c0d09ecd110,6544,3065275831310918062,M,1240,2025-06-17 12:00:41,1,1,11,MyProduct-Mastercard Credit,; match (1b) on tok+de38,20,0,0,4,4,15,1,3.75,6/03/2024 6:52,0,S,9,,200,,5311,,,5.13E+21,87694,7654,4.12E+11,190658,,,5.27E+14,JUMBO\LIMITED LLC,I-27 THE HORSEFAIR,MADRID,W12 7SL,CA,ESP,MDW,MDW,CT6,1,1.30E+22,MCC,1,12345,YB,6/03/2024,5,,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,Y,,840,826,840,,,,,EFGH123RF0127,185,,,77445,7654,65789,
54321000136,876545,987656802,878909903,40c8-abe2-17c0d09ecd111,6544,3065275831310918063,M,1240,2025-06-17 12:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-0.01,0,-0.01,0,1,5/03/2024 19:11,0,1,9,,200,,5311,,,5.13E+21,,87654,4.12E+11,190659,,12300009,1000700331,Aimn official store,"UNIT B, BARTON SQUARE",BARCELONA,OX1 1PE,SAU,ESP,MDW,MDW,MAN,1,1.30E+22,MCC,4,826001,PZ,6/03/2024,5,0,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,N,,682,826,840,,,,,EFGH123RF0128,186,,,77445,87654,65789,
54321000137,876546,987656803,878909904,40c8-abe2-17c0d09ecd112,6544,3065275831310918064,M,1240,2025-06-17 12:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-3.5,-0.93,-3.5,0.265714286,1,5/03/2024 7:06,1,M,0,0,200,,5311,,,5.13E+21,,9876,4.12E+11,190660,201,12300078,2.06E+11,Fifa.com,UNIT SU2231 & SU3231,TOLEDO,B24 9FP,SAU,ESP,MDW,MDW,POI,1,1.30E+22,MCC,4,826001,PP,6/03/2024,4,,,N,N,N,,,,1,6/03/2024,4,6/03/2024,1,N,,682,826,840,,,,,EFGH123RF0129,187,,,77445,9876,65789,
54321000138,876547,987656804,878909905,40c8-abe2-17c0d09ecd113,6955,3065275831310918065,M,1240,2025-06-17 12:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-15,-4,-15,0.266666667,1,3/03/2024 19:28,1,C,1,0,200,1401,5311,,,5.13E+21,873888,8765,4.12E+11,190661,,63512345,2.06E+11,Pradaamerlia,UNIT SU2231 & SU3231,VAUXHALL,M60 1TX,GBR,ESP,MPL,MPL,POI,1,1.30E+22,MCC,4,826001,PP,6/03/2024,6,0,,N,N,N,,,,1,6/03/2024,6,6/03/2024,1,N,,682,826,840,,,,,EFGH123RF0130,188,,,77445,8765,65789,
54321000139,876548,987656805,878909906,40c8-abe2-17c0d09ecd114,6955,3065275831310918066,M,1240,2025-06-17 14:00:41,1,-1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,0,0,0,-1.7,-4.52,-16.95,2.658823529,9.970588235,5/03/2024 17:09,1,M,5,,200,1401,5967,,,7.53E+22,989789,12345,4.12E+11,190662,,,2.06E+11,honda.com/au,OXFORD WESTGATE,BRISTOL,M60 1TX,GBR,BHR,MPL,MPL,POI,1,1.30E+22,MCC,2,60001,YQ,6/03/2024,3,,,N,N,N,,,,1,6/03/2024,3,6/03/2024,1,Y,,48,826,840,,,,,EFGH123RF0131,189,,,77445,12345,65789,
54321000140,876549,987656806,878909907,40c8-abe2-17c0d09ecd115,6955,3065275831310918067,M,1240,2025-06-17 14:00:41,1,-1,11,MyProduct-Mastercard Credit,1400=Not previously authorized; match (1a) on tok+de38,0,30,0,-60,-16,-60,0.266666667,1,5/03/2024 14:39,0,S,6,1,200,1400,5967,,,7.53E+22,,87654,4.12E+11,190663,,7654567,2.06E+11,CHEWTON GLEN HOTELS LI,UNIT 1B - 3A,GLASGOW,M60 1TX,GBR,SAU,MPL,MPL,CT6,1,1.30E+22,MCC,4,826001,PQ,7/03/2024,1,,,N,N,N,,,,1,7/03/2024,1,7/03/2024,1,N,,682,826,840,,,,,EFGH123RF0132,190,,,77445,87654,65789,
54321000141,876550,987656807,878909908,40c8-abe2-17c0d09ecd116,6955,3065275831310918068,M,1240,2025-06-17 14:00:41,1,-1,7,MyProduct-Mastercard Debit,"1404=Previously approved auth—partial amt, final clear; match (1a) on tok+de38",0,0,0,-21.29,-5.8,-21.74,0.27242837,1.021136684,5/03/2024 17:27,0,S,9,,200,1404,5817,,,2.68E+21,,9876,4.12E+11,190664,,,2.06E+11,GAME KING LLC,,BOSTON,784,GBR,ARE,MDS,MDS,CT6,1,1.30E+22,DMC,2,60001,YA,6/03/2024,5,,,N,N,N,,,,1,6/03/2024,5,6/03/2024,1,Y,,784,826,840,,,,,EFGH123RF0133,191,,,77445,9876,65789,
54321000142,876551,987656808,878909909,40c8-abe2-17c0d09ecd117,6955,3065275831310918069,M,1240,2025-06-17 14:00:41,1,-1,7,MyProduct-Mastercard Debit,; match (1a) on tok+de38,0,0,0,-26.66,-26.66,-99.99,1,3.750562641,5/03/2024 16:25,0,S,9,,200,,5817,,,2.68E+21,16738,8765,4.12E+11,190665,0,ABCD12K2,DDFGSJKKTLR8909,JKL.EU,,ADOBE.LY/BILL,100,GBR,KEN,MDS,MDS,CT6,1,1.30E+22,DMC,2,60001,YA,6/03/2024,2,,,N,N,N,,,,1,6/03/2024,2,6/03/2024,1,Y,,840,826,840,,,,,EFGH123RF0134,192,,,77445,8765,65789,
54321000143,876552,987656809,878909910,40c8-abe2-17c0d09ecd118,6955,3065275831310918070,M,1240,2025-06-17 14:00:41,1,-1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,0,0,0,-10,-2.67,-10,0.267,1,5/03/2024 10:13,1,M,9,0,200,,5817,,,2.68E+21,,7654,4.12E+11,190666,101,89098888,2.06E+11,SAMSUNG.com,,APPLE.COM/BIL,,SAU,SAU,MPL,MPL,POI,1,1.30E+22,MCC,4,826001,PP,6/03/2024,4,0,,N,N,N,,,,1,6/03/2024,4,6/03/2024,1,N,,682,826,840,,,,,,193,,,77445,7654,65789,
Visa
This section specifies the format of a Presentment report when the scheme is Visa. The Visa Presentment report is currently running v2.0 , v3.0 and v4.0. If you're using Visa, check which version you're using.
All new clients should integrate with the latest report version
Visa v2.0
ImportantThis report version (Visa v2.0) will be discontinued by 1st November 2025.
You can refer to our Migration guidelines for helpful information on how you can upgrade from v2.0 to v4.0.
Official communication was sent to you on/around 1st November 2024.
Below are the data fields and format of the Visa v2.0 Presentments report.
Click here to view the complete list of fields
Field | Sample Data | Field Description | Source |
|---|---|---|---|
PY__RID_Settlement | 68221000001 | Unique Id for settlement generated by paymentology | Paymentology |
PY__RID_Authorization | 1764498 | Unique ID for authorisation transaction (this may have value 0 if no Authorisation involved in the transaction) | Paymentology |
PY__Account_ID | 257521707 | Unique Account identifier in the Paymentology Banking.Live platform | Paymentology |
PY__Account_Currency | 826 | Numeric currency code of the account that performed the transaction | Paymentology |
PY__Token | 278368604 | Public token generated by Paymentology to replace PAN | Paymentology |
PY__Account_External_Reference | O | Unique identifier for the account created by the client in the Paymentology Banking.Live platform. May be used to populate the account identifier in the client core banking platform to ensure account association | Paymentology |
PY__Transaction_ID | 1900688818 | Unique Id for transaction generated by paymentology | Paymentology |
PY__Network | VISA | Indicates the Network provider. M = Mastercard, VISA = VISA | Paymentology |
PY__Created_Date | 2021-09-23 | Indicates the time at which Paymentology processed the file. Format: YYYY-MM-DD | Paymentology |
PY__Matched_Status | 1 | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have value ranging from 1 to 9 . 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform . | Paymentology |
PY__Product_ID | 912 | Unique Identifier for the product in the Paymentology Banking.Live platform | Paymentology |
PY__Product_Name | Derayah | Product name in the Paymentology Banking.Live platform | Paymentology |
PY__Settlement_Note | ; match (1b) on tok+de38 | "Position for Paymentology to assign notes that may be of relevance to client, relating to the presentment Provisional field, reserved for future use" | Paymentology |
Transaction_Code | 5 | Two digit code determining the type of transaction | VISA |
Transaction_Code_Qualifier | 0 | "The field must contain one of the following values: | VISA |
Acquirer_Reference_Number | 700000011190 | A 23-digit identification number assigned by the acquirer. | VISA |
Acquirer_Business_ID | 0 | Contains the Visa-assigned business ID of the acquirer that signed the merchant for processing purchase or mail/phone order transactions. In this case, the acquirer is referred to as the Merchant Sponsor. The entry must be numeric | VISA |
Purchase_Date | 2021-09-22 | Date the purchase transaction was made. Format: YYYY-MM-DD | VISA |
Destination_Amount | -5000.00 | "Identifies the submitted transaction amount in the currency that is appropriate to the destination endpoint.It is the billing amount." | VISA |
Destination_Currency_Code | 826 | The currency type presented to the member on incoming transactions.It is the billing currency | VISA |
Source_Amount | -5000.00 | The purchase value in transaction currency | VISA |
Source_Currency_Code | 826 | Currency code used in the transaction | VISA |
Merchant_Name | ACQUIRER NAME | Name of the merchant in the original transaction | VISA |
Merchant_City | CITY NAME | City of merchant | VISA |
Merchant_Country_Code | US | country code of merchant | VISA |
Merchant_Category_Code | 5999 | Two character country code where the Visa transaction occurred | VISA |
Merchant_ZIP_Code | 0 | Postal code of the merchant where the transaction took place | VISA |
Merchant_State_Province_Code | NY | If the Merchant Country Code is US or CA, this field will contain a valid U.S. State Code or Canadian Province Code, respectively. | VISA |
Settlement_Flag | 0 | "Indicates the service used for settlement | VISA |
Authorization_Characteristics_Indicator | 9 | "Code used by the acquirer to request CPS qualification | VISA |
Authorization_Code | 103507 | "Code that an issuer, its authorizing processor, or Stand-In Processing (STIP) provides to indicate approval of a transaction" | VISA |
Cardholder_ID_Method | 1 | "Indicates method used to identify cardholder (e.g., signature, Personal Identification Number (PIN), etc.). The field must contain a space or 1 through 4." | VISA |
POS_Entry_Mode | 0 | "A V.I.P. System field indicating the method by which a point-of-transaction terminal obtains and transmits the cardholder information necessary to complete a Transaction. | VISA |
Central_Processing_Date | 2021-09-23 | The date that BASE II processes this transaction or item. Format: YYYY-MM-DD | VISA |
Member_Message_Text | This is a sample message | This field is used to send text messages | VISA |
Card_Acceptor_ID | C123456 | Code that identifies the card acceptor operating the POS terminal. | VISA |
Terminal_ID | T789012 | Code that identifies the card acceptor terminal or ATM. | VISA |
Interface_Trace_Number | 123456789 | Reserved field. | VISA |
AVS_Response_Code | M | Contains the response to an Address Verification Service (AVS) request, indicating matches or discrepancies between addresses and ZIP codes. | VISA |
Authorization_Source_Code | Online | "Indicates whether authorization was obtained and the source of the authorization." | VISA |
Transaction_Code_Qualifier__TCR3 | 0 | "This field must contain one of the following values: | VISA |
Transaction_Component_Sequence_Number__TCR3 | VISA | ||
Fast_Funds_Indicator | "VIC will return the transaction if any non-space value is present on an Original Transaction." | VISA | |
Business_Format_Code | Code indicating the type of business that is applicable to this transaction. | VISA | |
Business_Application_ID | "This field provides additional information regarding the usage and application of the transaction" | VISA | |
Source_of_Funds | "This field should contain one of the following values: | VISA | |
Payment_Reversal_Reason_Code | "This field should contain one of the following values: | VISA | |
Sender_Reference_Number | "This field will contain a transaction reference number that is provided by the originator and can be used to uniquely identify the sender" | VISA | |
Sender_Account_Number | "This field will contain the sender's card token from which the funds are to be taken." | VISA | |
Sender_Name | "This field will contain the name of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_Address | "This field will contain the address of the person or entity for the account from which funds are to be taken" | VISA | |
Sender_City | "This field will contain the city of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_State | "This field will contain the geographical state or province of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_Country | "This field will contain the country of the person or entity for the account from which funds are to be taken" | VISA | |
Transaction_Code_Qualifier__TCR5 | 0 | "This field must contain one of the following values: | VISA |
Transaction_Component_Sequence_Number__TCR5 | 5 | Sequence no of the transaction component | VISA |
Transaction_Identifier | 316190801000252 | "A unique value that Visa assigns to each transaction and returns to the acquirer in the authorization response." | VISA |
Authorized_Amount | 500000 | "Amount the issuer originally authorized. The entry must be numeric. For CPS original draft transactions and their reversals, this entry may not be zeros. CPS credit vouchers and their reversals must contain zeros in this field." | VISA |
Authorization_Currency_Code | 826 | Currency code of the authorized source amount | VISA |
Interchange_Fee_Amount | 0.00 | "Specifies the interchange fee amount (in the settlement currency of the member) calculated by Visa for this transaction" | VISA |
Interchange_Fee_Sign | "Specifies if the interchange fee amount is a credit or a debit for the receiving member. | VISA | |
Source_Currency_to_Base_Currency_Exchange_Rate | 0 | "Specifies the currency exchange rate applied to this transaction when Visa converts the source amount to the transaction amount in the destination currency" | VISA |
Base_Currency_to_Destination_Currency_Exchange_Rate | 0 | "Specifies the currency exchange rate applied to this transaction when Visa converts the source amount to the transaction amount in the destination currency" | VISA |
Optional_Issuer_ISA_Amount | 0.00 | "This ISO-defined field can be used for any charge type or any fee applied to a transaction. Currently, Visa uses this field to carry optional International Service Assessment (ISA) data for issuers in the LAC region" | VISA |
Product_ID | Product identifier code | VISA | |
CVV2_Result_Code | "Card Verification Value 2 (CVV2) is the verification result for card-not-present transactions and also for card-present CVV2 verification-only requests" | VISA |
Visa v3.0
ImportantThis report version (Visa v3.0) will be discontinued by 1st November 2025.
You can refer to our Migration guidelines for helpful information on how you can upgrade from v3.0 to v4.0.
Official communication was sent to you on/around 1st November 2024.
Notable changesBelow are the notable differences between v2.0 and v3.0:
- Addition of a new field
Usage_Code
Click here to view the complete list of fields and a sample file
Field | Sample Data | Field Description | Source |
|---|---|---|---|
PY__RID_Settlement | 234567000001 | Unique Id for settlement generated by Paymentology | Paymentology |
PY__RID_Authorization | 2345678 | Unique ID for authorisation transaction (this may have value 0 if no Authorisation involved in the transaction) | Paymentology |
PY__Account_ID | 987654321 | Unique Account identifier in the Paymentology Banking.Live platform | Paymentology |
PY__Account_Currency | 400 | Numeric currency code of the account that performed the transaction | Paymentology |
PY__Token | 912345678 | Public token generated by Paymentology to replace PAN | Paymentology |
PY__Account_External_Reference | 10101234567890 | Unique identifier for the account created by the client in the Paymentology Banking.Live platform. May be used to populate the account identifier in the client core banking platform to ensure account association | Paymentology |
PY__Transaction_ID | 2012345678901000000 | Unique Id for transaction generated by paymentology | Paymentology |
PY__Network | VISA | Indicates the Network provider. M = Mastercard, VISA = VISA | Paymentology |
PY__Created_Date | 2023/06/08 | Indicates the date on which Paymentology processed the file | Paymentology |
PY__Matched_Status | 1 | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have value ranging from 1 to 9 . 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform . | Paymentology |
PY__Product_ID | 123 | Unique Identifier for the product in the Paymentology Banking.Live platform | Paymentology |
PY__Product_Name | Multi Currency Bin | Product name in the Paymentology Banking.Live platform | Paymentology |
PY__Settlement_Note | Position for Paymentology to assign notes that may be of relevance to client, relating to the presentment Provisional field, reserved for future use | Paymentology | |
Transaction_Code | 5 | Two digit code determining the type of transaction | VISA |
Transaction_Code_Qualifier | 0 | "The field must contain one of the following values: | VISA |
Usage_Code | Indicates whether this is the first or second presentment. The entry will be 1 on original transactions | VISA | |
Acquirer_Reference_Number | 70000001234500000000789 | A 23-digit identification number assigned by the acquirer. | VISA |
Acquirer_Business_ID | 0 | Contains the Visa-assigned business ID of the acquirer that signed the merchant for processing purchase or mail/phone order transactions. In this case, the acquirer is referred to as the Merchant Sponsor. The entry must be numeric | VISA |
Purchase_Date | 2023/06/07 | Date the purchase transaction was made. | VISA |
Destination_Amount | -5000.00 | "Identifies the submitted transaction amount in the currency that is appropriate to the destination endpoint.It is the billing amount." | VISA |
Destination_Currency_Code | 826 | The currency type presented to the member on incoming transactions.It is the billing currency | VISA |
Source_Amount | -5000.00 | The purchase value in transaction currency | VISA |
Source_Currency_Code | 826 | Currency code used in the transaction | VISA |
Merchant_Name | Name of a physical or online store | Name of the merchant in the original transaction | VISA |
Merchant_City | Gotham City | City of merchant | VISA |
Merchant_Country_Code | US | Country code of merchant | VISA |
Merchant_Category_Code | 5999 | Four digit number that describes the type of business of the merchant | VISA |
Merchant_ZIP_Code | 1234 | Postal code of the merchant where the transaction took place | VISA |
Merchant_State_Province_Code | NY | If the Merchant Country Code is US or CA, this field will contain a valid U.S. State Code or Canadian Province Code, respectively. | VISA |
Settlement_Flag | 0 | "Indicates the service used for settlement | VISA |
Authorization_Characteristics_Indicator | 9 | "Code used by the acquirer to request CPS qualification | VISA |
Authorization_Code | 103507 | "Code that an issuer, its authorizing processor, or Stand-In Processing (STIP) provides to indicate approval of a transaction" | VISA |
Cardholder_ID_Method | 1 | "Indicates method used to identify cardholder (e.g., signature, Personal Identification Number (PIN), etc.). The field must contain a space or 1 through 4." | VISA |
POS_Entry_Mode | 0 | "A V.I.P. System field indicating the method by which a point-of-transaction terminal obtains and transmits the cardholder information necessary to complete a Transaction. | VISA |
Central_Processing_Date | 16/03/2022 | The date that BASE II processes this transaction or item. | VISA |
Member_Message_Text | This is a sample message | This field is used to send text messages | VISA |
Card_Acceptor_ID | C123456 | Code that identifies the card acceptor operating the POS terminal. | VISA |
Terminal_ID | T012345 | Code that identifies the card acceptor terminal or ATM. | VISA |
Interface_Trace_Number | 123456789 | Reserved field. | VISA |
AVS_Response_Code | M | Contains the response to an Address Verification Service (AVS) request, indicating matches or discrepancies between addresses and ZIP codes. | VISA |
Authorization_Source_Code | Online | "Indicates whether authorization was obtained and the source of the authorization." | VISA |
Transaction_Code_Qualifier__TCR3 | 0 | "This field must contain one of the following values: | VISA |
Transaction_Component_Sequence_Number__TCR3 | VISA | ||
Fast_Funds_Indicator | "VIC will return the transaction if any non-space value is present on an Original Transaction." | VISA | |
Business_Format_Code | Code indicating the type of business that is applicable to this transaction. | VISA | |
Business_Application_ID | "This field provides additional information regarding the usage and application of the transaction" | VISA | |
Source_of_Funds | "This field should contain one of the following values: | VISA | |
Payment_Reversal_Reason_Code | "This field should contain one of the following values: | VISA | |
Sender_Reference_Number | "This field will contain a transaction reference number that is provided by the originator and can be used to uniquely identify the sender" | VISA | |
Sender_Account_Number | "This field will contain the sender's card token from which the funds are to be taken." | VISA | |
Sender_Name | "This field will contain the name of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_Address | "This field will contain the address of the person or entity for the account from which funds are to be taken" | VISA | |
Sender_City | "This field will contain the city of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_State | "This field will contain the geographical state or province of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_Country | "This field will contain the country of the person or entity for the account from which funds are to be taken" | VISA | |
Transaction_Code_Qualifier__TCR5 | 0 | This field must contain one of the following values: | VISA |
Transaction_Component_Sequence_Number__TCR5 | 5 | Sequence no of the transaction component | VISA |
Transaction_Identifier | 312340801000789 | A unique value that Visa assigns to each transaction and returns to the acquirer in the authorization response. | VISA |
Authorized_Amount | 500000 | "Amount the issuer originally authorized. The entry must be numeric. For CPS original draft transactions and their reversals, this entry may not be zeros. CPS credit vouchers and their reversals must contain zeros in this field." | VISA |
Authorization_Currency_Code | 826 | Currency code of the authorized source amount | VISA |
Interchange_Fee_Amount | 0.00 | "Specifies the interchange fee amount (in the settlement currency of the member) calculated by Visa for this transaction" | VISA |
Interchange_Fee_Sign | "Specifies if the interchange fee amount is a credit or a debit for the receiving member. | VISA | |
Source_Currency_to_Base_Currency_Exchange_Rate | 0 | "Specifies the currency exchange rate applied to this transaction when Visa converts the source amount to the transaction amount in the destination currency" | VISA |
Base_Currency_to_Destination_Currency_Exchange_Rate | 0 | "Specifies the currency exchange rate applied to this transaction when Visa converts the source amount to the transaction amount in the destination currency" | VISA |
Optional_Issuer_ISA_Amount | 0.00 | "This ISO-defined field can be used for any charge type or any fee applied to a transaction. Currently, Visa uses this field to carry optional International Service Assessment (ISA) data for issuers in the LAC region" | VISA |
Product_ID | Product identifier code | VISA | |
CVV2_Result_Code | "Card Verification Value 2 (CVV2) is the verification result for card-not-present transactions and also for card-present CVV2 verification-only requests" | VISA |
v3.0 sample file
PY__RID_Settlement,PY__RID_Authorization,PY__Account_ID,PY__Account_Currency,PY__Token,PY__Account_External_Reference,PY__Transaction_ID,PY__Network,PY__Created_Date,PY__Matched_Status,PY__Product_ID,PY__Product_Name,PY__Settlement_Note,Transaction_Code,Transaction_Code_Qualifier,Usage_Code,Acquirer_Reference_Number,Acquirer_Business_ID,Purchase_Date,Destination_Amount,Destination_Currency_Code,Source_Amount,Source_Currency_Code,Merchant_Name,Merchant_City,Merchant_Country_Code,Merchant_Category_Code,Merchant_ZIP_Code,Merchant_State_Province_Code,Settlement_Flag,Authorization_Characteristics_Indicator,Authorization_Code,Cardholder_ID_Method,POS_Entry_Mode,Central_Processing_Date,Member_Message_Text,Card_Acceptor_ID,Terminal_ID,Interface_Trace_Number,AVS_Response_Code,Authorization_Source_Code,Transaction_Code_Qualifier__TCR3,Transaction_Component_Sequence_Number__TCR3,Fast_Funds_Indicator,Business_Format_Code,Business_Application_ID,Source_of_Funds,Payment_Reversal_Reason_Code,Sender_Reference_Number,Sender_Account_Number,Sender_Name,Sender_Address,Sender_City,Sender_State,Sender_Country,Transaction_Code_Qualifier__TCR5,Transaction_Component_Sequence_Number__TCR5,Transaction_Identifier,Authorized_Amount,Authorization_Currency_Code,Interchange_Fee_Amount,Interchange_Fee_Sign,Source_Currency_to_Base_Currency_Exchange_Rate,Base_Currency_to_Destination_Currency_Exchange_Rate,Optional_Issuer_ISA_Amount,Product_ID,CVV2_Result_Code
54321000123,0,987656789,682,878909890,40c8-abe2-17c0d09ecd98,8.43E+18,VISA,6/03/2024 10:00,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),5,1,,5.52E+22,10000123,4/03/2024 17:39,9.94,400,9.94,400,My Company.com,HK ,AU ,7311,0,WA ,0,E,,1,1,6/03/2024,jesjkerkknfk reference,80001234,789898324,4011 0,,,0,,,,,,,,,,,,,,2,5,4.12E+14,994,400,0.02,C,0.266599598,1,0,F ,
54321000124,765432,987656790,566,878909891,40c8-abe2-17c0d09ecd99,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,5.52E+22,10000124,5/03/2024 0:00,-4.12,400,-1700,826,Lush living Auckland NZL,HK ,ES ,7311,0,WA ,0,E,190654,2,5,6/03/2024,,2.57E+14,689899,4015 0,,,0,,,,,,,,,,,,,,2,5,4.12E+14,170000,826,0.08,C,0.000647059,0.002423529,0,F ,
54321000125,765433,987656791,682,878909892,40c8-abe2-17c0d09ecd100,8.43E+18,VISA,6/03/2024 14:55,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1b) on tok+de38,5,1,,5.52E+22,10000125,6/03/2024 0:00,3.99,400,3.99,400,GOT MONEY CA AB Home Town GBR,LONDON,CY ,7311,10004,TX ,0,E,190655,3,7,6/03/2024,,2.57E+14,,4014 0,C,,0,,,,AA,,,,,,,,,,2,5,4.12E+14,399,400,0.2,C,0.26566416,1,0,N ,P
54321000126,765434,987656792,566,878909893,40c8-abe2-17c0d09ecd101,8.43E+18,VISA,6/03/2024 4:00,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,5.55E+22,10000126,5/03/2024 0:00,-4.12,400,-1700,978,Givememore Auckland NZL,HAMPSHIRE,NL ,5734,10004, ,0,N,190656,4,10,6/03/2024,,2.57E+14,,4016 0,,,0,,Y,,,,,,,,,,,,2,5,4.12E+14,170000,978,2.26,C,0.000647059,0.002423529,0,N ,
54321000127,765435,987656793,840,878909894,40c8-abe2-17c0d09ecd102,8.43E+18,VISA,6/03/2024 4:00,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,5.55E+22,10000127,5/03/2024 0:00,-22.28,400,-5.94,826,Amazon Prime Amzn.com/bill USA,Riyadh,AU ,5734,60612,WA ,0,N,190657,4,,6/03/2024,,2.57E+14,,4011 0,,5,0,,Y,,,,,,,,,,,,2,5,4.12E+14,594,826,0.79,C,1,3.750841751,0,N ,
54321000128,0,987656794,682,878909895,40c8-abe2-17c0d09ecd103,8.43E+18,VISA,6/03/2024 14:55,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),5,1,,6.55E+22,10000128,5/03/2024 7:12,16.53,400,16.53,400,APPLE.COM/BILL ITUNES.COM IRL,Dubai,ES ,5945,10004,WA ,0,N,,4,5,6/03/2024,,2.57E+14,,4015 0,,6,1,,Y,CR,,,,,,,,,,,0,5,4.12E+14,1653,400,0.62,C,0.266787659,1,0,N ,
54321000129,765436,987656795,840,878909896,40c8-abe2-17c0d09ecd104,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,8.54E+22,10000129,5/03/2024 0:00,-135.14,400,-36.03,840,Google YouTube River View CAL,Westland,CY ,5734,10004,CA ,0,N,898098,4,7,6/03/2024,,2.57E+14,89689698234,4014 0,N,7,0,,,,FD,,,,,,,,,,0,5,4.12E+14,3603,840,0.62,C,1,3.750763253,0,N ,
54321000130,765437,987656796,840,878909897,40c8-abe2-17c0d09ecd105,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,8.26E+22,10000130,5/03/2024 0:00,-22.28,400,-5.94,840,Alloallo Melbourne AUS,RIYADH,NL ,5734,0,CA ,0,N,909090,4,10,6/03/2024,,2.57E+14,,4016 0,,9,2,3,Y,,,,,,,,,,,,0,5,4.12E+14,594,840,0.04,C,1,3.750841751,0,N ,M
54321000131,0,987656797,840,878909898,40c8-abe2-17c0d09ecd106,8.43E+18,VISA,6/03/2024 14:55,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),5,1,,8.26E+22,10000131,5/03/2024 18:09,299.46,400,79.84,124,GOOGLE *YouTube ,google.com,US ,5818,0, ,0,N,,4,1,6/03/2024,,2.57E+14,,4011 0,,,0,,,,FD,,,,,,,,,,0,5,4.12E+14,7984,124,0.67,C,1,3.750751503,0,N ,M
54321000132,654321,987656798,682,878909899,40c8-abe2-17c0d09ecd107,8.43E+18,VISA,7/03/2024 1:20,1,11,MyProduct-Mastercard Credit,1400=Not previously authorized; match (1a) on tok+de38,5,1,,7.27E+22,10000132,6/03/2024 14:44,-90,400,-90,400,BRUNELLO CUCINELLI,London,US ,5818,10004,IL ,0,N,667788,4,1,7/03/2024,6.76E+11,65613598L483,,4015 0,,,0,,,,,,,,,,,,,,0,5,4.12E+14,9000,400,0.08,C,0.266666667,1,0,F ,M
54321000133,876543,987656799,949,878909900,40c8-abe2-17c0d09ecd108,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,5,1,,7.27E+22,10000133,5/03/2024 14:38,-34.3,400,-285.36,124,ISTYLE,MEDFORD,US ,5661,75216,FL ,0,N,998877,4,1,6/03/2024,,6677567,89799,4014 0,S,B,0,,,,PS,2,,,,,,,,,0,5,4.12E+14,28536,124,0.74,C,0.03206476,0.120199047,0,F ,
54321000134,0,987656800,682,878909901,40c8-abe2-17c0d09ecd109,8.43E+18,VISA,6/03/2024 14:55,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),6,2,,5.13E+21,10000134,5/03/2024 7:12,16.53,400,16.53,400,Alexander McQueen,KUWAIT,US ,5311,90245,FL ,0,N,,1,7,6/03/2024,,2.57E+14,,4016 0,U,B,0,,,CR,MD,,,,,,,,,,0,5,4.12E+14,1653,400,0.13,C,0.266787659,1,0,N ,
54321000135,876544,987656801,840,878909902,40c8-abe2-17c0d09ecd110,8.43E+18,VISA,6/03/2024 14:55,1,11,MyProduct-Mastercard Credit,; match (1b) on tok+de38,6,2,,5.13E+21,10000135,6/03/2024 6:52,15,400,4,978,JUMBO\LIMITED LLC,MADRID,US ,5311,80401, ,0,N,190658,1,5,6/03/2024,,5.27E+14,,4011 0,C,B,0,,,,,,,,,,,,,,0,5,4.12E+14,400,978,0.13,D,1,3.75,0,N ,
54321000136,876545,987656802,682,878909903,40c8-abe2-17c0d09ecd111,8.43E+18,VISA,6/03/2024 14:55,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,6,2,,5.13E+21,10000136,5/03/2024 19:11,-0.01,400,-0.01,400,Aimn official store,BARCELONA,CA ,5311,4101,MN ,0,N,190659,2,1,6/03/2024,hjjjg-788239912,1000700331,,4015 0,,,0,3,,,PS,,,,,,,,,,0,5,4.12E+14,1,400,0.7,D,0,1,0,N ,
54321000137,876546,987656803,682,878909904,40c8-abe2-17c0d09ecd112,8.43E+18,VISA,6/03/2024 10:00,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,6,2,,5.13E+21,10000137,5/03/2024 7:06,-3.5,400,-3.5,400,Fifa.com,TOLEDO,SG ,5311,0,MN ,0,N,190660,2,1,6/03/2024,,2.06E+11,34,4014 0,,,0,,,,,,,,,,,,,,0,5,4.12E+14,350,400,0.04,C,0.265714286,1,0,N ,N
54321000138,6955895,457964803,840,960565442,7898798090,2.59E+18,VISA,6/03/2024,1,12,MyProduct-Mastercard Credit,; match (1e) on tok+de38+mcc ,6,0,1,5.13E+21,10000138,3/03/2024 19:28,-15,400,-15,400,Pradaamerlia,VAUXHALL,US ,5311,60176,WA ,0,N,190661,4,1,6/03/2024, ,2.06E+11,10140001,4016 0,,9,0,,,,WT,,,,,,,,,,0,5,4.12E+14,1500,400,2.21,D,0.266666667,1,0,N ,N
54321000139,7952961,248296493,978,354801751,9.00E+11,2.62E+18,VISA,6/03/2024,1,12,MyProduct-Mastercard Credit,; match (1a) on tok+de38+de62_2 ,7,0,1,7.53E+22,10000139,5/03/2024 17:09,-16.95,400,-1.7,978,honda.com/au,BRISTOL,ES ,5967,60611,WA ,0,E,190662,2,7,6/03/2024, ,2.06E+11,204,4011 0,N,V,0,,,,WT,,,,,,,,,,0,5,4.12E+14,170,978,0.05,D,2.658823529,9.970588235,0,N ,
54321000140,7933290,781072871,400,338120243,9.98E+14,2.62E+18,VISA,6/03/2024,4,14,MyProduct-Mastercard Credit,; match (4a) : reversal settlement.,25,0,1,7.53E+22,10000140,5/03/2024 14:39,-60,400,-60,400,CHEWTON GLEN HOTELS LI,GLASGOW,CY ,5967,32603,WA ,0,N,190663,4,1,7/03/2024, ,2.06E+11,70000946,4012 0,,V,0,,,,WT,,,,,,,,,,0,5,4.12E+14,6000,400,0.21,D,0.266666667,1,0,N ,M
54321000141,6683465,755429020,840,679138802,1.00E+13,2.58E+18,VISA,6/03/2024,1,12,MyProduct-Mastercard Credit,; match (1e) on tok+de38+mcc ,5,0,9,2.68E+21,10000141,5/03/2024 17:27,-21.74,400,-21.29,978,GAME KING LLC,BOSTON,NL ,5817,33133,WA ,0,N,190664,4,1,6/03/2024, ,2.06E+11, ,4013 0,,V,0,,,,,,,,,,,,,,0,5,4.12E+14,2129,978,0.22,C,0.27242837,1.021136684,0,F ,
54321000142,876551,987656808,840,878909909,40c8-abe2-17c0d09ecd117,8.43E+18,VISA,6/03/2024 4:00,1,7,MyProduct-Mastercard Credit,; match (1a) on tok+de38,5,0,,2.68E+21,10000142,5/03/2024 16:25,-99.99,400,-26.66,826,JKL.EU,ADOBE.LY/BILL,US ,5817,33133,,0,E,190665,3,7,6/03/2024,,DDFGSJKKTLR8909,,4014 0,,,2,,,,,,,,,,,,,,2,5,4.12E+14,2666,826,0.13,C,1,3.750562641,0,F ,
54321000143,876552,987656809,682,878909910,40c8-abe2-17c0d09ecd118,8.43E+18,VISA,6/03/2024 10:00,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,5,0,,2.68E+21,10000143,5/03/2024 10:13,-10,400,-10,400,SAMSUNG.com,APPLE.COM/BIL,,5817,2903,,0,E,190666,3,7,6/03/2024,,2.06E+11,889989,4015 0,S,E,2,,,,AA,,,,,,,,,,2,5,4.12E+14,1000,400,0.93,C,0.267,1,0,N ,P
Visa v4.0
Notable changesBelow are the notable differences between v3.0 and v4.0:
- Addition of a new field
PY__Transaction_Type.
Below are the data fields and format of the Visa v4.0 Presentment report.
Field | Sample Data | Field Description | Source |
|---|---|---|---|
PY__RID_Settlement | 234567000001 | Unique Id for settlement generated by Paymentology | Paymentology |
PY__RID_Authorization | 2345678 | Unique ID for authorisation transaction (this may have value 0 if no Authorisation involved in the transaction) | Paymentology |
PY__Account_ID | 987654321 | Unique Account identifier in the Paymentology Banking.Live platform | Paymentology |
PY__Account_Currency | 400 | Numeric currency code of the account that performed the transaction | Paymentology |
PY__Token | 912345678 | Public token generated by Paymentology to replace PAN | Paymentology |
PY__Account_External_Reference | 10101234567890 | Unique identifier for the account created by the client in the Paymentology Banking.Live platform. May be used to populate the account identifier in the client core banking platform to ensure account association | Paymentology |
PY__Transaction_ID | 2012345678901000000 | Unique Id for transaction generated by paymentology | Paymentology |
PY__Network | VISA | Indicates the Network provider. M = Mastercard, VISA = VISA | Paymentology |
PY__Created_Date | 2023/06/08 | Indicates the date on which Paymentology processed the file | Paymentology |
PY__Matched_Status | 1 | Indicates the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. It can have value ranging from 1 to 9 . 1 = perfect match and 9 = no match achieved. If a value of 0 is present please raise a ticket on our Customer Support Platform . | Paymentology |
PY__Product_ID | 123 | Unique Identifier for the product in the Paymentology Banking.Live platform | Paymentology |
PY__Product_Name | Multi Currency Bin | Product name in the Paymentology Banking.Live platform | Paymentology |
PY__Settlement_Note | Position for Paymentology to assign notes that may be of relevance to client, relating to the presentment Provisional field, reserved for future use | Paymentology | |
Transaction_Code | 5 | Two digit code determining the type of transaction | VISA |
Transaction_Code_Qualifier | 0 | "The field must contain one of the following values: | VISA |
Usage_Code | Indicates whether this is the first or second presentment. The entry will be 1 on original transactions | VISA | |
Acquirer_Reference_Number | 70000001234500000000789 | A 23-digit identification number assigned by the acquirer. | VISA |
Acquirer_Business_ID | 0 | Contains the Visa-assigned business ID of the acquirer that signed the merchant for processing purchase or mail/phone order transactions. In this case, the acquirer is referred to as the Merchant Sponsor. The entry must be numeric | VISA |
Purchase_Date | 2023/06/07 | Date the purchase transaction was made. | VISA |
Destination_Amount | -5000.00 | "Identifies the submitted transaction amount in the currency that is appropriate to the destination endpoint.It is the billing amount." | VISA |
Destination_Currency_Code | 826 | The currency type presented to the member on incoming transactions.It is the billing currency | VISA |
Source_Amount | -5000.00 | The purchase value in transaction currency | VISA |
Source_Currency_Code | 826 | Currency code used in the transaction | VISA |
Merchant_Name | Name of a physical or online store | Name of the merchant in the original transaction | VISA |
Merchant_City | Gotham City | City of merchant | VISA |
Merchant_Country_Code | US | Country code of merchant | VISA |
Merchant_Category_Code | 5999 | Four digit number that describes the type of business of the merchant | VISA |
Merchant_ZIP_Code | 1234 | Postal code of the merchant where the transaction took place | VISA |
Merchant_State_Province_Code | NY | If the Merchant Country Code is US or CA, this field will contain a valid U.S. State Code or Canadian Province Code, respectively. | VISA |
Settlement_Flag | 0 | "Indicates the service used for settlement | VISA |
Authorization_Characteristics_Indicator | 9 | "Code used by the acquirer to request CPS qualification | VISA |
Authorization_Code | 103507 | "Code that an issuer, its authorizing processor, or Stand-In Processing (STIP) provides to indicate approval of a transaction" | VISA |
Cardholder_ID_Method | 1 | "Indicates method used to identify cardholder (e.g., signature, Personal Identification Number (PIN), etc.). The field must contain a space or 1 through 4." | VISA |
POS_Entry_Mode | 0 | "A V.I.P. System field indicating the method by which a point-of-transaction terminal obtains and transmits the cardholder information necessary to complete a Transaction. | VISA |
Central_Processing_Date | 16/03/2022 | The date that BASE II processes this transaction or item. | VISA |
Member_Message_Text | This is a sample message | This field is used to send text messages | VISA |
Card_Acceptor_ID | C123456 | Code that identifies the card acceptor operating the POS terminal. | VISA |
Terminal_ID | T012345 | Code that identifies the card acceptor terminal or ATM. | VISA |
Interface_Trace_Number | 123456789 | Reserved field. | VISA |
AVS_Response_Code | M | Contains the response to an Address Verification Service (AVS) request, indicating matches or discrepancies between addresses and ZIP codes. | VISA |
Authorization_Source_Code | Online | "Indicates whether authorization was obtained and the source of the authorization." | VISA |
Transaction_Code_Qualifier__TCR3 | 0 | "This field must contain one of the following values: | VISA |
Transaction_Component_Sequence_Number__TCR3 | VISA | ||
Fast_Funds_Indicator | "VIC will return the transaction if any non-space value is present on an Original Transaction." | VISA | |
Business_Format_Code | Code indicating the type of business that is applicable to this transaction. | VISA | |
Business_Application_ID | "This field provides additional information regarding the usage and application of the transaction" | VISA | |
Source_of_Funds | "This field should contain one of the following values: | VISA | |
Payment_Reversal_Reason_Code | "This field should contain one of the following values: | VISA | |
Sender_Reference_Number | "This field will contain a transaction reference number that is provided by the originator and can be used to uniquely identify the sender" | VISA | |
Sender_Account_Number | "This field will contain the sender's card token from which the funds are to be taken." | VISA | |
Sender_Name | "This field will contain the name of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_Address | "This field will contain the address of the person or entity for the account from which funds are to be taken" | VISA | |
Sender_City | "This field will contain the city of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_State | "This field will contain the geographical state or province of the person or entity for the account from which funds are to be taken." | VISA | |
Sender_Country | "This field will contain the country of the person or entity for the account from which funds are to be taken" | VISA | |
Transaction_Code_Qualifier__TCR5 | 0 | This field must contain one of the following values: | VISA |
Transaction_Component_Sequence_Number__TCR5 | 5 | Sequence no of the transaction component | VISA |
Transaction_Identifier | 312340801000789 | A unique value that Visa assigns to each transaction and returns to the acquirer in the authorization response. | VISA |
Authorized_Amount | 500000 | "Amount the issuer originally authorized. The entry must be numeric. For CPS original draft transactions and their reversals, this entry may not be zeros. CPS credit vouchers and their reversals must contain zeros in this field." | VISA |
Authorization_Currency_Code | 826 | Currency code of the authorized source amount | VISA |
Interchange_Fee_Amount | 0.00 | "Specifies the interchange fee amount (in the settlement currency of the member) calculated by Visa for this transaction" | VISA |
Interchange_Fee_Sign | "Specifies if the interchange fee amount is a credit or a debit for the receiving member. | VISA | |
Source_Currency_to_Base_Currency_Exchange_Rate | 0 | "Specifies the currency exchange rate applied to this transaction when Visa converts the source amount to the transaction amount in the destination currency" | VISA |
Base_Currency_to_Destination_Currency_Exchange_Rate | 0 | "Specifies the currency exchange rate applied to this transaction when Visa converts the source amount to the transaction amount in the destination currency" | VISA |
Optional_Issuer_ISA_Amount | 0.00 | "This ISO-defined field can be used for any charge type or any fee applied to a transaction. Currently, Visa uses this field to carry optional International Service Assessment (ISA) data for issuers in the LAC region" | VISA |
Product_ID | Product identifier code | VISA | |
CVV2_Result_Code | "Card Verification Value 2 (CVV2) is the verification result for card-not-present transactions and also for card-present CVV2 verification-only requests" | VISA | |
PY__Transaction_Type | POS | Identifies the transaction type. For example: POS, ECOM, UNKNOWN | Paymentology |
v4.0 sample file
PY__RID_Settlement,PY__RID_Authorization,PY__Account_ID,PY__Account_Currency,PY__Token,PY__Account_External_Reference,PY__Transaction_ID,PY__Network,PY__Created_Date,PY__Matched_Status,PY__Product_ID,PY__Product_Name,PY__Settlement_Note,Transaction_Code,Transaction_Code_Qualifier,Usage_Code,Acquirer_Reference_Number,Acquirer_Business_ID,Purchase_Date,Destination_Amount,Destination_Currency_Code,Source_Amount,Source_Currency_Code,Merchant_Name,Merchant_City,Merchant_Country_Code,Merchant_Category_Code,Merchant_ZIP_Code,Merchant_State_Province_Code,Settlement_Flag,Authorization_Characteristics_Indicator,Authorization_Code,Cardholder_ID_Method,POS_Entry_Mode,Central_Processing_Date,Member_Message_Text,Card_Acceptor_ID,Terminal_ID,Interface_Trace_Number,AVS_Response_Code,Authorization_Source_Code,Transaction_Code_Qualifier__TCR3,Transaction_Component_Sequence_Number__TCR3,Fast_Funds_Indicator,Business_Format_Code,Business_Application_ID,Source_of_Funds,Payment_Reversal_Reason_Code,Sender_Reference_Number,Sender_Account_Number,Sender_Name,Sender_Address,Sender_City,Sender_State,Sender_Country,Transaction_Code_Qualifier__TCR5,Transaction_Component_Sequence_Number__TCR5,Transaction_Identifier,Authorized_Amount,Authorization_Currency_Code,Interchange_Fee_Amount,Interchange_Fee_Sign,Source_Currency_to_Base_Currency_Exchange_Rate,Base_Currency_to_Destination_Currency_Exchange_Rate,Optional_Issuer_ISA_Amount,Product_ID,CVV2_Result_Code,PY__Transaction_Type
54321000123,0,987656789,682,878909890,40c8-abe2-17c0d09ecd98,8.43E+18,VISA,6/03/2024 10:00,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),5,1,,5.52E+22,10000123,4/03/2024 17:39,9.94,400,9.94,400,My Company.com,HK ,AU ,7311,0,WA ,0,E,,1,1,6/03/2024,jesjkerkknfk reference,80001234,789898324,4011 0,,,0,,,,,,,,,,,,,,2,5,4.12E+14,994,400,0.02,C,0.266599598,1,0,F ,,ECOM
54321000124,765432,987656790,566,878909891,40c8-abe2-17c0d09ecd99,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,5.52E+22,10000124,5/03/2024 0:00,-4.12,400,-1700,826,Lush living Auckland NZL,HK ,ES ,7311,0,WA ,0,E,190654,2,5,6/03/2024,,2.57E+14,689899,4015 0,,,0,,,,,,,,,,,,,,2,5,4.12E+14,170000,826,0.08,C,0.000647059,0.002423529,0,F ,,POS
54321000125,765433,987656791,682,878909892,40c8-abe2-17c0d09ecd100,8.43E+18,VISA,6/03/2024 14:55,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1b) on tok+de38,5,1,,5.52E+22,10000125,6/03/2024 0:00,3.99,400,3.99,400,GOT MONEY CA AB Home Town GBR,LONDON,CY ,7311,10004,TX ,0,E,190655,3,7,6/03/2024,,2.57E+14,,4014 0,C,,0,,,,AA,,,,,,,,,,2,5,4.12E+14,399,400,0.2,C,0.26566416,1,0,N ,P,POS
54321000126,765434,987656792,566,878909893,40c8-abe2-17c0d09ecd101,8.43E+18,VISA,6/03/2024 4:00,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,5.55E+22,10000126,5/03/2024 0:00,-4.12,400,-1700,978,Givememore Auckland NZL,HAMPSHIRE,NL ,5734,10004, ,0,N,190656,4,10,6/03/2024,,2.57E+14,,4016 0,,,0,,Y,,,,,,,,,,,,2,5,4.12E+14,170000,978,2.26,C,0.000647059,0.002423529,0,N ,,ECOM
54321000127,765435,987656793,840,878909894,40c8-abe2-17c0d09ecd102,8.43E+18,VISA,6/03/2024 4:00,1,7,MyProduct-Mastercard Debit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,5.55E+22,10000127,5/03/2024 0:00,-22.28,400,-5.94,826,Amazon Prime Amzn.com/bill USA,Riyadh,AU ,5734,60612,WA ,0,N,190657,4,,6/03/2024,,2.57E+14,,4011 0,,5,0,,Y,,,,,,,,,,,,2,5,4.12E+14,594,826,0.79,C,1,3.750841751,0,N ,,UNKNOWN
54321000128,0,987656794,682,878909895,40c8-abe2-17c0d09ecd103,8.43E+18,VISA,6/03/2024 14:55,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),5,1,,6.55E+22,10000128,5/03/2024 7:12,16.53,400,16.53,400,APPLE.COM/BILL ITUNES.COM IRL,Dubai,ES ,5945,10004,WA ,0,N,,4,5,6/03/2024,,2.57E+14,,4015 0,,6,1,,Y,CR,,,,,,,,,,,0,5,4.12E+14,1653,400,0.62,C,0.266787659,1,0,N ,,POS
54321000129,765436,987656795,840,878909896,40c8-abe2-17c0d09ecd104,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,8.54E+22,10000129,5/03/2024 0:00,-135.14,400,-36.03,840,Google YouTube River View CAL,Westland,CY ,5734,10004,CA ,0,N,898098,4,7,6/03/2024,,2.57E+14,89689698234,4014 0,N,7,0,,,,FD,,,,,,,,,,0,5,4.12E+14,3603,840,0.62,C,1,3.750763253,0,N ,,POS
54321000130,765437,987656796,840,878909897,40c8-abe2-17c0d09ecd105,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,1401=Previously approved auth -amt same; match (1a) on tok+de38,5,1,,8.26E+22,10000130,5/03/2024 0:00,-22.28,400,-5.94,840,Alloallo Melbourne AUS,RIYADH,NL ,5734,0,CA ,0,N,909090,4,10,6/03/2024,,2.57E+14,,4016 0,,9,2,3,Y,,,,,,,,,,,,0,5,4.12E+14,594,840,0.04,C,1,3.750841751,0,N ,M,UNKNOWN
54321000131,0,987656797,840,878909898,40c8-abe2-17c0d09ecd106,8.43E+18,VISA,6/03/2024 14:55,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),5,1,,8.26E+22,10000131,5/03/2024 18:09,299.46,400,79.84,124,GOOGLE *YouTube ,google.com,US ,5818,0, ,0,N,,4,1,6/03/2024,,2.57E+14,,4011 0,,,0,,,,FD,,,,,,,,,,0,5,4.12E+14,7984,124,0.67,C,1,3.750751503,0,N ,M,ECOM
54321000132,654321,987656798,682,878909899,40c8-abe2-17c0d09ecd107,8.43E+18,VISA,7/03/2024 1:20,1,11,MyProduct-Mastercard Credit,1400=Not previously authorized; match (1a) on tok+de38,5,1,,7.27E+22,10000132,6/03/2024 14:44,-90,400,-90,400,BRUNELLO CUCINELLI,London,US ,5818,10004,IL ,0,N,667788,4,1,7/03/2024,6.76E+11,65613598L483,,4015 0,,,0,,,,,,,,,,,,,,0,5,4.12E+14,9000,400,0.08,C,0.266666667,1,0,F ,M,UNKNOWN
54321000133,876543,987656799,949,878909900,40c8-abe2-17c0d09ecd108,8.43E+18,VISA,6/03/2024 4:00,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,5,1,,7.27E+22,10000133,5/03/2024 14:38,-34.3,400,-285.36,124,ISTYLE,MEDFORD,US ,5661,75216,FL ,0,N,998877,4,1,6/03/2024,,6677567,89799,4014 0,S,B,0,,,,PS,2,,,,,,,,,0,5,4.12E+14,28536,124,0.74,C,0.03206476,0.120199047,0,F ,,UNKNOWN
54321000134,0,987656800,682,878909901,40c8-abe2-17c0d09ecd109,8.43E+18,VISA,6/03/2024 14:55,9,11,MyProduct-Mastercard Credit,; match (5a) : unmatched settlement except reversal. (known card),6,2,,5.13E+21,10000134,5/03/2024 7:12,16.53,400,16.53,400,Alexander McQueen,KUWAIT,US ,5311,90245,FL ,0,N,,1,7,6/03/2024,,2.57E+14,,4016 0,U,B,0,,,CR,MD,,,,,,,,,,0,5,4.12E+14,1653,400,0.13,C,0.266787659,1,0,N ,,POS
54321000135,876544,987656801,840,878909902,40c8-abe2-17c0d09ecd110,8.43E+18,VISA,6/03/2024 14:55,1,11,MyProduct-Mastercard Credit,; match (1b) on tok+de38,6,2,,5.13E+21,10000135,6/03/2024 6:52,15,400,4,978,JUMBO\LIMITED LLC,MADRID,US ,5311,80401, ,0,N,190658,1,5,6/03/2024,,5.27E+14,,4011 0,C,B,0,,,,,,,,,,,,,,0,5,4.12E+14,400,978,0.13,D,1,3.75,0,N ,,POS
54321000136,876545,987656802,682,878909903,40c8-abe2-17c0d09ecd111,8.43E+18,VISA,6/03/2024 14:55,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,6,2,,5.13E+21,10000136,5/03/2024 19:11,-0.01,400,-0.01,400,Aimn official store,BARCELONA,CA ,5311,4101,MN ,0,N,190659,2,1,6/03/2024,hjjjg-788239912,1000700331,,4015 0,,,0,3,,,PS,,,,,,,,,,0,5,4.12E+14,1,400,0.7,D,0,1,0,N ,,ECOM
54321000137,876546,987656803,682,878909904,40c8-abe2-17c0d09ecd112,8.43E+18,VISA,6/03/2024 10:00,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,6,2,,5.13E+21,10000137,5/03/2024 7:06,-3.5,400,-3.5,400,Fifa.com,TOLEDO,SG ,5311,0,MN ,0,N,190660,2,1,6/03/2024,,2.06E+11,34,4014 0,,,0,,,,,,,,,,,,,,0,5,4.12E+14,350,400,0.04,C,0.265714286,1,0,N ,N,UNKNOWN
54321000138,6955895,457964803,840,960565442,7898798090,2.59E+18,VISA,6/03/2024,1,12,MyProduct-Mastercard Credit,; match (1e) on tok+de38+mcc ,6,0,1,5.13E+21,10000138,3/03/2024 19:28,-15,400,-15,400,Pradaamerlia,VAUXHALL,US ,5311,60176,WA ,0,N,190661,4,1,6/03/2024, ,2.06E+11,10140001,4016 0,,9,0,,,,WT,,,,,,,,,,0,5,4.12E+14,1500,400,2.21,D,0.266666667,1,0,N ,N,UNKNOWN
54321000139,7952961,248296493,978,354801751,9.00E+11,2.62E+18,VISA,6/03/2024,1,12,MyProduct-Mastercard Credit,; match (1a) on tok+de38+de62_2 ,7,0,1,7.53E+22,10000139,5/03/2024 17:09,-16.95,400,-1.7,978,honda.com/au,BRISTOL,ES ,5967,60611,WA ,0,E,190662,2,7,6/03/2024, ,2.06E+11,204,4011 0,N,V,0,,,,WT,,,,,,,,,,0,5,4.12E+14,170,978,0.05,D,2.658823529,9.970588235,0,N , ,POS
54321000140,7933290,781072871,400,338120243,9.98E+14,2.62E+18,VISA,6/03/2024,4,14,MyProduct-Mastercard Credit,; match (4a) : reversal settlement.,25,0,1,7.53E+22,10000140,5/03/2024 14:39,-60,400,-60,400,CHEWTON GLEN HOTELS LI,GLASGOW,CY ,5967,32603,WA ,0,N,190663,4,1,7/03/2024, ,2.06E+11,70000946,4012 0,,V,0,,,,WT,,,,,,,,,,0,5,4.12E+14,6000,400,0.21,D,0.266666667,1,0,N ,M,ECOM
54321000141,6683465,755429020,840,679138802,1.00E+13,2.58E+18,VISA,6/03/2024,1,12,MyProduct-Mastercard Credit,; match (1e) on tok+de38+mcc ,5,0,9,2.68E+21,10000141,5/03/2024 17:27,-21.74,400,-21.29,978,GAME KING LLC,BOSTON,NL ,5817,33133,WA ,0,N,190664,4,1,6/03/2024, ,2.06E+11, ,4013 0,,V,0,,,,,,,,,,,,,,0,5,4.12E+14,2129,978,0.22,C,0.27242837,1.021136684,0,F ,,ECOM
54321000142,876551,987656808,840,878909909,40c8-abe2-17c0d09ecd117,8.43E+18,VISA,6/03/2024 4:00,1,7,MyProduct-Mastercard Credit,; match (1a) on tok+de38,5,0,,2.68E+21,10000142,5/03/2024 16:25,-99.99,400,-26.66,826,JKL.EU,ADOBE.LY/BILL,US ,5817,33133,,0,E,190665,3,7,6/03/2024,,DDFGSJKKTLR8909,,4014 0,,,2,,,,,,,,,,,,,,2,5,4.12E+14,2666,826,0.13,C,1,3.750562641,0,F ,,POS
54321000143,876552,987656809,682,878909910,40c8-abe2-17c0d09ecd118,8.43E+18,VISA,6/03/2024 10:00,1,11,MyProduct-Mastercard Credit,; match (1a) on tok+de38,5,0,,2.68E+21,10000143,5/03/2024 10:13,-10,400,-10,400,SAMSUNG.com,APPLE.COM/BIL,,5817,2903,,0,E,190666,3,7,6/03/2024,,2.06E+11,889989,4015 0,S,E,2,,,,AA,,,,,,,,,,2,5,4.12E+14,1000,400,0.93,C,0.267,1,0,N ,P,POS
Updated 7 months ago
