Wiki/Statement Excel Field Limits: Difference between revisions
Jump to navigation
Jump to search
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..." |
|||
| Line 1: | Line 1: | ||
== Statement Excel Export Field | == 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:
|
| 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 |