Wiki/Statement Excel Field Limits
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:
|
| 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 |