nombre de la taxonomía - circabc - welcome · web viewmappings between sbs and ias/ifrs overview...

23
Reference: Project Writing date: Page: Eurostat: X-DIS/XBRL Eurostat: X-DIS/XBRL 08-08-2006 08-08-2006 i Software AG: Software AG: PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping set IFRS mapping set Version: 2.00 Version: 2.00 X-DIS E X-DIS E UROPEAN UROPEAN XBRL XBRL M M APPINGS APPINGS BETWEEN BETWEEN SBS SBS AND AND IAS/IFRS IAS/IFRS Overview Document Date 2006-08-08 Confidential Document property of Eurostat i

Upload: truongphuc

Post on 25-Apr-2018

213 views

Category:

Documents


0 download

TRANSCRIPT

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 iiSoftware AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

X-DIS EX-DIS EUROPEANUROPEAN XBRL XBRL

MMAPPINGSAPPINGS BETWEENBETWEEN SBS SBS ANDAND IAS/IFRS IAS/IFRS

Overview DocumentDate 2006-08-08

Confidential Document property of Eurostati

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 iiiiSoftware AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

RECEIPT ADVICE SLIP FOR DELIVERABLES

RECEIPT OF WORK

To be filled in by the Contractor and the Commission

Contractor CommissionDate of delivery/signing:

Person responsible for checking (in block capitals):Comments:

Date and signature:

ACCEPTANCE AND VALIDATION OF WORK

To be filled in by the Commission

Official responsible for acceptance (in block capitals): OIA(*)

Date and Signature

Official responsible for final validation (in block capitals): OVA(*)Date and Signature

(*) OIA: The Commission’s responsible in charge of the reception of the work is obliged to act as OIA (Operational initiating agent) for this General Directorate.

OVA: The Commission’s responsible in charge of the final validation of the work is obliged to act as OVA (Operational verifying agent) for this General Directorate

Confidential Document property of Eurostatii

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 iiiiiiSoftware AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Document OverviewThe current document overviews the information concerned to the mapping process between the SBS statistical framework as defined by Eurostat and the IAS/IFRS accounting framework.

Despite there is not a unique solution for the mapping process, a default solution will be provided.

Document StageThe document is public working draft and will allow the public review previous the testing plan of the project.

Confidential Document property of Eurostatiii

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 ivivSoftware AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

IndexDocument Overview.......................................................................................................... iiiDocument Stage................................................................................................................ iiiIndex................................................................................................................................. iv1 Introduction..............................................................................................................5

1.1 Document Objectives..........................................................................................51.2 Document Structure............................................................................................61.3 Specific terms used in the document..................................................................6

2 Business Requirements............................................................................................83 Mapping set for C-I sectors.....................................................................................104 Mapping set for credit entities................................................................................14Apéndice A. Approval process.......................................................................................18Apéndice B. References................................................................................................18

Confidential Document property of Eurostativ

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 55Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

1 Introduction

Within the scope of the XDIS Program (XML for Data Interoperability in Statistics), which is being carried out by Eurostat, the Statistical Office of the European Commission, Software AG has been awarded with the initial phase of the XBRL/X-DIS project. This stage targets for a study on the capabilities and suitability of XBRL technology as mechanism for collecting statistical data delivered by enterprises of each Member State to their respective NSI.

As a proof of concept for evaluating XBRL suitability, the project scope includes definition and implementations of taxonomies to collect statistics required by some of the Regulations, e.g. SBS, STS, PRODCOM, Balance of Payments, Labour Force, etcetera. The data collected on the basis of the SBS Regulation has been selected for the initial tasks.

The SBS Regulation defines 6 activity areas, namely industry, services and trades, construction, credit entities, insurance services and pension funds, each one with a number of common but also different variables to collect (called characteristics in the SBS framework domain).

NSI competencies include the implementation of the data collection to ensure that data requested by the Regulation can be delivered to Eurostat in the required scope and quality. A number of additional data requirements exist in the countries that are used for national purposes. As such the variables to collect might probably be larger than those defined in the SBS regulation itself.

The purpose of the current taxonomy is defining a valid data model of variables that can be collected by the NSI to comply with the European SBS requirements. The taxonomy can afterwards be extended at National level to cover also additional needs for national purposes.

On the other hand, it will be evaluated the horizontal extensibility of the taxonomy to include variables from frameworks other than SBS.

The XBRL specification version for the development of the taxonomy is the scope belonging to the XBRL 2.1 + “corrected errata” dated in 2005-05-24.

1.1 Document ObjectivesThe objectives of this document are:

Describing the business requirements for the report delivery scope,

Develop a mapping task between the SBS characteristics as defined by the previous regulatory environment,

Find out a proposed data model to be included in the taxonomy structure

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 66Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

1.2 Document StructureThe business requirements and taxonomy necessity will be exposed. We will introduce the overall design, getting into further details of its building blocks, and after details of the data dictionary, the concepts and the characteristics. Finally, we will analyze other issues as flexibility, extensibility and modularity.

1.3 Specific terms used in the documentThe following table offers a relationship of some frequently used XBRL terms:Table 1. XBRL terms being used in this document.

Concept Definition

ContextIt is the definition of the information associated to the XBRL report corresponding to the time period which data are referred and being reported by the Entity.

DTS Stands for “Discoverable Taxonomy Set” and defines the set of taxonomies required for the XBRL report validation.

FRTAStands for Financial Reporting Taxonomy Architecture, as the guidelines for defining and unifying as good practices rules in the design of Financial Taxonomies.

XBRL reportIt is the XML document compliant with XBRL spec, which contains the values (facts) defined by the taxonomy which it belongs to. Form the technical point of view, it is the XML document that can be validated against the xsd schema.

ItemIt is the kind of parameter defined in the taxonomy that enables for simple data concepts representation, i.e. only a value is required, being either text, date or a number.

LinkbaseIt is part of the XBRL specification which is intended for structuring and adding meaning to the elements defined in the taxonomy, i.e. defined in the data models within the schemas.

Calculation LinkbaseIt is a kind of linkbase targeted for adding in the elements a hierarchy so mathematical bindings between concepts can be checked in parent-children relationships. Only additions with sign are allowed.

Reference Linkbase

It is a kind of linkbase that links every concept in the taxonomy with a reference to a, typically legal source, backing the element definition. As a pointer to the document it allows to define advanced linkages within the pointed document as the number, the paragraph or the page.

Labels Linkbase

As another kind of linkbase, allows establishing the tag for every single concept in the data model. It is possible to associate labels for different languages as well as labels other than naming the concept as checking, processing or data validation. This feature is supported by the roles in the label arcs.

Presentation LinkbaseAs the calculation linkbase, this linkbase allows to establish hierarchies between the concepts in the taxonomy. Such a hierarchy is targeted to be for human view and presentation purposes.

TaxonomyThe taxonomy is the structure that defines the data model of elements allowed in an XBRL report for a domain. It is composed by a minimum of an schema and zero or more linkbases.

Tuple This is a kind of data model structure that allows grouping of

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 77Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

several simple concepts (items), for which is meaningful to report them together and eligible to be repeated within a report. They can be nested with other tuples forming broader structures.

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 88Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

2 Business RequirementsThe business requirements are to collect, process and publish all statistical data laid down in the Structural Business Statistics regulation (58/97) and its amendments, collect, process and publish all statistical data laid down in the regulation on steel statistics adopted by the Council and the Parliament in 2003, ensure high quality output and apply a high service ethos to main users in EU institutions.

Structural business statistics (SBS) form one of the basic statistical tools for measuring and monitoring the Union’s competitiveness and entrepreneurship and it covers all market activities in industry and services (NACE C – K). Economic and employment variables are collected annually at a detailed level.

The Objectives of the data collection are: To disseminate high quality statistics on the structure of European businesses To ensure full compliance with the SBS regulation To further pursue the quality action plan in relation to structural business

statistics To implement and continue projects covering areas like business demography,

business services, international sourcing, factors of business success To pursue the adoption of the FATS regulation and start the collection of data on

foreign affiliates To balance the response burden on enterprises with the increasing needs of users To identify and test new ways of data collection with the aim to reduce response

burden

The involved Legal acts for SBS framework are:

Council Regulation No: 58/97/EC, Euratom of 20/12/96: OJ: L014 of 17/01/97, *structural business statistics

Council Regulation No: 410/98/EC, Euratom of 16/02/98: OJ: L052 of 21/02/98, *amending Regulation (EC, Euratom) No 58/97 concerning structural business statistics

Council Regulation No: 2699/98/EC of 17/12/98: OJ: L344 of 18/12/98, *concerning the derogations to be granted for structural business statistics

Commission Regulation No: 2700/98/EC of 17/12/98: OJ: L344 of 18/12/98, *concerning the definitions of characteristics for structural business statistics

Commission Regulation No: 2701/98/EC of 17/12/98: OJ: L344 of 18/12/98, *concerning the series of data to be produced for structural business statistics

Commission Regulation No: 2702/98/EC of 17/12/98: OJ: L344 of 18/12/98, *concerning the technical format for the transmission of structural business statistics

Commission Regulation No: 1225/1999/EC of 27/05/99: OJ: L154 of 19/06/99, *concerning the definitions of characteristics

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 99Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

for insurance services statistics

Commission Regulation No: 1226/1999/EC of 28/05/99: OJ: L154 of 19/06/99, *concerning the derogations to be granted for insurance services statistics

Commission Regulation No: 1227/1999/EC of 28/05/99: OJ: L154 of 19/06/99, *concerning the technical format for the transmission of insurance services statistics

Commission Regulation No: 1228/1999/EC of 28/05/90: OJ: L154 of 19/06/99, *concerning the series of data to be produced for insurance services statistics

Commission Regulation No: 1618/1999/EC of 23/07/99: OJ: L192 of 24/07/99, *concerning the criteria for the evaluation of quality of structural business statistics

Commission Regulation No: 1112/2001/EC of 06/06/01: OJ: L151 of 07/06/01, *concerning derogations from the provisions of Council Regulation (EC, Euratom) No 58/97 in respect of insurance services statistics

Commission Regulation No: 1614/2002/EC of 06/09/02: OJ: L 244 of 12/09/02, *adjusting Council Regulation (EC, Euratom) No 58/97 to economic and technical developments and amending Commission Regulations (EC) No 2700/98, (EC) No 2701/98 and (EC) No 2702/98

Parliament and Council Regulation No: 2056/2002/EC of 05/11/02: OJ: L 317 of 21/11/02, *amending Council Regulation (EC, Euratom) No 58/97 concerning structural business statistics

Commission Regulation No: 1667/2003/EC of 01/09/03: OJ: L244 of 29/09/03, *implementing Council Regulation (EC, Euratom) No 58/97 with regard to derogations to be granted for structural business statistics

Commission Regulation No: 1668/2003/EC of 01/09/03: OJ: L244 of 29/09/03, *implementing Council Regulation (EC, Euratom) No 58/97 with regard to the technical format for the transmission of the structural business statistics and amending Commission Regulation No 2702/98 concerning the technical format for the transmission of structural business statistics

Commission Regulation No: 1669/2003/EC of 01/09/03: OJ: L244 of 29/09/03, *implementing Council Regulation (EC, Euratom) No 58/97 with regard to the series of data to be produced for structural business statistics and amending Commission Regulation (EC) No 2701/98 concerning the series of data to be produced for structural business statistics

Commission Regulation No: 1670/2003/EC of 01/09/03: OJ: L244 of 29/09/03, *implementing Council Regulation (EC, Euratom) No 58/97 with regard to the definitions of characteristics for structural business statistics and amending Regulation (EC) No 2700/98 concerning the definitions of characteristics for structural business statistics

Parliament and Council Regulation No: 48/2004/EC of 05/12/03: OJ: L7 of 13/01/04, *on the production of annual Community statistics on the steel industry for the reference years 2003-2009

Such regulations provide:

Definition for SBS characteristics in the 6 involved sectors: industry, services/trades, construction, credit entities, insurance and pension funds,

Data delivery,

Derogations for Member State,

Other relevant information to structural data compilation.

The SBS taxonomy focuses currently in the IAS/IFRS accounting principles as defined by the IAS framework and implemented by IFRS-GP 2005 taxonomy.

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1010Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

3 Mapping set for C-I sectorsIn the current part it will be proposed a possibility of mapping between SBS characteristics as defined in the regulation and the IAS/IFRS disclosures. We will use the parameterization provided by IFRS-GP 2005 by convenience to refer for IAS disclosure variables.

It would be interesting to mention that there are several possibilities of mapping set, each one more suitable for each particular NSI. We will propose just a default solution. It would need to be investigated if obtaining other solutions, in a detailed, case scenario analysis, would make sense.

The result of the mapping task will allow obtaining the source variables that will be required to request from enterprises to fill the SBS questionnaires, and will seed the taxonomy.

Please find the following color codes for the variable type:

in green color variables already in FR (i.e. IFRS-GP 2005), in green color variables representing other SBS characteristics themselves, in red color the concepts that would need to be created from scratch in the SBS

taxonomy,

Characteristics Components breakdown IFRS-GP11110 Number of enterprises NSI

11120 Number of births of enterprises Date of birth NSI

11130 Number of deaths of enterprises Date of deaths NSI

11210 Number of local units Local units NSI

11310 Number of kind of activity units Kind of activity units NSI

12110 Turnover Turnover ifrs-gp_RevenueTotalByNature12120 Production Value Turnover (12.11.0)

+/- Change in stocks of finished products and work in progress manufactured by the unit (13 21 3)+/- Change in stocks of goods and services purchased for resale in the same condition as received (13 21 1)- Purchases of goods and services purchased for resale in the same condition as received (13 12 0)

+ Capitalized productionifrs-

gp_WorkPerformedByEntityAndCapitalised

+ Other operating income (excluding subsidies)ifrs-

gp_OtherOperatingIncomeTotalByNature

12130 Gross margin on goods for resale Turnover (12110)

- Purchases of goods and services purchased for resale in the same conditions as received (13120)Change in stocks of goods and services purchased for resale in the same condition as received (13211)

12150 Value added at factor cost Turnover (12 11 0)

+/- Change in stocks of goods and services (13 21 0)

+ Capitalized productionifrs-

gp_WorkPerformedByEntityAndCapitalised

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1111Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GP

+ Other operating incomeifrs-

gp_OtherOperatingIncomeTotalByNature

- Purchases of goods and services (13 11 0)- Duties and taxes linked to production ifrs-gp_IncomeTaxExpenseIncome- Other taxes on products which are linked to turnover but not deductible

12170 Gross operating surplus Value added at factor cost (12 15 0)

- Personnel costs (13 31 0)

13110 Total purchases of goods and services Raw materials and consumables used

ifrs-gp_RawMaterialsAndConsumables

UsedByNatureWork contracted outPayments for long-term rental and operational leasing of goods (13411)

Other operating expensesifrs-

gp_MiscellaneousOtherOperatingExpensesByNature

13120

Purchases of goods and services purchased for resale in the same conditions as received

Purchases of goods and services purchased for resale in the same conditions as received

13131 Payments for agency workers Payments for agency workers

13210 Change in stocks of goods and services Change in Raw Materials ifrs-gp_RawMaterials(c1) - ifrs-

gp_RawMaterials(c2)Change in Merchandise ifrs-gp_MerchandiseChange in Production Supplies ifrs-gp_ProductionSuppliesChange in Work in Process ifrs-gp_WorkInProgressChange in Finished Goods ifrs-gp_FinishedGoodsChange in Other Inventories ifrs-gp_OtherInventoriesChange in stocked services stockedServices

13211

Change in stocks of goods and services purchased for resale in the same condition as received

Change in stock of merchandise ifrs-gp_Merchandise

Change in stocked services for resale stockedServicesResale

13213

Change in stocks of finished products and work in progress manufactured by the unit

Change in stocks of finished products and work in progress manufactured by the unit

ifrs-gp_ChangesInInventoriesOfFinishedGoodsAndWorkInProgressByNatur

e

13310 Personnel costs Personnel costs ifrs-gp_EmployeeExpensesByNature

13320 Wages and salaries Wages and salaries WageAndSalariesByNature13330 Social security costs Social security costs

13410Operating costs linked to buildings and equipment

Operating costs linked to buildings and equipment

13411Payments for long-term rental and operational leasing of goods

Payments for long-term rental and operational leasing of goods

ifrs-gp_LeaseAndSubleasePaymentsRe

cognisedInIncomeStatementTotal

13420 Cost of selling Cost of selling

13430 Other operating costs Other operating costsifrs-

gp_MiscellaneousOtherOperatingExpensesByNature

15110 Gross investment in tangible goods Gross investment in land (15120)

Gross investment in existing buildings and structures (15130)Gross investment in construction and alteration of buildings (15140)Gross investment in machinery and equipment (15150)

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1212Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GP

15120 Gross investment in land Acquisitions land

ifrs-gp_AcquisitionsThroughBusinessCo

mbinationsLand

15130Gross investment in existing buildings and structures

Acquisitions buildings and structuresifrs-

gp_AcquisitionsThroughBusinessCombinationsBuildings

15140Gross investment in construction and alteration of buildings

Acquisitions construction and alteration of buildings

ifrs-gp_AcquisitionsThroughBusinessCombinationsConstructionInProgress

15150Gross investment in machinery and equipment

Acquisitions in machinery and equipmentifrs-

gp_AcquisitionsThroughBusinessCombinationsPlantAndEquipment

15210 Sales of tangible investment goods Sales of tangible investment goods

ifrs-gp_ProceedsFromDisposalOfInvest

mentProperty

15310Value of tangible goods acquired through financial leasing

Value of tangible goods acquired through financial leasing

ifrs-gp_PropertyPlantAndEquipmentUnd

erFinanceLeasesNetTotal

15420Gross investment in concessions, patents, licenses, trade marks and similar rights

Acquisitions

ifrs-gp_AcquisitionsThroughBusinessCombinationsPatentsTrademarksAndO

therRights

+ Internal Development

ifrs-gp_AdditionsFromInternalDevelopmentPatentsTrademarksAndOtherRig

hts

15441 Investment in purchased software Acquisitions

ifrs-gp_AcquisitionsThroughBusinessCo

mbinationsSoftware

15442Investment in software produced by the unit

Internal Developmentifrs-

gp_AdditionsFromInternalDevelopmentSoftware

16110 Number of persons employed Number of employees (16130)

- unpaid workers

16130 Number of employees Number of employeesifrs-

gp_NumberOfEmployeesAverageOverPeriod

16131 Number of part-time employees Number of part-time employees

16135 Number of home workers Number of home workers

16140Number of employees in full-time equivalent units

Number of employees in full-time equivalent units

16150 Number of hours worked by employees Number of hours worked by employees

17110

Number of enterprises having an association or cooperation agreement with other enterprises

Number of enterprises having an association or cooperation agreement with other enterprises

17310Information on forms of trading by enterprises

Information on forms of trading by enterprises

17320 Number of retail stores Number of retail stores

17330Category of sales space for retail stores engaged in retail trade

Category of sales space for retail stores engaged in retail trade

17331 Sales Space Sales Space

17340Number of fixed market stands and/or stalls

Number of fixed market stands and/or stalls

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1313Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GP

18100Turnover from agriculture, forestry, fishing and industrial activities

Turnover from agriculture, forestry, fishing and industrial activities

18110Turnover from the principal activity at the NACE REV.1 three digit-level

Turnover from the principal activity at the NACE REV.1 three digit-level

ifrs-gp_RevenueForPrimarySegmentTot

al

18120 Turnover from industrial activities

Turnover from industrial activities excluding construction (18121)Turnover from construction (18122)

18121Turnover from industrial activities excluding construction

Turnover from industrial activities excluding construction

18122 Turnover from construction Turnover from construction

ifrs-gp_RevenueFromConstructionContr

actsByNature

18150 Turnover from services activities Turnover from services activities

18160

Turnover from trading activities of purchase and resale and intermediary activities (agents)

Turnover from trading activities of purchase and resale and intermediary activities (agents)

18310 Turnover from building Turnover from building

18320 Turnover from civil engineering Turnover from civil engineering

20110 Purchases of energy products (value) Purchases of energy products (value)

20111 Purchases of solid fuels (in value) Purchases of solid fuels (in value)

20112Purchases of petroleum products (in value)

Purchases of petroleum products (in value)

20113Purchases of natural and derived gas (in value)

Purchases of natural and derived gas (in value)

20114Purchases of renewable energy sources (in value)

Purchases of renewable energy sources (in value)

20115 Purchases of heat (in value) Purchases of heat (in value)

20116 Purchases of electricity (in value) Purchases of electricity (in value)

21110

Investment in equipment and plant for pollution control, and special anti-pollution accessories (mainly end of pipe equipment)

Investment in equipment and plant for pollution control, and special anti-pollution accessories (mainly end of pipe equipment)

21120

Investment in equipment and plant linked to cleaner technology (integrated technology)

Investment in equipment and plant linked to cleaner technology (integrated technology)

21140Total current expenditure on environmental protection

Total current expenditure on environmental protection

22110 Total intramural R&D expenditure ifrs-gp_ResearchAndDevelopment

22120 Total number of R&D personnel Total number of R&D personnel

23110 Payments to subcontractors Payments to subcontractors

25111Percentage share of turnover to resale traders: retail traders

turnover to resale traders: retail traders

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1414Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GP

25112Percentage share of turnover to professional users (wholesale, others)

turnover to professional users (wholesale, others)

25113Percentage share of turnover to final customers (retail trade activity)

turnover to final customers (retail trade activity)

25211Percentage share of purchases from wholesalers, purchasing group

purchases from wholesalers, purchasing group

25212Percentage share of purchases from producers

purchases from producers

4 Mapping set for credit entitiesIn the current part it will be proposed a possibility of mapping between SBS characteristics as defined in the regulation and the IAS/IFRS disclosures. We will use the parameterization provided by IFRS-GP 2005 by convenience to refer for IAS disclosure variables.

It would be interesting to mention that there are several possibilities of mapping set, each one more suitable for each particular NSI. We will propose just a default solution. It would need to be investigated if obtaining other solutions, in a detailed case scenario analysis, would make sense.

The result of the mapping task will allow obtaining the source variables that will be required to request from enterprises to fill the SBS questionnaires, and will seed the taxonomy.

Please find the following color codes for the variable type:

in green color variables already in FR (i.e. IFRS-GP 2005), in green color variables representing other SBS characteristics themselves, in red color the concepts that would need to be created from scratch in the SBS

taxonomy,

Characteristics Components breakdown IFRS-GP11.11.0 Number of enterprises aggregation int-gcd_EntityIdentifyingCodes

11.11.1Number of enterprises broken down by legal status

legal status int-gcd_LegalFormEntity

aggregation int-gcd_EntityIdentifyingCodes

11.11.4Number of enterprises broken down by residence of the parent enterprise

residence of the parent enterprise int-gcd_EntityIdentifyingCodes

aggregation int-gcd_CountryCode

11.11.6Number of enterprises broken down by size classes of the balance sheet total

size classes of the balance sheet total int-gcd_CountryCode

Balance sheet total (CI) (43.30.0)

11.11.7Number of enterprises broken down by category of credit institutions

category of credit institutions int-gcd_DescriptionActivity

aggregation int-gcd_EntityIdentifyingCodes

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1515Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GP11.21.0 Number of local units Number of Local Units

11.41.1Total number of branches broken down by location in non-EEA countries

Number of Branches

location in non-EEA countries int-gcd_CountryCode

11.51.0

Total number of financial subsidiaries broken down by location in other countries

Number of Financial Subsidiaries

location in other countries int-gcd_CountryCode

12.12.0 Production value Interest receivable and similar income (42.11.0)- Interest payable and similar charges (42.12.0)+ Commissions receivable (42.14.0)+ Income from shares an other variable yield securities (42.13.1)+ Net profit or net loss on financial operations (42.20.0)Other operating income (42.31.0)

12.14.0 Value added at basic prices

12.15.0 Value added at factor cost Production Value (12.12.0)

- Total Purchases of Goods and services (13.11.0)

13.11.0 Total purchases of goods and services

Commissions payable (42.15.0) + Other administrative expenses (42.32.2)+ Other operating changes (42.33.0)

13.31.0 Personnel costs ifrs-gp_EmployeeExpensesByNature13.32.0 Wages and salaries ifrs-gp_WageAndSalariesByNature

15.11.0 Gross investment in tangible goods

16.11.0 Number of persons employed

16.11.1Number of persons employed broken down by category of credit institutions

Number of persons employed (16.11.0)

category of credit institutions int-gcd_DescriptionActivity

16.11.2 Number of women employed

16.13.0 Number of employees ifrs-gp_NumberOfEmployeesAtEndOfPeriod

16.13.1 Number of part-time employees

16.13.6 Number of female employees

16.14.0Number of employees in full-time equivalent units

42.11.0 Interest receivable and similar income ifrs-gp_InterestIncomeTotalFinancialInstitutions

42.11.1Interest receivable and similar income arising from fixed-income securities

42.12.0 Interest payable and ifrs-gp_InterestExpenseTotalFinancialInstitutions

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1616Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GPsimilar charges

42.12.1Interest payable and similar charges linked to debt securities in issue

42.13.0 Income from securities

42.13.1Income from shares and other variable-yield securities

42.14.0 Commissions receivable ifrs-gp_FeesAndCommissionIncomeTotal

42.15.0 Commissions payable ifrs-gp_FeesAndCommissionExpenseTotal

42.20.0 Net profit or net loss on financial operations ifrs-gp_ProfitLossFromOperations

42.31.0 Other operating charges ifrs-gp_OtherOperatingExpenses

42.32.0 General administrative expenses ifrs-gp_OperatingExpensesTotalByNature

42.32.2 Other administrative expenses ifrs-gp_OtherAdministrativeExpenses

42.35.0

Value adjustments and value readjustments in respect of loans and advances and provisions for contingent liabilities and commitments

42.36.0Other value adjustments and value readjustments

42.40.0 Profit and loss on ordinary activities ifrs-gp_ProfitLossAfterTaxFromContinuingOperations

42.50.0 Extraordinary profit or loss ifrs-gp_ProfitLossFromDiscontinuedOperationsNetOfTax

42.51.0

All taxes (tax on profit or loss on ordinary activities, tax on extraordinary profit or loss, other taxes)

tax on profit or loss on ordinary activities ifrs-gp_IncomeTaxExpenseIncome

tax on extraordinary profit or lossother taxes

42.60.0 Profit or loss for the financial year ifrs-gp_ProfitLoss

43.11.0 Loans and advances to customers ifrs-gp_LoansAndAdvancesToCustomers

43.21.0 Amounts owned by customers

43.29.0 Total of capital and reserves ifrs-gp_EquityTotal

43.30.0 Balance sheet total (CI) Assets Current Total ifrs-gp_AssetsCurrentTotal

Assets Non-Current Total ifrs-gp_AssetsNonCurrentTotal

43.31.0

Balance sheet total broken down according to the residence of the parent enterprise

Balance sheet total (CI) (43.30.0)

residence of the parent enterprise int-gcd_CountryCode

43.32.0Balance sheet total broken down by legal status

Balance sheet total (CI) (43.30.0)

Legal status int-gcd_LegalFormEntity44.11.0 Interest receivable

and similar income broken down by (sub)categories of the

Interest receivable and similar income (42.11.0)

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1717Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GPCPA

(sub)categories of the CPA int-gcd_DescriptionActivity

44.12.0

Interest payable and similar charges broken down by (sub)categories of the CPA

Interest payable and similar charges (42.12.0)

(sub)categories of the CPA int-gcd_DescriptionActivity

44.13.0

Commissions receivable broken down by (sub)categories of the CPA

Commissions receivable (42.14.0)

(sub)categories of the CPA int-gcd_DescriptionActivity

44.14.0Commissions payable broken down by (sub)categories of the CPA

Interest receivable and similar income (42.11.0)

(sub)categories of the CPA int-gcd_DescriptionActivity

45.11.0Geographical breakdown of the total number of EEA branches

number of EEA branches

Geographical classification int-gcd_CountryCode

45.21.0Geographical breakdown of interest receivable and similar income

Interest receivable and similar income (42.11.0)

Geographical classification int-gcd_CountryCode

45.22.0Geographical breakdown of balance sheet total

Balance sheet total (CI) (43.30.0)

Geographical classification int-gcd_CountryCode

45.31.0

Geographical breakdown of interest receivable and similar income via the freedom to provide service business (in other EEA countries)

Interest receivable and similar income via the freedom to provide service business (in other EEA countries)

Geographical classification int-gcd_CountryCode

45.41.0

Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries)

Interest receivable and similar income via branch business (in non-EEA countries)

Geographical classification int-gcd_CountryCode

45.42.0

Geographical breakdown of interest receivable and similar income via the freedom to provide service business (in non-EEA countries)

Interest receivable and similar income via the freedom to provide service business (in non-EEA countries)

Geographical classification int-gcd_CountryCode

47.11.0Number of accounts broken down by (sub)categories of the CPA

Number of accounts

(sub)categories of the CPA int-gcd_DescriptionActivity

47.12.0

Number of loans and advances to customers broken down by (sub)categories of the CPA

Loans and advances to customers (43.11.0) NSI

(sub)categories of the CPA int-gcd_DescriptionActivity47.13.0 Number of automatic

Confidential Document property of Eurostat

Reference: Project Writing date: Page:Eurostat: X-DIS/XBRLEurostat: X-DIS/XBRL

08-08-200608-08-2006 1818Software AG:Software AG:PHC6CE1/SBS SBS – PHC6CE1/SBS SBS – IFRS mapping setIFRS mapping set Version: 2.00 Version: 2.00

Characteristics Components breakdown IFRS-GPteller machines (ATM) owned by credit institutions

Apéndice A. Approval process

Stage Responsible for decision Next step Required

versions Target Date1 Public working draft Eurostat Approval

2Update for credit Entities. Added chapter 4.

Eurostat

Apéndice B. ReferencesA similar task was carried out by Georgios Pappas in Feb 2004

(http://forum.europa.eu.int/irc/dsis/accstat/info/data/en/point%202%20sbs-ias%20study.doc)

Confidential Document property of Eurostat