Presentments (Deprecated)

⚠️

Deprecation Notice

This 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
00000
0005

Numeric

PY__RID_Authorization

Unique ID for authorisation transaction (this may have value 0 if no Authorisation involved in the transaction)

4321
2345

Numeric

PY__Account_ID

Account identifier

21234
5678

Numeric

PY__Token

Public token generated by Paymentology to replace PAN

33344
4555

Numeric

PY__Account_External_Reference

Unique file ID assigned by Paymentology

389-12
45678
45200

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
23456
78900
0000

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:
YYYY-MM-DD
HH:MM

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).
Settlement Reversal will still hold the value of the original settlement.

-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
22:13

Datetime:
YYYY/MM/DD
HH:MM

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
22:12

Datetime:
YYYY/MM/DD
HH:MM

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
0155551E+21

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
003000

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
2233

Numeric

DE42__Card_Acceptor_ID_Code

Card Acceptor ID Code

58000
123456

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 = the original message
-1 = the reversal of the original

1

Numeric

DE48_0105__Network_File_Reference

PDS 0105 value. Network File Reference

1,2304
560000
0005E+22

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:
YYYY-MM-DD

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:
YYYY/MM/DD

DE48_159_7__Reconciliation_Cycle

PDS 0159_7 value, Reconciliation Cycle

1

Numeric

DE48_159_8__Settlement_Date

Settlement Date

2023/01/16

Date:
YYYY/MM/DD

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
GH123456

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:
YYYY-MM-DD

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_Authorization is the same as the rid_authorization field found in the Authorizations report and the PY\_\_RID_Authorization field found in the Interchange report. You can use these fields to match transaction message records.
  • PY\_\_Token is the same as the card_number_proxy field found in the Authorizations report, the PY\_\_Token field found in the Interchange and Fees reports, the Card field found in the Chargebacks report and the Token field found in the Program fees report.
  • PY\_\_Transaction_ID is the same as the transaction\_id field found in the Authorizations report, the PY\_\_Transaction\_ID field found in the Interchange and Fees reports and the Transaction_ID field found in the Program fees report. You can use these fields to match transaction threads.
  • PY\_\_RID_Settlement is the same as the PY\_\_RID_Settlement field found in the Interchange, Fees and Program fees reports.

Alignment to FAST messages

  • PY\_\_RID_Authorization is the same as the RID field found in FAST authorization messages and the ADD_REF_RID field found in FAST V3 clearing and settlement messages. You can use these fields to match transaction message records.
  • PY\_\_Token is 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_ID is 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_Settlement is the same RID field 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

❗️

Important

This 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

Large integer, incremental

843210
001230
5330000

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
09:25:00

Date:
YYYY-MM-DD
HH:MM:SS

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).
Settlement Reversal will still hold the value of the original settlement.

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
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

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 -
decimal

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
21:21:10

Datetime:
YYYY-MM-DD
HH:MM:SS

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
12345678
0000000

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
123456

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
1234

Numeric

DE42__Card_Acceptor_ID_Code

Card Acceptor ID Code

300-9876
654321

Numeric

DE43_1__Card_Acceptor_Name

Card acceptor name (22 long)

GULF AIR
0987654321

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 = the original message
-1 = the reversal of the original

1

Numeric

DE48_0105__Network_File_Reference

Network_File_Reference

1230321
0000001
2000000

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:
DD/MM/YYYY

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:
YYYY-MM-DD

DE48_159_7__Reconciliation_Cycle

Reconciliation Cycle

2

Numeric

DE48_159_8__Settlement_Date

Settlement Date. Format: YYYY-MM-DD

2023-09-23

Date:
YYYY-MM-DD

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:
YYYY-MM-DD

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 changes

Below 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

Large integer, incremental

843210
001230
5330000

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
09:25:00

Date:
YYYY-MM-DD
HH:MM:SS

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).
Settlement Reversal will still hold the value of the original settlement.

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
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

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 -
decimal

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
21:21:10

Datetime:
YYYY-MM-DD
HH:MM:SS

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
12345678
0000000

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
123456

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
1234

Numeric

DE42__Card_Acceptor_ID_Code

Card Acceptor ID Code

300-9876
654321

Numeric

DE43_1__Card_Acceptor_Name

Card acceptor name (22 long)

GULF AIR
0987654321

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 = the original message
-1 = the reversal of the original

1

Numeric

DE48_0105__Network_File_Reference

Network_File_Reference

1230321
0000001
2000000

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:
DD/MM/YYYY

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:
YYYY-MM-DD

DE48_159_7__Reconciliation_Cycle

Reconciliation Cycle

2

Numeric

DE48_159_8__Settlement_Date

Settlement Date. Format: YYYY-MM-DD

2023-09-23

Date:
YYYY-MM-DD

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:
YYYY-MM-DD

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
-4579-9801-02338f3db573

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
850000000

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).
Settlement Reversal will still hold the value of original settlement.

-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.
Position 1-2 = Cardholder transaction type (numeric), Example, code = XX. Note: the processing codes of MC and MADA are not coincided for 100% and the lists of processing codes have some differences."

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
0145A515

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
RIYADH
SA

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 = the original message
-1 = the reversal of the original

-1

M

M

1

M

M

DE48_0105__Network_File_Reference

PDS 0105 value. Network File Reference

TLF04.20211221.
SPAN.242030

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
bee1177771f249a7fd

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

❗️

Important

This 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
901000000

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
VISA Platinum

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:
0 = Default
1 = Account Funding
2 = Original Credit"

VISA

Acquirer_Reference_Number

700000011190
00000000000

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
0 = International settlement service
3 = Clearing-only (valid only for countries with defined service)
8 = National Net settlement service (valid only for countries with defined service)
9 = BASE II selects the appropriate settlement service based on routing and country-defined default"

VISA

Authorization_Characteristics_Indicator

9

"Code used by the acquirer to request CPS qualification
T, N or space = Not a payment service transaction
E = Card present with merchant name and location data
X = Disqualified custom payment service transaction (inserted by BASE II)"

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.
This entry must be spaces, 00 through 07, 10, 90, 91 or 95."

VISA

Central_Processing_Date

2021-09-23

The date that BASE II processes this transaction or item. Format: YYYY-MM-DD
This is the date the transaction cleared/settled.
You should use this date for your financial reconcilation with the scheme.

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:
0 = Default
1 = Account Funding
2 = Original Credit"

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:
1 = Cash
2 = Check
3 = Card"

VISA

Payment_Reversal_Reason_Code

"This field should contain one of the following values:
01 = Returned check not sufficient funds (NSF)
02 = Returned check stop payment
03 = Returned check account closed
04 = Returned check refer to maker
05 = Returned check – other
Spaces = Unspecified"

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:
0 = Default
1 = Account Funding
2 = Original Credit"

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.
Valid values:
C = Credit
D = Debit"

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

❗️

Important

This 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 changes

Below 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:
0 = Default
1 = Account Funding
2 = Original Credit"

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
0 = International settlement service
3 = Clearing-only (valid only for countries with defined service)
8 = National Net settlement service (valid only for countries with defined service)
9 = BASE II selects the appropriate settlement service based on routing and country-defined default"

VISA

Authorization_Characteristics_Indicator

9

"Code used by the acquirer to request CPS qualification
T, N or space = Not a payment service transaction
E = Card present with merchant name and location data
X = Disqualified custom payment service transaction (inserted by BASE II)"

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.
This entry must be spaces, 00 through 07, 10, 90, 91 or 95."

VISA

Central_Processing_Date

16/03/2022

The date that BASE II processes this transaction or item.
This is the date the transaction cleared/settled.
You should use this date for your financial reconcilation with the scheme.

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:
0 = Default
1 = Account Funding
2 = Original Credit"

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:
1 = Cash
2 = Check
3 = Card"

VISA

Payment_Reversal_Reason_Code

"This field should contain one of the following values:
01 = Returned check not sufficient funds (NSF)
02 = Returned check stop payment
03 = Returned check account closed
04 = Returned check refer to maker
05 = Returned check – other
Spaces = Unspecified"

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:
0 = Default
1 = Account Funding
2 = Original Credit

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.
Valid values:
C = Credit
D = Debit"

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 changes

Below 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:
0 = Default
1 = Account Funding
2 = Original Credit"

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
0 = International settlement service
3 = Clearing-only (valid only for countries with defined service)
8 = National Net settlement service (valid only for countries with defined service)
9 = BASE II selects the appropriate settlement service based on routing and country-defined default"

VISA

Authorization_Characteristics_Indicator

9

"Code used by the acquirer to request CPS qualification
T, N or space = Not a payment service transaction
E = Card present with merchant name and location data
X = Disqualified custom payment service transaction (inserted by BASE II)"

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.
This entry must be spaces, 00 through 07, 10, 90, 91 or 95."

VISA

Central_Processing_Date

16/03/2022

The date that BASE II processes this transaction or item.
This is the date the transaction cleared/settled.
You should use this date for your financial reconcilation with the scheme.

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:
0 = Default
1 = Account Funding
2 = Original Credit"

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:
1 = Cash
2 = Check
3 = Card"

VISA

Payment_Reversal_Reason_Code

"This field should contain one of the following values:
01 = Returned check not sufficient funds (NSF)
02 = Returned check stop payment
03 = Returned check account closed
04 = Returned check refer to maker
05 = Returned check – other
Spaces = Unspecified"

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:
0 = Default
1 = Account Funding
2 = Original Credit

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.
Valid values:
C = Credit
D = Debit"

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

🔝