{"id":3654,"date":"2022-09-08T10:04:58","date_gmt":"2022-09-08T08:04:58","guid":{"rendered":"https:\/\/www.recordinformatica.it\/?page_id=3654"},"modified":"2023-02-20T12:27:38","modified_gmt":"2023-02-20T11:27:38","slug":"production-of-xml-sepa-flows_en","status":"publish","type":"page","link":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm","title":{"rendered":"Production of XML SEPA flows"},"content":{"rendered":"<p>[vc_row el_class=&#8221;fake_breadcrumbs&#8221;][vc_column][vc_column_text]<strong><span class=\"menu_2_grass\">Products <\/span><\/strong><span class=\"menu_2\"><b>&gt;\u00a0<\/b>XML SEPA<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2297 alignleft\" src=\"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/Sepa.jpg\" alt=\"\" width=\"200\" height=\"73\" \/><\/p>\n<p><strong>SEPA<\/strong> (<strong>Single Euro Payments Area<\/strong>) is a project promoted by the European Central Bank and the European Commission, whose aim is to extend the European integration process to euro retail payments made by non-cash means (credit transfers, direct debits and payment cards).[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Since February 1, 2014, the SEPA legislation has come into effect, demanding new data transmission formats for credit transfers and RID, based on the XML standard that replaces the CBI (Customer to Business Interaction) formats.<\/p>\n<p>The Bank of Italy has provided for a temporary derogation in the enforcement of the new track until the 1st of February, 2016. After that, however, the data must be sent from the companies to the banks according to this new format.<\/p>\n<p><strong>If you need to create this (relatively complex) type of flow for Credit Transfers (Credit Transfer &#8211; SCT) and RID (Direct Debit &#8211; SDD), Record Informatica can provide you with a native <a href=\"https:\/\/www.recordinformatica.it\/en\/what-is-as-400_en.htm\">AS\/400<\/a> procedure (iseries &#8211; System i &#8211; IBM i) which allows you to convert an AS400 file to the XML format required by the SEPA regulation.<\/strong><\/p>\n<p>The steps to create and send the flow in the new format are three:<\/p>\n<ol>\n<li>Preparation of payment data on a dedicated track on text file AS\/400<\/li>\n<\/ol>\n<p><strong>For the users of the Accounting Applications Management (ACG) updated to version 3.3 or 3.8, we have a connector already prepared for the conversion from the transfer and RID archive to our data format.<\/strong><\/p>\n<p>Since the files exported by ACG are in <strong>CBI<\/strong> format, the ACG connector is also suitable for converting streams produced by other management systems that create CBI files for credit transfers and RID.<\/p>\n<p>Below you can see a partial example of an input file used for our procedure, containing the basic data required by the submission (recipient\u2019s IBAN, company name, etc.).[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=&#8221;2299&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Note that among the input data there is also the &#8220;type of credit transfer&#8221;, primarily to manage the differentiation present in some TLQ between general and payroll transfers.<\/p>\n<p>The procedure also checks for the presence of fundamental data by blocking the generation of the flow in the absence of elements such as the creditor\u2019s IBAN. The presence of invalid characters, replaced by spaces, is also checked.<\/p>\n<p>A modification function of the data of the transfers in input is also provided, so you can correct\/ add any incorrect or missing data. With the same procedure you can even enter a bank transfer from scratch or cancel one.<\/p>\n<p><strong>2. Performing the AS\/400 procedure, provided by us, to convert to XML<\/strong><\/p>\n<p>Run the program provided by us, which will take care of all the conversion steps, obtaining an XML file saved in an AS\/400 library and compliant with SEPA standards. Below you can see an example:[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=&#8221;2301&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<strong>3. Download the XML file, via Client Access or FTP, from AS\/400 and import it to TLQ (corporate banking)<\/strong><\/p>\n<p>This involves performing an operation, by the accounting user, of acquiring (through Client Access or FTP) the file from the AS\/400 system and then uploading it to the home (or corporate) banking site.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=&#8221;2303&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]As you can see, the operation is very simple and allows you to prepare the transfer flow or RID in XML SEPA format, starting from a simplified start file or in <strong>CBI<\/strong> format (as for <strong>ACG<\/strong>).<\/p>\n<p>You can, therefore, put this final conversion into your AS\/400 workflow without changing the operation of users who, in the end, just download a file from the AS\/400 just like they always do.<\/p>\n<p><strong>Transfer &#8220;XML Estero&#8221;<\/strong><\/p>\n<p>The procedure also allows you to create the flow for the &#8220;<strong>Foreign XML<\/strong>&#8221; transfers. This is the flow in XML format, also inspired by the ISO 20022 standard, dedicated to transfers outside the SEPA area (the US, for example) or within the SEPA area but in a currency other than euro (Switzerland in francs, for example).[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Download the presentation <strong>document<\/strong> of our Credit Transfer and SEPA RID procedure below.<\/p>\n<ul>\n<li><a href=\"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/XML-SEPA.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">XML-SEPA Presentation<\/a> (italian version)<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row el_class=&#8221;fake_breadcrumbs&#8221;][vc_column][vc_column_text]Products &gt;\u00a0XML SEPA[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text] SEPA (Single Euro Payments Area) is a project promoted by the European Central Bank and the<\/p>\n","protected":false},"author":7,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3654","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Preparation of SEPA XML file for AS400<\/title>\n<meta name=\"description\" content=\"Description of the software to produce SEPA XML files with the AS\/400 (iSeries - IBM i ) system.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Preparation of SEPA XML file for AS400\" \/>\n<meta property=\"og:description\" content=\"-1170\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm\" \/>\n<meta property=\"og:site_name\" content=\"Record Informatica\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-20T11:27:38+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"4\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/Sepa.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm\",\"url\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm\",\"name\":\"Preparation of SEPA XML file for AS400\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.recordinformatica.it\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/Sepa.jpg\",\"datePublished\":\"2022-09-08T08:04:58+00:00\",\"dateModified\":\"2023-02-20T11:27:38+00:00\",\"description\":\"Description of the software to produce SEPA XML files with the AS\\\/400 (iSeries - IBM i ) system.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.recordinformatica.it\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/Sepa.jpg\",\"contentUrl\":\"https:\\\/\\\/www.recordinformatica.it\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/Sepa.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/production-of-xml-sepa-flows_en.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.recordinformatica.it\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Production of XML SEPA flows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/\",\"name\":\"Record Informatica\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/#organization\",\"name\":\"Record Informatica\",\"url\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.recordinformatica.it\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/logo_recordgrande_white_border_top_bottom-3.jpg\",\"contentUrl\":\"https:\\\/\\\/www.recordinformatica.it\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/logo_recordgrande_white_border_top_bottom-3.jpg\",\"width\":568,\"height\":368,\"caption\":\"Record Informatica\"},\"image\":{\"@id\":\"https:\\\/\\\/www.recordinformatica.it\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Preparation of SEPA XML file for AS400","description":"Description of the software to produce SEPA XML files with the AS\/400 (iSeries - IBM i ) system.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm","og_locale":"en_US","og_type":"article","og_title":"Preparation of SEPA XML file for AS400","og_description":"-1170","og_url":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm","og_site_name":"Record Informatica","article_modified_time":"2023-02-20T11:27:38+00:00","twitter_card":"summary_large_image","twitter_title":"4","twitter_image":"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/Sepa.jpg","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm","url":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm","name":"Preparation of SEPA XML file for AS400","isPartOf":{"@id":"https:\/\/www.recordinformatica.it\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm#primaryimage"},"image":{"@id":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/Sepa.jpg","datePublished":"2022-09-08T08:04:58+00:00","dateModified":"2023-02-20T11:27:38+00:00","description":"Description of the software to produce SEPA XML files with the AS\/400 (iSeries - IBM i ) system.","breadcrumb":{"@id":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm#primaryimage","url":"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/Sepa.jpg","contentUrl":"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2020\/08\/Sepa.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.recordinformatica.it\/en\/production-of-xml-sepa-flows_en.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.recordinformatica.it\/en\/"},{"@type":"ListItem","position":2,"name":"Production of XML SEPA flows"}]},{"@type":"WebSite","@id":"https:\/\/www.recordinformatica.it\/it\/#website","url":"https:\/\/www.recordinformatica.it\/it\/","name":"Record Informatica","description":"","publisher":{"@id":"https:\/\/www.recordinformatica.it\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.recordinformatica.it\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.recordinformatica.it\/it\/#organization","name":"Record Informatica","url":"https:\/\/www.recordinformatica.it\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recordinformatica.it\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2023\/03\/logo_recordgrande_white_border_top_bottom-3.jpg","contentUrl":"https:\/\/www.recordinformatica.it\/wp-content\/uploads\/2023\/03\/logo_recordgrande_white_border_top_bottom-3.jpg","width":568,"height":368,"caption":"Record Informatica"},"image":{"@id":"https:\/\/www.recordinformatica.it\/it\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/pages\/3654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/comments?post=3654"}],"version-history":[{"count":0,"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/pages\/3654\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.recordinformatica.it\/en\/wp-json\/wp\/v2\/media?parent=3654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}