Transactional reports

The transactional reports generated can be uploaded periodically on our SFTP server where you can download them from and process them automatically. Please request login details from support@smart2pay.com.

The transactional reports are available in CSV format. By default these reports are generated every Friday (weekly) but upon request the frequency can be changed to daily.

Below there are examples of transactional reports in CSV format:

  1. All transactions initiated, no matter the status of the payment: MerchantDemo_ATTEMPTS_2018_07_07;

    The generated transactional report contains transactions with all the statuses we process for your merchant account.

  2. The transactions with Success status: MerchantDemo_SUCCESS_2018_07_07;

    In case a transaction was exported with a status (any status except Success), but at a later time the status changed to Success (and only Success), GlobalPay will notify again the payment with the success status and the payment will be exported in a separate report (the format is the same) and the report filename ends in “_success”.

    1 Transactional report</p

    The transactional report file with Success transactions contains the following information:

    Id
    Id
    Definition
    GlobalPay transaction ID, a unique number that identifies the transaction in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
    – GlobalPay transaction ID, a unique number that identifies the transaction in the GlobalPay system;
    MerchantTransactionID
    MerchantTransactionID
    Definition
    Merchant Transaction ID, a number that uniquely identifies a transaction in your system.
    Type
    string
    Regex
    ^[0-9a-zA-Z_-]{1,50}$
    – Merchant Transaction ID, a number that uniquely identifies a transaction in your system;
    InputDateTime
    InputDateTime
    Definition
    Date and time when the transaction was created in GlobalPay system.
    Type
    datetime
    – Date and time when the transaction was created in GlobalPay system;
    Status
    Status
    Definition
    The status of the transaction. It can have the following values: Open, Success, Cancelled, Failed, Expired, Authorized.
    Type
    string
    – The status of the transaction. It can have the following values: Open, Success, Cancelled, Failed, Expired, Authorized;
    MerchantAmount
    MerchantAmount
    Definition
    The amount of the transaction.
    Type
    int
    Regex
    ^\d{1,12}$
    – The amount of the transaction;
    MerchantCurrency
    MerchantCurrency
    Definition
    The currency in which the transaction was initiated. Format is according to ISO 4217, a three-letter code.
    Type
    string
    Regex
    ^[A-Z]{3}$
    – The currency in which the transaction was initiated;
    MethodID
    MethodID
    Definition
    The ID of the payment method.
    Type
    int
    Regex
    ^([0-9]{1,10})$
    – The ID of the payment method;
    ReportedByBOTOperatorDate
    ReportedByBOTOperatorDate
    Definition
    The date when the transaction was exported in a SFTP/CSV file.
    Type
    datetime
    – The date when the transaction was exported in a SFTP/CSV file;
    CapturedAmount
    CapturedAmount
    Definition
    The payment‘s captured amount.
    Type
    int
    Regex
    ^\d{1,12}$
    – The payment‘s captured amount;
    MethodName
    MethodName
    Definition
    The name of the payment method used.
    Type
    string
    – The name of the payment method used;
    PaymentStateDefID
    PaymentStateDefID
    Definition
    The ID of the payment status. It can have the following values: 1 - Open, 2 - Success, 3 - Cancelled, 4 - Failed, 5 - Expired, 9 - Authorized.
    Type
    int
    – The ID of the payment status;
    SpecificDetails
    SpecificDetails
    Definition
    Specific details provided.
    Type
    string
    – Specific details provided;
    ReconciliationProviderID
    ReconciliationProviderID
    Definition
    A payment identification ID used at the provider’s end.
    Type
    int
    – A payment identification ID used at the provider’s end;
    ProviderTransactionID
    ProviderTransactionID
    Definition
    Internal ID used for payment notification within our system.
    Type
    int
    – Internal ID used for payment notification within our system;
    MerchantAlias
    MerchantAlias
    Definition
    Your merchant alias in our system.
    Type
    string
    – Your merchant alias in our system;
    MerchantSiteID
    MerchantSiteID
    Definition
    GlobalPay website ID, a unique number that identifies the website in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
    – The ID of your site in our system;
    MerchantSiteAlias
    MerchantSiteAlias
    Definition
    Site alias, an alternative name that identifies the website in the GlobalPay system.
    Type
    string
    Regex
    ^.{1,255}$
    – Your site alias in our system;
    RootProviderTransactionID
    RootProviderTransactionID
    Definition
    The transaction ID from the provider.
    Type
    int
    – The transaction ID from the provider;
    Country
    Country
    Definition
    Customer‘s country. Format is according to ISO-3166-1 alpha-2, a two-letter code.
    Type
    string
    Regex
    ^[a-zA-Z]{2}$
    – When available, it containts the customer billing country.
  3.  

  4. The list of refunds: MerchantDemo_REFUNDS_2018_07_07;

    1 Refunds report

    The refunds report file contains the following information:

    Id
    Id
    Definition
    GlobalPay Refund ID, a unique number that identifies the refund in the GlobalPay system
    Type
    int
    Regex
    ^\d{1,12}$
    – GlobalPay Refund ID, a unique number that identifies the refund in the GlobalPay system;
    RefundRequestDate
    RefundRequestDate
    Definition
    Date and time when the refund was created in GlobalPay system
    Type
    datetime
     – Date and time when the refund was created in GlobalPay system;
    EntryDate
    EntryDate
    Definition
    Date and time when the refund was created in GlobalPay system
    Type
    datetime
     – Date and time when the refund was created in GlobalPay system;
    MethodName
    MethodName
    Definition
    The name of the payment method used
    Type
    string
     – The name of the payment method used;
    Customer
    Customer
    Definition
    When available, the Customer Name is being displayed in this field
     – When available, the Customer Name is being displayed in this field;
    MerchantTransactionID
    MerchantTransactionID
    Definition
    Merchant Transaction ID, a number that uniquely identifies a transaction in your system
     – Your Merchant Transaction ID – can be used for reconciliation;
    Amount
    Amount
    Definition
    The amount of the refund in the currency in which the refund was initiated
     – The amount of the refund in the currency in which the refund was initiated;
    Currency
    Currency
    Definition
    The currency in which the refund was initiated
     – The currency in which the refund was initiated;
    ToBeInvoiced
    ToBeInvoiced
    Definition
    if a fee is applied against the refund or not
     – if a fee is applied against the refund or not;
    PaymentID
    PaymentID
    Definition
    ID of the initial payment for which the refund was made
     – ID of the initial payment for which the refund was made;
    TrxDate
    TrxDate
    Definition
    The data and time when the initial transaction was initiated in our system (UTC)
     – The data and time when the initial transaction was initiated in our system (UTC);
    OtherDetails
    OtherDetails
    Definition
    Any other additional information
    ;
    Merchant
    Merchant
    Definition
    Your merchant alias in our system
    Type
    string
     – Your merchant alias in our system;
    SiteID
    SiteID
    Definition
    GlobalPay website ID, a unique number that identifies the website in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
     – The ID of your site in our system;
    RefundType
    RefundType
    Definition
    The type of refund: Native, SEPABankTransfer, SWIFTBankTransfer, ManualSupportWorkNoInfo, SEPABankTransferNoInfo, SWIFTBankTransferNoInfo, LocalBankTransfer, LocalBankTransferNoInfo, ManualSupportWorkDetailsNeeded, LocalBankTransfer2API
     – the type of refund: https://docs.smart2pay.com/category/refunds-api/refund-types/;
    PayerEntity
    PayerEntity
    Definition
    The source of the refund entity (usually Smart2Pay entity)
     – the source of the refund entity (usually Smart2Pay entity);
    PayerAccount
    PayerAccount
    Definition
    Smart2Pay Account, when applicable
     – Smart2Pay Account, when applicable;
    PayerBIC
    PayerBIC
    Definition
    Smart2Pay BIC, when applicable
     – Smart2Pay BIC, when applicable;
    Country
    Country
    Definition
    Customer‘s country. Format is according to ISO-3166-1 alpha-2, a two-letter code.
    Type
    string
    Regex
    ^[a-zA-Z]{2}$
     – When available, it contains the customer billing country;
    ReconciliationProviderID
    ReconciliationProviderID
    Definition
    A payment identification ID used at the provider’s end
     – The transaction ID from the provider.
  5.  

  6. The list of refunds for SmartCards payment method: MerchantDemo_SMARTCARDS_REFUNDS_2018_07_07.

    1 SmartCards Refunds report

    The SmartCards refunds report file contains the following information:

    ID
    ID
    Definition
    A unique number that identifies the refund in the Smartcards system
    Type
    int
    Regex
    ^\d{1,12}$
     – a unique number that identifies the refund in the Smartcards system;
    MerchantAlias
    MerchantAlias
    Definition
    Your merchant alias in our system
    Type
    string
     – Your merchant alias in our system;
    MerchantSiteAlias
    MerchantSiteAlias
    Definition
    Your site alias in our system
    Type
    string
     – Your site alias in our system;
    MerchantSiteID
    MerchantSiteID
    Definition
    The ID of your site in our system
    Type
    string
     – The ID of your site in our system;
    MerchantTransactionID
    MerchantTransactionID
    Definition
    Merchant Transaction ID, a number that uniquely identifies a transaction in your system.
    Type
    string
    Regex
    ^[0-9a-zA-Z_-]{1,50}$
     – Merchant Transaction ID, a number that uniquely identifies a transaction in your system;
    InputDateTime
    InputDateTime
    Definition
    Date and time when the transaction was created in GlobalPay system.
    Type
    datetime
     – Date and time when the refund was created in the Smartcards system;
    InitialPaymentID
    InitialPaymentID
    Definition
    ID of the initial payment for which the refund was made
     – ID of the initial payment for which the refund was made;
    MerchantAmount
    MerchantAmount
    Definition
    The amount of the refund
     – The amount of the refund;
    MerchantCurrency
    MerchantCurrency
    Definition
    The currency in which the refund was initiated
     – The currency in which the refund was initiated;
    Status
    Status
    Definition
    The status of the refund. It can have the following values: Open, Success, Failed.
    Type
    int
     – The status of the refund. It can have the following values: Open, Success, Failed;
    MethodName
    MethodName
    Definition
    The name of the payment method used
     – The name of the payment method used;
    ProviderTransactionID
    ProviderTransactionID
    Definition
    Internal ID used for payment notification within our system.
    Type
    int
     – The transaction ID from the provider;
    RefundType
    RefundType
    Definition
    The type of refund: Native - is the only one available at the moment
     – the types of refund: https://docs.smart2pay.com/category/refunds-api/refund-types/;
    ReportedByBOTOperatorDate
    ReportedByBOTOperatorDate
    Definition
    The date when the transaction was exported in a SFTP/CSV file
    Type
    datetime
     – The date when the transaction is exported in a SFTP/CSV file;
    Bookdate
    Bookdate
    Definition
    Bookdate
     – The date when the transaction is reported by the bank.