alongside Investment Solutions Extract on the sub-menu on the left. Additional options will be displayed.To generate an Investment Solutions Extract file for FinSwitch, click alongside Investment Solutions Extract on the sub-menu on the left. Additional options will be displayed.
Click New below Investment Solutions Extract.
The Investment Solutions Extract Report screen will be displayed.
Capture data as follows:
|
Notification Date |
The date of trade, i.e. the day the asset manager needs to purchase or sell.
The Investment Solutions extract will only allow one extract per notification day as the extract is marked as already processed. |
|
|
The email address to which the report must be sent.
The e-mail that is sent to the user in the e-mail box will receive the file in the Investment Solutions Interface layout. |
Click GENERATE REPORT.
A message will confirm that the job has been submitted successfully.
Once the batch run that produces the report has completed, a confirmation e-mail message will be sent to the address that was provided. In addition to this notification e-mail, the application will also send an e-mail with the relevant interface file attached. (This file will be in line with the Investment Solutions interface requirements).
Note:
Translation Values must be set-up for investment medium codes where the JSE code is longer than 8 characters (the limit of the investment medium code box).
For more information refer to
Accounting
Structure
Translation Values
When GENERATE REPORT is selected, the system will read the Portfolio Advice Detail records for the Portfolios linked to an Investment Medium for which the value for Interface on the Asset Manager linked to the Investment Medium is INV SOLUTIONS, and with a Notification Date equal to the Notification Date captured and extract the information as per the table below:
Note:
For each record extracted, the system will insert 3 new optional columns, one for the timestamp, for the userid and for a UDPV for target system, with the value FINSWITCH. (RT-OBJECT- TARGETSYS, target system) and a UDPV with the value FILE (RT-OBJECT, METHOD).
If GENERATE REPORT is selected more than once on a day, then do not extract the items that have been extracted previously by referring to these columns.
If GENERATE REPORT is selected more than once on a day, then the system will not extract the items that have been extracted previously, by referring to these columns.
|
Field |
M/O |
Type |
Size |
Source/Default Value |
|
Contact Person and number |
Mandatory |
A/N |
|
First Name and Surname of Person liked to the Scheme with a Role of Contact Person followed by Telephone Area Code and Telephone Number of the Contact Person |
|
Date |
|
Date |
30 |
dd-mm-yyyy Notification Date on the Portfolio Advice Detail record |
|
Client Name |
|
N/T |
100 |
Scheme Name |
|
Client ID |
|
N |
6 |
Value for Account Number on the Portfolio Detail record for the Portfolio |
|
Portfolio Name |
|
N/T |
50 |
Read the Translation Value for the Target System Attribute FUND CODE for the Source System Attribute INVESTMENT MEDIUM for which the Translation Value is equal to the Investment Medium Code on the Portfolio Advice Detail and the Buy/Sell Indicator on Portfolio Advice Detail. If not found extract the Investment Medium Code |
|
Portfolio ID |
|
N |
6 |
Read the Translation Value for the Target System Attribute FUND CODE for the Source System Attribute INVESTMENT MEDIUM for which the Translation Value is equal to the Investment Medium Code on the Portfolio Advice Detail and the Buy/Sell Indicator on Portfolio Advice Detail. If not found extract the Investment Medium Code |
|
Transaction Description |
Mandatory |
T |
50 |
Read the Translation Value for the Target System Attribute TRANSACTION TYPE for the Source System Attribute PROCESS/SELLBUY for which the Translation Value is a combination of the Originating Process on the Portfolio Advice Detail and the Buy/Sell Indicator. Example: SWITCH/S = SWITCH FROM |
|
Transaction ID |
|
N |
3 |
Read the Translation Value for the Target System Attribute TRANSACTION ID for the Source System Attribute PROCESS/SELLBUY for which the Translation Value is a combination of the Originating Process on the Portfolio Advice Detail and the Buy/Sell Indicator. Example: SWITCH/S = 12 |
|
Unique ID |
|
N |
12 |
Code on Asset Manager linked to Investment Medium on Portfolio Advice Detail |
|
Swich Unique Match Number |
|
N |
15 |
Default to 15 zero’s |
|
Rand Amount |
|
N |
12.2 |
Amount on Portfolio Advice Detail. Negatives to be displayed with - |
|
Unit Amount |
|
N |
12.2 |
Number of Units on Portfolio Advice Detail Negatives to be displayed with - |
|
Branch Number |
|
N |
6 |
Branch Code of the Scheme’s bank Account i.e. the value for Code on the Client with a Client Type of DTI Branch for the DTI Account linked to the Fund DTI Account for the Scheme |
|
Account No |
|
N |
11 |
Account Number of the Scheme’s bank Account i.e. the value for DTI Account Number on the DTI Account linked to Fund DTI Account for the Scheme |
|
Percent |
|
N |
|
Leave blank |
Click View below Investment Solutions Extract.
The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To view the report, click display at the end of the required line. The Report Selection screen will be displayed.
The following columns are displayed:
- Contact Person
- Date
- Client Name
- Client ID
- Portfolio Name
- Portfolio ID
- Transaction Description
- Transaction ID
- Unique ID
- Switch Unique Match
- Rand Amount
- Unit Amount
- Branch Number
- Account No
- Percentage