{"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":123,"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","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\". In case of first registration, Banca d'Italia will proceed with the creation of the A2A user in CRDM with the Login Name indicated in this field"]
["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 A2A user8"]
["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 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":775,"n_cols":4,"rows_kept":775,"cut":false,"hidden":false,"merged":[[757,0,757,1],[741,0,741,1],[606,0,606,1],[616,0,616,1],[626,0,626,1],[668,0,668,1],[710,0,710,1],[219,0,220,0],[221,0,222,0],[223,0,224,0],[225,0,225,1],[600,0,600,1],[573,0,573,1],[455,0,455,1],[471,0,471,1],[209,0,210,0],[211,0,212,0],[213,0,214,0],[215,0,216,0],[217,0,218,0],[184,0,185,0],[186,0,186,1],[199,0,199,1],[206,0,206,1],[207,0,208,0],[167,0,176,0],[177,0,177,1],[178,0,179,0],[180,0,181,0],[182,0,183,0],[158,0,158,1],[159,0,160,0],[161,0,162,0],[163,0,164,0],[165,0,165,1],[141,0,141,1],[151,0,151,1],[152,0,153,0],[154,0,155,0],[156,0,157,0],[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],[49,0,49,1],[301,0,301,1],[43,0,43,1],[229,0,229,1],[400,0,400,1],[384,0,384,1],[337,0,337,1],[59,0,59,1],[79,0,80,0],[67,0,67,1],[74,0,74,1],[81,0,81,1],[93,0,93,1],[100,0,101,0],[98,0,99,0],[96,0,97,0],[0,0,0,1],[1,0,1,1],[9,0,9,1],[15,0,15,1],[26,0,26,1],[776,0,776,1],[774,0,774,1],[55,0,55,1],[295,0,295,1],[83,0,92,0],[68,0,69,0],[70,0,71,0],[72,0,73,0],[75,0,76,0],[77,0,78,0],[487,0,487,1],[346,0,346,1],[423,0,423,1],[94,0,95,0],[102,0,102,1],[115,0,115,1]]}
["TARGET Registration Form - Banca d'Italia"]
["1. REGISTRATION INFORMATION",null,"FORM CHECK:",{"$f":"IF(COUNTBLANK(D3:D774)=ROWS(D3:D774)-10,\"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)=ROWS(D11:D49),\"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:D229)=ROWS(D51:D229),\"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:B144)=82,COUNTBLANK(B152:B229)=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(B168),OR(ISTEXT(B$407),ISTEXT(B$414),ISTEXT(B$421))),\"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,""]
[]
[]
[]
[]
[]
[]
["NEXI NETWORK SERVICE","TECHNICAL ADDRESS USED FOR SENDING/RECEIVING MESSAGES IN A2A MODE"]
["CLM",null,null,{"$f":"IF(AND(ISTEXT(B152),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(B153),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(B154),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(B159),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(B160),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(B161),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(B225),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,""]
["4. PARTY ROLES",null,null,{"$f":"IF(COUNTBLANK(D231:D295)=ROWS(D231:D295),\"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(B241),\"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$748)),IF(ISBLANK(B241),\"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(B242),\"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$748)),IF(ISBLANK(B242),\"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(B247),\"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$748)),IF(ISBLANK(B247),\"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(B248),\"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$748)),IF(ISBLANK(B248),\"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 Manager",null,null,{"$f":"IF(AND(ISTEXT(B260),OR(ISTEXT(B261),ISTEXT(B262))),\"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(B261),ISTEXT(B260)),\"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(B262),ISTEXT(B260)),\"Error: AH RTGS Inter-bank CT U2A is incompatible with AH RTGS Backup Payment Manager\",\"\")","v":""}]
["AH RTGS Limit/Reservation Manager"]
["AH RTGS Liquidity Transfer Manager",null,null,{"$f":"IF(AND(OR(ISTEXT(B353),ISTEXT(B365),ISTEXT(B377)),ISBLANK(B264),$B$3<>\"Delete\"),\"Mandatory field\",\"\")","v":""}]
["AH RTGS Payment Manager",null,null,{"$f":"IF(AND(OR(ISTEXT(B353),ISTEXT(B365),ISTEXT(B377)),ISBLANK(B265),$B$3<>\"Delete\"),\"Mandatory field\",\"\")","v":""}]
["AH RTGS Reader",null,null,{"$f":"IF(AND(OR(ISTEXT(B353),ISTEXT(B365),ISTEXT(B377)),ISBLANK(B266),$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(B430),ISTEXT(B440),ISTEXT(B450)),ISBLANK(B280)),\"Mandatory field\",\"\")","v":""}]
["AH T2S Reader",null,null,{"$f":"IF(AND(OR(ISTEXT(B430),ISTEXT(B440),ISTEXT(B450)),ISBLANK(B281)),\"Mandatory field\",\"\")","v":""}]
[]
[]
[]
["AH Instant Payment Manager (A2A only)",null,null,{"$f":"IF(AND(OR(ISTEXT(B407),ISTEXT(B414),ISTEXT(B421)),ISBLANK(B285)),\"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(B407),ISTEXT(B414),ISTEXT(B421)),ISBLANK(B289)),\"Mandatory field\",\"\")","v":""}]
["AH TIPS Party Query",null,null,{"$f":"IF(AND(OR(ISTEXT(B407),ISTEXT(B414),ISTEXT(B421)),ISBLANK(B290)),\"Mandatory field\",\"\")","v":""}]
["AH TIPS Reachable Party Query"]
["AH TIPS Broadcast Manager",null,null,{"$f":"IF(AND(OR(ISTEXT(B407),ISTEXT(B414),ISTEXT(B421)),ISBLANK(B292)),\"Mandatory field\",\"\")","v":""}]
["AH TIPS Broadcast Reader",null,null,{"$f":"IF(AND(OR(ISTEXT(B407),ISTEXT(B414),ISTEXT(B421)),ISBLANK(B293)),\"Mandatory field\",\"\")","v":""}]
[]
[]
["5. CASH ACCOUNTS",null,null,{"$f":"IF(COUNTBLANK(D297:D487)=ROWS(D297:D487),\"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(B308),\"Mandatory field\",IF(LEFT($B308,17)<>CONCATENATE(\"MITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),IF(AND(ISTEXT(B308),LEFT($B308,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(B309),\"Mandatory field\",IF(LEN(B309)<>11,\"Error: enter a 11-digit BIC\",\"\")),IF(AND(ISTEXT(B308),ISBLANK(B309)),\"Mandatory field\",IF(AND(ISTEXT(B309),LEN(B309)<>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(B310),\"Mandatory field\",IF(AND(B310=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",\"\")),IF(AND(ISTEXT(B308),ISBLANK(B310)),\"Mandatory field\",IF(AND(B310=\"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(B308),ISBLANK(B311)),\"Mandatory field\",\nIF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B308),B311=\"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(B311=\"YES\",ISBLANK(B312)),\"Mandatory field\",IF(AND(B311=\"YES\",ISTEXT(B312)),IF(LEN(B312)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B311=\"NO\",ISTEXT(B312)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["Co-manager Party BIC",null,null,{"$f":"IF(AND(B311=\"YES\",ISBLANK(B313)),\"Mandatory field\",IF(AND(B311=\"YES\",ISTEXT(B313)),IF(LEN(B313)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B311=\"NO\",ISTEXT(B313)),\"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($B353),ISTEXT($B365),ISTEXT($B377))),\nIF(ISBLANK($B314), \"This field is mandatory if you own an RTGS DCA\",IF(AND(B314<>B353,B314<>B365,B314<>B377),\"Error: The RTGS account does not match the ones defined below\",\"\")),\nIF(ISTEXT(B314),\nIF(LEFT($B314,17)<>CONCATENATE(\"RITEUR\",$B$4),\"Error: wrong RTGS DCA account number\",\"\"),\nIF(AND(OR($B$3=\"New/Add\",$B$3=\"Modify\"),OR(ISTEXT($B353),ISTEXT($B365),ISTEXT($B377))),\n\"This field is mandatory if you own an RTGS DCA\",\"\"))\n)","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B320),B320=B308),\"Error: account number already defined\",IF(AND(ISTEXT(B320),LEFT($B320,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B320),ISBLANK(B321)),\"Mandatory field\",IF(AND(ISTEXT(B321),LEN(B321)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B321),OR(B321=B$309,B321=B$332)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B322=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B320),ISBLANK(B322)),\"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(B320),ISBLANK(B323)),\"Mandatory field\",\nIF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B320),B323=\"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(B323=\"YES\",ISBLANK(B324)),\"Mandatory field\",IF(AND(B323=\"YES\",ISTEXT(B324)),IF(LEN(B324)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B323=\"NO\",ISTEXT(B324)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["Co-manager Party BIC",null,null,{"$f":"IF(AND(B323=\"YES\",ISBLANK(B325)),\"Mandatory field\",IF(AND(B323=\"YES\",ISTEXT(B325)),IF(LEN(B325)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B323=\"NO\",ISTEXT(B325)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B331),OR(B331=B320,B331=B308)),\"Error: account number already defined\",IF(AND(ISTEXT(B331),LEFT($B331,17)<>CONCATENATE(\"MITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B331),ISBLANK(B332)),\"Mandatory field\",IF(AND(ISTEXT(B332),LEN(B332)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B332),OR(B332=B$309,B332=B$321)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B333=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B331),ISBLANK(B333)),\"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(B331),ISBLANK(B334)),\"Mandatory field\",\nIF(AND(B$58=\"No connectivity (only for particpants with co-managed MCA and no DCAs)\",ISTEXT(B331),B334=\"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(B334=\"YES\",ISBLANK(B335)),\"Mandatory field\",IF(AND(B334=\"YES\",ISTEXT(B335)),IF(LEN(B335)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B334=\"NO\",ISTEXT(B335)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
["Co-manager Party BIC",null,null,{"$f":"IF(AND(B334=\"YES\",ISBLANK(B336)),\"Mandatory field\",IF(AND(B334=\"YES\",ISTEXT(B336)),IF(LEN(B336)<>11,\"Error: enter a 11-digit BIC\",\"\"),IF(AND(B334=\"NO\",ISTEXT(B336)),\"If you select Co-managed = NO, leave this field blank\",\"\")))","v":""}]
[]
["OVERNIGHT DEPOSIT ACCOUNT"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B344),IF(LEFT($B344,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(B344),ISBLANK(B345)),\"Mandatory field\",IF(AND(ISTEXT(B345),B345<>B308),\"Error: enter the Default MCA Number defined in field B318\",\"\")),\nIF(AND(ISTEXT(B344),ISBLANK(B345)),\"Mandatory field\",IF(AND(ISTEXT(B345),LEFT(B345,17)<>CONCATENATE(\"MITEUR\",B$4)),\"Error: wrong account number\",\"\"))\n)","v":""}]
[]
["RTGS DCAs"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B353),IF(LEFT($B353,17)<>CONCATENATE(\"RITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B353),ISBLANK(B354)),\"Mandatory field\",IF(AND(ISTEXT(B354),LEN(B354)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B355=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B353),ISBLANK(B355)),\"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(B353),B365=B353),\"Error: account number already defined\",IF(AND(ISTEXT(B365),LEFT($B365,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B365),ISBLANK(B366)),\"Mandatory field\",IF(AND(ISTEXT(B366),LEN(B366)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B366),OR(B366=B354,B366=B378)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B367=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B365),ISBLANK(B367)),\"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(B377),OR(B377=B365,B377=B353)),\"Error: account number already defined\",IF(AND(ISTEXT(B377),LEFT($B377,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B377),ISBLANK(B378)),\"Mandatory field\",IF(AND(ISTEXT(B378),LEN(B378)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B378),OR(B378=B354,B378=B366)),\"Error: account BIC already defined\",\"\")))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B379=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B377),ISBLANK(B379)),\"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($B391)),IF(LEFT($B391,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($B392)),\nIF(AND($B392<>$B353,$B392<>$B365,$B392<>$B377),\"Error: Enter an RTGS DCA account from those defined\",\"\"),\nIF(AND(ISTEXT($B391),ISBLANK(B392)),\"Mandatory field\",\"\"))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B398),B398=B391),\"Error: account number already defined\",IF(AND(ISTEXT(B398),LEFT($B398,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($B399)),\nIF(AND($B399<>$B353,$B399<>$B365,$B399<>$B377),\"Error: Enter an RTGS DCA account from those defined\",IF(AND(ISTEXT(B399),B399=B392),\"Error: it is not pssible to link more RTGS Sub-accounts to the same RTGS DCA\",\"\")),\nIF(AND(ISTEXT($B398),ISBLANK(B399)),\"Mandatory field\",IF(AND(ISTEXT(B399),B399=B392),\"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($B407),IF(LEFT($B407,17)<>CONCATENATE(\"IITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B408=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B407),ISBLANK(B408)),\"Mandatory field\",\"\"))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B414),B414=B407),\"Error: account number already defined\",IF(AND(ISTEXT(B414),LEFT($B414,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B415=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B414),ISBLANK(B415)),\"Mandatory field\",\"\"))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(AND(ISTEXT(B421),OR(B421=B407,B421=B414)),\"Error: account number already defined\",IF(AND(ISTEXT(B421),LEFT($B421,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B422=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B421),ISBLANK(B422)),\"Mandatory field\",\"\"))","v":""}]
[]
["T2S DCAs"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B430),IF(LEFT($B430,17)<>CONCATENATE(\"CITEUR\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\")","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B431=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B430),ISBLANK(B431)),\"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(B440),B440=B430),\"Error: account number already defined\",IF(AND(ISTEXT(B440),LEFT($B440,17)<>CONCATENATE(\"CITEUR\",$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":""}]
["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(B450),OR(B450=B430,B450=B440)),\"Error: account number already defined\",IF(AND(ISTEXT(B450),LEFT($B450,17)<>CONCATENATE(\"CITEUR\",$B$4)),\"Attention: naming convention not respected\",\"\"))","v":""}]
["Account to be included for Minimum Reserve Calculation",null,null,{"$f":"IF(AND(B451=\"YES\",OR(B$46=\"Indirect\",B$46=\"No\")),\"Error: 'YES' is not allowed if you select 'Indirect/No' in field B46\",IF(AND(ISTEXT(B450),ISBLANK(B451)),\"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($B462),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B462,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B462),ISBLANK(B463)),\"Mandatory field\",IF(AND(ISTEXT(B463),LEN(B463)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B463),OR(B463=B$354,B463=B$378)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B469),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B469,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B469),ISBLANK(B470)),\"Mandatory field\",IF(AND(ISTEXT(B470),LEN(B470)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B470),OR(B470=B$354,B470=B$378,B470=B$463)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
["AS GUARANTEE FUNDS ACCOUNTS (Only for Ancillary System)"]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B478),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B478,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B478),ISBLANK(B479)),\"Mandatory field\",IF(AND(ISTEXT(B479),LEN(B479)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B479),OR(B479=B$354,B479=B$378,B479=B$463,B479=B$470)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
[]
[]
[]
[]
["Cash Account Number",null,null,{"$f":"IF(ISTEXT($B485),IF(B$19=\"Payment Bank\",\"Error: only Ancillary Systems are allowed to open AS Technical Accounts\",IF(LEFT($B485,17)<>CONCATENATE(\"TITEUR\",$B$4),\"Attention: naming convention not respected\",\"\")),\"\")","v":""}]
["Account BIC",null,null,{"$f":"IF(AND(ISTEXT(B485),ISBLANK(B486)),\"Mandatory field\",IF(AND(ISTEXT(B486),LEN(B486)<>11),\"Error: enter a 11-digit BIC\",IF(AND(ISTEXT(B486),OR(B486=B$354,B486=B$378,B486=B$463,B486=B$470,B486=B$479)),\"Error: BIC already defined as Account BIC\",\"\")))","v":""}]
[]
["6. AUTHORISED ACCOUNT USERS",null,null,{"$f":"IF(COUNTBLANK(D489:D573)=ROWS(D489:D573),\"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(B494),OR(ISTEXT(B407),ISTEXT(B414),ISTEXT(B421))),\"Mandatory field\",\nIF(AND(ISTEXT(B494),LEFT(B496,4)=\"TIPS\",LEN(B494)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B494),LEFT(B495,6)=\"RITEUR\",OR(B494=B$354,B494=B$366,B494=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B494),ISBLANK(B495)),\"Mandatory field\",\nIF(AND(ISTEXT($B495),B$3=\"First registration in TARGET-Banca d'Italia\",B495<>B$353,B495<>B$365,B495<>B$377,B495<>B$407,B495<>B$414,B495<>B$421,B495<>B$430,B495<>B$440,B495<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B495),LEFT($B495,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B495,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B495,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B494),ISBLANK(B496)),\"Mandatory field\",\n  IF(AND(ISTEXT(B494),LEFT(B495,6)=\"RITEUR\",AND(LEFT(B496,4)<>\"RTGS\",LEFT(B496,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B494),LEFT(B495,6)=\"CITEUR\",AND(LEFT(B496,3)<>\"T2S\",LEFT(B496,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B494),LEFT(B495,6)=\"IITEUR\",LEFT(B496,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(B497),B496<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B497),B496=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B497),B496=\"TIPS AAU/Reachable Party\",B497<>B$84,B497<>B$85,B497<>B$86,B497<>B$87,B497<>B$88,B497<>B$89,B497<>B$90,B497<>B$91,B497<>B$92,B497<>B$93,B497<>B$168,B497<>B$169,B497<>B$170,B497<>B$171,B497<>B$172,B497<>B$173,B497<>B$174,B497<>B$175,B497<>B$176,B497<>B$177),\"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(B498),B496<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B498),B496=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B499),B$496<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B500),B496<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B500),B496=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B502),LEFT(B504,4)=\"TIPS\",LEN(B502)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B502),LEFT(B503,6)=\"RITEUR\",OR(B502=B$354,B502=B$366,B502=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B502),ISBLANK(B503)),\"Mandatory field\",\nIF(AND(ISTEXT($B503),B$3=\"First registration in TARGET-Banca d'Italia\",B503<>B$353,B503<>B$365,B503<>B$377,B503<>B$407,B503<>B$414,B503<>B$421,B503<>B$430,B503<>B$440,B503<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B503),LEFT($B503,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B503,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B503,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B502),ISBLANK(B504)),\"Mandatory field\",\n  IF(AND(ISTEXT(B502),LEFT(B503,6)=\"RITEUR\",AND(LEFT(B504,4)<>\"RTGS\",LEFT(B504,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B502),LEFT(B503,6)=\"CITEUR\",AND(LEFT(B504,3)<>\"T2S\",LEFT(B504,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B502),LEFT(B503,6)=\"IITEUR\",LEFT(B504,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(B505),B504<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B505),B504=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B505),B504=\"TIPS AAU/Reachable Party\",B505<>B$84,B505<>B$85,B505<>B$86,B505<>B$87,B505<>B$88,B505<>B$89,B505<>B$90,B505<>B$91,B505<>B$92,B505<>B$93,B505<>B$168,B505<>B$169,B505<>B$170,B505<>B$171,B505<>B$172,B505<>B$173,B505<>B$174,B505<>B$175,B505<>B$176,B505<>B$177),\"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(B506),B504<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B506),B504=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B507),B504<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B508),B504<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B508),B504=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B510),LEFT(B512,4)=\"TIPS\",LEN(B510)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B510),LEFT(B511,6)=\"RITEUR\",OR(B510=B$354,B510=B$366,B510=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B510),ISBLANK(B511)),\"Mandatory field\",\nIF(AND(ISTEXT($B511),B$3=\"First registration in TARGET-Banca d'Italia\",B511<>B$353,B511<>B$365,B511<>B$377,B511<>B$407,B511<>B$414,B511<>B$421,B511<>B$430,B511<>B$440,B511<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B511),LEFT($B511,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B511,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B511,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B510),ISBLANK(B512)),\"Mandatory field\",\n  IF(AND(ISTEXT(B510),LEFT(B511,6)=\"RITEUR\",AND(LEFT(B512,4)<>\"RTGS\",LEFT(B512,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B510),LEFT(B511,6)=\"CITEUR\",AND(LEFT(B512,3)<>\"T2S\",LEFT(B512,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B510),LEFT(B511,6)=\"IITEUR\",LEFT(B512,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(B513),B512<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B513),B512=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B513),B512=\"TIPS AAU/Reachable Party\",B513<>B$84,B513<>B$85,B513<>B$86,B513<>B$87,B513<>B$88,B513<>B$89,B513<>B$90,B513<>B$91,B513<>B$92,B513<>B$93,B513<>B$168,B513<>B$169,B513<>B$170,B513<>B$171,B513<>B$172,B513<>B$173,B513<>B$174,B513<>B$175,B513<>B$176,B513<>B$177),\"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(B514),B512<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B514),B512=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B515),B512<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B516),B512<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B516),B512=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B518),LEFT(B520,4)=\"TIPS\",LEN(B518)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B518),LEFT(B519,6)=\"RITEUR\",OR(B518=B$354,B518=B$366,B518=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B518),ISBLANK(B519)),\"Mandatory field\",\nIF(AND(ISTEXT($B519),B$3=\"First registration in TARGET-Banca d'Italia\",B519<>B$353,B519<>B$365,B519<>B$377,B519<>B$407,B519<>B$414,B519<>B$421,B519<>B$430,B519<>B$440,B519<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B519),LEFT($B519,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B519,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B519,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B518),ISBLANK(B520)),\"Mandatory field\",\n  IF(AND(ISTEXT(B518),LEFT(B519,6)=\"RITEUR\",AND(LEFT(B520,4)<>\"RTGS\",LEFT(B520,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B518),LEFT(B519,6)=\"CITEUR\",AND(LEFT(B520,3)<>\"T2S\",LEFT(B520,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B518),LEFT(B519,6)=\"IITEUR\",LEFT(B520,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(B521),B520<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B521),B520=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B521),B520=\"TIPS AAU/Reachable Party\",B521<>B$84,B521<>B$85,B521<>B$86,B521<>B$87,B521<>B$88,B521<>B$89,B521<>B$90,B521<>B$91,B521<>B$92,B521<>B$93,B521<>B$168,B521<>B$169,B521<>B$170,B521<>B$171,B521<>B$172,B521<>B$173,B521<>B$174,B521<>B$175,B521<>B$176,B521<>B$177),\"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(B522),B520<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B522),B520=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B523),B520<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B524),B520<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B524),B520=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B526),LEFT(B528,4)=\"TIPS\",LEN(B526)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B526),LEFT(B527,6)=\"RITEUR\",OR(B526=B$354,B526=B$366,B526=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B526),ISBLANK(B527)),\"Mandatory field\",\nIF(AND(ISTEXT($B527),B$3=\"First registration in TARGET-Banca d'Italia\",B527<>B$353,B527<>B$365,B527<>B$377,B527<>B$407,B527<>B$414,B527<>B$421,B527<>B$430,B527<>B$440,B527<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B527),LEFT($B527,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B527,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B527,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B526),ISBLANK(B528)),\"Mandatory field\",\n  IF(AND(ISTEXT(B526),LEFT(B527,6)=\"RITEUR\",AND(LEFT(B528,4)<>\"RTGS\",LEFT(B528,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B526),LEFT(B527,6)=\"CITEUR\",AND(LEFT(B528,3)<>\"T2S\",LEFT(B528,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B526),LEFT(B527,6)=\"IITEUR\",LEFT(B528,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(B529),B528<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B529),B528=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B529),B528=\"TIPS AAU/Reachable Party\",B529<>B$84,B529<>B$85,B529<>B$86,B529<>B$87,B529<>B$88,B529<>B$89,B529<>B$90,B529<>B$91,B529<>B$92,B529<>B$93,B529<>B$168,B529<>B$169,B529<>B$170,B529<>B$171,B529<>B$172,B529<>B$173,B529<>B$174,B529<>B$175,B529<>B$176,B529<>B$177),\"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(B530),B528<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B530),B528=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B531),B528<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B532),B528<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B532),B528=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","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$354,B534=B$366,B534=B$378)),\"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$353,B535<>B$365,B535<>B$377,B535<>B$407,B535<>B$414,B535<>B$421,B535<>B$430,B535<>B$440,B535<>B$450),\"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$168,B537<>B$169,B537<>B$170,B537<>B$171,B537<>B$172,B537<>B$173,B537<>B$174,B537<>B$175,B537<>B$176,B537<>B$177),\"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":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B540),B536<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B540),B536=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B542),LEFT(B544,4)=\"TIPS\",LEN(B542)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B542),LEFT(B543,6)=\"RITEUR\",OR(B542=B$354,B542=B$366,B542=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B542),ISBLANK(B543)),\"Mandatory field\",\nIF(AND(ISTEXT($B543),B$3=\"First registration in TARGET-Banca d'Italia\",B543<>B$353,B543<>B$365,B543<>B$377,B543<>B$407,B543<>B$414,B543<>B$421,B543<>B$430,B543<>B$440,B543<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B543),LEFT($B543,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B543,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B543,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B542),ISBLANK(B544)),\"Mandatory field\",\n  IF(AND(ISTEXT(B542),LEFT(B543,6)=\"RITEUR\",AND(LEFT(B544,4)<>\"RTGS\",LEFT(B544,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B542),LEFT(B543,6)=\"CITEUR\",AND(LEFT(B544,3)<>\"T2S\",LEFT(B544,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B542),LEFT(B543,6)=\"IITEUR\",LEFT(B544,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(B545),B544<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B545),B544=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B545),B544=\"TIPS AAU/Reachable Party\",B545<>B$84,B545<>B$85,B545<>B$86,B545<>B$87,B545<>B$88,B545<>B$89,B545<>B$90,B545<>B$91,B545<>B$92,B545<>B$93,B545<>B$168,B545<>B$169,B545<>B$170,B545<>B$171,B545<>B$172,B545<>B$173,B545<>B$174,B545<>B$175,B545<>B$176,B545<>B$177),\"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(B546),B544<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B546),B544=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B547),B544<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B548),B544<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B548),B544=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B550),LEFT(B552,4)=\"TIPS\",LEN(B550)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B550),LEFT(B551,6)=\"RITEUR\",OR(B550=B$354,B550=B$366,B550=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B550),ISBLANK(B551)),\"Mandatory field\",\nIF(AND(ISTEXT($B551),B$3=\"First registration in TARGET-Banca d'Italia\",B551<>B$353,B551<>B$365,B551<>B$377,B551<>B$407,B551<>B$414,B551<>B$421,B551<>B$430,B551<>B$440,B551<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B551),LEFT($B551,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B551,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B551,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B550),ISBLANK(B552)),\"Mandatory field\",\n  IF(AND(ISTEXT(B550),LEFT(B551,6)=\"RITEUR\",AND(LEFT(B552,4)<>\"RTGS\",LEFT(B552,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B550),LEFT(B551,6)=\"CITEUR\",AND(LEFT(B552,3)<>\"T2S\",LEFT(B552,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B550),LEFT(B551,6)=\"IITEUR\",LEFT(B552,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(B553),B552<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B553),B552=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B553),B552=\"TIPS AAU/Reachable Party\",B553<>B$84,B553<>B$85,B553<>B$86,B553<>B$87,B553<>B$88,B553<>B$89,B553<>B$90,B553<>B$91,B553<>B$92,B553<>B$93,B553<>B$168,B553<>B$169,B553<>B$170,B553<>B$171,B553<>B$172,B553<>B$173,B553<>B$174,B553<>B$175,B553<>B$176,B553<>B$177),\"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(B554),B552<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B554),B552=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B555),B552<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B556),B552<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B556),B552=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B558),LEFT(B560,4)=\"TIPS\",LEN(B558)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B558),LEFT(B559,6)=\"RITEUR\",OR(B558=B$354,B558=B$366,B558=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B558),ISBLANK(B559)),\"Mandatory field\",\nIF(AND(ISTEXT($B559),B$3=\"First registration in TARGET-Banca d'Italia\",B559<>B$353,B559<>B$365,B559<>B$377,B559<>B$407,B559<>B$414,B559<>B$421,B559<>B$430,B559<>B$440,B559<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B559),LEFT($B559,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B559,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B559,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B558),ISBLANK(B560)),\"Mandatory field\",\n  IF(AND(ISTEXT(B558),LEFT(B559,6)=\"RITEUR\",AND(LEFT(B560,4)<>\"RTGS\",LEFT(B560,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B558),LEFT(B559,6)=\"CITEUR\",AND(LEFT(B560,3)<>\"T2S\",LEFT(B560,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B558),LEFT(B559,6)=\"IITEUR\",LEFT(B560,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(B561),B560<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B561),B560=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B561),B560=\"TIPS AAU/Reachable Party\",B561<>B$84,B561<>B$85,B561<>B$86,B561<>B$87,B561<>B$88,B561<>B$89,B561<>B$90,B561<>B$91,B561<>B$92,B561<>B$93,B561<>B$168,B561<>B$169,B561<>B$170,B561<>B$171,B561<>B$172,B561<>B$173,B561<>B$174,B561<>B$175,B561<>B$176,B561<>B$177),\"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(B562),B560<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B562),B560=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B563),B560<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B564),B560<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B564),B560=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["Authorised Account User BIC",null,null,{"$f":"IF(AND(ISTEXT(B566),LEFT(B568,4)=\"TIPS\",LEN(B566)<>11),\"Error: enter a 11-digit BIC\",\nIF(AND(ISTEXT(B566),LEFT(B567,6)=\"RITEUR\",OR(B566=B$354,B566=B$366,B566=B$378)),\"Error: BIC already defined as RTGS DCA account BIC\",\"\")\n)","v":""}]
["Cash Account Number for AAU",null,null,{"$f":"IF(AND(ISTEXT($B566),ISBLANK(B567)),\"Mandatory field\",\nIF(AND(ISTEXT($B567),B$3=\"First registration in TARGET-Banca d'Italia\",B567<>B$353,B567<>B$365,B567<>B$377,B567<>B$407,B567<>B$414,B567<>B$421,B567<>B$430,B567<>B$440,B567<>B$450),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B567),LEFT($B567,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B567,17)<>CONCATENATE(\"CITEUR\",$B$4),LEFT($B567,17)<>CONCATENATE(\"IITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Type",null,null,{"$f":"IF(AND(ISTEXT($B566),ISBLANK(B568)),\"Mandatory field\",\n  IF(AND(ISTEXT(B566),LEFT(B567,6)=\"RITEUR\",AND(LEFT(B568,4)<>\"RTGS\",LEFT(B568,4)<>\"Excl\")),\"AAU Type not allowed for RTGS DCA\",\nIF(AND(ISTEXT(B566),LEFT(B567,6)=\"CITEUR\",AND(LEFT(B568,3)<>\"T2S\",LEFT(B568,4)<>\"Excl\")),\"AAU Type not allowed for T2S DCA\",\nIF(AND(ISTEXT(B566),LEFT(B567,6)=\"IITEUR\",LEFT(B568,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(B569),B568<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B569),B568=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\nIF(AND(B$3=\"First registration in TARGET-Banca d'Italia\",ISTEXT(B569),B568=\"TIPS AAU/Reachable Party\",B569<>B$84,B569<>B$85,B569<>B$86,B569<>B$87,B569<>B$88,B569<>B$89,B569<>B$90,B569<>B$91,B569<>B$92,B569<>B$93,B569<>B$168,B569<>B$169,B569<>B$170,B569<>B$171,B569<>B$172,B569<>B$173,B569<>B$174,B569<>B$175,B569<>B$176,B569<>B$177),\"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(B570),B568<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B570),B568=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
["Maximum Amount for Instant Payments (default value = 100,000.00€)",null,null,{"$f":"IF(AND(ISTEXT(B571),B568<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\"\")","v":""}]
["BIC accepting cross-currency payments",null,null,{"$f":"IF(AND(ISTEXT(B572),B568<>\"TIPS AAU/Reachable Party\"),\"Error: this field is only allowed for TIPS AAU/Reachable Party\",\nIF(AND(ISBLANK(B572),B568=\"TIPS AAU/Reachable Party\"),\"Mandatory field\",\"\")\n)","v":""}]
[]
["7. DIRECT DEBIT MANDATES",null,null,{"$f":"IF(COUNTBLANK(D575:D600)=ROWS(D575:D600),\"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$353),ISBLANK(B580)),\"Mandatory field\",\nIF(AND(ISTEXT(B580),LEN(B580)<>11),\"Error: enter a 11-digit BIC\",\"\")\n)","v":""}]
["Payee Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B580),ISBLANK(B581)),\"Mandatory field\",\nIF(AND(ISTEXT(B581),LEN(B581)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Cash Account to be debited",null,null,{"$f":"IF(AND(ISTEXT($B581),ISBLANK(B582)),\"Mandatory field\",\nIF(AND(ISTEXT($B582),B$3=\"First registration in TARGET-Banca d'Italia\",B582<>B$353,B582<>B$365,B582<>B$377),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B582),LEFT($B582,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Payee Reference",null,null,{"$f":"IF(AND(ISTEXT($B580),ISBLANK(B583)),\"Mandatory field\",\"\")","v":""}]
["Maximum mount per counterparty",null,null,{"$f":"IF(AND(ISTEXT($B580),ISBLANK(B584)),\"Mandatory field\",\"\")","v":""}]
["Maximum amount per payment",null,null,{"$f":"IF(AND(ISTEXT($B580),ISBLANK(B585)),\"Mandatory field\",\"\")","v":""}]
[]
["Payee Parent BIC",null,null,{"$f":"IF(AND(ISTEXT(B587),LEN(B587)<>11),\"Error: enter a 11-digit BIC\",\"\")","v":""}]
["Payee Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B587),ISBLANK(B588)),\"Mandatory field\",\nIF(AND(ISTEXT(B588),LEN(B588)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Cash Account to be debited",null,null,{"$f":"IF(AND(ISTEXT($B588),ISBLANK(B589)),\"Mandatory field\",\nIF(AND(ISTEXT($B589),B$3=\"First registration in TARGET-Banca d'Italia\",B589<>B$353,B589<>B$365,B589<>B$377),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B589),LEFT($B589,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Payee Reference",null,null,{"$f":"IF(AND(ISTEXT($B587),ISBLANK(B590)),\"Mandatory field\",\"\")","v":""}]
["Maximum mount per counterparty",null,null,{"$f":"IF(AND(ISTEXT($B587),ISBLANK(B591)),\"Mandatory field\",\"\")","v":""}]
["Maximum amount per payment",null,null,{"$f":"IF(AND(ISTEXT($B587),ISBLANK(B592)),\"Mandatory field\",\"\")","v":""}]
[]
["Payee Parent BIC",null,null,{"$f":"IF(AND(ISTEXT(B594),LEN(B594)<>11),\"Error: enter a 11-digit BIC\",\"\")","v":""}]
["Payee Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B594),ISBLANK(B595)),\"Mandatory field\",\nIF(AND(ISTEXT(B595),LEN(B595)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Cash Account to be debited",null,null,{"$f":"IF(AND(ISTEXT($B595),ISBLANK(B596)),\"Mandatory field\",\nIF(AND(ISTEXT($B596),B$3=\"First registration in TARGET-Banca d'Italia\",B596<>B$353,B596<>B$365,B596<>B$377),\"Error: enter one of the cash accounts defined above\",\nIF(AND(ISTEXT($B596),LEFT($B596,17)<>CONCATENATE(\"RITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)\n)","v":""}]
["Payee Reference",null,null,{"$f":"IF(AND(ISTEXT($B594),ISBLANK(B597)),\"Mandatory field\",\"\")","v":""}]
["Maximum mount per counterparty",null,null,{"$f":"IF(AND(ISTEXT($B594),ISBLANK(B598)),\"Mandatory field\",\"\")","v":""}]
["Maximum amount per payment",null,null,{"$f":"IF(AND(ISTEXT($B594),ISBLANK(B599)),\"Mandatory field\",\"\")","v":""}]
[]
["8. GROUPS",null,null,{"$f":"IF(COUNTBLANK(D602:D710)=ROWS(D602:D710),\"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($B613),ISBLANK(B614)),\"Mandatory field\",\nIF(AND(ISTEXT(B614),LEN(B614)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Leader Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B613),ISBLANK(B615)),\"Mandatory field\",\nIF(AND(ISTEXT(B615),LEN(B615)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
[]
["BILLING GROUP"]
[]
[]
[]
[]
[]
["Group Name"]
["Leader Parent BIC",null,null,{"$f":"IF(AND(ISTEXT($B623),ISBLANK(B624)),\"Mandatory field\",\nIF(AND(ISTEXT(B624),LEN(B624)<>11),\"Error: enter a 11-digit BIC\",\"\"))","v":""}]
["Leader Party BIC",null,null,{"$f":"IF(AND(ISTEXT($B623),ISBLANK(B625)),\"Mandatory field\",\nIF(AND(ISTEXT(B625),LEN(B625)<>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($B634),B$3=\"First registration in TARGET-Banca d'Italia\",B634<>B$353,B634<>B$365,B634<>B$377,B634<>B$391,B634<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B634),LEFT($B634,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B634,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($B635),B$3=\"First registration in TARGET-Banca d'Italia\",B635<>B$353,B635<>B$365,B635<>B$377,B635<>B$391,B635<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B635),LEFT($B635,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B635,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($B636),B$3=\"First registration in TARGET-Banca d'Italia\",B636<>B$353,B636<>B$365,B636<>B$377,B636<>B$391,B636<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B636),LEFT($B636,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B636,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($B637),B$3=\"First registration in TARGET-Banca d'Italia\",B637<>B$353,B637<>B$365,B637<>B$377,B637<>B$391,B637<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B637),LEFT($B637,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B637,17)<>CONCATENATE(\"UITEUR\",$B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B640),B$3=\"First registration in TARGET-Banca d'Italia\",B640<>B$353,B640<>B$365,B640<>B$377,B640<>B$391,B640<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B640),LEFT($B640,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B640,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($B641),B$3=\"First registration in TARGET-Banca d'Italia\",B641<>B$353,B641<>B$365,B641<>B$377,B641<>B$391,B641<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B641),LEFT($B641,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B641,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($B642),B$3=\"First registration in TARGET-Banca d'Italia\",B642<>B$353,B642<>B$365,B642<>B$377,B642<>B$391,B642<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B642),LEFT($B642,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B642,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($B643),B$3=\"First registration in TARGET-Banca d'Italia\",B643<>B$353,B643<>B$365,B643<>B$377,B643<>B$391,B643<>B$398),\"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":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B646),B$3=\"First registration in TARGET-Banca d'Italia\",B646<>B$353,B646<>B$365,B646<>B$377,B646<>B$391,B646<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B646),LEFT($B646,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B646,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($B647),B$3=\"First registration in TARGET-Banca d'Italia\",B647<>B$353,B647<>B$365,B647<>B$377,B647<>B$391,B647<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B647),LEFT($B647,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B647,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($B648),B$3=\"First registration in TARGET-Banca d'Italia\",B648<>B$353,B648<>B$365,B648<>B$377,B648<>B$391,B648<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B648),LEFT($B648,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B648,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($B649),B$3=\"First registration in TARGET-Banca d'Italia\",B649<>B$353,B649<>B$365,B649<>B$377,B649<>B$391,B649<>B$398),\"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":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B652),B$3=\"First registration in TARGET-Banca d'Italia\",B652<>B$353,B652<>B$365,B652<>B$377,B652<>B$391,B652<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B652),LEFT($B652,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B652,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($B653),B$3=\"First registration in TARGET-Banca d'Italia\",B653<>B$353,B653<>B$365,B653<>B$377,B653<>B$391,B653<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B653),LEFT($B653,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B653,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($B654),B$3=\"First registration in TARGET-Banca d'Italia\",B654<>B$353,B654<>B$365,B654<>B$377,B654<>B$391,B654<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B654),LEFT($B654,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B654,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($B655),B$3=\"First registration in TARGET-Banca d'Italia\",B655<>B$353,B655<>B$365,B655<>B$377,B655<>B$391,B655<>B$398),\"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":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B658),B$3=\"First registration in TARGET-Banca d'Italia\",B658<>B$353,B658<>B$365,B658<>B$377,B658<>B$391,B658<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B658),LEFT($B658,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B658,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($B659),B$3=\"First registration in TARGET-Banca d'Italia\",B659<>B$353,B659<>B$365,B659<>B$377,B659<>B$391,B659<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B659),LEFT($B659,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B659,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($B660),B$3=\"First registration in TARGET-Banca d'Italia\",B660<>B$353,B660<>B$365,B660<>B$377,B660<>B$391,B660<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B660),LEFT($B660,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B660,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($B661),B$3=\"First registration in TARGET-Banca d'Italia\",B661<>B$353,B661<>B$365,B661<>B$377,B661<>B$391,B661<>B$398),\"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":""}]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B664),B$3=\"First registration in TARGET-Banca d'Italia\",B664<>B$353,B664<>B$365,B664<>B$377,B664<>B$391,B664<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B664),LEFT($B664,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B664,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($B665),B$3=\"First registration in TARGET-Banca d'Italia\",B665<>B$353,B665<>B$365,B665<>B$377,B665<>B$391,B665<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B665),LEFT($B665,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B665,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($B666),B$3=\"First registration in TARGET-Banca d'Italia\",B666<>B$353,B666<>B$365,B666<>B$377,B666<>B$391,B666<>B$398),\"Error: enter one of the RTGS DCAS or Sub-accounts defined above\",\nIF(AND(ISTEXT($B666),LEFT($B666,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B666,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($B667),B$3=\"First registration in TARGET-Banca d'Italia\",B667<>B$353,B667<>B$365,B667<>B$377,B667<>B$391,B667<>B$398),\"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":""}]
[]
["LIQUIDITY TRANSFER GROUP"]
[]
[]
[]
[]
[]
["Group Name"]
["Cash Account to be included in the group",null,null,{"$f":"IF(AND(ISTEXT($B676),B$3=\"First registration in TARGET-Banca d'Italia\",B676<>B$353,B676<>B$365,B676<>B$377,B676<>B$308,B676<>B$320,B676<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B676),LEFT($B676,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B676,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($B677),B$3=\"First registration in TARGET-Banca d'Italia\",B677<>B$353,B677<>B$365,B677<>B$377,B677<>B$308,B677<>B$320,B677<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B677),LEFT(B677,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B677,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B677),LEFT(B677,17)<>LEFT(B676,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($B678),B$3=\"First registration in TARGET-Banca d'Italia\",B678<>B$353,B678<>B$365,B678<>B$377,B678<>B$308,B678<>B$320,B678<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B678),LEFT(B678,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B678,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B678),LEFT(B678,17)<>LEFT(B677,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($B679),B$3=\"First registration in TARGET-Banca d'Italia\",B679<>B$353,B679<>B$365,B679<>B$377,B679<>B$308,B679<>B$320,B679<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B679),LEFT(B679,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B679,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B679),LEFT(B679,17)<>LEFT(B678,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($B682),B$3=\"First registration in TARGET-Banca d'Italia\",B682<>B$353,B682<>B$365,B682<>B$377,B682<>B$308,B682<>B$320,B682<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B682),LEFT($B682,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B682,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($B683),B$3=\"First registration in TARGET-Banca d'Italia\",B683<>B$353,B683<>B$365,B683<>B$377,B683<>B$308,B683<>B$320,B683<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B683),LEFT(B683,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B683,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B683),LEFT(B683,17)<>LEFT(B682,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($B684),B$3=\"First registration in TARGET-Banca d'Italia\",B684<>B$353,B684<>B$365,B684<>B$377,B684<>B$308,B684<>B$320,B684<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B684),LEFT(B684,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B684,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B684),LEFT(B684,17)<>LEFT(B683,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($B685),B$3=\"First registration in TARGET-Banca d'Italia\",B685<>B$353,B685<>B$365,B685<>B$377,B685<>B$308,B685<>B$320,B685<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B685),LEFT(B685,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B685,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B685),LEFT(B685,17)<>LEFT(B684,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($B688),B$3=\"First registration in TARGET-Banca d'Italia\",B688<>B$353,B688<>B$365,B688<>B$377,B688<>B$308,B688<>B$320,B688<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B688),LEFT($B688,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B688,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($B689),B$3=\"First registration in TARGET-Banca d'Italia\",B689<>B$353,B689<>B$365,B689<>B$377,B689<>B$308,B689<>B$320,B689<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B689),LEFT(B689,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B689,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B689),LEFT(B689,17)<>LEFT(B688,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($B690),B$3=\"First registration in TARGET-Banca d'Italia\",B690<>B$353,B690<>B$365,B690<>B$377,B690<>B$308,B690<>B$320,B690<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B690),LEFT(B690,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B690,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B690),LEFT(B690,17)<>LEFT(B689,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($B691),B$3=\"First registration in TARGET-Banca d'Italia\",B691<>B$353,B691<>B$365,B691<>B$377,B691<>B$308,B691<>B$320,B691<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B691),LEFT(B691,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B691,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B691),LEFT(B691,17)<>LEFT(B690,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($B694),B$3=\"First registration in TARGET-Banca d'Italia\",B694<>B$353,B694<>B$365,B694<>B$377,B694<>B$308,B694<>B$320,B694<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B694),LEFT($B694,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B694,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($B695),B$3=\"First registration in TARGET-Banca d'Italia\",B695<>B$353,B695<>B$365,B695<>B$377,B695<>B$308,B695<>B$320,B695<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B695),LEFT(B695,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B695,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B695),LEFT(B695,17)<>LEFT(B694,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($B696),B$3=\"First registration in TARGET-Banca d'Italia\",B696<>B$353,B696<>B$365,B696<>B$377,B696<>B$308,B696<>B$320,B696<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B696),LEFT(B696,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B696,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B696),LEFT(B696,17)<>LEFT(B695,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($B697),B$3=\"First registration in TARGET-Banca d'Italia\",B697<>B$353,B697<>B$365,B697<>B$377,B697<>B$308,B697<>B$320,B697<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B697),LEFT(B697,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B697,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B697),LEFT(B697,17)<>LEFT(B696,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($B700),B$3=\"First registration in TARGET-Banca d'Italia\",B700<>B$353,B700<>B$365,B700<>B$377,B700<>B$308,B700<>B$320,B700<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B700),LEFT($B700,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B700,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($B701),B$3=\"First registration in TARGET-Banca d'Italia\",B701<>B$353,B701<>B$365,B701<>B$377,B701<>B$308,B701<>B$320,B701<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B701),LEFT(B701,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B701,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B701),LEFT(B701,17)<>LEFT(B700,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($B702),B$3=\"First registration in TARGET-Banca d'Italia\",B702<>B$353,B702<>B$365,B702<>B$377,B702<>B$308,B702<>B$320,B702<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B702),LEFT(B702,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B702,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B702),LEFT(B702,17)<>LEFT(B701,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($B703),B$3=\"First registration in TARGET-Banca d'Italia\",B703<>B$353,B703<>B$365,B703<>B$377,B703<>B$308,B703<>B$320,B703<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B703),LEFT(B703,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B703,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B703),LEFT(B703,17)<>LEFT(B702,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($B706),B$3=\"First registration in TARGET-Banca d'Italia\",B706<>B$353,B706<>B$365,B706<>B$377,B706<>B$308,B706<>B$320,B706<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT($B706),LEFT($B706,17)<>CONCATENATE(\"RITEUR\",$B$4),LEFT($B706,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($B707),B$3=\"First registration in TARGET-Banca d'Italia\",B707<>B$353,B707<>B$365,B707<>B$377,B707<>B$308,B707<>B$320,B707<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B707),LEFT(B707,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B707,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B707),LEFT(B707,17)<>LEFT(B706,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($B708),B$3=\"First registration in TARGET-Banca d'Italia\",B708<>B$353,B708<>B$365,B708<>B$377,B708<>B$308,B708<>B$320,B708<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B708),LEFT(B708,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B708,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B708),LEFT(B708,17)<>LEFT(B707,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($B709),B$3=\"First registration in TARGET-Banca d'Italia\",B709<>B$353,B709<>B$365,B709<>B$377,B709<>B$308,B709<>B$320,B709<>B$331),\"Error: enter one of the MCAs or RTGS DCAs defined above\",\nIF(AND(ISTEXT(B709),LEFT(B709,17)<>CONCATENATE(\"MITEUR\",B$4),LEFT(B709,17)<>CONCATENATE(\"RITEUR\",B$4)),\"Error: wrong account number\",\nIF(AND(ISTEXT(B709),LEFT(B709,17)<>LEFT(B708,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(D712:D741)=ROWS(D712:D741),\"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(B718),OR(B717=\"A\",B717=\"B\",B717=\"C\",B717=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B718),LEFT(B718,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B719),IF(OR(B717=\"C\",B717=\"D\",B717=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B719,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B723),OR(B722=\"A\",B722=\"B\",B722=\"C\",B722=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B723),LEFT(B723,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B724),IF(OR(B722=\"C\",B722=\"D\",B722=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B724,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B728),OR(B727=\"A\",B727=\"B\",B727=\"C\",B727=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B728),LEFT(B728,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B729),IF(OR(B727=\"C\",B727=\"D\",B727=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B729,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B733),OR(B732=\"A\",B732=\"B\",B732=\"C\",B732=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B733),LEFT(B733,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B734),IF(OR(B732=\"C\",B732=\"D\",B732=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B734,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["Procedure"]
["Ancillary System Technical Account",null,null,{"$f":"IF(AND(ISBLANK(B738),OR(B737=\"A\",B737=\"B\",B737=\"C\",B737=\"D\")),\"Mandatory field\",\nIF(AND(ISTEXT(B738),LEFT(B738,17)<>CONCATENATE(\"TITEUR\",B$4)),\"Error: wrong account number\",\"\")\n)","v":""}]
["Ancillary System Guarantee Funds Account",null,null,{"$f":"IF(ISTEXT(B739),IF(OR(B737=\"C\",B737=\"D\",B737=\"E\"),\"Error: Guarantee funds account not allowed for the selected procedure\",IF(LEFT(B739,17)<>CONCATENATE(\"GITEUR\",B$4),\"Error: wrong account number\",\"\")),\"\")","v":""}]
["Single/Global Notification"]
[]
["10. ADMINISTRATOR USERS",null,null,{"$f":"IF(COUNTBLANK(D743:D757)=ROWS(D743:D757),\"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(B748),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(B748),ISBLANK(B749)),\"Mandatory field\",\nIF(AND(ISTEXT($B$4),ISTEXT($B749)),\nIF(LEFT($B749,14)<>CONCATENATE(\"AIT\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\"))","v":""}]
["Certificate Distinguished Name ",null,null,{"$f":"IF(AND(ISTEXT(B748),ISBLANK(B750)),\"Mandatory field\",\nIF(ISNUMBER(FIND(\"cn=\",B750)),\"Error: the qualifier 'CN' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"ou=\",B750)),\"Error: the qualifier 'OU' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"o=\",B750)),\"Error: the qualifier 'O' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"dc=\",B750)),\"Error: the qualifier 'DC' must be entered uppercase\",\n IF(OR(LEN(SUBSTITUTE(B750,\", \",\",\"))<>LEN(SUBSTITUTE(B750,\",\",\"\")),ISNUMBER(SEARCH(\",  \",B750))),\"Error: insert a space after each comma\",\n\"\")))))\n)","v":""}]
["Main User (only required for accessing TIPS GUI)",null,null,{"$f":"IF(AND(ISTEXT(B748),ISBLANK(B751)),\"Mandatory field\",\"\")","v":""}]
[]
["Name"]
["Login Name (System User Reference)",null,null,{"$f":"IF(AND(ISTEXT(B753),ISBLANK(B754)),\"Mandatory field\",\nIF(AND(ISTEXT($B$4),ISTEXT($B754)),\nIF(LEFT($B754,14)<>CONCATENATE(\"AIT\",$B$4),\"Attention: naming convention not respected\",\"\"),\"\"))","v":""}]
["Certificate Distinguished Name ",null,null,{"$f":"IF(AND(ISTEXT(B753),ISBLANK(B755)),\"Mandatory field\",\nIF(ISNUMBER(FIND(\"cn=\",B755)),\"Error: the qualifier 'CN' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"ou=\",B755)),\"Error: the qualifier 'OU' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"o=\",B755)),\"Error: the qualifier 'O' must be entered uppercase\",\n IF(ISNUMBER(FIND(\"dc=\",B755)),\"Error: the qualifier 'DC' must be entered uppercase\",\n IF(OR(LEN(SUBSTITUTE(B755,\", \",\",\"))<>LEN(SUBSTITUTE(B755,\",\",\"\")),ISNUMBER(SEARCH(\",  \",B755))),\"Error: insert a space after each comma\",\n\"\")))))\n)","v":""}]
["Main User (only required for accessing TIPS GUI)",null,null,{"$f":"IF(AND(ISTEXT(B753),ISBLANK(B756)),\"Mandatory field\",\"\")","v":""}]
[]
["11. INVOICE CONFIGURATION",null,null,{"$f":"IF(COUNTBLANK(D759:D774)=ROWS(D759:D774),\"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(B764),B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT(B$353),ISTEXT(B$365),ISTEXT(B$377),B$19<>\"Payment Bank\")),\"Mandatory field\",\nIF(AND(ISTEXT(B764),B$19=\"Payment Bank\",LEFT(B764)<>\"C\"),\"Error: option not allowed for Payment Banks\",\nIF(AND(ISTEXT(B764),LEFT(B$19)=\"A\",LEFT(B764)=\"C\"),\"Error: option not allowed for Ancillary Systems\",\"\")\n))","v":""}]
["MCA to be debited",null,null,{"$f":"IF(AND(ISBLANK(B765),B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT(B$353),ISTEXT(B$365),ISTEXT(B$377),ISTEXT(B$407),ISTEXT(B$414),ISTEXT(B$421),ISTEXT(B$430),ISTEXT(B$440),ISTEXT(B$450))),\"Mandatory field\",\nIF(AND(ISTEXT(B765),LEFT(B765,6)<>\"MITEUR\"),\"Error: wrong account number\",\"\")\n)","v":""}]
["Invoice Street",null,null,{"$f":"IF(AND(ISBLANK(B766),B$3=\"First registration in TARGET-Banca d'Italia\",OR(ISTEXT(B$353),ISTEXT(B$365),ISTEXT(B$377),ISTEXT(B$407),ISTEXT(B$414),ISTEXT(B$421),ISTEXT(B$430),ISTEXT(B$440),ISTEXT(B$450))),\"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"]
["La Banca d’Italia effettua il trattamento dei dati personali in conformità con quanto disposto dalla normativa europea e nazionale in materia di privacy.\nPer ulteriori dettagli si rimanda all’informativa privacy pubblicata sul sito www.bancaditalia.it, sezione Compiti / Gestione dei sistemi di pagamento / T2: il regolamento dei pagamenti all’ingrosso."]

{"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)"]