Report 2022: Money Market Transaction Analysis (W5)

This version is superseded. Click here to view the latest guide

PURPOSE

To provide the details used by CS Lucas to show Money Market Movement sort by Counterparty ID and Currency.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Money Market Trade.

QUERY

1. Navigate to Reporting > Standard > Report 2022: Money Market Transaction Analysis.

2. Fill in the mandatory parameters – Acct Cntr, From Date* and To Date, Borrow/Lend, Report Currency and Rate Type. The rest are optional parameters.

3. Click on the required format.

4. The report shows the Accounting Centre, CounterpartyID, Trade ID, VDate, MDate, Days, Rate, Interest, Currency, Principal (Amount), New and Matured.

For explanation of  button, please see link.
For explanation of  buttons, please see link.

DATA SOURCE

To view the following transaction,

Follow the steps as shown below:

1. Navigate to Transaction > Money Market.

2. Key in the Mdate From: 01/01/2007.

3. Select Ctpy: JAREV-SG.

4. Select Transaction: Borrow/Loan.

5. Click Refresh.

Days: Number of days between Value Date (D) and Due Date (E)
Ex Rate: Navigate to Prices > Exc Rate

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

 

CHANGE HISTORY