{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["How to fill in the Form","Foglio1","Foglio2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"How to fill in the Form","index":0,"n_rows":121,"n_cols":5,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["Scenario","Business case description","Mandatory Sections","Optional Sections","Notes"]
["A","First Registration in TARGET-Banca d'Italia","1. REGISTRATION INFORMATION","3. CONNECTIVITY TO ESMIG1","1only in case of A2A connection"]
["A","First Registration in TARGET-Banca d'Italia","2. PARTY REFERENCE DATA","  - Enter SWIFT/SIA TANSL","2refer also to the related Scenarios C, D, E, F"]
["A","First Registration in TARGET-Banca d'Italia","3. CONNECTIVITY TO ESMIG","    - T2BDM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF","3only for authorising a CB different form Banca d'Italia to debit an MCA"]
["A","First Registration in TARGET-Banca d'Italia","  - SELECT YOUR ESMIG CONNECTIVITY MODE","    - T2DWH.SWIFT/SIA.FILESNF"]
["A","First Registration in TARGET-Banca d'Italia","  - Enter SWIFT/SIA TANSL1","4. PARTY ROLES"]
["A","First Registration in TARGET-Banca d'Italia","    - T2CLM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF","  - Assign Data Warehouse Roles"]
["A","First Registration in TARGET-Banca d'Italia","    - T2CRDM.SWIT/SIA.FILESNF/MSGRT/MSGSNF","5. CASH ACCOUNTS2"]
["A","First Registration in TARGET-Banca d'Italia","4. PARTY ROLES","  - MAIN CASH ACCOUNTS"]
[null,null,"  - Assign Admin and Access Roles","    - Enter 2°/3° MCA Data"]
["A","First Registration in TARGET-Banca d'Italia","  - Assign CLM Roles","  - MARGINAL LENDING ACCOUNT "]
["A","First Registration in TARGET-Banca d'Italia","  - Assign CRDM Roles","  - OVERNIGHT DEPOSIT ACCOUNT"]
["A","First Registration in TARGET-Banca d'Italia","5. CASH ACCOUNTS","  - RTGS DCAs"]
["A","First Registration in TARGET-Banca d'Italia","  - MAIN CASH ACCOUNTS","  - RTGS SUB-ACCOUNTS"]
["A","First Registration in TARGET-Banca d'Italia","    - Enter Default MCA Data","  - TIPS DCAs"]
["A","First Registration in TARGET-Banca d'Italia","10. ADMINISTRATOR USERS","  - T2S DCAS"]
["A","First Registration in TARGET-Banca d'Italia",null,"7. DIRECT DEBIT MANDATES3"]
["A","First Registration in TARGET-Banca d'Italia",null,"8. GROUPS"]
["A","First Registration in TARGET-Banca d'Italia",null,"  - BANKING GROUP"]
["A","First Registration in TARGET-Banca d'Italia",null,"  - LIQUIDITY TRANSFER GROUP"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","1. REGISTRATION INFORMATION","4. PARTY ROLES","1only in case of A2A connection or if the co-manager needs to receive the camt.054 of the co-managed MCA "]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","2. PARTY REFERENCE DATA","  - Assign Admin and Access Roles","2only in case of A2A connection"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","3. CONNECTIVITY TO ESMIG","  - Assign CLM Roles","3only for authorising a CB different form Banca d'Italia to debit an MCA"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","  - SELECT YOUR ESMIG CONNECTIVITY MODE","  - Assign CRDM Roles"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","  - Enter SWIFT/SIA TANSL1","  - Assign Data Warehouse Roles"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","    - T2CLM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF1","5. CASH ACCOUNTS"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","    - T2CRDM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF2","  - MAIN CASH ACCOUNTS"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","5. CASH ACCOUNTS","    - Enter 2°/3° MCA Data"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","  - MAIN CASH ACCOUNTS","7. DIRECT DEBIT MANDATES3"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only","    - Enter Default MCA Data","8. GROUPS"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only",null,"  - BANKING GROUP"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only",null,"  - LIQUIDITY TRANSFER GROUP"]
["B","First Registration in TARGET-Banca d'Italia with co-managed MCA(s) only",null,"10. ADMINISTRATOR USERS"]
["C","Opening of OD/ML Account","1. REGISTRATION INFORMATION"]
["C","Opening of OD/ML Account","5. CASH ACCOUNTS"]
["C","Opening of OD/ML Account","  - OD/ML ACCOUNT"]
["D","First opening of RTGS DCA(s)","1. REGISTRATION INFORMATION","3. CONNECTIVITY TO ESMIG1","1only in case of A2A connection"]
["D","First opening of RTGS DCA(s)","3. CONNECTIVITY TO ESMIG1","  - Enter SWIFT/SIA TANSL","2required to allow Banca d'Italia to debit the RTGS DCA(s) "]
["D","First opening of RTGS DCA(s)","  - SELECT YOUR ESMIG CONNECTIVITY MODE","    - T2BILL.SWIFT/SIA.FILESNF/MSGRT/MSGSNF","3see Scenario K for registering one or more Addressable BICs/Multi-addressees"]
["D","First opening of RTGS DCA(s)","  - Enter SWIFT/SIA TANSL","    - T2BDM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF"]
["D","First opening of RTGS DCA(s)","    - T2RTGS.SWIFT/SIA.FILESNF/MSGRT/MSGSNF","    - T2DWH.SWIFT/SIA.FILESNF"]
["D","First opening of RTGS DCA(s)","4. PARTY ROLES","4. PARTY ROLES"]
["D","First opening of RTGS DCA(s)","  - Assign RTGS Roles","  - Assign Billing Roles"]
["D","First opening of RTGS DCA(s)","5. CASH ACCOUNTS","  - Assign Data Warehouse Roles"]
["D","First opening of RTGS DCA(s)","  - RTGS DCAs","6. AUTHORISED ACCOUNT USERS3"]
["D","First opening of RTGS DCA(s)","7. DIRECT DEBIT MANDATES2","8. GROUPS"]
["D","First opening of RTGS DCA(s)","11. INVOICE CONFIGURATION","  - BILLING GROUP"]
["D","First opening of RTGS DCA(s)",null,"  - LIQUIDITY TRANSFER GROUP"]
["D","First opening of RTGS DCA(s)",null,"  - SBAG"]
["E","First opening of TIPS DCA(s)","1. REGISTRATION INFORMATION","3. CONNECTIVITY TO ESMIG","1enter the technical address for receiving the TIPS Directory"]
["E","First opening of TIPS DCA(s)","3. CONNECTIVITY TO ESMIG","  - Enter SWIFT/SIA TANSL","2enter the technical address(es) for sending/receiving instant payments"]
["E","First opening of TIPS DCA(s)","  - Enter SWIFT/SIA TANSL","    - TIPSBILL.SWIFT/SIA.FILESNF/MSGRT/MSGSNF","3enter the technical address for receiving notifications (camt.054)"]
["E","First opening of TIPS DCA(s)","    - TIPSCRDM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF1","4. PARTY ROLES","4enter the BIC used by the TIPS DCA owner for sending/reciving instant payements for each TIPS DCA"]
["E","First opening of TIPS DCA(s)","    - SWIFT/SIA2","  - Assign Billing Roles","5enter the TIPS DCA number as reported in section 5 "]
["E","First opening of TIPS DCA(s)","    - SWIFT/SIA.NOTIF3","6. AUTHORISED ACCOUNT USERS9","6select TIPS AAU/Reachable Party"]
["E","First opening of TIPS DCA(s)","4. PARTY ROLES",null,"7enter the technical address for sending/receiving instant payments as reported in section 3"]
["E","First opening of TIPS DCA(s)","  - Assign TIPS Roles",null,"8enter the Login Name of the A2A user to be granted with the role \"AH Instant Payment Manager 2E\""]
["E","First opening of TIPS DCA(s)","5. CASH ACCOUNTS",null,"9see Scenario L for registering one or more Reachable Parties"]
["E","First opening of TIPS DCA(s)","  - TIPS DCAs"]
["E","First opening of TIPS DCA(s)","6. AUTHORISED ACCOUNT USERS"]
["E","First opening of TIPS DCA(s)","  - Authorised Account User BIC4"]
["E","First opening of TIPS DCA(s)","  - Cash Account Number for AAU5"]
["E","First opening of TIPS DCA(s)","  - Type6"]
["E","First opening of TIPS DCA(s)","  - Inbound/Outbound DN-BIC Routing7"]
["E","First opening of TIPS DCA(s)","  - Login Name of the A2A8"]
["E","First opening of TIPS DCA(s)","11. INVOICE CONFIGURATION"]
["F","First opening of T2S DCA(s)","1. REGISTRATION INFORMATION","3. CONNECTIVITY TO ESMIG","1only in case of A2A connection"]
["F","First opening of T2S DCA(s)","3. CONNECTIVITY TO ESMIG1","  - Enter SWIFT/SIA TANSL","2see Scenario M for registering one or more BIC in the Primary CMB"]
["F","First opening of T2S DCA(s)","  - Enter SWIFT/SIA TANSL","    - T2SBDM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF"]
["F","First opening of T2S DCA(s)","    - SWIFT/SIA.FILERT/FILESNF/MSGRT/MSGSNF","    - T2SBILL.SWIFT/SIA.FILESNF/MSGRT/MSGSNF"]
["F","First opening of T2S DCA(s)","4. PARTY ROLES","   - T2SCRDM.SWIFT/SIA.FILESNF/MSGRT/MSGSNF"]
["F","First opening of T2S DCA(s)","  - Assign T2S Roles","4. PARTY ROLES"]
["F","First opening of T2S DCA(s)","5. CASH ACCOUNTS","  - Assign Billing Roles"]
["F","First opening of T2S DCA(s)","  - T2S DCAs","  - Assign Data Warehouse Roles"]
["F","First opening of T2S DCA(s)","6. AUTHORISED ACCOUNT USERS2"]
["F","First opening of T2S DCA(s)","11. INVOICE CONFIGURATION"]
["G","Opening of further MCAs","1. REGISTRATION INFORMATION","7. DIRECT DEBIT MANDATES1","1only for authorising a CB different form Banca d'Italia to debit an MCA"]
["G","Opening of further MCAs","5. CASH ACCOUNTS","8. GROUPS"]
["G","Opening of further MCAs","  - MAIN CASH ACCOUNTS","  - LIQUIDITY TRANSFER GROUP"]
["G","Opening of further MCAs","    - Enter 2°/3° MCA Data"]
["H","Opening of further RTGS DCAs1 ","1. REGISTRATION INFORMATION","6. AUTHORISED ACCOUNT USERS2","1participants already owner of at least one RTGS DCA"]
["H","Opening of further RTGS DCAs1 ","5. CASH ACCOUNTS","7. DIRECT DEBIT MANDATES","2for registering one or more Addressable BICs/Multi-addressees"]
["H","Opening of further RTGS DCAs1 ","  - RTGS DCA","8. GROUPS"]
["H","Opening of further RTGS DCAs1 ",null,"  - LIQUIDITY TRANSFER GROUP"]
["I","Opening of further TIPS DCAs1 ","1. REGISTRATION INFORMATION","6. AUTHORISED ACCOUNT USERS7","1participants already owner of at least one TIPS DCA"]
["I","Opening of further TIPS DCAs1 ","5. CASH ACCOUNTS",null,"2only in case a new technical address will be used for sending/receiving the instant payments"]
["I","Opening of further TIPS DCAs1 ","  - TIPS DCAs",null,"3enter the BIC used by the TIPS DCA owner for sending/reciving instant payments for each TIPS DCA"]
["I","Opening of further TIPS DCAs1 ","3. CONNECTIVITY TO ESMIG2",null,"4enter the TIPS DCA number as reported in section 5 "]
["I","Opening of further TIPS DCAs1 ","  - Enter SWIFT/SIA TANSL",null,"5select TIPS AAU/Reachable Party"]
["I","Opening of further TIPS DCAs1 ","    - SWIFT/SIA",null,"6enter the technical address used for sending/receiving instant payments (must be one of the Party TA, if not must be reported in section 3)"]
["I","Opening of further TIPS DCAs1 ","6. AUTHORISED ACCOUNT USERS",null,"7enter the Login Name of the A2A user granted with the role \"AH Instant Payment Manager 2E\""]
[null,null,"  - Authorised Account User BIC3",null,"8refer to Scenario L for registering one or more Reachable Parties"]
[null,null,"  - Cash Account Number for AAU4"]
[null,null,"  - Type5"]
["I","Opening of further TIPS DCAs1 ","  - Inbound/Outbound DN-BIC Routing6"]
["I","Opening of further TIPS DCAs1 ","  - Login Name of the A2A7"]
["I","Opening of further TIPS DCAs1 ","11. INVOICE CONFIGURATION"]
["J","Opening of further T2S DCAs1 ","1. REGISTRATION INFORMATION",null,"1participants already owner of at least one T2S DCA"]
["J","Opening of further T2S DCAs1 ","5. CASH ACCOUNTS",null,"2see Scenario M for registering one or more BIC in the Primary CMB"]
["J","Opening of further T2S DCAs1 ","  - T2S DCAs"]
["J","Opening of further T2S DCAs1 ","6. AUTHORISED ACCOUNT USERS2"]
["K","Registering Addressable BIC(s)/Multi-addressee(s)","1. REGISTRATION INFORMATION",null,"1enter the Addressable BIC/Multi-addressee BIC"]
["K",null,"6. AUTHORISED ACCOUNT USERS",null,"2enter the RTGS DCA number (RITEUR...)"]
["K",null,"  - Authorised Account User BIC1",null,"3select the type of Addressable BIC/Multi-addressee"]
["K",null,"  - Cash Account Number for AAU2"]
["K",null,"  - Type3"]
["L","Registering TIPS Reachable Parties","1. REGISTRATION INFORMATION",null,"1only in case a new technical address (i.e. not yet included in the list of Party Technical Addresses) will be used for sending/receiving the Reachable Party's instant payments"]
["L","Registering TIPS Reachable Parties","3. CONNECTIVITY TO ESMIG1",null,"2enter the BIC used by the Reachable Party for sending/reciving instant payments"]
["L","Registering TIPS Reachable Parties","  - Enter SWIFT/SIA TANSL",null,"3enter the TIPS DCA number (IITEUR...)"]
["L","Registering TIPS Reachable Parties","    - SWIFT/SIA",null,"4select TIPS AAU/Reachable Party"]
["L","Registering TIPS Reachable Parties","6. AUTHORISED ACCOUNT USERS",null,"5enter the technical address used for sending/receiving the Reachable Party's instant payments"]
["L","Registering TIPS Reachable Parties","  - Authorised Account User BIC2",null,"6enter the Login Name of the A2A user granted with the role \"AH Instant Payment Manager 2E\""]
["L","Registering TIPS Reachable Parties","  - Cash Account Number for AAU3"]
["L","Registering TIPS Reachable Parties","  - Type4"]
["L","Registering TIPS Reachable Parties","  - Inbound/Outbound DN-BIC Routing5"]
["L","Registering TIPS Reachable Parties","  - Login Name of the A2A6"]
["M","Registering BIC(s) in the Primary CMB","1. REGISTRATION INFORMATION",null,"1enter the BIC of the Party registered by the CSD owning the securities accounts to be linked to the T2S DCA "]
["M","Registering BIC(s) in the Primary CMB","6. AUTHORISED ACCOUNT USERS",null,"2enter the T2S DCA number (CITEUR...)"]
["M","Registering BIC(s) in the Primary CMB","  - Authorised Account User BIC1",null,"3select T2S Primary CMB Authorised BIC"]
["M","Registering BIC(s) in the Primary CMB","  - Cash Account Number for AAU2"]
["M","Registering BIC(s) in the Primary CMB","  - Type3"]

{"sheet":"Foglio1","index":1,"n_rows":790,"n_cols":4,"rows_kept":790,"cut":false,"hidden":false,"merged":[[224,0,225,0],[226,0,227,0],[228,0,229,0],[230,0,230,1],[214,0,215,0],[216,0,217,0],[218,0,219,0],[220,0,221,0],[222,0,223,0],[189,0,190,0],[191,0,191,1],[204,0,204,1],[211,0,211,1],[212,0,213,0],[172,0,181,0],[182,0,182,1],[183,0,184,0],[185,0,186,0],[187,0,188,0],[163,0,163,1],[164,0,165,0],[166,0,167,0],[168,0,169,0],[170,0,170,1],[141,0,141,1],[156,0,156,1],[157,0,158,0],[159,0,160,0],[161,0,162,0],[102,0,102,1],[115,0,115,1],[122,0,122,1],[139,0,140,0],[137,0,138,0],[135,0,136,0],[133,0,134,0],[131,0,132,0],[129,0,130,0],[127,0,128,0],[125,0,126,0],[123,0,124,0],[81,0,81,1],[93,0,93,1],[100,0,101,0],[98,0,99,0],[96,0,97,0],[94,0,95,0],[72,0,73,0],[75,0,76,0],[77,0,78,0],[79,0,80,0],[67,0,67,1],[74,0,74,1],[609,0,609,1],[766,0,766,1],[750,0,750,1],[615,0,615,1],[625,0,625,1],[635,0,635,1],[677,0,677,1],[719,0,719,1],[582,0,582,1],[474,0,474,1],[490,0,490,1],[506,0,506,1],[365,0,365,1],[0,0,0,1],[1,0,1,1],[9,0,9,1],[15,0,15,1],[26,0,26,1],[316,0,316,1],[442,0,442,1],[49,0,49,1],[311,0,311,1],[43,0,43,1],[241,0,241,1],[419,0,419,1],[403,0,403,1],[347,0,347,1],[356,0,356,1],[59,0,59,1],[55,0,55,1],[305,0,305,1],[83,0,92,0],[68,0,69,0],[70,0,71,0]]}
["TARGET Registration Form - Banca d'Italia"]
["1. REGISTRATION INFORMATION",null,"FORM CHECK:",{"$f":"IF(COUNTBLANK(D3:D784)=772,\"The form is correct\",\"Warning: There are errors or missing fields. Check the messages in this column\")","v":"Warning: There are errors or missing fields. Check the messages in this column"}]
["Type of request",null,null,{"$f":"IF(ISBLANK(B3),\"Mandatory field\",\"\")","v":"Mandatory field"}]
["Party BIC",null,null,{"$f":"IF(ISBLANK(B4),\"Mandatory field\",IF(LEN(B4)<>11,\"Error: enter a 11-digit BIC\",\"\"))","v":"Mandatory field"}]
["Form submission date",null,null,{"$f":"IF(ISBLANK(B5),\"Mandatory field\",\"\")","v":"Mandatory field"}]
["Form reference (optional free text)"]
["Requested activation date in TARGET (business day)",null,null,{"$f":"IF(ISBLANK(B7),\"Mandatory field\",\nIF(NETWORKDAYS(B5,B7)<10,\"Error: activation date must be at least 10 business day after the submission date\",\"\")\n)","v":"Mandatory field"}]
["Environment",null,null,{"$f":"IF(ISBLANK(B8),\"Mandatory field\",\"\")","v":"Mandatory field"}]
[]
["2. PARTY REFERENCE DATA",null,null,{"$f":"IF(COUNTBLANK(D11:D49)=39,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["MAIN INFORMATION"]
["Party Long Name",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B17),\"Mandatory field\",IF(LEN($B17)>350,CONCATENATE(\"ERROR: The maximum length is \",\"350\",\" characters\"),\"\")),\"\")","v":""}]
["Party Short name",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B18),\"Mandatory field\",IF(LEN($B18)>35,CONCATENATE(\"ERROR: The maximum length is \",\"35\",\" characters\"),\"\")),\"\")","v":""}]
["Party type",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",ISBLANK(B19)),\"Mandatory field\",\"\")","v":""}]
["Street",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B20),\"Mandatory field\",IF(LEN($B20)>70,CONCATENATE(\"ERROR: The maximum length is \",\"70\",\" characters\"),\"\")),\"\")","v":""}]
["House Number",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B21),\"Mandatory field\",IF(LEN($B21)>16,CONCATENATE(\"ERROR: The maximum length is \",\"16\",\" characters\"),\"\")),\"\")","v":""}]
["Postal code",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B22),\"Mandatory field\",IF(LEN($B22)>35,CONCATENATE(\"ERROR: The maximum length is \",\"35\",\" characters\"),\"\")),\"\")","v":""}]
["City",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B23),\"Mandatory field\",IF(LEN($B23)>35,CONCATENATE(\"ERROR: The maximum length is \",\"35\",\" characters\"),\"\")),\"\")","v":""}]
["State Or Province",null,null,{"$f":"IF(LEN($B24)>35,CONCATENATE(\"ERROR: The maximum length is \",\"35\",\" characters\"),\"\")","v":""}]
["Country code",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B25),\"Mandatory field\",IF(LEN($B25)>2,CONCATENATE(\"ERROR: The maximum length is \",\"2\",\" characters\"),\"\")),\"\")","v":""}]
["Legal Entity Identifier",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B26),\"Mandatory field\",IF(LEN($B26)<20,\"Error: LEI code must be 20 characters long\",\"\")),\"\")","v":""}]
["PARTY CONTACT INFORMATION"]
["Party contact name",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B28),\"Mandatory field. It is preferable to enter the contact of a unit or structure\",\"\"),\"\")","v":""}]
["Party contact position",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B29),\"Mandatory field\",\"\"),\"\")","v":""}]
["Office Telephone Number",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B30),\"Mandatory field\",\"\"),\"\")","v":""}]
["E-mail address",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B31),\"Mandatory field\",\"\"),\"\")","v":""}]
[]
[]
[]
["Party contact name 2"]
["Party contact position 2"]
["Office Telephone Number 2"]
["E-mail address 2"]
["Party contact name 3"]
["Party contact position 3"]
["Office Telephone Number 3"]
["E-mail address 3"]
[]
["PARTY CONFIGURATION DATA FOR CLM"]
["Intraday Credit Indicator",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B45),\"Mandatory field\",\"\"),\"\")","v":""}]
["Minimum Reserve Obligation",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B46),\"Mandatory field\",\"\"),\"\")","v":""}]
["MFI Code",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B47),\"Mandatory field\",\"\"),\"\")","v":""}]
["Leading CLM Account Holder Party BIC",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",ISBLANK(B48)),\"Mandatory field\",\nIF(AND(ISTEXT(B48),LEN(B48)<>11),\"Error: enter a 11-digit BIC\",\"\")\n)","v":""}]
[]
["3. CONNECTIVITY TO ESMIG",null,null,{"$f":"IF(COUNTBLANK(D51:D241)=191,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["SELECT YOUR ESMIG CONNECTIVITY MODE"]
[]
["ESMIG connectivity mode",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",IF(ISBLANK(B58),\"Mandatory field\",\"\"),\"\")","v":""}]
[]
["TECHNICAL ADDRESS - NETWORK SERVICE LINK (Only for participants with A2A ESMIG connectivity)",null,null,{"$f":"IF(AND(B58=\"Both A2A and U2A\",COUNTBLANK(B68:B149)=82,COUNTBLANK(B157:B240)=84),\"Error: enter at least one Technical Address-Network Service Link\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISBLANK(B84),ISBLANK(B173),OR(ISTEXT(B$426),ISTEXT(B$433),ISTEXT(B$440))),\"Error: enter at least one Technical Address for TIPS Network Service SWIFT or SIA-COLT\",\"\")\n)","v":""}]
[]
[]
[]
[]
[]
[]
["SWIFT NETWORK SERVICE","TECHNICAL ADDRESS USED FOR SENDING/RECEIVING MESSAGES IN A2A MODE"]
["CLM",null,null,{"$f":"IF(AND(ISTEXT(B68),ISTEXT(B$58),B$58=\"U2A Only\"),\"Error: this field is not allowed for ESMIG connectivity mode 'U2A Only'\",\"\")","v":""}]
["T2CLM.SWIFT.FILESNF",null,null,{"$f":"IF(AND(ISTEXT(B69),ISTEXT(B$58),B$58=\"U2A Only\"),\"Error: this field is not allowed for ESMIG connectivity mode 'U2A Only'\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(ISTEXT(B70),ISTEXT(B$58),B$58=\"U2A Only\"),\"Error: this field is not allowed for ESMIG connectivity mode 'U2A Only'\",\"\")","v":""}]
["T2CLM.SWIFT.MSGRT",null,null,""]
[null,null,null,""]
["T2CLM.SWIFT.MSGSNF",null,null,""]
[null,null,null,""]
["RTGS",null,null,{"$f":"IF(AND(ISTEXT(B75),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
["T2RTGS.SWIFT.FILESNF",null,null,{"$f":"IF(AND(ISTEXT(B76),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(ISTEXT(B77),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
["T2RTGS.SWIFT.MSGRT",null,null,""]
[null,null,null,""]
["T2RTGS.SWIFT.MSGSNF",null,null,""]
[null,null,null,""]
["TIPS",null,null,""]
["SWIFT.NOTIF",null,null,""]
["SWIFT",null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
["T2S",null,null,""]
["SWIFT.FILERT",null,null,""]
[null,null,null,""]
["SWIFT.FILESNF",null,null,""]
[null,null,null,""]
["SWIFT.MSGRT",null,null,""]
[null,null,null,""]
["SWIFT.MSGSNF",null,null,""]
[null,null,null,""]
["BILLING",null,null,""]
["T2BILL.SWIFT.FILESNF",null,null,""]
["T2BILL.SWIFT.MSGRT",null,null,""]
["T2BILL.SWIFT.MSGSNF",null,null,""]
["TIPSBILL.SWIFT.FILESNF",null,null,""]
["TIPSBILL.SWIFT.MSGRT",null,null,""]
["TIPSBILL.SWIFT.MSGSNF",null,null,""]
["T2SBILL.SWIFT.FILESNF",null,null,""]
["T2SBILL.SWIFT.MSGRT",null,null,""]
["T2SBILL.SWIFT.MSGSNF",null,null,""]
["ECMSBILL.SWIFT.FILESNF",null,null,""]
["ECMSBILL.SWIFT.MSGRT",null,null,""]
["ECMSBILL.SWIFT.MSGSNF",null,null,""]
["BUSINESS DAY MANAGEMENT",null,null,""]
["T2BDM.SWIFT.FILESNF",null,null,""]
["T2BDM.SWIFT.MSGRT",null,null,""]
["T2BDM.SWIFT.MSGSNF",null,null,""]
["T2SBDM.SWIFT.FILESNF",null,null,""]
["T2SBDM.SWIFT.MSGRT",null,null,""]
["T2SBDM.SWIFT.MSGSNF",null,null,""]
["CRDM",null,null,""]
["T2CRDM.SWIFT.FILESNF",null,null,""]
[null,null,null,""]
["T2CRDM.SWIFT.MSGRT",null,null,""]
[null,null,null,""]
["T2CRDM.SWIFT.MSGSNF",null,null,""]
[null,null,null,""]
["TIPSCRDM.SWIFT.FILESNF",null,null,""]
[null,null,null,""]
["TIPSCRDM.SWIFT.MSGRT",null,null,""]
[null,null,null,""]
["TIPSCRDM.SWIFT.MSGSNF",null,null,""]
[null,null,null,""]
["T2SCRDM.SWIFT.FILESNF",null,null,""]
[null,null,null,""]
["T2SCRDM.SWIFT.MSGRT",null,null,""]
[null,null,null,""]
["T2SCRDM.SWIFT.MSGSNF",null,null,""]
[null,null,null,{"$f":"IF(AND(ISTEXT(B141),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
["DATA WAREHOUSE",null,null,""]
["T2DWH.SWIFT.FILESNF",null,null,""]
["T2SDWH.SWIFT.FILESNF",null,null,""]
[null,null,null,{"$f":"IF(AND(ISTEXT(B145),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
["SIA NETWORK SERVICE","TECHNICAL ADDRESS USED FOR SENDING/RECEIVING MESSAGES IN A2A MODE"]
["CLM",null,null,{"$f":"IF(AND(ISTEXT(B157),ISTEXT(B$58),B$58=\"U2A Only\"),\"Error: this field is not allowed for ESMIG connectivity mode 'U2A Only'\",\"\")","v":""}]
["T2CLM.SIA-COLT.FILESNF",null,null,{"$f":"IF(AND(ISTEXT(B158),ISTEXT(B$58),B$58=\"U2A Only\"),\"Error: this field is not allowed for ESMIG connectivity mode 'U2A Only'\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(ISTEXT(B159),ISTEXT(B$58),B$58=\"U2A Only\"),\"Error: this field is not allowed for ESMIG connectivity mode 'U2A Only'\",\"\")","v":""}]
["T2CLM.SIA-COLT.MSGRT",null,null,""]
[null,null,null,""]
["T2CLM.SIA-COLT.MSGSNF",null,null,""]
[null,null,null,""]
["RTGS",null,null,{"$f":"IF(AND(ISTEXT(B164),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
["T2RTGS.SIA-COLT.FILESNF",null,null,{"$f":"IF(AND(ISTEXT(B165),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(ISTEXT(B166),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
["T2RTGS.SIA-COLT.MSGRT",null,null,""]
[null,null,null,""]
["T2RTGS.SIA-COLT.MSGSNF",null,null,""]
[null,null,null,""]
["TIPS",null,null,""]
["SIA.NOTIF",null,null,""]
["SIA",null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
["T2S",null,null,""]
["SIA-COLT.FILERT",null,null,""]
[null,null,null,""]
["SIA-COLT.FILESNF",null,null,""]
[null,null,null,""]
["SIA-COLT.MSGRT",null,null,""]
[null,null,null,""]
["SIA-COLT.MSGSNF",null,null,""]
[null,null,null,""]
["BILLING",null,null,""]
["T2BILL.SIA-COLT.FILESNF",null,null,""]
["T2BILL.SIA-COLT.MSGRT",null,null,""]
["T2BILL.SIA-COLT.MSGSNF",null,null,""]
["TIPSBILL.SIA-COLT.FILESNF",null,null,""]
["TIPSBILL.SIA-COLT.MSGRT",null,null,""]
["TIPSBILL.SIA-COLT.MSGSNF",null,null,""]
["T2SBILL.SIA-COLT.FILESNF",null,null,""]
["T2SBILL.SIA-COLT.MSGRT",null,null,""]
["T2SBILL.SIA-COLT.MSGSNF",null,null,""]
["ECMSBILL.SIA-COLT.FILESNF",null,null,""]
["ECMSBILL.SIA-COLT.MSGRT",null,null,""]
["ECMSBILL.SIA-COLT.MSGSNF",null,null,""]
["BUSINESS DAY MANAGEMENT",null,null,""]
["T2BDM.SIA-COLT.FILESNF",null,null,""]
["T2BDM.SIA-COLT.MSGRT",null,null,""]
["T2BDM.SIA-COLT.MSGSNF",null,null,""]
["T2SBDM.SIA-COLT.FILESNF",null,null,""]
["T2SBDM.SIA-COLT.MSGRT",null,null,""]
["T2SBDM.SIA-COLT.MSGSNF",null,null,""]
["CRDM",null,null,""]
["T2CRDM.SIA-COLT.FILESNF",null,null,""]
[null,null,null,""]
["T2CRDM.SIA-COLT.MSGRT",null,null,""]
[null,null,null,""]
["T2CRDM.SIA-COLT.MSGSNF",null,null,""]
[null,null,null,""]
["TIPSCRDM.SIA-COLT.FILESNF",null,null,""]
[null,null,null,""]
["TIPSCRDM.SIA-COLT.MSGRT",null,null,""]
[null,null,null,""]
["TIPSCRDM.SIA-COLT.MSGSNF",null,null,""]
[null,null,null,""]
["T2SCRDM.SIA-COLT.FILESNF",null,null,""]
[null,null,null,""]
["T2SCRDM.SIA-COLT.MSGRT",null,null,""]
[null,null,null,""]
["T2SCRDM.SIA-COLT.MSGSNF",null,null,""]
[null,null,null,{"$f":"IF(AND(ISTEXT(B230),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
["DATA WAREHOUSE",null,null,""]
["T2DWH.SIA-COLT.FILESNF",null,null,""]
["T2SDWH.SIA-COLT.FILESNF",null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(AND(ISTEXT(B239),ISTEXT(B$58),B$58<>\"Both A2A and U2A\"),\"Error: this field is only allowed for ESMIG connectivity mode 'Both A2A and U2A'\",\"\")","v":""}]
[null,null,null,""]
[]
["4. PARTY ROLES",null,null,{"$f":"IF(COUNTBLANK(D243:D305)=63,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["AH Party Administrator"]
["AH Access Rights Admin",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",OR($B$58=\"Both A2A and U2A\",$B$58=\"U2A Only\")),IF(ISBLANK(B253),\"Mandatory field\",\"\"),\nIF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",$B$58<>\"Both A2A and U2A\",$B$58<>\"U2A Only\",ISTEXT(B$757)),IF(ISBLANK(B253),\"Mandatory field\",\"\"),\"\")\n)","v":""}]
["AH ESMIG Access",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",OR($B$58=\"Both A2A and U2A\",$B$58=\"U2A Only\")),IF(ISBLANK(B254),\"Mandatory field\",\"\"),\nIF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",$B$58<>\"Both A2A and U2A\",$B$58<>\"U2A Only\",ISTEXT(B$757)),IF(ISBLANK(B254),\"Mandatory field\",\"\"),\"\")\n)","v":""}]
["AH CRDM Access"]
[]
[]
[]
["AH CLM Manager",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",OR($B$58=\"Both A2A and U2A\",$B$58=\"U2A Only\")),IF(ISBLANK(B259),\"Mandatory field\",\"\"),\nIF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",$B$58<>\"Both A2A and U2A\",$B$58<>\"U2A Only\",ISTEXT(B$757)),IF(ISBLANK(B259),\"Mandatory field\",\"\"),\"\")\n)","v":""}]
["AH CLM Reader",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",OR($B$58=\"Both A2A and U2A\",$B$58=\"U2A Only\")),IF(ISBLANK(B260),\"Mandatory field\",\"\"),\nIF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",$B$58<>\"Both A2A and U2A\",$B$58<>\"U2A Only\",ISTEXT(B$757)),IF(ISBLANK(B260),\"Mandatory field\",\"\"),\"\")\n)","v":""}]
[]
[]
[]
["AH CRDM AMG Manager"]
["AH CRDM Configuration Manager"]
["AH CRDM Liquidity Manager"]
["AH CRDM Reader"]
[]
[]
[]
["AH RTGS AS Manager"]
["AH RTGS Backup Payment Mngr",null,null,{"$f":"IF(AND(ISTEXT(B272),OR(ISTEXT(B273),ISTEXT(B274))),\"Error: AH RTGS Backup Payment Manager is incompatible with AH RTGS Cutomer/Inter-bank CT U2A\",\"\")","v":""}]
["AH RTGS Customer CT U2A",null,null,{"$f":"IF(AND(ISTEXT(B273),ISTEXT(B272)),\"Error: AH RTGS Cutomer CT U2A is incompatible with AH RTGS Backup Payment Manager\",\"\")","v":""}]
["AH RTGS Inter-bank CT U2A",null,null,{"$f":"IF(AND(ISTEXT(B274),ISTEXT(B272)),\"Error: AH RTGS Inter-bank CT U2A is incompatible with AH RTGS Backup Payment Manager\",\"\")","v":""}]
["AH RTGS Limit/Rsrvtion Mngr"]
["AH RTGS Liquidity Trfr Mngr",null,null,{"$f":"IF(AND(OR(ISTEXT(B372),ISTEXT(B384),ISTEXT(B396)),ISBLANK(B276),$B$3<>\"Delete\"),\"Mandatory field\",\"\")","v":""}]
["AH RTGS Payment Manager",null,null,{"$f":"IF(AND(OR(ISTEXT(B372),ISTEXT(B384),ISTEXT(B396)),ISBLANK(B277),$B$3<>\"Delete\"),\"Mandatory field\",\"\")","v":""}]
["AH RTGS Reader",null,null,{"$f":"IF(AND(OR(ISTEXT(B372),ISTEXT(B384),ISTEXT(B396)),ISBLANK(B278),$B$3<>\"Delete\"),\"Mandatory field\",\"\")","v":""}]
[]
[]
[]
["AH Bill Reader"]
[]
[]
[]
["AH Data Warehouse User"]
[]
[]
[]
["AH T2S CMB Manager"]
["AH T2S Collateral Manager"]
["AH T2S Liquidity Manager",null,null,{"$f":"IF(AND(OR(ISTEXT(B449),ISTEXT(B459),ISTEXT(B469)),ISBLANK(B292)),\"Mandatory field\",\"\")","v":""}]
["AH T2S Reader",null,null,{"$f":"IF(AND(OR(ISTEXT(B449),ISTEXT(B459),ISTEXT(B469)),ISBLANK(B293)),\"Mandatory field\",\"\")","v":""}]
[]
[]
[]
["AH Instant Payment Manager (A2A only)",null,null,{"$f":"IF(AND(OR(ISTEXT(B426),ISTEXT(B433),ISTEXT(B440)),ISBLANK(B297)),\"Mandatory field\",\"\")","v":""}]
["AH MPL Reader"]
["AH TIPS CMB Manager"]
["AH TIPS CMB Set-up Manager"]
["AH TIPS Liquidity Manager",null,null,{"$f":"IF(AND(OR(ISTEXT(B426),ISTEXT(B433),ISTEXT(B440)),ISBLANK(B301)),\"Mandatory field\",\"\")","v":""}]
["AH TIPS Party Query",null,null,{"$f":"IF(AND(OR(ISTEXT(B426),ISTEXT(B433),ISTEXT(B440)),ISBLANK(B302)),\"Mandatory field\",\"\")","v":""}]
["AH TIPS Reachable Party Query"]
[]
[]
["5. CASH ACCOUNTS",null,null,{"$f":"IF(COUNTBLANK(D307:D506)=200,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["MAIN CASH ACCOUNTS"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",\n  IF(ISBLANK(B318),\"Mandatory field\",IF(LEFT($B318,17)<>CONCATENATE(\"MITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),IF(AND(ISTEXT(B318),LEFT($B318,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",\n  IF(ISBLANK(B319),\"Mandatory field\",IF(LEN(B319)<>11,\"Error: enter a 11-digit BIC\",\"\")),IF(AND(ISTEXT(B318),ISBLANK(B319)),\"Mandatory field\",IF(AND(ISTEXT(B319),LEN(B319)<>11),\"Error: enter a 11-digit BIC\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",\n  IF(ISBLANK(B320),\"Mandatory field\",IF(AND(B320=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",\"\")),IF(AND(ISTEXT(B318),ISBLANK(B320)),\"Mandatory field\",IF(AND(B320=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",\"\")))","v":""}]
["Co-managed",null,null,{"$f":"IF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B318),ISBLANK(B321)),\"Mandatory field\",\nIF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B318),B321=\"NO\"),\"Error: if you have no ESMIG connection (see field B57) you can only own co-managed MCAs\",\"\")\n)","v":""}]
["Co-manager Parent BIC",null,null,{"$f":"IF(AND(B321=\"YES\",ISBLANK(B322)),\"Mandatory field\",IF(AND(B321=\"YES\",ISTEXT(B322)),IF(LEN(B322)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B321=\"NO\",ISTEXT(B322)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["Co-manager Party BIC",null,null,{"$f":"IF(AND(B321=\"YES\",ISBLANK(B323)),\"Mandatory field\",IF(AND(B321=\"YES\",ISTEXT(B323)),IF(LEN(B323)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B321=\"NO\",ISTEXT(B323)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["RTGS DCA to be used for automatic LT in case of pending central bank operations",null,null,{"$f":"IF(\nAND($B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT($B372),ISTEXT($B384),ISTEXT($B396))),\nIF(ISBLANK($B324), \"This field is mandatory if you own an RTGS DCA\",IF(AND(B324<>B372,B324<>B384,B324<>B396),\"Error: The RTGS account does not match the ones defined below\",\"\")),\nIF(ISTEXT(B324),\nIF(LEFT($B324,17)<>CONCATENATE(\"RITEUR\",$B$4),\"Error: wrong RTGS DCA account number\",\"\"),\nIF(AND(OR($B$3=\"New/Add\",$B$3=\"Modify\"),OR(ISTEXT($B372),ISTEXT($B384),ISTEXT($B396))),\n\"This field is mandatory if you own an RTGS DCA\",\"\"))\n)","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B330),B330=B318),\"Error: account number already defined\",IF(AND(ISTEXT(B330),LEFT($B330,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B330),ISBLANK(B331)),\"Mandatory field\",IF(AND(ISTEXT(B331),LEN(B331)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B331),OR(B331=B$319,B331=B$342)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B332=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B330),ISBLANK(B332)),\"Mandatory field\",\"\"))","v":""}]
["Co-managed",null,null,{"$f":"IF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B330),ISBLANK(B333)),\"Mandatory field\",\nIF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B330),B333=\"NO\"),\"Error: if you have no ESMIG connection (see field B57) you can only own co-managed MCAs\",\"\")\n)","v":""}]
["Co-manager Parent BIC",null,null,{"$f":"IF(AND(B333=\"YES\",ISBLANK(B334)),\"Mandatory field\",IF(AND(B333=\"YES\",ISTEXT(B334)),IF(LEN(B334)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B333=\"NO\",ISTEXT(B334)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["Co-manager Party BIC",null,null,{"$f":"IF(AND(B333=\"YES\",ISBLANK(B335)),\"Mandatory field\",IF(AND(B333=\"YES\",ISTEXT(B335)),IF(LEN(B335)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B333=\"NO\",ISTEXT(B335)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B341),OR(B341=B330,B341=B318)),\"Error: account number already defined\",IF(AND(ISTEXT(B341),LEFT($B341,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B341),ISBLANK(B342)),\"Mandatory field\",IF(AND(ISTEXT(B342),LEN(B342)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B342),OR(B342=B$319,B342=B$331)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B343=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B341),ISBLANK(B343)),\"Mandatory field\",\"\"))","v":""}]
["Co-managed",null,null,{"$f":"IF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B341),ISBLANK(B344)),\"Mandatory field\",\nIF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B341),B344=\"NO\"),\"Error: if you have no ESMIG connection (see field B57) you can only own co-managed MCAs\",\"\")\n)","v":""}]
["Co-manager Parent BIC",null,null,{"$f":"IF(AND(B344=\"YES\",ISBLANK(B345)),\"Mandatory field\",IF(AND(B344=\"YES\",ISTEXT(B345)),IF(LEN(B345)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B344=\"NO\",ISTEXT(B345)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["Co-manager Party BIC",null,null,{"$f":"IF(AND(B344=\"YES\",ISBLANK(B346)),\"Mandatory field\",IF(AND(B344=\"YES\",ISTEXT(B346)),IF(LEN(B346)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B344=\"NO\",ISTEXT(B346)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
[]
["MARGINAL LENDING ACCOUNT"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B354),IF(LEFT($B354,17)<>CONCATENATE(\"LITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Linked Default MCA ",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",\nIF(AND(ISTEXT(B354),ISBLANK(B355)),\"Mandatory field\",IF(AND(ISTEXT(B355),B355<>B318),\"Error: enter the Default MCA Number defined in field B318\",\"\")),\nIF(AND(ISTEXT(B354),ISBLANK(B355)),\"Mandatory field\",IF(AND(ISTEXT(B355),LEFT(B355,17)<>CONCATENATE(\"MITEUR\",B$4)),\"Error: wrong account number\",\"\"))\n)","v":""}]
[]
["OVERNIGHT DEPOSIT ACCOUNT"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B363),IF(LEFT($B363,17)<>CONCATENATE(\"DITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Linked Default MCA ",null,null,{"$f":"IF($B$3=\"First registration in TARGET-Banca d'Italia\",\nIF(AND(ISTEXT(B363),ISBLANK(B364)),\"Mandatory field\",IF(AND(ISTEXT(B364),B364<>B318),\"Error: enter the Default MCA Number defined in field B318\",\"\")),\nIF(AND(ISTEXT(B363),ISBLANK(B364)),\"Mandatory field\",IF(AND(ISTEXT(B364),LEFT(B364,17)<>CONCATENATE(\"MITEUR\",B$4)),\"Error: wrong account number\",\"\"))\n)","v":""}]
[]
["RTGS DCAs"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B372),IF(LEFT($B372,17)<>CONCATENATE(\"RITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B372),ISBLANK(B373)),\"Mandatory field\",IF(AND(ISTEXT(B373),LEN(B373)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B374=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B372),ISBLANK(B374)),\"Mandatory field\",\"\"))","v":""}]
["Rule-based LT for Queued High Priority Payments"]
["Rule-based LT for Queued Urgent Priority Payments/AS Transfer Orders"]
["Marked as Main BIC Account in RTGS Directory"]
["Non-published in RTGS Directory"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B372),B384=B372),\"Error: account number already defined\",IF(AND(ISTEXT(B384),LEFT($B384,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B384),ISBLANK(B385)),\"Mandatory field\",IF(AND(ISTEXT(B385),LEN(B385)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B385),OR(B385=B373,B385=B397)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B386=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B384),ISBLANK(B386)),\"Mandatory field\",\"\"))","v":""}]
["Rule-based LT for Queued High Priority Payments"]
["Rule-based LT for Queued Urgent Priority Payments/AS Transfer Orders"]
["Marked as Main BIC Account in RTGS Directory"]
["Non-published in RTGS Directory"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B396),OR(B396=B384,B396=B372)),\"Error: account number already defined\",IF(AND(ISTEXT(B396),LEFT($B396,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B396),ISBLANK(B397)),\"Mandatory field\",IF(AND(ISTEXT(B397),LEN(B397)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B397),OR(B397=B373,B397=B385)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B398=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B396),ISBLANK(B398)),\"Mandatory field\",\"\"))","v":""}]
["Rule-based LT for Queued High Priority Payments"]
["Rule-based LT for Queued Urgent Priority Payments/AS Transfer Orders"]
["Marked as Main BIC Account in RTGS Directory"]
["Non-published in RTGS Directory"]
[]
["RTGS SUB-ACCOUNTS"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT($B$4),ISTEXT($B410)),IF(LEFT($B410,17)<>CONCATENATE(\"UITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Linked RTGS DCA",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT($B411)),\nIF(AND($B411<>$B372,$B411<>$B384,$B411<>$B396),\"Error: Enter an RTGS DCA account from those defined\",\"\"),\nIF(AND(ISTEXT($B410),ISBLANK(B411)),\"Mandatory field\",\"\"))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B417),B417=B410),\"Error: account number already defined\",IF(AND(ISTEXT(B417),LEFT($B417,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Linked RTGS DCA",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT($B418)),\nIF(AND($B418<>$B372,$B418<>$B384,$B418<>$B396),\"Error: Enter an RTGS DCA account from those defined\",IF(AND(ISTEXT(B418),B418=B411),\"Error: it is not pssible to link more RTGS Sub-accounts to the same RTGS DCA\",\"\")),\nIF(AND(ISTEXT($B417),ISBLANK(B418)),\"Mandatory field\",IF(AND(ISTEXT(B418),B418=B411),\"Error: it is not pssible to link more RTGS Sub-accounts to the same RTGS DCA\",\"\")))","v":""}]
[]
["TIPS DCAs"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B426),IF(LEFT($B426,17)<>CONCATENATE(\"IITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B427=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B426),ISBLANK(B427)),\"Mandatory field\",\"\"))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B433),B433=B426),\"Error: account number already defined\",IF(AND(ISTEXT(B433),LEFT($B433,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B434=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B433),ISBLANK(B434)),\"Mandatory field\",\"\"))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B440),OR(B440=B426,B440=B433)),\"Error: account number already defined\",IF(AND(ISTEXT(B440),LEFT($B440,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B441=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B440),ISBLANK(B441)),\"Mandatory field\",\"\"))","v":""}]
[]
["T2S DCAs"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B449),IF(LEFT($B449,17)<>CONCATENATE(\"CITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B450=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B449),ISBLANK(B450)),\"Mandatory field\",\"\"))","v":""}]
["Linked MCA (to allow LTs between T2S DCAs linked to the same MCA)"]
["Central Bank Auto-collateralisation"]
["Requested auto-collateralisation limit"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B459),B459=B449),\"Error: account number already defined\",IF(AND(ISTEXT(B459),LEFT($B459,17)<>CONCATENATE(\"CITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B460=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B459),ISBLANK(B460)),\"Mandatory field\",\"\"))","v":""}]
["Linked MCA (to allow LTs between T2S DCAs linked to the same MCA)"]
["Central Bank Auto-collateralisation"]
["Requested auto-collateralisation limit"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B469),OR(B469=B449,B469=B459)),\"Error: account number already defined\",IF(AND(ISTEXT(B469),LEFT($B469,17)<>CONCATENATE(\"CITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B470=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B469),ISBLANK(B470)),\"Mandatory field\",\"\"))","v":""}]
["Linked MCA (to allow LTs between T2S DCAs linked to the same MCA)"]
["Central Bank Auto-collateralisation"]
["Requested auto-collateralisation limit"]
[]
["AS TECHNICAL ACCOUNTS (Only for Ancillary System)"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B481),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B481,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B481),ISBLANK(B482)),\"Mandatory field\",IF(AND(ISTEXT(B482),LEN(B482)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B482),OR(B482=B$373,B482=B$397)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B488),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B488,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B488),ISBLANK(B489)),\"Mandatory field\",IF(AND(ISTEXT(B489),LEN(B489)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B489),OR(B489=B$373,B489=B$397,B489=B$482)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
["AS GUARANTEE FUNDS ACCOUNTS (Only for Ancillary System)"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B497),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B497,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B497),ISBLANK(B498)),\"Mandatory field\",IF(AND(ISTEXT(B498),LEN(B498)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B498),OR(B498=B$373,B498=B$397,B498=B$482,B498=B$489)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B504),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B504,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B504),ISBLANK(B505)),\"Mandatory field\",IF(AND(ISTEXT(B505),LEN(B505)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B505),OR(B505=B$373,B505=B$397,B505=B$482,B505=B$489,B505=B$498)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
["6. AUTHORISED ACCOUNT USERS",null,null,{"$f":"IF(COUNTBLANK(D508:D582)=75,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISBLANK(B513),OR(ISTEXT(B426),ISTEXT(B433),ISTEXT(B440))),\"Mandatory field\",\nIF(AND(ISTEXT(B513),LEFT(B515,4)=\"TIPS\",LEN(B513)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B513),LEFT(B514,6)=\"RITEUR\",OR(B513=B$373,B513=B$385,B513=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B513),ISBLANK(B514)),\"Mandatory field\",\nIF(AND(ISTEXT($B514),B$3=\"First registration in TARGET-Banca d'Italia\",B514<>B$372,B514<>B$384,B514<>B$396,B514<>B$426,B514<>B$433,B514<>B$440,B514<>B$449,B514<>B$459,B514<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B514),LEFT($B514,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B514,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B514,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B513),ISBLANK(B515)),\"Mandatory field\",\n  IF(AND(ISTEXT(B513),LEFT(B514,6)=\"RITEUR\",AND(LEFT(B515,4)<>\"RTGS\",LEFT(B515,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B513),LEFT(B514,6)=\"CITEUR\",AND(LEFT(B515,3)<>\"T2S\",LEFT(B515,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B513),LEFT(B514,6)=\"IITEUR\",LEFT(B515,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B516),B515<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B516),B515=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B516),B515=\"TIPS AAU/Reachable Party\",B516<>B$84,B516<>B$85,B516<>B$86,B516<>B$87,B516<>B$88,B516<>B$89,B516<>B$90,B516<>B$91,B516<>B$92,B516<>B$93,B516<>B$173,B516<>B$174,B516<>B$175,B516<>B$176,B516<>B$177,B516<>B$178,B516<>B$179,B516<>B$180,B516<>B$181,B516<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B517),B515<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B517),B515=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B518),B$515<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B520),LEFT(B522,4)=\"TIPS\",LEN(B520)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B520),LEFT(B521,6)=\"RITEUR\",OR(B520=B$373,B520=B$385,B520=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B520),ISBLANK(B521)),\"Mandatory field\",\nIF(AND(ISTEXT($B521),B$3=\"First registration in TARGET-Banca d'Italia\",B521<>B$372,B521<>B$384,B521<>B$396,B521<>B$426,B521<>B$433,B521<>B$440,B521<>B$449,B521<>B$459,B521<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B521),LEFT($B521,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B521,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B521,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B520),ISBLANK(B522)),\"Mandatory field\",\n  IF(AND(ISTEXT(B520),LEFT(B521,6)=\"RITEUR\",AND(LEFT(B522,4)<>\"RTGS\",LEFT(B522,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B520),LEFT(B521,6)=\"CITEUR\",AND(LEFT(B522,3)<>\"T2S\",LEFT(B522,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B520),LEFT(B521,6)=\"IITEUR\",LEFT(B522,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B523),B522<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B523),B522=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B523),B522=\"TIPS AAU/Reachable Party\",B523<>B$84,B523<>B$85,B523<>B$86,B523<>B$87,B523<>B$88,B523<>B$89,B523<>B$90,B523<>B$91,B523<>B$92,B523<>B$93,B523<>B$173,B523<>B$174,B523<>B$175,B523<>B$176,B523<>B$177,B523<>B$178,B523<>B$179,B523<>B$180,B523<>B$181,B523<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B524),B522<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B524),B522=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B525),B522<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B527),LEFT(B529,4)=\"TIPS\",LEN(B527)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B527),LEFT(B528,6)=\"RITEUR\",OR(B527=B$373,B527=B$385,B527=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B527),ISBLANK(B528)),\"Mandatory field\",\nIF(AND(ISTEXT($B528),B$3=\"First registration in TARGET-Banca d'Italia\",B528<>B$372,B528<>B$384,B528<>B$396,B528<>B$426,B528<>B$433,B528<>B$440,B528<>B$449,B528<>B$459,B528<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B528),LEFT($B528,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B528,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B528,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B527),ISBLANK(B529)),\"Mandatory field\",\n  IF(AND(ISTEXT(B527),LEFT(B528,6)=\"RITEUR\",AND(LEFT(B529,4)<>\"RTGS\",LEFT(B529,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B527),LEFT(B528,6)=\"CITEUR\",AND(LEFT(B529,3)<>\"T2S\",LEFT(B529,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B527),LEFT(B528,6)=\"IITEUR\",LEFT(B529,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B530),B529<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B530),B529=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B530),B529=\"TIPS AAU/Reachable Party\",B530<>B$84,B530<>B$85,B530<>B$86,B530<>B$87,B530<>B$88,B530<>B$89,B530<>B$90,B530<>B$91,B530<>B$92,B530<>B$93,B530<>B$173,B530<>B$174,B530<>B$175,B530<>B$176,B530<>B$177,B530<>B$178,B530<>B$179,B530<>B$180,B530<>B$181,B530<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B531),B529<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B531),B529=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B532),B529<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B534),LEFT(B536,4)=\"TIPS\",LEN(B534)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B534),LEFT(B535,6)=\"RITEUR\",OR(B534=B$373,B534=B$385,B534=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B534),ISBLANK(B535)),\"Mandatory field\",\nIF(AND(ISTEXT($B535),B$3=\"First registration in TARGET-Banca d'Italia\",B535<>B$372,B535<>B$384,B535<>B$396,B535<>B$426,B535<>B$433,B535<>B$440,B535<>B$449,B535<>B$459,B535<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B535),LEFT($B535,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B535,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B535,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B534),ISBLANK(B536)),\"Mandatory field\",\n  IF(AND(ISTEXT(B534),LEFT(B535,6)=\"RITEUR\",AND(LEFT(B536,4)<>\"RTGS\",LEFT(B536,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B534),LEFT(B535,6)=\"CITEUR\",AND(LEFT(B536,3)<>\"T2S\",LEFT(B536,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B534),LEFT(B535,6)=\"IITEUR\",LEFT(B536,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B537),B536<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B537),B536=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B537),B536=\"TIPS AAU/Reachable Party\",B537<>B$84,B537<>B$85,B537<>B$86,B537<>B$87,B537<>B$88,B537<>B$89,B537<>B$90,B537<>B$91,B537<>B$92,B537<>B$93,B537<>B$173,B537<>B$174,B537<>B$175,B537<>B$176,B537<>B$177,B537<>B$178,B537<>B$179,B537<>B$180,B537<>B$181,B537<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B538),B536<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B538),B536=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B539),B536<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B541),LEFT(B543,4)=\"TIPS\",LEN(B541)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B541),LEFT(B542,6)=\"RITEUR\",OR(B541=B$373,B541=B$385,B541=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B541),ISBLANK(B542)),\"Mandatory field\",\nIF(AND(ISTEXT($B542),B$3=\"First registration in TARGET-Banca d'Italia\",B542<>B$372,B542<>B$384,B542<>B$396,B542<>B$426,B542<>B$433,B542<>B$440,B542<>B$449,B542<>B$459,B542<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B542),LEFT($B542,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B542,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B542,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B541),ISBLANK(B543)),\"Mandatory field\",\n  IF(AND(ISTEXT(B541),LEFT(B542,6)=\"RITEUR\",AND(LEFT(B543,4)<>\"RTGS\",LEFT(B543,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B541),LEFT(B542,6)=\"CITEUR\",AND(LEFT(B543,3)<>\"T2S\",LEFT(B543,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B541),LEFT(B542,6)=\"IITEUR\",LEFT(B543,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B544),B543<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B544),B543=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B544),B543=\"TIPS AAU/Reachable Party\",B544<>B$84,B544<>B$85,B544<>B$86,B544<>B$87,B544<>B$88,B544<>B$89,B544<>B$90,B544<>B$91,B544<>B$92,B544<>B$93,B544<>B$173,B544<>B$174,B544<>B$175,B544<>B$176,B544<>B$177,B544<>B$178,B544<>B$179,B544<>B$180,B544<>B$181,B544<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B545),B543<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B545),B543=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B546),B543<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B548),LEFT(B550,4)=\"TIPS\",LEN(B548)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B548),LEFT(B549,6)=\"RITEUR\",OR(B548=B$373,B548=B$385,B548=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B548),ISBLANK(B549)),\"Mandatory field\",\nIF(AND(ISTEXT($B549),B$3=\"First registration in TARGET-Banca d'Italia\",B549<>B$372,B549<>B$384,B549<>B$396,B549<>B$426,B549<>B$433,B549<>B$440,B549<>B$449,B549<>B$459,B549<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B549),LEFT($B549,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B549,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B549,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B548),ISBLANK(B550)),\"Mandatory field\",\n  IF(AND(ISTEXT(B548),LEFT(B549,6)=\"RITEUR\",AND(LEFT(B550,4)<>\"RTGS\",LEFT(B550,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B548),LEFT(B549,6)=\"CITEUR\",AND(LEFT(B550,3)<>\"T2S\",LEFT(B550,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B548),LEFT(B549,6)=\"IITEUR\",LEFT(B550,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B551),B550<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B551),B550=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B551),B550=\"TIPS AAU/Reachable Party\",B551<>B$84,B551<>B$85,B551<>B$86,B551<>B$87,B551<>B$88,B551<>B$89,B551<>B$90,B551<>B$91,B551<>B$92,B551<>B$93,B551<>B$173,B551<>B$174,B551<>B$175,B551<>B$176,B551<>B$177,B551<>B$178,B551<>B$179,B551<>B$180,B551<>B$181,B551<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B552),B550<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B552),B550=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B553),B550<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B555),LEFT(B557,4)=\"TIPS\",LEN(B555)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B555),LEFT(B556,6)=\"RITEUR\",OR(B555=B$373,B555=B$385,B555=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B555),ISBLANK(B556)),\"Mandatory field\",\nIF(AND(ISTEXT($B556),B$3=\"First registration in TARGET-Banca d'Italia\",B556<>B$372,B556<>B$384,B556<>B$396,B556<>B$426,B556<>B$433,B556<>B$440,B556<>B$449,B556<>B$459,B556<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B556),LEFT($B556,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B556,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B556,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B555),ISBLANK(B557)),\"Mandatory field\",\n  IF(AND(ISTEXT(B555),LEFT(B556,6)=\"RITEUR\",AND(LEFT(B557,4)<>\"RTGS\",LEFT(B557,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B555),LEFT(B556,6)=\"CITEUR\",AND(LEFT(B557,3)<>\"T2S\",LEFT(B557,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B555),LEFT(B556,6)=\"IITEUR\",LEFT(B557,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B558),B557<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B558),B557=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B558),B557=\"TIPS AAU/Reachable Party\",B558<>B$84,B558<>B$85,B558<>B$86,B558<>B$87,B558<>B$88,B558<>B$89,B558<>B$90,B558<>B$91,B558<>B$92,B558<>B$93,B558<>B$173,B558<>B$174,B558<>B$175,B558<>B$176,B558<>B$177,B558<>B$178,B558<>B$179,B558<>B$180,B558<>B$181,B558<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B559),B557<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B559),B557=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B560),B557<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B562),LEFT(B564,4)=\"TIPS\",LEN(B562)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B562),LEFT(B563,6)=\"RITEUR\",OR(B562=B$373,B562=B$385,B562=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B562),ISBLANK(B563)),\"Mandatory field\",\nIF(AND(ISTEXT($B563),B$3=\"First registration in TARGET-Banca d'Italia\",B563<>B$372,B563<>B$384,B563<>B$396,B563<>B$426,B563<>B$433,B563<>B$440,B563<>B$449,B563<>B$459,B563<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B563),LEFT($B563,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B563,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B563,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B562),ISBLANK(B564)),\"Mandatory field\",\n  IF(AND(ISTEXT(B562),LEFT(B563,6)=\"RITEUR\",AND(LEFT(B564,4)<>\"RTGS\",LEFT(B564,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B562),LEFT(B563,6)=\"CITEUR\",AND(LEFT(B564,3)<>\"T2S\",LEFT(B564,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B562),LEFT(B563,6)=\"IITEUR\",LEFT(B564,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B565),B564<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B565),B564=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B565),B564=\"TIPS AAU/Reachable Party\",B565<>B$84,B565<>B$85,B565<>B$86,B565<>B$87,B565<>B$88,B565<>B$89,B565<>B$90,B565<>B$91,B565<>B$92,B565<>B$93,B565<>B$173,B565<>B$174,B565<>B$175,B565<>B$176,B565<>B$177,B565<>B$178,B565<>B$179,B565<>B$180,B565<>B$181,B565<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B566),B564<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B566),B564=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B567),B564<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B569),LEFT(B571,4)=\"TIPS\",LEN(B569)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B569),LEFT(B570,6)=\"RITEUR\",OR(B569=B$373,B569=B$385,B569=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B569),ISBLANK(B570)),\"Mandatory field\",\nIF(AND(ISTEXT($B570),B$3=\"First registration in TARGET-Banca d'Italia\",B570<>B$372,B570<>B$384,B570<>B$396,B570<>B$426,B570<>B$433,B570<>B$440,B570<>B$449,B570<>B$459,B570<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B570),LEFT($B570,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B570,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B570,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B569),ISBLANK(B571)),\"Mandatory field\",\n  IF(AND(ISTEXT(B569),LEFT(B570,6)=\"RITEUR\",AND(LEFT(B571,4)<>\"RTGS\",LEFT(B571,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B569),LEFT(B570,6)=\"CITEUR\",AND(LEFT(B571,3)<>\"T2S\",LEFT(B571,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B569),LEFT(B570,6)=\"IITEUR\",LEFT(B571,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B572),B571<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B572),B571=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B572),B571=\"TIPS AAU/Reachable Party\",B572<>B$84,B572<>B$85,B572<>B$86,B572<>B$87,B572<>B$88,B572<>B$89,B572<>B$90,B572<>B$91,B572<>B$92,B572<>B$93,B572<>B$173,B572<>B$174,B572<>B$175,B572<>B$176,B572<>B$177,B572<>B$178,B572<>B$179,B572<>B$180,B572<>B$181,B572<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B573),B571<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B573),B571=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B574),B571<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B576),LEFT(B578,4)=\"TIPS\",LEN(B576)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B576),LEFT(B577,6)=\"RITEUR\",OR(B576=B$373,B576=B$385,B576=B$397)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B576),ISBLANK(B577)),\"Mandatory field\",\nIF(AND(ISTEXT($B577),B$3=\"First registration in TARGET-Banca d'Italia\",B577<>B$372,B577<>B$384,B577<>B$396,B577<>B$426,B577<>B$433,B577<>B$440,B577<>B$449,B577<>B$459,B577<>B$469),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B577),LEFT($B577,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B577,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B577,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B576),ISBLANK(B578)),\"Mandatory field\",\n  IF(AND(ISTEXT(B576),LEFT(B577,6)=\"RITEUR\",AND(LEFT(B578,4)<>\"RTGS\",LEFT(B578,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B576),LEFT(B577,6)=\"CITEUR\",AND(LEFT(B578,3)<>\"T2S\",LEFT(B578,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B576),LEFT(B577,6)=\"IITEUR\",LEFT(B578,4)<>\"TIPS\"),\"AAU Type not allowed for TIPS DCA\",\"\"\n)\n)\n)\n)","v":""}]
["DN used for sending/receiving messages to/from TIPS (Inbound/Outbound DN-BIC Routing)",null,null,{"$f":"IF(AND(ISTEXT(B579),B578<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B579),B578=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B579),B578=\"TIPS AAU/Reachable Party\",B579<>B$84,B579<>B$85,B579<>B$86,B579<>B$87,B579<>B$88,B579<>B$89,B579<>B$90,B579<>B$91,B579<>B$92,B579<>B$93,B579<>B$173,B579<>B$174,B579<>B$175,B579<>B$176,B579<>B$177,B579<>B$178,B579<>B$179,B579<>B$180,B579<>B$181,B579<>B$182),\"Error: enter one of the technical addresses defined for TIPS Network Service (SWIFT or SIA)\",\"\")\n)\n)","v":""}]
["Login Name of the A2A user used for sending/receiving messages to/from TIPS",null,null,{"$f":"IF(AND(ISTEXT(B580),B578<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B580),B578=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B581),B578<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
[]
["7. DIRECT DEBIT MANDATES",null,null,{"$f":"IF(COUNTBLANK(D584:D609)=26,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["Payee Parent BIC",null,null,{"$f":"IF(AND($B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B$372),ISBLANK(B589)),\"Mandatory field\",\nIF(AND(ISTEXT(B589),LEN(B589)<>11),\"Error: enter a 11-digit BIC\",\"\")\n)","v":""}]
["Payee Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B589),ISBLANK(B590)),\"Mandatory field\",\nIF(AND(ISTEXT(B590),LEN(B590)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Cash Account to be debited",null,null,{"$f":"IF(AND(ISTEXT($B590),ISBLANK(B591)),\"Mandatory field\",\nIF(AND(ISTEXT($B591),B$3=\"First registration in TARGET-Banca d'Italia\",B591<>B$372,B591<>B$384,B591<>B$396),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B591),LEFT($B591,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Payee Reference",null,null,{"$f":"IF(AND(ISTEXT($B589),ISBLANK(B592)),\"Mandatory field\",\"\")","v":""}]
["Maximum mount per counterparty",null,null,{"$f":"IF(AND(ISTEXT($B589),ISBLANK(B593)),\"Mandatory field\",\"\")","v":""}]
["Maximum amount per payment",null,null,{"$f":"IF(AND(ISTEXT($B589),ISBLANK(B594)),\"Mandatory field\",\"\")","v":""}]
[]
["Payee Parent BIC",null,null,{"$f":"IF(AND(ISTEXT(B596),LEN(B596)<>11),\"Error: enter a 11-digit BIC\",\"\")","v":""}]
["Payee Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B596),ISBLANK(B597)),\"Mandatory field\",\nIF(AND(ISTEXT(B597),LEN(B597)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Cash Account to be debited",null,null,{"$f":"IF(AND(ISTEXT($B597),ISBLANK(B598)),\"Mandatory field\",\nIF(AND(ISTEXT($B598),B$3=\"First registration in TARGET-Banca d'Italia\",B598<>B$372,B598<>B$384,B598<>B$396),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B598),LEFT($B598,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Payee Reference",null,null,{"$f":"IF(AND(ISTEXT($B596),ISBLANK(B599)),\"Mandatory field\",\"\")","v":""}]
["Maximum mount per counterparty",null,null,{"$f":"IF(AND(ISTEXT($B596),ISBLANK(B600)),\"Mandatory field\",\"\")","v":""}]
["Maximum amount per payment",null,null,{"$f":"IF(AND(ISTEXT($B596),ISBLANK(B601)),\"Mandatory field\",\"\")","v":""}]
[]
["Payee Parent BIC",null,null,{"$f":"IF(AND(ISTEXT(B603),LEN(B603)<>11),\"Error: enter a 11-digit BIC\",\"\")","v":""}]
["Payee Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B603),ISBLANK(B604)),\"Mandatory field\",\nIF(AND(ISTEXT(B604),LEN(B604)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Cash Account to be debited",null,null,{"$f":"IF(AND(ISTEXT($B604),ISBLANK(B605)),\"Mandatory field\",\nIF(AND(ISTEXT($B605),B$3=\"First registration in TARGET-Banca d'Italia\",B605<>B$372,B605<>B$384,B605<>B$396),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B605),LEFT($B605,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Payee Reference",null,null,{"$f":"IF(AND(ISTEXT($B603),ISBLANK(B606)),\"Mandatory field\",\"\")","v":""}]
["Maximum mount per counterparty",null,null,{"$f":"IF(AND(ISTEXT($B603),ISBLANK(B607)),\"Mandatory field\",\"\")","v":""}]
["Maximum amount per payment",null,null,{"$f":"IF(AND(ISTEXT($B603),ISBLANK(B608)),\"Mandatory field\",\"\")","v":""}]
[]
["8. GROUPS",null,null,{"$f":"IF(COUNTBLANK(D611:D719)=109,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["BANKING GROUP"]
[]
[]
[]
[]
[]
["Group Name"]
["Leader Parent BIC",null,null,{"$f":"IF(AND(ISTEXT($B622),ISBLANK(B623)),\"Mandatory field\",\nIF(AND(ISTEXT(B623),LEN(B623)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Leader Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B622),ISBLANK(B624)),\"Mandatory field\",\nIF(AND(ISTEXT(B624),LEN(B624)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
[]
["BILLING GROUP"]
[]
[]
[]
[]
[]
["Group Name"]
["Leader Parent BIC",null,null,{"$f":"IF(AND(ISTEXT($B632),ISBLANK(B633)),\"Mandatory field\",\nIF(AND(ISTEXT(B633),LEN(B633)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Leader Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B632),ISBLANK(B634)),\"Mandatory field\",\nIF(AND(ISTEXT(B634),LEN(B634)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
[]
["SETTLEMENT BANK ACCOUNT GROUP"]
[]
[]
[]
[]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B643),B$3=\"First registration in TARGET-Banca d'Italia\",B643<>B$372,B643<>B$384,B643<>B$396,B643<>B$410,B643<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B643),LEFT($B643,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B643,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B644),B$3=\"First registration in TARGET-Banca d'Italia\",B644<>B$372,B644<>B$384,B644<>B$396,B644<>B$410,B644<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B644),LEFT($B644,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B644,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B649),B$3=\"First registration in TARGET-Banca d'Italia\",B649<>B$372,B649<>B$384,B649<>B$396,B649<>B$410,B649<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B649),LEFT($B649,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B649,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B655),B$3=\"First registration in TARGET-Banca d'Italia\",B655<>B$372,B655<>B$384,B655<>B$396,B655<>B$410,B655<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B655),LEFT($B655,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B655,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B661),B$3=\"First registration in TARGET-Banca d'Italia\",B661<>B$372,B661<>B$384,B661<>B$396,B661<>B$410,B661<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B661),LEFT($B661,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B661,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B667),B$3=\"First registration in TARGET-Banca d'Italia\",B667<>B$372,B667<>B$384,B667<>B$396,B667<>B$410,B667<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B667),LEFT($B667,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B667,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B673),B$3=\"First registration in TARGET-Banca d'Italia\",B673<>B$372,B673<>B$384,B673<>B$396,B673<>B$410,B673<>B$417),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B673),LEFT($B673,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B673,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
["Cash Account to be included in the group",null,null,""]
[]
["LIQUIDITY TRANSFER GROUP"]
[]
[]
[]
[]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B685),B$3=\"First registration in TARGET-Banca d'Italia\",B685<>B$372,B685<>B$384,B685<>B$396,B685<>B$318,B685<>B$330,B685<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B685),LEFT($B685,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B685,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B686),B$3=\"First registration in TARGET-Banca d'Italia\",B686<>B$372,B686<>B$384,B686<>B$396,B686<>B$318,B686<>B$330,B686<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B686),LEFT(B686,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B686,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B686),LEFT(B686,17)<>LEFT(B685,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B687),B$3=\"First registration in TARGET-Banca d'Italia\",B687<>B$372,B687<>B$384,B687<>B$396,B687<>B$318,B687<>B$330,B687<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B687),LEFT(B687,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B687,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B687),LEFT(B687,17)<>LEFT(B686,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B688),B$3=\"First registration in TARGET-Banca d'Italia\",B688<>B$372,B688<>B$384,B688<>B$396,B688<>B$318,B688<>B$330,B688<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B688),LEFT(B688,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B688,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B688),LEFT(B688,17)<>LEFT(B687,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B691),B$3=\"First registration in TARGET-Banca d'Italia\",B691<>B$372,B691<>B$384,B691<>B$396,B691<>B$318,B691<>B$330,B691<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B691),LEFT($B691,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B691,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B692),B$3=\"First registration in TARGET-Banca d'Italia\",B692<>B$372,B692<>B$384,B692<>B$396,B692<>B$318,B692<>B$330,B692<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B692),LEFT(B692,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B692,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B692),LEFT(B692,17)<>LEFT(B691,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B693),B$3=\"First registration in TARGET-Banca d'Italia\",B693<>B$372,B693<>B$384,B693<>B$396,B693<>B$318,B693<>B$330,B693<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B693),LEFT(B693,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B693,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B693),LEFT(B693,17)<>LEFT(B692,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B694),B$3=\"First registration in TARGET-Banca d'Italia\",B694<>B$372,B694<>B$384,B694<>B$396,B694<>B$318,B694<>B$330,B694<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B694),LEFT(B694,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B694,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B694),LEFT(B694,17)<>LEFT(B693,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B697),B$3=\"First registration in TARGET-Banca d'Italia\",B697<>B$372,B697<>B$384,B697<>B$396,B697<>B$318,B697<>B$330,B697<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B697),LEFT($B697,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B697,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B698),B$3=\"First registration in TARGET-Banca d'Italia\",B698<>B$372,B698<>B$384,B698<>B$396,B698<>B$318,B698<>B$330,B698<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B698),LEFT(B698,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B698,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B698),LEFT(B698,17)<>LEFT(B697,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B699),B$3=\"First registration in TARGET-Banca d'Italia\",B699<>B$372,B699<>B$384,B699<>B$396,B699<>B$318,B699<>B$330,B699<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B699),LEFT(B699,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B699,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B699),LEFT(B699,17)<>LEFT(B698,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B700),B$3=\"First registration in TARGET-Banca d'Italia\",B700<>B$372,B700<>B$384,B700<>B$396,B700<>B$318,B700<>B$330,B700<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B700),LEFT(B700,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B700,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B700),LEFT(B700,17)<>LEFT(B699,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B703),B$3=\"First registration in TARGET-Banca d'Italia\",B703<>B$372,B703<>B$384,B703<>B$396,B703<>B$318,B703<>B$330,B703<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B703),LEFT($B703,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B703,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B704),B$3=\"First registration in TARGET-Banca d'Italia\",B704<>B$372,B704<>B$384,B704<>B$396,B704<>B$318,B704<>B$330,B704<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B704),LEFT(B704,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B704,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B704),LEFT(B704,17)<>LEFT(B703,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B705),B$3=\"First registration in TARGET-Banca d'Italia\",B705<>B$372,B705<>B$384,B705<>B$396,B705<>B$318,B705<>B$330,B705<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B705),LEFT(B705,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B705,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B705),LEFT(B705,17)<>LEFT(B704,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B706),B$3=\"First registration in TARGET-Banca d'Italia\",B706<>B$372,B706<>B$384,B706<>B$396,B706<>B$318,B706<>B$330,B706<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B706),LEFT(B706,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B706,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B706),LEFT(B706,17)<>LEFT(B705,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B709),B$3=\"First registration in TARGET-Banca d'Italia\",B709<>B$372,B709<>B$384,B709<>B$396,B709<>B$318,B709<>B$330,B709<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B709),LEFT($B709,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B709,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B710),B$3=\"First registration in TARGET-Banca d'Italia\",B710<>B$372,B710<>B$384,B710<>B$396,B710<>B$318,B710<>B$330,B710<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B710),LEFT(B710,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B710,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B710),LEFT(B710,17)<>LEFT(B709,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B711),B$3=\"First registration in TARGET-Banca d'Italia\",B711<>B$372,B711<>B$384,B711<>B$396,B711<>B$318,B711<>B$330,B711<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B711),LEFT(B711,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B711,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B711),LEFT(B711,17)<>LEFT(B710,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B712),B$3=\"First registration in TARGET-Banca d'Italia\",B712<>B$372,B712<>B$384,B712<>B$396,B712<>B$318,B712<>B$330,B712<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B712),LEFT(B712,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B712,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B712),LEFT(B712,17)<>LEFT(B711,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B715),B$3=\"First registration in TARGET-Banca d'Italia\",B715<>B$372,B715<>B$384,B715<>B$396,B715<>B$318,B715<>B$330,B715<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B715),LEFT($B715,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B715,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B716),B$3=\"First registration in TARGET-Banca d'Italia\",B716<>B$372,B716<>B$384,B716<>B$396,B716<>B$318,B716<>B$330,B716<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B716),LEFT(B716,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B716,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B716),LEFT(B716,17)<>LEFT(B715,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B717),B$3=\"First registration in TARGET-Banca d'Italia\",B717<>B$372,B717<>B$384,B717<>B$396,B717<>B$318,B717<>B$330,B717<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B717),LEFT(B717,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B717,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B717),LEFT(B717,17)<>LEFT(B716,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B718),B$3=\"First registration in TARGET-Banca d'Italia\",B718<>B$372,B718<>B$384,B718<>B$396,B718<>B$318,B718<>B$330,B718<>B$341),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B718),LEFT(B718,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B718,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B718),LEFT(B718,17)<>LEFT(B717,17)),\"Error: only cash account of the same type (MCA/RTGS DCA) can be included in an LTG\",\"\")\n)\n)","v":""}]
[]
["9. AS PROCEDURES (Only for Ancillary Systems)",null,null,{"$f":"IF(COUNTBLANK(D721:D750)=30,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B727),OR(B726=\"A\",B726=\"B\",B726=\"C\",B726=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B727),LEFT(B727,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B728),IF(OR(B726=\"C\",B726=\"D\",B726=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B728,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B732),OR(B731=\"A\",B731=\"B\",B731=\"C\",B731=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B732),LEFT(B732,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B733),IF(OR(B731=\"C\",B731=\"D\",B731=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B733,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B737),OR(B736=\"A\",B736=\"B\",B736=\"C\",B736=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B737),LEFT(B737,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B738),IF(OR(B736=\"C\",B736=\"D\",B736=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B738,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B742),OR(B741=\"A\",B741=\"B\",B741=\"C\",B741=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B742),LEFT(B742,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B743),IF(OR(B741=\"C\",B741=\"D\",B741=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B743,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B747),OR(B746=\"A\",B746=\"B\",B746=\"C\",B746=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B747),LEFT(B747,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B748),IF(OR(B746=\"C\",B746=\"D\",B746=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B748,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["10. ADMINISTRATOR USERS",null,null,{"$f":"IF(COUNTBLANK(D752:D766)=15,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
["Name",null,null,{"$f":"IF(AND(ISBLANK(B757),B$3=\"First registration in TARGET-Banca d'Italia\",LEFT(B58,2)<>\"No\"),\"Mandatory field\",\"\")","v":""}]
["Login Name (System User Reference)",null,null,{"$f":"IF(AND(ISTEXT(B757),ISBLANK(B758)),\"Mandatory field\",\nIF(AND(ISTEXT($B$4),ISTEXT($B758)),\nIF(LEFT($B758,14)<>CONCATENATE(\"AIT\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\"))","v":""}]
["Certificate Distinguished Name ",null,null,{"$f":"IF(AND(ISTEXT(B757),ISBLANK(B759)),\"Mandatory field\",\nIF(ISNUMBER(FIND(\"cn=\",B759)),\"Error: the qualifier 'CN' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"ou=\",B759)),\"Error: the qualifier 'OU' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"o=\",B759)),\"Error: the qualifier 'O' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"dc=\",B759)),\"Error: the qualifier 'DC' must be entered uppercase\",\n IF(OR(LEN(SUBSTITUTE(B759,\", \",\",\"))<>LEN(SUBSTITUTE(B759,\",\",\"\")),ISNUMBER(SEARCH(\",  \",B759))),\"Error: insert a space after each comma\",\n\"\")))))\n)","v":""}]
["Main User (only required for accessing TIPS GUI)",null,null,{"$f":"IF(AND(ISTEXT(B757),ISBLANK(B760)),\"Mandatory field\",\"\")","v":""}]
[]
["Name"]
["Login Name (System User Reference)",null,null,{"$f":"IF(AND(ISTEXT(B762),ISBLANK(B763)),\"Mandatory field\",\nIF(AND(ISTEXT($B$4),ISTEXT($B763)),\nIF(LEFT($B763,14)<>CONCATENATE(\"AIT\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\"))","v":""}]
["Certificate Distinguished Name ",null,null,{"$f":"IF(AND(ISTEXT(B762),ISBLANK(B764)),\"Mandatory field\",\nIF(ISNUMBER(FIND(\"cn=\",B764)),\"Error: the qualifier 'CN' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"ou=\",B764)),\"Error: the qualifier 'OU' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"o=\",B764)),\"Error: the qualifier 'O' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"dc=\",B764)),\"Error: the qualifier 'DC' must be entered uppercase\",\n IF(OR(LEN(SUBSTITUTE(B764,\", \",\",\"))<>LEN(SUBSTITUTE(B764,\",\",\"\")),ISNUMBER(SEARCH(\",  \",B764))),\"Error: insert a space after each comma\",\n\"\")))))\n)","v":""}]
["Main User (only required for accessing TIPS GUI)",null,null,{"$f":"IF(AND(ISTEXT(B762),ISBLANK(B765)),\"Mandatory field\",\"\")","v":""}]
[]
["11. INVOICE CONFIGURATION",null,null,{"$f":"IF(COUNTBLANK(D768:D784)=17,\"This section is correct\",\"Warning: There are errors or missing fields. Check the messages in this section\")","v":"This section is correct"}]
[]
[]
[]
[]
[]
[]
["RTGS Pricing scheme options (only for RTGS DCA owners)",null,null,{"$f":"IF(AND(ISBLANK(B774),B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT(B372),ISTEXT(B384),ISTEXT(B396),B19<>\"Payment Bank\")),\"Mandatory field\",\nIF(AND(ISTEXT(B774),B19=\"Payment Bank\",LEFT(B774)<>\"C\"),\"Error: option not allowed for Payment Banks\",\nIF(AND(ISTEXT(B774),LEFT(B19)=\"A\",LEFT(B774)=\"C\"),\"Error: option not allowed for Ancillary Systems\",\"\")\n))","v":""}]
["MCA to be debited",null,null,{"$f":"IF(AND(ISBLANK(B775),B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT(B$372),ISTEXT(B$384),ISTEXT(B$396),ISTEXT(B$426),ISTEXT(B$433),ISTEXT(B$440),ISTEXT(B$449),ISTEXT(B$459),ISTEXT(B$469))),\"Mandatory field\",\nIF(AND(ISTEXT(B775),LEFT(B775,6)<>\"MITEUR\"),\"Error: wrong account number\",\"\")\n)","v":""}]
["Invoice Street",null,null,{"$f":"IF(AND(ISBLANK(B776),B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT(B$372),ISTEXT(B$384),ISTEXT(B$396),ISTEXT(B$426),ISTEXT(B$433),ISTEXT(B$440),ISTEXT(B$449),ISTEXT(B$459),ISTEXT(B$469))),\"Mandatory field\",\"\")","v":""}]
["Invoice House Number",null,null,""]
["Invoice Country Code",null,null,""]
["Invoice City",null,null,""]
["Invoice Postal Code",null,null,""]
["Invoice State Or Province",null,null,""]
["Invoice Phone Number"]
["Invoice Fax Number"]
["Invoice Email Address"]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Foglio2","index":2,"n_rows":87,"n_cols":1,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
[]
["Environment"]
["Production"]
["UTEST - Pre-production"]
[]
[]
["Party Type"]
["Payment Bank"]
["Ancillary System - Central Counterparties"]
["Ancillary System - Foreign Exchange Settlement Systems"]
["Ancillary System - High value payment system"]
["Ancillary System - Instant Payment System"]
["Ancillary System - Money Market Settlement Systems"]
["Ancillary System - Retail Payment System"]
["Ancillary System - Security Settlement System"]
["Ancillary System - Other"]
[]
["YES/NO"]
["YES"]
["NO"]
[]
[]
["Minimum Reserve"]
["Direct"]
["Indirect"]
["No"]
[]
[]
["2/4-Eyes"]
[]
["2-Eyes"]
["4-Eyes"]
[]
[]
["2-Eyes only"]
[]
["2-Eyes"]
[]
[]
["4-Eyes only"]
[]
["4-Eyes"]
[]
["AAU Type"]
["RTGS Addressable BIC – Branch of Direct Participant"]
["RTGS Addressable BIC - Correspondent"]
["RTGS Addressable BIC – Branch of Correspondent"]
["RTGS Multi Addressee – Branch of Direct Participant"]
["RTGS Multi Addressee – Credit Institution"]
["T2S Primary CMB Authorised BIC"]
["TIPS AAU/Reachable Party"]
["Excluded BIC from a Wildcard Pattern"]
[]
[]
["AS Procedures"]
["A"]
["B"]
["C"]
["D"]
["E"]
[]
[]
["Single/Global Notification"]
["Single Notification"]
["Global Notification"]
[]
[]
["Pricing Scheme"]
["Core scheme - Option A"]
["Core scheme - Option B"]
["AS with banking activity - Option A"]
["AS with banking activity - Option B"]
["AS without banking activity - Option A"]
["AS without banking activity - Option B"]
[]
[]
["Type of request"]
["First registration in TARGET-Banca d'Italia"]
["New/Add"]
["Modify"]
["Delete"]
[]
[]
["ESMIG connectivity type"]
["Both A2A and U2A"]
["U2A Only"]
["No connectivity (only for particpants with co-managed MCA and no DCAs)"]