Last update 28/08/2019

3. Structure

Obtain the data by using one of the following structures:

  • Standard
  • Extended
  • Dynamic
  • File Management

Each structure has a different number (and position) of fields in the selected payments.
These fields are described in the data dictionary which includes the XML tag name, size, format and description.

3.1 Common Fields

XML Tags Description
ID Payment reference
REF Merchant's reference
ORDER Order date
STATUS Status
LIB Status description
ACCEPT Authorisation code from acquirer

3.2 Standard

Financial history, View transactions:

XML Tags Description
See Common Fields ...
PAYDATE Payment date
CIE Company
NAME Invoicing name
COUNTRY Buyer's invoicing country (optional)
TOTAL Amount
CUR Currency
SHIP Delivery costs (optional)
TAX Taxes (optional)
METHOD Payment methods
BRAND Card type
CARD Card number
STRUCT Structured communication (optional) (e.g. for Net banking payments)

View files (selection page):

XML Tags Description
MERCHREF Merchant's reference
DATE File date
STATUS Status
OPERATION File Operation
NBPAY Number of transactions
TRANSACTION Transaction code

Financial history (Download Summary):

XML Tags Description
CLIENTID ClientID
METHOD Payment methods
BRAND Card type
OWNER Cardholder's name
CARD Card number
PAYDATE Payment date
STATUS Status
LIB Status description
TOTAL Amount
CUR Currency
NBPAY Number of transactions
BATCHREF Batch Reference

3.3 Extended

For the View files (selection page) and the Financial history (summary), please refer to the Standard structure.

Financial history, View transactions:

XML Tags Description
See Common Fields ...
NCID Transaction code (NCID)
NCSTER Transaction state
PAYDATE Payment date
CIE Company
FACNAME1 Invoicing name, line 1
FACNAME2 Invoicing name, line 2 (optional)
FACSTREET1 Invoicing address, line 1 (optional)
FACSTREET2 Invoicing address, line 2 (optional)
FACZIP Invoicing postcode/ZIP (optional)
FACTOWN Invoicing city (optional)
COUNTRY Buyer's invoicing country (optional)
DELNAME1 Delivery name, line 1 (optional)
DELNAME2 Delivery name, line 2 (optional)
DELSTREET1 Delivery address, line 1 (optional)
DELSTREET2 Delivery address, line 2 (optional)
DELZIP Delivery postcode/ZIP (optional)
DELTOWN Delivery city (optional)
DELCOUNTRY Delivery country (optional)
TOTAL Amount
CUR Currency
SHIP Delivery costs (optional)
TAX Taxes (optional)
METHOD Payment methods
BRAND Card type
CARD Card number
UID UID
STRUCT

Structured communication
(e.g. for net banking payments)

FILEID Transaction uploaded via file
ACTION Last action (Financial history)
TICKET Virtual Ticket (Financial history)
PSPID PSPID (for Merchant group users)
DESC Description

3.4 Dynamic (new extended format)

This structure contains optional fields. A detailed level is available for Purchasing, Merchant Assistant or Travel.

XML Tags Description
See Common Fields ...
NCID Transaction code (NCID)
NCSTER Transaction state
PAYDATE Payment date
CIE Company
FACNAME1 Invoicing name, line 1
COUNTRY Buyer's invoicing country (optional)
TOTAL Amount
CUR Currency
METHOD Payment methods
BRAND Card type
CARD Card number
EXPDATE Exp. date
UID UID
STRUCT Structured communication (e.g. for Net banking payments)
FILEID Transaction uploaded via file
ACTION Last action (Financial history)
TICKET Virtual Ticket (Financial history)
DESC Description
SHIP Delivery costs (optional)
TAX Taxes (optional)
USERID User
PSPID PSPID (for Merchant group users)
REFID Entity
REFKIND Entity type
ECI Electronic Commerce Indicator (Origin of the transaction (ECI)).
CCCTY Card-issuing country
IPCTY IP address country
CVCCHECK Card Validity Code Check
AAVCHECK Automatic Address validity Check
VC Virtual Card type
BATCHREF Batch Reference

For the "Dynamic" structure, these fields can be added at the end of the structure.

List of available fields on the "Electronic reporting" page:

XML Tags Description Note
FACNAME2 Invoicing name, line 2 Available with "View transactions"
FACSTREET1 Invoicing address, line 1 Available with "View transactions"
FACSTREET2 Invoicing address, line 2 Available with "View transactions"
FACZIP Invoicing postcode (ZIP) Available with "View transactions"
FACTOWN Invoicing city Available with "View transactions"
DELNAME1 Delivery name, line 1 Available with "View transactions"
DELNAME2 Delivery name, line 2 Available with "View transactions"
DELSTREET1 Delivery address, line 1 Available with "View transactions"
DELSTREET2 Delivery address, line 2 Available with "View transactions"
DELZIP Delivery postcode (ZIP) Available with "View transactions"
DELTOWN Delivery city Available with "View transactions"
DELCOUNTRY Delivery country Available with "View transactions"
DELDOB Delivery date of birth  
TELNO Phone number  
REF1 Customer reference (Ref.1) Available with "View transactions"
REF2 Customer reference (Ref.2) Available with "View transactions"
REF3 Customer reference (Ref.3) Available with "View transactions"
REF4 Customer reference (Ref.4) Available with "View transactions"
OWNER Cardholder's name Available with "Financial history" and "View transactions"
EMAIL E-mail address Available with "View transactions"
ALIAS Alias Available with "Financial history" and "View transactions"
SCORING Scoring Only for the 'Fraud detection module' with 'Scoring', otherwise not present. Available with "Financial history".
SCO_CATEGORY Scoring category Only for the 'Fraud detection module' with 'Scoring', otherwise not present. Available with "Financial history".
FDMA_SCORING_CATEGORY FDMA Scoring category  
EXPERT_SCORING_CATEGORY Fraud Expert Scoring Category  
IPADDR Request's IP address  
REC_IPADDR Received IP address  
OPEDESC Reason for the operation  
BINCARD Card BIN number  
CARDUNIQUEID Card unique identifier  
ORDERDATETIME Payment dd/mm/yyy hh:mm:ss
 
PAYDATETIME Payment dd/mm/yyy hh:mm:ss  
SUBBRAND Sub-brand  
CREDITDEBIT Show credit/debit split information  
DEVICE Device Available with : "View transactions"
TO_MOBILEMODE Mobile mode Available with : "Financial history","View transactions"
XF_BIC BIC/Sort code  
XF_MANDATEID Mandate ID  
XF_SIGNDATE Sign date (yyyymmdd)  
XF_SEQUENCETYPE Sequence type  
EXPERT_DEVICEID Device ID  
DFP_DEVICEID Displays the fingerprint of the device (computer, mobile,…) used in the transaction Available only for merchants who have the InAuth device fingerprint option
DFP_RISK_LEVEL_CATEGORY The risk level associated with the device fingerprint. Format: 1=Low risk
2=Medium risk, suspicious
3=High risk
Available only for merchants who have the InAuth device fingerprint option
AS_FRAUD_TYPE Transactions that are classified as "dispute" by a merchant or an acquirer Actual Fraud (FRA), Suspicion of Fraud (SOF) or Commercial Dispute (COM) are also included in the list 

The "WithDetail" flag can be selected on the "Electronic reporting" page.

3.4.1 Travel details

XML Tags Description
ID Payment reference (Details)
TINUM Ticket number
TIDATE Ticket Date
CONJTI Conjunction Ticket
PASNAME Passenger Name
ORCITY Departure Airport (Cod.)
DESTCITY Arrival Airport (Cod.)
ORCITYL Departure Airport
DESTCITYL Arrival Airport
CARRIER Carrier Code
BOOKIND Booking Indicator
FLNUM Flight Number
FLDATE Flight Date
CLASS Airline Class
STOPOV Stopover
VATAPPL VAT applicability
TYPCH Type of Charge
AIRTAX Airport Taxes
EYCD Destination area code
IRST Destination area code (Typ.)
CHDETL Charge Details

3.4.2 Merchant Assistant details

XML Tags Description
ID Payment reference (Details)
ITEMNO Item ID
ITEMNAME Item name
QUANTITY Quantity
UNITNETPRICE Item price (excl. VAT)
CUR Currency
LIDREF1 Item Reference (1)
LIDREF2 Item Reference (2)
LIDDISCOUNTRATE Discount
LIDNETAMT Price (excl. VAT)
LIDTAXRATE VAT rate (%)
LIDGROSSAMT Price (incl. VAT)

3.5 File Management

For the View files (selection page) and the Financial history (summary), please refer to the Standard structure.

Financial history, View transactions:

XML Tags Description
TOTAL Amount
CUR Currency
BRAND Card type
CARD Card number
EXPDATE Exp. date
REF Your file reference
NCID Transaction code (NCID)
ID Payment reference
STATUS File status
LIB Status description
ACCEPT Authorisation code from acquirer
PAYDATE Payment date
ACTION Last action (Financial history)
TICKET Virtual Ticket (Financial history)
PSPID PSPID (Only when connected as a Merchant Group user)
DESC Description

3.6 Format

Each record corresponds to a payment. The output formats are:

  • XML: Each field describing the payment is available as a property of the <PAYMENT> tag;
  • Fixed Length: each field has a fixed size as described in the various structures above.
  • Delimited along with a separator: Each field of a payment record is separated by the specified separator (T for tab-delimited). If a value contains the separator, it will be replaced with a space in the download field, in order to avoid mismatches.

3.7 Sort by

After selecting the structure and format, you can also group your payments according to the value of the selected fields. You can choose up to 3 fields to create groups and sub-groups on 3 levels.

3.8 Name and Format of Downloaded File

You can specify the name and the extension of the downloaded file. In the file name, you cannot use specials characters like [/ . \ : * ? | < > "]

You can include dynamic parameters in the filename:

  • [DATE] for the previous date of the processed file
  • [FILEDATE] for the date of the processed file
  • [TIME] for the time of the processed file

Example: File[DATE]_[TIME] will be converted to File20111025_16134.

In the extension field, you can use any file extension with 3 characters. Specifying * in this field means that the extension will be derived from the file format:

  • '.xml' for XML
  • '.csv' for semicolon delimited values
  • '.txt' for Fixed-length or tab-delimited

3.9 Additional options

  • Header box: to make your data more readable or 'no headers' to keep only the relevant data.
  • Decimal Separator: to use in the download format [, or .].
  • With column header: to have the name (i.e. the XML Tag name) of each field on the line before the first payment (only applicable for FIX and DEL formats).
  • With Details: for merchants with Travel, Merchant Assistant or Purchasing details (only applicable for DYN format).

*Call Charges: The following is a guide to call charge information from Business landlines within the UK.

Barclaycard is a trading name of Barclays Bank PLC. Barclays Bank PLC is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority (Financial Services Register number: 122702). Registered in England. Registered No. 1026167. Registered office: 1 Churchill Place, London E14 5HP

Barclays Bank PLC subscribes to the Lending Code which is monitored and enforced by the Lending Standards Board. Further details can be found at www.lendingstandardsboard.org.uk escape arrow


© Barclaycard 2016