SaFi Bank Space : FS: Cards Transaction

cards_fs

cards_transaction_features

card_transaction_features

Kafka Topic

customerId

cards_transaction_history_features

cards_transaction_historical_features

BigQuery / AlloyDB

customerId

mti

Message Type Identifier

string

proxyNumber

unique identifier for a card

string

processingCode

Refer to processing codes section

string

transactionAmount

Transaction amount is the value dispensed / entered at transaction origination. The decimal value is decided from the Currency code. ISO 4217. This denotes the original currency or acquirer currency, need not be PHD(home currency).

int

cardHolderBillingAmount

Cardholder amount is transaction amounted converted to local currency amount, (PHD)

int

transmissionDateTime

Transmission Date and Time to be sent in ISO 8601 format, eg: 2022-01-25T04:01:52Z, in SGT format

string

systemTraceAuditNumber

Number to trace in euronet system

string

localTransactionDateTime

Local Transaction Date and Time at the acquirer side to be sent in MMDDhhmmss.
(Time zone is not known) ISO 8601 format, eg: 2022-01-25T04:01:52Z

string

merchantCategoryCode

Merchant Category Code

string

acquirerCountryCode

Acquirer bank country code to be passed in numeric code in ISO 4217. This field will tell where the txn is performed. Currently not used in MC platform

string

panEntryMode

PAN entry mode, see complete list below

• [Blank] = Unknown, default to 00

• 0 = Terminal not used

• 1 = Key entry

• 2 = Magnetic strip read (general or track 2)

• 3 = Bar code read (visa only)

• 4 = OCR read

• 5 = Chip card read-data

• 6 = Track 1 read

• 7 = Proximity payment originating using VSDC chip data rules

• 79 = Chip card—unable to read chip or magnetic stripe; manual

• 80 = Chip card—fallback to magnetic stripe 3

• 81 = PAN entry via electronic commerce, including chip

• 90 = Entire content of magnetic stripe was transmitted in authorization request (CVV)

• 91 = Proximity payment originating using magnetic strip data rules

• 95 = Initiated by chip card: CVV data may be unreliable

string

networkID

“MCN” Mastercard Network

string

PosDataSF4

POS Cardholder Presence indicates whether the cardholder is present at the point of service and explains the condition if the cardholder is not present.

string

PosDataSF5

POS Card Presence indicates if the card is present at the point of service.

string

PosDataSF7

POS Transaction Status indicates the purpose or status of the request.

string

PosDataSF10

Cardholder-Activated Terminal Level indicates the type of cardholder activated terminal used by the cardholder to initiate the transaction

string

acquirerID

Unique id for Acquirer bank

string

retrievalReferenceNumber

Retrieval reference number can be used to trace the transaction from acquirer, scheme and euronet. Generated by acquirer, unique for that particular txn. Can be duplicated across different acquirers.

string

authorizationID

Authorization ID, to be generated by EN and sent this request.

string

cardAcceptorTerminalID

Merchant Terminal ID/ ATM ID

string

cardAcceptorMerchantID

Merchant ID/ For ATM what will this be?

string

cardAcceptorTermName

Merchant name and description/ ATM Name and location.
Refers to DE43 in MC specs.
Use last three characters of this field to identify DCC.
If PH or PHL then local, if not PH or PHL, then can be fx or dcc.
If transactionCurrencyCode is 608, then DCC. else fx.

string

transactionCurrencyCode

Transaction currency represents the currency in which transaction was performed. Format: ISO 4217, for example USD, need not be home currency.

string

cardHolderCurrencyCode

Cardholder currency represents the currency of issuer ISO 4217, home currency

string

transactionID

Unique ID for all transaction requests across MC EN and AIG,

string

OrgtransactionID

This field will be used in follow up transactions like incremental auth, reversals and advice of the original transactions.

string

threeDsAuthTID

The Directory Server Transaction ID is generated by the EMV 3DS Mastercard
Directory Server during the authentication transaction. Transaction ID during authorization in order to link authentication and authorization data.

string

DCCIndicator*

Only populated for DCC Txn

string

ECOMindicator

Ecommerce Indicator.
This field will represent if its Ecommerce Transaction or Tokenized Payment transaction.

string

UCAFIndicator

UCAF Collection Values represeting security of Ecommerce Transaction

string

threeDsValidation

This will be populated when Switch validates IAV successfully

string

PANValidation

PANValidation.

string

expiryDateValidation

Expiry date validation,

string

pinValidation

Pin validation check. Only present if transaction is PIN base transaction. Like For ATM txns.

string

CVVValidation

CVV Validation. Only present if transaction is Card base transaction. CVV is present in the physical card mag data.

string

CVV2Validation

CVV2 Validation. Only present if transaction is Non-Card base transaction

string

EMVValidation

EMV Validation. Only present if transaction is EMV Card base transaction

string

MSTransactionTypeId

Transaction Type Identifier used to identify type / mode of funding

• C07 = MoneySend Person-to-Person

• C52 = MoneySend Account-to-Account Transfers

• C53 = MoneySend Agent Cash Out

• C54 = MoneySend Credit Card Bill Payment

• C55 = MoneySend Business Disbursement

• C56 = MoneySend Government/Nonprofit Disbursement

• C57 = MoneySend Acquirer Merchant Settlement

• C58 = MoneySend Cash2ATM

• C59 = MoneySend Cash2Card

• C65 = MoneySend Business to Business Transfer

string

MSTransactionRefData

Additional transaction reference Data containing Sender Data

string

senderInfo

JSON

beneficiaryInfo

JSON

categoryCode

string

cardInfo

JSON

fee

JSON

transactionType

string

transactionCode

string