This chapter contains the following sections:
This section contains the following topics:
Oracle FLEXCUBE Investor Servicing interfaces with the Oracle FLEXCUBE Internet Banking application, whenever both systems are installed at Oracle FLEXCUBE installation location.
Oracle FLEXCUBE Internet Banking is a web-enabled application through which customers and investors of the bank or AMC may login at a remote web location and send requests for data or initiate transactions.
Through this interface, an investor that has a unit holder account mapped to a CIF account in the FC-IS system can perform the following operations by logging in to the Oracle FLEXCUBE Internet Banking system at a remote web location:
Note
The information interchange between the two systems is formatted in XML.
In addition to specifying new information or editing existing information, the investor can also request for information on the unit holder account, pertaining to any of the following:
The FC-IS system updates the Oracle FLEXCUBE Internet Banking system online, whenever the following are authorized in FCIS:
The creation or amendment of data could occur in any or all of the following cases:
Whenever data is authorized relating to any of these, a hand-off is triggered from the FC-IS database to the local Oracle FLEXCUBE Internet Banking database. When a request is made by a logged-in user in Oracle FLEXCUBE Internet Banking, the requested information is made available from the refreshed local Oracle FLEXCUBE Internet Banking database.
To log in to the Oracle FLEXCUBE Internet Banking application at a remote web location, the investor must specify the User ID and password assigned to the investor in the Oracle FLEXCUBE Internet Banking application.
Note
The User ID used by the investor to log in to Oracle FLEXCUBE Internet Banking is typically different from the unit holder ID or CIF account number of the investor in FC-IS. It is assigned to the investor at the time of registration at Oracle FLEXCUBE Internet Banking.
When the investor logs in to the Oracle FLEXCUBE Internet Banking system and then proceeds to specify the unit holder or CIF account number, the following information is supplied by FC-IS to Oracle FLEXCUBE Internet Banking through the interface between the two applications:
When an investor logs in to Oracle FLEXCUBE Internet Banking, the following information is available from FC-IS, facilitated by the data hand-off between the two applications:
Note
Any static data from FC-IS is made available through a Bulk Table Upload, and the user in FC@ does not have the choice of selecting the information to be viewed.
Unit holder account information
Unit holder bank account information
The funds into which switch transactions are allowed are displayed.
For a fund and transaction type,
When investors that have unit holder accounts or CIF accounts log in to Oracle FLEXCUBE Internet Banking, they can request to view details of their portfolio of investment (at a CIF level), with details such as the fund-wise holdings positions and the consolidated market value. The market value is the value of the current holdings, in terms of the current NAV, and displayed in the preferred transaction currency of the unit holder.
The following portfolio details are propagated from FC-IS for such requests, for each unit holder ID and fund:
Transaction information
The unit holder or CIF account holder can initiate a subscription transaction or a buy transaction into a fund that is in the IPO period, after logging in to Oracle FLEXCUBE Internet Banking, by specifying the following information:
For payments through account transfer, the following information must be specified as mandatory information:
For payments through credit card, the following information must be specified as mandatory information:
The transaction in FC-IS
The FLEXCUBE Investor Services system only accepts requests for new transactions from the Oracle FLEXCUBE Internet Banking system. Editing or deletion of a previously entered transaction is not accepted.
FC-IS processes the transaction on receiving the Buy Order request from Oracle FLEXCUBE Internet Banking. The processing is done as follows:
Validations for transaction processing
For allocating transactions in pre-priced funds, the prevalent price during the Beginning of Day process on the day of the transaction is considered, and the accruals until such time are included.
If any errors occur during the processing, the error messages are written into a queue corresponding with the details for the transaction obtained from FLEXCUBE@.
If all validations are successful, the transaction is saved and authorized and the transaction number is inserted with a success message into a queue, corresponding with the details for the transaction obtained from FLEXCUBE@.
While processing the transaction, FC-IS also inserts the following as default information (along with the details from Oracle FLEXCUBE Internet Banking) that is necessary for saving the transaction request:
Transaction information
The unit holder or CIF account holder can initiate a redemption transaction (or a sell transaction) after logging in to Oracle FLEXCUBE Internet Banking, by specifying the following information:
Note
Redemption transactions are accepted for only scrip-less funds for which the ageing policy specified in the fund rules is FIFO (First In First Out) or certificate option fund having the scrip-less characteristic.
If payment is to be made by a self-check, payment details are optional.
If payment is to be made through a third party check, the following details are to be specified as mandatory information:
The following information is optional for third party check payments:
For payments through account transfer, the following information must be specified as mandatory:
The transaction in FC-IS
The transaction is processed in the FC-IS system along the same lines as that described for the IPO and subscription transactions, except that all the validations are made as for a redemption transaction.
Transaction information
The unit holder or CIF account holder can initiate a switch transaction after logging in to Oracle FLEXCUBE Internet Banking, by specifying the following information:
The transaction in FC-IS
The transaction is processed in the FC-IS system along the same lines as that described for the IPO, subscription or redemption transactions, except that all the validations are made as for a switch transaction.
Transaction information
The unit holder or CIF account holder can initiate a transfer transaction after logging in to Oracle FLEXCUBE Internet Banking, by specifying the following information:
The transaction in FC-IS
The transaction is processed in the FC-IS system along the same lines as that described for the IPO, subscription or redemption transactions, except that all the validations are made as for a transfer transaction.
Transaction information
The unit holder or CIF account holder can initiate a conversion transaction, after logging in to Oracle FLEXCUBE Internet Banking, by specifying the following information:
The transaction in FC-IS
The FLEXCUBE Investor Services system only accepts requests for new transactions from the Oracle FLEXCUBE Internet Banking system. Editing or deletion of a previously entered transaction is not accepted.
The transaction is processed in the FC-IS system along the same lines as that described for the IPO, subscription or redemption transactions, except that all the validations are made as for a conversion transaction.
Any transaction entered through the Oracle FLEXCUBE Internet Banking system will normally undergo auto-authorisation check after all validations are successful and the transaction has been successfully saved. As a result of the check, if auto authorization is allowable, based on the User ID and transaction type, based on the auto authorization set up in FC-IS, the transaction will be authorized immediately. If not, it is saved as an unauthorized transaction.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can view the status of any transaction requests, that were previously entered between a given time period, through the Order Status screen.
The system will display the status for all transaction requests – those entered through the Oracle FLEXCUBE Internet Banking system as well as those entered directly through agency branches. The status of the following transaction types will be displayed, as applicable:
For switch transactions, both the legs of the transaction are displayed.
In the ‘Order Status’ screen, any or all of the following information must be specified as inquiry parameters by the unit holder:
On receiving an Order Status request from Oracle FLEXCUBE Internet Banking, FC-IS relays back the following information regarding the transaction:
In addition, for buy and sell transactions, the following information is also sent:
The status could be one of the following:
For incomplete transactions (i.e., transactions for which the payment details or the exchange rate details are not available) a message is displayed indicating that the information is incomplete as there are transactions pending processing.
If the query is unsuccessful for some reasons, FC-IS also relays the description of the error with its associated error code.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can view the activity of any transaction requests, that were previously entered between a given time period. In addition to this, the unit holder can view fund – wise opening balance of all funds applicable to the request criteria.
The unit holder must specify any or all of the following information as inquiry parameters to view the transaction activity:
For request and response elements details and sample XML for search based on AMC, refer the section titled ‘Search Based on AMC’ in this chapter.
On receiving a Transaction Activity request from Oracle FLEXCUBE Internet Banking, FC-IS processes the request and relays back the following information regarding the transaction:
Note
In this option, the opening balance as of the start date of the request is displayed. The closing balance as on the requested end date, after summing up the same, is computed by Oracle FLEXCUBE Internet Banking and displayed.
For incomplete transactions (i.e., transactions for which the payment details or the exchange rate details are not available) a message is displayed indicating that the information is incomplete as there are transactions pending processing.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can request for account statements. This statement request after being received by FC-IS and generated, is mailed to the unit holder in paper form.
When FC-IS receives the account statement request from Oracle FLEXCUBE Internet Banking, the required statements are manually generated in FC-IS through the Browser component menu.
If the unit holder ID is not specified as part of the request, the statement is generated for all unit holders under the selected CIF account.
The Inward Query Logging and Action Tracking screens in FC-IS can be used to log these requests.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can view all the open IPO’s by the AMC. The following information (as part of fund rules download) is displayed against each fund offered as IPO:
A drill down facility is also available to enable the viewing of fund information by clicking on the fund name.
The Fund Information is provided by the AMC in the form of an HTML document. The AMC creates its own fund page for IPO’s. The publishing architecture of Oracle FLEXCUBE Internet Banking is used to present this information to the customer.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can view the NAV movement for all the funds offered by the AMC.
To view the NAV movement, the following information must be specified as inquiry parameters:
The following information is displayed:
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can effect changes to the following details of the unit holder profile:
On receiving the profile change request with the changed information, FC-IS updates the address details for the specified unit holder ID, and saves the account record as an unauthorized one, with the changed information. The changed record must be manually authorized.
Note
If the change is effected at a CIF level, the change request is sent to the FCC or FCR systems, as applicable. If it is at unit holder ID level, the change request is sent to FC-IS.
If there are any errors that occur during the process, an appropriate error message is inserted into queue, along with the original details sent from FLEXCUBE@. If not, i.e., in case of a successful change, an appropriate message is inserted along with original details.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can enter bank details for the account, or effect changes to any previously entered bank details of the unit holder profile:
On receiving new bank details, modified bank details or a request for deletion of bank details, FC-IS performs an amendment (information change) to the bank details of the unit holder profile, based on the operation type (either New, Modify or Delete). This change is saved as an unauthorized change.
If there are any errors that occur during the process, an appropriate error message is inserted into queue, along with the original details sent from FLEXCUBE@. If not, i.e., in case of a successful addition or change, an appropriate message is inserted along with original details.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can enter income distribution options for the account, or effect changes to any previously entered income distribution options of the unit holder profile. The following information must be specified for a new income distribution option set up, or the modification of an existing set up for a unit holder account for a fund:
Note
Deletion of an existing income distribution set up for a unit holder account is not possible.
To inquire about the income distribution options for a fund and for a unit holder, the inquiry parameters to be specified in Oracle FLEXCUBE Internet Banking are CIF Number, Unit Holder ID and Fund ID.
On receiving the income distribution request from Oracle FLEXCUBE Internet Banking, FC-IS will save the set up details (whether new or modified) as unauthorized information for the account. The changed record must be manually authorized. On inquiry, all income distribution details for the selected CIF account will be sent for viewing.
If there are any errors that occur during the process, an appropriate error message is inserted into queue, along with the original details sent from FLEXCUBE@. If not, i.e., in case of a successful addition or change, an appropriate message is inserted along with original details.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can enter standing instructions for the account, or effect changes to any previously entered standing instructions for the unit holder profile. Standing instructions may be set up for subscription, redemption and switch transactions.
New standing instructions
The following information must be specified for a new standing instruction in a fund for a unit holder ID:
Details specific to transaction types are as follows:
The information required for the payment mode are same as required for subscription transactions.
The information required for the payment mode are same as required by redemption transactions.
Information required for the payment mode are same as required for switch transactions.
The following information in an existing standing instruction can be modified for a unit holder account for a fund:
Any existing unauthorized standing instructions for a unit holder account can be deleted through a request from Oracle FLEXCUBE Internet Banking, by specifying the required Standing Instructions Number.
Authorized standing instructions cannot be deleted through this function, but the status can be changed from ACTIVE to CANCELLED using the CANCEL option.
Any existing standing instructions for a CIF account can be viewed through a request from Oracle FLEXCUBE Internet Banking, by specifying the required CIF account.
On receiving the standing instructions request (whether a new addition, modification, or inquiry), FCIS will process the instruction.
If there are any errors that occur during the process, an appropriate error message is inserted into queue, along with the original details sent from FLEXCUBE@. If not, i.e., in case of a successful addition or change, the transaction is saved as an unauthorized transaction and the transaction number is inserted with an appropriate message along with original details.
While processing the standing instructions transaction, FC-IS also inserts the following as default information (along with the details from Oracle FLEXCUBE Internet Banking) that is necessary for saving the standing instructions transaction request:
Standing instruction requests (whether additions, changes, or inquiry) are accepted on holidays. In such an event, the start date is changed to the next working day.
After logging in to Oracle FLEXCUBE Internet Banking, the unit holder or CIF account holder can enter enquiries regarding the dividend information for the account. The account number must be specified as the inquiry parameter.
On receiving the dividend information request from Oracle FLEXCUBE Internet Banking, FC-IS relays the following information for all unit holder accounts under the CIF:
If the request is for dividend information for a single unit holder ID, the above information is provided for the specified unit holder ID.
Any requests for information or relaying of information from Oracle FLEXCUBE Internet Banking are accepted in the Oracle FLEXCUBE Internet Banking system even if they are entered during the End of Day cycle in FC-IS.
In such an event, if the End of Day cycle is in progress, Oracle FLEXCUBE Internet Banking notifies the investor that the requests will be processed only next working day. The information details specified are accepted in XML format and written into Queue.
Therefore, FC-IS will accept inquiry requests irrespective of End of Day / Beginning of Day statuses.
Transactions are accepted when an AMC is up for operations, as well as during the FC-IS End of Day cycle (i.e., FC-IS is offline). During the End of Day, then transactions are accepted, but a message indicating the End of Day cycle is displayed.
After the FC-IS system completes its End of Day process, the queue for any transaction / update requests from Oracle FLEXCUBE Internet Banking is read and the requests are processed one by one.
When investors log in to Oracle FLEXCUBE Internet Banking, they can request to view details of funds pertaining to a particular AMC. On selecting an AMC information related to all the funds offered by the AMC is displayed.
Order status, Customer dividend information, fund NAV, fund dividend information, holding statement, etc are some of the parameters that can be queried based on AMC.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Unitholders |
QUERY_UH |
FCISUH.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
|
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID (Optional) |
|
|
|
FUNDID |
Fund ID (Optional) |
|
|
|
CORPORATEACTIONTYPE |
Corp Action Type(Optional) |
|
|
|
AMCID |
ID of the selected AMC (Optional) |
|
|
|
JOINTORNOMINEE |
If ‘N’ then ‘Nominee’ only, if ‘J’ then ‘Joint UH’. If NULL, then both. |
Transactions |
QUERY_TXN |
FCISTXN.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
|
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID (Optional) |
|
|
|
FUNDID |
Fund ID (Optional) |
|
|
|
NUMBEROFTXNS |
Number of Transactions to be displayed |
|
|
|
STARTDATE |
Start Date of Search (Optional) |
|
|
|
ENDDATE |
End Date of Search (Optional) |
|
|
|
TXNNUMBER |
Transaction Number to Search (Optional) |
|
|
|
TXNTYPE |
Could be any of the following values: 02-Buy, 03-Sell, 04-Switch, 05-Transfer (Optional) |
|
|
|
AMCID |
ID of the selected AMC (Optional) |
Unitholders |
QUERY_FUND |
FCISFUND.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
The Request Type |
|
|
|
RECORDID |
Fund ID, if Selected |
|
|
|
AMCID |
ID of the selected AMC |
|
|
|
FROMDATE |
From Date of Filter |
|
|
|
TODATE |
To Date of Filter |
If more than one unit holder is associated with the customer account, the joint unit holder details can be viewed in the welcome screen in addition to the primary account holder and mutual fund balance. Details of the nominees can also be viewed upon request.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Unitholders |
QUERY_UH |
FCISUH.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
GETUHBENEFICIARY |
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID (Optional) |
|
|
|
JOINTORNOMINEE |
If “N” then “Nominee” only, if “J” then “Joint UH”. If NULL then both. |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Unitholders |
REPLY_UH |
FCISUH.DTD |
ERRCODE |
Error Code |
|
|
|
ERRDESC |
Error Description |
|
HANDOFF_UH> UHBENEFICIARY |
FCISUH.DTD |
UNITHOLDERID |
Unit holder ID |
|
|
|
BENEFICIARYID |
The Beneficiary ID |
|
|
|
BENEFICIARYTYPE |
J1 and J2 for first and second Joint unit holders, N1, N2 for first and second Nominees respectively. |
|
|
|
BENEFICIARYNAME |
Name of the beneficiary |
|
|
|
BENEFICIARYDOB |
Date of Birth of the beneficiary |
|
|
|
BENEFICIARYADDRESS |
Address of the beneficiary |
|
|
|
BENEFICIARYRELATION |
Relation to Primary Holder |
|
|
|
BENEFICIARYPANNO |
Pan Number of the beneficiary |
|
|
|
BENEFICIARYFORM60 |
‘1’ if Form 60 is available else it should be ‘0’. |
|
|
|
BENEFICIARYUIN |
In case of Corporate the UIN. |
Transaction Cancellation
Customer/Unit holder can cancel transactions through Oracle FLEXCUBE Internet Banking. Transaction cancellation is not allowed after the cut off time.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Transaction |
REVERSE_TXN |
FCISTXN |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial Number |
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
|
|
|
FUNDID |
|
|
|
|
TXNTYPE |
|
|
|
|
TXNNUMBER |
The Transaction number which is to be reversed. |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Transaction |
REPLY_TXN |
FCISTXN |
TXNNUMBER |
Reversed Transaction Number |
|
|
|
TXNREFNUMBER |
Running Serial Number |
|
|
|
SETTLEMENTDATE |
RRRRMMDD |
|
|
|
ERRCODE |
The FCIS Error Code |
|
|
|
ERRDESC |
Error Description |
The following dividend details are displayed for a customer:
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Unitholders |
QUERY_UH |
FCISUH.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
GETDIV |
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID (Optional) |
|
|
|
AMCID |
If AMC ID is given then only records of funds in that AMC will be shown. |
The table below describes the important elements of the response XML.
Level |
Response Element
|
DTD |
Field |
Value |
Unitholders |
REPLY_UH
|
FCISUH.DTD |
ERRCODE |
Error Code |
|
|
|
ERRDESC |
Error Description |
Unitholders |
HANDOFF_DIV> DIVIDEND |
FCISUH.DTD |
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID |
|
|
|
UNITHOLDERNAME |
Customer Name |
|
|
|
FUNDID |
ID of the fund |
|
|
|
ISINCODE |
ISIN |
|
|
|
DIVIDENDNUMBER |
Dividend Number |
|
|
|
PAYMENTNUMBER |
Payment Number for this dividend |
|
|
|
FROMDATE |
The Start Period of this distribution. |
|
|
|
TODATE |
The End Period of this distribution. |
|
|
|
DIVIDENDDECLAREDATE |
The date of Dividend Declaration |
|
|
|
DIVIDENDPAYMENTDATE |
The date Dividend is Processed. |
|
|
|
DIVIDENDVALUEDATE |
Value Date |
|
|
|
COUPONNUMBER |
Coupon number, if any. |
|
|
|
EPU |
Earning Per Unit |
|
|
|
UNITBALANCE |
Balance on which Dividend is given. |
|
|
|
DIV_CCY |
Dividend Currency |
|
|
|
DIV_AMT |
Total Dividend Amount |
|
|
|
TAXDEDUCTED |
Total Tax Deducted |
|
|
|
NETPAID |
Net paid after Tax |
|
|
|
REINV_AMT |
Total Amount Reinvested in Fund |
|
|
|
MOP |
Mode of Payment if Payout (T – Transfer, Q – Cheque) |
|
|
|
BANKNAME |
Bank Name of Transfer |
|
|
|
BRANCHNAME |
Branch Name of Transfer |
|
|
|
BRANCHBICCODE |
BIC Code for SWIFT |
|
|
|
ACCOUNTNUMBER |
Account Number for Transfer |
|
|
|
ACCOUNTCURRENCY |
Currency of Account |
|
|
|
CHEQUENUMBER |
Cheque number if mode of payment is cheque |
|
|
|
CHEQUEAMOUNT |
Cheque Amount |
|
|
|
CHEQUECURRENCY |
Cheque Currency |
|
|
|
TRANSFERAMOUNT |
Total Amount Transferred |
|
|
|
TRANSFEREXCHANGERATE |
Exchange Rate Used for Transfer |
|
|
|
CHEQUEEXCHANGERATE |
Exchange Rate Used for Cheque |
|
|
|
CORPORATEACTIONTYPE |
Type of Dividend C-Cash , S- Stock |
|
|
|
SD_PARENTRATIO |
Stock Dividend – Parent Ratio |
|
|
|
SD_RESULTANTRATIO |
Stock Dividend Resultant ratio |
|
|
|
REINVESTMENTUNITS |
Units Reinvested |
Unitholders |
HANDOFF_DIV> REINVESTMENT |
|
CID |
CIF Number |
Level |
Request Element |
DTD |
Field |
Value |
|
|
|
UNITHOLDERID |
Unit holder ID |
|
|
|
FUNDID |
Id of the fund |
|
|
|
PAYMENTNUMBER |
Payment Number for this dividend |
|
|
|
TOUNITHOLDERID |
Reinvestment Unit holder ID |
|
|
|
TOFUNDID |
Reinvestment Fund ID |
|
|
|
TOFUNDCURRENCY |
Reinvestment Fund ID Currency |
|
|
|
REINVESTMENTEXCHANGERATE |
Exchange rate used |
|
|
|
REINV_AMT_TO_FUND |
Reinvested Amount in the Reinvestment Fund |
Level |
Request Element |
DTD |
Field |
Value |
|
|
|
UNITSALLOTED |
Units Allotted for Reinvestment Transaction |
|
|
|
UNITPRICE |
Unit Price for Reinvestment Allocation |
|
|
|
REINV_AMT |
Amount of Reinvestment |
|
|
|
CORPORATEACTIONTYPE |
Type of Dividend could be either C-Cash or S- Stock |
Unitholders |
HANDOFF_DIV> TAXCOMPONENT |
|
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID |
|
|
|
FUNDID |
Id of the fund |
|
|
|
DIVIDENDNUMBER |
Dividend Number |
|
|
|
TAXCOMPONENTTEXT |
Description |
|
|
|
TAXCURRENCY |
Currency of Tax |
|
|
|
TAXDEDUCTEDINFUNDCCY |
Tax in Fund Based Currency |
|
|
|
TAXDEDUCTEDINTAXCCY |
Tax in Tax Base Currency |
|
|
|
PAYMENTNUMBER |
Payment Number for this dividend |
Dividend information for the various funds/schemes available in the system can be viewed. Search may be based on AMC, Scheme Name, From Date and To Date.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Unitholders |
QUERY_FUND |
FCISFUND.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
GETFUNDDIV |
|
|
|
RECORDID |
Fund ID, if Selected |
|
|
|
AMCID |
AMC ID of the AMC Selected |
|
|
|
FROMDATE |
From Date of Dividend Info |
|
|
|
TODATE |
To Date of Dividend Info |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Unitholders |
REPLY_FUND |
FCISFUND.DTD |
ERRCODE |
Error Code |
|
|
|
ERRDESC |
Error Description |
Unitholders |
HANDOFF_DIV> FUNDDIV |
FCISFUND.DTD |
FUNDID |
|
|
|
|
DIVIDENDNUMBER |
|
|
|
|
DIVIDENDTYPE |
Could be either R-Regular or I-Interim |
|
|
|
FROMDATE |
Dividend Period Start |
|
|
|
TODATE |
Dividend Period End |
|
|
|
FREEZEHOLDINGDATE |
Date of Freeze Holding of Units |
|
|
|
DIVIDENDDECLAREDATE |
Date of Dividend |
|
|
|
EPU |
Earnings Per Unit |
|
|
|
CORPORATEACTIONTYPE |
Type of Dividend Distribution. Could be either C-Cash or S-Stock |
|
|
|
SD_PARENTRATIO |
Stock Dividend Parent ratio |
|
|
|
SD_RESULTANTRATIO |
Stock Dividend Resultant ratio |
|
|
|
STATUS |
Could be either P-Processed or U-Unprocessed, |
Oracle FLEXCUBE Internet Banking allows you to view investment options. This gives you information about the fund distribution mode. In case a fund does not have this data it indicates if a plan is ‘Growth Plan’ or ‘Dividend Plan’. The Default Distribution Mode will be picked up. In case it is ‘Rl’ then Investment Option is ‘Reinvestment’ else it is ‘P’ for ‘Payout’.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Fund |
QUERY_FUND |
FCISFUND |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial Number |
|
|
|
QUERYTYPE |
GETFUNDIDR |
|
|
|
RECORDID |
Not Required when fetching for all Funds, else FCIS Fund ID |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Unitholders |
REPLY_FUND |
FCISFUND.DTD |
ERRCODE |
Error Code |
|
|
|
ERRDESC |
Error Description |
Fund |
HANDOFF_FUND> FUNDIDR |
FCISFUND |
FUNDID |
|
|
|
|
DIVDECLAREFREQ |
Could be any of the following values: D –Daily, M-Monthly, H-Half Yearly, Y-Yearly, Q-Quarterly |
|
|
|
DIVPYMTFREQ |
Could be any of the vales in the following list: D –Daily, M-Monthly, H-Half Yearly, Y-Yearly, Q-Quarterly |
|
|
|
LASTDIVNO |
Last Dividend Number |
|
|
|
LASTPYMTNO |
Last Payment Number |
|
|
|
DEFAULTDISTMODE |
Distribution Mode. Could be any of the following: P-Payout, R- Reinvestment |
|
|
|
RESTRICTIDS |
|
|
|
|
CORPORATEACTIONTYPE |
Could be either C-Cash Dividend or S-Stock Dividend |
Total Unit Balance minus the under-process units is referred as Online Balance. This Balance is displayed on the Redemption and Switch Screens.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Unitholders |
QUERY_UH |
FCISUH.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial No |
|
|
|
QUERYTYPE |
GETUHDETAILS |
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Unitholders |
REPLY_UH |
FCISUH.DTD |
ERRCODE |
Error Code |
|
|
|
ERRDESC |
Error Description |
|
HANDOFF_UH> UHFUNDBALANCE |
FCISUH.DTD |
UNITHOLDERID |
Unit holder ID |
|
|
|
CID |
CIF Number |
|
|
|
FUNDID |
Fund |
|
|
|
FUNDNAME |
Name of Fund |
|
|
|
FUNDOBJECTIVE |
Objective of Fund |
|
|
|
CURRENTNAV |
Current NAV |
|
|
|
FUNDCCY |
Fund Base Currency |
|
|
|
VALUEINFUNDCCY |
Value of Holding in Fund based Currency |
|
|
|
VALUEINUHCCY |
Value of Holding in Unit holder Base Currency |
|
|
|
CURRENTHOLDING_UNITS |
Total Allotted Balance in the Fund |
|
|
|
SELLABLEUNITS |
Total Balance that can be liquidated or sold. |
|
|
|
PROVISIONALUNITS |
Balance that cannot be sold and is not Blocked. |
|
|
|
BLOCKEDUNITS |
Total balance that is Blocked for Collateral. |
|
|
|
ISSUEDBAL |
Total Units for which Certificate has been issued-if Certificate Fund. |
|
|
|
UNISSUEDBAL |
Total Units for which Certificate has not been issued-if Certificate Fund. |
|
|
|
REDEEMBAL |
Total Approximate Amount that is Redeemable. |
|
|
|
UHPREFERREDCCY |
Unit holder Base Currency |
|
|
|
PRODUCTID |
Product of Balance |
|
|
|
AMCID |
AMC of Fund |
|
|
|
AMCNAME |
Name of the AMC |
|
|
|
PRODUCTNAME |
Name of the Product |
|
|
|
CIDNAME |
Name of Customer |
|
|
|
ONLINEBAL |
The Total Balance – In Process Balance |
|
|
|
ONLIBALINFBCCY |
The above Balance * NAV in FBCCY |
|
|
|
ONLIBALINFBCCY |
The above Balance * NAV in UHCCY |
During transaction activity, if the customer requests for a particular AMC, then activity will be shown for all funds in that AMC.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Fund |
QUERY_TXN |
FCISTXN.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Running Serial Number |
|
|
|
QUERYTYPE |
TXN_ACTIVITY |
|
|
|
REQUESTDATE |
System date |
|
|
|
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID |
|
|
|
FUNDID |
Id of the fund |
|
|
|
NUMBEROFTXNS |
Number of Transactions to display |
|
|
|
STARTDATE |
Start date of Transaction |
|
|
|
ENDDATE |
End date of Transaction |
|
|
|
TXNNUMBER |
Transaction Number |
|
|
|
TXNTYPE |
Transaction Type |
|
|
|
AMCID |
AMC Code |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Transactions |
HANDOFF_TXN> FUND_TXN |
FCISTXN.DTD |
CID |
CIF Number |
|
|
|
UNITHOLDERID |
Unit holder ID |
|
|
|
SERIALNO |
Running Serial Number |
|
|
|
TXNNUMBER |
Transaction Number |
|
|
|
TXNDATE |
Transaction Date |
|
|
|
TXNTYPE |
Transaction Type |
|
|
|
FUNDID |
ID of the fund |
|
|
|
TXNMODE |
Transaction Mode |
|
|
|
TXN_CCY_AMT |
Transaction Currency Amount |
|
|
|
TXN_CCY |
Transaction Currency |
|
|
|
UNITPRICE |
Unit Price |
|
|
|
UNITSAFFECTED |
Units |
|
|
|
RUNNINGTOTAL |
Current Running Total of Units |
|
|
|
ISSUEDBAL |
Issued bal |
|
|
|
LOIAPPLICABLE |
LOI Applicable |
|
|
|
LOAD |
Fee/Tax Amount |
|
|
|
VATAMT |
Vat Amount |
|
|
|
PAYMENTMODE |
Mode of Payment (T Transfer/C-Cash-Q Cheque, D-Demand Draft) |
|
|
|
SUBPAYMENTMODE |
Sub Mode of Payment (T Transfer/C-Cash-Q Cheque, D-Demand Draft) |
|
|
|
CHEQUENUMBER |
If paid by Cheque the ChequeNumber |
|
|
|
CHEQUEDATE |
If paid by Cheque the ChequeDate |
|
|
|
CLEARINGDATE |
Payment Clearing Date of Transaction |
|
|
|
DRAWEEBANKCODE |
If paid by Transfer Bank Code |
|
|
|
TRANSFERBRANCHCODE |
If paid by Transfer Branch Code |
|
|
|
TRANSFERACCOUNTTYPE |
If paid by Transfer Account Type |
|
|
|
TRANSFERACCOUNTNUMBER |
If paid by Transfer Account Number |
|
|
|
TRANSFERACCOUNTCURRENCY |
If paid by Transfer Account Currency |
|
|
|
PAYMENTTYPE |
S-Self T –Third Party |
|
|
|
THIRDPARTYPAYMENTREFERENCE |
Third Party Reference number |
|
|
|
THIRDPARTYADDRESS1 |
Third Party Address Line 1 |
|
|
|
THIRDPARTYADDRESS2 |
Third Party Address Line 2 |
|
|
|
THIRDPARTYADDRESS3 |
Third Party Address Line 3 |
|
|
|
THIRDPARTYSTATE |
Third Party State |
|
|
|
THIRDPARTYZIPCODE |
Third party Zipcode |
|
|
|
THIRDPARTYUSSTATE |
Third Party US state |
|
|
|
THIRDPARTYCOUNTRY |
Third party Country |
|
|
|
THIRDPARTYBICCODE |
Third Party BIC Code for Swift |
|
|
|
TRANSFERREFERENCENUMBER |
Reference Number |
|
|
|
TRANSFERACCOUNTHOLDERNAME |
Account Holder Name |
|
|
|
REFTYPE |
Reftype |
|
HANDOFF_TXN> OPENINGBAL |
FCISTXN.DTD |
CID |
Cif Number |
|
|
|
FUNDID |
Fund |
|
|
|
OPENINGBALANCE |
Opening Balance in this Fund for the criteria in Request. |
Customer numbers (CIF) are sent across as an offline Handoff so that FLEXCUBE@ shows Mutual Fund Menu only to those Customers who have an Account in FCIS.
The table below describes the important elements of the request XML.
Level |
Request Element |
DTD |
Field |
Value |
Unitholders |
QUERY_UH |
FCISUH.DTD |
SCODE |
Identifies the external system that is sending the request. For example, HDFC. |
|
|
|
XREF |
Keystring with Time Stamp |
|
|
|
QUERYTYPE |
GETCIF |
|
|
|
REQUESTDATE |
RRRRMMDD |
|
|
|
CID |
CIF Number |
The table below describes the important elements of the response XML.
Level |
Response Element |
DTD |
Field |
Value |
Unitholders |
REPLY_UH |
FCISUH.DTD |
ERRCODE |
Error Code |
|
|
|
ERRDESC |
Error Description |
|
HANDOFF_UH> CIFDTLS |
FCISUH.DTD |
CID |
CIF Number |
|
|
|
STATUS |
Status. Could be either O-Open or C-Closed |