Mapping Services 3.3.1 DML Users Guide DML functions: SWIFT checkBICSubtypes isValidIBANCode isValidBICCode isValidISINCode isValidAmount updateBICTable The following SWIFT functions are available: checkBICSubtypes checkBICSubtypes Comment Description checkBICSubtypes checks the association of the BIC with the Location Indication. Syntax checkBICSutbypes(BIC_LC, BIC_BC) Returns True or false (boolean): Returns true if the BIC code is associated with the Location Indication "BEID", "TRCO", “MCCO”, “SMDP” or “CORP”. Otherwise, it returns false. Parameters BIC_LC (String) = Location Code to validate, 8 characters BIC_BC (String) = Branch Code to validate, 3 characters Example checkBICSubtypes("AGRIFRPP","BRT") isValidIBANCode isValidIBANCode Comment Description isValidBANCode checks if the specified code is a valid IBAN code. Syntax isValidBANCode(code_number) Returns Trueor false (boolean) Parameters code_number = IBAN code to validate Example isValidBANCode(GB99 NWBK 1234 5612 3456 78) isValidBICCode isValidBICCode Comment Description isValidBICCode checks if the specified code is a valid BIC code. Syntax isValidBICCode(BIC_LC, BIC_BC) Returns True or false (boolean) Parameters BIC_LC (String) = Location Code to validate, 8 characters BIC_BC (String) = Branch Code to validate, 3 characters Example isValidBICCode("AGRIFRPP","BRT") isValidISINCode isValidISINCode Comment Description isValidISINCode checks if the specified code is a valid ISIN code. Syntax isValidISINCode(code_number) Returns True or false (boolean) Parameters code_number = ISIN code to validate Example isValidISINCode(US0378331005) isValidAmount isValidAmount Comment Description isValidAmount validates the number of spaces after the decimal point. Syntax isValidAmount(Amount, NumberDecimals) Returns True or false (boolean) Parameters Amount = The monetary sum to check (String) NumberDecimals = The number of permitted decimals (Integer) Example isValidAmount("1478869", 2) updateBICTable updateBICTable Comment Description updateBICTable updates, inserts, or deletes all BIC codes in the server table. Syntax updateBICTable(BIC_LC, BIC_BC, Subtype_Indication, Flag) Returns True or false (boolean): False if it fails, otherwise True. Parameters BIC_LC = Location Code, 8 characters (String) BIC_LC = Branch Code, 3 characters (String) Subtype_Indication = Subtype Indication, 4 characters (String) Flag: I = insertU = updateM = modifyD = delete Example updateBICTable("AGRIFRPP","BRT","BANK","I") Related Links
DML functions: SWIFT checkBICSubtypes isValidIBANCode isValidBICCode isValidISINCode isValidAmount updateBICTable The following SWIFT functions are available: checkBICSubtypes checkBICSubtypes Comment Description checkBICSubtypes checks the association of the BIC with the Location Indication. Syntax checkBICSutbypes(BIC_LC, BIC_BC) Returns True or false (boolean): Returns true if the BIC code is associated with the Location Indication "BEID", "TRCO", “MCCO”, “SMDP” or “CORP”. Otherwise, it returns false. Parameters BIC_LC (String) = Location Code to validate, 8 characters BIC_BC (String) = Branch Code to validate, 3 characters Example checkBICSubtypes("AGRIFRPP","BRT") isValidIBANCode isValidIBANCode Comment Description isValidBANCode checks if the specified code is a valid IBAN code. Syntax isValidBANCode(code_number) Returns Trueor false (boolean) Parameters code_number = IBAN code to validate Example isValidBANCode(GB99 NWBK 1234 5612 3456 78) isValidBICCode isValidBICCode Comment Description isValidBICCode checks if the specified code is a valid BIC code. Syntax isValidBICCode(BIC_LC, BIC_BC) Returns True or false (boolean) Parameters BIC_LC (String) = Location Code to validate, 8 characters BIC_BC (String) = Branch Code to validate, 3 characters Example isValidBICCode("AGRIFRPP","BRT") isValidISINCode isValidISINCode Comment Description isValidISINCode checks if the specified code is a valid ISIN code. Syntax isValidISINCode(code_number) Returns True or false (boolean) Parameters code_number = ISIN code to validate Example isValidISINCode(US0378331005) isValidAmount isValidAmount Comment Description isValidAmount validates the number of spaces after the decimal point. Syntax isValidAmount(Amount, NumberDecimals) Returns True or false (boolean) Parameters Amount = The monetary sum to check (String) NumberDecimals = The number of permitted decimals (Integer) Example isValidAmount("1478869", 2) updateBICTable updateBICTable Comment Description updateBICTable updates, inserts, or deletes all BIC codes in the server table. Syntax updateBICTable(BIC_LC, BIC_BC, Subtype_Indication, Flag) Returns True or false (boolean): False if it fails, otherwise True. Parameters BIC_LC = Location Code, 8 characters (String) BIC_LC = Branch Code, 3 characters (String) Subtype_Indication = Subtype Indication, 4 characters (String) Flag: I = insertU = updateM = modifyD = delete Example updateBICTable("AGRIFRPP","BRT","BANK","I")