Search variables

The following table contains a complete list of variables supported by the search in Transactions overview. The data stored in these datapoints or attributes is available for search purposes.

Good to remember

Datapoints carry specific information about a transaction. You send datapoints to us via the Fraugster API. Attributes carry additional information about a transaction. They are are calculated during the enrichment process using the data in datapoints.

It's important to remember that some attributes rely on specific datapoints to be calculated. If these datapoints are not available, the attributes won't be calculated. An example from the following table is cust_fl_norm. If you want it to be calculated, you need to send cust_name or cust_first_name + cust_last_name in your API request.

Internal name	Display name	Datapoint (D) or attribute (A)?	Description
bill_ad_zip	Billing address | Postal code	D	The postal code on the billing address.
bill_ad_line2	Billing address | Apartment number	D	The apartment or flat number on the billing address.
cc_num_hash	Credit card | Hashed number	D	The hashed value of the credit card number. Use this datapoint to send credit card numbers if you cannot send the full card number in cc_num.
acct_ad_line1	Account address | Street and building number	D	The street and building number on the account address.
phone_work	Phone | Work	D	The phone number of the customer marked as the work phone.
ship_ad_first_name	Shipping address | First name	D	The first name of the customer on the shipping address.
pmt_method	Transaction | Payment method	D	The payment method used for the transaction.
bin_brand	BIN | Brand	D or A (requires cc_bin)	The credit card brand.
cust_fl_norm	Customer | Full name normalized	A (requires cust_name or cust_first_name + cust_last_name)	The normalized value of the customer's full name. Normalization in this case removes unicode and special characters (for example, an apostrophe is removed and ü becomes u) and spells all the names in lower case.
ship_ad_email	Shipping address | Email	D	The email address of the customer on the shipping address.
cust_middle_name	Customer | Middle name	D	The middle name of the customer.
ip_isp	IP | Internet service provider	A (requires ip)	The ISP (Internet Service Provider) that owns the IP address.
ship_ad_city	Shipping address | City	D	The city on the shipping address.
cust_email	Customer | Email address	D	The primary email address of the customer.
ba_iban	Bank account | IBAN	D	IBAN (International bank account number). Up to 34 alphanumeric characters.
scndry_phone	Customer | Secondary phone	D	The secondary phone number of the customer.
bill_ad_state	Billing address | State	D	The state or another unit of administrative division on the billing address.
client_id	Client | ID	D	Client IDs are assigned by Fraugster during the integration process. By definition, they are equal to the API user that customers send in order to authenticate. Client IDs are always lower case.
bill_ad_line1	Billing address | Street and building number	D	The street and building number on the billing address.
bill_ad_last_name	Billing address | Last name	D	The last name of the customer on the billing address.
ship_ad_line2	Shipping address | Apartment number	D	The apartment or flat number on the shipping address.
ship_ad_last_name	Shipping address | Last name	D	The last name of the customer on the shipping address.
phone	Customer | Phone	D	The phone number of the customer.
bill_ad_first_name	Billing address | First name	D	The first name of the customer on the billing address.
ship_ad_zip	Shipping address | Postal code	D	The postal code on the shipping address.
cc_first_name	Credit card | Cardholder first name	D	The first name of the credit card holder.
order_id	Merchant | Order ID	D	The identification code of the order as captured by the merchant. Do not confuse with the order ID assigned by the PSP (trans_id) or the order ID created by Fraugster (frg_trans_id).
cust_last_name	Customer | Last name	D	The last name of the customer.
bill_ad_city	Billing address | City	D	The city on the billing address.
acct_ad_zip	Account address | Postal code	D	The postal code on the account address.
device_id	Device | ID	D	Device identification code.
acct_ad_line2	Account address | Apartment number	D	The apartment or flat number on the account address.
ba_bic	Bank account | BIC	D	The BIC (bank identifier code) of the bank account. Up to 11 characters.
cc_last_name	Credit card | Cardholder last name	D	The last name of the credit card holder.
customer_account_number	Customer | Account number	D	The account number of the customer in the merchant's database.
ip	IP	D	The IP address of the customer.
ba_num	Bank account | Number	D or A (requires ba_iban)	The bank account number of the customer.
cust_scndry_email	Customer | Secondary email address	D	The secondary email address of the customer.
cc_cardholder	Credit card | Cardholder full name	D	The full name of the credit card holder. Send this datapoint if you collect the full name. Otherwise send parts of the name separately in cc_first_name, cc_middle_name, and cc_last_name.
ship_ad_state	Shipping address | State	D	The state or another unit of administrative division on the shipping address.
ba_last_name	Bank account | Account holder last name	D	The last name of the bank account holder.
ip_city	IP | City	A (requires ip)	The city of the IP address.
slr_ind_mcc	Merchant | MCC	D	The MCC (merchant category code) of the merchant. You can either have this configured in the configuration service or send this information in the API request.
seller_id	Merchant | ID	D	The identification code of the merchant.
cust_first_name	Customer | First name	D	The first name of the customer.
acct_ad_state	Account address | State	D	The state or another unit of administrative division on the account address.
acct_ad_city	Account address | City	D	The city on the address of the customer saved in the customer's account on the merchant's platform.
ba_first_name	Bank account | Account holder first name	D	The first name of the bank account holder.
cc_bin	BIN | Number	D	The BIN number of the credit card (the first 6 digits).
bin_category	BIN | Brand category	A (requires cc_bin)	The category of the credit card brand.
cc_last_4_dig	Credit card | Last 4 digits	D	The last 4 digits of the credit card.
device_name	Device | Name	D	The name of the customer's device.
sub_seller	Sub-merchant | ID	D	The identification code of the sub-merchant.
ship_ad_line1	Shipping address | Street and building number	D	The street and building number on the shipping address.
slr_name	Merchant | Name	D	The name of the merchant. You can either have this configured in the configuration service or send this information in the API request.
ship_ad_line1_zip_cnct	Shipping address | Street, building number, postal code concatenated	A (if you send ship_ad_line1 and ship_ad_zip)	The normalized and concatenated values of the street and building number on the shipping address together with the postal code. The attribute is useful if you want to create a blacklist. It helps you see a specific address without upper-case letters or spaces, making it easier to find and compare two identical addresses.
cust_id	Customer | ID as per merchant	D	The ID of the customer in the merchant's database.
device_id_exact	Device | Exact ID	D	Exact ID is a hashed device fingerprint generated by the payment company. It's based on a variety of markers to give a 100-percent accuracy in identifying a device, including browser language, cookies settings, and more.
device_id_smart	Device | Smart ID	D	Smart ID is a hashed device fingerprint generated by the payment company. It's optimized for persistence across standard computer lifecycle events. It works without the use of cookies and is calculated from hundreds of device attributes that are measured in real time.
cust_email_norm	Customer | Email address normalized	A (requires cust_email)	The normalized version of the customer's email address. Normalization may include standardizing the case, removing unnecessary spaces, etc.
cust_name	Customer | Full name	D	The full name of the customer. Use this datapoint when a customer sends their full name in one field, as opposed to sending their first, middle, and last name in separate fields.
sanctions_lists_hits_json	Sanctions lists hits | JSON string	A (requires sanctions list configuration)	A list of objects with all sanctions lists hits, represented as a JSON string.
device_id_mapped	Device | Device ID mapped	A (requires device ID configuration)	The value of the device ID based on the client's configuration (Fraugster's or their own).
frg_trans_id	Transaction | ID	A (generated by Fraugster)	The order ID created by Fraugster. Do not confuse with the order ID assigned by the PSP (trans_id) or the ID of the order as captured by the merchant (order_id).
trans_id	Transaction | ID	D	The order ID assigned by the PSP. Do not confuse with the ID created by Fraugster (frg_trans_id) or the ID of the order as captured by the merchant (order_id).