User manual for e-Line DNB: the XML import file version 1.2 dated
Contents
1. Section 7 3 gives an example of an import file containing a dynamic table It shows that items may also have the same row numbers There are items in the example in Section 7 3 that are positioned on the same row number in the table but in different colums 10 User manual for e Line DNB the XML import file 5 Validating the XML import file You can validate your import file to make sure that it has the correct format using the XSD file in Annex 1 11 User manual for e Line DNB the XML import file 6 Importing the XML import file to e Line DNB This section describes how an import file should be imported to e Line DNB Procedure e in the list of requirements click on Import under Period after which the following screen appears Period 31 12 2014 31 12 2014 31 12 2014 31 12 2014 31 12 2014 31 12 2014 31 12 2014 Search import file xml or zip 31 12 2014 31 12 2014 Options 31 12 2014 i A Only import into empty form set 31 12 2014 Combining items 31 12 2014 Remove dimensions a 31 12 2014 Error situation 9 Skip invalid items only Skip invalid forms only Abort import operation when an invalid form is found IMPORT Figure 3 Importing reports e Use the Browse button Bladeren to locate the file you wish to import XML format e You then have a choice of three options Only import into empty form set Tick this option if you wish to prevent previously2. cube the row and the column in which the field is positioned This indicates the precise location of the value to be entered User manual for e Line DNB the XML import file Staat muller 9006 blad 2 2 Kwa sak appa lage GrensoverrchviMerd Be lalrgsuerkeer Figure 2 Cube row rij and column kolom The Item tag has the following attributes lt post value 425 cube bijlage2 rij 11201 kolom 3 or lt post value 425 cube bijlage omzet dochters rij 0 kolom 3 rijnr 12 gt Value Enter the value for the item It does not need to consist of digits A combination of digits and letters is also allowed Cube Enter the name of the table in which you wish to place the value Each form consists of at least one table These tables are referred to as cubes in the item tags of the XML files Note A list of all forms and the names of the related cubes can be found on http www dnb nl en statistics eline dnb index jsp Please make sure you copy these names carefully Rij Enter the number of the row in the table in which you wish to place the value Although the row numbers have not been formatted in a uniform manner in the XML files these are a few rules of thumb Contains only digits Contains no dots Contains no spaces User manual for e Line DNB the XML import file Inthe case of a dynamic table the value of the row is 0 see the row number
3. lt post value 1 05 04 cube bijlage1 rij 0 kolom 01 rijnr 0 gt lt post value 1 06 04 cube bijlage1 rij 0 kolom 01 rijnr 1 gt lt post value 1 07 04 cube bijlage1 rij 0 kolom 01 rijnr 2 gt lt post value 1 08 04 cube bijlage1 rij 0 kolom 01 rijnr 3 gt lt post value 1 09 04 cube bijlage1 rij 0 kolom 01 rijnr 4 gt lt post value 1 10 04 cube bijlage1 rij 0 kolom 01 rijnr 5 gt lt post value 100 cube bijlage1 rij 0 kolom 03 rijnr 0 gt lt post value 100 cube bijlage1 rij 0 kolom 03 rijnr 1 gt lt post value 100 cube bijlagel rij 0 kolom 03 rijnr 2 gt lt post value 100 cube bijlage1 rij 0 kolom 03 rijnr 3 gt lt post value 100 cube bijlage1 rij 0 kolom 03 rijnr 4 gt lt post value 100 cube bijlagel rij 0 kolom 03 rijnr 5 gt lt post value 1 05 04 cube bijlage2 rij 0 kolom 01 rijnr 0 gt lt post value 1 06 04 cube bijlage2 rij 0 kolom 01 rijnr 1 gt lt post value 1 07 04 cube bijlage2 rij 0 kolom 01 rijnr 2 gt lt post value 1 08 04 cube bijlage2 rij 0 kolom 01 rijnr 3 gt lt post value 1 09 04 cube bijlage2 rij 0 kolom 01 rijnr 4 gt lt post value 1 10 04 cube bijlage2 rij 0 kolom 01 rijnr 5 gt lt post value 1500 cube bijlage2 rij 0 kolom 04 rijnr 0 gt lt post value 1500 cube bijlage2 rij 0 kolom 04 rijn
4. 8 Support If you have any questions about the XML files please contact DNB Service Desk Telephone 31 20 524 6111 E mail servicedesk dnb nl You can find examples of import files on http www dnb nl en statistics eline dnb index jsp as well as the e Line DNB User Manual 18 User manual for e Line DNB the XML import file Annexes Annex 1 XSD file lt xml version 1 0 encoding UTF 8 gt lt l W3C Schema generated by XML Spy v4 3 U http www xmlspy com gt lt xs schema xmins xs http www w3 org 2001 XMLSchema elementFormDefault qualified gt lt xs element name bestand gt lt xs complexType gt lt xs sequence gt lt xs element name rapportage type rapportageType maxOccurs unbounded gt lt xs sequence gt lt xs attribute name registratienummer type xs int use required gt lt xs complexType gt lt xs element gt lt xs complexType name postType gt lt xs attribute name value type xs long use required gt lt xs attribute name cube type xs string use required gt lt xs attribute name rij type xs int use required gt lt xs attribute name kolom type xs byte use required gt lt xs complexType gt lt xs complexType name rapportageType gt lt xs sequence gt lt xs element name variant type variantType minOccurs 0 maxOccurs unbounded gt lt xs element name post type postType maxOccurs unbounded gt lt x
5. 03 gt lt post value cube blad1 rij 00120 kolom 12 gt lt post value cube blad1 rij 00120 kolom 13 gt lt post value cube blad1 rij 00130 kolom 02 gt lt post value cube blad1 rij 00130 kolom 03 gt lt post value cube blad1 rij 00130 kolom 12 gt lt post value cube blad1 rij 00130 kolom 13 gt lt post value cube blad1 rij 00210 kolom 03 gt lt post value cube blad1 rij 00210 kolom 13 gt lt post value cube blad1 rij 00220 kolom 03 gt lt post value cube blad1 rij 00220 kolom 13 gt lt post value cube blad1 rij 00230 kolom 03 gt lt post value cube blad1 rij 00230 kolom 13 gt lt post value cube blad1 rij 00300 kolom 02 gt lt post value cube blad1 rij 00300 kolom 03 gt lt post value cube blad1 rij 00300 kolom 12 gt lt post value cube blad1 rij 00300 kolom 13 gt lt post value cube blad1 rij 00410 kolom 02 gt lt post value cube blad1 rij 00410 kolom 03 gt lt post value cube blad1 rij 00410 kolom 12 gt lt post value cube blad1 rij 00410 kolom 13 gt lt post value cube blad1 rij 00420 kolom 02 gt lt post value cube blad1 rij 00420 kolom 03 gt lt post value cube blad1 rij 00420 kolom
6. 12 gt lt post value cube blad1 rij 00420 kolom 13 gt lt post value cube blad1 rij 00430 kolom 02 gt lt post value cube blad1 rij 00430 kolom 03 gt lt post value cube blad1 rij 00430 kolom 12 gt lt post value cube blad1 rij 00430 kolom 13 gt lt post value cube blad1 rij 00510 kolom 02 gt lt rapportage gt lt bestand gt 15 User manual for e Line DNB the XML import file 7 2 XML import file with a variant lt xml version 1 0 encoding UTF 8 gt lt bestand registratienummer 99983 gt TP nihil false periode 2002 11 30 formulierid 8501 frequentie M lt post value 100 cube blad1 lt post value 101 cube blad1 lt post value 103 cube blad1 lt post value 108 cube blad1 lt post value 109 cube blad1 lt post value 111 cube blad1 lt post value 101 cube blad1 lt post value 103 cube blad1 lt post value 108 cube blad1 lt post value 109 cube blad1 lt post value 110 cube blad1 lt post value 112 cube blad1 rij 010000 kolom 03 gt rij 011000 kolom 03 gt rij 013000 kolom 03 gt rij 018000 kolom 03 gt rij 011000 kolom 05 gt rij 013000 kolom 05 gt rij 021000 kolom 04 gt rij 023000 kolom 04 gt rij 028000 kolom 04 gt rij 029000 kolom 04 gt rij 021000 kolom 05 gt rij 023000 kolom 05 gt
7. attribute below Note Departures from these rules may occur in exceptional cases A row name may then be for example 00 5 1 0 Examples of all XML files can be found on http www dnb nl en statistics eline dnb index jsp You can check there how you must include the row numbers in the specific report you wish to import e Kolom Enter the number of the column in the table in which you wish to place the value Although the column numbers have not been formatted in a uniform manner in the XML files these are a few rules of thumb Contains only digits Contains no leading zeros Contains no dots Contains no spaces Note Departures from these rules may occur in exceptional cases A column name may then be for example 03 Examples of all XML files can be found on http www dnb nl en statistics eline dnb index jsp You can check there how you must include the column numbers in the specific report you wish to import e Rijnummer This attribute is used for dynamic tables only The number of rows is variable rather than fixed in dynamic tables which means that reporting entities may add rows at their own discretion If you do set the value of a row attribute to 0 and start numbering the rows from 0 Although the row numbers have not been formatted in a uniform manner in the XML files these are a few rules of thumb Contains only digits Contains no dots Contains no spaces Numbering starts at 0
8. entered data from being overwritten e Line DNB will only import data into a report that was not previously completed or stored Combining items Tick this option if the data in your import file must be added to data previously entered in your report Remove dimensions Tick this option if you wish to overwrite variants such as currencies and countries e Line DNB will first remove variants in the form before importing new variants to prevent the report from containing more variants following importing than the import file You may choose to tick no one two or three options If you do not tick any all data previously entered will be overwritten by those in the import file e You must then choose one of the following three options Only skip invalid items 12 User manual for e Line DNB the XML import file Choose this option if you want e Line DNB to continue importing the next item after an unknown or incorrect item has been found in the import file The incorrect item will then be skipped Only skip invalid reports Choose this option if you want e Line DNB to continue importing the next form after an unknown or incorrect item has been found in the import file The other items in the form in which the incorrect item was found will also be skipped Abort import operation when an invalid form is found Choose this option if you wish e Line DNB to stop the import once an unknown item is found in the import file Changes
9. User manual for e Line DNB the XML import file User manual for e Line DNB the XML import file version 1 2 dated 19 February 2015 User manual for e Line DNB the XML import file 1 Contents Je CONtEntS iin ssn E aed iet ae ease els ade en ette daan setae 2 Be me DN Dr ts etna E E E Alas candy nne 3 2 1 Submitting your reports to De Nederlandsche Bank nanne 3 2 3 Entering data manually or importing data nevens evens er enneerenneerenneevenne 3 ZA Structure of this mantal til it kont based okeee 3 de The POE AI ern A toate tn ech ve E O 4 SL Overall StuG aida a a 4 3 2 N AROS types OL MELAS A IES dada 4 0 Usina one or several Imports 5 4 Fags and AUT ULES AAA Ee een 7 A O 7 AD REDOT SEE 7 AS tl lts EE 7 A A A A cae de woes oem aaah Sagas 8 5 Validating the XML import lesvianas 11 6 Importing the XML import file to e Line DNB nanne enne erneeeen veen 12 Te Examples of AM IES str Natan ae sath beta tL E 15 Tl AML 1mp rt lea aid sida 15 7 2 XML import file with a variant di RA iia 16 7 3 XML import file with a dynamic table netten teert 17 A EE EE E E E A E E EA 18 A a a e i 19 Annex 1 XSD Tile util a 19 dek pne nA L E tie each 2s a R a outa 2 a E ES 20 User manual for e Line DNB the XML import file 2 e Line DNB 2 1 Submitting your reports to De Nederlandsche Bank Various financial institutions are obliged under statutory provisions to submit periodic reports to De Nederlandsche Bank DNB These report
10. dler at DNB if you do not know which address is used e You can now add or change data manually if needed and save the form set 13 User manual for e Line DNB the XML import file Note A file that was successfully imported may still contain errors e g if the imported report s opening balance does not reconcile with the closing balance for the previous period This type of error may prevent a report from being submitted You can make errors visible by performing a check See the e Line DNB User Manual http www dnb nl en statistics eline dnb general user documentation index jsp 14 User manual for e Line DNB the XML import file 7 Examples of XML import files The examples of XML code presented in this section only serve to illustrate an import file s structure Files are often much longer in practice The examples may be lacking certain mandatory fields 7 1 XML import file lt xml version 1 0 encoding UTF 8 gt lt bestand registratienummer gt lt rapportage nihil false periode 20 formulierid 9006 frequentie K gt lt post value cube blad1 rij 00110 kolom 02 gt lt post value cube blad1 rij 00110 kolom 03 gt lt post value cube blad1 rij 00110 kolom 12 gt lt post value cube blad1 rij 00110 kolom 13 gt lt post value cube blad1 rij 00120 kolom 02 gt lt post value cube blad1 rij 00120 kolom
11. ether your report is a yearly report jaarrapportage J a quarterly report kwartaalrapportage K amonthly report maandrapportage M a weekly report weekrapportage W a daily report dagrapportage D 4 3 Variant The Variant tag has the following attributes lt variant type land value BW gt lt variant type valuta value USD gt User manual for e Line DNB the XML import file e Type valuta or land Enter the name of the variant Two often used variants are currency and country You must use the ISO codes to indicate these The correct codes may be found on various websites including www iso ch Many variants have values that you can define yourself such as the bank account number variant e Value Enter the value for the variant Example Botswana value BW Example US dollar value USD If you report on several variants e g currency and country you must create a report for each variant in the import file This means the import file s structure 1s as follows lt bestand gt lt rapportage gt lt variant gt lt post gt lt post gt lt rapportage gt lt rapportage gt lt variant gt lt post gt lt post gt lt rapportage gt lt bestand gt 4 4 Item The attributes of the Item tag are used to indicate the position in which a specific value is placed by stating the coordinates of the field to be completed specifying the table
12. made to previously imported files will be saved hereas the form containing the incorrect item and the remaining forms in the import file will not be imported You can choose one of the above options The default selection is the second option e Now click on the IMPORT button e Line DNB presents an import report following importing The screen below will appear T Wi x 2 Import form s Windows Internet Explorer S 5 amp e https e line dnb nl eline forward do action importerengoed aa Start import 27 01 2015 15 14 12 End of import 27 01 2015 15 14 16 File name Test xml File type text xml File size bytes 2967 File error No Form Period Frequency Dimension Dimension value Imported Rejected items AIF24F10V14 2014 12 31 H Yes c01 c_01 r_22 c20 c_73 r_aws_233 Figure 4 Import report The import report shows whether importing has been successful The import illustrated above has been successful as can be seen from the word Yes under the Imported header However a number of items were rejected You can read the error messages for each imported form by clicking the code for the form in the import report In addition you will receive the import report by e mail to allow you to read it afterwards Only one e mail address for each reporting entity is linked to the system and import reports will be sent to this address Please contact your report han
13. ple the structure of an import file containing several reports may be as follows User manual for e Line DNB the XML import file lt bestand gt lt rapportage gt lt variant gt lt post gt lt post gt lt rapportage gt lt rapportage gt lt variant gt lt post gt lt post gt lt rapportage gt lt bestand gt User manual for e Line DNB the XML import file 4 Tags and attributes This section describes the tags and attributes in the generic XML structure 4 1 File The File tag has one attribute lt bestand registratienummer 99983 gt e Registratienummer This is where you enter the registration number you were given by DNB The number is compared with the details of the reporting entity logged in during importing If they do not match the file cannot be imported 4 2 Report The Report tag has the following attributes lt rapportage nihil false periode 2005 12 31 formulierid 9005 frequentie M gt e Nihil true or false Enter true if you are submitting a nil report If your report is not a nil report enter false e Periode YYYY MM DD Enter the closing date of your reporting period e Formulier id Enter the name of the form A list of all forms and their IDs can be found on http www dnb nl en statistics eline dnb index jsp o Frequentie J K M Ww D Indicate wh
14. r 1 gt lt post value 1500 cube bijlage2 rij 0 kolom 04 rijnr 2 gt lt post value 1500 cube bijlage2 rij 0 kolom 04 rijnr 3 gt lt post value 1500 cube bijlage2 rij 0 kolom 04 rijnr 4 gt lt post value 1500 cube bijlage2 rij 0 kolom 04 rijnr 5 gt lt rapportage gt lt bestand gt 16 User manual for e Line DNB the XML import file 7 3 XML import file with a dynamic table lt bestand registratienummer 99983 gt lt rapportage nihil false periode 2002 11 30 formulierid 8501 frequentie M varianttype valuta variantwaarde USD gt lt post value 100 cube blad1 lt post value 101 cube blad1 lt post value 103 cube blad1 lt post value 108 cube blad1 lt post value 109 cube blad1 lt post value 111 cube blad1 lt post value 101 cube blad1 lt post value 103 cube blad1 lt post value 108 cube blad1 lt post value 109 cube blad1 lt post value 110 cube blad1 lt post value 112 cube blad1 lt post value 100 cube bijlage1 lt post value 100 cube bijlage1 lt post value 100 cube bijlage1 lt post value 100 cube bijlage1 lt post value 100 cube bijlage1 lt post value 100 cube bijlage1 lt post value 1 05 04 cube bijlage2 lt post value 1 06 04 cube bijlage2 lt post value 1 07 04 cube bijlage2 lt post value 1 08 04 cube bijlage2 lt post value 1 09 04 cube bijlage2 lt po
15. reo An neen ee 8 N O A O 7 P ONO 7 20 User manual for e Line DNB the XML import file R TOBIN UNO ia 7 remove variants AA iia 12 Ae EEE EN 4 OPONEN ic wreede venen et 7 reporting obligations A A aE eia 3 pS inns iten eneen eeen te ls 5 Ossa ereen eren a eesveedegouaniae E 9 CIA A trado 10 S Skipping incorrect items secsi d a AA AA ib 13 Skipping incorre rE O S a eene ate en E E ee 13 O ANO 18 T V A arlene des he eee nies ee ee ee eet ae 11 A TNA 9 da 7 16 VCE In erosiones E E E ETA 7 voorbeeld MEDION ta 10 NN 4 X XMLimporttile example iaa a ee XML imp rtfil A ET ETE do A A E E E ds XML import file with a dynamic table example He XML import file with a variart example 25400200 ida 21
16. rt files User manual for e Line DNB the XML import file 3 The import file This section describes the generic XML structure of an import file 3 1 Overall structure Each XML import file has the following overall structure lt bestand gt lt rapportage gt lt variant gt lt post gt lt post gt lt rapportage gt lt bestand gt This means that an import file bestand contains information from one or several reports rapportage e g the 9006 report and or the 9002 report A report may contain a variant e g when you must complete the same table s of a form for various variants Suppose you must report on euro yen and US dollar amounts then currency is the variant The various items posten are listed in the report The items are described using their location in the form e g table revenue data row number 12 column number 3 Each items is then given a value These building blocks bestand rapportage variant and post are referred to as tags In turn tags are composed of other building blocks referred to as attributes Section 4 explains these attributes in more detail Paragraph 4 1 discusses the attributes of the File tag Paragraph 4 2 deals with the attributes of the Report tag Paragraph 4 3 describes the Variant attributes and Paragraph 4 4 explains the Item attributes 3 2 Various types of fields A form in e Line DNB can contain two types of field
17. s see Figure 1 input field invoerveld Fields completed by the reporting entity These are the yellow empty fields calculation field rekenveld Fields whose values are automatically calculated based on the values of the fields completed by the reporting entity In e Line DNB they are always grey and always contain a value Their value is 0 in the example provided in Figure 1 You only need to include the input fields in the XML import file User manual for e Line DNB the XML import file Staatfornuier 9006 Had 1 1 Kwartaarappertage Bnnerlands Betalingsverkeer Esem voor de Medertarmiode Bart Pe tack Ist tha Code namme r Became ben Boe ne ne un aartalkn b clubenckneenbecta Am taltan acts Be bor ack onzter Totaal Partcaker Ze llk Total Partcaler Zae ilk Debeivostr ol oz u o lij o 0 Lj o li o 0 0 0 o Li o ooooo rekenveld o 0 ooo Que ite transacties pen debe tos en nn Figure 1 Input field invoerveld and calculation field rekenveldn 3 3 Using one or several import files Many reporting forms in e Line DNB contain large and complex tables Of course the 1mport file will also contain a long list of items You may also use several import files and either import them one by one or combine them into a ZIP file for importing You may include several reports in a single import file which allows you to complete an entire form set in e Line DNB using a single import file For exam
18. s provide DNB the information it needs to perform its duties Most of them are submitted using e Line DNB DNB s internet application which you can use to complete and submit your reports Using the log in details provided you can log in to the website after which an overview of your current reporting obligations is shown 2 3 Entering data manually or importing data All fields of a report may be completed manually in e Line DNB but in some cases it may be easier to export data from your own accounting system as an XML file and 1mporting it to e Line DNB e g in case of a large number of data This manual is aimed at system developers of those reporting entities that wish to complete their reports using such XML import files It describes the structure which an XML import file should have to ensure problem free importing into e Line DNB 2 4 Structure of this manual Section 3 of this manual explains the generic XML structure Section 4 describes the tags in that generic structure and the attributes of which they consist Section 5 describes how an import file must be validated Section 6 explains how you must import the XML files to e Line DNB Section 7 provides examples of various types of XML files a plain XML import file an XML import file with a variant and an XML import file with a dynamic table You may also request support from DNB Section 8 sets out how and where you can reach us to ask for support when creating your XML impo
19. s sequence gt lt xs attribute name nihil type xs boolean use required gt lt xs attribute name periode type xs date use required gt lt xs attribute name formulierid type xs string use required gt lt xs attribute name frequentie type xs string use required gt lt xs complexType gt lt xs complexType name variantType gt lt xs attribute name type type xs string use required gt lt xs attribute name value type xs string use required gt lt xs complexType gt lt xs schema gt 19 User manual for e Line DNB the XML import file Index A attributes nennen O deer nne deed eee ee eee 4 C Calcula els A SA E A A A E S 4 A 5 Succ head 25 tahcces EEE A TAE AE ETA Gab sens Lande tah diel EA A 10 combine E S 22 nennen SS o dl 12 completing reports m nually ico iii 3 lof nn AE cube currency D DNB Service Desk sns enen dao aia 18 dynamietables rme nnen hetere vam even eee are ee 10 17 A EEn 10 E Lina INBA ia 3 F A eit ies OS Rene ee a en aed 7 A ON 7 I ID 7 import file structure overall import files several import report eee En import Only ifinOt vet existing nn seert ta importing stop after incorrect report has been found aans ernneeonseerneernnerenseennenenserensernsereneernnenenseennenentersneennen 13 Aal ore Ta AEN 12 input Maldita ii aliaron al necia A A 4 NEEN NO 4 MO o e CO te od 8 TEM Stag a A A A o
20. st value 1 10 04 cube bijlage2 lt post value 1500 cube bijlage2 lt post value 1500 cube bijlage2 lt post value 1500 cube bijlage2 lt post value 1500 cube bijlage2 lt post value 1500 cube bijlage2 lt post value 1500 cube bijlage2 lt rapportage gt lt bestand gt rij 010000 kolom 03 gt rij 011000 kolom 03 gt rij 013000 kolom 03 gt rij 018000 kolom 03 gt rij 011000 kolom 05 gt rij 013000 kolom 05 gt rij 021000 kolom 04 gt rij 023000 kolom 04 gt rij 028000 kolom 04 gt rij 029000 kolom 04 gt rij 021000 kolom 05 gt rij 023000 kolom 05 gt lt post value 1 05 04 cube bijlage1 rij 0 kolom 01 rijnr 0 gt rij 0 kolom 03 rij 0 kolom 03 rij 0 kolom 03 rij 0 kolom 03 rij 0 kolom 03 rij 0 kolom 03 rij 0 kolom 01 rij 0 kolom 01 rij 0 kolom 01 rij 0 kolom 01 rij 0 kolom 01 rij 0 kolom 01 rijnr rijnr rijnr rijnr rijnr rijnr 17 rijnr 0 gt rijnr 1 gt rijnr 2 gt rijnr 3 gt rijnr 4 gt rijnr 5 gt 0 gt nefe 12 gt 3 gt a gt 5 gt rij 0 kolom 04 rijnr 0 gt rij 0 kolom 04 rijnr 1 gt rij 0 kolom 04 rijnr 2 gt rij 0 kolom 04 rijnr 3 gt rij 0 kolom 04 rijnr 4 gt rij 0 kolom 04 rijnr 5 gt User manual for e Line DNB the XML import file
Download Pdf Manuals
Related Search