Bookshelf Home | Contents | Index | Search | PDF

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

FINS AAG Transactions

---

This business component stores the detailed account transactions for aggregated Banking and Credit Card accounts. The data can include all charges to a credit card account, different withdraws from a savings account, or checks drawn on a checking account.

This business component is based on the data stored in the S_FN_ACCNT_TXN table of the Siebel database where the field type equals AAG Txn. Important fields of interest are Transaction Type, Transaction Date, and Amount of the transaction.

The FINS AAG Transactions business component is based off of the Table: S_FN_ACCNT_TXN, where the Search Spec: [Type] = LookupValue ('AAG_TABLE_TYPE', 'AAG Txn'). Table 30 contains a list of join tables for the FINS AAG Transactions business component.

Table 30.  List of Join Tables for FINS AAG Transactions Business Component

Join Table	Outer Join Flag	Join Spec - Destination Column	Join Spec - Source Field	Comments
S_ASSET		ROW_ID	Account Id

Table 31 lists all the fields of the FINS AAG Transactions business component and the associated table columns.

Table 31.  FINS AAG Transactions Business Component Fields and Table Columns

Field	Description	Table Column	Join
Account Id	Account Id	ACCNT_ID
Amount	Amount Currenct Code Field: Currency	AMT
Check Number	Check Number	ORDER_CD
Con Svc Id	Contact Service Id	AAGSVC_CON_ID	S_ASSET
Contact Id	Contact Id	PR_CON_ID	S_ASSET
Currency	Currency Code	CURCY_CD	S_ASSET
Description	Description	PAYEE_DESC
Post Date	Post Date	POST_DT
Ref Number	Reference Number	TXN_REF_NUM
Transaction Date	Transaction Date	TXN_DT
Transaction Type	Transaction Type	STATUS_CD
Type	Type	TXN_SIDE_CD

Bookshelf Home | Contents | Index | Search | PDF