{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Foglio1","Foglio2"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

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

{"sheet":"Foglio2","index":1,"n_rows":87,"n_cols":1,"rows_kept":87,"hidden":true}
[]
["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)"]