alongside FinSwitch Extract on the sub-menu on the left. Additional options will be displayed.To generate a Transaction Request file for FinSwitch, click alongside FinSwitch Extract on the sub-menu on the left. Additional options will be displayed.
Click New below FinSwitch Extract.
The FinSwitch 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 Finswitch 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 FinSwitch 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 FinSwitch 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 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 |
|
Message Type Code |
Mandatory |
|
30 |
TR |
|
Message Type Name |
Derived |
|
30 |
Leave blank as this is populated by FinSwitch |
|
Type Code |
Mandatory |
|
30 |
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 = SO (switch out) |
|
Type Name |
Derived |
|
30 |
Leave blank as this is populated by FinSwitch |
|
ManCo Code |
Mandatory |
|
50 |
Code on Asset Manager linked to Investment Medium on Portfolio Advice Detail |
|
ManCo Name |
Derived |
|
50 |
Leave blank as this is populated by FinSwitch |
|
Fund Code |
Mandatory |
|
30 |
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. If not found extract the Investment Medium Code on Portfolio Advice Detail |
|
Fund Name |
Derived |
|
30 |
Leave blank as this is populated by FinSwitch |
|
Bulked Investor Code |
Mandatory |
|
50 |
Administrator Code |
|
Bulked Investor Name |
Derived |
|
50 |
Leave blank as this is populated by FinSwitch |
|
Product Code |
Mandatory |
|
30 |
Scheme Code |
|
Product Name |
Derived |
|
50 |
Leave blank as this is populated by FinSwitch |
|
Account No |
Mandatory |
|
50 |
Account Number on Investment Portfolio Detail |
|
Reference No |
Optional |
|
20 |
Leave blank |
|
Percent |
Optional |
|
20 |
Leave blank |
|
Units |
Optional |
|
20 |
Number of Units on Portfolio Advice Detail |
|
Currency |
Mandatory |
|
30 |
Read the Translation Value for the Target System Attribute CURRENCY for the Source System Attribute CURRENCY for which the Translation Value is equal to the Currency for the Scheme |
|
Amount |
Optional |
|
20 |
Amount on Portfolio Advice Detail |
|
Cycle Date |
Mandatory |
Date |
10 |
Notification Date on Portfolio Advice Detail |
|
Mode Code |
Mandatory |
|
30 |
NON-EFT |
|
FinSwitch Reference Number |
Derived |
|
50 |
Leave blank as this is populated by FinSwitch |
|
Status |
Derived |
|
20 |
Leave blank as this is populated by FinSwitch |
Click View below FinSwitch Extract.
The Report Selection screen will be displayed.
The following columns are displayed:
- 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:
- Message Type Code
- Message Type Name
- Type Code
- Type Name
- ManCo Code
- ManCo Name
- Fund Code
- Fund Name
- Bulked Investor Code
- Bulked Investor Name
- Product Code
- Product Name
- Account No
- Reference No
- Percent
- Units
- Currency
- Amount
- Cycle Date
- Mode Code
- FinSwitch Reference Number
- Status