List of exportable columns

This is an exhaustive list of all the exportable columns you can use with the COLUMNS parameter.
You have to respect the syntax with or without spaces.
Also be careful to only use parameters which are relevant for a payment method.
For example, when requesting a standard payment, you shoudn’t provide columns AUTHORIZEDBY or CAPTUREDBY.
These parameters should be use for CAPTURE or AUTHORIZATION operations. Requesting a non-compatible parameter for a given payment method will result in empty columns in the export.

  • 3DSECI string (9)

    Electronic Commerce Indicator.

  • 3DSECURE no, yes

    The transaction has been processed with 3-D Secure.

  • 3DSECUREAUTHENTICATIONSTATUS y, n, u, a

    Authentication status (Y = yes ; N = no ; U = unavailable; A = attempted).

  • 3DSECURESIGNATURESTATUS y, n

    Signature status.

  • 3DSGLOBALSTATUS ok, not_enrolled, unavailable, not_required

    Global status.

  • 3DSLIABILITYSHIFT ‘yes’, ‘no’

    3D-Secure Liability Shift.

  • ADDITIONAL DATA string

    Bank response additional data from authorization request.

  • ALIAS string(1-40)

    Identifier of a previously processed payment method.

  • ALIASMODE oneclick, subscription

    Indicates the ALIAS usage mode:
    oneclick indicates a one click or an online transaction;
    subscription indicates an offline transaction.

  • AMOUNT integer

    The transaction amount in the smallest money decimal (e.g. cents for euro).

  • AMOUNT IN BILLING CURRENCY integer

    Transaction amount in the billing currency.

  • ARN string

    Acquirer Reference Number.

  • AUTHENTICATION string

    Cardholder authentication mechanism.

  • AUTHORIZATION NUMBER string

    Authorization number (POS only).

  • AVS CODE string(1)

    The Address Verification System result code. See the Address Verification System result codes section.

  • AVS MESSAGE string(1, 255)

    The Address Verification System result message. See the Address Verification System result codes section.

  • BANK COLLECTION NUMBER string(1-50)

    Bank collection number (POS only).

  • BILLING ADDRESS string(1-50)

    The billing address as specified by the merchant in the original payment request.

  • BILLING COUNTRY string(2)

    The billing country (ISO_3166-1_alpha-2) as specified by the merchant in the original payment request.

  • BILLING CURRENCY string(3)

    Billing and payment currency.

  • BILLING FIRST NAME string(1-15)

    The first name part of the billing address as specified by the merchant in the original payment request.

  • BILLING LAST NAME string(1-15)

    The last name part of the billing address as specified by the merchant in the original payment request.

  • BILLING MOBILE PHONE string(1-32)

    Billing mobile phone number in international format as specified by the merchant in the original payment request.

  • BILLING NETWORK string(1-10)

    Billing network.

  • BILLING PHONE string(1-32)

    Billing phone number in international format as specified by the merchant in the original payment request.

  • BILLING POSTAL CODE string(1-9)

    The billing postal code as specified by the merchant in the original payment request.

  • BILLING TITLE mr, miss, mrs

    The title used for the billing address name.

  • BILLING VAT FEES integer

    Billing fees on transaction (VAT fees).

  • BILLINGFEES EX. VAT integer

    Billing fees on transaction (ex. VAT).

  • BILLINGFEES EXCHANGE RATE integer

    Exchange rate used to calculate the fee in billing currency

  • BILLINGFEES INCL. VAT integer

    Billing fees on transaction (incl. VAT).

  • BRAND string

    Equipement brand (POS only).

  • CARD PRODUCT string

    Card product.

  • CARD SERVICE TYPE debit,credit

    Card service type (Debit/Credit)

  • CARD SUBTYPE string

    Card type (advanced).

  • CARD3DSECUREENROLLED y, n, u

    Card 3-D Secure enrollment status.

  • CARDBANK string

    Cardholder’s bank.

  • CARDCODE string(12-19)

    The user’s bank card’s Primary Account Number (PAN)

  • CARDCODE 6X4 integer

    First six and last 4 digits of holder’s card.

  • CARDCOUNTRY string(2)

    The country code (format ISO_3166-1_alpha-2).

  • CARDFULLNAME string(1-255)

    The holder’s full name (as described on the payment method).

  • CARDTYPE string

    The payment method type.

  • CARDVALIDITYDATE date(MM-YY)

    Card expiry date.

  • CB2A int(2)

    Bank response code from authorization request.

  • CHARGEBACK CODE string(1-255)

    Chargeback reason code.

  • CHARGEBACKDATE date(YYYY-MM-DD)

    Chargeback date.

  • CHARGEBACKSTATUS chargeback, representment

    Chargeback type.

  • CHARGED_DATE date(YYY-MM-DD)

    Date of commission payment to the merchant.

  • CHARGED_REFERENCE string(0-45)

    Reference of the transfer in which commissions were taken for the transaction.

  • CLIENTADDRESS string(1-510)

    The user’s address.

  • CLIENTDOB date(YYYY-MM-DD)

    The user’s date of birth.

  • CLIENTEMAIL email(5-255)

    The user’s email.

  • CLIENTIDENT string(1-255)

    Unique identifier of the user in your application (e.g. a login or a primary key).

  • CLIENTIP ipv4

    The user’s public IP address.

  • CLIENTREFERRER string(1-255)

    The user’s HTTP referrer URL.

  • CLIENT_IDENTIFIER string

    Client export identifier (Export Sevices only).

  • CLIENT_INTERNAL_ID string(1-125)

    Unique Client identifier.

  • COLLECTION DATE datetime(yyyy-MM-dd HH:mm:ss)

    Settlement date.

  • COLLECTION NUMBER integer

    Settlement number (only for POS transactions)

  • CURRENCY string(3)

    Currency code (ISO 4217 format).

  • DATE date(YYYY-MM)

    Required and mutually exclusive with STARTDATE and ENDDATE. Month or day of data to be exported, formatted YYYY-MM ou YYYY-MM-DD.

  • DESCRIPTION string(1-510)

    A short description of the operation, can be used to trigger fraud actions. Don’t hesitate to ask your Payment Manager for some advice on this topic.

  • DESCRIPTOR string

    The transaction label sent to the bank network. The transaction will display with this label on the user’s bank statement.

  • EPT RANK int(3)

    Payment terminal rank (only for POS transactions).

  • EXECCODE string(4)

    The operation result code. (See the complete list of execution code)

  • EXTRADATA string(1-255)

    Free field (Be2bill will send you back the content of the EXTRADATA you specified ahead).

  • FINANCIALSTATE being processed,collected,paid

    Transaction financial state (‘Being processed’; ‘Collected’ ; ‘Paid’).

  • FORM ATTEMPT 1,2,3,4

    Form attempt number

  • IDENTIFIER string(1-32)

    Your processing account technical identifier.

  • INTERCHANGE FEE integer

    Interchange fee.

  • IP COUNTRY ipv4

    holder’s IP country.

  • LANGUAGE fr, en, de, es, it, nl, zh, ru, pt, cs

    Configure the hosted form display language.

  • LAST NOTIFICATION CONTENT string(1-45)

    Last notification content.

  • LAST NOTIFICATION HTTP CODE sent,succeeded,pending,failure

    Last notification http code.

  • LAST NOTIFICATION RESULT sent,succeeded,pending,failure

    Last notification result.

  • LOCATION string(1-35)

    Equipment location: open field that can be modified on the POS inventory page of your extranet (POS only).

  • MERCHANT COUNTRY string(2)

    Merchant’s country used in the interchange calculation.

  • MESSAGE string(no length limit)

    The operation result description linked to EXECCODE.

  • METADATA string(1-255)

    Additional transactional data. Contact your account manager for more informations.

  • MID integer

    Merchant Identification.

  • MODEL int(3)

    Equipment model (POS only).

  • NATURE retrieval request,chargeback,representment

    Nature of the operation. Same as OPERATIONTYPE until a retrieval request, a chargeback or representment event occurs. In this case, indicates ‘retrieval request’, ‘chargeback’ or ‘representment’.

  • NFC y,n

    Contactless transaction (POS only)(‘yes’; ‘no’).

  • OPERATIONTYPE authorization, payment, capture, refund, credit, void

    The action you want to process.

  • OPPOTOTA_ENTRY_DATE datetime(yyyy-MM-dd HH:mm:ss)

    Oppotota entry date.

  • OPPOTOTA_REASON lost,stolen,did not reach cardholder,counterfeit,misuse

    Oppotota reason.

  • ORDERID string(1-40)

    Unique ID associated to an order in the merchant’s database (as specified in your initial POST request)

  • PAYMENT OPTION facilypay-3x, facilypay-3xsansfrais, facilypay-4x, facilypay-4xsansfrais, ANCV, EANCV

    Facily Pay and ANCV payment options.

  • POS TERMINAL TYPE ept,mpos, kiosk

    POS terminal type (‘EPT’; ‘mPOS’; ‘Kiosk’)(POS only)

  • PP_ADDRESS STATUS none, confirmed, unconfirmed

    Status of street address on file with PayPal.

  • PP_PAYER ID STATUS string(13)

    ID of Paypal payer’s account

  • PP_PAYER STATUS none, canceled-reversal, completed, denied, expired, failed, in-progress, partially-refunded, pending, refunded, reversed, processed, voided, completed-funds-held

    The status of the payment.

  • PP_PROTECTION ELIGIBILITY eligible, partiallyeligible, ineligible

    The kind of seller protection in force for the transaction.

  • PP_PROTECTION ELIGIBILITY TYPE itemnotreceivedeligible, unauthorizedpaymenteligible, ineligible

    The kind of seller protection in force for the transaction.

  • PP_SHIP TO CITY string(40 Bytes)

    Shipping city.

  • PP_SHIP TO COUNTRY CODE string(2)

    Country code.

  • PP_SHIP TO NAME string(1-32)

    Holder’s shipping last name.

  • PP_SHIP TO STREET string(1-100)

    Shipping street address.

  • PP_SHIP TO ZIP CODE string(1-20)

    U.S. ZIP code or other country-specific postal code.

  • PP_TRANSACTION ID string(20 max)

    Unique transaction ID of the payment.

  • REASON string(1-125)

    Rule Description.

  • REF ARCH string(1-12)

    Retrieval reference number.

  • REFUND TRANSFER REFERENCE proxy,vads

    retrieval reference number.

  • REFUND TRANSFER STATUS pending,failed,succeeded

    Refund transfer status (‘Pending’, ‘Failed’, ‘Succeeded’).

  • REFUNDED string

    Refunded transaction ID, if OPERATIONTYPE=’refund’.

  • REFUNDEDBY string(0-n)

    Refund transaction IDs (separated by commas ,) if this transaction is refunded.

  • REFUNDTYPE refund,cancel

    Refund type (‘refund’;’cancel’).

  • RETRY string(no length limit)

    Payment schedule information (retry number - number of retries).

  • RULE APPLIED string(1-125)

    Rule applied by fraud rule engine.

  • RULE IDS string(1-255)

    Rule IDs applied by fraud rule engine.

  • SCHEDULE string(no length limit)

    Payment schedule information (installment number - number of instalments).

  • SERIAL NUMBER string(12)

    Payment terminal serial number (POS only).

  • SHIP TO ADDRESS string(1-50)

    The shipping address.

  • SHIP TO COUNTRY string(2)

    The shipping country (ISO_3166-1_alpha-2 format).

  • SHIP TO FIRST NAME string(1-15)

    Holder’s first name in the shipping address.

  • SHIP TO LAST NAME string(1-30)

    Holder’s last name in the shipping address.

  • SHIP TO MOBILE PHONE string(1-32)

    Shipping mobile phone number in international format.

  • SHIP TO PHONE string(1-32)

    Shipping phone number in international format.

  • SHIP TO POSTAL CODE string(1-9)

    The shipping postal code.

  • SHIP TO TITLE mr, miss, mrs

    Holder’s title in the shipping address..

  • SIRET string

    SIRET number.

  • SUBMERCHANTS EXTERNAL IDS string(32)

    Sub-merchants external ID as received in the transaction request.

  • TAGS string(no max length)

    Tags set by the Be2bill’s rule engine

  • TRADE NAME

    Trade name.

  • TRANSACTION EXPIRATION DATE datetime(yyyy-MM-dd HH:mm:ss)

    Transaction expiration date.

  • TRANSACTIONID string(1-32)

    Unique Be2bill transaction ID. Make sure to store this ID in your database.

  • TRANSFER REFERENCE string(1-45)

    Transfer reference.

  • UDV string(10)

    Be2bill merchant account.

  • VERSION 3.0

    The API protocol version.

  • VISA MC FEE float

    Fees charged by the card schemes (Visa or Mastercard).

  • VOIDED string(1-40)

    Voided transaction ID.

  • VOIDEDBY string(1-40)

    Void transaction ID.

  • VOIDTYPE authorization,capture,payment,refund,credit

    Void type.