Field mappings for transactions through Zuora Fraud Protection
The following table shows the field mappings for transactions between Microsoft and Zuora.
Payment
| Microsoft Field | Zuora Field | Sample Data |
|---|---|---|
|
purchaseId |
UUID for each request |
fb197b7e-473f-4c39-a7ed-47c4ce8dc40f |
|
totalAmount |
Payment Amount |
6.41 |
|
merchantLocalDate |
Current Time |
2023-10-06T00:42:47-07:00 |
|
currency |
Payment Amount Currency |
USD |
|
paymentInstrument#type |
Payment Method Type |
CreditCard |
|
paymentInstrument#accountType |
Static Value |
CREDIT_FACILITY |
|
paymentInstrument#creationDate |
Current Time |
2023-10-06T00:22:37-07:00 |
|
paymentInstrument#updateDate |
Current Time |
2023-10-06T00:22:37-07:00 |
|
paymentInstrument#cardType |
Card Type |
Visa |
|
paymentInstrument#holderName |
Card Holder Name |
Jason Hoover |
|
paymentInstrument#bin |
Card Bin Code |
440393 |
|
paymentInstrument#expirationDate |
Card Expiration Date |
2028-09-01T00:00:00Z |
|
paymentInstrument#lastFourDigits |
The last four digits of Card Number |
6583 |
|
paymentInstrument#encryptedCreditCardNumber |
Encrypted Card Number |
b5423b******f9dc56 |
|
paymentInstrument#email |
Card Holder Email This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#street1 |
Card Holder Address Street1 This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#street2 |
Card Holder AAddress Street2 This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#city |
Card Holder City This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#state |
Card Holder State This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#country |
Card Holder Country This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#zipCode |
Card Holder Zip Code This field is populated based on the following priority order:
|
49022 |
|
paymentInstrument#billingAddress#phoneNumber |
Card Holder Phone Number This field is populated based on the following priority order:
|
|
|
paymentInstrument#billingAddress#firstName |
First name of card holder name from HPM transaction |
Jason |
|
paymentInstrument#billingAddress#lastName |
Last name of card holder name from HPM transaction |
Hoover |
|
_metadata#merchantTimeStamp |
Request timestamp |
2023-10-06T00:42:47-07:00 |
|
_metadata#trackingId |
Tracking this request ID |
0010c0d0-3d43-424e-80b6-16e965217999 |
|
merchantIdentifier |
Tenant ID in Zuora |
5983 |
|
orderType |
Customer/Merchant Initiated Transactions Keep empty if the type is unknown |
CIT |
|
paymentInstrument#paymentMethod |
Payment Method Type |
Wallet |
|
user#userId |
BillingAccount#id |
402881e68a922764018a928a037c014d |
|
user#email |
BillingAccount#billToContact#personalEmail |
|
|
user#country |
BillingAccount#billToContact#country |
US |
|
user#zipCode |
BillingAccount#billToContact#postalCode |
94043 |
|
user#creationDate |
BillingAccount#createdOn |
2023-09-14T15:13:52-07:00 |
|
user#phoneNumber |
BillingAccount#billToContact#phoneNumber |
1359046662981 |
|
user#lastName |
BillingAccount#billToContact#lastName |
Smith |
|
user#firstName |
BillingAccount#billToContact#firstName |
Sam |
|
user#updateDate |
BillingAccount#updatedOn |
2023-09-14T15:13:52-07:00 |
|
product#productId |
InvoiceDetail#sku |
SKU-00000001 |
|
product#type |
N/A |
Empty |
|
product#category |
N/A |
Empty |
|
product#productName |
InvoiceDetail#skuName |
FF_daily -- Prepayment Credit |
|
product#quantity |
InvoiceDetail#quantity |
10 |
|
product#purchasePrice |
InvoiceDetail#amountWithoutTax |
100.550000000 |
|
product#isFree |
Static Value |
false |
|
product#isPreorder |
Static Value |
false |
|
product#merchantProductCategory |
N/A |
Empty |
|
product#currency |
PM Amount Currency |
|
|
product#shippingMethod |
N/A |
Empty |
|
isRecurringCharge |
Payment#mitTransactionSource |
true |
|
originalOrderId |
N/A |
Empty |
|
recurringChargeFrequencyInDays |
N/A |
Empty |
|
recurringChargeStartDate |
N/A |
Empty |
|
recurringChargeEndDate |
N/A |
Empty |
|
recurringSubscriptionId |
N/A |
Empty |
|
recurringChargeSequence |
N/A |
Empty |
Chargeback
| Microsoft Field | Zuora Field | Sample Data |
|---|---|---|
|
chargebackId |
Refund#Id |
8a128ab18b0e5d17018b1eadfaca4010 |
|
reason |
Refund#GatewayReconciliationReason |
refund_settled / null(if no value) |
|
isFraud |
Value not set |
null |
|
reasonText |
N/A |
null |
|
status |
Static Value of Accepted |
Accepted |
|
bankEventTimestamp |
Refund#SettledOn / Refund#CreatedOn if no SettledOn |
2023-04-20T04:19:24-07:00 / 2023-04-20T10:00:00-07:00 |
|
amount |
Refund#TotalAmount |
141.960000000 |
|
currency |
Refund#Currency#Code |
USD |
|
purchaseId |
PaymentTransactionLog#TransactionId (The purchase ID in the Purchase request) / PaymentMethodTransactionLog#TransactionId (If DFP is disabled for payment there is no Purchase ID for the payment, then find the Purchase ID by the payment method of the payment related to the refund) |
e5955365-fc0c-49e6-a1c2-decc087f6545 |
|
userId |
BillingAccount#Id |
8a1287547f72bb64017f7920a7941d6c |
|
_metadata#trackingId |
Refund#Id |
8a128ab18b0e5d17018b1eadfaca4010 |
|
_metadata#merchantTimeStamp |
Current Time (ISO8601 format) |
2023-11-10T05:29:14-07:00 |