{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Form","Data sets","Data 146","Data 147","Recurring 148","Recurring 149","Data 150","Arvomäärittelyt"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["REPORT ON A REPORTABLE ARRANGEMENT (VSDAC6DC)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"<--- Click the button to open a table to be filled in"]
["INSTRUCTIONS:"]
[]
["Enable macros if prompted: Settings – Enable this content – OK"]
[]
["The Generate file button runs a macro that saves the file in the directory of your choice under a name specified by you."]
[]
["Always accept the data you have entered by pressing Enter or the arrow button."]
[]
["1. Enter the details in appropriate columns based on descriptions and identifiers."]
[]
["2. Run the macro by pressing the command button."]
[]
["3. When the file has been generated, you can check its accuracy "]
["by using the TYVI-record check routine in Ilmoitin.fi."]
[]
[]
["IF YOU COPY DATA FROM ANOTHER FILE, USE THE ATTACH BY SPECIFYING VALUES/TEXT FUNCTION "]
["SO AS NOT TO COPY THE FORMAT OF THE SOURCE DATA, WHICH MIGHT INTERFERE WITH THE MACRO."]

{"sheet":"Form","index":1,"n_rows":280,"n_cols":3,"rows_kept":280,"cut":false,"hidden":false,"merged":[]}
[null,"Enter data in the Value field. To add a recurring data set, click the Add partial data set button. For some data elements, allowed values have been determined. To select a value, click the arrow next to the field. No other calculation or check routines."]
[null,"When you have entered the data, you can generate a name:value data pair file by clicking the Generate file button. The file is saved in the folder of your choice. Click the Data pairs button to list the data converted into name:value data pairs on this page."]
["Ilmoitus raportoitavasta järjestelystä",null,"Value"]
["000","File identifier","VSDAC6DC"]
["061","This is a replacement report"]
["062","This is a marketable arrangement"]
["063","First report on a marketable arrangement"]
["064","The report contains inside information"]
["065","Date or estimated date when inside information is free for release"]
["066","Reference number"]
["067","Report number"]
["010","Filer’s Finnish Business ID or personal ID"]
["011","Type of filer"]
["012","Filer's foreign TIN"]
["013","Filer’s name: full name of legal person or last name of natural person"]
["015","Filer’s (natural person’s) first name"]
["016","Filer’s (natural person’s) middle names"]
["017","Filer’s (natural person’s) date of birth"]
["018","Filer’s (natural person’s) place of birth"]
["019","Filer’s address: street name"]
["020","Filer’s address: house number"]
["021","Filer’s address: entrance"]
["022","Filer’s address: door number"]
["023","Filer’s address: P.O. Box"]
["024","Filer’s address: postal code"]
["025","Filer’s address: post office"]
["026","Filer’s address: country"]
["027","Filer’s country of tax residence"]
["028","Filer's telephone number"]
["029","Filer’s e-mail address"]
["030","Filer’s role"]
["031","Filer’s connection to report country"]
["032","The filer is liable to submit reports to more than one EU Member State."]
["033","Service provider’s status"]
["034","The service provider is relieved from the reporting obligation on account of confidentiality"]
["035","Basis for taxpayer’s report"]
["Recurring data set, 0–n",null,"Osatietoryhmat"]
[141,"Date of implementation of the arrangement"]
["142","Value of the arrangement"]
["143","Main benefit test is fulfilled"]
["144","Basis for the reporting obligation"]
["145","Name of arrangement"]
["146","Description of arrangement (summary)","Tieto146"]
["147","Regulations on which the arrangement is based","Tieto147"]
["002","Recurring lines 148 EU Member States that the arrangement concerns","Toistuvat148"]
["002","Recurring lines 149 Hallmarks","Toistuvat149"]
["150","DAC6D1 other information","Tieto150"]
["168","Date when the arrangement was implemented (identifier 141) is unknown "]
["169","Value of the arrangement (identifier 142) is unknown"]
["048","Software that generated the report"]
["014","Identifier of the software that generated the file","0245458-3_VH"]
["198","Software-generated timestamp",{"$f":"Arvomäärittelyt!N2&Arvomäärittelyt!U2","v":"02112022072254"}]
["999","End-of-record character",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Urakoitsijan ja urakan tiedot"]
["Urakoitsijan tunnistetiedot"]
["400","Toimeksiannon laji"]
["300","Urakoitsijan nimi"]
["301","Urakoitsijan y-tunnus tai suomalainen henkilötunnus"]
["302","Urakoitsijan ulkomainen tunnus"]
["303","Urakoitsijan ulkomaisen tunnuksen tyyppi"]
["304","Urakoitsijan kotivaltio"]
["305","Urakoitsijan kotivaltion nimi"]
["Urakoitsijan osoite kotivaltiossa"]
["306","Urakoitsijan c/o tarkenne kotivaltiossa"]
["307","Urakoitsijan lähiosoite kotivaltiossa"]
["308","Urakoitsijan PL kotivaltiossa"]
["309","Urakoitsijan postinumero kotivaltiossa"]
["310","Urakoitsijan postitoimipaikka kotivaltiossa"]
["311","Urakoitsijan osoitteen maatunnus"]
["312","Urakoitsijan osoitteen maan nimi"]
["350","Urakoitsijan yhteyshenkilön sukunimi"]
["351","Urakoitsijan yhteyshenkilön etunimi"]
["352","Urakoitsijan yhteyshenkilön puhelinnumero"]
["Ei toimintaa ilmoitus urakoitsijakohtaisesti"]
["401","Ei-toimintaa kohdekuukautena urakoitsijakohtaisesti"]
["Urakkaa koskevat tiedot"]
["402","Käännetty ALV"]
["403","Urakan laskutettu määrä"]
["404","Urakan maksettu määrä"]
["405","Ennakkomaksu"]
["406","Urakkasumma  kokonaisuudessaan"]
["407","Urakan alkupäivämäärä"]
["408","Urakan loppupäivämäärä"]
["Vuokratyönteettäjän antama tieto vuokratyövoiman käytön aloituksesta"]
["409","Ensimmäinen työntekijä aloitti työskentelyn tällä työmaalla"]
["009","Toistuvan osatietoryhmän loppumerkki"]

{"sheet":"Data sets","index":2,"n_rows":7,"n_cols":27,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Recurring data set, 0–n"]
[]
["Enter the details and go back to the main page by clicking the Go to form button."]
[]
["Role of reported party","Type of reported party","Reported party’s Finnish Business ID/personal ID","Reported party's foreign TIN\n(max. 3 identifiers separated by semicolons)\n","Reported party’s name: full name of legal person or last name of natural person","Reported natural person’s first name","Reported natural person’s middle name","Reported natural person’s date of birth","Reported natural person’s place of birth","Reported party’s address: street name","Reported party’s address: house number","Reported party’s address: entrance","Reported party’s address: door number","Reported party’s address: P.O. Box","Reported party’s address: postal code","Reported party’s address: post office","Reported party’s address: country","Reported party’s country of tax residence","Reported party’s e-mail address","Name of the taxpayer who is the other party in the associated relationship","Date when the marketable arrangement was implemented for the taxpayer","Reported party’s TIN (identifiers 112 and 113) is unknown","Reported person’s first name (identifier 115) is unknown","Reported person’s date of birth (identifier 117) is unknown","Reported person’s place of birth (identifier 118) is unknown","Reported party’s place of tax residence (identifier 127) is unknown","Date when the marketable arrangement was implemented for the taxpayer (identifier 130) is unknownn"]
["P/V","P/V","V","V","P/V","P/V","V","P/V","P/V","V","V","V","V","V","V","P/V","P/V","P/V","V","P/V","P/V","V","V","V","V","V","V"]
[110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,161,163,164,165,166,167]

{"sheet":"Data 146","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Description of arrangement (summary)"]
[]
["Enter the details in the appropriate grey textbox and go back to the main page by clicking Go to form."]
["Note: You cannot use line breaks."]

{"sheet":"Data 147","index":4,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Regulations on which the arrangement is based"]
[]
["Enter the details in the appropriate grey textbox and go back to the main page by clicking Go to form."]
["Note: You cannot use line breaks."]

{"sheet":"Recurring 148","index":5,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Recurring data 148 EU Member States"]
[]
["Enter the details and go back to the main page by clicking Go to form."]
[]
["EU Member States that the arrangement concerns"]
["P"]
[148]

{"sheet":"Recurring 149","index":6,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Recurring data 149 Hallmarks"]
[]
["Enter the details and go back to the main page by clicking Go to form."]
[]
["Hallmarks"]
["P"]
[149]

{"sheet":"Data 150","index":7,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["DAC6D1 other information"]
[]
["Enter the details in the appropriate grey textbox and go back to the main page by clicking Go to form."]
["Note: You cannot use line breaks."]

{"sheet":"Arvomäärittelyt","index":8,"n_rows":129,"n_cols":21,"rows_kept":129,"cut":false,"hidden":true,"merged":[]}
[null,"VSDAC6DC",null,null,null,null,null,null,null,"Kuluva","vuosi","kk","pp",null,null,"Aika","hh","mm","ss"]
[null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-11-02T07:22:54.100"},{"$f":"YEAR(J2)","v":2022},{"$f":"TEXT((J2),\"kk\")","v":"11"},{"$f":"TEXT((J2),\"pp\")","v":"02"},{"$f":"M2&L2&K2","v":"02112022"},null,{"$f":"NOW()","v":"2022-11-02T07:22:54.100"},{"$f":"TEXT(P2,\"tt\")","v":"07"},{"$f":"TEXT(P2,\"mm\")","v":"22"},{"$f":"TEXT(P2,\"ss\")","v":"54"},null,{"$f":"Q2&R2&S2","v":"072254"}]
[null,"061/Kyseessä on korvaava ilmoitus"]
[null,"1"]
[]
[null,"062/Järjestely on markkinakelpoinen"]
[null,"1"]
[]
[null,"063/Markkinakelpoisen järjestelyn ensimmäinen ilmoitus"]
[null,"1"]
[]
[null,"064/Ilmoitus sisältää sisäpiiritietoa"]
[null,"1"]
[]
[null,"011/Ilmoittajan tyyppi"]
[null,"1"]
[null,"2"]
[]
[null,"030/Ilmoittajan rooli"]
[null,"1"]
[null,"2"]
[]
[null,"031/Ilmoittajan yhteys ilmoitusvaltioon"]
[null,"1"]
[null,"2"]
[null,"3"]
[null,"4"]
[null,"5"]
[null,"6"]
[]
[null,"032/Ilmoittaja on velvollinen raportoimaan useammassa EU-jäsenvaltiossa"]
[null,"1"]
[]
[null,"033/Palvelun tarjoajan asema"]
[null,"1"]
[null,"2"]
[]
[null,"034/Palvelun tarjoaja on vapautettu tiedonantovel-\nvollisuudesta salassapitovelvollisuuden vuoksi"]
[null,"1"]
[]
[null,"035/Verovelvollisen ilmoituksen peruste"]
[null,"1"]
[null,"2"]
[null,"3"]
[]
[null,"110/Ilmoitettavan osapuolen rooli"]
[null,"1"]
[null,"2"]
[null,"4"]
[null,"5"]
[]
[]
[null,"111/Ilmoitettavan osapuolen tyyppi"]
[null,"1"]
[null,"2"]
[]
[null,"143/Pääasiallisen hyödyn testi täyttyy"]
[null,"1"]
[]
[null,"144/Ilmoitusvelvollisuuden peruste"]
[null,"1"]
[null,"2"]
[null,"3"]
[null,"4"]
[]
[null,"027/Ilmoittajan asuinvaltio verotuksessa"]
[null,"148/EU-jäsenvaltiot, joita järjestely koskee"]
[null,"AT"]
[null,"BE"]
[null,"BG"]
[null,"CY"]
[null,"CZ"]
[null,"DE"]
[null,"DK"]
[null,"EE"]
[null,"EL"]
[null,"ES"]
[null,"FI"]
[null,"FR"]
[null,"GB"]
[null,"HR"]
[null,"HU"]
[null,"IE"]
[null,"IT"]
[null,"LT"]
[null,"LU"]
[null,"LV"]
[null,"MT"]
[null,"NL"]
[null,"PL"]
[null,"PT"]
[null,"RO"]
[null,"SE"]
[null,"SI"]
[null,"SK"]
[]
[null,"149/Tunnusmerkit"]
[null,"DAC6A1"]
[null,"DAC6A2a"]
[null,"DAC6A2b"]
[null,"DAC6A3"]
[null,"DAC6B1"]
[null,"DAC6B2"]
[null,"DAC6B3"]
[null,"DAC6C1a"]
[null,"DAC6C1bi"]
[null,"DAC6C1bii"]
[null,"DAC6C1c"]
[null,"DAC6C1d"]
[null,"DAC6C2"]
[null,"DAC6C3"]
[null,"DAC6C4"]
[null,"DAC6D1a"]
[null,"DAC6D1b"]
[null,"DAC6D1c"]
[null,"DAC6D1d"]
[null,"DAC6D1e"]
[null,"DAC6D1f"]
[null,"DAC6D1Other"]
[null,"DAC6D2"]
[null,"DAC6E1"]
[null,"DAC6E2"]
[null,"DAC6E3"]
[]
[null,"999/Tietueen loppumerkki"]
[null,"1"]
[]
[null,"Onko arvo voimassa"]
[null,"1"]