Wiki/Statement Excel Field Limits: Difference between revisions

From Barion Documentation
Jump to navigation Jump to search
[email protected] (talk | contribs)
Created page with "== Statement Excel Export Field Reference == A statement Excel export contains 14 columns Fields that are not applicable to a given transaction show a dash {| class="wikitable api-table" !Column header !Data type !Maximum length !Notes |- |'''Transaction Time''' |string (DateTime) |22 characters |Locale-dependent: * en-US: <code>MM/dd/yyyy hh:mm:ss tt</code> * hu-HU: <code>yyyy/MM/dd/ HH:mm:ss</code> * cs-CZ / sk-SK: <code>dd/MM/yyyy hh:mm:ss tt</code> * de-DE: <code>d..."
 
[email protected] (talk | contribs)
Line 1: Line 1:
== Statement Excel Export Field Reference ==
== Statement Excel Export Field Limits ==
A statement Excel export contains 14 columns
A statement Excel export contains 14 columns



Revision as of 14:06, 28 May 2026

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 - The type of the transaction
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