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 = insert
  • U = update
  • M = modify
  • D = delete

Example

updateBICTable("AGRIFRPP","BRT","BANK","I")

Related Links