{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["User Guide","Beneficial Owner","Representative","Chain Of Custody","Acquisitions And Disposals","Fields","Fields Content"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":21,"comments":0,"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":"User Guide","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["User Guide - Tax Document Requests template"]
[]
["Filling data in the template"]
[]
[null,"Each individual sheet within the template is designed to allow data bulk input directly into the request screen tables by file upload."]
[null,"Please fill in mandatory fields before exporting the files."]
[null,"A more exhaustive help on data format is provided in the \"Fields\" sheet."]
[]
[]
[]
[]
["Exporting data to a CSV file"]
[]
[null,"When your requests are ready, click on the \"Create CSV file\" button above the data table."]
[]
[]
[]
[]
[null,"Your requests will be exported into a CSV file. A message will then confirm the export."]
[null,"Examples of file name: Beneficial_Owner_03232026_093709.csv or Representative_03232026_093922.csv or Chain_Of_Custody_03232026_093929.csv or Acquisitions_And_Disposals_03232026_093935.csv"]
[null,"The timestamp will allow a unique filename for each data export and will facilitate the archiving of your data files."]

{"sheet":"Beneficial Owner","index":1,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,8,2,13],[2,21,2,23]]}
["Tax Document Requests - Beneficial Owner table"]
[null,"Type","Name Prefix","Title","First Name","Last Name","Name Suffix","Name","Building Number","Building Number Additional","Street Name","City","Post Code","Country","Date Of Birth","Date Of Incorporation","Legal Form","German Identification Number","German Economic Identification Number","German Tax Number","European Unique Identifier","Foreign TIN","Identification Country","Fund ID"]
[null,null,"Natural Person","Natural Person","Natural Person","Natural Person","Natural Person","Legal Person",null,null,null,null,null,null,"Natural Person","Legal Person","Legal Person","Natural Person","Legal Person","Legal Person","Legal Person"]

{"sheet":"Representative","index":2,"n_rows":3,"n_cols":21,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,7,2,12],[2,19,2,20]]}
["Tax Document Request - Representative table"]
[null,"Name Prefix","Title","First Name","Last Name","Name Suffix","Name","Building Number","Building Number Additional","Street Name","City","Post Code","Country","Date Of Birth","German Identification Number","German Economic Identification Number","German Tax Number","BZSt Tax Number","European Unique Identifier","Foreign TIN","Identification Country"]
[null,"Natural Person","Natural Person","Natural Person","Natural Person","Natural Person","Legal Person",null,null,null,null,null,null,"Natural Person","Natural Person","Legal Person","Legal Person","Legal Person","Legal Person"]

{"sheet":"Chain Of Custody","index":3,"n_rows":2,"n_cols":18,"rows_kept":2,"cut":false,"hidden":false,"merged":[[2,1,2,17]]}
["Tax Document Request - Chain Of Custody table"]
[null,"Name","Building Number","Building Number Additional","Street Name","Additional Details","City","Post Code","Country","Legal Form","German Economic Identification Number","German Tax Number","European Unique Identifier","Foreign TIN","LEI","Identification Country","Account Number","Account Type"]

{"sheet":"Acquisitions And Disposals","index":4,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
["Tax Document Request - Acquisitions And Disposals table"]
[null,"Trade Type","Client Transaction ID","Trade Quantity","Trade Date","Transaction Type","Contractual Settlement Date","Actual Settlement Date"]

{"sheet":"Fields","index":5,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":false,"merged":[[45,0,61,0],[62,0,68,0],[2,0,24,0],[25,0,44,0]]}
[null,"Specifications"]
[null,"Position in CSV","Field name","Field format","Field status ","Additional information"]
["Beneficial Owner (Max 10 occurrences)","1","Type",null,"Mandatory"]
[null,"2","Name Prefix (Natural Person)",null,"Optional"]
[null,"3","Title (Natural Person)","Max 30 alphanumeric","Optional"]
[null,"4","First Name (Natural Person)","Max 72 alphanumeric","Conditional","Mandatory if \"Beneficial Owner\" is Natural Person"]
[null,"5","Last Name (Natural Person)","Max 72 alphanumeric","Conditional","Mandatory if \"Beneficial Owner\" is Natural Person"]
[null,"6","Name Suffix (Natural Person)",null,"Optional"]
[null,"7","Name (Legal Person)","Max 120 alphanumeric","Conditional","Mandatory if \"Beneficial Owner\" is a Legal Person"]
[null,"8","Building Number","Max 5 digits","Optional"]
[null,"9","Building Number Additional","Max 20 alphanumeric","Optional"]
[null,"10","Street Name","Max 72 alphanumeric","Mandatory"]
[null,"11","City","Max 72 alphanumeric","Mandatory"]
[null,"12","Post Code","Domestic Post Code: 5 digits\nForeign Post Code: max 12 digits","Mandatory"]
[null,"13","Country","ISO Alpha-2 country code","Mandatory"]
[null,"14","Date Of Birth (Natural Person)","DD/MM/YYYY","Conditional","Mandatory if \"Beneficial Owner\" is Natural Person"]
[null,"15","Date Of Incorporation (Legal Person)","DD/MM/YYYY","Conditional"]
[null,"16","Legal Form (Legal Person)","60 alphanumeric","Conditional"]
[null,"17","German Identification Number (Natural Person)","11 digits","Conditional","IdNr"]
[null,"18","German Economic Identification Number (Legal Person)","16 alphanumeric","Conditional","W-IdNr"]
[null,"19","German Tax Number (Legal Person)","13 digits","Conditional","StNr"]
[null,"20","European Unique Identifier (Legal Person)","200 digits","Conditional","EUID"]
[null,"21","Foreign TIN","Max 35 alphanumeric","Conditional"]
[null,"22","Identification Country","ISO Alpha-2 country code","Conditional","Mandatory for non-German \"Beneficial Owner\""]
[null,"23","Fund ID","Max 16 digits","Optional","Ordnungsnummer, to be provided for the first BO, only for reduced rate"]
["Representative (Max 5 occurrences)","1","Name Prefix (Natural Person)",null,"Optional"]
[null,"2","Title (Natural Person)","Max 30 alphanumeric","Optional"]
[null,"3","First Name (Natural Person)","Max 72 alphanumeric","Conditional","Mandatory if \"Representative\" is a Natural Person"]
[null,"4","Last Name (Natural Person)","Max 72 alphanumeric","Conditional","Mandatory if \"Representative\" is a Natural Person"]
[null,"5","Name Suffix (Natural Person)",null,"Optional"]
[null,"6","Name (Legal Person)","Max 120 alphanumeric","Conditional","Mandatory if \"Representative\" is a Legal Person"]
[null,"7","Building Number","Max 5 digits","Optional"]
[null,"8","Building Number Additional","Max 20 alphanumeric","Optional"]
[null,"9","Street Name","Max 72 alphanumeric","Optional"]
[null,"10","City","Max 72 alphanumeric","Mandatory"]
[null,"11","Post Code","Domestic Post Code: 5 digits\nForeign Post Code: max 12 digits","Mandatory"]
[null,"12","Country","ISO Alpha-2 country code","Mandatory"]
[null,"13","Date Of Birth (Natural Person)","DD/MM/YYYY","Conditional","Mandatory if \"Beneficial Owner\" is a Natural Person"]
[null,"14","German Identification Number (Natural Person)","11 digits","Conditional","IdNr, one of the available IDs must be provided"]
[null,"15","German Economic Identification Number (Legal Person)","16 alphanumeric","Conditional","W-IdNr, one of the available IDs must be provided"]
[null,"16","German Tax Number (Legal Person)","13 digits","Conditional","StNr, one of the available IDs must be provided"]
[null,"17","BZSt Tax Number (Legal Person)","13 digits","Conditional","BZSt StNr, one of the available IDs must be provided"]
[null,"18","European Unique Identifier (Legal Person)","200 digits","Conditional","EUID, one of the available IDs must be provided"]
[null,"19","Foreign TIN","Max 35 alphanumeric","Conditional","One of the available IDs must be provided"]
[null,"20","Identification Country","ISO Alpha-2 country code","Conditional","Mandatory for non-German \"Representative\""]
["Chain Of Custody (Max 25 Occurrences)","1","Name","Max 120 alphanumeric","Mandatory"]
[null,"2","Building Number","Max 5 digits","Optional"]
[null,"3","Building Number Additional","Max 20 alphanumeric","Optional"]
[null,"4","Additional Details",null,"Optional"]
[null,"5","Street Name","Max 72 alphanumeric","Optional"]
[null,"6","City","Max 72 alphanumeric","Mandatory"]
[null,"7","Post Code","Domestic Post Code: 5 digits\nForeign Post Code: max 12 digits","Optional"]
[null,"8","Country","ISO Alpha-2 country code","Mandatory"]
[null,"9","Legal Form",null,"Mandatory"]
[null,"10","German Economic Identification Number","13 digits","Conditional","W-IdNr, one of the available IDs must be provided"]
[null,"11","German Tax Number","13 digits","Conditional","StNr, one of the available IDs must be provided"]
[null,"12","European Unique Identifier","200 digits","Conditional","BZSt StNr, one of the available IDs must be provided"]
[null,"13","Foreign TIN","Max 35 alphanumeric","Conditional","EUID, one of the available IDs must be provided"]
[null,"14","Legal Entity Identifier","20 alphanumeric","Conditional","LEI, one of the available IDs must be provided"]
[null,"15","Identification Country","ISO Alpha-2 country code","Mandatory"]
[null,"16","Account Number",null,"Mandatory"]
[null,"17","Account Type",null,"Mandatory"]
["Acquisitions And Disposals (Max 1000 Acquisitions and 1000 Disposals)","1","Trade Type",null,"Mandatory"]
[null,"2","Client Transaction ID",null,"Optional"]
[null,"3","Trade Quantity",null,"Mandatory"]
[null,"4","Trade Date","DD/MM/YYYY","Mandatory"]
[null,"5","Transaction Type",null,"Mandatory"]
[null,"6","Contractual Settlement Date","DD/MM/YYYY","Mandatory"]
[null,"7","Actual Settlement Date","DD/MM/YYYY","Mandatory"]

{"sheet":"Fields Content","index":6,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,3,0],[4,0,10,0],[13,2,19,2],[13,1,19,1],[11,0,19,0],[2,1,3,1],[2,2,3,2],[4,1,10,1],[4,2,10,2],[11,1,12,1],[11,2,12,2]]}
[null,"Specifications"]
[null,"Position in CSV","Field name","Field values","Field decode"]
["Beneficial Owner","1","Type","Account Holder"]
[null,null,null,"Creditor"]
["Chain Of Custody","17","Account Type","Own Asset Account"]
[null,null,null,"Omnibus Account"]
[null,null,null,"Segregated Account"]
[null,null,null,"Segregated Sub-account"]
[null,null,null,"Omnibus not at Clearstream"]
[null,null,null,"Segregated not at Clearstream"]
[null,null,null,"Other"]
["Acquisitions And Disposals","1","Trade Type","Acquisition"]
[null,null,null,"Disposal"]
[null,"5","Transaction Type","Purchase"]
[null,null,null,"Sale"]
[null,null,null,"Transfer"]
[null,null,null,"Transfer Due To Loan"]
[null,null,null,"Loan Return"]
[null,null,null,"Transfer Due To Repo Transaction"]
[null,null,null,"Retransfer Due To Repo Transaction"]