Fees

PY__RID_Settlement

Unique ID for settlement transaction

12345000000005

Numeric

PY__Account_ID

Account identifier

212345678

Numeric

PY__Token

Public token generated by Paymentology to replace PAN

987654321

Numeric

PY__Account_External_Reference

Optional unique identifier which client may define at account creation, i.e. to link the acc_id with a unique account id in the bank systems

389-124567845200

Alphanumeric

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

2200123456789000000

Numeric

PY__Network

Indicates the Network provider. M = Mastercard

M

Alphabetic

PY__MTID

MTID code (Message Transaction Identifier)

1740

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 a Fee Message, Presentment and Auth based on several parameters.

0 or cell left blank = is used when the fee is not associated with a specific card. When trhe value is 0 the corresponding txn_id will be left blank.

1-9 = are used to indicate the degree of matching Paymentology achieved between Presentment and Auth based on several parameters. 1 = perfect match and 9 = no match achieved.

• *Note:** In most cases the matched status for messages within the Fees report will be 0 or left blank, as the Fee message is not associated with any card or transaction.

0

Numeric

PY__Is_Debit

This field determines the direction of funds flow of the original transaction, -1 = debit, +1 = credit, 0 = record with no financial movement (balance enquiry, no fees).

-1

Numeric

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

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

DE9__Conversion_Rate_Reconciliation

if DE5 is present, else 0

0

Numeric

DE24__Function_Code

Function Code. Is present for some operation types. Is absent for DE3_1=10 + MCC6011

700

Numeric

DE25__Message_Reason_Code

Message Reason Code. Indicates the reason for sending the message.
Is present for some operation types. Is absent for DE3_1=10 + MCC6011

7606

Numeric

DE26__Merchant_Category_Code

MCC Merchant Category Codes.
If MCC is not applicable this will be left blank or contain 0.

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.
If DE 30 is not present then this will be left blank

-711.23

Numeric - decimal

DE30_2__Original_Amount_Reconciliation

DE 30 (Amounts, reconciliation) Mastercard populate this with all zeros.
If DE 30 is not present then this will be left blank

Numeric - decimal

DE31__Acquirer_Reference_Data

Acquirer Reference Data (See MC IPM Clearing Formats document)

5,4448880155551E+21

Numeric

DE32__Acquiring_Institution_ID_Code

Acquirer Member ID.
If DE 31 is not present then this will be left blank

Numeric

DE33__Forwarding_Institution_ID_Code

Forwarding Institution Code

12345

Numeric

DE38__Approval_Code

Approval Code (the code that goes on customer receipt, Paymentology generated)

111333

Alphanumeric

DE41__Card_Acceptor_Terminal_ID

Card Acceptor Terminal Identifier.
If DE41 is not present then this will be left blank

Numeric

DE42__Card_Acceptor_ID_Code

Card Acceptor ID Code.
If DE42 is not present then this will be left blank

56251012

Numeric

DE43_1__Card_Acceptor_Name

Card acceptor name (22 long).
If DE43 is not present then this will be left blank

cosmetic store1

Alphanumeric

DE43_2__Card_Acceptor_Street_Address

Card Acceptor Street address (48 long).
If DE43 is not present then this will be left blank

123 address street

Alphanumeric

DE43_3__Card_Acceptor_City

Card Acceptor City (13 long).
If DE43 is not present then this will be left blank

Bangkok

Alphabetic

DE43_4__Card_Acceptor_Zip_Code

Post/zip code (10 long).
If DE43 is not present then this will be left blank

10110

Alphanumeric

DE43_5__Card_Acceptor_State_Code

State or province (3 long).
If DE43 is not present then this will be left blank

THA

Alphabetic

DE43_6__Card_Acceptor_Country_Code

Country Code (3 long).
If DE43 is not present then this will be left blank

THA

Alphabetic

DE48_0002__GCMS_Product_Identifier

GCMS Product Identifier, e.g. MRW is Prepaid Mastercard Business Card (Non-U.S.).
If DE48 is not present then this will be left blank

MRW

Alphabetic

DE48_0003__Licensed_Product_Identifier

Licensed Product Identifier.
If DE48 is not present then this will be left blank

ABC

Alphabetic

DE48_0023__Terminal_Type

Terminal Type, identifies the type of terminal used at the point of interaction.
If DE48 is not present then this will be left blank

CT6

Alphanumeric

DE48_0025_1__Message_Reversal_Indicator

PDS 0025 subfield 1.
Message 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,23045600000005E+22

Numeric

DE48_0158_1__Card_Program_Identifier

Card Program Identifier

DMC

Alphanumeric

DE48_0158_2__Business_Service_Arrangement_Type_Code

Business Service Arrangement Type Code

3

Numeric

DE48_0158_3__Business_Service_ID_Code

PDS 0158 subfield 3 value.
Business Service ID Code - Unique, six-position code that identifies the specific interchange arrangement assigned to that transaction

50012

Numeric

DE48_0158_4__Interchange_Rate_Designaor

PDS 0158 subfield 4 value.
Interchange Rate Designator - Code that specifies the interchange rate to apply to the transaction

YA

Alphanumeric

DE48_0158_5__Central_Site_Business_Date

PDS 0158 subfield 5 value.
Central Site Business Date

2023/01/06

Date: YYYY-MM-DD

DE48_0158_6__Business_Cycle

PDS 0158 subfield 6 value.
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

Alphanumeric

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.

Alphabetic

DE48_0158_13__Rate_Indicator

Rate Indicator indicates the rate applied by GCMS to the transaction, e.g. N = Non-regulated

Alphabetic

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

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

PDS 0159 subfield 6 value,
Reconciliation Date

2023/01/16

Date: YYYY/MM/DD

DE48_159_7__Reconciliation_Cycle

PDS 0159 subfield 7 value,
Reconciliation Cycle

1

Numeric

DE48_159_8__Settlement_Date

PDS 0159 subfield 8 value.
Settlement date

2023/01/16

Date: YYYY/MM/DD

DE48_159_9__Settlement_Cycle

PDS 0159 subfield 9 value.
Settlement Cycle

1

Numeric

DE49__Currency_Code_Transaction

Currency of transaction (local currency/DE4)

978

Numeric

DE50__Currency_Code_Reconciliation

Currency of reconciliation/Settlement

978

Numeric

DE63__Transaction_Life_Cycle_ID

DE 63 value.
Transaction Life Cycle ID

ABCDEFGH123456

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.

INTERCHANGE COMPLIANCE ADJUSTMENT FOR : 12/23/22

Alphanumeric

DE73__Action_Date

DE 73 value.
Date, Action - specifies the date (year, month and day) of a future action

230116

Numeric

DE93__Transaction_Destination_Institution_ID

DE 93 value.
Transaction Destination Institution ID Code (Length 11)

56789

Numeric

DE94__Transaction_Originator_Institution_ID

DE 94 value.
Transaction Originator ID Code (Length 11)

12345

Numeric

DE100__Receiving_Institution_ID

DE 100 value.
Receiving Institution ID Code

56789

Numeric