Field Mappings for Payment Processing for Fraud Protection
This document provides field mappings between LexisNexis and Zuora for payment processing and fraud protection, detailing static values, billing account information, and payment method specifics.
| LexisNexis Field | Zuora Field | Sample Data |
|---|---|---|
| org_id | Static Value, pass in via x-org-id in the header | 96zn8q74 |
| api-key | Static value, pass in via x-api-key in header | ywrcatkh6lvoexcw |
| service_type | Static Value | all |
| event_type | Static Value | payment |
| policy | Static Value | payment |
| account_number | Billing Account Account Number | A000001 |
| account_name | Billing Account Customer Name | name1359046645619 |
| account_email |
HPM Email with below priority: 1.Payment Method Address Email 2.Billing Account Bill To Contact Work Email 3.Billing Account Bill To Contact Personal Email 3.Billing Account Sold To Contact Work Email 4.Billing Account Sold To Contact Personal Email | dinap@zuora.com |
| account_login | Billing Account ID (Orphan PM has no Billing Count, then not pass in) | 402881e68a922764018a928a037c014d |
| account_telephone |
HPM input billing address based on below priority: 1.Payment Method Address phone 2.Billing Account Bill To Contact Work Phone 3.Billing Account Bill To Contact Mobile Phone 4.Billing Account Sold To Contact Work Phone 5.Billing Account Sold To Contact Mobile Phone | 1359046662981 |
| account_address_street1 |
HPM input billing address with below priority: 1.Payment Method Address street 1 2.Billing Account Bill To Contact Street Address1 3.Billing Account Sold To Contact Street Address1) | 312 2nd Ave W |
| account_address_street2 |
HPM input billing address based on below priority: 1.Payment Method Address address street 2 2.Billing Account Bill To Contact Street Address2 3.Billing Account Sold To Contact Street Address 2 | |
| account_address_city |
HPM input billing address based on below priority: 1.Payment Method Address city 2.Billing Account Bill To Contact City 3.Billing Account Sold To Contact City | Seattle |
| account_address_state |
HPM input billing address 1.Payment Method Address state 2.Billing Account Bill To Contact State 3.Billing Account Sold To Contact State | Washington |
| account_address_country |
HPM input billing address 1.Payment Method Address country 2.Billing Account Bill To Contact Country 3.Billing Account Sold To Contact Country | US |
| account_address_zip | HPM input billing address based on below priority: 1.Payment Method Address postal code 2.Billing Account Bill To Contact Postal Code 3.Billing Account Sold To Contact Postal Code | 49022 |
| account_first_name | First Name of HPM Card holder name | Jason |
| account_last_name | Last Name of HPM Card holder name | Hoover |
| transaction_id | Payment id | 0010c0d0-3d43-424e-80b6-16e965217999 |
| cc_number_hash | The hash value of credit card number | d6f2dabb9e1b02ed3e691734755e01c8bc10735f |
| ach_account_hash | The hash value of bank transfer account number | 0a68e1ab7067f9505b4f7b64914723a3229b33fc |
| ach_routing_number | The hash value of ACH account routing number, for other banktransfer type, not pass it | 0123456 |
| input_ip_address | Client IP Address | 76.50.89.173 |
| shipping_address_street1 |
Find the street1 based on below priority: 1.Billing Account Bill To Contact Street Address 1 2.Billing Account Sold To Contact Street Address 1 | 312 2nd Ave W |
| shipping_address_street2 |
Find the street 2 based on below priority: 1.Billing Account Bill To Contact Street Address 2 2.Billing Account Sold To Contact Street Address 2 | |
| shipping_address_city |
Find the city based on below priority: 1.Billing Account Bill To Contact City 2.Billing Account Sold To Contact City | Seattle |
| shipping_address_state |
Find the State based on below priority: 1.Billing Account Bill To Contact State 2.Billing Account Sold To Contact State | Washington |
| shipping_address_country |
Find country with below priority: 1. Billing Account Bill To Contact Country 2. Billing Account Sold To Contact Country | US |
| shipping_address_zip |
Find zipcode with below priority: 1.Billing Account Bill To Contact Postal Code 2.Billing Account Sold To Contact Postal Code | 94043 |
| THREATMETRIX_EXACTID | If the payment is initialized from HPM as on-session payment, we can get the honeypot_fingerprint from session query api | 54930c2d59e3e56e715547df911c540222045fc8 |
| device_id | If the payment is initialized from HPM as on-session payment, we can get the device_id from session query api | 0d5ca73a5aad42e58a05c07199954496 |
| http_referer_domain | The http-referer when it is on-session payment | |
| profiled_domain | The http-referer when it is on-session payment | |
| transaction_amount | Payment Method Auth Amount | 0 or 1.0 |
| transaction_currency | Payment currency, can not pick up the account currency because Zuora supports multi-currency on billing account level. | USD |
| application_name | Payment method subtype as the field type in DFP | CreditCard |
| line_of_business | Payment Method AchBankName or BankName | CommerceBank |
| delivery_type | Static value for Credit Card | CREDIT_FACILITY |
| cc_bin_number_brand | Credit card brand | Visa |
| segment_name | Payment method type as the field paymentMethod in MS DFP | Card |
| cc_bin_number | 6 digital credit card bin number | 439226 |
| card_expiry_date | Expiry of the credit card, yyMM | 2712 |
| pos_mit_detail | Check MITMessageType | R |
| customer_event_type | MITInitiatedBy as the field orderType in MS DFP | MIT |
| ecommerce_order_array | Invoice item list | "ecommerce_order_array":[{"sku":"SKU-00000001","item_name":"New Component 1","price":"500","quantity":"1"}] |
| local_attrib_2 | Tenant Id | 9 |
| local_attrib_4 | The business identification code of BankTransfer | BIN |
| local_attrib_5 | MITInitiatedBy as the field merchantBusinessSegment in MS DFP | MIT |
| local_attrib_6 | 6 digital credit card bin number | 439226 |
| local_attrib_7 | First Name of HPM Card holder name | John |
| local_attrib_8 | Last Name of HPM Card holder name | Hoover |
| local_attrib_9 | Ach Number Hash | cc552495fc90556293db500b985bacc918d9fb4d37b42052adf6445efdca5e89 |
| local_attrib_12 | Last 4 digits of the credit card number | 1111 |