Presentaci

1
(No Transcript)
2
A real case of flipa taxonomy usage
Andreas Henzl / Coface Central Europe Olaf
Naumann / Atradius NV Stefan Bodewig /
Atradius NV
Wednesday 17.05.2006, Track 5 (Data Vendors
Information disseminators), 1430h - 1530h CET
3
Content

• About us
• Coface Central Europe
• Atradius NV
• Technical Components of the Project
• Overview
• Process Create Company
• Process Record Credit Limit Application
• Process Receive Monitoring Notification
• Technical components
• XBRL
• XBRL Flipa Difficulties Solutions
• XBRL Benefits
• XBRL Weaknesses
• XBRL Summary
• XBRL Status of Project

4

• About us
• Coface Central Europe
• Atradius NV

5
ENTITY
Coface Central Europe
Coface Bulgaria
Coface Croatia
Coface Czech
Coface Hungary
Coface Poland
Coface Romania
Coface Slovenia
Coface Slovakia
Information
Debt Collection

• The biggest single company database (ICON) in
  Central and Eastern Europe
• Information on 7.3 million companies in in
  Central and Eastern Europe.
• 1.6 million financial statements, 73 million
  financials
• 85,000 companies with insolvency information
• 30,000 debt collection cases added each year
• Unique company identifier across the region

ICON
DCON
6
CPL
Coface Central Europe
Coface Central EuropeServer Center Vienna
CCZ
HTTPS
HTTP/HTTPS
CHU

• Online
• Research
• Order-fulfilment
• DC casehandling

CSK
CSI
CHR
CRO
XML Webservices
CBG
Creici/Creica protocolftp
Eurogate interface
new
7

• Atradius - former GERLING NCM - is a global
  leader in credit insurance and debt management.
  Backed by new shareholders we are able to face
  new opportunities. Now we are an independent,
  financially sound market player with the most
  comprehensive global network.
• Professional competence with more than 75 years
  of experience and knowledge
• World market position No 2 (market share 24)
• Rating of A from Standard Poors and A2 by
  Moodys
• Trade transactions worth 330 billion Euro
  covered annually
• Access to information about 45 million companies
  world-wide
• Annual income 1.3 billion Euro in 2005
• 3,400 employees work in 90 offices in more than
  40 countries
• Atradius Holding headquartered in Amsterdam, The
  Netherlands

8

• Technical Components of the Project
• Overview
• Process Create Company
• Process Record Credit Limit Application
• Process Receive Monitoring Notification
• Technical components

9
Atradius Customer
Overview
Enter Internet
Reception of Credit Limit Decision
Record Credit Limit Application via Atradius
Serv_at_Net
Record Credit Limit Decision based on structured
data from Info Report
Atradius Backend
Request Information Report at CCE (if no data are
available in Atradius database)
Send back Information Report
CCE Backend
10
Process Create Company
Company not known in Atradius database
Copy Company
Atradius database
Copy of full CCE company database
Index file - Name - Address - Status - CCE
number - ... - ...
Companies - Name - Address - Status - CCE
number - ... - ...
CCE system
daily updates via ftp
11
Process Record Credit Limit Application
Record Credit Limit Application in Atradius
database
Automatic decision possible?
yes
no
Info fresh and complete?
Store structured data in Atradius database
yes
no
Request Information Report
Receive Information Report (immediately or later)
Manual decision
Automatic decision
12
Process Receive Monitoring Notice
Receive Monitoring Notification
Store structured data in Atradius database
Important reason for notification??
yes
no
alert users
no further action
13
Technical components
Web Application
Inhouse Application (Symphony)
ORACLE Core database
Display of report
Websphere Server
UB Portal
Web services
CCE Systems
14

• XBRL
• XBRL Difficulties Solutions
• XBRL Benefits
• XBRL Weaknesses
• XBRL Summary
• XBRL Status of Project

15
XBRL Flipa Difficulties Solutions (1)

• Difficulty
• No standardised transport protocol for purchasing
  and selling credit reports
• Why?
• Save costs and time
• by a standardised fully automatic search and
  ordering process
• Information Providers have to implement this
  protocol only once for all customers
• Information Receivers have to implement this
  protocol only once for all information providers
• Developing new connections is always complicated
  and expensive especially when it comes to testing
• Integrate the retrieved credit reports or
  structured information directly into your own
  applications or database
• Solution
• Definition of ICON Web Services which do provide
  B2B services for purchasing and selling business
  credit reports

http//icon.cofacecentraleurope.com/Default.asp?ac
tion110
16
XBRL Flipa Difficulties Solutions (2)

• Difficulty
• Cardinality within the entity tuple
• Why?
• Companies have multiple
• Addresses (Principal Address, Registration
  Address)
• NACE codes
• IDs (internat. ID, national ID, statistic nr,
  registration nr, VAT)

17
ltelement id"flipa_Entity" name"Entity"
substitutionGroup"xbrlituple" nillable"true"gt
ltcomplexTypegt ltcomplexContentgt
ltrestriction base"anyType"gt
ltsequencegt ltelement
ref"flipaIdentifier" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaNameDetails" minOccurs"0"
maxOccurs"unbounded" /gt ltelement
ref"flipaAddress" minOccurs"0" maxOccurs"1"
/gt ltelement ref"flipaCommunication"
minOccurs"0" maxOccurs"1" /gt
ltelement ref"flipaIncorporationStartDate"
minOccurs"0" maxOccurs"1" /gt
ltelement ref"flipaListingInformation"
minOccurs"0" maxOccurs"1" /gt
ltelement ref"flipaActivity" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaLegalForm" minOccurs"0" maxOccurs"1"
/gt ltelement ref"flipaEmployees"
minOccurs"0" maxOccurs"1" /gt
ltelement ref"flipaManager" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaRelatedEntity" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaTradingCountry" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaTrendAnalysis" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaPaymentRecord" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaRealEstate" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaFinancialInstitution" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaRiskAssessment" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaNegativeEvents" minOccurs"0"
maxOccurs"1" /gt ltelement
ref"flipaFinancialStatementPresentation"
minOccurs"0" maxOccurs"1" /gt
ltelement ref"flipaIndustryAveragePresentation"
minOccurs"0" maxOccurs"1" /gt
18
XBRL Flipa Difficulties Solutions (2)

• Difficulty
• Cardinality within the entity tuple
• Why?
• Companies have multiple
• Addresses (Principal Address, Registration
  Address)
• NACE codes
• IDs (internat. ID, national ID, statistic nr,
  registration nr, VAT)
• Solution
• Change the cardinality within the entity tuple to
  unbounded

19
XBRL Flipa Difficulties Solutions (3)

• Difficulty
• Limited set of Financials in FLIPA
• Why?
• Only a limited set of IFRS financials is
  available in FLIPA
• CCE covers 8 countries and offers an
  international balance sheet based on IFRS with
  160 positions
• Only 50 positions can be mapped into FLIPA
• Only PL according to the method by nature is
  included in FLIPA, PL by function can not be
  delivered
• Restricts our financials so much that even key
  positions (e.g. Cost of Sales) can not be
  delivered

20
BALANCE SHEET BALANCE SHEET BALANCE SHEET BALANCE SHEET
ASSETS ASSETS
000 Non-current assets (001010040070100) Non-current assets (001010040070100) Non-current assets (001010040070100) Non-current assets (001010040070100) Non-current assets (001010040070100) Non-current assets (001010040070100)      
  001 Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses Formation, restructuring and research Development expenses

  010 Intangible assets (011 to 030) Intangible assets (011 to 030) Intangible assets (011 to 030) Intangible assets (011 to 030)        
011 Software licenses, industrial property rights and similar rights Software licenses, industrial property rights and similar rights Software licenses, industrial property rights and similar rights Software licenses, industrial property rights and similar rights Software licenses, industrial property rights and similar rights Software licenses, industrial property rights and similar rights Software licenses, industrial property rights and similar rights
015 Goodwill Goodwill
020 Negative goodwill Negative goodwill
025 Prepayments for intangible assets Prepayments for intangible assets Prepayments for intangible assets Prepayments for intangible assets
030 Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification

  040 Property, plant and equipment (041 to 065) Property, plant and equipment (041 to 065) Property, plant and equipment (041 to 065) Property, plant and equipment (041 to 065) Property, plant and equipment (041 to 065) Property, plant and equipment (041 to 065)    
041 Land and buildings, including buildings on land owned by third parties Land and buildings, including buildings on land owned by third parties Land and buildings, including buildings on land owned by third parties Land and buildings, including buildings on land owned by third parties Land and buildings, including buildings on land owned by third parties Land and buildings, including buildings on land owned by third parties Land and buildings, including buildings on land owned by third parties
045 Machinery,tools, equipment and transportation means Machinery,tools, equipment and transportation means Machinery,tools, equipment and transportation means Machinery,tools, equipment and transportation means Machinery,tools, equipment and transportation means Machinery,tools, equipment and transportation means
050 Furniture and fixtures Furniture and fixtures
055 Non-current biological assets (Woods, plants, animals,...) Non-current biological assets (Woods, plants, animals,...) Non-current biological assets (Woods, plants, animals,...) Non-current biological assets (Woods, plants, animals,...) Non-current biological assets (Woods, plants, animals,...) Non-current biological assets (Woods, plants, animals,...)
060 Prepayments and assets under construction Prepayments and assets under construction Prepayments and assets under construction Prepayments and assets under construction Prepayments and assets under construction
065 Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification

  070 Financial assets (071 to 099) Financial assets (071 to 099) Financial assets (071 to 099) Financial assets (071 to 099)        
071 Investments Investments
072 in subsidiaries in subsidiaries
075 in associates in associates
080 other
085 Long term securities Long term securities
090 Loans granted Loans granted
095 Finance lease receivables (long term) Finance lease receivables (long term) Finance lease receivables (long term) Finance lease receivables (long term)
099 Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification Other items/items without detailed specification

  100 Deferred tax assets (long term) Deferred tax assets (long term) Deferred tax assets (long term) Deferred tax assets (long term)        
21
XBRL Flipa Difficulties Solutions (3)

• Difficulty
• Limited set of Financials
• Why?
• Only a limited set of IFRS financials is
  available in FLIPA
• CCE covers 8 countries and offers an
  international balance sheet based on IFRS with
  160 positions
• Only 50 positions can be mapped into FLIPA
• Only PL according to the method by nature is
  included in FLIPA, PL by function can not be
  delivered
• Restricts our financials so much that even key
  positions (e.g. Cost of Sales) can not be
  delivered
• Solution
• Include the whole set of IFRS as defined in XBRL
  in FLIPA

22
XBRL Flipa Difficulties Solutions (4)

• Difficulty
• Missing Value Elements
• Why?
• We have found several important elements missing
• Legal Form Joint stock company
• Identifiers Statistical number
• Linked Companies Customers and Suppliers

23
IdentifierType Identifier Type
IdentifierTypeCodeItemHead Identifier Type Code Item Head
Xcode_IDT_UN_1153.AHO Chamber of Commerce registration number
Xcode_IDT_UN_1153.ARA National government business identification number
Xcode_IDT_UN_1153.ARC Companies Registry Office (CRO) number
Xcode_IDT_UN_1153.ARD Costa Rican judicial number
Xcode_IDT_UN_1153.ARE Numero de Identificacion Tributaria (NIT)
Xcode_IDT_UN_1153.ARG Registro Informacion Fiscal (RIF) number
Xcode_IDT_UN_1153.ARH Registro Unico de Contribuyente (RUC) number
Xcode_IDT_UN_1153.ARI Tokyo SHOKO Research (TSR) business identifier
Xcode_IDT_UN_1153.ARK Systeme Informatique pour le Repertoire des Entreprises
Xcode_IDT_UN_1153.ARL Systeme Informatique pour le Repertoire des Etablissements
Xcode_IDT_UN_1153.FC Fiscal number
Xcode_IDT_UN_1153.VA VAT registration number
Xcode_IDT_UN_1153.XA Company/place registration number
Xcode_IDT_UN_1153.ZZZ Mutually defined reference number
RelatedEntity Related Entity
RelationType Relation Type
RelationTypeCodeItemHead Relation Type Code Item Head
Xcode_GRE_250_7143.PAC Parent company
Xcode_GRE_250_7143.UPC Ultimate Parent Company
Xcode_GRE_250_7143.DUP Domestic ultimate parent company
Xcode_GRE_250_7143.GRT Guarantor
Xcode_UN_3035.TX Shareholder
Xcode_UN_3035.UR Affiliated company
Xcode_UN_3035.UY Subsidiary
Xcode_UN_3035.VT Branch
24
XBRL Flipa Difficulties Solutions (4)

• Difficulty
• Missing Value Elements
• Why?
• We have found several important elements missing
• Legal Form Joint stock company
• Identifiers Statistical number
• Linked Companies Customers and Suppliers
• Solution
• We have extended the missing value elements

25
XBRL Flipa Difficulties Solutions (5)

• Difficulty
• Extensibility of XBRL
• Why?
• It is easily possible to extend XBRL with new
  tuples
• Extensions of existing tuples is not possible
• This is needed to add missing things like
• Priority of NACE codes
• Size of real estate
• Free text comments to certain elements

26
XBRL Flipa Difficulties Solutions (5)

• Difficulty
• Extensibility of XBRL
• Why?
• It is easily possible to extend XBRL with new
  tuples
• ltEntitygt
• ltAgt
• ltBgt ltB/gt
• lt/Agt
• ltCgtFoolt/Cgt
• lt/Entitygt
• ltExtensiongt
• ...
• lt/ Extension gt

27
XBRL Flipa Difficulties Solutions (5)

• Difficulty
• Extensibility of XBRL
• Why?
• Extensions of existing tuples is not possible1.
  The content copy method
• ltNewEntitygt
• ltNewAgt
• (other info within A)
• ltNewBgt
• (other info within B)
• ltextensiongt...lt/extensiongt
• lt/NewBgt
• lt/NewAgt
• ltCgtFoolt/Cgt
• lt/NewEntitygt

28
XBRL Flipa Difficulties Solutions (5)

• Difficulty
• Extensibility of XBRL
• Why?
• Extensions of existing tuples is not possible2.
  The nested tuple method
• ltNewEntitygt
• ltEntitygt
• ltCgtFoolt/Cgt
• lt/Entitygt
• ltNewAgt
• ltAgt(other info within A)lt/Agt
• ltNewBgt
• ltBgt(other info within B)lt/Bgt
• ltextensiongt...lt/extensiongt
• lt/NewBgt
• lt/NewAgt
• lt/NewEntitygt

29
XBRL Flipa Difficulties Solutions (5)

• Difficulty
• Extensibility of XBRL
• Why?
• Extensions of existing tuples is not possible
• ltNewEntitygt
• ltEntitygt
• ltAgt
• ltBgt(some B info)lt/Bgt
• lt/Agt
• ltCgtFoolt/Cgt
• lt/Entitygt
• ltNewAgt
• ltAgt
• ltBgt(some B info too)lt/Bgt
• lt/Agt
• ltNewBgt
• ltBgt(other info within B)lt/Bgt
• ltCommentgt...lt/Commentgt

30
XBRL Flipa Difficulties Solutions (5)

• Difficulty
• Extensibility of XBRL
• Why?
• It is easily possible to extend XBRL with new
  tuples
• Extensions of existing tuples is not possible
• This is needed to add missing things like
• Priority of NACE codes
• Size of real estate
• Free text comments to certain elements
• Solution
• The extensions needed have been added to a new
  FLIPA core taxonomy

31
XBRL Benefits

• Availability of structured data (e.g. financial
  data)
• leads to an automatic risk assessment within
  Atradius database
• Usage of a standardised format
• no vendor dependency
• reduced IT effort for the second- and following
  connections
• Financial data based on proven IFRS Standard (in
  our extended version)
• Generic layout for Information Reports
• unified reports across all data sources

32
XBRL Weaknesses

• Standard for transmission protocol not yet
  existing
• Complex technical implementation (compared to
  regular XML)
• Limitations of expandability
• Presented difficulties are not specific to the
  connection CCE lt-gt Atradiusbut would appear for
  any flipa connection

33
XBRL Summary

• Coface Central Europe has now managed to include
  all credit report data delivered in HTML, XML or
  PDF also into CCEs XBRL reports
• It was necessary to create a new version of the
  Flipa core taxonomy which helps to overcome the
  difficulties described
• Atradius and CCE suggest making this new Flipa
  taxonomy to the new Flipa core taxonomy (it is an
  replacement rather than an extension)
• CCE offers to make the ICON Webservices to an
  Open Standard for the community

34
XBRL Status of Project

• New extended flipa taxonomy - ready
• Order/Receive communication via Webservices -
  ready
• Extraction of structured information - proof of
  concept, done
• Generic viewer - proof of concept, done
• Release in August 2006