The first view you see after login is ' Payments '. The table of payments is empty if there are no payments satisfying the filter parameters.
Filter
To hide the filter you should press the extra icon (marked by a red arrow in the figure below):
To show the filter you should press the header “Search payment” (marked by a red arrow in the figure below):
The current payment search filters are displayed in the Search section, which carried out the sample data in the table.
The following buttons exist on all the tabs:
Find | Displays the payments satisfying the filter parameters. |
Clear | Clears all specified filter parameters on the current tab. |
Hide the current filter. |
The parameters that are specified on the tab are taken into account while deriving the results (parameters are joined by 'AND' operator).
Parameters, which can be specified are listed in the table below:
Parameter name | Description |
Group of payment means | Drop-down list of means groups (All (by default), card, E-wallet, other). |
Mean type | Drop-down list of means types (VISA, AMEX, CASH and etc.), please at first select the type of payment mean. |
Date from | Begin of the period for the displayed payments. The day, month, year, hour, and minutes can be specified. The date can be chosen using the calendar. |
Date to | End of the period for the displayed payments. The day, month, year, hour, and minutes can be specified. The date can be chosen using the calendar. |
Result | Drop-down list of payment processing results on the payment gateway side. |
Mean number | Search by this field ignores the other fields (for example, time period or type of payment means), it is performed over all transactions available to the current user. |
Payment number | Number of the payment in the external system. |
Amount from | The lower limit of the payment amount for the search. |
Amount to | The upper limit of the payment amount for the search. |
Merchant | The merchant ID should be specified here. Here SOFI merchant ID is used. You can use the search button 'Select' to find a merchant (the search is described below). |
Risk | Drop-down list: All , Clear , Suspicious , Fraud. (Details about the fraud probability you can find below). |
Card holder | Search performed by full match but it is not case-sensitive. Search value can be specified by mask (see description below). |
Customer e-mail | Search performed by full match. |
Mobile phone | Search by payer mobile phone number, performed by full match. |
Sorting | Default sort order of entries in the table is in order of decreasing date of payment. You can change the sort order of records in the table by selecting options from the drop down list. |
Pressing the button 'Select' opens the search window.
The search can be performed by merchant identity from SOFI or by name. The search results are displayed in a table. The search is performed among those merchants whose payments are available for review according to the user rights, if this merchant has any payments in SOFI.
Search by mask
It is possible to use pattern symbols '_' and '%' in search criteria by text fields. The underscore symbol '_' is used for the one symbol replacement. The percent symbol '%' is used for replacement of any number of symbols.
Examples:
Test_C – TestAC, TestBC will be found, but TestABC will not match.
Test%C – TestAC, TestBC, TestABC will be found, but TestABCD will not match.
Test%C% – TestAC, TestBC, TestABC, TestABCD, TestABCDEF and etc. will be found.
List of payments
Each payment is displayed as a row in the result table.
The buttons in upper part of the screen displays numbers of fraudulent and suspicious payments after preparing of request results in accordance with the search filter.
You can apply the search filter "Risk" to the results of the query by clicking on one of these buttons. Information about each payment is shown in the table in the corresponding color.
Common list of payment parameters is in the table:
Parameter name | Icon | Comment |
Order | The parameters of the order, which was paid: · BillNumber - bill number in the external system; · OrderNumber - number of order in the external system; · Merchant ID - merchant identity number (external merchant ID); · Merchant - merchant name. Clicking on the icon takes you to the detail of this order. | |
Date | Payment date in format DD.MM.YYYY HH:MM. | |
Payment | Payment parameters: · Payment ID in the external system; · Status of the payment in the external system. | |
Amount | Original payment amount, the icon corresponds to the currency of payment. | |
Payment mean | Payment mean parameters: · Payment mean number (masked); · Payment mean holder; · Expiration date; · Issuer bank name; · Country of the issuer bank. The icon corresponds to the group and type of payment mean. | |
Payer | Payer parameters: · Last and first name of payer; · E-mail address; · Merchant's internal customer identification; · Phone number. | |
Risk |
| Risk parameters: Fraud percentage; Reasons for the fraud-status determination. Each reason for the fraud-status has its own icon: · fraud-status was determined by the mathematical modeling methods; · corresponds to the 'clear' fraud-status but no checks were performed by mathematical modeling methods as insufficient data were provided for the payment; · corresponds to the 'clear' fraud-status but no checks were performed; · fraud-status was determined by expert; · according to 'Black list' of payment attributes; · according to trust 'white-list' of payment attributes; · according to allowing white list, when payment attributes are out of that list; · by corresponding to the filter on card number; · by corresponding to the filter on E-mail; · by corresponding to the filter on unique payer identity values under application/service of external system; · payment was successfully checked by mathematical methods and passed all filters but some characteristics of payment look like payments that were considered as fraudulent; · by corresponding to the filter on customer country (country is determined by customer IP-address); · by corresponding to the filter on issuer-bank country; · by corresponding to the filter on IP-address; · due to the card belonging to list of trusted cards; · due to the IP belonging to list of trusted IP-address; · due to fraud-lists from bank; · by corresponding to the filter on customer phone number; · in accordance with the limit (based on aggregated payments for a certain period) for the merchant, external system or the payment application. |
Device |
| Description of the user device, which is used for payment. Each type of device its own icon: · computer; · phone. |
At the bottom of the screen are some controls for configuring of displayed information.
Configures number of rows to be shown on the page (select the value from the drop-down box), in the result will be shown not more than specified number of payments on each page. | |
You can go to the last page by pressing “»»»»” button or return to the first page by pressing “««««”.The next page of the payments is available by pressing “»” button and you can go on previous page by button “«”. |
Payment details
Clicking on detail icon (
) on some payment opens a new window with detailed information about the payment.The following parameters are displayed in this window:
Parameter name | Comment |
Payment ID (payment identity) | |
Processing | |
CODE: | Operation execution code (from processing center). Each processing center uses its own codes. |
DATE | Date of a payment transaction execution in processing center. UTC data (GMT-0) or GMT+ hour-offset. |
RESPONSE | The result code of payment from processing center. |
RRN/STAN: | · Retrieval Reference Number (formed by processing center by its own algorithm) for processing centers which transmitting RRN (currently: BPC, BPCBel, RAIF, SviazBank, MBank, AmexPOA and MULT-family) or · another possible transaction number. |
Card | |
Type (subtype) of card | Type (Visa, for example), subtype (Electron, for example) of card. |
Country | Country of the issuer bank |
Card number | Bank card number (first 6 and last 4 digits only). |
Card holder | Card holder (full name). |
VALID THRU: | Expiration date |
Bank | Issuer bank name |
| Did the CSC were entered: · yes; · no. |
| The 3DSecure authorization results: · success; · not success; · attempt; · unknown. |
| The result of 3DSsecure involvement check: · involved; · not involved; · unknown; · error appears during the involvement check. |
Suspicious | |
Statistical analysis | Statistical analysis has revealed <the mathematical model score percentage>% fraud. |
Neural network analysis | Neural network analysis has revealed <the mathematical model score percentage>% fraud. |
Method of constructing CART | The analysis by constructing CART (Classification and Regression Tree) found <the mathematical model score percentage>% fraud. |
Expert mark | Expert set payment fraud suspicious as <score percent that were set by expert>. |
The total score: | Possible values of status - Neat, Suspicious, Fraud. |
Ad parameter into list: | |
Card number | Add the payment mean of current payment to the list. |
Add E-mail address of current payment’s payer to the list. | |
User ID | Add user ID of current payment’s payer to the list. |
Reason | The reason for adding the parameter(s) to the list. |
The result of pressing one of the buttons displayed at the top of the payment details window:: | · Blocked – the number of mean of payment and E-mail address are being added to the "black" lists, and if these values were presented in the corresponding "white" lists, they are become inactive there; the user ID is added to the domain filter. ID пользователя добавляется в доменный фильтр. · Checked - the number of mean of payment and E-mail address are being added to the "grey" lists, and if these values were presented in the corresponding "white" or "black" lists, they are become inactive there; the user ID is become inactive in the domain filter, if this value was presented there. · Trusted - the number of mean of payment and E-mail address are being added to the "white" lists, and if these values were presented in the corresponding «grey» or "black" lists, they are become inactive there. |
Device info | |
Client_Browser_Platform | Browser platform name. |
Client_COOKIES | Unique identity of the payment service user in an external system. |
Client_JAVA | Java script support enabled indicator. |
CLIENT_JS_BROWSER_NAME | Customer browser name. |
CLIENT_JS_VER | Java script interpretator version. |
CLIENT_LOCAL_TIME | Customer local time. |
See more | Button for getting more information about payment. |
By choosing of «See more» option the additional window is opened to show the extended details of the payment. It contains several sections, which can be expanded by click on theirs headers:
Parameter info | Description | |
Payment info (Payment ID) | ||
Date | Payment date in SOFI | |
External system | Name of the external system which provided the payment data | |
Merchant | Merchant name | |
Order number | Number of order | |
Bill number | Bill number | |
Payment ID | ID of the payment in the external system | |
Amount | Original payment amount | |
Currency | Original payment currency | |
Payment result | Status of the payment in the external system | |
Risk | Percentage of fraud suspicion (description is below) | |
Test mode | Yes/No | |
Recurring indicator | Yes/No | |
Two-step schema | Yes/No | |
Mean info (6 first and 4 last digits of the card number) | ||
Type | Visa, for example | |
Subtype | Electron, for example | |
Exp. date | Expiration date | |
Card holder | Card holder (full name) | |
Country | Country of the issuer bank | |
Bank | Issuer bank name | |
CSC provided | Did the CSC were entered (yes/no) | |
3DSsecure authorization result | The 3DSecure authorization results (Y - success, N – not success, A - Attempt, U – unknown) | |
3DSsecure involvement check result | The result of 3DSsecure involvement check (1 – involved, 0 – not involved, -1 – unknown, null – error appear during the involvement check) | |
Corporate card | Yes/No | |
Client info (last and first name of payer) | ||
Payer E-mail provided in order | ||
Phone | Payer phone number | |
Mob. phone | Payer mobile phone number | |
IP | IP-address of the payer | |
Country of IP | Country determined by IP | |
Country | Payer country specified during order payment | |
State/Region | Payer state/region specified during order payment | |
City | Payer city specified during order payment | |
Address | The address specified during order payment | |
Additional info | ||
The data on the user's system environment | ||
Processing data | ||
Approval code | Operation execution code (from processing center). Each processing center uses its own codes. | |
Process date | Date of a payment transaction execution in processing center. UTC data (GMT-0) or GMT+ hour-offset. | |
Response code | The result code of payment from processing center. | |
Response comment: | Explanation of the result code from the payment processing center. | |
RRN or STAN: | · Retrieval Reference Number (formed by processing center by its own algorithm) for processing centers which transmitting RRN (currently: BPC, BPCBel, RAIF, SviazBank, MBank, AmexPOA and MULT-family) or · another possible transaction number. | |
Product data | ||
Billing number | Abonent's id number, according to the type of billing, for payment of goods and services. | |
Billing type | The type of subscription contract for the provision of telecommunications services, etc. | |
Air data (additional flight data, details in a special document) | ||
Passengers | ||
Route | ||
Time of departure | ||
PNR | ||
Application and device data | ||
Mobile device ID | Unique number of the user device (UDID, IMEI, MEID, ESN or IMSI). | |
Device | Description of the user device, which is used for payment. | |
Application | Name of the application, which is used for payment. | |
Application version | Version of the application, which is used for payment. | |
MAC-address | MAC address of the user device. | |
Android ID | ID of Android device. | |
Latitude (deg.) | Geographic latitude coordinates defining the position of the payer on the Earth's surface. Specified in degrees. For example, 55.755831. | |
Longitude (deg.) | Geographic longitude coordinates defining the position of the payer to the Earth's surface. Specified in degrees. For example, 37.617673. | |
Suspicious | ||
Testing was not performed due to lack of payment details. | If not enough data was been transferred for analysis. | |
Fraud checking is disabled for the merchant | If the payments are verified by the expert | |
Statistical analysis has revealed <the mathematical model score percentage>% fraud, neural network analysis has revealed <the mathematical model score percentage>% fraud. The analysis by constructing CART (Classification and Regression Tree) found <the mathematical model score percentage>% fraud. | If the payment has passed the check by mathematical models. | |
Expert set payment fraud suspicious as <score percent that were set by expert> | If the payment has evaluated by expert. | |
There are dangerous signs of the payment: | Suspicious data are displayed | |
Can’t resolve the client IP | ||
Card is in the 'Black list' of cards | ||
Email is in the 'Black list' of e-mails | ||
Cookie is in the 'Black list' of cookies | ||
Cookie support is switched off | ||
JavaScript support is switched off | ||
Payer conducted fraudulent payments (number of payments) | ||
There are similar fraudulent payments (number of payments) | ||
Payer country and country of IP mismatch | ||
Payer country and card country mismatch | ||
Country of IP and card country mismatch | ||
No CSC were provided during the payment | ||
Mismatch of the payment parameters repeatability | ||
Card holder and payer name mismatch | ||
Address without any digit | ||
The total score of the payment fraud: <Status> | Possible values of status - Neat, Suspicious, Fraud. |
In the field ‘Fraud Suspiciousness’ is shown the SOFI conclusion about the payment suspicion (final scoring) is derived based on estimates of the mathematical models, expert conclusions and other reasons. The reason, by which the final scoring was set, is displayed in brackets.
The evaluations of mathematical models and expert are varies in range from 0 to 100% while the value displayed in the column 'Fraud probability' can take only three values - 0%, 50%, 100%, which means respectively - 'Neat', 'Suspicious', 'Fraud' payment.
Additional user settings and export to csv
For comfortable work with SOFI software interface, the user can also choose the display language:
If you change the display language you should re-login into the system to download the necessary data in the selected language.
Thus, the user does not need to reconfigure the language when he/she changed the browser or cleared cookies; the language setting for user is stored in a database for later use.
For export of all displayed payments press the icon in the upper-right corner:
A Zip file will be created with a name like AFSPayments_YYYYMMDDhhmmss (where YYYY – year, MM – month, DD – day, hh – hour, mm – minutes, ss – seconds of the moment of the file export in GMT time zone).
Archive contains two file - export.csv and README.
README file is a standard text file. It contains the information about creation date, character encoding:
generated: 2013.01.09 15:10:26 GMT encoding: UTF-8 format: CSV ESCAPE_CHARACTER: " QUOTE_CHARACTER: " SEPARATOR: , Filters: Period: 2013.01.09 00:00:00 - 2013.01.09 00:00:00
File export.csv format and about filters which were used to select the payments. File export.csv is a standard CSV file which can be opened in the MS Excel or OpenOffice Calc. To open file export.csv in MS Excel you should:
- open empty book and select from menu Data -> From Text-> Import data from a text file;
- select the file export.csv to import;
- using the Import wizard:
- on step 1: set that it is file with delimiters, select appropriate encoding (UTF-8 is recommended);
- on step 2: Select semicolon (';') as delimiter;
- on step 3: Select the data type 'Text' for the first column;
- on the last step: you should specify the list of the book that will be used for import.
File contains all the payments that fit the filter parameters, but not only those that displayed on one page.