Field mappings for transactions through Zuora Fraud Protection
The following table shows the field mappings for transactions between Microsoft and Zuora:
| 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 |