Skip to main content

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:

  • average of 2 or 3 month end positions 
  • leveraged by number of day in quarter 

 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 codeSource System

 

Default to SCD 

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)A) ProfitInvoice Centergroup

 

100

Yes

Counterparty Code

(B)A) ProfitInvoice Centergroup

Contains spaces and is not consistently in capital letters e.g. MR AG

50

Yes

Counterparty external reference

(B)A) ProfitInvoice Centergroup

 

50

Yes

SharesFee Base Amount

( = AUM)

 (P) Dirty Value QC

Can be EUR or USD

N/A

Yes

Fee Base Amount

(AUA)

Q (Dirty Value PC



Yes

Effective Date

(X) Selection date

Take from file

N/A dd.mm.yyyy

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















Back to top