Extranet Message Log Application User Manual - Functions

update: May 2003





Contents

User functions

This section describes the functions available to EXTRANET users for consulting SWIFT/RNI messages regarding payments made to/received from the Foreign Office of Banca Popolare Sondrio. There are two different types of EXTRANET users: Institutional Customer and Corresponding Bank. The available functions are slightly different according to user type. These differences are pointed out in the detail of the individual functions.


Search

Two different search functions are available. They allow you to make queries on messages in the online archive and SWIFT and RNI message log, and therefore select the application messages pertaining to the payments of interest based on set search criteria.



Search by date

This function lets you carry out a search based on the date the messages in the archive are recorded together with other characteristic parameters of the payment messages.

A Corresponding Bank type of user does not have available several selection fields that are unimportant for this type of user, which are:

However, an Institutional Customer does not have the Channel field (settlement channel) available.

At least one interval of dates must be given in the "Record Date" field in order to carry out a search. When "Search" is pressed, the search Results page containing the messages complying with the selection criteria indicated is displayed.

The detail of the selection fields is the following:

Record Date

from: date when the interval for the record date search starts (dd mm yyyy format). This field is mandatory.

a: date when the interval for the record date search ends (dd mm yyyy format). If it is not given, then the date found in "Record Date from:" is taken. The interval provided cannot exceed 31 solar days.

Value date: it is the value date of the message (dd mm yy format). The field is optional.

Counterpart: it is the Sender Bank for incoming messages and the Receiver Bank for outgoing messages.
The following formats are allowed: BIC (6, 8 or 11 characters) or ABI (5 numerical characters) address.
The ABI search can be used only for RNI messages.
The BIC search can be used only for SWIFT messages.
The field is optional. It cannot be provided if a value for the "Country" field has been given.

Country: it is the country of the Counterpart (Sender or Receiver Bank). It is a combo box with the countries available in ISO format (2 alphabetical characters).
The field is optional and cannot be provided if a "Counterpart" has been given or if the message is the RNI type.

Amount

from: it is the minimum amount with which the search for the amount of the message is made. Fifteen-digit format, with 3 decimals at the most. The dot character separates the thousands. The comma separates the decimals. If not present but there is the "Amount to:" field, it is assumed valorised at 0.

a: it is the maximum amount with which the search for the amount of the message is made. If not indicated, the figure in "Amount from:" will be taken.

Currency: it is the dealing currency of the message. It is a combo box with the foreign currencies available in ISO format (3 alphabetical characters). The field is optional.

Message Type: it is made up of two input fields.

The first lets you choose the network from which the messages to search for come from/are addressed to.

It is a combo box with the following values: This field is mandatory.

The second allows you to choose the type of SWIFT or RNI message to search. The field may take a numerical 3-digit value to search for a precise type of message. Also a search pattern can be built by replacing one or two digits with the character '*'. For example, if the field is given the value 1** and "Msg Network" is valorised SWIFT, all SWIFT messages of the 100, 101, 102, etc. type will be found. The field may also be valorised with ACK or NAK if you want to find positive or negative application confirmations given by the network.

Channel: it lets you identify the messages that debit or credit a type of account or one of the Settlement Providers that Banca Popolare di Sondrio belongs to.

It is a combo box with the following values:
The field is optional.

Direction: it lets you select only outgoing or incoming messages.

It is a combo box with the following values: The field is optional.

Beneficiary Bank: it is the Bank on which the funds have been credited.
Only the BIC address format is allowed (with 6, 8 or 11 characters).
The field is optional.

Beneficiary: it is the descriptive address of the Beneficiary Customer. The search singles out all messages containing the string provided in input in any part of the descriptive part of tag 59 of the SWIFT message.
The field is up to 35 alphanumerical characters in length and is optional.

Remitter: it is the descriptive address of the Remitter Customer. The search singles out all messages containing the string provided in input in any part of the descriptive part of tag 50 of the SWIFT message.
The field is up to 35 alphanumerical characters in length and is optional.


Buttons

When selecting the Search button, first of all the correctness of the data indicated in the form is verified.
If the verification is positive, the search is performed and the search Results page is presented with the query's results, if any.
The Reset button lets you clear the form's contents, deleting all set values.


Search by key

This function lets you carry out searches based on a key that univocally identifies one of the messages in the archive.
In order to make the search, you have to select a search key and set the value of the component segments. Then the search Results page containing the messages meeting the indicated selection criteria is displayed when "Search" is pressed.

The detail of the search fields is the following:

Key: it allows you to choose the type of key on which the search is to be made.

It is a combo box with the following values:


Values: depending on the key selected, from 1 to 4 input fields where the value of the segments making up the key are to be entered are shown on the video. In detail, the expected format for the segments making up the "Key" value is the following:

Buttons

When selecting the Search button, first of all the correctness of the data indicated in the form is verified. If the verification is positive, the search is performed and the search Results page is presented with the query's results, if any.
The Reset button lets you clear the form's contents, deleting all set values.


Search results

This function supplies the result of a search made according to the selection criteria indicated in one of the two Search functions (by key or by date).
The page is divided into three sections. The sear criteria are summarised in the top part, whether they regard the search function by key or by date of recording.
The list of messages that may meet the criteria is presented underneath, and then the area with the paging buttons (on the left) and the buttons for accessing other application functions displaying additional information tied to the individual messages follows.

Selected search parameters

In order to get better readability of the results provided, it also gives the parameters previously selected on the Search by Key or Search by Date page.

List of messages

It contains a list of the messages put in order by "Message ID" that comply with the conditions set for the search.
Each message on the list may be selected by clicking on the button shown in the "Sel" column.

Message ID: it is the univocal key that identifies the message in the Message Log application archive.

MOR/CRO: for the SWIFT messages, it contains the MOR key value, and for the RNI messages, it contains the CRO key value.

Counterpart: it is the identifier of the Counterpart Bank (Sender Bank for incoming messages and Receiver Bank for outgoing messages). It is generally in BIC code. If missing, the ABI + CAB + OFFICE code is supplied.

I/O: it indicates whether the message is incoming ('I' value) or outgoing ('O' value).

Msg Type: it indicates the type of message in the RInnn or SWnnn format, where RI stands for RNI network and SW for SWIFT network, whereas nnn is the actual type of message for the relative payment network.

Currency: it is the foreign currency in the message text.

Amount: iit is the amount in the message text. The format envisages the dot character as separator of the thousands and the comma character as the decimal separator in display mode as well.

Value: it is the value date in the message text.

Beneficiary: the descriptive address of the Beneficiary Customer as given by tag 59 of the SWIFT message text.

Customer: (for Institutional Customer) it is the descriptive address of the Beneficiary Customer for the outgoing messages or that of the Remitter Customer for the outgoing messages.


Buttons

The following buttons are present:

Stampa: with the same search parameters as before, it performs a new search and updates the page with the query's results.

Stampa: it displays the print page that has the same format and content of the original results page, but a layout without embellishments, suitable for being printed.

<< < > >>: buttons for pagination of the search results. They let you move to the first, previous, next and last page of the set of pages where the list of selected messages is divided up and presented to the user.

Statuses: it shows the message Statuses page with the list of evolutionary statuses for the selected message. An error appears if no message is selected.

Associated: it shows the associated Messages page with the list of messages that are associated with the selected message. An error appears if no message is selected.

Details: it shows the message Detail page with detailed information about the selected message. An error appears if no message is selected.

Search: it presents again the search page from which the query, Search by date or Search by key was made.

Print Details: it presents the Print Details page that lets you print details of more than one message all in one solution.


Detail of a message

This page shows the detailed information of only one message. The page is divided into two vertical sections. The application data of the message are presented in the upper part. It is basically an enrichment of the information presented on the search Results page per single message. The actual text of the message with the list of tags forming it is presented in the lower part.

Application Data

Shown are several of the most important fields that cannot be obtained directly from the message text or fields obtained from the message text and that a Banca Popolare di Sondrio operator may have modified (such as amount and value date) as to the value in the original message.

The list of fields presented follows:

Currency: it is the foreign currency with which the message was recorded.

Amount: it is the amount with which the message was recorded.

Value: it is the value date with which the message was recorded.

Our Reference: it is the univocal reference of the Banca Popolare di Sondrio Foreign Procedure.

File Gathering: combined with the recording date, it is the only accounting reference of the Foreign Procedure.

End-processing date: it is the date that indicates when the message's processing was completed.

Message Type: it is the type of message in the RInnn or SWnnn format, where RI stands for RNI network and SW for SWIFT network, whereas nnn is the actual type of message for the relative payment network.

Direction: it indicates whether the message is incoming or outgoing.

Also the following accounting data are provided:

Debit Bank, Debit Account, Credit Bank, Credit Account, Last Network Status and Last Accounting Status.

Network Text

The following fields are listed for each TAG forming the text of the message:

Description: it is the description of the TAG of the SWIFT network message text or of the FI (Field Identifier) of the RNI network message.

TAG/FI: it is the identifier of the TAG/FI in the message in network format.

Content: it is the content of the TAG/FI in the message text.


Buttons

The following buttons are present:

Stampa: it displays the print page that has the same format and content of the original detail page, but a layout without embellishments, suitable for being printed.

DPA Details: it shows the page with the list of arrangements made through bank cheques or bank transfers tied to the single message. The button is present only if this information is present for the message.

Statuses: it shows the message Statuses page with the list of evolutionary statuses for the selected message.

Back: it returns to the page the message had been selected from (search Results or List of associated messages).


Statuses of a message

This page shows the evolution of the statuses followed by a single message. The traced messages regard the automatic processing done by one of the Banca Popolare di Sondrio computer system procedures or manually by a user.

Statuses table

It contains a list of all the statuses the selected message has gone through.

The following fields are shown:

Date: it is the date (in the dd.mm.yyyy format) when the event occurred.

Time: it is the time (in the hh:mm:ss format) when the event occurred

Status: it is the status identifier.

Description: it is the full description of the status.

Operator: it is the identifier of the operator who generated the status.

Customer: (for Institutional Customer) it is the descriptive address of the Beneficiary Customer for the outgoing messages or that of the Remitter Customer for the outgoing messages.


Buttons

The following buttons are present:

Stampa: it updates the content of the page by accessing the database again.

Stampa: it displays the print page that has the same format and content of the original statuses page, but a layout without embellishments, suitable for being printed.

Back: it returns to the page the message had been selected from (search Results, List of associated messages or Message Detail).


List of associated messages

This page displays the list of messages that are logically associated with a message. The displayed messages are all those found in the same folder of the selected message. The identifier of the common folder (Folder Date + Folder Consecutive number) is given in the upper part of the page.

List of messages

It contains a list of messages in the folder, ordered by consecutive message going up. Each message on the list may be selected by clicking on the button shown in the "Sel" column. The list of other fields presented is the same as the search Results page aside from the beneficiary, who is not presented on this page.

Progr. Message: it is the univocal key that identifies the message in the Message Log application archive. The first part (Folder Date + Folder Consecutive number) is common because the messages all belong to the same folder. What changes from one message to the next are the last 2 characters that identify the Message Consecutive number.

MOR/CRO: for the SWIFT messages, it contains the MOR key value, and for the RNI messages, it contains the CRO key value.

Counterpart: it is the identifier of the Counterpart Bank (Sender Bank for incoming messages and Receiver Bank for outgoing messages). It is generally in BIC code. If missing, the ABI + CAB + OFFICE code is supplied.

I/O: it indicates whether the message is incoming ('I' value) or outgoing ('O' value).

Msg Type: it indicates the type of message in the RInnn or SWnnn format, where RI stands for RNI and SW for SWIFT, whereas nnn is the actual type of message for the relative payment network.

Currency: it is the foreign currency in the message text.

Amount: it is the amount in the message text. The format envisages the dot character as separator of the thousands and the comma character as the decimal separator in display mode as well.

Value: it is the value date in the message text.


Buttons

The following buttons are present:

Stampa: it updates the content of the page by accessing the database again.

Stampa: it displays the print page that has the same format and content of the original page, but a layout without embellishments, suitable for being printed.

Statuses: it shows the message Statuses page with the list of evolutionary statuses for the selected message. An error appears if no message is selected.

Details: it shows the message Detail page with detailed information about the selected message. An error appears if no message is selected.

Back: it returns to the page from which the message was selected, which in this case can only be the search Results page.


Multiple printing of details

This function provides the user the possibility of printing all details of the list of messages resulting from a search or one of its subsets in just one solution.

List of messages

The same list of the search Results page is presented (excluding the "Beneficiary" field), the page from which this function can be enabled. Also the same size of presentation page is kept. Unlike the results page, in this case it is possible to simultaneously select all the messages you want to print the detail of by clicking on the checkbox button shown in the "Sel" column.


Buttons

The following buttons are present:

<< < > >>: buttons for paginating the messages. They let you move to the first, previous, next and last page of the set of pages where the list of selected messages is divided up and presented to the user.

Print: it shows the print page in which the details of only the messages selected with the checkboxes are exploded, with a layout devoid of embellishments, suitable for being printed.

Print All: it shows the print page in which the details of all messages resulting from the search are exploded, with a layout devoid of embellishments, suitable for being printed.

Reset: it deletes all selections made, returning the page to its original condition.

Back: it returns to the search Results page.


Detail of cheques

This page shows the details of the arrangements made through bank cheques tied to the single payment message. A few of the most important fields that cannot be directly obtained from the message detail page from which this function can be enabled are shown for each cheque.

Arrangement number: it is an internal key of the DPA procedure that univocally identifies the payment arrangement.

Cheque number: it is the number of the cheque issued.

Date of cheque: it is the date the cheque is issued.

Due date: it is the date until which the cheque is valid.

Arrangement currency: it is the payment currency.

Arrangement amount: it is the amount of payment.

Charges currency: it is the currency of the charges linked to the payment.

Charges amount: it is the amount of the charges linked to the payment.

Commissions currency: it is the currency of the commissions linked to the payment.

Commissions amount: it is the amount of the commissions linked to the payment.

Result date: it is the date of the result (positive or negative) of the payment.

Result description: it is the full description of the result of the payment.

ABI payment: it is the ABI code (the cheques are used only for payment between Italian banks) of the bank that paid the cheque.

Customer address: all the references of the beneficiary customer.

Buttons

The following buttons are present:

Stampa: it displays the print page that has the same format and content of the original page, but a layout without embellishments, suitable for being printed.

Back: it always returns to the message detail page


Detail of transfers

This page shows the details of the arrangements made through transfers tied to the single payment message. A few of the most important fields that cannot be directly obtained from the message detail page from which this function can be enabled are shown for each transfer.

Arrangement number: it is an internal key of the DPA procedure that univocally identifies the payment arrangement.

CRO: univocal key that identifies the payment message.

Order date: it is the date when issue of the transfer was requested.

Arrangement currency: it is the currency of the bank arrangement made with the transfer.

Arrangement amount: it is the amount of the bank transfer.

Bank: it is the uncoded name of the bank that makes the transfer payment.

Branch: it is the uncoded name of the branch that makes the transfer payment.

Sort code: it is the bank sort code (in coded IBAN format or in free format).

Result date: it is the date of the result (positive or negative) of the transfer.

Result description: it is the full description of the result of the transfer.

Notes: information regarding any beneficiary value date reversal or adjustment operations.

Buttons


The following buttons are present:

Stampa: it displays the print page that has the same format and content of the original page, but a layout without embellishments, suitable for being printed.

Back: it always returns to the message detail page.