Siebel eService Administration Guide Addendum for Industry Applications > Siebel eBanking Account Aggregation Business Components >
FINS AAG All Account
This business component stores all of the customers' aggregated account information. This business component is based off of the data stored in the S_ASSET table of the Siebel database where the field type equals AAG Account.
The most important fields of interest are Account Type, Contact Full Name, and Current Balance, which store the total balance in the account; Data Private Flag, which indicates if the customer wishes to keep the account information private; and Service Name, which is the name of the financial institution where the account is held.
The FINS AAG All Account business component is based off of the S_Asset table, where the Search Spec: [Type] = LookupValue ('AAG_TABLE_TYPE', 'AAG Account'). Table 25 contains a list of join tables for the FINS AAG All Account business component.
Table 25. List of Join Tables for FINS AAG All Account Business Component
Join Table
|
Outer Join Flag
|
Join Spec - Destination Column
|
Join Spec - Source Field
|
Comments
|
S_FN_AAG_SVC
|
|
ROW_ID
|
Service Id
|
|
S_CONTACT
|
|
ROW_ID
|
Contact Id
|
|
S_FN_AAGSVC_CON
|
Yes
|
ROW_ID
|
Con Svc Id
|
|
Table 26 lists all the fields of the FINS AAG All Account business component and the associated table columns.
Table 26. FINS AAG All Account Business Component Fields and Associated Table Columns
Field
|
Description
|
Table Column
|
Join
|
Account Number
|
Account Number
|
ASSET_NUM
|
|
Account Type
|
Account Type, Required
|
SUB_TYPE_CD
|
|
Account Type INT
|
Calculated field
Calculated value: LookupName("AAG_ACCOUNT_TYPE"
|
N/A
|
|
Available Limit
|
Available Limit, Currency Code Field: Currency
|
CC_AVLCRDT_LIMIT
|
S_FN_ACCNT1_FNX
|
Con Svc Id
|
Contact Service ID, Required
|
AAGSVC_CON_ID
|
|
Con Svc Id User Key
|
Contact Service ID user key, Required
|
REV_NUM
|
|
Contact First Name
|
Contact first name
|
FST_NAME
|
S_CONTACT
|
Contact Full Name
|
Contact full name, Calculated value: [Contact First Name] + "[Contact Last Name]"
|
|
|
Contact Id
|
Contact Login ID (to Siebel application)
|
PR_CON_ID
|
|
Credit Line
|
Credit line
Currency Code Field: Currency
|
CC_CREDIT_LINE
|
S_FN_ACCNT1_FNX
|
Currency
|
Currency symbol
Pre-default value: System: Currency
|
CURCY_CD
|
|
Current Balance
|
Current Balance
Currency Code Field: Currency
|
CURRENT_BAL
|
|
Current Due Date
|
Current Due Date
|
CC_PAY_DUE_DT
|
S_FN_ACCNT1_FNX
|
Data Private Flag
|
Indicates if this account is to be visible to employees
Force Active
|
PRIVATE_FLG
|
S_FN_AAGSVC_CON
|
Description
|
Comments
|
COMMENTS
|
|
Interest YTD
|
Interest Year to Date
Currency Code Field: Currency
|
CP_YTD_INTEREST
|
S_FN_ACCNTI_FNX
|
Item Id
|
Item Id (Yodlee)
|
YL_ITEM_IDEN
|
S_FN_AAGSVC_CON
|
Last Payment
|
Last Payment
Currency Code Field: Currency
|
CC_LAST_PAYMT
|
S_FN_ACCNTI_FNX
|
Last Payment Date
|
Last Payment Date
|
CC_LAST_PAYMT_DT
|
S_FN_ACCNTI_FNX
|
Minimum Due
|
Minimum Due
Currency Code Field: Currency
|
CC_MIN_DUE
|
S_FN_ACCNTI_FNX
|
Previous Balance
|
Previous Balance
Currency Code Field: Currency
|
CC_PREV_BAL
|
S_FN_ACCNTI_FNX
|
Service Id
|
Service Id (Siebel specific)
|
AAG_SVC_ID
|
S_FN_AAGSVC_CON
|
Service Name
|
Service Name
|
NAME
|
S_FN_AAG_SVC
|
Service Type Name
|
The type of the service
|
YL_SVC_TYPE
|
S_FN_AAG_SVC
|
Total Cash
|
Total currency amount
Currency Code Field: Currency
|
CASH_VALUE
|
S_FN_ACCNT2_FNX
|
Type
|
The type of the account
|
TYPE_CD
|
|
Update Time
|
Last update time
|
LAST_UPD
|
|