Exporting Reports
The order/transaction reports can be extracted from Verifone Central to help you keep track of your available data. This can be used to better extract statistics and validate merchant records. The export is a CSV file that can be processed manually or automatically.
You can customize a report template or select the following options:
Basic report will contain the same columns as the transaction table in Verifone Central.
Full report will export all transaction details which are available for export.
Customized report will export the report you or another user in your organization has created.
For more information on how to export a report check our available documentation.
Report fields
Below are definitions for all of the available fields in each report.
3DS authentication value
Cardholder Authentication Verification Value (CAVV). Base64-encoded values of 28 or 32 characters. Hex-encoded values of 40 or 48 characters.
N/A
N/A
3DS_authentication_value
3DS challenge indicator
This is a 2.0 required field. Possible values are 01, 02 to 09 and 90.
N/A
N/A
3DS_challenge_indicator
3DS enrollment status
The enrolment response status of authentication eligibility from the Directory Server.
N/A
N/A
3DS_enrollment_status
3DS scheme transaction ID
The unique transaction identifier assigned by the Directory Server. Supported for 3D Secure v2 only.
N/A
N/A
3DS_scheme_transaction_ID
3DS status
Authentication response code.
N/A
N/A
3DS_status
3DS version
The 3DS version used to process the transaction.
N/A
N/A
3DS_version
3DS white list status
Enables the communication of trusted beneficiary between the ACS, the Directory Server (DS) and the 3DS Requestor.
N/A
N/A
3DS_white_list_status
3DS white list status source
This data element will be populated by the system setting WhitelistStatus.
N/A
N/A
3DS_white_list_status_source
3DS XID
The transaction identifier assigned by Directory Server. Supported for 3D Secure v1 only.
N/A
N/A
3DS_XID
Account Type
Type of the account used for the payment (credit/debit).
N/A
account_type
Account_type
Acquirer
A type indicator to identify the acquirer of the payment.
N/A
N/A
Acquirer
Acquirer Account Type
A field that indicates how the transaction was processed by the acquirer (it can be either debit or credit).
N/A
acquirer_account_type
Acquirer_account_type
Acquirer Authorization Result
Authorization as received from the acquirer.
N/A
acquirer_authorisation_result
Acquirer_authorisation_result
Acquirer Merchant ID
Identifier assigned to the merchant and known by the acquirer (it is not supported by all the acquirers).
N/A
acquirer_merchant_id
Acquirer_merchant_ID(MID)
Acquirer Response Code
Description of the response received from the acquirer.
N/A
acquirer_response_code
Acquirer_response_code
Acquirer Response message
Acquired response message.
N/A
acquirer_response_message
Acquirer_response
Acquirer Settlement ID
An identifier given to a settlement by the acquirer.
N/A
N/A
Acquirer_settlement_ID
Actions
The available actions per transaction.
N/A
header.source.acquirer
N/A
Ancestor name
The ancestor name of the entity this transaction is attached to.
N/A
N/A
Ancestor_name
ARN
Acquirer Reference Number is the "transaction ID " set by the acquirer. It is usually used when communicating to banks and schemes.
N/A
arn
ARN
Authentication mode
The authentication types that were used to validate a payment.
N/A
N/A
Authentication_mode
Authorization Date Time
The date returned in the authorization response message.
N/A
N/A
Auth_date_time
Authorization Code
Value assigned by the acquirer for specific authorized transactions.
N/A
authorisation_code
Authorisation_code
AVS Result Code
Address verification services result code, which provides information about the outcome of the AVS check.
N/A
AVS_result_code
AVS_result_code
Batch Number
Batch or settlement date as assigned by the payment acceptor (in most cases Verifone) for the POI or merchant. This is not the same as the batch that can be assigned by the acquirer.
N/A
batch_id
Batch_ID
Bin Number*
The Bank Identification Number contains the first 6-8 digits of the Primary Account Number (PAN). The BIN (or a BIN range) is assigned to a card issuer.
N/A
card.bin
Card_bin
Capture Status
Identifier that indicates whether the transaction resulted in the capture of the authorization.
N/A
N/A
Capture_status
Cashback Amount
A part of the purchase price returned to the customer as a reward or incentive in a payment transaction.
N/A
cashback_amount
Cashback_amount
Cashier Name
Name of the cashier who created the transaction (not used for all the providers).
N/A
cashier_name
Cashier_name
Cashier ID
ID of the cashier who created the transaction (not used for all the providers).
N/A
cashier_ID
Cashier_ID
Card Issuer Country
The country where the card was issued.
N/A
card_issuer_country
Fee_configuration_card_issuer_country
Card Expiry Month
A 2 digit value displayed on the card indicating the month when the card will expire.
N/A
N/A
Card_expiry_month
Card Expiry Year
A 4 digit value displayed on the card indicating the month when the card will expire.
N/A
N/A
Card_expiry_year
Card Last Four
Last four digits of the PAN (Payment card number).
N/A
card.last_four
Card_last_four_digits
Card Number
Primary Account Number or Card Number. Displayed in a masked format.
N/A
masked_card_number
Masked_card_number
CAVV Result
The Cardholder Authentication Verification Value.
N/A
cavv_result
CAVV_result
Charitable Donation
A voluntary contribution made by a person or organization to a charitable cause or nonprofit organization in a payment transaction.
N/A
charitable_donation
Charity_donation_amount
Cheque Account Number
The masked cheque holder's account number.
N/A
cheque_account_number
Cheque_account_number
Cheque Number
The cheque sequence number.
N/A
cheque_number
Cheque_number
Confirm Date Time
Identifier that indicates the transaction capture date and time.
N/A
N/A
Confirm_date_time
Contract ID
An identifier used to identify a contract from a merchant perspective. As this may not be unique across gateways or scquirers, the UUID is used as the surrogate key.
N/A
N/A
PPC_ID
Created
Date when the transaction was made.
created_at_date
created_at_date
Creation_date
Creation date time
Date and time when the transaction was made.
N/A
N/A
Created_datetime
Creation time
Time when the transaction was made
created_at_time
created_at_time
Creation_time
Created at Timezone
The timezone of the creation date.
created_at_timezone
created_at_timezone
Timezone
Created at UTC
Date of creation according to the UTC timezone.
created_at_utc
created_at_utc
Created_in_UTC
Credit Term
Terms under which the transaction is performed.
N/A
credit_term
Credit_term
Cross border fee
A fee which is charged if the payer is coming from a different country than the merchant.
N/A
N/A
Cross_border_fee
Currency
Currency of the transaction.
Curr.amount currency code
Curr.amount currency code
Current_currency
Current Amount/ Transaction amount
Current amount of the transaction (after some actions). Also mapped as Transaction amount, which can be found under the Fee Details in the Details section.
Curr.amount
Curr.amount
Current_amount
Customer App Phone Number
The phone number to be used for the contact. If you include this property there should be at least one phone number.
N/A
customer.app_phone_number
Customer_ID
Customer Billing City
Shopper's billing city.
N/A
customer.billing.city
Customer_billing_city
Customer Billing Country Code
Shopper's country code.
N/A
customer.billing.country_code
Customer_billing_country
Customer Billing First Name
Shopper's first name as displayed in the address.
N/A
customer.billing.first_name
Customer_first_name
Customer ID/Payer ID
Identifier as a string for the customer. This is for the Verifone defined customer ID e.g from the customer service. The field is termed as Customer ID in the Customer Information section and as Payer ID in the Details tab of the transaction side-menu.
N/A
customer._id
Customer_app_phone
CVV Result
The result of a Card Verification Value check. The CVV or CVV2 will never be stored, but an indicator of the result can be captured.
N/A
N/A
CVV_result
Deferred Months
Number of months this payment is due for the cardholder.
N/A
deferred_months
Deferred_month
Device ID
Identifier used by an Estate Management System.
N/A
estate_management_id
Estate_management_ID
Device Serial Number
A value to indicate the device serial number.
N/A
device_serial_number
Device_serial_number
Due date
Date when the issuer will retrieve funds from the cardholder account.
N/A
due_date
Due_date
Electronic Commerce Indicator
Number that indicates the level of security used to retrieve the customer's payment credentials.
N/A
electronic_commerce_indicator
3D_secure_eci
Shopper email.
N/A
customer.email_address
Customer_email
Entry Mode
Entry mode of transaction that affects the fee amount. Only a subset of all possible key entry modes are relevant for the fee amount.
N/A
entry_mode
Fee_entry_mode
Exchange rate
(Only available for Wynid processor) The rate used to convert the local amount into the cardholder’s currency at the time of the transaction.
N/A
N/A
Exchange_rate
Fallback Transaction
A card entry mode used as an alternative after the initial card reading has failed.
N/A
fallback_transaction
Fallback_transaction
Fee Currency
Name of the currency used for paying the fee.
N/A
fee_currency
Processing_fee_currency
Fee configuration Card issuer country
The country of the card issuing bank used in the transaction. This field is part of the fee configuration details, identifying the card’s issuing country for acquiring and fee calculation purposes.
N/A
N/A
Fee_configuration_card_issuer_country
Fee Configuration Card Type
The card type (credit, debit or commercial) that influences the fee calculation.
N/A
payment_mode
Fee_configuration_card_type
Fraud score
The fraud score returned by the Fraud Protection Service.
N/A
fraud_score
Fraud_score
Fraud Reason Code
A code that indicates if a response code captured by the gateway is different that the one received by the acquirer or the issuer.
N/A
fraud_reason_code
Fraud_reason_code
Fraud Reason Insights
The list of reasons for the fraud score.
N/A
fraud_reason_insights
Fraud_reason_insight
Gratuity amount
A optional additional payment made by a customer to a service provider as a token in a payment transaction.
N/A
Gratuity_amount
Gratuity_amount
ID Check Result
ID check identifier used in regions where the customer's ID is used for verification.
N/A
id_check_result
Customer_ID_check
Instalment payment index
Field is applicable for Israel only. Possible values are:
index-linked
dollar-linked
N/A
issuer_instalment_payment_index
Issuer_installment_payment_index
Invoice number
Identifier of the invoice created for a transaction.
N/A
N/A
Invoice_number
Issuer Authorization Result
Identifier that determines how the transaction was authorized by the issuer.
N/A
issuer_authorisation_result
Issuer_authorisation_result
Issuer Instalment Down Payment Amount
The down payment amount required by the card issuer.
N/A
issuer_instalment_down_payment_amount
Issuer_instalment_down_payment_amount
Issuer Instalment Amount
The regular instalment amount required by the card issuer.
N/A
issuer_instalment_instalment_amount
Issuer_instalment_amount
Issuer Instalment Number of Instalments
The number of instalments that the total amount should be paid in.
N/A
issuer_instalment_number_of_instalments
Issuer_instalments_count
Merchant Country
Country the merchant is based in
N/A
merchant_country
Merchant_country
Merchant ID
Identifier assigned to the merchant and known by the merchant or client, whether this is an external client, client system or gateway, i.e., this field is for the MID used internally by VF.
N/A
merchant_id
Merchant_ID
Merchant Present
Identifier which signals whether the merchant was present or not during the transaction.
N/A
N/A
Merchant_present
Merchant reference
Merchant reference is a value (up to 50 characters) that is assigned by the merchant in each transaction for their own identification.
merchant_reference
merchant_reference
Merchant_reference
Message No
A number assigned by a transaction initiator (originator) to assist in identifying a transaction uniquely.
N/A
N/A
Message_no
Offline reason
Reason why transaction is processed offline.
N/A
offline_reason
N/A
Organization
Organization name.
Organisation
organisation.name
Organization_name
Organization ID
Organization ID.
N/A
Entity
Internal_organization_ID
Orig. Amount/ Total transaction amount
Initial amount of the transaction or total amount of the transaction. Also mapped as Total Transaction amount, which can be found under the Fee Details in the Details section.
Orig.amount
Orig.amount
Original_amount
Orig.amount currency code
Transaction payment currency.
Orig.amount currency code
Orig.amount currency code
Original_currency
Parent Transaction ID
Identifier populated only in case of follow-up transactions (capture, void or refund), indicates the transaction ID of the initial transaction (sale, authorization or preAuth) that was used to created the follow-up transaction.
N/A
N/A
Parent_transaction_ID
Payment Account Reference
A unique non-sensitive reference to the cardholder PAN (Payment Account Number).
N/A
Payment_account_reference
Payment_account_reference
Payment Document Provider
The service that generated the transaction receipt.
N/A
payment_document_provider
Payment_document_provider
Payment Document Type
The type of receipt that is generated for the transaction.
N/A
payment_document_type
Payment_document_type
Payment Document ID
Unique identifier of the document in internal or external datastore.
N/A
payment_document_id
Payment_document_ID
Payment method
A type of indicator for the card scheme.
N/A
payment_method
Payment_method
Payment Product Type
A type of indicator for the payment that is being processed (only used for Klarna).
N/A
payment_product_type
Payment_product_type
Pre-currency conversion amount
(Only available for Wynid processor) The amount of the transaction in the local currency before it was converted to the cardholder’s currency.
N/A
N/A
Pre_currency_conversion_amount
Pre-currency conversion currency
(Only available for Wynid processor) The currency code of the local currency used before conversion.
N/A
N/A
Pre_currency_conversion_currency
Processing Fee
An amount paid for the processing services provided by Verifone acquiring to the merchant (currently only used for transactions with Klarna).
N/A
Platform_fee
N/A
POI Name
An identifier used to represent the POI as generated by the estate manager. This is not the same as the TID, which will be derived from the relationship with an acquirer agreement.
N/A
poi_name
POI_name
Processor
Type indicator to identify the processor of the payment.
N/A
sourcePIM
Source_PIM
Processor Card Brand
A type indicator for the card scheme.
N/A
processor_card_brand
Processor_card_brand
Processor Acquirer Name
The name of the acquirer. Possibly derived from the acquiring Institution ID.
N/A
processor_acquirer_name
Processor_acquirer_name
Processor Issuer Name
The name of the card issuer. Possibly derived from the Issuer Code.
N/A
processor_issuer_name
Processor_issuer_name
Processor RRN
A corresponding RRN or reference number returned by the acquirer/ processor.
N/A
processor_rrn
Processor_RRN
Product
Payment method used to place the order.
Product
Product
Product
Provider transaction ID
Transaction ID generated by the provider.
N/A
processor_transaction_id
Processor_transaction_ID
PRM type
Types of transactions processed by PRM service.
N/A
N/A
PRM_type
Purchase Order Number
The number of the purchase as assigned by the merchant.
N/A
purchase_order_number
PO_number
Reporting group
(Only available for Wynid processor) Field used for reporting purposes. Could be passed ready value in FullRequest or the source of the field could be configurable and field value calculated at Pre-Processor. For instance, depending on the configuration the value could be cardBrand, cardProduct, accountType or combined.
N/A
Reporting_group
N/A
Response code
Where a Gateway maps a different response code to that received from Acquirer/Issuer that should be captured here.
N/A
N/A
Transaction_response_code
RRN
Retrieval Reference Number, may be used as reference against acquirers.
N/A
RRN
RRN
Sales Chanel
A type indicator that shows the sales channel used to capture the transaction. The indicator is used to enable the customer to specify the instrument (card) details. This may also indicate whether the customer is returning or not (if the account has any stored credentials), which can be identified by other elements of the authentication method and entry mode.
N/A
N/A
Sales_channel
Sales description
A reference used by the merchant to typically capture a description of the service provided. It could then be used by the merchant to help locate transactions.
N/A
sales_description
Sales_description
Sales Identifier
An external identifier from the POS or third-party for the transaction. Also known as 'customer transaction reference' or 'third party reference'.
N/A
third_party_transaction_reference
Third_party_reference
Scheme Identifier
Identifier sent by the acquirer in the authorization response message, and sent in a subsequent authorization request messages associated with the same transaction.
N/A
N/A
Scheme_identifier
Settlement Batch ID
Identifier assigned to a settlement batch.
N/A
settlement_id
Settlement_ID
Settlement date
Settlement date.
N/A
settlement_date
Settlement_date
Shipping address
Shopper shipping address.
N/A
shipping_information.address
Customer_shipping_address
Shipping Information City
Shopper shipping city.
N/A
shipping_information.city
Customer_shipping_city
Shipping Information Country
Shopper shipping country.
N/A
shipping_information.country
Customer_shipping_country
Shipping Information Email
Shopper email.
N/A
shipping_information.email
Customer_shipping_email
Shipping Information First Name
Shopper first name.
N/A
shipping_information.first_name
Customer_shipping_name
Shopper Interaction
Type of software/hardware interface from which payment has been made.
N/A
shopper_interaction
Channel
Shipping Information Phone
Shopper phone number.
N/A
shipping_information.phone
Customer_shipping_phone
Shipping Information Postal Code
Shipping address post code.
N/A
shipping_information.postal_code
Customer_shipping_postal code
Shipping Information State
Shopper shipping state.
N/A
shipping_information.state
Customer_shipping_state
Sim card identifier (ICCID)
The Subscriber Identity Module Serial Number (SSN) is a 19 or 20 digit unique number that identifies an individual SIM card. The SSN may also be referred to as an Integrated Circuit Card ID (ICCID).
N/A
N/A
SSN_ICC_ID
Site Reference
An identifier for the site that is unique to the merchant organization. It is used to locate the instance of a site.
N/A
site_reference_id
External_site_reference_ID
State / Status
Displays details on the current transaction state./ Status of the transaction.
status
status
Transaction_state
STAN
Verification method for API calls. Verification is done through a number that is assigned by a counter in the gateway (or the terminal) to identify the uniqueness against acquirers. The length of STAN will depend upon acquirer.
N/A
STAN
STAN
Stored Credential Reference
Reference to the signup request.
N/A
N/A
Stored_credential_reference
Stored Credential Type
A signup or enrolment request for the stored credentials. A subsequent charge request for the stored credentials, related to a previous signup
N/A
stored_credentials_type
Stored_credential_type
Stored Identifier
An identifier generated from the POS or a third-party for this transaction.
N/A
N/A
Store_identifier
Surcharge fee
Processing fees or additional costs applied to customers, included in the original purchase price.
N/A
Surcharge_amount
Surcharge_amount
Tax Amount
The amount of tax to be paid on the purchase
N/A
tax_amount
Tax_amount
Tax discount
The total amount of any tax discount applied to the transaction. This value represents the portion of the transaction that has been reduced due to tax-related discounts.
N/A
N/A
Tax_discount
Tax Indicator
An indicator denoting whether sales tax must be paid on the purchase or not.
N/A
tax_indicator
Tax_indicator
Technology
Entry mode (breakdown of cards like mag stripe, chip insert or contactless).
N/A
technology
Payment_technology
Terminal ID
Identifier assigned to POI and known by the merchant or client, whether this is an external client, client system or gateway.
N/A
terminal_id
Terminal_ID
Terminal manufacturer
Optional value to indicate, where known, the Manufacturer of the Device.
N/A
N/A
Terminal_manufacturer
Token Type
Identifier that indicates the type of instrument used in the transaction.
N/A
token_type
Token_type
Transaction Description
An arbitrary string attached to a transaction or payment object for descriptive purposes. This would correspond to the Alipay 'memo' property.
N/A
transaction_description
Transaction_description
Transaction fee
Fees applicable for the transaction.
N/A
payment_processing_fee_amount
Processing_fee
Transaction ID
ID of the transaction.
N/A
_id
Transaction_ID
Transaction Online Flag
Identifier that specifies if the transaction was submitted online or was captured offline and subsequently submitted to the processor or acquirer.
N/A
N/A
Transaction_online_flag
Transaction timezone
Timezone of the transaction.
N/A
N/A
Transaction_timezone
Transaction Reference
Unique ID of the transaction, generated by the acquirer's system.
Reference
Reference
Reference
Transaction type
Type of the transaction. See more in Transaction Types and Statuses.
Type
N/A
Transaction_type
User agent
The full user agent string of the device the customer used to submit the transaction.
N/A
user_agent
Browser_version
Verifone Terminal ID
An identifier assigned to a Point of Interaction (POI) and known by the merchant or client, This field is for the TID used internally by VF.
N/A
N/A
Internal_terminal_ID
Wallet
Wallet type.
N/A
N/A
Wallet
Last updated
Was this helpful?