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 formatted in csv. |
| Post-condition(s) | The file is processed by FSC and results are visible in the session monitor |
| Main success scenario | FSC picks the file up from the defined storage place. After some pre-processing (see separate use case) the data is imported. Any error are visible in the session monitor. The computation is kicked off after successful import |
| Extensions | See separate use case for cloning file to produce portfolio-counterparty links Multiple fee types (AuM and AuA) |
| 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 |
|
|
|
|
|
|
| SCD Columns | Description | Finsoft internal mapping | Data type | Mandatory | Sample data |
| Fee Date (x) | Date which defines the fee period | Rebate date | Date, dd.mm.yyyy | Yes | 31.03.2026 |
| N/A | Create a unique reference for the entry by combining Fee Date_Portfolio_Product | Transaction external reference | String 50 characters, case sensitive | Yes | 31012026_PK7500D00_XS1076018305 |
| SCD Security ID (H) | Refers to which Assets/projects etc are being invoiced | Product external reference | String 50 characters, case sensitive | No | XS123456789 |
| Depot (G) | Refers to the account/portfolio etc were assets are located | Portfolio External reference | String 50 characters, case sensitive | Yes | SX7108984664 |
| Here the fixed value SCD should be used. | Portfolio source system | String, 255 characters, case sensitive | Yes | SCD | |
| Sub Service code | Refers to the sub service under which the data is invoiced | Sub Service code | String, 50 characters | Yes | AdmFee, TravelCost, PerfFee etc |
|
Dirty Value QC/Dirty value |
The Amount which is the basis of the fee calculation (e.g. Assets under management or Assets under Administration) | AUM (Fee Base Amount) | Real, 14,4 | No | 1.765,00 |
|
Fee Base Currency |
The currency of the fee base amount (see above) | Amount CCY code | ISO Currency code | No | EUR |
| Fee Amount | The amount of fees calculated (externally) | Fee Amount | Real, 14,4 | No | 98,00 |
|
Fee Currency |
The currency of the fee amount | Fee Amount CC Y code | ISO Currency code | No | USD |
|
Fee Rate |
The fee rate applied, expressed in % | fee_rate | Real 20,9 | No | 3,5 |
|
Period From |
The start date of the period for which the fees are being invoiced ( example 01.01.2026) . This will appear on the invoice ! |
Statement start date |
Date ddd.mm.yyyy |
Yes | 01.01.2026 |
|
Period To |
The end date of the period for which the fees are invoiced. (example 31.03.2026) . This will appear on the invoice ! | Statement end date |
Date dd.mm.yyyy |
Yes | 31.03.2026 |
| 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 |