Wiki/Statement Excel Field Limits

From Barion Documentation
Jump to navigation Jump to search

Statement Excel Export Field Limits

A statement Excel export contains 14 columns

Fields that are not applicable to a given transaction show a dash

Column header Data type Maximum length Notes
Transaction Time string (DateTime) 22 characters Locale-dependent:
  • en-US: MM/dd/yyyy hh:mm:ss tt
  • hu-HU: yyyy/MM/dd/ HH:mm:ss
  • cs-CZ / sk-SK: dd/MM/yyyy hh:mm:ss tt
  • de-DE: dd/MM/yyyy hh:mm:ss
Transaction type string 100 characters Length depends on transaction type and language, never exceeds 100 characters
Customer/beneficiary string 256 characters Email address or display name of the beneficiary
Transaction Amount numeric (decimal) - The locale-specific-formatted amount of the transaction. Deposits are positive, and withdrawals are negative. Displayed with 0 decimal places for HUF, 2 decimal places for all other currencies
Balance after transaction numeric (decimal) - The locale-specific-formatted balance of the Barion Wallet after the transaction
Currency string 3 characters The 3 character ISO 4217 currency code of the payment
Own transaction id string 100 characters The identifier of the transaction generated by the webshop associated with it, if applicable. Empty if the transaction is not a payment
Own payment id string 100 characters The identifier for the payment generated by the webshop that requested it, if the entry is a payment and a webshop is involved. Empty if the transaction is not a payment
Payment identifier in Barion Guid 32 characters Barion's GUID for the payment, empty if the transaction is not a payment
Transaction identifier in Barion Guid 32 characters Barion's GUID for the transaction
Order number string 100 characters The identifier generated by the webshop associated with the transaction, if applicable, to identify the order that the transaction was part of, if applicable
Bank card number string 50 characters Last four digits of the debited or credited bank card. Only applies to transactions credited to or debited from a bank card, empty if the transaction is not a payment
Authorization code string 100 characters The authorization code received by the card processing system when executing the payment. Empty if the transaction is not a payment
Comment string 800 characters 800 characters maximum, though the length limit depends on how the comment was created, for example bank transfer comments are limited to 90 characters and payment transaction comments to 640 characters