Bank code
A three digit bank code for the bank. Each code uniquely identifies a different bank. Central Bank assigns a bank code for each bank. The bank code defined in FCR can be the same code assigned by the central bank.
Bank code and entity code's mapping is stored in the table BA_ENTITY_MAST.
Clearing Bank Code
The code given to the bank by the clearing bank/central clearing authority. This code will be present on all the instruments of the bank and shall be used to identify if the instruments are the bank's own instruments or other bank's instruments.
Bank Identifier
The code will be a part of the IBAN number when it is generated.
ISO Code
The ISO country code entered will be a part of IBAN number whenever it is generated.
Last Process Date
The date on which the EOD process was last run. The date will be maintained for the first time when the bank starts its operations on FCR. Subsequently, this will be maintained automatically by FCR based on the holiday calendar of the bank.
Current Process Date
By default, the current date will be the next process date after the last EOD was run on the system.
Next Process Date
By default, the next process date will be the next working date after the current process date.
GL Process Date
The current process date for the general Ledger module. The system completes the processing of each module separately while running the EOD. Thus, the current process date, i.e. the next process date after the last EOD was run on the system, for each module is displayed separately for information purposes. The same principle applies to other module's process date.
STL Process Date
The current process date for the settlement module.
CHQ Process Date
The current process date for the CASA module.
TD Process Date
The current process date for the term deposit module.
LN Process Date
The current process date for the loans module.
IBAN Mask (International Bank Account Number)
IBAN Mast constitutes the following :
First 2 digits: ISO Country Code
Next 2 digits: Check digit generated based on an algorithm
Next 5 digits: Bank identifier
Last 11 digits: the first 11 digits of the FCR account number...
Maybe different bank can use different IBAN Mask schema.
The first 4 digits are needed in every IBAN, but the remaining part of the IBAN (both schema and length) is defined by the national bank community.
GL details of a bank
Credit Suspense Account
An offline credit transaction, which is rejected by the host after becoming online, will be posted to this account. Branches will have to manually reverse out entries from this GL and post it to the relevant account after undertaking suitable corrective mechanisms.
Debit Suspense Account
An offline debit transaction, which is rejected by the host after becoming online, will be posted in this account. Branches will have to manually reverse out entries from this GL and post it to the relevant account after undertaking suitable corrective mechanisms.
IB Credit Account
The GL entries for all the inter branch transactions are recorded in this account. At the end of every business day the balance in this account across all the branches in the bank should be zero. For the transactions done on accounts of the other branches, contra inter branch entries are generated automatically by FCR during EOD and posted against this GL.
IB Debit Account
The similar as the IB Credit Account.
Future Dated Bridge GL-CR/DR Account (Two accounts)
All the bridging debit entries for future dated transactions, from the transaction date to the value date, will be recorded in this account.
Withholding Tax GL
Used in accumulating withholding tax. The GL entries for tax deducted at source (TDS) for CASA and TD accounts will be recorded in this GL. Withholding tax, also known as TDS or Tax deducted at source, is an amount withheld by the bank making an interest payment to customer and paid to the taxation authorities. The payee is assessed on the interest income, and the tax to be withheld(the withholding tax) is computed in that assessment. The purpose of withholding tax is to facilitate or accelerate collection, by collecting tax from payers rather than a much greater number of payees, and by collecting tax from payers within the jurisdiction rather than payees who may be outside the jurisdiction. It may also be used to counteract tax evasion and tax avoidance.
Sounds like this GL is used by the bank to collect interest tax for the tax authorities.
VAT GL Account (Value Added Tax)
A GL account, don't know the exact usage of this account.
Bank Cash GL
The central bank GL. The GL entries for the buy and sell transactions between the vault of the branch and the central bank will be recorded in this GL.
Branch Vault Cash GL
Cash GL for the branch. The GL entries for the debit and credit transactions for a customer in a branch will be recorded in this GL. Don't know why, debit and credit transactions should be recorded in their respective product GL???
Cash Overage GL
The liability type GL for excess cash. The credit entries for the reconciliation of excess cash physically held by the teller will be recorded in this GL.
Cash shortage GL
The asset type GL for cash shortage. The debit entries for the reconciliation of the shortage of cash physically held by the teller will be recorded in this GL.
FX Profit Sundry GL
Sundry GL for FX profit.
FX Profit/Loss GL
Income GL for FX profit/loss.
IB IBD Credit GL account and Debit GL account
GL code for the inter branch international business department credits. The GL entries for all the inter branch transactions are recorded in this account. At the end of every business day the balance in this account across all the branches in the bank should be zero. For the transactions done on accounts of other branches, contra inter branch entries are generated automatically during EOD and posted against this GL.
Contingent Asset/Liability GL code for Limit
Set up the contingent asset GL code to which contingent balance needs to be posted if the contingent entries are passed at limit level. The system will pass contingent accounting entry for un-utilized limit amount (Sanctioned Amount-Disbursed Amount) for Term loans, revolving loan and OD account.
Position Currency
Maybe this is related to the position accounting. If position accounting is to be done, then the system shall pass one pair of entries for every foreign currency entry.
Tax Receivable GL
This GL is used to debit for tax refund on the backdated debit interest adjustment. It's an asset type of GL account.
Other Details
Bank Tax Id
The identity number provided by the tax authorities in your country under which the bank pays the tax. This field is only for information purposes.
Central Bank Code
The central bank code. This code is assigned to a bank by the central bank.
Head Office LO
Don't know what is LO yet... Maybe Local Office????
Head office Cost Center
Cost center of the HO
Default Bank Currency
The currency code of the local currency of the bank.
Head Office Currency
Currency code applicable for your head office.
Start Year Month
First Month of the financial year. Interest/charges capitalization dates for CASA/TD products are determined based on the value in this field. For example, if the value in this field is set as 7 and if the capitalization frequency is set as half-yearly at the product level, the credit capitalization for the CASA product will take place in June and December every year.
Income Tax Circle Number (Income Tax)
Income Tax number where annual returns are filed.
TDS Next Remittance Date
Set up the next date on which tax is to be remitted by the bank to the government agents. This field is for information purpose only.
Interface Flag
For Universal Banking implementation with interface to Flexcube Corporate modules.
TD variance for OD
Variance that is added to interest rate of a term deposit against which an overdraft is granted. When the term deposit is kept as security against an overdraft, the OD interest rate is calculated as follows:
(OD interest rate) = (TD interest rate) + (TD variance for OD)
The interest rate is taken as a variance above the term deposit rate.
TDS Start Month
The month that represents the beginning of the tax year.
Week Start Day
The day that represents the beginning of the week for the bank.
Automatic Acct No. Generation
If the bank want the system to automatically generate account numbers. The number is generated as a combination of branch/product code/serial number and a check digit.
Rate VAT
percentage value, don't know the exact meaning.
IS Interface
Universal Banking implementation with interface to Flexcube retail investor service modules.
Amount VAT
don't know the exact meaning.
Reserve Calculation Frequency
The frequency at which provisioning should take place for CASA and loan accounts based on the customer CRR codes.
Hold Amt.Flg
The Flag is to allow the bank to put a hold on the customer's available balance in case of future transactions. The hold will be removed on the value date. If it was not selected, the system will post the future dated transaction only on the value date.
Flier to be sent with statement
The type of flier to be sent along with the statement. A flier is additional information with the statement. The nature of OMR mark in the output statement file will be determined based on this flag.
Service Charge Package
Set up the service charge package for transactions which do not have account numbers (e.g. Walk-In transactions).
Don't know what is Walk-In.
Service Charge Package Name
AML Dr/Cr Limit
Anti Money laundering limit for debit/credit transactions
AML Daily Dr/Cr Limit
Anti Money laundering limit for cumulative debit/credit transactions on a particular day.
Future Dated Funds Transfer Parameters
Hold for Asset/Liability Product
If credit hold is required for asset type product for future dated transactions.
Holiday Processing
The processing date of the transaction if the value date of the transaction is on a non-working day according to bank calendar.
The options are Next and Previous.
Last Revaluation Date
The last date of revaluation of the bank.
Limit Revaluation Frequency
The frequency of the limit revaluation.
Next Revaluation Date
The next date of revaluation of the bank.
Revaluation Base
The base of revaluation of the bank.
A three digit bank code for the bank. Each code uniquely identifies a different bank. Central Bank assigns a bank code for each bank. The bank code defined in FCR can be the same code assigned by the central bank.
Bank code and entity code's mapping is stored in the table BA_ENTITY_MAST.
Clearing Bank Code
The code given to the bank by the clearing bank/central clearing authority. This code will be present on all the instruments of the bank and shall be used to identify if the instruments are the bank's own instruments or other bank's instruments.
Bank Identifier
The code will be a part of the IBAN number when it is generated.
ISO Code
The ISO country code entered will be a part of IBAN number whenever it is generated.
Last Process Date
The date on which the EOD process was last run. The date will be maintained for the first time when the bank starts its operations on FCR. Subsequently, this will be maintained automatically by FCR based on the holiday calendar of the bank.
Current Process Date
By default, the current date will be the next process date after the last EOD was run on the system.
Next Process Date
By default, the next process date will be the next working date after the current process date.
GL Process Date
The current process date for the general Ledger module. The system completes the processing of each module separately while running the EOD. Thus, the current process date, i.e. the next process date after the last EOD was run on the system, for each module is displayed separately for information purposes. The same principle applies to other module's process date.
STL Process Date
The current process date for the settlement module.
CHQ Process Date
The current process date for the CASA module.
TD Process Date
The current process date for the term deposit module.
LN Process Date
The current process date for the loans module.
IBAN Mask (International Bank Account Number)
IBAN Mast constitutes the following :
First 2 digits: ISO Country Code
Next 2 digits: Check digit generated based on an algorithm
Next 5 digits: Bank identifier
Last 11 digits: the first 11 digits of the FCR account number...
Maybe different bank can use different IBAN Mask schema.
The first 4 digits are needed in every IBAN, but the remaining part of the IBAN (both schema and length) is defined by the national bank community.
GL details of a bank
Credit Suspense Account
An offline credit transaction, which is rejected by the host after becoming online, will be posted to this account. Branches will have to manually reverse out entries from this GL and post it to the relevant account after undertaking suitable corrective mechanisms.
Debit Suspense Account
An offline debit transaction, which is rejected by the host after becoming online, will be posted in this account. Branches will have to manually reverse out entries from this GL and post it to the relevant account after undertaking suitable corrective mechanisms.
IB Credit Account
The GL entries for all the inter branch transactions are recorded in this account. At the end of every business day the balance in this account across all the branches in the bank should be zero. For the transactions done on accounts of the other branches, contra inter branch entries are generated automatically by FCR during EOD and posted against this GL.
IB Debit Account
The similar as the IB Credit Account.
Future Dated Bridge GL-CR/DR Account (Two accounts)
All the bridging debit entries for future dated transactions, from the transaction date to the value date, will be recorded in this account.
Withholding Tax GL
Used in accumulating withholding tax. The GL entries for tax deducted at source (TDS) for CASA and TD accounts will be recorded in this GL. Withholding tax, also known as TDS or Tax deducted at source, is an amount withheld by the bank making an interest payment to customer and paid to the taxation authorities. The payee is assessed on the interest income, and the tax to be withheld(the withholding tax) is computed in that assessment. The purpose of withholding tax is to facilitate or accelerate collection, by collecting tax from payers rather than a much greater number of payees, and by collecting tax from payers within the jurisdiction rather than payees who may be outside the jurisdiction. It may also be used to counteract tax evasion and tax avoidance.
Sounds like this GL is used by the bank to collect interest tax for the tax authorities.
VAT GL Account (Value Added Tax)
A GL account, don't know the exact usage of this account.
Bank Cash GL
The central bank GL. The GL entries for the buy and sell transactions between the vault of the branch and the central bank will be recorded in this GL.
Branch Vault Cash GL
Cash GL for the branch. The GL entries for the debit and credit transactions for a customer in a branch will be recorded in this GL. Don't know why, debit and credit transactions should be recorded in their respective product GL???
Cash Overage GL
The liability type GL for excess cash. The credit entries for the reconciliation of excess cash physically held by the teller will be recorded in this GL.
Cash shortage GL
The asset type GL for cash shortage. The debit entries for the reconciliation of the shortage of cash physically held by the teller will be recorded in this GL.
FX Profit Sundry GL
Sundry GL for FX profit.
FX Profit/Loss GL
Income GL for FX profit/loss.
IB IBD Credit GL account and Debit GL account
GL code for the inter branch international business department credits. The GL entries for all the inter branch transactions are recorded in this account. At the end of every business day the balance in this account across all the branches in the bank should be zero. For the transactions done on accounts of other branches, contra inter branch entries are generated automatically during EOD and posted against this GL.
Contingent Asset/Liability GL code for Limit
Set up the contingent asset GL code to which contingent balance needs to be posted if the contingent entries are passed at limit level. The system will pass contingent accounting entry for un-utilized limit amount (Sanctioned Amount-Disbursed Amount) for Term loans, revolving loan and OD account.
Position Currency
Maybe this is related to the position accounting. If position accounting is to be done, then the system shall pass one pair of entries for every foreign currency entry.
Tax Receivable GL
This GL is used to debit for tax refund on the backdated debit interest adjustment. It's an asset type of GL account.
Other Details
Bank Tax Id
The identity number provided by the tax authorities in your country under which the bank pays the tax. This field is only for information purposes.
Central Bank Code
The central bank code. This code is assigned to a bank by the central bank.
Head Office LO
Don't know what is LO yet... Maybe Local Office????
Head office Cost Center
Cost center of the HO
Default Bank Currency
The currency code of the local currency of the bank.
Head Office Currency
Currency code applicable for your head office.
Start Year Month
First Month of the financial year. Interest/charges capitalization dates for CASA/TD products are determined based on the value in this field. For example, if the value in this field is set as 7 and if the capitalization frequency is set as half-yearly at the product level, the credit capitalization for the CASA product will take place in June and December every year.
Income Tax Circle Number (Income Tax)
Income Tax number where annual returns are filed.
TDS Next Remittance Date
Set up the next date on which tax is to be remitted by the bank to the government agents. This field is for information purpose only.
Interface Flag
For Universal Banking implementation with interface to Flexcube Corporate modules.
TD variance for OD
Variance that is added to interest rate of a term deposit against which an overdraft is granted. When the term deposit is kept as security against an overdraft, the OD interest rate is calculated as follows:
(OD interest rate) = (TD interest rate) + (TD variance for OD)
The interest rate is taken as a variance above the term deposit rate.
TDS Start Month
The month that represents the beginning of the tax year.
Week Start Day
The day that represents the beginning of the week for the bank.
Automatic Acct No. Generation
If the bank want the system to automatically generate account numbers. The number is generated as a combination of branch/product code/serial number and a check digit.
Rate VAT
percentage value, don't know the exact meaning.
IS Interface
Universal Banking implementation with interface to Flexcube retail investor service modules.
Amount VAT
don't know the exact meaning.
Reserve Calculation Frequency
The frequency at which provisioning should take place for CASA and loan accounts based on the customer CRR codes.
Hold Amt.Flg
The Flag is to allow the bank to put a hold on the customer's available balance in case of future transactions. The hold will be removed on the value date. If it was not selected, the system will post the future dated transaction only on the value date.
Flier to be sent with statement
The type of flier to be sent along with the statement. A flier is additional information with the statement. The nature of OMR mark in the output statement file will be determined based on this flag.
Service Charge Package
Set up the service charge package for transactions which do not have account numbers (e.g. Walk-In transactions).
Don't know what is Walk-In.
Service Charge Package Name
AML Dr/Cr Limit
Anti Money laundering limit for debit/credit transactions
AML Daily Dr/Cr Limit
Anti Money laundering limit for cumulative debit/credit transactions on a particular day.
Future Dated Funds Transfer Parameters
Hold for Asset/Liability Product
If credit hold is required for asset type product for future dated transactions.
Holiday Processing
The processing date of the transaction if the value date of the transaction is on a non-working day according to bank calendar.
The options are Next and Previous.
Last Revaluation Date
The last date of revaluation of the bank.
Limit Revaluation Frequency
The frequency of the limit revaluation.
Next Revaluation Date
The next date of revaluation of the bank.
Revaluation Base
The base of revaluation of the bank.