SRS Web Service Reports
Segpay recommends that reporting services are used in conjunction with the postback notification system.
There are several benefits:
- 
                                                            
Pulling data from reporting services provides a backup in case postbacks don’t go through.
 - 
                                                            
You can pull data from reporting services on a set schedule, for use as a reconciliation tool. We recommend you pull transaction data from the previous day’s transactions only. As a reminder, the Segpay system operates on GMT.
 
For more information about Segpay's reporting services, please see:
Data Availability Chart
| Data Element | Definition | SRS | Postbacks | 
|---|---|---|---|
| URL | Website | X | 
                                                                     X  | 
                                                            
| Transaction ID | n/a | X | X | 
| Related Transaction ID | Original transaction ID associated with a chargeback, refund, or void | X | X | 
| Transaction Time | Time Stamp of transaction | X | X | 
| Type | Sale, voice, refund, chargeback, one-click | X | X | 
| Source | Sign-up, conversion, rebill, system | X | X | 
| Auth | Yes or No | X | X | 
| Transaction Amount | n/a | X | X | 
| Currency | n/a | X | X | 
| AuthCode | Bank response to an authorization or decline | X | |
| Purchase ID | n/a | X | X | 
| Purch Type | Identifies if one time, recurring, digital purchase, instant conversion. | X | |
| Customer Name | n/a | X | X | 
| Customer Email | n/a | X | 
                                                                     X  | 
                                                            
| Customer Address | n/a | X | X | 
| Customer City | n/a | X | X | 
| Customer State | n/a | X | X | 
| Customer Zip | n/a | X | X | 
| Customer Country | n/a | X | X | 
| Customer Phone | n/a | X | X | 
| Customer IP | n/a | X | X | 
| IP Country | n/a | X | |
| Username | n/a | X | X | 
| Purchase Status | Status of the subscription (active, canceled, expired) | X | |
| Initial Amount | Sign-up Amount | X | X | 
| Recurring Amount | n/a | X | X | 
| Recurring Period | n/a | X | X | 
| Next Date | Next rebill date | X | |
| Cancel Date | Date consumer canceled | X | |
| Expired Date | Date membership expires | X | |
| Retries | n/a | X | |
| Last Result | Identifies the approval or decline result of most recent transaction. | X | |
| Merchant Partner ID | The affiliate ID passed in by the merchant. | X | X | 
| eticketID | This is the package ID and bill config ID to identify the price point and website the purchase was made to. | X | X | 
| REF Variables | Up to 10 variables that you pass through (REF1 - REF10) | X | X | 
| UserData | Grouping of all user-defined variables passed through by the merchant. In the SRS reports it also includes paypage languages and browser type/version. | X | X | 
| Bin / First 6 | First 6 credit card digits | X | X | 
| Last 4 | Last 4 credit card digits | X | X | 
| Bin Country | Country where BIN is from | X | |
| Refund entered by | n/a | X | |
| Refund Reason Code | n/a | X | |
| Refund Comment | n/a | X |