SCD feed for IC_AA
Purpose / Description
SCD as a data source does already provide data for group clients in fee model commission calculation. For IC and AA, there will be a dedicated monthly feed
Use Case
| As a system I want to import the asset values for calculating invoice amount based on AuM or AuA under Fee Distribution model | |
| Primary Actor(s) | FSC |
| Stakeholders and Interest | Invoice reviewer, Invoice manager |
| Trigger | Import of the file with dedicated naming convention |
| Pre-condition(s) |
The file has the agreed naming convention, the file is |
| Post-condition(s) | |
| Main success scenario | |
| Extensions | |
| Exception scenarios |
The import is done monthly. Quarterly and monthly agreements which are calculated based on 'last day of period' will be automatic. Calculations based on for example:
will not be automatic. Please contact FinSoft for these agreements as these need to be sourced via the standard template with pre-calculated values.
|
| Special requirements | |
| Open questions |
Mockup
Functional Requirements
| Business rules and functional requirements |
| The portfolio source system will be mapped to ???? |
| The file name |
Field level specification
|
FSC Usage |
SCD IC_AA column |
Rules |
Size |
Mandatory |
|
Entity |
|
|
3 |
No |
|
ISIN |
(H) SCD Security ID |
|
50 |
No |
|
Portfolio external ref |
(G) Depot |
|
50 |
Yes |
|
Portfolio code |
|
|
50 |
Yes |
|
Portfolio name |
|
|
255 |
Yes |
|
Product name |
|
|
100 |
No |
|
Product short name |
|
|
50 |
Yes |
|
Product external ref |
(H) SCD Security ID |
|
50 |
Yes |
|
Product currency |
|
Take from file name |
3 |
Yes |
|
Counterparty name |
(B) Profit Center |
|
100 |
Yes |
|
Counterparty Code |
(B) Profit Center |
Contains spaces and is not consistently in capital letters e.g. MR AG |
50 |
Yes |
|
Counterparty external reference |
(B) Profit Center |
|
50 |
Yes |
|
Shares ( = AUM) |
|
Can be EUR or USD |
N/A |
Yes |
|
Date |
|
Take from file |
N/A |
Yes |
|
Transaction external reference |
(N) Elementar-Gesch-Nr |
|
50 |
Yes |
|
Name |
(F) WP Name |
|
255 |
Yes |
|
Portfolio Asset Manager Reference |
Take from file name |
|
N/A |
Yes |
|
Portfolio Source System |
|
|
N/A |
Yes |
|
Effective Date |
(H) Valuta |
|
N/A |
Yes |
|
Fee Amount |
(I) Betrag KNW |
|
N/A |
Yes |
|
|
|
|
|
|
| Label | UI control |
Manda- tory |
Editable | Data Type | Value set | Default | Data sample |
Data validation failure response
| Field label | Validation/ Business reules | Error message(s) | Data dependencies | Additional information |