Generating Requests for Account Statements

You can generate a request for account statement using the SWIFT Statement Request window.

It generates the following requests based on the selected statement:

• MT549 messages of type SEC_STATEMENT_REQUEST for MT5xx statements
• semt.021 messages of type SEC_STATEMENT_REQUEST for semt.017 statements
• MT920 messages of type STATEMENT_REQUEST for MT9xx statements
• camt.003 messages of type STATEMENT_REQUEST for camt.004 return account
• camt.060 messages of type STATEMENT_REQUEST for camt.05x statements

 

1. Before you Begin

 

Execute SQL

You need to add "<calypso home>/client/resources/samples/dbscripts/SchemaData_swift_statement_request.xml" to Execute SQL, in order to populate static data for Requests for Statement.

 

semt.021 Setup

You need to add the following domain values:

 

Domain = “semt021StatementTypes”

Value = semt.021.001.06

Comment = semt.021 SecuritiesStatementQuery

 

Domain = “MX.Versions”

Value = semt.021.001

Comment = 06

 

camt.003 Setup

You need to add the following domain values:

 

Domain = MX-StatementType

Value = camt.003.001

Comment = camt.004 ReturnAccount

 

Domain = MX.T2

Value = SAA.Receiver, Comment = <T2 receiver>

Value = SAA.ReceiverCLM, Comment = <CLM receiver>

Value = SAA.ReceiverT2S, Comment = <T2S receiver>

 

2. Message Workflows

You can create dedicated workflows for the message types SEC_STATEMENT_REQUEST and STATEMENT_REQUEST.

Example:

Orig Status Action Resulting Status Use STP SD Filter Rules Create Task
NONE NEW PENDING False  

 

 False
PENDING AUTHORIZE TO_BE_SENT True  

 

 True
TO_BE_SENT SEND SENT False  

 

 False
SENT ACK ACKED False  

 

 False
SENT NACK NACKED False  

 

 False

 

3. Generating Account Statement Requests

From the Calypso Navigator, navigate to Processing > SWIFT > SWIFT Statement Request (menu action reporting.SWIFTStatementRequestWindow).

» Enter the fields described below and click Send.
» For MT549 messages, you can also set the optional fields described below and click Add before sending the message.

 

Mandatory Fields

Fields

Description

Statement Type

Select a statement type for which you want to generate a statement request.
Request Date

Enter the request date.
Format

Select the format: SWIFT, INDEVAL, MX or JSONMX.

For INDEVAL, you need to have configured the interface with INDEVAL.

Please refer to Calypso INDEVAL Integration documentation for details.
Gateway

Only applies to MX format.

Select the gateway.
Jurisdiction

Only applies to MX format.

Select the jurisdiction.
Sender Address

Click ... to select the sender. You will be prompted to select a contact. It will display the BIC Code when Format = SWIFT, or the Participant Id when Format = INDEVAL.
Receiver Address

Click ... to select the sender. You will be prompted to select a contact. It will display the BIC Code when Format = SWIFT, or the Participant Id when Format = INDEVAL.
Safekeep Account

Select the account for which the statement is requested.

 

Optional Fields (for MT549 messages only)

Fields

Description

Status

Select one or more Qualifier / Status Code from the list.

They are defined in the domain "MT549Statuses".
Reason

Select one or more Qualifier / Status Code from the list.

They are defined in the domain "MT549Reasons".
Financial Instrument

Click ... to select a product as needed.

 

Generating camt.003 Messages in Batch

You can generate camt.003 messages in batch using the scheduled task MX_GET_ACCOUNT.

The common attribute Processing Org is mandatory.

Select the task attributes as needed:

• Services - Select T2, CLM and / or T2S
• PO Contact Type - Select the PO contact
• Account Owner - Select the account owner
• Account Owner Contact Type - Select the account owner contact
• Account - Select an account, or none for all
• Gateway - Select one gateway in the dropdown list coming from the domain gateway