Siebel eService Administration Guide Addendum for Industry Applications > Siebel eBanking Account Aggregation Business Components >

FINS AAG Investment Holding

This business component stores the detailed security holdings for aggregated Investment accounts. This business component is based off of the data stored in the S_FN_ACCNT_FNXM table of the Siebel database where the field type equals AG Holdg.

There are two different joins to the S_ASSET table as referenced below. Important fields of interest are Symbol, to identify the security and Amount, which is the security's market value.

The FINS AAG Investment Holding business component is based off of the Table: S_FN_ACCNT_FNXM, where the Search Spec: [Type] = LookupValue ('AAG_TABLE_TYPE', 'AAG Holdg').

Table 28 contains a list of join tables for the FINS AAG Investment Holding business component.

Table 28.  List of Join Tables for FINS AAG Investment Holding Business Component
Join Table
Outer Join Flag
Join Spec - Destination Column
Join Spec - Source Field
Comments
S_ASSET (1)
 
ROW_ID
Account Id
 
S_ASSET (2)
 
ROW_ID
Portfolio Id
 

Table 29 lists all the fields of the FINS AAG Investment Holding business component and the associated table columns.

Table 29.  FINS AAG Investment Holding Business Component Fields and Associated Table Columns
Field
Description
Table Column
Join
Account Id
The ID of the account
PAR_ASSET_ID
S_ASSET (2)
Amount
Amount of the holding
[CurrentPrice]*[Quantity]
Type: DTYPE_CURRENCY
N/A
 
Con Svc Id
Contact service Id
AAGSVC_CON_ID
S_ASSET (1)
Contact Id
Contact Id
PR_CON_ID
S_ASSET (1)
Currency
Currency code
Pre-default value: System: Currency
ATTRIB_03
 
Current Price
Current Price
ATTRIB_14
 
Portfolio Id
Portfolio Id
PAR_ROW_ID
 
Quantity
Quantity
ATTRIB_15
 
Symbol
Symbol
NAME
 
Type
Type
TYPE
 


 Siebel eService Administration Guide Addendum for Industry Applications, Version 7.5, Rev. A 
 Published: 18 April 2003