Balance XML Reporting Guide

This guide describes the structure and contents of the Thredd Balance XML reports.

Topics covered: ClosedTypes of XML reports, Format of data files, XML schema, primary elements, Sub-elements and attributes

You can view and download the latest Thredd XSD schema files for the current and future versions here: Downloads

Current Version

The current version is available in both Online (HTML) and PDF format.

Online (HTML)

PDF

What's Changed?

Version

 

 

Balance XML Reporting Guide

 

 

Added new Balance XML schema where country and currency codes are removed (see Balance Report XML Schema). Removed country and currency codes reference sections.

Added currency code for the Caribbean Guilder currency (XCG) for Curacao and Sint Maartens that replaces Netherlands Antillean guilder (see ISO Currency Codes). Added Curacao and Sint Maartens to the currency list for this new currency.

Added references to Thredd Portal, our new online portal for managing your cards and transactions.
Added an FAQ to explain differences between the balance reporting in the balance XML file and the balance in Smart Client for Primary and Secondary cards. See the FAQs.

Updated minimum length requirement of PAN in <Card> to 14 digits. See PRN-196

Added new ISO currency code: 924. See PRN-197

Added Discover card type to the ACCTYPE element in the Balance XML Schema.

Updated the company address.

 

 

2.0.6

Older Versions

Older versions are available in PDF format only.

File Name

What's Changed?

Version

Balance XML Reporting Guide 2.0.5

Updates to content and graphics to align with taxonomy updates on our Documentation Portal.

Updated the description of the BLKAMT field. See the ACCOUNT element.

Guide rebrand to new company name and brand identity.

2.0.5

Balance XML Reporting Guide 2.0.4

Added Chinese Offshore Renminbi (currency code CNH) to the list of supported currencies. See Currency Codes.

Update to the description of the XML report file naming convention. See Balance Data Files.

Update to description of frequency of XML reports in FAQs section.

Updated the Copyright Statement.

2.0.4

Balance XML Reporting Guide 2.0.3

Added a description of the Thredd 16-digit public token.

Updates to description of when the balance XML files can be generated.

Updates to the Balance XML filename format to include details of the applicable Production environment. See Balance Data Files.

Updates made to Introduction (QMR section) and Balance Data Files (Sending of Files section).

2.0.3

Balance XML Reporting Guide 2.0.2

Added the following missing STATCODE values to the XML schema: G1,G2,G3,G4,G5,G6,G7,G8,G9,93,6P,59 & 46. See Status Codes.

New field PRIMARYTOKEN added to the CARD element, which shows the full Primary Account Number (PAN) of the card; If this is a secondary card, shows the full PAN of the linked primary card. See PRN-109.

Added the ability to accept empty strings in the GPSEXPDATE.

Added details of the XMLCutoffUTCtime setting, which allows you to set the equivalent local midnight cut-off time for receiving balance XMl reports if the time zone in your country differs from the UK time. See Balance Data Files.

Added a link to the Downloads page on the Documentation Portal, where you can view and download upcoming/future schema versions.

2.0.2

Balance XML Reporting Guide 2.0.1

New GPSEXPDATE field added to the CARD element. See PRN-60.

2.0.1

Balance XML Reporting Guide 2.0

Major revamp to look and feel and organisation of the guide. Rewrite of content to simplify and make the guide easier to use.

2.0

For versions prior to 2.0 please contact your Account Manager.