FCR supports transactions from different channels. Some of the channels supported are :
Branch
ATM
POS
Tele Banking
Internet Banking
Each transaction channel has an association log table. The processing functions of each channel will log the details of the transaction into the individual log tables. Data from these log tables is then taken to their corresponding cutoff tables and from there it to the settlement table.
Here is the list of channels and their corresponding log cutoff table.
Sr.no Channel Log Table Cutoff table STL table
1. Branch xf_ol_st_txnlog_current xf_ol_st_txnlog_cutoff xf_ol_st_brop_stl
2. ATM xf_ol_st_cotxn xf_ol_st_cotxn_cutoff xf_ol_st_cotxn_stl
3. POS xf_ol_st_postxn xf_ol_st_postxn_cutoff xf_ol_st_postxn_stl
4. TeleBanking xf_ol_st_tbstxn xf_ol_st_tbstxn_cutoff xf_ol_st_tbstxn_stl
5. InternetBanking xf_ol_st_ibtxnlog xf_ol_st_ibtxnlog_cutoff xf_ol_st_ibtxn_stl
All transactions are logged in above tables throughout the day.
Cutoff:
It is the point when system is handed over for end of day processing. Transaction coming until this tile are considered for that particular end of day processing. Transaction coming after cutoff are considered for next day's end of day processing.
Data movement in cutoff:
1. Data from log tables is then taken to their corresponding cutoff tables.
2. From cutoff tables data is then moved to their corresponding settlement tables
3. records from settlement tables are then combined in one settlemtn table (xf_ol_st_txnlog_stl)
4. Data from xf_ol_st_txnlog_stl is then used for EOD processing.
Branch
ATM
POS
Tele Banking
Internet Banking
Each transaction channel has an association log table. The processing functions of each channel will log the details of the transaction into the individual log tables. Data from these log tables is then taken to their corresponding cutoff tables and from there it to the settlement table.
Here is the list of channels and their corresponding log cutoff table.
Sr.no Channel Log Table Cutoff table STL table
1. Branch xf_ol_st_txnlog_current xf_ol_st_txnlog_cutoff xf_ol_st_brop_stl
2. ATM xf_ol_st_cotxn xf_ol_st_cotxn_cutoff xf_ol_st_cotxn_stl
3. POS xf_ol_st_postxn xf_ol_st_postxn_cutoff xf_ol_st_postxn_stl
4. TeleBanking xf_ol_st_tbstxn xf_ol_st_tbstxn_cutoff xf_ol_st_tbstxn_stl
5. InternetBanking xf_ol_st_ibtxnlog xf_ol_st_ibtxnlog_cutoff xf_ol_st_ibtxn_stl
All transactions are logged in above tables throughout the day.
Cutoff:
It is the point when system is handed over for end of day processing. Transaction coming until this tile are considered for that particular end of day processing. Transaction coming after cutoff are considered for next day's end of day processing.
Data movement in cutoff:
1. Data from log tables is then taken to their corresponding cutoff tables.
2. From cutoff tables data is then moved to their corresponding settlement tables
3. records from settlement tables are then combined in one settlemtn table (xf_ol_st_txnlog_stl)
4. Data from xf_ol_st_txnlog_stl is then used for EOD processing.